mindhunter Posted June 8, 2010 Share Posted June 8, 2010 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. Link to comment Share on other sites More sharing options...
lpgservers Posted June 8, 2010 Share Posted June 8, 2010 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. Link to comment Share on other sites More sharing options...
mindhunter Posted June 8, 2010 Author Share Posted June 8, 2010 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 Link to comment Share on other sites More sharing options...
ECF Posted June 9, 2010 Share Posted June 9, 2010 You are probably trying to collect your stats too often. Or your stats data files may be corrupted. Link to comment Share on other sites More sharing options...
mindhunter Posted June 11, 2010 Author Share Posted June 11, 2010 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.