Forum OpenACS Q&A: Strange log notices

Collapse
Posted by Tom Jackson on
I saw the following NOTICE in the AOLserver/OpenACS server.log file:
[20/Sep/2001:08:53:51][16657.9226][-conn0-] Notice: 216.254.26.187 GET
/typing/test-new?lesson_id=3037 HTTP/1.0
NOTICE:  Adding missing FROM-clause entry for table
"acs_object_id_seq"
NOTICE:  identifier "acs_object__initialize_attributes" will be
truncated to "acs_object__initialize_attribut"

Is some process logging to this file not using Ns_Log? If this
formatting doesn't make it through, the NOTICE begins a new entry in
the server log. They only appear the first time through the page
/typing/test-new.

Collapse
Posted by Don Baccus on
These are messages posted by the PG driver itself, not the application code.

You only see it once because it's being generated when a function body's
being compiled, which happens only once per PG process.  You're probably
getting the same recycled handle when you revisit since it's a test machine (I assume) and you're the only visitor (I assume).  This is just
an informed guess on my part, i.e. I assume these are coming from code within a PL/pgSQL function.