https://linen.dev logo
Join Slack
Powered by
Hello all - I have a strange issue in my installat...
# troubleshooting
i
Hello all - I have a strange issue in my installation of meltano - error inside of the thread. this happens when I do a meltano install --force
installing all meltano parts for dvload 2024-10-30T091124.740917Z [error ] (psycopg.errors.InvalidSchemaName) no schema has been selected to create in LINE 2: CREATE TABLE alembic_version ( ^ [SQL: CREATE TABLE alembic_version ( version_num VARCHAR(32) NOT NULL, CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num) ) ]
log.log
I have an older version running meltano --version meltano, version 3.1.0
there was no change in plugins, database or anything it just didn't work anymore
v
Smells like an engine_uri change or the user you're using to connect to your database doesn't have a default schema or something like that. Just a guess but I'd guess it's something with that if you could share your URI (redacted) Also I don't think 
--force
is a valid option
i
ah ok I have full control over the database - I use postgresql
The --force option should not be used ?
e
--force
is a valid options but it won't help here. Its help text reads 
Ignore the required Python version declared by the plugins
. Can you try updating your 
database_uri
using https://docs.meltano.com/reference/settings/#targeting-a-postgresql-schema?
i
yes it was the schema - all working well now. thanks a lot for the pointers
👍 1
someone changed the dynamic replacement of the schema and in the automatic deployment the schema was not written to the connection url
😅 1
6 Views
Open in Slack
PreviousNext
Powered by