The reported time is the time the server became a primary server or a secondary server. The STANDALONE state is considered to be a primary server state.
The primary start time is set when the following transitions occur:
▪ SECONDARY ALONE => PRIMARY ALONE
▪ SECONDARY ALONE => STANDALONE
▪ SECONDARY ACTIVE => PRIMARY ACTIVE
The secondary start time is set when the following transitions occur:
▪ The server is started in the SECONDARY ALONE state
▪ OFFLINE (started with -x backupserver) => SECONDARY ALONE
▪ PRIMARY ALONE => SECONDARY ALONE
▪ STANDALONE => SECONDARY ALONE
▪ PRIMARY ACTIVE => SECONDARY ACTIVE
If the current role contradicts the query, the query returns an empty string. For example, if the server is a secondary server and you run the command 'info primarystarttime', an empty string is returned.