@insekticid opened this Issue on September 13th 2021

I run this command one week ago
./console core:fix-duplicate-log-actions --invalidate-archives >> log.txt

today I checked results and command crashed.

Latest output is:

/var/www/html $ tail -f log.txt 
        Fixed duplicates in log_conversion_item. Time elapsed: 0.001s.
[2223 / 41708] Fixing duplicates for 'http://ad.yieldmanager.com/clk?3,eAGVTcFugzAM.ZreKCIECFO0QzrUiZWgsqaH9BYyChQoFQti5esXCt19lmX7vWc.A4jR-SWVrutn6TlNPS.FADoCQuAiWxoWxhghACGClmWQKXZtv0tI5XXDA5K3QkXJPJJ86nwGe3.qQfDh-PtFH2UYzGJwzMblfib-Wzn7fD4NCVmsVM1.2jHZ.Jm9xwW3KeTj0YkYBadLrijb1vQAyviyqSImIW'
        Fixed duplicates in log_link_visit_action. Time elapsed: 15.819s.
        Fixed duplicates in log_conversion. Time elapsed: 0.002s.
        Fixed duplicates in log_conversion_item. Time elapsed: 0.001s.
[2224 / 41708] Fixing duplicates for 'http://ad.yieldmanager.com/clk?3,eAGVTcFugzAM.ZreKCIEKAj14C1rRQtr02XS2C2krDBKQSwoKl-.tLDeZ1m233t-NsIhXwjEgy.huSLLFl4QIuxw7AdWdgwMKwxDB7k2cgIf2QbcYtv0WwqV16k7hOdCxnQc4QQvAOkI9v6tE9I6.n7SBxGRUSTv-TD5R-K.NWWHv6cRwHTqQ.WbZqBPj2Nk853a1E3WkYpZYicklQlbnZM3VL4ywD'
        Fixed duplicates in log_link_visit_action. Time elapsed: 14.583s.
        Fixed duplicates in log_conversion. Time elapsed: 0.003s.
        Fixed duplicates in log_conversion_item. Time elapsed: 0.001s.
[2225 / 41708] Fixing duplicates for 'http://ad.yieldmanager.com/clk?3,eAGVTcFugzAM.ZreKCIJVFTRDlkpqCqg0mUHcgueN1BBVF26aHz9YNDdZ1l-fu.Jz4RxDxhu3wJCNdN6w945YT4wAlgFleNxzhkhNNzSgPiOmOrY34-FuGxu9peKXW3SYl7Fx4TlTE7hhLu98sPT4g9wiGYzesVhuZ-F.85Snh9PD0IsURR7sEPx.BeWxJdMgs2TzEtlXqsITCbjNnvxgpKe21SCr2'

image

Today I rerun command again and it will start again with total duplicate items: 41708, so no record has been fixed

image

Your Environment

  • Matomo Version: matomo:4.4.1-fpm-alpine
Powered by GitHub Issue Mirror