ReleaseEngineering/Buildbot Database Schemas

All data featured here is accurate as of Wednesday, July 17th, 2013.

Accessing the Buildbot Database

To access the database with mysql, you'll want to login to cruncher. From there, use the "Host", "User", "Password" and "DB" fields from buildbot-db.txt in the private releng repo like so:

cruncher$ mysql -u ${User} -h ${Host} -D {DB} -p -e "SELECT ..."

This will prompt you for the password, which you can now type in.

Statusdb

Statusdb is where buildbot stores all of the status information on jobs. Statusdb is defined here.

Overview

Here is a list of all the tables represented in Statusdb.

build_properties

build_requests

builder_slaves

builders

builds

changes

file_changes

files

master_slaves

masters

patches

properties

request_properties

requests

schedulerdb_requests

slaves

source_changes

sourcestamps

steps

Schemas for each Table

These are the schemas for each table in Statusdb.

Field	Type	Null	Key	Default	Extra
BUILD_PROPERTIES
property_id	int(11)	NO	MUL	NULL
build_id	int(11)	NO	MUL	NULL
BUILD_REQUESTS
build_id	int(11)	NO	MUL	NULL
request_id	int(11)	NO	MUL	NULL
BUILDER_SLAVES
id	int(11)	NO	PRI	NULL	auto_increment
builder_id	int(11)	NO	MUL	NULL
slave_id	int(11)	NO	MUL	NULL
added	datetime	NO	MUL	NULL
removed	datetime	YES	MUL	NULL
BUILDERS
id	int(11)	NO	PRI	NULL	auto_increment
name	varchar(200)	NO	MUL	NULL
master_id	int(11)	NO	MUL	NULL
category	varchar(30)	YES	MUL	NULL
BUILDS
id	int(11)	NO	PRI	NULL	auto_increment
buildnumber	int(11)	NO	MUL	NULL
builder_id	int(11)	NO	MUL	NULL
slave_id	int(11)	NO	MUL	NULL
master_id	int(11)	NO	MUL	NULL
starttime	datetime	YES	MUL	NULL
endtime	datetime	YES	MUL	NULL
result	int(11)	YES	MUL	NULL
reason	varchar(500)	YES		NULL
source_id	int(11)	YES	MUL	NULL
lost	tinyint(1)	NO		NULL
CHANGES
id	int(11)	NO	PRI	NULL	auto_increment
number	int(11)	NO		NULL
branch	varchar(50)	YES		NULL
revision	varchar(50)	YES		MUL
who	varchar(200)	YES	MUL	MUL
comments	text	YES		NULL
when	datetime	YES		NULL
FILE_CHANGES
file_id	int(11)	NO	MUL	NULL
change_id	int(11)	NO	MUL	NULL
FILES
id	int(11)	NO	PRI	NULL	auto_increment
path	varchar(400)	NO	MUL	NULL
MASTER_SLAVES
id	int(11)	NO	PRI	NULL	auto_increment
slave_id	int(11)	NO	MUL	NULL
master_id	int(11)	NO	MUL	NULL
connected	datetime	NO	MUL	NULL
disconnected	datetime	YES	MUL	NULL
MASTERS
id	int(11)	NO	PRI	NULL	auto_increment
url	varchar(100)	YES	UNI	NULL
name	varchar(100)	YES		NULL
PATCHES
id	int(11)	NO	PRI	NULL	auto_increment
patch	text	YES		NULL
patchlevel	int(11)	YES		NULL
PROPERTIES
id	int(11)	NO	PRI	NULL	auto_increment
name	varchar(40)	YES	MUL	NULL
source	varchar(40)	YES	MUL	NULL
value	text	YES		NULL
REQUEST_PROPERTIES
property_id	int(11)	NO	MUL	NULL
request_id	int(11)	NO	MUL	NULL
REQUESTS
id	int(11)	NO	PRI	NULL	auto_increment
submittime	datetime	YES	MUL	NULL
builder_id	int(11)	YES	MUL	NULL
startcount	int(11)	NO	MUL	NULL
source_id	int(11)	YES	MUL	NULL
lost	tinyint(1)	NO	MUL	NULL
cancelled	tinyint(1)	NO	MUL	NULL
SCHEDULERDB_REQUESTS
status_build_id	int(11)	NO	MUL	NULL
scheduler_request_id	int(11)	NO	MUL	NULL
scheduler_build_id	int(11)	NO	MUL	NULL
SLAVES
id	int(11)	NO	PRI	NULL	auto_increment
name	varchar(50)	NO	MUL	NULL
SOURCE_CHANGES
source_id	int(11)	NO	MUL	NULL
change_id	int(11)	NO	MUL	NULL
order	int(11)	NO		NULL
id	int(11)	NO	PRI	NULL	auto_increment
SOURCESTAMPS
id	int(11)	NO	PRI	NULL	auto_increment
branch	varchar(50)	YES		NULL
revision	varchar(50)	YES	MUL	NULL
patch_id	int(11)	YES	MUL	NULL
STEPS
id	int(11)	NO	PRI	NULL	auto_increment
name	varchar(256)	NO	MUL	NULL
description	text	YES		NULL
build_id	int(11)	NO	MUL	NULL
order	int(11)	NO		NULL
starttime	datetime	YES		NULL
endtime	datetime	YES		NULL
status	int(11)	YES	MUL	NULL

Schedulerdb

Schedulerdb is where buildbot stores all of the scheduling information for jobs. Schedulerdb is defined here.

Overview

Here is a list of all the tables represented in Schedulerdb.

buildrequests

builds

buildset_properties

buildsets

change_files

change_links

change_properties

changes

patches

scheduler_changes

scheduler_upstream_buildsets

schedulers

sourcestamp_changes

sourcestamps

version

Schemas for each Table

These are the schemas for each table in Schedulerdb.

Field	Type	Null	Key	Default	Extra
BUILDREQUESTS
id	int(11)	NO	PRI	NULL	auto_increment
buildsetid	int(11)	NO	MUL	NULL
buildername	varchar(256)	NO	MUL	NULL
priority	int(11)	NO		0
claimed_at	int(11)	YES	MUL	0
claimed_by_name	varchar(256)	YES	MUL	NULL
claimed_by_incarnation	varchar(256)	YES		NULL
complete	int(11)	YES	MUL	0
results	smallint(6)	YES		NULL
submitted_at	int(11)	NO		NULL
complete_at	int(11)	YES		NULL
BUILDS
id	int(11)	NO	PRI	NULL	auto_increment
number	int(11)	NO	MUL	NULL
brid	int(11)	NO	MUL	NULL
start_time	int(11)	NO	MUL	NULL
finish_time	int(11)	YES	MUL	NULL
BUILDSET_PROPERTIES
buildsetid	int(11)	NO	MUL	NULL
property_name	varchar(256)	NO		NULL
property_value	varchar(1024)	NO		NULL
BUILDSETS
id	int(11)	NO	PRI	NULL	auto_increment
external_idstring	varchar(256)	YES		NULL
reason	varchar(256)	YES		NULL
sourcestampid	int(11)	NO	MUL	NULL
submitted_at	int(11)	NO	MUL	NULL
complete	smallint(6)	NO	MUL	0
complete_at	int(11)	YES		NULL
results	smallint(6)	YES		NULL
CHANGE_FILES
changeid	int(11)	NO	MUL	NULL
filename	varchar(1024)	NO		NULL
CHANGE_LINKS
changeid	int(11)	NO	MUL	NULL
link	varchar(1024)	NO		NULL
CHANGE_PROPERTIES
changeid	int(11)	NO	MUL	NULL
property_name	varchar(256)	NO		NULL
property_value	varchar(1024)	NO		NULL
CHANGES
changeid	int(11)	NO	PRI	NULL	auto_increment
author	varchar(1024)	NO	MUL	NULL
comments	varchar(1024)	NO		NULL
is_dir	smallint(6)	NO		NULL
branch	varchar(1024)	YES	MUL	NULL
revision	varchar(256)	YES	MUL	NULL
revlink	varchar(256)	YES		NULL
when_timestamp	int(11)	NO	MUL	NULL
category	varchar(256)	YES	MUL	NULL
repository	text	NO		NULL
project	text	NO		NULL
PATCHES
id	int(11)	NO	PRI	NULL	auto_increment
patchlevel	int(11)	NO		NULL
patch_base64	text	NO		NULL
subdir	text	YES		NULL
SCHEDULER_CHANGES
schedulerid	int(11)	YES	MUL	NULL
changeid	int(11)	YES	MUL	NULL
important	smallint(6)	YES		NULL
SCHEDULER_UPSTREAM_BUILDSETS
buildsetid	int(11)	YES	MUL	NULL
schedulerid	int(11)	YES	MUL	NULL
active	smallint(6)	YES	MUL	NULL
SCHEDULERS
schedulerid	int(11)	NO	PRI	NULL	auto_increment
name	varchar(100)	NO	MUL	NULL
class_name	varchar(100)	NO		NULL
state	text	YES		NULL
SOURCESTAMP_CHANGES
sourcestampid	int(11)	NO	MUL	NULL
changeid	int(11)	NO	MUL	NULL
SOURCESTAMPS
id	int(11)	NO	PRI	NULL	auto_increment
branch	varchar(256)	YES	MUL	NULL
revision	vrachar(256)	YES	MUL	NULL
patchid	int(11)	YES		NULL
repository	text	NO		NULL
project	text	NO		NULL
VERSION
version	int(11)	NO		NULL