Arvados

2023-01-26_21:08:14.29202 ActiveRecord::StatementInvalid: PG::FeatureNotSupported: ERROR:  FOR UPDATE is not allowed with GROUP BY clause
2023-01-26_21:08:14.29202 : SELECT MIN(uuid) AS uuid, COUNT(uuid) AS n FROM links
2023-01-26_21:08:14.29202         WHERE tail_uuid IS NOT NULL
2023-01-26_21:08:14.29203          AND head_uuid IS NOT NULL
2023-01-26_21:08:14.29203          AND link_class = 'permission'
2023-01-26_21:08:14.29203          AND name in ('can_read', 'can_write', 'can_manage')
2023-01-26_21:08:14.29204         GROUP BY (tail_uuid, head_uuid)
2023-01-26_21:08:14.29204         HAVING COUNT(uuid) > 1
2023-01-26_21:08:14.29204         FOR UPDATE

This is with Debian postgresql 11+200+deb10u5, which is the default version on Debian 10.

Ubuntu 18.04 has postgresql 10.22-0ubuntu0.18.04.1