Issue Details (XML | Word | Printable)

Key: CORE-3011
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Denis Nosov
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Server hangs or crashes while monitoring connections repeatedly attaching and detaching

Created: 22/May/10 01:33 PM   Updated: 04/Feb/11 12:08 PM
Component/s: Engine
Affects Version/s: 2.1.0, 2.5 Alpha 1, 2.1.1, 2.1.2, 2.5 Beta 1, 2.5 Beta 2, 2.1.3, 2.5 RC1, 2.5 RC2
Fix Version/s: 2.5 RC3, 2.1.4

Time Tracking:
Not Specified

Environment:
OS: Windows Seven (win32)
FB 2.5.0.26024 Classic
CPU: Intel Q9400
MEM: 3Gb

Planning Status: Unspecified


 Description  « Hide
Reproduced with ISQL and .bat
With 10 concurrent connections running, at 20 hangs.
firebird.log is empty.

test.bat:
@echo off
for /L %%i in (1,1,10) do (
   for /L %%j in (1,1,20) do start isql -u SYSDBA -p masterke -i _input.sql -o _output.txt "192.168.10.10:d:\Program Files\Firebird\Firebird_2_5\examples\empbuild\employee.fdb"
   isql -u SYSDBA -p masterke -i _input.sql -o _output.txt "192.168.10.10:d:\Program Files\Firebird\Firebird_2_5\examples\empbuild\employee.fdb"
)


_input.sql:
with
nx as
(
  select 0 i from rdb$database union all select 1 from rdb$database union all
  select 2 from rdb$database union all select 3 from rdb$database union all
  select 4 from rdb$database union all select 5 from rdb$database
)
select count(*) from nx n5, nx n4, nx n3, nx n2, nx n1, nx n0 where n5.i+n4.i+n3.i = n2.i+n1.i+n0.i;
select count(*) from mon$attachments;
with
nx as
(
  select 0 i from rdb$database union all select 1 from rdb$database union all
  select 2 from rdb$database union all select 3 from rdb$database union all
  select 4 from rdb$database union all select 5 from rdb$database
)
select count(*) from nx n5, nx n4, nx n3, nx n2, nx n1, nx n0 where n5.i+n4.i+n3.i = n2.i+n1.i+n0.i;
exit;



 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.