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 <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

--
  Russell Blau
  russblau@imapmail.org
_______________________________________________
Cloud mailing list -- cloud@lists.wikimedia.org
List information: https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/