A possible scenario: What version of Spectrum did you upgrade from? From what I remember, Archive Manager is multi-threaded at revision 9.2 and above. It works with most setup, but not all. If you upgrade from prior to 9.2 and are having problems, then you can consider this a possibility. > archive manager crashes after only a few hours We have similar problem. It crashes once every few hours, or days, or sometime weeks. It took us several months to get this fixed, with 2 cases opened, waited for another Spectrum version upgrade and upgrade, and finally a patch. Patch # 09.02.01.D202 You will have to call support to confirm and get the patch. The patch basically applies older single threaded Archive Manager. In the meantime, you can increase your locally stored events by editing your $SPECROOT/SS/.vnmrc max_event_records=200000 This gives you more buffers before losing your events when Archive Manager crashes.
Hope you could find a solution quickly. Lip Jen Chew ________________________________________ From: Ednei Lima Ruiz [[email protected]] Sent: Friday, July 06, 2012 6:55 AM To: spectrum Subject: RES: [spectrum] Archive manager crashing Hi, After you install H06 the file my-spectrum.cnf is restored to default value. Tip of the technical support: --------------- Please follow this steps: -Modify the $SPECROOT/mysql/my-spectrum.cnf file as follows (make a backup prior modifying it): # Spectrum mysql config file. # This will be passed to all mysql clients client port=3306 #socket=MySQL # The MySQL server mysqld shared-memory port=3306 #socket=MySQL basedir = d:/spectrum/mysql tmpdir = d:/spectrum/mysql/tmp #log-slow-queries #long_query_time = 10 #skip-innodb innodb_file_per_table innodb_buffer_pool_size = 256M innodb_log_file_size = 256M innodb_log_buffer_size = 4M max_allowed_packet=256M net_read_timeout=600 Save a copy of the $SPECROOT/SS/DDM/.configrc file to a backup location or add .orig to a copy of it. Change the following line in the $SPECROOT/SS/DDM/.configrc file: DDM_DATABASE_PORT=0 Here how the .configrc will look like: DDM_SOCKET_NUMBER=0xddec ARCH_MGR_SOCKET_NUMBER=0xbafe MAX_STAT_DAYS=45 MAX_EVENT_DAYS=45 LANDSCAPE_PRECEDENCE=10 TIME_TOLERANCE_IN_SECONDS=300 DDM_DATABASE_NAME=ddmdb DDM_DATABASE_USERNAME=site_specs_acc DDM_DATABASE_HOSTNAME=localhost DDM_DATABASE_PASSWORD=site_specs_acc orb_args=-Dvbroker.se.iiop_tp.scm.iiop_tp.listener.port=14003 -ORBpropStorage ../../.corbarc DDM_DATABASE_PORT=0 max_mhs_in_filter= You will need ot restart the MySQL server to put these changes in place. But to stop the MySQL server, you will need to stop the Spectrum Daemon (because it controls the startup and shutdown of MySQL service). If you cannot stop the Spectrum, then follow this procedure to stop the MySQL service. 1. Stop the execution of Archive Manager via SCP. Make sure the process is not running via Windows Task Manager. 2. Stop the MySQL server process. To stop MySQL database server, run the following $SPECROOT/bin/cmdC command on bash shell: cmdC <hostname> 2 MYSQL 3. Start MySQL database server: To start MySQL database server, run the $SPECROOT/bin/launchinstdbapp command on bash shell. launchinstdbapp <hostname> MYSQL y MYSQL.OUT 4. Start the Archive Manager. Note: If the SRM (Spectrum Report Manager) is also running on this SS, you will need to stop the Spectrum Tomcat service prior stopping the MySQL service. ------------------ Regards, Ednei Ruiz Gerenciamento de Rede TM Solutions - Soluções sob medida em tecnologia da informação Rua Gêmeos, 64 - Cond. Conde Empresarial - Alphaville - CEP.06473-020 ----Mensagem original---- De: Jon Magnus Dullerud [mailto:[email protected]] Enviada em: sexta-feira, 6 de julho de 2012 05:49 Para: spectrum Assunto: [spectrum] Archive manager crashing Hi all. Have anyone experienced problems with archive manager on version 9.2.1.006. We upgraded to this version a couple of weeks ago, ever since the archive manager crashes after only a few hours, have tried the db repair myisamchk with no success. All the best Jon Magnus Dullerud Norwegian Defence --- To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected] ----- Nenhum vírus encontrado nessa mensagem. Verificado por AVG - www.avgbrasil.com.br Versão: 2012.0.2193 / Banco de dados de vírus: 2437/5111 - Data de Lançamento: 07/04/12 --- To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected] --- To unsubscribe from spectrum, send email to [email protected] with the body: unsubscribe spectrum [email protected]
