Hi,
We are experiencing some strange behaviour from PostgreSQL and our
applications. Recently, various queries have started to exceed the warn trace
timeout set by er.extensions.ERXAdaptorChannelDelegate.trace.milliSeconds.warn.
Some of the most basic select statements against a table with 3 rows are
taking upwards of 6 seconds to execute each, where they should easily be well
under that. We set the warn flag to 2.5 seconds.
A partial stacktrace is shown below:
java.lang.RuntimeException: Statement running too long
at
er.extensions.eof.ERXEOAccessUtilities.logExpression(ERXEOAccessUtilities.java:1203)
at
er.extensions.eof.ERXAdaptorChannelDelegate.adaptorChannelDidEvaluateExpression(ERXAdaptorChannelDelegate.java:88)
at sun.reflect.GeneratedMethodAccessor301.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
com.webobjects.foundation.NSSelector._safeInvokeMethod(NSSelector.java:122)
at com.webobjects.foundation._NSDelegate._perform(_NSDelegate.java:223)
at com.webobjects.foundation._NSDelegate.perform(_NSDelegate.java:163)
at
com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:377)
at
com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression(JDBCChannel.java:296)
at
com.webobjects.jdbcadaptor.JDBCChannel.selectAttributes(JDBCChannel.java:220)
at
er.extensions.jdbc.ERXJDBCAdaptor$Channel.selectAttributes(ERXJDBCAdaptor.java:150)
at
com.webobjects.eoaccess.EODatabaseChannel._selectWithFetchSpecificationEditingContext(EODatabaseChannel.java:897)
at
com.webobjects.eoaccess.EODatabaseChannel.selectObjectsWithFetchSpecification(EODatabaseChannel.java:234)
at
com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificationEditingContext(EODatabaseContext.java:3055)
at
er.extensions.eof.ERXDatabaseContext._objectsWithFetchSpecificationEditingContext(ERXDatabaseContext.java:57)
at
com.webobjects.eoaccess.EODatabaseContext.objectsWithFetchSpecification(EODatabaseContext.java:3195)
at
com.webobjects.eocontrol.EOObjectStoreCoordinator.objectsWithFetchSpecification(EOObjectStoreCoordinator.java:488)
at
com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4069)
at
er.extensions.eof.ERXEC.objectsWithFetchSpecification(ERXEC.java:1114)
at
com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4444)
at
com.webobjects.eoaccess.EOUtilities.objectWithPrimaryKey(EOUtilities.java:461)
at
com.webobjects.eoaccess.EOUtilities.objectWithPrimaryKeyValue(EOUtilities.java:432)
Has anyone experienced problems with PostgreSQL and basic statements timing
out? What might be the best way to troubleshoot this problem? We have tried
various JDBC driver versions, tuned the PostgreSQL configuration, enabled
ERXJDBCAdaptor.useConnectionBroker and enabled 5 connections....
We have not changed the production PostgreSQL version (8.4.1) recently, and we
run the latest 5.4 Wonder frameworks from the Hudson builds.
Daniel Roy
[email protected]
Software Developer
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-deploy mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-deploy/archive%40mail-archive.com
This email sent to [email protected]
