restore refreshable materialized view doesn’t work

[Slach]

2025-10-13 18:00:20.712 INF ../usr/src/RPM/BUILD/clickhouse-backup-2.6.39/pkg/clickhouse/clickhouse.go:1186 > ATTACH MATERIALIZED VIEW repodb2.rmv_repository_statistics UUID 'cd14eebe-8b13-4dc9-b1e1-ca145686445a' REFRESH EVERY 1 HOUR RANDOMIZE FOR 10 MINUTE TO repodb2.lv_repository_statistics (...) DEFINER = default SQL SECURITY DEFINER AS...

https://github.com/Altinity/clickhouse-backup/blob/master/pkg/clickhouse/clickhouse.go#L1057-L1059

backup_name/metadata/repodb2/rmv_repository_statistics.json

{
 "table": "rmv_repository_statistics",
 "database": "repodb2",
 "uuid": "cd14eebe-8b13-4dc9-b1e1-ca145686445a",
 "parts": null,
 "query": "ATTACH MATERIALIZED VIEW repodb2.rmv_repository_statistics UUID 'cd14eebe-8b13-4dc9-b1e1-ca145686445a' REFRESH EVERY 1 HOUR RANDOMIZE FOR 10 MINUTE TO repodb2.lv_repository_statistics (`branch` String, `branch_date` DateTime, `stats` Array(Tuple(String, String, String, UInt64, UUID))) DEFINER = default SQL SECURITY DEFINER AS WITH pkgset_roots AS (SELECT pkgset_nodename AS name, argMax(pkgset_ruuid, pkgset_date) AS ruuid, max(pkgset_date) AS date FROM repodb2.PackageSetName WHERE (pkgset_depth = 0) AND ((pkgset_kv.v[2]) = 'repo') GROUP BY pkgset_nodename), pkgset_uuids AS (SELECT pkgset_uuid AS uuid, pkgset_nodename AS name, splitByChar('/', pkgset_kv.v[5])[1] AS arch FROM repodb2.PackageSetName WHERE (pkgset_ruuid IN (SELECT ruuid FROM pkgset_roots)) AND (pkgset_depth \u003e 0)), pkgset_hashes AS (SELECT pkgset_uuid, pkg_hash FROM repodb2.PackageSet WHERE pkgset_uuid IN (SELECT uuid FROM pkgset_uuids)) SELECT any(CI.name) AS branch, any(CI.date) AS branch_date, groupUniqArray((CI.arch, CI.comp, CI.size, CS.size, CI.pkgset_uuid)) AS stats FROM (SELECT pkgset_ruuid, PR.name, PR.date, pkgset_uuid, splitByChar('/', pkgset_kv.v[5])[1] AS arch, pkgset_nodename AS comp, pkgset_kv.v[3] AS size FROM repodb2.PackageSetName LEFT JOIN (SELECT name, ruuid, date FROM pkgset_roots) AS PR ON PR.ruuid = pkgset_ruuid WHERE (pkgset_depth \u003e 0) AND (pkgset_ruuid IN (SELECT ruuid FROM pkgset_roots)) AND (((pkgset_kv.v[2]) = 'comp') OR ((pkgset_kv.v[2]) = 'srpm'))) AS CI LEFT JOIN (SELECT pkgset_uuid, sum(PS.size) AS size FROM pkgset_hashes LEFT JOIN (SELECT pkg_hash AS hash, pkg_filesize AS size FROM repodb2.Packages WHERE pkg_hash IN (SELECT pkg_hash FROM pkgset_hashes)) AS PS ON PS.hash = pkg_hash GROUP BY pkgset_uuid) AS CS ON CS.pkgset_uuid = CI.pkgset_uuid GROUP BY pkgset_ruuid",
 "size": null,
 "metadata_only": false
}