Re: [firebird-support] large fb_table files
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. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] large fb_table files
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
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. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] large fb_table files
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 superserver firebird_tmp=f:\firebird_temp(50GBytes) What could be the reason, that the file is still growing? What are we doing wrong?