The sitemap_index.xml shows 500 error (after 30 seconds and it seems as timeout error):
$ date -u
Sun Mar 3 09:35:35 UTC 2019
$ curl -i https://www.xxxxxxxxxx.net/sitemap_index.xml
HTP/1.1 500 Internal Server Error
Date: Sun, 03 Mar 2019 09:34:07 GMT
Content-Type: text/html; charset=UTF-8
Transfer-Encoding: chunked
Connection: keep-alive
Set-Cookie: __cfduid=dd1b7d73f0e2d9e4c0b7174fbd4d8572c1551605636; expires=Mon, 02-Mar-20 09:33:56 GMT; path=/; domain=.xxxxxxxxxx.net; HttpOnly; Secure
Expect-CT: max-age=604800, report-uri="https://report-uri.cloudflare.com/cdn-cgi/beacon/expect-ct"
Server: cloudflare
CF-RAY: 4b1a9c9e4e087c54-BEG
Other sitemaps (page-sitemap.xml and post-sitemap.xml) work. Please check server (and PHP) logs and try to increase max_execution_time in php.ini.
How many posts/pages your website has? It’s possible that’s an issue related to slow SQL queries. You could try to add proper INDEX in MySQL database.
I have more than 200k posts. Thats the issue..?
@pavanbhat If you have a large number of posts it takes a larger amount of server resources to generate the sitemap. You can increase these resources (such as max_execution_time and PHP memory). If you aren’t sure how to change the these settings in php.ini, we would recommend contacting your hosting provider for additional assistance.
This thread has been marked as resolved due to lack of activity.
You’re always welcome to re-open this topic. Please read this post before opening a new request.
Thanks for understanding!
