[firebird-support] Re: server 2.5.8 deadlocked

13.02.2018 05:07, Hamish Moffatt wrote: > I attached gdb and dumped the state of all threads, which shows every > one of them is waiting on a mutex or futex, ie it's dead locked. I've > attached the trace. You need to download the debug symbols (Firebird-debuginfo-* package) and copy them into

Re: [firebird-support] server 2.5.8 deadlocked

On 13/02/18 13:07, Hamish Moffatt ham...@risingsoftware.com [firebird-support] wrote: I'm getting the Firebird 2.5 superclassic server on Linux deadlocking regularly at the moment. Twice in one day last week, and again today after uptime of less than 6 hours. I just upgraded to 2.5.8 today,

Re: [firebird-support] server 2.5.8 deadlocked

any solution find？i have same problem also From Hugo Chia On 13 Feb 2018, at 10:07 AM, Hamish Moffatt ham...@risingsoftware.com [firebird-support] > wrote: I'm getting the Firebird

[firebird-support] server 2.5.8 deadlocked

I'm getting the Firebird 2.5 superclassic server on Linux deadlocking regularly at the moment. Twice in one day last week, and again today after uptime of less than 6 hours. I just upgraded to 2.5.8 today, from 2.5.6. Our workload isn't huge, but we do have a lot of small databases and maybe

[firebird-support] Linux Journal

Hello Helen, It's been a while, but I still read your posts on the FB (not facebook!!) forums! I saw this article below and thought I might try and lend a hand to Firebird by taking up the offer, but then realised there was a better person to do so so passing the baton if you wish to

Re: [firebird-support] Adding a field with NOT NULL constraint

Hello Helen,     One of the most dangerous consequences of forgetting to update values of the new added field, when it has constraints, is that, when recovering a database from a backup, errors are risen and the recover process aborts. Although backups are done raising no error, that doesn't

Re: [firebird-support] Re: Adding a field with NOT NULL constraint

Dmitry,     Thanks for your answer.     Also note that when a not null field is created with a default value ( test4 ), not only any select returns its default value but also the engine considers it in compare statements as if it contained the default value.     This is also true if you

Re: [firebird-support] Adding a field with NOT NULL constraint

Helen,     Thank you very much for you advices.     As a matter of fact, I had been changing table structures and stored procedures while other clients were connected since many years with no problems. Nevertheless, what you say is indeed true and can give rise potentially to trouble.