Re: [Firebird-devel] Operating system call pthread_mutex_lock failed. Error code 22 #Fb 4.0.1 #Centos 7
On 6/3/22 14:58, Lucas Schatz wrote: Hello Just do clarify, 600-900 seconds or ms? I think makes sense to be ms, anyway I'll put 30 seconds just to be sure, because almost every second the DB gets attached As soon as I have news I'll post here (hope not), at most probably next month I'll give a feedback Thanks I've talked about 600-900 seconds (i.e. 10-15 min) alter database set linger to 600; But if it's attached almost every second 30 vs 600 makes no real difference :) Next, with that attach/detach rate linger should have some erformance effect. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Operating system call pthread_mutex_lock failed. Error code 22 #Fb 4.0.1 #Centos 7
Hello Just do clarify, 600-900 seconds or ms? I think makes sense to be ms, anyway I'll put 30 seconds just to be sure, because almost every second the DB gets attached As soon as I have news I'll post here (hope not), at most probably next month I'll give a feedback Thanks Em sex., 3 de jun. de 2022 06:41, Alex Peshkoff via Firebird-devel < firebird-devel@lists.sourceforge.net> escreveu: > On 5/27/22 23:06, Lucas Schatz wrote: > > Installed, now wait for the error, probably only next week > > > > > With that dump I've more or less understood where bug happens. But > fixing that may be not quick. I'm almost sure that use of big enough > linger (600 or 900 or even bigger) should make this bug happen very > rare. Try that please - in the best case segfaults will be gone. > > A. > > > > > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel > Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Operating system call pthread_mutex_lock failed. Error code 22 #Fb 4.0.1 #Centos 7
On 5/27/22 23:06, Lucas Schatz wrote: Installed, now wait for the error, probably only next week With that dump I've more or less understood where bug happens. But fixing that may be not quick. I'm almost sure that use of big enough linger (600 or 900 or even bigger) should make this bug happen very rare. Try that please - in the best case segfaults will be gone. A. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Operating system call pthread_mutex_lock failed. Error code 22 #Fb 4.0.1 #Centos 7
Installed, now wait for the error, probably only next week Em sex., 27 de mai. de 2022 08:58, Alex Peshkoff escreveu: > On 5/27/22 04:38, Lucas Schatz wrote: > > Hello, > > I moved the database to another server with Fb4.0.0 for some days, and > > "fortunately" today crashed too > > So, if you can send me the tar.gz I'll install with no problem > > http://web.firebirdsql.org/download/rabbits/alex/MutexError22/ > > > Any additional risk of losing data? > > Additional - no. > > Moreover - for a database being attached in the moment of a crash > absolutely no risks: it's file is just opened at that time. Certainly > other databases accessed by server at this time may be affected by a > crash - but possibility of data loss is very low. For sure it will not > be higher compared with std build. > > > Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Operating system call pthread_mutex_lock failed. Error code 22 #Fb 4.0.1 #Centos 7
On 5/27/22 04:38, Lucas Schatz wrote: Hello, I moved the database to another server with Fb4.0.0 for some days, and "fortunately" today crashed too So, if you can send me the tar.gz I'll install with no problem http://web.firebirdsql.org/download/rabbits/alex/MutexError22/ Any additional risk of losing data? Additional - no. Moreover - for a database being attached in the moment of a crash absolutely no risks: it's file is just opened at that time. Certainly other databases accessed by server at this time may be affected by a crash - but possibility of data loss is very low. For sure it will not be higher compared with std build. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Operating system call pthread_mutex_lock failed. Error code 22 #Fb 4.0.1 #Centos 7
Hello, I moved the database to another server with Fb4.0.0 for some days, and "fortunately" today crashed too So, if you can send me the tar.gz I'll install with no problem Any additional risk of losing data? Thanks! On Thu, May 26, 2022 at 1:40 PM Alex Peshkoff via Firebird-devel < firebird-devel@lists.sourceforge.net> wrote: > On 5/25/22 17:43, Lucas Schatz wrote: > > Sorry, just to clarify: server Fb4.0.1, remote client Fb 3.0+PHP7.3 > > > > Anyway I'll send you the links as soon as possible. > > > > I've made a close look at that dump. Unfortunately I could not find > something very useful in it. I.e. it's more or less clear at what step > happens 'error 22' and why segfault later details remin in dark - FB > tried too much to recover after an error. If I prepare special build > which will make core dump immediatrly after mutex error can you run it? > I.e. server will fail a bit earlier (1-2 sec real time) but it anyway > dies currently :-( > > > > > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel > Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Operating system call pthread_mutex_lock failed. Error code 22 #Fb 4.0.1 #Centos 7
On 5/25/22 17:43, Lucas Schatz wrote: Sorry, just to clarify: server Fb4.0.1, remote client Fb 3.0+PHP7.3 Anyway I'll send you the links as soon as possible. I've made a close look at that dump. Unfortunately I could not find something very useful in it. I.e. it's more or less clear at what step happens 'error 22' and why segfault later details remin in dark - FB tried too much to recover after an error. If I prepare special build which will make core dump immediatrly after mutex error can you run it? I.e. server will fail a bit earlier (1-2 sec real time) but it anyway dies currently :-( Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Operating system call pthread_mutex_lock failed. Error code 22 #Fb 4.0.1 #Centos 7
Sorry, just to clarify: server Fb4.0.1, remote client Fb 3.0+PHP7.3 Anyway I'll send you the links as soon as possible. On Wed, May 25, 2022 at 11:40 AM Alex Peshkoff via Firebird-devel < firebird-devel@lists.sourceforge.net> wrote: > On 5/25/22 17:35, Lucas Schatz wrote: > > I got 4 coredumps, can I send PM to you the link? > > > > Please do - but compress them separately. > > > Also, I think we spotted the problem's source, looks like it's a PHP > > related issue > > Looking at the stack-trace, it looks like something related to a web > > server with PHP7.3 FPM and Fb V3.0.4.33054. > > Attached stack trace is 4.0.1. And I doubt PHP can directly affect SS, > running in separate process. > > > > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel > Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Operating system call pthread_mutex_lock failed. Error code 22 #Fb 4.0.1 #Centos 7
On 5/25/22 17:35, Lucas Schatz wrote: I got 4 coredumps, can I send PM to you the link? Please do - but compress them separately. Also, I think we spotted the problem's source, looks like it's a PHP related issue Looking at the stack-trace, it looks like something related to a web server with PHP7.3 FPM and Fb V3.0.4.33054. Attached stack trace is 4.0.1. And I doubt PHP can directly affect SS, running in separate process. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Operating system call pthread_mutex_lock failed. Error code 22 #Fb 4.0.1 #Centos 7
I got 4 coredumps, can I send PM to you the link? Also, I think we spotted the problem's source, looks like it's a PHP related issue Looking at the stack-trace, it looks like something related to a web server with PHP7.3 FPM and Fb V3.0.4.33054. Updated Firebird to 3.0.9, but didn't helped But not really sure On Wed, May 25, 2022 at 11:29 AM Alex Peshkoff via Firebird-devel < firebird-devel@lists.sourceforge.net> wrote: > On 5/25/22 17:23, Lucas Schatz wrote: > > 17gb +- > > > > Can you compress it (xz is preferred for obv.reasons) and put to some > downloadable place? > > > > > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel > Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Operating system call pthread_mutex_lock failed. Error code 22 #Fb 4.0.1 #Centos 7
On 5/25/22 17:23, Lucas Schatz wrote: 17gb +- Can you compress it (xz is preferred for obv.reasons) and put to some downloadable place? Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Operating system call pthread_mutex_lock failed. Error code 22 #Fb 4.0.1 #Centos 7
17gb +- On Wed, May 25, 2022 at 8:30 AM Alex Peshkoff via Firebird-devel < firebird-devel@lists.sourceforge.net> wrote: > On 5/23/22 16:07, Lucas Schatz wrote: > > > The stack-trace is attached, as soon I get more stack-traces I'll send > > here too > > How big is core dump? > > > > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel > Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Operating system call pthread_mutex_lock failed. Error code 22 #Fb 4.0.1 #Centos 7
On 5/23/22 16:07, Lucas Schatz wrote: The stack-trace is attached, as soon I get more stack-traces I'll send here too How big is core dump? Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel