percona-server-5.7.19-17 crash
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Incomplete
|
Undecided
|
Unassigned |
Bug Description
1. the following part is crash information.
04:42:11 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.
Please help us make Percona Server better by reporting any
bugs at http://
key_buffer_
read_buffer_
max_used_
max_threads=2001
thread_count=220
connection_
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x7f4b6800a3e0
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 = 7f4a87fbde80 thread_stack 0x40000
/usr/local/
/usr/local/
/lib64/
/lib64/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/usr/local/
/lib64/
/lib64/
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f4b6800f100): is an invalid pointer
Connection ID (thread ID): 122
Status: NOT_KILLED
2. my.cnf as follows
# For advice on how to change settings please see
# http://
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[client]
#default-
[mysqld_multi]
mysqld = /usr/local/
mysqladmin = /usr/local/
log = /usr/local/
user = root
[mysqld1]
port=3306
pid-file=
log-error=
socket=
datadir=
slow_query_
log-bin=
log-bin-
relay-log=
relay-log-
innodb_
innodb_
server-id=603306
[mysqld2]
port=3307
pid-file=
log-error=
socket=
datadir=
slow_query_
log-bin=
log-bin-
relay-log=
relay-log-
innodb_
innodb_
server-id=603307
slave-skip-
# 因为 3307 原本是用默认设置12M, 假如改为1G启动,则会报
innodb_
[mysqld3]
port=3308
pid-file=
log-error=
socket=
datadir=
slow_query_
log-bin=
log-bin-
relay-log=
relay-log-
innodb_
innodb_
server-id=603308
read-only=1
[mysqld4]
port=3309
pid-file=
log-error=
socket=
datadir=
slow_query_
log-bin=
log-bin-
relay-log=
relay-log-
innodb_
innodb_
server-id=603309
#binlog_
read-only=1
[mysqld]
basedir=
skip-external-
# gtid set on
enforce_
gtid_mode = on
master_
relay_log_
relay_log_
#skip-federated
character-
init_connect='SET collation_
init_connect='SET NAMES utf8mb4'
#init_connect='SET GLOBAL MASTER_
#init_connect='SET GLOBAL RELAY_LOG_
#character-
collation-
skip-character-
#skip-grant-tables
user = mysql
lower_case_
innodb_
skip-name-resolve
key_buffer_size=64M
max_allowed_
table_open_
sort_buffer_size=2M
myisam_
thread_cache_size=8
#thread_
query_cache_
max_binlog_
binlog_
wait_timeout=3600
interactive_
read_rnd_
join_buffer_
tmp_table_
max_heap_
max_connections
max_connect_
expire_logs_days=10
event-scheduler=on
log-bin-
binlog_format=ROW
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
#innodb_
innodb_
explicit_
innodb_
innodb_
log_slave_updates
slave_compresse
binlog-
binlog-
replicate-
replicate-
replicate-
slave-skip-errors = 1062
# mcafee_ 变量没有落盘
#auto_increment
#auto_increment
# slave
#slave-
#slave-
sql_mode=
[mysqld_safe]
#malloc-lib = /usr/local/
#malloc-lib = tcmalloc
[mysqldump]
quick
max_allowed_
[mysql]
#no-auto-rehash
#prompt=\U|d>
#default-
[isamchk]
sort_buffer_
read_buffer=2M
write_buffer=2M
[mysqlhotcopy]
interactive-timeout
sql_mode=
3. server version: as the title describing: percona-
Changed in percona-server: | |
assignee: | nobody → Vishal kasle (vishal.percona) |
Changed in percona-server: | |
status: | New → Incomplete |
assignee: | Vishal kasle (vishal.percona) → nobody |
before crashing, there are many access denied by server due to the password modified for the user.
i don't know whether it matters or not. I will try to reproduce the bug .