Crash on infinite mutual SP calls (instead of "Too many concurrent executions
of the same request.")
----------------------------------------------------------------------------------------------------
Key: CORE-4653
URL: http://tracker.firebirdsql.org/browse/CORE-4653
Project: Firebird Core
Issue Type: Bug
Reporter: Pavel Zotov
set term ^;
create or alter procedure p03(a_i int) returns (z int) as
begin
z = 0 ;
suspend;
end^
commit^
create or alter procedure p02(a_i int) returns (z int) as
begin
z = (select z from p03(:a_i)) + 1;
suspend;
end^
commit^
create or alter procedure p03(a_i int) returns (z int) as
begin
z = (select z from p02(:a_i)) + 1;
suspend;
end^
commit^
create or alter procedure p01(a_i int) returns (z int) as
begin
z = (select z from p02(:a_i)) + 1;
suspend;
end^
commit^
set term ;^
SQL> show proc;
Global procedures:
Procedure Name Invalid Dependency, Type
================================= ======= =================
P01 P02, Procedure
P02 P03, Procedure
P03 P02, Procedure
This statement:
SQL> select * from p01(1);
-- leads FB to "Segmentation fault (core dumped)"
Stacktrace samples see in attach.
SQL> show version;
ISQL Version: LI-T3.0.0.31474 Firebird 3.0 Beta 2
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-T3.0.0.31474 Firebird
3.0 Beta 2"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-T3.0.0.31474 Firebird
3.0 Beta 2/tcp (oel64)/P13"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-T3.0.0.31474
Firebird 3.0 Beta 2/tcp (oel64)/P13"
on disk structure version 12.0
PS.
No such result in 2.5, get there as expected:
Too many concurrent executions of the same request.
Too many concurrent executions of the same request.
At procedure 'P03' line: 3, col: 3
At procedure 'P02' line: 3, col: 3
At procedure 'P03' line: 3, col: 3
At procedure 'P02' line: 3, col: 3
....
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
