Page 1 of 1

Memory Error!

Unread postPosted: 25 Feb 2015, 04:36
by taoism
Exception org.springframework.dao.TransientDataAccessResourceException
Message PreparedStatementCallback; SQL [insert into media_file (id, path, folder, type, override, format, data, title, album, album_name, artist, album_artist, disc_number, track_number, year, genre, mood, 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) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; org.hsqldb.HsqlException: java.io.EOFException; nested exception is java.sql.SQLException: org.hsqldb.HsqlException: java.io.EOFException
Java version Oracle Corporation 1.8.0_31
Operating system Windows 7 6.1
Server jetty/8.y.z-SNAPSHOT
Memory Used 49 of 372 MB
Stack trace org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [insert into media_file (id, path, folder, type, override, format, data, title, album, album_name, artist, album_artist, disc_number, track_number, year, genre, mood, 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) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; org.hsqldb.HsqlException: java.io.EOFException; nested exception is

Re: Memory Error!

Unread postPosted: 01 Mar 2015, 02:40
by DoCC
welcome to club, hsqldb fucked up : )

stop the deamon,
rename the db directory,
restart the deamon,
wait 30 sec,
stop the deamon,
copy some needed stuff like users, customavatars and podcasts to the regarding place from the old to the new madsonic.script file
restart the deamon,
setup the music folders once again.
rescan the media files ...

no, there is no other way.