Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Connecting ApicurioStudio to Postgresql fails running non-postgres migrations #2218

Open
andreaTP opened this issue Jun 20, 2023 Discussed in #2217 · 2 comments
Open

Connecting ApicurioStudio to Postgresql fails running non-postgres migrations #2218

andreaTP opened this issue Jun 20, 2023 Discussed in #2217 · 2 comments
Assignees

Comments

@andreaTP
Copy link
Member

Seems like the migrations are not run for the correct DB type:

Discussed in #2217

Originally posted by SkyTaill June 20, 2023
Hi,
I have some problem with apicurio-api service - some problem with connect to Postgresql. what could be the problem?

  • postgres:15.2
  • apicurio-studio-platforms-quarkus-api 0.2.62

2023-06-20 10:30:53,587 ERROR [io.und.req.io] (executor-thread-0) Exception handling request 9378c0fb-3099-4e19-b518-c798b60ac8cc-1 to /currentuser/activity: org.jboss.resteasy.spi.UnhandledException: org.jdbi.v3.core.statement.UnableToExecuteStatementException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "AUTO_INCREMENT"
Position: 37 [statement:"CREATE TABLE api_designs (id BIGINT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, description VARCHAR(1024), created_by VARCHAR(255) NOT NULL, created_on TIMESTAMP NOT NULL, tags VARCHAR(2048), api_type VARCHAR(255) NOT NULL)", arguments:{positional:{}, named:{}, finder:[]}]

image
@EricWittmann EricWittmann self-assigned this Jun 21, 2023
@EricWittmann
Copy link
Member

2023-06-20 10:30:53,587 ERROR [io.und.req.io] (executor-thread-0) Exception handling request 9378c0fb-3099-4e19-b518-c798b60ac8cc-1 to /currentuser/activity: org.jboss.resteasy.spi.UnhandledException: org.jdbi.v3.core.statement.UnableToExecuteStatementException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "AUTO_INCREMENT"
Position: 37 [statement:"CREATE TABLE api_designs (id BIGINT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, description VARCHAR(1024), created_by VARCHAR(255) NOT NULL, created_on TIMESTAMP NOT NULL, tags VARCHAR(2048), api_type VARCHAR(255) NOT NULL)", arguments:{positional:{}, named:{}, finder:[]}]

@EricWittmann
Copy link
Member

@SkyTaill any chance you could include the full stack trace? It's cut off in the screenshot and the full trace (with any "caused by" traces) would be helpful.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants