Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bug: execution of php files stalls if database DNS resolves to an non-existing IP #14864

Closed
toredash opened this issue Sep 6, 2019 · 1 comment
Labels
answered For when a question was asked and we referred to forum or answered it.
Milestone

Comments

@toredash
Copy link
Contributor

toredash commented Sep 6, 2019

Hi,

Running Matomo 3.11 / Nginx 1.16 / PHP 7.3.9 and ran into an issue where parsing of PHP files related to matomo stall completely.

Our database got migrated to from one AWS RDS Serverless instance to another. When the migration was done, the existing database was turned off. After this, the DNS name for the turned of database still resolve to an IP address, but nothing responds.

The issue was discovered when matomo was restarted, requests for index.php would then time out on the client-side. Increase of log level in nginx and php-fpm didn't indicate anything, other than that the client terminated the connection.

Requesting php files that isn't part of matomo worked fine, and issues requests for php-fpm internal /ping and /status command worked as expected as well.

We also tried to decrease php_admin_value[max_execution_time] to 5 seconds, but the request for e.g. index.php never times out on the server side, and the client will in the end terminate the request, which is logged in php-fpm as client initiated closure.

Changing the DNS hostname to our next database, resolved the issue. It was extremely hard to debug since there was no logs or outputs that would indicate what could be wrong.

@tsteur
Copy link
Member

tsteur commented Sep 10, 2019

You can enable tracker debug in this case eg https://matomo.org/faq/troubleshooting/faq_115/ It would have likely shown the error. Cheers

@tsteur tsteur closed this as completed Sep 10, 2019
@tsteur tsteur added the answered For when a question was asked and we referred to forum or answered it. label Sep 10, 2019
@mattab mattab added this to the 3.12.0 milestone Oct 27, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Development

No branches or pull requests

3 participants