I've started to see an error on a couple of projec...
# announcements
a
I've started to see an error on a couple of projects when
meltano install
is run:
Copy code
Cannot upgrade the system database. It might be corrupted or was created before database migrations where introduced (v0.34.0)
and what looks like the root cause:
Copy code
sqlite3.OperationalError: no such table: role
Any ideas what might produce that error?
A little further down:
Copy code
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such table: role
[SQL: SELECT role.id AS role_id, role.name AS role_name, role.description AS role_description 
FROM role 
WHERE role.name = ?
LIMIT ? OFFSET ?]
[parameters: ('admin', 1, 0)]
d
@adam_roderick Are you also seeing errors related to
alembic
by any chance?
I fixed the incompatibility in https://gitlab.com/meltano/meltano/-/merge_requests/2002, which hasn't gone into a release yet, but already moved back to alembic 1.4.x in https://gitlab.com/meltano/meltano/-/commit/1e15eb0f223fd1fce7224d077d57c0287e8f916d which went into v1.66.0
a
Confirmed upgrading to 1.66.0 resolved the issue. Thanks, @douwe_maan
d
Awesome!