Subject Re: Transactions with prepared statements CRASH.
Author Stan
I dont mind taking a look when I have some time. I am just surprised
that no one else has run into this. Honestly, I assumed that I was
doing something stupid.

I will try to reproduce this issue with straight C api calls, and if
it works that way, I will take a look into the php driver.

thanks,

stan


--- In firebird-php@yahoogroups.com, Lester Caine <lester@...> wrote:
>
> Stan
>
> >>> $trans = ibase_trans($db, IBASE_WRITE|IBASE_CONCURRENCY|IBASE_WAIT);
> >> try IBASE_REC_VERSION | IBASE_COMMITTED when using IBASE_WRITE
> >> IBASE_CONCURRENCY is more consistent with IBASE_READ since it
> > provides a
> >> SNAPSHOT view of the data
> >
> > I tried IBASE_REC_VERSION|IBASE_COMMITED as well as
> > IBASE_NO_REC_VERSION|IBASE_COMMITED.
> >
> > both ways produce the same crash at the same address
> > in gds32.dll
> >
> > am I doing everything else correctly?
> >
> > does anyone know why I am getting:
> > -501 Attempt to reclose a closed cursor
> > and
> > invalid transaction handle (expecting explicit transaction start)
> >
> > when retrying a failed statement in the code below?
>
> One of the other problems here is that the person who was maintaining
> the PHP driver has gone quiet and no one has the internal knowledge to
> take over :(
> But we do need to start moving on this since I'm sure other niggles are
> going to surface once FB2 is in use more!
> I see an occasional lockuup in bitweaver which I've not worried
about as
> it seemed to be related to older code and has not been happening with
> newer builds, but I'm sure that things are not 100% 'under the hood' :(
>
> --
> Lester Caine - G8HFL
> -----------------------------
> L.S.Caine Electronic Services - http://home.lsces.co.uk
> Model Engineers Digital Workshop -
> http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
> Treasurer - Firebird Foundation Inc. -
http://www.firebirdsql.org/index.php
>