MySQL Forums
Forum List  »  Stored Procedures

Re: Mysql 8.0 crash while calling stored proc
Posted by: Jason Kafer
Date: March 06, 2021 03:24PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Mysql 8.0 crash while calling stored proc
107
March 06, 2021 03:24PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.