Kryptix Posted November 5, 2009 Share Posted November 5, 2009 I'm running XAMPP on Windows Server 2003 and have been for a few months now. When I first set it up I got this weird error in err.log: 091027 22:52:09 [Note] Event Scheduler: Purging the queue. 0 events 091027 22:52:09 InnoDB: Starting shutdown... 091027 22:52:10 InnoDB: Shutdown completed; log sequence number 0 69112 091027 22:52:10 [Note] PrimeBase XT Engine shutdown... 091027 22:52:10 [Warning] Forcing shutdown of 1 plugins 091027 22:52:10 [Note] C:\XAMPP\mysql\bin\mysqld.exe: Shutdown complete This went away randomly for ages, and then today it came back and proceeded to shut MySQL down every 13 minutes... I've renamed all the 'event' files in 'XAMPP\mysql\data\mysql' as well as trying to disable the 'event scheduler' via 'my.ini', but it says it's a unknown command. The guide I followed told me to try 'my.cfg' but I can't find this anywhere. Has anyone got any other ideas? This is really getting annoying now. Quote Link to comment https://forums.phpfreaks.com/topic/180410-event-scheduler-shutting-down-mysql/ Share on other sites More sharing options...
Mchl Posted November 5, 2009 Share Posted November 5, 2009 What this says? SELECT * FROM `information_schema`.`EVENTS`; Quote Link to comment https://forums.phpfreaks.com/topic/180410-event-scheduler-shutting-down-mysql/#findComment-951751 Share on other sites More sharing options...
Kryptix Posted November 5, 2009 Author Share Posted November 5, 2009 MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0008 sec ) Quote Link to comment https://forums.phpfreaks.com/topic/180410-event-scheduler-shutting-down-mysql/#findComment-951868 Share on other sites More sharing options...
Mchl Posted November 5, 2009 Share Posted November 5, 2009 That would indicate you have no events scheduled... Try asking also here: http://forums.mysql.com/ Quote Link to comment https://forums.phpfreaks.com/topic/180410-event-scheduler-shutting-down-mysql/#findComment-951882 Share on other sites More sharing options...
Kryptix Posted November 5, 2009 Author Share Posted November 5, 2009 That would indicate you have no events scheduled... Try asking also here: http://forums.mysql.com/ I have, I've bumped it 3 times now, no reply what-so-ever. I've just re-installed the latest copy of MySQL and it happens exactly the same. I'm at a lost end, what else is there to try? :'( Quote Link to comment https://forums.phpfreaks.com/topic/180410-event-scheduler-shutting-down-mysql/#findComment-951888 Share on other sites More sharing options...
fenway Posted November 18, 2009 Share Posted November 18, 2009 What are event files? What version? Quote Link to comment https://forums.phpfreaks.com/topic/180410-event-scheduler-shutting-down-mysql/#findComment-960098 Share on other sites More sharing options...
Kryptix Posted December 6, 2009 Author Share Posted December 6, 2009 It turns out it was a query causing it to crash, but I still don't know which one. No error was given what-so-ever, it just shut down MySQL. All sorted now though. Quote Link to comment https://forums.phpfreaks.com/topic/180410-event-scheduler-shutting-down-mysql/#findComment-972200 Share on other sites More sharing options...
Mchl Posted December 6, 2009 Share Posted December 6, 2009 Interesting. Can you tell us HOW it was fixed? Did you need to upgrade your server or something else? Quote Link to comment https://forums.phpfreaks.com/topic/180410-event-scheduler-shutting-down-mysql/#findComment-972275 Share on other sites More sharing options...
Kryptix Posted December 9, 2009 Author Share Posted December 9, 2009 Interesting. Can you tell us HOW it was fixed? Did you need to upgrade your server or something else? Trust be told, I don't actually know. I was using two different versions of the game. One made it crash and one didn't. To diagnose the difference would take hours as it queries something like 50-200 times a minute and it used to sometimes take over 3 hours to crash. It would close MySQL though with no errors what-so-ever. I even updated to the latest version. Quote Link to comment https://forums.phpfreaks.com/topic/180410-event-scheduler-shutting-down-mysql/#findComment-973936 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.