Regarding ERROR: fmgr_info: function 2720768: cache lookup failed - Mailing list pgsql-performance

From soni de
Subject Regarding ERROR: fmgr_info: function 2720768: cache lookup failed
Date
Msg-id 9f2e40a90606212158p58652b2bg4d5f4500b3564641@mail.gmail.com
Whole thread Raw
Responses Re: Regarding ERROR: fmgr_info: function 2720768: cache lookup failed
List pgsql-performance

Hello,

 

I am getting following error while inserting a row into the "abc" table:

ERROR:  fmgr_info: function 2720768: cache lookup failed

 

Table "abc" has one trigger called "abct"

Definition is as follows:

 

BEGIN;

   LOCK TABLE abc IN SHARE ROW EXCLUSIVE MODE;

 

   create TRIGGER abct

      AFTER INSERT OR DELETE on abc

      FOR EACH ROW EXECUTE PROCEDURE abc_function();

 

COMMIT;

 

abc_function() updates entry from the "xyz" table for every insert and delete operations on table "abc".

 

"xyz" table maintains the count of total number of rows in table "abc"

 

Currently "abc" table contains 1000090 rows. And same count is available in table "xyz".

But now I am not able to insert any records into the "abc" table because of above mentioned error.

 

Please provide me some help regarding this.

 

Thanks,

Soni

pgsql-performance by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Performance of DOMAINs
Next
From: Richard Frith-Macdonald
Date:
Subject: Why is my (empty) partial index query slow?