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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
