mysql80 upgrade után random hibák

Fórumok

Sziasztok!

upgradeltem freebsd 12.2 alatt mysql80-server és client-et 8.0.22-ről 8.0.23-ra, azóta a következő hibaüzenetek jönnek elő random a mysql szerver logjában és áll meg a mysql szerver. Van valakinek ötlete?

Assertion failed: (m_sp == current_thd->sp_runtime_ctx->sp), function this_item, file /usr/ports/databases/mysql80-server/work/mysql-8.0.23/sql/item.cc, line 1730.
14:19:00 UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0xa536d6000
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...
[0x2309ad6] unsigned char+0x1c6
[0x80489eb70] _pthread_cleanup_pop+0x1c6
[0x80489e13f] _pthread_cleanup_pop+0x1c6
[0x7ffffffff003] +0x1c6
[0x804a6dc2a] __error+0x1c6
[0x804a6c084] __error+0x1c6
[0x8049e2279] __error+0x1c6
[0x804a5c291] __error+0x1c6
[0x1e5cbaf] Item_splocal::this_item(void)+0x9f
[0x1e5c742] Item_sp_variable::fix_fields(THD*, Item**)+0x12
[0x1da0e46] Item_func::fix_fields(THD*, Item**)+0xf6
[0x205b6ab] sp_prepare_func_item(THD*, Item**)+0xcb
[0x206c20f] sp_instr_jump_if_not::exec_core(THD*, unsigned int*)+0x1f
[0x206a491] sp_lex_instr::reset_lex_and_exec_core(THD*, unsigned int*, bool)+0x2d1
[0x206ae03] sp_lex_instr::validate_lex_and_execute_core(THD*, unsigned int*, bool)+0x1c3
[0x2063d7d] sp_head::execute(THD*, bool)+0x56d
[0x2065645] sp_head::execute_procedure(THD*, mem_root_deque<Item*>*)+0x535
[0x20ae42d] Sql_cmd_call::execute_inner(THD*)+0xfd
[0x21f536e] Sql_cmd_dml::execute(THD*)+0x3ee
[0x21952fd] mysql_execute_command(THD*, bool)+0x130d
[0x2192b6b] dispatch_sql_command(THD*, Parser_state*)+0x42b
[0x21915e9] dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x1c39
[0x21923e8] do_command(THD*)+0x1c8
[0x22f1e8f] Per_thread_connection_handler::add_connection(Channel_info*)+0x46f
[0x3408080] pfs_spawn_thread_vc(unsigned int, my_thread_handle*, pthread_attr* const*, void*(*)(void*), void*)+0x280
[0x804898fac] _pthread_cleanup_pop+0x280
[0x0] +0x280
stack_bottom = 7fffdb154f60 thread_stack 0x46000
0x2309ad6 <handle_fatal_signal+454> at /usr/local/libexec/mysqld
0x80489eb70 <_pthread_sigmask+1328> at /lib/libthr.so.3
0x80489e13f <_pthread_getspecific+3567> at /lib/libthr.so.3
0x7ffffffff003
0x8049e2279 <abort+73> at /lib/libc.so.7
0x804a5c291 <__assert+81> at /lib/libc.so.7
0x1e5cbaf <_ZN12Item_splocal9this_itemEv+159> at /usr/local/libexec/mysqld
0x1e5c742 <_ZN16Item_sp_variable10fix_fieldsEP3THDPP4Item+18> at /usr/local/libexec/mysqld
0x1da0e46 <_ZN9Item_func10fix_fieldsEP3THDPP4Item+246> at /usr/local/libexec/mysqld
0x205b6ab <_Z20sp_prepare_func_itemP3THDPP4Item+203> at /usr/local/libexec/mysqld
0x206c20f <_ZN20sp_instr_jump_if_not9exec_coreEP3THDPj+31> at /usr/local/libexec/mysqld
0x206a491 <_ZN12sp_lex_instr23reset_lex_and_exec_coreEP3THDPjb+721> at /usr/local/libexec/mysqld
0x206ae03 <_ZN12sp_lex_instr29validate_lex_and_execute_coreEP3THDPjb+451> at /usr/local/libexec/mysqld
0x2063d7d <_ZN7sp_head7executeEP3THDb+1389> at /usr/local/libexec/mysqld
0x2065645 <_ZN7sp_head17execute_procedureEP3THDP14mem_root_dequeIP4ItemE+1333> at /usr/local/libexec/mysqld
0x20ae42d <_ZN12Sql_cmd_call13execute_innerEP3THD+253> at /usr/local/libexec/mysqld
0x21f536e <_ZN11Sql_cmd_dml7executeEP3THD+1006> at /usr/local/libexec/mysqld
0x21952fd <_Z21mysql_execute_commandP3THDb+4877> at /usr/local/libexec/mysqld
0x2192b6b <_Z20dispatch_sql_commandP3THDP12Parser_state+1067> at /usr/local/libexec/mysqld
0x21915e9 <_Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command+7225> at /usr/local/libexec/mysqld
0x21923e8 <_Z10do_commandP3THD+456> at /usr/local/libexec/mysqld
0x22f1e8f <_ZN29Per_thread_connection_handler14add_connectionEP12Channel_info+1135> at /usr/local/libexec/mysqld
0x3408080 <_Z19pfs_spawn_thread_vcjP16my_thread_handlePKP12pthread_attrPFPvS5_ES5_+640> at /usr/local/libexec/mysqld
0x804898fac <pthread_create+2348> at /lib/libthr.so.3

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (a54770028): Call GetSetup('GET_ALL_KEY',null)
Connection ID (thread ID): 18
Status: NOT_KILLED

Hozzászólások

assert okan ez nagy valoszinuseggel valami bug lesz, downgrade lesz a baratod ;)

// Happy debugging, suckers
#define true (rand() > 10)

én is erre gondoltam, csak 8.0-tól nincsen downgrade... :S

másik szerveren, ugyanez az OS és mysql verzió semmi gond nincs az upgrade óta, itt nem jövök rá mi okozhatja

Mindig a Call(GetSetup) SQL parancs okozza a hibát vagy ez csak egy példa? Ha ez okozza akkor jobban koruljarhato a dolog, más szerveren megy-e ez a query...

Dump+restore másik néven (gyak. Db masolasa/ujraepitese) megoldja-e a problémát.

Ha downgrade megoldja akkor ticketben bejelentenem. Ha nincs downgrade akkor sima ujratelepites lesz belőle, db formátum nem változott, binarisok cseréje lesz csak, menni fog. 

"Van valakinek ötlete?" - a production környezet alatt ne csináld meg egyelőre a frissítést :-P