I have to regenerate because the sitemap of one of my sites is very unstable, frequently xmlsitemap.xml disapears or some files are not ok for google. My sitemap has now 350.000 nodes the message now is:

Hubo un error HTTP AJAX. Código de Resultado HTTP: 500 A continuación se detalla la información de depuración. Ruta: /batch?render=overlay&id=1173&op=do StatusText: error ResponseText: PDOException: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/MYjUSYTr' (Errcode: 28): SELECT x.loc AS loc, x.lastmod AS lastmod, x.changefreq AS changefreq, x.changecount AS changecount, x.priority AS priority, x.language AS language, x.access AS access, x.status AS status FROM {xmlsitemap} x WHERE (x.access = :db_condition_placeholder_0) AND (x.status = :db_condition_placeholder_1) ORDER BY x.language DESC, x.loc ASC LIMIT 50000 OFFSET 0; Array ( [:db_condition_placeholder_0] => 1 [:db_condition_placeholder_1] => 1 ) en xmlsitemap_generate_chunk() (línea 165 de /home/empresa/public_html/sites/all/modules/xmlsitemap/xmlsitemap.generate.inc).

and the /temp is at 5%
maybe i have to start the sitema again, but this unstability is very bad for my site, I don't know how to fix

Comments

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented

Have you tried setting a smaller 'chunk' size on the settings page from the Automatic setting?

egarias’s picture

egarias commented

It was at 500 i changed for 250
I am now rebuilding the sitemap, i will let it work, it will take a lot of time
Thanks

renatog’s picture

renatog commented
Issue summary: View changes
Status: Active » Fixed

I tested here and for worked well. Of course I don't have so many nodes, but I included a lot of them using devel and I don't get any error.

The recommendation #1 really makes sense

Another important point if someone get this error, please update to the last version:

  1. Upgrade Drupal core to the last 7.x stable version 7.89
  2. Upgrade the XML sitemap to 7.x.2.6
  3. Run pending updates at update.php
  4. Clear all caches drush cc all

For it worked well and will works for you.

If you have any other issue please feel free to let us know ok?

Thank you so much, have a great weekend

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.