ERROR MediaScannerService - Failed to scan media library.

Need help? Post your questions here.

Moderator: moderators

ERROR MediaScannerService - Failed to scan media library.

Postby Anjin » Tue Feb 18, 2020 7:47 pm

Subsonic 6.1.6 (build 0cfa60) – November 10, 2019
Running with MySQL as a db.

org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [insert into media_file (id, path, folder, type, format, title, album, artist, album_artist, disc_number, track_number, year, genre, 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, children_last_updated, present, version) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; Data truncation: Data too long for column 'genre' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'genre' at row 1

Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'genre' at row 1

I looked through the MySQL table, and see it well populated. I am not sure where the fail was, or what file was being processed. I did a walk of the media being scanned and checked genre tags and found nothing untold. Seems 'genre' is 64 chars, and nothing in the entire library meets that.

Thanks in advance.
Anjin
 
Posts: 1
Joined: Tue Feb 18, 2020 7:37 pm

Return to Help

Who is online

Users browsing this forum: Bing [Bot], Majestic-12 [Bot] and 12 guests