[firebird-support] 2.5.9 - LOCALTIME

Hi Everyone! Can You recommend a simple workaround on the new LOCALTIME variable when the very same name is used as column name in a table? Thanks in advance Regards Zsolt

[firebird-support] Data dump

Hello guys/gals! What is the fastest (performance-wise) way to export all data from a massive 2.5 database? Any tools installed already with the server or available freely? Thanks in advance! Best Regards Zsolt

[firebird-support] firebird.log in Windows directory

Hi everyone, We are using FB 2.5.2 and 2.5.3 x64 SuperClassic under Windows 2008R2 with default installation options and noticed recently that beside the expected location (%programfiles%\firebird\firebird_2_5\) a firebird.log instance containing fairly recent entries. Anyone else noticed, any

Re: [firebird-support] firebird.log in Windows directory

2014-09-19 15:55 GMT+02:00 Mark Rotteveel m...@lawinegevaar.nl [firebird-support] firebird-support@yahoogroups.com: On Fri, 19 Sep 2014 15:14:22 +0200, Zsazsi m-zs...@freemail.hu [firebird-support] firebird-support@yahoogroups.com wrote: Hi everyone, We are using FB 2.5.2 and 2.5.3 x64

Re: [firebird-support] Cache Performance Options

Hi Karol, what Windows 2008 memory problem are You refering to that needs 2.5.3? Thanks Zsazsi 2014-05-13 7:23 GMT+02:00 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support] firebird-support@yahoogroups.com: Hi, Your database is not big but your settings are low

Re: [firebird-support] Cache Performance Options

Hi Karol, I can see nothing related, The only problem that shows up was fixed in 2.5.2 already. http://tracker.firebirdsql.org/browse/CORE-3791 Do You know something more specific? Regards Zsazsi 2014-05-13 8:56 GMT+02:00 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird

Re: [firebird-support] NBackup Levels

, 2 - 90 minutes). Regards Zsazsi 2014-05-07 8:43 GMT+02:00 Steffen Heil (Mailinglisten) li...@steffen-heil.de: Hi There is no formal limit, ... Is there a negative effect on too many levels? (Slowdown or database storage overhead?) Regards, Steffen

Re: [firebird-support] Re: Shutting down the server - active sevice(s)

Hi Vlad, Thank You for the answer. It could be an indication of a memory leak caused by an offending client application that failed to execute isc_dsql_free_statement after executing the statements. Anyone interested how I found out the offending client: selecting the records from the

Re: [firebird-support] FB 2.5.2 SS crash

2014-04-28 15:22 GMT+02:00 Gabor Boros gaborbo...@outlook.com: 2014.04.23. 14:57 keltezéssel, Zsazsi írta: Before these, several (I mean a lot) INET/inet_error: read errno = 10054 was logged and the Server refused to answer to the requests for a few minutes. Hi, 10054 is a network

[firebird-support] Shutting down the server - active sevice(s)

Dea all, What does the 110 active service(s) mean in the firebird.log? Is it an indication of some further problem? Shutting down the server with 11 active connection(s) to 3 database(s), 110 active service(s) Any suggestions? FB 2.5.2 SS Win64 Regards Zsolt

[firebird-support] Threads and Handles

Hi all, On one of our client's system the thread and handle count associated with fbserver.exe in Windows Task Manager grows quite quickly. The thread count is around 600 and the handles ar about 7000 after a few hours of Firebird service restart, We have backed up and restored the databases

Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2

Hi folks, Alexey might be referring to us as we also had some performance issues under Win2008R2 and FB 252 SS, but we started a different thread, so I might as well be wrong. Anyway we are still in the process of evaluating the impact of our resolving actions on performance. The operator

Re: [firebird-support] Firebird slowdowns while resources are available

Hi Alexey, I've sent a mail directly to You about this particular case asking for personal assistance. Any suggestions or hints are welcome if someone else is willing to participate. Best Regards Zsolt 2014-02-11 9:58 GMT+01:00 Alexey Kovyazin a...@ib-aid.com: Hi Zoltan, this problem is

Re: [firebird-support] Re: Fwd: MON$STATE CPU usage

Dear Sean and Dmitry, It is clear now, thanks for taking time to answer. Best Regards Zsolt 2014-02-07 19:20 GMT+01:00 Leyne, Sean s...@broadviewsoftware.com: 07.02.2014 20:39, Leyne, Sean wrote: The case subject reads: Memory usage statistics in MON$STATEMENTS and MON$STATE

[firebird-support] Fwd: MON$STATE CPU usage

Hello everyone, I am a bit perplexed understanding the meaning of the values of MON$STATEMENTS.MON$STATE. Here is what I found in the FB 2.5 Release notes: Memory Usage in MON$STATEMENTS and MON$STATE Memory usage statistics in MON$STATEMENTS and MON$STATE represent actual CPU consumption.

[firebird-support] FB freeze

Hi everyone! We have FB 2.5.2 SS running on Win2003/x32 and Win2008/x64 servers. around 50 - 150 user connects to de databases . Every now and then some of our clients' FB server service freezes at the time we issue an ALTER DATABASE BEGIN BACKUP or start an nbackup session. After the freeze the