ALERT! Savings Time / MYSQL Bugs galore - GoFuckYourself.com

teksonline · 03-11-2007, 09:44 PM

Y2K coming back to haunt us...

due to the change in daylight savings lots of problems ahead

Check your servers as it appears mysql uses some sort of time caching feature and your cron jobs probably did not run tonite.... catch it fast and save tons of headaches tommorow!

2012 · 03-11-2007, 09:46 PM

thanks for the heads up

BigBen · 03-11-2007, 10:46 PM

Stop and start mysql and it should be alright as long as your server time is set properly. I just restarted my servers as there were a few different services that were screwed up and everything synced properly on the restart.

RawAlex · 03-12-2007, 12:17 AM

Here is a cron job secret, one of the best ones I ever learned.

Never schedule anything to run between 2 and 3 am on a Sunday morning. Then you never have issues with time changes. Always schedule for after 3am (because it only happens once) and not before (1 am) because once a year it will happen twice.

xxxice · 03-12-2007, 11:46 AM

Off topic does Free BSD have any issues with the time change ?

kacy · 03-12-2007, 12:55 PM

http://www.freebsd.org/releng/dst_info.html

03-11-2007, 09:44 PM	#1
teksonline So Fucking Banned Join Date: Jan 2005 Location: At My Desk Posts: 2,904	ALERT! Savings Time / MYSQL Bugs galore Y2K coming back to haunt us... due to the change in daylight savings lots of problems ahead Check your servers as it appears mysql uses some sort of time caching feature and your cron jobs probably did not run tonite.... catch it fast and save tons of headaches tommorow!

03-11-2007, 09:46 PM	#2
2012 So Fucking What Industry Role: Join Date: Jul 2006 Posts: 17,189	thanks for the heads up __________________ best host: Webair \| best sponsor: Kink \| best coder: 688218966 \| Go Fuck Yourself

03-12-2007, 12:55 PM	#6
kacy Confirmed User Join Date: Oct 2002 Location: So Cal Posts: 877	http://www.freebsd.org/releng/dst_info.html __________________ ~Kacy

03-11-2007, 10:46 PM	#3
BigBen Confirmed User Join Date: Nov 2004 Location: scv Posts: 2,299	Stop and start mysql and it should be alright as long as your server time is set properly. I just restarted my servers as there were a few different services that were screwed up and everything synced properly on the restart.

03-12-2007, 12:17 AM	#4
RawAlex So Fucking Banned Join Date: Oct 2003 Location: In a house. Posts: 9,465	Here is a cron job secret, one of the best ones I ever learned. Never schedule anything to run between 2 and 3 am on a Sunday morning. Then you never have issues with time changes. Always schedule for after 3am (because it only happens once) and not before (1 am) because once a year it will happen twice.

03-12-2007, 11:46 AM	#5
xxxice Confirmed User Join Date: Feb 2002 Posts: 5,042	Off topic does Free BSD have any issues with the time change ?