duplicate key sql error syncing db
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Syncany |
New
|
Undecided
|
Unassigned |
Bug Description
Running syncany on ubuntu 10.04.3 32bits local setup
i get this error ( removing the .$HOME/.syncany/db do not solve )
11-08-23 16:43:53 | ubuntu-desktop | org.eclipse.
Local Exception Stack:
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.2.0.v20110202
Internal Exception: java.sql.
Error Code: 20000
Call: INSERT INTO CLONEFILE_
bind => [6 parameters bound]
Query: DataModifyQuery
at org.eclipse.
at org.eclipse.
Thank you
I've had this problem multiple times. It's an issue with JPA's List handling: JPA does not allow duplicates in a List object, which is problematic if one files contains a single chunk multiple times.
However, my current plan (and the code on my machine) gets rid of JPA entirely, so this won't be an issue anymore. I am switching to an in-memory scheme, and store the DB using my own file format.