Hi Joseph,
I still have not solved my case, whenever the problem occurs I show that the Spectrum processes (spectroserver.exe, mysqld.exe, archmgr.exe) consume around 7 GB of server memory and total is 8GB. This is a very strange behavior since in normal situations the same 3 processes do not consume more than 2 GB of memory.
I do not know if it is recommended to increase the memory of the server since it can continue consuming the total that is assigned.
Original Message:
Sent: 05-28-2020 10:51 AM
From: Joseph Ackley
Subject: SpectroServer Crash Frequently
Sebastian,
Looks like you are running out of memory. So either some other process is using up memory and there is no memory available for Spectrum or the SpectroSERVER is using up all the memory indicating a possible memory leak.
Joe
Original Message:
Sent: 05-28-2020 10:34 AM
From: Sebastian Garcia Arevalo
Subject: SpectroServer Crash Frequently
Joseph,
Following your recommendation when reviewing the windows event viewer in the period of the failure, several Warning type events are registered:
And at the time the backup is executed an Error type event is evident:
Original Message:
Sent: 05-28-2020 07:45 AM
From: Joseph Ackley
Subject: SpectroServer Crash Frequently
Sebastian,
There is no debug that I am aware of. An analysis of the crash data is needed.
Since this is Windows, check for errors in the Windows Event Viewer as well.
Joe
Original Message:
Sent: 05-27-2020 05:31 PM
From: Sebastian Garcia Arevalo
Subject: SpectroServer Crash Frequently
Hello Joseph
thanks for the reply. Whenever this happens I look at the VNM.OUT file and nothing related to the error is evident. Before opening a case I would like to know if I can put a debug mode or something that allows to identify something in the log related to the failure?
Original Message:
Sent: 05-27-2020 04:47 PM
From: Joseph Ackley
Subject: SpectroServer Crash Frequently
Sabastian,
The lock file is created when an application (like the SpectroSERVER) has a lock on the SpectroSERVER database. That way only one application can lock the database at any one time. The lock file is removed when the application shuts down gracefully. It is not when it terminates. When the application terminates, there is a high risk of database corruption and you need to restore from a previously saved database.
To find the root cause of the crash, you will need to open a case with Spectrum support so the errors in the $SPECROOT/SS/VNM.OUT file and the dmp and mdmp files from the crash located in the $SPECROOT/SS/support directory can be analyzed.
Joe
Original Message:
Sent: 05-27-2020 04:41 PM
From: Sebastian Garcia Arevalo
Subject: SpectroServer Crash Frequently
Hello everyone,
We recently upgraded to Spectrum 10.3, since that our main Spectroserver (MLS) is in "Terminated" state frequently, about every 8 days. When trying to start the spectro server the error message of the attached image is displayed and a BD needs to be restored. How can I avoid these .VNMDB.LOCK or find the root cause of this.
Thanks.