Error mysqld got signal 11

I’m running application which reading and writing data with mysql database. I’m having both mysql ndbclustr and master master replication in same database. (bcoz of master master replication tables’ engines are innodb, clustering won’t replicate data of those tables.)

I’m having 64GB RAM in each MYSQL server and there are 2 servers with same configurations

Issue I’m getting is, when writing to tables after a few minutes of a time I’m getting

05:49:16 UTC - mysqld got signal 11 ;

This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
Attempting to collect some information that could help diagnose the problem.
As this is a crash and something is definitely wrong, the information
collection process might fail.

key_buffer_size=134217728
read_buffer_size=131072
max_used_connections=502
max_threads=600
thread_count=505
connection_count=501
It is possible that mysqld could use up to 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 369478 K  bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x7fe8ac0273a0
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...
stack_bottom = 7fea140bae70 thread_stack 0x40000
/usr/sbin/mysqld(my_print_stacktrace+0x3b)[0xf7246b]
/usr/sbin/mysqld(handle_fatal_signal+0x461)[0x82a6e1]
/lib64/libpthread.so.0(+0xf100)[0x7fee30719100]
/usr/sbin/mysqld(_ZN12NdbOperation23insertKEYINFO_NdbRecordEPKcj+0xda)[0x136d69a]
/usr/sbin/mysqld(_ZN12NdbOperation21buildSignalsNdbRecordEjyPKj+0x5bd)[0x136de1d]
/usr/sbin/mysqld(_ZN16NdbScanOperation23takeOverScanOpNdbRecordEN12NdbOperation13OperationTypeEP14NdbTransactionPK9NdbRecordPcPKhPKNS0_16OperationOptionsEj+0x1f1)[0x1370651]
/usr/sbin/mysqld(_ZN13ha_ndbcluster14ndb_update_rowEPKhPhi+0x5e7)[0x12ec577]
/usr/sbin/mysqld(_Z12mysql_updateP3THDR4ListI4ItemES4_y15enum_duplicatesPyS6_+0x1305)[0xdc5625]
/usr/sbin/mysqld(_ZN14Sql_cmd_update23try_single_table_updateEP3THDPb+0x1d6)[0xdc7b16]
/usr/sbin/mysqld(_ZN14Sql_cmd_update7executeEP3THD+0x36)[0xdc7e56]
/usr/sbin/mysqld(_Z21mysql_execute_commandP3THDb+0x5d0)[0xd3d680]
/usr/sbin/mysqld(_Z11mysql_parseP3THDP12Parser_state+0x3b5)[0xd43a55]
/usr/sbin/mysqld(_Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command+0xa7a)[0xd4454a]
/usr/sbin/mysqld(_Z10do_commandP3THD+0x19f)[0xd45f8f]
/usr/sbin/mysqld(handle_connection+0x288)[0xe055d8]
/usr/sbin/mysqld(pfs_spawn_thread+0x1b4)[0x142e644]
/lib64/libpthread.so.0(+0x7dc5)[0x7fee30711dc5]
/lib64/libc.so.6(clone+0x6d)[0x7fee2f1cd1cd]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7fe8ac02b980): update dash_subscription_total_count set subscription = 38, unsubscription =10, authentication = 2368553
Connection ID (thread ID): 1107
Status: NOT_KILLED

Below contains the outputs related to

mysql> SHOW GLOBAL STATUS LIKE ‘key_%’;

+------------------------+--------+
| Variable_name          | Value  |
+------------------------+--------+
| Key_blocks_not_flushed | 0      |
| Key_blocks_unused      | 107171 |
| Key_blocks_used        | 3      |
| Key_read_requests      | 6      |
| Key_reads              | 3      |
| Key_write_requests     | 0      |
| Key_writes             | 0      |
+------------------------+--------+

mysql> SHOW GLOBAL STATUS LIKE ‘uptime_%’;

+---------------------------+--------+
| Variable_name             | Value  |
+---------------------------+--------+
| Uptime_since_flush_status | 613    |

http://mysqlcalculator.com/ this site shows the output for memory as 32522 MB.

Mysql Configuration

[mysqld]
#ndbcluster                      # run NDB storage engine
open_files_limit =4096
max_connections = 600
event_scheduler = OFF

server-id = 14
log-bin=mysql-bin
expire_logs_days=1
binlog_format=mixed
relay-log=mysql-relay-bin
replicate-do-table=css_cluster_ndb.transaction_log_0
replicate-do-table=css_cluster_ndb.transaction_log_1
replicate-do-table=css_cluster_ndb.transaction_log_2
replicate-do-table=css_cluster_ndb.transaction_log_3
replicate-do-table=css_cluster_ndb.transaction_log_4
replicate-do-table=css_cluster_ndb.transaction_log_5
replicate-do-table=css_cluster_ndb.transaction_log_6
replicate-do-table=css_cluster_ndb.transaction_log_7
replicate-do-table=css_cluster_ndb.transaction_log_8
replicate-do-table=css_cluster_ndb.transaction_log_9

skip-name-resolve=1
symbolic-links=0
wait_timeout=120
interactive_timeout=120
query_cache_size=0
query_cache_type=0
query_cache_limit=32M
thread_cache_size=36
innodb_flush_log_at_trx_commit=2
innodb_buffer_pool_size=15G
innodb_flush_method=O_DIRECT    #O_DSYNC, O_DIRECT
innodb_doublewrite = 0
innodb_file_per_table=1
innodb_lock_wait_timeout=120
key_buffer_size=128M
max_connect_errors = 2000
innodb_log_file_size=1G
innodb_buffer_pool_instances=15
slave-skip-errors=1590
slave-skip-errors=1533
table_open_cache =8000
#######################
#######################################
explicit_defaults_for_timestamp = 1
log_timestamps = SYSTEM
##############################
auto-increment-increment = 2 # No of replication servers
auto-increment-offset = 5 # First replication server

log-error=/var/log/mysqld.log

ndbcluster
#bind-address=10.81.133.2
#bind-address=10.80.172.194
ndb-connectstring=10.81.133.5:1186      # IP address for server management node
#ndb-connectstring=10.81.133.5:1186      # IP address for server management node
default_storage_engine=ndbcluster     # Define default Storage Engine used by MySQL
#log-error=/var/log/mysqld.log

[mysql_cluster]
#ndb-connectstring=10.81.133.5    # IP address for server management node
ndb-connectstring=10.81.133.5 

SHOW ENGINE INNODB STATUS

| InnoDB |      | 
=====================================
2018-03-12 13:00:06 0x7f4d495c0700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 24 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 422 srv_active, 0 srv_shutdown, 210 srv_idle
srv_master_thread log flush and writes: 632
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 3725
OS WAIT ARRAY INFO: signal count 4814
RW-shared spins 0, rounds 1901, OS waits 128
RW-excl spins 0, rounds 69393, OS waits 5
RW-sx spins 0, rounds 0, OS waits 0
Spin rounds per wait: 1901.00 RW-shared, 69393.00 RW-excl, 0.00 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 2024054201
Purge done for trx's n:o < 2024041077 undo n:o < 0 state: running but idle
History list length 53
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421461956475616, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421461956474704, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421461956473792, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
I/O thread 8 state: waiting for completed aio requests (write thread)
I/O thread 9 state: waiting for completed aio requests (write thread)
Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] ,
 ibuf aio reads:, log i/o's:, sync i/o's:
Pending flushes (fsync) log: 0; buffer pool: 0
13166 OS file reads, 6011 OS file writes, 2135 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 1.75 writes/s, 1.12 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 160766, seg size 160768, 0 merges
merged operations:
 insert 0, delete mark 0, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 3983951, node heap has 0 buffer(s)
Hash table size 3983951, node heap has 0 buffer(s)
Hash table size 3983951, node heap has 0 buffer(s)
Hash table size 3983951, node heap has 0 buffer(s)
Hash table size 3983951, node heap has 1 buffer(s)
Hash table size 3983951, node heap has 0 buffer(s)
Hash table size 3983951, node heap has 0 buffer(s)
Hash table size 3983951, node heap has 0 buffer(s)
0.37 hash searches/s, 0.21 non-hash searches/s
---
LOG
---
Log sequence number 1096750789777
Log flushed up to   1096750789777
Pages flushed up to 1096750789777
Last checkpoint at  1096750789768
0 pending log flushes, 0 pending chkp writes
3508 log i/o's done, 0.83 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 16491479040
Dictionary memory allocated 268388
Buffer pool size   982920
Free buffers       972688
Database pages     10231
Old database pages 3874
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10192, created 39, written 5341
0.00 reads/s, 0.04 creates/s, 0.92 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 10231, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   65528
Free buffers       64836
Database pages     692
Old database pages 275
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 692, created 0, written 403
0.00 reads/s, 0.00 creates/s, 0.08 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 692, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   65528
Free buffers       64759
Database pages     769
Old database pages 303
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 769, created 0, written 415
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 769, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   65528
Free buffers       64818
Database pages     710
Old database pages 282
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 710, created 0, written 282
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 710, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   65528
Free buffers       64872
Database pages     656
Old database pages 262
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 656, created 0, written 309
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 656, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   65528
Free buffers       64836
Database pages     692
Old database pages 273
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 688, created 4, written 534
0.00 reads/s, 0.04 creates/s, 0.67 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 692, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   65528
Free buffers       64960
Database pages     568
Old database pages 229
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 568, created 0, written 379
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 568, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   65528
Free buffers       65058
Database pages     470
Old database pages 0
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 470, created 0, written 267
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 470, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   65528
Free buffers       64751
Database pages     777
Old database pages 306
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 777, created 0, written 365
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 777, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 8
Buffer pool size   65528
Free buffers       64883
Database pages     645
Old database pages 258
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 645, created 0, written 168
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 645, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 9
Buffer pool size   65528
Free buffers       64778
Database pages     750
Old database pages 296
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 750, created 0, written 374
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 750, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 10
Buffer pool size   65528
Free buffers       64811
Database pages     717
Old database pages 284
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 717, created 0, written 254
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 717, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 11
Buffer pool size   65528
Free buffers       64944
Database pages     583
Old database pages 235
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 583, created 0, written 272
0.00 reads/s, 0.00 creates/s, 0.17 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 583, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 12
Buffer pool size   65528
Free buffers       64783
Database pages     745
Old database pages 295
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 745, created 0, written 471
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 745, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 13
Buffer pool size   65528
Free buffers       64694
Database pages     834
Old database pages 327
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 799, created 35, written 570
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 834, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 14
Buffer pool size   65528
Free buffers       64905
Database pages     623
Old database pages 249
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 623, created 0, written 278
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 623, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=988, Main thread ID=139970148284160, state: sleeping
Number of rows inserted 427, updated 0, deleted 0, read 8
0.50 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================

What catches my eye is the Query recorded in the general log

150629  9:17:14 76946 Query     UPDATE `api_dictionaryitem` SET `name` = '', `group_id` = 4, `count` = 2248844, `last_occurence` = NULL WHERE `api_dictionaryitem`.`id` = 8

when you got signal 11

09:17:14 UTC - mysqld got signal 11 ;

I would suspect you hit some weird bug when running the table api_dictionaryitem in this instance. Why ?

Look at the response to the signal 11 you got which I will itemize

• This could be because you hit a bug.
• It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured.
• This error can also be caused by malfunctioning hardware.
• We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail.

Let’s see what mysqld was doing before it had to resort to a stack trace

stack_bottom = 7f4a0043ee70 thread_stack 0x30000
/usr/sbin/mysqld(my_print_stacktrace+0x2c)[0x7cbffc]
/usr/sbin/mysqld(handle_fatal_signal+0x4a1)[0x699251]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x10340)[0x7f4a3278b340]
/lib/x86_64-linux-gnu/libc.so.6(+0x9818e)[0x7f4a3114b18e]
/usr/sbin/mysqld(_ZN8Protocol14net_store_dataEPKhm+0x47)[0x52e3b7]
/usr/sbin/mysqld[0x52fea4]
/usr/sbin/mysqld(_ZN8Protocol24send_result_set_metadataEP4ListI4ItemEj+0x52c)[0x52fbbc]
/usr/sbin/mysqld(_Z18mysqld_list_fieldsP3THDP10TABLE_LISTPKc+0x22a)[0x5e8d2a]
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x2498)[0x5a6988]
/usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x13a)[0x643a4a]
/usr/sbin/mysqld(handle_one_connection+0x4a)[0x643b3a]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x8182)[0x7f4a32783182]

Look at the line that says

/usr/sbin/mysqld(_ZN8Protocol14net_store_dataEPKhm+0x47)[0x52e3b7]

The query at the moment of impact was

UPDATE `api_dictionaryitem` SET
`name` = '',
`group_id` = 4,
`count` = 2248844,
`last_occurence` = NULL
WHERE `api_dictionaryitem`.`id` = 8

What was net_store_data doing at that moment ?

The book Understanding MySQL Internals says something about net_store_data and NULL values on Pages 74,75 under the heading Server Responses subheading Data Fields

Data fields are critical components in many of the server response packets. A data field consists of a length specifier sequence followed by the actual data value. The length specifier sequence can be understood by studying of net_store_length() …

What is interesting is that net_store_data() calls net_store_length() on line 482 in protocol.cc. That code looks like this

{
  to=net_store_length_fast(to,length);
  memcpy(to,from,length);
  return to+length;
}

On line 489, another version of net_store_data() looks like this:

{
  char buff[20];
  uint length=(uint) (int10_to_str(from,buff,10)-buff);
  to=net_store_length_fast(to,length);
  memcpy(to,buff,length);
  return to+length;
}

On line 498, another version of net_store_data() looks like this:

{
  char buff[22];
  uint length=(uint) (longlong10_to_str(from,buff,10)-buff);
  to=net_store_length_fast(to,length);
  memcpy(to,buff,length);
  return to+length;
}

These snippets of code can be found in SourceCodeBrowser

The code for net_store_length

00450 {
00451   uchar *packet=(uchar*) pkg;
00452   if (length < 251)
00453   {
00454     *packet=(uchar) length;
00455     return (char*) packet+1;
00456   }
00457   *packet++=252;
00458   int2store(packet,(uint) length);
00459   return (char*) packet+2;
00460 }

can be found here

Since net_store_data is the single point of failure in the stack trace, what is in the SQL that would have triggered such a a failure ?

Look back at the SQL

UPDATE `api_dictionaryitem` SET
`name` = '',
`group_id` = 4,
`count` = 2248844,
`last_occurence` = NULL
WHERE `api_dictionaryitem`.`id` = 8

The only thing that looks out of place to me is the

`last_occurence` = NULL

Look back at the code for net_store_length. Note the line

00452   if (length < 251)

What is so special about the number 251 ? According the book Understanding MySQL Internals, the last paragraph on page 74 says:

One may ask why the 1 byte length is limited to 251, when the first reserved value in the net_store_length() is 252. The code 251 has a special meaning. It indicates that there is no length value or data following the code, and the value of the field is the SQL NULL.

Aha !!! The NULL value is being mishandled in net_store_length() when dealing with the last_occurence field. If the last_occurence is a DATETIME or TIMESTAMP, using NULL is most likely not being permitted.

Perhaps changing

`last_occurence` = NULL

to a bogus but legitimate date value

`last_occurence` = '1970-01-01 00:00:00'

would probably nail this problem right on the head.

The stack trace’s first response was right : This could be because you hit a bug.

Please read the MySQL Documentation on Using a Stack Trace.

UPDATE 2015-07-06 10:47 EST

Earlier you commented on the definition of the table

mysql> desc api_dictionaryitem;
+----------------+--------------+------+-----+---------+----------------+
| Field          | Type         | Null | Key | Default | Extra          |
+----------------+--------------+------+-----+---------+----------------+
| id             | int(11)      | NO   | PRI | NULL    | auto_increment |
| name           | varchar(255) | NO   |     | NULL    |                |
| count          | bigint(20)   | YES  |     | NULL    |                |
| last_occurence | bigint(20)   | YES  |     | NULL    |                |
| group_id       | int(11)      | NO   | MUL | NULL    |                |
+----------------+--------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

You mentioned that last_occurence is BIGINT. Since it is BIGINT, which is 8 bytes, and it is being set to NULL, think of what that does.

The first byte has 0xFB (251) followed by 7 bytes of undefined stuff.
The code for net_store_length I have shown you in my answer has something for integer starting at line 458

00450 {
00451   uchar *packet=(uchar*) pkg;
00452   if (length < 251)
00453   {
00454     *packet=(uchar) length;
00455     return (char*) packet+1;
00456   }
00457   *packet++=252;
00458   int2store(packet,(uint) length);
00459   return (char*) packet+2;
00460 }

The function is called int2store. I don’t think it can handle a BIGINT correctly since the 7 bytes after the NULL flag could be anything. Please keep in mind that signal 11 is a Segmentation Fault. In this case, it is due to the process of bytes that are unknown or spurious.

I’m trying to get mysql up and running on a VPS i’ve not used in a few months (when it was working). I’m using MariaDB and everything is up to date.

The error log shows this:

  systemd[1]: Starting LSB: Start and stop the mysql database server daemon...
  systemd[1]: Failed to reset devices.list on /system.slice/mysql.service: No such file or directory
  mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
  mysqld: 180123  4:52:41 [Note] /usr/sbin/mysqld (mysqld 10.0.32-MariaDB-0+deb8u1) starting as process 24959 ...
  mysqld: 180123  4:52:41 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
  mysqld: 
  mysqld: 180123  4:52:41 [Note] InnoDB: Using mutexes to ref count buffer pool pages
  mysqld: 180123  4:52:41 [Note] InnoDB: The InnoDB memory heap is disabled
  mysqld: 180123  4:52:41 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  mysqld: 180123  4:52:41 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
  mysqld: 180123  4:52:41 [Note] InnoDB: Compressed tables use zlib 1.2.8
  mysqld: 180123  4:52:41 [Note] InnoDB: Using Linux native AIO
  mysqld: 180123  4:52:41 [Note] InnoDB: Using CPU crc32 instructions
  mysqld: 180123  4:52:41 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  mysqld: 180123  4:52:41 [Note] InnoDB: Completed initialization of buffer pool
  mysqld: 180123  4:52:41 [Note] InnoDB: Highest supported file format is Barracuda.
  mysqld: 180123  4:52:41 [Note] InnoDB: The log sequence numbers 6768897232 and 6768897232 in ibdata files do not match the log sequence number 6768897252 in the ib_logfiles!
  mysqld: 180123  4:52:41 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
  mysqld: 180123  4:52:42 [Note] InnoDB: 128 rollback segment(s) are active.
  mysqld: 180123  4:52:42 [Note] InnoDB: Waiting for purge to start
  mysqld: 180123  4:52:42 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 6768897252
  mysqld: 180123  4:52:42 [Note] mysqld: Aria engine: starting recovery
  mysqld: recovered pages: 0% 10% 20% 30% 40% 50% 60% 70% 80% 90%180123  4:52:42 [ERROR] mysqld got signal 11 ;
  mysqld: This could be because you hit a bug. It is also possible that this binary
  mysqld: or one of the libraries it was linked against is corrupt, improperly built,
  mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.
  mysqld: 
  mysqld: To report this bug, see https://mariadb.com/kb/en/reporting-bugs
  mysqld: 
  mysqld: We will try our best to scrape up some info that will hopefully help
  mysqld: diagnose the problem, but since we have already crashed,
  mysqld: something is definitely wrong and this may fail.
  mysqld: 
  mysqld: Server version: 10.0.32-MariaDB-0+deb8u1
  mysqld: key_buffer_size=16777216
  mysqld: read_buffer_size=131072
  mysqld: max_used_connections=0
  mysqld: max_threads=153
  mysqld: thread_count=0
  mysqld: It is possible that mysqld could use up to
  mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 352327 K  bytes of memory
  mysqld: Hope that's ok; if not, decrease some variables in the equation.
  mysqld: 
  mysqld: Thread pointer: 0x0
  mysqld: Attempting backtrace. You can use the following information to find out
  mysqld: where mysqld died. If you see no messages after this, something went
  mysqld: terribly wrong...
  mysqld: stack_bottom = 0x0 thread_stack 0x30000
  mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0xc047de]
  mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x3af)[0x7362bf]
  mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0xf890)[0x7f128077c890]
  mysqld: /usr/sbin/mysqld[0xae046a]
  mysqld: /usr/sbin/mysqld[0xadf4e1]
  mysqld: /usr/sbin/mysqld[0xae4307]
  mysqld: /usr/sbin/mysqld[0xae4a8e]
  mysqld: /usr/sbin/mysqld[0xac0495]
  mysqld: /usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x5e)[0x73836e]
  mysqld: /usr/sbin/mysqld[0x5d0995]
  mysqld: /usr/sbin/mysqld(_Z11plugin_initPiPPci+0x4b0)[0x5d1b70]
  mysqld: /usr/sbin/mysqld[0x529d85]
  mysqld: /usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x55d)[0x52f8ad]
  mysqld: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf5)[0x7f127f30db45]
  mysqld: /usr/sbin/mysqld[0x525361]
  mysqld: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
  mysqld: information that should help you find out what is causing the crash.
  mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended

I’ve google all of the error codes and also tried the innodb recovery flags to no avail. I’m really stumped, hopefully someone can help. Thanks`

edit: I backed-up the folder for the db i want to salvge, then removed and insalled mariadb to get it up and running, then i copied the db folder back.

It’s now running but one of the tables is inaccessible. If i do a CHECK on it:

tblProducts: Table is marked as crashed and last repair failed
tblProducts: 22 clients are using or haven't closed the table properly
tblProducts: Table create_trd (8415420) > current max_transaction id (1). Table needs to be repaired or zerofilled to be usable
tblProducts: Size of indexfile is: 564641792 Expected: 17252352
tblProducts: Corrupt

edit2: I then did a simple «repair» on the table and all is well. So frustrtingn that the errors given were suggesting hardware issues and had me googling all of the error codes, when it was something so simple. Oh well you live and learn!

0

0

Hello! My GaleraCluster MySQL 5.7 nodes restarts time to time with error:

11:40:21 UTC — mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
Attempting to collect some information that could help diagnose the problem.
As this is a crash and something is definitely wrong, the information
collection process might fail.

key_buffer_size=16777216
read_buffer_size=4194304
max_used_connections=281
max_threads=1000
thread_count=51
connection_count=26
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 8222321 K bytes of memory
Hope that’s ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
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…

stack_bottom = 0 thread_stack 0x80000
/usr/sbin/mysqld(my_print_stacktrace+0x2c)[0x55f48c960d9c]
/usr/sbin/mysqld(handle_fatal_signal+0x479)[0x55f48c268309]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x110e0)[0x7fe1f80f50e0]
/usr/sbin/mysqld(handle_connection+0x17e)[0x55f48c7e8f5e]
/usr/sbin/mysqld(pfs_spawn_thread+0x1b4)[0x55f48cccfb64]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x74a4)[0x7fe1f80eb4a4]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fe1f6937d0f]

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.

I am make coredump files, but it didnt help, because need debug symbols

[New LWP 5857]
[Thread debugging using libthread_db enabled]
Using host libthread_db library «/lib/x86_64-linux-gnu/libthread_db.so.1».
Core was generated by `/usr/sbin/mysqld —daemonize —pid-file=/var/run/mysqld/mysqld.pid —wsrep_star’.
Program terminated with signal SIGSEGV, Segmentation fault.
#0 0x00007faea87fa3b4 in pthread_kill () from /lib/x86_64-linux-gnu/libpthread.so.0
[Current thread is 1 (Thread 0x7faa43173700 (LWP 5637))]
(gdb) bt full
#0 0x00007faea87fa3b4 in pthread_kill () from /lib/x86_64-linux-gnu/libpthread.so.0
No symbol table info available.
#1 0x000055cf4bde5487 in my_write_core (sig=) at /home/galera/mysql-wsrep-5.7.24-25.16/mysys/stacktrace.c:249
No locals.
#2 0x000055cf4b6ed275 in handle_fatal_signal (sig=11) at /home/galera/mysql-wsrep-5.7.24-25.16/sql/signal_handler.cc:220
curr_time = 1555041055
tmins = 25917350
thrs = 431955
hrs = 3
mins = 50
secs = 55
hrs_buf = «03»
mins_buf = «50»
secs_buf = «55»
max_threads =
#3
No symbol table info available.
#4 0x000055cf4bc6df5e in handle_connection (arg=arg@entry=0x55cf67e5e710) at /home/galera/mysql-wsrep-5.7.24-25.16/sql/conn_handler/connection_handler_per_thread.cc:332
psi =
channel_info =
pthread_reused =
#5 0x000055cf4c154b64 in pfs_spawn_thread (arg=0x55cf67f527c0) at /home/galera/mysql-wsrep-5.7.24-25.16/storage/perfschema/pfs.cc:2190
typed_arg = 0x55cf67f527c0
user_arg = 0x55cf67e5e710
user_start_routine = 0x55cf4bc6dde0 <handle_connection(void*)>
pfs =
klass =
#6 0x00007faea87f34a4 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
No symbol table info available.
#7 0x00007faea703fd0f in clone () from /lib/x86_64-linux-gnu/libc.so.6
No symbol table info available.
(gdb) bt
#0 0x00007faea87fa3b4 in pthread_kill () from /lib/x86_64-linux-gnu/libpthread.so.0
#1 0x000055cf4bde5487 in my_write_core (sig=) at /home/galera/mysql-wsrep-5.7.24-25.16/mysys/stacktrace.c:249
#2 0x000055cf4b6ed275 in handle_fatal_signal (sig=11) at /home/galera/mysql-wsrep-5.7.24-25.16/sql/signal_handler.cc:220
#3
#4 0x000055cf4bc6df5e in handle_connection (arg=arg@entry=0x55cf67e5e710) at /home/galera/mysql-wsrep-5.7.24-25.16/sql/conn_handler/connection_handler_per_thread.cc:332
#5 0x000055cf4c154b64 in pfs_spawn_thread (arg=0x55cf67f527c0) at /home/galera/mysql-wsrep-5.7.24-25.16/storage/perfschema/pfs.cc:2190
#6 0x00007faea87f34a4 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#7 0x00007faea703fd0f in clone () from /lib/x86_64-linux-gnu/libc.so.6

Do you provied packet like mysql-wsrep-5.7-dbg with debug symbols?

Всем доброго времени суток,

после переезда на новый сервер с самого начала начал падать mysql-сервер (version 5.7.22) , по логам вылетает ошибка mysqld got signal 11 , после этого сервер перезагружается, самое неприятное, что иногда из-за этого падения повреждаются таблицы.

Падает сервер в рандомное время, независимо от нагрузки, вчера последний раз упал ночью, когда онлайн был 50 человек.

Сервер — Intel® Core™ i7-6700 Quadcore Skylake , 2 x 500 GB SSD SATA-III, 64 GB DDR4

Ось — Linux server0 4.9.0-5-amd64 #1 SMP Debian 4.9.65-3+deb9u2 (2018-01-04) x86_64 GNU/Linux

Mysql version — 5.7.22

ошибка mysqld got signal 11

16:47:15 UTC - mysqld got signal 11 ;

This could be because you hit a bug. It is also possible that this binary

or one of the libraries it was linked against is corrupt, improperly built,

or misconfigured. This error can also be caused by malfunctioning hardware.

Attempting to collect some information that could help diagnose the problem.

As this is a crash and something is definitely wrong, the information

collection process might fail.

key_buffer_size=8388608

read_buffer_size=131072

max_used_connections=102

max_threads=1500

thread_count=8

connection_count=8

It is possible that mysqld could use up to

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 604254 K  bytes of memory

Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x7f4a2742f8c0

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...

stack_bottom = 7f4b21dd3e80 thread_stack 0x40000

/usr/sbin/mysqld(my_print_stacktrace+0x2c)[0x563e387cf1ec]

/usr/sbin/mysqld(handle_fatal_signal+0x479)[0x563e380fde59]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7f4d4c9270c0]

/usr/sbin/mysqld(_ZN5Field2eqEPS_+0x2)[0x563e38132a02]

/usr/sbin/mysqld(+0xad6be9)[0x563e38582be9]

/usr/sbin/mysqld(_ZN4JOIN14make_join_planEv+0x414)[0x563e385942e4]

/usr/sbin/mysqld(_ZN4JOIN8optimizeEv+0x69c)[0x563e38595f6c]

/usr/sbin/mysqld(_ZN13st_select_lex8optimizeEP3THD+0x692)[0x563e385dc582]

/usr/sbin/mysqld(_Z12handle_queryP3THDP3LEXP12Query_resultyy+0x20c)[0x563e385dc7fc]

/usr/sbin/mysqld(+0x61be6d)[0x563e380c7e6d]

/usr/sbin/mysqld(_Z21mysql_execute_commandP3THDb+0x48e7)[0x563e385a04a7]

/usr/sbin/mysqld(_Z11mysql_parseP3THDP12Parser_state+0x395)[0x563e385a2ab5]

/usr/sbin/mysqld(_Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command+0xfc4)[0x563e385a3b74]

/usr/sbin/mysqld(_Z10do_commandP3THD+0x197)[0x563e385a4f27]

/usr/sbin/mysqld(handle_connection+0x270)[0x563e38660320]

/usr/sbin/mysqld(pfs_spawn_thread+0x1b4)[0x563e38b35314]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x7494)[0x7f4d4c91d494]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f4d4b169acf]

Trying to get some variables.

месяц назад падал еще с ошибкой mysqld got signal 6

04:58:50 UTC - mysqld got signal 6 ;

This could be because you hit a bug. It is also possible that this binary

or one of the libraries it was linked against is corrupt, improperly built,

or misconfigured. This error can also be caused by malfunctioning hardware.

Attempting to collect some information that could help diagnose the problem.

As this is a crash and something is definitely wrong, the information

collection process might fail.

key_buffer_size=8388608

read_buffer_size=131072

max_used_connections=8

max_threads=1500

thread_count=3

connection_count=3

It is possible that mysqld could use up to

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 604254 K  bytes of memory

Hope that's ok; if not, decrease some variables in the equation.




  


                       
  




Thread pointer: 0x7f9dcc012d40

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...

stack_bottom = 7f9e33339e80 thread_stack 0x40000

/usr/sbin/mysqld(my_print_stacktrace+0x2c)[0x55c5db9c21ec]

/usr/sbin/mysqld(handle_fatal_signal+0x479)[0x55c5db2f0e59]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x110c0)[0x7fa05cd280c0]

/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcf)[0x7fa05b4b4fff]

/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7fa05b4b642a]

/usr/sbin/mysqld(+0x628387)[0x55c5db2c7387]

/usr/sbin/mysqld(_ZN2ib5fatalD1Ev+0x12d)[0x55c5dbb90c8d]

/usr/sbin/mysqld(_Z16buf_page_get_genRK9page_id_tRK11page_size_tmP11buf_block_tmPKcmP5mtr_tb+0xa18)[0x55c5dbbcb8b8]

/usr/sbin/mysqld(_Z27btr_cur_search_to_nth_levelP12dict_index_tmPK8dtuple_t15page_cur_mode_tmP9btr_cur_tmPKcmP5mtr_t+0x7b6)[0x55c5dbbad0e6]

/usr/sbin/mysqld(+0xe62429)[0x55c5dbb01429]

/usr/sbin/mysqld(_Z15row_search_mvccPh15page_cur_mode_tP14row_prebuilt_tmm+0x1b90)[0x55c5dbb081f0]

/usr/sbin/mysqld(_ZN11ha_innobase13general_fetchEPhjj+0x6a)[0x55c5db9fef9a]

/usr/sbin/mysqld(_ZN7handler13ha_index_prevEPh+0x1c5)[0x55c5db33e4c5]

/usr/sbin/mysqld(_Z19join_read_prev_sameP11READ_RECORD+0x24)[0x55c5db760f84]

/usr/sbin/mysqld(_Z10sub_selectP4JOINP7QEP_TABb+0x187)[0x55c5db767be7]

/usr/sbin/mysqld(_ZN4JOIN4execEv+0x370)[0x55c5db7609f0]

/usr/sbin/mysqld(_Z12handle_queryP3THDP3LEXP12Query_resultyy+0x233)[0x55c5db7cf823]

/usr/sbin/mysqld(+0x61be6d)[0x55c5db2bae6d]

/usr/sbin/mysqld(_Z21mysql_execute_commandP3THDb+0x48e7)[0x55c5db7934a7]

/usr/sbin/mysqld(_Z11mysql_parseP3THDP12Parser_state+0x395)[0x55c5db795ab5]

/usr/sbin/mysqld(_Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command+0xfc4)[0x55c5db796b74]

/usr/sbin/mysqld(_Z10do_commandP3THD+0x197)[0x55c5db797f27]

/usr/sbin/mysqld(handle_connection+0x270)[0x55c5db853320]

/usr/sbin/mysqld(pfs_spawn_thread+0x1b4)[0x55c5dbd28314]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x7494)[0x7fa05cd1e494]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7fa05b56aacf]

Trying to get some variables.

Some pointers may be invalid and cause the dump to abort.

show global status https://www.pastiebin.com/5b3089648d76d

SHOW VARIABLES https://www.pastiebin.com/5b30899861180

TOP

Коллеги, помогите плиз:

У нас стоит Vbulletin 3.8.4 — постоянно слетают одни и теже таблицы, если во время не починить, слетает вся база…

Таблицы: thread, session — причем в пхпмайадмине статус этих таблиц — «используется», после починки становятся нормальные, если непочинить — база отваливается, потом опять все заново…

Вот лог:

————————-
Ошибка базы данных в vBulletin 3.8.4:
Invalid SQL:
SELECT IF(visible = 2, 1, 0) AS isdeleted,
thread.*
FROM vb_forum_thread AS thread
WHERE thread.threadid = 33059;

Ошибка MySQL : Table ‘./db_base/_forum_thread’ is marked as crashed and should be repaired
Номер ошибки : 145
Дата запроса : Wednesday, November 4th 2009 @ 12:06:05 AM
Дата ошибки : Wednesday, November 4th 2009 @ 12:06:05 AM
Скрипт : http://www.***.ru/_forum/showthread….ewpost&t=33059
Реферрер : http://www.***.ru/_forum/
IP адрес : ————-
Имя пользователя : ***
Имя класса : vB_Database
Версия MySQL : 5.0.51a-community-log
————————-

Включили логи MySQL:

—————————————————————————
091109 10:48:35 mysqld started
091109 10:48:36 [Warning] Asked for 196608 thread stack, but got 126976
091109 10:48:36 InnoDB: Started; log sequence number 0 43655
091109 10:48:36 [Note] /usr/sbin/mysqld: ready for connections.
Version: ‘5.0.51a-community-log’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 MySQL Community Edition (GPL)
091109 13:17:22 — mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=268435456
read_buffer_size=126976
max_used_connections=15
max_connections=1024
threads_connected=2
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 389112 K
bytes of memory
Hope that’s ok; if not, decrease some variables in the equation.

thd=0xa682e3f0
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…
Cannot determine thread, fp=0xbf7de618, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x80a94ae
0x836dd38
0x818a7a7
0x818a772
0x818a735
0x818a6b2
0x818964a
0x8116843
0x80bdcf2
0x80c2a53
0x80ba79b
0x80ba083
0x80b9525
0x836b4ec
0x83959ca
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://dev.mysql.com/doc/mysql/en/us…ack-trace.html and follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort…
thd->query at 0x8b4bc40 = UPDATE vb_forum_user AS user

thd->thread_id=63280
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.

Number of processes running now: 0
091109 13:17:22 mysqld restarted
091109 13:17:22 [Warning] Asked for 196608 thread stack, but got 126976
091109 13:17:22 InnoDB: Started; log sequence number 0 43655
091109 13:17:23 [Note] /usr/sbin/mysqld: ready for connections.
Version: ‘5.0.51a-community-log’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 MySQL Community Edition (GPL)
091109 13:19:03 [ERROR] Got error 134 when reading table ‘./db_lacetticlub3/vb_forum_session’
091109 13:19:08 [ERROR] /usr/sbin/mysqld: Incorrect key file for table ‘./db_lacetticlub3/vb_forum_forumread.MYI’; try to repair it
091109 13:19:08 [ERROR] /usr/sbin/mysqld: Incorrect key file for table ‘./db_lacetticlub3/vb_forum_forumread.MYI’; try to repair it
091109 13:19:08 [ERROR] /usr/sbin/mysqld: Incorrect key file for table ‘./db_lacetticlub3/vb_forum_session.MYI’; try to repair it
091109 13:19:08 [ERROR] Got error 134 when reading table ‘./db_lacetticlub3/vb_forum_session’
091109 13:19:29 [ERROR] /usr/sbin/mysqld: Incorrect key file for table ‘./db_lacetticlub3/vb_forum_session.MYI’; try to repair it
091109 13:19:57 [ERROR] Got error 134 when reading table ‘./db_lacetticlub3/vb_forum_session’
091109 13:19:57 [ERROR] /usr/sbin/mysqld: Incorrect key file for table ‘./db_lacetticlub3/vb_forum_session.MYI’; try to repair it
091109 13:20:03 [ERROR] /usr/sbin/mysqld: Incorrect key file for table ‘./db_lacetticlub3/vb_forum_session.MYI’; try to repair it
091109 13:20:03 [ERROR] /usr/sbin/mysqld: Incorrect key file for table ‘./db_lacetticlub3/vb_forum_session.MYI’; try to repair it
091109 13:20:06 [ERROR] /usr/sbin/mysqld: Table ‘./db_lacetticlub3/vb_forum_forumread’ is marked as crashed and should be repaired
091109 13:20:06 [ERROR] /usr/sbin/mysqld: Table ‘./db_lacetticlub3/vb_forum_forumread’ is marked as crashed and should be repaired
091109 13:20:07 [ERROR] /usr/sbin/mysqld: Table ‘./db_lacetticlub3/vb_forum_session’ is marked as crashed and should be repaired
091109 13:20:07 [ERROR] /usr/sbin/mysqld: Table ‘./db_lacetticlub3/vb_forum_session’ is marked as crashed and should be repaired
—————————————————————————
последняя запись еще растягивается на нное кол-во строк, после того, как руками профиксил — все заработало…

Стоит SELinux, MySQL 5.0.51a-community-log

В чем может быть дело? Уже голову сломали ((

Спасибо!

The bug is reproducible:

CREATE DATABASE `test` /*!40100 COLLATE ‘utf8_general_ci’ */;
USE `test`;
CREATE TABLE `t1` (
`c1` INT NULL
)
COLLATE=’utf8_general_ci’
;
SET STATEMENT max_statement_time=900 FOR LOCK TABLES `t1` WRITE

190719 20:17:34 [ERROR] mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

Server version: 10.4.6-MariaDB-1:10.4.6+maria~bionic-log
key_buffer_size=8388608
read_buffer_size=393216
max_used_connections=3
max_threads=82
thread_count=10
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 713412 K bytes of memory
Hope that’s ok; if not, decrease some variables in the equation.

Thread pointer: 0x7f0fe0000c08
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…
stack_bottom = 0x7f11a0744dd8 thread_stack 0x40000
/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55afef2d9e0e]
/usr/sbin/mysqld(handle_fatal_signal+0x515)[0x55afeed52f95]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x12890)[0x7f11a7ffa890]
/usr/sbin/mysqld(_ZN13st_select_lex17add_table_to_listEP3THDP11Table_identP25st_mysql_const_lex_stringm13thr_lock_type13enum_mdl_typeP4ListI10Index_hintEPS8_I6StringEP19st_mysql_lex_string+0x214)[0x55afeeb3eb04]
/usr/sbin/mysqld(_Z10MYSQLparseP3THD+0xa569)[0x55afeece77a9]
/usr/sbin/mysqld(_Z9parse_sqlP3THDP12Parser_stateP19Object_creation_ctxb+0x13d)[0x55afeeb42a5d]
/usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x146)[0x55afeeb4b636]
/usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x166d)[0x55afeeb4dedd]
/usr/sbin/mysqld(_Z10do_commandP3THD+0x148)[0x55afeeb4f348]
/usr/sbin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x2c2)[0x55afeec2a542]
/usr/sbin/mysqld(handle_one_connection+0x3d)[0x55afeec2a60d]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76db)[0x7f11a7fef6db]
/lib/x86_64-linux-gnu/libc.so.6(clone+0x3f)[0x7f11a73ed88f]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7f0fe0010000): SET STATEMENT max_statement_time=900 FOR LOCK TABLES `t1` WRITE
Connection ID (thread ID): 14
Status: NOT_KILLED

Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
Writing a core file…
Working directory at /var/lib/mysql/sw21dev
Resource Limits:
Limit Soft Limit Hard Limit Units
Max cpu time unlimited unlimited seconds
Max file size unlimited unlimited bytes
Max data size unlimited unlimited bytes
Max stack size 8388608 unlimited bytes
Max core file size 0 unlimited bytes
Max resident set unlimited unlimited bytes
Max processes 31664 31664 processes
Max open files 16364 16364 files
Max locked memory 16777216 16777216 bytes
Max address space unlimited unlimited bytes
Max file locks unlimited unlimited locks
Max pending signals 31664 31664 signals
Max msgqueue size 819200 819200 bytes
Max nice priority 0 0
Max realtime priority 0 0
Max realtime timeout unlimited unlimited us
Core pattern: |/usr/share/apport/apport %p %s %c %d %P