Rajat Khandelwal created LENS-1221:
--------------------------------------
Summary: Saved Query service is unable to initialize
Key: LENS-1221
URL: https://issues.apache.org/jira/browse/LENS-1221
Project: Apache Lens
Issue Type: Task
Reporter: Rajat Khandelwal
Assignee: Rajat Khandelwal
{noformat}
19 Jul 2016 11:16:48 [d691692a-8ef7-4a34-b2b7-d555e89b0d18] [main] ERROR
org.apache.lens.server.LensServer - Error while creating Lens server
java.lang.RuntimeException: Cannot initialize saved query service
at
org.apache.lens.server.query.save.SavedQueryServiceImpl.init(SavedQueryServiceImpl.java:75)
~[classes/:na]
at
org.apache.hive.service.CompositeService.init(CompositeService.java:59)
~[hive-service-2.1.2-inm.jar:2.1.2-inm]
at org.apache.lens.server.LensServices.init(LensServices.java:252)
~[classes/:na]
at org.apache.lens.server.LensServer.startServices(LensServer.java:134)
~[classes/:na]
at org.apache.lens.server.LensServer.<init>(LensServer.java:85)
~[classes/:na]
at
org.apache.lens.server.LensServer.createLensServer(LensServer.java:74)
~[classes/:na]
at org.apache.lens.server.LensServer.main(LensServer.java:190)
~[classes/:na]
Caused by: org.apache.lens.server.api.error.LensException: Error initializing
saved query dao
at
org.apache.lens.server.query.save.SavedQueryDao.<init>(SavedQueryDao.java:72)
~[classes/:na]
at
org.apache.lens.server.query.save.SavedQueryServiceImpl.init(SavedQueryServiceImpl.java:70)
~[classes/:na]
... 6 common frames omitted
Caused by: org.apache.lens.server.api.error.LensException: Cannot create saved
query table!
at
org.apache.lens.server.query.save.SavedQueryDao.createSavedQueryTableIfNotExists(SavedQueryDao.java:85)
~[classes/:na]
at
org.apache.lens.server.query.save.SavedQueryDao.<init>(SavedQueryDao.java:70)
~[classes/:na]
... 7 common frames omitted
Caused by: java.sql.SQLException: Invalid default value for 'updated_at' Query:
CREATE TABLE IF NOT EXISTS saved_query (id int(11) NOT NULL AUTO_INCREMENT,name
varchar(255) NOT NULL,description varchar(255) DEFAULT NULL,query
longtext,params_json longtext,created_at timestamp,updated_at timestamp,
PRIMARY KEY (id)) Parameters: []
at
org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:363)
~[commons-dbutils-1.5.jar:1.5]
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:490)
~[commons-dbutils-1.5.jar:1.5]
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:420)
~[commons-dbutils-1.5.jar:1.5]
at
org.apache.lens.server.query.save.SavedQueryDao.createSavedQueryTableIfNotExists(SavedQueryDao.java:83)
~[classes/:na]
... 8 common frames omitted
19 Jul 2016 11:16:48 [d691692a-8ef7-4a34-b2b7-d555e89b0d18] [main] INFO
org.apache.lens.server.LensServices - Stopping lens server
19 Jul 2016 11:16:48 [d691692a-8ef7-4a34-b2b7-d555e89b0d18] [main] ERROR
org.apache.lens.server.LensServer - Error stopping services
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
