{"action":"opened","issue":{"url":"https://api.github.com/repos/openSUSE/open-build-service/issues/2949","repository_url":"https://api.github.com/repos/openSUSE/open-build-service","labels_url":"https://api.github.com/repos/openSUSE/open-build-service/issues/2949/labels{/name}","comments_url":"https://api.github.com/repos/openSUSE/open-build-service/issues/2949/comments","events_url":"https://api.github.com/repos/openSUSE/open-build-service/issues/2949/events","html_url":"https://github.com/openSUSE/open-build-service/issues/2949","id":220455974,"number":2949,"title":"updating from 2.7.4 to 2.8.1 fails during db:migrate","user":{"login":"jsjhb","id":6535620,"avatar_url":"https://avatars3.githubusercontent.com/u/6535620?v=3","gravatar_id":"","url":"https://api.github.com/users/jsjhb","html_url":"https://github.com/jsjhb","followers_url":"https://api.github.com/users/jsjhb/followers","following_url":"https://api.github.com/users/jsjhb/following{/other_user}","gists_url":"https://api.github.com/users/jsjhb/gists{/gist_id}","starred_url":"https://api.github.com/users/jsjhb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jsjhb/subscriptions","organizations_url":"https://api.github.com/users/jsjhb/orgs","repos_url":"https://api.github.com/users/jsjhb/repos","events_url":"https://api.github.com/users/jsjhb/events{/privacy}","received_events_url":"https://api.github.com/users/jsjhb/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-04-09T08:14:35Z","updated_at":"2017-04-09T08:14:35Z","closed_at":null,"body":"Issue/Feature description\r\n====================\r\nMachine is an old installation updates in steps over the years from 2.1.\r\nUntil today it was a 2.6 on openSUSE 13.2, I made an update to obs 2.7, still on 13.2.\r\nAfter that update to openSUSE Leap 42.1, still with 2.7.4.\r\nUpdate to obs 2.8.1, following README.UPDATERS:\r\n\r\nRAILS_ENV=\"production\" rails.ruby2.4 db:migrate\r\n----\r\n/usr/lib64/ruby/gems/2.4.0/gems/activesupport-5.0.1/lib/active_support/xml_mini.rb:51: warning: constant ::Fixnum is deprecated\r\n/usr/lib64/ruby/gems/2.4.0/gems/activesupport-5.0.1/lib/active_support/xml_mini.rb:52: warning: constant ::Bignum is deprecated\r\n/usr/lib64/ruby/gems/2.4.0/gems/activejob-5.0.1/lib/active_job/arguments.rb:38: warning: constant ::Fixnum is deprecated\r\n/usr/lib64/ruby/gems/2.4.0/gems/activejob-5.0.1/lib/active_job/arguments.rb:38: warning: constant ::Bignum is deprecated\r\n/usr/lib64/ruby/gems/2.4.0/gems/activesupport-5.0.1/lib/active_support/core_ext/numeric/conversions.rb:138: warning: constant ::Fixnum is deprecated\r\n== 20170123115500 RemoveDuplicateIndexes: migrating ===========================\r\n-- execute(\"ALTER TABLE `attrib_namespace_modifiable_bies` DROP INDEX `index_attrib_namespace_modifiable_bies_on_attrib_namespace_id`;\")\r\n   -> 0.0252s\r\n-- execute(\"ALTER TABLE `attrib_types` DROP INDEX `attrib_namespace_id`;\")\r\nrails aborted!\r\nStandardError: An error has occurred, all later migrations canceled:\r\n\r\nMysql2::Error: Can't DROP 'attrib_namespace_id'; check that column/key exists: ALTER TABLE `attrib_types` DROP INDEX `attrib_namespace_id`;\r\n/srv/www/obs/api/db/migrate/20170123115500_remove_duplicate_indexes.rb:32:in `up'\r\nbin/rails:4:in `require'\r\nbin/rails:4:in `<main>'\r\nActiveRecord::StatementInvalid: Mysql2::Error: Can't DROP 'attrib_namespace_id'; check that column/key exists: ALTER TABLE `attrib_types` DROP INDEX `attrib_namespace_id`;\r\n/srv/www/obs/api/db/migrate/20170123115500_remove_duplicate_indexes.rb:32:in `up'\r\nbin/rails:4:in `require'\r\nbin/rails:4:in `<main>'\r\nMysql2::Error: Can't DROP 'attrib_namespace_id'; check that column/key exists\r\n/srv/www/obs/api/db/migrate/20170123115500_remove_duplicate_indexes.rb:32:in `up'\r\nbin/rails:4:in `require'\r\nbin/rails:4:in `<main>'\r\nTasks: TOP => db:migrate\r\n(See full trace by running task with --trace)\r\n----\r\nThe index in 20170123115500 is not in the database, thus the migration fails.\r\n\r\nExpected result\r\n============\r\nit's obvious ;-)\r\n\r\nHow to Reproduce\r\n===============\r\ndunno, but probably take a 2.7.4 on 42.1, and migrate to 2.8.1\r\nIf this is ok, then follow:\r\nopenSUSE 13.2 -> obs 2.6.x\r\nmigrate to 2.7.4\r\nupdate to openSUSE Leap 42.1\r\nmigrate to 2.8.1\r\n\r\n\r\nFurther information\r\n===============\r\n* A link to an OBS instance showing the issue\r\nhttps://buildhost.jacobs-university.de - if access needed, please contact me\r\nprobably pmbs.links2linux.de is affected too, my buildhost would have been the test case for PMBS\r\n* Exact server version (in case a private instance is used)\r\n2.7.4->2.8.1"}}
{"actor":{"display_login":"jsjhb"}}