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.

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

21.11 unable to start: Cannot attach 1 tables due to cyclic dependencies #31315

Closed
den-crane opened this issue Nov 11, 2021 · 1 comment · Fixed by #32288
Closed

21.11 unable to start: Cannot attach 1 tables due to cyclic dependencies #31315

den-crane opened this issue Nov 11, 2021 · 1 comment · Fixed by #32288
Assignees
Labels

Comments

@den-crane
Copy link
Contributor

den-crane commented Nov 11, 2021

21.11.3.6

cat /etc/clickhouse-server/node.tsv
1,test

cat /etc/clickhouse-server/node_dictionary.xml
<dictionaries>
    <dictionary>
        <name>node</name>
        <source>
            <file>
                <path>/etc/clickhouse-server/node.tsv</path>
                <format>CSV</format>
            </file>
        </source>
        <lifetime>0</lifetime>
        <layout><flat /></layout>
        <structure>
            <id><name>key</name></id>
            <attribute>
                <name>name</name>
                <type>String</type>
                <null_value></null_value>
            </attribute>
        </structure>
    </dictionary>
</dictionaries>

create table default.node ( key UInt64, name String ) Engine=Dictionary(node);

select * from default.node;
┌─key─┬─name─┐
│   1 │ test │
└─────┴──────┘

/etc/init.d/clickhouse-server restart

<Error> Application: DB::Exception: Cannot attach 1 tables due to cyclic dependencies. See server log for details.
<Information> Application: shutting down
@den-crane den-crane added potential bug To be reviewed by developers and confirmed/rejected. comp-dictionary Dictionaries v21.1-affected and removed v21.1-affected labels Nov 11, 2021
@tavplubix tavplubix self-assigned this Nov 12, 2021
@tavplubix
Copy link
Member

Workaround:
add <ignore_table_dependencies_on_metadata_loading> to the config.xml, it will disable dependencies check

@alexey-milovidov alexey-milovidov added minor Priority: minor unexpected behaviour and removed potential bug To be reviewed by developers and confirmed/rejected. labels Nov 12, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants