Bug #2068917 “DB Sync fails while upgrading from 2023.2 to 2024....” : Bugs : masakari

<!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr"> <head> <base href="https://bugs.launchpad.net/masakari/+bug/2068917/+index" /> <meta charset="UTF-8" /> <title>Bug #2068917 “DB Sync fails while upgrading from 2023.2 to 2024....” : Bugs : masakari</title> <link rel="apple-touch-icon" sizes="180x180" href="/@@/apple-touch-icon.png?v=2022" /> <link rel="icon" type="image/png" sizes="32x32" href="/@@/favicon-32x32.png?v=2022" /> <link rel="icon" type="image/png" sizes="16x16" href="/@@/favicon-16x16.png?v=2022" /> <link rel="manifest" href="/@@/site.webmanifest?v=2022" /> <link rel="mask-icon" href="/@@/safari-pinned-tab.svg?v=2022" color="#e9531f" /> <link rel="shortcut icon" href="/@@/favicon.ico?v=2022" /> <meta name="msapplication-TileColor" content="#da532c" /> <meta name="msapplication-config" content="/@@/browserconfig.xml?v=2022" /> <meta name="theme-color" content="#ffffff" /> <link rel="canonical" href="https://bugs.launchpad.net/bugs/2068917" /> <link rel="alternate" type="application/atom+xml" href="http://feeds.launchpad.net/bugs/2068917/bug.atom" title="Bug 2068917 Feed" /> <link type="text/css" rel="stylesheet" media="screen, print" href="/+icing/revaa29ae0fff49e4e804b39147c9f259d2fb023199/combo.css" /> <meta name="description" content="We're using kolla and kolla-ansible to deploy our environment. While upgrading from 2023.2 to 2024.1 we observed that the upgrade fails because the bootstrap container of Masakari is failing. The bootstrap container of kolla-ansible is calling 'masakari-manage db sync' without further arguments. 2024-03-13 17:06:58.827 31 INFO migrate.versioning.api [-] 0 -> 1... 2024-03-13 17:06:58.841 31 INFO migrate.versioning.api [-] done 2024-03-13 17:06:58.841 31 INFO migrate.versioning.api [-] 1 ->..." /> <meta property="og:description" content="We're using kolla and kolla-ansible to deploy our environment. While upgrading from 2023.2 to 2024.1 we observed that the upgrade fails because the bootstrap container of Masakari is failing. The bootstrap container of kolla-ansible is calling 'masakari-manage db sync' without further arguments. 2024-03-13 17:06:58.827 31 INFO migrate.versioning.api [-] 0 -> 1... 2024-03-13 17:06:58.841 31 INFO migrate.versioning.api [-] done 2024-03-13 17:06:58.841 31 INFO migrate.versioning.api [-] 1 ->..." /> <meta property="og:title" content="Bug #2068917 “DB Sync fails while upgrading from 2023.2 to 2024....” : Bugs : masakari" /> <meta property="og:type" content="website" /> <meta property="og:image" content="/@@/launchpad-og-image.png" /> <meta property="og:url" content="https://bugs.launchpad.net/bugs/2068917" /> <meta property="og:site_name" content="Launchpad" /> <script type="text/javascript"> var LP = { cache: {}, links: {} }; </script> <script type="text/javascript">var cookie_scope = '; Path=/; Secure; Domain=.launchpad.net';</script> <script type="text/javascript" src="/+combo/revaa29ae0fff49e4e804b39147c9f259d2fb023199/?yui/yui/yui-min.js&lp/meta.js&yui/loader/loader-min.js"></script> <script type="text/javascript"> var raw = null; if (LP.devmode) { raw = 'raw'; } YUI.GlobalConfig = { combine: true, comboBase: '/+combo/revaa29ae0fff49e4e804b39147c9f259d2fb023199/?', root: 'yui/', filter: raw, debug: false, fetchCSS: false, maxURLLength: 2000, groups: { lp: { combine: true, base: '/+combo/revaa29ae0fff49e4e804b39147c9f259d2fb023199/?lp/', comboBase: '/+combo/revaa29ae0fff49e4e804b39147c9f259d2fb023199/?', root: 'lp/', // comes from including lp/meta.js modules: LP_MODULES, fetchCSS: false } } }</script> <script type="text/javascript"> // we need this to create a single YUI instance all events and code // talks across. All instances of YUI().use should be based off of // LPJS instead. var LPJS = new YUI(); </script> <script id="base-layout-load-scripts" type="text/javascript"> //<![CDATA[ LPJS.use('base', 'node', 'console', 'event', 'oop', 'lp', 'lp.app.foldables','lp.app.sorttable', 'lp.app.inlinehelp', 'lp.app.links', 'lp.bugs.bugtask_index', 'lp.bugs.subscribers', 'lp.app.ellipsis', 'lp.code.branchmergeproposal.diff', 'lp.views.global', function(Y) { Y.on("domready", function () { var global_view = new Y.lp.views.Global(); global_view.render(); Y.lp.app.sorttable.SortTable.init(); Y.lp.app.inlinehelp.init_help(); Y.lp.activate_collapsibles(); Y.lp.app.foldables.activate(); Y.lp.app.links.check_valid_lp_links(); }); Y.on('lp:context:web_link:changed', function(e) { window.location = e.new_value; }); }); //]]> </script> <script id="base-helper-functions" type="text/javascript"> //<![CDATA[ // This code is pulled from lp.js that needs to be available on every // request. Pulling here to get it outside the scope of the YUI block. function setFocusByName(name) { // Focus the first element matching the given name which can be focused. var nodes = document.getElementsByName(name); var i, node; for (i = 0; i < nodes.length; i++) { node = nodes[i]; if (node.focus) { try { // Trying to focus a hidden element throws an error in IE8. if (node.offsetHeight !== 0) { node.focus(); } } catch (e) { LPJS.use('console', function(Y) { Y.log('In setFocusByName(<' + node.tagName + ' type=' + node.type + '>): ' + e); }); } break; } } } function selectWidget(widget_name, event) { if (event && (event.keyCode === 9 || event.keyCode === 13)) { // Avoid firing if user is tabbing through or simply pressing // enter to submit the form. return; } document.getElementById(widget_name).checked = true; } //]]> </script> <script type="text/javascript" id="available-official-tags-js">var available_official_tags = [];</script> <script type="text/javascript"> LPJS.use('base', 'node', 'oop', 'event', 'lp.bugs.bugtask_index', 'lp.bugs.subscribers', 'lp.code.branchmergeproposal.diff', 'lp.app.comment', 'lp.services.messages.edit', function(Y) { Y.on('domready', function() { Y.lp.code.branchmergeproposal.diff.connect_diff_links(); Y.lp.bugs.bugtask_index.setup_bugtask_index(); Y.lp.bugs.bugtask_index.setup_bugtask_table(); LP.cache.comment_context = LP.cache.bug; var cl = new Y.lp.app.comment.CommentList(); cl.render(); var sl = new Y.lp.bugs.subscribers.createBugSubscribersLoader({ container_box: '#other-bug-subscribers', subscribers_details_view: '/+bug-portlet-subscribers-details', subscribe_someone_else_link: '.menu-link-addsubscriber' }, window); Y.lp.services.messages.edit.setup(); }); }); </script> <style type="text/css"> /* Align the 'add comment' link to the right of the comment box. */ #add-comment-form textarea { width: 100%; } #add-comment-form { max-width: 60em; padding-bottom: 4em; } #add-comment-form .actions {float: right;} .buglink-summary dd { font-size: 10px; } a#privacy-link:link:hover, a#privacy-link:visited:hover {text-decoration:none;} </style> <style type="text/css"> .yui3-overlay .value label { /* It normally makes sense for form labels to be bold, but since this form consists only of radio buttons, there's nothing but labels so we just get wall-to-wall bold. */ font-weight: normal !important; } </style> </head> <body id="document" itemscope="" itemtype="http://schema.org/WebPage" class="tab-bugs main_side public yui3-skin-sam"> <div class="yui-d0"> <div id="locationbar" class="login-logout"> <div id="logincontrol"><a href="https://bugs.launchpad.net/masakari/+bug/2068917/+login">Log in / Register</a></div> </div> <div id="watermark" class="watermark-apps-portlet"> <div> <a href="https://launchpad.net/masakari"><img alt="" width="64" height="64" src="/@@/product-logo" /></a> </div> <div class="wide"> <h2 id="watermark-heading"><a href="https://launchpad.net/masakari">masakari</a></h2> </div>  <ul class="facetmenu"> <li class="overview"><a href="https://launchpad.net/masakari">Overview</a></li> <li class="branches"><a href="https://code.launchpad.net/masakari">Code</a></li> <li class="bugs active"><a href="https://bugs.launchpad.net/masakari">Bugs</a></li> <li class="specifications"><a href="https://blueprints.launchpad.net/masakari">Blueprints</a></li> <li class="translations"><a href="https://translations.launchpad.net/masakari">Translations</a></li> <li class="answers"><a href="https://answers.launchpad.net/masakari">Answers</a></li> </ul> </div> <div class="yui-t4"> <div id="maincontent" class="yui-main"> <div class="yui-b" dir="ltr"> <div class="context-publication"> <h1 id="edit-title"> <span class="yui3-editable_text-text ellipsis" style="max-width: 95%;"> DB Sync fails while upgrading from 2023.2 to 2024.1 </span> </h1> <div id="registration" class="registering"> Bug #2068917 reported by <a href="https://launchpad.net/~msnatepg" class="sprite person">Maximilian Sesterhenn</a> <time title="2024-06-10 15:38:54 UTC" datetime="2024-06-10T15:38:54.447640+00:00">on 2024-06-10</time> </div> </div> <div id="request-notifications"> </div> <div> <div id="bug-is-duplicate"> </div> <div style="float: right;"> <span><a href="/+help-bugs/bug-heat.html" target="help" class="sprite flame">18</a></span> </div> <div class="actions"> <span id="affectsmetoo" style="display: inline">This bug affects 4 people</span> </div> <table id="affected-software" class="listing"> <thead> <tr> <th colspan="2">Affects</th> <th>Status</th> <th>Importance</th> <th>Assigned to</th> <th>Milestone</th> </tr> </thead> <tbody> <tr class="highlight" id="tasksummary3208668"> <td> </td> <td> <span id="bugtarget-picker-tasksummary3208668"> <span class="yui3-activator-data-box"> <a class="sprite product" href="https://bugs.launchpad.net/masakari">masakari</a> </span> <div class="yui3-activator-message-box yui3-activator-hidden"></div> </span> </td> <td style="width: 20%; vertical-align: middle"> <div class="status-content" style="width: 100%; float: left"> <span style="float: left" class="value statusNEW">New</span> </div> </td> <td style="width: 15em; vertical-align: middle"> <div class="importance-content" style="width: 100%; float: left"> <span style="float: left" class="value importanceUNDECIDED">Undecided</span> </div> </td> <td style="width:20%; margin: 0; padding: 0; vertical-align: middle; padding-left: 0.5em"> <span id="assignee-picker-tasksummary3208668"> <span class="yui3-activator-data-box"> Unassigned </span> <div class="yui3-activator-message-box yui3-activator-hidden"></div> </span> </td> <td style="width: 20%; vertical-align: middle"> </td> </tr> </tbody> </table> <div id="maincontentsub"> <div class="top-portlet"> <div itemprop="mainContentOfPage" class="report"> <div> <div class="lazr-multiline-edit" id="edit-description"> <div class="clearfix"> <h3>Bug Description</h3> </div> <div class="yui3-editable_text-text"><p>We're using kolla and kolla-ansible to deploy our environment.</p> <p>While upgrading from 2023.2 to 2024.1 we observed that the upgrade fails because the bootstrap container of Masakari is failing.</p> <p>The bootstrap container of kolla-ansible is calling 'masakari-manage db sync' without further arguments.</p> <p>2024-03-13 17:06:58.827 31 INFO migrate.<wbr />versioning.<wbr />api [-] 0 -> 1...<br /> 2024-03-13 17:06:58.841 31 INFO migrate.<wbr />versioning.<wbr />api [-] done<br /> 2024-03-13 17:06:58.841 31 INFO migrate.<wbr />versioning.<wbr />api [-] 1 -> 2...<br /> 2024-03-13 17:06:58.858 31 INFO migrate.<wbr />versioning.<wbr />api [-] done<br /> 2024-03-13 17:06:58.859 31 INFO migrate.<wbr />versioning.<wbr />api [-] 2 -> 3...<br /> 2024-03-13 17:06:58.888 31 INFO migrate.<wbr />versioning.<wbr />api [-] done<br /> 2024-03-13 17:06:58.888 31 INFO migrate.<wbr />versioning.<wbr />api [-] 3 -> 4...<br /> 2024-03-13 17:06:58.899 31 INFO migrate.<wbr />versioning.<wbr />api [-] done<br /> 2024-03-13 17:06:58.899 31 INFO migrate.<wbr />versioning.<wbr />api [-] 4 -> 5...<br /> 2024-03-13 17:06:58.922 31 INFO migrate.<wbr />versioning.<wbr />api [-] done<br /> 2024-03-13 17:06:58.922 31 INFO migrate.<wbr />versioning.<wbr />api [-] 5 -> 6...<br /> 2024-03-13 17:06:58.923 31 INFO masakari.<wbr />engine.<wbr />driver [-] Loading masakari notification driver 'taskflow_driver'<br /> 2024-03-13 17:06:59.213 31 INFO alembic.<wbr />runtime.<wbr />migration [-] Context impl MySQLImpl.<br /> 2024-03-13 17:06:59.213 31 INFO alembic.<wbr />runtime.<wbr />migration [-] Will assume non-transactional DDL.<br /> 2024-03-13 17:06:59.222 31 INFO alembic.<wbr />runtime.<wbr />migration [-] Running upgrade -> 1cea328f0f65, initial_<wbr />logbook_<wbr />details_<wbr />tables<br /> 2024-03-13 17:06:59.254 31 INFO alembic.<wbr />runtime.<wbr />migration [-] Running upgrade 1cea328f0f65 -> 1c783c0c2875, Replace exception and stacktrace with failure column<br /> 2024-03-13 17:06:59.265 31 INFO alembic.<wbr />runtime.<wbr />migration [-] Running upgrade 1c783c0c2875 -> 84d6e888850, Add task detail type<br /> 2024-03-13 17:06:59.270 31 INFO alembic.<wbr />runtime.<wbr />migration [-] Running upgrade 84d6e888850 -> 14b227d79a87<br /> 2024-03-13 17:06:59.276 31 INFO alembic.<wbr />runtime.<wbr />migration [-] Running upgrade 14b227d79a87 -> 589dccdf2b6e, Rename taskdetails to atomdetails<br /> 2024-03-13 17:06:59.281 31 INFO alembic.<wbr />runtime.<wbr />migration [-] Running upgrade 589dccdf2b6e -> 3162c0f3f8e4, Add 'revert_results' and 'revert_failure' atom detail column.<br /> 2024-03-13 17:06:59.290 31 INFO alembic.<wbr />runtime.<wbr />migration [-] Running upgrade 3162c0f3f8e4 -> 2ad4984f2864, Switch postgres to json native type.<br /> 2024-03-13 17:06:59.292 31 INFO alembic.<wbr />runtime.<wbr />migration [-] Running upgrade 2ad4984f2864 -> 0bc3e1a3c135, set_result_<wbr />meduimtext_<wbr />type<br /> 2024-03-13 17:06:59.299 31 INFO alembic.<wbr />runtime.<wbr />migration [-] Running upgrade 0bc3e1a3c135 -> 6df9422fcb43, fix flowdetails meta size<br /> 2024-03-13 17:06:59.306 31 INFO alembic.<wbr />runtime.<wbr />migration [-] Running upgrade 6df9422fcb43 -> 40fc8c914bd2, fix atomdetails failure size<br /> 2024-03-13 17:06:59.323 31 INFO migrate.<wbr />versioning.<wbr />api [-] done<br /> 2024-03-13 17:06:59.323 31 INFO migrate.<wbr />versioning.<wbr />api [-] 6 -> 7...<br /> 2024-03-13 17:06:59.340 31 INFO migrate.<wbr />versioning.<wbr />api [-] done<br /> 2024-03-13 17:06:59.340 31 INFO migrate.<wbr />versioning.<wbr />api [-] 7 -> 8...<br /> 2024-03-13 17:06:59.351 31 INFO migrate.<wbr />versioning.<wbr />api [-] done<br /> 2024-06-10 16:54:44.364 30 INFO masakari.<wbr />db.sqlalchemy.<wbr />migration [-] Applying migration(s)<br /> 2024-06-10 16:54:44.372 30 INFO alembic.<wbr />runtime.<wbr />migration [-] Context impl MySQLImpl.<br /> 2024-06-10 16:54:44.372 30 INFO alembic.<wbr />runtime.<wbr />migration [-] Will assume non-transactional DDL.<br /> 2024-06-10 16:54:44.375 30 INFO alembic.<wbr />runtime.<wbr />migration [-] Context impl MySQLImpl.<br /> 2024-06-10 16:54:44.375 30 INFO alembic.<wbr />runtime.<wbr />migration [-] Will assume non-transactional DDL.<br /> 2024-06-10 16:54:44.381 30 INFO alembic.<wbr />runtime.<wbr />migration [-] Running upgrade -> 8f848eb45d03, Initial revision<br /> 2024-06-10 16:54:44.385 30 CRITICAL masakari [-] Unhandled error: sqlalchemy.<wbr />exc.Operational<wbr />Error: (pymysql.<wbr />err.Operational<wbr />Error) (1050, "Table 'failover_segments' already exists")<br /> [SQL:<br /> CREATE TABLE failover_segments (<br />         created_at DATETIME,<br />         updated_at DATETIME,<br />         deleted_at DATETIME,<br />         deleted INTEGER,<br />         id INTEGER NOT NULL AUTO_INCREMENT,<br />         uuid VARCHAR(36) NOT NULL,<br />         name VARCHAR(255) NOT NULL,<br />        <wbr /> service_<wbr />type VARCHAR(255) NOT NULL,<br />         description TEXT,<br />        <wbr /> recovery_<wbr />method ENUM('auto'<wbr />,'reserved_<wbr />host','<wbr />auto_priority'<wbr />,'rh_priority'<wbr />) NOT NULL,<br />         enabled BOOL,<br />         PRIMARY KEY (id),<br />         CONSTRAINT uniq_segment0na<wbr />me0deleted UNIQUE (name, deleted),<br />         CONSTRAINT uniq_segments0uuid UNIQUE (uuid)<br /> )</p> <p>]<br /> (Background on this error at: <a rel="nofollow" href="https://sqlalche.me/e/14/e3q8">https:/<wbr />/sqlalche.<wbr />me/e/14/<wbr />e3q8</a>)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari Traceback (most recent call last):<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />sqlalchemy/<wbr />engine/<wbr />base.py"<wbr />, line 1910, in _execute_context<br /> 2024-06-10 16:54:44.385 30 ERROR masakari self.dialect.<wbr />do_execute(<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />sqlalchemy/<wbr />engine/<wbr />default.<wbr />py", line 736, in do_execute<br /> 2024-06-10 16:54:44.385 30 ERROR masakari cursor.<wbr />execute(<wbr />statement, parameters)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />pymysql/<wbr />cursors.<wbr />py", line 153, in execute<br /> 2024-06-10 16:54:44.385 30 ERROR masakari result = self._query(query)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />pymysql/<wbr />cursors.<wbr />py", line 322, in _query<br /> 2024-06-10 16:54:44.385 30 ERROR masakari conn.query(q)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />pymysql/<wbr />connections.<wbr />py", line 558, in query<br /> 2024-06-10 16:54:44.385 30 ERROR masakari self._affected_rows = self._read_<wbr />query_result(<wbr />unbuffered=<wbr />unbuffered)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />pymysql/<wbr />connections.<wbr />py", line 822, in _read_query_result<br /> 2024-06-10 16:54:44.385 30 ERROR masakari result.read()<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />pymysql/<wbr />connections.<wbr />py", line 1200, in read<br /> 2024-06-10 16:54:44.385 30 ERROR masakari first_packet = self.connection<wbr />._read_<wbr />packet(<wbr />)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />pymysql/<wbr />connections.<wbr />py", line 772, in _read_packet<br /> 2024-06-10 16:54:44.385 30 ERROR masakari packet.<wbr />raise_for_<wbr />error()<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />pymysql/<wbr />protocol.<wbr />py", line 221, in raise_for_error<br /> 2024-06-10 16:54:44.385 30 ERROR masakari err.raise_<wbr />mysql_exception<wbr />(self._<wbr />data)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />pymysql/<wbr />err.py"<wbr />, line 143, in raise_mysql_<wbr />exception<br /> 2024-06-10 16:54:44.385 30 ERROR masakari raise errorclass(errno, errval)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari pymysql.<wbr />err.Operational<wbr />Error: (1050, "Table 'failover_segments' already exists")<br /> 2024-06-10 16:54:44.385 30 ERROR masakari<br /> 2024-06-10 16:54:44.385 30 ERROR masakari The above exception was the direct cause of the following exception:<br /> 2024-06-10 16:54:44.385 30 ERROR masakari<br /> 2024-06-10 16:54:44.385 30 ERROR masakari Traceback (most recent call last):<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />bin/masakari-<wbr />manage"<wbr />, line 8, in <module><br /> 2024-06-10 16:54:44.385 30 ERROR masakari sys.exit(main())<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />masakari/<wbr />cmd/manage.<wbr />py", line 207, in main<br /> 2024-06-10 16:54:44.385 30 ERROR masakari fn(*fn_args)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />masakari/<wbr />cmd/manage.<wbr />py", line 70, in sync<br /> 2024-06-10 16:54:44.385 30 ERROR masakari return db_migration.<wbr />db_sync(<wbr />version)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />masakari/<wbr />db/sqlalchemy/<wbr />migration.<wbr />py", line 163, in db_sync<br /> 2024-06-10 16:54:44.385 30 ERROR masakari _upgrade_<wbr />alembic(<wbr />engine, config, version)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />masakari/<wbr />db/sqlalchemy/<wbr />migration.<wbr />py", line 130, in _upgrade_alembic<br /> 2024-06-10 16:54:44.385 30 ERROR masakari alembic_<wbr />api.upgrade(<wbr />config, version or 'head')<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />alembic/<wbr />command.<wbr />py", line 378, in upgrade<br /> 2024-06-10 16:54:44.385 30 ERROR masakari script.run_env()<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />alembic/<wbr />script/<wbr />base.py"<wbr />, line 569, in run_env<br /> 2024-06-10 16:54:44.385 30 ERROR masakari util.load_<wbr />python_<wbr />file(self.<wbr />dir, "env.py")<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />alembic/<wbr />util/pyfiles.<wbr />py", line 94, in load_python_file<br /> 2024-06-10 16:54:44.385 30 ERROR masakari module = load_module_<wbr />py(module_<wbr />id, path)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />alembic/<wbr />util/pyfiles.<wbr />py", line 110, in load_module_py<br /> 2024-06-10 16:54:44.385 30 ERROR masakari spec.loader.<wbr />exec_module(<wbr />module) # type: ignore<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "<frozen importlib.<wbr />_bootstrap_<wbr />external><wbr />", line 850, in exec_module<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "<frozen importlib.<wbr />_bootstrap><wbr />", line 228, in _call_with_<wbr />frames_<wbr />removed<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />masakari/<wbr />db/sqlalchemy/<wbr />migrations/<wbr />env.py"<wbr />, line 109, in <module><br /> 2024-06-10 16:54:44.385 30 ERROR masakari run_migrations_<wbr />online(<wbr />)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />masakari/<wbr />db/sqlalchemy/<wbr />migrations/<wbr />env.py"<wbr />, line 103, in run_migrations_<wbr />online<br /> 2024-06-10 16:54:44.385 30 ERROR masakari context.<wbr />run_migrations(<wbr />)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "<string>", line 8, in run_migrations<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />alembic/<wbr />runtime/<wbr />environment.<wbr />py", line 867, in run_migrations<br /> 2024-06-10 16:54:44.385 30 ERROR masakari self.get_<wbr />context(<wbr />).run_migration<wbr />s(**kw)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />alembic/<wbr />runtime/<wbr />migration.<wbr />py", line 624, in run_migrations<br /> 2024-06-10 16:54:44.385 30 ERROR masakari step.migration_<wbr />fn(**kw)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />masakari/<wbr />db/sqlalchemy/<wbr />migrations/<wbr />versions/<wbr />8f848eb45d03_<wbr />initial_<wbr />revision.<wbr />py", line 32, in upgrade<br /> 2024-06-10 16:54:44.385 30 ERROR masakari op.create_table(<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "<string>", line 8, in create_table<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "<string>", line 3, in create_table<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />alembic/<wbr />operations/<wbr />ops.py"<wbr />, line 1260, in create_table<br /> 2024-06-10 16:54:44.385 30 ERROR masakari return operations.<wbr />invoke(<wbr />op)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />alembic/<wbr />operations/<wbr />base.py"<wbr />, line 401, in invoke<br /> 2024-06-10 16:54:44.385 30 ERROR masakari return fn(self, operation)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />alembic/<wbr />operations/<wbr />toimpl.<wbr />py", line 114, in create_table<br /> 2024-06-10 16:54:44.385 30 ERROR masakari operations.<wbr />impl.create_<wbr />table(table)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />alembic/<wbr />ddl/impl.<wbr />py", line 354, in create_table<br /> 2024-06-10 16:54:44.385 30 ERROR masakari self._exec(<wbr />schema.<wbr />CreateTable(<wbr />table))<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />alembic/<wbr />ddl/impl.<wbr />py", line 193, in _exec<br /> 2024-06-10 16:54:44.385 30 ERROR masakari return conn.execute( # type: ignore[<wbr />call-overload]<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />sqlalchemy/<wbr />engine/<wbr />base.py"<wbr />, line 1385, in execute<br /> 2024-06-10 16:54:44.385 30 ERROR masakari return meth(self, multiparams, params, _EMPTY_<wbr />EXECUTION_<wbr />OPTS)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />sqlalchemy/<wbr />sql/ddl.<wbr />py", line 80, in _execute_<wbr />on_connection<br /> 2024-06-10 16:54:44.385 30 ERROR masakari return connection.<wbr />_execute_<wbr />ddl(<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />sqlalchemy/<wbr />engine/<wbr />base.py"<wbr />, line 1477, in _execute_ddl<br /> 2024-06-10 16:54:44.385 30 ERROR masakari ret = self._execute_<wbr />context(<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />sqlalchemy/<wbr />engine/<wbr />base.py"<wbr />, line 1953, in _execute_context<br /> 2024-06-10 16:54:44.385 30 ERROR masakari self._handle_<wbr />dbapi_exception<wbr />(<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />sqlalchemy/<wbr />engine/<wbr />base.py"<wbr />, line 2132, in _handle_<wbr />dbapi_exception<br /> 2024-06-10 16:54:44.385 30 ERROR masakari util.raise_<wbr />(newraise, with_traceback=<wbr />exc_info[<wbr />2], from_=e)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />sqlalchemy/<wbr />util/compat.<wbr />py", line 211, in raise_<br /> 2024-06-10 16:54:44.385 30 ERROR masakari raise exception<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />sqlalchemy/<wbr />engine/<wbr />base.py"<wbr />, line 1910, in _execute_context<br /> 2024-06-10 16:54:44.385 30 ERROR masakari self.dialect.<wbr />do_execute(<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />sqlalchemy/<wbr />engine/<wbr />default.<wbr />py", line 736, in do_execute<br /> 2024-06-10 16:54:44.385 30 ERROR masakari cursor.<wbr />execute(<wbr />statement, parameters)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />pymysql/<wbr />cursors.<wbr />py", line 153, in execute<br /> 2024-06-10 16:54:44.385 30 ERROR masakari result = self._query(query)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />pymysql/<wbr />cursors.<wbr />py", line 322, in _query<br /> 2024-06-10 16:54:44.385 30 ERROR masakari conn.query(q)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />pymysql/<wbr />connections.<wbr />py", line 558, in query<br /> 2024-06-10 16:54:44.385 30 ERROR masakari self._affected_rows = self._read_<wbr />query_result(<wbr />unbuffered=<wbr />unbuffered)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />pymysql/<wbr />connections.<wbr />py", line 822, in _read_query_result<br /> 2024-06-10 16:54:44.385 30 ERROR masakari result.read()<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />pymysql/<wbr />connections.<wbr />py", line 1200, in read<br /> 2024-06-10 16:54:44.385 30 ERROR masakari first_packet = self.connection<wbr />._read_<wbr />packet(<wbr />)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />pymysql/<wbr />connections.<wbr />py", line 772, in _read_packet<br /> 2024-06-10 16:54:44.385 30 ERROR masakari packet.<wbr />raise_for_<wbr />error()<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />pymysql/<wbr />protocol.<wbr />py", line 221, in raise_for_error<br /> 2024-06-10 16:54:44.385 30 ERROR masakari err.raise_<wbr />mysql_exception<wbr />(self._<wbr />data)<br /> 2024-06-10 16:54:44.385 30 ERROR masakari File "/var/lib/<wbr />kolla/venv/<wbr />lib64/python3.<wbr />9/site-<wbr />packages/<wbr />pymysql/<wbr />err.py"<wbr />, line 143, in raise_mysql_<wbr />exception<br /> 2024-06-10 16:54:44.385 30 ERROR masakari raise errorclass(errno, errval)</p> <p>Thanks in advance!</p></div> </div> </div> <div style="margin:-10px 0 20px 5px" class="clearfix"> </div> <div id="bug-tags"> <span id="tags-heading"> </span> <span id="tag-list"> </span> </div> <script type="text/javascript"> LPJS.use('event', 'node', 'lp.bugs.tags_entry', function(Y) { Y.on('domready', function(e) { Y.lp.bugs.tags_entry.setup_tag_entry( available_official_tags); }, window); }); </script> <div class="clearfix"></div> </div> <div id="branches-and-cves"> <div id="bug-branches-container" style="float: left"> </div> <div class="clearfix"></div> </div>  </div> <div> <div xmlns="http://www.w3.org/1999/xhtml" itemscope="" itemtype="http://schema.org/UserComments" class="boardComment editable-message " data-baseurl="/masakari/+bug/2068917/comments/1" data-i-can-edit="False"> <div class="boardCommentDetails"> <div class="message-revision-container"> <div class="message-revision-container-header"> <span>Revision history for this message</span> <img src="/+icing/build/overlay/assets/skins/sam/images/close.gif" class="message-revision-close" /> </div> <script type="text/template"> <div class='message-revision-item'> <div class='message-revision-title'> <a class="sprite remove action-icon message-revision-del-btn"> Remove </a> <a class="js-action"> Revision #{revision}, created at {date_created_display} </a> </div> <div class='message-revision-body'>{content}</div> </div> </script> <div class="message-revision-list"></div> </div> <table> <tbody> <tr> <td> <a href="https://launchpad.net/~przemekkuczynski" class="sprite person">Przemysław Kuczyński (przemekkuczynski)</a> wrote <time itemprop="commentTime" datetime="2024-07-09T09:12:34.977930+00:00" title="2024-07-09 09:12:34 UTC">on 2024-07-09</time><span class="editable-message-last-edit-date">: </span> </td> <td> </td> <td> </td> <td class="bug-comment-index"> <a itemprop="url" href="/masakari/+bug/2068917/comments/1"> #1</a> </td> </tr> </tbody> </table> </div> <div class="boardCommentBody"> <div class="editable-message-body"> <div class="comment-text editable-message-text" itemprop="commentText"><p>Same here</p> <p>During upgrade we have error like</p> <p>CRITICAL masakari [-] Unhandled error: sqlalchemy.<wbr />exc.Operational<wbr />Error: (pymysql.<wbr />err.Operational<wbr />Error) (1050, "Table 'failover_segments' already exists")</p> <p>2024-07-09 10:53:17.013 1015 INFO alembic.<wbr />runtime.<wbr />migration [-] Running upgrade -> 8f848eb45d03, Initial revision<br /> 2024-07-09 10:53:17.060 1015 CRITICAL masakari [-] Unhandled error: sqlalchemy.<wbr />exc.Operational<wbr />Error: (pymysql.<wbr />err.Operational<wbr />Error) (1050, "Table 'notifications' already exists")</p> <p>After delete tables all goes ok</p> <p>2024-07-09 10:56:05.149 1015 INFO alembic.<wbr />runtime.<wbr />migration [-] Running upgrade -> 1cea328f0f65, initial_<wbr />logbook_<wbr />details_<wbr />tables<br /> 2024-07-09 10:56:05.276 1015 INFO alembic.<wbr />runtime.<wbr />migration [-] Running upgrade 1cea328f0f65 -> 1c783c0c2875, Replace exception and stacktrace with failure column<br /> 2024-07-09 10:56:05.318 1015 INFO alembic.<wbr />runtime.<wbr />migration [-] Running upgrade 1c783c0c2875 -> 84d6e888850, Add task detail type<br /> 2024-07-09 10:56:05.333 1015 INFO alembic.<wbr />runtime.<wbr />migration [-] Running upgrade 84d6e888850 -> 14b227d79a87<br /> 2024-07-09 10:56:05.350 1015 INFO alembic.<wbr />runtime.<wbr />migration [-] Running upgrade 14b227d79a87 -> 589dccdf2b6e, Rename taskdetails to atomdetails<br /> 2024-07-09 10:56:05.360 1015 INFO alembic.<wbr />runtime.<wbr />migration [-] Running upgrade 589dccdf2b6e -> 3162c0f3f8e4, Add 'revert_results' and 'revert_failure' atom detail column.<br /> 2024-07-09 10:56:05.394 1015 INFO alembic.<wbr />runtime.<wbr />migration [-] Running upgrade 3162c0f3f8e4 -> 2ad4984f2864, Switch postgres to json native type.<br /> 2024-07-09 10:56:05.397 1015 INFO alembic.<wbr />runtime.<wbr />migration [-] Running upgrade 2ad4984f2864 -> 0bc3e1a3c135, set_result_<wbr />meduimtext_<wbr />type<br /> 2024-07-09 10:56:05.420 1015 INFO alembic.<wbr />runtime.<wbr />migration [-] Running upgrade 0bc3e1a3c135 -> 6df9422fcb43, fix flowdetails meta size<br /> 2024-07-09 10:56:05.444 1015 INFO alembic.<wbr />runtime.<wbr />migration [-] Running upgrade 6df9422fcb43 -> 40fc8c914bd2, fix atomdetails failure size</p></div> </div> <div class="editable-message-form" style="display: none"> <textarea style="width: 100%" rows="10">Same here During upgrade we have error like CRITICAL masakari [-] Unhandled error: sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1050, "Table 'failover_segments' already exists") 2024-07-09 10:53:17.013 1015 INFO alembic.runtime.migration [-] Running upgrade -> 8f848eb45d03, Initial revision 2024-07-09 10:53:17.060 1015 CRITICAL masakari [-] Unhandled error: sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1050, "Table 'notifications' already exists") After delete tables all goes ok 2024-07-09 10:56:05.149 1015 INFO alembic.runtime.migration [-] Running upgrade -> 1cea328f0f65, initial_logbook_details_tables 2024-07-09 10:56:05.276 1015 INFO alembic.runtime.migration [-] Running upgrade 1cea328f0f65 -> 1c783c0c2875, Replace exception and stacktrace with failure column 2024-07-09 10:56:05.318 1015 INFO alembic.runtime.migration [-] Running upgrade 1c783c0c2875 -> 84d6e888850, Add task detail type 2024-07-09 10:56:05.333 1015 INFO alembic.runtime.migration [-] Running upgrade 84d6e888850 -> 14b227d79a87 2024-07-09 10:56:05.350 1015 INFO alembic.runtime.migration [-] Running upgrade 14b227d79a87 -> 589dccdf2b6e, Rename taskdetails to atomdetails 2024-07-09 10:56:05.360 1015 INFO alembic.runtime.migration [-] Running upgrade 589dccdf2b6e -> 3162c0f3f8e4, Add 'revert_results' and 'revert_failure' atom detail column. 2024-07-09 10:56:05.394 1015 INFO alembic.runtime.migration [-] Running upgrade 3162c0f3f8e4 -> 2ad4984f2864, Switch postgres to json native type. 2024-07-09 10:56:05.397 1015 INFO alembic.runtime.migration [-] Running upgrade 2ad4984f2864 -> 0bc3e1a3c135, set_result_meduimtext_type 2024-07-09 10:56:05.420 1015 INFO alembic.runtime.migration [-] Running upgrade 0bc3e1a3c135 -> 6df9422fcb43, fix flowdetails meta size 2024-07-09 10:56:05.444 1015 INFO alembic.runtime.migration [-] Running upgrade 6df9422fcb43 -> 40fc8c914bd2, fix atomdetails failure size</textarea> <input type="button" value="Update" class="editable-message-update-btn" /> <input type="button" value="Cancel" class="editable-message-cancel-btn" /> </div> </div> </div> <div xmlns="http://www.w3.org/1999/xhtml" itemscope="" itemtype="http://schema.org/UserComments" class="boardComment editable-message " data-baseurl="/masakari/+bug/2068917/comments/2" data-i-can-edit="False"> <div class="boardCommentDetails"> <div class="message-revision-container"> <div class="message-revision-container-header"> <span>Revision history for this message</span> <img src="/+icing/build/overlay/assets/skins/sam/images/close.gif" class="message-revision-close" /> </div> <script type="text/template"> <div class='message-revision-item'> <div class='message-revision-title'> <a class="sprite remove action-icon message-revision-del-btn"> Remove </a> <a class="js-action"> Revision #{revision}, created at {date_created_display} </a> </div> <div class='message-revision-body'>{content}</div> </div> </script> <div class="message-revision-list"></div> </div> <table> <tbody> <tr> <td> <a href="https://launchpad.net/~kevin-schwerdtfeger" class="sprite person">Kevin Schwerdtfeger (kevin-schwerdtfeger)</a> wrote <time itemprop="commentTime" datetime="2024-08-15T13:19:14.222885+00:00" title="2024-08-15 13:19:14 UTC">on 2024-08-15</time><span class="editable-message-last-edit-date">: </span> </td> <td> </td> <td> </td> <td class="bug-comment-index"> <a itemprop="url" href="/masakari/+bug/2068917/comments/2"> #2</a> </td> </tr> </tbody> </table> </div> <div class="boardCommentBody"> <div class="editable-message-body"> <div class="comment-text editable-message-text" itemprop="commentText"><p>It appears that alembic is attempting to run database migration scripts that are unnecessary. I was able to work around the issue by updating the current alembic revision in the masakari database to 8bdf5929c5a6.</p> <p>INSERT INTO masakari_<wbr />alembic_<wbr />version VALUES ('8bdf5929c5a6') ;</p></div> </div> <div class="editable-message-form" style="display: none"> <textarea style="width: 100%" rows="10">It appears that alembic is attempting to run database migration scripts that are unnecessary. I was able to work around the issue by updating the current alembic revision in the masakari database to 8bdf5929c5a6. INSERT INTO masakari_alembic_version VALUES ('8bdf5929c5a6') ;</textarea> <input type="button" value="Update" class="editable-message-update-btn" /> <input type="button" value="Cancel" class="editable-message-cancel-btn" /> </div> </div> </div> <div style="float: right;"> <a class="menu-link-activitylog" href="https://bugs.launchpad.net/masakari/+bug/2068917/+activity">See full activity log</a> </div> <div class="clearfix"></div> <div align="center" id="add-comment-login-first"> To post a comment you must <a href="+login?comments=all">log in</a>. </div> </div> </div> <div> <div id="duplicate-form-container"></div> <div id="privacy-form-container"></div> </div> </div> </div> </div> <div id="side-portlets" class="yui-b side"> <div id="involvement" class="portlet"> <ul class="involvement"> <li class="single"> <a class="sprite bugs" href="/masakari/+filebug"> Report a bug </a> </li> </ul> </div> <div id="privacy" class="first portlet public"> <div id="privacy-text"> <span id="information-type-summary" class="sprite public">This report contains <strong id="information-type">Public</strong> information </span>  <div id="information-type-description" style="padding-top: 5px">Everyone can see this information. </div> </div> </div> <div id="portlet-actions" class="portlet vertical"> <ul id="duplicate-actions"> </ul> <ul id="lock-status-actions"> </ul> </div> <div class="portlet vertical" id="portlet-subscription"> <div class="section"> <div id="current_user_subscription" class="False"> <span>You are</span> <a class="menu-link-subscription sprite modify edit" href="/masakari/+bug/2068917/+subscribe"> not directly subscribed to this bug's notifications. </a> </div> <div id="sub-unsub-spinner">Subscribing...</div> <ul> <li><a class="menu-link-editsubscriptions sprite modify edit" href="https://bugs.launchpad.net/masakari/+bug/2068917/+subscriptions" title="View and change your subscriptions to this bug">Edit bug mail</a></li> </ul> </div> <script type="text/javascript"> LPJS.use('io-base', 'node', 'lp.bugs.bugtask_index.portlets.subscription', function(Y) { Y.on('domready', function() { Y.lp.bugs.bugtask_index.portlets.subscription.initialize(); }); }); </script> </div> <div class="portlet vertical" id="portlet-subscribers"> <h2>Other bug subscribers</h2> <div> <div><a class="menu-link-addsubscriber sprite add" href="https://bugs.launchpad.net/masakari/+bug/2068917/+addsubscriber" title="Launchpad will email that person whenever this bugs changes">Subscribe someone else</a></div> </div> <div id="other-bug-subscribers"></div> </div> <div class="portlet" id="portlet-watches"> <h2>Remote bug watches</h2> <ul> </ul> <p>Bug watches keep track of this bug in other bug trackers.</p> </div> </div> </div> <div id="footer" class="footer"> <div class="lp-arcana"> <div class="lp-branding"> <a href="https://launchpad.net/"><img src="/@@/launchpad-footer-logo.svg" alt="Launchpad" width="65" height="18" /></a>  •  <a href="https://launchpad.net/+tour">Take the tour</a>  •  <a href="https://help.launchpad.net/">Read the guide</a>   <form id="globalsearch" method="get" accept-charset="UTF-8" action="https://launchpad.net/+search"> <input type="search" id="search-text" name="field.text" /> <input type="image" src="/@@/search" style="vertical-align:5%" alt="Search Launchpad" /> </form> </div> </div> <div class="colophon"> © 2004 <a href="http://canonical.com/">Canonical Ltd.</a>  •  <a href="https://launchpad.net/legal">Terms of use</a>  •  <a href="https://www.ubuntu.com/legal/dataprivacy">Data privacy</a>  •  <a href="/feedback">Contact Launchpad Support</a>  •  <a href="http://blog.launchpad.net/">Blog</a>  •  <a href="https://canonical.com/careers">Careers</a>  •  <a href="https://ubuntu.social/@launchpadstatus">System status</a> <span id="lp-version">  •  aa29ae0 (<a href="https://dev.launchpad.net/">Get the code!</a>) </span> </div> </div> </div> <script id="json-cache-script">LP.cache = {"related_features": {}, "bug": {"self_link": "https://bugs.launchpad.net/api/devel/bugs/2068917", "web_link": "https://bugs.launchpad.net/bugs/2068917", "resource_type_link": "https://bugs.launchpad.net/api/devel/#bug", "id": 2068917, "private": false, "information_type": "Public", "name": null, "title": "DB Sync fails while upgrading from 2023.2 to 2024.1", "description": "We're using kolla and kolla-ansible to deploy our environment.\n\nWhile upgrading from 2023.2 to 2024.1 we observed that the upgrade fails because the bootstrap container of Masakari is failing.\n\nThe bootstrap container of kolla-ansible is calling 'masakari-manage db sync' without further arguments.\n\n2024-03-13 17:06:58.827 31 INFO migrate.versioning.api [-] 0 -\u003e 1... \n2024-03-13 17:06:58.841 31 INFO migrate.versioning.api [-] done\n2024-03-13 17:06:58.841 31 INFO migrate.versioning.api [-] 1 -\u003e 2... \n2024-03-13 17:06:58.858 31 INFO migrate.versioning.api [-] done\n2024-03-13 17:06:58.859 31 INFO migrate.versioning.api [-] 2 -\u003e 3... \n2024-03-13 17:06:58.888 31 INFO migrate.versioning.api [-] done\n2024-03-13 17:06:58.888 31 INFO migrate.versioning.api [-] 3 -\u003e 4... \n2024-03-13 17:06:58.899 31 INFO migrate.versioning.api [-] done\n2024-03-13 17:06:58.899 31 INFO migrate.versioning.api [-] 4 -\u003e 5... \n2024-03-13 17:06:58.922 31 INFO migrate.versioning.api [-] done\n2024-03-13 17:06:58.922 31 INFO migrate.versioning.api [-] 5 -\u003e 6... \n2024-03-13 17:06:58.923 31 INFO masakari.engine.driver [-] Loading masakari notification driver 'taskflow_driver'\n2024-03-13 17:06:59.213 31 INFO alembic.runtime.migration [-] Context impl MySQLImpl.\n2024-03-13 17:06:59.213 31 INFO alembic.runtime.migration [-] Will assume non-transactional DDL.\n2024-03-13 17:06:59.222 31 INFO alembic.runtime.migration [-] Running upgrade -\u003e 1cea328f0f65, initial_logbook_details_tables\n2024-03-13 17:06:59.254 31 INFO alembic.runtime.migration [-] Running upgrade 1cea328f0f65 -\u003e 1c783c0c2875, Replace exception and stacktrace with failure column\n2024-03-13 17:06:59.265 31 INFO alembic.runtime.migration [-] Running upgrade 1c783c0c2875 -\u003e 84d6e888850, Add task detail type\n2024-03-13 17:06:59.270 31 INFO alembic.runtime.migration [-] Running upgrade 84d6e888850 -\u003e 14b227d79a87\n2024-03-13 17:06:59.276 31 INFO alembic.runtime.migration [-] Running upgrade 14b227d79a87 -\u003e 589dccdf2b6e, Rename taskdetails to atomdetails\n2024-03-13 17:06:59.281 31 INFO alembic.runtime.migration [-] Running upgrade 589dccdf2b6e -\u003e 3162c0f3f8e4, Add 'revert_results' and 'revert_failure' atom detail column.\n2024-03-13 17:06:59.290 31 INFO alembic.runtime.migration [-] Running upgrade 3162c0f3f8e4 -\u003e 2ad4984f2864, Switch postgres to json native type.\n2024-03-13 17:06:59.292 31 INFO alembic.runtime.migration [-] Running upgrade 2ad4984f2864 -\u003e 0bc3e1a3c135, set_result_meduimtext_type\n2024-03-13 17:06:59.299 31 INFO alembic.runtime.migration [-] Running upgrade 0bc3e1a3c135 -\u003e 6df9422fcb43, fix flowdetails meta size\n2024-03-13 17:06:59.306 31 INFO alembic.runtime.migration [-] Running upgrade 6df9422fcb43 -\u003e 40fc8c914bd2, fix atomdetails failure size\n2024-03-13 17:06:59.323 31 INFO migrate.versioning.api [-] done\n2024-03-13 17:06:59.323 31 INFO migrate.versioning.api [-] 6 -\u003e 7... \n2024-03-13 17:06:59.340 31 INFO migrate.versioning.api [-] done\n2024-03-13 17:06:59.340 31 INFO migrate.versioning.api [-] 7 -\u003e 8... \n2024-03-13 17:06:59.351 31 INFO migrate.versioning.api [-] done\n2024-06-10 16:54:44.364 30 INFO masakari.db.sqlalchemy.migration [-] Applying migration(s)\n2024-06-10 16:54:44.372 30 INFO alembic.runtime.migration [-] Context impl MySQLImpl.\n2024-06-10 16:54:44.372 30 INFO alembic.runtime.migration [-] Will assume non-transactional DDL.\n2024-06-10 16:54:44.375 30 INFO alembic.runtime.migration [-] Context impl MySQLImpl.\n2024-06-10 16:54:44.375 30 INFO alembic.runtime.migration [-] Will assume non-transactional DDL.\n2024-06-10 16:54:44.381 30 INFO alembic.runtime.migration [-] Running upgrade -\u003e 8f848eb45d03, Initial revision\n2024-06-10 16:54:44.385 30 CRITICAL masakari [-] Unhandled error: sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1050, \"Table 'failover_segments' already exists\")\n[SQL: \nCREATE TABLE failover_segments (\n created_at DATETIME, \n updated_at DATETIME, \n deleted_at DATETIME, \n deleted INTEGER, \n id INTEGER NOT NULL AUTO_INCREMENT, \n uuid VARCHAR(36) NOT NULL, \n name VARCHAR(255) NOT NULL, \n service_type VARCHAR(255) NOT NULL, \n description TEXT, \n recovery_method ENUM('auto','reserved_host','auto_priority','rh_priority') NOT NULL, \n enabled BOOL, \n PRIMARY KEY (id), \n CONSTRAINT uniq_segment0name0deleted UNIQUE (name, deleted), \n CONSTRAINT uniq_segments0uuid UNIQUE (uuid)\n)\n\n]\n(Background on this error at: https://sqlalche.me/e/14/e3q8)\n2024-06-10 16:54:44.385 30 ERROR masakari Traceback (most recent call last):\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/sqlalchemy/engine/base.py\", line 1910, in _execute_context\n2024-06-10 16:54:44.385 30 ERROR masakari self.dialect.do_execute(\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/sqlalchemy/engine/default.py\", line 736, in do_execute\n2024-06-10 16:54:44.385 30 ERROR masakari cursor.execute(statement, parameters)\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/pymysql/cursors.py\", line 153, in execute\n2024-06-10 16:54:44.385 30 ERROR masakari result = self._query(query)\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/pymysql/cursors.py\", line 322, in _query\n2024-06-10 16:54:44.385 30 ERROR masakari conn.query(q)\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/pymysql/connections.py\", line 558, in query\n2024-06-10 16:54:44.385 30 ERROR masakari self._affected_rows = self._read_query_result(unbuffered=unbuffered)\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/pymysql/connections.py\", line 822, in _read_query_result\n2024-06-10 16:54:44.385 30 ERROR masakari result.read()\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/pymysql/connections.py\", line 1200, in read\n2024-06-10 16:54:44.385 30 ERROR masakari first_packet = self.connection._read_packet()\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/pymysql/connections.py\", line 772, in _read_packet\n2024-06-10 16:54:44.385 30 ERROR masakari packet.raise_for_error()\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/pymysql/protocol.py\", line 221, in raise_for_error\n2024-06-10 16:54:44.385 30 ERROR masakari err.raise_mysql_exception(self._data)\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/pymysql/err.py\", line 143, in raise_mysql_exception\n2024-06-10 16:54:44.385 30 ERROR masakari raise errorclass(errno, errval)\n2024-06-10 16:54:44.385 30 ERROR masakari pymysql.err.OperationalError: (1050, \"Table 'failover_segments' already exists\")\n2024-06-10 16:54:44.385 30 ERROR masakari \n2024-06-10 16:54:44.385 30 ERROR masakari The above exception was the direct cause of the following exception:\n2024-06-10 16:54:44.385 30 ERROR masakari \n2024-06-10 16:54:44.385 30 ERROR masakari Traceback (most recent call last):\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/bin/masakari-manage\", line 8, in \u003cmodule\u003e\n2024-06-10 16:54:44.385 30 ERROR masakari sys.exit(main())\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/masakari/cmd/manage.py\", line 207, in main\n2024-06-10 16:54:44.385 30 ERROR masakari fn(*fn_args)\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/masakari/cmd/manage.py\", line 70, in sync\n2024-06-10 16:54:44.385 30 ERROR masakari return db_migration.db_sync(version)\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/masakari/db/sqlalchemy/migration.py\", line 163, in db_sync\n2024-06-10 16:54:44.385 30 ERROR masakari _upgrade_alembic(engine, config, version)\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/masakari/db/sqlalchemy/migration.py\", line 130, in _upgrade_alembic\n2024-06-10 16:54:44.385 30 ERROR masakari alembic_api.upgrade(config, version or 'head')\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/alembic/command.py\", line 378, in upgrade\n2024-06-10 16:54:44.385 30 ERROR masakari script.run_env()\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/alembic/script/base.py\", line 569, in run_env\n2024-06-10 16:54:44.385 30 ERROR masakari util.load_python_file(self.dir, \"env.py\")\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/alembic/util/pyfiles.py\", line 94, in load_python_file\n2024-06-10 16:54:44.385 30 ERROR masakari module = load_module_py(module_id, path)\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/alembic/util/pyfiles.py\", line 110, in load_module_py\n2024-06-10 16:54:44.385 30 ERROR masakari spec.loader.exec_module(module) # type: ignore\n2024-06-10 16:54:44.385 30 ERROR masakari File \"\u003cfrozen importlib._bootstrap_external\u003e\", line 850, in exec_module\n2024-06-10 16:54:44.385 30 ERROR masakari File \"\u003cfrozen importlib._bootstrap\u003e\", line 228, in _call_with_frames_removed\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/masakari/db/sqlalchemy/migrations/env.py\", line 109, in \u003cmodule\u003e\n2024-06-10 16:54:44.385 30 ERROR masakari run_migrations_online()\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/masakari/db/sqlalchemy/migrations/env.py\", line 103, in run_migrations_online\n2024-06-10 16:54:44.385 30 ERROR masakari context.run_migrations()\n2024-06-10 16:54:44.385 30 ERROR masakari File \"\u003cstring\u003e\", line 8, in run_migrations\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/alembic/runtime/environment.py\", line 867, in run_migrations\n2024-06-10 16:54:44.385 30 ERROR masakari self.get_context().run_migrations(**kw)\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/alembic/runtime/migration.py\", line 624, in run_migrations\n2024-06-10 16:54:44.385 30 ERROR masakari step.migration_fn(**kw)\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/masakari/db/sqlalchemy/migrations/versions/8f848eb45d03_initial_revision.py\", line 32, in upgrade\n2024-06-10 16:54:44.385 30 ERROR masakari op.create_table(\n2024-06-10 16:54:44.385 30 ERROR masakari File \"\u003cstring\u003e\", line 8, in create_table\n2024-06-10 16:54:44.385 30 ERROR masakari File \"\u003cstring\u003e\", line 3, in create_table\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/alembic/operations/ops.py\", line 1260, in create_table\n2024-06-10 16:54:44.385 30 ERROR masakari return operations.invoke(op)\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/alembic/operations/base.py\", line 401, in invoke\n2024-06-10 16:54:44.385 30 ERROR masakari return fn(self, operation)\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/alembic/operations/toimpl.py\", line 114, in create_table\n2024-06-10 16:54:44.385 30 ERROR masakari operations.impl.create_table(table)\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/alembic/ddl/impl.py\", line 354, in create_table\n2024-06-10 16:54:44.385 30 ERROR masakari self._exec(schema.CreateTable(table))\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/alembic/ddl/impl.py\", line 193, in _exec\n2024-06-10 16:54:44.385 30 ERROR masakari return conn.execute( # type: ignore[call-overload]\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/sqlalchemy/engine/base.py\", line 1385, in execute\n2024-06-10 16:54:44.385 30 ERROR masakari return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS)\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/sqlalchemy/sql/ddl.py\", line 80, in _execute_on_connection\n2024-06-10 16:54:44.385 30 ERROR masakari return connection._execute_ddl(\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/sqlalchemy/engine/base.py\", line 1477, in _execute_ddl\n2024-06-10 16:54:44.385 30 ERROR masakari ret = self._execute_context(\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/sqlalchemy/engine/base.py\", line 1953, in _execute_context\n2024-06-10 16:54:44.385 30 ERROR masakari self._handle_dbapi_exception(\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/sqlalchemy/engine/base.py\", line 2132, in _handle_dbapi_exception\n2024-06-10 16:54:44.385 30 ERROR masakari util.raise_(newraise, with_traceback=exc_info[2], from_=e)\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/sqlalchemy/util/compat.py\", line 211, in raise_\n2024-06-10 16:54:44.385 30 ERROR masakari raise exception\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/sqlalchemy/engine/base.py\", line 1910, in _execute_context\n2024-06-10 16:54:44.385 30 ERROR masakari self.dialect.do_execute(\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/sqlalchemy/engine/default.py\", line 736, in do_execute\n2024-06-10 16:54:44.385 30 ERROR masakari cursor.execute(statement, parameters)\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/pymysql/cursors.py\", line 153, in execute\n2024-06-10 16:54:44.385 30 ERROR masakari result = self._query(query)\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/pymysql/cursors.py\", line 322, in _query\n2024-06-10 16:54:44.385 30 ERROR masakari conn.query(q)\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/pymysql/connections.py\", line 558, in query\n2024-06-10 16:54:44.385 30 ERROR masakari self._affected_rows = self._read_query_result(unbuffered=unbuffered)\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/pymysql/connections.py\", line 822, in _read_query_result\n2024-06-10 16:54:44.385 30 ERROR masakari result.read()\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/pymysql/connections.py\", line 1200, in read\n2024-06-10 16:54:44.385 30 ERROR masakari first_packet = self.connection._read_packet()\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/pymysql/connections.py\", line 772, in _read_packet\n2024-06-10 16:54:44.385 30 ERROR masakari packet.raise_for_error()\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/pymysql/protocol.py\", line 221, in raise_for_error\n2024-06-10 16:54:44.385 30 ERROR masakari err.raise_mysql_exception(self._data)\n2024-06-10 16:54:44.385 30 ERROR masakari File \"/var/lib/kolla/venv/lib64/python3.9/site-packages/pymysql/err.py\", line 143, in raise_mysql_exception\n2024-06-10 16:54:44.385 30 ERROR masakari raise errorclass(errno, errval)\n\nThanks in advance!", "owner_link": "https://bugs.launchpad.net/api/devel/~msnatepg", "bug_tasks_collection_link": "https://bugs.launchpad.net/api/devel/bugs/2068917/bug_tasks", "duplicate_of_link": null, "date_created": "2024-06-10T15:38:54.447640+00:00", "activity_collection_link": "https://bugs.launchpad.net/api/devel/bugs/2068917/activity", "subscriptions_collection_link": "https://bugs.launchpad.net/api/devel/bugs/2068917/subscriptions", "date_last_updated": "2024-08-15T13:19:14.744971+00:00", "who_made_private_link": null, "date_made_private": null, "heat": 18, "bug_watches_collection_link": "https://bugs.launchpad.net/api/devel/bugs/2068917/bug_watches", "cves_collection_link": "https://bugs.launchpad.net/api/devel/bugs/2068917/cves", "vulnerabilities_collection_link": "https://bugs.launchpad.net/api/devel/bugs/2068917/vulnerabilities", "duplicates_collection_link": "https://bugs.launchpad.net/api/devel/bugs/2068917/duplicates", "attachments_collection_link": "https://bugs.launchpad.net/api/devel/bugs/2068917/attachments", "security_related": false, "latest_patch_uploaded": null, "tags": [], "date_last_message": "2024-08-15T13:19:14.222885+00:00", "number_of_duplicates": 0, "message_count": 3, "users_affected_count": 4, "users_unaffected_count": 0, "users_affected_collection_link": "https://bugs.launchpad.net/api/devel/bugs/2068917/users_affected", "users_unaffected_collection_link": "https://bugs.launchpad.net/api/devel/bugs/2068917/users_unaffected", "users_affected_count_with_dupes": 4, "other_users_affected_count_with_dupes": 4, "users_affected_with_dupes_collection_link": "https://bugs.launchpad.net/api/devel/bugs/2068917/users_affected_with_dupes", "messages_collection_link": "https://bugs.launchpad.net/api/devel/bugs/2068917/messages", "lock_status": "Unlocked", "lock_reason": null, "linked_branches_collection_link": "https://bugs.launchpad.net/api/devel/bugs/2068917/linked_branches", "linked_merge_proposals_collection_link": "https://bugs.launchpad.net/api/devel/bugs/2068917/linked_merge_proposals", "http_etag": "\"aecea0b66befadb403205fbc3bde3550c36e7af8-dedd5a48b78863ffc6bc9f4098b0506a705c5190\""}, "subscribers_portlet_url_data": {"web_link": "https://bugs.launchpad.net/bugs/2068917", "self_link": "https://bugs.launchpad.net/api/devel/bugs/2068917"}, "total_comments_and_activity": 2, "initial_comment_batch_offset": 41, "first visible_recent_comment": -38, "bugtask_data": {"3208668": {"id": 3208668, "row_id": "tasksummary3208668", "form_row_id": "task3208668", "bugtask_path": "/masakari/+bug/2068917", "prefix": "masakari", "targetname": "masakari", "bug_title": "DB Sync fails while upgrading from 2023.2 to 2024.1", "assignee_value": null, "assignee_is_team": null, "assignee_vocabulary": "AllUserTeamsParticipation", "assignee_vocabulary_filters": [], "hide_assignee_team_selection": true, "user_can_unassign": false, "user_can_delete": false, "delete_link": "https://bugs.launchpad.net/masakari/+bug/2068917/+delete", "target_is_product": true, "status_widget_items": [{"name": "New", "value": "New", "description": "Not looked at yet.\n", "description_css_class": "choice-description", "style": "", "help": "", "disabled": false, "css_class": "statusNEW"}], "status_value": "New", "importance_widget_items": "[]", "importance_value": "Undecided", "milestone_widget_items": "[]", "milestone_value": null, "user_can_edit_assignee": false, "user_can_edit_milestone": false, "user_can_edit_status": false, "user_can_edit_importance": false}}, "information_type_data": {"PUBLIC": {"value": "PUBLIC", "description": "Everyone can see this information.\n", "name": "Public", "order": 0, "is_private": false, "description_css_class": "choice-description"}, "PUBLICSECURITY": {"value": "PUBLICSECURITY", "description": "Everyone can see this security related information.\n", "name": "Public Security", "order": 1, "is_private": false, "description_css_class": "choice-description"}, "PRIVATESECURITY": {"value": "PRIVATESECURITY", "description": "Only the security group can see this information.\n ", "name": "Private Security", "order": 2, "is_private": true, "description_css_class": "choice-description"}, "USERDATA": {"value": "USERDATA", "description": "Only shared with users permitted to see private user information.\n", "name": "Private", "order": 3, "is_private": true, "description_css_class": "choice-description"}}, "bug_is_private": false, "context": {"self_link": "https://bugs.launchpad.net/api/devel/masakari/+bug/2068917", "web_link": "https://bugs.launchpad.net/masakari/+bug/2068917", "resource_type_link": "https://bugs.launchpad.net/api/devel/#bug_task", "bug_link": "https://bugs.launchpad.net/api/devel/bugs/2068917", "milestone_link": null, "status": "New", "status_explanation": null, "importance": "Undecided", "importance_explanation": null, "assignee_link": null, "bug_target_display_name": "masakari", "bug_target_name": "masakari", "bug_watch_link": null, "date_assigned": null, "date_created": "2024-06-10T15:38:54.447640+00:00", "date_confirmed": null, "date_incomplete": null, "date_in_progress": null, "date_closed": null, "date_left_new": null, "date_triaged": null, "date_fix_committed": null, "date_fix_released": null, "date_left_closed": null, "owner_link": "https://bugs.launchpad.net/api/devel/~msnatepg", "target_link": "https://bugs.launchpad.net/api/devel/masakari", "title": "Bug #2068917 in masakari: \"DB Sync fails while upgrading from 2023.2 to 2024.1\"", "related_tasks_collection_link": "https://bugs.launchpad.net/api/devel/masakari/+bug/2068917/related_tasks", "is_complete": false, "http_etag": "\"0e0b7e737b10d403efb829438a40bed000651d9c-084028f1794832ee86ebbca61f657a52f0864678\""}};</script> </body>  </html>

CINXE.COM

Bug #2068917 “DB Sync fails while upgrading from 2023.2 to 2024....” : Bugs : masakari