Lost connection to MySQL server during query when i resize terminator window

[Michael Kozma]

When I inject a database dump into mysql, I lose the connection to mysql server as soon as I try to change the size of one of my windows in terminator.

I use 5 windows described here and i want to move the largest vertical bar :

___________________________
| | |
| | |
| | |
-----------------------------------------
| | | |
| | | |
| | | |
| | | |
-----------------------------------------

Examples below :

root@host:/home/www/backupbdd# mysql -u user -p database < backup_db-1.sql
Enter password:
ERROR 2013 (HY000) at line 2043: Lost connection to MySQL server during query
root@host:/home/www/backupbdd# mysql -u user -p database < backup_db-1.sql
Enter password:
ERROR 2013 (HY000) at line 131: Lost connection to MySQL server during query

My version of terminator is : 0.97 running on Ubuntu 14.04.2 LTS

[Stephen Boddy (stephen-j-boddy)]

Does this happen in other terminals too? I fairly certain that the problem is because the kernel sends a SIGWINCH (WINdow CHange) signal to the foreground process group (e.g. the running instance of mysql) of that pty, and mysql cannot handle it and exits. In fact:
https://bugs.mysql.com/bug.php?id=62578

Which version are you using? Someone comments that "I can confirm the problem still exists in 5.5.32 but not in 5.6.12."

A workaround might be to nohup/disown the process, and redirect the output to a temporary file, and tail the temporary file. I haven't tested that. In theory your mysql process would not then receive the signal.

[Michael Kozma (myckeul)]

Le mercredi 13 mai 2015 à 16:48 +0000, Stephen Boddy a écrit :
> Does this happen in other terminals too? I fairly certain that the problem is because the kernel sends a SIGWINCH (WINdow CHange) signal to the foreground process group (e.g. the running instance of mysql) of that pty, and mysql cannot handle it and exits. In fact:
> https://bugs.mysql.com/bug.php?id=62578
>
> Which version are you using? Someone comments that "I can confirm the
> problem still exists in 5.5.32 but not in 5.6.12."
>
> A workaround might be to nohup/disown the process, and redirect the
> output to a temporary file, and tail the temporary file. I haven't
> tested that. In theory your mysql process would not then receive the
> signal.
>
> ** Bug watch added: MySQL Bug System #62578
> http://bugs.mysql.com/bug.php?id=62578
>
> ** Changed in: terminator
> Status: New => Invalid
>

Hi,

It is indeed the mysql bug, i have same issue with gnome-terminal.

You can close this bug.

Regards,