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 2992You 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 dcaro@wikimedia.org Sent: Thursday, December 8, 2022 11:07 AM To: Wikimedia Cloud Services general discussion and support cloud@lists.wikimedia.org 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 russblau@imapmail.org _______________________________________________ Cloud mailing list -- cloud@lists.wikimedia.org 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 -- cloud@lists.wikimedia.org 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 -- cloud@lists.wikimedia.org List information: https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/
Attachments:
- signature.asc