[vz-users] Verarbeitung des Gesamtverbauchs für Strom führt oft zu einem Timeout

[Julian Sikorski]

Am 23.07.24 um 11:58 schrieb Julian Sikorski:
> Am 20.07.24 um 21:43 schrieb Julian Sikorski:
>> Am 20.07.24 um 15:18 schrieb Daniel Lauckner:
>>> Hallo,
>>>
>>>
>>> am Samstag, 20. Juli 2024 um 09:10 hat Julian Sikorski geschrieben:
>>>> from=0&group=day&tuples=1 holt für das Gas die richtige Anzahl von 
>>>> Zeilen (194 heute).
>>>
>>> Ich bin etwas irritiert. Bei einer Anfrage von Anbeginn der Zeit 
>>> (from=0) würde ich mehr Zeilen als nur die vom heutigen Tag erwarten.
>>>
>>> Was genau möchtest du den von der MW haben und was für ein Kanal 
>>> (Typ) ist es?
>>>
>>>
>>> mfg Daniel
>>>
>>>
>> Ich habe mich evtl. etwas unglücklich ausgedrückt.
>>
>> http://odroidxu4.local:8080/data/xxx.json?from=0&group=day&tuples=1
>> reagiert blitzschnell, liefert richtige Wert für consumption und eine 
>> Wert für rows, die suggeriert, dass die tägliche Aggregation 
>> korrekterweise verwendet wird. Es ist ein S0 Impulse Gas Kanal.
>>
>> http://odroidxu4.local:8080/data/yyy.json?from=0&group=day&tuples=1 
>> führt dagegen zu einem Timeout. Es ist ein Zählerstände (SML) basiert 
>> Stromkanal. In der aggregate Tabelle befindet sich eine vergleichbare 
>> Anzahl an Tageswerten (siehe vorherige E-Mail), es werden jedoch pro 
>> Tag deutlich mehr Werte generiert. Der SML Stromzähler schickt ein 
>> Zählerstand jede Sekunde.
>>
>> Von MW möchte ich Gesamtverbauch haben - genau das, was in dem 
>> Standardansicht in der Spalte "Gesamt" angezeigt wird. Und ich würde 
>> gerne verstehen, wieso ich, trotz aggregation, für Stromverbauch ein 
>> timeout kriege.
>>
>> LG,
>> Julian
>>
> Ich habe jetzt im config max-execution-time auf 60 erhöht und die 
> timeouts sind weg. Wenn es dabei bleibt bin ich zufrieden.
> 
> LG,
> Julian
> 
> 
So ganz rund läuft es immer noch nicht. Im log des containers ist 
folgendes zu sehen:

Starting PHP-PM with 8 workers, using StreamSelectLoop ...
8 workers (starting at 5501) up and ready. Application is ready at 
http://0.0.0.0:8080/
Maximum execution time of 60 seconds exceeded. Closing worker.
Maximum execution time of 60 seconds exceeded. Closing worker.
Restart worker #5501 because it reached max requests of 1000
Restart worker #5504 because it reached max requests of 1000
Restart worker #5505 because it reached max requests of 1000
Restart worker #5506 because it reached max requests of 1000
Restart worker #5507 because it reached max requests of 1000
Restart worker #5508 because it reached max requests of 1000
Restart worker #5502 because it reached max requests of 1000
Restart worker #5503 because it reached max requests of 1000
Restart worker #5501 because it reached max requests of 1000
Restart worker #5504 because it reached max requests of 1000
Restart worker #5505 because it reached max requests of 1000
Restart worker #5506 because it reached max requests of 1000
Restart worker #5507 because it reached max requests of 1000
Restart worker #5508 because it reached max requests of 1000
Restart worker #5502 because it reached max requests of 1000
Restart worker #5503 because it reached max requests of 1000
Restart worker #5501 because it reached max requests of 1000
Restart worker #5504 because it reached max requests of 1000
Restart worker #5505 because it reached max requests of 1000
Script did not return a valid HTTP response. Maybe it has called exit() 
prematurely?
Script did not return a valid HTTP response. Maybe it has called exit() 
prematurely?
Maximum execution time of 60 seconds exceeded. Closing worker.
Restart worker #5506 because it reached max requests of 1000
Maximum execution time of 60 seconds exceeded. Closing worker.
Maximum execution time of 60 seconds exceeded. Closing worker.
Script did not return a valid HTTP response. Maybe it has called exit() 
prematurely?
Restart worker #5508 because it reached max requests of 1000
Restart worker #5503 because it reached max requests of 1000
Restart worker #5501 because it reached max requests of 1000
Restart worker #5505 because it reached max requests of 1000
Restart worker #5507 because it reached max requests of 1000
Restart worker #5506 because it reached max requests of 1000
Restart worker #5502 because it reached max requests of 1000
Restart worker #5504 because it reached max requests of 1000
Restart worker #5508 because it reached max requests of 1000
Restart worker #5503 because it reached max requests of 1000
Restart worker #5501 because it reached max requests of 1000
Restart worker #5505 because it reached max requests of 1000
Restart worker #5507 because it reached max requests of 1000
Restart worker #5506 because it reached max requests of 1000
Restart worker #5502 because it reached max requests of 1000
Restart worker #5504 because it reached max requests of 1000
Restart worker #5508 because it reached max requests of 1000
Restart worker #5503 because it reached max requests of 1000
Restart worker #5501 because it reached max requests of 1000
Restart worker #5505 because it reached max requests of 1000
Restart worker #5507 because it reached max requests of 1000
Restart worker #5506 because it reached max requests of 1000
Restart worker #5502 because it reached max requests of 1000
Restart worker #5504 because it reached max requests of 1000
Restart worker #5508 because it reached max requests of 1000
Restart worker #5503 because it reached max requests of 1000
Restart worker #5501 because it reached max requests of 1000
Restart worker #5505 because it reached max requests of 1000
Restart worker #5507 because it reached max requests of 1000
Restart worker #5506 because it reached max requests of 1000
Restart worker #5502 because it reached max requests of 1000
Restart worker #5504 because it reached max requests of 1000
Maximum execution time of 60 seconds exceeded. Closing worker.
Restart worker #5508 because it reached max requests of 1000
Restart worker #5501 because it reached max requests of 1000
Restart worker #5505 because it reached max requests of 1000
Restart worker #5507 because it reached max requests of 1000
Restart worker #5506 because it reached max requests of 1000
Restart worker #5502 because it reached max requests of 1000
Restart worker #5504 because it reached max requests of 1000
Restart worker #5503 because it reached max requests of 1000
Restart worker #5508 because it reached max requests of 1000
Restart worker #5501 because it reached max requests of 1000
Restart worker #5505 because it reached max requests of 1000
Restart worker #5507 because it reached max requests of 1000
Restart worker #5506 because it reached max requests of 1000
Restart worker #5502 because it reached max requests of 1000
Restart worker #5504 because it reached max requests of 1000
Restart worker #5503 because it reached max requests of 1000
Restart worker #5508 because it reached max requests of 1000
Restart worker #5501 because it reached max requests of 1000
Restart worker #5505 because it reached max requests of 1000
Restart worker #5507 because it reached max requests of 1000
Restart worker #5506 because it reached max requests of 1000
Restart worker #5502 because it reached max requests of 1000
Restart worker #5504 because it reached max requests of 1000
Restart worker #5503 because it reached max requests of 1000
Restart worker #5508 because it reached max requests of 1000
Restart worker #5501 because it reached max requests of 1000
Restart worker #5505 because it reached max requests of 1000
Restart worker #5507 because it reached max requests of 1000
Restart worker #5506 because it reached max requests of 1000
Restart worker #5502 because it reached max requests of 1000
Restart worker #5504 because it reached max requests of 1000
Restart worker #5503 because it reached max requests of 1000
Restart worker #5508 because it reached max requests of 1000
Restart worker #5501 because it reached max requests of 1000
Restart worker #5505 because it reached max requests of 1000
Restart worker #5507 because it reached max requests of 1000
Restart worker #5506 because it reached max requests of 1000
Restart worker #5502 because it reached max requests of 1000
Restart worker #5504 because it reached max requests of 1000
Restart worker #5503 because it reached max requests of 1000
Restart worker #5508 because it reached max requests of 1000
Restart worker #5501 because it reached max requests of 1000
Restart worker #5505 because it reached max requests of 1000
Restart worker #5507 because it reached max requests of 1000
Restart worker #5506 because it reached max requests of 1000
Restart worker #5502 because it reached max requests of 1000
Restart worker #5504 because it reached max requests of 1000
Restart worker #5503 because it reached max requests of 1000
Restart worker #5508 because it reached max requests of 1000
Restart worker #5501 because it reached max requests of 1000
Restart worker #5505 because it reached max requests of 1000
Restart worker #5507 because it reached max requests of 1000
Restart worker #5506 because it reached max requests of 1000
Restart worker #5502 because it reached max requests of 1000
Restart worker #5504 because it reached max requests of 1000
Restart worker #5503 because it reached max requests of 1000
Restart worker #5508 because it reached max requests of 1000
Restart worker #5501 because it reached max requests of 1000
Restart worker #5505 because it reached max requests of 1000
Restart worker #5507 because it reached max requests of 1000
Restart worker #5506 because it reached max requests of 1000
Restart worker #5502 because it reached max requests of 1000
Restart worker #5504 because it reached max requests of 1000
Restart worker #5503 because it reached max requests of 1000
Restart worker #5508 because it reached max requests of 1000
Restart worker #5501 because it reached max requests of 1000
Restart worker #5505 because it reached max requests of 1000
Restart worker #5507 because it reached max requests of 1000
Restart worker #5506 because it reached max requests of 1000
Restart worker #5502 because it reached max requests of 1000
Restart worker #5504 because it reached max requests of 1000
Restart worker #5503 because it reached max requests of 1000
Restart worker #5508 because it reached max requests of 1000
Restart worker #5501 because it reached max requests of 1000
Restart worker #5505 because it reached max requests of 1000
Restart worker #5507 because it reached max requests of 1000
Restart worker #5506 because it reached max requests of 1000
Restart worker #5502 because it reached max requests of 1000
Restart worker #5504 because it reached max requests of 1000
Restart worker #5503 because it reached max requests of 1000
Restart worker #5508 because it reached max requests of 1000
Restart worker #5501 because it reached max requests of 1000
Restart worker #5505 because it reached max requests of 1000
Restart worker #5507 because it reached max requests of 1000
Restart worker #5506 because it reached max requests of 1000
Restart worker #5502 because it reached max requests of 1000
Restart worker #5504 because it reached max requests of 1000
Restart worker #5503 because it reached max requests of 1000
Restart worker #5508 because it reached max requests of 1000
Restart worker #5501 because it reached max requests of 1000
Restart worker #5505 because it reached max requests of 1000
Restart worker #5507 because it reached max requests of 1000
Restart worker #5506 because it reached max requests of 1000
Restart worker #5502 because it reached max requests of 1000
Restart worker #5504 because it reached max requests of 1000
Restart worker #5503 because it reached max requests of 1000
Restart worker #5508 because it reached max requests of 1000
Restart worker #5501 because it reached max requests of 1000
Restart worker #5505 because it reached max requests of 1000
Restart worker #5507 because it reached max requests of 1000
Restart worker #5506 because it reached max requests of 1000
Restart worker #5502 because it reached max requests of 1000
Restart worker #5504 because it reached max requests of 1000
Restart worker #5503 because it reached max requests of 1000
Restart worker #5508 because it reached max requests of 1000
Restart worker #5501 because it reached max requests of 1000
Restart worker #5505 because it reached max requests of 1000
Restart worker #5507 because it reached max requests of 1000
Restart worker #5506 because it reached max requests of 1000
Restart worker #5502 because it reached max requests of 1000
Restart worker #5504 because it reached max requests of 1000
Restart worker #5503 because it reached max requests of 1000
Restart worker #5508 because it reached max requests of 1000
Restart worker #5501 because it reached max requests of 1000
Restart worker #5505 because it reached max requests of 1000
Restart worker #5507 because it reached max requests of 1000
Restart worker #5506 because it reached max requests of 1000
Restart worker #5502 because it reached max requests of 1000
Maximum execution time of 60 seconds exceeded. Closing worker.
Maximum execution time of 60 seconds exceeded. Closing worker.
Restart worker #5504 because it reached max requests of 1000

was könnten die 1000 requests sein? Das zeichnen der Abbildung?

LG,
Julian