Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16960

create database for db that already exists hangs

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 5.5.56
    • N/A
    • Server
    • 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

      Attachments

        Activity

          People

            Unassigned Unassigned
            Mehuge Austin France
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.