Buy Percona ServicesBuy Now!

pt-online-schema-change cause mysqld restart

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • carlos.salguero
    replied
    I cannot find the error reported to MySQL team, sorry.

    Leave a comment:


  • peng19832
    replied
    Originally posted by carlos.salguero View Post
    Hello,

    pt-online-schema-change runs regular queries (in a complex sequence, I know) so it shouldn't cause MySQL to crash.
    From the attached error log I see this:

    Code:
    019-03-28T08:09:24.905320Z 0 [ERROR] Function 'validate_password' already exists
    2019-03-28T08:09:24.905374Z 0 [ERROR] Couldn't load plugin named 'validate_password' with soname 'validate_password.so'.
    2019-03-28T08:09:24.925899Z 0 [ERROR] Function 'validate_password' already exists
    2019-03-28T08:09:24.925967Z 0 [Warning] Couldn't load plugin named 'validate_password' with soname 'validate_password.so'.
    2019-03-28T08:09:24.926381Z 0 [Warning] Plugin validate_password reported: 'Dictionary file not specified'
    and more: at the beginning of the error log it says signal 11. That's a MySQL internal error.
    Code:
    08:07:45 UTC - mysqld got signal 11 ;
    I only saw a similar error on MySQL 8 having empty users and roles and that was causing a different program (minimum_permissions) to fail after MySQL crashed with a signal 11.
    Could you verify that there are no invalid/empty users in your db?

    Regards
    Do these two have an impact?
    Can you post the page of the bug you mentioned,?
    Thank you.

    | mysql.session | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
    | mysql.sys | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |

    Leave a comment:


  • carlos.salguero
    replied
    Hello,

    pt-online-schema-change runs regular queries (in a complex sequence, I know) so it shouldn't cause MySQL to crash.
    From the attached error log I see this:

    Code:
    019-03-28T08:09:24.905320Z 0 [ERROR] Function 'validate_password' already exists
    2019-03-28T08:09:24.905374Z 0 [ERROR] Couldn't load plugin named 'validate_password' with soname 'validate_password.so'.
    2019-03-28T08:09:24.925899Z 0 [ERROR] Function 'validate_password' already exists
    2019-03-28T08:09:24.925967Z 0 [Warning] Couldn't load plugin named 'validate_password' with soname 'validate_password.so'.
    2019-03-28T08:09:24.926381Z 0 [Warning] Plugin validate_password reported: 'Dictionary file not specified'
    and more: at the beginning of the error log it says signal 11. That's a MySQL internal error.
    Code:
    08:07:45 UTC - mysqld got signal 11 ;
    I only saw a similar error on MySQL 8 having empty users and roles and that was causing a different program (minimum_permissions) to fail after MySQL crashed with a signal 11.
    Could you verify that there are no invalid/empty users in your db?

    Regards

    Leave a comment:


  • peng19832
    replied
    Someone has encountered this situation or how to solve it.

    Leave a comment:


  • peng19832
    started a topic pt-online-schema-change cause mysqld restart

    pt-online-schema-change cause mysqld restart

    environment:
    OS:Red Hat Enterprise Linux Server release 6.5 (Santiago)
    MySQL version:5.7.22
    Questions:I use pt-online-schema-change to cause the mysqld service to restart when adding an index in a table with 50 million records.
    Attached Files
Working...
X