cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1425
Views
0
Helpful
1
Replies

Database locked on APIC

compterds
Level 1
Level 1

Hello networking world,

 

I'm currently seeing some syslog regarding obersver1.db (database locked)

 

<1027> Mar 08 08:18:38 XXXX %LOG_LOCAL0-3-SYSTEM_MSG [E4208012][transition][major][topology/pod-1/node-1/lon/svc-ifc_observer/rpl-1-1] [GenericSQLiteException] ErrorCode=5. Msg=database is locked. SQLiteError at base::Bool db::SQLiteStatement::exec():148. . Path=/data2/dbstats/observer_1.db
<1027> Mar 08 08:29:43 XXXX %LOG_LOCAL0-3-SYSTEM_MSG [E4208012][transition][major][topology/pod-1/node-1/lon/svc-ifc_observer/rpl-1-1] [GenericSQLiteException] ErrorCode=5. Msg=database is locked. SQLiteError at base::Bool db::SQLiteStatement::exec():148. . Path=/data2/dbstats/observer_1.db
<1027> Mar 08 08:29:43 XXXX%LOG_LOCAL0-3-SYSTEM_MSG [E4208012][transition][major][topology/pod-1/node-1/lon/svc-ifc_observer/rpl-1-1] [GenericSQLiteException] ErrorCode=5. Msg=database is locked. SQLiteError at base::Bool db::SQLiteStatement::exec():148. . Path=/data2/dbstats/observer_1.db


I've found a cisco bug regarding this "issue" https://quickview.cloudapps.cisco.com/quickview/bug/CSCuz82822

 

But we're running aci 3.0.2h at the moment, our release seems to be "impacted" by this behavior.

 

Does anyone seen this issue from aci 3.x ? 

 

Note : If you look through /data2/dbstats, as we can see on the observer_1.db line, there is admin as the group while root is the one for the others file.

 

-rw------- 1 ifc root 8117248 Nov 3 08:26 observer_template.db
-rw-r--r-- 1 ifc root 8117248 Nov 3 08:26 observer_2.db
-rw-r--r-- 1 ifc root 8688640 Nov 3 08:26 observer_3.db
-rw-r--r-- 1 ifc root 8117248 Nov 3 08:26 observer_5.db
-rw-r--r-- 1 ifc root 8117248 Nov 3 08:26 observer_6.db
-rw-r--r-- 1 ifc root 8117248 Nov 3 08:26 observer_8.db
-rw-r--r-- 1 ifc root 8117248 Nov 3 08:26 observer_9.db
-rw-r--r-- 1 ifc root 8117248 Nov 3 08:27 observer_11.db
-rw-r--r-- 1 ifc root 8117248 Nov 3 08:27 observer_12.db
-rw-r--r-- 1 ifc root 8119296 Nov 3 08:27 observer_14.db
-rw-r--r-- 1 ifc root 8126464 Nov 3 08:27 observer_15.db
-rw-r--r-- 1 ifc root 8119296 Nov 3 08:27 observer_17.db
-rw-r--r-- 1 ifc root 8119296 Nov 3 08:27 observer_18.db
-rw-r--r-- 1 ifc root 8117248 Nov 3 08:27 observer_20.db
-rw-r--r-- 1 ifc root 9075712 Nov 3 08:27 observer_21.db
-rw-r--r-- 1 ifc root 8758272 Nov 3 08:27 observer_23.db
-rw-r--r-- 1 ifc root 8752128 Nov 3 08:27 observer_24.db
-rw-r--r-- 1 ifc root 8117248 Nov 3 08:27 observer_26.db
-rw-r--r-- 1 ifc root 8117248 Nov 3 08:27 observer_27.db
-rw-r--r-- 1 ifc root 8204288 Nov 3 08:28 observer_29.db
-rw-r--r-- 1 ifc root 8117248 Nov 3 08:28 observer_30.db
-rw-r--r-- 1 ifc root 8117248 Nov 3 08:28 observer_32.db
-rw-r--r-- 1 ifc root 8288256 Nov 23 10:19 observer_7.db
-rw-r--r-- 1 ifc root 8269824 Mar 8 09:10 observer_25.db
-rw-r--r-- 1 ifc root 35417088 Mar 8 09:12 observer_28.db
-rw-r--r-- 1 ifc root 27639808 Mar 8 09:12 observer_4.db
-rw-r--r-- 1 ifc root 8925184 Mar 8 09:13 observer_16.db
-rw-r--r-- 1 ifc root 8592384 Mar 8 09:14 observer_31.db
-rw-r--r-- 1 ifc root 230865920 Mar 8 09:14 observer_22.db
-rw-r--r-- 1 ifc root 8188928 Mar 8 09:14 observer_10.db
-rw-r--r-- 1 ifc root 8385536 Mar 8 09:14 observer_13.db
-rw-r--r-- 1 ifc root 8714240 Mar 8 09:14 observer_19.db
-rw-r--r-- 1 ifc admin 8292352 Mar 8 09:14 observer_1.db
-rw-r--r-- 1 ifc root 10083328 Mar 8 09:14 observer_255.db

 

(We don't have any impact on production but strange behavior)

 

Have a nice day,

 

Yoann

 

1 Reply 1

phrunner33
Level 1
Level 1

I see this as well in 3.2(4d)

Review Cisco Networking for a $25 gift card

Save 25% on Day-2 Operations Add-On License