Archive for the ‘ Firebird ’ Category
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 […]
New problem within the Firebird RDBMS was how to get copy of consice data and not restarting server? I needed to make such backup once a two hours and send it to backup server. In order to do this I used internal “replication” of Firebird called “shadowing“. Creating of shadow copy is the process of […]
Uniquely, downgrade is required. That happened in my production environment. In generally, there is no official tools supporting such operation however I found on some forum solution which I successfuly tested. The clue is to make backup with tool gbak derived from version you wish to downgrade (in my situation it is 1.5.6). First of […]
How to trace Firebird on Linux to discover what queries / procedures are executed, which machines are connected to and more with strace and tcpdump.