iceScrum | icescrum on ec2 tomcat7 connect to rds mysql5.6 – iceScrum

iceScrum Forums Discuss on iceScrum

Viewing 2 posts - 1 through 2 (of 2 total)

  • Author
    Posts
  • #10642

    Kagilum
    Keymaster

    Hi All,

    I have icescum working on the internal db, but I can not get it to work to a rds mysql 5.6 version.
    Any pointers would be great,
    thx
    Art

    The webapp seems to fail on an sql insert, catalina.out showing


    014-06-26 17:08:53,377 [localhost-startStop-1] ERROR context.ContextLoader - Context initialization failed
    org.springframework.beans.factory.access.BootstrapException: Error executing bootstraps; nested exception is org.springframework.dao.DataIntegrityViolationException: could not insert: [org.icescrum.core.domain.User]; SQL [insert into icescrum2_user (version, account_expired, account_external, account_locked, date_created, email, enabled, first_name, last_name, last_updated, passwd, password_expired, preferences_id, uid, username) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not insert: [org.icescrum.core.domain.User]
    at org.codehaus.groovy.grails.web.context.GrailsContextLoader.createWebApplicationContext(GrailsContextLoader.java:87)
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
    at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:983)
    at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1660)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:744)
    Caused by: org.springframework.dao.DataIntegrityViolationException: could not insert: [org.icescrum.core.domain.User]; SQL [insert into icescrum2_user (version, account_expired, account_external, account_locked, date_created, email, enabled, first_name, last_name, last_updated, passwd, password_expired, preferences_id, uid, username) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not insert: [org.icescrum.core.domain.User]
    at org.icescrum.core.security.AuthorityManager$__clinit__closure1.doCall(AuthorityManager.groovy:43)
    at org.icescrum.core.security.AuthorityManager$__clinit__closure2.doCall(AuthorityManager.groovy:58)
    at org.icescrum.core.services.BootStrapService.start(BootStrapService.groovy:45)
    at org.icescrum.core.services.BootStrapService$$FastClassByCGLIB$$79776cdd.invoke()
    at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
    at org.icescrum.core.services.BootStrapService$$EnhancerByCGLIB$$d4a9b368.start(
    )
    at org.icescrum.core.services.BootStrapService$start.call(Unknown Source)
    at IcescrumCoreGrailsPlugin$_closure4.doCall(IcescrumCoreGrailsPlugin.groovy:341)
    ... 5 more
    Caused by: org.hibernate.exception.DataException: could not insert: [org.icescrum.core.domain.User]
    at com.sun.proxy.$Proxy28.saveOrUpdate(Unknown Source)
    ... 13 more
    Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'date_created' at row 1
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2973)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
    at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1129)
    at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:681)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1368)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1283)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1268)
    ... 14 more
    #10887

    Nicolas Noullet
    Keymaster

    Hi

    That’s the first time I see this error.

    Could you provide your config.groovy (with obfuscated passwords)?

    What version of Tomcat and Java do you use?

Viewing 2 posts - 1 through 2 (of 2 total)

The forum ‘Installation’ is closed to new topics and replies.