primary key violation
Forum rules
Please make sure you follow the Problem Reporting Guidelines before posting if you want a reply
Please make sure you follow the Problem Reporting Guidelines before posting if you want a reply
primary key violation
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]
- Attachments
-
debug.log- (40.77 KiB) Downloaded 544 times
Re: primary key violation
Reboot PC and TV and Bob's Your Uncle. Very strange.
Re: primary key violation
Hi bigtroll, this bug will be fixed in the next version, thanks!