search

matomo-org / plugin-GoogleAnalyticsImporter

Google Analytics to Matomo importer
24 stars 14 forks source link

Import data killed - long-running PHP processes #494

Closed Stevie0130 closed 8 months ago

Stevie0130 commented 9 months ago

Hi I have a problem with the long-running PHP processes. I host my data with the webhoster all-inkl and have set the PHP settings to max_execution_time to 0 and memory_limit to 512M in the ".user.ini" file. However, I still receive the error message. I am currently using PHP version 8.2.13. But I had the same problem with 8.1 and 8.0 as well. What can I do? I just can't get the importer to work. Does anyone have an idea?

AltamashShaikh commented 9 months ago

@Stevie0130 Have you enabled archiving ? If not you can refer to this doc to set it up.

The archiving can restart the process automatically.

Stevie0130 commented 9 months ago

@AltamashShaikh yes, I added webcron today and set the execution to 15 minutes. Unfortunately, the import still aborts. The cron job does run, but it has no effect.

AltamashShaikh commented 9 months ago

@Stevie0130 This issue looks like specific to your webhosting platform, and looks like your ini_settings are not being respected by your hosting provider, can you please check with them on how to run long running task ?

Stevie0130 commented 9 months ago

@AltamashShaikh I asked the support and received the following answer: "The value you have used is set as localvalue in the max_execution_time and thus affects the execution time of the PHP scripts accordingly." So, everything should be correct here. Do you have any other ideas?

AltamashShaikh commented 9 months ago

@Stevie0130 Reading on how to setup cronjobs in all-inkl, it looks like it supports a webcron and that webcron might be timing out after certain period and that is leading to your import being killed.

I am afraid we couldn't help you much here, you might need to contact the support and explain them the issue, they would be able to help you better here

AltamashShaikh commented 8 months ago

@Stevie0130 Can we close this ticket?

Stevie0130 commented 8 months ago

@AltamashShaikh Yes, thank you for your help!