https://linen.dev logo
Join Slack
Powered by
Good beginning of week everyone! I've been gettin...
# troubleshooting
s
Good beginning of week everyone! I've been getting this issue on meltano 
no such revision or branch '<branch id>'
, and I'm unsure what it is and how it's affecting my project. It almost seems to act as a warning, because as far as I can tell, it does not hinder my pipeline. Any ideas? Full error log in comments
Copy code
2022-05-02T15:44:42.493466Z [info     ] Environment 'dev' is active
2022-05-02T15:44:42.539482Z [error    ] No such revision or branch '13e8639c6d2b' 
Traceback (most recent call last):
  File "/home/stephane/Documents/projects/meltano-projects/meltano/.venv/lib/python3.8/site-packages/meltano/core/migration_service.py", line 89, in upgrade
    self.ensure_migration_needed(script, context, head)
  File "/home/stephane/Documents/projects/meltano-projects/meltano/.venv/lib/python3.8/site-packages/meltano/core/migration_service.py", line 55, in ensure_migration_needed
    for rev in script.iterate_revisions(current_head, "base"):
  File "/home/stephane/Documents/projects/meltano-projects/meltano/.venv/lib/python3.8/site-packages/alembic/script/revision.py", line 789, in iterate_revisions
    revisions, heads = fn(
  File "/home/stephane/Documents/projects/meltano-projects/meltano/.venv/lib/python3.8/site-packages/alembic/script/revision.py", line 1389, in _collect_upgrade_revisions
    targets: Collection["Revision"] = self._parse_upgrade_target(
  File "/home/stephane/Documents/projects/meltano-projects/meltano/.venv/lib/python3.8/site-packages/alembic/script/revision.py", line 1189, in _parse_upgrade_target
    return self.get_revisions(target)
  File "/home/stephane/Documents/projects/meltano-projects/meltano/.venv/lib/python3.8/site-packages/alembic/script/revision.py", line 549, in get_revisions
    return tuple(
  File "/home/stephane/Documents/projects/meltano-projects/meltano/.venv/lib/python3.8/site-packages/alembic/script/revision.py", line 550, in <genexpr>
    self._revision_for_ident(rev_id, branch_label)
  File "/home/stephane/Documents/projects/meltano-projects/meltano/.venv/lib/python3.8/site-packages/alembic/script/revision.py", line 619, in _revision_for_ident
    raise ResolutionError(
alembic.script.revision.ResolutionError: No such revision or branch '13e8639c6d2b'
Cannot upgrade the system database. It might be corrupted or was created before database migrations where introduced (v0.34.0)
Legend:
        selected
        excluded
        automatic

Enabled patterns:
        contacts.*
e
Hi @Stéphane Burwash! What version of Meltano are you on?
(this might be related to recent changes to state mgmt that required some db migrations iirc)
s
1.101.0
I made the upgrade as soon as I saw the cool state management feature 😉
e
@cody_hanson could this be related to the 
meltano state
changes?
c
Yeah it seems like it is probably related--that 
13e8639c6d2b
is the revision ID for the job table migration. @Stéphane Burwash is this a pre-existing install that you upgraded via 
meltano upgrade
?
s
From what I recall, I simply popped up the ui and clicked on the update button
The error also seems to have just disappeared after multiple 
sudo rm -r .meltano
and 
meltano install
, so I'll keep you updated on if it happens again
c
Glad it's working now. If you see the same behavior again, would you mind filing an issue in Gitlab?
Open in Slack
PreviousNext
Powered by