Hi all,
Just wondering if someone can help me out with this error in the app
server logs, running against a remote Postgresql 9.1 machine, I get a
lot of these:
30.07.2012 07:05:16.140 *WARN* [Timer-3]
org.sakaiproject.nakamura.lite.storage.jdbc.ConnectionHolder Error
running validation query org.postgresql.util.PSQLException: An I/O
error occured while sending to the backend.
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:283)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
at
org.sakaiproject.nakamura.lite.storage.jdbc.ConnectionHolder.hasExpired(ConnectionHolder.java:66)
at
org.sakaiproject.nakamura.lite.storage.jdbc.ConnectionManager.cleanThreadMap(ConnectionManager.java:91)
at
org.sakaiproject.nakamura.lite.storage.jdbc.ConnectionManager.run(ConnectionManager.java:38)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
Caused by: java.io.EOFException
at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:276)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1661)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
... 8 more
The exception *seems* harmless right now. Was wondering if a plethora
of these indicate that I might need to tweak a tcp keep-alive on the
remote machine or something? Or, is our code known to manually close
database connections at the dismay of the connection pool?
Any advice is welcome. Thanks!
--
Cheers,
Branden
_______________________________________________
oae-dev mailing list
[email protected]
http://collab.sakaiproject.org/mailman/listinfo/oae-dev
