[MDEV-9830] Plugins unable to load with sql_mode PAD_CHAR_TO_FULL_LENGTH Created: 2016-03-30  Updated: 2016-04-28  Resolved: 2016-04-28

Status: Closed
Project: MariaDB Server
Component/s: Plugins
Affects Version/s: 10.1.12
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Ole Dalgaard Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback
Environment:

RHEL 7.2

Issue Links:
Relates
relates to MDEV-9524 Cannot load from mysql.event when sql... Closed

 Description   

With sql_mode='PAD_CHAR_TO_FULL_LENGTH' mariadb is unable to load plugins at startup. The log says:

2016-03-29  9:37:32 140393308063872 [ERROR] Can't open shared library 'mysqldamlevlim.so                                                                                                               ' (errno: 0, /usr/lib64/mysql/plugin/mysqldamlevlim.so                                                                                       )

Notice the spaces after the lib filename. Making a filesystem link with a lot of spaces to the real filename makes it unable to find the symbol.

 Comments   
Comment by Elena Stepanova [ 2016-03-30 ]

odlg,
How old is your database, and when was the last time you ran mysql_upgrade? Could you please paste the output of show create mysql.plugin table and attach the error log?

Unlike mysql.event from MDEV-9524 which still has CHAR columns, mysql.plugin has VARCHAR since 5.5, so it's supposed to be immune to PAD_CHAR_TO_FULL_LENGTH mode.

Comment by Elena Stepanova [ 2016-04-28 ]

Please comment to re-open if you have further information on the issue.

Generated at Thu Feb 08 07:37:38 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.