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-issue-importer opened this issue May 26, 2010 · 7 comments

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 26, 2010

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 27, 2010

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 27, 2010

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

Fix Version: 2.1.4 [ 10361 ] =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 1, 2010

Commented by: @hvlad

Fix is backported into v2.1.4

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 1, 2010

Modified by: @hvlad

Fix Version: 2.1.4 [ 10361 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Feb 4, 2011

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 18, 2016

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
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants