One reason why Sqlite hangs. (For your consideration.)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SM Ryan - 28 Dec 2006 12:07 GMT

Posted so anyone else Googling "sqlite hang" can find this.

We sometimes get persistent Sqlite database busy errors with
no apparent cause (all processes killed, etc) and no help from
the documentation. I found one cause:

We open the sqlite database, some/path, with different uids.
Blown transactions can leave a some/path-journal file which
is mode 600 to the opener uid only; other uids cannot read the
journal and clear out the deceased transaction.

I dewedged sqlite by deleting the journal file. I didn't think
of trying chmod a+rw until later, so I don't know if that will
also work with less risk of damage.

--
SM Ryan http://www.rawbw.com/~wyrmwif/
Leave it to the Catholics to destroy existence.

Reply to this Message

Steven Fisher - 30 Dec 2006 07:05 GMT

> I dewedged sqlite by deleting the journal file. I didn't think
> of trying chmod a+rw until later, so I don't know if that will
> also work with less risk of damage.

Interesting -- which version of sqlite are you using?

-- Steve

Reply to this Message

SM Ryan - 30 Dec 2006 09:20 GMT

# In article <12p7cs3cmol9481@corp.supernews.com>,
# SM Ryan <wyrmwif@tango-sierra-oscar-foxtrot-tango.fake.org> wrote:
#
# > I dewedged sqlite by deleting the journal file. I didn't think
# > of trying chmod a+rw until later, so I don't know if that will
# > also work with less risk of damage.
#
# Interesting -- which version of sqlite are you using?

The Sqlite3 Apple installs in the MacOS 10.4.

--
SM Ryan http://www.rawbw.com/~wyrmwif/
Quit killing people. That's high profile.

Reply to this Message

Mac Forum / Programming / Mac Programming / December 2006

One reason why Sqlite hangs. (For your consideration.)