Closed GoogleCodeExporter closed 9 years ago
I have some questions:
1. Output of command: cat /opt/ovz-web-panel/revision
2. How many physical servers do you have?
3. How many virtual servers do you have?
Try to restart the panel again using "/etc/init.d/owp restart" Do you see the
same error? What error do you see on login attempt? Need to check
/opt/ovz-web-panel/log/production.log for errors.
Original comment by sibprogrammer
on 14 Nov 2010 at 4:31
[deleted comment]
hi,
i have same probleme but after login, i connect putty and restar owp:READ Error
/opt/ovz-web-panel/vendor/rails/railties/lib/commands/runner.rb:47:
/usr/lib/ruby/1.8/sqlite3/errors.rb:62:in `check': database is locked
(SQLite3::BusyException)
Regard.
More problem SQLite, i try fresh install panel again problem
tks.
Original comment by pirath...@gmail.com
on 14 Nov 2010 at 6:11
1.Output of command: cat /opt/ovz-web-panel/revision
cat /opt/ovz-web-panel/revision
766
2.How many physical servers do you have?
3 physical servers
3. How many virtual servers do you have?
~20 on 1 physical servers.
Original comment by x.empty....@gmail.com
on 14 Nov 2010 at 7:10
cat production.log
# Logfile created on Sun Nov 14 22:11:44 +0300 2010
Processing SessionsController#new (for 77.239.236.192 at 2010-11-14 22:13:09)
[GET]
Rendering template within layouts/application
Rendering sessions/new
Completed in 125ms (View: 12, DB: 0) | 200 OK [http://blablabla.ru/]
Processing SessionsController#new (for 11.111.111.111 at 2010-11-14 22:13:14)
[POST]
Parameters: {"remember_me"=>"on", "locale"=>"ru", "login"=>"admin", "password"=>"blablabla"}
Cookie set: locale=ru; path=/; expires=Mon, 14 Nov 2011 19:13:14 GMT
Cookie set: auth_token=; path=/; expires=Thu, 01 Jan 1970 00:00:00 GMT
SQLite3::BusyException (database is locked):
/usr/lib/ruby/1.8/sqlite3/errors.rb:62:in `check'
/usr/lib/ruby/1.8/sqlite3/statement.rb:39:in `initialize'
/usr/lib/ruby/1.8/sqlite3/database.rb:154:in `new'
/usr/lib/ruby/1.8/sqlite3/database.rb:154:in `prepare'
/usr/lib/ruby/1.8/sqlite3/database.rb:202:in `execute2'
/usr/lib/ruby/1.8/sqlite3/pragmas.rb:217:in `table_info'
/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite3_adapter.rb:28:in `table_structure'
/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:189:in `columns'
/vendor/rails/activerecord/lib/active_record/base.rb:1220:in `columns'
/vendor/rails/activerecord/lib/active_record/base.rb:1233:in `column_names'
/vendor/rails/activerecord/lib/active_record/base.rb:1246:in `column_methods_hash'
/vendor/rails/activerecord/lib/active_record/base.rb:1860:in `all_attributes_exists?'
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `all?'
/vendor/rails/activerecord/lib/active_record/base.rb:1860:in `each'
/vendor/rails/activerecord/lib/active_record/base.rb:1860:in `all?'
/vendor/rails/activerecord/lib/active_record/base.rb:1860:in `all_attributes_exists?'
/vendor/rails/activerecord/lib/active_record/base.rb:1778:in `method_missing'
/app/models/user.rb:27:in `authenticate'
/app/controllers/sessions_controller.rb:11:in `new'
/vendor/rails/actionpack/lib/action_controller/base.rb:1253:in `send'
/vendor/rails/actionpack/lib/action_controller/base.rb:1253:in `perform_action_without_filters'
/vendor/rails/actionpack/lib/action_controller/filters.rb:617:in `call_filters'
/vendor/rails/actionpack/lib/action_controller/filters.rb:610:in `perform_action_without_benchmark'
/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/vendor/rails/actionpack/lib/action_controller/rescue.rb:136:in `perform_action_without_caching'
/vendor/rails/actionpack/lib/action_controller/caching/sql_cache.rb:13:in `perform_action'
/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache'
/vendor/rails/activerecord/lib/active_record/query_cache.rb:8:in `cache'
/vendor/rails/actionpack/lib/action_controller/caching/sql_cache.rb:12:in `perform_action'
/vendor/rails/actionpack/lib/action_controller/base.rb:524:in `send'
/vendor/rails/actionpack/lib/action_controller/base.rb:524:in `process_without_filters'
/vendor/rails/actionpack/lib/action_controller/filters.rb:606:in `process_without_session_management_support'
/vendor/rails/actionpack/lib/action_controller/session_management.rb:134:in `process'
/vendor/rails/actionpack/lib/action_controller/base.rb:392:in `process'
/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:183:in `handle_request'
/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:110:in `dispatch_unlocked'
/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:123:in `dispatch'
/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:122:in `synchronize'
/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:122:in `dispatch'
/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:132:in `dispatch_cgi'
/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:39:in `dispatch'
/vendor/rails/railties/lib/webrick_server.rb:103:in `handle_dispatch'
/vendor/rails/railties/lib/webrick_server.rb:74:in `service'
/usr/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
/usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
/usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
/usr/lib/ruby/1.8/webrick/server.rb:162:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
/usr/lib/ruby/1.8/webrick/server.rb:95:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:92:in `each'
/usr/lib/ruby/1.8/webrick/server.rb:92:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:37:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:82:in `start'
/vendor/rails/railties/lib/webrick_server.rb:60:in `dispatch'
/vendor/rails/railties/lib/commands/servers/webrick.rb:66
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `require'
/vendor/rails/activesupport/lib/active_support/dependencies.rb:153:in `require'
/vendor/rails/activesupport/lib/active_support/dependencies.rb:521:in `new_constants_in'
/vendor/rails/activesupport/lib/active_support/dependencies.rb:153:in `require'
/vendor/rails/railties/lib/commands/server.rb:49
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `require'
//script/server:3
Processing SessionsController#new (for 11.111.111.111 at 2010-11-14 22:13:24)
[POST]
Parameters: {"remember_me"=>"on", "locale"=>"ru", "login"=>"admin", "password"=>"blablabla"}
SQLite3::BusyException (database is locked):
/usr/lib/ruby/1.8/sqlite3/errors.rb:62:in `check'
/usr/lib/ruby/1.8/sqlite3/statement.rb:39:in `initialize'
/usr/lib/ruby/1.8/sqlite3/database.rb:154:in `new'
/usr/lib/ruby/1.8/sqlite3/database.rb:154:in `prepare'
/usr/lib/ruby/1.8/sqlite3/database.rb:202:in `execute2'
/usr/lib/ruby/1.8/sqlite3/pragmas.rb:217:in `table_info'
/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite3_adapter.rb:28:in `table_structure'
/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:189:in `columns'
/vendor/rails/activerecord/lib/active_record/base.rb:1220:in `columns'
/vendor/rails/activerecord/lib/active_record/base.rb:2839:in `attributes_from_column_definition_without_lock'
/vendor/rails/activerecord/lib/active_record/locking/optimistic.rb:55:in `attributes_from_column_definition'
/vendor/rails/activerecord/lib/active_record/base.rb:2279:in `initialize'
/app/models/event_log.rb:23:in `new'
/app/models/event_log.rb:23:in `log'
/app/models/event_log.rb:19:in `error'
/app/controllers/application.rb:44:in `log_error'
/vendor/rails/actionpack/lib/action_controller/rescue.rb:118:in `rescue_action_without_handler'
/vendor/rails/actionpack/lib/action_controller/rescue.rb:61:in `rescue_action'
/vendor/rails/actionpack/lib/action_controller/rescue.rb:138:in `perform_action_without_caching'
/vendor/rails/actionpack/lib/action_controller/caching/sql_cache.rb:13:in `perform_action'
/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache'
/vendor/rails/activerecord/lib/active_record/query_cache.rb:8:in `cache'
/vendor/rails/actionpack/lib/action_controller/caching/sql_cache.rb:12:in `perform_action'
/vendor/rails/actionpack/lib/action_controller/base.rb:524:in `send'
/vendor/rails/actionpack/lib/action_controller/base.rb:524:in `process_without_filters'
/vendor/rails/actionpack/lib/action_controller/filters.rb:606:in `process_without_session_management_support'
/vendor/rails/actionpack/lib/action_controller/session_management.rb:134:in `process'
/vendor/rails/actionpack/lib/action_controller/base.rb:392:in `process'
/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:183:in `handle_request'
/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:110:in `dispatch_unlocked'
/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:123:in `dispatch'
/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:122:in `synchronize'
/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:122:in `dispatch'
/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:132:in `dispatch_cgi'
/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:39:in `dispatch'
/vendor/rails/railties/lib/webrick_server.rb:103:in `handle_dispatch'
/vendor/rails/railties/lib/webrick_server.rb:74:in `service'
/usr/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
/usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
/usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
/usr/lib/ruby/1.8/webrick/server.rb:162:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
/usr/lib/ruby/1.8/webrick/server.rb:95:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:92:in `each'
/usr/lib/ruby/1.8/webrick/server.rb:92:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:37:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:82:in `start'
/vendor/rails/railties/lib/webrick_server.rb:60:in `dispatch'
/vendor/rails/railties/lib/commands/servers/webrick.rb:66
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `require'
/vendor/rails/activesupport/lib/active_support/dependencies.rb:153:in `require'
/vendor/rails/activesupport/lib/active_support/dependencies.rb:521:in `new_constants_in'
/vendor/rails/activesupport/lib/active_support/dependencies.rb:153:in `require'
/vendor/rails/railties/lib/commands/server.rb:49
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `require'
//script/server:3
/!\ FAILSAFE /!\ Sun Nov 14 22:13:29 +0300 2010
Status: 500 Internal Server Error
database is locked
/usr/lib/ruby/1.8/sqlite3/errors.rb:62:in `check'
/usr/lib/ruby/1.8/sqlite3/statement.rb:39:in `initialize'
/usr/lib/ruby/1.8/sqlite3/database.rb:154:in `new'
/usr/lib/ruby/1.8/sqlite3/database.rb:154:in `prepare'
/usr/lib/ruby/1.8/sqlite3/database.rb:202:in `execute2'
/usr/lib/ruby/1.8/sqlite3/pragmas.rb:217:in `table_info'
/opt/ovz-web-panel/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite3_adapter.rb:28:in `table_structure'
/opt/ovz-web-panel/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:189:in `columns'
/opt/ovz-web-panel/vendor/rails/activerecord/lib/active_record/base.rb:1220:in `columns'
/opt/ovz-web-panel/vendor/rails/activerecord/lib/active_record/base.rb:2839:in `attributes_from_column_definition_without_lock'
/opt/ovz-web-panel/vendor/rails/activerecord/lib/active_record/locking/optimistic.rb:55:in `attributes_from_column_definition'
/opt/ovz-web-panel/vendor/rails/activerecord/lib/active_record/base.rb:2279:in `initialize'
/opt/ovz-web-panel/app/models/event_log.rb:23:in `new'
/opt/ovz-web-panel/app/models/event_log.rb:23:in `log'
/opt/ovz-web-panel/app/models/event_log.rb:19:in `error'
/opt/ovz-web-panel/app/controllers/application.rb:44:in `log_error'
/opt/ovz-web-panel/vendor/rails/actionpack/lib/action_controller/rescue.rb:118:in `rescue_action_without_handler'
/opt/ovz-web-panel/vendor/rails/actionpack/lib/action_controller/rescue.rb:61:in `rescue_action'
/opt/ovz-web-panel/vendor/rails/actionpack/lib/action_controller/rescue.rb:138:in `perform_action_without_caching'
/opt/ovz-web-panel/vendor/rails/actionpack/lib/action_controller/caching/sql_cache.rb:13:in `perform_action'
/opt/ovz-web-panel/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache'
/opt/ovz-web-panel/vendor/rails/activerecord/lib/active_record/query_cache.rb:8:in `cache'
/opt/ovz-web-panel/vendor/rails/actionpack/lib/action_controller/caching/sql_cache.rb:12:in `perform_action'
/opt/ovz-web-panel/vendor/rails/actionpack/lib/action_controller/base.rb:524:in `send'
/opt/ovz-web-panel/vendor/rails/actionpack/lib/action_controller/base.rb:524:in `process_without_filters'
/opt/ovz-web-panel/vendor/rails/actionpack/lib/action_controller/filters.rb:606:in `process_without_session_management_support'
/opt/ovz-web-panel/vendor/rails/actionpack/lib/action_controller/session_management.rb:134:in `process'
/opt/ovz-web-panel/vendor/rails/actionpack/lib/action_controller/base.rb:392:in `process'
/opt/ovz-web-panel/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:183:in `handle_request'
/opt/ovz-web-panel/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:110:in `dispatch_unlocked'
/opt/ovz-web-panel/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:123:in `dispatch'
/opt/ovz-web-panel/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:122:in `synchronize'
/opt/ovz-web-panel/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:122:in `dispatch'
/opt/ovz-web-panel/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:132:in `dispatch_cgi'
/opt/ovz-web-panel/vendor/rails/actionpack/lib/action_controller/dispatcher.rb:39:in `dispatch'
/opt/ovz-web-panel/vendor/rails/railties/lib/webrick_server.rb:103:in `handle_dispatch'
/opt/ovz-web-panel/vendor/rails/railties/lib/webrick_server.rb:74:in `service'
/usr/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
/usr/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
/usr/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
/usr/lib/ruby/1.8/webrick/server.rb:162:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
/usr/lib/ruby/1.8/webrick/server.rb:95:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:92:in `each'
/usr/lib/ruby/1.8/webrick/server.rb:92:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:37:in `start'
/usr/lib/ruby/1.8/webrick/server.rb:82:in `start'
/opt/ovz-web-panel/vendor/rails/railties/lib/webrick_server.rb:60:in `dispatch'
/opt/ovz-web-panel/vendor/rails/railties/lib/commands/servers/webrick.rb:66
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `require'
/opt/ovz-web-panel/vendor/rails/activesupport/lib/active_support/dependencies.rb:153:in `require'
/opt/ovz-web-panel/vendor/rails/activesupport/lib/active_support/dependencies.rb:521:in `new_constants_in'
/opt/ovz-web-panel/vendor/rails/activesupport/lib/active_support/dependencies.rb:153:in `require'
/opt/ovz-web-panel/vendor/rails/railties/lib/commands/server.rb:49
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `require'
/opt/ovz-web-panel//script/server:3
Original comment by x.empty....@gmail.com
on 14 Nov 2010 at 7:19
Hi, ME
I have some questions:
1. Output of command: cat /opt/ovz-web-panel/revision
- cat /opt/ovz-web-panel/revision 766
2. How many physical servers do you have?
- Five "5" serveur physique
3. How many virtual servers do you have?
- lol 86 of 5 physical machine
Original comment by pirath...@gmail.com
on 15 Nov 2010 at 4:09
Hi,
I have the same sqlite locking issue with 1.6:
Revision: 766
physical servers: 3
virtual servers: 58
Original comment by fornex....@gmail.com
on 15 Nov 2010 at 9:15
Is it a permanent error, or it occurs from time to time? Maybe SQLite database
in dead lock.
If it's a permanent error, can you give me the output of "ls -la
/opt/ovz-web-panel/db/"
Original comment by sibprogrammer
on 16 Nov 2010 at 8:32
It was a SQLite deadlock, and restarting OWP resolved the problem.
Original comment by fornex....@gmail.com
on 16 Nov 2010 at 8:45
[deleted comment]
not for me
after insert old pass, new pas X2 name and email, i have this
Internal error: SQLite3::BusyException: database is locked: UPDATE "users" SET
"updated_at" = '2010-11-17 14:30:53', "email" = 'webmaster@xxxxx.com',
"contact_name" = 'webmaster', "crypted_password" =
'xxxxxxff4a9806dxxxxxxxx16fc6667d0' WHERE "id" = 1
this is fresh install panel.
what is best os for panel ? debian ? ubuntu ? centos ?
Why 1.6 most bug sqlite ?
tks
Original comment by pirath...@gmail.com
on 17 Nov 2010 at 2:37
My servers are on Ubuntu/Debian. I can recommend them, but panel should work
well on CentOS also.
As a temporary solution to workaround SQLite busy errors is to disable watchdog
daemon:
ruby /opt/ovz-web-panel/utils/watchdog/watchdog.rb stop
Problem occurs due to intensive write operations of watchdog daemon for
gathering stats data. On my systems I didn't see such errors, but I have not so
much virtual servers.
Original comment by sibprogrammer
on 17 Nov 2010 at 3:09
no but the error occurs even without virtual server
I took a vps, put debian, update, then install the panel, admin / admin
edited my account and change the password, and the big mistake sqlite, I click
ok then it goes smoothly.
I tested under debian v5 v6squezze same problem then I test under centos 5.
I always by a new installation, I come back to you as soon as possible.
or I can join my problem so as not to pollute the tracking
Original comment by pirath...@gmail.com
on 17 Nov 2010 at 3:18
[deleted comment]
hi,
i try V1.6 centos again locked and more error sqlite.
I réinstall 1.5 for prod, no error very fast login action, 1.6 very slow and
sqite :O
it's very strange.
Original comment by pirath...@gmail.com
on 18 Nov 2010 at 5:10
If you have any problems related to SQLite, please wait till version 1.7. It
will be released very soon.
Original comment by sibprogrammer
on 18 Nov 2010 at 5:16
No worries, it's just that I wanted to make a update on production in spite of
my test, and I thought that despite the problems I encountered the wait for
version 2 of the panel. which is still far;).
Thank you for what you made.
Original comment by pirath...@gmail.com
on 19 Nov 2010 at 11:01
Original comment by sibprogrammer
on 19 Nov 2010 at 5:50
This issue was updated by revision r774.
New watchdog daemon.
Original comment by sibprogrammer
on 19 Nov 2010 at 5:54
Original comment by sibprogrammer
on 22 Nov 2010 at 4:02
Original issue reported on code.google.com by
x.empty....@gmail.com
on 14 Nov 2010 at 2:12