Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

gbak: cannot commit index ; primary key with german umlaut [CORE4417] #4739

Closed
firebird-issue-importer opened this issue May 2, 2014 · 4 comments

Comments

@firebird-issue-importer
Copy link

firebird-issue-importer commented May 2, 2014

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.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 2, 2014

Commented by: Oliver Wurdak (wurdak23)

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?

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 12, 2014

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5.3 [ 10461 ]

Fix Version: 3.0 Beta 1 [ 10332 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 3, 2015

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: Done successfully

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.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Sep 25, 2015

Modified by: @pcisar

Link: This issue is related to QA610 [ QA610 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment