So I guess using the welcome app and modifying it wasn't that good. how do I fix this? and can I keep my database?
On Thursday, March 7, 2013 7:05:51 PM UTC+1, Niphlod wrote: > > ehm..... you're using sqlite, the only locking-on-write db engine to keep > track of each visitor landing on your pages ? > You can't "fix" the error because it happened for a resource-contention: > it means that the app was already writing to the SQLite database while your > pagestatistic was trying to write too at it in the same time. > > On Thursday, March 7, 2013 6:46:09 PM UTC+1, BlueShadow wrote: >> >> >> One of the tickets I got: >> " >> Ticket ID >> >> 66.249.yy.xxx.2013-03-06.15-43-30.1c957bf8-ba69-4762-8b82-b9c63c2ab027 >> <class 'sqlite3.OperationalError'> database is locked Version web2py™ (2, >> 3, 2, datetime.datetime(2012, 12, 17, 15, 3, 30), 'stable') Python Python >> 2.7.3: /usr/bin/python Traceback >> >> 1. >> 2. >> 3. >> 4. >> 5. >> 6. >> 7. >> 8. >> 9. >> 10. >> 11. >> 12. >> 13. >> 14. >> 15. >> 16. >> 17. >> 18. >> 19. >> >> Traceback (most recent call last): >> File "/home/www-data/web2py/gluon/restricted.py", line 212, in restricted >> exec ccode in environment >> File "/home/www-data/web2py/applications/app/models/pagestatistics.py" >> <https://www.movie-alarm.de/admin/edit/Movie_Alarm/models/pagestatistics.py>, >> line 93, in <module> >> pageStatistics = PageStatistics(db, initialHits=0, initialVisits=0)() >> File "/home/www-data/web2py/applications/app/models/pagestatistics.py" >> <https://www.movie-alarm.de/admin/edit/Movie_Alarm/models/pagestatistics.py>, >> line 57, in __call__ >> self.update() >> File "/home/www-data/web2py/applications/app/models/pagestatistics.py" >> <https://www.movie-alarm.de/admin/edit/Movie_Alarm/models/pagestatistics.py>, >> line 83, in update >> set.update(visits=newvisits) >> File "/home/www-data/web2py/gluon/dal.py", line 8929, in update >> ret = db._adapter.update(tablename,self.query,fields) >> File "/home/www-data/web2py/gluon/dal.py", line 1387, in update >> self.execute(sql) >> File "/home/www-data/web2py/gluon/dal.py", line 1709, in execute >> return self.log_execute(*a, **b) >> File "/home/www-data/web2py/gluon/dal.py", line 1703, in log_execute >> ret = self.cursor.execute(*a, **b) >> OperationalError: database is locked >> >> Error snapshot [image: help] >> >> <class 'sqlite3.OperationalError'>(database is locked) >> " >> 66.249.yy.xxx this is probably the ip of the person who made the error. >> 2013-03-06.15-43-30 this should be the timestamp. >> Database is locked is the type of error, which does not help me much. >> The Traceback tells me that the pagestatistics did the error. >> but since it is on every site of my app and the error count is 1 I got no >> clue where to start to fix this error. >> What I would need is the information how to reproduce this error. >> >> >> -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
