Howdy... Hope someone can help on this... I get the following error: <!-- Error type: pg.error Error value: ERROR: fmgr_info: function 21121: cache lookup failed --> Traceback (innermost last): File /data1/zope-2.0.0/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /data1/zope-2.0.0/lib/python/ZPublisher/Publish.py, line 176, in publish File /data1/zope-2.0.0/lib/python/Zope/__init__.py, line 201, in zpublisher_exception_hook (Object: ElementWithAttributes) File /data1/zope-2.0.0/lib/python/ZPublisher/Publish.py, line 161, in publish File /data1/zope-2.0.0/lib/python/ZPublisher/mapply.py, line 160, in mapply (Object: DeleteEmployeeAction) File /data1/zope-2.0.0/lib/python/ZPublisher/Publish.py, line 102, in call_object (Object: DeleteEmployeeAction) File /data1/zope-2.0.0/lib/python/OFS/DTMLMethod.py, line 145, in __call__ (Object: DeleteEmployeeAction) File /data1/zope-2.0.0/lib/python/DocumentTemplate/DT_String.py, line 502, in __call__ (Object: DeleteEmployeeAction) File /data1/zope-2.0.0/lib/python/DocumentTemplate/DT_With.py, line 148, in render (Object: delete) File /data1/zope-2.0.0/lib/python/Shared/DC/ZRDB/DA.py, line 401, in __call__ (Object: delete_employee) File /data1/zope-2.0.0/lib/python/Products/ZPyGreSQLDA/db.py, line 163, in query pg.error: (see above) With Zope 2.0.1, Python 1.5.2, ZPyGreSQL 0.0.3, PostGreSQL 6.5.2. Recently I switched from Zserver to (IBM)Apache/PCGI. I've found fmgr_info in the /usr/include/pgsql/fmgr.h header file, but this is way beyond my experience. Note that I am able to do inserts and selects using this DB connection, just deletes fail. Thanks in advance for any help... Bruce -- Bruce Elrick, Ph.D. Saltus Technology Consulting Group Personal: belrick@home.com IBM Certified Specialist Business: belrick@saltus.ab.ca ADSM, AIX Support, RS/6000 SP, HACMP
On Thu, Oct 21, 1999 at 01:36:01PM -0600, Bruce Elrick wrote:
Howdy...
Hope someone can help on this...
I get the following error: <!-- Error type: pg.error Error value: ERROR: fmgr_info: function 21121: cache lookup failed -->
Hi Bruce - This is a PostgreSQL backend error, being propogated all the way up through all those layers of software... I have'nt looked at it closely, but I'll take a stab. You say only DELETEs error. The message above is from the 'function manager' interface (fmgr) Looks to me like your DB has referential integrity implemented using trigger functions, and one of them is failing. Take a look at the postgres postmaster logs (perhaps after bumping the debug switch -D=5 or so) and find which one is erroring. Not a Zope problem, probably. <snipped traceback>
Bruce Elrick, Ph.D. Saltus Technology Consulting Group Personal: belrick@home.com IBM Certified Specialist Business: belrick@saltus.ab.ca ADSM, AIX Support, RS/6000 SP, HACMP ^^^^^^^^^^^^^^^^^^^^^^^ Hmm, you wouldn't know anything about this old RS/6000 N40 laptop I got cheap, would you? ;-)
Ross P.S. I just noticed that this email came directly to me, as well as to the Zope list. Because of the way my procmail scripts work, duplicates like this will get routed to my Zope list folder, rather than my work inbox. For error reports (involving the ZPyGreSQLDA) if you'd like to email me directly and get quicker response, please re-send or forward a copy to my email address, rather than just CC:ing me. Since I'm so behind on the lists, I've started grepping for references to PostgreSQL and the DA, so I might find them anyway, but you never know. -- Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005
participants (2)
-
Bruce Elrick -
Ross J. Reedstrom