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.
