I reset the start number to 100000 using my database and started entering nodes. I am getting duplicate numbers. So far I have entered 45 nodes and the numbers 10, 20, and 40 have rendered duplicates. At first I thought that it might happen every ten numbers, but it did not repeat the number 30.

I just noticed that in the field "serial_item_field_serial" it does not record a unique ID when the number ends in "0". I have included images of both the "field_data_field_serial" and "serial_item_field_serial" tables.

Do I need to use a shorter start number, perhaps 10000?

Help! Thanks.

CommentFileSizeAuthor
serial2.png157.89 KBgettysburger
serial1.png144.19 KBgettysburger
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

gettysburger’s picture

gettysburger CreditAttribution: gettysburger commented

I just saw a similar issue wherein someone saw the missing sid every ten nodes https://www.drupal.org/node/1905986.

But he said that he still gets sequential serial numbers. I am getting a duplicate every ten, but only some times.

cialog’s picture

cialog CreditAttribution: cialog commented
Related issues: +#1905986: Strange Behavior: Missing SIDs in Increments of ten

Please see comment #2 https://www.drupal.org/node/1905986#comment-9481613 for a possible solution.

gettysburger’s picture

gettysburger CreditAttribution: gettysburger commented

Thanks. I will give that a try.

colan’s picture

colan
he/him
Primary language English
Location Toronto 🇨🇦
CreditAttribution: colan at Colan Schwartz Consulting for Chapter Three commented
Status: Active » Closed (duplicate)

Assuming this is a duplicate for now.