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

Database-Update 1.5 to 2.0 fails [CORE997] #1408

Closed
firebird-automations opened this issue Nov 12, 2006 · 19 comments
Closed

Database-Update 1.5 to 2.0 fails [CORE997] #1408

firebird-automations opened this issue Nov 12, 2006 · 19 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Ulrich Wagner (schiller)

Relate to QA20
Is duplicated by CORE1049

Attachments:
BUG2.zip

On the "old" system the database has been backed up with gbak without any errors. The attempt to restore the database on the "new " system failed with an error "index size too big". A restore without activating the indices worked without warnings. Here is the DDL of the table without the index:

/******************************************************************************/
/**** Generated by IBExpert 14.11.2006 09:40:33 ****/
/******************************************************************************/

SET SQL DIALECT 3;

SET NAMES WIN1252;

/******************************************************************************/
/**** Tables ****/
/******************************************************************************/

CREATE TABLE VSSCHNIT (
VSS_ART VARCHAR(10) NOT NULL COLLATE PXW_INTL,
VSS_BEMERKUNG VARCHAR(30) default null COLLATE PXW_INTL,
VSS_PROGNAM VARCHAR(30) default null COLLATE PXW_INTL,
VSS_WODAT VARCHAR(100) default null COLLATE PXW_INTL,
VSS_GLVOBNR INTEGER default null,
VSS_SCHREIBW VARCHAR(1) default null COLLATE PXW_INTL,
VSS_ANREDE VARCHAR(1) default null COLLATE PXW_INTL,
VSS_STRASSE_ORT VARCHAR(1) default null COLLATE PXW_INTL,
VSS_HDE_TAB VARCHAR(1) default null COLLATE PXW_INTL,
VSS_HDE_TAB_PRO VARCHAR(8) default null COLLATE PXW_INTL,
VSS_HDE_TRENN VARCHAR(1) default null COLLATE PXW_INTL,
VSS_HDE_OERE INTEGER default null,
VSS_HDE_PRIV INTEGER default null,
VSS_HDE_ALLG INTEGER default null,
VSS_SB_NR INTEGER default null,
VSS_VOA_VB INTEGER default null,
VSS_VOA_VB_WDV SMALLINT default null,
VSS_DRU_VB_BESCHEID VARCHAR(1) default null COLLATE PXW_INTL,
VSS_VOA_AHE INTEGER default null,
VSS_VOA_AHE_WDV SMALLINT default null,
VSS_DRU_AHE_BESCHEID VARCHAR(1) default null COLLATE PXW_INTL,
VSS_AHE_AUTO_GLAU VARCHAR(1) default null COLLATE PXW_INTL,
VSS_POS_8_SUM VARCHAR(1) default null COLLATE PXW_INTL,
VSS_UEAZ_AUTO VARCHAR(1) default null COLLATE PXW_INTL,
VSS_MAHNGEB_SOLL VARCHAR(1) default null COLLATE PXW_INTL,
VSS_SAUM_SOLL VARCHAR(1) default null COLLATE PXW_INTL,
VSS_SAUM_WEITER VARCHAR(1) default null COLLATE PXW_INTL,
VSS_ZAHL_ZURUECK VARCHAR(1) default null COLLATE PXW_INTL,
VSS_ZAHL_RU_DTA VARCHAR(1) default null COLLATE PXW_INTL,
VSS_ZAHL_RU_ART SMALLINT default null,
VSS_ZAHL_D_UEBER VARCHAR(1) default null COLLATE PXW_INTL,
VSS_ZAHL_DU_STATIS VARCHAR(1) default null COLLATE PXW_INTL,
VSS_ZAHL_DU_VB VARCHAR(1) default null COLLATE PXW_INTL,
VSS_SZ_DATUM_JN VARCHAR(1) default null COLLATE PXW_INTL,
VSS_SZ_BIS_DATUM SMALLINT default null,
VSS_VOA_PRIV INTEGER default null,
VSS_VOA_PRIV_WDV SMALLINT default null,
VSS_DRU_PRIV_BESCHEID VARCHAR(1) default null COLLATE PXW_INTL,
VSS_MAHN_GEBTAB SMALLINT default null,
VSS_MAHN_ERMIT VARCHAR(1) default null COLLATE PXW_INTL,
VSS_SZ_NEU VARCHAR(1) default null COLLATE PXW_INTL,
VSS_MG_DATUM_JN VARCHAR(1) default null COLLATE PXW_INTL,
VSS_VOA_VB_NURNF INTEGER default null,
VSS_VOA_VB_NURNF_WDV SMALLINT default null,
VSS_DRU_VB_NURNF_BESCH VARCHAR(1) default null COLLATE PXW_INTL,
VSS_VOA_AHE_NURNF INTEGER default null,
VSS_VOA_AHE_NURNF_WDV SMALLINT default null,
VSS_DRU_AHE_NURNF_BESCH VARCHAR(1) default null COLLATE PXW_INTL,
VSS_VOA_PRIV_NURNF INTEGER default null,
VSS_VOA_PRIV_NURNF_WDV SMALLINT default null,
VSS_DRU_PRIV_NURNF_BESCH VARCHAR(1) default null COLLATE PXW_INTL,
VSS_SBZUO SMALLINT default null,
VSS_SOLLSTNF_VAR VARCHAR(20) default null COLLATE PXW_INTL
);

It is impossible to create an unique index on the field VSS_ART if the data in this field contains some german "Umlaute".

If I start with an empty database in Firebird 2.0, create the table with this DDL and fill it with data. I can create an unique index on VSS_ART without any errors.

Commits: 1c0e423 ac0f122

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

If you can create your index on new database but can't restore existing backup then i guess you have created old database with small page size.
Try change page size at restore using gbak's command line switch : -page_size 4096 ...

@firebird-automations
Copy link
Collaborator Author

Commented by: Ulrich Wagner (schiller)

This is a zipped Firebird 2.0 database. It has been created by an gbak operation from an Firebird 1.5 database. I can't create an unique index on VSS_ART as long as german "Umlaute" in this column.

@firebird-automations
Copy link
Collaborator Author

Modified by: Ulrich Wagner (schiller)

Attachment: BUG2.zip [ 10160 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Ulrich Wagner (schiller)

The Firebird 1.5 database had an page size of 8192. I have restored the database with an page size of 8192.

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

An old bug become more visible.

Try this in 1.5.3:

create table t (c varchar(4) character set win1252 collate pxw_intl);
insert into t values ('????');
commit;
create unique index t_c on t (c);

Statement failed, SQLCODE = -902

internal gds software consistency check (index key too big (174))
Statement failed, SQLCODE = -902

internal gds software consistency check (can't continue after bugcheck)

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 2.0.1 [ 10090 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 2.1 [ 10041 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Link: This issue is duplicated by CORE1049 [ CORE1049 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA20 [ QA20 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

Reopened to update ticket information.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Closed [ 6 ] => Reopened [ 4 ]

resolution: Fixed [ 1 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Fix Version: 2.1 Alpha 1 [ 10150 ]

Fix Version: 2.1.0 [ 10041 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Reopened [ 4 ] => Closed [ 6 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 11310 ] => Firebird [ 15406 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue relate to QA20 [ QA20 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA20 [ QA20 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

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

No branches or pull requests

2 participants