<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><!--p.MsoNormal, li.MsoNormal, div.MsoNormal {
margin: 0.0cm;
font-size: 11.0pt;
font-family: Calibri , sans-serif;
}
a:link, span.MsoHyperlink {
color: blue;
text-decoration: underline;
}
a:visited, span.MsoHyperlinkFollowed {
color: purple;
text-decoration: underline;
}
span.E-MailFormatvorlage17 {
font-family: Calibri , sans-serif;
color: windowtext;
}
*.MsoChpDefault {
font-family: Calibri , sans-serif;
}
div.WordSection1 {
page: WordSection1;
}
-->
<div>
<div class="WordSection1">
<p class="MsoNormal">Hallo,</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">eigentlich hatte ich mit viel Mühe und Unterstüzung aus dieser Liste eine funktionierende Lösung für ein DB-Backup gefunden. Seinerzeit funktionierte der Restore von Daten aus dem Produktiv- auf das Testsystem einwandfrei.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Nun wollte ich das Ganze nach einiger Zeit nochmal testen und bekommen beim Restore der Daten folgenden Fehler:</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">---</p>
<p class="MsoNormal"><em><span>entities: copying 5 rows (overwrite)</span></em></p>
<p class="MsoNormal"><em><span>[============================] 100% < 1 sec/< 1 sec 5 rows</span></em></p>
<p class="MsoNormal"><em><span> </span></em></p>
<p class="MsoNormal"><em><span>properties: copying 46 rows (overwrite)</span></em></p>
<p class="MsoNormal"><em><span>[============================] 100% < 1 sec/< 1 sec 46 rows</span></em></p>
<p class="MsoNormal"><em><span> </span></em></p>
<p class="MsoNormal"><em><span>entities_in_aggregator: copying 0 rows (overwrite)</span></em></p>
<p class="MsoNormal"><em><span> 0 [->--------------------------] < 1 sec 6.0 MiB</span></em></p>
<p class="MsoNormal"><em><span> </span></em></p>
<p class="MsoNormal"><em><span>data: copying 1327389 rows (partial copy)</span></em></p>
<p class="MsoNormal"><em><span>[>---------------------------] 0% < 1 sec/< 1 sec 0 rowsPHP Warning: PDOStatement::execute(): MySQL server has gone away in /home/pi/volkszaehler.org/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php on line 115</span></em></p>
<p class="MsoNormal"><em><span>PHP Warning: PDOStatement::execute(): Error reading result set's header in /home/pi/volkszaehler.org/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php on line 115</span></em></p>
<p class="MsoNormal"><em><span> </span></em></p>
<p class="MsoNormal"><em><span>In AbstractMySQLDriver.php line 115:</span></em></p>
<p class="MsoNormal"><em><span> </span></em></p>
<p class="MsoNormal"><em><span> An exception occurred while executing 'INSERT INTO `data` (`id`,`channel_id`,`timestamp`,`value</span></em></p>
<p class="MsoNormal"><em><span> `) VALUES (?,?,?,?)' with params ["20525333", "3", "1630461850000", "204.20042408039"]:</span></em></p>
<p class="MsoNormal"><em><span> </span></em></p>
<p class="MsoNormal"><em><span> SQLSTATE[HY000]: General error: 2006 MySQL server has gone away</span></em></p>
<p class="MsoNormal"><em><span> </span></em></p>
<p class="MsoNormal"><em><span> </span></em></p>
<p class="MsoNormal"><em><span>In Exception.php line 18:</span></em></p>
<p class="MsoNormal"><em><span> </span></em></p>
<p class="MsoNormal"><em><span> SQLSTATE[HY000]: General error: 2006 MySQL server has gone away</span></em></p>
<p class="MsoNormal"><em><span> </span></em></p>
<p class="MsoNormal"><em><span> </span></em></p>
<p class="MsoNormal"><em><span>In PDOStatement.php line 115:</span></em></p>
<p class="MsoNormal"><em><span> </span></em></p>
<p class="MsoNormal"><em><span> SQLSTATE[HY000]: General error: 2006 MySQL server has gone away</span></em></p>
<p class="MsoNormal">---</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Danach scheint die DB generell hinüber, den auch via Web-Frontend bekomme ich Fehlermeldungen.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Hat jemand eine Idee?</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Grüße</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Micha</p>
<p class="MsoNormal"> </p>
</div>
</div></div></body></html>