Subject the "to many savepoints" & other problem
Author Leonardo Cosmai
hi,

my database every two/three days says:


Database: /guest/XXXX.gdb
internal gds software consistency check (Too many savepoints (287))

or

Database: /guest/XXXX.gdb
internal gds software consistency check (decompression overran buffer (179))


1. im my application i don't use any of ADOdb, Pear.

2. no explicit transactions used in php code; no "complex" store procedures or other operations

3. no difference between persistent/NO persistent connection: the problem is the same

4. the database in small (100 mb) and with a medium of 1000 connections per day

5. i think the problem is in the transaction mechanism used by php (maybe a bug in 4.3.3, but no literature on the internet).

6. often i have a this message: deadlock confilct....but i think is not the problem (or i'm wrong?)

7. what happens if a php script goes in "fatal error" to the firebird connection/trasaction?


Any suggestion?
Thanx.

this in my phpinfo()


...

Interbase Support => enabled
Revision => $Revision: 1.91.2.20 $
Dynamic Module => yes
Allow Persistent Links => Yes
Persistent Links => 0/unlimited
Total Links => 0/unlimited
Timestamp Format => %m/%d/%Y %H:%M:%S
Date Format => %m/%d/%Y
Time Format => %H:%M:%S

...


and this is my sever

Linux RedHat 2.1 Enteprise
PHP VERSION 4.3.3
Firebird SS 1.0.3



Ciao, L.
(Linux User #332241)
-----------------------
afortune4u!

Definizione: "Berlusconi ne possiede tre".
Risposta: "Capelli".
-- Dal cruciverba di Lello Splendor (Giorgio Panariello)