Duplicate entry with taxonomy term

This is a small part of warnings:

I have this problem also... My taxonomy has more than 10,000 terms (8 thousand in just one vocabulary).

What is this function that you mention? Is it in Devel?

Thanks for attention!

subscribing

What kind of taxonomy-related modules does everyone have enabled? Maybe we can find the culprit somewhere as I don't get this problem with just XML sitemap + Drupal core.

The only modules I can currently think of that extend taxonomy specific functionalities on my site are taxonomy_breadcrumb, taxonomy_menu, taxonomy_title, term_fields... no actions, triggers or rules.

If it's a module I would guess taxonomy_menu could be a cause. I have a ~1200 terms menu based on taxonomy_menu. But I have not seen this issues with the previous alpha versions and have not updated taxonomy_menu!

I think you need to uninstall and reinstall or upgrade from earlier versions to see this happens again...

If something has failed and is now cluttered and defective it should affect something... Maybe you haven't seen it yet.

I do not have autotag installed. Never heard about it yet...

To be clear, see the description at comment #361509-16: Duplicate entry for taxonomy SQL query. I go into detail of the issue with both an array of tids and objects of term data set in the data passed to taxonomy_node_save.

I've taken a look into the xmlsitemap table and now I have many duplicates per ID... or it looks so.

I have uninstalled taxonomy and done a full rebuild - but the below entries are still in the tables.

The problem affects me as well.
Happens every time I run Cron or update taxonomy terms.

Subscribing

This IS a bug and many have it... and really annoying and critical nevertheless you cannot repro yourself.

I am re-opening this issue because I am also getting this error. Per Dave's request at #26, Schema module reports the following mismatch for xmlsitemap:

column type - difference on: length
declared: array('description' => t('TODO: please describe this field!'), 'type' => 'varchar', 'length' => 32, 'not null' => TRUE, 'default' => '')
actual: array('description' => t('TODO: please describe this field!'), 'type' => 'varchar', 'length' => '12', 'not null' => TRUE, 'default' => '')
column subtype - differences on: not null, length, default
declared: array('description' => t('TODO: please describe this field!'), 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'default' => '')
actual: array('description' => t('TODO: please describe this field!'), 'type' => 'varchar', 'length' => '32', 'not null' => FALSE)
menu_name: unexpected column in database
indexes menu_name: unexpected (not an error)

The primary key is:
Keyname (BTREE), Type (PRIMARY), Unique (Yes), Packed (No), Field (id, type), Cardinality (0, 26751), Collation (A, A)

FYI, the user warning I get is:
user warning: Duplicate entry '461-taxonomy_ter' for key 'PRIMARY' query: INSERT INTO xmlsitemap (id, type, subtype, loc, language, access, status, status_override, lastmod, priority, priority_override, changefreq, changecount) VALUES (461, 'taxonomy_term', '53', 'taxonomy/term/461', '', 1, 0, 0, 0, 0.5, 0, 0, 0) in /media/data/3-www/dr620test/sites/all/modules/xmlsitemap/xmlsitemap.inc on line 137.

I am using xmlsitemap version 6.x-2.0-beta1, and have xmlsitemap taxonomy turned on. I just want to check whether I should manually correct the varchar lengths and the 'not null' setting to TRUE -- don't want to create any other problems here since I don't know what these changes will affect. Also, any hints on where the menu_name column and indexes menu_name came from -- is it from xmlsitemap menu (which I don't have turned on), and is it OK to delete these columns?

Thanks.

I think the manual intervention for this case is the only solution to the issue.