You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
the 2nd gbak command produces this output (only the last lines)
........
gbak:creating indexes
gbak: activating and creating deferred index RDB$PRIMARY1
gbak:cannot commit index RDB$PRIMARY1
gbak: ERROR:connection lost to database
gbak: ERROR:Error writing data to the connection.
gbak:Exiting before completion due to errors
gbak: ERROR:Error writing data to the connection.
Confirmed crash of restoring on WI-V2.5.2.26540: message about abnnormal program termination appeared.
No any troubles on 2.5.3 and above, including 3.0.
The text was updated successfully, but these errors were encountered:
I found 2 ways to prevent the error.
1.) change the default collation to WIN1252
CREATE DATABASE 'leer.DB' USER 'SYSDBA' PASSWORD 'masterkey' DEFAULT CHARACTER SET WIN1252 collation WIN1252;
2.) modify the key size
CREATE TABLE TABZL (ZLKENNZ VARCHAR(4) NOT NULL,PRIMARY KEY (ZLKENNZ));
The problem is I have this database in a productive environment. I need to know whether the error is in the core engine or only in the gbak utility?
Test Details: Confirmed crash of restoring on WI-V2.5.2.26540: message about abnnormal program termination appeared.
No any troubles on 2.5.3 and above, including 3.0.
Submitted by: Oliver Wurdak (wurdak23)
Is related to QA610
I create a database with the following isql script. (CreateErrorDB.sql)
in the reduced table (1 field ,1 record) the value is XXÄ (german umlaut A)
CREATE DATABASE 'leer.DB' USER 'SYSDBA' PASSWORD 'masterkey' DEFAULT CHARACTER SET WIN1252 collation PXW_INTL;
CREATE TABLE TABZL (ZLKENNZ VARCHAR(3) NOT NULL,PRIMARY KEY (ZLKENNZ));
INSERT INTO TABZL (ZLKENNZ) VALUES ('XXÄ');
this batchjob produces the error:
"%PROGRAMFILES%\Firebird\Firebird_2_5\bin\isql.exe" -q -i CreateErrorDB.sql
"%PROGRAMFILES%\Firebird\Firebird_2_5\bin\gbak.exe" -b leer.db test.fbak -USER SYSDBA -pas masterkey
"%PROGRAMFILES%\Firebird\Firebird_2_5\bin\gbak.exe" -v -user SYSDBA -pas masterkey -C test.fbak test.db
the 2nd gbak command produces this output (only the last lines)
........
gbak:creating indexes
gbak: activating and creating deferred index RDB$PRIMARY1
gbak:cannot commit index RDB$PRIMARY1
gbak: ERROR:connection lost to database
gbak: ERROR:Error writing data to the connection.
gbak:Exiting before completion due to errors
gbak: ERROR:Error writing data to the connection.
Commits: 49a4e33 d5d8292 FirebirdSQL/fbt-repository@326c62c FirebirdSQL/fbt-repository@fbe44dd
====== Test Details ======
Confirmed crash of restoring on WI-V2.5.2.26540: message about abnnormal program termination appeared.
No any troubles on 2.5.3 and above, including 3.0.
The text was updated successfully, but these errors were encountered: