Bug#907392:
Dam, it was my thread on the subject, before Mark adviced me to post here. I'll try fbcopy / fbexport as backup . Regards
Bug#907392: firebird3.0-utils: tables with varchar attributes with big size cannot be backed up with gbak on armel
Control: severity -1 important Control: tags -1 upstream confirmed Control: subject -1 firebird3.0-utils: [armel] varchar(32765) cannot be backed up or restored with gbak -=| Pablo Sánchez[gmail], 27.08.2018 10:06:49 -0300 |=- > Package: firebird3.0-utils > Version: 3.0.3.32900.ds4-4 > Severity: grave > Justification: renders package unusable (kind of) Severity descriptions: * grave makes the package in question unusable or mostly so, or causes data loss, or introduces a security hole allowing access to the accounts of users who use the package. * important a bug which has a major effect on the usability of a package, without rendering it completely unusable to everyone. I don't think that gbak problems on armel fall in the first category. > 1- create database, and insert on column (using raspbian) > > SQL> create database '/srv/data/debian-test.fdb' > CON> user 'SYSDBA' > CON> password 'masterkey' > CON> page_size 8192 > CON> default character set iso8859_1; > SQL> commit ; > SQL> exit ; > > 2- create a table with a big size varchar and insert data into it . > CREATE TABLE TEST > ( > ID INTEGER, > VC VARCHAR(32765) > ); > > INSERT INTO TABLE1 (ID, TEXT) VALUES ('1', 'abcdef123456'); > > 3- backup database > > root@raspberrypi:/srv/data# gbak -b -v -user SYSDBA -password masterkey > /srv/data/debian-test.fdb /srv/data/debian-test.fbk > gbak:readied database /srv/data/debian-test.fdb for backup > gbak:creating file /srv/data/debian-test.fbk > gbak:starting transaction > ... > gbak:writing packages > gbak:writing data for table TABLE1 > gbak: ERROR:message length error (encountered -32758, expected 32778) > gbak: ERROR:gds_$receive failed > gbak:Exiting before completion due to errors > > Note that if I create db on amd64 and restore on raspberrypi, I get the > same error . > But if create db on amd64 and restore on amd64 there is no error and data > is there. > I use buster now, but on v2.5 on stretch had the same problem. After > posting on > firebrid-support , I was suggested to post here. For reference, this is the thread: https://groups.yahoo.com/neo/groups/firebird-support/conversations/topics/132945 I can reproduce the issue on abel.debian.org (armel/buster). No idea yet what could be the cause. -- dam
Bug#907392: firebird3.0-utils: tables with varchar attributes with big size cannot be backed up with gbak
Package: firebird3.0-utils Version: 3.0.3.32900.ds4-4 Severity: grave Justification: renders package unusable (kind of) 1- create database, and insert on column (using raspbian) SQL> create database '/srv/data/debian-test.fdb' CON> user 'SYSDBA' CON> password 'masterkey' CON> page_size 8192 CON> default character set iso8859_1; SQL> commit ; SQL> exit ; 2- create a table with a big size varchar and insert data into it . CREATE TABLE TEST ( ID INTEGER, VC VARCHAR(32765) ); INSERT INTO TABLE1 (ID, TEXT) VALUES ('1', 'abcdef123456'); 3- backup database root@raspberrypi:/srv/data# gbak -b -v -user SYSDBA -password masterkey /srv/data/debian-test.fdb /srv/data/debian-test.fbk gbak:readied database /srv/data/debian-test.fdb for backup gbak:creating file /srv/data/debian-test.fbk gbak:starting transaction gbak:database /srv/data/debian-test.fdb has a page size of 8192 bytes. gbak:writing domains gbak:writing domain RDB$1 gbak:writing domain RDB$2 gbak:writing shadow files gbak:writing character sets gbak:writing collations gbak:writing tables gbak:writing table TABLE1 gbak: writing column ID gbak: writing column TEXT gbak:writing types gbak:writing filters gbak:writing id generators gbak:writing exceptions gbak:writing functions gbak:writing stored procedures gbak:writing packages gbak:writing data for table TABLE1 gbak: ERROR:message length error (encountered -32758, expected 32778) gbak: ERROR:gds_$receive failed gbak:Exiting before completion due to errors Note that if I create db on amd64 and restore on raspberrypi, I get the same error . But if create db on amd64 and restore on amd64 there is no error and data is there. I use buster now, but on v2.5 on stretch had the same problem. After posting on firebrid-support , I was suggested to post here. -- System Information: Distributor ID:Raspbian Description:Raspbian GNU/Linux testing (buster) Release:testing Codename:buster Architecture: armv7l Kernel: Linux 4.14.62-v7+ (SMP w/4 CPU cores) Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8), LANGUAGE=en_GB.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system) Versions of packages firebird3.0-utils depends on: ii firebird3.0-common 3.0.3.32900.ds4-4 ii firebird3.0-common-doc 3.0.3.32900.ds4-4 ii libc6 2.27-5+rpi1 ii libedit23.1-20180525-1 ii libfbclient23.0.3.32900.ds4-4 ii libgcc1 1:8.1.0-12+rpi1 ii libncurses6 6.1+20180714-1 ii libstdc++6 8.1.0-12+rpi1 ii libtinfo6 6.1+20180714-1 ii libtommath1 1.0.1-1 Versions of packages firebird3.0-utils recommends: ii firebird3.0-server-core 3.0.3.32900.ds4-4 Versions of packages firebird3.0-utils suggests: pn firebird3.0-doc ii firebird3.0-server 3.0.3.32900.ds4-4 -- no debconf information Regards Pablo Sánchez