FUDforum: Database discussions » HY000: database is locked

Home » General » Database discussions » HY000: database is locked

Show: Today's Messages :: Polls :: Message Navigator

Re: HY000: database is locked [message #168272 is a reply to message #168271]

Wed, 03 April 2013 12:51

kwag

Messages: 6
Registered: April 2013
Location: San Juan, PR.

Karma:

Junior Member

Thanks for replying.
naudefj wrote on Wed, 03 April 2013 01:57

Are you using SQLite?

Yes.Quote:

SQLite is meant for single user or low concurrency environments.
Consider switching to MySQL or one of the other supported databases.

I know. But the problem seems is not related to concurrency, because I see the error happen even when there's nobody logged in Exclamation

The way I have the forum set up, no anonymous posts are permitted, so there are no "writers", unless there's actually someone logged in and doing a post.
SQLite doesnt have a problem with hundreds of simultaneous readers. I do that every day, on other non-forum related stuff.
I have seen the error even when I am the only user logged in, so there is another issue.
And other times when there are 5 or 6 users posting, there are no errors Exclamation

There must be some lock contention somewhere.

But anyway, if there's no workaround for this, can I migrate the SQLite database I already have into MySQL or Postgres Question

Thanks

Report message to a moderator

[Message index]

		HY000: database is locked By: kwag on Wed, 03 April 2013 03:14
		Re: HY000: database is locked By: naudefj on Wed, 03 April 2013 05:57
		Re: HY000: database is locked By: kwag on Wed, 03 April 2013 12:51
		Re: HY000: database is locked By: naudefj on Sun, 14 April 2013 07:07

Previous Topic:	Regenerate tv table without running consistency checker
Next Topic:	Insert html content as a value into mysql database?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 19:12:51 GMT 2024

Total time taken to generate the page: 0.04387 seconds