Andreas Roedl said the following on 01/15/2009 12:46 PM:
>
> Try to set a timeout in your database.yml as described in the last
> post of this thread:
>
> http://www.ruby-forum.com/topic/138904
Done that. Restarted Passenger ...
Still locked. Now it takes about 10 seconds to come back with the 500
page instead of being immediate.
How do I unlock it?
This is the tail end of the log file:
Page Load (0.004572) SELECT * FROM pages WHERE (pages."id" = 1)
PagePart Load (0.007668) SELECT * FROM page_parts WHERE
(page_parts.page_id = 3) ORDER BY id
WARNING: Can't mass-assign these protected attributes: id
WARNING: Can't mass-assign these protected attributes: id
Page Load (0.005181) SELECT * FROM pages WHERE (pages.slug = 'rss'
AND pages.parent_id = 1 AND pages.id <> 3) LIMIT 1
Page Update with optimistic locking (0.006955) UPDATE pages
SET "keywords" = '', "created_at" = '2007-01-19 03:04:44',
"event_datetime" = NULL, "layout_id" = 3, "created_by_id" = 1, "virtual"
= 'f', "posi
tion" = 12, "updated_by_id" = 2, "title" = 'RSS ', "published_at" =
'2007-01-18 22:04:44', "breadcrumb" = 'RSS ', "class_name" = 'Page',
"descrip
tion" = '', "parent_id" = 1, "updated_at" = '2009-01-15 18:15:55',
"status_id" = 100, "lock_version" = 3, "slug" = 'rss'
WHERE id = 3
AND "lock_version" = 2
SQLite3::BusyException (database is locked):
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/errors.rb:94:in
`check'
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/resultset.rb:76:in
`check'
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/resultset.rb:68:in
`commence'
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/resultset.rb:61:in
`initialize'
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/statement.rb:163:in
`new'
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/statement.rb:163:in
`execute'
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/database.rb:212:in
`execute'
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/database.rb:187:in
`prepare'
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/database.rb:211:in
`execute'
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.2.1/lib/sqlite3/database.rb:611:in
`commit'
/usr/lib/ruby/gems/1.8/gems/radiant-0.6.9/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:160:in
`commit_db
_transaction'
--
Make up your mind to act decidedly and take the consequences. No good is
ever done in this world by hesitation.
Thomas H. Huxley
_______________________________________________
Radiant mailing list
Post: Radiant@radiantcms.org
Search: http://radiantcms.org/mailing-list/search/
Site: http://lists.radiantcms.org/mailman/listinfo/radiant
