Maybe i just use mongo for this . Its a simple app with only 8 tasks (more to come)
What do you think ? 2014-11-20 9:50 GMT+00:00 Niphlod <[email protected]>: > 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]>: >> >>> Thank u for the tip >>> >>> António >>> >>> 2014-11-17 15:45 GMT+00:00 Niphlod <[email protected]>: >>> >>>> 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]. >>>> 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. > -- 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.
