Re: [GENERAL] Backend cache invalidation initialization failed... HUH?

[Charset iso-8859-1 unsupported, filtering to ASCII...]
> Here's the problem:
>
> [rschutt@jin logs]$psql transfer
> NOTICE:  SIAssignBackendId: discarding tag 2147482551
> Connection to database 'transfer' failed.
> FATAL 1:  Backend cache invalidation initialization failed
>
> The frustrating thing is, psql seems to go thru phases where it will work
> fine for a few minutes, and then it won't work at all for a few minutes,
> then it will connect about 5% of the time for a while, and then it will
> connect about 50% of the time.
>
> Here's my config:
> sparc SunOS 5.5.1, postgresql 6.3.2, apache 1.2.6 with mod_jserv, mod_php3,
> and mod_perl compiled in (persistant mod_perl connections via Apache::DBI),
> perl scripts accessing postgresql thru DBI, java servlets accessing
> postgresql thru jdbc, and a few php pages.
>
> It seems that all applications seem to connect or fail to connect to
> postgresql with the same success rate.
>
> Restarting apache seems to clear up the problem..
>
> Any help would be greatly appreciated!!!
>
>
>

6.4 has better cache code, which I am sure will fix this.


--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026