SIGBUS in AllocSetAlloc & jdbc

Peter, I hope this long and boring message can shed some light on my
difficulties getting jdbc & postgres6.5b1(current snapshot) to work
with blobs. I have NO problem with text, numeric, etc. Just blobs &
the LO interface.

I feel that it is a 64 vs 32 bit memory management problem.

My system:

uname -a
SunOS vlad 5.7 Generic_106541-03 sun4u sparc SUNW,Ultra-5_10

postgreSQL:
[PostgreSQL 6.5.0 on sparc-sun-solaris2.7, compiled by cc ]

cc -V
cc: WorkShop Compilers 5.0 98/12/15 C 5.0

The database & tables:

mini_stores=> select * from item;
item_num|item_picture|item_descr
|ship_unit |unit_price|stock
--------+------------+--------------------------------------------------------------+----------+----------+-----

1| 18602|Maximum protection for high-mileage
runners |pair |$75.50 | 1000
2| 18617|Customize your mountain bike with extra-durable
crankset |each |$20.00 | 500
3| 18634|Long drive golf balls -fluorescent
yellow |pack of 12|$50.00 | 200
4| 18652|Your first season's baseball
glove |pair |$25.00 | 250
5| 18668|Minimum chin contact, feather-light, maximum
protection helmet|each |$35.50 | 50
(5 rows)

Now the java code that reads the item table and tries to display the
image & data. This is "borrowed" from an example from informix &
their store7/mini_stores jdbc examples.
-----BEGIN---
/***************************************************************************

*
* Title: demo4.java
*
* Description: To use the fetch_buf_size connection parameter to
* optimize the query and retrieve large byte data in
the
* form of an image
*
* An example of running the program:
*
* java demo4 jdbc:postgresql:mini_stores <userid> <password>
*
***************************************************************************

*/

import java.awt.*;
import java.awt.image.*;
import java.awt.event.*;
import java.sql.*;

public class demo4 extends Frame {
static String connURL; // the URL to be used for establishing the
JDBC
static String usr; // the user id to connect with.
static String pwd; // the pasword of the user id.

Connection conn; // the database connection
ResultSet queryResults; // the ResultSet containing the rows
returned by

// The GUI controls
Label itemNumLabel;
TextField itemNumField;
Label itemDescrLabel;
TextArea itemDescrArea;
Label shipUnitLabel;
TextField shipUnitField;
Label unitPriceLabel;
TextField unitPriceField;
Label stockLabel;
TextField stockField;
Label itemPictureLabel;
ImgCanvas itemPictureCanvas;
Button nextRowBtn;

public static void main(String args[]) {
if (args.length != 0) {
connURL = args[0];
usr = args[1];
pwd = args[2];
demo4 thisDemo = new demo4();
} else {
System.out.println("Missing input!! Please specify the connection
URL");
System.out.println("Usage...java demo4 <jdbc_conn_url>");
}
}

public demo4() {
super();
createControls();
connectToDBServer();
executeQuery();
}

private void createControls() {
setLayout(null);
setSize(700,500);
setVisible(true);
setTitle("Item Table Data");

// Adding label & text-field for item_num column
itemNumLabel = new Label("Item Num");
itemNumLabel.setBounds(12,24,60,24);
add(itemNumLabel);
itemNumField = new TextField();
itemNumField.setBounds(84,24,50,38);
add(itemNumField);

// Adding label and text-area for item_descr column
itemDescrLabel = new Label("Item Description");
itemDescrLabel.setBounds(12,72,96,24);
add(itemDescrLabel);
itemDescrArea = new TextArea();
itemDescrArea.setBounds(12,108,194,168);
add(itemDescrArea);

// Adding label & text-field for ship_unit column
shipUnitLabel = new Label("Ship Unit");
shipUnitLabel.setBounds(24,288,60,38);
add(shipUnitLabel);
shipUnitField = new TextField();
shipUnitField.setBounds(84,288,84,38);
add(shipUnitField);

// Adding label & text-field for unit_price column
unitPriceLabel = new Label("Unit Price");
unitPriceLabel.setBounds(24,336,60,38);
add(unitPriceLabel);
unitPriceField = new TextField();
unitPriceField.setBounds(84,336,84,38);
add(unitPriceField);

// Adding label & text-field for stock column
stockLabel = new Label("Stock");
stockLabel.setBounds(36,384,36,38);
add(stockLabel);
stockField = new TextField();
stockField.setBounds(84,384,84,38);
add(stockField);

// Adding label & ImgCanvas for item_picture column
itemPictureLabel = new Label("Item Picture");
itemPictureLabel.setBounds(216,24,72,24);
add(itemPictureLabel);
itemPictureCanvas = new ImgCanvas();
itemPictureCanvas.setBounds(216,60,480,432);
add(itemPictureCanvas);

// Adding Next Row button
nextRowBtn = new Button("Next Row");
nextRowBtn.setBounds(60,432,84,48);
add(nextRowBtn);

// Adding actionListener for button action events
nextRowBtn.addActionListener((ActionListener)
new nextRowBtnActionListener());

// Adding WindowListener for the main frame to process window events
addWindowListener((WindowListener) new demo4WindowAdapter());
}

private void connectToDBServer() {
try {
String psqlDriver = "postgresql.Driver";

// Register the POSTGRESQL-JDBC driver
Driver PgsqlDrv = (Driver) Class.forName(psqlDriver).newInstance();

// Get a connection to the database server
conn = DriverManager.getConnection(connURL, usr, pwd);

System.out.println("Driver loaded...and connection established");
} catch (Exception e) {
System.out.println("Could not connect to database server....");
System.out.println(e.getMessage());
}
}

private void executeQuery() {
// The select statement to be used for querying the item table
String selectStmt = "SELECT * FROM item";

try {
// Create a Statement object and use it to execute the query
Statement stmt = conn.createStatement();
queryResults = stmt.executeQuery(selectStmt);

System.out.println("Query executed...");
} catch (Exception e) {
System.out.println("Could not execute query....");
System.out.println(e.getMessage());
}
}

// Private inner class extending java.awt.Canvas
// Will be used for displaying the item_picture image
private class ImgCanvas extends Canvas {
Image myImage;

private ImgCanvas() {
super();
myImage = null;
}

private void setImage(Image img) {
myImage = img;
}

public void paint(Graphics g) {
if(myImage == null)
return;
else
g.drawImage(myImage, 0, 0, this);
}
}

// Private inner class implementing the ActionListener interface
// for the 'Next Row' button
private class nextRowBtnActionListener implements ActionListener {
// This is the code that will be executed whenever the 'Next Row'
// button is pressed
// Here, we get the values of all the columns of the current row
// and display them
public void actionPerformed(ActionEvent evt) {
try {
if (queryResults.next()) {
// Getting the values of the item_num, ship_unit
// unit_price, item_descr & stock columns and displaying them
itemNumField.setText(queryResults.getString(1));
itemDescrArea.setText(queryResults.getString(3));
shipUnitField.setText(queryResults.getString(4));
unitPriceField.setText(queryResults.getString(5));
stockField.setText(queryResults.getString(6));

// Getting the value of the item_picture column and
// displaying it
System.err.println("Got oid "+queryResults.getInt(2));
byte itemPictureArray [] = queryResults.getBytes(2);
if (itemPictureArray != null) {
Image img =
Toolkit.getDefaultToolkit().createImage(itemPictureArray);
itemPictureCanvas.setImage(img);
itemPictureCanvas.repaint();
}
} else {
System.out.println("No more rows!!");
}
} catch (Exception e) {
System.out.println("Could not display next row...");
System.out.println(e.getMessage());
}
}
}

// Private inner class implementing the WindowAdapter interface
// for the main frame window
private class demo4WindowAdapter extends WindowAdapter {
// This is the code that will be executed whenever the frame
// window is closed using the button in its upper-right corner
public void windowClosing(WindowEvent evt) {
setVisible(false); // hide the main frame
dispose(); // free the system resources
System.exit(0); // close the application
}
}
}
------END----

Now I start it & attach to the backend with gdb. After the frame is
up, I can select the next row (the first). It works as it should.
When I select next (for the second), then I get the following back
trace:

vlad: ps -ef | grep po
root 272 1 0 Apr 27 ? 0:00 /usr/lib/power/powerd
bpm 771 1 0 10:45:48 pts/2 0:00 /opt/pgsql/bin/postmaster
-o -F -o /opt/pgsql/logs/backend.log -S 16384 -i -p 5
bpm 796 771 1 10:53:49 pts/2 0:00 /opt/pgsql/bin/postmaster
-o -F -o /opt/pgsql/logs/backend.log -S 16384 -i -p 5
bpm 798 1153 0 10:53:53 pts/10 0:00 grep po
vlad: gdb /opt/pgsql/bin/postmaster 796
GNU gdb 4.17
Copyright 1998 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you
are
welcome to change it and/or distribute copies of it under certain
conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB. Type "show warranty" for
details.
This GDB was configured as "sparc-sun-solaris2.7"...
(no debugging symbols found)...

/home/bpm/development/perl_ext/DBD-Pg-0.91/796: No such file or
directory.
Attaching to program `/opt/pgsql/bin/postmaster', process 796
Reading symbols from /usr/lib/libgen.so.1...(no debugging symbols
found)...
done.
Reading symbols from /usr/lib/libcrypt_i.so.1...(no debugging symbols
found)...
done.
Reading symbols from /usr/lib/libnsl.so.1...(no debugging symbols
found)...
done.
Reading symbols from /usr/lib/libsocket.so.1...(no debugging symbols
found)...
done.
Reading symbols from /usr/lib/libdl.so.1...(no debugging symbols
found)...done.
Reading symbols from /usr/lib/libm.so.1...(no debugging symbols
found)...done.
Reading symbols from /usr/lib/libcurses.so.1...(no debugging symbols
found)...
done.
Reading symbols from /usr/lib/libc.so.1...(no debugging symbols
found)...done.
Reading symbols from /usr/lib/libmp.so.2...(no debugging symbols
found)...done.
Reading symbols from /usr/platform/SUNW,Ultra-5_10/lib/libc_psr.so.1...
---Type <return> to continue, or q <return> to quit---
(no debugging symbols found)...done.
Reading symbols from /usr/lib/nss_files.so.1...(no debugging symbols
found)...
done.
Symbols already loaded for /usr/lib/libgen.so.1
Symbols already loaded for /usr/lib/libcrypt_i.so.1
Symbols already loaded for /usr/lib/libnsl.so.1
Symbols already loaded for /usr/lib/libsocket.so.1
Symbols already loaded for /usr/lib/libdl.so.1
Symbols already loaded for /usr/lib/libm.so.1
Symbols already loaded for /usr/lib/libcurses.so.1
Symbols already loaded for /usr/lib/libc.so.1
Symbols already loaded for /usr/lib/libmp.so.2
Symbols already loaded for
/usr/platform/SUNW,Ultra-5_10/lib/libc_psr.so.1
Symbols already loaded for /usr/lib/nss_files.so.1
0xff19311c in _so_recv ()
(gdb) bt
#0 0xff19311c in _so_recv ()
#1 0xbb4d4 in pq_recvbuf ()
#2 0xbb710 in pq_getbytes ()
#3 0x13e020 in SocketBackend ()
#4 0x13e124 in ReadCommand ()
#5 0x140434 in PostgresMain ()
#6 0x11161c in DoBackend ()
#7 0x110e78 in BackendStartup ()
#8 0x10fd98 in ServerLoop ()
#9 0x10f6e0 in PostmasterMain ()
#10 0xbca58 in main ()
(gdb) c
Continuing.

Program received signal SIGBUS, Bus error.
0x19f180 in AllocSetAlloc ()
(gdb) bt
#0 0x19f180 in AllocSetAlloc ()
#1 0x19fa2c in GlobalMemoryAlloc ()
#2 0x19f7b8 in MemoryContextAlloc ()
#3 0x19fc58 in pstrdup ()
#4 0x1331c4 in inv_open ()
#5 0xb3e18 in lo_open ()
#6 0x199e38 in fmgr_c ()
#7 0x19a46c in fmgr ()
#8 0x13dc44 in HandleFunctionRequest ()
#9 0x14048c in PostgresMain ()
#10 0x11161c in DoBackend ()
#11 0x110e78 in BackendStartup ()
#12 0x10fd98 in ServerLoop ()
#13 0x10f6e0 in PostmasterMain ()
#14 0xbca58 in main ()

######## NEXT EXAMPLE ###############

I stopped/started the postmaster as:
/opt/pgsql/bin/postmaster -o "-d 3 -F -o ${PGSQLHOME}/logs/backend.log
-W 30 -S 16384" \
-i -d 3 -p 5432 -D ${PGDATA} >
${PGSQLHOME}/logs/error.log 2>&1 &

Now I ran the examples/blobtest, attached to the backend & got the
following:

vlad: ps -ef | grep po
root 272 1 0 Apr 27 ? 0:00 /usr/lib/power/powerd
bpm 815 1 0 11:00:58 pts/2 0:00 /opt/pgsql/bin/postmaster
-o -F -o /opt/pgsql/logs/backend.log -W 30 -S 16384 -
bpm 830 815 0 11:01:37 pts/2 0:00 /opt/pgsql/bin/postmaster
-o -F -o /opt/pgsql/logs/backend.log -W 30 -S 16384 -
bpm 833 1153 0 11:01:45 pts/10 0:00 grep po
vlad: gdb /opt/pgsql/bin/postmaster 830
GNU gdb 4.17
Copyright 1998 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you
are
welcome to change it and/or distribute copies of it under certain
conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB. Type "show warranty" for
details.
This GDB was configured as "sparc-sun-solaris2.7"...
(no debugging symbols found)...

/opt/pgsql/logs/830: No such file or directory.
Attaching to program `/opt/pgsql/bin/postmaster', process 830
Reading symbols from /usr/lib/libgen.so.1...(no debugging symbols
found)...
done.
Reading symbols from /usr/lib/libcrypt_i.so.1...(no debugging symbols
found)...
done.
Reading symbols from /usr/lib/libnsl.so.1...(no debugging symbols
found)...
done.
Reading symbols from /usr/lib/libsocket.so.1...(no debugging symbols
found)...
done.
Reading symbols from /usr/lib/libdl.so.1...(no debugging symbols
found)...done.
Reading symbols from /usr/lib/libm.so.1...(no debugging symbols
found)...done.
Reading symbols from /usr/lib/libcurses.so.1...(no debugging symbols
found)...
done.
Reading symbols from /usr/lib/libc.so.1...(no debugging symbols
found)...done.
Reading symbols from /usr/lib/libmp.so.2...(no debugging symbols
found)...done.
Reading symbols from /usr/platform/SUNW,Ultra-5_10/lib/libc_psr.so.1...
---Type <return> to continue, or q <return> to quit---
(no debugging symbols found)...done.
Reading symbols from /usr/lib/nss_files.so.1...(no debugging symbols
found)...
done.
Symbols already loaded for /usr/lib/libgen.so.1
Symbols already loaded for /usr/lib/libcrypt_i.so.1
Symbols already loaded for /usr/lib/libnsl.so.1
Symbols already loaded for /usr/lib/libsocket.so.1
Symbols already loaded for /usr/lib/libdl.so.1
Symbols already loaded for /usr/lib/libm.so.1
Symbols already loaded for /usr/lib/libcurses.so.1
Symbols already loaded for /usr/lib/libc.so.1
Symbols already loaded for /usr/lib/libmp.so.2
Symbols already loaded for
/usr/platform/SUNW,Ultra-5_10/lib/libc_psr.so.1
Symbols already loaded for /usr/lib/nss_files.so.1
0xff195d88 in _sigsuspend ()
(gdb) c
Continuing.

Program received signal SIGSEGV, Segmentation fault.
0x19f180 in AllocSetAlloc ()
(gdb) bt
#0 0x19f180 in AllocSetAlloc ()
#1 0x19fa2c in GlobalMemoryAlloc ()
#2 0x19f7b8 in MemoryContextAlloc ()
#3 0x5b69c in btrescan ()
#4 0x199e60 in fmgr_c ()
#5 0x19a46c in fmgr ()
#6 0x4d3a0 in index_rescan ()
#7 0x4cc70 in RelationGetIndexScan ()
#8 0x5b4d0 in btbeginscan ()
#9 0x199e8c in fmgr_c ()
#10 0x19a46c in fmgr ()
#11 0x4d2e4 in index_beginscan ()
#12 0x133624 in inv_seek ()
#13 0xb4070 in lo_lseek ()
#14 0x199e60 in fmgr_c ()
#15 0x19a46c in fmgr ()
#16 0x13dc44 in HandleFunctionRequest ()
#17 0x14048c in PostgresMain ()
#18 0x11161c in DoBackend ()
#19 0x110e78 in BackendStartup ()
#20 0x10fd98 in ServerLoop ()
#21 0x10f6e0 in PostmasterMain ()
#22 0xbca58 in main ()

I looked at src/backend/utils/mmgr/aset.c to see what was going on in
AllocSetAlloc, but I am but a mere mortal.

Thanks.

--
Brian Millett
Enterprise Consulting Group "Heaven can not exist,
(314) 205-9030 If the family is not eternal"
bpm(at)ec-group(dot)com F. Ballard Washburn