The problem is that SQLite is not a client-server database and only thread can access a SQLite database at one time. If one thread access the db file, the file is locked and nobody else can use it until released.
You should be using postgresql or mysql to do what you are doing. Massimo On Oct 9, 9:10 am, Scott Hunter <[EMAIL PROTECTED]> wrote: > When I tried that, I got the following error when attempting a query: > > ProgrammingError: SQLite objects created in a thread can only be > used in that same thread. > > But when I try to create an SQLDB object in my thread, I get: > > OperationalError: unable to open database file > > Maybe my thread didn't "instantiate its own connection to the > database"; what does this involve? > > Thanks, > Scott > > On Oct 8, 5:58 pm, mdipierro <[EMAIL PROTECTED]> wrote: > > > It depends on who starts the thread. The main problem is that the web > > server monitors threads and kills them when they take long. > > I principle a model, view controller can start its own thread but you > > should pass a SQLDB object to it. It needs to instantiate its own > > connection to the database and commit or rollback explicitly. > > > Massimo > > > On Oct 8, 4:42 pm, Scott Hunter <[EMAIL PROTECTED]> wrote: > > > > Using the shell command-line option of web2py, one can create a daemon > > > with full access to the DB that the webserver has. Is it possible to > > > do something similar w/ a thread created within web2py? When I tried, > > > I got complaints that my db variable wasn't defined; then I tried to > > > include my model file, but got a complaint that it isn't a module. > > > > Thanks, > > > Scott --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
