ERROR [AbstractFlushingEventListener] Could not synchronize database state with session

horsager's Avatar

horsager

03 Jun, 2011 08:02 PM

I am seeing a lot of the following error in my logs after we had a power failure:

ERROR [AbstractFlushingEventListener] Could not synchronize database state with session

It seems also that within a couple hours of rebooting that logins stop working and I see this in my logs as well:

[JDBCExceptionReporter] Cannot get a connection, pool exhausted

Has anyone experienced this before?
I just reinstalled 6.8.2. I still see the synchronization errors, but I'm waiting on the pool exhausted errors to appear again.

  1. Support Staff 1 Posted by Tim on 21 Jun, 2011 12:10 PM

    Tim's Avatar

    Are you still seeing these problems in your instance? This looks to be related to a potential problem with the database configuration. If you continue to see errors concerning the connection pool, you'll want to check what the current setting is on the database (for the connection pool) and then check to see the maximum number of connections Cascade Server is using.

    To check on the Cascade side, you will want to view the contents of the file /tomcat/conf/context.xml.

    In that file, you will see a database configuration for the database to which you are connecting. In the <Resource> element, you should see the attribute MaxActive. By default, I believe this is set to 50. This value is the maximum number of database connections in the pool. You could try increasing this by 10 or so to see if that alleviates the problem, but you will want to make sure first that your database allows for that number of connections.

    Let me know what you find.

    Thanks

  2. 2 Posted by horsager on 21 Jun, 2011 01:21 PM

    horsager's Avatar

    Tim,

    Thank you for the reply. We are no longer experiencing this issue. It appears to have resolved itself. No configuration changes were made. For some reason a third service restart was more magic than the first two.

    Chris

  3. Support Staff 3 Posted by Tim on 21 Jun, 2011 01:23 PM

    Tim's Avatar

    Good deal Chris! Glad to hear that you are no longer experiencing these problems.

    I appreciate the update!

  4. Tim closed this discussion on 21 Jun, 2011 01:23 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac