MySQL InnoDB Cluster Charm

mysql 8.0.19-0ubuntu4 has new permissions requirements

Bug #1873331 reported by David Ames
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Charm Helpers
Fix Committed
Critical
David Ames
MySQL InnoDB Cluster Charm
Fix Released
Critical
David Ames
MySQL InnoDB Cluster Charm 20.05

Bug Description

Mysql router is unable to bootstrap due to missing permissions:

ERROR juju-log Failed to bootstrap mysqlrouter: Error: Error executing MySQL query "select cluster_type from mysql_innodb_cluster_metadata.v2_this_instance": View 'mysql_innodb_cluster_metadata.v2_this_instance' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)

mysql 8.0.19-0ubuntu4 is a recent update.

David Ames (thedac)
Changed in charm-mysql-innodb-cluster:
status: New → Confirmed
importance: Undecided → Critical
assignee: nobody → David Ames (thedac)
Revision history for this message
David Ames (thedac) wrote :

The view mysql_innodb_cluster_metadata.v2_this_instance references performance_schema.global_variables which the mysqlrouter user does not have permissions for.

 v2_this_instance | CREATE ALGORITHM=UNDEFINED DEFINER=`clusteruser`@`10.5.0.4` SQL SECURITY INVOKER VIEW `v2_this_instance` AS select `i`.`cluster_id` AS `cluster_id`,`i`.`instance_id` AS `instance_id`,`c`.`cluster_name` AS `cluster_name`,`c`.`cluster_type` AS `cluster_type` from (`v2_instances` `i` join `clusters` `c` on((`i`.`cluster_id` = `c`.`cluster_id`))) where (`i`.`mysql_server_uuid` = (select convert(`performance_schema`.`global_variables`.`VARIABLE_VALUE` using ascii) from `performance_schema`.`global_variables` where (`performance_schema`.`global_variables`.`VARIABLE_NAME` = 'server_uuid'))) | utf8mb4 | utf8mb4_0900_ai_ci |

Adding charmhelpers to the bug. Needs: "GRANT SELECT ON performance_schema.global_variables"

Changed in charm-helpers:
status: New → Confirmed
importance: Undecided → Critical
assignee: nobody → David Ames (thedac)
Revision history for this message
David Ames (thedac) wrote :

Grant is in charm helpers
https://github.com/juju/charm-helpers/pull/455

Changed in charm-helpers:
status: Confirmed → Fix Committed
OpenStack Infra (hudson-openstack)
Changed in charm-mysql-innodb-cluster:
status: Confirmed → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to charm-mysql-innodb-cluster (master)

Reviewed: https://review.opendev.org/720305
Committed: https://git.openstack.org/cgit/openstack/charm-mysql-innodb-cluster/commit/?id=96ddade852a751f601f98f5d2ac1c600722fc1e2
Submitter: Zuul
Branch: master

commit 96ddade852a751f601f98f5d2ac1c600722fc1e2
Author: David Ames <email address hidden>
Date: Mon Apr 13 15:26:14 2020 -0700

    Pass wait timeout all the way through to clients

    Wait timeout is the non-interactive idle timeout setting. The default of
    3600 is aligned to OpenStack's idle_timeout configuration default.

    Along with changes to the mysql-shared and mysql-router interfaces, this
    change passes the wait timeout value all the way through to the client.

    Depends-On: I6ec40bc65f719e1938d9b0ccdb7ad00236f435d0
    Closes-Bug: #1841063
    Closes-Bug: #1873331
    Change-Id: Ie2b2ad2856cbe1d830f1b7e674a2fb867d81de12

Changed in charm-mysql-innodb-cluster:
status: In Progress → Fix Committed
David Ames (thedac)
Changed in charm-mysql-innodb-cluster:
milestone: none → 20.05
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.