BUG #6684: An I/O error occured while sending to the backend

The following bug has been logged on the website:

Bug reference:      6684
Logged by:          wbrana
Email address:      wbrana@gmail.com
PostgreSQL version: 9.1.4
Operating system:   Linux
Description:=20=20=20=20=20=20=20=20

I tried to post this to pgsql-jdbc, but it was blocked.

java version "1.7.0_04"
Java(TM) SE Runtime Environment (build 1.7.0_04-b20)
Java HotSpot(TM) Client VM (build 23.0-b21, mixed mode)

    public Connection getConn(){
        if (conn =3D=3D null) {
            try {
                    Class.forName("org.postgresql.Driver"); //load the driver
                    conn =3D
DriverManager.getConnection("jdbc:postgresql://localhost/forum?loglevel=3D1=
","forum","forum");
            } catch (Exception e) {
                if (debug) {
                    e.printStackTrace();
                }
            }
        }
        return conn;
    }

forum.ViewsThread.run:
    public void run() {
        Connection conn =3D new Jdbc().getConn();
        try {
            conn.setAutoCommit(false);
            conn.prepareStatement("analyze forum_cats").executeUpdate();
            conn.prepareStatement("analyze forums").executeUpdate();
            conn.prepareStatement("analyze groups").executeUpdate();
            conn.prepareStatement("analyze posts").executeUpdate(); // Line 77
            conn.prepareStatement("analyze threads").executeUpdate();
            conn.prepareStatement("analyze user_groups").executeUpdate();
            conn.prepareStatement("analyze users").executeUpdate();
            conn.commit();

2012-06-09 12:43:52.654 CEST,,,2285,"",4fd328e8.8ed,1,"",2012-06-09
12:43:52 CEST,,0,LOG,00000,"connection received: host=3D127.0.0.1
port=3D55770",,,,,,,,,""
2012-06-09 12:43:52.656
CEST,"forum","forum",2285,"127.0.0.1:55770",4fd328e8.8ed,2,"authentication"=
,2012-06-09
12:43:52 CEST,10/151,0,LOG,00000,"connection authorized: user=3Dforum
database=3Dforum",,,,,,,,,""
2012-06-09 12:43:52.658
CEST,"forum","forum",2285,"127.0.0.1:55770",4fd328e8.8ed,3,"SET",2012-06-09
12:43:52 CEST,10/152,0,LOG,00000,"execute <unnamed>: SET
extra_float_digits =3D 3",,,,,,,,,""
2012-06-09 12:43:52.668
CEST,"forum","forum",2285,"127.0.0.1:55770",4fd328e8.8ed,4,"BEGIN",2012-06-=
09
12:43:52 CEST,10/153,0,LOG,00000,"execute S_1: BEGIN",,,,,,,,,""
2012-06-09 12:43:52.668
CEST,"forum","forum",2285,"127.0.0.1:55770",4fd328e8.8ed,5,"ANALYZE",2012-0=
6-09
12:43:52 CEST,10/153,0,LOG,00000,"execute <unnamed>: analyze
forum_cats",,,,,,,,,""
2012-06-09 12:43:52.670
CEST,"forum","forum",2285,"127.0.0.1:55770",4fd328e8.8ed,6,"ANALYZE",2012-0=
6-09
12:43:52 CEST,10/153,6274,LOG,00000,"execute <unnamed>: analyze
forums",,,,,,,,,""
2012-06-09 12:43:52.671
CEST,"forum","forum",2285,"127.0.0.1:55770",4fd328e8.8ed,7,"ANALYZE",2012-0=
6-09
12:43:52 CEST,10/153,6274,LOG,00000,"execute <unnamed>: analyze
groups",,,,,,,,,""
2012-06-09 12:43:52.671
CEST,"forum","forum",2285,"127.0.0.1:55770",4fd328e8.8ed,8,"ANALYZE",2012-0=
6-09
12:43:52 CEST,10/153,6274,LOG,00000,"execute <unnamed>: analyze
posts",,,,,,,,,""
2012-06-09 12:43:52.691
CEST,"forum","forum",2228,"127.0.0.1:55758",4fd328e4.8b4,8,"SELECT",2012-06=
-09
12:43:48 CEST,2/184,0,LOG,00000,"execute <unnamed>: SELECT forum_id,
cat_id, cat_name, forum_description, forum_name, login, post_count,
post_created, thread_count, thread_name FROM v_forums",,,,,,,,,""
2012-06-09 12:43:52.696
CEST,"forum","forum",2228,"127.0.0.1:55758",4fd328e4.8b4,9,"SET",2012-06-09
12:43:48 CEST,2/185,0,LOG,00000,"execute <unnamed>: SET
application_name =3D ''",,,,,,,,,""
2012-06-09 12:43:53.080
CEST,"forum","forum",2285,"127.0.0.1:55770",4fd328e8.8ed,9,"idle in
transaction",2012-06-09 12:43:52 CEST,,0,LOG,00000,"disconnection:
session time: 0:00:00.425 user=3Dforum database=3Dforum host=3D127.0.0.1
port=3D55770",,,,,,,,,""

Launching GlassFish on Felix platform
INFO: Running GlassFish Version: GlassFish Server Open Source Edition
3.1.2 (build 23)
INFO: Grizzly Framework 1.9.46 started in: 33ms - bound to [0.0.0.0:8181]
INFO: Grizzly Framework 1.9.46 started in: 29ms - bound to [0.0.0.0:4848]
INFO: Grizzly Framework 1.9.46 started in: 47ms - bound to [0.0.0.0:8080]
INFO: Grizzly Framework 1.9.46 started in: 22ms - bound to [0.0.0.0:3700]
INFO: Grizzly Framework 1.9.46 started in: 15ms - bound to [0.0.0.0:7676]
INFO: The Admin Console is already installed, but not yet loaded.
INFO: Registered
org.glassfish.ha.store.adapter.cache.ShoalBackingStoreProxy for
persistence-type =3D replicated in BackingStoreFactoryRegistry
INFO: Created EjbThreadPoolExecutor with thread-core-pool-size 16
thread-max-pool-size 32 thread-keep-alive-seconds 60
thread-queue-capacity 2147483647 allow-core-thread-timeout false
INFO: SEC1002: Security Manager is OFF.
INFO: SEC1010: Entering Security Startup Service
INFO: SEC1143: Loading policy provider
com.sun.enterprise.security.provider.PolicyWrapper.
INFO: SEC1115: Realm [admin-realm] of classtype
[com.sun.enterprise.security.auth.realm.file.FileRealm] successfully
created.
INFO: SEC1115: Realm [file] of classtype
[com.sun.enterprise.security.auth.realm.file.FileRealm] successfully
created.
INFO: SEC1115: Realm [certificate] of classtype
[com.sun.enterprise.security.auth.realm.certificate.CertificateRealm]
successfully created.
INFO: SEC1115: Realm [jdbcDigestRealm] of classtype
[com.sun.enterprise.security.auth.realm.jdbc.JDBCRealm] successfully
created.
INFO: SEC1011: Security Service(s) Started Successfully
INFO: WEB0169: Created HTTP listener [http-listener-1] on host/port
[0.0.0.0:8080]
INFO: WEB0169: Created HTTP listener [http-listener-2] on host/port
[0.0.0.0:8181]
INFO: WEB0169: Created HTTP listener [admin-listener] on host/port
[0.0.0.0:4848]
INFO: WEB0171: Created virtual server [server]
INFO: WEB0171: Created virtual server [__asadmin]
INFO: WEB0172: Virtual server [server] loaded default web module []
INFO: Hibernate Validator 4.2.0.Final
INFO: EclipseLink, version: Eclipse Persistence Services -
2.3.2.v20111125-r10461
INFO:
file:/home/x/NetBeansProjects/forum/build/web/WEB-INF/classes/_forumPU
login successful
WARNING: Multiple [2] JMX MBeanServer instances exist, we will use the
server at index [0] :
[com.sun.enterprise.v3.admin.DynamicInterceptor@1816407].
WARNING: JMX MBeanServer in use:
[com.sun.enterprise.v3.admin.DynamicInterceptor@1816407] from index
[0]
WARNING: JMX MBeanServer in use:
[com.sun.jmx.mbeanserver.JmxMBeanServer@1e2a099] from index [1]
INFO: EJB5181:Portable JNDI names for EJB ThreadsFacade:
[java:global/forum/ThreadsFacade,
java:global/forum/ThreadsFacade!forum.ThreadsFacade]
INFO: EJB5181:Portable JNDI names for EJB UsersFacade:
[java:global/forum/UsersFacade,
java:global/forum/UsersFacade!forum.UsersFacade]
INFO: EJB5181:Portable JNDI names for EJB ForumsPageFacade:
[java:global/forum/ForumsPageFacade,
java:global/forum/ForumsPageFacade!forum.ForumsPageFacade]
INFO: EJB5181:Portable JNDI names for EJB GroupsFacade:
[java:global/forum/GroupsFacade,
java:global/forum/GroupsFacade!forum.GroupsFacade]
INFO: EJB5181:Portable JNDI names for EJB VPostsFacade:
[java:global/forum/VPostsFacade!forum.VPostsFacade,
java:global/forum/VPostsFacade]
INFO: EJB5181:Portable JNDI names for EJB VThreads2Facade:
[java:global/forum/VThreads2Facade,
java:global/forum/VThreads2Facade!forum.VThreads2Facade]
INFO: EJB5181:Portable JNDI names for EJB VThreadsFacade:
[java:global/forum/VThreadsFacade,
java:global/forum/VThreadsFacade!forum.VThreadsFacade]
INFO: EJB5181:Portable JNDI names for EJB PostsFacade:
[java:global/forum/PostsFacade,
java:global/forum/PostsFacade!forum.PostsFacade]
INFO: EJB5181:Portable JNDI names for EJB ForumCatsFacade:
[java:global/forum/ForumCatsFacade,
java:global/forum/ForumCatsFacade!forum.ForumCatsFacade]
INFO: EJB5181:Portable JNDI names for EJB UserGroupsFacade:
[java:global/forum/UserGroupsFacade!forum.UserGroupsFacade,
java:global/forum/UserGroupsFacade]
INFO: EJB5181:Portable JNDI names for EJB VPostsFacade2:
[java:global/forum/VPostsFacade2!forum.VPostsFacade2,
java:global/forum/VPostsFacade2]
INFO: EJB5181:Portable JNDI names for EJB VUserRoleFacade:
[java:global/forum/VUserRoleFacade!forum.VUserRoleFacade,
java:global/forum/VUserRoleFacade]
INFO: EJB5181:Portable JNDI names for EJB AuthBackingBeanFacade:
[java:global/forum/AuthBackingBeanFacade!forum.AuthBackingBeanFacade,
java:global/forum/AuthBackingBeanFacade]
INFO: WELD-000900 1.1.4 (Final)
INFO: Initializing Mojarra 2.1.7 (SNAPSHOT 20120206) for context '/forum'
WARNING: JSF1074: Managed bean named 'customerCRUD' has already been
registered.  Replacing existing managed bean class type
forum.CustomerCRUD with forum.CustomerCRUD.
INFO: Monitoring jndi:/server/forum/WEB-INF/faces-config.xml for
modifications
INFO: WEB0671: Loading application [forum] at [/forum]
INFO: CORE10010: Loading application forum done in 5,708 ms
INFO: GlassFish Server Open Source Edition 3.1.2 (23) startup time :
Felix (1,031ms), startup services(6,263ms), total(7,294ms)
INFO: JMX005: JMXStartupService had Started JMXConnector on JMXService
URL service:jmx:rmi://localhost:8686/jndi/rmi://localhost:8686/jmxrmi
INFO: Initiating Jersey application, version 'Jersey: 1.11 12/09/2011 10:27
AM'
INFO: WEB0169: Created HTTP listener [http-listener-1] on host/port
[0.0.0.0:8080]
INFO: Grizzly Framework 1.9.46 started in: 1ms - bound to [0.0.0.0:8080]
INFO: 12:43:52.653 (9) PostgreSQL 9.2devel JDBC4 (build 1000)

INFO: getConnection returning org.postgresql.Driver

INFO: REST00001: Listening to REST requests at context: /management/domain
INFO: The Admin Console is already installed, but not yet loaded.
INFO: The Admin Console is starting. Please wait.
INFO: org.postgresql.util.PSQLException: An I/O error occured while
sending to the backend.

INFO:     at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:281)

INFO:     at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.=
java:553)

INFO:     at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2S=
tatement.java:415)

INFO:     at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Stat=
ement.java:361)

INFO:     at forum.ViewsThread.run(ViewsThread.java:77)

INFO: SQLException: SQLState(08006)

SEVERE: org.postgresql.util.PSQLException: An I/O error occured while
sending to the backend.
    at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:281)
    at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.=
java:553)
    at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2S=
tatement.java:415)
    at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Stat=
ement.java:361)
    at forum.ViewsThread.run(ViewsThread.java:77)
Caused by: java.net.SocketException: Socket closed
    at java.net.SocketInputStream.socketRead0(Native Method)
    at java.net.SocketInputStream.read(SocketInputStream.java:150)
    at java.net.SocketInputStream.read(SocketInputStream.java:121)
    at
org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInpu=
tStream.java:143)
    at
org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedI=
nputStream.java:112)
    at
org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStr=
eam.java:71)
    at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:272)
    at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.j=
ava:1700)
    at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
    ... 4 more

SEVERE:     at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:281)
SEVERE:     at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.=
java:553)
SEVERE:     at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2S=
tatement.java:415)
SEVERE:     at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Stat=
ement.java:361)
SEVERE:     at forum.ViewsThread.run(ViewsThread.java:77)
SEVERE: Caused by: java.net.SocketException: Socket closed
SEVERE:     at java.net.SocketInputStream.socketRead0(Native Method)
SEVERE:     at java.net.SocketInputStream.read(SocketInputStream.java:150)
SEVERE:     at java.net.SocketInputStream.read(SocketInputStream.java:121)
SEVERE:     at
org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInpu=
tStream.java:143)
SEVERE:     at
org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedI=
nputStream.java:112)
SEVERE:     at
org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStr=
eam.java:71)
SEVERE:     at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:272)
SEVERE:     at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.j=
ava:1700)
SEVERE:     at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
SEVERE:     ... 4 more
INFO: org.postgresql.util.PSQLException: This connection has been closed.

INFO:     at
org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Conne=
ction.java:823)

INFO:     at
org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connecti=
on.java:840)

INFO:     at forum.ViewsThread.run(ViewsThread.java:86)

INFO: SQLException: SQLState(08003)

SEVERE: org.postgresql.util.PSQLException: This connection has been closed.
    at
org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Conne=
ction.java:823)
    at
org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connecti=
on.java:840)
    at forum.ViewsThread.run(ViewsThread.java:86)

SEVERE:     at
org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Conne=
ction.java:823)
SEVERE:     at
org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connecti=
on.java:840)
SEVERE:     at forum.ViewsThread.run(ViewsThread.java:86)