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 libedit2 3.1-20180525-1
ii libfbclient2 3.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 <none>
ii firebird3.0-server 3.0.3.32900.ds4-4
-- no debconf information
Regards
Pablo Sánchez
