MySQL Bugs: #115228: MySQL workbench getting crashed while execute a procedure

Bug #115228	MySQL workbench getting crashed while execute a procedure
Submitted:	5 Jun 2024 11:26	Modified:	6 Jun 2024 12:30
Reporter:	Prabhu E	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench	Severity:	S1 (Critical)
Version:	8.0.36,8.0.33,8.0.35	OS:	Windows (Microsoft Windows 10 )
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\prabhu.e\AppData\Roaming\MySQL\Workbench\log\wb.log]

Workbench getting restarted while continously  execute a same proceudure.It affects my products also

How to repeat:
create a procedure has query like this 

SELECT DISTINCT RLE.RIGHT_NAME
        FROM
        PERSON_ROLES PR ,
        (SELECT ROLE_ID,RT.RIGHT_NAME 
           FROM ROLE_RIGHTS RR,
                RIGHTS RT
            WHERE RR.RIGHT_ID = RT.RIGHT_ID
              AND RT.RIGHT_NAME IN (
        'CREATE_PROPOSAL',
        'MODIFY_PROPOSAL',
        'DELETE_PROPOSAL',
        'SUBMIT_PROPOSAL',
        'MAINTAIN_PROPOSAL_BUDGET',
        'VIEW_PROPOSAL',
        'WITHDRAW_PROPOSAL',
        'VIEW_PROPOSAL_ATTACHMENTS',
        'MODIFY_PROPOSAL_ATTACHEMNTS',
        'ASSIGN_REVIEW',
        'ENDORSE_PROPOSAL',
        'MAINTAIN_RANK',
        'DEFINE_APPROVED_BUDGET',
        'MAINTAIN_PRIVATE_COMMENTS',
        'WRITE_REVIEW',
        'VIEW_REVIEW_COMPLETED_TAB',
        'VIEW_REVIEW_IN_PROGRESS_TAB',
        'BYPASS_APPROVER',
        'ALTER_PROPOSAL_DATA',
        'MAINTAIN_PROPOSAL_ACCESS',
        'APPROVE_PROPOSAL_EVALUATION',
        'VIEW_ANY_PROPOSAL',
        'MAINTAIN_APPLICATIONS',
        'SHORTLIST_APPLICATIONS',
        'DEACTIVATE_PROPOSAL',
        'MAINTAIN_EVALUATION_FORM',
        'BYPASS_WORKFLOW',
        'VIEW_EVALUATION_ROUTE_LOG',
        'MODIFY_DOCUMENT_PERMISSION',
        'START_EVALUATION',
        'ADD_APPROVER_WORKFLOW',
        'PD_ADMIN_CORRECTION',
        'CREATE_INST_PROPOSAL',
        'MODIFY_PROPOSAL_ATTACHMENTS_IN_WORKFLOW',
        'PROXY_PROPOSAL_PERSON_CERTIFICATION',
        'CREATE_EXT_REVIEW',
        'VIEW_EXT_REVIEW',
        'MODIFY_EXT_REVIEW',
        'MODIFY_PROPOSAL_QUESTIONNAIRE',
        'VIEW_CONFIDENTIAL_PROPOSAL_ATTACHMENTS'
    )
        ) RLE    
        WHERE PR.PERSON_ID = AV_PERSON_ID
          AND (( PR. DESCEND_FLAG = 'Y' AND AV_LEAD_UNIT IN (SELECT CHILD_UNIT_NUMBER
                                                                 FROM UNIT_WITH_CHILDREN 
                                                                                  WHERE UNIT_NUMBER = PR.UNIT_NUMBER
             ))OR ( PR. DESCEND_FLAG = 'N' AND PR.UNIT_NUMBER = AV_LEAD_UNIT )
            )
           and RLE.ROLE_ID = PR.ROLE_ID  and execute continously then workbench get crashed

option 'max_connections': unsigned value 500000 adjusted to 100000.
Changed limits: max_open_files: 10000 (requested 500000)
Changed limits: max_connections: 9190 (requested 100000)
Changed limits: table_open_cache: 400 (requested 4000)
/usr/sbin/mysqld (mysqld 8.0.36-0ubuntu0.22.04.1) starting as process 3709601
InnoDB initialization has started.
InnoDB initialization has ended.
Starting XA crash recovery...
XA crash recovery finished.
CA certificate ca.pem is self signed.
Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysqld/mysqlx.sock
/usr/sbin/mysqld: ready for connections. Version: '8.0.36-0ubuntu0.22.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu).
2024-06-05T04:50:17Z UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=2acbd229b2cf8b640b93084ba33099e6af38fd44
Thread pointer: 0x7f9f7c000fd0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 7f9fe85d3c40 thread_stack 0x46000
/usr/sbin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x41) [0x586a11901b31]
/usr/sbin/mysqld(print_fatal_signal(int)+0x3bc) [0x586a10f1282c]
/usr/sbin/mysqld(handle_fatal_signal+0x95) [0x586a10f128d5]
/lib/x86_64-linux-gnu/libc.so.6(+0x42520) [0x7f9fffe42520]
/usr/sbin/mysqld(Item_cache::walk(bool (Item::*)(unsigned char*), enum_walk, unsigned char*)+0x7c) [0x586a11036f6c]
/usr/sbin/mysqld(+0x9fdd95) [0x586a10d0fd95]
/usr/sbin/mysqld(Item_func::walk(bool (Item::*)(unsigned char*), enum_walk, unsigned char*)+0x92) [0x586a11089b92]
/usr/sbin/mysqld(Item_cond::walk(bool (Item::*)(unsigned char*), enum_walk, unsigned char*)+0x75) [0x586a1103ac45]
/usr/sbin/mysqld(Query_block::check_column_privileges(THD*)+0x12d) [0x586a10e1279d]
/usr/sbin/mysqld(Query_block::check_privileges_for_subqueries(THD*)+0x47) [0x586a10e12637]
/usr/sbin/mysqld(Query_block::check_column_privileges(THD*)+0x2bc) [0x586a10e1292c]
/usr/sbin/mysqld(Sql_cmd_select::check_privileges(THD*)+0xf5) [0x586a10e2c8e5]
/usr/sbin/mysqld(Sql_cmd_dml::execute(THD*)+0x3dc) [0x586a10e1cb3c]

-- Error capture from performance_schema.error_log

it happens only in MySQL version 8.0.33,8.0.35,8.0.36 but not in 8.0.28

my products getting affected.Need a solution as soon as possible

Hello Prabhu,

Thank you for the bug report.
Could you please provide create table statements and sample insert data for tables involved in the affected procedure? Please make it as private if you prefer. Thanks.

Regards,
Ashwini Patil

Hello Prabhu,

Thank you for the details.
I tried to reproduce your issue on windows 11 with workbench 8.0.36 using procedure and data provided but I am not seeing any issues at my end.

Regards,
Ashwini Patil

8.0.36 test results

Attachment: 115228_test_results.png (image/png, text), 202.88 KiB.