{"id":644,"date":"2013-12-24T11:15:17","date_gmt":"2013-12-24T11:15:17","guid":{"rendered":"http:\/\/10sa.com\/sql_stories\/?p=644"},"modified":"2013-12-24T11:15:17","modified_gmt":"2013-12-24T11:15:17","slug":"firebird-downgrade-to-1-5-6-problem","status":"publish","type":"post","link":"http:\/\/10sa.com\/sql_stories\/?p=644","title":{"rendered":"Firebird: downgrade to 1.5.6 problem"},"content":{"rendered":"<p>gbak: creating indexes<br \/>\ngbak: ERROR: invalid request BLR at offset 2129<br \/>\ngbak: ERROR: BLR syntax error: expected invalid BLR code at offset 2129, encountered 181<br \/>\ngbak: Exiting before completion due to errors<\/p>\n<p>How to repeat:<br \/>\nBackup (with gbak from version 1.5) only metadata (-m option), e.g.<br \/>\n\/opt\/firebird\/bin\/gbak1.5 -m -g -l -b -k -e -v -t -user sysdba -password $YourPasswd \/source\/database.gdb \/backup\/database.bck<br \/>\nRestore newly created backup file:<br \/>\n\/opt\/firebird\/bin\/gbak -r -c -g -l -o -n -one_at_a_time -verbose -user sysdba -password $YourPasswd \/backup\/database.bck \/databases\/database.gdb<\/p>\n<p>How to solve:<br \/>\nOpen newly created database with IBExpert. Open context menu at Procedures and choose Deactivate procedures -> Deactivate All Stored Procedures. The same thing concerns (context menu on Triggers and choose Deactivate triggers -> Deactivate All Triggers).<br \/>\nMake backup of this database and restore with tools from version 1.5 of Firebird. Open it with IBExpert and the same way you deactivated try to activate your procedures and triggers. Uncompatible structures are to be revealed.<\/p>\n<p>If the problem still occures comment all procedures, backup database together with data and restore it. When restore is ready activate all procedures.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>gbak: creating indexes gbak: ERROR: invalid request BLR at offset 2129 gbak: ERROR: BLR syntax error: expected invalid BLR code at offset 2129, encountered 181 gbak: Exiting before completion due to errors How to repeat: Backup (with gbak from version 1.5) only metadata (-m option), e.g. \/opt\/firebird\/bin\/gbak1.5 -m -g -l -b -k -e -v -t [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6],"tags":[],"_links":{"self":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts\/644"}],"collection":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=644"}],"version-history":[{"count":5,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts\/644\/revisions"}],"predecessor-version":[{"id":661,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=\/wp\/v2\/posts\/644\/revisions\/661"}],"wp:attachment":[{"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=644"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/10sa.com\/sql_stories\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}