a@UBINTI:~/env1$ m7-system2/shutdown.sh
|
a@UBINTI:~/env1$ m7-system2/startup.sh
|
171026 16:35:36 mysqld_safe Logging to '/home/a/env1/m7-system2/dt/error.log'.
|
171026 16:35:36 mysqld_safe Starting mysqld daemon with databases from /home/a/env1/m7-system2/dt
|
mysqld is alive
|
a@UBINTI:~/env1$ bash spawn_sql.sh
|
+------------------+-------+
|
| Variable_name | Value |
|
+------------------+-------+
|
| Aborted_clients | 0 |
|
| Aborted_connects | 0 |
|
+------------------+-------+
|
number of errors: 0
|
a@UBINTI:~/env1$ bash spawn_sql.sh
|
+------------------+-------+
|
| Variable_name | Value |
|
+------------------+-------+
|
| Aborted_clients | 0 |
|
| Aborted_connects | 0 |
|
+------------------+-------+
|
number of errors: 0
|
a@UBINTI:~/env1$ bash spawn_sql.sh
|
+------------------+-------+
|
| Variable_name | Value |
|
+------------------+-------+
|
| Aborted_clients | 0 |
|
| Aborted_connects | 4 |
|
+------------------+-------+
|
number of errors: 46
|
a@UBINTI:~/env1$ m7-system2/shutdown.sh
|
a@UBINTI:~/env1$ m7-system2/startup.sh
|
171026 16:36:12 mysqld_safe Logging to '/home/a/env1/m7-system2/dt/error.log'.
|
171026 16:36:12 mysqld_safe Starting mysqld daemon with databases from /home/a/env1/m7-system2/dt
|
mysqld is alive
|
a@UBINTI:~/env1$ pidof bash
|
5757 5030 3777
|
a@UBINTI:~/env1$ bash spawn_sql.sh
|
+------------------+-------+
|
| Variable_name | Value |
|
+------------------+-------+
|
| Aborted_clients | 0 |
|
| Aborted_connects | 0 |
|
+------------------+-------+
|
number of errors: 250
|
a@UBINTI:~/env1$ bash spawn_sql.sh
|
+------------------+-------+
|
| Variable_name | Value |
|
+------------------+-------+
|
| Aborted_clients | 0 |
|
| Aborted_connects | 0 |
|
+------------------+-------+
|
number of errors: 0
|
a@UBINTI:~/env1$ bash spawn_sql.sh
|
+------------------+-------+
|
| Variable_name | Value |
|
+------------------+-------+
|
| Aborted_clients | 0 |
|
| Aborted_connects | 0 |
|
+------------------+-------+
|
number of errors: 0
|
a@UBINTI:~/env1$ m7-system2/shutdown.sh
|
a@UBINTI:~/env1$ m7-system2/startup.sh
|
171026 16:36:49 mysqld_safe Logging to '/home/a/env1/m7-system2/dt/error.log'.
|
171026 16:36:49 mysqld_safe Starting mysqld daemon with databases from /home/a/env1/m7-system2/dt
|
mysqld is alive
|
a@UBINTI:~/env1$ bash spawn_sql.sh
|
+------------------+-------+
|
| Variable_name | Value |
|
+------------------+-------+
|
| Aborted_clients | 0 |
|
| Aborted_connects | 0 |
|
+------------------+-------+
|
number of errors: 161
|
a@UBINTI:~/env1$ bash spawn_sql.sh
|
+------------------+-------+
|
| Variable_name | Value |
|
+------------------+-------+
|
| Aborted_clients | 0 |
|
| Aborted_connects | 0 |
|
+------------------+-------+
|
number of errors: 0
|
a@UBINTI:~/env1$ bash spawn_sql.sh
|
+------------------+-------+
|
| Variable_name | Value |
|
+------------------+-------+
|
| Aborted_clients | 0 |
|
| Aborted_connects | 0 |
|
+------------------+-------+
|
number of errors: 49
|
a@UBINTI:~/env1$ bash spawn_sql.sh
|
+------------------+-------+
|
| Variable_name | Value |
|
+------------------+-------+
|
| Aborted_clients | 0 |
|
| Aborted_connects | 0 |
|
+------------------+-------+
|
number of errors: 0
|
The problem is the easiest to reproduce on freshly started server, but it may happen after some uptime (the more idle server had, the easiest to reproduce) as well.
Start server with max_connections=600 and use script with following content to generate burst of 600 simultaneous connections:
# make sure that all spawned processes are cleaned up
# clean up previous logs
done
a@UBINTI:~/env1$ m7-system2/shutdown.sh
a@UBINTI:~/env1$ m7-system2/startup.sh
171026 16:35:36 mysqld_safe Logging to '/home/a/env1/m7-system2/dt/error.log'.
171026 16:35:36 mysqld_safe Starting mysqld daemon with databases from /home/a/env1/m7-system2/dt
mysqld is alive
a@UBINTI:~/env1$ bash spawn_sql.sh
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
+------------------+-------+
number of errors: 0
a@UBINTI:~/env1$ bash spawn_sql.sh
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
+------------------+-------+
number of errors: 0
a@UBINTI:~/env1$ bash spawn_sql.sh
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| Aborted_clients | 0 |
| Aborted_connects | 4 |
+------------------+-------+
number of errors: 46
a@UBINTI:~/env1$ m7-system2/shutdown.sh
a@UBINTI:~/env1$ m7-system2/startup.sh
171026 16:36:12 mysqld_safe Logging to '/home/a/env1/m7-system2/dt/error.log'.
171026 16:36:12 mysqld_safe Starting mysqld daemon with databases from /home/a/env1/m7-system2/dt
mysqld is alive
a@UBINTI:~/env1$ pidof bash
5757 5030 3777
a@UBINTI:~/env1$ bash spawn_sql.sh
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
+------------------+-------+
number of errors: 250
a@UBINTI:~/env1$ bash spawn_sql.sh
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
+------------------+-------+
number of errors: 0
a@UBINTI:~/env1$ bash spawn_sql.sh
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
+------------------+-------+
number of errors: 0
a@UBINTI:~/env1$ m7-system2/shutdown.sh
a@UBINTI:~/env1$ m7-system2/startup.sh
171026 16:36:49 mysqld_safe Logging to '/home/a/env1/m7-system2/dt/error.log'.
171026 16:36:49 mysqld_safe Starting mysqld daemon with databases from /home/a/env1/m7-system2/dt
mysqld is alive
a@UBINTI:~/env1$ bash spawn_sql.sh
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
+------------------+-------+
number of errors: 161
a@UBINTI:~/env1$ bash spawn_sql.sh
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
+------------------+-------+
number of errors: 0
a@UBINTI:~/env1$ bash spawn_sql.sh
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
+------------------+-------+
number of errors: 49
a@UBINTI:~/env1$ bash spawn_sql.sh
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
+------------------+-------+
number of errors: 0