More help on PL/Perl

From: oberpwd(at)anubis(dot)network(dot)com (Wade D(dot) Oberpriller)
To: pgsql-general(at)postgresql(dot)org (general-help postgresql)
Subject: More help on PL/Perl
Date: 2000-11-12 03:22:06
Message-ID: 200011120322.VAA29665@truck.network.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I found my path problem. I set LD_LIBRARY_PATH to include the directory
where libperl.so existed (It wasn't where I thought it was.)

Now when I execute some simple plperl code, it crashes the backend:

cdt=# SELECT f();
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Server process (pid 29083) exited with status 11 at Sat Nov 11 21:17:31 2000
Terminating any active server processes...
Server processes were terminated at Sat Nov 11 21:17:31 2000
Reinitializing shared memory and semaphores
DEBUG: Data Base System is starting up at Sat Nov 11 21:17:31 2000
The Data Base System is starting up
Failed.
!# DEBUG: Data Base System was interrupted being in production at Sat Nov 11 21:14:31 2000
DEBUG: Data Base System is in production state at Sat Nov 11 21:17:31 2000

I am using PostgreSQL 7.0.2 and Perl 5.005_03.

Wade Oberpriller

Browse pgsql-general by date

  From Date Subject
Next Message Tod McQuillin 2000-11-12 04:05:37 Re: Query error corrected after vacuum
Previous Message Matt Doucleff 2000-11-12 01:29:31 Query error corrected after vacuum