Thanks Niphlod.
On Thursday, March 7, 2013 8:55:10 PM UTC+1, Niphlod wrote: > > you need to figure out yourself . I'm keen to postgresql, but that's a > personal preference. In ANY case, do not use SQLite for everything that is > write-intensive (lots of reads are not a problem). The welcome app it's a > base-start, not a one-solution-for-all-problems app. > > On Thursday, March 7, 2013 7:42:16 PM UTC+1, BlueShadow wrote: >> >> 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? >> What is the recommended DB? There are like 20 in the web2py documentation. >> >> 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.