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

Firebird SS: internal gds software consistency check (CCH_precedence: block marked (212), file: cch.cpp line: 3640) [CORE1199] #1624

Closed
firebird-automations opened this issue Apr 6, 2007 · 14 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: skaushanskiy (skaushanskiy)

Attachments:
gds_cch_precedence__block_marked.zip

I started getting this error recently:
internal gds software consistency check (CCH_precedence: block marked
(212), file: cch.cpp line: 3640)

Sometimes I also get "Deadlock" messages that follow the GDS:

PDD-STAN (Server) Fri Apr 06 11:37:33 2007
Database: db
internal gds software consistency check (CCH_precedence: block marked
(212), file: cch.cpp line: 3640)

PDD-STAN (Server) Fri Apr 06 11:39:33 2007
Database: db
deadlock

PDD-STAN (Server) Fri Apr 06 11:39:33 2007
Database: db
deadlock

PDD-STAN (Server) Fri Apr 06 11:39:33 2007
Database: db
deadlock

Does anyone know what could be the cause?

I understand that I have "deadlocks" but I am
handling them in the client code. I commit the
current transaction, start a new one, and retry my
queries. I am using default transaction parameters.

This happens under load (75+ concurrent connections)
All connections are doing selects and inserts using
stored procedures. No schema modifications.

I tried all the different GCPolicies (background, cooperative and
combined) This does not seem to effect this problem.

fbclient.dll (from the FB 2.0.1 release for the client code)
FB 2.0.1 SS
Windows XP SP2
Athlon X2 4400
2GB RAM

thanks,

stan

Commits: 1112210 e833be6 37e3128

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Are you sure that the issue (bugcheck 212) happens on v2.0.0 as well? From the first glance, I suspect a v2.0.1 regression that shouldn't exist in v2.0.0...

@firebird-automations
Copy link
Collaborator Author

Commented by: skaushanskiy (skaushanskiy)

This just happened on V2.0.0, the log is slightly different:

PDD-STAN (Server) Mon Apr 09 19:03:22 2007
Database: C:\DB.FDB
internal gds software consistency check (CCH_precedence: block marked (212), file: cch.cpp line: 3805)

@firebird-automations
Copy link
Collaborator Author

Commented by: skaushanskiy (skaushanskiy)

it seems to happen more ofter when I use page_size = 16384
than when I use page_size = 8192.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Vlad Horsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Can you make test case ?

@firebird-automations
Copy link
Collaborator Author

Commented by: skaushanskiy (skaushanskiy)

not easily, but I will try. Do you prefer straight C/C++ API code or PHP?

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

C\C++\Delphi, please (not Delphi for PHP :)

@firebird-automations
Copy link
Collaborator Author

Commented by: skaushanskiy (skaushanskiy)

Reproducible test case. Instructions:

Under windows with:
VS7 includes/libs/path environment variables set,
Firebird bin in path
Firebird 2.0.0 installation in c:/firebird

Run make.bat
will compile firebird_tester.cpp
will create database tester.fdb in the current directory

Create an alias to the newly created tester.fdb, called "tester"

Run: firebird_tester.exe

On my machine, I get the GDS check in 3 out of 5 times within the first minute or two.

@firebird-automations
Copy link
Collaborator Author

Modified by: skaushanskiy (skaushanskiy)

Attachment: gds_cch_precedence__block_marked.zip [ 10710 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Target: 2.1 RC1, 2.0.4 [ 10201, 10211 ]

Version: 2.1 Beta 2 [ 10190 ]

Version: 2.0.3 [ 10200 ]

Fix Version: 2.1 RC1 [ 10201 ]

Fix Version: 2.0.4 [ 10211 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 11748 ] => Firebird [ 15539 ]

@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