search for: busyexcept

I am currently experiencing concurrency issues after moving from MySQL to SQLite. My original program worked fined using MySQL but is now returning "SQLite3::BusyException" errors. The same result happens whether or not I enable the allow_concurrency flag. If I do manually acquire a lock on the SQLite DB the problem would disapear, but I thought that rails was supposed to handle this internally (optimistic locking?) For example the following code (shortened...

I get too often SQLite3::BusyException and after searching a bit I think I''d need to install a busy_hanlder to return true. That seems to be per connection, how would you do this in a global way in Rails? -- fxn

Just wondering if anyone is using a backend database other than sqlite, and if so, how easy/hard it was to configure. I''m constantly receiving "SQLite3::BusyException: database is locked..." which I presume is due to sqlite''s relatively coarse locking method. Cheers, James -- Senior Linux Platform Engineer Midrange Services AXA Technology Services - Asia Pacific ********************************************************************************...

Hi, Strange behavior here. On my dev machine code works, but on the production machine I get the dreaded: SQLite3::BusyException: database is locked INSERT INTO "comments" [...] What kind of bug could yield such behavior? It''s impossible the database times out, there are no concurrent requests coming in, and the db is only 150kB. Is there a possible race condition? Caching conflict? In development mod...

I have an application where speed is probably the #1 priority here. I am using MySQL 5.0.22. Would SQL be considerably faster than MySQL? I know this has been discussed before, but the search on the forums is not working. Thanks for your help. -- Posted via http://www.ruby-forum.com/.