[ https://issues.apache.org/jira/browse/LENS-1221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15391687#comment-15391687 ]
Hudson commented on LENS-1221: ------------------------------ UNSTABLE: Integrated in Lens-Commit #1300 (See [https://builds.apache.org/job/Lens-Commit/1300/]) LENS-1221: Saved Query service is unable to initialize (rajatgupta59: rev 3780744f87e89839d7d51ce069d5e84c66ca6740) * lens-server/src/main/java/org/apache/lens/server/query/save/SavedQueryDao.java > 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 > Fix For: 2.6 > > Attachments: LENS-1221.2016-07-19_17:00:08.patch, > LENS-1221.2016-07-19_17:05:29.patch > > > {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)