server process (PID 1188) exited with exit code -1073741819, 8.2 beta1
От | JEAN-PIERRE PELLETIER |
---|---|
Тема | server process (PID 1188) exited with exit code -1073741819, 8.2 beta1 |
Дата | |
Msg-id | BAY118-F910FFA84302F2F0EA339D95010@phx.gbl обсуждение исходный текст |
Ответы |
Re: server process (PID 1188) exited with exit code -1073741819, 8.2 beta1
|
Список | pgsql-jdbc |
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
В списке pgsql-jdbc по дате отправления: