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.
Schemas for each Table
These are the schemas for each table in Statusdb.
property_id | int(11) | NO | MUL | NULL | |
build_id | int(11) | NO | MUL | NULL | |
build_id | int(11) | NO | MUL | NULL | |
request_id | int(11) | NO | MUL | NULL | |
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 | |
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 | |
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 | ||
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_id | int(11) | NO | MUL | NULL | |
change_id | int(11) | NO | MUL | NULL | |
id | int(11) | NO | PRI | NULL | auto_increment |
path | varchar(400) | NO | MUL | NULL | |
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 | |
id | int(11) | NO | PRI | NULL | auto_increment |
url | varchar(100) | YES | UNI | NULL | |
name | varchar(100) | YES | NULL | ||
id | int(11) | NO | PRI | NULL | auto_increment |
patch | text | YES | NULL | ||
patchlevel | int(11) | YES | NULL | ||
id | int(11) | NO | PRI | NULL | auto_increment |
name | varchar(40) | YES | MUL | NULL | |
source | varchar(40) | YES | MUL | NULL | |
value | text | YES | NULL | ||
property_id | int(11) | NO | MUL | NULL | |
request_id | int(11) | NO | MUL | NULL | |
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 | |
status_build_id | int(11) | NO | MUL | NULL | |
scheduler_request_id | int(11) | NO | MUL | NULL | |
scheduler_build_id | int(11) | NO | MUL | NULL | |
id | int(11) | NO | PRI | NULL | auto_increment |
name | varchar(50) | NO | MUL | NULL | |
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 |
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 | |
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.
Schemas for each Table
These are the schemas for each table in Schedulerdb.
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 | ||
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 | |
buildsetid | int(11) | NO | MUL | NULL | |
property_name | varchar(256) | NO | NULL | ||
property_value | varchar(1024) | NO | NULL | ||
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 | ||
changeid | int(11) | NO | MUL | NULL | |
filename | varchar(1024) | NO | NULL | ||
changeid | int(11) | NO | MUL | NULL | |
link | varchar(1024) | NO | NULL | ||
changeid | int(11) | NO | MUL | NULL | |
property_name | varchar(256) | NO | NULL | ||
property_value | varchar(1024) | NO | NULL | ||
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 | ||
id | int(11) | NO | PRI | NULL | auto_increment |
patchlevel | int(11) | NO | NULL | ||
patch_base64 | text | NO | NULL | ||
subdir | text | YES | NULL | ||
schedulerid | int(11) | YES | MUL | NULL | |
changeid | int(11) | YES | MUL | NULL | |
important | smallint(6) | YES | NULL | ||
buildsetid | int(11) | YES | MUL | NULL | |
schedulerid | int(11) | YES | MUL | NULL | |
active | smallint(6) | YES | MUL | NULL | |
schedulerid | int(11) | NO | PRI | NULL | auto_increment |
name | varchar(100) | NO | MUL | NULL | |
class_name | varchar(100) | NO | NULL | ||
state | text | YES | NULL | ||
sourcestampid | int(11) | NO | MUL | NULL | |
changeid | int(11) | NO | MUL | NULL | |
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 | int(11) | NO | NULL |