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
