You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by "Rajat Khandelwal (JIRA)" <ji...@apache.org> on 2016/08/25 11:52:21 UTC
[jira] [Closed] (LENS-1221) Saved Query service is unable to
initialize
[ https://issues.apache.org/jira/browse/LENS-1221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rajat Khandelwal closed LENS-1221.
----------------------------------
> 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)