|
|
Info Catalog
(mysql.info.gz) MySQL Cluster Logging Management Commands
(mysql.info.gz) MySQL Cluster Event Reports
16.5.2.2 Log Events
...................
All reportable events are listed below.
*Event* *Category* *Priority**Severity**Description*
DB nodes CONNECTION 8 INFO
connected
DB nodes CONNECTION 8 INFO
disconnected
Communication CONNECTION 8 INFO API & DB nodes connection
closed closed
Communication CONNECTION 8 INFO API & DB nodes connection
opened opened
Global checkpoint CHECKPOINT 9 INFO Start of a GCP, i.e., REDO
started log is written to disk
Global checkpoint CHECKPOINT 10 INFO GCP finished
completed
Local checkpoint CHECKPOINT 7 INFO Start of local check
started pointing, i.e., data is
written to disk. LCP Id and
GCI Ids (keep and oldest
restorable)
Local checkpoint CHECKPOINT 8 INFO LCP finished
completed
LCP stopped in CHECKPOINT 0 ALERT LCP stopped!
calc keep GCI
Local checkpoint CHECKPOINT 11 INFO A LCP on a fragment has been
fragment completed
completed
Report undo log CHECKPOINT 7 INFO Reports undo logging blocked
blocked due buffer near to overflow
DB node start STARTUP 1 INFO NDB Cluster starting
phases initiated
DB node all start STARTUP 1 INFO NDB Cluster started
phases completed
Internal start STARTUP 15 INFO Internal start signal to
signal received blocks received after
STTORRY restart finished
DB node start STARTUP 4 INFO A start phase has completed
phase X completed
Node has been STARTUP 3 INFO President node, own node and
successfully dynamic id is shown
included into the
cluster
Node has been STARTUP 8 INFO
refused to be
included into the
cluster
DB node STARTUP 8 INFO Show left and right DB nodes
neighbours neighbours
DB node shutdown STARTUP 1 INFO
initiated
DB node shutdown STARTUP 1 INFO
aborted
New REDO log STARTUP 10 INFO GCI keep X, newest
started restorable GCI Y
New log started STARTUP 10 INFO Log part X, start MB Y, stop
MB Z
Undo records STARTUP 15 INFO
executed
Completed copying NODERESTART 8 INFO
of dictionary
information
Completed copying NODERESTART 8 INFO
distribution
information
Starting to copy NODERESTART 8 INFO
fragments
Completed copying NODERESTART 10 INFO
a fragment
Completed copying NODERESTART 8 INFO
all fragments
Node failure NODERESTART 8 ALERT Reports node failure phases
phase completed
Node has failed, NODERESTART 8 ALERT Reports that a node has
node state was X failed
Report whether an NODERESTART 6 INFO 7 different cases
arbitrator is
found or not
- President restarts
arbitration thread [state=X]
- Prepare arbitrator node X
[ticket=Y]
- Receive arbitrator node X
[ticket=Y]
- Started arbitrator node X
[ticket=Y]
- Lost arbitrator node X -
process failure [state=Y]
- Lost arbitrator node X -
process exit [state=Y]
- Lost arbitrator node X
<error msg>[state=Y]
Report arbitrator NODERESTART 2 ALERT 8 different results
results
- Arbitration check lost -
less than 1/2 nodes left
- Arbitration check won -
node group majority
- Arbitration check lost -
missing node group
- Network partitioning -
arbitration required
- Arbitration won - positive
reply from node X
- Arbitration lost -
negative reply from node X
- Network partitioning - no
arbitrator available
- Network partitioning - no
arbitrator configured
GCP take over NODERESTART 7 INFO
started
GCP take over NODERESTART 7 INFO
completed
LCP take over NODERESTART 7 INFO
started
LCP take NODERESTART 7 INFO
completed (state
= X)
Report STATISTICS 8 INFO # of: transactions, commits,
transaction reads, simple reads, writes,
statistics concurrent operations,
attribute info, aborts
Report operations STATISTICS 8 INFO # of operations
Report table STATISTICS 7 INFO
create
Report job STATISTICS 9 INFO Mean Internal job scheduling
scheduling statistics
statistics
Sent # of bytes STATISTICS 9 INFO Mean # of bytes sent to node
X
Received # of STATISTICS 9 INFO Mean # of bytes received
bytes from node X
Memory usage STATISTICS 5 INFO Data and Index memory usage
(80%, 90% and 100%)
Transporter ERROR 2 ERROR
errors
Transporter ERROR 8 WARNING
warnings
Missed heartbeats ERROR 8 WARNING Node X missed heartbeat # Y
Dead due to ERROR 8 ALERT Node X declared dead due to
missed heartbeat missed heartbeat
General warning ERROR 2 WARNING
events
Sent heartbeat INFO 12 INFO Heartbeat sent to node X
Create log bytes INFO 11 INFO Log part, log file, MB
General info INFO 2 INFO
events
An event report has the following format in the logs:
<date & time in GMT> [<any string>] <event severity> -- <log message>
09:19:30 2003-04-24 [NDB] INFO -- Node 4 Start phase 4 completed
Info Catalog
(mysql.info.gz) MySQL Cluster Logging Management Commands
(mysql.info.gz) MySQL Cluster Event Reports