Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Various "Cannot initialize the shared memory region" errors [CORE3015] #3396

Closed
firebird-automations opened this issue May 26, 2010 · 7 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @hvlad

Using slightly modified test case of CORE3011 :

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\. 

Commits: 730a5a1 1674db2 3940fee

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

status: Open [ 1 ] => Open [ 1 ]

Target: 2.5 RC3, 2.1.4, 3.0 Alpha 1 [ 10381, 10361, 10331 ]

Fix Version: 2.5 RC3 [ 10381 ]

Fix Version: 2.1.4 [ 10361 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

Planning Status: Unspecified =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.1.4 [ 10361 ] =>

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Fix is backported into v2.1.4

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Fix Version: 2.1.4 [ 10361 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants