https://meltano.com/ logo
#announcements
Title
# announcements
b

bumpy-dog-48208

01/19/2021, 10:55 PM
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?
1
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)]
r

ripe-musician-59933

01/19/2021, 10:57 PM
@bumpy-dog-48208 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
b

bumpy-dog-48208

01/19/2021, 10:59 PM
Confirmed upgrading to 1.66.0 resolved the issue. Thanks, @ripe-musician-59933
r

ripe-musician-59933

01/19/2021, 10:59 PM
Awesome!