Product Documentation

c-treeACE V11.0 Update Guide

Previous Topic

Next Topic

Using ctalog SYSLOG Utility to Read Restore Point Data

The ctalog utility is a sample program that can read the SYSLOG files and display their contents. It can purge the contents of the SYSLOG files. A sample record output from ctalog is shown below.

The first record corresponds to a failed server startup because of a read error (36) with the temporary event file. (Such an error is very unlikely and was forced under a debugger for demonstration purposes.) The second record output shows the result of the subsequent successful startup with a rollback. Note that the second record output indicates a rollback is pending. The rollback is pending because the first attempt at recovery failed.


Class = 8 (Restore Point)

Event = 2 (Recovery results with Restore Points)

Date = 08/08/2014

Time = 11:57:19

Sequence number = 2

Error code = 36

User ID = ''

Node name = ''

Variable-length information:

---------------------------------------------------

Restore point specifications -

serial number: 1

log number: 1

log position: 23e58x

timestamp: 1407499816 Fri Aug 08 07:10:16 2014

type: Lightweight RP

name: 20140808_071016

Recovery/Restore Point status bits:

- Deferred LOG SYNC was enabled at the time of the crash

- RECOVER_TO_RESTORE_POINT is enabled

- rollback attempted

- rollback error

- error inserting skip forward info into log

Event originally added to temporary event file on

failed startup at 20140808 115705

System state:

All transactions committed before the system crash are recovered, but

rollback to a Restore Point failed (see error code) during the insertion of the

skip forward information into the Restore Point. It may be necessary to use the

log file copied before the insertion.

---------------------------------------------------

Class = 8 (Restore Point)

Event = 2 (Recovery results with Restore Points)

Date = 08/08/2014

Time = 11:57:19

Sequence number = 3

Error code = 0

User ID = ''

Node name = ''

Variable-length information:

---------------------------------------------------

Restore point specifications -

serial number: 1

log number: 1

log position: 23e58x

timestamp: 1407499816 Fri Aug 08 07:10:16 2014

type: Lightweight RP

name: 20140808_071016

Recovery/Restore Point status bits:

- Deferred LOG SYNC was enabled at the time of the crash

- pending rollback from previous recovery from Deferred LOG SYNC crash

- RECOVER_TO_RESTORE_POINT is enabled

- rollback attempted

- rollback to Restore Point completed

System state:

All transactions committed before the Restore Point are recovered, and

any transactions committed after the Restore Point are undone.

---------------------------------------------------

The system state output corresponds to the final system state bitmap entries shown above. The following routine is in ctalog.c:

VOID printRPsyslogrec (pSYSLOGrec psr,NINT print_header)

This routine could be used in other applications designed to read the SYSLOG files. Its only external requirements are the dateout() and timeout() routines included in ctalog.c.

The print_header parameter indicates whether or not to print the information from the common SYSLOG record header. ctalog sets this to NO since it already prints the information for each event. For a specialized SYSLOG reader, one might want to print the header information from the routine. ctalog calls this routine for each ctSYSLOGrstpnt event.

TOCIndex