Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

not supporter users with dot in name #930

Closed
VladislavePolyakov opened this issue Jun 5, 2024 · 6 comments
Closed

not supporter users with dot in name #930

VladislavePolyakov opened this issue Jun 5, 2024 · 6 comments
Assignees
@Slach
Milestone
2.5.13

Comments

@VladislavePolyakov
Copy link 

2024/06/05 09:28:11.778302  info SELECT name FROM system.user_directories WHERE type='replicated' logger=clickhouse
2024/06/05 09:28:11.779187  info SELECT toString(id) AS id, name FROM `system`.`users` WHERE name=? LIMIT 1 with args [bpmbi] logger=clickhouse
2024/06/05 09:28:11.781418  info SELECT toString(id) AS id, name FROM `system`.`users` WHERE name=? LIMIT 1 with args [d.morozov] logger=clickhouse
2024/06/05 09:28:11.783350  warn RBAC object kind=USER, name=d.ivanov already present, will recreate logger=backuper
2024/06/05 09:28:11.783360  info DROP USER IF EXISTS d.ivanov logger=clickhouse
2024/06/05 09:28:11.783797  info clickhouse connection closed logger=clickhouse
2024/06/05 09:28:11.783811 error code: 62, message: Syntax error: failed at position 22 ('.'): .ivanov. Expected one of: token, At, Comma, FROM, ON, end of query

when resotre with --rbac got error

look like bug and need add quotes for user

Version: 2.5.12
Git Commit: eb33790
Build Date: 2024-06-03
@Slach
Copy link
Collaborator

Slach commented Jun 5, 2024

thanks for reporting, will fix it ASAP

@Slach Slach added this to the 2.5.13 milestone Jun 5, 2024
@Slach Slach self-assigned this Jun 5, 2024
@Slach Slach closed this as completed in d2e5fab Jun 5, 2024
@Slach Slach reopened this Jun 5, 2024
@Slach
Copy link
Collaborator

Slach commented Jun 5, 2024

@VladislavePolyakov could you share result of
ls -la /var/lib/clickhouse/backup/backup_name/access/

@VladislavePolyakov
Copy link
Author

@VladislavePolyakov could you share result of ls -la /var/lib/clickhouse/backup/backup_name/access/

total 1.5M
drwxrwx---  2 clickhouse clickhouse  28K Jun  5 09:09 .
drwx------ 17 clickhouse clickhouse 4.0K Jun  5 10:10 ..
-rw-r-----  1 clickhouse clickhouse 1.7K Jun  5 08:55 014f2584-ec2d-fa8d-e764-4eb970219182.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 0240cfbb-713d-6544-68a0-4a9092bcb5a5.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 03406d16-71a9-56a7-655e-db6cd42483be.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 044a6028-1924-6043-2af4-1334976261bf.sql
-rw-r-----  1 clickhouse clickhouse 1.6K Jun  5 08:55 044c554b-6283-63ee-d563-78a741ed00af.sql
-rw-rw----  1 clickhouse clickhouse  647 Jun  5 08:55 044d02af-d27f-7cc7-610e-40226426e9a0.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 0541bee2-376e-fd90-a25c-b5e974771481.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 05436aac-e29e-ed1c-978b-1103af26859a.sql
-rw-r-----  1 clickhouse clickhouse 1.7K Jun  5 08:55 05488672-3ec3-27de-4945-f12b0a739393.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 054a83ca-ba31-2fab-37e2-5e325c9d92b1.sql
-rw-r-----  1 clickhouse clickhouse 2.0K Jun  5 08:55 054f6c89-dfeb-7840-10fe-82ad392f9a92.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 0741459c-e008-3517-b5c0-01de87ba9586.sql
-rw-r-----  1 clickhouse clickhouse 1.6K Jun  5 08:55 074148cf-3a01-a907-1f76-b1a56f01fb90.sql
-rw-r-----  1 clickhouse clickhouse 1.9K Jun  5 08:55 0843f595-b36d-9f6b-4c8c-fd04dd81bcb9.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 0945b6f2-b42f-0850-9f52-5a878e6baf9d.sql
-rw-rw----  1 clickhouse clickhouse 1.2K Jun  5 08:55 0949565c-dd60-9006-d81f-07a76ee68eb7.sql
-rw-rw----  1 clickhouse clickhouse 1.2K Jun  5 08:55 0b42f62c-8313-0c42-df95-3ba5a7407aa7.sql
-rw-rw----  1 clickhouse clickhouse  337 Jun  5 08:55 0b48791e-654e-07bb-4574-3727cd2bb7a9.sql
-rw-rw----  1 clickhouse clickhouse 1.7K Jun  5 08:55 0c43a583-80d9-92cb-f2bb-3e345de8868f.sql
-rw-r-----  1 clickhouse clickhouse 1.1K Jun  5 08:55 0f45bf69-d148-b841-362e-d6dca3b6d498.sql
-rw-rw----  1 clickhouse clickhouse 1.5K Jun  5 08:55 104881fa-4ef0-fb2f-c2c4-3cead11f3a90.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 104dacac-0649-55eb-af8a-02e1be27acb1.sql
-rw-rw----  1 clickhouse clickhouse  415 Jun  5 08:55 1440e218-f17e-3f47-9964-cac96d1adb8a.sql
-rw-rw----  1 clickhouse clickhouse  642 Jun  5 08:55 144432e4-0650-ed55-09c0-870ab57eea95.sql
-rw-r-----  1 clickhouse clickhouse 1.1K Jun  5 08:55 144de587-53c8-2b51-dd1b-99651d191180.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 1749dbad-e053-e96e-a234-f51533412789.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 18451ca2-7245-f878-145a-78ccb4568e93.sql
-rw-rw----  1 clickhouse clickhouse 1.3K Jun  5 08:55 1847aacd-b769-d96d-42c9-c2f811aa95a3.sql
-rw-r-----  1 clickhouse clickhouse 2.0K Jun  5 08:55 1943f1d1-998e-6c15-e3ab-97f635065685.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 1a4cfb11-daa3-9255-0c4b-32a76826e9b4.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 1c403999-b318-59d9-c4a9-5dc7dd3aa185.sql
-rw-r-----  1 clickhouse clickhouse 2.2K Jun  5 08:55 1d42d075-98df-2363-4e38-aa7b40a25a99.sql
-rw-r-----  1 clickhouse clickhouse 3.4K Jun  5 08:55 1d477456-cc28-c985-34a8-2b67aea94299.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 1d48eabf-5ec1-a65d-a620-bda10d4f648f.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 1d4e653e-83d6-6d68-03a1-b8c610cdb4b4.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 1e443ace-2d8c-50ae-14df-422ea8a0d48e.sql
-rw-r-----  1 clickhouse clickhouse  952 Jun  5 08:55 1e49da44-ff92-b7dd-eb78-c214321d1ba2.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 1e4a362f-3d5b-d729-539f-369536ca61ba.sql
-rw-r-----  1 clickhouse clickhouse  143 Jun  5 08:55 1f4397d0-3d64-e484-e688-18029cb1f69d.sql
-rw-rw----  1 clickhouse clickhouse  534 Jun  5 08:55 1f4399a1-435d-0e62-f9d6-6c65b124dd96.sql
-rw-rw----  1 clickhouse clickhouse 1.4K Jun  5 08:55 1f474e25-b2df-513c-88db-0b9fd349f2b6.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 1f498650-c1d7-c2b4-c42b-67ac1513f59e.sql
-rw-rw----  1 clickhouse clickhouse 1.3K Jun  5 08:55 2440b411-ed90-49b8-1170-b9ef966d2d9f.sql
-rw-rw----  1 clickhouse clickhouse 1.8K Jun  5 08:55 24414124-2391-510d-ba16-2edd7f8b6491.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 26481fc7-5bc0-43b0-00c7-a1fdf97657b3.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 264b26c0-d753-8506-0b40-ef65034b7fa7.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 2746d8cc-d048-82d5-db37-b0ca08db9bab.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 28427db4-f1a6-8bbb-3beb-f887b3b7a59f.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 2847bcad-98b5-4015-7f28-eb1a541f68bb.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 28486740-b394-dc33-b7e5-92e6bedb9a87.sql
-rw-r-----  1 clickhouse clickhouse 3.5K Jun  5 08:55 294355dc-51c1-6c67-a4cc-838613e22ab3.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 2a4c7c55-c39f-212c-6e08-59bd81003684.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 2a4f4bbe-783c-ad44-8939-d51fddc8cebe.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 2b438392-2be9-c142-ae47-f16f788f2488.sql
-rw-rw----  1 clickhouse clickhouse   16 Jun  5 08:55 2b4fba5d-95b6-152f-1b7a-76e2857fe586.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 2d44eb3c-6b2e-5f3b-9a75-09f9c36c4393.sql
-rw-r-----  1 clickhouse clickhouse 1.1K Jun  5 08:55 2e42a852-55ab-09bb-4c2a-f8632bf272b2.sql
-rw-rw----  1 clickhouse clickhouse  783 Jun  5 08:55 2f43b04b-1056-6fdf-d9af-c1c3ad85c1bb.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 2f452b25-8770-fa84-290c-1b61ca0db599.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 2f493d64-b8f4-2cb0-ca1a-4a64158ee186.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 30457709-13ca-5c60-a537-7742db5c69b0.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 31494de8-e2db-e06d-f8e3-e7c56100a08e.sql
-rw-rw----  1 clickhouse clickhouse  288 Jun  5 08:55 314a8f75-b133-7c6b-246f-6175e173508d.sql
-rw-rw----  1 clickhouse clickhouse 1.4K Jun  5 08:55 324a86c0-7d5e-bfd2-6573-4aab328b1093.sql
-rw-rw----  1 clickhouse clickhouse  295 Jun  5 08:55 324b311f-6e31-2a2e-65ba-e920bff24e8e.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 334f2243-ff41-de82-7256-aa8de423fba2.sql
-rw-rw----  1 clickhouse clickhouse  514 Jun  5 08:55 334f504a-c81e-994f-e8da-eda9e2f97c92.sql
-rw-r-----  1 clickhouse clickhouse  995 Jun  5 08:55 34420a7a-85fc-8b3b-43e8-1fb20b1e9da8.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 37459bfb-4d55-07d8-729f-9fe0b7a7519c.sql
-rw-r-----  1 clickhouse clickhouse 1.1K Jun  5 08:55 374d9942-2ba9-36b0-3750-397085ae15b5.sql
-rw-r-----  1 clickhouse clickhouse 2.3K Jun  5 08:55 38446f87-c29d-13cb-31e3-5aad8d16df83.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 3845f18e-cda9-1b1a-6868-4e4c3984b9a4.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 3848c874-7cea-a639-75b6-54947275b3ad.sql
-rw-rw----  1 clickhouse clickhouse 1.6K Jun  5 08:55 39450c46-5b2b-ce6c-8dd5-e20a9f692b97.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 394efc2f-7eca-78e4-9be4-daa69d6203aa.sql
-rw-r-----  1 clickhouse clickhouse 2.4K Jun  5 08:55 3b40f62c-bafa-3f29-b4c2-86a93f718798.sql
-rw-rw----  1 clickhouse clickhouse 3.0K Jun  5 08:55 3b4a8698-b9a7-2080-b77a-172d0b16d186.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 3c4457a1-d765-6c6c-31c7-222b04c10492.sql
-rw-rw----  1 clickhouse clickhouse  302 Jun  5 08:55 3d41fdea-d870-d969-fe9d-50367d6d7880.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 3e445dbe-8ef6-4aaf-2cb2-b5ea3a9a64ab.sql
-rw-rw----  1 clickhouse clickhouse   16 Jun  5 08:55 3f452a9e-1df5-85bb-12f1-dd06b67b3496.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 3f48db29-d95c-b68c-4846-2025fe9268bc.sql
-rw-rw----  1 clickhouse clickhouse 1.5K Jun  5 08:55 42428a9d-05e5-f79a-facb-33784b687394.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 4249aa3a-28f8-0fbb-61ed-4d1bbfe39da9.sql
-rw-r-----  1 clickhouse clickhouse   25 Jun  5 08:55 434443dd-8af7-c437-899d-98e6ceb00d8e.sql
-rw-r-----  1 clickhouse clickhouse 1.6K Jun  5 08:55 43483a93-9f46-b73f-5020-2145e1660f8f.sql
-rw-r-----  1 clickhouse clickhouse 1.1K Jun  5 08:55 4442f549-56f7-cc8b-4310-c1d31b8e869f.sql
-rw-r-----  1 clickhouse clickhouse 1.6K Jun  5 08:55 4443d771-0875-1d6e-8ece-d920d2fdb88d.sql
-rw-r-----  1 clickhouse clickhouse  860 Jun  5 08:55 4448cbf7-3044-530a-5ff5-64aa41cea1ad.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 4540c192-5b80-d78f-d400-44ee869c79b1.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 454954bd-6840-cd91-5ec3-6a1dd5ed82a0.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 454ea5c5-c303-e32b-bde9-f81a9f7f28ad.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 464610c2-74d6-54fb-8cd4-faa9b6529789.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 47472e16-3d7d-6c93-0d36-4e72cae79b97.sql
-rw-r-----  1 clickhouse clickhouse 1.1K Jun  5 08:55 4840490e-1543-8f6f-3d1f-3928d884e78f.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 484ce33c-e3d6-3791-6b46-95d2b6709f97.sql
-rw-rw----  1 clickhouse clickhouse 1.7K Jun  5 08:55 4948c463-1034-8253-8e4f-016393b1309b.sql
-rw-rw----  1 clickhouse clickhouse  36K Jun  5 08:55 4b410b78-a25f-9817-71a0-60355ea28cae.sql
-rw-r-----  1 clickhouse clickhouse 1.6K Jun  5 08:55 4c401b63-0ce9-ec3a-06a4-2b82f77383a3.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 4d407e2f-bbdc-4e45-6ca3-abe9d5340eac.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 4d460ec3-5728-e803-3d6e-fd4b998e339e.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 4d48e9bd-a232-fd1e-b118-586c8e1eab9e.sql
-rw-r-----  1 clickhouse clickhouse 1.1K Jun  5 08:55 4e425dfe-9b68-2641-c53f-dc19d5e9e4a5.sql
-rw-r-----  1 clickhouse clickhouse 1.1K Jun  5 08:55 4f4c3c6e-c31b-e667-abee-7a4f5191ae8b.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 4f4dec1a-7a71-f233-711d-9d0fc533598f.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 5049f66e-a31d-ab73-0a10-3021bab96a9d.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 504c77fb-3b2a-8f63-8f6c-282fc862b1b1.sql
-rw-rw----  1 clickhouse clickhouse  647 Jun  5 08:55 51423939-9ffb-20f0-2229-98b0ddcbc880.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 514dd5fc-525b-2701-e72b-97af710a3db8.sql
-rw-r-----  1 clickhouse clickhouse 1.7K Jun  5 08:55 524c19ee-b7da-12c7-0698-40328cf4efbd.sql
-rw-rw----  1 clickhouse clickhouse  358 Jun  5 08:55 534d0465-149e-6bc5-b525-6a963a031d95.sql
-rw-r-----  1 clickhouse clickhouse 1.9K Jun  5 08:55 544175d6-4369-30db-ecdb-cdfa6388549b.sql
-rw-r-----  1 clickhouse clickhouse 1.6K Jun  5 08:55 5547c82b-05bd-f01b-2369-cf47baed568d.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 56477a54-a130-5236-9fd2-34a8b4e1cb9f.sql
-rw-r-----  1 clickhouse clickhouse 1.6K Jun  5 08:55 564fe732-d917-1084-98f6-d6f61394aaa6.sql
-rw-rw----  1 clickhouse clickhouse 1.4K Jun  5 08:55 574908ca-5177-3365-8666-73057b7a6d90.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 5a421e9c-9e10-2101-3c6d-9d458b2e838b.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 5b43150e-6b4c-d27a-5772-7554d8e75f93.sql
-rw-r-----  1 clickhouse clickhouse 2.3K Jun  5 08:55 5b49eec8-177c-c8b7-2365-0f7934e9e780.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 5c45ecb5-8f1e-9353-0b9a-17e653aad4ae.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 5c4b13bf-ad75-9878-57d5-2d75b424c0a9.sql
-rw-r-----  1 clickhouse clickhouse 1.1K Jun  5 08:55 5c4e112a-d1ab-4a13-8dd0-b69c1b4785aa.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 5d40a07b-a0bb-30c6-9db3-d52c0dd151a6.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 5d4fea70-ee2f-5821-456e-879f40c2a4b1.sql
-rw-rw----  1 clickhouse clickhouse  663 Jun  5 08:55 5e495497-487f-eb27-8925-c4ad1a73b68a.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 5e4cd3f3-3c84-135b-58b9-8df6cd257c97.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 5e4f86d6-80ef-a21c-f5ad-6d28a0513386.sql
-rw-rw----  1 clickhouse clickhouse  365 Jun  5 08:55 5f4016d8-e1e1-afad-6138-bbced5910bbd.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 5f44c720-38dd-5a97-f359-b9a59a04bf9e.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 5f4ec7b6-61a7-fd78-571e-b6164869f4bb.sql
-rw-rw----  1 clickhouse clickhouse 1.4K Jun  5 08:55 6149138d-705d-33ed-e977-c6fb71f7589d.sql
-rw-rw----  1 clickhouse clickhouse  687 Jun  5 08:55 62417da2-5bed-1c57-28a3-e538efb55597.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 6246b4be-9b8b-1d7a-6272-861e771e27ae.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 63473a02-9fef-522f-0689-b01c25696689.sql
-rw-r-----  1 clickhouse clickhouse 1.7K Jun  5 08:55 6441b83b-7784-87d0-b2d0-d309b43786b5.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 6446c46c-1d78-c657-ef86-629e67a7fa86.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 654e64e3-b3b4-f768-e00f-c0c800cfd3ae.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 6645b256-067c-9a24-821f-365987bf70a8.sql
-rw-rw----  1 clickhouse clickhouse 1.7K Jun  5 08:55 6647913c-339a-8705-ae4b-336f37b9999e.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 664e711b-e4d4-6c49-14b9-3cf40afe7fa5.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 6747dd22-0217-3c92-5089-f654a2201c90.sql
-rw-r-----  1 clickhouse clickhouse 1.8K Jun  5 08:55 68410665-605e-521f-d0d7-a570ad778182.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 6844fab8-64c4-d979-3ffa-f95e65f77fab.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 684db7c2-761d-05d6-b131-d6a81089fd80.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 69424e88-09d1-8770-03e7-4fbdcca4aeb5.sql
-rw-rw----  1 clickhouse clickhouse 1.5K Jun  5 08:55 6a40292f-8c7b-b094-7bec-3a5344657ba8.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 6b444dba-5e7e-dd68-ab8e-0a16149d42bc.sql
-rw-rw----  1 clickhouse clickhouse 1.6K Jun  5 08:55 6b4478fd-81f8-cb7b-326f-9b3e3459a09b.sql
-rw-r-----  1 clickhouse clickhouse 1.1K Jun  5 08:55 6b47cc7a-d98c-9f3c-5d8a-1c60b4147ba3.sql
-rw-r-----  1 clickhouse clickhouse 1.1K Jun  5 08:55 6b4e8723-0b9b-cfc0-8416-1be28fcf32a0.sql
-rw-rw----  1 clickhouse clickhouse   44 Jun  5 08:55 6c4c0a2d-7191-14b9-0eff-e2b57c8d5e84.sql
-rw-r-----  1 clickhouse clickhouse 1.6K Jun  5 08:55 6e4f0d35-7fc7-25fd-87a4-dacac2793fb3.sql
-rw-rw----  1 clickhouse clickhouse 1.3K Jun  5 08:55 6e4fcd16-12ae-474e-7d79-d825209738bc.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 6f4cc0c0-3b6d-cb9d-a324-48242de1098b.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 7045523e-f501-aa5f-9932-dea6c2011482.sql
-rw-r-----  1 clickhouse clickhouse 1.6K Jun  5 08:55 7047b92d-6e35-c795-89d6-3e984282c186.sql
-rw-r-----  1 clickhouse clickhouse 1.1K Jun  5 08:55 7140340c-1b82-e9a6-a319-59c4b53bbbb1.sql
-rw-rw----  1 clickhouse clickhouse 1.3K Jun  5 08:55 71436234-675b-b11f-ecf5-91f48f72d4bb.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 7248c5a4-ef29-4134-99f4-fb87b32b8da7.sql
-rw-rw----  1 clickhouse clickhouse 1.4K Jun  5 08:55 7347b316-ad3a-9958-ef60-5f8c5f05649c.sql
-rw-rw----  1 clickhouse clickhouse 1.3K Jun  5 08:55 744aa7f4-5b76-57dd-e82e-7c966a48c696.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 7544c218-806a-0765-7cba-aab529dd81b3.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 75478b4f-e8de-b251-6b04-446ed9d7c8a2.sql
-rw-rw----  1 clickhouse clickhouse  274 Jun  5 08:55 7645417c-441e-5124-cd68-80505c2e52a0.sql
-rw-rw----  1 clickhouse clickhouse 1.6K Jun  5 08:55 7645c884-f63d-9b0d-2e2f-f63fa00c02b3.sql
-rw-rw----  1 clickhouse clickhouse  276 Jun  5 08:55 784da032-6420-97bf-eea4-92cfb3dd8594.sql
-rw-r-----  1 clickhouse clickhouse 1.1K Jun  5 08:55 79430f0f-5c04-cae1-5bea-0d3e7fad7cbc.sql
-rw-rw----  1 clickhouse clickhouse   16 Jun  5 08:55 794ab9a7-cc63-415c-f37e-89fc55e5a4be.sql
-rw-r-----  1 clickhouse clickhouse 1.1K Jun  5 08:55 7a49c993-5f26-4180-9a11-7407de493584.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 7b4723a2-ade9-f754-8213-4b47e2da4390.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 7d4e463b-84fd-585b-9e98-ef78cbddacbc.sql
-rw-rw----  1 clickhouse clickhouse  246 Jun  5 08:55 7e450842-1ccd-7b8f-31d7-2c912b6177ba.sql
-rw-rw----  1 clickhouse clickhouse  767 Jun  5 08:55 7f41da0f-8b8d-8b98-129f-2734eaf5a591.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 7f4c3d09-352b-4f18-3783-47b35663dcbe.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 7f4eec2f-aaf4-6799-941f-fe90588e2f8e.sql
-rw-r-----  1 clickhouse clickhouse 1.1K Jun  5 08:55 8040162f-c63f-059d-83c6-468513f7f996.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 814804fe-213d-e393-e7f7-7ee6a6624993.sql
-rw-rw----  1 clickhouse clickhouse  719 Jun  5 08:55 814f2834-815c-0717-09ce-a6b6059e4094.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 8244c1fc-e9a0-6288-06dc-d48c51143d85.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 82479fe7-4091-f2dc-7f53-0d64cca28891.sql
-rw-r-----  1 clickhouse clickhouse 1.6K Jun  5 08:55 824df54f-75a9-a5dd-a56b-ff7f06410bae.sql
-rw-rw----  1 clickhouse clickhouse 1.2K Jun  5 08:55 834ec765-eb18-f63b-f0b5-8ec65ae42e8f.sql
-rw-rw----  1 clickhouse clickhouse 1.9K Jun  5 08:55 86402c53-a5ba-138f-f7e6-1efe927f4194.sql
-rw-r-----  1 clickhouse clickhouse  901 Jun  5 08:55 864ad7db-5fb0-05de-44d8-21c3da39d9a9.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 864bc412-ee6d-f78f-f849-2439cc2ef797.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 864c313b-e41e-d85e-8736-fdb1abe1ca86.sql
-rw-r-----  1 clickhouse clickhouse 1.7K Jun  5 08:55 864cf599-7f4e-0d72-0b18-3b23b821f597.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 8741fbff-0ca4-2fed-e0e5-257a91ae0884.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 87444ea2-5894-7bdf-d548-7b7a20475cbc.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 874f0307-9005-0eb7-04fb-5e75c7e96fac.sql
-rw-r-----  1 clickhouse clickhouse 1.7K Jun  5 08:55 88410ba9-0421-cb85-3638-4cd76215a085.sql
-rw-rw----  1 clickhouse clickhouse  679 Jun  5 08:55 884cdcbc-df1c-80cb-2185-a768be5f6aa4.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 884f0ed3-e9b4-87f6-0d93-d02dd341aa88.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 894b8559-d947-ac0d-976e-e891a26fb294.sql
-rw-r-----  1 clickhouse clickhouse  143 Jun  5 08:55 8c410b6c-bb9b-fb25-216d-457fe626a9a2.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 8c4e79b9-df64-4a4d-9617-04ed526e2982.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 8e42ee5a-e52e-3f65-42b5-c0e3290fbaa7.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 8e43e11f-a1d4-13e7-7a33-6b7b190cecaf.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 8f406d9e-c879-325c-660c-0a1613ad7d8f.sql
-rw-rw----  1 clickhouse clickhouse 1.9K Jun  5 08:55 8f4fed72-eeb4-ca00-a103-4ddda1389996.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 9040b423-10f0-e4b9-993f-838cb0c98ba8.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 9041cf67-789d-957b-b965-c510c84596bd.sql
-rw-r-----  1 clickhouse clickhouse  946 Jun  5 08:55 9141e8d3-2f73-48ba-0dfb-2c0496557bae.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 91429f6f-bb31-8d5e-5318-b1a84237839d.sql
-rw-rw----  1 clickhouse clickhouse 1.3K Jun  5 08:55 914a12bb-908e-8d3a-2deb-f53ac0acf0b9.sql
-rw-r-----  1 clickhouse clickhouse 1.1K Jun  5 08:55 934ce50e-65a9-37a9-0013-5db4645b808c.sql
-rw-rw----  1 clickhouse clickhouse 1.7K Jun  5 08:55 94400bb3-4406-9db3-f99d-afac05741fa8.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 954c2563-1c9d-a369-152f-ee5e939c9e86.sql
-rw-r-----  1 clickhouse clickhouse 1.6K Jun  5 08:55 9649b5ee-c852-3752-f3f7-117ffd81b198.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 964d212f-e6ad-a29f-56be-9b5e670d9483.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 974b7b7a-de49-62b8-9680-f56d1fd9a9ba.sql
-rw-rw----  1 clickhouse clickhouse 1.5K Jun  5 08:55 98423570-552b-b67a-e91b-92198d366eb5.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 9844a2da-3a6a-9384-0877-7a6fd9918fad.sql
-rw-rw----  1 clickhouse clickhouse  171 Jun  5 08:55 9945391c-cc5f-d995-18b9-cf80d29dd292.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 99454b04-4cda-2dcf-441c-3f263fd56098.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 994bb21b-f971-eb59-875d-bd1cdaf2029f.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 9a40a603-e75c-c051-cae3-cb8b4c79018a.sql
-rw-rw----  1 clickhouse clickhouse   87 Jun  5 08:55 9c457afb-6b9f-d1ae-7f51-854373fb7381.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 9d4dfa9e-ea32-8a92-fa56-b2a6e7f3ceb0.sql
-rw-rw----  1 clickhouse clickhouse  260 Jun  5 08:55 9f4aeaef-bb3f-0b8d-41cb-7308d26652b4.sql
-rw-r-----  1 clickhouse clickhouse 1.1K Jun  5 08:55 a1443464-beff-ef50-2893-c045e0944183.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 a148656b-1523-0215-1803-c72a867a3d9d.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 a241378a-5846-b079-cf56-542ba393da99.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 a2427c50-a72c-198e-3da8-73381aa02f8c.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 a2434891-d0f7-12b6-7f94-16620aebbaac.sql
-rw-rw----  1 clickhouse clickhouse  899 Jun  5 08:55 a3433b33-d00d-4acc-330a-abaf18db03b2.sql
-rw-r-----  1 clickhouse clickhouse  228 Jun  5 08:55 a3485fe1-0edf-58a1-e11a-421982a5b591.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 a444f310-589a-81ab-5a79-52176df19caf.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 a44d49f1-5d8e-4a74-daca-f196b47144b4.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 a6462872-ebd3-9401-ea03-a1031ff9259e.sql
-rw-rw----  1 clickhouse clickhouse 1.9K Jun  5 08:55 a74b0b20-9a00-e5af-0595-c2554deeaca7.sql
-rw-r-----  1 clickhouse clickhouse 1.6K Jun  5 08:55 a843bad5-1567-4f7c-b84e-fdadbfda5783.sql
-rw-rw----  1 clickhouse clickhouse  695 Jun  5 08:55 a847ce52-6095-72c9-3b06-4669cb9e1799.sql
-rw-rw----  1 clickhouse clickhouse 1.4K Jun  5 08:55 a94dfb25-3604-e445-3545-411a5b37e0a6.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 aa4c0595-fa1b-bd71-fd7a-22930c6d818c.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 aa4fccbf-0502-a3dc-5c9a-35788c1572b8.sql
-rw-rw----  1 clickhouse clickhouse  775 Jun  5 08:55 ab42a05f-05a5-c3a0-ab8d-317628e463ac.sql
-rw-rw----  1 clickhouse clickhouse 1.6K Jun  5 08:55 ab444692-80a0-941a-9504-5c17574c728d.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 ab45d55b-daf7-e9e4-edf9-20e1241a07b9.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 ab4b847e-69ad-9305-d846-1fdfc2e97e96.sql
-rw-rw----  1 clickhouse clickhouse 1.7K Jun  5 08:55 ad410450-1c54-f2d2-45d4-d2c5faf942b1.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 ad42bad1-f4a0-8349-9d68-2e8500f9d19b.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 ad4325b4-a04f-89f8-2d04-c6865b5d4491.sql
-rw-r-----  1 clickhouse clickhouse 1.7K Jun  5 08:55 ad4a0b4e-d2af-748c-c32f-d920ad050683.sql
-rw-r-----  1 clickhouse clickhouse 1.6K Jun  5 08:55 ae4f56c7-c047-6401-acf5-bc57c25b21b1.sql
-rw-rw----  1 clickhouse clickhouse  281 Jun  5 08:55 af4ada06-f5b6-cf1b-ddc8-8f8cfe1404a5.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 b1421016-e2df-c3e1-89d0-4e99623f40a2.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 b142150f-918b-4f33-b494-58fab906b7ac.sql
-rw-rw----  1 clickhouse clickhouse  246 Jun  5 08:55 b14b610b-bb60-a9d7-89d6-9f8c6d8a2e8c.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 b14bf19c-5f56-c4a6-7501-c5ec55ebfb80.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 b2449753-a7f7-b4eb-279a-4e12f9af8383.sql
-rw-r-----  1 clickhouse clickhouse 1.1K Jun  5 08:55 b2458c7e-166e-d1f4-9228-1d4200724bbd.sql
-rw-rw----  1 clickhouse clickhouse  981 Jun  5 08:55 b245ecd4-82a8-cc63-2622-7d2a9e80469b.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 b449e038-916e-1d98-c0cd-0f312b641cb2.sql
-rw-r-----  1 clickhouse clickhouse 1.1K Jun  5 08:55 b44e2c49-ab66-3162-2b2e-d42d374dfc9f.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 b5400d8c-bf93-ae19-0f38-a805ba37d683.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 b5492ce5-32fc-791e-0f0c-acd4e4de0397.sql
-rw-r-----  1 clickhouse clickhouse 1.1K Jun  5 08:55 b748591c-18b6-5951-03ae-b36275defbb4.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 b74e3b03-cedf-8a9b-fa06-e1af48c08594.sql
-rw-rw----  1 clickhouse clickhouse  791 Jun  5 08:55 b8442627-943a-e1bd-c930-e441fc019993.sql
-rw-rw----  1 clickhouse clickhouse 2.4K Jun  5 08:55 b9429447-2d81-f937-1e97-615455f8b897.sql
-rw-r-----  1 clickhouse clickhouse 1.8K Jun  5 08:55 b945acf2-e4b0-13bf-def5-d117804a9183.sql
-rw-r-----  1 clickhouse clickhouse 1.9K Jun  5 08:55 b94afa8a-0505-ef2f-9f05-ad482c6c06b5.sql
-rw-rw----  1 clickhouse clickhouse  344 Jun  5 08:55 ba4c5e69-2564-c174-370a-4dd174260b81.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 bc40c5ea-ccfa-fcd6-c3da-fdba3eb34d82.sql
-rw-rw----  1 clickhouse clickhouse 1.6K Jun  5 08:55 bc4699c4-e003-05e7-e91a-e858d423a286.sql
-rw-rw----  1 clickhouse clickhouse  372 Jun  5 08:55 bc47a4af-eb69-ada0-6c51-af8beb1b158f.sql
-rw-r-----  1 clickhouse clickhouse 1.1K Jun  5 08:55 bc489d58-e8f7-1932-0741-04e9d46e209f.sql
-rw-r-----  1 clickhouse clickhouse 1.7K Jun  5 08:55 bd45ec68-3891-c681-9dcd-dd762c9f7c90.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 be4aad52-7797-677b-64d7-ee34972ab490.sql
-rw-rw----  1 clickhouse clickhouse 3.2K Jun  5 08:55 bf49040b-c082-4995-ac56-1ada31aa2492.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 c049e464-5165-4144-8739-66b5810431a7.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 c24383bc-bdb9-af67-3b72-14565fffae92.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 c24c6be5-99ba-415d-9cf2-b1d9b1b44b95.sql
-rw-r-----  1 clickhouse clickhouse 1.7K Jun  5 08:55 c34ec86e-a20d-a369-183d-eeaae2c5b0b7.sql
-rw-rw----  1 clickhouse clickhouse  703 Jun  5 08:55 c445d203-403a-2b15-3794-5cfd28afee8e.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 c4477c6e-88da-b497-50e0-f6d2cef31fa9.sql
-rw-r-----  1 clickhouse clickhouse 1.6K Jun  5 08:55 c645738c-f06b-c25c-0ab5-9388d741a881.sql
-rw-r-----  1 clickhouse clickhouse 1.6K Jun  5 08:55 c64820a8-e7a6-c376-a890-399bbe23ee94.sql
-rw-r-----  1 clickhouse clickhouse  143 Jun  5 08:55 c84a367b-321d-5ea4-c465-39a33b666cb8.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 c946821b-5fab-f91d-379d-a736bc8356a5.sql
-rw-rw----  1 clickhouse clickhouse   30 Jun  5 08:55 c949137a-3051-33a9-bc97-0c82f67428a5.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 c9495c9d-bb3c-a0d9-b107-575f382ab3b0.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 c94a4393-2638-8acb-0b21-8102e86c77ae.sql
-rw-rw----  1 clickhouse clickhouse 1.4K Jun  5 08:55 cb41b723-3ac8-f527-92d1-ab34bda9b7ab.sql
-rw-r-----  1 clickhouse clickhouse 1.1K Jun  5 08:55 cb42ef20-c858-0f54-52d0-2acc5ed54db2.sql
-rw-rw----  1 clickhouse clickhouse 1.5K Jun  5 08:55 cb475803-c2e1-8320-ed1d-dcee31fab584.sql
-rw-r-----  1 clickhouse clickhouse 1.7K Jun  5 08:55 cb4e3ff5-edd6-7920-adce-5aca44a7f784.sql
-rw-rw----  1 clickhouse clickhouse  372 Jun  5 08:55 cd454b5e-bf01-0c9a-7d3d-6eafe06e8f89.sql
-rw-r-----  1 clickhouse clickhouse   25 Jun  5 08:55 ce42f0c8-9605-3f98-8bef-8267993e51a3.sql
-rw-rw----  1 clickhouse clickhouse 1.5K Jun  5 08:55 ce45850d-560a-744b-3812-bb51e361d08f.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 ce45a44f-acce-a108-300e-096b3140eaa2.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 cf40a909-8a84-24f8-3f21-972c00e35795.sql
-rw-rw----  1 clickhouse clickhouse 7.7K Jun  5 08:55 cf419d9d-ad40-a2a9-be12-750a829c7c92.sql
-rw-rw----  1 clickhouse clickhouse  34K Jun  5 08:55 d14f8840-1f74-cfe7-9b47-9f8abb0cda9c.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 d2473740-3074-7fcd-e325-d4accf47e1af.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 d24cd79e-5609-a57f-2a18-baddf70fdda7.sql
-rw-rw----  1 clickhouse clickhouse 1.3K Jun  5 08:55 d341934f-9d12-a583-6a09-8a50b32ef29f.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 d3462488-7093-4998-5189-69a9303c4f83.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 d440af32-4968-2c4a-4b5d-18cb4ab7a987.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 d4497d0a-1d66-b5da-d0bc-e606e5a06ebe.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 d5434061-02b4-bcbe-769a-d35ea2651dbe.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 d5470dfe-1335-1e75-4a2a-090015e40da1.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 d74a7aff-be67-4628-e3e5-fe8d33936480.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 d840141f-cd03-aba7-9945-eb543f571cb1.sql
-rw-r-----  1 clickhouse clickhouse 1.8K Jun  5 08:55 d847e52d-3498-bcb4-11e0-2de714076a96.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 d9486ad0-ab5a-8496-ce8e-4e8597fd96b3.sql
-rw-r-----  1 clickhouse clickhouse 1.7K Jun  5 08:55 db470138-ceb2-9541-6d80-86b63f24cf8d.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 dc49ee58-8de6-0f8e-9aa1-6b7e0b8e86b1.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 de4489f2-fd74-1116-d0f4-686f0590098e.sql
-rw-rw----  1 clickhouse clickhouse 1.3K Jun  5 08:55 de4ee6fa-e7de-76ef-5b74-51edfec24b82.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 df4248dc-91c9-3094-911b-2e3058c9ea91.sql
-rw-r-----  1 clickhouse clickhouse 2.3K Jun  5 08:55 df481e6f-ce35-fcc5-7993-67ff19b1179b.sql
-rw-rw----  1 clickhouse clickhouse  288 Jun  5 08:55 df49e239-7c37-eb0c-c61a-081c01d3b999.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 e04ff25b-844b-6999-e053-f890ed36b28e.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 e24893d7-fdc6-598d-dceb-2e03e98daf80.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 e444fb92-5b9b-8e44-9a55-2cff97d25abf.sql
-rw-r-----  1 clickhouse clickhouse 1.6K Jun  5 08:55 e446fbe1-ace8-63f3-3c5d-8c9c46c3cc8f.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 e44e84d9-b82c-19c2-4050-d4670d9b2292.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 e6438556-b636-0311-0690-a42fb3a226ab.sql
-rw-rw----  1 clickhouse clickhouse   16 Jun  5 08:55 e644ab0d-4c5e-db07-6a52-ac6560212fb5.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 e7482da8-ec5a-0043-8616-2689433ef594.sql
-rw-rw----  1 clickhouse clickhouse 1.8K Jun  5 08:55 e74f80db-c44a-8503-ef84-88956ec3c885.sql
-rw-rw----  1 clickhouse clickhouse  13K Jun  5 08:55 e84d3616-ea71-e924-9237-9e9b534209a9.sql
-rw-r-----  1 clickhouse clickhouse 1.2K Jun  5 08:55 e9458813-996e-0e6e-8973-3bbfb847d895.sql
-rw-r-----  1 clickhouse clickhouse  948 Jun  5 08:55 ea4697a2-dbf1-0dbc-3e6a-24f6ba8bfdb5.sql
-rw-rw----  1 clickhouse clickhouse  695 Jun  5 08:55 eb47f40e-5771-58cf-169d-03d54b622f85.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 ee46b299-40d9-bd70-5ab5-8e618cc3208e.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 ef4cd240-37da-59f3-4058-8be09857fd89.sql
-rw-rw----  1 clickhouse clickhouse  751 Jun  5 08:55 f04644e3-8284-a41d-22f1-5615d0d28bab.sql
-rw-rw----  1 clickhouse clickhouse 1.8K Jun  5 08:55 f04cd754-3f55-fa7a-d3a5-a347850ed483.sql
-rw-r-----  1 clickhouse clickhouse 3.4K Jun  5 08:55 f1416128-7640-9df4-b2ba-5e02ce4f5aa4.sql
-rw-rw----  1 clickhouse clickhouse 1.2K Jun  5 08:55 f2402363-73af-3974-80fc-86b1e561efaa.sql
-rw-rw----  1 clickhouse clickhouse 1.7K Jun  5 08:55 f24d8364-23e8-b613-77e3-431245ea83a4.sql
-rw-rw----  1 clickhouse clickhouse 1.5K Jun  5 08:55 f64f9c29-1a56-78f9-8ff3-f33ccb7edc88.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 f943fa51-d325-2982-8f97-0a504076c8b5.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 fa4d276f-29db-6b87-7df8-032889f2f3bd.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 fb40b0ed-f87e-5baa-788c-117ae3ab45a6.sql
-rw-rw----  1 clickhouse clickhouse 1.3K Jun  5 08:55 fb438a09-2898-07e1-d5e3-883a8376f1a6.sql
-rw-rw----  1 clickhouse clickhouse 1.2K Jun  5 08:55 fc41edb4-46eb-618a-3634-fe35a5f862bd.sql
-rw-r-----  1 clickhouse clickhouse 1.6K Jun  5 08:55 fc4a7fa3-5bcd-a72f-7d99-33a03be3c8b9.sql
-rw-r-----  1 clickhouse clickhouse 1.3K Jun  5 08:55 fd43c65f-0627-3614-5b25-0d86289054a9.sql
-rw-r-----  1 clickhouse clickhouse 1.5K Jun  5 08:55 fd457bf5-8602-9a91-cbe1-d0aab5fbeb93.sql
-rw-r-----  1 clickhouse clickhouse 1.4K Jun  5 08:55 fe4ec9bc-bf39-45c5-7da8-7499fbc3119c.sql
-rw-rw----  1 clickhouse clickhouse  711 Jun  5 08:55 ff427703-e1c0-92e2-2f69-4b474e80dcbf.sql
-rw-r-----  1 clickhouse clickhouse    1 Jun  5 09:03 quotas.list
-rw-r-----  1 clickhouse clickhouse 3.1K Jun  5 09:03 roles.list
-rw-r-----  1 clickhouse clickhouse    1 Jun  5 09:03 row_policies.list
-rw-r-----  1 clickhouse clickhouse   52 Jun  5 09:03 settings_profiles.list
-rw-r-----  1 clickhouse clickhouse  13K Jun  5 09:09 users.list

@VladislavePolyakov
Copy link
Author

it happen when run --rbac again, when users already exists, on first run no errors

@Slach
Copy link
Collaborator

Slach commented Jun 5, 2024

ok. could you share

grep "ATTACH USER" -r /var/lib/clickhouse/backup/backup_name/access/ | grep ivanov
without sensitive password related data?

@Slach
Copy link
Collaborator

Slach commented Jun 5, 2024 •
edited
Loading

it happen when run --rbac again, when users already exists

This is a bit weird, actually
if your user contains dot in name
then a whole username should be quoted in backticks in *.sql file

could you also share?
grep version /var/lib/clickhouse/backup/backup_name/metadata.json

@Slach Slach closed this as completed in 03f3387 Jun 5, 2024
Slach added a commit that referenced this issue Jul 3, 2024
@Slach
fix restore --rbac behavior when RBAC objects contains -, . or …
587e3ae 
…any special characters new fix #930
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Slach Slach

Labels
None yet
Projects
None yet
Milestone
2.5.13
Development

No branches or pull requests
2 participants
@Slach @VladislavePolyakov