Hi!
I am having trouble with one installation of my application: Whenever I
try to create a table, I receive error 335544351 "unsuccessful metadata
update\nrequest depth exceeded. (Recursive definition?)". I cannot
figure what could possibly be causing this, as the CREATE TABLE
statement is extremely simple:
CREATE DOMAIN "TID" AS INTEGER;
CREATE TABLE sometable (
table_id TID NOT NULL,
value1 INTEGER,
value2 TIMESTAMP,
value3 DOUBLE PRECISION,
CONSTRAINT pk_sometable PRIMARY KEY (table_id)
);
(Note: The script is "anonymized", but right as I am writing this, I am
trying to create precisely this table, named "sometable"
If I remove the constraint, the table gets created OK, but of course, I
rather need the primary key. If I try to add it separately (ALTER TABLE
sometable ADD PRIMARY KEY (table_id))
I tried the following database-wide settings:
- Start/stop the server.
- Upgrade Firebird to version 2.5.3.
- Make sure the application is using a fbclient.dll (gds32.dll) from
version 2.5.3.
- Use SuperServer (fbserver.exe).
- Use a default firebird.conf.
- Run a backup/restore cycle.
- Compare that the database structure is the same as in a good
installation (where table creation works fine).
- Grab a structure from a good installation, copy all data from the
"bad" database to this correct structure, run a backup/restore cycle.
None of them helped. This one instance just won't create tables :-(
GSTAT says:
Database header page information:
Flags 0
Checksum 12345
Generation 1673822
Page size 8192
ODS version 11.2
Oldest transaction 169804
Oldest active 1672359
Oldest snapshot 1672279
Next transaction 1673795
Bumped transaction 1
Sequence number 0
Next attachment ID 136502
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Nov 15, 2014 7:43:26
Attributes
I find it strange that I have such a difference between Oldest
transaction, Oldest active and Next transaction, as I am convinced that
my application is closing transactions correctly, but perhaps that is
the result of the failed table-creation attempts.
Can anybody suggest a course that I could try? I am running out of
ideas. Thank you.
Josef
