[MDEV-16960] create database for db that already exists hangs Created: 2018-08-13  Updated: 2018-09-11  Resolved: 2018-09-11

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

Type: Bug Priority: Major
Reporter: Austin France Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback
Environment:

Linux (Centos 7)



 Description   

I have the following statement

echo 'create database bugs50;' | mysql

Ran first time, creates database. Ran a second time, it just hangs on the create database statement.

Workaround is to use

echo 'create database if not exists bugs50;' | mysql

The only slightly unusual setup I have is that my db directory is not under /var/lib

[mysqld]
datadir=/home/mariadb/mysql
socket=/home/mariadb/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd
max_allowed_packet=64M
 
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
 
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

I also have a symlink from /var/lib/mysql -> /home/mariadb/mysql



 Comments   
Comment by Elena Stepanova [ 2018-08-13 ]

Can you get a stack trace from the hanging process?

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