Thread: An I/O error occured while sending to the backend
public Connection getConn(){
if (conn == null) {
try {
Class.forName("org.postgresql.Driver"); //load the driver
conn = DriverManager.getConnection("jdbc:postgresql://localhost/forum?loglevel=1","forum","forum");
} catch (Exception e) {
if (debug) {
e.printStackTrace();
}
}
}
return conn;
}
forum.ViewsThread.run:
public void run() {
Connection conn = 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=127.0.0.1
port=55770",,,,,,,,,""
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=forum
database=forum",,,,,,,,,""
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 = 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-06-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-06-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-06-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-06-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 = ''",,,,,,,,,""
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=forum database=forum host=127.0.0.1
port=55770",,,,,,,,,""
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 = 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(AbstractJdbc2Statement.java:415)
INFO: at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.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(AbstractJdbc2Statement.java:415)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.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(VisibleBufferedInputStream.java:143)
at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:112)
at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:71)
at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:272)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java: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(AbstractJdbc2Statement.java:415)
SEVERE: at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.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(VisibleBufferedInputStream.java:143)
SEVERE: at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:112)
SEVERE: at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:71)
SEVERE: at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:272)
SEVERE: at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java: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(AbstractJdbc2Connection.java:823)
INFO: at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.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(AbstractJdbc2Connection.java:823)
at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:840)
at forum.ViewsThread.run(ViewsThread.java:86)
SEVERE: at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:823)
SEVERE: at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:840)
SEVERE: at forum.ViewsThread.run(ViewsThread.java:86)
Any chance we can see the server logs ? do you have statement timeout set on the server ? Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On Sat, Jun 9, 2012 at 7:25 AM, wbrana <wbrana@gmail.com> wrote: > public Connection getConn(){ > if (conn == null) { > try { > Class.forName("org.postgresql.Driver"); //load the driver > conn = DriverManager.getConnection("jdbc:postgresql://localhost/forum?loglevel=1","forum","forum"); > } catch (Exception e) { > if (debug) { > e.printStackTrace(); > } > } > } > return conn; > } > > forum.ViewsThread.run: > public void run() { > Connection conn = 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=127.0.0.1 > port=55770",,,,,,,,,"" > 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=forum > database=forum",,,,,,,,,"" > 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 = 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-06-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-06-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-06-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-06-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 = ''",,,,,,,,,"" > 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=forum database=forum host=127.0.0.1 > port=55770",,,,,,,,,"" > > 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 = 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(AbstractJdbc2Statement.java:415) > > INFO: at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.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(AbstractJdbc2Statement.java:415) > at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.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(VisibleBufferedInputStream.java:143) > at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:112) > at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:71) > at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:272) > at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java: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(AbstractJdbc2Statement.java:415) > SEVERE: at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.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(VisibleBufferedInputStream.java:143) > SEVERE: at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:112) > SEVERE: at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:71) > SEVERE: at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:272) > SEVERE: at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java: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(AbstractJdbc2Connection.java:823) > > INFO: at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.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(AbstractJdbc2Connection.java:823) > at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:840) > at forum.ViewsThread.run(ViewsThread.java:86) > > SEVERE: at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:823) > SEVERE: at org.postgresql.jdbc2.AbstractJdbc2Connection.rollback(AbstractJdbc2Connection.java:840) > SEVERE: at forum.ViewsThread.run(ViewsThread.java:86) > > -- > Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-jdbc
I reproduced error with 64-bit Java. java version "1.7.0_04" Java(TM) SE Runtime Environment (build 1.7.0_04-b20) Java HotSpot(TM) 64-Bit Server VM (build 23.0-b21, mixed mode) Logs, config, application uploaded http://www.mediafire.com/?5rnw1v4c0wygqya Application steps: scroll, click and wait, error occurred in less than 30 seconds
How about a tar file for the downloads. I certainly don't run windows. Dave Cramer dave.cramer(at)credativ(dot)ca http://www.credativ.ca On Mon, Jun 11, 2012 at 5:22 PM, wbrana <wbrana@gmail.com> wrote: > I reproduced error with 64-bit Java. > java version "1.7.0_04" > Java(TM) SE Runtime Environment (build 1.7.0_04-b20) > Java HotSpot(TM) 64-Bit Server VM (build 23.0-b21, mixed mode) > Logs, config, application uploaded > http://www.mediafire.com/?5rnw1v4c0wygqya > Application steps: scroll, click and wait, error occurred in less than > 30 seconds > > -- > Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-jdbc
This 2012-06-11 22:39:24.243 CEST forum forum 26187 127.0.0.1:33646 4fd65776.664b 99 idle 2012-06-11 22:39:18 CEST 0 LOG 0 disconnection: session time: 0:00:06.080 user=forum database=forum host=127.0.0.1 port=33646 log_disconnections, postgres.c:4375 Line shows that someone does a disconnect. Looks like con.close() is being called by someone. dave.cramer(at)credativ(dot)ca http://www.credativ.ca On Mon, Jun 11, 2012 at 5:55 PM, Dave Cramer <pg@fastcrypt.com> wrote: > How about a tar file for the downloads. I certainly don't run windows. > > Dave Cramer > > dave.cramer(at)credativ(dot)ca > http://www.credativ.ca > > > On Mon, Jun 11, 2012 at 5:22 PM, wbrana <wbrana@gmail.com> wrote: >> I reproduced error with 64-bit Java. >> java version "1.7.0_04" >> Java(TM) SE Runtime Environment (build 1.7.0_04-b20) >> Java HotSpot(TM) 64-Bit Server VM (build 23.0-b21, mixed mode) >> Logs, config, application uploaded >> http://www.mediafire.com/?5rnw1v4c0wygqya >> Application steps: scroll, click and wait, error occurred in less than >> 30 seconds >> >> -- >> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-jdbc
On Mon, Jun 11, 2012 at 11:55 PM, Dave Cramer <pg@fastcrypt.com> wrote: > How about a tar file for the downloads. I certainly don't run windows. trace.7z was created on Linux. tar.bz2: http://www.mediafire.com/?813ndtzt4o4bmyb
On 06/12/2012 05:55 AM, Dave Cramer wrote: > How about a tar file for the downloads. I certainly don't run windows. Just for the future: 7zip works well on Linux. In fact, I strongly prefer it to tar+gzip. It offers better compression ratios and much more robust archive files. yum install p7zip apt-get install p7zip-full Handily, as well as its own native high-compression-ratio archive format, 7zip deals with all those annoying RARs and ARJs and all that mess that people send around. (Digressing somewhat:) I don't understand why *nix users stick to tar. As a long-time Linux user, I avoid it and think tar files are obsolete. Creating an archive then compressing it with a stream cypher means that a one-bit error renders the archive completely destroyed after the error bit, so it's not good for backups. The compression ratio offered by tar+gzip is poor, so it isn't much good for file exchange unless you ditch gzip for bzip2, which is _really_ slow and still doesn't offer great compression ratios. Better IMO to stick to zip files, or 7zip when compression ratio matters. IMO about the only use for tar is if you need to archive device nodes, POSIX ACLs, xattrs, etc, in which case `star' or GNU tar are better choices. -- Craig Ringer
On 12/06/2012 09:04, Craig Ringer wrote: > (Digressing somewhat:) > > I don't understand why *nix users stick to tar. As a long-time Linux > user, I avoid it and think tar files are obsolete. Creating an archive > then compressing it with a stream cypher means that a one-bit error > renders the archive completely destroyed after the error bit, so it's > not good for backups. The compression ratio offered by tar+gzip is > poor, so it isn't much good for file exchange unless you ditch gzip > for bzip2, which is _really_ slow and still doesn't offer great > compression ratios. > > Better IMO to stick to zip files, or 7zip when compression ratio > matters. IMO about the only use for tar is if you need to archive > device nodes, POSIX ACLs, xattrs, etc, in which case `star' or GNU tar > are better choices. > The only reason I use tar is it preserves user information and permissions, which AFAIK the others don't (although never used p7zip) John -- Get the PriceGoblin Browser Addon www.pricegoblin.co.uk
On Tue, 2012-06-12 at 16:04 +0800, Craig Ringer wrote: > Just for the future: 7zip works well on Linux. Not to veer *too* far off-topic, but I don't trust any piece of software whose man page includes something like "CAUTION: this flag does not do what you think, avoid using it". -- Glenn Holmer Weyco Group, Inc. phone: 414-908-1809 fax: 414-908-1601
It seems to be Gentoo specific problem. I can't reproduce with client and server running on OpenSuse 12.1 32-bit or server running on Gentoo 64-bit and client running on Ubuntu 10.04 32-bit VirtualBox virtual machine.
On 06/12/2012 10:16 PM, Glenn Holmer wrote: > On Tue, 2012-06-12 at 16:04 +0800, Craig Ringer wrote: >> Just for the future: 7zip works well on Linux. > Not to veer *too* far off-topic, but I don't trust any piece of software > whose man page includes something like "CAUTION: this flag does not do > what you think, avoid using it". Yikes. I'd never noticed that before; good point. -- Craig Ringer