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

[bb-10.0-monty] Server crashes in my_hash_insert / Master_info_index::add_master_info / change_master upon shutdown

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Incomplete
    • N/A
    • N/A
    • Replication
    • None

    Description

      bb-10.0-monty f5a696b150df5

      #3  <signal handler called>
      #4  0x00000000013b5ec0 in my_hash_insert (info=0x7f9d82c14da0, record=0x7f9d58c27000 "02\262\001") at /data/src/bb-10.0-monty/mysys/hash.c:491
      #5  0x000000000088f633 in Master_info_index::add_master_info (this=0x7f9d82c14a00, mi=0x7f9d58c27000, write_to_file=true) at /data/src/bb-10.0-monty/sql/rpl_mi.cc:1259
      #6  0x000000000071d310 in change_master (thd=0x7f9d6ac3b070, mi=0x7f9d58c27000, master_info_added=0x7f9d8377135f) at /data/src/bb-10.0-monty/sql/sql_repl.cc:3345
      #7  0x00000000006cdb98 in mysql_execute_command (thd=0x7f9d6ac3b070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:2734
      #8  0x00000000006dea8e in mysql_parse (thd=0x7f9d6ac3b070, rawbuf=0x7f9d58c22088 "CHANGE MASTER 'test1' TO MASTER_HOST='127.0.0.1', MASTER_PORT=3333, MASTER_USER='foo' /* QNO 863177 CON_ID 8 */", length=111, parser_state=0x7f9d837716a0) at /data/src/bb-10.0-monty/sql/sql_parse.cc:6580
      #9  0x00000000006c8170 in dispatch_command (command=COM_QUERY, thd=0x7f9d6ac3b070, packet=0x7f9d6ac41071 "CHANGE MASTER 'test1' TO MASTER_HOST='127.0.0.1', MASTER_PORT=3333, MASTER_USER='foo' /* QNO 863177 CON_ID 8 */ ", packet_length=112) at /data/src/bb-10.0-monty/sql/sql_parse.cc:1309
      #10 0x00000000006c6b61 in do_command (thd=0x7f9d6ac3b070) at /data/src/bb-10.0-monty/sql/sql_parse.cc:999
      #11 0x000000000089c621 in do_handle_one_connection (thd_arg=0x7f9d6ac3b070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1377
      #12 0x000000000089c173 in handle_one_connection (arg=0x7f9d6ac3b070) at /data/src/bb-10.0-monty/sql/sql_connect.cc:1292
      #13 0x00007f9d856a30a4 in start_thread (arg=0x7f9d83772700) at pthread_create.c:309
      #14 0x00007f9d8385b87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      Version: '10.0.30-MariaDB-debug'  socket: '/data/logs/analyze80_slave/mysql.sock'  port: 19302  Source distribution
      170205 20:27:36 [Note] Master 'test1': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log './mysql-relay-bin-test1.00003
      0' position: 4
      170205 20:27:36 [ERROR] Master 'test1': Slave I/O: error connecting to master 'foo@127.0.0.1:3333' - retry-time: 60  retries: 86400  message: Can't connect to M
      ySQL server on '127.0.0.1' (111 "Connection refused"), Internal MariaDB error code: 2003
      170205 20:27:47 [Note] /data/src/bb-10.0-monty/sql/mysqld: Normal shutdown
       
      170205 20:27:47 [Note] Event Scheduler: Purging the queue. 0 events
      170205 20:27:47 [Note] Master 'test1': Error reading relay log event: slave SQL thread was killed
      170205 20:27:47 [Note] Master 'test1': Slave SQL thread exiting, replication stopped in log 'FIRST' at position 0
      170205 20:27:47 [Note] Master 'test1': Slave I/O thread killed while connecting to master
      170205 20:27:47 [Note] Master 'test1': Slave I/O thread exiting, read up to log 'FIRST', position 4
      170205 20:27:47 [Note] Master 'm1': Slave I/O thread exiting, read up to log 'mysql-bin.000001', position 10260177; GTID position 0-1-56491
      170205 20:27:47 [Note] Master 'm1': Slave SQL thread exiting, replication stopped in log 'mysql-bin.000001' at position 820966; GTID position '0-1-3727'
      170205 20:27:47 [ERROR] mysqld got signal 11 ;
      ...
      Query (0x7f9d58c22088): CHANGE MASTER 'test1' TO MASTER_HOST='127.0.0.1', MASTER_PORT=3333, MASTER_USER='foo' /* QNO 863177 CON_ID 8 */
      Connection ID (thread ID): 7
      Status: KILL_SERVER
      

      All threads' stack trace is attached

      Attachments

        Activity

          People

            monty Michael Widenius
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.