RegistrationLog to long

[Daniel Zoller]

#!

The following fields are to long (max. length):'
registrationLog (65535)]

        at org.bibsonomy.database.common.impl.DBSessionImpl.endTransaction(DBSessionImpl.java:164)
        at org.bibsonomy.database.managers.UserDatabaseManager.createUser(UserDatabaseManager.java:366)
        at org.bibsonomy.database.DBLogic.storeUser(DBLogic.java:1829)
        at org.bibsonomy.database.DBLogic.createUser(DBLogic.java:1719)
        at org.bibsonomy.webapp.controller.actions.UserRegistrationController.workOn(UserRegistrationController.java:257)
        at org.bibsonomy.webapp.controller.actions.UserRegistrationController.workOn(UserRegistrationController.java:67)
        at org.bibsonomy.webapp.util.spring.controller.MinimalisticControllerSpringWrapper.handleRequestInternal(MinimalisticControllerSpringWrapper.java:231)
        at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
        at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)

[Robert Jäschke]

Hhmm. Not so nice. We could change the column type (to MEDIUMTEXT) but on the long run it would be nice if we could automatically truncate data that is too long. Does iBatis support this?

[Daniel Zoller]

You can use MySQL's left(x, length) command (see logging module).

[Robert Jäschke]

changed column type to MEDIUMTEXT.

[Daniel Zoller]

#!

[2016-02-22 11:08:17,892] [ERROR] [org.bibsonomy.database.common.impl.DBSessionImpl] - Couldn't execute query 'insertPendingUser' - throwing RuntimeException
com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred while applying a parameter map.  
--- Check the insertPendingUser-InlineParameterMap.  
--- Check the statement (update failed).  
--- Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'reg_log' at row 1
com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred while applying a parameter map.  
--- Check the insertPendingUser-InlineParameterMap.  
--- Check the statement (update failed).  
--- Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'reg_log' at row 1

[Robert Jäschke]

fixes #2587 by limiting the length of reg_log to 1M characters

(should fit into MEDIUMTEXT, which is 2^24 bytes long)

→ <<cset 5f22782b86cf>>

[Daniel Zoller]

still not working :(

[Daniel Zoller]

we found the reason, the reg_log column in the table pending user was still text instead of longtext

thanks @thoni