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.