No connection to the server anymore (NullPointerException)

Need help? Post your questions here.
User avatar
Matt Zornig
Contributor
Contributor
Posts: 242
Joined: 14 Feb 2017, 12:03
Has thanked: 38 times
Been thanked: 28 times

No connection to the server anymore (NullPointerException)

Unread post by Matt Zornig »

Code: Select all

=========================================================================================
VERSION: MADSONIC 6.3 | BUILD: 9840.8df1ddd.20180107.0710
REST: MADSONIC REST API v3.0.0, MADSONIC REST API v2.8.0, SUBSONIC REST API v1.16.0
OS: Linux 3.10.102 #15266 SMP Mon Mar 26 15:08:28 CST 2018 x86_64 GNU/Linux
SERVER: jetty/8.y.z-SNAPSHOT, java 1.8.0_172, Linux 3.10.102 (amd64)
HOST: Synology NAS 1815+ (DSM 6.1.6-15266 Update 1) | CPU: INTEL Atom C2538| ARCH: X64 | MEMORY: 16GB | HDD: 36TB, RAID6
CLIENT/BROWSER: FF 53.x
JAVA: ORACLE JDK 1.8.0_172
DESCRIPTION: as in the topic's subject or body
REPRODUCIBLE: hopefully not
logged in as admin
=========================================================================================
Hello,

A sceduled scan for Share-K is running since some hours and I was listening to music via Madsonic Server,
as all of a sudden, the WebGUI was not responding anymore.

I restarted the Browser but still not response from Madsonic WebGUI.

The Log tells me, Madsonic Server is alive, but scannng stopped incompleted, as you can see in the last lines.

When I check the logs, I see this:

Code: Select all

[2018-05-06 05:08:59,715] INFO MediaScannerService - Scanned media library with 285000 entries.
[2018-05-06 05:09:11,418] INFO MediaScannerService - Scanned media library with 285500 entries.
[2018-05-06 05:09:22,543] INFO MediaScannerService - Scanned media library with 286000 entries.
[2018-05-06 05:09:34,742] INFO MediaScannerService - Scanned media library with 286500 entries.
[2018-05-06 05:09:46,591] INFO MediaScannerService - Scanned media library with 287000 entries.
[2018-05-06 05:09:57,678] INFO MediaScannerService - Scanned media library with 287500 entries.
[2018-05-06 05:10:08,821] INFO MediaScannerService - Scanned media library with 288000 entries.
[2018-05-06 05:10:22,466] INFO MediaScannerService - Scanned media library with 288500 entries.
[2018-05-06 05:10:48,337] DEBUG AbstractDao - fn::scanFile::markPresent:  8349 ms:  update media_file set present=?, last_scanned=? where path=?
[2018-05-06 05:10:48,337] DEBUG AbstractDao - fn::getUserSettings::queryOne:  6257 ms:  select username, locale, theme_id, final_version_notification, beta_version_notification, main_caption_cutoff, main_popular, main_disc_number, main_track_number, main_artist, main_album, main_genre, main_mood, main_comment, main_year, main_bit_rate, main_duration, main_format, main_file_size, main_bpm, main_composer, main_custom, playlist_caption_cutoff, playlist_popular, playlist_disc_number, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_mood, playlist_comment, playlist_year, playlist_bit_rate, playlist_duration, playlist_format, playlist_file_size, playlist_bpm, playlist_composer, playlist_custom, 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, list_default, 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=?
[2018-05-06 05:10:48,337] DEBUG AbstractDao - fn::run::getAudioConversionsByStatus:  3902 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
[2018-05-06 05:10:48,337] DEBUG AbstractDao - fn::run::getVideoConversionsByStatus:  3903 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
[2018-05-06 05:10:48,813] INFO MediaScannerService - Scanned media library with 289000 entries.
[2018-05-06 05:11:01,006] INFO MediaScannerService - Scanned media library with 289500 entries.
[2018-05-06 05:11:15,835] INFO MediaScannerService - Scanned media library with 290000 entries.
[2018-05-06 05:11:29,557] INFO MediaScannerService - Scanned media library with 290500 entries.
[2018-05-06 05:11:39,222] INFO MediaScannerService - Scanned media library with 291000 entries.
[2018-05-06 05:12:15,370] DEBUG StreamController - GET /stream?player=1&id=484255&auth=1376140715&scrobble=false, Range: bytes=0-
[2018-05-06 05:12:15,381] DEBUG StreamController - Content-Range: 0-6278169/6278170
[2018-05-06 05:12:15,381] DEBUG StreamController - Content-Length: 6278170
[2018-05-06 05:12:15,383] INFO StreamController - admin is streaming "2015 - Ham Kummst [CD]/108. Seiler Und Speer - Stopp Doch Die Zeit.mp3" [RAW]
[2018-05-06 05:12:15,639] DEBUG StreamController - GET /stream?player=1&id=484264&auth=247794154&scrobble=false, Range: bytes=0-
[2018-05-06 05:12:15,645] DEBUG StreamController - Content-Range: 0-8157318/8157319
[2018-05-06 05:12:15,645] DEBUG StreamController - Content-Length: 8157319
[2018-05-06 05:12:15,646] INFO StreamController - admin is streaming "2015 - Ham Kummst [CD]/104. Seiler Und Speer - Bonnie Und Clyde.mp3" [RAW]
[2018-05-06 05:12:19,326] DEBUG StreamController - GET /stream?player=1&id=484241&auth=726304746&scrobble=false, Range: bytes=0-
[2018-05-06 05:12:19,443] DEBUG StreamController - Content-Range: 0-7559362/7559363
[2018-05-06 05:12:19,443] DEBUG StreamController - Content-Length: 7559363
[2018-05-06 05:12:19,444] INFO StreamController - admin is streaming "2015 - Ham Kummst [CD]/102. Seiler Und Speer - Ham Kummst.mp3" [RAW]
[2018-05-06 05:12:49,452] DEBUG AbstractDao - fn::getUserSettings::queryOne:  3327 ms:  select username, locale, theme_id, final_version_notification, beta_version_notification, main_caption_cutoff, main_popular, main_disc_number, main_track_number, main_artist, main_album, main_genre, main_mood, main_comment, main_year, main_bit_rate, main_duration, main_format, main_file_size, main_bpm, main_composer, main_custom, playlist_caption_cutoff, playlist_popular, playlist_disc_number, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_mood, playlist_comment, playlist_year, playlist_bit_rate, playlist_duration, playlist_format, playlist_file_size, playlist_bpm, playlist_composer, playlist_custom, 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, list_default, 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=?
[2018-05-06 05:13:08,852] DEBUG AbstractDao - fn::run::getVideoConversionsByStatus:  4868 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
[2018-05-06 05:14:11,666] DEBUG AbstractDao - fn::getUserSettings::queryOne:  67681 ms:  select username, locale, theme_id, final_version_notification, beta_version_notification, main_caption_cutoff, main_popular, main_disc_number, main_track_number, main_artist, main_album, main_genre, main_mood, main_comment, main_year, main_bit_rate, main_duration, main_format, main_file_size, main_bpm, main_composer, main_custom, playlist_caption_cutoff, playlist_popular, playlist_disc_number, playlist_track_number, playlist_artist, playlist_album, playlist_genre, playlist_mood, playlist_comment, playlist_year, playlist_bit_rate, playlist_duration, playlist_format, playlist_file_size, playlist_bpm, playlist_composer, playlist_custom, 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, list_default, 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=?
[2018-05-06 05:14:11,672] DEBUG AbstractDao - fn::run::getVideoConversionsByStatus:  47840 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
[2018-05-06 05:15:00,303] DEBUG AbstractDao - fn::scanFile::markPresent:  188770 ms:  update media_file set present=?, last_scanned=? where path=?
[2018-05-06 05:15:00,315] INFO MediaScannerService - Scanned media library with 291500 entries.
[2018-05-06 05:15:00,318] DEBUG AbstractDao - fn::updateMediaFile::createOrUpdateMediaFile:  164924 ms:  update media_file set folder=?,type=?,override=?,format=?,data=?,title=?,album=?,album_name=?,artist=?,album_artist=?,disc_number=?,track_number=?,year=?,genre=?,genre_raw=?,mood=?,mood_raw=?,bpm=?,composer=?,bit_rate=?,variable_bit_rate=?,duration_seconds=?,file_size=?,width=?,height=?,cover_art_path=?,parent_path=?,play_count=?,last_played=?,comment=?,changed=?,last_scanned=?,children_last_updated=?,present=?, version=?, rank=?, custom=?, popular=? where path=?
[2018-05-06 05:15:08,614] ERROR MediaScannerService - Failed to scan media library.
org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [update media_file set present=?, last_scanned=? where path=?]; integrity constraint violation: unique constraint or index violation: IDX_MEDIA_FILE_GENRE_RAW; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation: IDX_MEDIA_FILE_GENRE_RAW
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:818)
	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:874)
	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:882)
	at org.madsonic.dao.AbstractDao.update(AbstractDao.java:82)
	at org.madsonic.dao.MediaFileDao.markPresent(MediaFileDao.java:1115)
	at org.madsonic.service.MediaScannerService.scanFile(MediaScannerService.java:531)
	at org.madsonic.service.MediaScannerService.scanFile(MediaScannerService.java:509)
	at org.madsonic.service.MediaScannerService.scanFile(MediaScannerService.java:512)
	at org.madsonic.service.MediaScannerService.scanFile(MediaScannerService.java:512)
	at org.madsonic.service.MediaScannerService.doFullScanLibrary(MediaScannerService.java:361)
	at org.madsonic.service.MediaScannerService.access$200(MediaScannerService.java:62)
	at org.madsonic.service.MediaScannerService$4.run(MediaScannerService.java:209)
Caused by: java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation: IDX_MEDIA_FILE_GENRE_RAW
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source)
	at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:824)
	at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:818)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
	... 12 more
Caused by: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation: IDX_MEDIA_FILE_GENRE_RAW
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.index.IndexAVL.insert(Unknown Source)
	at org.hsqldb.persist.RowStoreAVL.indexRow(Unknown Source)
	at org.hsqldb.persist.RowStoreAVLDisk.indexRow(Unknown Source)
	at org.hsqldb.persist.RowStoreAVLDisk.rollbackRow(Unknown Source)
	at org.hsqldb.TransactionManager2PL.rollbackPartial(Unknown Source)
	at org.hsqldb.TransactionManager2PL.rollbackAction(Unknown Source)
	at org.hsqldb.Session.endAction(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 17 more

[2018-05-06 05:15:08,654] ERROR MediaScannerService - ERROR PreparedStatementCallback; SQL [update media_file set present=?, last_scanned=? where path=?]; integrity constraint violation: unique constraint or index violation: IDX_MEDIA_FILE_GENRE_RAW; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation: IDX_MEDIA_FILE_GENRE_RAW
org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [update media_file set present=?, last_scanned=? where path=?]; integrity constraint violation: unique constraint or index violation: IDX_MEDIA_FILE_GENRE_RAW; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation: IDX_MEDIA_FILE_GENRE_RAW
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:818)
	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:874)
	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:882)
	at org.madsonic.dao.AbstractDao.update(AbstractDao.java:82)
	at org.madsonic.dao.MediaFileDao.markPresent(MediaFileDao.java:1115)
	at org.madsonic.service.MediaScannerService.scanFile(MediaScannerService.java:531)
	at org.madsonic.service.MediaScannerService.scanFile(MediaScannerService.java:509)
	at org.madsonic.service.MediaScannerService.scanFile(MediaScannerService.java:512)
	at org.madsonic.service.MediaScannerService.scanFile(MediaScannerService.java:512)
	at org.madsonic.service.MediaScannerService.doFullScanLibrary(MediaScannerService.java:361)
	at org.madsonic.service.MediaScannerService.access$200(MediaScannerService.java:62)
	at org.madsonic.service.MediaScannerService$4.run(MediaScannerService.java:209)
Caused by: java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation: IDX_MEDIA_FILE_GENRE_RAW
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source)
	at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:824)
	at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:818)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
	... 12 more
Caused by: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation: IDX_MEDIA_FILE_GENRE_RAW
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.index.IndexAVL.insert(Unknown Source)
	at org.hsqldb.persist.RowStoreAVL.indexRow(Unknown Source)
	at org.hsqldb.persist.RowStoreAVLDisk.indexRow(Unknown Source)
	at org.hsqldb.persist.RowStoreAVLDisk.rollbackRow(Unknown Source)
	at org.hsqldb.TransactionManager2PL.rollbackPartial(Unknown Source)
	at org.hsqldb.TransactionManager2PL.rollbackAction(Unknown Source)
	at org.hsqldb.Session.endAction(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 17 more

[2018-05-06 05:15:13,297] DEBUG MediaScannerService - WATCHDOG:END:
[2018-05-06 05:15:13,297] INFO PlaylistService - Starting playlist import.
[2018-05-06 05:15:13,297] INFO PlaylistService - Completed playlist import.
[2018-05-06 05:15:13,297] INFO PlaylistService - Starting playlist statistics update.
[2018-05-06 05:15:13,857] INFO PlaylistService - Completed playlist statistics update.
[2018-05-06 05:16:01,340] INFO MediaScannerService - WATCHDOG:SCAN: doFolderScanLibrary() started at Sun May 06 05:16:01 CEST 2018
[2018-05-06 05:16:01,342] DEBUG MediaScannerService - WATCHDOG:RUN: doUpdateTasks()
[2018-05-06 05:16:01,345] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [Share-K]
[2018-05-06 05:16:01,347] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [Share-W]
[2018-05-06 05:18:01,340] INFO MediaScannerService - WATCHDOG:SCAN: doFolderScanLibrary() started at Sun May 06 05:18:01 CEST 2018
[2018-05-06 05:18:01,984] INFO MediaScannerService - Scanned media library with 292000 entries.
[2018-05-06 05:18:08,186] INFO MediaScannerService - Scanned media library with 292500 entries.
[2018-05-06 05:18:13,685] INFO MediaScannerService - Scanned media library with 293000 entries.
[2018-05-06 05:18:21,019] INFO MediaScannerService - Scanned media library with 293500 entries.
[2018-05-06 05:18:27,317] INFO MediaScannerService - Scanned media library with 294000 entries.
[2018-05-06 05:18:27,933] ERROR MediaScannerService - Failed to scan folder.
org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [select id, path, folder, type, override, format, data, title, album, album_name, artist, album_artist, disc_number, track_number, year, genre, genre_raw, mood, mood_raw, 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, custom, popular from media_file where parent_path=? and present]; java.lang.NullPointerException; nested exception is java.sql.SQLException: java.lang.NullPointerException
	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:106)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:668)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:676)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:716)
	at org.madsonic.dao.AbstractDao.query(AbstractDao.java:109)
	at org.madsonic.dao.MediaFileDao.getChildrenOf(MediaFileDao.java:125)
	at org.madsonic.service.MediaFileService.getChildrenOf(MediaFileService.java:337)
	at org.madsonic.service.MediaScannerService.scanFile(MediaScannerService.java:443)
	at org.madsonic.service.MediaScannerService.scanFile(MediaScannerService.java:447)
	at org.madsonic.service.MediaScannerService.scanFile(MediaScannerService.java:447)
	at org.madsonic.service.MediaScannerService.scanFile(MediaScannerService.java:447)
	at org.madsonic.service.MediaScannerService.doFolderScanLibrary(MediaScannerService.java:292)
	at org.madsonic.service.MediaScannerService.access$000(MediaScannerService.java:62)
	at org.madsonic.service.MediaScannerService$3.run(MediaScannerService.java:191)
Caused by: java.sql.SQLException: java.lang.NullPointerException
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.executeQuery(Unknown Source)
	at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:646)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
	... 14 more
Caused by: org.hsqldb.HsqlException: java.lang.NullPointerException
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.persist.DataFileCache.getFromFile(Unknown Source)
	at org.hsqldb.persist.DataFileCache.get(Unknown Source)
	at org.hsqldb.persist.RowStoreAVLDisk.get(Unknown Source)
	at org.hsqldb.index.NodeAVLDisk.findNode(Unknown Source)
	at org.hsqldb.index.NodeAVLDisk.getLeft(Unknown Source)
	at org.hsqldb.index.IndexAVL.next(Unknown Source)
	at org.hsqldb.index.IndexAVL.next(Unknown Source)
	at org.hsqldb.index.IndexAVL$IndexRowIterator.getNextRow(Unknown Source)
	at org.hsqldb.index.IndexAVL$IndexRowIterator.next(Unknown Source)
	at org.hsqldb.RangeVariable$RangeIteratorMain.findNext(Unknown Source)
	at org.hsqldb.RangeVariable$RangeIteratorMain.next(Unknown Source)
	at org.hsqldb.QuerySpecification.buildResult(Unknown Source)
	at org.hsqldb.QuerySpecification.getSingleResult(Unknown Source)
	at org.hsqldb.QuerySpecification.getResult(Unknown Source)
	at org.hsqldb.StatementQuery.getResult(Unknown Source)
	at org.hsqldb.StatementDMQL.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 18 more
Caused by: java.lang.NullPointerException

[2018-05-06 05:18:27,934] ERROR MediaScannerService - ERROR PreparedStatementCallback; SQL [select id, path, folder, type, override, format, data, title, album, album_name, artist, album_artist, disc_number, track_number, year, genre, genre_raw, mood, mood_raw, 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, custom, popular from media_file where parent_path=? and present]; java.lang.NullPointerException; nested exception is java.sql.SQLException: java.lang.NullPointerException
org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [select id, path, folder, type, override, format, data, title, album, album_name, artist, album_artist, disc_number, track_number, year, genre, genre_raw, mood, mood_raw, 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, custom, popular from media_file where parent_path=? and present]; java.lang.NullPointerException; nested exception is java.sql.SQLException: java.lang.NullPointerException
	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:106)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:668)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:676)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:716)
	at org.madsonic.dao.AbstractDao.query(AbstractDao.java:109)
	at org.madsonic.dao.MediaFileDao.getChildrenOf(MediaFileDao.java:125)
	at org.madsonic.service.MediaFileService.getChildrenOf(MediaFileService.java:337)
	at org.madsonic.service.MediaScannerService.scanFile(MediaScannerService.java:443)
	at org.madsonic.service.MediaScannerService.scanFile(MediaScannerService.java:447)
	at org.madsonic.service.MediaScannerService.scanFile(MediaScannerService.java:447)
	at org.madsonic.service.MediaScannerService.scanFile(MediaScannerService.java:447)
	at org.madsonic.service.MediaScannerService.doFolderScanLibrary(MediaScannerService.java:292)
	at org.madsonic.service.MediaScannerService.access$000(MediaScannerService.java:62)
	at org.madsonic.service.MediaScannerService$3.run(MediaScannerService.java:191)
Caused by: java.sql.SQLException: java.lang.NullPointerException
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.executeQuery(Unknown Source)
	at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:646)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:589)
	... 14 more
Caused by: org.hsqldb.HsqlException: java.lang.NullPointerException
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.persist.DataFileCache.getFromFile(Unknown Source)
	at org.hsqldb.persist.DataFileCache.get(Unknown Source)
	at org.hsqldb.persist.RowStoreAVLDisk.get(Unknown Source)
	at org.hsqldb.index.NodeAVLDisk.findNode(Unknown Source)
	at org.hsqldb.index.NodeAVLDisk.getLeft(Unknown Source)
	at org.hsqldb.index.IndexAVL.next(Unknown Source)
	at org.hsqldb.index.IndexAVL.next(Unknown Source)
	at org.hsqldb.index.IndexAVL$IndexRowIterator.getNextRow(Unknown Source)
	at org.hsqldb.index.IndexAVL$IndexRowIterator.next(Unknown Source)
	at org.hsqldb.RangeVariable$RangeIteratorMain.findNext(Unknown Source)
	at org.hsqldb.RangeVariable$RangeIteratorMain.next(Unknown Source)
	at org.hsqldb.QuerySpecification.buildResult(Unknown Source)
	at org.hsqldb.QuerySpecification.getSingleResult(Unknown Source)
	at org.hsqldb.QuerySpecification.getResult(Unknown Source)
	at org.hsqldb.StatementQuery.getResult(Unknown Source)
	at org.hsqldb.StatementDMQL.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 18 more
Caused by: java.lang.NullPointerException

[2018-05-06 05:18:27,937] DEBUG MediaScannerService - WATCHDOG:RUN: doUpdateTasks()
[2018-05-06 05:18:27,938] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [Share-K]
[2018-05-06 05:18:27,940] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [Share-W]
[2018-05-06 05:20:01,339] INFO MediaScannerService - WATCHDOG:SCAN: doFolderScanLibrary() started at Sun May 06 05:20:01 CEST 2018
[2018-05-06 05:20:01,357] DEBUG MediaScannerService - WATCHDOG:RUN: doUpdateTasks()
[2018-05-06 05:20:01,357] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [Share-K]
[2018-05-06 05:20:01,359] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [Share-W]
[2018-05-06 05:22:01,340] INFO MediaScannerService - WATCHDOG:SCAN: doFolderScanLibrary() started at Sun May 06 05:22:01 CEST 2018
[2018-05-06 05:22:01,347] DEBUG MediaScannerService - WATCHDOG:RUN: doUpdateTasks()
[2018-05-06 05:22:01,407] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [Share-K]
[2018-05-06 05:22:01,408] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [Share-W]
[2018-05-06 05:24:01,340] INFO MediaScannerService - WATCHDOG:SCAN: doFolderScanLibrary() started at Sun May 06 05:24:01 CEST 2018
[2018-05-06 05:24:01,347] DEBUG MediaScannerService - WATCHDOG:RUN: doUpdateTasks()
[2018-05-06 05:24:01,347] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [Share-K]
[2018-05-06 05:24:01,349] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [Share-W]
[2018-05-06 05:26:01,339] INFO MediaScannerService - WATCHDOG:SCAN: doFolderScanLibrary() started at Sun May 06 05:26:01 CEST 2018
[2018-05-06 05:26:01,347] DEBUG MediaScannerService - WATCHDOG:RUN: doUpdateTasks()
[2018-05-06 05:26:01,348] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [Share-K]
[2018-05-06 05:26:01,349] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [Share-W]
[2018-05-06 05:28:01,339] INFO MediaScannerService - WATCHDOG:SCAN: doFolderScanLibrary() started at Sun May 06 05:28:01 CEST 2018
[2018-05-06 05:28:01,346] DEBUG MediaScannerService - WATCHDOG:RUN: doUpdateTasks()
[2018-05-06 05:28:01,347] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [Share-K]
[2018-05-06 05:28:01,348] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [Share-W]
[2018-05-06 05:30:01,340] INFO MediaScannerService - WATCHDOG:SCAN: doFolderScanLibrary() started at Sun May 06 05:30:01 CEST 2018
[2018-05-06 05:30:01,347] DEBUG MediaScannerService - WATCHDOG:RUN: doUpdateTasks()
[2018-05-06 05:30:01,347] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [Share-K]
[2018-05-06 05:30:01,349] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [Share-W]
[2018-05-06 05:32:01,339] INFO MediaScannerService - WATCHDOG:SCAN: doFolderScanLibrary() started at Sun May 06 05:32:01 CEST 2018
[2018-05-06 05:32:01,346] DEBUG MediaScannerService - WATCHDOG:RUN: doUpdateTasks()
[2018-05-06 05:32:01,347] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [Share-K]
[2018-05-06 05:32:01,348] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [Share-W]
[2018-05-06 05:34:01,339] INFO MediaScannerService - WATCHDOG:SCAN: doFolderScanLibrary() started at Sun May 06 05:34:01 CEST 2018
[2018-05-06 05:34:01,346] DEBUG MediaScannerService - WATCHDOG:RUN: doUpdateTasks()
[2018-05-06 05:34:01,347] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [Share-K]
[2018-05-06 05:34:01,348] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [Share-W]
[2018-05-06 05:36:01,340] INFO MediaScannerService - WATCHDOG:SCAN: doFolderScanLibrary() started at Sun May 06 05:36:01 CEST 2018
[2018-05-06 05:36:01,347] DEBUG MediaScannerService - WATCHDOG:RUN: doUpdateTasks()
[2018-05-06 05:36:01,348] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [Share-K]
[2018-05-06 05:36:01,349] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [Share-W]
[2018-05-06 05:38:01,340] INFO MediaScannerService - WATCHDOG:SCAN: doFolderScanLibrary() started at Sun May 06 05:38:01 CEST 2018
[2018-05-06 05:38:01,347] DEBUG MediaScannerService - WATCHDOG:RUN: doUpdateTasks()
[2018-05-06 05:38:01,348] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [Share-K]
[2018-05-06 05:38:01,349] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [Share-W]
[2018-05-06 05:40:01,340] INFO MediaScannerService - WATCHDOG:SCAN: doFolderScanLibrary() started at Sun May 06 05:40:01 CEST 2018
[2018-05-06 05:40:01,349] DEBUG MediaScannerService - WATCHDOG:RUN: doUpdateTasks()
[2018-05-06 05:40:01,350] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [Share-K]
[2018-05-06 05:40:01,352] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [Share-W]
[2018-05-06 05:42:01,341] INFO MediaScannerService - WATCHDOG:SCAN: doFolderScanLibrary() started at Sun May 06 05:42:01 CEST 2018
[2018-05-06 05:42:01,348] DEBUG MediaScannerService - WATCHDOG:RUN: doUpdateTasks()
[2018-05-06 05:42:01,348] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [Share-K]
[2018-05-06 05:42:01,349] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [Share-W]
[2018-05-06 05:44:01,341] INFO MediaScannerService - WATCHDOG:SCAN: doFolderScanLibrary() started at Sun May 06 05:44:01 CEST 2018
[2018-05-06 05:44:01,348] DEBUG MediaScannerService - WATCHDOG:RUN: doUpdateTasks()
[2018-05-06 05:44:01,349] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [Share-K]
[2018-05-06 05:44:01,350] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [Share-W]
[2018-05-06 05:46:01,340] INFO MediaScannerService - WATCHDOG:SCAN: doFolderScanLibrary() started at Sun May 06 05:46:01 CEST 2018
[2018-05-06 05:46:01,347] DEBUG MediaScannerService - WATCHDOG:RUN: doUpdateTasks()
[2018-05-06 05:46:01,348] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [Share-K]
[2018-05-06 05:46:01,349] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [Share-W]
[2018-05-06 05:48:01,340] INFO MediaScannerService - WATCHDOG:SCAN: doFolderScanLibrary() started at Sun May 06 05:48:01 CEST 2018
[2018-05-06 05:48:01,348] DEBUG MediaScannerService - WATCHDOG:RUN: doUpdateTasks()
[2018-05-06 05:48:01,349] DEBUG MediaScannerService - WATCHDOG:TIMER: PLANNED [Share-K]
[2018-05-06 05:48:01,368] DEBUG MediaScannerService - WATCHDOG:TIMER: UPDATED [Share-W]
Post Reply