Subject Cannot create tables in new FB 2.5 DB, fails with error 335544351 on commit
Author peterbelow@ymail.com
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