CINXE.COM
Upgrade from v9 to v10 - Administrators - Invenio
<!DOCTYPE html> <html lang="en-GB"> <head> <meta charset="utf-8"> <title>Upgrade from v9 to v10 - Administrators - Invenio</title> <meta name="description" content="Hello!! I want to upgrade from v9 to v10 using the documentation. But in the Re-index data section, the commands are not known by the system even so i am in “my-site” directory. can anybody help ? Thanks in advance"> <meta name="generator" content="Discourse 3.5.0.beta1-dev - https://github.com/discourse/discourse version 4a7a9efbb95c1976f56c3bddc36a9236eade8fa4"> <link rel="icon" type="image/png" href="https://invenio-talk.web.cern.ch/uploads/default/optimized/1X/_129430568242d1b7f853bb13ebea28b3f6af4e7_2_32x32.png"> <link rel="apple-touch-icon" type="image/png" href="https://invenio-talk.web.cern.ch/uploads/default/optimized/1X/_129430568242d1b7f853bb13ebea28b3f6af4e7_2_180x180.png"> <meta name="theme-color" media="all" content="#0377cd"> <meta name="color-scheme" content="light"> <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, viewport-fit=cover"> <link rel="canonical" href="https://invenio-talk.web.cern.ch/t/upgrade-from-v9-to-v10/274" /> <link rel="search" type="application/opensearchdescription+xml" href="https://invenio-talk.web.cern.ch/opensearch.xml" title="Invenio Search"> <link href="/stylesheets/color_definitions_invenio-colors_3_3_78717404254d1ec7295464cdb414dbe578ccec05.css?__ws=invenio-talk.web.cern.ch" media="all" rel="stylesheet" class="light-scheme"/> <link href="/stylesheets/desktop_32d4b9f3691d5368f2eacb10ff7a08a4055d57ca.css?__ws=invenio-talk.web.cern.ch" media="all" rel="stylesheet" data-target="desktop" /> <link href="/stylesheets/checklist_32d4b9f3691d5368f2eacb10ff7a08a4055d57ca.css?__ws=invenio-talk.web.cern.ch" media="all" rel="stylesheet" data-target="checklist" /> <link href="/stylesheets/discourse-details_32d4b9f3691d5368f2eacb10ff7a08a4055d57ca.css?__ws=invenio-talk.web.cern.ch" media="all" rel="stylesheet" data-target="discourse-details" /> <link href="/stylesheets/discourse-lazy-videos_32d4b9f3691d5368f2eacb10ff7a08a4055d57ca.css?__ws=invenio-talk.web.cern.ch" media="all" rel="stylesheet" data-target="discourse-lazy-videos" /> <link href="/stylesheets/discourse-local-dates_32d4b9f3691d5368f2eacb10ff7a08a4055d57ca.css?__ws=invenio-talk.web.cern.ch" media="all" rel="stylesheet" data-target="discourse-local-dates" /> <link href="/stylesheets/discourse-narrative-bot_32d4b9f3691d5368f2eacb10ff7a08a4055d57ca.css?__ws=invenio-talk.web.cern.ch" media="all" rel="stylesheet" data-target="discourse-narrative-bot" /> <link href="/stylesheets/discourse-presence_32d4b9f3691d5368f2eacb10ff7a08a4055d57ca.css?__ws=invenio-talk.web.cern.ch" media="all" rel="stylesheet" data-target="discourse-presence" /> <link href="/stylesheets/discourse-solved_32d4b9f3691d5368f2eacb10ff7a08a4055d57ca.css?__ws=invenio-talk.web.cern.ch" media="all" rel="stylesheet" data-target="discourse-solved" /> <link href="/stylesheets/discourse-templates_32d4b9f3691d5368f2eacb10ff7a08a4055d57ca.css?__ws=invenio-talk.web.cern.ch" media="all" rel="stylesheet" data-target="discourse-templates" /> <link href="/stylesheets/discourse-voting_32d4b9f3691d5368f2eacb10ff7a08a4055d57ca.css?__ws=invenio-talk.web.cern.ch" media="all" rel="stylesheet" data-target="discourse-voting" /> <link href="/stylesheets/footnote_32d4b9f3691d5368f2eacb10ff7a08a4055d57ca.css?__ws=invenio-talk.web.cern.ch" media="all" rel="stylesheet" data-target="footnote" /> <link href="/stylesheets/poll_32d4b9f3691d5368f2eacb10ff7a08a4055d57ca.css?__ws=invenio-talk.web.cern.ch" media="all" rel="stylesheet" data-target="poll" /> <link href="/stylesheets/spoiler-alert_32d4b9f3691d5368f2eacb10ff7a08a4055d57ca.css?__ws=invenio-talk.web.cern.ch" media="all" rel="stylesheet" data-target="spoiler-alert" /> <link href="/stylesheets/discourse-voting_desktop_32d4b9f3691d5368f2eacb10ff7a08a4055d57ca.css?__ws=invenio-talk.web.cern.ch" media="all" rel="stylesheet" data-target="discourse-voting_desktop" /> <link href="/stylesheets/poll_desktop_32d4b9f3691d5368f2eacb10ff7a08a4055d57ca.css?__ws=invenio-talk.web.cern.ch" media="all" rel="stylesheet" data-target="poll_desktop" /> <link href="/stylesheets/desktop_theme_3_5df97cdc18ad8ad890b86b5c67d94411ef6ea99e.css?__ws=invenio-talk.web.cern.ch" media="all" rel="stylesheet" data-target="desktop_theme" data-theme-id="3" data-theme-name="shades of blue"/> <link rel="alternate nofollow" type="application/rss+xml" title="RSS feed of 'Upgrade from v9 to v10'" href="https://invenio-talk.web.cern.ch/t/upgrade-from-v9-to-v10/274.rss" /> <meta property="og:site_name" content="Invenio" /> <meta property="og:type" content="website" /> <meta name="twitter:card" content="summary" /> <meta name="twitter:image" content="https://invenio-talk.web.cern.ch/uploads/default/original/1X/365b3da954a64ad5402137fe610018898acec6a9.png" /> <meta property="og:image" content="https://invenio-talk.web.cern.ch/uploads/default/original/1X/365b3da954a64ad5402137fe610018898acec6a9.png" /> <meta property="og:url" content="https://invenio-talk.web.cern.ch/t/upgrade-from-v9-to-v10/274" /> <meta name="twitter:url" content="https://invenio-talk.web.cern.ch/t/upgrade-from-v9-to-v10/274" /> <meta property="og:title" content="Upgrade from v9 to v10" /> <meta name="twitter:title" content="Upgrade from v9 to v10" /> <meta property="og:description" content="Hello!! I want to upgrade from v9 to v10 using the documentation. But in the Re-index data section, the commands are not known by the system even so i am in “my-site” directory. can anybody help ? Thanks in advance" /> <meta name="twitter:description" content="Hello!! I want to upgrade from v9 to v10 using the documentation. But in the Re-index data section, the commands are not known by the system even so i am in “my-site” directory. can anybody help ? Thanks in advance" /> <meta property="og:article:section" content="Community" /> <meta property="og:article:section:color" content="12A89D" /> <meta property="og:article:section" content="Administrators" /> <meta property="og:article:section:color" content="BF1E2E" /> <meta name="twitter:label1" value="Reading time" /> <meta name="twitter:data1" value="2 mins 🕑" /> <meta name="twitter:label2" value="Likes" /> <meta name="twitter:data2" value="1 ❤" /> <meta property="article:published_time" content="2023-01-10T08:15:28+00:00" /> <meta property="og:ignore_canonical" content="true" /> </head> <body class="crawler browser-update"> <header> <a href="/"> Invenio </a> </header> <div id="main-outlet" class="wrap" role="main"> <div id="topic-title"> <h1> <a href="/t/upgrade-from-v9-to-v10/274">Upgrade from v9 to v10</a> </h1> <div class="topic-category" itemscope itemtype="http://schema.org/BreadcrumbList"> <span itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem"> <a href="/c/community/administrators/13" class="badge-wrapper bullet" itemprop="item"> <span class='badge-category-bg' style='background-color: #12A89D'></span> <span class='badge-category clear-badge'> <span class='category-name' itemprop='name'>Community</span> </span> </a> <meta itemprop="position" content="1" /> </span> <span itemprop="itemListElement" itemscope itemtype="http://schema.org/ListItem"> <a href="/c/community/administrators/13" class="badge-wrapper bullet" itemprop="item"> <span class='badge-category-bg' style='background-color: #BF1E2E'></span> <span class='badge-category clear-badge'> <span class='category-name' itemprop='name'>Administrators</span> </span> </a> <meta itemprop="position" content="2" /> </span> </div> </div> <div itemscope itemtype='http://schema.org/DiscussionForumPosting'> <meta itemprop='headline' content='Upgrade from v9 to v10'> <link itemprop='url' href='https://invenio-talk.web.cern.ch/t/upgrade-from-v9-to-v10/274'> <meta itemprop='datePublished' content='2023-01-10T08:15:27Z'> <meta itemprop='articleSection' content='Administrators'> <meta itemprop='keywords' content=''> <div itemprop='publisher' itemscope itemtype="http://schema.org/Organization"> <meta itemprop='name' content='Invenio'> <div itemprop='logo' itemscope itemtype="http://schema.org/ImageObject"> <meta itemprop='url' content='https://invenio-talk.web.cern.ch/uploads/default/original/1X/365b3da954a64ad5402137fe610018898acec6a9.png'> </div> </div> <div id='post_1' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" rel='nofollow' href='https://invenio-talk.web.cern.ch/u/GabomaGeek'><span itemprop='name'>GabomaGeek</span></a> </span> <link itemprop="mainEntityOfPage" href="https://invenio-talk.web.cern.ch/t/upgrade-from-v9-to-v10/274"> <span class="crawler-post-infos"> <time datetime='2023-01-10T08:15:28Z' class='post-time'> 10 January 2023 08:15 </time> <meta itemprop='dateModified' content='2023-01-10T08:15:28Z'> <span itemprop='position'>1</span> </span> </div> <div class='post' itemprop='text'> <p>Hello!!<br> I want to upgrade from v9 to v10 using the <a href="https://inveniordm.docs.cern.ch/releases/upgrading/upgrade-v10.0/" rel="noopener nofollow ugc">documentation</a>. But in the Re-index data section, the commands are not known by the system even so i am in “my-site” directory.<br> can anybody help ?<br> Thanks in advance</p> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="0" /> <span class='post-likes'></span> </div> </div> <div id='post_2' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" rel='nofollow' href='https://invenio-talk.web.cern.ch/u/nitarocc'><span itemprop='name'>nitarocc</span></a> </span> <span class="crawler-post-infos"> <time itemprop='datePublished' datetime='2023-01-10T10:44:51Z' class='post-time'> 10 January 2023 10:44 </time> <meta itemprop='dateModified' content='2023-01-10T10:44:51Z'> <span itemprop='position'>2</span> </span> </div> <div class='post' itemprop='text'> <p>Hello,<br> do you have the latest version of <code>invenio-cli</code>?</p> <pre><code class="lang-auto">$ pip show invenio-cli Name: invenio-cli Version: 1.0.14 </code></pre> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="0" /> <span class='post-likes'></span> </div> </div> <div id='post_3' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" rel='nofollow' href='https://invenio-talk.web.cern.ch/u/GabomaGeek'><span itemprop='name'>GabomaGeek</span></a> </span> <span class="crawler-post-infos"> <time itemprop='datePublished' datetime='2023-01-10T12:29:37Z' class='post-time'> 10 January 2023 12:29 </time> <meta itemprop='dateModified' content='2023-01-10T12:29:37Z'> <span itemprop='position'>3</span> </span> </div> <div class='post' itemprop='text'> <p>I have the version 1.0.4</p> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="0" /> <span class='post-likes'></span> </div> </div> <div id='post_4' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" rel='nofollow' href='https://invenio-talk.web.cern.ch/u/nitarocc'><span itemprop='name'>nitarocc</span></a> </span> <span class="crawler-post-infos"> <time itemprop='datePublished' datetime='2023-01-10T12:58:39Z' class='post-time'> 10 January 2023 12:58 </time> <meta itemprop='dateModified' content='2023-01-10T12:58:39Z'> <span itemprop='position'>4</span> </span> </div> <div class='post' itemprop='text'> <p>You will need to upgrade, see the step <a href="https://inveniordm.docs.cern.ch/releases/upgrading/upgrade-v10.0/#upgrade-steps">Upgrade your invenio-cli</a>, the first step in the upgrade guide.</p> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="0" /> <span class='post-likes'></span> </div> </div> <div id='post_5' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" rel='nofollow' href='https://invenio-talk.web.cern.ch/u/GabomaGeek'><span itemprop='name'>GabomaGeek</span></a> </span> <span class="crawler-post-infos"> <time itemprop='datePublished' datetime='2023-01-10T13:09:41Z' class='post-time'> 10 January 2023 13:09 </time> <meta itemprop='dateModified' content='2023-01-10T13:09:41Z'> <span itemprop='position'>5</span> </span> </div> <div class='post' itemprop='text'> <p>I did that, but i still have the version 1.0.4</p> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="0" /> <span class='post-likes'></span> </div> </div> <div id='post_6' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" rel='nofollow' href='https://invenio-talk.web.cern.ch/u/nitarocc'><span itemprop='name'>nitarocc</span></a> </span> <span class="crawler-post-infos"> <time itemprop='datePublished' datetime='2023-01-10T13:22:14Z' class='post-time'> 10 January 2023 13:22 </time> <meta itemprop='dateModified' content='2023-01-10T13:22:14Z'> <span itemprop='position'>6</span> </span> </div> <div class='post' itemprop='text'> <p>I am not sure what is the command that you have used, I suggest the following:</p> <pre><code class="lang-auto">$ pip uninstall -y invenio-cli $ pip install invenio-cli </code></pre> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="0" /> <span class='post-likes'></span> </div> </div> <div id='post_7' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" rel='nofollow' href='https://invenio-talk.web.cern.ch/u/GabomaGeek'><span itemprop='name'>GabomaGeek</span></a> </span> <span class="crawler-post-infos"> <time itemprop='datePublished' datetime='2023-01-10T13:37:46Z' class='post-time'> 10 January 2023 13:37 </time> <meta itemprop='dateModified' content='2023-01-10T13:37:46Z'> <span itemprop='position'>7</span> </span> </div> <div class='post' itemprop='text'> <p>thanks, it’s working.</p> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="0" /> <span class='post-likes'></span> </div> </div> <div id='post_8' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" rel='nofollow' href='https://invenio-talk.web.cern.ch/u/GabomaGeek'><span itemprop='name'>GabomaGeek</span></a> </span> <span class="crawler-post-infos"> <time itemprop='datePublished' datetime='2023-01-11T08:29:57Z' class='post-time'> 11 January 2023 08:29 </time> <meta itemprop='dateModified' content='2023-01-11T08:29:57Z'> <span itemprop='position'>8</span> </span> </div> <div class='post' itemprop='text'> <p>I got an error when i run <code>pipenv run invenio alembic upgrade</code></p> <pre><code class="lang-auto">The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/home/openmrs/.local/share/virtualenvs/invenio-YWY9aZyz/bin/invenio", line 8, in <module> sys.exit(cli()) File "/home/openmrs/.local/share/virtualenvs/invenio-YWY9aZyz/lib/python3.8/site-packages/click/core.py", line 1130, in __call__ return self.main(*args, **kwargs) File "/home/openmrs/.local/share/virtualenvs/invenio-YWY9aZyz/lib/python3.8/site-packages/click/core.py", line 1055, in main rv = self.invoke(ctx) File "/home/openmrs/.local/share/virtualenvs/invenio-YWY9aZyz/lib/python3.8/site-packages/click/core.py", line 1657, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/openmrs/.local/share/virtualenvs/invenio-YWY9aZyz/lib/python3.8/site-packages/click/core.py", line 1657, in invoke return _process_result(sub_ctx.command.invoke(sub_ctx)) File "/home/openmrs/.local/share/virtualenvs/invenio-YWY9aZyz/lib/python3.8/site-packages/click/core.py", line 1404, in invoke return ctx.invoke(self.callback, **ctx.params) File "/home/openmrs/.local/share/virtualenvs/invenio-YWY9aZyz/lib/python3.8/site-packages/click/core.py", line 760, in invoke return __callback(*args, **kwargs) File "/home/openmrs/.local/share/virtualenvs/invenio-YWY9aZyz/lib/python3.8/site-packages/click/decorators.py", line 26, in new_func return f(get_current_context(), *args, **kwargs) File "/home/openmrs/.local/share/virtualenvs/invenio-YWY9aZyz/lib/python3.8/site-packages/flask/cli.py", line 357, in decorator return __ctx.invoke(f, *args, **kwargs) File "/home/openmrs/.local/share/virtualenvs/invenio-YWY9aZyz/lib/python3.8/site-packages/click/core.py", line 760, in invoke return __callback(*args, **kwargs) File "/home/openmrs/.local/share/virtualenvs/invenio-YWY9aZyz/lib/python3.8/site-packages/flask_alembic/cli/click.py", line 91, in upgrade base.upgrade(target) File "/home/openmrs/.local/share/virtualenvs/invenio-YWY9aZyz/lib/python3.8/site-packages/flask_alembic/cli/base.py", line 85, in upgrade get_alembic().upgrade(target) File "/home/openmrs/.local/share/virtualenvs/invenio-YWY9aZyz/lib/python3.8/site-packages/flask_alembic/extension.py", line 327, in upgrade self.run_migrations(do_upgrade) File "/home/openmrs/.local/share/virtualenvs/invenio-YWY9aZyz/lib/python3.8/site-packages/flask_alembic/extension.py", line 236, in run_migrations env.run_migrations(**kwargs) File "/home/openmrs/.local/share/virtualenvs/invenio-YWY9aZyz/lib/python3.8/site-packages/alembic/runtime/environment.py", line 865, in run_migrations self.get_context().run_migrations(**kw) File "/home/openmrs/.local/share/virtualenvs/invenio-YWY9aZyz/lib/python3.8/site-packages/alembic/runtime/migration.py", line 611, in run_migrations for step in self._migrations_fn(heads, self): File "/home/openmrs/.local/share/virtualenvs/invenio-YWY9aZyz/lib/python3.8/site-packages/flask_alembic/extension.py", line 325, in do_upgrade return self.script_directory._upgrade_revs(target, revision) File "/home/openmrs/.local/share/virtualenvs/invenio-YWY9aZyz/lib/python3.8/site-packages/alembic/script/base.py", line 439, in _upgrade_revs return [ File "/usr/lib/python3.8/contextlib.py", line 131, in __exit__ self.gen.throw(type, value, traceback) File "/home/openmrs/.local/share/virtualenvs/invenio-YWY9aZyz/lib/python3.8/site-packages/alembic/script/base.py", line 267, in _catch_revision_errors raise util.CommandError(err.args[0]) from err alembic.util.exc.CommandError: Requested revision 41157f1933d6 overlaps with other requested revisions eb9743315a9d </code></pre> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="0" /> <span class='post-likes'></span> </div> </div> <div id='post_9' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" rel='nofollow' href='https://invenio-talk.web.cern.ch/u/maadeoli'><span itemprop='name'>maadeoli</span></a> </span> <span class="crawler-post-infos"> <time itemprop='datePublished' datetime='2023-01-11T13:19:20Z' class='post-time'> 11 January 2023 13:19 </time> <meta itemprop='dateModified' content='2023-01-11T13:25:59Z'> <span itemprop='position'>9</span> </span> </div> <div class='post' itemprop='text'> <p>Hello!</p> <p>Did you try to restore the database at some point?</p> <p>Can you provide us with the current migrations installed in your system? We can have a look and take it from there. To do so, run the following commands:</p> <p>List current heads:</p> <pre data-code-wrap="terminal"><code class="lang-plaintext">invenio alembic heads </code></pre> <p>then access the database and list all the alembic versions:</p> <pre data-code-wrap="terminal"><code class="lang-plaintext">psql -U <name_of_your_instance> <instance_name>=# SELECT * FROM alembic_version; </code></pre> <p>lastly, paste both results here.</p> <p>Thank you! <img src="https://invenio-talk.web.cern.ch/images/emoji/twitter/slight_smile.png?v=12" title=":slight_smile:" class="emoji" alt=":slight_smile:" loading="lazy" width="20" height="20"></p> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="0" /> <span class='post-likes'></span> </div> </div> <div id='post_10' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" rel='nofollow' href='https://invenio-talk.web.cern.ch/u/GabomaGeek'><span itemprop='name'>GabomaGeek</span></a> </span> <span class="crawler-post-infos"> <time itemprop='datePublished' datetime='2023-01-11T14:15:00Z' class='post-time'> 11 January 2023 14:15 </time> <meta itemprop='dateModified' content='2023-01-11T14:15:00Z'> <span itemprop='position'>10</span> </span> </div> <div class='post' itemprop='text'> <p><code>invenio alembic heads</code></p> <pre><code class="lang-auto">dbdbc1b19cf2 -> 35c1075e6360 (default) (effective head), Force naming convention. 2da9a03b0833 (2e97565eba72, 862037093962) -> 1ba76da94103 (default, invenio_records_files) (head), Create records files tables. 676dd587542d -> e1146238edd3 (invenio_vocabularies) (head), Create awards table. 862037093962 -> 07fb52561c5c (invenio_records) (head), Alter column from json to jsonb. bff1f190b9bd (62efc52773d4) -> aaa265b0afa6 (default, invenio_oauthclient) (head), Move UserIdentity to accounts. dbe499bfda43 -> 04480be1593e (invenio_access) (head), Add ActionSystemRoles. 5b478fe7ef7f -> a3f5a8635cbb (invenio_communities) (head), Remove version table. 12a88921ada2 -> 4e57407b8e4a (default, invenio_oauth2server) (head), Add on delete cascade. 8ae99b034410 -> a29271fd78f8 (invenio_files_rest) (head), Create files object partial unique index. e655021de0de -> 5d25c1981985 (invenio_oaiserver) (head), Add system_created field. 5cd30a3503c9 -> a14fa442680f (invenio_requests) (effective head), Create tables. 8ed1a438601c, 88d1463de5c0 (de9c14cbb0b2, a14fa442680f) -> 9e0ac518b9df (invenio_rdm_records) (head) (mergepoint), Create records/communities M2M table. 88d1463de5c0 -> a3957490361d (invenio_rdm_records) (head), Remove PIDRelations tables. 62efc52773d4 -> eb9743315a9d (invenio_accounts) (effective head), Add user profile and preferences as JSON fields to the User table. f615cee99600 -> 999c62899c20 (invenio_pidstore) (head), Create pidstore tables. c25ef2c50ffa (eb9743315a9d) -> 41157f1933d6 (invenio_userprofiles) (head), Remove table. </code></pre> <p>and</p> <p><code>SELECT * FROM alembic_version</code></p> <pre><code class="lang-auto">version_num -------------- 1ba76da94103 9e0ac518b9df a3957490361d 4e57407b8e4a a29271fd78f8 e655021de0de 04480be1593e 999c62899c20 07fb52561c5c a3f5a8635cbb aaa265b0afa6 eb9743315a9d 41157f1933d6 e1146238edd3 </code></pre> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="0" /> <span class='post-likes'></span> </div> </div> <div id='post_11' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" rel='nofollow' href='https://invenio-talk.web.cern.ch/u/maadeoli'><span itemprop='name'>maadeoli</span></a> </span> <span class="crawler-post-infos"> <time itemprop='datePublished' datetime='2023-01-12T13:31:37Z' class='post-time'> 12 January 2023 13:31 </time> <meta itemprop='dateModified' content='2023-01-12T14:59:54Z'> <span itemprop='position'>11</span> </span> </div> <div class='post' itemprop='text'> <aside class="quote no-group" data-username="GabomaGeek" data-post="10" data-topic="274"> <div class="title"> <div class="quote-controls"></div> <img loading="lazy" alt="" width="24" height="24" src="https://invenio-talk.web.cern.ch/letter_avatar_proxy/v4/letter/g/df705f/48.png" class="avatar"> GabomaGeek:</div> <blockquote> <pre><code class="lang-auto">1ba76da94103 9e0ac518b9df a3957490361d 4e57407b8e4a a29271fd78f8 e655021de0de 04480be1593e 999c62899c20 07fb52561c5c a3f5a8635cbb aaa265b0afa6 eb9743315a9d 41157f1933d6 e1146238edd3 </code></pre> </blockquote> </aside> <p>I fear your database migrations are currently in an inconsistent state. I have run the migration from a fresh instance and I got the following versions in the database:</p> <pre><code class="lang-auto">1ba76da94103 9e0ac518b9df a3957490361d 4e57407b8e4a a29271fd78f8 04480be1593e 999c62899c20 07fb52561c5c a3f5a8635cbb aaa265b0afa6 41157f1933d6 e1146238edd3 5d25c1981985 </code></pre> <p>As you can see, I do not have the following migrations:</p> <pre><code class="lang-auto">e655021de0de eb9743315a9d </code></pre> <p>And you do not have the following:</p> <pre><code class="lang-auto">5d25c1981985 </code></pre> <p>EDIT: it seems that the migration <code>e655021de0de</code> did not upgrade to <code>5d25c1981985</code>. They are from <code>invenio-oaiserver</code> (see <a href="https://github.com/search?q=org%3Ainveniosoftware+repo%3Ainveniosoftware%2Finvenio-oaiserver++e655021de0de&type=code" rel="noopener nofollow ugc">code</a>) Thus, the difference.</p> <p>Did you try to restore the database to an older version at some point? If so, it might have caused the issue.</p> <p>Is your data safe to be wiped? If so, you can simply wipe it and run an upgrade again. To do so:</p> <pre><code class="lang-auto">invenio db drop invenio alembic upgrade </code></pre> <p>If the data is not meant to be wiped (e.g. production data), please let me know and we can try to fix the migrations using alembic solely.</p> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="0" /> <span class='post-likes'></span> </div> </div> <div id='post_12' itemprop='comment' itemscope itemtype='http://schema.org/Comment' class='topic-body crawler-post'> <div class='crawler-post-meta'> <span class="creator" itemprop="author" itemscope itemtype="http://schema.org/Person"> <a itemprop="url" rel='nofollow' href='https://invenio-talk.web.cern.ch/u/GabomaGeek'><span itemprop='name'>GabomaGeek</span></a> </span> <span class="crawler-post-infos"> <time itemprop='datePublished' datetime='2023-01-13T11:06:01Z' class='post-time'> 13 January 2023 11:06 </time> <meta itemprop='dateModified' content='2023-01-13T11:06:01Z'> <span itemprop='position'>12</span> </span> </div> <div class='post' itemprop='text'> <p>It is a development environment. I followed your instructions and everything is fine now. Thanks you</p> </div> <div itemprop="interactionStatistic" itemscope itemtype="http://schema.org/InteractionCounter"> <meta itemprop="interactionType" content="http://schema.org/LikeAction"/> <meta itemprop="userInteractionCount" content="1" /> <span class='post-likes'>1 Like</span> </div> </div> </div> </div> <footer class="container wrap"> <nav class='crawler-nav'> <ul> <li itemscope itemtype='http://schema.org/SiteNavigationElement'> <span itemprop='name'> <a href='/' itemprop="url">Home </a> </span> </li> <li itemscope itemtype='http://schema.org/SiteNavigationElement'> <span itemprop='name'> <a href='/categories' itemprop="url">Categories </a> </span> </li> <li itemscope itemtype='http://schema.org/SiteNavigationElement'> <span itemprop='name'> <a href='/guidelines' itemprop="url">Guidelines </a> </span> </li> <li itemscope itemtype='http://schema.org/SiteNavigationElement'> <span itemprop='name'> <a href='/tos' itemprop="url">Terms of Service </a> </span> </li> <li itemscope itemtype='http://schema.org/SiteNavigationElement'> <span itemprop='name'> <a href='/privacy' itemprop="url">Privacy Policy </a> </span> </li> </ul> </nav> <p class='powered-by-link'>Powered by <a href="https://www.discourse.org">Discourse</a>, best viewed with JavaScript enabled</p> </footer> <div class="buorg"><div>Unfortunately, <a href="https://www.discourse.org/faq/#browser">your browser is unsupported</a>. Please <a href="https://browsehappy.com">switch to a supported browser</a> to view rich content, log in and reply.</div></div> </body> </html>