I have clickhouse cluster with 2 shard 1 replicated, when i run clickhouse-backup has error

[cntsp]

./clickhouse-backup --config config.yml create tables 2021/08/31 03:28:42 error cat't get tables from clickhouse: code: 999, message: Session expired (Session expired): While executing Tables

The clickhouse cluster has 3 clickhouse instances of docker deploying(shard1 \shard2\replicated1), the some tables engine of is distributed. about the parts configuration of the cluster's config.xml

[Slach]

could you share LOG_LEVEL=debug ./clickhouse-backup --config config.yml create test_backup result?

[cntsp]

LOG_LEVEL=debug ./clickhouse-backup --config config.yml tables 2021/08/31 07:21:37 debug SELECT count() FROM system.settings WHERE name = 'show_table_uuid_in_table_create_query_if_not_nil' 2021/08/31 07:21:37 debug SELECT * FROM system.tables WHERE is_temporary = 0 SETTINGS show_table_uuid_in_table_create_query_if_not_nil=1 2021/08/31 07:21:37 error can't get tables: code: 999, message: Session expired (Session expired): While executing Tables

[Slach]

could you share the results of

SELECT name, engine FROM system.databases WHERE name !='system'

?

[Slach]

also, could you try to use alexakulov/clickouse-backup:master docker image instead of standalone binary?

[cntsp]

[Slach]

is SELECT * FROM system.tables WHERE is_temporary = 0 SETTINGS show_table_uuid_in_table_create_query_if_not_nil=1 works from clickhouse-client ?

[cntsp]

dev8 :) SELECT * FROM system.tables WHERE is_temporary = 0 SETTINGS show_table_uuid_in_table_create_query_if_not_nil=1

SELECT * FROM system.tables WHERE is_temporary = 0 SETTINGS show_table_uuid_in_table_create_query_if_not_nil = 1

Query id: 19c8ec72-eb87-4773-b56f-2a734440fc4b

Received exception from server (version 20.11.4): Code: 999. DB::Exception: Received from localhost:9000. DB::Exception: Session expired (Session expired): While executing Tables.

0 rows in set. Elapsed: 0.406 sec.

[Slach]

let's try to execute

SELECT engine, name FROM system.tables WHERE engine NOT LIKE  '%MergeTree' AND is_temporary = 0

[cntsp]

Excuse me, I need to make some marks！

[Slach]

ok. let's try to do something like this to detect which table is root cause of error:

clickhouse-client -mn --echo <$( clickhouse-client -q "SELECT concat('SELECT * FROM system.tables WHERE name=\\'',name,'\\' AND is_temporary = 0 SETTINGS show_table_uuid_in_table_create_query_if_not_nil=1') FROM system.tables WHERE is_temporary = 0 " )

[cntsp]

Sorry, I need to make some marks！

[cntsp]

sh: 2: cannot open SELECT * FROM system.tables WHERE name=\'.inner.daf2_local_batch\' AND is_temporary = 0 SETTINGS show_table_uuid_in_table_create_query_if_not_nil=1 Is the table .inner.daf2_local_batch root cause of error?

[Slach]

no, I don't think so ;) sorry for a little bit bash misleads try to run

clickhouse-client -q "SELECT concat('SELECT * FROM system.tables WHERE database=',char(0x27),database,char(0x27),' AND name=',char(0x27),name,char(0x27),' AND is_temporary = 0 SETTINGS show_table_uuid_in_table_create_query_if_not_nil=1 FORMAT Vertical;') FROM system.tables WHERE is_temporary = 0 FORMAT TSVRaw" | clickhouse-client -mn --echo

and share the results

[Slach]

@cntsp is the issue still relevant for you? Did you try the latest releases 1.1.0+?

Let's close issue, during inactivity, feel free to reopen if necessary