June Will Be 1 Second Longer

by
in internet on (#9XMS)
story imageIt's a dreaded day for many Internet companies: On June 30, an extra second will be added to the clock, creating the potential to wreak havoc on computer systems not equipped to handle the change. The International Earth Rotation and Reference Systems (IERS) announced an extra second will be added at the end of June to account for a discrepancy between Earth's rotation and the atomic clock. The extra second will be added as the clock strikes midnight universal time, meaning the extra second will come for people in the United States at 8 p.m. EDT. There have been 25 instances since 1972 of an extra second being added.

It's possible that programs not equipped to handle the extra second could have an issue. When the last leap second was added on June 30, 2012, it caused issues with a number of websites, including LinkedIn and Yelp. Mozilla, Reddit and Foursquare all experienced system crashes. Qantas was hard hit, too, with a failure of its check-in system creating flight delays across the network.
Fatal Error - sql [select reason, count(reason) as reason_count, value from comment_vote where comment_id = ? group by reason order by reason_count desc] arg [325649] msg [SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'pipedot.comment_vote.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by] - Pipedot
Fatal Error
sql [select reason, count(reason) as reason_count, value from comment_vote where comment_id = ? group by reason order by reason_count desc] arg [325649] msg [SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'pipedot.comment_vote.value' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by]