HPE Storage Users Group
https://3parug.net/

SQLite DB error executing BEGIN: TRANSACTION;~INSERT INTO
https://3parug.net/viewtopic.php?f=18&t=3933
Page 1 of 1

Author:  celoxgroup [ Mon Nov 20, 2023 7:06 am ]
Post subject:  SQLite DB error executing BEGIN: TRANSACTION;~INSERT INTO

Hi all,

System: 3PAR 8400 3.3.2.159 (MU1)+P10

I don't know when exactly this problem happened but it might be after I have applied the latest updates.

Second controller node is reporting SQLite DB error executing ... My suspicion is that the Insight database is corrupted on the node controller 1. I could not find instructions how to reinstate the database and hopefully someone knows how to do it. No DB errors on node 0.

I get a few errors every 5 minutes :/ and looks like this:

Code:
SQLite DB error executing BEGIN: TRANSACTION;~INSERT INTO current.vvspace VALUES (1700480700,'-',0,0,'admin','60002AC000000000000000000001F878','---','---','full','base','','RW','normal','2023-07-15 19:02:40 AEST','--',10240,0,0,0,0,0,0,0,0,0,0,10240,20480,10240,0,0,20971520.0,20971520.0,0,0,0,0,'-','-','-',0,'-',0,0,'NA',0,1700480700,0);~INSERT INTO current.vvspace VALUES (1700480700,'-',1,1,'.srdata','60002AC000000000000000010001F878','---','---','full','base','','RW','normal','2023-07-15 19:03:00 AEST','--',112640,0,0,0,0,0,0,0,0,0,0,11.

Recommended Action
Description: An internal database used to track and take action based on system statistics is not responding as expected. Resolution: Contact your next level of support.

Component
Detected by node 1


Kind Regards, Matt

Page 1 of 1 All times are UTC - 5 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/