search

pilosus / dienstplan

Slack bot app for duty rotations
https://dienstplan-slack.pilosus.org
Other
21 stars 1 forks source link

[TECH] When DB user has no DDL permissions, migration fails silently #104

Closed pilosus closed 6 months ago

pilosus commented 11 months ago

Steps to repdoduce:

  1. Get a DB up & running with user that has no DDL permissions
  2. Run migration job with the user creds
  3. Job fails silently (setting loglevel to DEBUG doesn't help)
[...]
14:20:16,401 |-INFO in ch.qos.logback.classic.util.ContextInitializer@62891fc8 - ch.qos.logback.classic.util.DefaultJoranConfigurator.configure() call lasted 114 milliseconds. ExecutionStatus=DO_NOT_INVOKE_NEXT_IF_ANY
2023-10-20 14:20:17,188 [main] INFO  org.eclipse.jetty.util.log - Logging initialized @1808ms to org.eclipse.jetty.util.log.Slf4jLog
2023-10-20 14:20:17,476 [main] INFO  com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
2023-10-20 14:20:18,287 [main] INFO  com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@11c999da
2023-10-20 14:20:18,289 [main] INFO  com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.

pilosus@fedora:~/git/dienstplan$ echo $?
1

Obviously, we want verbose failure

pilosus commented 6 months ago

Cannot reproduce locally anymore. Reopen the issue if occurs anew