primary key violation
Posted: Fri Nov 16, 2012 9:31 am
I've got an error which causes mediaserver to crash:
INFO 2012-11-15 22:17:41.173 [New I/O server worker #2-4] Node(net.pms.dlna.virtual.MediaLibrary) already has an ID=0$5, which is overriden now. The previous parent node was:RootFolder[[MapFile [name=Music, id=0$1, format=null, children=[]], MapFile [name=Movies, id=0$2, format=null, children=[]], MapFile [name=tv optagelser, id=0$3, format=null, children=[]], MapFile [name=My Pictures, id=0$4, format=null, children=[]], VirtualFolder [id=5, name=Web, full path=0$5, ext=null, discovered=false]]]
ERROR 2012-11-15 22:18:24.013 [New I/O server worker #2-2] null
org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "PRIMARY_KEY_C ON PUBLIC.SUBTRACKS(FILEID, ID)"; SQL statement:
INSERT INTO SUBTRACKS VALUES (?, ?, ?, ?, ?) [23505-168]
INFO 2012-11-15 22:17:41.173 [New I/O server worker #2-4] Node(net.pms.dlna.virtual.MediaLibrary) already has an ID=0$5, which is overriden now. The previous parent node was:RootFolder[[MapFile [name=Music, id=0$1, format=null, children=[]], MapFile [name=Movies, id=0$2, format=null, children=[]], MapFile [name=tv optagelser, id=0$3, format=null, children=[]], MapFile [name=My Pictures, id=0$4, format=null, children=[]], VirtualFolder [id=5, name=Web, full path=0$5, ext=null, discovered=false]]]
ERROR 2012-11-15 22:18:24.013 [New I/O server worker #2-2] null
org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "PRIMARY_KEY_C ON PUBLIC.SUBTRACKS(FILEID, ID)"; SQL statement:
INSERT INTO SUBTRACKS VALUES (?, ?, ?, ?, ?) [23505-168]