Data too long for column 'artist' - MariaDB

[greatquux]

Hi - I've set up Subsonic 6.1 beta 2 with MariaDB and for a lot of things it's working great. However when scanning one of my folders, it appears there's something Subsonic doesn't like about one of the ID3 tags. I get up to a certain point then it stops with this error:

[2017-04-04 08:09:53,669] INFO MediaScannerService - Scanned media library with 7750 entries.
[2017-04-04 08:09:56,112] ERROR MediaScannerService - Failed to scan media library.
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 'artist' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'artist' at row 1
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:792)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:850)
at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:858)
at net.sourceforge.subsonic.dao.AbstractDao.update(AbstractDao.java:68)
at net.sourceforge.subsonic.dao.MediaFileDao.createOrUpdateMediaFile(MediaFileDao.java:165)
at net.sourceforge.subsonic.service.MediaFileService.updateChildren(MediaFileService.java:385)
at net.sourceforge.subsonic.service.MediaFileService.getChildrenOf(MediaFileService.java:183)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:219)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:223)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:223)
at net.sourceforge.subsonic.service.MediaScannerService.scanFile(MediaScannerService.java:223)
at net.sourceforge.subsonic.service.MediaScannerService.doScanLibrary(MediaScannerService.java:161)
at net.sourceforge.subsonic.service.MediaScannerService.access$000(MediaScannerService.java:31)
at net.sourceforge.subsonic.service.MediaScannerService$2.run(MediaScannerService.java:130)
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'artist' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3968)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2009)
at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5098)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1994)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:798)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
... 14 more


I'm not sure which file it is that is causing this error. But in any case, it's probably a good idea to check the length of the items before inserting them anyway, so I figured the developers may want to look at this first.

[greatquux]

I changed the artist column in media_file to varchar(512) instead of varchar(256), and now my scan has completed. Turns out one of my artists was 274 characters (from some random classical files with all the credits listed in the artist). This is an unusual situation, but would be good if Subsonic could have let me know which file was the issue (the log entry has ?? for the values).

[dkl]

Hello,

I know it's been a long time, but I'm facing the same issue.

Can anybody here explain me how I could to the same, i.e "change the artist column in media_file to varchar(512) instead of varchar(256)"?

media_file is a table created at subsonic initialization. Should I log into MYSQL and manually change the size of the artist file there?

Thanks in advance.

EDIT: found the solution.

Denis