Skip to content

Fix 02680_mysql_ast_logical_err in analyzer#49362

Merged
vdimir merged 1 commit intomasterfrom
vdimir/analyzer_02680_mysql_ast_logical_err
May 3, 2023
Merged

Fix 02680_mysql_ast_logical_err in analyzer#49362
vdimir merged 1 commit intomasterfrom
vdimir/analyzer_02680_mysql_ast_logical_err

Conversation

@vdimir
Copy link
Copy Markdown
Member

@vdimir vdimir commented May 1, 2023

Changelog category (leave one):

  • Not for changelog (changelog entry is not required)

Changelog entry (a user-readable short description of the changes that goes to CHANGELOG.md):

...

@robot-clickhouse robot-clickhouse added the pr-not-for-changelog This PR should not be mentioned in the changelog label May 1, 2023
@robot-clickhouse
Copy link
Copy Markdown
Member

robot-clickhouse commented May 1, 2023 •
edited by robot-ch-test-poll1
Loading

This is an automated comment for commit 98d5aed with description of existing statuses. It's updated for the latest CI running
The full report is available here
The overall status of the commit is 🟡 pending

Check nameDescriptionStatus
CI runningA meta-check that indicates the running CI. Normally, it's in success or pending state. The failed status indicates some problems with the PR🟡 pending
Fast testNormally this is the first check that is ran for a PR. It builds ClickHouse and runs most of stateless functional tests, omitting some. If it fails, further checks are not started until it is fixed. Look at the report to see which tests fail, then reproduce the failure locally as described here🟢 success
Mergeable CheckChecks if all other necessary checks are successful🟢 success
Push to DockerhubThe check for building and pushing the CI related docker images to docker hub🟢 success
Style CheckRuns a set of checks to keep the code style clean. If some of tests failed, see the related log from the report🟢 success

@vdimir
Copy link
Copy Markdown
Member Author

vdimir commented May 2, 2023 •
edited
Loading

Stateless tests (release) — fail: 1, passed: 5276, skipped: 4 Details

00002_log_and_exception_messages_formatting

Shouldn't be related because 02680_mysql_ast_logical_err produces message Table function '{}' cannot be used as an expression (and also Invalid expression. Expected identifier, literal, matcher, function, subquery. Actual {} with analyzer) which is long enough

SELECT
    message_format_string,
    length(message_format_string) AS len
FROM logs
WHERE (message ILIKE '%DB::Exception%') AND (message_format_string NOT IN (known_short_messages))
ORDER BY len DESC
LIMIT 1 BY message_format_string
FORMAT PrettyCompactMonoBlock


┌─message_format_string────────────────────────────────────────────────────────────────────┬─len─┐
│ Invalid expression. Expected identifier, literal, matcher, function, subquery. Actual {} │  88 │
│ Unknown table expression identifier '{}' in scope {}                                     │  52 │
│ Table function '{}' cannot be used as an expression                                      │  51 │
│ Illegal type ({}) of {} argument of function {}                                          │  47 │
│ Unknown {}{} identifier '{}' in scope {}{}                                               │  42 │
│ Query {} from stage {} to stage {}{}                                                     │  36 │
│ Temporary table {} already exists.                                                       │  34 │
│ (from {}{}{}){}{} {} (stage: {})                                                         │  32 │
│ Query {} to stage {}{}                                                                   │  22 │
└──────────────────────────────────────────────────────────────────────────────────────────┴─────┘
Top short messages in run.log 
2023-05-01 11:17:22 Top short messages:
2023-05-01 11:17:22 
2023-05-01 11:17:22 c	message_format_string	substring(any(message), 1, 120)
2023-05-01 11:17:22 UInt64	LowCardinality(String)	String
2023-05-01 11:17:22 1279	Write file: {}	Write file: store/b0e/b0e57c94-c53c-4b22-8223-cd575d00e7c5/data.bin
2023-05-01 11:17:22 16	Unable to parse JSONPath	Code: 36. DB::Exception: Unable to parse JSONPath: While processing JSON_VALUE(\'{"1key":1}\', \'$..1key\'). (BAD_ARGUMENTS)
2023-05-01 11:17:22 6	Expected end of line	Code: 117. DB::Exception: Expected end of line: (at row 1)\n: Could not print diagnostic info because two last rows aren\'
2023-05-01 11:17:22 4	Host is empty in S3 URI.	Code: 36. DB::Exception: Host is empty in S3 URI. (BAD_ARGUMENTS) (version 23.5.1.380) (from [::1]:39200) (comment: 0074
2023-05-01 11:17:22 4	Invalid date: {}	Code: 38. DB::Exception: Invalid date: 1999-02-29: While processing toModifiedJulianDay(\'1999-02-29\'). (CANNOT_PARSE_DAT
2023-05-01 11:17:22 4	There is no cache by name: {}	Code: 36. DB::Exception: There is no cache by name: ff. (BAD_ARGUMENTS) (version 23.5.1.380) (from [::1]:54516) (comment
2023-05-01 11:17:22 4	{} \'{}\' not found	Code: 36. DB::Exception: external dictionary \'f6239f76-bec1-488b-85f7-fd388636f8ff\' not found. (BAD_ARGUMENTS) (version 
2023-05-01 11:17:22 4	Column \'{}\' is ambiguous	Code: 352. DB::Exception: Column \'time\' is ambiguous: While processing time = (time AS talias). (AMBIGUOUS_COLUMN_NAME) 
2023-05-01 11:17:22 4	Cannot parse object	Code: 117. DB::Exception: Cannot parse object: (at row 1)\n: While executing WaitForAsyncInsert. (INCORRECT_DATA) (versio
2023-05-01 11:17:22 4	Center is not valid	Code: 36. DB::Exception: Center is not valid: While processing s2CapContains(toUInt64(-1), -1., toUInt64(-1)). (BAD_ARGU
2023-05-01 11:17:22 3	`{}` should be a String	Could not update external dictionary \'1f92cd36-8920-4b91-bd8a-d5c8ce61fce7\', leaving the previous version: Code: 318. DB
2023-05-01 11:17:22 3	There are duplicate id {}	Could not update external dictionary \'b0308f91-2c11-47a0-92af-8c8971ae9f3a\', leaving the previous version: Code: 489. DB
2023-05-01 11:17:22 2	Cell is not valid	Code: 36. DB::Exception: Cell is not valid: While processing s2CellsIntersect(9926595209846587392, 9223372036854775806).
2023-05-01 11:17:22 2	Invalid H3 index: {}	Code: 43. DB::Exception: Invalid H3 index: : While processing stringToH3(\'\'). (ILLEGAL_TYPE_OF_ARGUMENT) (version 23.5.1
2023-05-01 11:17:22 2	Unknown era {}	Code: 41. DB::Exception: Unknown era ab: While processing parseDateTimeInJodaSyntax(\'AB\', \'G\'). (CANNOT_PARSE_DATETIME) 
2023-05-01 11:17:22 2	Point is not valid	Code: 36. DB::Exception: Point is not valid: While processing s2ToGeo(toUInt64(-1)). (BAD_ARGUMENTS) (version 23.5.1.380
2023-05-01 11:17:22 2	Too large node state size	Code: 128. DB::Exception: Too large node state size: While processing finalizeAggregation(CAST(unhex(\'FFFFFFF014181056F3
2023-05-01 11:17:22 2	Invalid qualified name: {}	Code: 62. DB::Exception: Invalid qualified name: a. (SYNTAX_ERROR) (version 23.5.1.380) (from [::1]:33938) (comment: 013
2023-05-01 11:17:22 2	Marks file \'{}\' doesn\'t exist	Code: 226. DB::Exception: Marks file \'/var/lib/clickhouse/store/f78/f784c2ea-3846-4ec7-b72e-c887c17042ac/detached/attach
2023-05-01 11:17:22 2	No additional keys found.	Code: 117. DB::Exception: No additional keys found. (INCORRECT_DATA) (version 23.5.1.380) (from [::ffff:127.0.0.1]:51498
2023-05-01 11:17:22 2	ntile\'s argument must > 0	Code: 36. DB::Exception: ntile\'s argument must > 0. (BAD_ARGUMENTS) (version 23.5.1.380) (from [::1]:54806) (comment: 02
2023-05-01 11:17:22 2	String size is too big ({})	Code: 131. DB::Exception: String size is too big (2147483648): while executing \'FUNCTION CAST(concat(unhex(\'ffffff7f\'), 
2023-05-01 11:17:22 2	Invalid replica name: {}	Code: 36. DB::Exception: Invalid replica name: s2/r1. (BAD_ARGUMENTS) (version 23.5.1.380) (from [::1]:58688) (comment: 
2023-05-01 11:17:22 2	INTO OUTFILE is not allowed	Code: 358. DB::Exception: INTO OUTFILE is not allowed. (INTO_OUTFILE_NOT_ALLOWED) (version 23.5.1.380) (from [::1]:35788
2023-05-01 11:17:22 2	Unexpected value {} in enum	Code: 36. DB::Exception: Unexpected value 2 in enum: while executing \'FUNCTION toString(v :: 0) -> toString(v) String : 
2023-05-01 11:17:22 2	Unknown BSON type: {}	Code: 50. DB::Exception: Unknown BSON type: 0x00: While executing BSONEachRowRowInputFormat. (UNKNOWN_TYPE) (version 23.
2023-05-01 11:17:22 2	Unexpected error: {}	Unexpected error, will try to restart main thread: Code: 341. DB::Exception: Unexpected error: Code: 57. DB::Exception: 
2023-05-01 11:17:22 2	Arguments must not be NaN	Code: 43. DB::Exception: Arguments must not be NaN: While processing geoToS2(nan, nan). (ILLEGAL_TYPE_OF_ARGUMENT) (vers
2023-05-01 11:17:22 1	Replication was stopped	Unexpected error, will try to restart main thread: Code: 341. DB::Exception: Replication was stopped. (UNFINISHED), Stac
2023-05-01 11:17:22 1	{}	building file infos
2023-05-01 11:17:22 1	Chunk size exceeded the limit	Cannot send exception to client: Code: 69. DB::Exception: Chunk size exceeded the limit. (ARGUMENT_OUT_OF_BOUND), Stack 
2023-05-01 11:17:22 1	No part {} in table	Code: 232. DB::Exception: No part 7_226_226_0 in table. (NO_SUCH_DATA_PART), Stack trace (when copying this message, alw
2023-05-01 11:17:22 1	Cannot parse uuid {}	Code: 376. DB::ParsingException: Cannot parse uuid : Cannot parse UUID from String: While processing toUUID(\'\'). (CANNOT
2023-05-01 11:17:22

@novikd novikd self-assigned this May 2, 2023
@novikd novikd mentioned this pull request May 2, 2023
Closed
@vdimir vdimir force-pushed the vdimir/analyzer_02680_mysql_ast_logical_err branch from 519f46c to 98d5aed Compare May 3, 2023 09:55
@vdimir vdimir merged commit bd8a0d9 into master May 3, 2023
@vdimir vdimir deleted the vdimir/analyzer_02680_mysql_ast_logical_err branch May 3, 2023 10:25
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

@novikd novikd novikd approved these changes

Assignees

@novikd novikd

Labels

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.

3 participants

@vdimir @robot-clickhouse @novikd