sqlite has very well known problems dealing with concurrent access. every write operation blocks the database. you may mitigate it enabling WAL, but in any case, the limitation stands.
On Thursday, November 20, 2014 10:32:56 AM UTC+1, Ramos wrote: > > i have this error and only using one worker, with 2 i eventually get an > error after some time . > My 8 tasks connects to 8 ftp servers to read a csv file and then connects > to other system via ODBC to save the data. > I dont understant why its saying "database is locked" > I´m not saving documents to my web2py tables. > However i'm using sqlite. > [image: Imagem inline 1] > > 2014-11-17 16:23 GMT+00:00 António Ramos <[email protected] <javascript:> > >: > >> Thank u for the tip >> >> António >> >> 2014-11-17 15:45 GMT+00:00 Niphlod <[email protected] <javascript:>>: >> >>> apart from "update web2py" (2.0.9 is so old that my brain hurts), trying >>> lowering the number of workers. That error means that your database can't >>> keep up with the workers. >>> >>> >>> On Monday, November 17, 2014 3:16:25 PM UTC+1, Ramos wrote: >>>> >>>> Hello i have this error i started 10 workers but only have 8 tasks. >>>> Thank u >>>> >>>> >>>> [image: Imagem inline 1] >>>> >>> -- >>> 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 [email protected] <javascript:>. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> > -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
