Memory Error!

Post your Server Bug Report
taoism
Posts: 8
Joined: 19 May 2014, 06:58
Has thanked: 3 times
Been thanked: 4 times

Memory Error!

Unread post by taoism » 25 Feb 2015, 04:36

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

User avatar
DoCC
Contributor
Contributor
Posts: 210
Joined: 25 Feb 2014, 14:41
Has thanked: 39 times
Been thanked: 65 times

Re: Memory Error!

Unread post by DoCC » 01 Mar 2015, 02:40

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.

Post Reply