Проблема поднималась уже несколькими сообщениями назад. Через некоторое время после запуска (или стирания неиспользуемых тем) начинают вылазить битые темы и сообщения, которые в конечном счете все собой заполняют и полезная информация просто тонет в них.
Наступает момент, когда MQTT модуль зависает, и МЖД не может сменить состояние устройств (например из сцены), хотя брокер при этом прекрасно работает, с телефона MQTT клиентом можно управлять устройствами.
В "ошибках" пишет:
Код: Выделить всё
cycle_mqtt
Backtrace:
#0 /var/www/cycle.php(366): registerError('cycle_hang', 'cycle_mqtt')
#1 {main}
С cycle_mqtt.php.txt такая простыня.
Код: Выделить всё
Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...19:27:16 Topics to watch: # (Total: 1)
19:27:16 Path: #
19:27:16 Subscribing to: #
19:27:21 Topics to watch: # (Total: 1)
19:27:21 Path: #
19:27:21 Subscribing to: #
Trying to reconnect...19:58:57 Topics to watch: # (Total: 1)
19:58:57 Path: #
19:58:57 Subscribing to: #
Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect...Trying to reconnect... <html>
<head>
<title>Error</title>
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
<!-- Optional theme -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp" crossorigin="anonymous">
<!-- Latest compiled and minified JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
</head>
<body>
<div class="container">
<h1>Error</h1>
<h3>Details</h3>
<div class="alert alert-danger">http://<br/>2006: MySQL server has gone away<br>SELECT * FROM mqtt WHERE PATH LIKE 'tele/Washer_Power/STATE/Time'</div>
<h3>Backtrace</h3>
<div><pre>#0 /var/www/lib/mysqli.class.php(396): custom_error->__construct('2006: MySQL ser...', 0)
#1 /var/www/lib/mysqli.class.php(185): mysql->Error('SELECT * FROM m...', 0)
#2 /var/www/lib/mysqli.class.php(230): mysql->Exec('SELECT * FROM m...')
#3 /var/www/lib/sqlFunctions.class.php(90): mysql->SelectOne('SELECT * FROM m...')
#4 /var/www/modules/mqtt/mqtt.class.php(290): SQLSelectOne('SELECT * FROM m...')
#5 /var/www/modules/mqtt/mqtt.class.php(285): mqtt->processMessage('tele/Washer_Pow...', '2018-11-30T22:4...')
#6 /var/www/scripts/cycle_mqtt.php(135): mqtt->processMessage('tele/Washer_Pow...', '{"Time":"2018-1...')
#7 /var/www/lib/mqtt/phpMQTT.php(276): procmsg('tele/Washer_Pow...', '{"Time":"2018-1...')
#8 /var/www/lib/mqtt/phpMQTT.php(325): phpMQTT->message('{"Time":"2018-1...')
#9 /var/www/scripts/cycle_mqtt.php(93): phpMQTT->proc()
#10 {main}</pre></div>
<div>
<a href="#" class="btn btn-default" onclick="window.history.go(-1);return false;"><<< Back</a>
<a href="/diagnostic.php" class="btn btn-success">Submit Diagnostic info</a>
<a href="#" class="btn btn-default" onclick="window.location.reload();return false;">Reload page</a>
<a href="/admin.php?md=panel&action=saverestore" class="btn btn-default">Go to Backup section</a>
</div>
</div>
</body>
</html> <html>
<head>
<title>Error</title>
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
<!-- Optional theme -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp" crossorigin="anonymous">
<!-- Latest compiled and minified JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
</head>
<body>
<div class="container">
<h1>Error</h1>
<h3>Details</h3>
<div class="alert alert-danger">http://<br/>2006: MySQL server has gone away<br>SELECT * FROM mqtt WHERE PATH LIKE 'tele/Washer_Power/STATE/Time'</div>
<h3>Backtrace</h3>
<div><pre>#0 /var/www/lib/mysqli.class.php(396): custom_error->__construct('2006: MySQL ser...', 0)
#1 /var/www/lib/mysqli.class.php(238): mysql->Error('SELECT * FROM m...')
#2 /var/www/lib/sqlFunctions.class.php(90): mysql->SelectOne('SELECT * FROM m...')
#3 /var/www/modules/mqtt/mqtt.class.php(290): SQLSelectOne('SELECT * FROM m...')
#4 /var/www/modules/mqtt/mqtt.class.php(285): mqtt->processMessage('tele/Washer_Pow...', '2018-11-30T22:4...')
#5 /var/www/scripts/cycle_mqtt.php(135): mqtt->processMessage('tele/Washer_Pow...', '{"Time":"2018-1...')
#6 /var/www/lib/mqtt/phpMQTT.php(276): procmsg('tele/Washer_Pow...', '{"Time":"2018-1...')
#7 /var/www/lib/mqtt/phpMQTT.php(325): phpMQTT->message('{"Time":"2018-1...')
#8 /var/www/scripts/cycle_mqtt.php(93): phpMQTT->proc()
#9 {main}</pre></div>
<div>
<a href="#" class="btn btn-default" onclick="window.history.go(-1);return false;"><<< Back</a>
<a href="/diagnostic.php" class="btn btn-success">Submit Diagnostic info</a>
<a href="#" class="btn btn-default" onclick="window.location.reload();return false;">Reload page</a>
<a href="/admin.php?md=panel&action=saverestore" class="btn btn-default">Go to Backup section</a>
</div>
</div>
</body>
</html> <html>
<head>
<title>Error</title>
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
<!-- Optional theme -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp" crossorigin="anonymous">
<!-- Latest compiled and minified JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
</head>
<body>
<div class="container">
<h1>Error</h1>
<h3>Details</h3>
<div class="alert alert-danger">http://<br/>2006: MySQL server has gone away<br>SELECT * FROM mqtt WHERE PATH_WRITE LIKE 'tele/Washer_Power/STATE/Time'</div>
<h3>Backtrace</h3>
<div><pre>#0 /var/www/lib/mysqli.class.php(396): custom_error->__construct('2006: MySQL ser...', 0)
#1 /var/www/lib/mysqli.class.php(185): mysql->Error('SELECT * FROM m...', 0)
#2 /var/www/lib/mysqli.class.php(230): mysql->Exec('SELECT * FROM m...')
#3 /var/www/lib/sqlFunctions.class.php(90): mysql->SelectOne('SELECT * FROM m...')
#4 /var/www/modules/mqtt/mqtt.class.php(294): SQLSelectOne('SELECT * FROM m...')
#5 /var/www/modules/mqtt/mqtt.class.php(285): mqtt->processMessage('tele/Washer_Pow...', '2018-11-30T22:4...')
#6 /var/www/scripts/cycle_mqtt.php(135): mqtt->processMessage('tele/Washer_Pow...', '{"Time":"2018-1...')
#7 /var/www/lib/mqtt/phpMQTT.php(276): procmsg('tele/Washer_Pow...', '{"Time":"2018-1...')
#8 /var/www/lib/mqtt/phpMQTT.php(325): phpMQTT->message('{"Time":"2018-1...')
#9 /var/www/scripts/cycle_mqtt.php(93): phpMQTT->proc()
#10 {main}</pre></div>
<div>
<a href="#" class="btn btn-default" onclick="window.history.go(-1);return false;"><<< Back</a>
<a href="/diagnostic.php" class="btn btn-success">Submit Diagnostic info</a>
<a href="#" class="btn btn-default" onclick="window.location.reload();return false;">Reload page</a>
<a href="/admin.php?md=panel&action=saverestore" class="btn btn-default">Go to Backup section</a>
</div>
</div>
</body>
</html> <html>
<head>
<title>Error</title>
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
<!-- Optional theme -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp" crossorigin="anonymous">
<!-- Latest compiled and minified JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
</head>
<body>
<div class="container">
<h1>Error</h1>
<h3>Details</h3>
<div class="alert alert-danger">http://<br/>2006: MySQL server has gone away<br>SELECT * FROM mqtt WHERE PATH_WRITE LIKE 'tele/Washer_Power/STATE/Time'</div>
<h3>Backtrace</h3>
<div><pre>#0 /var/www/lib/mysqli.class.php(396): custom_error->__construct('2006: MySQL ser...', 0)
#1 /var/www/lib/mysqli.class.php(238): mysql->Error('SELECT * FROM m...')
#2 /var/www/lib/sqlFunctions.class.php(90): mysql->SelectOne('SELECT * FROM m...')
#3 /var/www/modules/mqtt/mqtt.class.php(294): SQLSelectOne('SELECT * FROM m...')
#4 /var/www/modules/mqtt/mqtt.class.php(285): mqtt->processMessage('tele/Washer_Pow...', '2018-11-30T22:4...')
#5 /var/www/scripts/cycle_mqtt.php(135): mqtt->processMessage('tele/Washer_Pow...', '{"Time":"2018-1...')
#6 /var/www/lib/mqtt/phpMQTT.php(276): procmsg('tele/Washer_Pow...', '{"Time":"2018-1...')
#7 /var/www/lib/mqtt/phpMQTT.php(325): phpMQTT->message('{"Time":"2018-1...')
#8 /var/www/scripts/cycle_mqtt.php(93): phpMQTT->proc()
#9 {main}</pre></div>
<div>
<a href="#" class="btn btn-default" onclick="window.history.go(-1);return false;"><<< Back</a>
<a href="/diagnostic.php" class="btn btn-success">Submit Diagnostic info</a>
<a href="#" class="btn btn-default" onclick="window.location.reload();return false;">Reload page</a>
<a href="/admin.php?md=panel&action=saverestore" class="btn btn-default">Go to Backup section</a>
</div>
</div>
</body>
</html> <html>
<head>
<title>Error</title>
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
<!-- Optional theme -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp" crossorigin="anonymous">
<!-- Latest compiled and minified JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
</head>
<body>
<div class="container">
<h1>Error</h1>
<h3>Details</h3>
<div class="alert alert-danger">http://<br/>2006: MySQL server has gone away<br>INSERT INTO `mqtt`(`PATH`, `TITLE`, `VALUE`, `UPDATED`, `ID`) VALUES('tele/Washer_Power/STATE/Time', 'tele/Washer_Power/STATE/Time', '2018-11-30T22:40:46', '2018-11-30 22:40:47', '')</div>
<h3>Backtrace</h3>
<div><pre>#0 /var/www/lib/mysqli.class.php(396): custom_error->__construct('2006: MySQL ser...', 0)
#1 /var/www/lib/mysqli.class.php(185): mysql->Error('INSERT INTO `mq...', 0)
#2 /var/www/lib/mysqli.class.php(329): mysql->Exec('INSERT INTO `mq...')
#3 /var/www/lib/sqlFunctions.class.php(111): mysql->Insert('mqtt', Array)
#4 /var/www/modules/mqtt/mqtt.class.php(307): SQLInsert('mqtt', Array)
#5 /var/www/modules/mqtt/mqtt.class.php(285): mqtt->processMessage('tele/Washer_Pow...', '2018-11-30T22:4...')
#6 /var/www/scripts/cycle_mqtt.php(135): mqtt->processMessage('tele/Washer_Pow...', '{"Time":"2018-1...')
#7 /var/www/lib/mqtt/phpMQTT.php(276): procmsg('tele/Washer_Pow...', '{"Time":"2018-1...')
#8 /var/www/lib/mqtt/phpMQTT.php(325): phpMQTT->message('{"Time":"2018-1...')
#9 /var/www/scripts/cycle_mqtt.php(93): phpMQTT->proc()
#10 {main}</pre></div>
MJD на RasPi 3B (Stretch lite).