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

Assertion failure in mysql_install_db



    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.2
    • 10.2.3
    • Server
    • None
    • Linux, gcc


      server-id               = 1
      log_bin                 = /tmp/mysql-bin.log

      Run like this:
      mysql_install_db --basedir=/path2 --datadir=/path1 --defaults-file=./mysqld.cnf

      Installing MariaDB/MySQL system tables in './data' ...
      2016-12-09 13:19:45 139923804589760 [Warning] InnoDB: New log files created, LSN=45892
      2016-12-09 13:19:45 139923804589760 [Warning] InnoDB: Creating foreign key constraint system tables.
      2016-12-09 13:19:46 139923028783872 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
      ERROR: 1105  Bootstrap file error, return code (0). Nearest query: 'CREATE DEFINER=`root`@`localhost` PROCEDURE AddGeometryColumn(catalog varchar(64), t_schema varchar(64),
         t_name varchar(64), geometry_column varchar(64), t_srid int)
        set @qwe= concat('ALTER TABLE ', t_schema, '.', t_name, ' ADD ', geometry_column,' GEOMETRY REF_SYSTEM_ID=', t_srid); PREPARE ls from @qwe; execute ls; deallocate prepare ls; end~~
      CREATE DEFINER=`root`@`localhost` PROCEDURE DropGeometryColumn(catalog varchar(64), t_schema varch
      mysqld: /home/kevg/work/mariadb_10.2/sql/sql_parse.cc:1098: void do_handle_bootstrap(THD *): Assertion `!opt_bootstrap || thread_count == 0' failed.
      161209 13:19:49 [ERROR] mysqld got signal 6 ;
      This could be because you hit a bug. It is also possible that this binary
      or one of the libraries it was linked against is corrupt, improperly built,
      or misconfigured. This error can also be caused by malfunctioning hardware.
      To report this bug, see https://mariadb.com/kb/en/reporting-bugs
      We will try our best to scrape up some info that will hopefully help
      diagnose the problem, but since we have already crashed, 
      something is definitely wrong and this may fail.
      Server version: 10.2.2-MariaDB-debug-log
      It is possible that mysqld could use up to 
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467292 K  bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.
      Thread pointer: 0x0x0
      Attempting backtrace. You can use the following information to find out
      where mysqld died. If you see no messages after this, something went
      terribly wrong...
      stack_bottom = 0x0 thread_stack 0x48c00
      The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
      information that should help you find out what is causing the crash.
      Installation of system tables failed!  Examine the logs in
      ./data for more information.
      The problem could be conflicting information in an external
      my.cnf files. You can ignore these by doing:
          shell> /home/kevg/work/mariadb_10.2/scripts/scripts/mysql_install_db --defaults-file=~/.my.cnf
      You can also try to start the mysqld daemon with:
          shell> /home/kevg/work/debug/sql/mysqld --skip-grant --general-log &
      and use the command line tool /home/kevg/work/debug/client/mysql
      to connect to the mysql database and look at the grant tables:
          shell> /home/kevg/work/debug/client/mysql -u root mysql
          mysql> show tables;
      Try 'mysqld --help' if you have problems with paths.  Using
      --general-log gives you a log in ./data that may be helpful.
      The latest information about mysql_install_db is available at
      MariaDB is hosted on launchpad; You can find the latest source and
      email lists at http://launchpad.net/maria
      Please check all of the above before submitting a bug report
      at http://mariadb.org/jira


        Issue Links



              serg Sergei Golubchik
              kevg Eugene Kosov (Inactive)
              0 Vote for this issue
              2 Start watching this issue



                Git Integration

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