Bug 253577

Summary: databases/mysql80-server: 8.0.23 server lost connection when call function that return variable
Product: Ports & Packages Reporter: Al <AlEgo2000>
Component: Individual Port(s)Assignee: Jochen Neumeister <joneum>
Status: Closed Feedback Timeout    
Severity: Affects Only Me CC: chris, freebsd, jason.kafer, joneum, lwhsu
Priority: ---    
Version: Latest   
Hardware: Any   
OS: Any   
Attachments:
Description Flags
Function that make problem and Mysql-server log none

Description Al 2021-02-17 07:41:47 UTC
Created attachment 222509 [details]
Function that make problem and Mysql-server log

FreeBSD freebsd 12.2-RELEASE-p3 FreeBSD 12.2-RELEASE-p3 GENERIC  amd64
MySQL log:
Assertion failed: (m_sp == thd->sp_runtime_ctx->sp), function this_item_addr, file /wrkdirs/usr/ports/databases/mysql80-server/work/mysql-8.0.23/sql/item.cc, line 1742.
08:15:58 UTC - mysqld got signal 6 ;

After upgrade package form mysql-server 8.0.22_1 to 8.0.23 when I call function or procedure that return any avriable mysql server crashed. When I try return scalar all work O'k.
I try call function from mysql CLI and though ODBC connection. Result the same.
This only occurs in FreeBSD. On Ubuntu mysql server 8.0.23 continues work well.

Fix pleace
Comment 1 Jason Kafer 2021-02-22 20:28:46 UTC
We too are experiencing this issue, any procedure that accesses an IN variable seams to cause it. If we create a simple procedure with the body being simple SELECT 1; it returns file. If we create a procedure with an IN variable and the body is SELECT inVariable the server crashes.
Comment 2 Li-Wen Hsu freebsd_committer freebsd_triage 2021-12-20 14:30:13 UTC
Does this still happen in 8.0.27?