I never ever ever faced the issue . But I trust my VPS with its I/O :-P On Tuesday, April 12, 2016 at 10:39:27 AM UTC+2, Martin wrote: > > Ok, yes i have decided to switch to a mysql db. Still think its a little > strange since i have less then 1k page views/day and this happens every day > now. Thanks for the advice! > > Edit: Could using WAL help mitigate this issue? Maybe Sqlite isn't the > best option, but for my very small application i think that it should work? > Sqlite is so convenient that I'm a little reluctant to migrate just yet. > > On Tuesday, 12 April 2016 09:39:04 UTC+2, Niphlod wrote: >> >> the system can be strained as long as it gets but a malformed database is >> an indicator that the VPS I/O subsystem is not responding correctly, or >> that the VPS gets brutally rebooted from time to time. There's nothing >> web2py can do. That being said, going into production with a maybe >> write-intensive app backed by SQLite is not the smartest idea around. >> SQLite is good but it's not a production backend if not strictly readonly. >> >> On Monday, April 11, 2016 at 10:22:23 PM UTC+2, Martin wrote: >>> >>> Ok, most of the information i found was only about how to repair such an >>> error, but maybe i didnt search long enough.. >>> >>> I am hosting the website on my own VPS using nginx. I dont have a very >>> large amount of traffic so in that case maybe i made something very >>> inefficient. Could brute force break in attempts put extra strain on the >>> system in that regard? I am constantly under that kind of attacks, not >>> worried that they will succeed though. >>> >>> On Monday, 11 April 2016 21:18:15 UTC+2, Niphlod wrote: >>>> >>>> seems that the i/o subsystem of your hosting is getting "tired". Google >>>> is full of information regarding that particular error.... where are you >>>> hosting your app ? >>>> >>>> On Monday, April 11, 2016 at 9:02:09 PM UTC+2, Martin wrote: >>>>> >>>>> Hi, >>>>> >>>>> I am running a webshop built using web2py. Everything has been running >>>>> smoothly for a few weeks but now I am having some problems. At seemingly >>>>> random times the database will break somehow. The website becomes >>>>> inaccessible and the tickets give the message "DatabaseError: database >>>>> disk >>>>> image is malformed". The only way to my knowledge to repair the website >>>>> is >>>>> to perform a full restore. I am using an sqlite database. What could >>>>> cause >>>>> this error? Perhaps most important, could it be some kind of attack? I'm >>>>> not very knowledgeable in that area... >>>>> >>>>> Hope somebody knows the awnser to this, it is becoming really annoying! >>>>> >>>>
-- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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/d/optout.
