When generating xmlsitemap, an endless loop happens.
Entries are added and removed from table constantly.

I am running PostgreSQL, not MySQL.
Drupal is installed with latest dev code.

I suspect some code not compliant with guidelines: http://drupal.org/node/555514

CommentFileSizeAuthor
#7 infinite-loop.png16.16 KBgrub3
endless-loop.png28.25 KBgrub3

Comments

dave reid’s picture

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

Do you have any more specifics about why its happening? My development machine experience a hard drive failure so I won't be able to get my environment up until at least tomorrow.

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented
Status: Active » Postponed (maintainer needs more info)
grub3’s picture

grub3 commented
Assigned: Unassigned » grub3

No, I upgraded using latest Drupal version and the problem is still on.
This is a grave stopping bug for me.

This could be a MySQLism.

You may have a look at my guide:

Writing code compliant with both MySQL and PostgreSQL
http://drupal.org/node/555514

I assigned the bug to myself but would appreciate XMLsitemap team reading my guide.
Maybe the fix is obvious and this will help you find a fix.

grub3’s picture

grub3 commented
Status: Postponed (maintainer needs more info) » Active

Setting back to active as I am working on this bug.

It seems that entries are added and deleted constantly.
There seems to be a problem in XMLsitemap design.

Will enquire.

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented
Status: Active » Postponed (maintainer needs more info)

Until you can point out what's specifically going wrong, I can't help you. I know how to write cross-db compatible code so its not and run all my SQL through the SQL-99 validators.

grub3’s picture

grub3 commented

I assume this is a cross-db problem because all my websites and client websites are running under PostgreSQL and we all have this issue. When running the rebuild query, I connect to PostgreSQL and I see the table grow and shrink indefinitely. There could be a problem on count somewhere so that there is no end to the loop.

Do you need access to my site? If you provide me a fixed IP, I can open access.

grub3’s picture

grub3 commented
StatusFileSize
new infinite-loop.png16.16 KB

One site has 8 pages.
5 pages are part of the XML site map.

It stops on first page and increments the counter endless.

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented
Assigned: grub3 » dave reid
Status: Postponed (maintainer needs more info) » Active

Finally got postgresql installed back after the hard drive crash and I can duplicate this. I'm on it. :)

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented
Status: Active » Fixed

Ok got this fixed! :)
http://drupal.org/cvs?commit=337308
http://drupal.org/cvs?commit=337310

grub3’s picture

grub3 commented

Thank you very much Dave.

I tried to test, but it seems that the file was not committed to CVS:
http://drupalcode.org/viewvc/drupal/contributions/modules/xmlsitemap/xml...

Reopening so you can see the issue and commit the file.

grub3’s picture

grub3 commented
Status: Fixed » Needs review
dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented
Status: Needs review » Fixed

Wow. Ok I fixed that horribly broken-committed file. Sorry about that!

Status: Fixed » Closed (fixed)

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