Re: [firebird-support] large fb_table files

2016-10-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.10.2016 13:12, r.terschlue...@probat.com [firebird-support] wrote: > If we close the connection, the memory of the file will not be released. Most likely you closed wrong connection, not the one which the table belongs to. -- WBR, SD.

Re: [firebird-support] large fb_table files

2016-10-07 Thread r.terschlue...@probat.com [firebird-support]
Thanks for the quick anwer yes we use GTT with on commit preserve rows in very long connection. If we close the connection, the memory of the file will not be released.

Re: [firebird-support] large fb_table files

2016-10-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.10.2016 10:40, r.terschlue...@probat.com [firebird-support] wrote: > What could be the reason, that the file is still growing? Inserting more records into a temporary table. > What are we doing wrong? Perhaps, you use GTT with on commit preserve rows in very long connection. --

[firebird-support] large fb_table files

2016-10-07 Thread r.terschlue...@probat.com [firebird-support]
Hello, We have a problem with large fb_table_xxx file in the firebird_tmp directory. The fb_table file will only be deleted, if no connection is activ, but this is very rare. So the file is still growing up and the server crashes, if the file has more than 50GBytes Firebird-2.5.5.26952-0