or Create a profile

Home → General →

ERROR [AbstractFlushingEventListener] Could not synchronize database state with session

horsager's Avatar

horsager

Jun 03, 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 Jun 21, 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 Jun 21, 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 Jun 21, 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 Jun 21, 2011 @ 01:23 PM.

Discussions are closed to public comments.
If you need help with Cascade CMS please start a new discussion.

  • New Issue

  • Conversation Started

  • The discussion is closed

    No more actions from Cascade CMS or the discussion starter are required.

  • Re-open the discussion

Private Permissions

This discussion is private. Only you and Cascade CMS support staff can see and reply to it.

Public Permissions

This discussion is public. Everyone can see and reply to it.

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

Recent Discussions

26 Oct 20:45 Incorrect path in submenus
31 Jan 20:08 example of php (web services) that reads a page and writes a new one
15 Sep 16:50 Best way to convert title tags to h1 tags
30 Aug 12:28 Query using selected option value from select
26 Aug 14:40 Are we suppose to use the new help/support website?

 

26 Aug 13:19 Links in PDF Output
25 Aug 15:02 Site Import Issues
25 Aug 12:50 Velocity syntax for conditional statement with two or more conditions
24 Aug 20:43 Increment integer on loop
24 Aug 19:20 Multi-select
21 Aug 13:20 Include contents from a rendered page