Skip to content

Enable ThreadFuzzer with random migrations#9516

Closed
alexey-milovidov wants to merge 22 commits intomasterfrom
thread-fuzzer-random-migrations
Closed

Enable ThreadFuzzer with random migrations#9516
alexey-milovidov wants to merge 22 commits intomasterfrom
thread-fuzzer-random-migrations

Conversation

@alexey-milovidov
Copy link
Copy Markdown
Member

@alexey-milovidov alexey-milovidov commented Mar 4, 2020

Changelog category (leave one):

  • Non-significant (changelog entry is not required)

Detailed description / Documentation draft:
Not intended for merge. Only to run CI tests and catch a fire.

@alexey-milovidov alexey-milovidov added the pr-not-for-changelog This PR should not be mentioned in the changelog label Mar 4, 2020
@alexey-milovidov
Copy link
Copy Markdown
Member Author

alexey-milovidov commented Mar 7, 2020

Nice catch!
https://clickhouse-test-reports.s3.yandex.net/9516/27fba2278b3222198f6bb153475eb59a35b33855/functional_stateless_tests_(thread)/stderr.log

@alexey-milovidov alexey-milovidov mentioned this pull request Mar 7, 2020
Merged
@alexey-milovidov
Copy link
Copy Markdown
Member Author

alexey-milovidov commented Mar 12, 2020

No more issues found.
We can selectively enable fuzzer for specific types of builds (functional tests with thread sanitizer).

@alexey-milovidov alexey-milovidov mentioned this pull request May 18, 2020
Merged
@alexey-milovidov
Copy link
Copy Markdown
Member Author

alexey-milovidov commented May 18, 2020

Bad test has been found: #10989

@alexey-milovidov
Copy link
Copy Markdown
Member Author

alexey-milovidov commented May 18, 2020

For unknown reason, it took 12 minutes starting odbc-bridge and it does not response in next second.

@alexey-milovidov alexey-milovidov mentioned this pull request May 18, 2020
Merged
@alexey-milovidov alexey-milovidov mentioned this pull request Jul 5, 2020
Closed
@alexey-milovidov
Copy link
Copy Markdown
Member Author

alexey-milovidov commented Sep 16, 2020

Found flaky tests: 01133_max_result_rows, 01474_executable_dictionary.

@azat
Copy link
Copy Markdown
Member

azat commented Sep 17, 2020

Functional stateless tests (debug) — fail: 1, passed: 2247, skipped: 15

#14957

@azat azat mentioned this pull request Sep 20, 2020
Merged
@alexey-milovidov alexey-milovidov mentioned this pull request Dec 23, 2020
Merged
@vdimir vdimir mentioned this pull request Jan 21, 2021
Merged
@qoega
Copy link
Copy Markdown
Member

qoega commented May 14, 2021

@Mergifyio update

@mergify
Copy link
Copy Markdown
Contributor

mergify bot commented May 14, 2021

Command update: success

Branch has been successfully updated

@nikitamikhaylov
Copy link
Copy Markdown
Member

nikitamikhaylov commented May 27, 2021

@Mergifyio update

@mergify
Copy link
Copy Markdown
Contributor

mergify bot commented May 27, 2021

Command update: success

Branch has been successfully updated

@qoega
Copy link
Copy Markdown
Member

qoega commented Jun 12, 2021

@Mergifyio update

@mergify
Copy link
Copy Markdown
Contributor

mergify bot commented Jun 12, 2021

Command update: success

Branch has been successfully updated

@qoega
Copy link
Copy Markdown
Member

qoega commented Jun 15, 2021

01275_alter_rename_column_default_expr looks like something is bad:

2021-06-12 15:43:31 01275_alter_rename_column_default_expr:                                 [ FAIL ] 0.68 sec. - return code 85
2021-06-12 15:43:31 [3407811b5850] 2021.06.12 15:43:31.087853 [ 5694 ] {b8ae2bbc-c277-4642-99fa-167b69562695} <Error> void DB::StorageMergeTree::waitForMutation(DB::Int64, const DB::String &): Code: 341, e.displayText() = DB::Exception: Exception happened during execution of mutation 'mutation_10.txt' with part '20191001_1_1_0_9' reason: 'Code: 47, e.displayText() = DB::Exception: Missing columns: 'value2' while processing query: 'value3, key, value3, date, value1, value2', required columns: 'value3' 'date' 'key' 'value1' 'value2', maybe you meant: ['value3','date','key','value1','value2'] (version 21.7.1.7144)'. This error maybe retryable or not. In case of unretryable error, mutation can be killed with KILL MUTATION query, Stack trace (when copying this message, always include the lines below):
2021-06-12 15:43:31 
2021-06-12 15:43:31 0. DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int, bool) @ 0x8d8649a in /usr/lib/debug/.build-id/64/054935534e653e4f6d0e6d5773703f0e92fca7.debug
2021-06-12 15:43:31 1. DB::Exception::Exception<char const*, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >&>(int, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, char const*&&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >&&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >&) @ 0x104faee3 in /usr/lib/debug/.build-id/64/054935534e653e4f6d0e6d5773703f0e92fca7.debug
2021-06-12 15:43:31 2. DB::checkMutationStatus(std::__1::optional<DB::MergeTreeMutationStatus>&, std::__1::set<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::less<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&) @ 0x104fad60 in /usr/lib/debug/.build-id/64/054935534e653e4f6d0e6d5773703f0e92fca7.debug
2021-06-12 15:43:31 3. DB::StorageMergeTree::waitForMutation(long, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) @ 0x1010ddff in /usr/lib/debug/.build-id/64/054935534e653e4f6d0e6d5773703f0e92fca7.debug
2021-06-12 15:43:31 4. DB::StorageMergeTree::alter(DB::AlterCommands const&, std::__1::shared_ptr<DB::Context const>, std::__1::shared_ptr<DB::RWLockImpl::LockHolderImpl>&) @ 0x1010cdd6 in /usr/lib/debug/.build-id/64/054935534e653e4f6d0e6d5773703f0e92fca7.debug
2021-06-12 15:43:31 5. DB::InterpreterAlterQuery::execute() @ 0xf9403ac in /usr/lib/debug/.build-id/64/054935534e653e4f6d0e6d5773703f0e92fca7.debug
2021-06-12 15:43:31 6. DB::executeQueryImpl(char const*, char const*, std::__1::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, bool, DB::ReadBuffer*) @ 0xfe7031c in /usr/lib/debug/.build-id/64/054935534e653e4f6d0e6d5773703f0e92fca7.debug
2021-06-12 15:43:31 7. DB::executeQuery(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, bool) @ 0xfe6e943 in /usr/lib/debug/.build-id/64/054935534e653e4f6d0e6d5773703f0e92fca7.debug
2021-06-12 15:43:31 8. DB::TCPHandler::runImpl() @ 0x106ec372 in /usr/lib/debug/.build-id/64/054935534e653e4f6d0e6d5773703f0e92fca7.debug
2021-06-12 15:43:31 9. DB::TCPHandler::run() @ 0x106ff239 in /usr/lib/debug/.build-id/64/054935534e653e4f6d0e6d5773703f0e92fca7.debug
2021-06-12 15:43:31 10. Poco::Net::TCPServerConnection::start() @ 0x133c470f in /usr/lib/debug/.build-id/64/054935534e653e4f6d0e6d5773703f0e92fca7.debug
2021-06-12 15:43:31 11. Poco::Net::TCPServerDispatcher::run() @ 0x133c619a in /usr/lib/debug/.build-id/64/054935534e653e4f6d0e6d5773703f0e92fca7.debug
2021-06-12 15:43:31 12. Poco::PooledThread::run() @ 0x134f9019 in /usr/lib/debug/.build-id/64/054935534e653e4f6d0e6d5773703f0e92fca7.debug
2021-06-12 15:43:31 13. Poco::ThreadImpl::runnableEntry(void*) @ 0x134f52aa in /usr/lib/debug/.build-id/64/054935534e653e4f6d0e6d5773703f0e92fca7.debug
2021-06-12 15:43:31 14. start_thread @ 0x9609 in /usr/lib/x86_64-linux-gnu/libpthread-2.31.so
2021-06-12 15:43:31 15. clone @ 0x122293 in /usr/lib/x86_64-linux-gnu/libc-2.31.so
2021-06-12 15:43:31  (version 21.7.1.7144)

01282_system_parts_ttl_info and 00933_ttl_with_default looks flaky.

@alexey-milovidov
Copy link
Copy Markdown
Member Author

alexey-milovidov commented Jun 29, 2021

@Mergifyio update

@mergify
Copy link
Copy Markdown
Contributor

mergify bot commented Jun 29, 2021

Command update: success

Branch has been successfully updated

@alexey-milovidov
Copy link
Copy Markdown
Member Author

alexey-milovidov commented Jul 13, 2021

@Mergifyio update

@mergify
Copy link
Copy Markdown
Contributor

mergify bot commented Jul 13, 2021

Command update: success

Branch has been successfully updated

@alexey-milovidov
Copy link
Copy Markdown
Member Author

alexey-milovidov commented Aug 8, 2021

@Mergifyio update

@mergify
Copy link
Copy Markdown
Contributor

mergify bot commented Aug 8, 2021

Command update: success

Branch has been successfully updated

@alexey-milovidov
Copy link
Copy Markdown
Member Author

alexey-milovidov commented Aug 8, 2021

@Mergifyio update

@mergify
Copy link
Copy Markdown
Contributor

mergify bot commented Aug 8, 2021

Command update: success

Branch has been successfully updated

@alexey-milovidov alexey-milovidov mentioned this pull request Aug 10, 2021
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

No reviews

Assignees

No one assigned

Labels

no-docs-needed pr-not-for-changelog This PR should not be mentioned in the changelog

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

5 participants

@alexey-milovidov @azat @qoega @nikitamikhaylov @blinkov