HPE Storage Users Group

A Storage Administrator Community




Post new topic Reply to topic  [ 7 posts ] 
Author Message
 Post subject: HP 3PAR System Reporter Error
PostPosted: Mon Nov 03, 2014 3:27 pm 

Joined: Fri Apr 25, 2014 11:00 am
Posts: 1
HP 3PAR System reporter throws error "Error from dedupinv: child killed: SIGABRT"
I have tried restarting services, but in vain.
Could anybody help me try and fix this issue please...


Regards,
Jon


Top
 Profile  
Reply with quote  
 Post subject: Re: HP 3PAR System Reporter Error
PostPosted: Tue Nov 04, 2014 1:15 am 
Site Admin
User avatar

Joined: Tue Aug 18, 2009 10:35 pm
Posts: 1328
Location: Dallas, Texas
Dig into the log files under system reporter... you should be able to find an error from your database server in there somewhere. Possibly a deadlock between the dedupe job and the polling... but thats just a guess.

_________________
Richard Siemers
The views and opinions expressed are my own and do not necessarily reflect those of my employer.


Top
 Profile  
Reply with quote  
 Post subject: Re: HP 3PAR System Reporter Error
PostPosted: Tue Nov 04, 2014 2:13 am 

Joined: Fri Jun 27, 2014 2:01 am
Posts: 390
Well, we are talking about System Reporter... Which has not been updated since months and won't be updated for the next... 50 years... So nothing to do with dedup and Inform OS 3.2.1 MU1.

You must have a table corrupted. As Richard said, check your logs.


Top
 Profile  
Reply with quote  
 Post subject: Re: HP 3PAR System Reporter Error
PostPosted: Tue Apr 07, 2015 10:38 am 

Joined: Mon Jul 30, 2012 8:53 am
Posts: 7
It looks like I have the same issue with our System Reporter.

This is what I found in the trimdb.log:
Mssql DB error executing DELETE FROM statvluninv_hires_4 with (rowlock) WHERE TSECS < 1428333011 AND sys_uid = 7: 40001 1205 {[Microsoft][SQL Server Native Client 11.0][SQL Server]Transaction (Process ID 60) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.}

Any suggestions for a solution?


Top
 Profile  
Reply with quote  
 Post subject: Re: HP 3PAR System Reporter Error
PostPosted: Fri Jul 03, 2015 2:58 am 

Joined: Fri Jul 03, 2015 2:54 am
Posts: 5
Same Issue here

Mssql DB error executing DELETE FROM statvluninv_hires_4 with (rowlock) WHERE TSECS < 1435736566 AND sys_uid = 7: 40001 1205 {[Microsoft][SQL Server Native Client 10.0][SQL Server]Transaction (Process ID 352) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.}

Any news or hints on how to fix this ?


Top
 Profile  
Reply with quote  
 Post subject: Re: HP 3PAR System Reporter Error
PostPosted: Fri Jul 03, 2015 6:47 am 

Joined: Wed May 07, 2014 1:51 am
Posts: 267
Whenever I run in problems with sr-db, I execute

Code:
myisamchk --key_buffer_size=512M --sort_buffer_size=512M --read_buffer_size=8M --write_buffer_size=8M –r -f d:\SystemReporter_db\data\inservstats\*.MYI


This is from the SR Best Practices guide, it chews through all db-files (takes some time!) and auto-corrects any errors (at least those we tend to encounter).

Use at your own risc, take backups beforehand, and only use it if you use SR with mysql-db! And don't forget to first stop sr-services!

_________________
When all else fails, read the instructions.


Top
 Profile  
Reply with quote  
 Post subject: Re: HP 3PAR System Reporter Error
PostPosted: Wed Nov 01, 2017 9:52 am 

Joined: Thu Jul 06, 2017 3:28 pm
Posts: 41
apol wrote:
Whenever I run in problems with sr-db, I execute

Code:
myisamchk --key_buffer_size=512M --sort_buffer_size=512M --read_buffer_size=8M --write_buffer_size=8M –r -f d:\SystemReporter_db\data\inservstats\*.MYI


This is from the SR Best Practices guide, it chews through all db-files (takes some time!) and auto-corrects any errors (at least those we tend to encounter).

Use at your own risc, take backups beforehand, and only use it if you use SR with mysql-db! And don't forget to first stop sr-services!


Is there a similar command for oracle db?

Getting the following error:

"Oracle DB error executing DELETE FROM statvlun_hires_4 WHERE TSECS < 1508929724 AND sys_uid = 13: ORA-00060: deadlock detected while waiting for resource”"


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 


Who is online

Users browsing this forum: No registered users and 74 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group | DVGFX2 by: Matt