Sorry; it is the database 's51290__dpl_p' on tools.db.svc.wikimedia.cloud. And I realize since my initial message that a VARCHAR() can be more than one byte per character, so perhaps the key may not be less than 767 bytes after all; but the job never threw this error before today.
On Thu, Dec 8, 2022, at 11:32 AM, David Caro wrote: > Toolsdb is a service that has many databases: > > ``` > $ ssh login.toolforge.org > > dcaro@tools-sgebastion-10:~$ mysql --defaults-file=$HOME/replica.my.cnf > -h tools.db.svc.wikimedia.cloud > > dcaro@tools-sgebastion-10:~$ mysql --defaults-file=$HOME/replica.my.cnf > -h tools.db.svc.wikimedia.cloud <<< "show databases;" | wc > 150 150 2992 > ``` > > You had to create your own at some point (see > https://wikitech.wikimedia.org/wiki/Help:Toolforge/Database#User_databases). > > You can check the database you are connected to with the query: > ``` > select DATABASE(); > ``` > > > On 12/08 11:11, Russell Blau wrote: >> As it says in the subject line, it is toolsdb. >> __________________________________________________________________ >> >> From: David Caro <[email protected]> >> Sent: Thursday, December 8, 2022 11:07 AM >> To: Wikimedia Cloud Services general discussion and support >> <[email protected]> >> Subject: [Cloud] Re: Key errors on toolsdb database >> >> What database are you using? >> On 12/08 08:59, Russell Blau wrote: >> > This morning I'm getting a bunch of errors that look like the >> following: >> > >> > ERROR: CREATE TABLE IF NOT EXISTS admin_list ( admin varchar(255) >> binary NOT NULL default '', PRIMARY KEY (admin) ) ENGINE=InnoDB >> ROW_FORMAT=DYNAMIC: Specified key was too long; max key length is 767 >> bytes >> > >> > I don't know whether this might be related to yesterday's database >> outage. I also don't understand the error message, since the primary >> key clearly is 255 bytes, which is less than 767. >> > >> > -- >> > Russell Blau >> > [email protected] >> > _______________________________________________ >> > Cloud mailing list -- [email protected] >> > List information: >> https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/ >> -- >> David Caro >> SRE - Cloud Services >> Wikimedia Foundation <https://wikimediafoundation.org/> >> PGP Signature: 7180 83A2 AC8B 314F B4CE 1171 4071 C7E1 D262 69C3 >> "Imagine a world in which every single human being can freely share in >> the >> sum of all knowledge. That's our commitment." > >> _______________________________________________ >> Cloud mailing list -- [email protected] >> List information: >> https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/ > > > -- > David Caro > SRE - Cloud Services > Wikimedia Foundation <https://wikimediafoundation.org/> > PGP Signature: 7180 83A2 AC8B 314F B4CE 1171 4071 C7E1 D262 69C3 > > "Imagine a world in which every single human being can freely share in the > sum of all knowledge. That's our commitment." > > _______________________________________________ > Cloud mailing list -- [email protected] > List information: > https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/ > > Attachments: > * signature.asc -- Russell Blau [email protected] _______________________________________________ Cloud mailing list -- [email protected] List information: https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/
