Обсуждение: plperl on AIX

<br /><font face="sans-serif" size="2">I posted this in other lists with no response...  Can anyone help?</font><br
/><br/><font face="sans-serif" size="2">I'm having trouble getting plperl to work on AIX 5.3.2.</font><font size="3">
</font><fontface="sans-serif" size="2"><br /> Postgresql Version: 8.1.1</font><font size="3"> </font><font
face="sans-serif"size="2"><br /> Perl Version: 5.8.7</font><font size="3"><br /></font><font face="sans-serif"
size="2"><br/> I've rebuilt perl as a shared library version and built that into postgre using --with-perl.  The
postgrebuild/install works fine, without errors.</font><font size="3"><br /></font><font face="sans-serif" size="2"><br
/>The plperl regression tests all fail, though.  Here are the test results of the first regression test:</font><font
size="3"><br/></font><font face="sans-serif" size="2"><br /> --</font><font size="3"> </font><font face="sans-serif"
size="2"><br/> -- checkpoint so that if we have a crash in the tests, replay of the</font><font size="3"> </font><font
face="sans-serif"size="2"><br /> -- just-completed CREATE DATABASE won't discard the core dump file</font><font
size="3"></font><font face="sans-serif" size="2"><br /> --</font><font size="3"> </font><font face="sans-serif"
size="2"><br/> checkpoint;</font><font size="3"> </font><font face="sans-serif" size="2"><br /> --</font><font
size="3"></font><font face="sans-serif" size="2"><br /> -- Test result value processing</font><font size="3">
</font><fontface="sans-serif" size="2"><br /> --</font><font size="3"> </font><font face="sans-serif" size="2"><br />
CREATEOR REPLACE FUNCTION perl_int(int) RETURNS INTEGER AS $$</font><font size="3"> </font><font face="sans-serif"
size="2"><br/> return undef;</font><font size="3"> </font><font face="sans-serif" size="2"><br /> $$ LANGUAGE
plperl;</font><fontsize="3"> </font><font face="sans-serif" size="2"><br /> server closed the connection
unexpectedly</font><fontsize="3"> </font><font face="sans-serif" size="2"><br />        This probably means the server
terminatedabnormally</font><font size="3"> </font><font face="sans-serif" size="2"><br />        before or while
processingthe request.</font><font size="3"> </font><font face="sans-serif" size="2"><br /> connection to server was
lost</font><fontsize="3"><br /></font><font face="sans-serif" size="2"><br /> I've tried this same thing manually with
thesame result.</font><font size="3"><br /></font><font face="sans-serif" size="2"><br /> Does anyone have any
suggestionson how to get this to work?</font><font size="3"><br /></font><font face="sans-serif" size="2"><br />
Thanks</font>

John F Rizzo <jfrizzo@us.ibm.com> writes:
> I'm having trouble getting plperl to work on AIX 5.3.2. 

You need to gather more info.  What shows up in the postmaster log
when the backend crashes?  Also, get a debugger stack trace from
the core file the backend leaves behind.  (If it doesn't leave a
core file then the first thing to do is fix that --- on Linux
"ulimit -c unlimited" before starting the postmaster helps, but
I'm not too familiar with AIX.)
        regards, tom lane

In an attempt to throw the authorities off his trail, jfrizzo@us.ibm.com (John F Rizzo) transmitted:
> I posted this in other lists with no response...  Can anyone help?
> I'm having trouble getting plperl to work on AIX 5.3.2.
> Postgresql Version: 8.1.1
> Perl Version: 5.8.7
> I've rebuilt perl as a shared library version and built that into postgre using --with-perl.  The postgre
build/installworks fine, without
 
> errors.
> The plperl regression tests all fail, though.  Here are the test results of the first regression test:

The first thing that comes to mind is the question of whether or not
Perl was compiled using the same compiler as was used for PostgreSQL.
If you're not sure, then perhaps using GCC for one and VAC for the
other might be what is turning out badly...

I know that mismatches of that sort have had adverse effects on AIX
and Solaris...
-- 
(reverse (concatenate 'string "moc.liamg" "@" "enworbbc"))
http://linuxdatabases.info/info/rdbms.html
"you  can   obvioulsy understand what  i'm  saying.  you're just being
pendantic." -- bazzz777@yahoo.com