I've just installed Typo (the current stable build) in my DreamHost
account. I followed the directions on the handy Typo-DreamHost page
(thanks!) except I configured it for sqlite instead of mysql.
The site ran fine for five minutes, but halfway through configuring
my blog it started to return the dreaded "Application Error", first
intermittently and now constantly.
The production.log shows a bunch of Ruby exceptions. Most of them
look like the one I've pasted below -- a sqlite query fails with
"database is locked". I think what's happening is that there are
multiple fcgi processes and when two try to access the database at
the same time, the one that gets there second is not handling the
lock errors gracefully (by waiting and retrying); instead it decides
the query has failed and throws an exception.
Is this a known bug? I'm a total Rails newbie (though I have a little
experience with Ruby and a lot with sqlite) so it's possible I
screwed something up in my install.
And yes, I will work around this by setting up mysql instead. I just
hate having to configure some lumbering industrial-strength db server
with its own account setup, just to run one little blog :)
--Jens
Processing Base#show_available (for 69.12.133.193 at 2005-12-21
09:18:08) [POST]
Parameters: {"action"=>"show_available", "controller"=>"admin/
sidebar"}
ActiveRecord::StatementInvalid (database is locked: UPDATE sessions
SET 'updated_at' = '2005-12-21 09:18:08', 'data' = 'BAh7BzoJdXNlcm86CVVz
ZXIGOhBAYXR0cmlidXRlc3sKIgluYW1lIg9KZW5z
IEFsZmtlIgdpZCIGMSIKbG9naW4iCWplbnMiDXBhc3N3b3JkIi1lM2YzZTYz
MDgyNDUyNDU0YTdiY2VlOWRlYjYyMzc2M2Y0YTAwMDkwIgplbWFpbCIXamVu
c0Btb29zZXlhcmQuY29tIgpmbGFzaElDOidBY3Rpb25Db250cm9sbGVyOjpG
bGFzaDo6Rmxhc2hIYXNoewAGOgpAdXNlZHsA
', 'sessid' = '6eb4029b9917899cce11dd4c98b7da0d' WHERE id = 1):
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.0/lib/
active_record/connection_adapters/abstract_adapter.rb:67:in `log'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.0/lib/
active_record/connection_adapters/sqlite_adapter.rb:133:in `execute'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.0/lib/
active_record/connection_adapters/sqlite_adapter.rb:137:in `update'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.0/lib/
active_record/base.rb:1436:in `update_without_lock'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.0/lib/
active_record/locking.rb:45:in `update_without_callbacks'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.0/lib/
active_record/callbacks.rb:274:in `update_without_timestamps'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.0/lib/
active_record/timestamp.rb:39:in `update'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.0/lib/
active_record/base.rb:1431:in `create_or_update_without_callbacks'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.0/lib/
active_record/callbacks.rb:249:in `create_or_update'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.0/lib/
active_record/base.rb:1231:in `save_without_validation'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.0/lib/
active_record/validations.rb:687:in `save_without_transactions'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.0/lib/
active_record/transactions.rb:126:in `save'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.0/lib/
active_record/transactions.rb:126:in `transaction'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.0/lib/
active_record/transactions.rb:91:in `transaction'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.0/lib/
active_record/transactions.rb:118:in `transaction'
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.0/lib/
active_record/transactions.rb:126:in `save'
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.0/lib/
action_controller/session/active_record_store.rb:294:in `update'
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.0/lib/
action_controller/session/active_record_store.rb:294:in `silence'
/usr/lib/ruby/gems/1.8/gems/actionpack-1.11.0/lib/
action_controller/session/active_record_store.rb:294:in `update'
...
_______________________________________________
Typo-list mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/typo-list
