roctaiwan <[email protected]> writes: > 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);"
The database looks pretty mussed up if parts of relations are missing. I'd concur with Glyn that you probably need to reconstruct that would-be subscriber from scratch (likely from the point of running "initdb"), as well as that it would be useful to figure out what caused the database to be corrupted. Slony-I shouldn't be able to do so. The amount of cache is pretty irrelevant to the matter. -- (reverse (concatenate 'string "ofni.sailifa.ac" "@" "enworbbc")) <http://dba2.int.libertyrms.com/> Christopher Browne (416) 673-4124 (land) "Bother," said Pooh, "Eeyore, ready two photon torpedoes and lock phasers on the Heffalump, Piglet, meet me in transporter room three" _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
