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
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 |