[MDEV-15647] [Draft] [ERROR] mysqld: Out of memory (Needed 33554424 bytes) Created: 2018-03-23  Updated: 2018-03-23

Status: Open
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.2
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Unresolved Votes: 0
Labels: None

Attachments: HTML File threads    

 Description   

It's suspicious, because didn't happen before in Travis
https://api.travis-ci.org/v3/job/356426575/log.txt

10.2 82aeb6b59640b9733c4026bda71887720153b70a

Version: '10.2.14-MariaDB-debug-log'  socket: '/home/travis/logs/vardir1_2/mysql.sock'  port: 19300  Source distribution
2018-03-21 17:50:37 139716445026048 [ERROR] mysqld: Out of memory (Needed 33554424 bytes)
180321 17:50:37 [ERROR] mysqld got signal 11 ;
 
Query (0x7f11f801a438): REPLACE INTO /* t1_temp_myisam_26337 table10_int_autoinc t2_temp_myisam_26337 */ table1_innodb_int ( `col_timestamp`, col_tinyint ) VALUES ( @aux, 77 )  /* QNO 2192 CON_ID 17 */
Connection ID (thread ID): 17
Status: NOT_KILLED

#3  <signal handler called>
#4  0x000055c60f4ff0ca in String::length (this=0x0) at /home/travis/src/sql/sql_string.h:203
#5  0x000055c60f867856 in Item::save_in_field (this=0x7f11f801af00, field=0x7f11f81933b8, no_conversions=false) at /home/travis/src/sql/item.cc:6465
#6  0x000055c60f564e3a in fill_record (thd=0x7f11f8009d70, table_arg=0x7f11f8178430, fields=..., values=..., ignore_errors=false, update=false) at /home/travis/src/sql/sql_base.cc:7917
#7  0x000055c60f5653d1 in fill_record_n_invoke_before_triggers (thd=0x7f11f8009d70, table=0x7f11f8178430, fields=..., values=..., ignore_errors=false, event=TRG_EVENT_INSERT) at /home/travis/src/sql/sql_base.cc:8059
#8  0x000055c60f5a5409 in mysql_insert (thd=0x7f11f8009d70, table_list=0x7f11f801a670, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_REPLACE, ignore=false) at /home/travis/src/sql/sql_insert.cc:958
#9  0x000055c60f5ccec1 in mysql_execute_command (thd=0x7f11f8009d70) at /home/travis/src/sql/sql_parse.cc:4432
#10 0x000055c60f5d7e1a in mysql_parse (thd=0x7f11f8009d70, rawbuf=0x7f11f801a438 "REPLACE INTO /* t1_temp_myisam_26337 table10_int_autoinc t2_temp_myisam_26337 */ table1_innodb_int ( `col_timestamp`, col_tinyint ) VALUES ( @aux, 77 )  /* QNO 2192 CON_ID 17 */", length=177, parser_state=0x7f1245132210, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7916
#11 0x000055c60f5c5ceb in dispatch_command (command=COM_QUERY, thd=0x7f11f8009d70, packet=0x7f11f91f0d71 " REPLACE INTO /* t1_temp_myisam_26337 table10_int_autoinc t2_temp_myisam_26337 */ table1_innodb_int ( `col_timestamp`, col_tinyint ) VALUES ( @aux, 77 )  /* QNO 2192 CON_ID 17 */ ", packet_length=179, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1817
#12 0x000055c60f5c464e in do_command (thd=0x7f11f8009d70) at /home/travis/src/sql/sql_parse.cc:1371
#13 0x000055c60f713c16 in do_handle_one_connection (connect=0x55c61385a480) at /home/travis/src/sql/sql_connect.cc:1335
#14 0x000055c60f7139a3 in handle_one_connection (arg=0x55c61385a480) at /home/travis/src/sql/sql_connect.cc:1241
#15 0x00007f1248784184 in start_thread (arg=0x7f1245133700) at pthread_create.c:312
#16 0x00007f1247c9103d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111

experimental 69312423111b0cf4cb265a01b0950234901e8764

perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1521654375 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsPreparedTwice,ExecuteAsSPTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --views --vcols --redefine=conf/mariadb/alter_table.yy --redefine=conf/mariadb/bulk_insert.yy --basedir=/home/travis/server --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --grammar=conf/replication/replication-ddl_sql.yy --gendata=conf/replication/replication-ddl_data.zz --engine=InnoDB --vardir=/home/travis/logs/vardir1_2

Not easily reproducible.


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