'Leap second' snafu affects Oracle clusterware

By Chris Kanaracus, IDG News Service |  Software, database, leap year Add a new comment

The additional second that time-tracking scientists added to 2008 to adjust for the slowing of the earth's rotation is causing problems with Oracle's Cluster Ready Services (CRS) clusterware, but a pair of fixes are available, said an Oracle document dated Monday.

CRS is used in conjunction with Oracle's Real Application Clusters software, which allows one Oracle database to be deployed on a group of servers or "nodes," providing fault tolerance and scalability.

The "leap second event" is causing CRS nodes to reboot, according to an Oracle document detailing the problem. Among the affected platforms are Oracle Server Enterprise Edition Version 10.1.0.2 to 11.1.0.7; Sun Solaris SPARC (64-bit); and Oracle CRS and patchsets 10.2.0.1 to 11.1.0.7.

Coordinated Universal Time (UTC) is the world's standard for time. UTC is "regularly adjusted by introducing a leap second based on the accumulated difference between the atomic clock time (TAI) and UT1, the time reflecting the Earth's rotational speed," Oracle said.

Leap seconds are handled by the International Earth Rotation and Reference System Service (IERS), which added one second to Dec. 31.

Due to this, "NTP daemons had to adjust time accordingly and CRS product stack has encountered problems resulting in node reboots," the Oracle document states.

NTP, which stands for Network Time Protocol, is the standard used for synchronizing the clocks of computers. NTP employs UTC for a reference time.

The reboots will occur on affected nodes only when two specific conditions are present, which are detailed in Oracle's announcement. The document also includes two methods for fixing the issue, including available patches.

A spokesman for Oracle did not immediately respond to a request for additional comment.

The rebooting issue prompted some discussion on user forumsand lists in recent days.

"This begs the question -- how the heck do timekeepers and politicians get away with last minute time changes?" one user posted. "Surely there's some pushback from technology-related interest groups to try and get more than four weeks warning?"

Other posters, however, pointed out that the IERS announcement regarding the most recent leap second was made in July 2008.

Oracle's announcement is one of the latest leap-year related bugs to surface. Last week, one involved Microsoft's Zune media player.

    Add a comment

    Post a comment using one of these accounts
    Or join now
    At least 6 characters

    Note: Comment will appear soon after you have activated your account.
    Obscene/spam comments will be removed and accounts suspended.
    The information you submit is subject to our Privacy Policy and Terms of Service.

    ITworld LIVE

    SoftwareWhite Papers & Webcasts

    White Paper

    Best Practices Guide: Microsoft Exchange 2010 on VMware

    This guide provides best practice guidelines for deploying Exchange Server 2010 on vSphere.

    White Paper

    Free Trial: vRanger, the Powerful VMware Recovery Solution

    When disaster strikes, don't waste hours and dollars recovering critical data. vRanger delivers blazing-fast speed and granular recovery for your VMware applications and data. Get your free trial today.

    White Paper

    Executive Guide to Business and Software Requirements

    This paper is designed as an executive briefing on the issues surrounding business and software requirements. It features a wealth of statistics and tactics to help you get requirements right, and includes a tear-out single page summary.

    White Paper

    How to Launch a Successful IT Automation Initiative

    Corporations across all industries are under increasing pressure to cut costs and work more efficiently. In the race to meet both of these requirements, many organizations turn to technology, often purchasing and installing disparate pieces of software in hopes of achieving efficiencies not afforded by manual systems.

    White Paper

    Why Corporations Need to Automate IT Systems Management

    With corporate budgets being slashed and leaders expecting more out of their employees, companies are forced to do more with less, yet are still expected to provide the highest quality experience to customers. This is pushing them to make better use of their IT assets without breaking the budget. Companies are under more pressure than ever, thanks to data management regulations; increasingly complex security threats; and growing demand from management and end users for 24/7 uptime and high performance. These hurdles require a strategic investment in technologies that boost efficiency, save money and position IT as an integral part of the entire firm's operations. IT systems management is helping corporations fill these gaps.

    See more White Papers | Webcasts

    Ask a question

    Ask a Question