This is a server bug, I will post to hackers for you, it has little
to do with JDBC, however the ? can't be a column in a prepared statement
DAVE
On 24-Oct-06, at 4:45 PM, JEAN-PIERRE PELLETIER wrote:
Hi,
I have a query that throws "org.postgresql.util.PSQLException: An I/
O error occured while sending to the backend". Here is a simplified
version of it where I used pg_database, but any table or view do
the same.
PreparedStatement pstmt = connection.prepareStatement("select ?
from (select * from pg_database) t");
pstmt.setObject(1, 1);
ResultSet rs = pstmt.executeQuery();
It restarts PostgreSQL with this in the Log
2006-10-24 15:35:38 LOG: server process (PID 1188) exited with
exit code -1073741819
2006-10-24 15:35:38 LOG: terminating any other active server
processes
2006-10-24 15:35:38 LOG: all server processes terminated;
reinitializing
2006-10-24 15:35:39 LOG: database system was interrupted at
2006-10-24 15:34:54 Eastern Standard Time
2006-10-24 15:35:39 LOG: Windows fopen("recovery.conf","r")
failed: code 2, errno 2
2006-10-24 15:35:39 LOG: Windows fopen("pg_xlog/
00000001.history","r") failed: code 2, errno 2
2006-10-24 15:35:39 LOG: Windows fopen("backup_label","r") failed:
code 2, errno 2
2006-10-24 15:35:39 LOG: checkpoint record is at 0/31FDF0A0
2006-10-24 15:35:39 LOG: redo record is at 0/31FDF0A0; undo record
is at 0/0; shutdown TRUE
2006-10-24 15:35:39 LOG: next transaction ID: 0/22535; next OID:
101011
2006-10-24 15:35:39 LOG: next MultiXactId: 1; next MultiXactOffset: 0
2006-10-24 15:35:39 LOG: database system was not properly shut
down; automatic recovery in progress
2006-10-24 15:35:39 LOG: record with zero length at 0/31FDF0F0
2006-10-24 15:35:39 LOG: redo is not required
2006-10-24 15:35:40 LOG: database system is ready
2006-10-24 15:35:40 LOG: Windows fopen("global/pg_fsm.cache","rb")
failed: code 2, errno 2
2006-10-24 15:35:40 LOG: transaction ID wrap limit is 2147484172,
limited by database "postgres"
2006-10-24 15:36:40 LOG: Windows fopen("global/pgstat.stat","rb")
failed: code 2, errno 2
2006-10-24 15:36:40 LOG: Windows fopen("global/pgstat.stat","rb")
failed: code 2, errno 2
I am using PostgreSQL 8.2 beta1 on Windows XP, Service Pack 2
Both JDBC3 driver 8.1 build 407 and 8.2 build 503 do the same.
Thanks,
Jean-Pierre Pelletier
e-djuster
---------------------------(end of
broadcast)---------------------------
TIP 6: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq