--- On Tue, 29/9/09, roctaiwan <nettreeinc at gmail.com> wrote:
> 
> Ok I have received this error today, can anybody tell me
> why is it happening?
> and how can I fix it? looks like it has something to do
> with cache, but I
> have set my cache 256mb in postgresql.conf, isn't it not
> enough?
> 
> contactdb=# copy contact from '/home/postgres/5m.copy';
> ERROR:  cache lookup failed for type 58783
> CONTEXT:  SQL statement "INSERT INTO
> _sql_cluster.sl_log_1 (log_origin,
> log_xid, log_tableid, log_actionseq, log_cmdtype,
> log_cmddata) VALUES (1,
> $1, $2, nextval('_sql_cluster.sl_action_seq'), $3, $4);"
> 
> Also, it said something about sl_log1 but I don't see
> anything in that
> table. it's empty


Hmm, looks like data corruption to me.  Probably something to do with the problem you posted earlier about the backend crashing.

I'd flatten that slave database and try again, obviously it'd be useful for you to find out why the server was crashing in the first place too...


Glyn

Send instant messages to your online friends http://uk.messenger.yahoo.com