Hi,
I am able to successfully install Gitorious at my local machine. But when I am
trying to create a new project it gives me the following error:
Error:
ActiveRecord::StatementInvalid in ProjectsController#create
Mysql::Error: Lock wait timeout exceeded; try restarting transaction: INSERT
INTO `projects` (`oauth_path_prefix`, `title`, `description`, `created_at`,
`license`, `wiki_enabled`, `oauth_signoff_key`, `owner_type`, `site_id`,
`home_url`, `oauth_signoff_secret`, `mailinglist_url`, `oauth_signoff_site`,
`slug`, `bugtracker_url`, `owner_id`, `user_id`, `merge_requests_need_signoff`,
`merge_request_custom_states`, `suspended_at`, `updated_at`) VALUES(NULL,
'InnerSource', 'innersource', '2012-07-10 12:17:45', 'Academic Free License
v3.0', 1, NULL, 'User', NULL, NULL, NULL, NULL, NULL, 'innersource', NULL, 1,
1, 0, NULL, NULL, '2012-07-10 12:17:45')
Also please find below the error that I am getting in the log file:
** ultrasphinx: spelling support not available (raspell configuration raised
"uninitialized constant Ultrasphinx::Spell::Aspell")
ActiveRecord::StatementInvalid (Mysql::Error: Lock wait timeout exceeded; try
restarting transaction: INSERT INTO `projects` (`oauth_path_prefix`, `title`,
`description`, `created_at`, `license`, `wiki_enabled`, `oauth_signoff_key`,
`owner_type`, `site_id`, `home_url`, `oauth_signoff_secret`, `mailinglist_url`,
`oauth_signoff_site`, `slug`, `bugtracker_url`, `owner_id`, `user_id`,
`merge_requests_need_signoff`, `merge_request_custom_states`, `suspended_at`,
`updated_at`) VALUES(NULL, 'InnerSource', 'innersource', '2012-07-10 12:17:45',
'Academic Free License v3.0', 1, NULL, 'User', NULL, NULL, NULL, NULL, NULL,
'innersource', NULL, 1, 1, 0, NULL, NULL, '2012-07-10 12:17:45')):
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:219:in
`log'
vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:323:in
`execute'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:259:in
`insert_sql'
vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:333:in
`insert_sql'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:44:in
`insert_without_query_dirty'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:18:in
`insert'
vendor/rails/activerecord/lib/active_record/base.rb:2910:in
`create_without_timestamps'
vendor/rails/activerecord/lib/active_record/timestamp.rb:53:in
`create_without_callbacks'
vendor/rails/activerecord/lib/active_record/callbacks.rb:266:in `create'
vendor/rails/activerecord/lib/active_record/base.rb:2876:in
`create_or_update_without_callbacks'
vendor/rails/activerecord/lib/active_record/callbacks.rb:250:in
`create_or_update'
vendor/rails/activerecord/lib/active_record/base.rb:2540:in
`save_without_validation'
vendor/rails/activerecord/lib/active_record/validations.rb:1078:in
`save_without_dirty'
vendor/rails/activerecord/lib/active_record/dirty.rb:79:in
`save_without_transactions'
vendor/rails/activerecord/lib/active_record/transactions.rb:229:in `send'
vendor/rails/activerecord/lib/active_record/transactions.rb:229:in
`with_transaction_returning_status'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:136:in
`transaction'
vendor/rails/activerecord/lib/active_record/transactions.rb:182:in
`transaction'
vendor/rails/activerecord/lib/active_record/transactions.rb:228:in
`with_transaction_returning_status'
vendor/rails/activerecord/lib/active_record/transactions.rb:196:in `save'
vendor/rails/activerecord/lib/active_record/transactions.rb:208:in
`rollback_active_record_state!'
vendor/rails/activerecord/lib/active_record/transactions.rb:196:in `save'
app/controllers/projects_controller.rb:104:in `create'
vendor/rails/actionpack/lib/action_controller/base.rb:1331:in `send'
vendor/rails/actionpack/lib/action_controller/base.rb:1331: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'
vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:17:in `ms'
/usr/lib/ruby/1.8/benchmark.rb:308:in `realtime'
vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:17:in `ms'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in
`perform_action_without_rescue'
vendor/rails/actionpack/lib/action_controller/rescue.rb:160:in
`perform_action_without_flash'
vendor/rails/actionpack/lib/action_controller/flash.rb:146:in `perform_action'
vendor/rails/actionpack/lib/action_controller/base.rb:532:in `send'
vendor/rails/actionpack/lib/action_controller/base.rb:532:in
`process_without_filters'
vendor/rails/actionpack/lib/action_controller/filters.rb:606:in `process'
vendor/rails/actionpack/lib/action_controller/base.rb:391:in `process'
vendor/rails/actionpack/lib/action_controller/base.rb:386:in `call'
vendor/rails/actionpack/lib/action_controller/routing/route_set.rb:437:in
`call'
vendor/rails/actionpack/lib/action_controller/dispatcher.rb:87:in `dispatch'
vendor/rails/actionpack/lib/action_controller/dispatcher.rb:121:in `_call'
vendor/rails/actionpack/lib/action_controller/dispatcher.rb:130:in
`build_middleware_stack'
vendor/rails/actionpack/lib/action_controller/string_coercion.rb:25:in `call'
vendor/rails/actionpack/lib/action_controller/string_coercion.rb:25:in `call'
rack (1.0.1) lib/rack/head.rb:9:in `call'
rack (1.0.1) lib/rack/methodoverride.rb:24:in `call'
vendor/rails/actionpack/lib/action_controller/params_parser.rb:15:in `call'
vendor/rails/railties/lib/rails/rack/metal.rb:47:in `call'
vendor/rails/actionpack/lib/action_controller/session/abstract_store.rb:122:in
`call'
vendor/rails/activerecord/lib/active_record/query_cache.rb:29:in `call'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in
`cache'
vendor/rails/activerecord/lib/active_record/query_cache.rb:9:in `cache'
vendor/rails/activerecord/lib/active_record/query_cache.rb:28:in `call'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/connection_pool.rb:361:in
`call'
vendor/rails/activesupport/lib/active_support/cache/strategy/local_cache.rb:24:in
`call'
vendor/rails/actionpack/lib/action_controller/failsafe.rb:26:in `call'
rack (1.0.1) lib/rack/lock.rb:11:in `call'
rack (1.0.1) lib/rack/lock.rb:11:in `synchronize'
rack (1.0.1) lib/rack/lock.rb:11:in `call'
vendor/rails/actionpack/lib/action_controller/dispatcher.rb:106:in `call'
passenger (3.0.13) lib/phusion_passenger/rack/request_handler.rb:96:in
`process_request'
passenger (3.0.13) lib/phusion_passenger/abstract_request_handler.rb:516:in
`accept_and_process_next_request'
passenger (3.0.13) lib/phusion_passenger/abstract_request_handler.rb:274:in
`main_loop'
passenger (3.0.13)
lib/phusion_passenger/classic_rails/application_spawner.rb:321:in
`start_request_handler'
passenger (3.0.13)
lib/phusion_passenger/classic_rails/application_spawner.rb:275:in `send'
passenger (3.0.13)
lib/phusion_passenger/classic_rails/application_spawner.rb:275:in
`handle_spawn_application'
passenger (3.0.13) lib/phusion_passenger/utils.rb:479:in `safe_fork'
passenger (3.0.13)
lib/phusion_passenger/classic_rails/application_spawner.rb:270:in
`handle_spawn_application'
passenger (3.0.13) lib/phusion_passenger/abstract_server.rb:357:in `__send__'
passenger (3.0.13) lib/phusion_passenger/abstract_server.rb:357:in
`server_main_loop'
passenger (3.0.13) lib/phusion_passenger/abstract_server.rb:206:in
`start_synchronously'
passenger (3.0.13) lib/phusion_passenger/abstract_server.rb:180:in `start'
passenger (3.0.13)
lib/phusion_passenger/classic_rails/application_spawner.rb:149:in `start'
passenger (3.0.13) lib/phusion_passenger/spawn_manager.rb:219:in
`spawn_rails_application'
passenger (3.0.13) lib/phusion_passenger/abstract_server_collection.rb:132:in
`lookup_or_add'
passenger (3.0.13) lib/phusion_passenger/spawn_manager.rb:214:in
`spawn_rails_application'
passenger (3.0.13) lib/phusion_passenger/abstract_server_collection.rb:82:in
`synchronize'
passenger (3.0.13) lib/phusion_passenger/abstract_server_collection.rb:79:in
`synchronize'
passenger (3.0.13) lib/phusion_passenger/spawn_manager.rb:213:in
`spawn_rails_application'
passenger (3.0.13) lib/phusion_passenger/spawn_manager.rb:132:in
`spawn_application'
passenger (3.0.13) lib/phusion_passenger/spawn_manager.rb:275:in
`handle_spawn_application'
passenger (3.0.13) lib/phusion_passenger/abstract_server.rb:357:in `__send__'
passenger (3.0.13) lib/phusion_passenger/abstract_server.rb:357:in
`server_main_loop'
passenger (3.0.13) lib/phusion_passenger/abstract_server.rb:206:in
`start_synchronously'
passenger (3.0.13) helper-scripts/passenger-spawn-server:99
Also I checked , all my below processes are running.
ps aux | grep git-daemon
ps aux | grep git-ultrasphinx
ps aux | grep git-poller
ps aux | grep stomp
ps aux | grep apaches2
ps aux | grep mysql
My Gitorious Home directory is : /var/lib/gitorious
Also I am using gem env is :
RubyGems Environment:
- RUBYGEMS VERSION: 1.8.15
- RUBY VERSION: 1.8.7 (2011-06-30 patchlevel 352) [i686-linux]
- INSTALLATION DIRECTORY: /var/lib/gems/1.8
- RUBY EXECUTABLE: /usr/bin/ruby1.8
- EXECUTABLE DIRECTORY: /usr/local/bin
- RUBYGEMS PLATFORMS:
- ruby
- x86-linux
- GEM PATHS:
- /var/lib/gems/1.8
- /root/.gem/ruby/1.8
Also I haven't installed the ActiveMQ. Please let me know if I am getting this
error because of that.
Please help me with this error.
Thanks and Regards
Mahima Agarwal
________________________________
Subject to local law, communications with Accenture and its affiliates
including telephone calls and emails (including content), may be monitored by
our systems for the purposes of security and the assessment of internal
compliance with Accenture policy.
______________________________________________________________________________________
www.accenture.com
--
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
