Closed Bug 722886 Opened 12 years ago Closed 12 years ago

Create runs_logs db table for tbpl

Categories

(Data & BI Services Team :: DB: MySQL, task)

x86
Linux
task
Not set
normal

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: Swatinem, Unassigned)

References

Details

Bug 717005 needs the following new mysql table. I would like it to be present in both staging and production before I push the new log handling to the repo (and that gets auto-pulled to staging)

CREATE TABLE IF NOT EXISTS `runs_logs` (
		`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
		`buildbot_id` integer NOT NULL,
		`type` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
		`content` longblob,
		UNIQUE INDEX runs_logs_buildbot_id_type_idx (buildbot_id, type),
		FOREIGN KEY (buildbot_id) REFERENCES runs(buildbot_id) ON DELETE CASCADE
		) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Assignee: server-ops → server-ops-database
Component: Server Operations: Web Operations → Server Operations: Database
I'd be happy to do that for you, except that I don't have any info on where that db lives.  The docs live at:

https://mana.mozilla.org/wiki/display/websites/tbpl.mozilla.org 

which points to 

https://wiki.mozilla.org/TbplWebsiteDoc#Database

which says that it's MongoDB.  

Whatever you can give me about dev/stage/production databases would help, even if it's something like "production is on tbpl-rw.mozilla.com".  I can work my way to the machine from a VIP.

FWIW, looks like https://wiki.mozilla.org/Tinderboxpushlog/ArchitectureAndDependencies needs to be updated too.
Honestly, I have no idea where the db lives. The production server (php) lives on the generic cluster, thats as much as I know.
Actually that's exactly the right info -- there's a tbpl_mozilla_org database in the generic cluster, and I've run the create table on that.  That's the production db, so I have to figure out where the stage db is, but it'll be soon.
Status: NEW → ASSIGNED
Found the dev/stage database (on dev1.db) - and ran the query to create the table.  You should be all set with this db on stage and production, please re-open if that's not the case.
Status: ASSIGNED → RESOLVED
Closed: 12 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.