[MDEV-20380] Server crash during update Created: 2019-08-19  Updated: 2019-12-06  Resolved: 2019-08-19

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Update
Affects Version/s: 10.4.7
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Jérôme Brauge Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Environment:

CentOS Linux release 7.6.1810 (Core)


Attachments: Text File mdev_update_default.txt    
Issue Links:
Duplicate
duplicates MDEV-16039 Crash when selecting virtual columns ... Closed

 Description   

Server crash on update when the table contains a column with the following default value : substring_index(user(),'@',1)



 Comments   
Comment by Alice Sherepa [ 2019-08-19 ]

Thanks! It seems to be a duplicate of MDEV-16039:

10.4

190819 12:57:35 [ERROR] mysqld got signal 11 ;
 
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f3df9cf9390]
sql/item.h:2494(Item_args::walk_args(bool (Item::*)(void*), bool, void*))[0x556c49bcaa12]
sql/item.h:5060(Item_func_or_sum::walk(bool (Item::*)(void*), bool, void*))[0x556c49bcaff3]
sql/table.cc:3235(fix_session_vcol_expr(THD*, Virtual_column_info*))[0x556c49d790d1]
sql/sql_base.cc:5412(fix_all_session_vcol_exprs(THD*, TABLE_LIST*))[0x556c49bbf823]
sql/sql_base.cc:5590(lock_tables(THD*, TABLE_LIST*, unsigned int, unsigned int))[0x556c49bbff2a]
sql/sql_update.cc:416(mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, bool, unsigned long long*, unsigned long long*))[0x556c49d5d953]
sql/sql_parse.cc:4376(mysql_execute_command(THD*))[0x556c49c59416]
sql/sql_parse.cc:7908(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x556c49c65aa6]
sql/sql_parse.cc:1845(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x556c49c51d14]
sql/sql_parse.cc:1360(do_command(THD*))[0x556c49c5042e]
sql/sql_connect.cc:1404(do_handle_one_connection(CONNECT*))[0x556c49dcb362]
sql/sql_connect.cc:1307(handle_one_connection)[0x556c49dcb08b]
perfschema/pfs.cc:1864(pfs_spawn_thread)[0x556c4a6f7849]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f3df9cef6ba]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f3df8f8041d]
 
Query (0x7f3de0013128): explain UPDATE gafld SET nuigafld = 0 WHERE nuigafld = 10

Generated at Thu Feb 08 08:59:01 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.