Failure Trace Archive

The trace format is organized hierarchically as follows:
Platform → Node → Component → Event Trace.

---

We summary the meaning of each table below. Table names are shown in bold.

• A platform contains a set of nodes. Examples of a platform include SETI@home, desktops at Microsoft.
• A node contains a set of components, which is a software module or hardware resource of the node. Each node can have several components (e.g. CPU speed, availability memory, client availability), each of which has a corresponding trace.
• A component describes attributes of a software module or hardware resource of a node.
• component_perf is the component performance, as measured through benchmarks for example.
• A creator is the person responsible for the trace data set. This table stores details about citations and copyright.
• An event_trace is the trace of an event, with all of corresponding timing information
• event_state is the state corresponding to an event_trace. For example, for CPU availability, the event_state could be the idleness of the CPU. For host availability, it could be the monitoring information associated with the event.

---

A description of the table attributes appears below. The mysql schema is defined in fta.src.

platform

platform_id	A unique number identifying this platform. It allows one to differentiate pools of nodes.
platform_name	name of the platform (e.g. "Berkeley_NOW_Lab_Fall_1998")
platform_location	location name of the platform source (e.g. "Berkeley NOW Lab - Soda Hall 2nd Floor, USA, Planet Earth")
platform_type	type of the platform (cluster, multicluster, grid, desktop_grid, or volunteer_computing)
notes	miscellaneous notes

node

node_id	unique ID for this node
platform_id	id of the platform containing node
node_name	name of node
node_ip	IP address
node_location	location of the node (e.g. country, geographic coordinates)
timezone	time zone of the resource (second offset from GMT)
proc_model	processor name, model, version number
os_name	name and version of the resource OS
cores_per_proc	number of cores per processor
num_procs	number of processors for this node
mem_size	number of bytes of memory
disk_size	number of bytes of disk space
up_bw	number of bytes/sec of upload speed
down_bw	number of bytes/sec of download speed
metric_id	unique ID for performance metric (e.g. benchmark)
notes	other notes related to this resource

node_perf

metric_id	unique ID for performance metric (benchmark)
node_id	unique ID for this node
platform_id	ID of platform containing node
sfpop_speed	single precision floating point speed (ops/sec)
dfpop_speed	double precision floating point speed (ops/sec)
iop_speed	integer operation speed (ops/sec)
i_val	integer
f_val	float
s_val	string

component

component_id	unique ID for this component
node_id	ID of the node containing this component
platform_id	ID of platform containing this node
creator_id	ID of creator of this component trace data
node_name	Name of the node
component_type	type of this component trace (for example, host, CPU, or network). see below for codes
trace_start	when the trace event first appeared (epoch time). Can be NULL if component was always available.
trace_end	when the trace event last appeared (epoch time). Can be NULL if component was always available.
resolution	resolution of the traces in seconds

creator

creator_id	ID of creator of this component trace data
component_id	unique ID for this component trace data
node_id	ID of the node corresponding to this trace
platform_id	ID of platform containing node
creator	name(s) of the person(s) who recorded the event traces
cite	citation (bibtex, etc) for using the data from the event traces
copyright	details of the copyright and rights reserved

event_trace

event_id	unique ID of event state
component_id	unique ID for this component trace data
node_id	unique ID for this node
platform_id	ID of platform that is the node parent
node_name	name of node
event_type	type of event. see below for event_type codes
event_start_time	start of this event (UNIX epoch time)
event_end_time	end of this event (UNIX epoch time)
event_end_reason	reason the event type or state changed at the end of this trace (for example, reason that CPU became unavailable. see below for event_end_reason codes)

event_state

event_id	unique ID of event state
component_id	unique ID for this component trace data
node_id	unique ID for this node
platform_id	ID of platform that is the node parent
i_val	integer
f_val	float (for example, 0% - 100% for CPU availability)
s_val	string

Component type codes

component.component_type code definitions

code	definition
0	host
1	CPU
2	IO
3	network
4	memory
5	software

Event type codes

Below are code ranges and definitions for the fields above.

Event id's up to 10,000 are reserved; the rest can be user defined.

event_trace.event_type code definitions

code	definition
0	unavailability
1	availability
2*	user present
3*	CPU threshold exceeded

(*) These codes are specifically for the Notre Dame trace.

---

Event end reason codes

The failure classification below is based on the traces from LANL.

event_trace.event_end_reason code ranges

code range	category
NULL	not reported
0	reported as undetermined
1-999	infrastructure
1000-1999	hardware
2000-2999	IO
3000-3999	network
4000-4999	software
5000-5999	human error
6000-6999	user
7000	end of measurement

event_trace.event_end_reason code definitions

code	definition
NULL	not reported
0	reported as undetermined
1	Infrastructure: Infrastructure
2	Infrastructure: Power Outage
3	Infrastructure: Power Spike
4	Infrastructure: Chillers
5	Infrastructure: Environment
6	Infrastructure: UPS
1000	Hardware: Hardware
1001	Hardware: 40MM Cooling Fan
1002	Hardware: Bach Plane Assembly
1003	Hardware: CD ROM
1004	Hardware: Console Interface Module
1005	Hardware: CPU
1006	Hardware: DG Board
1007	Hardware: Fan
1008	Hardware: Fan Assembly
1009	Hardware: GFX Power Supply
1010	Hardware: Graphics Accel Hdwr
1011	Hardware: Graphics Video Card
1012	Hardware: Heatsink bracket
1013	Hardware: IO6
1014	Hardware: IOS Buffer Memory
1015	Hardware: IOS CPU
1016	Hardware: KGPSA
1017	Hardware: Ktown Board
1018	Hardware: Maintenance
1019	Hardware: Memory Dimm
1020	Hardware: Memory Dimm/CPU
1021	Hardware: Memory Module
1022	Hardware: MIA
1023	Hardware: Mid-plane
1024	Hardware: MMB
1025	Hardware: Module Assembly
1026	Hardware: MSC Board
1027	Hardware: OCP
1028	Hardware: PCI Back Plane
1029	Hardware: Power cord
1030	Hardware: Power Supply
1031	Hardware: Rack Power Distribution Unit
1032	Hardware: Riser Card
1033	Hardware: RM Board
1034	Hardware: SSD Logic
1035	Hardware: SSD Memory Module
1036	Hardware: System Board
1037	Hardware: System Controller
1038	Hardware: Temp Probe
1039	Hardware: Term Server
1040	Hardware: Vhisp
1041	Hardware: WACS Logic
1042	Hardware: Wire Harness
1043	Hardware: Xtown Board
1044	Hardware: Node Board
2000	IO: IO
2001	IO: Disk Cabinet
2002	IO: Disk Drive
2003	IO: Drive Cage
2004	IO: Fddi
2005	IO: Fibre Cable
2006	IO: Fibre Channel Port Adapter
2007	IO: Fibre Drive
2008	IO: Fibre HBA
2009	IO: Fibre Raid Controller
2010	IO: Fibre Raid LCC card
2011	IO: Fibre Raid Midplane
2012	IO: Fibre Raid Power Supply
2013	IO: IDE Cable
2014	IO: IOS Disk Logic
2015	IO: PCI Fibre Channel Adapter
2016	IO: PCI IO Module
2017	IO: PCI SCSI Controller
2018	IO: PCI Shoebox
2019	IO: SAN Appliance
2020	IO: SAN Controller
2021	IO: SAN Disk Drive
2022	IO: SAN Fiber Cable
2023	IO: SAN GBIC
2024	IO: SAN Shelf
2025	IO: SAN Switch
2026	IO: SCSI Adapter Card
2027	IO: SCSI Controller
2028	IO: SCSI Drive
2029	IO: SCSI Back Plane
2030	IO: HSV
2031	IO: IO Controller
3000	Network: Network
3001	Network: 1 GBit Ethernet Card
3002	Network: 100 MBit Ethernet Card
3003	Network: Ethernet Cable
3004	Network: Ethernet Copper Cable
3005	Network: Ethernet Fiber Cable
3006	Network: Ethernet Switch
3007	Network: GE Board
3008	Network: Gig E Connection
3009	Network: Gig E Switch
3010	Network: Interconnect
3011	Network: Interconnect Cable
3012	Network: Interconnect Interface
3013	Network: Interconnect Misc
3014	Network: Interconnect Soft Error
3015	Network: Interconnect Switch
3016	Network: PCI Ethernet Board
3017	Network: PCI GBIT Ethernet Board
3018	Network: Router Board
3019	Network: Site Ethernet Switch
3020	Network: Site Network Interface
3021	Network: Console Network Device
3022	Network: ELAN
4000	Software: Software
4001	Software: Disk IO, firmware and storage
4002	Software: MPI, PVM, Array services
4003	Software: Cluster File System
4004	Software: Cluster Software
4005	Software: Compilers and libraries
4006	Software: DST
4007	Software: DST-Scan for errors /scratch
4008	Software: DST-Upgrd/Install OS sftw
4009	Software: DST-Upgrd/Instl 3rdParty Sftw
4010	Software: DST-Upgrd/Instl OS Sftw
4011	Software: Interconnect
4012	Software: IOS Software
4013	Software: Kernel software
4014	Software: Modify kernel parameters
4015	Software: Modify system config files
4016	Software: Network
4017	Software: NFS
4018	Software: OS
4019	Software: Parallel File System
4020	Software: Patch Install
4021	Software: Resource Mgmt System
4022	Software: Scheduler Software
4023	Software: Scratch Drive
4024	Software: Scratch FS
4025	Software: Security Software
4026	Software: Upgrade/Install 3rd Party Sftw
4027	Software: Upgrade/Install OS sftw
4028	Software: User code
4029	Software: Vizscratch FS
4030	Software: Applications
5000	Human Error: Human Error
6000	User: User
6001	User: Mouse Activity
6002	User: Keyboard Activity
6003	User: Shutdown