Subject | the "to many savepoints" & other problem |
---|---|
Author | Leonardo Cosmai |
Post date | 2004-10-29T13:31:14Z |
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)
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)