[MDEV-7427] datetime with connect overflows Created: 2015-01-09  Updated: 2015-01-10  Resolved: 2015-01-10

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Connect
Affects Version/s: 10.0.15
Fix Version/s: 10.0.16

Type: Bug Priority: Major
Reporter: Takuya Aoki (Inactive) Assignee: Olivier Bertrand
Resolution: Fixed Votes: 0
Labels: None
Environment:

CentOS release 6.5 (X86_64)


 Description   

When I create a CONNECT table to a table with a datetime column,
I cannot insert to this CONNECT table due to a bug with translation.
I can cope with it by changing the column to CHAR(19) but this bug should be fixed for user's convenience.

FROM SERVER 1
I created a MyISAM table.

[root@kc0022 test]# mysql -u root
 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
 
Your MariaDB connection id is 678
 
Server version: 10.0.13-MariaDB MariaDB Server
 
 
 
Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.
 
 
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
 
 
MariaDB [(none)]> use test;
 
Reading table information for completion of table and column names
 
You can turn off this feature to get a quicker startup with -A
 
 
 
Database changed
 
MariaDB [test]> show create table table_delivery;
 
+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
 
| Table          | Create Table                                                                                                                                                                                                                                                   |
 
+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
 
| table_delivery | CREATE TABLE `table_delivery` (
 
  `order_no` int(11) NOT NULL DEFAULT '0',
 
  `delivery_charge` double DEFAULT NULL,
 
  `charge` double DEFAULT NULL,
 
  `discount` double DEFAULT NULL,
 
  `ship_date` datetime DEFAULT NULL
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
 
+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
 
1 row in set (0.00 sec)

FROM SERVER 2
I created a MyISAM table.
I also created a CONNECT table linking to SERVER1's table.

[root@kc1060 my.cnf.d]# mysql -u root
 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
 
Your MariaDB connection id is 3
 
Server version: 10.0.15-MariaDB-log MariaDB Server
 
 
 
Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.
 
 
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
 
 
MariaDB [(none)]> use test;
 
Reading table information for completion of table and column names
 
You can turn off this feature to get a quicker startup with -A
 
 
 
Database changed
 
MariaDB [test]> SHOW CREATE TABLE table_delivery;
 
+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
 
| Table          | Create Table                                                                                                                                                                                                                                                   |
 
+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
 
| table_delivery | CREATE TABLE `table_delivery` (
 
  `order_no` int(11) NOT NULL DEFAULT '0',
 
  `delivery_charge` double DEFAULT NULL,
 
  `charge` double DEFAULT NULL,
 
  `discount` double DEFAULT NULL,
 
  `ship_date` datetime DEFAULT NULL
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
 
+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
 
1 row in set (0.01 sec)
 
 
 
MariaDB [test]> CREATE TABLE connect_table_delivery ENGINE=CONNECT DEFAULT CHARSET=utf8 table_type=MYSQL dbname=test tabname=table_delivery DATA_CHARSET=cp932 option_list='user=root,host=10.0.1.36';
 
Query OK, 0 rows affected (0.08 sec)
 
 
 
MariaDB [test]> INSERT INTO connect_table_delivery SELECT * FROM table_delivery;
 
 
 
ERROR 2013 (HY000): Lost connection to MySQL server during query

The below is recorded in
/var/lib/mysql/kc1060.err

150109 19:25:17 [Note] CONNECT: Version 1.03.0005 Nov 22 2014 03:49:03
 
150109 19:25:17 [Note] connect_init: hton=0x7f498727b388
 
DTVAL Shift=-32400
 
150109 19:25:17 [Note] Server socket created on IP: '::'.
 
150109 19:25:17 [Note] Event Scheduler: Loaded 0 events
 
150109 19:25:17 [Note] /usr/sbin/mysqld: ready for connections.
 
Version: '10.0.15-MariaDB-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
 
...skipping...
 
Done:  in=%4d-%2d-%2d %2d:%2d:%2d out=%Y-%m-%d %H:%M:%S
 
MakeDateFormat: dfmt=YYYY-MM-DD hh:mm:ss
 
Done:  in=%4d-%2d-%2d %2d:%2d:%2d out=%Y-%m-%d %H:%M:%S
 
PlugSubAlloc: Not enough memory in Work area for request of 80 (used=67108856 fr
 
ee=8)
 
150109 19:25:17 mysqld_safe Number of processes running now: 0
 
150109 19:25:17 mysqld_safe mysqld restarted

The error is related to the datetime row, so I changed the row to CHAR(19).
It works, but I don't want to do this everytime.

MariaDB [test]> ALTER TABLE connect_table_delivery MODIFY ship_date CHAR(19);
 
Query OK, 0 rows affected (0.00 sec)
 
Records: 0  Duplicates: 0  Warnings: 0
 
 
 
MariaDB [test]> INSERT INTO connect_table_delivery SELECT * FROM table_delivery;
 
Query OK, 500000 rows affected (3 min 6.25 sec)
 
Records: 500000  Duplicates: 0  Warnings: 0



 Comments   
Comment by Elena Stepanova [ 2015-01-09 ]

It has something to do with the number of rows. For me (with the tables described as in the report, and with 512 identical rows in the MyISAM table insert into table_delivery values (1,1.0,1.0,1.0,now()), the INSERT .. SELECT crashes after inserting 364704 rows into the underlying table.

All threads stacktrace from 10.0 revno 4549

 
[Thread debugging using libthread_db enabled]
 
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
 
Core was generated by `sql/mysqld --no-defaults --basedir=/home/elenst/bzr/10.0'.
 
Program terminated with signal 11, Segmentation fault.
 
#0  __longjmp () at ../sysdeps/x86_64/__longjmp.S:56
 
 
 
Thread 24 (Thread 0x7f35c8fff700 (LWP 21919)):
 
#0  0x00007f35e5a9ad03 in select () at ../sysdeps/unix/syscall-template.S:82
 
#1  0x0000000000a93480 in os_thread_sleep (tm=1000000) at storage/xtradb/os/os0thread.cc:282
 
#2  0x0000000000be9323 in page_cleaner_sleep_if_needed (next_loop_time=1420815782728) at storage/xtradb/buf/buf0flu.cc:2585
 
#3  0x0000000000be95e7 in buf_flush_page_cleaner_thread (arg=0x0) at storage/xtradb/buf/buf0flu.cc:2704
 
#4  0x00007f35e77eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#5  0x00007f35e5aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#6  0x0000000000000000 in ?? ()
 
 
 
Thread 23 (Thread 0x7f35c87fe700 (LWP 21920)):
 
#0  0x00007f35e5a9ad03 in select () at ../sysdeps/unix/syscall-template.S:82
 
#1  0x0000000000a93480 in os_thread_sleep (tm=1000000) at storage/xtradb/os/os0thread.cc:282
 
#2  0x0000000000be9323 in page_cleaner_sleep_if_needed (next_loop_time=1420815782725) at storage/xtradb/buf/buf0flu.cc:2585
 
#3  0x0000000000be9b64 in buf_flush_lru_manager_thread (arg=0x0) at storage/xtradb/buf/buf0flu.cc:2856
 
#4  0x00007f35e77eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#5  0x00007f35e5aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#6  0x0000000000000000 in ?? ()
 
 
 
Thread 22 (Thread 0x7f35cb3fe700 (LWP 21916)):
 
#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:216
 
#1  0x0000000000a9212c in os_cond_wait_timed (cond=0x7f35e50a69c0, fast_mutex=0x7f35e50a6980, abstime=0x7f35cb3fddf0) at storage/xtradb/os/os0sync.cc:177
 
#2  0x0000000000a92923 in os_event_wait_time_low (event=0x7f35e50a6980, time_in_usec=5000000, reset_sig_count=1) at storage/xtradb/os/os0sync.cc:723
 
#3  0x0000000000b4b14c in srv_monitor_thread (arg=0x0) at storage/xtradb/srv/srv0srv.cc:1987
 
#4  0x00007f35e77eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#5  0x00007f35e5aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#6  0x0000000000000000 in ?? ()
 
 
 
Thread 21 (Thread 0x7f35c7ffd700 (LWP 21921)):
 
#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
 
#1  0x0000000000a92214 in os_cond_wait (cond=0x7f35e50a6a40, fast_mutex=0x7f35e50a6a00) at storage/xtradb/os/os0sync.cc:214
 
#2  0x0000000000a92746 in os_event_wait_low (event=0x7f35e50a6a00, reset_sig_count=1) at storage/xtradb/os/os0sync.cc:610
 
#3  0x0000000000be1571 in buf_dump_thread (arg=0x0) at storage/xtradb/buf/buf0dump.cc:594
 
#4  0x00007f35e77eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#5  0x00007f35e5aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#6  0x0000000000000000 in ?? ()
 
 
 
Thread 20 (Thread 0x7f35ce3f6700 (LWP 21911)):
 
#0  0x00007f35e75e26a4 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
 
#1  0x0000000000a8fb21 in os_aio_linux_collect (array=0x7f35e51b8150, segment=3, seg_size=256) at storage/xtradb/os/os0file.cc:5102
 
#2  0x0000000000a8feb2 in os_aio_linux_handle (global_seg=9, message1=0x7f35ce3f5e20, message2=0x7f35ce3f5e18, type=0x7f35ce3f5e10, space_id=0x7f35ce3f5e08) at storage/xtradb/os/os0file.cc:5248
 
#3  0x0000000000c419f0 in fil_aio_wait (segment=9) at storage/xtradb/fil/fil0fil.cc:5662
 
#4  0x0000000000b504a5 in io_handler_thread (arg=0x18a1ec8) at storage/xtradb/srv/srv0start.cc:514
 
#5  0x00007f35e77eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#6  0x00007f35e5aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#7  0x0000000000000000 in ?? ()
 
 
 
Thread 19 (Thread 0x7f35d03fa700 (LWP 21907)):
 
#0  0x00007f35e75e26a4 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
 
#1  0x0000000000a8fb21 in os_aio_linux_collect (array=0x7f35e51b8060, segment=3, seg_size=256) at storage/xtradb/os/os0file.cc:5102
 
#2  0x0000000000a8feb2 in os_aio_linux_handle (global_seg=5, message1=0x7f35d03f9e20, message2=0x7f35d03f9e18, type=0x7f35d03f9e10, space_id=0x7f35d03f9e08) at storage/xtradb/os/os0file.cc:5248
 
#3  0x0000000000c419f0 in fil_aio_wait (segment=5) at storage/xtradb/fil/fil0fil.cc:5662
 
#4  0x0000000000b504a5 in io_handler_thread (arg=0x18a1ea8) at storage/xtradb/srv/srv0start.cc:514
 
#5  0x00007f35e77eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#6  0x00007f35e5aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#7  0x0000000000000000 in ?? ()
 
 
 
Thread 18 (Thread 0x7f35cebf7700 (LWP 21910)):
 
#0  0x00007f35e75e26a4 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
 
#1  0x0000000000a8fb21 in os_aio_linux_collect (array=0x7f35e51b8150, segment=2, seg_size=256) at storage/xtradb/os/os0file.cc:5102
 
#2  0x0000000000a8feb2 in os_aio_linux_handle (global_seg=8, message1=0x7f35cebf6e20, message2=0x7f35cebf6e18, type=0x7f35cebf6e10, space_id=0x7f35cebf6e08) at storage/xtradb/os/os0file.cc:5248
 
#3  0x0000000000c419f0 in fil_aio_wait (segment=8) at storage/xtradb/fil/fil0fil.cc:5662
 
#4  0x0000000000b504a5 in io_handler_thread (arg=0x18a1ec0) at storage/xtradb/srv/srv0start.cc:514
 
#5  0x00007f35e77eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#6  0x00007f35e5aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#7  0x0000000000000000 in ?? ()
 
 
 
Thread 17 (Thread 0x7f35ccbff700 (LWP 21914)):
 
#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:216
 
#1  0x0000000000a9212c in os_cond_wait_timed (cond=0x7f35d3c79640, fast_mutex=0x7f35d3c79600, abstime=0x7f35ccbfee20) at storage/xtradb/os/os0sync.cc:177
 
#2  0x0000000000a92923 in os_event_wait_time_low (event=0x7f35d3c79600, time_in_usec=1000000, reset_sig_count=1) at storage/xtradb/os/os0sync.cc:723
 
#3  0x0000000000a68bb0 in lock_wait_timeout_thread (arg=0x0) at storage/xtradb/lock/lock0wait.cc:499
 
#4  0x00007f35e77eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#5  0x00007f35e5aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#6  0x0000000000000000 in ?? ()
 
 
 
Thread 16 (Thread 0x7f35cbbff700 (LWP 21915)):
 
#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:216
 
#1  0x0000000000a9212c in os_cond_wait_timed (cond=0x7f35e50a6940, fast_mutex=0x7f35e50a6900, abstime=0x7f35cbbfedc0) at storage/xtradb/os/os0sync.cc:177
 
#2  0x0000000000a92923 in os_event_wait_time_low (event=0x7f35e50a6900, time_in_usec=1000000, reset_sig_count=1) at storage/xtradb/os/os0sync.cc:723
 
#3  0x0000000000b4b900 in srv_error_monitor_thread (arg=0x0) at storage/xtradb/srv/srv0srv.cc:2251
 
#4  0x00007f35e77eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#5  0x00007f35e5aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#6  0x0000000000000000 in ?? ()
 
 
 
Thread 15 (Thread 0x7f35bdbff700 (LWP 21924)):
 
#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:216
 
#1  0x0000000000e50adb in safe_cond_timedwait (cond=0x20bc160, mp=0x20bc0a0, abstime=0x7f35bdbfede0, file=0x11088b0 "include/mysql/psi/mysql_thread.h", line=1202) at mysys/thr_mutex.c:547
 
#2  0x0000000000d29698 in inline_mysql_cond_timedwait (that=0x20bc160, mutex=0x20bc0a0, abstime=0x7f35bdbfede0, src_file=0x11088e8 "storage/maria/ma_servicethread.c", src_line=119) at include/mysql/psi/mysql_thread.h:1202
 
#3  0x0000000000d29b44 in my_service_thread_sleep (control=0x16c1250, sleep_time=30000000000) at storage/maria/ma_servicethread.c:118
 
#4  0x0000000000d1efba in ma_checkpoint_background (arg=0x1e) at storage/maria/ma_checkpoint.c:709
 
#5  0x00007f35e77eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#6  0x00007f35e5aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#7  0x0000000000000000 in ?? ()
 
 
 
Thread 14 (Thread 0x7f35ca3fc700 (LWP 21918)):
 
#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162
 
#1  0x0000000000a92214 in os_cond_wait (cond=0x7f35e50a68c0, fast_mutex=0x7f35e50a6880) at storage/xtradb/os/os0sync.cc:214
 
#2  0x0000000000a92746 in os_event_wait_low (event=0x7f35e50a6880, reset_sig_count=1) at storage/xtradb/os/os0sync.cc:610
 
#3  0x0000000000b4d84e in srv_purge_coordinator_suspend (slot=0x7f35e5123880, rseg_history_len=0) at storage/xtradb/srv/srv0srv.cc:3336
 
#4  0x0000000000b4dd60 in srv_purge_coordinator_thread (arg=0x0) at storage/xtradb/srv/srv0srv.cc:3458
 
#5  0x00007f35e77eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#6  0x00007f35e5aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#7  0x0000000000000000 in ?? ()
 
 
 
Thread 13 (Thread 0x7f35e7bfe700 (LWP 21925)):
 
#0  do_sigwait (set=0x7f35e7bfdde0, sig=0x7f35e7bfde78) at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:65
 
#1  0x00007f35e77f2df7 in __sigwait (set=<optimized out>, sig=<optimized out>) at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:100
 
#2  0x00000000005c0364 in signal_hand (arg=0x0) at sql/mysqld.cc:3343
 
#3  0x00007f35e77eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#4  0x00007f35e5aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#5  0x0000000000000000 in ?? ()
 
 
 
Thread 12 (Thread 0x7f35c6ffb700 (LWP 21923)):
 
#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:216
 
#1  0x0000000000a9212c in os_cond_wait_timed (cond=0x7f35cd239140, fast_mutex=0x7f35cd239100, abstime=0x7f35c6ffad90) at storage/xtradb/os/os0sync.cc:177
 
#2  0x0000000000a92923 in os_event_wait_time_low (event=0x7f35cd239100, time_in_usec=5000000, reset_sig_count=1) at storage/xtradb/os/os0sync.cc:723
 
#3  0x0000000000b9047b in ib_wqueue_timedwait (wq=0x7f35e50e0738, wait_in_usecs=5000000) at storage/xtradb/ut/ut0wqueue.cc:154
 
#4  0x0000000000c6d925 in fts_optimize_thread (arg=0x7f35e50e0738) at storage/xtradb/fts/fts0opt.cc:2996
 
#5  0x00007f35e77eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#6  0x00007f35e5aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#7  0x0000000000000000 in ?? ()
 
 
 
Thread 11 (Thread 0x7f35d2bff700 (LWP 21902)):
 
#0  0x00007f35e75e26a4 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
 
#1  0x0000000000a8fb21 in os_aio_linux_collect (array=0x7f35e51b8100, segment=0, seg_size=256) at storage/xtradb/os/os0file.cc:5102
 
#2  0x0000000000a8feb2 in os_aio_linux_handle (global_seg=0, message1=0x7f35d2bfee20, message2=0x7f35d2bfee18, type=0x7f35d2bfee10, space_id=0x7f35d2bfee08) at storage/xtradb/os/os0file.cc:5248
 
#3  0x0000000000c419f0 in fil_aio_wait (segment=0) at storage/xtradb/fil/fil0fil.cc:5662
 
#4  0x0000000000b504a5 in io_handler_thread (arg=0x18a1e80) at storage/xtradb/srv/srv0start.cc:514
 
#5  0x00007f35e77eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#6  0x00007f35e5aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#7  0x0000000000000000 in ?? ()
 
 
 
Thread 10 (Thread 0x7f35c77fc700 (LWP 21922)):
 
#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:216
 
#1  0x0000000000a9212c in os_cond_wait_timed (cond=0x7f35d3f5f140, fast_mutex=0x7f35d3f5f100, abstime=0x7f35c77fbe40) at storage/xtradb/os/os0sync.cc:177
 
#2  0x0000000000a92923 in os_event_wait_time_low (event=0x7f35d3f5f100, time_in_usec=10000000, reset_sig_count=1) at storage/xtradb/os/os0sync.cc:723
 
#3  0x0000000000c3069a in dict_stats_thread (arg=0x0) at storage/xtradb/dict/dict0stats_bg.cc:349
 
#4  0x00007f35e77eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#5  0x00007f35e5aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#6  0x0000000000000000 in ?? ()
 
 
 
Thread 9 (Thread 0x7f35d23fe700 (LWP 21903)):
 
#0  0x00007f35e75e26a4 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
 
#1  0x0000000000a8fb21 in os_aio_linux_collect (array=0x7f35e51b80b0, segment=0, seg_size=256) at storage/xtradb/os/os0file.cc:5102
 
#2  0x0000000000a8feb2 in os_aio_linux_handle (global_seg=1, message1=0x7f35d23fde20, message2=0x7f35d23fde18, type=0x7f35d23fde10, space_id=0x7f35d23fde08) at storage/xtradb/os/os0file.cc:5248
 
#3  0x0000000000c419f0 in fil_aio_wait (segment=1) at storage/xtradb/fil/fil0fil.cc:5662
 
#4  0x0000000000b504a5 in io_handler_thread (arg=0x18a1e88) at storage/xtradb/srv/srv0start.cc:514
 
#5  0x00007f35e77eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#6  0x00007f35e5aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#7  0x0000000000000000 in ?? ()
 
 
 
Thread 8 (Thread 0x7f35cabfd700 (LWP 21917)):
 
#0  0x00007f35e5a9ad03 in select () at ../sysdeps/unix/syscall-template.S:82
 
#1  0x0000000000a93480 in os_thread_sleep (tm=1000000) at storage/xtradb/os/os0thread.cc:282
 
#2  0x0000000000b4cdad in srv_master_sleep () at storage/xtradb/srv/srv0srv.cc:2979
 
#3  0x0000000000b4cee9 in srv_master_thread (arg=0x0) at storage/xtradb/srv/srv0srv.cc:3027
 
#4  0x00007f35e77eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#5  0x00007f35e5aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#6  0x0000000000000000 in ?? ()
 
 
 
Thread 7 (Thread 0x7f35e7c00760 (LWP 21900)):
 
#0  0x00007f35e5a965c3 in *__GI___poll (fds=<optimized out>, nfds=<optimized out>, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:87
 
#1  0x00000000005c5093 in handle_connections_sockets () at sql/mysqld.cc:6111
 
#2  0x00000000005c4101 in mysqld_main (argc=11, argv=0x7f35e501e6a0) at sql/mysqld.cc:5543
 
#3  0x00000000005ba64c in main (argc=11, argv=0x7ffff155f248) at sql/main.cc:25
 
 
 
Thread 6 (Thread 0x7f35d13fc700 (LWP 21905)):
 
#0  0x00007f35e75e26a4 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
 
#1  0x0000000000a8fb21 in os_aio_linux_collect (array=0x7f35e51b8060, segment=1, seg_size=256) at storage/xtradb/os/os0file.cc:5102
 
#2  0x0000000000a8feb2 in os_aio_linux_handle (global_seg=3, message1=0x7f35d13fbe20, message2=0x7f35d13fbe18, type=0x7f35d13fbe10, space_id=0x7f35d13fbe08) at storage/xtradb/os/os0file.cc:5248
 
#3  0x0000000000c419f0 in fil_aio_wait (segment=3) at storage/xtradb/fil/fil0fil.cc:5662
 
#4  0x0000000000b504a5 in io_handler_thread (arg=0x18a1e98) at storage/xtradb/srv/srv0start.cc:514
 
#5  0x00007f35e77eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#6  0x00007f35e5aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#7  0x0000000000000000 in ?? ()
 
 
 
Thread 5 (Thread 0x7f35cf3f8700 (LWP 21909)):
 
#0  0x00007f35e75e26a4 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
 
#1  0x0000000000a8fb21 in os_aio_linux_collect (array=0x7f35e51b8150, segment=1, seg_size=256) at storage/xtradb/os/os0file.cc:5102
 
#2  0x0000000000a8feb2 in os_aio_linux_handle (global_seg=7, message1=0x7f35cf3f7e20, message2=0x7f35cf3f7e18, type=0x7f35cf3f7e10, space_id=0x7f35cf3f7e08) at storage/xtradb/os/os0file.cc:5248
 
#3  0x0000000000c419f0 in fil_aio_wait (segment=7) at storage/xtradb/fil/fil0fil.cc:5662
 
#4  0x0000000000b504a5 in io_handler_thread (arg=0x18a1eb8) at storage/xtradb/srv/srv0start.cc:514
 
#5  0x00007f35e77eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#6  0x00007f35e5aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#7  0x0000000000000000 in ?? ()
 
 
 
Thread 4 (Thread 0x7f35cfbf9700 (LWP 21908)):
 
#0  0x00007f35e75e26a4 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
 
#1  0x0000000000a8fb21 in os_aio_linux_collect (array=0x7f35e51b8150, segment=0, seg_size=256) at storage/xtradb/os/os0file.cc:5102
 
#2  0x0000000000a8feb2 in os_aio_linux_handle (global_seg=6, message1=0x7f35cfbf8e20, message2=0x7f35cfbf8e18, type=0x7f35cfbf8e10, space_id=0x7f35cfbf8e08) at storage/xtradb/os/os0file.cc:5248
 
#3  0x0000000000c419f0 in fil_aio_wait (segment=6) at storage/xtradb/fil/fil0fil.cc:5662
 
#4  0x0000000000b504a5 in io_handler_thread (arg=0x18a1eb0) at storage/xtradb/srv/srv0start.cc:514
 
#5  0x00007f35e77eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#6  0x00007f35e5aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#7  0x0000000000000000 in ?? ()
 
 
 
Thread 3 (Thread 0x7f35d0bfb700 (LWP 21906)):
 
#0  0x00007f35e75e26a4 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
 
#1  0x0000000000a8fb21 in os_aio_linux_collect (array=0x7f35e51b8060, segment=2, seg_size=256) at storage/xtradb/os/os0file.cc:5102
 
#2  0x0000000000a8feb2 in os_aio_linux_handle (global_seg=4, message1=0x7f35d0bfae20, message2=0x7f35d0bfae18, type=0x7f35d0bfae10, space_id=0x7f35d0bfae08) at storage/xtradb/os/os0file.cc:5248
 
#3  0x0000000000c419f0 in fil_aio_wait (segment=4) at storage/xtradb/fil/fil0fil.cc:5662
 
#4  0x0000000000b504a5 in io_handler_thread (arg=0x18a1ea0) at storage/xtradb/srv/srv0start.cc:514
 
#5  0x00007f35e77eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#6  0x00007f35e5aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#7  0x0000000000000000 in ?? ()
 
 
 
Thread 2 (Thread 0x7f35d1bfd700 (LWP 21904)):
 
#0  0x00007f35e75e26a4 in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
 
#1  0x0000000000a8fb21 in os_aio_linux_collect (array=0x7f35e51b8060, segment=0, seg_size=256) at storage/xtradb/os/os0file.cc:5102
 
#2  0x0000000000a8feb2 in os_aio_linux_handle (global_seg=2, message1=0x7f35d1bfce20, message2=0x7f35d1bfce18, type=0x7f35d1bfce10, space_id=0x7f35d1bfce08) at storage/xtradb/os/os0file.cc:5248
 
#3  0x0000000000c419f0 in fil_aio_wait (segment=2) at storage/xtradb/fil/fil0fil.cc:5662
 
#4  0x0000000000b504a5 in io_handler_thread (arg=0x18a1e90) at storage/xtradb/srv/srv0start.cc:514
 
#5  0x00007f35e77eab50 in start_thread (arg=<optimized out>) at pthread_create.c:304
 
#6  0x00007f35e5aa120d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#7  0x0000000000000000 in ?? ()
 
 
 
Thread 1 (Thread 0x7f35e7bb5700 (LWP 21932)):
 
#0  __longjmp () at ../sysdeps/x86_64/__longjmp.S:56
 
#1  0x0fb0637033f51653 in ?? ()

Comment by Olivier Bertrand [ 2015-01-10 ]

You're right. Unusefully the date format was reallocated on each inserted row, causing a memory shortage.

Generated at Thu Feb 08 07:19:31 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.