ACS Locked Database

shiloh — Wed, 13 Mar 2019 00:39:04 GMT

Folks - our Windows server disk filled up. Cisco ACS 4.2 threw a fatal error and locked the database.

I've cleared up space on disk and reloaded server. ACS processes start, but sockets do not. It appears that database is still locked, and CSMON is shutting down the sockets.

Any ideas on how to unlock database and bring up GUI? Following are logs.

*********************************************

CSMon 11/28/2010 17:48:57 E 0092 0592 0x0 ODBC Operation faild with the following information: Message=[Sybase][ODBC Driver][Adaptive Server Anywhere]Disk full 'Fatal error: disk full C:\Program Files\CiscoSecure ACS v4.2\CSDB\ACS.log' -- transaction rolled back, SqlState=S1000, NativeError=-304

CSMon 11/28/2010 17:48:58 A 0191 0592 0x0 SL:getValue (dword)- execution failed

CSMon 11/28/2010 17:49:08 E 0092 0208 0x0 ODBC Operation faild with the following information: Message=[Sybase][ODBC Driver][Adaptive Server Anywhere]Connection was terminated, SqlState=S1000, NativeError=-308

CSMon 11/28/2010 17:49:08 A 0932 0208 0x0 SL:isKeyExist - execution failed

**********************************************

CSMon 11/29/2010 11:56:19 E 0092 1392 0x0 ODBC Operation faild with the following information: Message=[Sybase][ODBC Driver][Adaptive Server Anywhere]Connection was terminated, SqlState=S1000, NativeError=-308

CSMon 11/29/2010 11:56:19 A 0147 1392 0x0 SL:setValue (string) - execution failed

CSMon 11/29/2010 11:56:19 A 0147 1392 0x0 SL:setValue (string) - execution failed

CSMon 11/29/2010 11:56:19 A 0429 1392 0x0 CSMon Shutdown: Stopping Notifications.

CSMon 11/29/2010 11:56:19 A 0501 1392 0x0 CSMon Shutdown, stopping Problem Monitoring.

CSMon 11/29/2010 11:56:19 A 0448 1392 0x0 CSMon Shutdown: Stopping Worker Threads.

CSMon 11/29/2010 11:56:19 A 0451 1392 0x0 CSMon Shutdown: Closing connection to CSAuth API.

CSMon 11/29/2010 11:56:21 A 0454 1392 0x0 CSMon Shutdown: Closing Mail and NTLog stuff.

CSMon 11/29/2010 11:56:21 A 0457 1392 0x0 CSMon Shutdown: Cleaning up Synchronisations stuff.

CSMon 11/29/2010 11:56:21 A 0280 1392 0x0 CSMon Shutdown: Closing Winsock.

CSMon 11/29/2010 11:56:23 A 0288 1392 0x0 ******************************************

CSMon 11/29/2010 11:56:23 A 0289 1392 0x0 * Shutdown Complete *

CSMon 11/29/2010 11:56:23 A 0290 1392 0x0 ******************************************

Re: ACS Locked Database

Serge Yasmine — Wed, 01 Dec 2010 16:22:50 GMT

Hi. any idea why the disk filled up, did you install any new application on the ACS Server, such as SQL Server maybe?

thx

Serge

Re: ACS Locked Database

shiloh — Wed, 01 Dec 2010 16:24:57 GMT

It was benign and resolved. We have enough disk space now.

Re: ACS Locked Database

Serge Yasmine — Wed, 01 Dec 2010 16:28:53 GMT

i searched on tac db and found a similar case to your where the problem was customer installed an SQL server on the same machine of acs that ate all disk space and caused same error message as you pasted. that is why i was asking, did you install SQL server lately on that machine?

ACS Locked Database

mrisinger — Thu, 21 Jun 2012 00:14:29 GMT

I ran into a similar issue. In my case, the services would not start after resolving the space issue and rebooting.

I was able to resolve the issue by renaming the acs.log (transaction log) file in the ...\CiscoSecure ACS v4.2\CSDB\ folder.

From there, I was able to restart the CSAuth service and all subsequent services.

The offending acs.log file was marked Read-Only and had a length of 0 bytes. Once started, the DB created a new file with a file size of 192KB.

topic Re: ACS Locked Database in Network Access Control

ACS Locked Database

Re: ACS Locked Database

Re: ACS Locked Database

Re: ACS Locked Database

ACS Locked Database