updated attributes entity values are assigned a new row in the database

[jasekiw]

When an import is ran using the datapump api, the value_id in catalog_product_entity_(data_type) is auto incrementing even if the value already exists. The current system is running the magmi update every 15 minutes and an import every day on 70k products. After some time the auto increment hit the maximum int capacity which is a lot larger than the attribute values in these tables.

I believe the code is deleting the current attribute value and recreating it instead of an update operation on the database which would cause this.

I cannot track down whether this issue is contained only to the update mode or create mode in the datapump api.

This is obviously very problematic for a very frequent import for synchronization with other servers.

I changed the value_id to a BIGINT in the mean time, but that isn't a permanent solution.

Thanks, Jason

[liam-wiltshire]

Hi @jasekiw,

What import plugins are you using in your profile?

Thanks,

Liam

[jasekiw]

I currently have all plugins disabled. in the production environment we have the Image attributes processor enabled.

thanks, Jason

[leond84]

Has there been a solution for this? In my case it keeps the id's but it does update the Auto Increment value of the table. With hundred of thousands records updated daily, this value rises significantly.