Re: Mysql 8.0 crash while calling stored proc

[Jason Kafer]

We too are seeing this on FreeBSD 12.2 with MySQL compiled from ports tree.

I've played around with the SPROCs a little and found that anytime there is any sort of variable (either IN var, or something declared in the procedure) that is accessed, the following crash occurs.

Assertion failed: (m_sp == current_thd->sp_runtime_ctx->sp), function this_item, file /wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.23/sql/item.cc, line 1730.
21:10:59 UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x875a3d000
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...
[0x2309c06] +0x0
[0x8044a5b70] _pthread_cleanup_pop+0x0
[0x8044a513f] _pthread_cleanup_pop+0x0
[0x7ffffffff193] +0x0
[0x804674c2a] __error+0x0
[0x804673084] __error+0x0
[0x8045e9279] __error+0x0
[0x804663291] __error+0x0
[0x1e5d0ff] +0x0
[0x1e5cc92] +0x0
[0x206b88d] +0x0
[0x206b4a2] +0x0
[0x206408d] +0x0
[0x2065955] +0x0
[0x20ae73d] +0x0
[0x21f51fe] +0x0
[0x219518d] +0x0
[0x21929fb] +0x0
[0x2191479] +0x0
[0x2192278] +0x0
[0x22f1fbf] +0x0
[0x34081c0] +0x0
[0x80449ffac] _pthread_cleanup_pop+0x0
[0x0] +0x0
[0x804673084] __error+0x0
stack_bottom = 7fffda194f60 thread_stack 0x46000
0x301e5de <_Z19my_print_stacktracePKhm+0x10e> at /usr/local/libexec/mysqld
0x2309c06 <handle_fatal_signal+0x1c6> at /usr/local/libexec/mysqld
0x8044a5b70 <_pthread_sigmask+0x530> at /lib/libthr.so.3

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (875a8c828): insert into testtable (testvalue)
values (in_merchant_id)
Connection ID (thread ID): 9
Status: NOT_KILLED