[MDEV-5537] mariadb keeps crashing Created: 2014-01-17  Updated: 2014-03-03  Due: 2014-02-20  Resolved: 2014-03-03

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.34
Fix Version/s: None

Type: Bug Priority: Critical
Reporter: robert cerulli Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: None
Environment:

ubuntu 13.10, vmware workstation 10 VM
Linux 350z 3.11.0-14-generic #21-Ubuntu SMP Tue Nov 12 17:04:55 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
Using mariadb ubuntu repos. DB on XFS part with mount options rw,noatime,nodiratime,nobarrier,logbufs=8,logbsize=32k 0 0


 Description   

Server keeps crashing randomly

140113  8:52:24 [ERROR] mysqld got signal 11 ;
 
Server version: 5.5.34-MariaDB-1~saucy-log
 
key_buffer_size=8388608
 
read_buffer_size=8388608
 
max_used_connections=50
 
max_threads=102
 
thread_count=29
 
It is possible that mysqld could use up to
 
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1054475 K  bytes of memory
 
Hope that's ok; if not, decrease some variables in the equation.
 
 
 
Thread pointer: 0x0x7fe8a2cac000
 
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 = 0x7fea5949cda0 thread_stack 0x30000
 
??:0(??)[0x7febd07b789e]
 
??:0(??)[0x7febd03ade17]
 
??:0(??)[0x7febcf45ebb0]
 
??:0(??)[0x7febd051c79d]
 
??:0(??)[0x7febd066f734]
 
??:0(??)[0x7febd0670a5c]
 
??:0(??)[0x7febd065d6ac]
 
??:0(??)[0x7febd06437b7]
 
??:0(??)[0x7febd05fe200]
 
??:0(??)[0x7febd05cefe1]
 
??:0(??)[0x7febd028f2e8]
 
??:0(??)[0x7febd029e9b3]
 
??:0(??)[0x7febd02a9b5d]
 
??:0(??)[0x7febd02bb287]
 
??:0(??)[0x7febd02bd2ed]
 
??:0(??)[0x7febd02617b9]
 
??:0(??)[0x7febd026e4c4]
 
??:0(??)[0x7febd027156a]
 
??:0(??)[0x7febd0273690]
 
??:0(??)[0x7febd032cd43]
 
??:0(??)[0x7febd032ce3a]
 
??:0(??)[0x7febd051bfd1]
 
??:0(??)[0x7febcf456f6e]
 
??:0(??)[0x7febce53f9cd]
 
Trying to get some variables.
 
Some pointers may be invalid and cause the dump to abort.
 
Query (0x7fe8a290c018): is an invalid pointer
 
Connection ID (thread ID): 35367
 
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=off,table_elimination=on,extended_keys=off



 Comments   
Comment by Sergei Golubchik [ 2014-01-20 ]

Do you know what statement caused this? Can you attach your my.cnf file to the bug report?

Comment by robert cerulli [ 2014-01-20 ]

More data - this is what casuses to crash, i dont know the exact statment as its an application im using and did not write

Error: queryDirect: SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query
 
 
 
PHP Warning:  Invalid argument supplied for foreach() in /var/www/nZEDb/www/lib/framework/db.php on line 310
 
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query' in /var/www/nZEDb/www/lib/releases.php:1578
 
Stack trace:
 
#0 /var/www/nZEDb/www/lib/releases.php(1578): PDOStatement->execute()
 
#1 /var/www/nZEDb/misc/update_scripts/nix_scripts/tmux/bin/update_releases.php(52): Releases->processReleasesStage7a('40', true)
 
#2 {main}
 
  thrown in /var/www/nZEDb/www/lib/releases.php on line 1578

Comment by robert cerulli [ 2014-01-20 ] 

[client]
 
port                                                            = 3306
 
socket                                                          =/var/lib/mysql/mysql.sock
 
default-character-set                           = utf8
 
 
 
[mysqld_safe]
 
socket                                                          = /var/lib/mysql/mysql.sock
 
nice                                                            = 0
 
 
 
[mysqld]
 
user                                                            = mysql
 
pid-file                                                        = /var/lib/mysql/mysql.pid
 
socket                                                          = /var/lib/mysql/mysql.sock
 
port                                                            = 3306
 
basedir                                                         = /usr
 
datadir                                                         = /var/lib/mysql
 
#tmpdir                                                         = /dev/shm
 
tmpdir                                                          = /tmp
 
character-set-server                            = utf8
 
performance_schema                                      = on
 
 
 
transaction-isolation                           = READ-COMMITTED
 
 
 
lc-messages-dir                                         = /usr/share/mysql
 
skip-external-locking
 
 
 
#inndb recovery mode
 
innodb_force_recovery                           = 0
 
 
 
max-connections                                         = 100
 
max_allowed_packet                                      = 32M
 
thread_stack                                            = 192K
 
thread_cache_size                               = 20
 
group_concat_max_len                            = 8192
 
 
 
tmp_table_size                                          = 2G
 
max_heap_table_size                                     = 2G
 
table_open_cache                                        = 20000
 
low_priority_updates                            = 1
 
concurrent_insert                                       = ALWAYS
 
join_buffer_size                                        = 64M
 
key_buffer_size                                         = 8M
 
read_buffer_size                                        = 8M
 
 
 
#explicit_defaults_for_timestamp        = TRUE
 
 
 
myisam-recover-options                          = BACKUP
 
#max_connections                                = 100
 
#table_cache                                    = 64
 
#thread_concurrency                             = 10
 
 
 
query_cache_limit                                       = 64M
 
query_cache_size                                        = 1G
 
#query_cache_size                                       = 0
 
 
 
#general_log_file                                       = /var/log/mysql/mysql.log
 
#general_log                                            = 1
 
log_error                                                       = /var/log/mysql/error.log
 
 
 
slow-query-log                                          = 1
 
slow_query_log_file                                     = /var/log/mysql/mysql-slow.log
 
long_query_time                                         = 5
 
#log-queries-not-using-indexes
 
 
 
#innodb_ft_min_token_size                       = 1
 
 
 
max_user_connections                            = 200
 
#table_cache                                            = 4000
 
 
 
#InnoDB specifics
 
 
 
#Engine options
 
innodb                                                          = ON
 
innodb_file_format                                      = Barracuda
 
innodb_file_per_table                           = 1
 
 
 
#misc uncategorized
 
innodb_table_locks                                      = false
 
innodb_lock_wait_timeout                        = 240
 
innodb_use_sys_malloc                           = 1
 
 
 
#threading
 
innodb_thread_concurrency                       = 0                     #or set to 0 and let mysql decide what it needs
 
innodb_read_io_threads                          = 64
 
innodb_write_io_threads                         = 64
 
innodb_purge_threads                            = 1
 
 
 
#buffer pool related
 
innodb_buffer_pool_size                         = 4G
 
innodb_buffer_pool_instances            = 4                     # each buffer pool instance should be at least 1 gigabyte
 
innodb_change_buffering                         = all
 
innodb_max_dirty_pages_pct                      = 90
 
#innodb_page_size                               = 4k
 
#innodb_flush_neighbors                         = 0
 
 
 
#expand_fast_index_creation                     = 1
 
#innodb_merge_sort_block_size           = 1G
 
 
 
#flush related
 
innodb_flush_method                             = O_DIRECT
 
innodb_flush_log_at_trx_commit          = 0
 
 
 
#transaction logs
 
innodb_log_buffer_size                          = 1G
 
innodb_log_files_in_group                       = 2
 
innodb_log_file_size                            = 2500M #this should be 25% of innodb_buffer_pool_size
 
 
 
[mysqldump]
 
quick
 
quote-names
 
max_allowed_packet                                      = 32M
 
 
 
[mysql]
 
#no-auto-rehash # faster start of mysql but no tab completition
 
 
 
[isamchk]
 
key_buffer_size                                         = 16M
 
 
 
#
 
# * IMPORTANT: Additional settings that can override those from this file!
 
#   The files must end with '.cnf', otherwise they'll be ignored.
 
#
 
!includedir /etc/mysql/conf.d/

Comment by robert cerulli [ 2014-01-20 ]

as a note, i moved the DB to a new set of disks and to EXT4 and its still crashing

Comment by Sergei Golubchik [ 2014-01-27 ]

Let's try that with 5.5.35 — you should get a better stack trace there, not just ":0()", that might help.

Or, perhaps one of the 5.5.35 bugfixes covers your case too, and the crash will go away completely — we've fixed quite a few issues related to prepared statements in this release.

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