HTTP Status 500 -


type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

<openjpa-1.2.1-r102384:102387M nonfatal general error> org.apache.renamed.openjpa.persistence.PersistenceException: Connection timed out {prepstmnt 1332422804 
SELECT t0.UIDPK, t1.UIDPK, t1.CATALOG_CODE, t1.DEFAULT_LOCALE, t1.MASTER, t1.NAME, t0.STORECODE, t0.CONTENT_ENCODING, 
        t0.COUNTRY, t0.CREDIT_CARD_CVV2_ENABLED, t0.DEFAULT_CURRENCY, t0.DEFAULT_LOCALE, t0.DESCRIPTION, 
        t0.DISPLAY_OUT_OF_STOCK, t0.EMAIL_SENDER_ADDRESS, t0.EMAIL_SENDER_NAME, t0.ENABLED, t0.NAME, 
        t0.STORE_ADMIN_EMAIL, t0.STORE_FULL_CREDIT_CARDS, t0.STORE_STATE, t0.STORE_TYPE, t0.SUB_COUNTRY, t0.TIMEZONE, 
        t0.URL 
    FROM TSTORE t0 LEFT OUTER JOIN TCATALOG t1 ON t0.CATALOG_UID = t1.UIDPK 
    WHERE (t0.STORE_STATE < ? OR t0.STORE_STATE >= ?) 
[params=(int) 0, (int) 100]} [code=0, state=08S01]
	org.apache.renamed.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4232)
	org.apache.renamed.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4197)
	org.apache.renamed.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
	org.apache.renamed.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:88)
	org.apache.renamed.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:64)
	org.apache.renamed.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
	org.apache.renamed.openjpa.datacache.QueryCacheStoreQuery$CachingResultObjectProvider.handleCheckedException(QueryCacheStoreQuery.java:649)
	org.apache.renamed.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:40)
	org.apache.renamed.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1228)
	org.apache.renamed.openjpa.kernel.QueryImpl.execute(QueryImpl.java:990)
	org.apache.renamed.openjpa.kernel.QueryImpl.execute(QueryImpl.java:805)
	org.apache.renamed.openjpa.kernel.QueryImpl.execute(QueryImpl.java:775)
	org.apache.renamed.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:533)
	org.apache.renamed.openjpa.persistence.QueryImpl.execute(QueryImpl.java:252)
	org.apache.renamed.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:294)
	com.elasticpath.persistence.impl.JpaPersistenceEngineImpl.retrieveByNamedQuery(JpaPersistenceEngineImpl.java:593)
	sun.reflect.GeneratedMethodAccessor96.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	java.lang.reflect.Method.invoke(Method.java:597)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
	$Proxy6.retrieveByNamedQuery(Unknown Source)
	com.elasticpath.service.store.impl.StoreServiceImpl.findAllCompleteStores(StoreServiceImpl.java:368)
	com.elasticpath.service.store.impl.StoreServiceImpl.findAllCompleteStores(StoreServiceImpl.java:356)
	sun.reflect.GeneratedMethodAccessor149.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	java.lang.reflect.Method.invoke(Method.java:597)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
	org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	$Proxy12.findAllCompleteStores(Unknown Source)
	com.elasticpath.sfweb.util.impl.StoreResolverImpl.getDomainToStoreMapping(StoreResolverImpl.java:174)
	com.elasticpath.sfweb.util.impl.StoreResolverImpl.resolveStoreCodeFromDomain(StoreResolverImpl.java:136)
	com.elasticpath.sfweb.util.impl.StoreResolverImpl.resolveDomainHeader(StoreResolverImpl.java:43)
	com.elasticpath.sfweb.util.impl.CachingStoreResolverImpl.resolveDomainHeader(CachingStoreResolverImpl.java:46)
	com.elasticpath.sfweb.filters.StoreSelectionFilter.resolveCandidate(StoreSelectionFilter.java:81)
	com.elasticpath.sfweb.filters.StoreSelectionFilter.doFilter(StoreSelectionFilter.java:50)
	com.elasticpath.sfweb.filters.EpFilterToBeanProxy.doFilter(EpFilterToBeanProxy.java:134)
	com.elasticpath.commons.filter.impl.EncodingFilter.handleFilter(EncodingFilter.java:138)
	com.elasticpath.commons.filter.impl.EncodingFilter.doFilter(EncodingFilter.java:81)
	com.elasticpath.siteoptimization.sfweb.filters.RequestContextRegistrationFilter.doFilter(RequestContextRegistrationFilter.java:38)
	com.elasticpath.sfweb.filters.EpFilterToBeanProxy.doFilter(EpFilterToBeanProxy.java:134)
	com.elasticpath.sfweb.filters.ThreadLocalHttpSessionFilter.doFilter(ThreadLocalHttpSessionFilter.java:43)
	com.elasticpath.sfweb.filters.EpFilterToBeanProxy.doFilter(EpFilterToBeanProxy.java:134)

root cause

org.apache.renamed.openjpa.lib.jdbc.ReportingSQLException: Connection timed out {prepstmnt 1332422804 
SELECT t0.UIDPK, t1.UIDPK, t1.CATALOG_CODE, t1.DEFAULT_LOCALE, t1.MASTER, t1.NAME, t0.STORECODE, t0.CONTENT_ENCODING, 
        t0.COUNTRY, t0.CREDIT_CARD_CVV2_ENABLED, t0.DEFAULT_CURRENCY, t0.DEFAULT_LOCALE, t0.DESCRIPTION, 
        t0.DISPLAY_OUT_OF_STOCK, t0.EMAIL_SENDER_ADDRESS, t0.EMAIL_SENDER_NAME, t0.ENABLED, t0.NAME, 
        t0.STORE_ADMIN_EMAIL, t0.STORE_FULL_CREDIT_CARDS, t0.STORE_STATE, t0.STORE_TYPE, t0.SUB_COUNTRY, t0.TIMEZONE, 
        t0.URL 
    FROM TSTORE t0 LEFT OUTER JOIN TCATALOG t1 ON t0.CATALOG_UID = t1.UIDPK 
    WHERE (t0.STORE_STATE < ? OR t0.STORE_STATE >= ?) 
[params=(int) 0, (int) 100]} [code=0, state=08S01]
	org.apache.renamed.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:192)
	org.apache.renamed.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:57)
	org.apache.renamed.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:852)
	org.apache.renamed.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:262)
	org.apache.renamed.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1527)
	org.apache.renamed.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:252)
	org.apache.renamed.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:496)
	org.apache.renamed.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:384)
	org.apache.renamed.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:325)
	org.apache.renamed.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:331)
	org.apache.renamed.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:94)
	org.apache.renamed.openjpa.datacache.QueryCacheStoreQuery$CachingResultObjectProvider.open(QueryCacheStoreQuery.java:592)
	org.apache.renamed.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:34)
	org.apache.renamed.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1228)
	org.apache.renamed.openjpa.kernel.QueryImpl.execute(QueryImpl.java:990)
	org.apache.renamed.openjpa.kernel.QueryImpl.execute(QueryImpl.java:805)
	org.apache.renamed.openjpa.kernel.QueryImpl.execute(QueryImpl.java:775)
	org.apache.renamed.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:533)
	org.apache.renamed.openjpa.persistence.QueryImpl.execute(QueryImpl.java:252)
	org.apache.renamed.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:294)
	com.elasticpath.persistence.impl.JpaPersistenceEngineImpl.retrieveByNamedQuery(JpaPersistenceEngineImpl.java:593)
	sun.reflect.GeneratedMethodAccessor96.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	java.lang.reflect.Method.invoke(Method.java:597)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
	$Proxy6.retrieveByNamedQuery(Unknown Source)
	com.elasticpath.service.store.impl.StoreServiceImpl.findAllCompleteStores(StoreServiceImpl.java:368)
	com.elasticpath.service.store.impl.StoreServiceImpl.findAllCompleteStores(StoreServiceImpl.java:356)
	sun.reflect.GeneratedMethodAccessor149.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	java.lang.reflect.Method.invoke(Method.java:597)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
	org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	$Proxy12.findAllCompleteStores(Unknown Source)
	com.elasticpath.sfweb.util.impl.StoreResolverImpl.getDomainToStoreMapping(StoreResolverImpl.java:174)
	com.elasticpath.sfweb.util.impl.StoreResolverImpl.resolveStoreCodeFromDomain(StoreResolverImpl.java:136)
	com.elasticpath.sfweb.util.impl.StoreResolverImpl.resolveDomainHeader(StoreResolverImpl.java:43)
	com.elasticpath.sfweb.util.impl.CachingStoreResolverImpl.resolveDomainHeader(CachingStoreResolverImpl.java:46)
	com.elasticpath.sfweb.filters.StoreSelectionFilter.resolveCandidate(StoreSelectionFilter.java:81)
	com.elasticpath.sfweb.filters.StoreSelectionFilter.doFilter(StoreSelectionFilter.java:50)
	com.elasticpath.sfweb.filters.EpFilterToBeanProxy.doFilter(EpFilterToBeanProxy.java:134)
	com.elasticpath.commons.filter.impl.EncodingFilter.handleFilter(EncodingFilter.java:138)
	com.elasticpath.commons.filter.impl.EncodingFilter.doFilter(EncodingFilter.java:81)
	com.elasticpath.siteoptimization.sfweb.filters.RequestContextRegistrationFilter.doFilter(RequestContextRegistrationFilter.java:38)
	com.elasticpath.sfweb.filters.EpFilterToBeanProxy.doFilter(EpFilterToBeanProxy.java:134)
	com.elasticpath.sfweb.filters.ThreadLocalHttpSessionFilter.doFilter(ThreadLocalHttpSessionFilter.java:43)
	com.elasticpath.sfweb.filters.EpFilterToBeanProxy.doFilter(EpFilterToBeanProxy.java:134)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.35 logs.


Apache Tomcat/6.0.35