Re: Madsonic Consistently Hanging
Posted: 20 Jan 2016, 18:34
by boco
Also, when the server becomes unresponsive the log fills with tons of these:
[1/20/16 10:31 AM] DEBUG AbstractDao 11315 ms: select id, path, folder, type, override, format, data, title, album, album_name, artist, album_artist, disc_number, track_number, year, genre, mood, bpm, composer, bit_rate, variable_bit_rate, duration_seconds, file_size, width, height, cover_art_path, parent_path, play_count, last_played, comment, created, changed, last_scanned, first_scanned, children_last_updated, present, version, rank from media_file where title = :title and type = :type and present
[1/20/16 10:31 AM] DEBUG AbstractDao 10842 ms: select id, path, folder, type, override, format, data, title, album, album_name, artist, album_artist, disc_number, track_number, year, genre, mood, bpm, composer, bit_rate, variable_bit_rate, duration_seconds, file_size, width, height, cover_art_path, parent_path, play_count, last_played, comment, created, changed, last_scanned, first_scanned, children_last_updated, present, version, rank from media_file where title = :title and type = :type and present
Re: Madsonic Consistently Hanging
Posted: 23 Jan 2016, 00:20
by boco
I also get the following delays when re-scanning media folders:
DEBUG AbstractDao 3608 ms: select id, path, folder, type, override, format, data, title, album, album_name, artist, album_artist, disc_number, track_number, year, genre, mood, bpm, composer, bit_rate, variable_bit_rate, duration_seconds, file_size, width, height, cover_art_path, parent_path, play_count, last_played, comment, created, changed, last_scanned, first_scanned, children_last_updated, present, version, rank from media_file where path=?
[1/22/16 2:09 PM] DEBUG AbstractDao 3608 ms: select id, path, folder, type, override, format, data, title, album, album_name, artist, album_artist, disc_number, track_number, year, genre, mood, bpm, composer, bit_rate, variable_bit_rate, duration_seconds, file_size, width, height, cover_art_path, parent_path, play_count, last_played, comment, created, changed, last_scanned, first_scanned, children_last_updated, present, version, rank from media_file where path=?
[1/22/16 2:09 PM] DEBUG AbstractDao 3608 ms: update media_file set present=false, children_last_updated=? where id between ? and ? and last_scanned != ? and present
[1/22/16 2:09 PM] DEBUG AbstractDao 4862 ms: select id, path, folder, type, override, format, data, title, album, album_name, artist, album_artist, disc_number, track_number, year, genre, mood, bpm, composer, bit_rate, variable_bit_rate, duration_seconds, file_size, width, height, cover_art_path, parent_path, play_count, last_played, comment, created, changed, last_scanned, first_scanned, children_last_updated, present, version, rank from media_file where path=?
[1/22/16 2:09 PM] DEBUG AbstractDao 4862 ms: update media_file set present=false, children_last_updated=? where id between ? and ? and last_scanned != ? and present
[1/22/16 2:09 PM] DEBUG AbstractDao 25616 ms: select id, name, type, username, ip_address, auto_control_enabled, last_seen, cover_art_scheme, transcode_scheme, dynamic_ip, technology, client_id from player where id=?
[1/22/16 2:09 PM] DEBUG AbstractDao 29209 ms: update media_file set present=false, children_last_updated=? where id between ? and ? and last_scanned != ? and present
[1/22/16 2:09 PM] DEBUG AbstractDao 24578 ms: select id, path, name, enabled, changed, mf_index, mf_type, mf_groupby, mf_timer, mf_interval from music_folder
And lots of theses when utilizing the "Clean-up database" feature:
DEBUG AbstractDao 3369 ms: select id, path, folder, type, override, format, data, title, album, album_name, artist, album_artist, disc_number, track_number, year, genre, mood, bpm, composer, bit_rate, variable_bit_rate, duration_seconds, file_size, width, height, cover_art_path, parent_path, play_count, last_played, comment, created, changed, last_scanned, first_scanned, children_last_updated, present, version, rank from media_file where title = :title and type = :type and present
[1/22/16 2:21 PM] DEBUG AbstractDao 4204 ms: select id, path, folder, type, override, format, data, title, album, album_name, artist, album_artist, disc_number, track_number, year, genre, mood, bpm, composer, bit_rate, variable_bit_rate, duration_seconds, file_size, width, height, cover_art_path, parent_path, play_count, last_played, comment, created, changed, last_scanned, first_scanned, children_last_updated, present, version, rank from media_file where title = :title and type = :type and present
[1/22/16 2:21 PM] DEBUG AbstractDao 4546 ms: select id, path, folder, type, override, format, data, title, album, album_name, artist, album_artist, disc_number, track_number, year, genre, mood, bpm, composer, bit_rate, variable_bit_rate, duration_seconds, file_size, width, height, cover_art_path, parent_path, play_count, last_played, comment, created, changed, last_scanned, first_scanned, children_last_updated, present, version, rank from media_file where title = :title and type = :type and present
[1/22/16 2:21 PM] DEBUG AbstractDao 4751 ms: select id, path, folder, type, override, format, data, title, album, album_name, artist, album_artist, disc_number, track_number, year, genre, mood, bpm, composer, bit_rate, variable_bit_rate, duration_seconds, file_size, width, height, cover_art_path, parent_path, play_count, last_played, comment, created, changed, last_scanned, first_scanned, children_last_updated, present, version, rank from media_file where title = :title and type = :type and present
[1/22/16 2:21 PM] DEBUG AbstractDao 4051 ms: select id, path, folder, type, override, format, data, title, album, album_name, artist, album_artist, disc_number, track_number, year, g