We have seen the following error couple of times on our mariadb galeracluster replications on the replication target host:

Slave SQL: Error 'Warning: Can't copy ownership for file './data/viewname.frm-' (Errcode: 1 "Operation not permitted")' on query. Default database: 'data'. Query: 'CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`username`@`%` SQL SECURITY INVOKER VIEW `viewname` AS SELECT someFields...

Everything else works fine, but sporadically we see these errors, and then replication stops and needs to be started from scratch.

The pod is running as non-root user 1001.

As a workaround I am thinking about simply not replicating any view specific modifications. But preferably, of course, the bug would be fixed in mariadb.

We are doing the same tasks on more than 30 different galeraclusters. We have seen this problem on only 3 of these. On these three databases the concerned table, for which the view should be update, is particularly large, it has more than a milion rows there.

(we have not tested it on more recent mariadb versions yet, but will do)