Subject | estrange problem "Too many savepoints (287)" |
---|---|
Author | mpvvee |
Post date | 2007-10-05T20:26Z |
Hi,
I'm experiencing a strange problem, when I try to run one query the
firebird server send this error "Too many savepoints (287)" but I
think that everything it's ok with my code, any toughs?
firebird log:
ARZA (Server) Fri Oct 05 15:57:17 2007
Database: C:\PROGRAM FILES\CACH\MAIN.DAT
internal gds software consistency check (Too many savepoints
(287), file: tra.cpp line: 2660)
Database header page information:
Flags 0
Checksum 12345
Generation 226
Page size 4096
ODS version 11.0
Oldest transaction 107
Oldest active 224
Oldest snapshot 224
Next transaction 225
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Oct 5, 2007 2:46:41
Attributes force write
Variable header data:
*END*
The error jumps when I break a loop of inserts, but these querys has
it's own transacction, also I made a commit.
My loop schema
transacction1
query1 loop1
query2 loop2
transacction2 (create)
query3 inserts
transacction2 commit
loop2 finished
loop1 finished
transacction1 commit
transacction3 start
query3 ( problem here)
Thanks in advance
Marcelo
I'm experiencing a strange problem, when I try to run one query the
firebird server send this error "Too many savepoints (287)" but I
think that everything it's ok with my code, any toughs?
firebird log:
ARZA (Server) Fri Oct 05 15:57:17 2007
Database: C:\PROGRAM FILES\CACH\MAIN.DAT
internal gds software consistency check (Too many savepoints
(287), file: tra.cpp line: 2660)
Database header page information:
Flags 0
Checksum 12345
Generation 226
Page size 4096
ODS version 11.0
Oldest transaction 107
Oldest active 224
Oldest snapshot 224
Next transaction 225
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Oct 5, 2007 2:46:41
Attributes force write
Variable header data:
*END*
The error jumps when I break a loop of inserts, but these querys has
it's own transacction, also I made a commit.
My loop schema
transacction1
query1 loop1
query2 loop2
transacction2 (create)
query3 inserts
transacction2 commit
loop2 finished
loop1 finished
transacction1 commit
transacction3 start
query3 ( problem here)
Thanks in advance
Marcelo