[MDEV-17876] .local folder in /var/lib/mysql when upgrading from MariaDB 10.3.10 to MariaDB 10.3.11 Created: 2018-11-29  Updated: 2019-02-06  Resolved: 2019-02-06

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

Type: Bug Priority: Major
Reporter: Todd Henderson Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback
Environment:

Static hostname: mariadbserver.localdomain
Icon name: computer-vm
Chassis: vm
Machine ID: 06d11d3d034041cfbc83ee22e99bc32d
Boot ID: c9b91909dd6243cf89f1c61056946ccc
Virtualization: kvm
Operating System: CentOS Linux 7 (Core)
CPE OS Name: cpe:/o:centos:centos:7
Kernel: Linux 3.10.0-862.14.4.el7.x86_64
Architecture: x86-64

MariaDB 10.3.11

Attachments: JPEG File Comparison from MariaDB.JPG     JPEG File userhomedirectory.JPG     JPEG File varlibmysqldirectory1.JPG    

 Description   

The .local folder appears in /var/lib/mysql after running a yum update. This occurs when going from MariaDB 10.3.10 to MariaDB 10.3.11. The folder is in /var/lib/mysql and when running a SHOW DATABASE; it shows an instance name called #mysql50#.local. The location of the folder should be at the home directory not /var/lib/mysql. Please see attached screenshot. Please feel free to contact me for any questions.



 Comments   
Comment by Elena Stepanova [ 2018-12-07 ]

I tried both yum upgrade and yum update on Centos 73, I'm not getting the folder. I also couldn't so far find any indication in the code that such folder would be created.
thenderson4@ewu.edu, is it reproducible for you – that is, you install MariaDB 10.3.10, you don't have the folder, then you run yum update and right after it the folder is there?

serg, do you have any idea what might cause creation of the folder?

Comment by Todd Henderson [ 2018-12-07 ]

Hi Elena Stepanov, I was already running MariaDB 10.3.10 and used yum update in my virtual machine to upgrade to MariaDB 10.3.11. That is when the .local folder is added in /var/lib/mysql.

Comment by Elena Stepanova [ 2019-01-08 ]

I'm still not getting the folder either on yum upgrade or on yum update.

thenderson4@ewu.edu, did you check system logs for any hints on where it could appear from?
Could you please paste or attach your cnf file(s) the output of 

SELECT * FROM INFORMATION_SCHEMA.ALL_PLUGINS\G

and 

rpm -qa | grep -iE 'mysql|maria|percona|galera'

?

Generated at Thu Feb 08 08:39:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.