Hi,
I'm running PostgreSQL 6.3.2. on SPARC Solaris 2.6.
I have several Web applications that I run under
mod_perl, using Apache::DBI to achieve persistent
database connections. I now have three databases
that connect on initialisation when Apache starts
up, which essentially means each Apache process has
an associated postgres process (or 2 by the looks
of it). When I have the three databases connecting
at start-up, there are about 60+ postgres processes.
When there are three databases that connect at
start-up, the most complicated application fails
with the following error:
NOTICE: SIAssignBackendId: discarding tag 2147483647
The other applications do not fail. If I only start
the database for this application on start-up, I do
not get this message.
The machine has 256 MB RAM + 256 MB swap. I don't think
there should be a resource problem.
Does anyone know what is going on here and how I can
fix it? Will 6.4 fix it? I know it's worth trying 6.4
but do you know why it would fix it?
I have included some debugging output below.
Also - is this the right list to mail such problems
to?
Thanks.
Patrick
--
---- query is:
SELECT * FROM images ORDER BY name
/kan/databases/pgsql/bin/postmaster: ServerLoop: handling reading 5
/kan/databases/pgsql/bin/postmaster: ServerLoop: handling reading 5
/kan/databases/pgsql/bin/postmaster: ServerLoop: handling writing 5
/kan/databases/pgsql/bin/postmaster child[0]: execv(/kan/databases/pgsql/bin/postgres, -p, -d2, -P5, -e, -v 65536,
marchcom_site_engine,)
FindBackend: found "/kan/databases/pgsql/bin/postgres" using argv[0]
NOTICE: SIAssignBackendId: discarding tag 2147483647
FATAL 1: Backend cache invalidation initialization failed
---debug info---
Quiet = f
Noversion = f
timings = f
dates = European
bufsize = 64
sortmem = 512
query echo = f
DatabaseName = [marchcom_site_engine]
----------------
InitPostgres()..
/kan/databases/pgsql/bin/postmaster: BackendStartup: pid 24702 user web db marchcom_site_engine socket 5
/kan/databases/pgsql/bin/postmaster: reaping dead processes...
/kan/databases/pgsql/bin/postmaster: CleanupProc: pid 24702 exited with status 0
/kan/databases/pgsql/bin/postmaster: ServerLoop: handling reading 5
/kan/databases/pgsql/bin/postmaster: ServerLoop: handling reading 5
/kan/databases/pgsql/bin/postmaster: ServerLoop: handling writing 5
/kan/databases/pgsql/bin/postmaster child[0]: execv(/kan/databases/pgsql/bin/postgres, -p, -d2, -P5, -e, -v 65536,
marchcom_site_engine,)
FindBackend: found "/kan/databases/pgsql/bin/postgres" using argv[0]
NOTICE: SIAssignBackendId: discarding tag 2147483647
FATAL 1: Backend cache invalidation initialization failed
--
#===============================#
\ KAN Design & Publishing Ltd /
/ T: +44 (0)1223 511134 \
\ F: +44 (0)1223 571968 /
/ E: mailto:patrick@kan.co.uk \
\ W: http://www.kan.co.uk /
#===============================#
