maria-developers team mailing list archive

[jerome brauge <j.brauge@xxxxxxxxxxx>]

Hello Alexander,
Attached script fail on my local bb-10.2-compatibility branch on the following assert  :

 /*
    If called from a stored procedure, ensure that we won't rollback
    external changes when cleaning up after validation.
  */
  DBUG_ASSERT(thd->change_list.is_empty());

Stack trace :

	mysqld.exe!my_sigabrt_handler(int sig) Line 477	C
 	mysqld.exe!raise(int signum) Line 516	C++
 	mysqld.exe!abort() Line 64	C++
 	mysqld.exe!common_assert_to_stderr_direct(const wchar_t * const expression, const wchar_t * const file_name, const unsigned int line_number) Line 124	C++
 	mysqld.exe!common_assert_to_stderr<wchar_t>(const wchar_t * const expression, const wchar_t * const file_name, const unsigned int line_number) Line 138	C++
 	mysqld.exe!common_assert<wchar_t>(const wchar_t * const expression, const wchar_t * const file_name, const unsigned int line_number, void * const return_address) Line 383	C++
 	mysqld.exe!_wassert(const wchar_t * expression, const wchar_t * file_name, unsigned int line_number) Line 404	C++
>	mysqld.exe!Prepared_statement::prepare(const char * packet, unsigned int packet_len) Line 3848	C++
 	mysqld.exe!Prepared_statement::execute_immediate(const char * query, unsigned int query_len) Line 4740	C++
 	mysqld.exe!mysql_sql_stmt_execute_immediate(THD * thd) Line 2863	C++
 	mysqld.exe!mysql_execute_command(THD * thd) Line 3722	C++
 	mysqld.exe!sp_instr_stmt::exec_core(THD * thd, unsigned int * nextp) Line 3335	C++
 	mysqld.exe!sp_lex_keeper::reset_lex_and_exec_core(THD * thd, unsigned int * nextp, bool open_tables, sp_instr * instr) Line 3098	C++
 	mysqld.exe!sp_instr_stmt::execute(THD * thd, unsigned int * nextp) Line 3251	C++
 	mysqld.exe!sp_head::execute(THD * thd, bool merge_da_on_success) Line 1265	C++
 	mysqld.exe!sp_head::execute_procedure(THD * thd, List<Item> * args) Line 2090	C++
 	mysqld.exe!do_execute_sp(THD * thd, sp_head * sp) Line 2871	C++
 	mysqld.exe!mysql_execute_command(THD * thd) Line 5900	C++
 	mysqld.exe!mysql_parse(THD * thd, char * rawbuf, unsigned int length, Parser_state * parser_state, bool is_com_multi, bool is_next_command) Line 7990	C++
 	mysqld.exe!dispatch_command(enum_server_command command, THD * thd, char * packet, unsigned int packet_length, bool is_com_multi, bool is_next_command) Line 1809	C++
 	mysqld.exe!do_command(THD * thd) Line 1367	C++
 	mysqld.exe!threadpool_process_request(THD * thd) Line 346	C++
 	mysqld.exe!tp_callback(TP_connection * c) Line 192	C++
 	mysqld.exe!tp_callback(_TP_CALLBACK_INSTANCE * instance, void * context) Line 377	C++
 	mysqld.exe!work_callback(_TP_CALLBACK_INSTANCE * instance, void * context, _TP_WORK * work) Line 451	C++

Can you reproduce this error ?

Regards,
Jérôme.

Attachment: grant_in_proc.sql
Description: grant_in_proc.sql