03-08-2018 12:23 AM - edited 03-01-2019 05:28 AM
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
12-11-2019 02:05 PM
I see this as well in 3.2(4d)
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide