<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=DE link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Hallo Frank,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>meinen verbindlichsten Dank! Mit deiner Anleitung konnte die Daten aller nicht mehr benötigten Kanäle erfolgreich löschen. <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Beim Löschen der Daten von Kanal 7 erhielt ich zunächst folgende Fehlermeldung: <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>MariaDB [volkszaehler]> delete from data where channel_id = 7;<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Nach Neustart von mysql war dann aber auch das Löschen der Daten von Kanal 7 möglich…<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Das Entfernen der Kanäle aus der Datenbank war dann über das Frontend möglich. Allerdings musste ich nach dem Löschen der Daten ein paar Minuten warten! Der Versuch den Kanal unmittelbar nach Abschluss des Löschvorgangs der Daten zu entfernen lief zunächst auf den gleichen Timeout wie zuvor.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Die Dauer des initialen Backups hat sich damit von den ursprünglichen 9h auf ca. 2,5h reduziert. Mal schauen, wie lange ein tägliches inkrementelles Backup dauert.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Nochmals meinen allgemeinen Dank an die vielen kompetenten und hilfsbereiten Nutzer dieser Liste. Da der Volkszähler keine „out oft he box“ Lösung ist, ist man als Nicht-SW-Experte ohne diese/eure Unterstützung sehr schnell am Ende!!!<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Grüße<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Micha<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>Von:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> volkszaehler-users [mailto:volkszaehler-users-bounces@demo.volkszaehler.org] <b>Im Auftrag von </b>Frank Richter<br><b>Gesendet:</b> Freitag, 23. Oktober 2020 19:49<br><b>An:</b> volkszaehler.org - users<br><b>Betreff:</b> Re: [vz-users] Daten aus der DB über Frontend löschen<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Hallo Micha,<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>woran es liegt weiß ich nicht, aber wenn es dir in erster Linie darum geht, die Daten endlich loszuwerden, mach's über die Kommandozeile:<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>sudo mysql<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Und dann am Prompt von MySQL bzw. MariaDB:<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><span lang=EN-US>use volkszaehler;<o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US>select * from entities;<o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p></div><div><p class=MsoNormal>dort suchst du dir die zur UUID passende id raus, mit der kannst du die betreffenden Daten löschen:<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><span lang=EN-US>delete from data where channel_id = 37;<o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p></div><div><p class=MsoNormal>Die id natürlich passend ersetzen.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Falls du die Aggregation nutzt, das gleiche noch für die Tabelle aggregate:<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal><span lang=EN-US>delete from aggregate where channel_id = 37;<o:p></o:p></span></p></div><div><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p></div><div><p class=MsoNormal>Zum Verlassen:<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>exit;<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Der "leere" Kanal müsste sich ja dann übers Frontend löschen lassen.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Viele Grüße<o:p></o:p></p></div><div><p class=MsoNormal>Frank<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>Michael Hartmann <<a href="mailto:hartmann-micha@web.de">hartmann-micha@web.de</a>> schrieb am Fr., 23. Okt. 2020, 19:30:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Hallo Frank,</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>ja das geht! Kein Problem!</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Grüße</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Micha</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>Von:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> volkszaehler-users [mailto:</span><a href="mailto:volkszaehler-users-bounces@demo.volkszaehler.org" target="_blank"><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>volkszaehler-users-bounces@demo.volkszaehler.org</span></a><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>] <b>Im Auftrag von </b>Frank Richter<br><b>Gesendet:</b> Freitag, 23. Oktober 2020 17:42<br><b>An:</b> </span><a href="http://volkszaehler.org" target="_blank"><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>volkszaehler.org</span></a><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> - users<br><b>Betreff:</b> Re: [vz-users] Daten aus der DB über Frontend löschen</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Kannst du einen frisch angelegten Kanal (ohne Daten) ohne Fehlermeldung löschen?<o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Viele Grüße<o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Frank<o:p></o:p></p></div></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Michael Hartmann <<a href="mailto:hartmann-micha@web.de" target="_blank">hartmann-micha@web.de</a>> schrieb am Fr., 23. Okt. 2020, 17:38:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Hallo,</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>ich bin hier nicht weiter. Die Installation ist exakt das Image, das im Wiki bereitgestellt wird. Ergänzt um Updates des vzloggers und der middleware nach der ebenfalls im Wiki beschriebenen Prozedur. Keine sonstigen Änderungen.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Wo finde ich das Apache Log-File?</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Grüße</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Micha</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>Von:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> volkszaehler-users [mailto:</span><a href="mailto:volkszaehler-users-bounces@demo.volkszaehler.org" target="_blank"><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>volkszaehler-users-bounces@demo.volkszaehler.org</span></a><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>] <b>Im Auftrag von </b>Andreas Goetz<br><b>Gesendet:</b> Dienstag, 20. Oktober 2020 09:16<br><b>An:</b> </span><a href="http://volkszaehler.org" target="_blank"><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>volkszaehler.org</span></a><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> - users<br><b>Betreff:</b> Re: [vz-users] Daten aus der DB über Frontend löschen</span><o:p></o:p></p></div></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Je nachdem wie Dein VZ installiert ist solltest Du das im Apache log finden. Wenn Timeout hier das Problem ist dann sollten die Daten eigentlich schlussendlich gelöscht werden, auch wenn die Response aufgrund des Timeouts nicht mehr im UI ankommen.<o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>Viele Grüße, Andreas<o:p></o:p></span></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US> <o:p></o:p></span></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt'><span lang=EN-US> <o:p></o:p></span></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US>On 20. Oct 2020, at 08:19, Michael Hartmann <</span><a href="mailto:hartmann-micha@web.de" target="_blank"><span lang=EN-US>hartmann-micha@web.de</span></a><span lang=EN-US>> wrote:<o:p></o:p></span></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span lang=EN-US> <o:p></o:p></span></p><div><div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Die Fehlermeldung des FE ist im Screenshot meines initialen Posts dargestellt.</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>"Network Error", "Gateway Timeout"</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Ich denke das ist eher irreführend? Gibt es ein Log in dem ich eine konkretere Fehlermeldung einsehen kann?</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Grüße</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Micha</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p><div style='border:none;border-left:solid #C3D9E5 1.5pt;padding:0cm 0cm 0cm 8.0pt;margin-left:7.5pt;margin-top:7.5pt;margin-right:3.75pt;margin-bottom:3.75pt;word-wrap:break-word' name=quote><div style='margin-bottom:7.5pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Gesendet:</span></b><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> Dienstag, 20. Oktober 2020 um 08:09 Uhr<br><b>Von:</b> "Andreas Goetz" <</span><a href="mailto:cpuidle@gmail.com" target="_blank"><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>cpuidle@gmail.com</span></a><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>><br><b>An:</b> "</span><a href="http://volkszaehler.org/" target="_blank"><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>volkszaehler.org</span></a><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> - users" <</span><a href="mailto:volkszaehler-users@demo.volkszaehler.org" target="_blank"><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>volkszaehler-users@demo.volkszaehler.org</span></a><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>><br><b>Betreff:</b> Re: [vz-users] Daten aus der DB über Frontend löschen</span><o:p></o:p></p></div><div name=quoted-content><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Fang doch bitte mit der *konkreten* Fehlermeldung an, damit wir wissen welches Problem hier den nun von den beiden zu lösen ist :/</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Viele Grüße, Andreas</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Am 20.10.2020 um 08:03 schrieb Michael Hartmann <</span><a href="mailto:hartmann-micha@web.de" target="_blank"><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>hartmann-micha@web.de</span></a><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>>:<br> </span><o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Tahoma","sans-serif"'></span><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Beim Löschen des Kanals über das FE wird explizit darauf hingewiesen das damit auch die Daten gelöscht werden. Ein seperates löschen der Daten wäre somit nicht erforderlich. Wie wäre der Workaround den Kanal und die anhängigen Daten aus der DB zu löschen. Entweder manuell oder durch erweitern der Rechte des Benutzers über den das FE zugreift. Ich möchte die Daten nur loswerden. Auf welchem Weg is dabei nachrangig.</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Grüße</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Micha</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p><div style='border:none;border-left:solid #C3D9E5 1.5pt;padding:0cm 0cm 0cm 8.0pt;margin-left:7.5pt;margin-top:7.5pt;margin-right:3.75pt;margin-bottom:3.75pt'><div style='margin-bottom:7.5pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Gesendet:</span></b><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> Dienstag, 20. Oktober 2020 um 07:45 Uhr<br><b>Von:</b> "Andreas Goetz" <</span><a href="mailto:cpuidle@gmail.com" target="_blank"><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>cpuidle@gmail.com</span></a><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>><br><b>An:</b> "</span><a href="http://volkszaehler.org/" target="_blank"><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>volkszaehler.org</span></a><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> - users" <</span><a href="mailto:volkszaehler-users@demo.volkszaehler.org" target="_blank"><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>volkszaehler-users@demo.volkszaehler.org</span></a><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>><br><b>Betreff:</b> Re: [vz-users] Daten aus der DB über Frontend löschen</span><o:p></o:p></p></div><div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Wenns ein Timeout ist dann liegts nicht am Standarduser. Beides kann aber die Ursache sein.</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Viele Grüße, Andreas</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Am 20.10.2020 um 07:35 schrieb Stefan Bauer <</span><a href="mailto:spam@stefan-bauer.net" target="_blank"><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>spam@stefan-bauer.net</span></a><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>>:<br> </span><o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Tahoma","sans-serif"'></span><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Ich meine der „Standard“-User der für das Frontend verwendet wird, hat keine Berechtigung in der Datenbank zu löschen.... </span><o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Ich würde die Änderungen direkt in der DB machen...</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Stefan<br> </span><o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Von meinem iPad gesendet</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Am 20.10.2020 um 07:17 schrieb Michael Hartmann <</span><a href="mailto:hartmann-micha@web.de" target="_blank"><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>hartmann-micha@web.de</span></a><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>>:<br> </span><o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Tahoma","sans-serif"'></span><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Hat niemand eine Idee, warum sich Kanäle und zugehörige Daten über das Frontend nicht löschen lassen und es zu dem timeout kommt?</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Grüße</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Micha</span><o:p></o:p></p></div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p><div style='border:none;border-left:solid #C3D9E5 1.5pt;padding:0cm 0cm 0cm 8.0pt;margin-left:7.5pt;margin-top:7.5pt;margin-right:3.75pt;margin-bottom:3.75pt'><div style='margin-bottom:7.5pt'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>Gesendet:</span></b><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> Sonntag, 18. Oktober 2020 um 15:18 Uhr<br><b>Von:</b> "Michael Hartmann" <</span><a href="mailto:hartmann-micha@web.de" target="_blank"><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>hartmann-micha@web.de</span></a><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>><br><b>An:</b> "'</span><a href="http://volkszaehler.org/" target="_blank"><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>volkszaehler.org</span></a><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> - users'" <</span><a href="mailto:volkszaehler-users@demo.volkszaehler.org" target="_blank"><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>volkszaehler-users@demo.volkszaehler.org</span></a><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'>><br><b>Betreff:</b> [vz-users] Daten aus der DB über Frontend löschen</span><o:p></o:p></p></div><div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Hallo,<o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>ich benötige noch einmal Unterstützung. Um die DB vor dem Backup etwas zu verkleinern, möchte ich Daten über das Frontend löschen. Ich hatte anfangs interessehalber die Spannung auf den drei Phasen und die Netzfrequenz aufgezeichnet. Diese Daten benötige ich nicht mehr und möchte sie auch künftig nicht weiter aufzeichnen.<o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Dazu habe ich im Frontend auf das (I) geklickt und im folgenden Dialog auf löschen. Leider bekomme ich dann nur einen Timeout (s. Screenshot). Es funktioniert weder für eine der Netzphasen, noch für die Netzfrequenz. Die Daten werden nicht gelöscht und verbleiben in der DB. Wie kann ich das bereinigen?<o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Danke und Gruß<o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:9.0pt;font-family:"Verdana","sans-serif"'> </span><o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Micha<o:p></o:p></p></div></div></div></div></div></div></div></div></blockquote></div></div></blockquote></div></div></div></div></div></div></div></blockquote></div></div></div></div></div></div></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><2020-10-18 <a href="http://15_15_12-volkszaehler.org/" target="_blank">15_15_12-volkszaehler.org</a> - web frontend.png><o:p></o:p></p></div></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div></div></div></div></blockquote></div></div></div></blockquote></div></div></body></html>