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

Exception about duplicated metadata could be more informative [CORE1871] #2302

Open
firebird-automations opened this issue Apr 28, 2008 · 3 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Attid (attid)

Votes: 2

some exception can be more informative for sample

DO
CREATE INDEX COUNTRY_IDX1 ON COUNTRY (CURRENCY);
CREATE INDEX COUNTRY_IDX1 ON COUNTRY (CURRENCY);
GET
This operation is not defined for system tables. unsuccessful metadata update. STORE RDB$INDICES failed. attempt to store duplicate value (visible to active transactions) in unique index «RDB$INDEX_5»

DO
CREATE generator test;
CREATE generator test;
GET
This operation is not defined for system tables. unsuccessful metadata update. DEFINE GENERATOR failed. attempt to store duplicate value (visible to active transactions) in unique index «RDB$INDEX_11».

DO
CREATE TABLE test(x int, x varchar(30));
GET
This operation is not defined for system tables. unsuccessful metadata update. STORE RDB$RELATION_FIELDS failed. attempt to store duplicate value (visible to active transactions) in unique index «RDB$INDEX_15».

DO
CREATE procedure test (t int) returns (t varchar(30)) AS begin end;
GET
This operation is not defined for system tables. unsuccessful metadata update. STORE RDB$PROCEDURE_PARAMETERS failed. attempt to store duplicate value (visible to active transactions) in unique index «RDB$INDEX_18».

DO
CREATE domain test smallint; CREATE domain test smallint;
GET
This operation is not defined for system tables. unsuccessful metadata update. STORE RDB$FIELDS failed. attempt to store duplicate value (visible to active transactions) in unique index «RDB$INDEX_2».

DO
CREATE TRIGGER country_bi0 FOR country active before INSERT position 0 AS begin /* Trigger text */ end;
CREATE TRIGGER country_bi0 FOR country active before INSERT position 0 AS begin /* Trigger text */ end;
GET
This operation is not defined for system tables. unsuccessful metadata update. DEFINE TRIGGER failed. attempt to store duplicate value (visible to active transactions) in unique index «RDB$INDEX_8».

DO
DECLARE EXTERNAL FUNCTION DIV INTEGER, INTEGER RETURNS DOUBLE PRECISION BY VALUE ENTRY_POINT 'IB_UDF_div' MODULE_NAME 'ib_udf';
DECLARE EXTERNAL FUNCTION DIV INTEGER, INTEGER RETURNS DOUBLE PRECISION BY VALUE ENTRY_POINT 'IB_UDF_div' MODULE_NAME 'ib_udf';
GET
This operation is not defined for system tables. unsuccessful metadata update. DEFINE FUNCTION failed. attempt to store duplicate value (visible to active transactions) in unique index «RDB$INDEX_9».

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

issuetype: Bug [ 1 ] => Improvement [ 4 ]

Component: Engine [ 10000 ]

summary: exeption aboute dublicate metadata can be more informative => Exception about duplicate metadata could be more informative

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

summary: Exception about duplicate metadata could be more informative => Exception about duplicated metadata could be more informative

@firebird-automations
Copy link
Collaborator Author

Commented by: Robert Gilland (robert.gilland_basx.com.au)

This forces a restore to fail.
It should never fail a restore.
Just whatever task it is, log an error and keep going!

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

1 participant