I have a vds with mysql on it and all my servers start timing out and going offline/online every second. John said that it wasnt a attack, or a exploit from either A2S attack or anything.
I also increased my cvar queries such as
sv_max_queries_sec 10000
sm_cvar sv_max_queries_sec 10000
sv_max_queries_sec_global 10000
sv_max_queries_window 10000
sv_max_queries_tracked_ips_prune 10000
this didn't work, so i went into mysql logs and every time the issue occurs where the servers time out, this pops up on mysql error log.
Code: Select all
2017-06-22T23:14:17.757926Z 80 [Note] Aborted connection 80 to db: 'donation_store' user: 'clanhost' host: 'c-192-223-28-102.internap-atlanta.nfoservers.com' (Got an error reading communication packets)
2017-06-22T23:14:17.758006Z 3022 [Note] Aborted connection 3022 to db: 'bans' user: 'clanhost' host: 'c-192-223-28-102.internap-atlanta.nfoservers.com' (Got an error reading communication packets)
2017-06-22T23:14:17.758429Z 3023 [Note] Aborted connection 3023 to db: 'bans' user: 'clanhost' host: 'c-192-223-28-102.internap-atlanta.nfoservers.com' (Got an error reading communication packets)
2017-06-22T23:15:46.411154Z 2332 [Note] Aborted connection 2332 to db: 'bans' user: 'clanhost' host: 'c-192-223-28-99.internap-atlanta.nfoservers.com' (Got timeout reading communication packets)
2017-06-22T23:15:46.494016Z 2334 [Note] Aborted connection 2334 to db: 'bans' user: 'clanhost' host: 'c-192-223-28-99.internap-atlanta.nfoservers.com' (Got timeout reading communication packets)
2017-06-22T23:15:58.389387Z 2335 [Note] Aborted connection 2335 to db: 'bans' user: 'clanhost' host: 'c-192-223-28-99.internap-atlanta.nfoservers.com' (Got timeout reading communication packets)
2017-06-22T23:15:58.477527Z 2336 [Note] Aborted connection 2336 to db: 'bans' user: 'clanhost' host: 'c-192-223-28-99.internap-atlanta.nfoservers.com' (Got timeout reading communication packets)
2017-06-22T23:18:41.159958Z 2172 [Note] Aborted connection 2172 to db: 'bans' user: 'clanhost' host: 'v-74-91-112-113.managed-vds.internap-atlanta.nfoservers.com' (Got timeout reading communication packets)
2017-06-22T23:18:41.227327Z 2173 [Note] Aborted connection 2173 to db: 'bans' user: 'clanhost' host: 'v-74-91-112-113.managed-vds.internap-atlanta.nfoservers.com' (Got timeout reading communication packets)
2017-06-22T23:19:01.725762Z 3061 [Note] Access denied for user 'backupexec'@'aqu33-h06-89-80-94-186.dsl.sta.abo.bbox.fr' (using password: YES)
2017-06-22T23:19:13.657909Z 2178 [Note] Aborted connection 2178 to db: 'bans' user: 'clanhost' host: 'v-74-91-112-113.managed-vds.internap-atlanta.nfoservers.com' (Got timeout reading communication packets)
2017-06-22T23:19:24.651164Z 2374 [Note] Aborted connection 2374 to db: 'bans' user: 'clanhost' host: 'v-74-91-112-113.managed-vds.internap-atlanta.nfoservers.com' (Got timeout reading communication packets)
2017-06-22T23:20:26.927541Z 3027 [Note] Aborted connection 3027 to db: 'bans' user: 'clanhost' host: 'c-192-223-28-102.internap-atlanta.nfoservers.com' (Got an error reading communication packets)
2017-06-22T23:20:26.927717Z 3026 [Note] Aborted connection 3026 to db: 'bans' user: 'clanhost' host: 'c-192-223-28-102.internap-atlanta.nfoservers.com' (Got an error reading communication packets)
2017-06-22T23:20:26.927734Z 3025 [Note] Aborted connection 3025 to db: 'bans' user: 'clanhost' host: 'c-192-223-28-102.internap-atlanta.nfoservers.com' (Got an error reading communication packets)
2017-06-22T23:20:26.927835Z 3030 [Note] Aborted connection 3030 to db: 'bans' user: 'clanhost' host: 'c-192-223-28-102.internap-atlanta.nfoservers.com' (Got an error reading communication packets)
2017-06-22T23:20:26.927856Z 3029 [Note] Aborted connection 3029 to db: 'bans' user: 'clanhost' host: 'c-192-223-28-102.internap-atlanta.nfoservers.com' (Got an error reading communication packets)
2017-06-22T23:20:34.367043Z 2179 [Note] Aborted connection 2179 to db: 'weaponpaints' user: 'clanhost' host: 'v-74-91-112-113.managed-vds.internap-atlanta.nfoservers.com' (Got timeout reading communication packets)
2017-06-22T23:48:30.967544Z 3430 [Note] Access denied for user 'backupexec'@'32-179-16-190.fibertel.com.ar' (using password: YES)
2017-06-23T00:01:27.130866Z 234 [Note] Aborted connection 234 to db: 'bans' user: 'clanhost' host: 'c-192-223-28-99.internap-atlanta.nfoservers.com' (Got timeout reading communication packets)
2017-06-23T00:01:27.269691Z 235 [Note] Aborted connection 235 to db: 'bans' user: 'clanhost' host: 'c-192-223-28-99.internap-atlanta.nfoservers.com' (Got timeout reading communication packets)
2017-06-23T00:03:40.063140Z 2402 [Note] Aborted connection 2402 to db: 'bans' user: 'clanhost' host: 'c-192-223-28-99.internap-atlanta.nfoservers.com' (Got timeout reading communication packets)
2017-06-23T00:08:35.652622Z 232 [Note] Aborted connection 232 to db: 'bans' user: 'clanhost' host: 'c-192-223-28-99.internap-atlanta.nfoservers.com' (Got timeout reading communication packets)
2017-06-23T00:08:35.652843Z 233 [Note] Aborted connection 233 to db: 'bans' user: 'clanhost' host: 'c-192-223-28-99.internap-atlanta.nfoservers.com' (Got timeout reading communication packets)
2017-06-23T00:17:41.269020Z 3726 [Note] Access denied for user 'backupexec'@'32-179-16-190.fibertel.com.ar' (using password: YES)
2017-06-23T00:19:14.810118Z 3072 [Note] Aborted connection 3072 to db: 'bans' user: 'clanhost' host: 'c-192-223-28-102.internap-atlanta.nfoservers.com' (Got an error reading communication packets)
2017-06-23T00:19:14.810260Z 3076 [Note] Aborted connection 3076 to db: 'donation_store' user: 'clanhost' host: 'c-192-223-28-102.internap-atlanta.nfoservers.com' (Got an error reading communication packets)
2017-06-23T00:19:14.810329Z 3075 [Note] Aborted connection 3075 to db: 'donation_store' user: 'clanhost' host: 'c-192-223-28-102.internap-atlanta.nfoservers.com' (Got an error reading communication packets)
2017-06-23T00:19:14.810474Z 3071 [Note] Aborted connection 3071 to db: 'bans' user: 'clanhost' host: 'c-192-223-28-102.internap-atlanta.nfoservers.com' (Got an error reading communication packets
2017-06-23T00:19:14.810563Z 3073 [Note] Aborted connection 3073 to db: 'bans' user: 'clanhost' host: 'c-192-223-28-102.internap-atlanta.nfoservers.com' (Got an error reading communication packets)
2017-06-23T00:33:49.775176Z 3221 [Note] Aborted connection 3221 to db: 'csgojb_ctban' user: 'clanhost' host: 'v-74-91-112-113.managed-vds.internap-atlanta.nfoservers.com' (Got timeout reading communication packets)
2017-06-23T00:47:15.157900Z 3402 [Note] Aborted connection 3402 to db: 'csgojb_ctban' user: 'clanhost' host: 'c-192-223-28-102.internap-atlanta.nfoservers.com' (Got timeout reading communication packets)
2017-06-23T00:48:18.722264Z 4061 [Warning] IP address '177.73.50.50' could not be resolved: Name or service not known
2017-06-23T00:48:19.969884Z 4061 [Note] Access denied for user 'backupexec'@'177.73.50.50' (using password: YES)I did try to use this as help http://feed.askmaclean.com/archives/mys ... rrors.html
so i do have max_connections set to 9000 and net_read_timeout 3600 and max_execution_time 0 and last off wait_timeout set to 3600. So even with this, it didn't work and i was still getting the errors hours later.
[ANOTHER NOTE: I did "netstats" and i found all these time_wait
