SPI_getvalue problem

From: Alex Guryanow <gav(at)nlr(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: SPI_getvalue problem
Date: 2001-01-28 14:46:49
Message-ID: 13740.010128@nlr.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have the following problem: the backend crashes on Solaris while executing the function
SPI_getvalue.

I have small database on Intel/Linux that works fine. Now I need to transfer them to
Sparc/Solaris. This database contains a small trigger written in C++. After installing
postgresql-7.0.3 on Solaris and compiling the trigger function by inserting a new row in table I
receive the following:

pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
connection to server was lost

And in postgres log I receive:

DEBUG: start update_prednet_words function
DEBUG: before 1 SPI
DEBUG: triggered for relation magazine
Server process (pid 1397) exited with status 139 at Sun Jan 28 17:23:48 2001
Terminating any active server processes...
Server processes were terminated at Sun Jan 28 17:23:48 2001
Reinitializing shared memory and semaphores
DEBUG: Data Base System is starting up at Sun Jan 28 17:23:48 2001
DEBUG: Data Base System was interrupted being in production at Sun Jan 28 17:23:30 2001
DEBUG: Data Base System is in production state at Sun Jan 28 17:23:48 2001

First 3 lines are from my C-function, after logging the string "triggered for relation ..." it calls
SPI_getvalue. And the backend crashes. And this happens on Solaris 2.6 and Solaris 2.8 for both
postgresql-7.0.2 and 7.0.3. At the same time on Linux this trigger works fine.

Is this a bug or my misconfuguration?

My setup is
Linux: RedHat 6.2, Intel Pentium II-400, 128 Mb
Solris: SunOS 5.8 Generic_108528-02 sun4u sparc SUNW,Ultra-60,
SunOS 5.6 Generic_105181-19 sun4u sparc SUNW,Ultra-1
postgres is configured in the following way:
./configure --enable-locale --enable-multibyte=UNICODE

Best regards,
Alex Guryanow

Responses

Browse pgsql-general by date

  From Date Subject
Next Message James Thompson 2001-01-28 15:36:10 Re: GUI Interfaces
Previous Message Adam Lang 2001-01-28 14:33:50 Re: LinuxWorld NYC