Subject | Cannot create tables in new FB 2.5 DB, fails with error 335544351 on commit |
---|---|
Author | peterbelow@ymail.com |
Post date | 2010-12-30T14:11:48Z |
I'm trying to get started with using Firebird.
Downloaded Firebird-2.5.0.26074_1_Win32.exe and used it to install Firebird as "super classic" server (on Windows XP SP3). I was able to create a new user, create a new database, added an alias for it in alias.conf. I can connect to the database using this new account, both with FlameRobin (0.9.2) or ISQL, I can create domains, exceptions, stored procedures.
I cannot create tables, though.
I execute
CREATE TABLE HL_Oids (
OID OidKey NOT NULL PRIMARY KEY
);
in FlameRobin, the execution log (see below) indicates success. I click the commit button and get a metadata update error. The resulting log follows:
Starting transaction...
Preparing query: CREATE TABLE HL_Oids (
OID OidKey NOT NULL PRIMARY KEY
)
Prepare time: 0.031s
Plan not available.
Executing...
Done.
552 fetches, 57 marks, 34 reads, 0 writes.
12 inserts, 2 updates, 0 deletes, 48 index, 2 seq.
Delta memory: 1251124 bytes.
RDB$INDEX_SEGMENTS: 1 inserts.
RDB$INDICES: 1 inserts.
RDB$RELATION_FIELDS: 1 inserts.
RDB$RELATIONS: 1 inserts. 2 updates.
RDB$USER_PRIVILEGES: 5 inserts.
RDB$RELATION_CONSTRAINTS: 2 inserts.
RDB$CHECK_CONSTRAINTS: 1 inserts.
Total execution time: 0.047s
Script execution finished.
Commiting transaction...
*** IBPP::SQLException ***
Context: Transaction::Commit
SQL Message : -607
This operation is not defined for system tables.
Engine Code : 335544351
Engine Message :
unsuccessful metadata update
cannot create index RDB$PRIMARY11
Executing the same create table statement in ISQL results in the same error, worded somewhat differently.
What can be the reason for this behaviour? And how do I get around it?
BTW: the database resides in C:\Daten\Datenbanken\SF\MYLIBRARY.FDB
--
Peter Below
Downloaded Firebird-2.5.0.26074_1_Win32.exe and used it to install Firebird as "super classic" server (on Windows XP SP3). I was able to create a new user, create a new database, added an alias for it in alias.conf. I can connect to the database using this new account, both with FlameRobin (0.9.2) or ISQL, I can create domains, exceptions, stored procedures.
I cannot create tables, though.
I execute
CREATE TABLE HL_Oids (
OID OidKey NOT NULL PRIMARY KEY
);
in FlameRobin, the execution log (see below) indicates success. I click the commit button and get a metadata update error. The resulting log follows:
Starting transaction...
Preparing query: CREATE TABLE HL_Oids (
OID OidKey NOT NULL PRIMARY KEY
)
Prepare time: 0.031s
Plan not available.
Executing...
Done.
552 fetches, 57 marks, 34 reads, 0 writes.
12 inserts, 2 updates, 0 deletes, 48 index, 2 seq.
Delta memory: 1251124 bytes.
RDB$INDEX_SEGMENTS: 1 inserts.
RDB$INDICES: 1 inserts.
RDB$RELATION_FIELDS: 1 inserts.
RDB$RELATIONS: 1 inserts. 2 updates.
RDB$USER_PRIVILEGES: 5 inserts.
RDB$RELATION_CONSTRAINTS: 2 inserts.
RDB$CHECK_CONSTRAINTS: 1 inserts.
Total execution time: 0.047s
Script execution finished.
Commiting transaction...
*** IBPP::SQLException ***
Context: Transaction::Commit
SQL Message : -607
This operation is not defined for system tables.
Engine Code : 335544351
Engine Message :
unsuccessful metadata update
cannot create index RDB$PRIMARY11
Executing the same create table statement in ISQL results in the same error, worded somewhat differently.
What can be the reason for this behaviour? And how do I get around it?
BTW: the database resides in C:\Daten\Datenbanken\SF\MYLIBRARY.FDB
--
Peter Below