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
Re: [Firebird-devel] Strange CAST result
On 25-05-2022 10:08, artyom.abakumov wrote: The CAST function returns a strange result in the following case: SQL> SELECT CAST(345.12e-2 as VARCHAR(10)) from RDB$DATABASE; CAST == 3.45 Is it a correct behavior? LI-V4.0.2.2770 Firebird 4.0 It does seem off, I would expect it to output 3.4512, same as happens for cast(3.4512e0 as varchar(10)). There are other oddities, e.g. cast(x as varchar(10)) where x is a literal gives weird results: 34512e-4: 3.4512000 3451.2e-3 : 3.5 34.512e-1 : 3.451 3.4512e0: 3.4512 0.34512e1 : 3.45120 0.034512e2 : 3.451200 0.0034512e3 : 3.4512000 These should basically be the same value Also select cast(x as varchar(10)) from (select cast(345.12e-2 as double precision) as x from rdb$database); results in 3.3412000 while select cast(x as varchar(10)) from (select 345.12e-2 as x from rdb$database); results in 3.45, which is odd as 345.12e-2 is a double precision literal, but it looks like it gets coerced to something else in the presence of the cast to varchar. Mark -- Mark Rotteveel Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Unused but still handled DPB items
16.05.2022 18:51, Dimitry Sibiryakov пишет: Hello All. Shouldn't code for handling isc_dpb_journal, isc_dpb_old_file, etc cleaned out or someone have plans for their reuse? I don't think any DPB code can be reused, unless the new behaviour completely matches the originally intended one (which we may only guess). So IMO their handling code should be wiped out. Dmitry Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Strange CAST result
Hi! The CAST function returns a strange result in the following case: SQL> SELECT CAST(345.12e-2 as VARCHAR(10)) from RDB$DATABASE; CAST == 3.45 Is it a correct behavior? LI-V4.0.2.2770 Firebird 4.0 Artyom Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel