Subject Re: [firebird-support] Digest Number 9396
Author
I use only 

CREATE TABLE <TN>  and DROP TABLE <TN> metadata commands in runtime. I populate the tables and that's all. I don't create domains, not at all. 

I use FB 3.0 on a Linux server (I don't maintain that server) . 

The database file is very big - 1+ GB in size, my customers append arround 3000 records each day. 

To try to fix my domain name problem I do as you suggested : I do the restore of the new database file with the correct structure and datapump the records. I just did that yesterday (I have some 6 million records in a few tables) but this process is very time consuming - around 4 hours of work. 

I have one possible explanation :  last time I upgraded from FB 2.55 to FB 3.0, I did the process on a Windows machine : backup FB 2.55 and restore FB 3.0 on the machine. I copied , then, the FDB file in Linux (Samba) , didn't performed a normal restore on Linux (because it is very time-consuming and my customer couldn't wait). Maybe something bad happened then with those domain names. Yesterday I did this : 
1. Exported the records (in some XML files) 
2. Restored an empty database file (full restore - not copy the FDB file) 
3. Datapumped the records (from the XML files) . 

I will see the result and keep you informed. 


Thank you , 

Tiberiu