[Uatschitchun]

Cleaning DB

Did some other changes to source und ran an update to the library, which also inititiated a clean (cleanonupdate)

As one can see, the process is still running for about 10h (36142/3600)

Code:

|  7438 | kodi | 192.168.5.5:56896 | MyMusic60 | Query   | 36142 | Sending data | delete from artist where idArtist not in (select idArtist from tmp_delartists) |    0.000 |

Without any result.

Strangely I get:

Code:

MariaDB [MyMusic60]> SELECT COUNT(1) FROM artist WHERE idArtist NOT IN  (SELECT idArtist FROM tmp_delartists);
ERROR 1146 (42S02): Table 'MyMusic60.tmp_delartists' doesn't exist

Code:

MariaDB [MyMusic60]> CREATE TEMPORARY TABLE tmp_delartists (idArtist integer) CHARACTER SET utf8 COLLATE utf8_general_ci;
Query OK, 0 rows affected (0.18 sec)

MariaDB [MyMusic60]> INSERT INTO tmp_delartists select idArtist from song_artist;
Query OK, 362599 rows affected (18.71 sec)
Records: 362599  Duplicates: 0  Warnings: 0

MariaDB [MyMusic60]> INSERT INTO tmp_delartists select idArtist from album_artist;
Query OK, 8348 rows affected (0.38 sec)
Records: 8348  Duplicates: 0  Warnings: 0

MariaDB [MyMusic60]> INSERT INTO tmp_delartists VALUES(1);
Query OK, 1 row affected (0.04 sec)

MariaDB [MyMusic60]> SELECT COUNT(1) FROM artist WHERE idArtist NOT IN  (SELECT idArtist FROM tmp_delartists);
+----------+
| COUNT(1) |
+----------+
|        0 |
+----------+
1 row in set (3.93 sec)

These are the last lines on this id in mysql.log:

Code:

170302 21:21:04  7438 Query     select * from album where album.idAlbum not in (select idAlbum from song)
                 7438 Query     delete from album where idAlbum in (1713,8132)
                 7438 Query     DELETE FROM song WHERE song.idAlbum = old.idAlbum
                 7438 Query     DELETE FROM album_artist WHERE album_artist.idAlbum = old.idAlbum
                 7438 Query     DELETE FROM album_genre WHERE album_genre.idAlbum = old.idAlbum
                 7438 Query     DELETE FROM albuminfosong WHERE albuminfosong.idAlbumInfo=old.idAlbum
                 7438 Query     DELETE FROM art WHERE media_id=old.idAlbum AND media_type='album'
                 7438 Query     DELETE FROM song WHERE song.idAlbum = old.idAlbum
                 7438 Query     DELETE FROM album_artist WHERE album_artist.idAlbum = old.idAlbum
                 7438 Query     DELETE FROM album_genre WHERE album_genre.idAlbum = old.idAlbum
                 7438 Query     DELETE FROM albuminfosong WHERE albuminfosong.idAlbumInfo=old.idAlbum
                 7438 Query     DELETE FROM art WHERE media_id=old.idAlbum AND media_type='album'
                 7438 Query     CREATE TEMPORARY TABLE tmp_delartists (idArtist integer) CHARACTER SET utf8 COLLATE utf8_general_ci
                 7438 Query     INSERT INTO tmp_delartists select idArtist from song_artist
170302 21:21:21  7438 Query     INSERT INTO tmp_delartists select idArtist from album_artist
170302 21:21:22  7438 Query     INSERT INTO tmp_delartists VALUES(1)
                 7438 Query     delete from artist where idArtist not in (select idArtist from tmp_delartists)

And, the changes are not visible in Kodi. Still as if no clean was done