Cache lookup error

From: Gunnar Sønsteby <gunnar(dot)sonsteby(at)netcom(dot)no>
To: pgsql-general(at)postgresql(dot)org
Subject: Cache lookup error
Date: 2009-11-13 13:36:14
Message-ID: 1258119374.13657.72.camel@gs-desktop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am new to user lists, so please don't be to hard on me if I am doing
anything wrong.

I have been running a postgres database with slony replication for some
years now as a backend for a apache webserver and lately some mono
(.net) programs. The database and webserver is running on a Ubuntu LTS
server and I compile the programs myself to be reasonable updated.

Current version is postgres 8.3.7 and Slony1-2.16

Yesterday I got a lot of errormessages in the postgres log.

2009-11-12 06:11:51 CET INSERTERROR: cache lookup failed for type 19218
2009-11-12 06:11:51 CET INSERTCONTEXT: SQL statement "INSERT INTO
_slony_webtrim.sl_log_1 (log_origin, log_xid, log_tableid,
log_actionseq, log_cmdtype, log_cmddata) VALUES (1, $1, $2,
nextval('_slony_webtrim.sl_action_seq'), $3, $4);"
2009-11-12 06:11:51 CET INSERTSTATEMENT: INSERT INTO reservation1
(activityid, activitydate, clientno, deptno, reservations, activityname,
room, dayofweek, starttime, maingroupname, activitystartdate,
activityenddate) SELECT activityid, '2009-11-12' AS activitydate,
clientno, deptno, 1 AS reservations, activityname, room, dayofweek,
starttime, maingroupname, activitystartdate, activityenddate FROM
activity WHERE activityid = 5374

2009-11-12 06:27:48 CET UPDATEERROR: cache lookup failed for type 19218
2009-11-12 06:27:48 CET UPDATECONTEXT: SQL statement "INSERT INTO
_slony_webtrim.sl_log_1 (log_origin, log_xid, log_tableid,
log_actionseq, log_cmdtype, log_cmddata) VALUES (1, $1, $2,
nextval('_slony_webtrim.sl_action_seq'), $3, $4);"
2009-11-12 06:27:48 CET UPDATESTATEMENT: UPDATE reservation2 SET
datetimereceipt = '2009-11-12 06:27:48' WHERE clientno = 342 AND refno =
945005

The applications worked happily as if everything were ok, but the data
was never written to disk and is lost. The error came after I dropped
(cascade) the slony schema and reinstalled it. I were not able to dump
the database (just hanging), but dumping table by table went ok. After
reinstalling the database (initdb) and install slony, everything seems
ok. I have scripts for installing slony, so there should not be any
differences in the way it is done.
I have had a database error once before, also after reinstalling slony.

I would appreciate very much if someone could tell me what kind of error
this is, and maybe some hints so I might avoid it in the future.

Best regards
Gunnar

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2009-11-13 14:12:05 Re: Customize the install directory of the postgres DB
Previous Message Ozgun Erdogan 2009-11-13 11:46:13 XLOG's implementation details