ReleaseEngineering/Buildbot Database Schemas

From MozillaWiki
Jump to: navigation, search

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_idint(11)NOMULNULL
build_idint(11)NOMULNULL
BUILD_REQUESTS
build_idint(11)NOMULNULL
request_idint(11)NOMULNULL
BUILDER_SLAVES
idint(11)NOPRINULLauto_increment
builder_idint(11)NOMULNULL
slave_idint(11)NOMULNULL
addeddatetimeNOMULNULL
removeddatetimeYESMULNULL
BUILDERS
idint(11)NOPRINULLauto_increment
namevarchar(200)NOMULNULL
master_idint(11)NOMULNULL
categoryvarchar(30)YESMULNULL
BUILDS
idint(11)NOPRINULLauto_increment
buildnumberint(11)NOMULNULL
builder_idint(11)NOMULNULL
slave_idint(11)NOMULNULL
master_idint(11)NOMULNULL
starttimedatetimeYESMULNULL
endtimedatetimeYESMULNULL
resultint(11)YESMULNULL
reasonvarchar(500)YESNULL
source_idint(11)YESMULNULL
losttinyint(1)NONULL
CHANGES
idint(11)NOPRINULLauto_increment
numberint(11)NONULL
branchvarchar(50)YESNULL
revisionvarchar(50)YESMUL
whovarchar(200)YESMULMUL
commentstextYESNULL
whendatetimeYESNULL
FILE_CHANGES
file_idint(11)NOMULNULL
change_idint(11)NOMULNULL
FILES
idint(11)NOPRINULLauto_increment
pathvarchar(400)NOMULNULL
MASTER_SLAVES
idint(11)NOPRINULLauto_increment
slave_idint(11)NOMULNULL
master_idint(11)NOMULNULL
connecteddatetimeNOMULNULL
disconnecteddatetimeYESMULNULL
MASTERS
idint(11)NOPRINULLauto_increment
urlvarchar(100)YESUNINULL
namevarchar(100)YESNULL
PATCHES
idint(11)NOPRINULLauto_increment
patchtextYESNULL
patchlevelint(11)YESNULL
PROPERTIES
idint(11)NOPRINULLauto_increment
namevarchar(40)YESMULNULL
sourcevarchar(40)YESMULNULL
valuetextYESNULL
REQUEST_PROPERTIES
property_idint(11)NOMULNULL
request_idint(11)NOMULNULL
REQUESTS
idint(11)NOPRINULLauto_increment
submittimedatetimeYESMULNULL
builder_idint(11)YESMULNULL
startcountint(11)NOMULNULL
source_idint(11)YESMULNULL
losttinyint(1)NOMULNULL
cancelledtinyint(1)NOMULNULL
SCHEDULERDB_REQUESTS
status_build_idint(11)NOMULNULL
scheduler_request_idint(11)NOMULNULL
scheduler_build_idint(11)NOMULNULL
SLAVES
idint(11)NOPRINULLauto_increment
namevarchar(50)NOMULNULL
SOURCE_CHANGES
source_idint(11)NOMULNULL
change_idint(11)NOMULNULL
orderint(11)NONULL
idint(11)NOPRINULLauto_increment
SOURCESTAMPS
idint(11)NOPRINULLauto_increment
branchvarchar(50)YESNULL
revisionvarchar(50)YESMULNULL
patch_idint(11)YESMULNULL
STEPS
idint(11)NOPRINULLauto_increment
namevarchar(256)NOMULNULL
descriptiontextYESNULL
build_idint(11)NOMULNULL
orderint(11)NONULL
starttimedatetimeYESNULL
endtimedatetimeYESNULL
statusint(11)YESMULNULL

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
idint(11)NOPRINULLauto_increment
buildsetidint(11)NOMULNULL
buildernamevarchar(256)NOMULNULL
priorityint(11)NO0
claimed_atint(11)YESMUL0
claimed_by_namevarchar(256)YESMULNULL
claimed_by_incarnationvarchar(256)YESNULL
completeint(11)YESMUL0
resultssmallint(6)YESNULL
submitted_atint(11)NONULL
complete_atint(11)YESNULL
BUILDS
idint(11)NOPRINULLauto_increment
numberint(11)NOMULNULL
bridint(11)NOMULNULL
start_timeint(11)NOMULNULL
finish_timeint(11)YESMULNULL
BUILDSET_PROPERTIES
buildsetidint(11)NOMULNULL
property_namevarchar(256)NONULL
property_valuevarchar(1024)NONULL
BUILDSETS
idint(11)NOPRINULLauto_increment
external_idstringvarchar(256)YESNULL
reasonvarchar(256)YESNULL
sourcestampidint(11)NOMULNULL
submitted_atint(11)NOMULNULL
completesmallint(6)NOMUL0
complete_atint(11)YESNULL
resultssmallint(6)YESNULL
CHANGE_FILES
changeidint(11)NOMULNULL
filenamevarchar(1024)NONULL
CHANGE_LINKS
changeidint(11)NOMULNULL
linkvarchar(1024)NONULL
CHANGE_PROPERTIES
changeidint(11)NOMULNULL
property_namevarchar(256)NONULL
property_valuevarchar(1024)NONULL
CHANGES
changeidint(11)NOPRINULLauto_increment
authorvarchar(1024)NOMULNULL
commentsvarchar(1024)NONULL
is_dirsmallint(6)NONULL
branchvarchar(1024)YESMULNULL
revisionvarchar(256)YESMULNULL
revlinkvarchar(256)YESNULL
when_timestampint(11)NOMULNULL
categoryvarchar(256)YESMULNULL
repositorytextNONULL
projecttextNONULL
PATCHES
idint(11)NOPRINULLauto_increment
patchlevelint(11)NONULL
patch_base64textNONULL
subdirtextYESNULL
SCHEDULER_CHANGES
scheduleridint(11)YESMULNULL
changeidint(11)YESMULNULL
importantsmallint(6)YESNULL
SCHEDULER_UPSTREAM_BUILDSETS
buildsetidint(11)YESMULNULL
scheduleridint(11)YESMULNULL
activesmallint(6)YESMULNULL
SCHEDULERS
scheduleridint(11)NOPRINULLauto_increment
namevarchar(100)NOMULNULL
class_namevarchar(100)NONULL
statetextYESNULL
SOURCESTAMP_CHANGES
sourcestampidint(11)NOMULNULL
changeidint(11)NOMULNULL
SOURCESTAMPS
idint(11)NOPRINULLauto_increment
branchvarchar(256)YESMULNULL
revisionvrachar(256)YESMULNULL
patchidint(11)YESNULL
repositorytextNONULL
projecttextNONULL
VERSION
versionint(11)NONULL