Bug #104163 MySQL Linux ODBC Driver crash - 8.0
Submitted: 30 Jun 10:50 Modified: 19 Aug 8:26
Reporter: Yuwei Yang Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:8.0 OS:Linux
Assigned to: CPU Architecture:Any

[30 Jun 10:50] Yuwei Yang
Description:
Hi team,

Our customer encounter an MySQL ODBC Driver crash on Linux platform.  The callstack looks like:

[0] /usr/lib64/libmyodbc8w.so + 0xe26fd
sp=0x7fdc532c2da0 bp=0x7fdc532c2da0
[1] /usr/lib64/libmyodbc8w.so + 0x77b46
[2] /usr/lib64/libmyodbc8w.so + 0x71b56
[3] /usr/lib64/libmyodbc8w.so + 0x71b2d
[4] /usr/lib64/libmyodbc8w.so + 0x6782e
[5] /opt/mstr/MicroStrategy/install/lib/libodbc.so + 0xf055a
[6] /opt/mstr/MicroStrategy/install/lib/libodbc.so + 0x104562
[7] /usr/lib64/libc-2.26.so + 0x1703ef
[8] /usr/lib64/libmyodbc8w.so + 0x726d0
[9] /usr/lib64/libmyodbc8w.so + 0x726aa
[10] /usr/lib64/libmyodbc8w.so + 0x747fb
[11] /usr/lib64/libmyodbc8w.so + 0x74a91
[12] /opt/mstr/MicroStrategy/install/lib/libodbc.so + 0xf7e1c
[13] /opt/mstr/MicroStrategy/install/lib/libodbc.so + 0xb32cf
[14] /opt/mstr/MicroStrategy/install/lib/libM8DbOd35.so.11.3.0200.1508 + 0x21194
[15] /opt/mstr/MicroStrategy/install/lib/libM8DbOd35.so.11.3.0200.1508 + 0x49128
[16] /opt/mstr/MicroStrategy/install/lib/libM8DbOd35.so.11.3.0200.1508 + 0x31780
[17] /opt/mstr/MicroStrategy/install/lib/libM8DbOd35.so.11.3.0200.1508 + 0x49128
[18] /opt/mstr/MicroStrategy/install/lib/libM8DbOd35.so.11.3.0200.1508 + 0x3174b
[19] /opt/mstr/MicroStrategy/install/lib/libM8DbOd35.so.11.3.0200.1508 + 0x31a6d
[20] /opt/mstr/MicroStrategy/install/lib/libM8DbOd35.so.11.3.0200.1508 + 0x2e630
[21] /opt/mstr/MicroStrategy/install/lib/libM8Db3.so.11.3.0200.1508 + 0xdc140
[22] /opt/mstr/MicroStrategy/install/lib/libM8DbOd35.so.11.3.0200.1508 + 0x492e8
[23] /opt/mstr/MicroStrategy/install/lib/libM8DbOd35.so.11.3.0200.1508 + 0x31d15
[24] /opt/mstr/MicroStrategy/install/lib/libM8DbOd35.so.11.3.0200.1508 + 0x31f05
[25] /opt/mstr/MicroStrategy/install/lib/libM8DbOd35.so.11.3.0200.1508 + 0x324a0
[26] /opt/mstr/MicroStrategy/install/lib/libM8PrcCo2.so.11.3.0200.1508 + 0x42cb3
[27] /opt/mstr/MicroStrategy/install/lib/libM8Synch4.so.11.3.0200.1508 + 0x1e8fd
[28] /usr/lib64/libpthread-2.26.so + 0x740b
[29] /usr/lib64/libc-2.26.so + 0xed09f

The minicore is attached. Could you help take a look to find what's wrong with the MySQL Driver? 

Thanks!

How to repeat:
We are asking for a full core dump from our customer to see if we can get more information.
[30 Jun 10:51] Yuwei Yang
mini core

Attachment: DE207029.dmp (application/octet-stream, text), 220.61 KiB.

[30 Jun 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 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 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;