Issue Details (XML | Word | Printable)

Key: CORE-3015
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Vlad Khorsun
Votes: 0
Watchers: 0
Operations

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

Various "Cannot initialize the shared memory region" errors

Created: 26/May/10 09:36 AM   Updated: 04/Feb/11 12:09 PM
Component/s: Engine
Affects Version/s: 2.5 RC2
Fix Version/s: 2.5 RC3, 2.1.4, 3.0 Alpha 1

Time Tracking:
Not Specified

Environment: Windows only issue

Target: 2.5 RC3, 2.1.4 and 3.0 Alpha 1


 Description  « Hide
Using slightly modified test case of CORE-3011 :

inp.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;



test.bat

@echo off
SET FB=F:\FB2\fb25.clean\temp\Win32\Release\firebird\bin
SET DB=localhost:%FB%\a.fdb

rem -o out_%%i_%%j.txt
rem -o out_%%i.txt

for /L %%i in (1,1,%1) do (
   echo %%i
   for /L %%j in (1,1,%2) do start /MIN %FB%\isql %DB% -u SYSDBA -p masterke -i inp.sql -o out_%%i_%%j.txt -m -m2
   %FB%\isql %DB% -u SYSDBA -p masterke -i inp.sql -o out_%%i_0.txt -m -m2
)


Run

test 250 25

and look into firebird.log after test ends. It will contain messages such as

Cannot initialize the shared memory region
operating system directive CreateFile failed
Access is denied.

Cannot initialize the shared memory region
operating system directive WaitForSingleObject failed
Cannot create a file when that file already exists.

Cannot initialize the shared memory region
operating system directive CreateFile failed
The process cannot access the file because it is being used by another process.


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Vlad Khorsun added a comment - 01/Aug/10 08:37 PM
Fix is backported into v2.1.4