| Bug #104163 | MySQL Linux ODBC Driver crash - 8.0 | ||
|---|---|---|---|
| Submitted: | 30 Jun 2021 10:50 | Modified: | 19 Aug 2021 8:26 |
| Reporter: | Yuwei Yang | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | Connector / ODBC | Severity: | S3 (Non-critical) |
| Version: | 8.0 | OS: | Linux |
| Assigned to: | CPU Architecture: | Any | |
[30 Jun 2021 10:50]
Yuwei Yang
[30 Jun 2021 10:51]
Yuwei Yang
mini core
Attachment: DE207029.dmp (application/octet-stream, text), 220.61 KiB.
[30 Jun 2021 13:08]
MySQL Verification Team
Hello Yuwei Yang, Thank you for the bug report. Please do not submit the same bug more than once. An existing bug report already describes this problem. Because of this, we hope you add your comments to the original bug instead. https://bugs.mysql.com/bug.php?id=103344 Regards, Ashwini Patil
[19 Aug 2021 8:12]
Yuwei Yang
Hi team, this error is logged as a separate one because this crash can be reproduced inhouse.
We got a full core dump and get the below message after load the dump file:
SQL: L"SELECT \nA.env_id AS \"Environment ID\",\nB.password AS \"Password\",\nA.web_url AS \"Web URL\",\nCONCAT(A.web_url,\"Admin\") AS \"Web Admin URL\",\nA.dossier_url AS \"Library URL\",\nCONCAT(A.dossier_url,\"/admin\") AS \"Library Admin URL\",\nREPLACE(A.dossier_url,\"MicroStrategyLibrary\",\"rdp\") AS \"Guacamole\",\nC.instance_ip AS \"RDP\",\nA.landing_page_url AS \"Home Page\",\nD.instance_name AS \"RDS Instance\",\nCONCAT('https://console.aws.amazon.com/ec2/v2/home?region=', A.region_name ,'#Instances:search=', A.env_id ,';sort=instanceState') AS \"EC2\",\nCONCAT('https://console.aws.amazon.com/cloudformation/home?region=', A.region_name ,'#/stacks?filteringText=', A.env_id ,'&filteringStatus=active&viewNested=true&hideStacks=false&stackId=') AS \"CloudFormation\",\nC.instance_id AS \"Win IID\",\nC.instance_name AS \"Win Name\",\nCONCAT('https://',A.region_name,'.console.aws.amazon.com/systems-manager/session-manager/',C.insta...') AS \"Win SysMan\",\nE.instance_id AS \"IS1 IID\",\nE.instance_name AS \"IS1 Name\",\nCONCAT('https://',A.region_name,'.console.aws.amazon.com/systems-manager/session-manager/',E.insta...') AS \"IS1 SysMan\",\nF.instance_id AS \"IS2 IID\",\nF.instance_name AS \"IS2 Name\",\nCONCAT('https://',A.region_name,'.console.aws.amazon.com/systems-manager/session-manager/',F.insta...') AS \"IS2 SysMan\",\nE.instance_os AS \"OS\",\nE.instance_ip AS \"IS1 IP\",\nF.instance_ip AS \"IS2 IP\"\nFROM SC_ENVIRONMENT A \nLEFT OUTER JOIN (SELECT A.env_id,A.password FROM SC_ENVIRONMENT_SECRET A join SC_ENVIRONMENT_OWNER B on (A.env_id = B.env_id)) B\nON A.env_id = B.env_id\nLEFT OUTER JOIN (select env_id, dns_name, instance_id, instance_name, instance_ip from SC_ENVIRONMENT_INSTANCE where instance_function = 'DeveloperInstance') C\nON A.env_id = C.env_id\nLEFT OUTER JOIN (select env_id, instance_name, instance_id from SC_ENVIRONMENT_INSTANCE where instance_type = 'RDS') D\non A.env_id = D.env_id\nLEFT OUTER JOIN (select env_id, instance_id, instance_name, instance_os, instance_ip from SC_ENVIRONMENT_INSTANCE where instance_type = \"EC2\" and instance_function = 'PlatformInstance' and (instance_name LIKE '%laio1%' or instance_name REGEXP '[^+]laio[a-z]')) E\non A.env_id = E.env_id\nLEFT OUTER JOIN (select env_id, instance_id, instance_name, instance_os, instance_ip from SC_ENVIRONMENT_INSTANCE where instance_type = \"EC2\" and instance_function = 'PlatformInstance' and (instance_name LIKE '%laio2%')) F\non A.env_id = F.env_id"
Column data types: MDataType::Variant::MSI_INTEGER, MDataType::Variant::MSI_UTF8_STRING <repeats 23 times>
Column precisions: 10, 255, 255, 260, 255, 261, 255, 31, 255, 255, 161, 220, 63, 255, 262, 63, 255, 262, 63, 255, 262, 31, 31, 31
[19 Aug 2021 8:26]
Yuwei Yang
We also got the related table structure:
CREATE TABLE
SC_ENVIRONMENT
(
env_id INT NOT NULL AUTO_INCREMENT,
build_kickoff_time DATETIME(6),
build_return_time DATETIME(6),
clustering TINYINT(1),
configuration_id INT,
env_cost DECIMAL(8,2),
env_name VARCHAR(255),
exe_msg VARCHAR(2047),
execution_id VARCHAR(32),
expired_time DATETIME(6),
identity_url VARCHAR(255),
env_state VARCHAR(31) NOT NULL,
web_url VARCHAR(255),
contact_id INT,
group_id INT,
tag_values VARCHAR(1023),
provision_notify TINYINT(1),
terminate_kickoff_time DATETIME(6),
expired_notified TINYINT(1) DEFAULT 0,
env_stop_period bigint DEFAULT 0,
cost_to_date DECIMAL(8,2),
last_start_time DATETIME(6),
last_stop_time DATETIME(6),
active TINYINT(1) DEFAULT 1,
env_sub_state VARCHAR(31),
ami_id VARCHAR(63),
sc_version INT,
landing_page_url VARCHAR(255) COLLATE utf8_general_ci,
hourly_cost DECIMAL(10,5),
region_name VARCHAR(63) COLLATE utf8_general_ci,
salesforce_opportunity_id VARCHAR(31) COLLATE utf8_general_ci,
dossier_url VARCHAR(255) COLLATE utf8_general_ci,
rest_server_url VARCHAR(255) COLLATE utf8_general_ci,
terminate_return_time DATETIME,
build_id INT,
last_message_time_stamp bigint,
last_resize_time DATETIME,
step_function_execution_arn VARCHAR(511) COLLATE utf8_general_ci,
customer_environment BIT DEFAULT b'0',
last_start_finish_time DATETIME,
backingup_percentage INT DEFAULT 0,
operation_exe_msg VARCHAR(2047) COLLATE utf8_general_ci,
upgrade_status VARCHAR(31) COLLATE utf8_general_ci,
upgrade_timestamp DATETIME,
hide BIT DEFAULT b'0',
tag VARCHAR(63) COLLATE utf8_general_ci,
pending_scheduled_operation VARCHAR(31) COLLATE utf8_general_ci,
mstrbak_s3_bucket_location VARCHAR(3072) COLLATE utf8_general_ci,
service_state VARCHAR(31) COLLATE utf8_general_ci,
expected_terminate_time DATETIME,
data_server_alb_target_arn VARCHAR(511) COLLATE utf8_general_ci,
last_pa_data_collect_time DATETIME,
bu_name VARCHAR(31) COLLATE utf8_general_ci,
platform_elb_name VARCHAR(255),
developer_elb_name VARCHAR(255),
platform_alb_target_arn VARCHAR(255),
template_name VARCHAR(63) COLLATE utf8_general_ci,
is_rds_maz BIT,
cloud_platform VARCHAR(31) COLLATE utf8_general_ci,
patch_status VARCHAR(63) COLLATE utf8_general_ci,
patch_timestamp DATETIME,
diagnose_status VARCHAR(63) COLLATE utf8_general_ci,
diagnose_timestamp DATETIME,
security_patch_status VARCHAR(63) COLLATE utf8_general_ci,
security_patch_timestamp DATETIME,
is_private_subnet BIT,
run_automation_timestamp DATETIME,
rds_size INT,
PRIMARY KEY (env_id),
CONSTRAINT FKFD543684A2A44269 FOREIGN KEY (ami_id) REFERENCES `SC_LU_AMI_BUILD_BKP`
(`ami_id`) ,
CONSTRAINT FKGROUP FOREIGN KEY (group_id) REFERENCES `SC_ENVIRONMENT_GROUP` (`group_id`) ON
DELETE
NO ACTION
ON
UPDATE
NO ACTION,
CONSTRAINT FKPROFILE FOREIGN KEY (contact_id) REFERENCES `SC_USER_PROFILE` (`profile_id`)
ON
DELETE
NO ACTION
ON
UPDATE
NO ACTION,
CONSTRAINT FKge0ppcxidki3wtl31kld9mlql FOREIGN KEY (contact_id) REFERENCES `SC_USER_PROFILE`
(`profile_id`) ,
CONSTRAINT FKn2j4o7lft9xhdn5i3x3e0j4ap FOREIGN KEY (group_id) REFERENCES `SC_ENVIRONMENT_GROUP`
(`group_id`),
INDEX FKFD543684A2A44269 (ami_id),
INDEX FKPROFILE_idx (contact_id),
INDEX FKGROUP_idx (group_id)
)
ENGINE=InnoDB DEFAULT CHARSET=latin1 DEFAULT COLLATE=latin1_swedish_ci;
CREATE TABLE
SC_ENVIRONMENT_SECRET
(
token VARCHAR(255) NOT NULL,
env_id INT NOT NULL,
password VARCHAR(255) NOT NULL,
PRIMARY KEY (token, env_id),
CONSTRAINT FK5EBC6CCB1CF47352 FOREIGN KEY (env_id) REFERENCES `SC_ENVIRONMENT` (`env_id`),
INDEX FK5EBC6CCB1CF47352 (env_id)
)
ENGINE=InnoDB DEFAULT CHARSET=latin1 DEFAULT COLLATE=latin1_swedish_ci;
CREATE TABLE
SC_ENVIRONMENT_OWNER
(
owner_id INT NOT NULL AUTO_INCREMENT,
created_time DATETIME,
environment_aws_account_id VARCHAR(511) COLLATE utf8_general_ci,
modification_time DATETIME,
env_id INT,
owner_email VARCHAR(255),
status VARCHAR(63) COLLATE utf8_general_ci,
active BIT DEFAULT b'0',
PRIMARY KEY (owner_id),
CONSTRAINT FK2C28A1181CF47352 FOREIGN KEY (env_id) REFERENCES `SC_ENVIRONMENT` (`env_id`) ,
CONSTRAINT FKEMAIL FOREIGN KEY (owner_email) REFERENCES `SC_LOGIN_USER` (`email`) ,
CONSTRAINT FKfwff2lmpuwwxsx7qcx3kgrmgd FOREIGN KEY (owner_email) REFERENCES `SC_LOGIN_USER`
(`email`) ,
CONSTRAINT FKt0fn8jd8frqu2a7otaykawusi FOREIGN KEY (env_id) REFERENCES `SC_ENVIRONMENT`
(`env_id`),
INDEX FK2C28A1181CF47352 (env_id),
INDEX FKEMAIL (owner_email)
)
ENGINE=InnoDB DEFAULT CHARSET=latin1 DEFAULT COLLATE=latin1_swedish_ci;
CREATE TABLE
SC_ENVIRONMENT_INSTANCE
(
instance_id VARCHAR(63) NOT NULL,
available TINYINT(1),
instance_type VARCHAR(16) NOT NULL,
env_id INT,
instance_ip VARCHAR(31),
instance_name VARCHAR(255),
cost_to_date DECIMAL(8,2),
ec2_instance_type VARCHAR(16) COLLATE utf8_general_ci,
cost DECIMAL(8,2),
status VARCHAR(31) COLLATE utf8_general_ci,
instance_stop_period bigint DEFAULT 0,
last_start_time DATETIME,
last_stop_time DATETIME,
last_start_finish_time DATETIME,
alb_registration_status BIT DEFAULT b'1' NOT NULL,
instance_function VARCHAR(31) COLLATE utf8_general_ci,
instance_os VARCHAR(31) COLLATE utf8_general_ci,
exe_msg VARCHAR(2047) COLLATE utf8_general_ci,
last_monitoring_time DATETIME,
dns_name VARCHAR(255) COLLATE utf8_general_ci,
monitor_zip_Version INT DEFAULT 0 NOT NULL,
PRIMARY KEY (instance_id),
CONSTRAINT FK_ENVID FOREIGN KEY (env_id) REFERENCES `SC_ENVIRONMENT` (`env_id`) ,
CONSTRAINT FKigbl8wnc4f3lp9abtkpqfgr3w FOREIGN KEY (env_id) REFERENCES `SC_ENVIRONMENT`
(`env_id`),
INDEX FK8A0893F0AA638C2B (env_id)
)
ENGINE=InnoDB DEFAULT CHARSET=latin1 DEFAULT COLLATE=latin1_swedish_ci;
