You are not logged in.

#1 2015-09-12 12:28:47

BBT
Member
From: Ghent
Registered: 2011-10-27
Posts: 11
Website

[SOLVED] MySQL (MariaDB) and jemalloc issues

Hello, I'm not 100% sure if I should be posting this here or on the package pages itself, so I'm sorry if I picked wrong.

Involved packages: https://www.archlinux.org/packages/extr … /jemalloc/ and https://www.archlinux.org/packages/extr … 4/mariadb/

Recently Jemalloc was upgraded from 3.x to 4.x, and one difference is that usr/lib/libjemalloc.so.2 is provided by 4.x (which wasn't for 3.x) and usr/lib/libjemalloc.so.1 vice versa.

In combination with Mariadb this leads to issues, mysqld needs the .1 library, so it depends on jemalloc 3.x, while mysql (the cli client) wants libjemalloc.so.2. This is happening in mariadb 10.0.21-2.

Does anyone have a workaround? It's not terribly critical at the moment - I can get by with a web-based administration tool, but it's a bit annoying nonetheless, for example it prevents my from executing

mysql_upgrade

edit: nevermind, oversaw new version of mariadb-clients. I'm an idiot

Last edited by BBT (2015-09-12 12:33:26)

Offline

#2 2015-09-12 13:24:08

WorMzy
Forum Moderator
From: Scotland
Registered: 2010-06-16
Posts: 11,901
Website

Re: [SOLVED] MySQL (MariaDB) and jemalloc issues

BBT wrote:

Hello, I'm not 100% sure if I should be posting this here or on the package pages itself, so I'm sorry if I picked wrong.

Involved packages: https://www.archlinux.org/packages/extr … /jemalloc/ and https://www.archlinux.org/packages/extr … 4/mariadb/

Recently Jemalloc was upgraded from 3.x to 4.x, and one difference is that usr/lib/libjemalloc.so.2 is provided by 4.x (which wasn't for 3.x) and usr/lib/libjemalloc.so.1 vice versa.

In combination with Mariadb this leads to issues, mysqld needs the .1 library, so it depends on jemalloc 3.x, while mysql (the cli client) wants libjemalloc.so.2. This is happening in mariadb 10.0.21-2.

Does anyone have a workaround? It's not terribly critical at the moment - I can get by with a web-based administration tool, but it's a bit annoying nonetheless, for example it prevents my from executing

mysql_upgrade

edit: nevermind, oversaw new version of mariadb-clients. I'm an idiot

Are you running partial updates? If so, stop doing that.

If you did a full system update, and had .so problems, try another mirror, yours might not be fully synced. If you still have the problem after fully updating your system using an up-to-date mirror, then open a bug report.

Mod note: Moving to Newbie Corner.


Sakura:-
Mobo: MSI MAG X570S TORPEDO MAX // Processor: AMD Ryzen 9 5950X @4.9GHz // GFX: AMD Radeon RX 5700 XT // RAM: 32GB (4x 8GB) Corsair DDR4 (@ 3000MHz) // Storage: 1x 3TB HDD, 6x 1TB SSD, 2x 120GB SSD, 1x 275GB M2 SSD

Making lemonade from lemons since 2015.

Offline

#3 2015-09-12 16:56:42

BBT
Member
From: Ghent
Registered: 2011-10-27
Posts: 11
Website

Re: [SOLVED] MySQL (MariaDB) and jemalloc issues

Yes and no, I was having issues with the limit of open_file_descriptors in mariadb and eventually reinstalled mariadb. Since I only touched that I figured that in this case a 'partial' update would help, but didn't take into account that the client was in a different package. I was getting frustrated with the initial issue while I had to get some work done, usually I just do it the way it's supposed to be done. Hence the 'I'm an idiot' in the edit of the original post wink

It was a 100% my own stupidity and solved already by using my head smile

Offline

Board footer

Powered by FluxBB