Hi,
Big trouble ... with PostgreSQL 7.1.2 and PHP 4.0.6 on linux
I'm using exactly the same configuration (and same application, same
connection system) using PostgreSQL 7.1 and PHP 4.0.4pl1 same postgreSQL
config file, same php.ini same kind of servers, same Apache version
1.3.19 and it's running perfectly then ...
If I made a phpinfo on the webserver in the good case I have :
pgsql
PostgreSQL Support : enabled
Active Persistent Links : 2
Active Links : 2
Directive: Local Value/Master Value
pgsql.allow_persistent: On/On
pgsql.max_links : 14/14
pgsql.max_persistent : 14/14
***** But with the lastests versions (with PostgreSQL 7.1.2 and PHP
4.0.6) I have : ******
pgsql
PostgreSQL Support : enabled
Active Persistent Links : 0
Active Links : 0
Directive: Local Value/Master Value
pgsql.allow_persistent: On/On
pgsql.max_links : 14/14
pgsql.max_persistent : 14/14
Impossible to get active links or active persistent link in the
php_info() in this case ??
But the service is running ! :-/ ??????
BUT in the postgres.log I get this all at many times (not each request
but a lot of times) !!
2001-07-03 16:45:27 DEBUG: ProcessQuery
2001-07-03 16:45:27 DEBUG: CommitTransactionCommand
pq_recvbuf: unexpected EOF on client connection
2001-07-03 16:45:26 DEBUG: proc_exit(0)
2001-07-03 16:45:26 DEBUG: shmem_exit(0)
2001-07-03 16:45:26 DEBUG: exit(0)
/usr/local/pgsql/bin/postmaster: reaping dead processes...
/usr/local/pgsql/bin/postmaster: CleanupProc: pid 29076 exited with
status 0
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading
5
/usr/local/pgsql/bin/postmaster: ServerLoop: handling reading
5
/usr/local/pgsql/bin/postmaster: ServerLoop: handling writing
5
/usr/local/pgsql/bin/postmaster: BackendStartup: pid 29077 user toto db
mydb socket 5
/usr/local/pgsql/bin/postmaster child[29077]: starting with (postgres
-d2 -v1310 72 -p mydb)
FindExec: found "/usr/local/pgsql/bin/postgres" using argv[0]
If I look to the backends of the postgreSQL they are like classical
connections ... so they seems to close all the time (I do not use
pg_close function) !! In the normal case I have all the time a minimum
of 98 backends running (persistant connexions) !!
And if I look to the backends of apache they seems to move a lot ...
moving for 10 to 80 to 40 to 64 etc in the space of 1 second ! In normal
case the number of apache backends grow slowly and down also slowly ...
I really do not understand what happend ... and do not find the mistake
... does anybody have any idea ???
Thanks per advance for your answers !!
--
Hervé
