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

Fix Sakilla schema restore bug #15

Open
rocket-3 opened this issue Jun 11, 2021 · 0 comments · May be fixed by #16
Open

Fix Sakilla schema restore bug #15

rocket-3 opened this issue Jun 11, 2021 · 0 comments · May be fixed by #16
Assignees
Labels
bug Something isn't working

Comments

@rocket-3
Copy link
Collaborator

@rultor deploy, tests=*IntegrationTest*#*CustomTypes*

@rocket-3 Oops, I failed. You can see the full log here (spent 4min)

|   >             Restoring indexes for table public/payment.tbl ... OK
|   >         Restoring function public/_group_concat.fnc ... OK
|   >         Restoring function public/film_in_stock.fnc ... OK03:13 ERROR [App.java:41] : Error execute dbgit
|   > ru.fusionsoft.dbgit.core.ExceptionDBGitRestore: Restore objects error
|   >   at ru.fusionsoft.dbgit.adapters.DBAdapter.restoreDataBase(DBAdapter.java:160)
|   >   at ru.fusionsoft.dbgit.core.GitMetaDataManager.restoreDataBase(GitMetaDataManager.java:384)
|   >   at ru.fusionsoft.dbgit.command.CmdRestore.execute(CmdRestore.java:183)
|   >   at ru.fusionsoft.dbgit.App.executeDbGitCommand(App.java:57)
|   >   at ru.fusionsoft.dbgit.App.main(App.java:29)
|   > Caused by: ru.fusionsoft.dbgit.core.ExceptionDBGitRestore: Error restore public/film_in_stock.fnc
|   >   at ru.fusionsoft.dbgit.postgres.DBRestoreFunctionPostgres.restoreMetaObject(DBRestoreFunctionPostgres.java:73)
|   >   at ru.fusionsoft.dbgit.adapters.DBAdapter.restoreDataBase(DBAdapter.java:140)
|   >   ... 4 common frames omitted
|   > Caused by: org.postgresql.util.PSQLException: ERROR: function inventory_in_stock(integer) does not exist
|   >   Hint: No function matches the given name and argument types. You might need to add explicit type casts.
|   >   at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266)
|   >   at ru.fusionsoft.dbgit.statement.StatementLogging.execute(StatementLogging.java:178)
|   >   at ru.fusionsoft.dbgit.postgres.DBRestoreFunctionPostgres.restoreMetaObject(DBRestoreFunctionPostgres.java:61)
|   >   ... 5 common frames omitted
|   java.lang.Exception: Process exited with error, code 1
Fri Jun 11 05:14:36 CEST 2021
@rocket-3 rocket-3 added the bug Something isn't working label Jun 11, 2021
@rocket-3 rocket-3 added this to the Production-ready milestone Jun 11, 2021
@rocket-3 rocket-3 linked a pull request Jun 11, 2021 that will close this issue
@rocket-3 rocket-3 self-assigned this Jun 12, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant