GeoIP2AutoUpdater: failed to unzip... The downloaded file is not a valid geolocation database

ERROR [2021-12-01 03:08:43] 530525  /var/www/html/matomo/plugins/GeoIp2/GeoIP2AutoUpdater.php(189): GeoIP2AutoUpdater: failed to unzip '/var/www/html/matomo/tmp/latest/DBIP-City.mmdb.gz.download' after downloading 'https://download.db-ip.com/free/dbip-city-lite-2021-12.mmdb.gz': The downloaded file is not a valid geolocation database. Please re-check the URL or download the file manually.
#0 /var/www/html/dbuser/plugins/GeoIp2/GeoIP2AutoUpdater.php(105): Piwik\Plugins\GeoIp2\GeoIP2AutoUpdater->downloadFile()
#1 [internal function]: Piwik\Plugins\GeoIp2\GeoIP2AutoUpdater->update()
#2 /var/www/html/dbuser/core/Scheduler/Scheduler.php(276): call_user_func()
#3 /var/www/html/dbuser/core/Scheduler/Scheduler.php(148): Piwik\Scheduler\Scheduler->executeTask()
#4 /var/www/html/dbuser/plugins/CoreAdminHome/API.php(69): Piwik\Scheduler\Scheduler->run()
#5 /var/www/html/dbuser/core/CronArchive.php(626): Piwik\Plugins\CoreAdminHome\API->runScheduledTasks()
#6 /var/www/html/dbuser/core/CronArchive.php(264): Piwik\CronArchive->runScheduledTasks()
#7 /var/www/html/dbuser/core/Access.php(661): Piwik\CronArchive->Piwik\{closure}()
#8 /var/www/html/dbuser/core/CronArchive.php(269): Piwik\Access::doAsSuperUser()
#9 /var/www/html/dbuser/plugins/CoreConsole/Commands/CoreArchiver.php(32): Piwik\CronArchive->main()
#10 /var/www/html/dbuser/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Piwik\Plugins\CoreConsole\Commands\CoreArchiver->execute()
#11 /var/www/html/dbuser/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Symfony\Component\Console\Command\Command->run()
#12 /var/www/html/dbuser/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand()
#13 [internal function]: Symfony\Component\Console\Application->doRun()
#14 /var/www/html/dbuser/core/Console.php(130): call_user_func()
#15 /var/www/html/dbuser/core/Access.php(670): Piwik\Console->Piwik\{closure}()
#16 /var/www/html/dbuser/core/Console.php(131): Piwik\Access::doAsSuperUser()
#17 /var/www/html/dbuser/core/Console.php(82): Piwik\Console->doRunImpl()
#18 /var/www/html/dbuser/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Piwik\Console->doRun()
#19 /var/www/html/dbuser/console(32): Symfony\Component\Console\Application->run()
#20 {main} [Query: , CLI mode: 1]

Versione di Matomo: 4.5.0
Versione MySQL: 8.0.27-0ubuntu0.20.04.1
Versione PHP: 8.0.13

Is it fixed by updating to 4.6? can i upgrade to 4.6?

ERROR [2021-12-01 02:08:48] 509001  /var/www/html/matomo/plugins/GeoIp2/GeoIP2AutoUpdater.php(189): GeoIP2AutoUpdater: failed to unzip '/var/www/html/matomo/tmp/latest/DBIP-City.mmdb.gz.download' after downloading 'https://download.db-ip.com/free/dbip-city-lite-2021-12.mmdb.gz': The downloaded file is not a valid geolocation database. Please re-check the URL or download the file manually.
#0 /var/www/html/dbuser/plugins/GeoIp2/GeoIP2AutoUpdater.php(105): Piwik\Plugins\GeoIp2\GeoIP2AutoUpdater->downloadFile()
#1 [internal function]: Piwik\Plugins\GeoIp2\GeoIP2AutoUpdater->update()
#2 /var/www/html/dbuser/core/Scheduler/Scheduler.php(276): call_user_func()
#3 /var/www/html/dbuser/core/Scheduler/Scheduler.php(148): Piwik\Scheduler\Scheduler->executeTask()
#4 /var/www/html/dbuser/plugins/CoreAdminHome/API.php(69): Piwik\Scheduler\Scheduler->run()
#5 /var/www/html/dbuser/core/CronArchive.php(626): Piwik\Plugins\CoreAdminHome\API->runScheduledTasks()
#6 /var/www/html/dbuser/core/CronArchive.php(264): Piwik\CronArchive->runScheduledTasks()
#7 /var/www/html/dbuser/core/Access.php(661): Piwik\CronArchive->Piwik\{closure}()
#8 /var/www/html/dbuser/core/CronArchive.php(269): Piwik\Access::doAsSuperUser()
#9 /var/www/html/dbuser/plugins/CoreConsole/Commands/CoreArchiver.php(32): Piwik\CronArchive->main()
#10 /var/www/html/dbuser/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Piwik\Plugins\CoreConsole\Commands\CoreArchiver->execute()
#11 /var/www/html/dbuser/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Symfony\Component\Console\Command\Command->run()
#12 /var/www/html/dbuser/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand()
#13 [internal function]: Symfony\Component\Console\Application->doRun()
#14 /var/www/html/dbuser/core/Console.php(130): call_user_func()
#15 /var/www/html/dbuser/core/Access.php(670): Piwik\Console->Piwik\{closure}()
#16 /var/www/html/dbuser/core/Console.php(131): Piwik\Access::doAsSuperUser()
#17 /var/www/html/dbuser/core/Console.php(82): Piwik\Console->doRunImpl()
#18 /var/www/html/dbuser/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Piwik\Console->doRun()
#19 /var/www/html/dbuser/console(32): Symfony\Component\Console\Application->run()
#20 {main} [Query: , CLI mode: 1]
ERROR [2021-12-01 01:09:01] 487369  /var/www/html/matomo/plugins/GeoIp2/GeoIP2AutoUpdater.php(189): GeoIP2AutoUpdater: failed to unzip '/var/www/html/matomo/tmp/latest/DBIP-City.mmdb.gz.download' after downloading 'https://download.db-ip.com/free/dbip-city-lite-2021-12.mmdb.gz': The downloaded file is not a valid geolocation database. Please re-check the URL or download the file manually.
#0 /var/www/html/dbuser/plugins/GeoIp2/GeoIP2AutoUpdater.php(105): Piwik\Plugins\GeoIp2\GeoIP2AutoUpdater->downloadFile()
#1 [internal function]: Piwik\Plugins\GeoIp2\GeoIP2AutoUpdater->update()
#2 /var/www/html/dbuser/core/Scheduler/Scheduler.php(276): call_user_func()
#3 /var/www/html/dbuser/core/Scheduler/Scheduler.php(148): Piwik\Scheduler\Scheduler->executeTask()
#4 /var/www/html/dbuser/plugins/CoreAdminHome/API.php(69): Piwik\Scheduler\Scheduler->run()
#5 /var/www/html/dbuser/core/CronArchive.php(626): Piwik\Plugins\CoreAdminHome\API->runScheduledTasks()
#6 /var/www/html/dbuser/core/CronArchive.php(264): Piwik\CronArchive->runScheduledTasks()
#7 /var/www/html/dbuser/core/Access.php(661): Piwik\CronArchive->Piwik\{closure}()
#8 /var/www/html/dbuser/core/CronArchive.php(269): Piwik\Access::doAsSuperUser()
#9 /var/www/html/dbuser/plugins/CoreConsole/Commands/CoreArchiver.php(32): Piwik\CronArchive->main()
#10 /var/www/html/dbuser/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Piwik\Plugins\CoreConsole\Commands\CoreArchiver->execute()
#11 /var/www/html/dbuser/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Symfony\Component\Console\Command\Command->run()
#12 /var/www/html/dbuser/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand()
#13 [internal function]: Symfony\Component\Console\Application->doRun()
#14 /var/www/html/dbuser/core/Console.php(130): call_user_func()
#15 /var/www/html/dbuser/core/Access.php(670): Piwik\Console->Piwik\{closure}()
#16 /var/www/html/dbuser/core/Console.php(131): Piwik\Access::doAsSuperUser()
#17 /var/www/html/dbuser/core/Console.php(82): Piwik\Console->doRunImpl()
#18 /var/www/html/dbuser/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Piwik\Console->doRun()
#19 /var/www/html/dbuser/console(32): Symfony\Component\Console\Application->run()
#20 {main} [Query: , CLI mode: 1]
ERROR [2021-12-01 00:05:11] 473489  /var/www/html/matomo/plugins/GeoIp2/GeoIP2AutoUpdater.php(189): GeoIP2AutoUpdater: failed to unzip '/var/www/html/matomo/tmp/latest/DBIP-City.mmdb.gz.download' after downloading 'https://download.db-ip.com/free/dbip-city-lite-2021-12.mmdb.gz': The downloaded file is not a valid geolocation database. Please re-check the URL or download the file manually.
#0 /var/www/html/dbuser/plugins/GeoIp2/GeoIP2AutoUpdater.php(105): Piwik\Plugins\GeoIp2\GeoIP2AutoUpdater->downloadFile()
#1 [internal function]: Piwik\Plugins\GeoIp2\GeoIP2AutoUpdater->update()
#2 /var/www/html/dbuser/core/Scheduler/Scheduler.php(276): call_user_func()
#3 /var/www/html/dbuser/core/Scheduler/Scheduler.php(148): Piwik\Scheduler\Scheduler->executeTask()
#4 /var/www/html/dbuser/plugins/CoreAdminHome/API.php(69): Piwik\Scheduler\Scheduler->run()
#5 /var/www/html/dbuser/core/CronArchive.php(626): Piwik\Plugins\CoreAdminHome\API->runScheduledTasks()
#6 /var/www/html/dbuser/core/CronArchive.php(264): Piwik\CronArchive->runScheduledTasks()
#7 /var/www/html/dbuser/core/Access.php(661): Piwik\CronArchive->Piwik\{closure}()
#8 /var/www/html/dbuser/core/CronArchive.php(269): Piwik\Access::doAsSuperUser()
#9 /var/www/html/dbuser/plugins/CoreConsole/Commands/CoreArchiver.php(32): Piwik\CronArchive->main()
#10 /var/www/html/dbuser/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Piwik\Plugins\CoreConsole\Commands\CoreArchiver->execute()
#11 /var/www/html/dbuser/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Symfony\Component\Console\Command\Command->run()
#12 /var/www/html/dbuser/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand()
#13 [internal function]: Symfony\Component\Console\Application->doRun()
#14 /var/www/html/dbuser/core/Console.php(130): call_user_func()
#15 /var/www/html/dbuser/core/Access.php(670): Piwik\Console->Piwik\{closure}()
#16 /var/www/html/dbuser/core/Console.php(131): Piwik\Access::doAsSuperUser()
#17 /var/www/html/dbuser/core/Console.php(82): Piwik\Console->doRunImpl()
#18 /var/www/html/dbuser/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Piwik\Console->doRun()
#19 /var/www/html/dbuser/console(32): Symfony\Component\Console\Application->run()
#20 {main} [Query: , CLI mode: 1]

Hi,

I got the same issue today and I think it is completely unrelated to Matomo 4.6.0:
Matomo always downloads the dbip-city-lite-2021-12.mmdb.gz file with the filename set to the current month. But some months dbip is a bit slow with creating the file, so the updater breaks when it by chance tries to update in the first few hours of a month before the file exists on db-ip’s servers.

I think you can ignore this and the next update should be fine.

Created

1 Like