Note also that innodb supports indexes larger than that (up to 3072 bytes),
but they require a minimum version and specific configuration. It is very
picky (depends on vendor, version, config, table version and format,
character set, etc.). But here is some hopefully useful links to help with
the riddle (it is a very common confusing issue :-():
On Thu, Dec 8, 2022 at 7:17 PM Russell Blau <russblau(a)imapmail.org> wrote:
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(a)wikimedia.org>
> Sent: Thursday, December 8, 2022 11:07 AM
> To: Wikimedia Cloud Services general discussion and support
> <cloud(a)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(a)imapmail.org
> > _______________________________________________
> > Cloud mailing list -- cloud(a)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(a)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(a)lists.wikimedia.org
List information:
https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/
Attachments:
* signature.asc
--
Russell Blau
russblau(a)imapmail.org
_______________________________________________
Cloud mailing list -- cloud(a)lists.wikimedia.org
List information:
https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/