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."
signature.asc
Description: PGP signature
_______________________________________________ Cloud mailing list -- [email protected] List information: https://lists.wikimedia.org/postorius/lists/cloud.lists.wikimedia.org/
