PostgreSQL plperl crash on Cygwin 1.7.5

[Andrew Dunstan]

On Cygwin version 1.7.5 I am trying to run set up a member of the 
PostgreSQL Buildfarm 
<http://www.pgbuildfarm.org/cgi-bin/show_status.pl>. We have a current 
Cygwin member (run by me) using Cygwin version 1.5.25, which for the 
most part runs without major problems.

The good news is that even on the latest code, both stable and 
development, PostgreSQL builds and its core regression tests run with 
100% success.

The bad news is that I get a segfault when trying to run the regression 
tests for the embedded PLPerl language. The test fails when it tries to 
load Postgres' plperl.dll.

I have been able to repeat this result on PostgreSQL code all the way 
back to version 8.1, which is when we first got fully mechanized tests 
for PLPerl.

This does not happen on the older Cygwin version, which routinely runs 
without incident on the same code.

I tried to dig further into this with gdb, but the back traces didn't 
appear to show any useful information.

Here is the session trace:

    $ bin/psql
    psql (9.0beta1)
    Type "help" for help.

    Andrew=# select backend

    Andrew=# select pg_backend_pid();
     pg_backend_pid
    ----------------
               8144
    (1 row)

    Andrew=# create language plperl;
    server closed the connection unexpectedly
            This probably means the server terminated abnormally
            before or while processing the request.
    The connection to the server was lost. Attempting reset: Failed.
    !> \q

Here is a check on the DLL it's trying to load:

    $ cygcheck.exe lib/postgresql/plperl.dll
    C:\cygwin\home\Andrew\bf\root\HEAD\inst\lib\postgresql\plperl.dll
      bin\postgres.exe
        C:\cygwin\bin\cygcrypto-0.9.8.dll
          C:\cygwin\bin\cygwin1.dll
            C:\Windows\system32\ADVAPI32.DLL
              C:\Windows\system32\ntdll.dll
              C:\Windows\system32\KERNEL32.dll
              C:\Windows\system32\RPCRT4.dll
          C:\cygwin\bin\cyggcc_s-1.dll
        C:\cygwin\bin\cygintl-8.dll
          C:\cygwin\bin\cygiconv-2.dll
        C:\cygwin\bin\cygssl-0.9.8.dll
      C:\cygwin\bin\cygperl5_10.dll
        C:\cygwin\bin\cygcrypt-0.dll
        C:\cygwin\bin\cygssp-0.dll

I have attached the gdb session log and the cygcheck.out.

Can anyone suggest where I should go from here to find out what the 
problem is?

cheers

andrew
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: cygcheck.out
URL: <http://cygwin.com/pipermail/cygwin/attachments/20100502/c99e55c2/attachment.ksh>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: gdb.out
URL: <http://cygwin.com/pipermail/cygwin/attachments/20100502/c99e55c2/attachment-0001.ksh>
-------------- next part --------------
--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple