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.
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)
- Stop xntpd on the clients and the database server:
stopsrc -s xntpd - Set the clock's time by calling the settimeofday subroutine:
ntpdate -b - Clear the contents from the /etc/ntp.drift file
- Restart the servers:
startsrc -s xntpd