SPI_getvalue problem
От | Alex Guryanow |
---|---|
Тема | SPI_getvalue problem |
Дата | |
Msg-id | 13740.010128@nlr.ru обсуждение исходный текст |
Ответы |
Re: SPI_getvalue problem
|
Список | 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
В списке pgsql-general по дате отправления: