NOTICE: SIAssignBackendId: discarding tag 2147483647 - Mailing list pgsql-general

From Patrick Verdon
Subject NOTICE: SIAssignBackendId: discarding tag 2147483647
Date
Msg-id 365EB9CC.236B6968@kan.co.uk
Whole thread Raw
List pgsql-general
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      /
#===============================#

pgsql-general by date:

Previous
From: The Hermit Hacker
Date:
Subject: New Mailing List...
Next
From: Roland Roberts
Date:
Subject: int4 <--> varch2 conversions