Bug #83407 [ERROR] Plugin Rewriter reported: Wrong column count or names when loading rules

• Submitted: 17 Oct 2016 9:10
• Modified: 10 May 2017 7:41
• Reporter: Roel Van de Paar
• Status: Won't fix
• Category: MySQL Server: Errors
• Severity: S1 (Critical)
• Version: 5.7/8.0
• OS: Any
• CPU Architecture: Any

[17 Oct 2016 9:10] Roel Van de Paar

Description:
2016-10-17T08:51:24.356739Z 2 [ERROR] Plugin Rewriter reported: 'Wrong column count or names when loading rules.'

How to repeat:
DROP DATABASE transforms;CREATE DATABASE transforms;DROP DATABASE test;CREATE DATABASE test;USE test;
INSTALL PLUGIN rewriter SONAME 'rewriter.so';
CREATE FUNCTION service_get_read_locks RETURNS INT SONAME 'locking_service.so';

[17 Oct 2016 10:32] MySQL Verification Team

2016-10-17T10:30:07.824853Z 0 [Note] Server socket created on IP: '::'.
2016-10-17T10:30:07.871666Z 0 [Note] InnoDB: Buffer pool(s) load completed at 161017  8:30:07
2016-10-17T10:30:07.981068Z 0 [Note] Event Scheduler: Loaded 0 events
2016-10-17T10:30:07.981068Z 0 [Note] c:\dbs\5.7\bin\mysqld: ready for connections.
Version: '5.7.17'  socket: ''  port: 3570  Source distribution PULL: 2016-OCT-14
2016-10-17T10:31:15.327725Z 3 [ERROR] Plugin Rewriter reported: 'Wrong column count or names when loading rules.'

[17 Oct 2016 10:47] MySQL Verification Team

Thank you for the bug report.

2016-10-17T10:43:34.252305Z 0 [Note] Server socket created on IP: '::'.
2016-10-17T10:43:34.908809Z 0 [Note] c:\dbs\8.0\bin\mysqld: ready for connections.
Version: '8.0.1-dmr'  socket: ''  port: 3580  Source distribution PULL: 2016-OCT-14
2016-10-17T10:44:08.949098Z 4 [ERROR] Plugin Rewriter reported: 'Wrong column count or names when loading rules.'

[18 Nov 2016 8:09] Erlend Dahl

Posted by developer:

[18 Oct 2016 9:28] Martin Hansson

This type of bug report springs up from time to time, so let's take a moment
for a quick recap of the three most important rules for using the Rewriter
plugin:

1) Do not issue the INSTALL PLUGIN command yourself.
2) Do not issue the INSTALL PLUGIN command yourself.
3) Do not issue the INSTALL PLUGIN command yourself.

If you feel that you absolutely have to issue the INSTALL PLUGIN command
yourself, you have to copy *all* the content of install_rewriter_plugin.sql.
And please remember that you have to run uninstall_rewriter.sql to uninstall
it, or do the same for this file. But there are no guarantees that your copy
will work with future versions of MySQL.

[10 May 2017 7:41] Roel Van de Paar

Reliable method;

SOURCE share/install_rewriter.sql