12.01.2015 16:18
AlexLog
 
Каждый день в одно и то же время после старта БД(на одном сервере через 8 часов, но втором через 8.20) такая пачка предупреждений, это нормально ?

2015-01-12 12:52:28 3260 [Warning] Aborted connection 9 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got timeout reading communication packets)
2015-01-12 12:52:28 3260 [Warning] Aborted connection 13 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got timeout reading communication packets)
2015-01-12 12:52:28 3260 [Warning] Aborted connection 12 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got timeout reading communication packets)
2015-01-12 12:52:28 3260 [Warning] Aborted connection 8 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got timeout reading communication packets)
2015-01-12 12:52:28 3260 [Warning] Aborted connection 14 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got timeout reading communication packets)
2015-01-12 12:52:28 3260 [Warning] Aborted connection 11 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got timeout reading communication packets)
2015-01-12 12:52:28 3260 [Warning] Aborted connection 7 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got timeout reading communication packets)
2015-01-12 12:52:28 3260 [Warning] Aborted connection 10 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got timeout reading communication packets)
2015-01-12 12:52:28 3260 [Warning] Aborted connection 45 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got timeout reading communication packets)
2015-01-12 12:52:28 3260 [Warning] Aborted connection 40 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got timeout reading communication packets)
2015-01-12 12:52:28 3260 [Warning] Aborted connection 39 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got timeout reading communication packets)
2015-01-12 12:52:28 3260 [Warning] Aborted connection 38 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got timeout reading communication packets)
2015-01-12 12:52:28 3260 [Warning] Aborted connection 42 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got timeout reading communication packets)
2015-01-12 12:52:28 3260 [Warning] Aborted connection 46 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got timeout reading communication packets)
2015-01-12 12:52:28 3260 [Warning] Aborted connection 44 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got timeout reading communication packets)
2015-01-12 12:52:28 3260 [Warning] Aborted connection 47 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got timeout reading communication packets)
2015-01-12 12:52:36 3260 [Warning] Aborted connection 37 to db: 'ukmserver' user: 'ukm_server' host: 'localhost' (Got timeout reading communication packets)
12.01.2015 16:24
Павел Сосновских
 
см.
или
19.01.2015 11:26
AlexLog
 
Итак, если вас смущают данные пачки варнингов, правим
wait_timeout=100000
и все незакрытые сессии, оставляемые укмсервером, висят больше суток.
Применимо в случае еженощного холодного бэкупа с рестартом майскуеля.
Часовой пояс GMT +3, время: 15:58.

Форум на базе vBulletin®
Copyright © Jelsoft Enterprises Ltd.
В случае заимствования информации гипертекстовая индексируемая ссылка на Форум обязательна.