[vz-users] DBCopy Fortschrittsanzeige

[Sirko]

Hi Andreas,

ich hab gestern mal den Volkszähler und Composer usw. aktualisiert, 
incl. DBCopy. (Laut git pull alles up-to-date)
Seit dem geht die Fortschrittsanzeige nicht mehr richtig, obwohl die 
Datensätze offenbar korrekt übertragen werden.

*Vorher:*
Start DBCopy...
entities: copying 24 rows (overwrite)
  [>---------------------------]   0%    1 sec/1 sec     0 rows
  [============================] 100%    1 sec/1 sec    24 rows

properties: copying 185 rows (overwrite)
  [>---------------------------]   0%    1 sec/1 sec      0 rows
  [============================] 100%    1 sec/1 sec    185 rows

entities_in_aggregator: copying 4 rows (overwrite)
  [>---------------------------]   0%    1 sec/1 sec    0 rowsPHP 
Warning:  Division by zero in 
/var/www/volkszaehler.org/vendor/symfony/console/Symfony/Component/Console/Helper/ProgressBar.php 
on line 400
PHP Warning:  Division by zero in 
/var/www/volkszaehler.org/vendor/symfony/console/Symfony/Component/Console/Helper/ProgressBar.php 
on line 401

  [============================] 100%    1 sec/1 sec    4 rows

data: *copying 14006 rows *(partial copy)
  [>---------------------------]   0%    1 sec/1 sec        0 rows
  [=>--------------------------]   4%   2 secs/40 secs    700 rows
  [==>-------------------------]   9%   5 secs/50 secs   1400 rows
  [====>-----------------------]  14%   7 secs/47 secs   2100 rows
  [=====>----------------------]  19%   9 secs/45 secs   2800 rows
  [======>---------------------]  24%  11 secs/44 secs   3500 rows
  [========>-------------------]  29%  13 secs/43 secs   4200 rows
  [=========>------------------]  34%  15 secs/43 secs   4900 rows
  [===========>----------------]  39%  17 secs/43 secs   5600 rows
  [============>---------------]  44%  19 secs/42 secs   6300 rows
  [=============>--------------]  49%  21 secs/42 secs   7000 rows
  [===============>------------]  54%  23 secs/42 secs   7700 rows
  [================>-----------]  59%  25 secs/42 secs   8400 rows
  [==================>---------]  64%  27 secs/42 secs   9100 rows
  [===================>--------]  69%  29 secs/41 secs   9800 rows
  [====================>-------]  74%  31 secs/41 secs  10500 rows
  [======================>-----]  79%  34 secs/43 secs  11200 rows
  [=======================>----]  84%  36 secs/42 secs  11900 rows
  [=========================>--]  89%  38 secs/42 secs  12600 rows
  [==========================>-]  94%  40 secs/42 secs  13300 rows
  [===========================>]  99%  42 secs/42 secs  14000 rows
  [============================] 100%  42 secs/42 secs  14006 rows
  [============================] 100%  42 secs/42 secs  14007 rows
  [============================] 100%  42 secs/42 secs  14008 rows
  [============================] 100%  42 secs/42 secs  14009 rows
  [============================] 100%  42 secs/42 secs  14010 rows
  [============================] 100%  42 secs/42 secs  14011 rows
  [============================] 100%  42 secs/42 secs  14012 rows
  [============================] 100%  42 secs/42 secs  14013 rows

aggregate: skipping
...

*Jetzt:*
Start DBCopy...
entities: copying 24 rows (overwrite)
  [>---------------------------]   0%  < 1 sec/< 1 sec   0 rows
  [============================] 100%  < 1 sec/< 1 sec  24 rows

properties: copying 185 rows (overwrite)
  [>---------------------------]   0%  < 1 sec/< 1 sec    0 rows
  [============================] 100%  < 1 sec/< 1 sec  185 rows

entities_in_aggregator: copying 4 rows (overwrite)
  [>---------------------------]   0%  < 1 sec/< 1 sec  0 rows
  [============================] 100%  < 1 sec/< 1 sec  4 rows

data: *copying 16153996 rows* (partial copy)
  [>---------------------------]   0%  < 1 sec/< 1 sec         0 rows
  [============================] *100%  < 1 sec/< 1 sec 16153996 rows*

aggregate: skipping

Das DBCopy tut so, als wöllte es 16 Mio Zeilen kopieren, kopiert aber 
wirklich nur die fehlenden Zeilen in wie üblich ein paar Sekunden.
Am Ende scheint es zu funktionieren, hat mich nur erschreckt ;-)

Grüße
Sirko
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://demo.volkszaehler.org/pipermail/volkszaehler-users/attachments/20160819/239e1a1d/attachment-0001.html>