Rundeck will not start - database errors?

[Nash Glover]

Hello,

I just upgraded Rundeck to 2.7.1. When restarting Rundeck, I was unable to access the web interface. I checked the service.log log file and found this:

2017-01-14 23:29:06.462:INFO:oejs.Server:main: jetty-9.0.7.v20131107
2017-01-14 23:29:08.917:INFO:oejw.StandardDescriptorProcessor:main: NO JSP Support for /, did not find org.apache.jasper.servlet.JspServlet
2017-01-14 23:29:09.908:INFO:/:main: Initializing Spring root WebApplicationContext
2017-01-14 23:29:23,926 [main] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table base_report add column failed_node_list varchar(255)
2017-01-14 23:29:23,927 [main] ERROR hbm2ddl.SchemaUpdate  - General error: "java.lang.IllegalArgumentException: timeNanos out of range 86400264000000"; SQL statement:
alter table base_report add column failed_node_list varchar(255) [50000-193]
2017-01-14 23:29:25,891 [main] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table base_report add column filter_applied varchar(255)
2017-01-14 23:29:25,892 [main] ERROR hbm2ddl.SchemaUpdate  - General error: "java.lang.IllegalArgumentException: timeNanos out of range 86400264000000"; SQL statement:
alter table base_report add column filter_applied varchar(255) [50000-193]
2017-01-14 23:29:27,752 [main] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table base_report add column succeeded_node_list varchar(255)
2017-01-14 23:29:27,752 [main] ERROR hbm2ddl.SchemaUpdate  - General error: "java.lang.IllegalArgumentException: timeNanos out of range 86400264000000"; SQL statement:
alter table base_report add column succeeded_node_list varchar(255) [50000-193]
2017-01-14 23:29:29,676 [main] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table execution add column execution_type varchar(30)
2017-01-14 23:29:29,676 [main] ERROR hbm2ddl.SchemaUpdate  - General error: "java.lang.IllegalArgumentException: timeNanos out of range 86400022000000"; SQL statement:
alter table execution add column execution_type varchar(30) [50000-193]
2017-01-14 23:29:31,504 [main] ERROR hbm2ddl.SchemaUpdate  - HHH000388: Unsuccessful: alter table execution add column node_filter_editable boolean
2017-01-14 23:29:31,504 [main] ERROR hbm2ddl.SchemaUpdate  - General error: "java.lang.IllegalArgumentException: timeNanos out of range 86400022000000"; SQL statement:
alter table execution add column node_filter_editable boolean [50000-193]




INFO  BootStrap: Starting Rundeck 2.7.1-1 (2016-12-03) ...
INFO  BootStrap: using rdeck.base config property: /var/lib/rundeck
INFO  BootStrap: loaded configuration: /etc/rundeck/framework.properties
INFO  BootStrap: RSS feeds disabled
INFO  BootStrap: Preauthentication is disabled
INFO  BootStrap: Rundeck is ACTIVE: executions can be run.
ERROR SqlExceptionHelper: General error: "java.lang.IllegalArgumentException: timeNanos out of range 86400022000000"; SQL statement:
select this_.id as y0_ from execution this_ where this_.date_started is not null and this_.date_completed is null and this_.server_nodeuuid is null and this_.date_started<? and (this_.status is null or this_.status<>?) [50000-193]
ERROR GrailsContextLoaderListener: Error initializing the application: could not extract ResultSet
org.hibernate.exception.GenericJDBCException: could not extract ResultSet
        at org.grails.datastore.gorm.GormStaticApi$_withCriteria_closure11.doCall(GormStaticApi.groovy:305)
        at org.grails.datastore.mapping.core.DatastoreUtils.execute(DatastoreUtils.java:302)
        at org.grails.datastore.gorm.AbstractDatastoreApi.execute(AbstractDatastoreApi.groovy:37)
        at org.grails.datastore.gorm.GormStaticApi.withCriteria(GormStaticApi.groovy:304)
        at rundeck.services.ExecutionService.cleanupRunningJobsAsync(ExecutionService.groovy:651)
        at rundeck.services.ExecutionService.cleanupRunningJobsAsync(ExecutionService.groovy:650)
        at BootStrap$_closure1.doCall(BootStrap.groovy:390)
        at grails.util.Environment.evaluateEnvironmentSpecificBlock(Environment.java:327)
        at grails.util.Environment.executeForEnvironment(Environment.java:320)
        at grails.util.Environment.executeForCurrentEnvironment(Environment.java:296)
        at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:788)
        at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:434)
        at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:780)
        at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:284)
        at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1322)
        at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:732)
        at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:490)
        at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:69)
        at org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:118)

There are a few more errors similar to this one. It seems that something got messed up during the upgrade. During the last update cycle, I had the error with the profile file not updating correctly and I had to copy the rpmnew file over. Not sure if that has anything to do with it.