{"action":"closed","issue":{"url":"https://api.github.com/repos/OCA/OpenUpgrade/issues/1641","repository_url":"https://api.github.com/repos/OCA/OpenUpgrade","labels_url":"https://api.github.com/repos/OCA/OpenUpgrade/issues/1641/labels{/name}","comments_url":"https://api.github.com/repos/OCA/OpenUpgrade/issues/1641/comments","events_url":"https://api.github.com/repos/OCA/OpenUpgrade/issues/1641/events","html_url":"https://github.com/OCA/OpenUpgrade/issues/1641","id":386465684,"node_id":"MDU6SXNzdWUzODY0NjU2ODQ=","number":1641,"title":"[9.0] account_account_parent_id_fkey contraint not delete","user":{"login":"stephanesalah","id":8567045,"node_id":"MDQ6VXNlcjg1NjcwNDU=","avatar_url":"https://avatars3.githubusercontent.com/u/8567045?v=4","gravatar_id":"","url":"https://api.github.com/users/stephanesalah","html_url":"https://github.com/stephanesalah","followers_url":"https://api.github.com/users/stephanesalah/followers","following_url":"https://api.github.com/users/stephanesalah/following{/other_user}","gists_url":"https://api.github.com/users/stephanesalah/gists{/gist_id}","starred_url":"https://api.github.com/users/stephanesalah/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stephanesalah/subscriptions","organizations_url":"https://api.github.com/users/stephanesalah/orgs","repos_url":"https://api.github.com/users/stephanesalah/repos","events_url":"https://api.github.com/users/stephanesalah/events{/privacy}","received_events_url":"https://api.github.com/users/stephanesalah/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/OCA/OpenUpgrade/milestones/6","html_url":"https://github.com/OCA/OpenUpgrade/milestone/6","labels_url":"https://api.github.com/repos/OCA/OpenUpgrade/milestones/6/labels","id":1314129,"node_id":"MDk6TWlsZXN0b25lMTMxNDEyOQ==","number":6,"title":"9.0","description":"","creator":{"login":"max3903","id":939952,"node_id":"MDQ6VXNlcjkzOTk1Mg==","avatar_url":"https://avatars3.githubusercontent.com/u/939952?v=4","gravatar_id":"","url":"https://api.github.com/users/max3903","html_url":"https://github.com/max3903","followers_url":"https://api.github.com/users/max3903/followers","following_url":"https://api.github.com/users/max3903/following{/other_user}","gists_url":"https://api.github.com/users/max3903/gists{/gist_id}","starred_url":"https://api.github.com/users/max3903/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/max3903/subscriptions","organizations_url":"https://api.github.com/users/max3903/orgs","repos_url":"https://api.github.com/users/max3903/repos","events_url":"https://api.github.com/users/max3903/events{/privacy}","received_events_url":"https://api.github.com/users/max3903/received_events","type":"User","site_admin":false},"open_issues":5,"closed_issues":215,"state":"open","created_at":"2015-09-18T21:46:44Z","updated_at":"2018-12-03T08:41:59Z","due_on":null,"closed_at":null},"comments":3,"created_at":"2018-12-01T15:00:50Z","updated_at":"2018-12-03T08:41:59Z","closed_at":"2018-12-03T08:41:59Z","author_association":"NONE","body":"Impacted versions:\r\nMigration fro 8.0 to 9.0\r\n\r\nSteps to reproduce:\r\nLaunch a migration of a 8.0 database.\r\n\r\nCurrent behavior:\r\nmigration log:\r\n```\r\n2018-12-01 14:46:24,916 15390 DEBUG prescom_mig_migrated OpenUpgrade: Running \r\n        ALTER TABLE account_account\r\n        DROP CONSTRAINT account_account_parent_id_fkey\r\n2018-12-01 14:46:24,917 15390 DEBUG prescom_mig_migrated OpenUpgrade: -1 rows affected\r\npostgres log:\r\n2018-12-01 15:24:51 CET [14704-19] stsal@prescom_mig_migrated ERROR:  constraint \"account_account_parent_id_fkey\" of relation \"account_account\" does not exist\r\n2018-12-01 15:24:51 CET [14704-20] stsal@prescom_mig_migrated STATEMENT:  \r\n                ALTER TABLE account_account\r\n                DROP CONSTRAINT account_account_parent_id_fkey\r\ncontrol on postgresql console:\r\nTABLE \"account_account\" CONSTRAINT \"account_account_parent_id_fkey\" FOREIGN KEY (parent_id) REFERENCES account_account(id) ON DELETE CASCADE\r\n```\r\nExpected behavior:\r\nthis constraint should be delete to permit 'view' type account unlink.\r\nIf i'm go on postgres console with the same user and execute 'ALTER TABLE ....' the request is ok.\r\n\r\nI can not explain chat the matter\r\n\r\nthanks for your help.\r\n\r\nStéphane"}}
{"actor":{"display_login":"pedrobaeza"}}