Re: [firebird-support] Delete causes server to hang

2016-08-25 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Hello kragh.tho...@yahoo.com, Thursday, August 25, 2016, 8:00:28 AM, you wrote: > On my website i have a tabel where i log some web requests - about > 90.000/hour. > Every hour this SQL is executed in a stored procedure: > delete from requests where created < dateadd(-7 day to

[firebird-support] Re: Delete causes server to hang

2016-08-25 Thread kragh.tho...@yahoo.com [firebird-support]
Hey Sean Yes there is a index, however I dont see the relevans, unless updating the index is the reason why the server hangs.

Re: [firebird-support] Server crash - guardian restarts permanently

2016-08-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.08.2016 14:20, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > I’ve updated to 3.0.1.32570 x64. Used the OpenSuse repositories. Current snapshot is 32583: http://web.firebirdsql.org/download/snapshot_builds/linux/fb3.0/ > Still the same problem. Seems there is

Re: [firebird-support] Server crash - guardian restarts permanently

2016-08-25 Thread Köditz, Martin martin.koed...@it-syn.de [firebird-support]
I've updated to 3.0.1.32570 x64. Used the OpenSuse repositories. Still the same problem. Seems there is something wrong with the system. But the syslog doesn't give any hints. Regards, Martin

Re: [firebird-support] Server crash - guardian restarts permanently

2016-08-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.08.2016 13:29, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > So what can I do? First of all - uprgade to current snapshot. -- WBR, SD.

[firebird-support] Server crash - guardian restarts permanently

2016-08-25 Thread Köditz, Martin martin.koed...@it-syn.de [firebird-support]
Hi, one of my Firebird servers did crash today. Now the firebird service doesn't work anymore. In firebird.log I can see following output (two entries each second): SDUD34-DB03 (Client)Thu Aug 25 13:28:20 2016 /usr/sbin/fbguard: guardian starting /usr/sbin/firebird SDUD34-DB03