3PAR System Reporter database corrupted

[celoxgroup]

Dear Team,

I have a specific challege I could not find a solution on the internet or documentation.

On 3PAR 8400 I am getting SQLite DB error executing <add SQL query> messages every few minutes and due to that no reports are working properly. I could not find a way to recreate the .srdata partition or somehow reset the SQLite database.

I tried to stop the sr service and admithw srdata however it says volume already exists.

Any suggestions appreciated.

[Cali]

Hi,

I fixed this Issue with:

-showsr

• Remove the SR-Volumes
- removevv -f .srdata
• Recreate the SR-Volumes
- admithw
• Check it is here
- showvv
• Restart System Reporter
- startsr (Mount Volume = Yes)
• wait
- check if it is mapped
- showsr

No Warranty, I'm not HPE Support!

Cali

[celoxgroup]

Hi Cali,

Thank you for your suggestion, I was so hoping this will work however the system didn't let me. I am logged in as 3paradm via SS.

My commands:
showsr
showvv
stopsr
removevv -f .srdata

Command is rejected with the following error message:

Removing vv .srdata
Attempt to delete vv .srdata which is in use by the system to store system information

When I type showvv, the .srdata is still there. Maybe this would work on the older version? I'm on the latest 3.3.2 MU1 P10

Any other suggestions?

Kind Regards, Matt

[Cali]

stopsr
admithw srdata
showvv
startsr

[celoxgroup]

Hi @Cali ,

I tried that one already before however admithw srdata says "System Reporter volume exists" and does nothing. I hoped to remove srdata with removevv however system blocks it.

Kind Regards, Matt

[veeyarvi]

Hi Celoxgroup,

Please try the below steps.

stopsr
removevv -rmsys  .srdata
admithw  srdata
showvv -pol  -showsysobjs  .srdata
showsr

Regards,

Veeyaarvi

[support_s]

Hello,

Let us know if you were able to resolve the issue.

If you have no further query, and you are satisfied with the answer then kindly mark the topic as Solved so that it is helpful for all community members.

Please click on "Thumbs Up/Kudo" icon to give a "Kudo".

Thank you for being a HPE valuable community member.

[celoxgroup]

Hi Veeyaarvi,

Thank you so much for the instructions. I was able to delete the .srdata volume. Unfortunately the problem re-appeared again once I've recreated the database with the admithw command (but one step closer to resolve the problem :)). There was a clue in the warning message as per below:

3par cli% admithw srdata
System has fewer cages than nodes
Using -ha mag for srdata volume

I will be installing a cage this weekend and hopefully after running the commands again the problem will be fixed.

Kind Regards, Matt

[Cali]

Hmm, usually this is not an error, only information.

Cali

[Sunitha_Mod]

Hello @celoxgroup,

Let us know if you were able to resolve the issue.

If you have no further query, and you are satisfied with the answer then kindly mark the topic as Solved so that it is helpful for all community members.