| HPE Storage Users Group https://3parug.com/ |
|
| HP 3PAR System Reporter Error https://3parug.com/viewtopic.php?f=18&t=988 |
Page 1 of 1 |
| Author: | jonmcnealy [ Mon Nov 03, 2014 3:27 pm ] |
| Post subject: | HP 3PAR System Reporter Error |
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 |
|
| Author: | Richard Siemers [ Tue Nov 04, 2014 1:15 am ] |
| Post subject: | Re: HP 3PAR System Reporter Error |
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. |
|
| Author: | RitonLaBevue [ Tue Nov 04, 2014 2:13 am ] |
| Post subject: | Re: HP 3PAR System Reporter Error |
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. |
|
| Author: | rmeertens [ Tue Apr 07, 2015 10:38 am ] |
| Post subject: | Re: HP 3PAR System Reporter Error |
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? |
|
| Author: | Marco [ Fri Jul 03, 2015 2:58 am ] |
| Post subject: | Re: HP 3PAR System Reporter Error |
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 ? |
|
| Author: | apol [ Fri Jul 03, 2015 6:47 am ] |
| Post subject: | Re: HP 3PAR System Reporter Error |
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! |
|
| Author: | storsnapper [ Wed Nov 01, 2017 9:52 am ] |
| Post subject: | Re: HP 3PAR System Reporter Error |
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”" |
|
| Page 1 of 1 | All times are UTC - 5 hours |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|