Help

Alfresco 5.2.3 : MySQLIntegrityConstraintViolationException Duplicate Entry upon call to upload

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
mohamad
Member II
‎30 Aug 2021 6:28 AM

Alfresco 5.2.3 : MySQLIntegrityConstraintViolationException Duplicate Entry upon call to upload

Hi,

 We've been getting this error:

com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate Entry

returning from every call to: 

/alfresco/s/api/upload

The exact SQL query is:

insert into alf_content_url (content_url, content_url_short, content_url_crc, content_size, orphan_time) 

values ('store://2021/8/30/13','5267da2e.bin',3465106200,68328,null);

com.mysql.jdbc.exceptions.jdbc4.MYSQLIntegrityConstraintViolationException: Duplicate entry '5267da2e.bin-3465106200' for key 'idx_alf_conturl_cr' 

How come this error occured when this is a fresh file upload ?

0 Kudos
Alfresco Content Services Forum

Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.

Related links:

We use cookies on this site to enhance your user experience

By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods).   If you are not ok with these terms, please do not use this website.