Port Bug Report: lo_import causes the back-end to dump core - Mailing list pgsql-ports

============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name        : Hassan Hassoun
Your email address    : hhassoun@aub.edu.lb

Category        : runtime: back-end
Severity        : serious

Summary: lo_import causes the back-end to dump core

System Configuration
- --------------------
  Operating System   : Solaris 2.6

  PostgreSQL version : 6.4

  Compiler used      : gcc 2.8.1

Hardware:
- ---------
Sparc station 2 , 32Meg Ram

Versions of other tools:
- ------------------------
GNU Make version 3.76.1
flex version 2.5.4



- --------------------------------------------------------------------------

Problem Description:
- --------------------
I have included a truss output of the backend and the
corresponding psql session (below)

- --------------------------------------------------------------------------

Test Case:
- ----------
unlink("/usr/local/pgsql6.4/data/base/test/pg_btsortXBTF3V_") = 0
close(43)                                       = 0
unlink("/usr/local/pgsql6.4/data/base/test/pg_btsortX0XYDsh") = 0
close(44)                                       = 0
unlink("/usr/local/pgsql6.4/data/base/test/pg_btsortXla9ZG_") = 0
close(45)                                       = 0
unlink("/usr/local/pgsql6.4/data/base/test/pg_btsortXH2dt3_") = 0
close(46)                                       = 0
unlink("/usr/local/pgsql6.4/data/base/test/pg_btsortX0Bq2r_") = 0
lseek(8, 0, SEEK_END)                           = 8192
lseek(8, 0, SEEK_END)                           = 8192
read(29, " G I F 8 9 a0301  \0F7\0".., 1024)    = 1024
lseek(30, 0, SEEK_END)                          = 0
lseek(30, 0, SEEK_END)                          = 0
write(30, "\0\0\0\0\0\0\0\0\0\0\0\0".., 8192)   = 8192
lseek(30, 0, SEEK_END)                          = 8192
lseek(30, 0, SEEK_END)                          = 8192
write(30, "\0\0\0\0\0\0\0\0\0\0\0\0".., 8192)   = 8192
    Incurred fault #5, FLTACCESS  %pc = 0x0012A500
      siginfo: SIGBUS BUS_ADRALN addr=0x002686FF
    Received signal #10, SIGBUS [default]
      siginfo: SIGBUS BUS_ADRALN addr=0x002686FF
  *** process killed ***




^^^^^^^^^^^^^^^^END of Backend Trace^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^


> psql test
Welcome to the POSTGRESQL interactive sql monitor:
  Please read the file COPYRIGHT for copyright terms of POSTGRESQL

   type \? for help on slash commands
   type \q to quit
   type \g or terminate with semicolon to execute query
 You are currently connected to the database: test

test=> select * from image;
name|raster
- ----+------
(0 rows)

test=> INSERT INTO image (name, raster) VALUES ('beautiful image', lo_import('/tmp/img'));
ERROR:  cannot create xinv18465
ERROR:  cannot create xinv18465
test=>  INSERT INTO image (name, raster) VALUES ('beautiful image', lo_import('/tmp/img'));
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally before or while processing the request.
We have lost the connection to the backend, so further processing is impossible.  Terminating.
>


- --------------------------------------------------------------------------

Solution:
- ---------


- --------------------------------------------------------------------------