[ОТВЕТИТЬ]
Опции темы
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
и все незакрытые сессии, оставляемые укмсервером, висят больше суток.
Применимо в случае еженощного холодного бэкупа с рестартом майскуеля.
 
"Спасибо" AlexLog от:
 
Опции темы



Часовой пояс GMT +3, время: 08:43.

Все в прочитанное - Календарь - RSS - - Карта - Вверх 👫 Яндекс.Метрика
Форум сделан на основе vBulletin®
Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. Перевод: zCarot и OlegON
В случае заимствования информации гипертекстовая индексируемая ссылка на Форум обязательна.