• Support

  • MySQLd service failed to start (after restarting server)

15 days later

I have the same problem

This is the log

/www/server/mysql/bin/mysqld(+0x66df6e)[0x558e0d302f6e]
/www/server/mysql/bin/mysqld(+0x66e453)[0x558e0d303453]
/www/server/mysql/bin/mysqld(Z20buf_page_io_completeP10buf_page_tb+0x2d6)[0x558e0df67b56]
/www/server/mysql/bin/mysqld(+0x12fca0c)[0x558e0df91a0c]
/www/server/mysql/bin/mysqld(Z13buf_read_pageRK9page_id_tRK11page_size_t+0x73)[0x558e0df921b3]
/www/server/mysql/bin/mysqld(Z16buf_page_get_genRK9page_id_tRK11page_size_tmP11buf_block_tmPKcmP5mtr_tb+0x46f)[0x558e0df65c9f]
/www/server/mysql/bin/mysqld(Z31trx_rseg_get_n_undo_tablespacesPm+0x13d)[0x558e0df0063d]
/www/server/mysql/bin/mysqld(+0x1238523)[0x558e0decd523]
/www/server/mysql/bin/mysqld(Z34innobase_start_or_create_for_mysqlv+0x2bd4)[0x558e0ded0c14]
/www/server/mysql/bin/mysqld(+0x110185e)[0x558e0dd9685e]
/www/server/mysql/bin/mysqld(Z24ha_initialize_handlertonP13st_plugin_int+0x59)[0x558e0d3905c9]
/www/server/mysql/bin/mysqld(+0xc7d656)[0x558e0d912656]
/www/server/mysql/bin/mysqld(Z40plugin_register_builtin_and_init_core_sePiPPc+0x1ec)[0x558e0d914a8c]
/www/server/mysql/bin/mysqld(Z11mysqld_mainiPPc+0xb90)[0x558e0d33c380]
/lib/x86_64-linux-gnu/libc.so.6(+0x29d90)[0x14fb0a658d90]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x80)[0x14fb0a658e40]
/www/server/mysql/bin/mysqld(_start+0x25)[0x558e0d3316f5]

    Hello, use the ssh tool to execute the command to see if there is any error?
    cat /www/server/data/*.err|grep -i -C 10 error

    jaac

      Hello, this is not the latest log, the time of your server is incorrect?

      jaac

      • jaac replied to this.

          I suggest you check whether you have modified the mysql log configuration? Check the mysql log for errors

          jaac

          • jaac replied to this.

              lutfifuadi
              Hello, what have you done? Try the server to do a snapshot backup and then operate
              please use the root authority to execute the command
              Is it normal to try to move the file away?
              cd /www/server/data/
              mv ibdata1 /tmp/ibdata1.bak
              mv ib_logfile0 /tmp/ib_logfile0.bak
              mv ib_logfile1 /tmp/ib_logfile1.bak
              /etc/init.d/mysqld restart

                19 days later

                Hi, please describe your problem in detail.
                If you delete the prompted directory by mistake, please find a professional company to help you restore important data
                If there is no database, you can reinstall mysql

                aaP_olaniyi

                  Please check whether the mysql configuration file has changed the database storage directory?

                  aaP_olaniyi