ERROR 3098 (HY000): The table does not comply with the requirements by an external plugin
SETUP:
- Three mysql group replication nodes in master master master.
- All work fine. I can add users/dbs and insert/update data.
- Each node is bound to a private IP address.
- I created a bash script to connect to mysql to delete users.
- Deleting a database with a script works fine.
PROBLEM:
The following commands will NOT run. I can create users and databases and delete databases but cant delete the users. I cant tell if its a replication issue OR a privilege issue.
- DELETE FROM mysql.user WHERE user='testme123';
- DELETE FROM mysql.db WHERE user='testme123';
- DROP USER IF EXISTS 'testme123';
ERROR 3098 (HY000) at line 1: The table does not comply with the requirements by an external plugin.
LOG: [ERROR] Plugin group_replication reported: 'Table user does not use the InnoDB storage engine. This is not compatible with Group Replication.
I get same error via local mysql console too logged in as root.
QUESTION(S):
- What could be preventing this?
- How can I troubleshoot what it is I am missing?
mysql bash replication
asked Nov 12 '18 at 19:17
Kyle Anderson
5801921
add a comment |
SETUP:
- Three mysql group replication nodes in master master master.
- All work fine. I can add users/dbs and insert/update data.
- Each node is bound to a private IP address.
- I created a bash script to connect to mysql to delete users.
- Deleting a database with a script works fine.
PROBLEM:
The following commands will NOT run. I can create users and databases and delete databases but cant delete the users. I cant tell if its a replication issue OR a privilege issue.
- DELETE FROM mysql.user WHERE user='testme123';
- DELETE FROM mysql.db WHERE user='testme123';
- DROP USER IF EXISTS 'testme123';
ERROR 3098 (HY000) at line 1: The table does not comply with the requirements by an external plugin.
LOG: [ERROR] Plugin group_replication reported: 'Table user does not use the InnoDB storage engine. This is not compatible with Group Replication.
I get same error via local mysql console too logged in as root.
QUESTION(S):
- What could be preventing this?
- How can I troubleshoot what it is I am missing?
mysql bash replication
asked Nov 12 '18 at 19:17
Kyle Anderson
5801921
What version of MySQL?
– Rick James
Dec 11 '18 at 5:10
Mysql 5.7 (not mariadb)
– Kyle Anderson
Dec 12 '18 at 18:26
add a comment |
SETUP:
- Three mysql group replication nodes in master master master.
- All work fine. I can add users/dbs and insert/update data.
- Each node is bound to a private IP address.
- I created a bash script to connect to mysql to delete users.
- Deleting a database with a script works fine.
PROBLEM:
The following commands will NOT run. I can create users and databases and delete databases but cant delete the users. I cant tell if its a replication issue OR a privilege issue.
- DELETE FROM mysql.user WHERE user='testme123';
- DELETE FROM mysql.db WHERE user='testme123';
- DROP USER IF EXISTS 'testme123';
ERROR 3098 (HY000) at line 1: The table does not comply with the requirements by an external plugin.
LOG: [ERROR] Plugin group_replication reported: 'Table user does not use the InnoDB storage engine. This is not compatible with Group Replication.
I get same error via local mysql console too logged in as root.
QUESTION(S):
- What could be preventing this?
- How can I troubleshoot what it is I am missing?
mysql bash replication
asked Nov 12 '18 at 19:17
Kyle Anderson
5801921
SETUP:
- Three mysql group replication nodes in master master master.
- All work fine. I can add users/dbs and insert/update data.
- Each node is bound to a private IP address.
- I created a bash script to connect to mysql to delete users.
- Deleting a database with a script works fine.
PROBLEM:
The following commands will NOT run. I can create users and databases and delete databases but cant delete the users. I cant tell if its a replication issue OR a privilege issue.
- DELETE FROM mysql.user WHERE user='testme123';
- DELETE FROM mysql.db WHERE user='testme123';
- DROP USER IF EXISTS 'testme123';
ERROR 3098 (HY000) at line 1: The table does not comply with the requirements by an external plugin.
LOG: [ERROR] Plugin group_replication reported: 'Table user does not use the InnoDB storage engine. This is not compatible with Group Replication.
I get same error via local mysql console too logged in as root.
QUESTION(S):
- What could be preventing this?
- How can I troubleshoot what it is I am missing?
mysql bash replication
mysql bash replication
asked Nov 12 '18 at 19:17
Kyle Anderson
5801921
asked Nov 12 '18 at 19:17
Kyle Anderson
5801921
edited Nov 12 '18 at 19:26
asked Nov 12 '18 at 19:17
Kyle Anderson
5801921
asked Nov 12 '18 at 19:17
Kyle Anderson
5801921
asked Nov 12 '18 at 19:17
Kyle Anderson
5801921
5801921
What version of MySQL?
– Rick James
Dec 11 '18 at 5:10
Mysql 5.7 (not mariadb)
– Kyle Anderson
Dec 12 '18 at 18:26
add a comment |
What version of MySQL?
– Rick James
Dec 11 '18 at 5:10
Mysql 5.7 (not mariadb)
– Kyle Anderson
Dec 12 '18 at 18:26
What version of MySQL?
– Rick James
Dec 11 '18 at 5:10
What version of MySQL?
– Rick James
Dec 11 '18 at 5:10
Mysql 5.7 (not mariadb)
– Kyle Anderson
Dec 12 '18 at 18:26
Mysql 5.7 (not mariadb)
– Kyle Anderson
Dec 12 '18 at 18:26
add a comment |
1 Answer
1
active
oldest
votes
If you are using Group Replication (in 5.7 or 8.0), you must do all user authentication through the GRANT/DROP/CREATE USER/etc commands, not INSERT/UPDATE/DELETE/etc.
MyISAM is not replicated in Group Replication due to serious technical difficulties.
(The above comments apply to Galera / PXC, too.)
(Caveat: What I have said may not be strictly true, but I think it will keep you out of trouble, and address the Question at hand.)
answered Dec 11 '18 at 5:19
Rick James
66.1k55897
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53268697%2ferror-3098-hy000-the-table-does-not-comply-with-the-requirements-by-an-extern%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
If you are using Group Replication (in 5.7 or 8.0), you must do all user authentication through the GRANT/DROP/CREATE USER/etc commands, not INSERT/UPDATE/DELETE/etc.
MyISAM is not replicated in Group Replication due to serious technical difficulties.
(The above comments apply to Galera / PXC, too.)
(Caveat: What I have said may not be strictly true, but I think it will keep you out of trouble, and address the Question at hand.)
answered Dec 11 '18 at 5:19
Rick James
66.1k55897
add a comment |
If you are using Group Replication (in 5.7 or 8.0), you must do all user authentication through the GRANT/DROP/CREATE USER/etc commands, not INSERT/UPDATE/DELETE/etc.
MyISAM is not replicated in Group Replication due to serious technical difficulties.
(The above comments apply to Galera / PXC, too.)
(Caveat: What I have said may not be strictly true, but I think it will keep you out of trouble, and address the Question at hand.)
answered Dec 11 '18 at 5:19
Rick James
66.1k55897
add a comment |
If you are using Group Replication (in 5.7 or 8.0), you must do all user authentication through the GRANT/DROP/CREATE USER/etc commands, not INSERT/UPDATE/DELETE/etc.
MyISAM is not replicated in Group Replication due to serious technical difficulties.
(The above comments apply to Galera / PXC, too.)
(Caveat: What I have said may not be strictly true, but I think it will keep you out of trouble, and address the Question at hand.)
answered Dec 11 '18 at 5:19
Rick James
66.1k55897
If you are using Group Replication (in 5.7 or 8.0), you must do all user authentication through the GRANT/DROP/CREATE USER/etc commands, not INSERT/UPDATE/DELETE/etc.
MyISAM is not replicated in Group Replication due to serious technical difficulties.
(The above comments apply to Galera / PXC, too.)
(Caveat: What I have said may not be strictly true, but I think it will keep you out of trouble, and address the Question at hand.)
answered Dec 11 '18 at 5:19
Rick James
66.1k55897
answered Dec 11 '18 at 5:19
Rick James
66.1k55897
answered Dec 11 '18 at 5:19
Rick James
66.1k55897
answered Dec 11 '18 at 5:19
Rick James
66.1k55897
66.1k55897
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53268697%2ferror-3098-hy000-the-table-does-not-comply-with-the-requirements-by-an-extern%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
What version of MySQL?
– Rick James
Dec 11 '18 at 5:10
Mysql 5.7 (not mariadb)
– Kyle Anderson
Dec 12 '18 at 18:26