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-issue-importer opened this issue Apr 6, 2007 · 14 comments

Comments

@firebird-issue-importer
Copy link

@firebird-issue-importer firebird-issue-importer commented Apr 6, 2007

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

@firebird-issue-importer firebird-issue-importer commented Apr 9, 2007

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

@firebird-issue-importer firebird-issue-importer commented Apr 9, 2007

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

@firebird-issue-importer firebird-issue-importer commented Apr 10, 2007

Commented by: skaushanskiy (skaushanskiy)

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 10, 2007

Modified by: @dyemanov

assignee: Vlad Horsun [ hvlad ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 10, 2007

Commented by: @hvlad

Can you make test case ?

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 10, 2007

Commented by: skaushanskiy (skaushanskiy)

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 10, 2007

Commented by: @hvlad

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Dec 14, 2007

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

@firebird-issue-importer firebird-issue-importer commented Dec 14, 2007

Modified by: skaushanskiy (skaushanskiy)

Attachment: gds_cch_precedence__block_marked.zip [ 10710 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Dec 16, 2007

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

@firebird-issue-importer firebird-issue-importer commented Dec 17, 2007

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 28, 2008

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 18, 2008

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 19, 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