Subject estrange problem "Too many savepoints (287)"
Author mpvvee
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