unresponsive webgui / unresponsive server
Posted: 04 Mar 2017, 22:29
Code: Select all
=========================================================================================
VERSION: MADSONIC 6.2 | BUILD: 9080.619dd31.20161222.0327
REST: MADSONIC REST API v2.5.0, SUBSONIC REST API v1.14.0
OS: Linux 3.10.77 #8451 SMP Wed Jan 4 00:31:32 CST 2017 x86_64 GNU/Linux
SERVER: jetty/8.y.z-SNAPSHOT, java 1.8.0_121, Linux 3.10.77 (amd64)
HOST: Synology NAS 1815+ (DSM 6.0.2-8451 Update 9) | CPU: INTEL Atom C2538| ARCH: X64 | MEMORY: 6GB | HDD: 36TB, RAID6
BROWSER: FF 51.x
CLIENT: see browser
JAVA: ORACLE JDK 1.8.121
DESCRIPTION: as in the topic's subject
REPRODUCIBLE: Quite often
logged in as admin
=========================================================================================
Example1)
When I click on some link (i.e. History - Songs), which generates a list, which is very very long, the webgui loads and loads and loads. It is not possible to click on any other link then. Noting happens anymore for the user to see.
Example2)
It happens more often, on songs with special chars/umlauts. I.e. clicking on an artists from within the playqueue.
The servers log is very quite about the waiting times for the user. Nothing is happening for "ages" (as in half an hour, sometimes).
Only help (to continue clicking and listening) is to stop the madsonic package via DSM and start it again.
It may be working after an hour of waiting time, but....nobody does wait so long nowadays...
Log:
Code: Select all
[2017-03-04 21:46:39,393] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [testing]
[2017-03-04 21:47:22,940] DEBUG AbstractDao - fn::getUserSettings::queryOne: 5933 ms: select username, locale, theme_id, final_version_notification, beta_version_notification, main_caption_cutoff, main_disc_number, main_track_number, main_artist, main_album, main_genre, main_mood, main_year, main_bit_rate, main_duration, main_format, main_file_size, main_bpm, main_composer, playlist_caption_cutoff, playlist_disc_number, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_mood, playlist_year, playlist_bit_rate, playlist_duration, playlist_format, playlist_file_size, playlist_bpm, playlist_composer, button_rank, button_loved, button_starred, button_play, button_playadd, button_playmore, button_addcontext, button_addnext, button_addlast, button_download, button_youtube, button_lyric, last_fm_enabled, last_fm_username, last_fm_password, transcode_scheme, show_now_playing, selected_music_folder_id, selected_genre, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_artist_info, show_chat, list_type, playqueue_resize, leftframe_resize, customscrollbar, customaccordion, view_as, song_notification, show_left_shrinked, show_left_bar, show_left_panel, show_right_panel, show_side_panel from user_settings where username=?
[2017-03-04 21:47:26,888] DEBUG AbstractDao - fn::getAllMusicFolders::getAllMusicFolders: 3228 ms: select id, path, name, enabled, changed, mf_index, mf_type, mf_groupby, mf_timer, mf_interval from music_folder
[2017-03-04 21:47:33,232] DEBUG AbstractDao - fn::getUserByName::queryOne: 6342 ms: select username, password, email, ldap_authenticated, bytes_streamed, bytes_downloaded, bytes_uploaded, group_id, locked, comment, approved from user where username=?
[2017-03-04 21:47:37,391] DEBUG AbstractDao - fn::getUserSettings::queryOne: 8342 ms: select username, locale, theme_id, final_version_notification, beta_version_notification, main_caption_cutoff, main_disc_number, main_track_number, main_artist, main_album, main_genre, main_mood, main_year, main_bit_rate, main_duration, main_format, main_file_size, main_bpm, main_composer, playlist_caption_cutoff, playlist_disc_number, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_mood, playlist_year, playlist_bit_rate, playlist_duration, playlist_format, playlist_file_size, playlist_bpm, playlist_composer, button_rank, button_loved, button_starred, button_play, button_playadd, button_playmore, button_addcontext, button_addnext, button_addlast, button_download, button_youtube, button_lyric, last_fm_enabled, last_fm_username, last_fm_password, transcode_scheme, show_now_playing, selected_music_folder_id, selected_genre, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_artist_info, show_chat, list_type, playqueue_resize, leftframe_resize, customscrollbar, customaccordion, view_as, song_notification, show_left_shrinked, show_left_bar, show_left_panel, show_right_panel, show_side_panel from user_settings where username=?
[2017-03-04 21:47:41,865] DEBUG AbstractDao - fn::run::getVideoConversionsByStatus: 7287 ms: select id, media_file_id, audio_track_id, username, status, target_file, log_file, bit_rate, progress_seconds, created, changed, started from video_conversion where status=? order by created
[2017-03-04 21:47:41,865] DEBUG AbstractDao - fn::getCurrentUserGroupId::getUserAccess: 4766 ms: select group_id from user where username=?
[2017-03-04 21:47:46,924] DEBUG AbstractDao - fn::getAllMusicFolders::getAllMusicFolders: 14451 ms: select id, path, name, enabled, changed, mf_index, mf_type, mf_groupby, mf_timer, mf_interval from music_folder
[2017-03-04 21:58:43,151] DEBUG AbstractDao - fn::getUserSettings::queryOne: 159022 ms: select username, locale, theme_id, final_version_notification, beta_version_notification, main_caption_cutoff, main_disc_number, main_track_number, main_artist, main_album, main_genre, main_mood, main_year, main_bit_rate, main_duration, main_format, main_file_size, main_bpm, main_composer, playlist_caption_cutoff, playlist_disc_number, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_mood, playlist_year, playlist_bit_rate, playlist_duration, playlist_format, playlist_file_size, playlist_bpm, playlist_composer, button_rank, button_loved, button_starred, button_play, button_playadd, button_playmore, button_addcontext, button_addnext, button_addlast, button_download, button_youtube, button_lyric, last_fm_enabled, last_fm_username, last_fm_password, transcode_scheme, show_now_playing, selected_music_folder_id, selected_genre, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_artist_info, show_chat, list_type, playqueue_resize, leftframe_resize, customscrollbar, customaccordion, view_as, song_notification, show_left_shrinked, show_left_bar, show_left_panel, show_right_panel, show_side_panel from user_settings where username=?
[2017-03-04 21:58:43,151] DEBUG AbstractDao - fn::run::getVideoConversionsByStatus: 505531 ms: select id, media_file_id, audio_track_id, username, status, target_file, log_file, bit_rate, progress_seconds, created, changed, started from video_conversion where status=? order by created
[2017-03-04 21:58:43,151] INFO MediaScannerService - WATCHDOG:SCAN: doFolderScanLibrary() started
[2017-03-04 21:58:43,151] DEBUG AbstractDao - fn::run::getAudioConversionsByStatus: 345258 ms: select id, media_file_id, username, status, target_file, target_format, log_file, bit_rate, progress_seconds, created, changed, started from audio_conversion where status=? order by created
[2017-03-04 22:17:13,860] DEBUG AbstractDao - fn::run::getVideoConversionsByStatus: 965592 ms: select id, media_file_id, audio_track_id, username, status, target_file, log_file, bit_rate, progress_seconds, created, changed, started from video_conversion where status=? order by created
[2017-03-04 22:17:13,860] DEBUG AbstractDao - fn::run::getAudioConversionsByStatus: 622479 ms: select id, media_file_id, username, status, target_file, target_format, log_file, bit_rate, progress_seconds, created, changed, started from audio_conversion where status=? order by created
[2017-03-04 22:19:42,236] DEBUG AbstractDao - fn::run::getVideoConversionsByStatus: 98725 ms: select id, media_file_id, audio_track_id, username, status, target_file, log_file, bit_rate, progress_seconds, created, changed, started from video_conversion where status=? order by created
[2017-03-04 22:19:42,237] DEBUG AbstractDao - fn::getAllMusicFolders::getAllMusicFolders: 861839 ms: select id, path, name, enabled, changed, mf_index, mf_type, mf_groupby, mf_timer, mf_interval from music_folder
[2017-03-04 22:19:42,245] DEBUG AbstractDao - fn::run::getAudioConversionsByStatus: 21982 ms: select id, media_file_id, username, status, target_file, target_format, log_file, bit_rate, progress_seconds, created, changed, started from audio_conversion where status=? order by created
[2017-03-04 22:19:42,245] DEBUG AbstractDao - fn::getAllMusicFolders::getAllMusicFolders: 451705 ms: select id, path, name, enabled, changed, mf_index, mf_type, mf_groupby, mf_timer, mf_interval from music_folder
[2017-03-04 22:19:47,488] DEBUG AbstractDao - fn::getMediaFile::queryOne: 5250 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=?
[2017-03-04 22:19:47,490] DEBUG AbstractDao - fn::getMediaFile::queryOne: 1905167 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=?
[2017-03-04 22:19:47,490] DEBUG AbstractDao - fn::getTask::queryOne: 5244 ms: select id, music_folder_id, found, scan, status, result, comment, enabled from music_folder_tasks where music_folder_id = ?
[2017-03-04 22:19:47,491] DEBUG AbstractDao - fn::getMediaFile::queryOne: 5255 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=?
[2017-03-04 22:19:47,491] DEBUG AbstractDao - fn::getMediaFile::queryOne: 1940602 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=?
[2017-03-04 22:19:47,492] DEBUG AbstractDao - fn::getMediaFile::queryOne: 5251 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=?
[2017-03-04 22:19:51,587] DEBUG AbstractDao - fn::getTask::queryOne: 4092 ms: select id, music_folder_id, found, scan, status, result, comment, enabled from music_folder_tasks where music_folder_id = ?
[2017-03-04 22:19:51,589] DEBUG AbstractDao - fn::populateBookmarkPosition::getMediaFileBookmarkPosition: 4082 ms: select POSITION_MILLIS from bookmark where media_file_id=? and username=?
[2017-03-04 22:19:55,700] DEBUG AbstractDao - fn::getTask::queryOne: 4112 ms: select id, music_folder_id, found, scan, status, result, comment, enabled from music_folder_tasks where music_folder_id = ?
[2017-03-04 22:19:58,772] DEBUG AbstractDao - fn::populateStarredDate::getMediaFileStarredDate: 4982 ms: select created from starred_media_file where media_file_id=? and username=?
[2017-03-04 22:19:58,778] DEBUG AbstractDao - fn::run::getAudioConversionsByStatus: 5000 ms: select id, media_file_id, username, status, target_file, target_format, log_file, bit_rate, progress_seconds, created, changed, started from audio_conversion where status=? order by created
[2017-03-04 22:19:58,779] DEBUG AbstractDao - fn::populateStarredDate::getMediaFileStarredDate: 4991 ms: select created from starred_media_file where media_file_id=? and username=?
[2017-03-04 22:19:58,779] DEBUG AbstractDao - fn::populateStarredDate::getMediaFileStarredDate: 4992 ms: select created from starred_media_file where media_file_id=? and username=?
[2017-03-04 22:19:58,779] DEBUG AbstractDao - fn::populateLovedDate::getMediaFileLovedDate: 5000 ms: select created from loved_media_file where media_file_id=? and username=?
[2017-03-04 22:20:02,811] DEBUG AbstractDao - fn::getUserSettings::queryOne: 4031 ms: select username, locale, theme_id, final_version_notification, beta_version_notification, main_caption_cutoff, main_disc_number, main_track_number, main_artist, main_album, main_genre, main_mood, main_year, main_bit_rate, main_duration, main_format, main_file_size, main_bpm, main_composer, playlist_caption_cutoff, playlist_disc_number, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_mood, playlist_year, playlist_bit_rate, playlist_duration, playlist_format, playlist_file_size, playlist_bpm, playlist_composer, button_rank, button_loved, button_starred, button_play, button_playadd, button_playmore, button_addcontext, button_addnext, button_addlast, button_download, button_youtube, button_lyric, last_fm_enabled, last_fm_username, last_fm_password, transcode_scheme, show_now_playing, selected_music_folder_id, selected_genre, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_artist_info, show_chat, list_type, playqueue_resize, leftframe_resize, customscrollbar, customaccordion, view_as, song_notification, show_left_shrinked, show_left_bar, show_left_panel, show_right_panel, show_side_panel from user_settings where username=?
[2017-03-04 22:20:02,814] DEBUG AbstractDao - fn::run::getVideoConversionsByStatus: 9031 ms: select id, media_file_id, audio_track_id, username, status, target_file, log_file, bit_rate, progress_seconds, created, changed, started from video_conversion where status=? order by created
[2017-03-04 22:20:05,992] DEBUG AbstractDao - fn::getUserSettings::queryOne: 4673 ms: select username, locale, theme_id, final_version_notification, beta_version_notification, main_caption_cutoff, main_disc_number, main_track_number, main_artist, main_album, main_genre, main_mood, main_year, main_bit_rate, main_duration, main_format, main_file_size, main_bpm, main_composer, playlist_caption_cutoff, playlist_disc_number, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_mood, playlist_year, playlist_bit_rate, playlist_duration, playlist_format, playlist_file_size, playlist_bpm, playlist_composer, button_rank, button_loved, button_starred, button_play, button_playadd, button_playmore, button_addcontext, button_addnext, button_addlast, button_download, button_youtube, button_lyric, last_fm_enabled, last_fm_username, last_fm_password, transcode_scheme, show_now_playing, selected_music_folder_id, selected_genre, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_artist_info, show_chat, list_type, playqueue_resize, leftframe_resize, customscrollbar, customaccordion, view_as, song_notification, show_left_shrinked, show_left_bar, show_left_panel, show_right_panel, show_side_panel from user_settings where username=?
[2017-03-04 22:20:18,470] DEBUG AbstractDao - fn::getUserSettings::queryOne: 9082 ms: select username, locale, theme_id, final_version_notification, beta_version_notification, main_caption_cutoff, main_disc_number, main_track_number, main_artist, main_album, main_genre, main_mood, main_year, main_bit_rate, main_duration, main_format, main_file_size, main_bpm, main_composer, playlist_caption_cutoff, playlist_disc_number, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_mood, playlist_year, playlist_bit_rate, playlist_duration, playlist_format, playlist_file_size, playlist_bpm, playlist_composer, button_rank, button_loved, button_starred, button_play, button_playadd, button_playmore, button_addcontext, button_addnext, button_addlast, button_download, button_youtube, button_lyric, last_fm_enabled, last_fm_username, last_fm_password, transcode_scheme, show_now_playing, selected_music_folder_id, selected_genre, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_artist_info, show_chat, list_type, playqueue_resize, leftframe_resize, customscrollbar, customaccordion, view_as, song_notification, show_left_shrinked, show_left_bar, show_left_panel, show_right_panel, show_side_panel from user_settings where username=?
[2017-03-04 22:20:25,849] DEBUG AbstractDao - fn::getTask::queryOne: 30148 ms: select id, music_folder_id, found, scan, status, result, comment, enabled from music_folder_tasks where music_folder_id = ?
[2017-03-04 22:20:57,366] DEBUG AbstractDao - fn::run::getAudioConversionsByStatus: 52758 ms: select id, media_file_id, username, status, target_file, target_format, log_file, bit_rate, progress_seconds, created, changed, started from audio_conversion where status=? order by created
[2017-03-04 22:20:57,366] DEBUG AbstractDao - fn::populateBookmarkPosition::getMediaFileBookmarkPosition: 50011 ms: select POSITION_MILLIS from bookmark where media_file_id=? and username=?
[2017-03-04 22:20:59,126] DEBUG AbstractDao - fn::run::getVideoConversionsByStatus: 47010 ms: select id, media_file_id, audio_track_id, username, status, target_file, log_file, bit_rate, progress_seconds, created, changed, started from video_conversion where status=? order by created
[2017-03-04 22:20:59,126] DEBUG AbstractDao - fn::getUserSettings::queryOne: 36903 ms: select username, locale, theme_id, final_version_notification, beta_version_notification, main_caption_cutoff, main_disc_number, main_track_number, main_artist, main_album, main_genre, main_mood, main_year, main_bit_rate, main_duration, main_format, main_file_size, main_bpm, main_composer, playlist_caption_cutoff, playlist_disc_number, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_mood, playlist_year, playlist_bit_rate, playlist_duration, playlist_format, playlist_file_size, playlist_bpm, playlist_composer, button_rank, button_loved, button_starred, button_play, button_playadd, button_playmore, button_addcontext, button_addnext, button_addlast, button_download, button_youtube, button_lyric, last_fm_enabled, last_fm_username, last_fm_password, transcode_scheme, show_now_playing, selected_music_folder_id, selected_genre, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_artist_info, show_chat, list_type, playqueue_resize, leftframe_resize, customscrollbar, customaccordion, view_as, song_notification, show_left_shrinked, show_left_bar, show_left_panel, show_right_panel, show_side_panel from user_settings where username=?
[2017-03-04 22:20:59,126] DEBUG AbstractDao - fn::getAllMusicFolders::getAllMusicFolders: 39358 ms: select id, path, name, enabled, changed, mf_index, mf_type, mf_groupby, mf_timer, mf_interval from music_folder
[2017-03-04 22:20:29,059] DEBUG AbstractDao - fn::getUserSettings::queryOne: 13201 ms: select username, locale, theme_id, final_version_notification, beta_version_notification, main_caption_cutoff, main_disc_number, main_track_number, main_artist, main_album, main_genre, main_mood, main_year, main_bit_rate, main_duration, main_format, main_file_size, main_bpm, main_composer, playlist_caption_cutoff, playlist_disc_number, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_mood, playlist_year, playlist_bit_rate, playlist_duration, playlist_format, playlist_file_size, playlist_bpm, playlist_composer, button_rank, button_loved, button_starred, button_play, button_playadd, button_playmore, button_addcontext, button_addnext, button_addlast, button_download, button_youtube, button_lyric, last_fm_enabled, last_fm_username, last_fm_password, transcode_scheme, show_now_playing, selected_music_folder_id, selected_genre, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_artist_info, show_chat, list_type, playqueue_resize, leftframe_resize, customscrollbar, customaccordion, view_as, song_notification, show_left_shrinked, show_left_bar, show_left_panel, show_right_panel, show_side_panel from user_settings where username=?
[2017-03-04 22:21:08,142] DEBUG AbstractDao - fn::populateStarredDate::getMediaFileStarredDate: 32989 ms: select created from starred_media_file where media_file_id=? and username=?
[2017-03-04 22:21:32,918] DEBUG AbstractDao - fn::run::getVideoConversionsByStatus: 6683 ms: select id, media_file_id, audio_track_id, username, status, target_file, log_file, bit_rate, progress_seconds, created, changed, started from video_conversion where status=? order by created
[2017-03-04 22:21:37,589] DEBUG AbstractDao - fn::getAllMusicFolders::getAllMusicFolders: 18270 ms: select id, path, name, enabled, changed, mf_index, mf_type, mf_groupby, mf_timer, mf_interval from music_folder
[2017-03-04 22:21:46,365] DEBUG AbstractDao - fn::run::getAudioConversionsByStatus: 28893 ms: select id, media_file_id, username, status, target_file, target_format, log_file, bit_rate, progress_seconds, created, changed, started from audio_conversion where status=? order by created
[2017-03-04 22:22:04,935] DEBUG AbstractDao - fn::getTask::queryOne: 75045 ms: select id, music_folder_id, found, scan, status, result, comment, enabled from music_folder_tasks where music_folder_id = ?
[2017-03-04 22:22:19,122] DEBUG AbstractDao - fn::getAllMusicFolders::getAllMusicFolders: 26485 ms: select id, path, name, enabled, changed, mf_index, mf_type, mf_groupby, mf_timer, mf_interval from music_folder
[2017-03-04 22:26:48,496] DEBUG AbstractDao - fn::populateLovedDate::getMediaFileLovedDate: 120550 ms: select created from loved_media_file where media_file_id=? and username=?
[2017-03-04 22:26:48,496] DEBUG AbstractDao - fn::getMediaFile::queryOne: 142621 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=?
[2017-03-04 22:35:42,950] DEBUG AbstractDao - fn::run::getVideoConversionsByStatus: 612482 ms: select id, media_file_id, audio_track_id, username, status, target_file, log_file, bit_rate, progress_seconds, created, changed, started from video_conversion where status=? order by created
[2017-03-04 22:36:21,708] DEBUG AbstractDao - fn::getTask::queryOne: 816693 ms: select id, music_folder_id, found, scan, status, result, comment, enabled from music_folder_tasks where music_folder_id = ?
[2017-03-04 22:36:21,708] DEBUG AbstractDao - fn::run::getAudioConversionsByStatus: 818374 ms: select id, media_file_id, username, status, target_file, target_format, log_file, bit_rate, progress_seconds, created, changed, started from audio_conversion where status=? order by created
[2017-03-04 22:40:39,841] DEBUG AbstractDao - fn::populateStarredDate::getMediaFileStarredDate: 430222 ms: select created from starred_media_file where media_file_id=? and username=?
[2017-03-04 22:47:34,521] WARN HsqlDaoHelper - Shutting down database...
[2017-03-04 22:47:34,521] DEBUG AbstractDao - fn::run::getVideoConversionsByStatus: 438997 ms: select id, media_file_id, audio_track_id, username, status, target_file, log_file, bit_rate, progress_seconds, created, changed, started from video_conversion where status=? order by created
[2017-03-04 22:49:37,940] DEBUG AbstractDao - fn::getMediaFile::queryOne: 1255143 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=?
[2017-03-04 22:55:59,747] DEBUG AbstractDao - fn::populateBookmarkPosition::getMediaFileBookmarkPosition: 698545 ms: select POSITION_MILLIS from bookmark where media_file_id=? and username=?
[2017-03-04 23:01:13,309] DEBUG AbstractDao - fn::getTask::queryOne: 1447167 ms: select id, music_folder_id, found, scan, status, result, comment, enabled from music_folder_tasks where music_folder_id = ?
[2017-03-04 23:02:32,288] DEBUG AbstractDao - fn::getUserSettings::queryOne: 1349882 ms: select username, locale, theme_id, final_version_notification, beta_version_notification, main_caption_cutoff, main_disc_number, main_track_number, main_artist, main_album, main_genre, main_mood, main_year, main_bit_rate, main_duration, main_format, main_file_size, main_bpm, main_composer, playlist_caption_cutoff, playlist_disc_number, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_mood, playlist_year, playlist_bit_rate, playlist_duration, playlist_format, playlist_file_size, playlist_bpm, playlist_composer, button_rank, button_loved, button_starred, button_play, button_playadd, button_playmore, button_addcontext, button_addnext, button_addlast, button_download, button_youtube, button_lyric, last_fm_enabled, last_fm_username, last_fm_password, transcode_scheme, show_now_playing, selected_music_folder_id, selected_genre, party_mode_enabled, now_playing_allowed, avatar_scheme, system_avatar_id, changed, show_artist_info, show_chat, list_type, playqueue_resize, leftframe_resize, customscrollbar, customaccordion, view_as, song_notification, show_left_shrinked, show_left_bar, show_left_panel, show_right_panel, show_side_panel from user_settings where username=?
Let me know, if I can give more/other precise information. (after shuting down the madsonic service, CPU and JAVA is still killing most of the ressources, AND after starting the madsonic server again, its still unresponsive. The "old" logfile is still being written. As you can see above. I guess, I need to kill the "old" Java process(es))
This behaviour is very simple reproduceable. (with a large/huge media library, I guess)