2018-10-28, 15:22
Dave,
is there any light you could shed on the following
started up kodi 18 beta 4 (which is set to a scan on startup)
and going by the speed it the media scan was going at it appeared as though it was doing a rescan of all my albums
but on further investigation log is full of the following entries
12:14:08.617 T:19284 NOTICE: CWebServer[8080]: Started
12:14:08.620 T:21860 NOTICE: ES: Starting UDP Event server on port 9777
12:14:08.620 T:21860 NOTICE: UDP: Listening on port 9777 (ipv6 : true)
12:14:10.957 T:20552 ERROR: SQL: [MyMusic72.db] Abort due to constraint violation
Query: INSERT INTO album_source (idAlbum, idSource) values(47, 2)
12:14:10.957 T:20552 ERROR: CDatabase::ExecuteQuery - failed to execute query 'INSERT INTO album_source (idAlbum, idSource) values(47, 2)'
12:14:11.937 T:20552 ERROR: SQL: [MyMusic72.db] Abort due to constraint violation
Query: INSERT INTO album_source (idAlbum, idSource) values(48, 2)
12:14:11.937 T:20552 ERROR: CDatabase::ExecuteQuery - failed to execute query 'INSERT INTO album_source (idAlbum, idSource) values(48, 2)'
12:14:13.875 T:20552 ERROR: SQL: [MyMusic72.db] Abort due to constraint violation
Query: INSERT INTO album_source (idAlbum, idSource) values(49, 2)
12:14:13.875 T:20552 ERROR: CDatabase::ExecuteQuery - failed to execute query 'INSERT INTO album_source (idAlbum, idSource) values(49, 2)'
12:14:15.341 T:20552 ERROR: SQL: [MyMusic72.db] Abort due to constraint violation
Query: INSERT INTO album_source (idAlbum, idSource) values(50, 2)
12:14:15.342 T:20552 ERROR: CDatabase::ExecuteQuery - failed to execute query 'INSERT INTO album_source (idAlbum, idSource) values(50, 2)'
12:14:16.296 T:20552 ERROR: SQL: [MyMusic72.db] Abort due to constraint violation
Query: INSERT INTO album_source (idAlbum, idSource) values(51, 2)
12:14:16.296 T:20552 ERROR: CDatabase::ExecuteQuery - failed to execute query 'INSERT INTO album_source (idAlbum, idSource) values(51, 2)'
12:14:17.958 T:20552 ERROR: SQL: [MyMusic72.db] Abort due to constraint violation
and one entry for each album I wondered why the first 46 albums appeared to have been ok, but realised they are a different source and they appeared at the end
12:58:50.764 T:20552 ERROR: SQL: [MyMusic72.db] Abort due to constraint violation
Query: INSERT INTO album_source (idAlbum, idSource) values(1, 1)
12:58:50.764 T:20552 ERROR: CDatabase::ExecuteQuery - failed to execute query 'INSERT INTO album_source (idAlbum, idSource) values(1, 1)'
12:58:52.349 T:20552 ERROR: SQL: [MyMusic72.db] Abort due to constraint violation
Query: INSERT INTO album_source (idAlbum, idSource) values(2, 1)
12:58:52.349 T:20552 ERROR: CDatabase::ExecuteQuery - failed to execute query 'INSERT INTO album_source (idAlbum, idSource) values(2, 1)'
12:58:53.583 T:20552 ERROR: SQL: [MyMusic72.db] Abort due to constraint violation
Query: INSERT INTO album_source (idAlbum, idSource) values(3, 1)
12:58:53.584 T:20552 ERROR: CDatabase::ExecuteQuery - failed to execute query 'INSERT INTO album_source (idAlbum, idSource) values(3, 1)'
12:58:54.698 T:20552 ERROR: SQL: [MyMusic72.db] Abort due to constraint violation
Query: INSERT INTO album_source (idAlbum, idSource) values(4, 1)
12:58:54.699 T:20552 ERROR: CDatabase::ExecuteQuery - failed to execute query 'INSERT INTO album_source (idAlbum, idSource) values(4, 1)'
etc etc
the album sources are held on a linux box sharing them out as samba shares, which are then mounted locally using a mapped drive
Kodi started up normally yesterday, and I closed it and restarted again, after this and it started normally
I have the whole log saved although there is nothing else of any note in it really but can supply if required
Can't see what the constraint violation could be nothing else would touch the kodi database,
I could browse the samba shares and play tracks during the issue,
pc had plenty of spare ram and cpu
so at a bit of a loss as to what underlying issue could be
from problem run 12:59:56.412 T:20552 NOTICE: My Music: Scanning for music info using worker thread, operation took 45:47
from good run straight after 13:05:33.625 T:18964 NOTICE: My Music: Scanning for music info using worker thread, operation took 00:45
any thoughts
Tim
is there any light you could shed on the following
started up kodi 18 beta 4 (which is set to a scan on startup)
and going by the speed it the media scan was going at it appeared as though it was doing a rescan of all my albums
but on further investigation log is full of the following entries
12:14:08.617 T:19284 NOTICE: CWebServer[8080]: Started
12:14:08.620 T:21860 NOTICE: ES: Starting UDP Event server on port 9777
12:14:08.620 T:21860 NOTICE: UDP: Listening on port 9777 (ipv6 : true)
12:14:10.957 T:20552 ERROR: SQL: [MyMusic72.db] Abort due to constraint violation
Query: INSERT INTO album_source (idAlbum, idSource) values(47, 2)
12:14:10.957 T:20552 ERROR: CDatabase::ExecuteQuery - failed to execute query 'INSERT INTO album_source (idAlbum, idSource) values(47, 2)'
12:14:11.937 T:20552 ERROR: SQL: [MyMusic72.db] Abort due to constraint violation
Query: INSERT INTO album_source (idAlbum, idSource) values(48, 2)
12:14:11.937 T:20552 ERROR: CDatabase::ExecuteQuery - failed to execute query 'INSERT INTO album_source (idAlbum, idSource) values(48, 2)'
12:14:13.875 T:20552 ERROR: SQL: [MyMusic72.db] Abort due to constraint violation
Query: INSERT INTO album_source (idAlbum, idSource) values(49, 2)
12:14:13.875 T:20552 ERROR: CDatabase::ExecuteQuery - failed to execute query 'INSERT INTO album_source (idAlbum, idSource) values(49, 2)'
12:14:15.341 T:20552 ERROR: SQL: [MyMusic72.db] Abort due to constraint violation
Query: INSERT INTO album_source (idAlbum, idSource) values(50, 2)
12:14:15.342 T:20552 ERROR: CDatabase::ExecuteQuery - failed to execute query 'INSERT INTO album_source (idAlbum, idSource) values(50, 2)'
12:14:16.296 T:20552 ERROR: SQL: [MyMusic72.db] Abort due to constraint violation
Query: INSERT INTO album_source (idAlbum, idSource) values(51, 2)
12:14:16.296 T:20552 ERROR: CDatabase::ExecuteQuery - failed to execute query 'INSERT INTO album_source (idAlbum, idSource) values(51, 2)'
12:14:17.958 T:20552 ERROR: SQL: [MyMusic72.db] Abort due to constraint violation
and one entry for each album I wondered why the first 46 albums appeared to have been ok, but realised they are a different source and they appeared at the end
12:58:50.764 T:20552 ERROR: SQL: [MyMusic72.db] Abort due to constraint violation
Query: INSERT INTO album_source (idAlbum, idSource) values(1, 1)
12:58:50.764 T:20552 ERROR: CDatabase::ExecuteQuery - failed to execute query 'INSERT INTO album_source (idAlbum, idSource) values(1, 1)'
12:58:52.349 T:20552 ERROR: SQL: [MyMusic72.db] Abort due to constraint violation
Query: INSERT INTO album_source (idAlbum, idSource) values(2, 1)
12:58:52.349 T:20552 ERROR: CDatabase::ExecuteQuery - failed to execute query 'INSERT INTO album_source (idAlbum, idSource) values(2, 1)'
12:58:53.583 T:20552 ERROR: SQL: [MyMusic72.db] Abort due to constraint violation
Query: INSERT INTO album_source (idAlbum, idSource) values(3, 1)
12:58:53.584 T:20552 ERROR: CDatabase::ExecuteQuery - failed to execute query 'INSERT INTO album_source (idAlbum, idSource) values(3, 1)'
12:58:54.698 T:20552 ERROR: SQL: [MyMusic72.db] Abort due to constraint violation
Query: INSERT INTO album_source (idAlbum, idSource) values(4, 1)
12:58:54.699 T:20552 ERROR: CDatabase::ExecuteQuery - failed to execute query 'INSERT INTO album_source (idAlbum, idSource) values(4, 1)'
etc etc
the album sources are held on a linux box sharing them out as samba shares, which are then mounted locally using a mapped drive
Kodi started up normally yesterday, and I closed it and restarted again, after this and it started normally
I have the whole log saved although there is nothing else of any note in it really but can supply if required
Can't see what the constraint violation could be nothing else would touch the kodi database,
I could browse the samba shares and play tracks during the issue,
pc had plenty of spare ram and cpu
so at a bit of a loss as to what underlying issue could be
from problem run 12:59:56.412 T:20552 NOTICE: My Music: Scanning for music info using worker thread, operation took 45:47
from good run straight after 13:05:33.625 T:18964 NOTICE: My Music: Scanning for music info using worker thread, operation took 00:45
any thoughts
Tim