Error restore with gbak
Check_Mail
Hello,
last year, I have extendet a database at the customer far away from my office. After this, I have created a backup and now I wanted to restore this file.
Unfortunately, I get an error:
gbak: ERROR:invalid request BLR at offset 847
gbak: ERROR: Input parameter mismatch for procedure P_AP_10
gbak:Exiting before completion due to errors
I have no Idea why this fails, the stored procedure p_ap_10 works fine on the customer side. How can I fix it? I see not one procedure after the backup.
Thank you.
Check_Mail
Can I fix it or restore it with the wrong reference?
--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/000901d81e62%24de4c72d0%249ae55870%24%40satron.de.
i...@kaabnl.nl
The same issue was posted by myself last saturday (same problem).
Your restore only restored the data, but got an error because of some dependency in stored procedures.
This means that stored procedures and triggers were not restored.
Also deferred indexes were not created.
There will be some dependency that you missed. Export all metadata into TXT, and find the dependencies on procedure P_AP_10.
M.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/001401d81e75%2403fed970%240bfc8c50%24%40satron.de.
Check_Mail
Thanks M,
can I, after I do this, repair the fbk file or should I execute the SQL-Statements?
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/505640c8-df00-e649-2dc0-1382ce928f0e%40kaabnl.nl.
i...@kaabnl.nl
i just executed (re-created) all stored procedures and triggers that i had in a local copy of database.
I don;t know what you can do with the fbk file, sorry.
M.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/001d01d81e76%24231ff220%24695fd660%24%40satron.de.
Check_Mail
How can I export Metadata into txt? Gbak -r -m does not work with this function.
Von: firebird...@googlegroups.com <firebird...@googlegroups.com> Im Auftrag von i...@kaabnl.nl
Gesendet: Donnerstag, 10. Februar 2022 12:53
An: firebird...@googlegroups.com
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/505640c8-df00-e649-2dc0-1382ce928f0e%40kaabnl.nl.
i...@kaabnl.nl
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/002201d81e77%24ff498760%24fddc9620%24%40satron.de.
Check_Mail
Hello,
but I have only the backupfile, how can I extract the metadata from it? The restore fails.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/91224263-1cfa-0e62-8a27-bbbd2c97c223%40kaabnl.nl.
i...@kaabnl.nl
You still have a working database right?
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/002f01d81e79%240a86eb80%241f94c280%24%40satron.de.
Dimitry Sibiryakov
> The restore fails.
It still leaves a partially restored database after that.
--
WBR, SD.
Check_Mail
-----Ursprüngliche Nachricht-----
Von: firebird...@googlegroups.com <firebird...@googlegroups.com> Im Auftrag von Dimitry Sibiryakov
Gesendet: Donnerstag, 10. Februar 2022 13:28
An: firebird...@googlegroups.com
Betreff: Re: AW: AW: AW: [firebird-support] Error restore with gbak
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
Dimitry Sibiryakov
> But I have to restore it and do some extensions.
--
WBR, SD.
Check_Mail
-----Ursprüngliche Nachricht-----
Von: firebird...@googlegroups.com <firebird...@googlegroups.com> Im Auftrag von Dimitry Sibiryakov
An: firebird...@googlegroups.com
Betreff: Re: AW: AW: AW: AW: [firebird-support] Error restore with gbak
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.