Hi,
I just tried to do an upgrade of gitlab version 9.1.9 to version 9.2.10 running on FreeBSD.
The problem I have now is that the db:migrate step failed due to no space left on the harddisk. The output was:
su -l git -c “cd /usr/local/www/gitlab && rake db:migrate RAILS_ENV=production”
The PGconn, PGresult, and PGError constants are deprecated, and will be
removed as of version 1.0.
You should use PG::Connection, PG::Result, and PG::Error instead, respectively.
Called from /usr/local/lib/ruby/gems/2.3/gems/activesupport-4.2.9/lib/active_support/dependencies.rb:240:in `load_dependency'
[DEPRECATION] 'Rack::Attack.blacklist' is deprecated. Please use 'blocklist' instead.
== 20170320173259 MigrateAssignees: migrating =================================
-- exec_query("SELECT COUNT(*) AS count FROM \"issues\" WHERE \"issues\".\"assignee_id\" = 0")
-> 0.0544s
-- exec_query("SELECT COUNT(*) AS count FROM \"issues\" WHERE \"issues\".\"assignee_id\" IS NOT NULL AND NOT (EXISTS (SELECT true FROM \"users\" WHERE \"users\".\"id\" = \"issues\".\"assignee_id\"))")
-> 0.5677s
== 20170320173259 MigrateAssignees: migrated (0.6265s) ========================
== 20170327091750 AddCreatedAtIndexToDeployments: migrating ===================
-- transaction_open?()
-> 0.0000s
-- execute("SET statement_timeout TO 0")
-> 0.0004s
-- add_index(:deployments, :created_at, {:algorithm=>:concurrently})
rake aborted!
StandardError: An error has occurred, all later migrations canceled:
PG::DiskFull: ERROR: could not extend file "base/16451/17983": No space left on device
HINT: Check free disk space.
: CREATE INDEX CONCURRENTLY "index_deployments_on_created_at" ON "deployments" ("created_at" )
/usr/local/www/gitlab/config/initializers/postgresql_opclasses_support.rb:142:in `add_index'
/usr/local/www/gitlab/lib/gitlab/database/migration_helpers.rb:26:in `add_concurrent_index'
/usr/local/www/gitlab/db/migrate/20170327091750_add_created_at_index_to_deployments.rb:9:in `up'
ActiveRecord::StatementInvalid: PG::DiskFull: ERROR: could not extend file "base/16451/17983": No space left on device
HINT: Check free disk space.
: CREATE INDEX CONCURRENTLY "index_deployments_on_created_at" ON "deployments" ("created_at" )
/usr/local/www/gitlab/config/initializers/postgresql_opclasses_support.rb:142:in `add_index'
/usr/local/www/gitlab/lib/gitlab/database/migration_helpers.rb:26:in `add_concurrent_index'
/usr/local/www/gitlab/db/migrate/20170327091750_add_created_at_index_to_deployments.rb:9:in `up'
PG::DiskFull: ERROR: could not extend file "base/16451/17983": No space left on device
HINT: Check free disk space.
/usr/local/www/gitlab/config/initializers/postgresql_opclasses_support.rb:142:in `add_index'
/usr/local/www/gitlab/lib/gitlab/database/migration_helpers.rb:26:in `add_concurrent_index'
/usr/local/www/gitlab/db/migrate/20170327091750_add_created_at_index_to_deployments.rb:9:in `up'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
I tried then to do a:
su -l git -c “cd /usr/local/www/gitlab && rake db:rollback RAILS_ENV=production”
And tried to repeat the migrate step, but I get the following error message:
su -l git -c “cd /usr/local/www/gitlab && rake db:migrate RAILS_ENV=production”
The PGconn, PGresult, and PGError constants are deprecated, and will be
removed as of version 1.0.
You should use PG::Connection, PG::Result, and PG::Error instead, respectively.
Called from /usr/local/lib/ruby/gems/2.3/gems/activesupport-4.2.9/lib/active_support/dependencies.rb:240:in `load_dependency'
[DEPRECATION] 'Rack::Attack.blacklist' is deprecated. Please use 'blocklist' instead.
== 20170327091750 AddCreatedAtIndexToDeployments: migrating ===================
-- transaction_open?()
-> 0.0000s
-- execute("SET statement_timeout TO 0")
-> 0.0003s
-- add_index(:deployments, :created_at, {:algorithm=>:concurrently})
rake aborted!
StandardError: An error has occurred, all later migrations canceled:
Index name 'index_deployments_on_created_at' on table 'deployments' already exists
/usr/local/www/gitlab/config/initializers/postgresql_opclasses_support.rb:80:in `add_index_options'
/usr/local/www/gitlab/config/initializers/postgresql_opclasses_support.rb:141:in `add_index'
/usr/local/www/gitlab/lib/gitlab/database/migration_helpers.rb:26:in `add_concurrent_index'
/usr/local/www/gitlab/db/migrate/20170327091750_add_created_at_index_to_deployments.rb:9:in `up'
ArgumentError: Index name 'index_deployments_on_created_at' on table 'deployments' already exists
/usr/local/www/gitlab/config/initializers/postgresql_opclasses_support.rb:80:in `add_index_options'
/usr/local/www/gitlab/config/initializers/postgresql_opclasses_support.rb:141:in `add_index'
/usr/local/www/gitlab/lib/gitlab/database/migration_helpers.rb:26:in `add_concurrent_index'
/usr/local/www/gitlab/db/migrate/20170327091750_add_created_at_index_to_deployments.rb:9:in `up'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
I even cannot restore the backup, as it was done with the old version, which I cannot install anymore.
I’m now in a completely broken state and have no idea how to fix this.
Could anyone please help me out here?
Thanks a lot
Matthias