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:
... /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: