Rundeck 1.1 upgrade error

[Anthony Shortland]

I just upgrade a 0.9 beta installation to Rundeck 1.1 and got the following error in the UI when logging in as the admin user:

"Attempt to insert null into a non-nullable column: column: AUTHORIZATION_ID table: USER in statement [insert into user (id, version, last_name, last_updated, filter_pref, password, email, date_created, login, dashboard_pref, first_name) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]"

... /var/log/rundeck/service.log reports:

ERROR JDBCExceptionReporter: Attempt to insert null into a non-nullable column: column: AUTHORIZATION_ID table: USER in statement [insert into user (id, version, last_name, last_updated, filter_pref, password, email, date_created, login, dashboard_pref, first_name) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]

ERROR GrailsExceptionResolver: could not insert: [User]; SQL [insert into user (id, version, last_name, last_updated, filter_pref, password, email, date_created, login, dashboard_pref, first_name) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [User]

org.springframework.dao.DataIntegrityViolationException: could not insert: [User]; SQL [insert into user (id, version, last_name, last_updated, filter_pref, password, email, date_created, login, dashboard_pref, first_name) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [User]

        at UserService.findOrCreateUser(UserService.groovy:11)

        at UserService$findOrCreateUser.callCurrent(Unknown Source)

        at UserService.getFilterPref(UserService.groovy:56)

        at UserService$$FastClassByCGLIB$$c7af504a.invoke(<generated>)

        at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)

        at UserService$$EnhancerByCGLIB$$2a46d1d0.getFilterPref(<generated>)

        at UserService$getFilterPref.call(Unknown Source)

        at ProjectSelectFilters$_closure1_closure2_closure3.doCall(ProjectSelectFilters.groovy:79)

        at ProjectSelectFilters$_closure1_closure2_closure3.doCall(ProjectSelectFilters.groovy)

Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [User]

        at $Proxy9.saveOrUpdate(Unknown Source)

        ... 9 more

Caused by: java.sql.SQLException: Attempt to insert null into a non-nullable column: column: AUTHORIZATION_ID table: USER in statement [insert into user (id, version, last_name, last_updated, filter_pref, password, email, date_created, login, dashboard_pref, first_name) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]

        at org.hsqldb.jdbc.Util.throwError(Unknown Source)

        at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)

        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)

        ... 10 more

Now this seems to be a installation problem driven from a non-backward compatible database schema. With this in mind, I decided "reinitialize" the database:

• Shutdown Rundeck:

[root@rundeck ~]# service rundeckd stop

Stopping rundeckd:                                         [  OK  ]

• Backed off the installation's database:

[root@rundeck etc]# mv /var/lib/rundeck/data /var/lib/rundeck/data.old

• Started Rundeck

[root@rundeck rundeck]# service rundeckd start

Starting rundeckd:                                         [  OK  ]

This cleared up the problem, if in a little extreme fashion!

Thanks,

Anthony.