topic ISE Database failure in Network Access Control

ISE Database failure

Frank Lothar Weber — Mon, 11 Mar 2019 03:04:01 GMT

Hi, all.

Anyone ever had this error on ISE :

ISE application is responding veeeery slowly, a "show app stat ise" doesn't complete at all ...

I have no idea what to do ...

Rgs

Frank

ISE Database failure

nspasov — Sat, 09 Feb 2013 04:33:32 GMT

Are you by any chance running ISE 1.1 ?

ISE Database failure

Frank Lothar Weber — Sat, 09 Feb 2013 10:41:44 GMT

No, this is the version ISE is running on :

sh ver

Cisco Application Deployment Engine OS Release: 2.0

ADE-OS Build Version: 2.0.4.018

ADE-OS System Architecture: i386

Hostname: deess01nise01

Version information of installed applications

---------------------------------------------

Cisco Identity Services Engine

---------------------------------------------

Version : 1.1.2.145

Build Date : Fri Oct 26 21:10:35 2012

Install Date : Thu Nov 8 17:56:09 2012

Cisco Identity Services Engine Patch

---------------------------------------------

Version : 2

Install Date : Sun Dec 16 18:22:32 2012

Re:ISE Database failure

Tarik Admani — Sun, 10 Feb 2013 02:00:22 GMT

Is this running on virtual machine or appliance? If vm what are the specs of your vm. Also are you using thin provisioning, how many cpu cores and memory is the instance running? Is this a distributed setup?

Sent from Cisco Technical Support Android App

Re:ISE Database failure

Frank Lothar Weber — Sun, 10 Feb 2013 18:31:58 GMT

Hi,

no, this is not a VM, it is the big appliance:

deess01nise01/xia0wf# sh inventory

NAME: "ISE-3395-K9        chassis", DESCR: "ISE-3395-K9        chassis"
PID: ISE-3395-K9       , VID: V01 , SN: Kxxxxxxxx
Total RAM Memory: 3997824 kB
CPU Core Count: 8
CPU 0: Model Info: Intel(R) Xeon(R) CPU           E5504 @ 2.00GHz
CPU 1: Model Info: Intel(R) Xeon(R) CPU           E5504 @ 2.00GHz
CPU 2: Model Info: Intel(R) Xeon(R) CPU           E5504 @ 2.00GHz
CPU 3: Model Info: Intel(R) Xeon(R) CPU           E5504 @ 2.00GHz
CPU 4: Model Info: Intel(R) Xeon(R) CPU           E5504 @ 2.00GHz
CPU 5: Model Info: Intel(R) Xeon(R) CPU           E5504 @ 2.00GHz
CPU 6: Model Info: Intel(R) Xeon(R) CPU           E5504 @ 2.00GHz
CPU 7: Model Info: Intel(R) Xeon(R) CPU           E5504 @ 2.00GHz
Hard Disk Count(*): 1
Disk 0: Device Name: /dev/sda
Disk 0: Capacity: 597.90 GB
Disk 0: Geometry: 255 heads 63 sectors/track 72702 cylinders
NIC Count: 4
NIC 0: Device Name: eth0
NIC 0: HW Address: 5C:F3:FC:E6:F0:B4
NIC 0: Driver Descr: Broadcom NetXtreme II BCM5706/5708/5709/5716 Driver
NIC 1: Device Name: eth1
NIC 1: HW Address: 5C:F3:FC:E6:F0:B6
NIC 1: Driver Descr: Broadcom NetXtreme II BCM5706/5708/5709/5716 Driver
NIC 2: Device Name: eth2
NIC 2: HW Address: 5C:F3:FC:6A:D1:D0
NIC 2: Driver Descr: Broadcom NetXtreme II BCM5706/5708/5709/5716 Driver
NIC 3: Device Name: eth3
NIC 3: HW Address: 5C:F3:FC:6A:D1:D2
NIC 3: Driver Descr: Broadcom NetXtreme II BCM5706/5708/5709/5716 Driver

(*) Hard Disk Count may be Logical.

It is also running as a single instance setup, not as a distributed setup.

If the box and features turn out to work fine, additional boxes and vms will be added to the setup.

The services activtated on the machine are "profiling" (via dhcp, snmp and device-sensors from a few access switches) and radius authentication (from one wireless controller 5508).

The box also fires a lot of these alarms:

90 minutes later, this alarm seems to be cleared:

Rgs

Frank

Re:ISE Database failure

nspasov — Mon, 11 Feb 2013 03:33:18 GMT

Hmm that is strange. There were a lot of DB related issues with 1.1 and that is why I was wondering if you were running that version.

With regards to the second screen shot: How many endpoints do you have authenticating to this node?

Lastly, when this error occurs can you check the output of "show disks" and post it here.

Re:ISE Database failure

Frank Lothar Weber — Mon, 11 Feb 2013 08:07:07 GMT

Hi,

the box is getting quite a lot of authentications (up to 32000 a day), but this should not be a problem for a 3395, should it ???

The disks seem to be fine at this moment also:

sh disks

disk repository: 5% used (618744 of 14877092)

Internal filesystems:

/ : 71% used ( 360053204 of 540283556)

/tmp : 3% used ( 41788 of 1976268)

/storedconfig : 7% used ( 5695 of 93327)

/boot : 9% used ( 40491 of 489992)

/dev/shm : 0% used ( 0 of 1998912)

all internal filesystems have sufficient free space

The "database failure" alam is not fired at the same time, I cannot predict the time when it is going to be fired.

Rgs

Frank

ISE Database failure

Tarik Admani — Mon, 11 Feb 2013 11:18:38 GMT

Frank,

Are you running any other services on this box like posturing? There has been a few issues related to the purging operations on ISE and you may need to open a tac request in order to see if you are experiencing the same issues.

Thanks,

Tarik Admani
*Please rate helpful posts*