issue with auto increment value from nodes_hierarchy table

LATEST Official version.
Questions and discussions - NO ISSUES
FOR ISSUES => http://mantis.testlink.org

Moderators: Amaradana, TurboPT, TL Developers

Post Reply
tedn
TestLink user
Posts: 9
Joined: Tue May 25, 2010 6:16 pm
Location: Raleigh, NC USA
Contact:

issue with auto increment value from nodes_hierarchy table

Post by tedn »

Using 1.9.3 we're suddenly unable to successfully create new Test Projects with consistent DB records.
The nodes_hierarchy table gets a new entry with a new id, for example 102020.
The mysql_insert_id, however is, for example 8545055, and that becomes the id value for the testprojects table.
The new Test Project is therefore not found by the SQL join between those two tables: nodes_hierarchy & testprojects.
We recently went well over 100,000 nodes in our nodes_hierarchy table and the last successfully created Test Project has an id value of 100295 appearing in both nodes_hierarchy & testprojects.

Has anyone seen something similar or have any thoughts? thanks!
fman
Member of TestLink Community
Posts: 3123
Joined: Tue Nov 15, 2005 7:19 am

Re: issue with auto increment value from nodes_hierarchy tab

Post by fman »

first time see this error reported
silly question: have you checked if MySQL have some limitations on autoincremented ID ?
can you provide your db for tests ?
(contact testlink.helpme@gmail.com)
Post Reply