mysql client aborts connection on terminal resize
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
|||
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Medium
|
Sergei Glushchenko | ||
5.1 |
Invalid
|
Undecided
|
Unassigned | ||
5.5 |
Fix Released
|
Medium
|
Sergei Glushchenko | ||
5.6 |
Fix Released
|
Medium
|
Sergei Glushchenko |
Bug Description
While running various sql scripts we hit "Lost connection to MySQL server during query" frequently.
Have tried both, network and unix socket for connection => same result. We have increased all timeout variables as well.
We use mysqld_multi for multiple percona installs.
OS: CentOS 6
Pkgs:
Percona-
Percona-
Percona-
percona-
Percona-
The database itself is quite large: 72G (du -sh)
All "InnoDB" tables.
[mysqld5]
socket = /var/lib/
port = 3311
datadir = /var/lib/mysql-db
max_connections = 300
innodb_
query_cache_size = 500M
log-bin = server-db-bin
relay-log = server-db-relay-bin
log-slave-updates
log_slow_queries = server-db-slow.log
long_query_time = 5
log-warnings
expire_logs_days = 7
binlog_format = MIXED
[mysqld]
basedir = /usr
datadir = /var/lib/mysql
port = 3306
socket = /var/lib/
max_allowed_packet = 64M
table_cache = 2048
max_heap_table_size = 256M
tmp_table_size = 256M
join_buffer_size = 3M
sort_buffer_size = 4M
read_buffer_size = 1M
read_rnd_
myisam_
thread_cache_size = 256
query_cache_limit = 4M
low_priority_
innodb_
innodb_
innodb_
innodb_
innodb_flush_method = O_DIRECT
innodb_
server-id = 10
skip-slave-start
old_passwords = 1
character-
net_read_timeout = 240
net_write_timeout = 240
connect_timeout = 240
tmpdir = /data/mysqltmp/
[mysqld_multi]
mysqld = /usr/bin/
mysqladmin = /usr/bin/mysqladmin
log = /var/log/
Any hint on what is going wrong here? The frequent "lost connection" makes any db upgrade process very painful.
We have not seen this issue before, using vanilla mysql 5.0 and 5.1.
Related branches
- Alexey Kopytov (community): Approve
- Stewart Smith (community): Approve
-
Diff: 66 lines (+7/-16)1 file modifiedPercona-Server/client/mysql.cc (+7/-16)
- Stewart Smith (community): Approve
-
Diff: 66 lines (+7/-16)1 file modifiedPercona-Server/client/mysql.cc (+7/-16)
Changed in percona-server: | |
importance: | Undecided → Medium |
summary: |
- Timeouts during long running scripts + mysql client aborts connection on terminal resize |
Might be related to bug #805805. Any chance that gdb or strace are being used against the server process when this issue occurs?