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
