On Tue, Jul 10, 2012 at 3:12 PM, <[email protected]> wrote:
> 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')
>
Mahima,
Looks like your MySQL server is blocked by a lock - are there a lot of
other processes using it?
> ****
>
> ** **
>
> 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.
>
You should definitely set up a message queue, or configure Gitorious to run
without one. There's a gem called stompserver that is easily installed and
started ("gem install stompserver && stompserver").
Cheers,
- Marius
--
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
