Master monitor crashes regular

[mindhunter]

My master monitor keeps crashing randomly and I think it's time to find out what the problem is.

 

I'm currently running 1 master monitor with 1 remote.

 

I've checked the monitor.errors file and it seems like it keeps repeating these errors:

 

StandardPlugins.Database.Manager.ExecuteNonQuery: ERROR [42S02] [MySQL][ODBC 3.51 Driver][mysqld-5.1.41-community]Can't find file: 'tc_server_performance' (errno: 2) SQL Command: INSERT INTO TC_SERVER_PERFORMANCE (PERF_KEY, PERF_DATE, PERF_VALUE)VALUES('TC0454355207228865781304', '2010-05-16 16:51:52', '77284.59')
5/16/2010 5:00:03 PM : StandardPlugins.Database.Manager.ExecuteNonQuery: ERROR [42S02] [MySQL][ODBC 3.51 Driver][mysqld-5.1.41-community]Can't find file: 'tc_server_performance' (errno: 2) SQL Command: INSERT INTO TC_SERVER_PERFORMANCE (PERF_KEY, PERF_DATE, PERF_VALUE)VALUES('TC2520364772142030818310', '2010-05-16 16:51:52', '183427.6')
5/16/2010 5:00:03 PM : StandardPlugins.Database.Manager.ExecuteNonQuery: ERROR [42S02] [MySQL][ODBC 3.51 Driver][mysqld-5.1.41-community]Can't find file: 'tc_server_performance' (errno: 2) SQL Command: INSERT INTO TC_SERVER_PERFORMANCE (PERF_KEY, PERF_DATE, PERF_VALUE)VALUES('TC8858767770642668387648', '2010-05-16 16:51:52', '100000000')
5/16/2010 5:00:03 PM : StandardPlugins.Database.Manager.ExecuteNonQuery: ERROR [42S02] [MySQL][ODBC 3.51 Driver][mysqld-5.1.41-community]Can't find file: 'tc_server_performance' (errno: 2) SQL Command: INSERT INTO TC_SERVER_PERFORMANCE (PERF_KEY, PERF_DATE, PERF_VALUE)VALUES('TC1024776354464743315654', '2010-05-16 16:51:52', '1.027231')
5/16/2010 5:00:03 PM : StandardPlugins.Database.Manager.ExecuteNonQuery: ERROR [42S02] [MySQL][ODBC 3.51 Driver][mysqld-5.1.41-community]Can't find file: 'tc_server_performance' (errno: 2) SQL Command: INSERT INTO TC_SERVER_PERFORMANCE (PERF_KEY, PERF_DATE, PERF_VALUE)VALUES('TC6715077847137236128870', '2010-05-16 16:51:52', '1.027231')
5/16/2010 5:00:03 PM : StandardPlugins.Database.Manager.ExecuteNonQuery: ERROR [42S02] [MySQL][ODBC 3.51 Driver][mysqld-5.1.41-community]Can't find file: 'tc_server_performance' (errno: 2) SQL Command: INSERT INTO TC_SERVER_PERFORMANCE (PERF_KEY, PERF_DATE, PERF_VALUE)VALUES('TC7871086422051300146886', '2010-05-16 16:51:53', '2.054462')
5/16/2010 5:00:03 PM : StandardPlugins.Database.Manager.ExecuteNonQuery: ERROR [42S02] [MySQL][ODBC 3.51 Driver][mysqld-5.1.41-community]Can't find file: 'tc_server_performance' (errno: 2) SQL Command: INSERT INTO TC_SERVER_PERFORMANCE (PERF_KEY, PERF_DATE, PERF_VALUE)VALUES('TC0047005016774463165802', '2010-05-16 16:51:53', '1000000000')
5/16/2010 5:00:03 PM : StandardPlugins.Database.Manager.ExecuteNonQuery: ERROR [42S02] [MySQL][ODBC 3.51 Driver][mysqld-5.1.41-community]Can't find file: 'tc_server_performance' (errno: 2) SQL Command: INSERT INTO TC_SERVER_PERFORMANCE (PERF_KEY, PERF_DATE, PERF_VALUE)VALUES('TC2113014581687647284817', '2010-05-16 16:51:53', '6.175029')
5/16/2010 5:00:03 PM : StandardPlugins.Database.Manager.ExecuteNonQuery: ERROR [42S02] [MySQL][ODBC 3.51 Driver][mysqld-5.1.41-community]Can't find file: 'tc_server_performance' (errno: 2) SQL Command: INSERT INTO TC_SERVER_PERFORMANCE (PERF_KEY, PERF_DATE, PERF_VALUE)VALUES('TC8442407688286276672336', '2010-05-16 16:51:53', '23.72223')
5/16/2010 5:00:03 PM : StandardPlugins.Database.Manager.ExecuteNonQuery: ERROR [42S02] [MySQL][ODBC 3.51 Driver][mysqld-5.1.41-community]Can't find file: 'tc_server_performance' (errno: 2) SQL Command: INSERT INTO TC_SERVER_PERFORMANCE (PERF_KEY, PERF_DATE, PERF_VALUE)VALUES('TC1517416263010451601343', '2010-05-16 16:51:53', '3.294754')
5/16/2010 5:00:03 PM : StandardPlugins.Database.Manager.ExecuteNonQuery: ERROR [42S02] [MySQL][ODBC 3.51 Driver][mysqld-5.1.41-community]Can't find file: 'tc_server_performance' (errno: 2) SQL Command: INSERT INTO TC_SERVER_PERFORMANCE (PERF_KEY, PERF_DATE, PERF_VALUE)VALUES('TC6308626756673844413477', '2010-05-16 16:51:53', '6.352961')
5/16/2010 5:00:03 PM : StandardPlugins.Database.Manager.ExecuteNonQuery: ERROR [42S02] [MySQL][ODBC 3.51 Driver][mysqld-5.1.41-community]Can't find file: 'tc_server_performance' (errno: 2) SQL Command: INSERT INTO TC_SERVER_PERFORMANCE (PERF_KEY, PERF_DATE, PERF_VALUE)VALUES('TC8464635331506017432484', '2010-05-16 16:51:53', '4.612655')

 

 

what could be the problem and how would I fix it so I dont have to keep restarting the service.

[lpgservers]

Your missing the table in your database TC_SERVER_PERFORMANCE

 

How or why that happened would have to be answered by Luis probably. I'd say your best bet is to put a ticket in for that.

[mindhunter]

allright, database is fixed after repairing/replacing 3 database tables.

 

However the monitor still crashes and I have no clue what the problem is. The logs don't show a reason why the master monitor stopped running and after restarting it, it runs correct until it crashes again.

 

If no-one has any experience with this/these problems I will open up a support ticket for it.

 

Thanx in advance guys

[ECF]

You are probably trying to collect your stats too often. Or your stats data files may be corrupted.

[mindhunter]

After restarting the master server and all remote servers it somehow seems te be running stable again. I gues all it needed was fixing the corrupted tables as I did and restart all of them.

 

Thanx for the help and this great product.