Resolved Maria DB update fail, autoupdate no longer works

[carini]

Server operating system version

Ubuntu 22.04.4 LTS

Plesk version and microupdate number

Plesk Obsidian v18.0.61_build1800240521.14

Autoupdate fail every time with warning mail:

Reason: 2024-05-27 06:26:06 INFO: pum is called with arguments: ['--list', '--repo-info', '--json']
2024-05-27 06:29:14 ERROR: Apt cache fetch failed. Try to run the `apt-get update` command.
2024-05-27 06:29:14 ERROR:
2024-05-27 06:29:14 ERROR: Exited with returncode 1.

Problem should be on Maria DB update source

root@plesk81:~# cat /etc/apt/sources.list.d/mariadb.list


# MariaDB Server
# To use a different major version of the server, or to pin to a specific minor version, change URI below.
deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/mariadb-server/10.11/repo/ubuntu jammy main
deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/mariadb-server/10.11/repo/ubuntu jammy main/debug

# MariaDB Tools
deb [arch=amd64] http://downloads.mariadb.com/Tools/ubuntu jammy main

Where https://dlm.mariadb.com/repo/mariadb-server/10.11/repo/ubuntu is no longer valid.

This is the second server with this problem, pure stock, no custom repos, freshly rebooted.

Anyone with the same problem? Is a Ubuntu-specific bug?

 

[Dave W]

Looks like the repo is outdated?
Current release is 11.x

 

[carini]

This repo was automatically installed by Plesk.

 

[marvv90]

Same Problem with Ubuntu 20.04 and Plesk Obsidian 18.0.60

 

[Kaspar@Plesk]

There seems to be an issue with the repositories on dlm.mariadb.com.

It best to replace the repositories in the mariadb.list with a mirror picked from here: https://mariadb.org/download/?t=repo-config

 

[carini]

Replaced: ...

root@plesk:/etc/apt/sources.list.d# diff /root/rollback/etc/apt/sources.list.d/mariadb.list_2024-05-27 ./mariadb.list
0a1
> # MariaDB 10.11 repository list - created 2024-05-27 12:49 UTC
2,7c3,7
< # MariaDB Server
< # To use a different major version of the server, or to pin to a specific minor version, change URI below.
< deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/mariadb-server/10.11/repo/ubuntu jammy main
<
< deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/mariadb-server/10.11/repo/ubuntu jammy main/debug
<
---
> # https://mariadb.org/download/
> # deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
> deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://deb.mariadb.org/10.11/ubuntu jammy main
> # deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main
> # deb-src [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main
10a11
>

New file is:

root@plesk:/etc/apt/sources.list.d# cat ./mariadb.list
# MariaDB 10.11 repository list - created 2024-05-27 12:49 UTC


# https://mariadb.org/download/
# deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://deb.mariadb.org/10.11/ubuntu jammy main
# deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main
# deb-src [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main


# MariaDB Tools
deb [arch=amd64] http://downloads.mariadb.com/Tools/ubuntu jammy main

We have to expect the same issue on all of our servers?

 

[marvv90]

Replaced: ...

root@plesk:/etc/apt/sources.list.d# diff /root/rollback/etc/apt/sources.list.d/mariadb.list_2024-05-27 ./mariadb.list
0a1
> # MariaDB 10.11 repository list - created 2024-05-27 12:49 UTC
2,7c3,7
< # MariaDB Server
< # To use a different major version of the server, or to pin to a specific minor version, change URI below.
< deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/mariadb-server/10.11/repo/ubuntu jammy main
<
< deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/mariadb-server/10.11/repo/ubuntu jammy main/debug
<
---
> # https://mariadb.org/download/
> # deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
> deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://deb.mariadb.org/10.11/ubuntu jammy main
> # deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main
> # deb-src [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main
10a11
>

New file is:

root@plesk:/etc/apt/sources.list.d# cat ./mariadb.list
# MariaDB 10.11 repository list - created 2024-05-27 12:49 UTC


# https://mariadb.org/download/
# deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://deb.mariadb.org/10.11/ubuntu jammy main
# deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main
# deb-src [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main


# MariaDB Tools
deb [arch=amd64] http://downloads.mariadb.com/Tools/ubuntu jammy main

We have to expect the same issue on all of our servers?

Sorry for the late Reply:

Attention Carini:

in my case I need the arch=amd64,arm64 property otherwise i receive the next error , receive after apt-get update !

 

[carini]

Thanks for your suggestion. Now reads

root@plesk81:~# cat /etc/apt/sources.list.d/mariadb.list
# MariaDB 10.11 repository list - created 2024-05-27 12:49 UTC

# https://mariadb.org/download/
# deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
deb [arch=amd64] https://deb.mariadb.org/10.11/ubuntu jammy main
# deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main
# deb-src [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main

# MariaDB Tools
deb [arch=amd64] http://downloads.mariadb.com/Tools/ubuntu jammy main

 

[marvv90]

Thanks for your suggestion. Now reads

root@plesk81:~# cat /etc/apt/sources.list.d/mariadb.list
# MariaDB 10.11 repository list - created 2024-05-27 12:49 UTC

# https://mariadb.org/download/
# deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
deb [arch=amd64] https://deb.mariadb.org/10.11/ubuntu jammy main
# deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main
# deb-src [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.mva-n.net/mariadb/repo/10.11/ubuntu jammy main

# MariaDB Tools
deb [arch=amd64] http://downloads.mariadb.com/Tools/ubuntu jammy main

Good Morning,

No you misunderstood me,

my mariadb.list

# MariaDB 10.11 repository list - created 2024-05-27 14:01 UTC
# https://mariadb.org/download/
# deb.mariadb.org is a dynamic mirror if your preferred mirror goes offline. See https://mariadb.org/mirrorbits/ for details.
# deb [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://deb.mariadb.org/10.11/ubuntu focal main
deb [arch=amd64,arm64 signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.digitalnova.at/mariadb/repo/10.11/ubuntu focal main
# deb-src [signed-by=/etc/apt/keyrings/mariadb-keyring.pgp] https://mirror.digitalnova.at/mariadb/repo/10.11/ubuntu focal main

# MariaDB MaxScale
# To use the latest stable release of MaxScale, use "latest" as the version
# To use the latest beta (or stable if no current beta) release of MaxScale, use "beta" as the version
deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/maxscale/latest/apt focal main

# MariaDB Tools
deb [arch=amd64] http://downloads.mariadb.com/Tools/ubuntu focal main

 

[carini]

Apart from MaxScale, which I am unsure if it is supported under Plesk, why include arm64?

The signed-by option also confuses me. I have noticed that some repositories are configured to use it, while others are not. It seems to be really necessary only if you are upgrading from third-party repositories.

 

[marvv90]

i hope it is supported , i copy paste MaxScale from my original mariadb.list

I think arm64 could be omitted, but it was in the original file, so I included it.

 

[Kaspar@Plesk]

We have to expect the same issue on all of our servers?

If your other server are using the same MaraiDB Repo I think it's best to change the Repo on there too

 

[carini]

Thanks a lot.

How can I marked this thread as "solved"?

 

[learning.neo]

Bonjour tout le monde,
nous avons exactement les mêmes erreurs
installation :
PLESK OBSIDIAN 18.0.61
DEBIAN 10.13

auriez vous une solution pour moi ? merci

voici mon fichier mariadb.list

[Courtesy translation by Admin]
Hello everyone,
we have exactly the same errors
installation:
PLESK OBSIDIAN 18.0.61
DEBIAN 10.13

would you have a solution for me? thank you

here is my mariadb.list file

# MariaDB Server
# To use a different major version of the server, or to pin to a specific minor version, change URI below.
deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/mariadb-server/10.6/repo/debian buster main


# MariaDB MaxScale
# To use the latest stable release of MaxScale, use "latest" as the version
# To use the latest beta (or stable if no current beta) release of MaxScale, use "beta" as the version
deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/maxscale/latest/apt buster main


# MariaDB Tools
deb [arch=amd64] Tools/debian/ - MariaDB buster main

 

[Kaspar@Plesk]

@learning.neo see Resolved - Maria DB update fail, autoupdate no longer works

 

[learning.neo]

Merci Kaspar,
mais est ce que je peux remplacer les éléments de mon mariadb.list par celui de Carini même si sur le mien il y a ..../10.6/repo/debian et pas ubuntu
?

[courtesy translation by Admin]
but can I replace the items in my mariadb.list with Carini's even though mine has ..../10.6/repo/debian and not ubuntu?

 

[Kaspar@Plesk]

@learning.neo the official forum language is English. Please use a translator like DeepL to translate posts before posting them. That way other users can read and react too.

[courtesy translation by Admin]
but can I replace the items in my mariadb.list with Carini's even though mine has ..../10.6/repo/debian and not ubuntu?

No. Use this link to get the right repositories for Ubuntu which you can use in your mariadb.list configration: Download MariaDB Server - MariaDB.org

 

[learning.neo]

Good morning

I did the test yesterday on one of our VPS by generating my configuration files from your link
and this morning no error message
Thank you again for your help
I will apply this to our 2 other VPS

Have a good day

 

[dgarcia90]

Hello everyone, I have an ubuntu 20.04 server and when I add the new repo I get an error sayting it can't be verified.

This is the content of the mariadb.list

# MariaDB Server
# To use a different major version of the server, or to pin to a specific minor version, change URI below.
#deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/mariadb-server/10.11/repo/ubuntu focal main
deb [arch=amd64,arm64, signed-by=/etc/apt/keyrings/mariadb-keyring.php] Index of /mariadb/repo/10.11/ubuntu focal main

#deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/mariadb-server/10.11/repo/ubuntu focal main/debug


# MariaDB Tools
deb [arch=amd64] http://downloads.mariadb.com/Tools/ubuntu focal main


This is the error when I run apt-get update

W: GPG error: Index of /mariadb/repo/10.11/ubuntu focal InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY F1656F24C74CD1D8
E: The repository 'Index of /mariadb/repo/10.11/ubuntu focal InRelease' is not signed.

I tried to add the key buy running this command

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys F1656F24C74CD1D8

But that did not fix the issue

Any idea?

Thanks in advance!

 

[dgarcia90]

Hello everyone, I have an ubuntu 20.04 server and when I add the new repo I get an error sayting it can't be verified.

This is the content of the mariadb.list

# MariaDB Server
# To use a different major version of the server, or to pin to a specific minor version, change URI below.
#deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/mariadb-server/10.11/repo/ubuntu focal main
deb [arch=amd64,arm64, signed-by=/etc/apt/keyrings/mariadb-keyring.php] Index of /mariadb/repo/10.11/ubuntu focal main

#deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/mariadb-server/10.11/repo/ubuntu focal main/debug


# MariaDB Tools
deb [arch=amd64] http://downloads.mariadb.com/Tools/ubuntu focal main


This is the error when I run apt-get update

W: GPG error: Index of /mariadb/repo/10.11/ubuntu focal InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY F1656F24C74CD1D8
E: The repository 'Index of /mariadb/repo/10.11/ubuntu focal InRelease' is not signed.

I tried to add the key buy running this command

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys F1656F24C74CD1D8

But that did not fix the issue

Any idea?

Thanks in advance!

Update: removing the "signed-by=/etc/apt/keyrings/mariadb-keyring.php" part fixed the issue for me