Missing Standard ACLs in sys_security_acl on Yokohama Patch 5 with MariaDB 10.6 Community

[Auverland]

Hi everyone,

Sorry in advance for the long post, but I’m trying to summarize an issue we’ve been struggling with.

We installed Vancouver on MariaDB 10.6 Community, then upgraded to Washington and finally Yokohama Patch 5 (YP5). We also created fresh YP5 environments. In these new instances, the sys_security_acl table is incomplete: several standard ACLs that exist in Vancouver are missing.

For example, this query should return 24 records, but we only get 2:

select * from sys_security_acl
where name like 'task.%'
and operation = 'write';

No errors appear in the zBoot logs. ServiceNow Support couldn’t reproduce the issue.

To isolate the cause, I built multiple test environments:

- Personal machine (RHEL 9.6) with a full MariaDB 10.6 install → YP5 and YP9 zBoot work fine.

- Internal lab with MariaDB 10.6 tarball (full install) → YP5 zBoot works fine.

- Corporate lab using our automated install of MariaDB 10.6 Community RPMs → ACLs missing.

Our automated install deploys only these RPMs:

MariaDB-shared-10.6.15
MariaDB-common-10.6.15
MariaDB-client-10.6.15
MariaDB-backup-10.6.15
MariaDB-server-10.6.15

MariaDB provides many other 10.6 packages, but they generally advise not installing everything (e.g., not installing MariaDB-test in production). ServiceNow documentation only lists required packages for MariaDB 10.4, not 10.6.

Question for other Self‑Hosted users:
1/ Which MariaDB 10.6 RPM packages are you using successfully with Yokohama Patch 5 (or later)?
2/ Have you ever seen missing ACLs after zBoot?

Thanks for your help, and again sorry for the long message.