[firebird-support] Re: Firebird hangs for a while blocking all DB operations periodically.

2012-05-30 Thread hvlad
--- In firebird-support@yahoogroups.com, anthonyjang2012 wrote: Environment : Firebird 2.5.1 Super-Classic x64 on Windows 2008 R2 Server with 32 GB of RAM We have a Firebird server installation that periodically blocks all operations for a few minutes and then comes back alive on its own.

RE: [firebird-support] Firebird hangs for a while blocking all DB operations periodically.

2012-05-30 Thread Svein Erling Tysvær
Environment : Firebird 2.5.1 Super-Classic x64 on Windows 2008 R2 Server with 32 GB of RAM We have a Firebird server installation that periodically blocks all operations for a few minutes and then comes back alive on its own. This has happened about once a month for the last few months.

Re: [firebird-support] Re: Firebird hangs for a while blocking all DB operations periodically.

2012-05-30 Thread Thomas Steinmaurer
When this problem occurs, the hard-disk is usable as I can still copy files, move files, delete files etc. so I don't believe that it is an I/O issue. We are not currently tracking any I/O performance metrics. We do use UDFs, but they should not be affecting all connections. The strange

[firebird-support] Re: Firebird hangs for a while blocking all DB operations periodically.

2012-05-30 Thread anthonyjang2012
We will run a lock print when it next occurs. The difficulty with this is that the issue seems to resolve itself after a few minutes so what tends to happen is that everything looks fine by the time we get on the system. Only once, we were able to observe the issue first-hand. Our application

[firebird-support] Re: Firebird hangs for a while blocking all DB operations periodically.

2012-05-30 Thread anthonyjang2012
How do we take a memory dump from the fb_inet_server process? We are using the production version of Firebird 2.5.1 x64 SC. Perhaps this issue can be identified by reverse engineering the code to see what the possibilities are for blocking all DB operations. CPU is low during the blocking.

Re: AW: [firebird-support] statement and composite variable names

2012-05-30 Thread Milan Babuskov
Olaf Kluge wrote: How can I realize: Fiels_name = 'COLUMNNAME''? Fiels_name = ''COLUMNNAME' I have test all combinations from one ' to four. How about five ' ? ;) -- Milan Babuskov == The easiest way to import XML, CSV and textual files into

Re: [firebird-support] Libs on Linux

2012-05-30 Thread Milan Babuskov
Matthias Hanft wrote: is http://www.firebirdfaq.org/faq47/ still true? That FAQ is meant only for users that have problems with libstdc++. The way you think, it was not true for a large portion of users the day when it was written. And again, I don't seem to need it... do I? No, if you can

Re: [firebird-support] Problems with dynamic events

2012-05-30 Thread Pete Cervasio
On Monday 28 May 2012 03:07:49 pm lortherin wrote: I'm having a problem with dynamic events and maybe someone can tell me what I'm doing wrong, or if this is a bug. Following up: This also happens on the 2.1.5 release candidate. This server crash doesn't appear to happen with Firebird 2.5.1,

RES: [firebird-support] Re: Firebird hangs for a while blocking all DB operations periodically.

2012-05-30 Thread Fabiano
The blocking beavior is for SS/SC? The Classic version has an different GC and maybe it does not occur. De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Em nome de nathanelrick Enviada em: quarta-feira, 30 de maio de 2012 12:55 Para:

[firebird-support] Re: Firebird hangs for a while blocking all DB operations periodically.

2012-05-30 Thread hvlad
--- In firebird-support@yahoogroups.com, anthonyjang2012 wrote: How do we take a memory dump from the fb_inet_server process? There are a lot of tools to do it, starting from task manager (since vista), userdump and process explorer (my favorite tool) Regards, Vlad

[firebird-support] Re: Firebird hangs for a while blocking all DB operations periodically.

2012-05-30 Thread anthonyjang2012
Thanks Vlad. We will try to obtain this to send to you when it happens again. Regards, Anthony --- In firebird-support@yahoogroups.com, hvlad hvlad@... wrote: There are a lot of tools to do it, starting from task manager (since vista), userdump and process explorer (my favorite tool)

Re: [firebird-support] Re: Firebird hangs for a while blocking all DB operations periodically.

2012-05-30 Thread Thomas Steinmaurer
it's exactly the same for us :( it's garbage collection ! when the garbage collection start, then any connection that try to load any row that are in the process of the garbage collection are blocked (freezed) ! in fact all the connection that try to select anything on the table are

Re: [firebird-support] Problems with dynamic events

2012-05-30 Thread Michael Ludwig
lortherin schrieb am 28.05.2012 um 20:07 (-): -- ISQL scriptlet: -- Two triggers to go with it: set term ;!! At this point, it should be: set term !! ; And a perl script which will show the error. I know this is probably horrible perl-fu. Looks good to me. But I couldn't get it