--- In firebird-support@yahoogroups.com, "mpvvee" <mpvvee@...> wrote:

>
> 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
>

Update,
Im using firebird 2.0.3.12981-1
windows xp
delphi 2007