Fix PXC operator reconcile loop: Error 4006 CREATE USER failed for a view definer account

Percona Operator for MySQL based on PXC 1.20.0 (PXC 8.4.8-8.1) reconciling a spec.users custom user who is a view, trigger, or routine DEFINER and already holds an explicit privilege list instead of ALL PRIVILEGES.

Confirm the loop signature in the operator log. Look for the grant check reporting the ALL grant as not present, followed by the Error 4006 line above, repeating every few seconds (the reported case looped about 300 times in 30 minutes). Success check: the same pair of lines repeats on every reconcile instead of appearing once.

Check what the custom user actually holds. Run SHOW GRANTS for the user named in spec.users. Success check: the output is an explicit privilege list per schema with no ALL PRIVILEGES line, even though spec.users requests grants [ALL].

Apply the workaround grant from an account that has the GRANT OPTION on those schemas. For each database listed for that user in spec.users, run: GRANT ALL ON appdb1.* TO the custom user account (repeat per schema, for example appdb2). Success check: SHOW GRANTS now returns ALL PRIVILEGES for each schema.

Watch the next reconcile cycles. Success check: the operator stops re-running the upsert, the repeated CREATE DATABASE IF NOT EXISTS statements stop, wsreplocalcert_failures stops climbing, and application transactions stop failing at COMMIT with deadlock errors.

Make the fix durable. Either keep the account grants aligned with the ALL entry in spec.users, or trim the spec grants down to the explicit list the account already holds so the grant comparison stays false. Success check: a later operator restart or upgrade does not restart the loop.

In the Percona community forum thread 41363 (OP DanielMuhra, Oct 21, 2026, 0 replies at check time): the operator reconcile looped about 300 times in 30 minutes, CREATE USER failed with Error 4006 for a view definer account, wsreplocalcertfailures reached 421 in a few hours, and the OP recorded the GRANT ALL per-schema workaround. Source: https://forums.percona.com/t/pxc-operator-1-20-0-custom-user-reconcile-loops-forever-view-definer-error-4006-and-repeated-create-database-aborts-app-transactions/41363