|
Database is locked error on 2nd conn: msg#00032python.db.pysqlite.user
Hi. I am attempting to handle two separate named connections to the same database in a class. Both are opened during initialization. The error comes on the second time the second connection and attempts an update. I think it is possible the second connection may have not committed properly with the logic the first time so when I aquire the connection object the second time(in the method that is reporting the error) it throws the 'database is locked'. Does this make sense? I increased the timeout to 10 sec on the connection, just to determine whether this would affect this behaviour at all but it did not. I have not set an isolation level at this point. Many thanks. Regards David |
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Re: Emulating a sequence: 00032, David Pratt |
|---|---|
| Next by Date: | Re: Database is locked error on 2nd conn: 00032, Gerhard Häring |
| Previous by Thread: | Re: .dump command of sqlitei: 00032, David Pratt |
| Next by Thread: | Re: Database is locked error on 2nd conn: 00032, Gerhard Häring |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
| News | FAQ | advertise |