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

Received signal Segmentation fault (11) when ALTER TABLE for dictionary #33251

Closed
infisamk opened this issue Dec 28, 2021 · 0 comments · Fixed by #33261
Closed

Received signal Segmentation fault (11) when ALTER TABLE for dictionary #33251

infisamk opened this issue Dec 28, 2021 · 0 comments · Fixed by #33261
Assignees
Labels
crash Crash / segfault / abort

Comments

@infisamk
Copy link

Clickhouse server drops when I send ALTER TABLE request with COMMENT COLUMN for DICTIONARY.

I know the request is incorrect. But instead of returning the error, the server simply stops working.

Server version: (version 21.12.2.17 (official build))

Reproduce:

  1. Create any dictionary. Example:
CREATE DICTIONARY stores (
    storeId UInt64,
    storeName String,
    shopId UInt32,
    status UInt8,
    lat Float32,
    lon Float32,
    address String,
    storeCountry String,
    storeRegion String,
    storeCity String,
    city_id UInt32,
    email String,
    storeParams String
)
PRIMARY KEY storeId
SOURCE(MYSQL(
    port 3306
    user 'user'
    password 'pass'
    replica(host '10.20.20.12' priority 1)
    db 'db'
    table 'stores'
))
LAYOUT(FLAT())
LIFETIME(300);
  1. Send ALTER TABLE for this dictionary. Example:
ALTER TABLE stores COMMENT COLUMN storeId 'any comment';
2021.12.28 09:17:05.578111 [ 251 ] {} <Fatal> BaseDaemon: ########################################
2021.12.28 09:17:05.582661 [ 251 ] {} <Fatal> BaseDaemon: (version 21.12.2.17 (official build), build id: 29EDA0CC01FD10E7) (from thread 96) (query_id: 780d68be-8e65-43c5-b454-0af77e7264a8) Received signal Segmentation fault (11)
2021.12.28 09:17:05.591963 [ 251 ] {} <Fatal> BaseDaemon: Address: 0x18 Access: read. Address not mapped to object.
2021.12.28 09:17:05.599694 [ 251 ] {} <Fatal> BaseDaemon: Stack trace: 0x12b47423 0x12b46d9b 0x12b251ca 0x1362c344 0x12f480b7 0x12f45d52 0x134cff90 0x134d341c 0x13d3426e 0x13d389c7 0x13f9b38a 0x16ee23af 0x16ee4801 0x16ff3589 0x16ff0c80 0x7f14c5f93609 0x7f14c5eba293
2021.12.28 09:17:05.607719 [ 251 ] {} <Fatal> BaseDaemon: 2. void DB::IAST::replace<DB::ASTExpressionList>(DB::ASTExpressionList*&, std::__1::shared_ptr<DB::IAST> const&) @ 0x12b47423 in /usr/bin/clickhouse
2021.12.28 09:17:05.614280 [ 251 ] {} <Fatal> BaseDaemon: 3. DB::applyMetadataChangesToCreateQuery(std::__1::shared_ptr<DB::IAST> const&, DB::StorageInMemoryMetadata const&) @ 0x12b46d9b in /usr/bin/clickhouse
2021.12.28 09:17:05.620176 [ 251 ] {} <Fatal> BaseDaemon: 4. DB::DatabaseOrdinary::alterTable(std::__1::shared_ptr<DB::Context const>, DB::StorageID const&, DB::StorageInMemoryMetadata const&) @ 0x12b251ca in /usr/bin/clickhouse
2021.12.28 09:17:05.629057 [ 251 ] {} <Fatal> BaseDaemon: 5. DB::IStorage::alter(DB::AlterCommands const&, std::__1::shared_ptr<DB::Context const>, std::__1::unique_lock<std::__1::timed_mutex>&) @ 0x1362c344 in /usr/bin/clickhouse
2021.12.28 09:17:05.634461 [ 251 ] {} <Fatal> BaseDaemon: 6. DB::InterpreterAlterQuery::executeToTable(DB::ASTAlterQuery const&) @ 0x12f480b7 in /usr/bin/clickhouse
2021.12.28 09:17:05.644173 [ 251 ] {} <Fatal> BaseDaemon: 7. DB::InterpreterAlterQuery::execute() @ 0x12f45d52 in /usr/bin/clickhouse
2021.12.28 09:17:05.651961 [ 251 ] {} <Fatal> BaseDaemon: 8. ? @ 0x134cff90 in /usr/bin/clickhouse
2021.12.28 09:17:05.661756 [ 251 ] {} <Fatal> BaseDaemon: 9. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, std::__1::shared_ptr<DB::Context>, std::__1::function<void (std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&)>, std::__1::optional<DB::FormatSettings> const&) @ 0x134d341c in /usr/bin/clickhouse
2021.12.28 09:17:05.673192 [ 251 ] {} <Fatal> BaseDaemon: 10. DB::HTTPHandler::processQuery(DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::__1::optional<DB::CurrentThread::QueryScope>&) @ 0x13d3426e in /usr/bin/clickhouse
2021.12.28 09:17:05.682933 [ 251 ] {} <Fatal> BaseDaemon: 11. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x13d389c7 in /usr/bin/clickhouse

Full logs:
clickhouse-server.log
clickhouse-server.err.log

@infisamk infisamk added the potential bug To be reviewed by developers and confirmed/rejected. label Dec 28, 2021
@kitaisreal kitaisreal self-assigned this Dec 28, 2021
@alexey-milovidov alexey-milovidov added crash Crash / segfault / abort and removed potential bug To be reviewed by developers and confirmed/rejected. labels Dec 28, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
crash Crash / segfault / abort
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants