topic 3PAR System Reporter database corrupted in HPE 3PAR StoreServ Storage

3PAR System Reporter database corrupted

celoxgroup — Wed, 16 Oct 2024 07:29:22 GMT

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.

Re: 3PAR System Reporter database corrupted

Cali — Tue, 08 Oct 2024 06:59:32 GMT

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

Re: 3PAR System Reporter database corrupted

celoxgroup — Tue, 08 Oct 2024 11:00:37 GMT

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

Re: 3PAR System Reporter database corrupted

Cali — Tue, 08 Oct 2024 11:36:34 GMT

stopsr
admithw srdata
showvv
startsr

Re: 3PAR System Reporter database corrupted

celoxgroup — Mon, 14 Oct 2024 10:11:06 GMT

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

Re: 3PAR System Reporter database corrupted

veeyarvi — Mon, 14 Oct 2024 12:45:13 GMT

Hi Celoxgroup,

Please try the below steps.

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

Regards,

Veeyaarvi

Query: 3PAR System Reporter database corrupted

support_s — Fri, 18 Oct 2024 09:30:40 GMT

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.

Re: 3PAR System Reporter database corrupted

celoxgroup — Fri, 18 Oct 2024 13:43:39 GMT

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

Re: 3PAR System Reporter database corrupted

Cali — Fri, 18 Oct 2024 15:54:37 GMT

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

Cali

Re: 3PAR System Reporter database corrupted

Sunitha_Mod — Fri, 20 Dec 2024 07:10:10 GMT

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.