Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to install with PostgreSQL #1

Open
lincolnloop opened this issue Sep 29, 2009 · 1 comment
Open

Unable to install with PostgreSQL #1

lincolnloop opened this issue Sep 29, 2009 · 1 comment

Comments

@lincolnloop
Copy link

See error below. I'm running on Redmine r2835.

About your application's environment
Ruby version 1.8.6 (x86_64-linux)
RubyGems version 1.3.3
Rails version 2.2.2
Active Record version 2.2.2
Action Pack version 2.2.2
Active Resource version 2.2.2
Action Mailer version 2.2.2
Active Support version 2.2.2
Application root /opt/projects/my_redmine/redmine
Environment production
Database adapter postgresql
Database schema version 20090614091200

About your Redmine plugins
Simple CI 1.0
Redmine Graphs plugin 0.1.0
Redmine Schedules plugin 0.4.2
Timesheet Plugin 0.5.0
Charts Plugin 0.0.10
Redmine Issues Group plugin 0.1.4
Stuff To Do Plugin 0.3.0

$ rake db:migrate_plugins --trace RAILS_ENV="production"
(in /opt/projects/my_redmine/redmine)
** Invoke db:migrate_plugins (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate_plugins
Migrating engines...
Migrating acts_as_activity_provider...
Migrating acts_as_attachable...
Migrating acts_as_customizable...
Migrating acts_as_event...
Migrating acts_as_list...
Migrating acts_as_searchable...
Migrating acts_as_tree...
Migrating acts_as_versioned...
Migrating acts_as_watchable...
Migrating awesome_nested_set...
Migrating classic_pagination...
Migrating coderay-0.7.6.227...
Migrating gravatar...
Migrating open_flash_chart...
Migrating open_id_authentication...
Migrating redmine_charts...
Migrating redmine_graphs...
Migrating redmine_issues_group...
==  AddQueriesGroupBy: migrating ==============================================
-- add_column(:queries, :group_by, :string)
==  AddQueriesGroupBy: migrated (0.0040s) =====================================

rake aborted!
An error has occurred, this and all later migrations canceled:

PGError: ERROR:  current transaction is aborted, commands ignored until end of transaction block
: INSERT INTO schema_migrations (version) VALUES ('1-redmine_issues_group')
/usr/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract_adapter.rb:188:in `log'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/postgresql_adapter.rb:503:in `execute'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/database_statements.rb:171:in `insert_sql'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/database_statements.rb:44:in `insert_without_query_dirty'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/abstract/query_cache.rb:18:in `insert'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/postgresql_adapter.rb:450:in `insert'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/migration.rb:539:in `record_version_state_after_migrating'
/opt/projects/my_redmine/redmine/vendor/plugins/engines/lib/engines/plugin/migrator.rb:39:in `record_version_state_after_migrating'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/migration.rb:481:in `migrate'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/migration.rb:554:in `call'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/migration.rb:554:in `ddl_transaction'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/connection_adapters/postgresql_adapter.rb:550:in `transaction'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/transactions.rb:129:in `transaction'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/migration.rb:554:in `ddl_transaction'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/migration.rb:479:in `migrate'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/migration.rb:466:in `each'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/migration.rb:466:in `migrate'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/migration.rb:394:in `up'
/usr/lib/ruby/gems/1.8/gems/activerecord-2.2.2/lib/active_record/migration.rb:377:in `migrate'
/opt/projects/my_redmine/redmine/vendor/plugins/engines/lib/engines/plugin/migrator.rb:20:in `migrate_plugin'
/opt/projects/my_redmine/redmine/config/../vendor/plugins/engines/lib/engines/plugin.rb:140:in `migrate'
/opt/projects/my_redmine/redmine/lib/tasks/migrate_plugins.rake:8
/opt/projects/my_redmine/redmine/lib/tasks/migrate_plugins.rake:5:in `each'
/opt/projects/my_redmine/redmine/lib/tasks/migrate_plugins.rake:5
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `call'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:636:in `execute'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `each'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:631:in `execute'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:597:in `invoke_with_call_chain'
/usr/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:590:in `invoke_with_call_chain'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:583:in `invoke'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2051:in `invoke_task'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `each'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2029:in `top_level'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2023:in `top_level'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2001:in `run'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:2068:in `standard_exception_handling'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1998:in `run'
/usr/lib/ruby/gems/1.8/gems/rake-0.8.7/bin/rake:31
/usr/local/bin/rake:16:in `load'
/usr/local/bin/rake:16
@rlogiacco
Copy link

Same exact problem here with redmine 0.9.2 and postgresql 8.3

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant