Bug 14619

Summary: Mariadb shows errors in the log.
Product: Mageia Reporter: Thomas Spuhler <thomas>
Component: RPM PackagesAssignee: AL13N <alien>
Status: RESOLVED FIXED QA Contact:
Severity: minor    
Priority: Normal CC: bittwister2, ennael1, mageia, oe
Version: Cauldron   
Target Milestone: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Source RPM: mariadb-10.0.14-3.mga5 CVE:
Status comment:

Description Thomas Spuhler 2014-11-20 18:34:19 CET
Description of problem:
I have a problem logging into roundcubemail. There is no good error in the logs, but it it kind of suggest that mariadb could be the problem. Also mysql-workbench cannot connect to it either.
When looking at the logs (on 2 different cauldron boxes, I see these errors
141120 10:15:47 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.20-68.0 started; log sequence number 1616747
141120 10:15:48 [ERROR] Can't find symbol '_mysql_plugin_interface_version_' in library
141120 10:15:48 [ERROR] Couldn't load plugins from 'dialog.so'.
141120 10:15:48 [ERROR] Can't find symbol '_mysql_plugin_interface_version_' in library
141120 10:15:48 [ERROR] Couldn't load plugins from 'mysql_clear_password.so'.
handlersocket: initialized

Version-Release number of selected component (if applicable):

mariadb-10.0.14-3.mga5

How reproducible:
 Every time when started or restarted

Steps to Reproduce:
1.systemctl start mysqld
2.look at /var/log/mysqld/mysqld.log


Reproducible: 

Steps to Reproduce:
David Walser 2014-11-20 19:55:11 CET

CC: (none) => oe
Assignee: bugsquad => alien

Comment 1 AL13N 2014-11-21 01:01:37 CET
perhaps something went wrong during mass rebuild and it needs a rebuild... i don't know for sure...

can you try rebuilding it locally and test it?

mysql-workbench is often using network connection by default instead of socket... so that's probably misconfig.

it looks like something is wrong with the basic plugin structure, so it suggests that all plugins aren't loaded...

i assume "mysql" cli works? or does that give any error?

is mysqld actually started and does it run? or doesn't it even have a socket?
Comment 2 Thomas Spuhler 2014-11-21 01:38:36 CET
mariadb is actually on David Walser's list for upgrading.
Why not do that first and see if it resolves the issue?
Comment 3 AL13N 2014-11-21 07:53:45 CET
where's this list?
Comment 4 Thomas Spuhler 2014-11-21 15:17:48 CET
It was posted on the dev mailing list.
[dev] new software versions since...the last time I checked


mariadb                        10.0.14              10.1.1               Cooker
Comment 5 David Walser 2014-11-21 22:41:37 CET
Full list is here:
https://ml.mageia.org/l/arc/dev/2014-11/msg00643.html

Horribly mangled by the awful sympa web interface as usual.

Here's the git log for the Cooker mariadb package:
https://abf.rosalinux.ru/openmandriva/mariadb/commits/master
Comment 6 Thomas Spuhler 2014-11-21 23:25:42 CET
I did rebuild it locally and installed it. It's not usable anymore with hundreds of errors in the logs. Files are at (I believe) wrong path.
This may need a lot more work.
Comment 7 Thomas Spuhler 2014-11-21 23:26:20 CET
(In reply to AL13N from comment #3)
> where's this list?

I checked it our, it's only alpha.
Comment 8 AL13N 2014-11-22 08:10:20 CET
ah yes, i hadn't noticed before, but 10.1 is a different major branch... we won't do that...
Comment 9 AL13N 2014-11-22 08:14:25 CET
10.0.14 is the latest one...

@thomas: tbh: i think there's something wrong with your machine...

the tests which should be run by the packager, should've seen the issues...

i don't have a cauldron near, but i'll see if i can do a virtual one to test this on. i assume it's x68_64?
Comment 10 AL13N 2014-11-22 08:15:09 CET
btw: i assume you already did 'rpm -V' ?
Comment 11 Thomas Spuhler 2014-11-22 16:27:15 CET
yep, no output.
And the problem is on two boxes, one (VBOX)  I did a lot of fiddling, so I would understand if it doesn't work.
The other one is a normal always upgraded box on hardware. Not much fiddling except building packages (much faster than a VBOX).
I can go back a few versions on the vbox.
Comment 12 Thomas Spuhler 2014-11-23 18:55:39 CET
I went back to a mga4 snapshot taken after upgrading from mga3 and the whole kolab mailsystem installed and working. No errors in the mysql logs.

I then did all upgrades in mga4 and still not errors. 

I then did an upgrade to cauldron, urpmi set to always verify.

Restart mysqld and now I have all the errors in the log. I don't think I need to run upgrade the DB, do I?

What are you seeing? I am sure your worked on this too.

Priority: Normal => release_blocker

Comment 13 Thomas Spuhler 2014-11-25 17:19:31 CET
The mariadbs were just rebuilt for other reasons and the bugs are still showing.

Status: NEW => ASSIGNED

Comment 14 Bit Twister 2014-11-26 21:35:59 CET
(In reply to Thomas Spuhler from comment #13)
> The mariadbs were just rebuilt for other reasons and the bugs are still
> showing.

I will confirm the plugin errors on both of my clean install beta1 64 bit systems with all updates applied.
# mysqld --version
mysqld  Ver 10.0.14-MariaDB for Linux on x86_64 (Mageia MariaDB Server)

none on
# cat /etc/release
Mageia release 4 (Official) for x86_64

#  mysqld --version
mysqld  Ver 5.5.40-MariaDB for Linux on x86_64 (Mageia MariaDB Server)

CC: (none) => junknospam

Comment 15 Thomas Spuhler 2014-11-28 18:04:54 CET
Unfortunately these errors are still in the logs after today's unpgrade:
141128 10:01:44 [ERROR] Can't find symbol '_mysql_plugin_interface_version_' in library
141128 10:01:44 [ERROR] Couldn't load plugins from 'dialog.so'.
141128 10:01:44 [ERROR] Can't find symbol '_mysql_plugin_interface_version_' in library
141128 10:01:44 [ERROR] Couldn't load plugins from 'mysql_clear_password.so'.
# mysqld --version
mysqld  Ver 10.0.15-MariaDB for Linux on x86_64 (Mageia MariaDB Server)
Comment 16 Anne Nicolas 2014-12-15 00:22:31 CET
Any update on that bug ?

CC: (none) => ennael1

Comment 17 AL13N 2014-12-15 11:50:26 CET
i'll try to reproduce tonight...
Comment 18 AL13N 2014-12-19 19:31:22 CET
it looks like only 2 plugins are wrongly built... but i can't find anything mageia specific regarding them... i suspect they are less important plugins. in any case, the server seems to work fine and a number of plugins are loaded...

whatever this bug, it doesn't seem that important, and it will not be any cause for issues regarding logins, unless you specifically need to login without password (but then you could use auth_pam anyway)...
AL13N 2014-12-19 19:31:49 CET

Severity: critical => minor
Priority: release_blocker => Normal

Comment 19 AL13N 2014-12-22 14:41:45 CET
ok, no, from upstream:

dialog and mysql_clear_password are actually client libraries and aren't supposed to be loaded (the client will load them on-demand).

however, since the client plugins are in the same directory, the plugin_dir needs to be in common...

I commited some changes to do this, but it's a bit extensive changes... it would be great if previous packagers could check this out before i put this on cauldron.

@blino, @oden: could you check this out and give opinion?
AL13N 2014-12-22 14:42:10 CET

CC: (none) => mageia

Comment 20 Thomas Spuhler 2014-12-30 20:27:41 CET
The errors are gone. So shall we close it as resolved?
Comment 21 Bit Twister 2014-12-30 21:05:36 CET
(In reply to Thomas Spuhler from comment #20)
> The errors are gone. So shall we close it as resolved?

Only if they are gone on both 32 and 64 bit.
I'll confirm they are gone on 64 bit installs.
Comment 22 AL13N 2014-12-30 22:28:15 CET
well, i ended up committing and pushing it... it worked for me, so it's probably resolved.
Comment 23 Thomas Spuhler 2015-01-10 18:17:12 CET
They are gonne in i586 as well

Status: ASSIGNED => RESOLVED
Resolution: (none) => FIXED