--- On Tue, 29/9/09, roctaiwan <[email protected]> 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 _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
