"Operation not allowed after ResultSet closed" when loading bundles at server startup

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

"Operation not allowed after ResultSet closed" when loading bundles at server startup

leconcombre
Hello,

I am getting an Operation not allowed after ResultSet closed while loading the bundles on a Hippo 7.7 repository on a Ubuntu Server using MySQL (on a separate machine).

This error started happening recently, but I also noticed that there the number of bundles is pretty high 249415. The site has been up for 2 months now.

I also saw that after the error, the number of bundles seems reduced (243361). Does that means that there was content lost?

Any ideas on how to fix this?

Thanks!

----
18.12.2012 08:48:24 INFO  [org.hippoecm.repository.jackrabbit.persistence.PatchedBundleDbPersistenceManager.checkConsistency():216] org.hippoecm.repository.jackrabbit.persistence.ForkedMySqlPersistenceManager@46dfd34: checked 242000/249415 bundles...
18.12.2012 08:48:26 INFO  [org.hippoecm.repository.jackrabbit.persistence.PatchedBundleDbPersistenceManager.checkConsistency():216] org.hippoecm.repository.jackrabbit.persistence.ForkedMySqlPersistenceManager@46dfd34: checked 243000/249415 bundles...
18.12.2012 08:48:27 ERROR [org.hippoecm.repository.jackrabbit.persistence.PatchedBundleDbPersistenceManager.checkConsistency():220] Error loading bundle
java.lang.reflect.UndeclaredThrowableException
        at $Proxy23.next(Unknown Source)
        at org.hippoecm.repository.jackrabbit.persistence.PatchedBundleDbPersistenceManager.checkConsistency(PatchedBundleDbPersistenceManager.java:190)
        at org.apache.jackrabbit.core.persistence.pool.BundleDbPersistenceManager.init(BundleDbPersistenceManager.java:559)
        at org.hippoecm.repository.jackrabbit.persistence.ForkedMySqlPersistenceManager.init(ForkedMySqlPersistenceManager.java:53)
        at org.apache.jackrabbit.core.RepositoryImpl.createPersistenceManager(RepositoryImpl.java:1325)
        at org.apache.jackrabbit.core.RepositoryImpl.createVersionManager(RepositoryImpl.java:475)
        at org.apache.jackrabbit.core.RepositoryImpl.<init>(RepositoryImpl.java:300)
        at org.hippoecm.repository.jackrabbit.RepositoryImpl.<init>(RepositoryImpl.java:77)
        at org.hippoecm.repository.LocalHippoRepository$LocalRepositoryImpl.<init>(LocalHippoRepository.java:245)
        at org.hippoecm.repository.LocalHippoRepository.initializeStartup(LocalHippoRepository.java:299)
        at org.hippoecm.repository.LocalHippoRepository.initialize(LocalHippoRepository.java:270)
        at org.hippoecm.repository.LocalHippoRepository.create(LocalHippoRepository.java:135)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at org.hippoecm.repository.HippoRepositoryFactory.getHippoRepository(HippoRepositoryFactory.java:184)
        at org.hippoecm.repository.RepositoryServlet.init(RepositoryServlet.java:153)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1266)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1185)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1080)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5001)
        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5289)
        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:866)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:842)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:958)
        at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1599)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
        at java.lang.Thread.run(Thread.java:722)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor30.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at org.apache.jackrabbit.core.util.db.ResultSetWrapper.invoke(ResultSetWrapper.java:66)
        ... 35 more
Caused by: java.sql.SQLException: Operation not allowed after ResultSet closed
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
        at com.mysql.jdbc.ResultSetImpl.checkClosed(ResultSetImpl.java:803)
        at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:6985)
        ... 39 more
18.12.2012 08:48:27 INFO  [org.hippoecm.repository.jackrabbit.persistence.PatchedBundleDbPersistenceManager.checkConsistency():305] org.hippoecm.repository.jackrabbit.persistence.ForkedMySqlPersistenceManager@46dfd34: checked 243361/243361 bundles.
18.12.2012 08:48:27 INFO  [org.hippoecm.repository.jackrabbit.persistence.PatchedBundleDbPersistenceManager.checkReferences():322] org.hippoecm.repository.jackrabbit.persistence.ForkedMySqlPersistenceManager@46dfd34: checking references consistency...
Reply | Threaded
Open this post in threaded view
|

Re: "Operation not allowed after ResultSet closed" when loading bundles at server startup

leconcombre
I think I found the issue,

the programmer that did the original server configuration specified

removeAbandonedTimeout="600" removeAbandoned="true" logAbandoned="true"

into the jdbc resource configuration. When removing those options I stopped getting the errors
Reply | Threaded
Open this post in threaded view
|

Re: "Operation not allowed after ResultSet closed" when loading bundles at server startup

b.vanderschans@onehippo.com
Thanks for reporting back!

On Wed, Jan 16, 2013 at 3:50 PM, leconcombre <[hidden email]> wrote:

> I think I found the issue,
>
> the programmer that did the original server configuration specified
>
> removeAbandonedTimeout="600" removeAbandoned="true" logAbandoned="true"
>
> into the jdbc resource configuration. When removing those options I stopped
> getting the errors
>
>
>
> --
> View this message in context: http://hippo.2275632.n2.nabble.com/Operation-not-allowed-after-ResultSet-closed-when-loading-bundles-at-server-startup-tp7580013p7580194.html
> Sent from the Hippo CMS 7 mailing list archive at Nabble.com.
> _______________________________________________
> Hippo-cms7-user mailing list and forums
> http://www.onehippo.org/cms7/support/forums.html



--
Amsterdam - Oosteinde 11, 1017 WT Amsterdam
Boston - 1 Broadway, Cambridge, MA 02142

US +1 877 414 4776 (toll free)
Europe +31(0)20 522 4466
www.onehippo.com
_______________________________________________
Hippo-cms7-user mailing list and forums
http://www.onehippo.org/cms7/support/forums.html