Preventing 5319 errors when using a remote database server


Problem


ERROR: 5319 Invalid msg creation time detected
Explanation: The system detected that a message’s creation time was invalid.

Cause


When using a remote database server in a SSI cluster, a time daemon should be used to maintain the same time on all machines, for example, the Network Time Protocol (NTP) daemon. However, occasionally the times can become unsynchronized and the 5319 DBSM (database server) return code can be thrown.

Resolving the problem


If using the NTP daemon: (as the root user)
  1. Stop xntpd on the clients and the database server:
    stopsrc -s xntpd
  2. Set the clock's time by calling the settimeofday subroutine:
    ntpdate -b
  3. Clear the contents from the /etc/ntp.drift file
  4. Restart the servers:
    startsrc -s xntpd