Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
22.08.2
-
None
-
2022-22
Description
"Where this join query hangs forever on the master node, but runs fine on the replicas"
SELECT ff.acct_id, COUNT(1)
|
FROM ff JOIN dd ON ff.acct_sk =dd.acct_sk
|
AND ff.db_source_sk =dd.db_source_sk
|
GROUP BY ff.acct_id LIMIT 10;
|
mariadb -e "create database test; use test;"
|
|
|
mariadb test -e "CREATE TABLE `dd`( `acct_sk` INT(11) UNSIGNED NOT NULL, `acct_id` VARCHAR(128) NOT NULL DEFAULT 'None', `db_source_sk` INT(11) UNSIGNED NOT NULL) ENGINE=Columnstore DEFAULT CHARSET=utf8mb4;"
|
mariadb test -e "CREATE TABLE `ff` ( `db_source_sk` INT(11) UNSIGNED NOT NULL, `acct_id` VARCHAR(128) NOT NULL DEFAULT 'None', `acct_sk` INT(11) UNSIGNED NOT NULL DEFAULT 0 ) ENGINE=Columnstore DEFAULT CHARSET=utf8mb4;"
|
|
|
mariadb test -e "INSERT INTO dd SELECT ROUND(RAND() * 10, 2), substring(MD5(RAND()),1,1), ROUND(RAND() * 100, 2) FROM seq_1_to_300000; "
|
mariadb test -e "INSERT INTO ff SELECT ROUND(RAND() * 10, 2), substring(MD5(RAND()),1,1), ROUND(RAND() * 100, 2) FROM seq_1_to_300000;"
|
|
Attachments
Issue Links
Activity
| Field | Original Value | New Value |
|---|---|---|
| Rank | Ranked higher |
| Assignee | Roman [ drrtuy ] |
| Priority | Major [ 3 ] | Blocker [ 1 ] |
| Fix Version/s | 22.11.01 [ 28458 ] |
| Sprint | 2022-22 [ 672 ] |
| Rank | Ranked lower |
| Description |
"Where this join query hangs forever on the master node, but runs fine on the replicas"
{NOFORMAT} SELECT ff.acct_id, COUNT(1) FROM ff JOIN dd ON ff.acct_sk =dd.acct_sk AND ff.db_source_sk =dd.db_source_sk GROUP BY ff.acct_id LIMIT 10; {NOFORMAT} |
"Where this join query hangs forever on the master node, but runs fine on the replicas"
{NOFORMAT} SELECT ff.acct_id, COUNT(1) FROM ff JOIN dd ON ff.acct_sk =dd.acct_sk AND ff.db_source_sk =dd.db_source_sk GROUP BY ff.acct_id LIMIT 10; {NOFORMAT} {noformat} mariadb -e "create database test; use test;" mariadb test -e "CREATE TABLE `dd`( `acct_sk` INT(11) UNSIGNED NOT NULL, `acct_id` VARCHAR(128) NOT NULL DEFAULT 'None', `db_source_sk` INT(11) UNSIGNED NOT NULL) ENGINE=Columnstore DEFAULT CHARSET=utf8mb4;" mariadb test -e "CREATE TABLE `ff` ( `db_source_sk` INT(11) UNSIGNED NOT NULL, `acct_id` VARCHAR(128) NOT NULL DEFAULT 'None', `acct_sk` INT(11) UNSIGNED NOT NULL DEFAULT 0 ) ENGINE=Columnstore DEFAULT CHARSET=utf8mb4;" mariadb test -e "INSERT INTO dd SELECT ROUND(RAND() * 10, 2), substring(MD5(RAND()),1,1), ROUND(RAND() * 100, 2) FROM seq_1_to_300000; " mariadb test -e "INSERT INTO ff SELECT ROUND(RAND() * 10, 2), substring(MD5(RAND()),1,1), ROUND(RAND() * 100, 2) FROM seq_1_to_300000;" {noformat} |
| Summary | CS Cluster: After software update from 6.x to 22.08, queries hang on one node | MCS Cluster: After software update from 6.x to 22.08, queries hang on one node |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | In Testing [ 10301 ] |
| Fix Version/s | 22.08.3 [ 28456 ] | |
| Fix Version/s | 22.11.01 [ 28458 ] |
| Assignee | Roman [ drrtuy ] | Daniel Lee [ dleeyh ] |
| Assignee | Daniel Lee [ dleeyh ] | Roman [ drrtuy ] |
| Assigned for Testing | Daniel Lee [ dleeyh ] |
| Resolution | Fixed [ 1 ] | |
| Status | In Testing [ 10301 ] | Closed [ 6 ] |
| Fix Version/s | 22.08.5 [ 28533 ] | |
| Fix Version/s | 22.08.3 [ 28456 ] |
| Fix Version/s | 22.08.3 [ 28456 ] | |
| Fix Version/s | 22.08.5 [ 28533 ] |
| Labels | triage | cluster triage |
| Zendesk Related Tickets | 175578 127889 |