8LJReYZV

1[snappydata@s-dcr-hdp-sl1 ~]$ /usr/snappydata/services/pecom-snappy-migration/start.sh
2[2018-08-21 16:26:12] [INFO] Start script.
3[2018-08-21 16:26:12] [INFO] Start migrator.
4[INFO] [08/21/2018 16:26:17.254] [main] Migrator$ - Run configuration: MigratorConfig(slickSnappy,Set(APP, SS),90 minutes)
5[WARN] [08/21/2018 16:26:17.629] [main] DatabaseConfig - Use `slickSnappy.profile` instead of `slickSnappy.driver`. The latter is deprecated since Slick 3.2 and will be removed.
6[INFO] [08/21/2018 16:26:17.806] [main] HikariDataSource - slickSnappy.db - Started.
7[INFO] [08/21/2018 16:26:18.013] [main] Migrator$ - Migrator started
8[INFO] [08/21/2018 16:26:18.271] [main] SnappyMigrator - Found 45 migrations:
9V1    | CREATE TABLE APP.ACCEPTANCE_DEPARTMENT ( DEPARTMENT_ACCEPTOR_GUID VARCHAR(36) NOT NULL, DEPARTMEN... | InitMigraion
10V2    | ALTER TABLE APP.ROUTE_BALANCE ADD COLUMN IS_FACT INTEGER;                                            | AddIsFact
11V3    | ALTER TABLE SS.CARGO_BALANCE_DIRECTION ADD COLUMN IS_FACT INTEGER; ALTER TABLE SS.CARGO_BALANCE A... | AddIsFactCargoBalance
12V4    | ALTER TABLE APP.TASK_WORK_ROUTE ADD COLUMN FIX_DATE_PLAN_SHIPMENT SMALLINT;                          | AddFixDatePlanShipmentTwr
13V5    | ALTER TABLE APP.ROUTE_TEAM_WORK_FACTS ADD COLUMN COEFFICIENT DECIMAL(8,4); ALTER TABLE APP.ROUTE_... | RouteTeamWorkFactsAddCoefficient
14 ... <skipped> ...
15V51   | ALTER TABLE APP.DICT_ROUTE_WAY ADD COLUMN DELETED INTEGER; ALTER TABLE APP.DICT_ROUTE_WAY ADD COL... | AddDeletedToDictRouteWay
16V50   | CREATE TABLE APP.DICT_ROUTE_WAY_KIND ( ROUTE_WAY_GUID VARCHAR(36) NOT NULL, ROUTE_WAY_KIND_GUID V... | AddDictRouteWayKind
17V47   | DROP TABLE IF EXISTS APP.WAREHOUSE_SPEC_TEMP;  CREATE TABLE APP.WAREHOUSE_SPEC_TEMP( ROUTE_TEAM_T... | WarehouseSpecShrinkPrimaryKey
18V46   | CREATE INDEX SS.IDX_DEP_HOUR_DIRECTION ON SS.CARGO_BALANCE_DIRECTION(DEPARTMENT_GUID, BALANCE_HOU... | AddCargoBalanceDirectionIndex
19V45   | CREATE TABLE APP.USER_DEPARTMENTS ( USER_GUID VARCHAR(36) NOT NULL, USER_NAME VARCHAR(50) NOT NUL... | CreateUserDepartments
20Aug 21, 2018 4:26:20 PM java.util.logging.LogManager$RootLogger log
21INFO: Starting client on 's-dcr-hdp-sl1.pecom.local' with ID='12459|2018/08/21 16:26:20.823 MSK' Source-Revision=bea52fb377f4b8ca1794f5aa083eb3dc01dfd9e1
22[INFO] [08/21/2018 16:26:21.996] [slickSnappy.db-3] SnappyMigrator - Migration table APP.APPLIED_MIGRATION is absent, going to create it
23[INFO] [08/21/2018 16:26:22.011] [slickSnappy.db-4] SnappyMigrator - Executing create table statement:
24          CREATE TABLE "APP"."APPLIED_MIGRATION"(
25           "ID" INTEGER NOT NULL PRIMARY KEY,
26           "QUERY" VARCHAR(512) NOT NULL,
27           "APPLY_DATE" TIMESTAMP NOT NULL ,
28           "COMMENT" VARCHAR(512) NOT NULL
29          ) PERSISTENT ASYNCHRONOUS;
30
31[INFO] [08/21/2018 16:26:29.068] [slickSnappy.db-8] SnappyMigrator - 45 unapplied migrations were found:
32V1    | CREATE TABLE APP.ACCEPTANCE_DEPARTMENT ( DEPARTMENT_ACCEPTOR_GUID VARCHAR(36) NOT NULL, DEPARTMEN... | InitMigraion
33V2    | ALTER TABLE APP.ROUTE_BALANCE ADD COLUMN IS_FACT INTEGER;                                            | AddIsFact
34V3    | ALTER TABLE SS.CARGO_BALANCE_DIRECTION ADD COLUMN IS_FACT INTEGER; ALTER TABLE SS.CARGO_BALANCE A... | AddIsFactCargoBalance
35V4    | ALTER TABLE APP.TASK_WORK_ROUTE ADD COLUMN FIX_DATE_PLAN_SHIPMENT SMALLINT;                          | AddFixDatePlanShipmentTwr
36V5    | ALTER TABLE APP.ROUTE_TEAM_WORK_FACTS ADD COLUMN COEFFICIENT DECIMAL(8,4); ALTER TABLE APP.ROUTE_... | RouteTeamWorkFactsAddCoefficient
37V6    | ALTER TABLE "APP"."TASK_WORK_ROUTE" ADD COLUMN DATE_PLAN_UNLOAD TIMESTAMP; ALTER TABLE "APP"."TAS... | AddTwrDates
38V7    | ALTER TABLE APP.RULE_DRAFT_ROUTE ADD COLUMN DATE_CREATE TIMESTAMP; ALTER TABLE APP.RULE_DRAFT_ROU... | RuleChange
39V8    | UPDATE APP.RULE_DRAFT_ROUTE SET DATE_CREATE = DATE_START; UPDATE APP.RULE_DRAFT_ROUTE_PARAM rdrp ... | RuleChangeUpdate
40V9    | CREATE TABLE APP.DICT_ROUTE_TEAM_TASK_RESULT ( WORK_TYPE_TASK_GUID VARCHAR(36) NOT NULL, WORK_TYP... | DictRouteTeamTaskResultCreate
41V10   | ALTER TABLE APP.ROUTE ADD COLUMN ROUTE_CODE_DATE TIMESTAMP;                                          | AddRouteCodeDateToRoute
42V11   | ALTER TABLE APP.DICT_ROUTE_WAY ADD COLUMN ROUTE_WAY_TYPE VARCHAR(36); ALTER TABLE APP.DICT_PEC AD... | DictRouteWayAddRouteWayType
43V12   | UPDATE app.dict_route_way SET route_way_type = '6193de5b-405a-426f-809a-4103f9e264db';               | DictRouteWayUpdateRouteWayType
44V14   | ALTER TABLE APP.ROUTE_TEAM_WORK_FACTS ADD COLUMN CREATE_TIMESTAMP TIMESTAMP;                         | RouteTeamWorkFactsAddCreateTimestamp
45V15   | DROP TABLE IF EXISTS APP.ROUTE_TEAM_WORK_FACTS_TEMP;  CREATE TABLE APP.ROUTE_TEAM_WORK_FACTS_TEMP... | RouteTeamWorkFactsAlterCommentFirst
46V16   | ALTER TABLE APP.ROUTE_TEAM_WORK ADD COLUMN COMMENT VARCHAR(1000);                                    | RouteTeamWorkAddComment
47V17   | ALTER TABLE APP.ROUTE_TEAM_WORK ADD COLUMN ROUTE_TEAM_TYPE_GUID VARCHAR(36); ALTER TABLE APP.ROUT... | RouteTeamWorkAddRouteTeamInfo
48V19   | DROP TABLE IF EXISTS APP.WAREHOUSE_SPEC_TEMP;  CREATE TABLE APP.WAREHOUSE_SPEC_TEMP ( ROUTE_TEAM_... | WarehouseSpecAlterDecimals
49V20   | ALTER TABLE APP.ROUTE_TEAM_WORK ADD COLUMN ROUTE_TEAM_FLAG_EXCEPTED INTEGER;                         | RouteTeamWorkAddRouteTeamFlagExcepted
50V21   | ALTER TABLE APP.ROUTE_TEAM ADD COLUMN ROUTE_TEAM_VERSION INTEGER; ALTER TABLE APP.ROUTE_TEAM ADD ... | RouteTeamAddVersionInfo
51V23   | CREATE INDEX SS.XAK3_SS_CARGO_BALANCE ON SS.CARGO_BALANCE (DEPARTMENT_GUID, DIRECTION_GUID, BALAN... | AddIndexes
52V24   | ALTER TABLE APP.PEC ADD COLUMN TIMETABLE_DIRECTION_GUID VARCHAR(36); ALTER TABLE APP.PEC ADD COLU... | AddTimetableDirectionGuidTimetableDirectionDate
53V25   | CREATE TABLE APP.TIMETABLE_DIRECTION ( TIMETABLE_GUID VARCHAR(36) NOT NULL, DEPARTMENT_GUID VARCH... | CreateTimeTableTables
54V26   | CREATE INDEX APP.XAK1_APP_DICT_ROUTE_OWNER ON APP.DICT_ROUTE_OWNER (ROUTE_WAY_START, ROUTE_WAY_EN... | AddIndexDictRouteOwner
55V28   | INSERT INTO APP.SETTINGS (SETTING_NAME,SETTING_VALUE) VALUES ('TIMETABLE_SEARCH_ROUTE_HOURS_BEFOR... | AddTimetableRouteTimeRangeSetting
56V29   | ALTER TABLE APP.TIMETABLE_DIRECTION_PARAM ADD COLUMN DAY_WEEK_START INTEGER; ALTER TABLE APP.TIME... | AlterTimetableDirectionParam
57V30   | CREATE INDEX APP.XAK4_APP_PEC ON APP.PEC (DEPARTMENT_GUID_RECIPIENT, DEPARTMENT_GUID_DIRECTION,PE... | AddIndexesPec
58V31   | CREATE TABLE APP.RULE_ALERT ( ALERT_GUID VARCHAR(36) NOT NULL, RULE_GUID VARCHAR(36) NOT NULL, RU... | CreateRuleAlertTable
59V32   | CREATE TABLE APP.DICT_ROUTE_WAY_DIRECTION ( ROUTE_WAY_GUID VARCHAR(36) NOT NULL, ROUTE_WAY_TYPE V... | DictRouteWayDirectionCreate
60V33   | ALTER TABLE APP.TIMETABLE_DIRECTION_PARAM ADD COLUMN DAY_WEEK_NEXT_ARRIVAL INTEGER; ALTER TABLE A... | AlterTimetableDirectionParam
61V34   | UPDATE app.TIMETABLE_DIRECTION_PARAM SET HOUR_NEXT_ARRIVAL = HOUR_END + 1, DAY_WEEK_NEXT_ARRIVAL ... | UpdateTimetableDirectionParam
62V35   | ALTER TABLE APP.PRIORITY_ROUTEWAY ADD COLUMN ROUTE_CREATE_HOUR_OFFSET INTEGER DEFAULT 12;            | PriorityRoutewayAddRouteCreateDelay
63V36   | CREATE TABLE APP.ROUTE_STOPPER ( ROUTE_STOPPER_GUID VARCHAR(36) NOT NULL CONSTRAINT ROUTE_STOPPER... | AddRouteStopper
64V37   | DROP INDEX IF EXISTS APP.RULE_ALERT_RULE_INDEX; DROP TABLE IF EXISTS APP.RULE_ALERT;  CREATE TABL... | AddRuleAlertDepartureEnd
65V38   | CREATE INDEX XAK2_APP_DICT_ROUTE_OWNER ON "APP"."DICT_ROUTE_OWNER"(ROUTE_OWNER_ID);                  | DictRouteOwnerAddIndexRouteOwnerId
66V39   | CREATE INDEX APP.X_ROUTE_STOPPER_DEPARTMENT ON APP.ROUTE_STOPPER (ROUTE_GUID, DEPARTMENT_GUID);      | AddIndexByDepartmentRouteStopper
67V40   | ALTER TABLE APP.DICT_DIRECTION ADD COLUMN WAREHOUSE_GUID VARCHAR(36);                                | DictDepartmentAddWarehouseGuid
68V41   | CREATE TABLE APP.DICT_WAREHOUSE_DIRECTION ( DIRECTION_GUID varchar(36) NOT NULL, DEPARTMENT_DIREC... | CreateDictWarehouseDirection
69V42   | CREATE TABLE APP.DICT_ROUTE_OWNER_NAMES ( ROUTE_OWNER_ID VARCHAR(50), ROUTE_OWNER_NAME VARCHAR(50... | CreateDictRouteOwnerNames
70V43   | DROP TABLE IF EXISTS APP.DICT_CELLULAR;  CREATE TABLE APP.DICT_CELLULAR ( CELLULAR_GUID varchar(3... | RecreateDictCellular
71V44   | INSERT INTO APP.SETTINGS (SETTING_NAME, SETTING_VALUE) VALUES ('MIN_VOLUME_ACCUM', '0.9');           | AddMinVolumeAccumSetting
72V45   | CREATE TABLE APP.USER_DEPARTMENTS ( USER_GUID VARCHAR(36) NOT NULL, USER_NAME VARCHAR(50) NOT NUL... | CreateUserDepartments
73V46   | CREATE INDEX SS.IDX_DEP_HOUR_DIRECTION ON SS.CARGO_BALANCE_DIRECTION(DEPARTMENT_GUID, BALANCE_HOU... | AddCargoBalanceDirectionIndex
74V47   | DROP TABLE IF EXISTS APP.WAREHOUSE_SPEC_TEMP;  CREATE TABLE APP.WAREHOUSE_SPEC_TEMP( ROUTE_TEAM_T... | WarehouseSpecShrinkPrimaryKey
75V50   | CREATE TABLE APP.DICT_ROUTE_WAY_KIND ( ROUTE_WAY_GUID VARCHAR(36) NOT NULL, ROUTE_WAY_KIND_GUID V... | AddDictRouteWayKind
76V51   | ALTER TABLE APP.DICT_ROUTE_WAY ADD COLUMN DELETED INTEGER; ALTER TABLE APP.DICT_ROUTE_WAY ADD COL... | AddDeletedToDictRouteWay
77[INFO] [08/21/2018 16:26:29.069] [slickSnappy.db-8] SnappyMigrator - Start applying migrations ...
78[INFO] [08/21/2018 16:26:44.879] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V1    | CREATE TABLE APP.ACCEPTANCE_DEPARTMENT ( DEPARTMENT_ACCEPTOR_GUID VARCHAR(36) NOT NULL, DEPARTMEN... | InitMigraion
79[INFO] [08/21/2018 16:26:45.011] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V2    | ALTER TABLE APP.ROUTE_BALANCE ADD COLUMN IS_FACT INTEGER;                                            | AddIsFact
80[INFO] [08/21/2018 16:26:45.278] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V3    | ALTER TABLE SS.CARGO_BALANCE_DIRECTION ADD COLUMN IS_FACT INTEGER; ALTER TABLE SS.CARGO_BALANCE A... | AddIsFactCargoBalance
81[INFO] [08/21/2018 16:26:45.461] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V4    | ALTER TABLE APP.TASK_WORK_ROUTE ADD COLUMN FIX_DATE_PLAN_SHIPMENT SMALLINT;                          | AddFixDatePlanShipmentTwr
82[INFO] [08/21/2018 16:26:46.062] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V5    | ALTER TABLE APP.ROUTE_TEAM_WORK_FACTS ADD COLUMN COEFFICIENT DECIMAL(8,4); ALTER TABLE APP.ROUTE_... | RouteTeamWorkFactsAddCoefficient
83[INFO] [08/21/2018 16:26:46.608] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V6    | ALTER TABLE "APP"."TASK_WORK_ROUTE" ADD COLUMN DATE_PLAN_UNLOAD TIMESTAMP; ALTER TABLE "APP"."TAS... | AddTwrDates
84[INFO] [08/21/2018 16:26:46.950] [slickSnappy.db-3] SnappyMigrator - Migration was applied: V7    | ALTER TABLE APP.RULE_DRAFT_ROUTE ADD COLUMN DATE_CREATE TIMESTAMP; ALTER TABLE APP.RULE_DRAFT_ROU... | RuleChange
85[INFO] [08/21/2018 16:26:47.001] [slickSnappy.db-3] SnappyMigrator - Migration was applied: V8    | UPDATE APP.RULE_DRAFT_ROUTE SET DATE_CREATE = DATE_START; UPDATE APP.RULE_DRAFT_ROUTE_PARAM rdrp ... | RuleChangeUpdate
86[INFO] [08/21/2018 16:26:47.092] [slickSnappy.db-7] SnappyMigrator - Migration was applied: V9    | CREATE TABLE APP.DICT_ROUTE_TEAM_TASK_RESULT ( WORK_TYPE_TASK_GUID VARCHAR(36) NOT NULL, WORK_TYP... | DictRouteTeamTaskResultCreate
87[INFO] [08/21/2018 16:26:47.190] [slickSnappy.db-7] SnappyMigrator - Migration was applied: V10   | ALTER TABLE APP.ROUTE ADD COLUMN ROUTE_CODE_DATE TIMESTAMP;                                          | AddRouteCodeDateToRoute
88[INFO] [08/21/2018 16:26:47.570] [slickSnappy.db-2] SnappyMigrator - Migration was applied: V11   | ALTER TABLE APP.DICT_ROUTE_WAY ADD COLUMN ROUTE_WAY_TYPE VARCHAR(36); ALTER TABLE APP.DICT_PEC AD... | DictRouteWayAddRouteWayType
89[INFO] [08/21/2018 16:26:47.581] [slickSnappy.db-5] SnappyMigrator - Migration was applied: V12   | UPDATE app.dict_route_way SET route_way_type = '6193de5b-405a-426f-809a-4103f9e264db';               | DictRouteWayUpdateRouteWayType
90[INFO] [08/21/2018 16:26:47.664] [slickSnappy.db-5] SnappyMigrator - Migration was applied: V14   | ALTER TABLE APP.ROUTE_TEAM_WORK_FACTS ADD COLUMN CREATE_TIMESTAMP TIMESTAMP;                         | RouteTeamWorkFactsAddCreateTimestamp
91[INFO] [08/21/2018 16:26:52.119] [slickSnappy.db-5] SnappyMigrator - Migration was applied: V15   | DROP TABLE IF EXISTS APP.ROUTE_TEAM_WORK_FACTS_TEMP;  CREATE TABLE APP.ROUTE_TEAM_WORK_FACTS_TEMP... | RouteTeamWorkFactsAlterCommentFirst
92[INFO] [08/21/2018 16:26:52.255] [slickSnappy.db-1] SnappyMigrator - Migration was applied: V16   | ALTER TABLE APP.ROUTE_TEAM_WORK ADD COLUMN COMMENT VARCHAR(1000);                                    | RouteTeamWorkAddComment
93[INFO] [08/21/2018 16:26:52.603] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V17   | ALTER TABLE APP.ROUTE_TEAM_WORK ADD COLUMN ROUTE_TEAM_TYPE_GUID VARCHAR(36); ALTER TABLE APP.ROUT... | RouteTeamWorkAddRouteTeamInfo
94[INFO] [08/21/2018 16:26:53.455] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V19   | DROP TABLE IF EXISTS APP.WAREHOUSE_SPEC_TEMP;  CREATE TABLE APP.WAREHOUSE_SPEC_TEMP ( ROUTE_TEAM_... | WarehouseSpecAlterDecimals
95[INFO] [08/21/2018 16:26:53.545] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V20   | ALTER TABLE APP.ROUTE_TEAM_WORK ADD COLUMN ROUTE_TEAM_FLAG_EXCEPTED INTEGER;                         | RouteTeamWorkAddRouteTeamFlagExcepted
96[INFO] [08/21/2018 16:26:53.803] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V21   | ALTER TABLE APP.ROUTE_TEAM ADD COLUMN ROUTE_TEAM_VERSION INTEGER; ALTER TABLE APP.ROUTE_TEAM ADD ... | RouteTeamAddVersionInfo
97[INFO] [08/21/2018 16:26:54.246] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V23   | CREATE INDEX SS.XAK3_SS_CARGO_BALANCE ON SS.CARGO_BALANCE (DEPARTMENT_GUID, DIRECTION_GUID, BALAN... | AddIndexes
98[INFO] [08/21/2018 16:26:54.404] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V24   | ALTER TABLE APP.PEC ADD COLUMN TIMETABLE_DIRECTION_GUID VARCHAR(36); ALTER TABLE APP.PEC ADD COLU... | AddTimetableDirectionGuidTimetableDirectionDate
99[INFO] [08/21/2018 16:26:54.580] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V25   | CREATE TABLE APP.TIMETABLE_DIRECTION ( TIMETABLE_GUID VARCHAR(36) NOT NULL, DEPARTMENT_GUID VARCH... | CreateTimeTableTables
100[INFO] [08/21/2018 16:26:54.951] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V26   | CREATE INDEX APP.XAK1_APP_DICT_ROUTE_OWNER ON APP.DICT_ROUTE_OWNER (ROUTE_WAY_START, ROUTE_WAY_EN... | AddIndexDictRouteOwner
101[INFO] [08/21/2018 16:26:55.019] [slickSnappy.db-5] SnappyMigrator - Migration was applied: V28   | INSERT INTO APP.SETTINGS (SETTING_NAME,SETTING_VALUE) VALUES ('TIMETABLE_SEARCH_ROUTE_HOURS_BEFOR... | AddTimetableRouteTimeRangeSetting
102[INFO] [08/21/2018 16:26:55.262] [slickSnappy.db-1] SnappyMigrator - Migration was applied: V29   | ALTER TABLE APP.TIMETABLE_DIRECTION_PARAM ADD COLUMN DAY_WEEK_START INTEGER; ALTER TABLE APP.TIME... | AlterTimetableDirectionParam
103[INFO] [08/21/2018 16:26:55.573] [slickSnappy.db-4] SnappyMigrator - Migration was applied: V30   | CREATE INDEX APP.XAK4_APP_PEC ON APP.PEC (DEPARTMENT_GUID_RECIPIENT, DEPARTMENT_GUID_DIRECTION,PE... | AddIndexesPec
104[INFO] [08/21/2018 16:26:56.019] [slickSnappy.db-4] SnappyMigrator - Migration was applied: V31   | CREATE TABLE APP.RULE_ALERT ( ALERT_GUID VARCHAR(36) NOT NULL, RULE_GUID VARCHAR(36) NOT NULL, RU... | CreateRuleAlertTable
105[INFO] [08/21/2018 16:26:56.434] [slickSnappy.db-9] SnappyMigrator - Migration was applied: V32   | CREATE TABLE APP.DICT_ROUTE_WAY_DIRECTION ( ROUTE_WAY_GUID VARCHAR(36) NOT NULL, ROUTE_WAY_TYPE V... | DictRouteWayDirectionCreate
106[INFO] [08/21/2018 16:26:56.595] [slickSnappy.db-9] SnappyMigrator - Migration was applied: V33   | ALTER TABLE APP.TIMETABLE_DIRECTION_PARAM ADD COLUMN DAY_WEEK_NEXT_ARRIVAL INTEGER; ALTER TABLE A... | AlterTimetableDirectionParam
107[INFO] [08/21/2018 16:26:56.609] [slickSnappy.db-9] SnappyMigrator - Migration was applied: V34   | UPDATE app.TIMETABLE_DIRECTION_PARAM SET HOUR_NEXT_ARRIVAL = HOUR_END + 1, DAY_WEEK_NEXT_ARRIVAL ... | UpdateTimetableDirectionParam
108[INFO] [08/21/2018 16:26:56.696] [slickSnappy.db-9] SnappyMigrator - Migration was applied: V35   | ALTER TABLE APP.PRIORITY_ROUTEWAY ADD COLUMN ROUTE_CREATE_HOUR_OFFSET INTEGER DEFAULT 12;            | PriorityRoutewayAddRouteCreateDelay
109[INFO] [08/21/2018 16:26:57.130] [slickSnappy.db-9] SnappyMigrator - Migration was applied: V36   | CREATE TABLE APP.ROUTE_STOPPER ( ROUTE_STOPPER_GUID VARCHAR(36) NOT NULL CONSTRAINT ROUTE_STOPPER... | AddRouteStopper
110[INFO] [08/21/2018 16:26:57.967] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V37   | DROP INDEX IF EXISTS APP.RULE_ALERT_RULE_INDEX; DROP TABLE IF EXISTS APP.RULE_ALERT;  CREATE TABL... | AddRuleAlertDepartureEnd
111[INFO] [08/21/2018 16:26:58.257] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V38   | CREATE INDEX XAK2_APP_DICT_ROUTE_OWNER ON "APP"."DICT_ROUTE_OWNER"(ROUTE_OWNER_ID);                  | DictRouteOwnerAddIndexRouteOwnerId
112[INFO] [08/21/2018 16:26:58.543] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V39   | CREATE INDEX APP.X_ROUTE_STOPPER_DEPARTMENT ON APP.ROUTE_STOPPER (ROUTE_GUID, DEPARTMENT_GUID);      | AddIndexByDepartmentRouteStopper
113[INFO] [08/21/2018 16:26:58.686] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V40   | ALTER TABLE APP.DICT_DIRECTION ADD COLUMN WAREHOUSE_GUID VARCHAR(36);                                | DictDepartmentAddWarehouseGuid
114[INFO] [08/21/2018 16:26:59.135] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V41   | CREATE TABLE APP.DICT_WAREHOUSE_DIRECTION ( DIRECTION_GUID varchar(36) NOT NULL, DEPARTMENT_DIREC... | CreateDictWarehouseDirection
115[INFO] [08/21/2018 16:26:59.575] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V42   | CREATE TABLE APP.DICT_ROUTE_OWNER_NAMES ( ROUTE_OWNER_ID VARCHAR(50), ROUTE_OWNER_NAME VARCHAR(50... | CreateDictRouteOwnerNames
116[INFO] [08/21/2018 16:27:00.417] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V43   | DROP TABLE IF EXISTS APP.DICT_CELLULAR;  CREATE TABLE APP.DICT_CELLULAR ( CELLULAR_GUID varchar(3... | RecreateDictCellular
117[INFO] [08/21/2018 16:27:00.427] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V44   | INSERT INTO APP.SETTINGS (SETTING_NAME, SETTING_VALUE) VALUES ('MIN_VOLUME_ACCUM', '0.9');           | AddMinVolumeAccumSetting
118[INFO] [08/21/2018 16:27:00.517] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V45   | CREATE TABLE APP.USER_DEPARTMENTS ( USER_GUID VARCHAR(36) NOT NULL, USER_NAME VARCHAR(50) NOT NUL... | CreateUserDepartments
119[INFO] [08/21/2018 16:27:00.842] [slickSnappy.db-10] SnappyMigrator - Migration was applied: V46   | CREATE INDEX SS.IDX_DEP_HOUR_DIRECTION ON SS.CARGO_BALANCE_DIRECTION(DEPARTMENT_GUID, BALANCE_HOU... | AddCargoBalanceDirectionIndex
120[ERROR] [08/21/2018 16:32:01.385] [slickSnappy.db-10] SnappyMigrator - Migration failed (in case of on non-transactional DDL it might need manual repair!): V47   | DROP TABLE IF EXISTS APP.WAREHOUSE_SPEC_TEMP;  CREATE TABLE APP.WAREHOUSE_SPEC_TEMP( ROUTE_TEAM_T... | WarehouseSpecShrinkPrimaryKey
121java.lang.IllegalStateException: Migration 47 failed. Couldn't execute statement in script at position 29.64 SQL:
122DROP TABLE IF EXISTS APP.WAREHOUSE_SPEC
123        at ru.neoflex.pecom.slick.migration.manager.MigrationManager$$anonfun$ru$neoflex$pecom$slick$migration$manager$MigrationManager$$migrationToDbio$1.apply(MigrationManager.scala:102)
124        at ru.neoflex.pecom.slick.migration.manager.MigrationManager$$anonfun$ru$neoflex$pecom$slick$migration$manager$MigrationManager$$migrationToDbio$1.apply(MigrationManager.scala:96)
125        at slick.jdbc.SimpleJdbcAction.run(StreamingInvokerAction.scala:70)
126        at slick.jdbc.SimpleJdbcAction.run(StreamingInvokerAction.scala:69)
127        at slick.dbio.DBIOAction$$anon$4$$anonfun$run$3.apply(DBIOAction.scala:240)
128        at slick.dbio.DBIOAction$$anon$4$$anonfun$run$3.apply(DBIOAction.scala:240)
129        at scala.collection.Iterator$class.foreach(Iterator.scala:891)
130        at scala.collection.AbstractIterator.foreach(Iterator.scala:1334)
131        at scala.collection.IterableLike$class.foreach(IterableLike.scala:72)
132        at scala.collection.AbstractIterable.foreach(Iterable.scala:54)
133        at slick.dbio.DBIOAction$$anon$4.run(DBIOAction.scala:240)
134        at slick.dbio.DBIOAction$$anon$4.run(DBIOAction.scala:238)
135        at slick.dbio.SynchronousDatabaseAction$FusedAndThenAction$$anonfun$run$4.apply(DBIOAction.scala:534)
136        at slick.dbio.SynchronousDatabaseAction$FusedAndThenAction$$anonfun$run$4.apply(DBIOAction.scala:534)
137        at scala.collection.Iterator$class.foreach(Iterator.scala:891)
138        at scala.collection.AbstractIterator.foreach(Iterator.scala:1334)
139        at scala.collection.IterableLike$class.foreach(IterableLike.scala:72)
140        at scala.collection.AbstractIterable.foreach(Iterable.scala:54)
141        at slick.dbio.SynchronousDatabaseAction$FusedAndThenAction.run(DBIOAction.scala:534)
142        at slick.dbio.SynchronousDatabaseAction$$anon$11.run(DBIOAction.scala:571)
143        at slick.dbio.SynchronousDatabaseAction$$anon$6.run(DBIOAction.scala:470)
144        at slick.dbio.SynchronousDatabaseAction$$anon$10.run(DBIOAction.scala:562)
145        at slick.dbio.SynchronousDatabaseAction$$anon$7.run(DBIOAction.scala:487)
146        at slick.basic.BasicBackend$DatabaseDef$$anon$2.liftedTree1$1(BasicBackend.scala:240)
147        at slick.basic.BasicBackend$DatabaseDef$$anon$2.run(BasicBackend.scala:240)
148        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
149        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
150        at java.lang.Thread.run(Thread.java:748)
151Caused by: java.sql.SQLException: (SQLState=40XL1 Severity=30000) (Server=s-dcr-hdp-sl2.pecom.local/10.255.2.16[1529] Thread=pool-3-thread-3) A lock could not be obtained within the time requested
152        at io.snappydata.thrift.SnappyDataService$executePrepared_result$executePrepared_resultStandardScheme.read(SnappyDataService.java:12075)
153        at io.snappydata.thrift.SnappyDataService$executePrepared_result$executePrepared_resultStandardScheme.read(SnappyDataService.java:12052)
154        at io.snappydata.thrift.SnappyDataService$executePrepared_result.read(SnappyDataService.java:11991)
155        at io.snappydata.org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:86)
156        at io.snappydata.thrift.SnappyDataService$Client.recv_executePrepared(SnappyDataService.java:374)
157        at io.snappydata.thrift.SnappyDataService$Client.executePrepared(SnappyDataService.java:357)
158        at io.snappydata.thrift.internal.ClientService.executePrepared(ClientService.java:1051)
159        at io.snappydata.thrift.internal.ClientPreparedStatement.execute(ClientPreparedStatement.java:201)
160        at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
161        at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
162        at ru.neoflex.pecom.slick.migration.manager.MigrationManager$$anonfun$ru$neoflex$pecom$slick$migration$manager$MigrationManager$$migrationToDbio$1$$anonfun$1.apply$mcZ$sp(MigrationManager.scala:99)
163        at ru.neoflex.pecom.slick.migration.manager.MigrationManager$$anonfun$ru$neoflex$pecom$slick$migration$manager$MigrationManager$$migrationToDbio$1$$anonfun$1.apply(MigrationManager.scala:97)
164        at ru.neoflex.pecom.slick.migration.manager.MigrationManager$$anonfun$ru$neoflex$pecom$slick$migration$manager$MigrationManager$$migrationToDbio$1$$anonfun$1.apply(MigrationManager.scala:97)
165        at scala.util.Try$.apply(Try.scala:192)
166        at ru.neoflex.pecom.slick.migration.manager.MigrationManager$$anonfun$ru$neoflex$pecom$slick$migration$manager$MigrationManager$$migrationToDbio$1.apply(MigrationManager.scala:97)
167        ... 27 more
168Caused by: java.rmi.ServerException: Server STACK: java.sql.SQLTransactionRollbackException(40XL1): A lock could not be obtained within the time requested
169        at com.pivotal.gemfirexd.internal.iapi.error.StandardException.newPreLocalizedException(StandardException.java:614)
170        at com.pivotal.gemfirexd.internal.engine.Misc.wrapSQLException(Misc.java:1062)
171        at com.pivotal.gemfirexd.internal.engine.Misc.wrapRemoteSQLException(Misc.java:1039)
172        at com.pivotal.gemfirexd.internal.engine.Misc.processFunctionException(Misc.java:767)
173        at com.pivotal.gemfirexd.internal.engine.Misc.processFunctionException(Misc.java:753)
174        at com.pivotal.gemfirexd.internal.engine.sql.execute.SnappySelectResultSet.setup(SnappySelectResultSet.java:282)
175        at com.pivotal.gemfirexd.internal.engine.distributed.message.GfxdFunctionMessage.executeFunction(GfxdFunctionMessage.java:332)
176        at com.pivotal.gemfirexd.internal.engine.distributed.message.GfxdFunctionMessage.executeFunction(GfxdFunctionMessage.java:274)
177        at com.pivotal.gemfirexd.internal.engine.sql.execute.SnappyActivation.executeOnLeadNode(SnappyActivation.java:234)
178        at com.pivotal.gemfirexd.internal.engine.sql.execute.SnappyActivation.executeWithResultSet(SnappyActivation.java:123)
179        at com.pivotal.gemfirexd.internal.engine.sql.execute.SnappyActivation.execute(SnappyActivation.java:86)
180        at com.pivotal.gemfirexd.internal.impl.sql.GenericActivationHolder.execute(GenericActivationHolder.java:462)
181        at com.pivotal.gemfirexd.internal.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:586)
182        at com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:2159)
183        at com.pivotal.gemfirexd.internal.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1981)
184        at com.pivotal.gemfirexd.internal.impl.jdbc.EmbedCallableStatement.executeStatement(EmbedCallableStatement.java:133)
185        at com.pivotal.gemfirexd.internal.impl.jdbc.EmbedPreparedStatement.execute(EmbedPreparedStatement.java:1599)
186        at io.snappydata.thrift.server.SnappyDataServiceImpl.executePrepared(SnappyDataServiceImpl.java:2340)
187        at io.snappydata.thrift.SnappyDataService$Processor$executePrepared.getResult(SnappyDataService.java:1607)
188        at io.snappydata.thrift.SnappyDataService$Processor$executePrepared.getResult(SnappyDataService.java:1591)
189        at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
190        at io.snappydata.thrift.server.SnappyDataServiceImpl$Processor.process(SnappyDataServiceImpl.java:197)
191        at io.snappydata.thrift.server.SnappyThriftServerThreadPool$WorkerProcess.run(SnappyThriftServerThreadPool.java:270)
192        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
193        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
194        at java.lang.Thread.run(Thread.java:745)
195Caused by: com.pivotal.gemfirexd.internal.engine.jdbc.GemFireXDRuntimeException: myID: s-dcr-hdp-sl2(29612)<v2>:38802, caused by java.sql.SQLTransactionRollbackException(40XL1): A lock could not be obtained within the time requested
196        at com.pivotal.gemfirexd.internal.engine.distributed.GfxdQueryStreamingResultCollector$Itr.moveNext(GfxdQueryStreamingResultCollector.java:451)
197        at com.pivotal.gemfirexd.internal.engine.distributed.GfxdQueryStreamingResultCollector$Itr.<init>(GfxdQueryStreamingResultCollector.java:363)
198        at com.pivotal.gemfirexd.internal.engine.distributed.GfxdQueryStreamingResultCollector.iterator(GfxdQueryStreamingResultCollector.java:207)
199        at com.pivotal.gemfirexd.internal.engine.sql.execute.SnappySelectResultSet.setup(SnappySelectResultSet.java:276)
200        ... 20 more
201Caused by: java.sql.SQLTransactionRollbackException(40XL1): A lock could not be obtained within the time requested
202        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.iapi.error.StandardException.newException(StandardException.java:456)
203        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.locks.GfxdLocalLockService.getLockTimeoutException(GfxdLocalLockService.java:296)
204        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.locks.GfxdDRWLockService.getLockTimeoutException(GfxdDRWLockService.java:727)
205        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.utils.GemFireXDUtils.lockObject(GemFireXDUtils.java:1293)
206        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.catalog.GfxdDataDictionary.lockForWriting(GfxdDataDictionary.java:603)
207        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.catalog.GfxdDataDictionary.startWriting(GfxdDataDictionary.java:533)
208        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.catalog.GfxdDataDictionary.startWriting(GfxdDataDictionary.java:478)
209        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.execute.DropTableConstantAction.executeConstantAction(DropTableConstantAction.java:254)
210        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.execute.MiscResultSet.open(MiscResultSet.java:64)
211        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:593)
212        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:2159)
213        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:1283)
214        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:1005)
215        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.executeUpdate(EmbedStatement.java:502)
216        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.sources.JdbcExtendedUtils$.executeUpdate(jdbcExtensions.scala:88)
217        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.row.GemFireXDBaseDialect.dropTable(GemFireXDDialect.scala:150)
218        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.sources.JdbcExtendedUtils$.dropTable(jdbcExtensions.scala:197)
219        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.row.JDBCMutableRelation.destroy(JDBCMutableRelation.scala:291)
220        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession.dropTable(SnappySession.scala:1153)
221        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.DropTable.run(SnappyDDLParser.scala:647)
222        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.backwardcomp.ExecutedCommand.sideEffectResult$lzycompute(sparkPlans.scala:40)
223        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.backwardcomp.ExecutedCommand.sideEffectResult(sparkPlans.scala:38)
224        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.backwardcomp.ExecutedCommand.doExecute(sparkPlans.scala:54)
225        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:115)
226        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:115)
227        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:136)
228        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
229        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:133)
230        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:114)
231        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.QueryExecution.toRdd$lzycompute(QueryExecution.scala:86)
232        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.QueryExecution.toRdd(QueryExecution.scala:86)
233        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.Dataset.<init>(Dataset.scala:186)
234        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.Dataset.<init>(Dataset.scala:167)
235        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.Dataset$.ofRows(Dataset.scala:65)
236        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SparkSession.sql(SparkSession.scala:582)
237        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession.executeSQL(SnappySession.scala:166)
238        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anon$3.load(SnappySession.scala:1616)
239        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anon$3.load(SnappySession.scala:1611)
240        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3599)
241        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2379)
242        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2342)
243        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2257)
244        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache.get(LocalCache.java:4000)
245        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4004)
246        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4874)
247        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4880)
248        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$.getPlan(SnappySession.scala:1641)
249        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anonfun$sql$1.apply(SnappySession.scala:160)
250        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anonfun$sql$1.apply(SnappySession.scala:160)
251        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.aqp.SnappyContextFunctions.sql(SnappyContextFunctions.scala:91)
252        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession.sql(SnappySession.scala:160)
253        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in io.snappydata.gemxd.SparkSQLExecuteImpl.<init>(SparkSQLExecuteImpl.scala:68)
254        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in io.snappydata.gemxd.ClusterCallbacksImpl$.getSQLExecute(ClusterCallbacksImpl.scala:80)
255        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.message.LeadNodeExecutorMsg.execute(LeadNodeExecutorMsg.java:128)
256        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.message.GfxdFunctionMessage.processMessage(GfxdFunctionMessage.java:739)
257        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.GfxdMessage.basicProcess(GfxdMessage.java:406)
258        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.internal.cache.AbstractOperationMessage.process(AbstractOperationMessage.java:212)
259        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionMessage.scheduleAction(DistributionMessage.java:429)
260        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionMessage$1.run(DistributionMessage.java:501)
261        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
262        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
263        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionManager.runUntilShutdown(DistributionManager.java:728)
264        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionManager$9$1.run(DistributionManager.java:1178)
265        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in java.lang.Thread.run(Thread.java:745)
266        at com.pivotal.gemfirexd.internal.iapi.error.StandardException.fixUpRemoteException(StandardException.java:162)
267        at com.pivotal.gemfirexd.internal.engine.Misc.wrapRemoteSQLException(Misc.java:1038)
268        at com.pivotal.gemfirexd.internal.engine.Misc.processFunctionException(Misc.java:767)
269        at com.pivotal.gemfirexd.internal.engine.Misc.processFunctionException(Misc.java:753)
270        at com.pivotal.gemfirexd.internal.engine.sql.execute.SnappySelectResultSet.setup(SnappySelectResultSet.java:282)
271        ... 20 more
272Caused by: com.gemstone.gemfire.cache.LockTimeoutException: lock timeout for object: DefaultGfxdLockable@52bc4624:GfxdDataDictionary, for lock: GfxdReentrantReadWriteLock@4eb5c7d3,QSync@6c753c9f[name=GfxdDataDictionary] [readers=0], requested for owner: DistributedTXLockOwner(member=s-dcr-hdp-sl2(29918)<v3>:5552,XID=1502,ownerThread=Thread[Function Execution Processor1,10,DistributionManager Threads Interruptible],vmCreatorThread=Thread[Function Execution Processor1,10,DistributionManager Threads Interruptible])
273        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.locks.GfxdLocalLockService.getLockTimeoutRuntimeException(GfxdLocalLockService.java:291)
274        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.locks.GfxdLocalLockService.getLockTimeoutException(GfxdLocalLockService.java:297)
275        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.locks.GfxdDRWLockService.getLockTimeoutException(GfxdDRWLockService.java:727)
276        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.utils.GemFireXDUtils.lockObject(GemFireXDUtils.java:1293)
277        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.catalog.GfxdDataDictionary.lockForWriting(GfxdDataDictionary.java:603)
278        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.catalog.GfxdDataDictionary.startWriting(GfxdDataDictionary.java:533)
279        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.catalog.GfxdDataDictionary.startWriting(GfxdDataDictionary.java:478)
280        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.execute.DropTableConstantAction.executeConstantAction(DropTableConstantAction.java:254)
281        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.execute.MiscResultSet.open(MiscResultSet.java:64)
282        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:593)
283        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:2159)
284        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:1283)
285        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:1005)
286        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.executeUpdate(EmbedStatement.java:502)
287        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.sources.JdbcExtendedUtils$.executeUpdate(jdbcExtensions.scala:88)
288        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.row.GemFireXDBaseDialect.dropTable(GemFireXDDialect.scala:150)
289        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.sources.JdbcExtendedUtils$.dropTable(jdbcExtensions.scala:197)
290        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.row.JDBCMutableRelation.destroy(JDBCMutableRelation.scala:291)
291        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession.dropTable(SnappySession.scala:1153)
292        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.DropTable.run(SnappyDDLParser.scala:647)
293        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.backwardcomp.ExecutedCommand.sideEffectResult$lzycompute(sparkPlans.scala:40)
294        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.backwardcomp.ExecutedCommand.sideEffectResult(sparkPlans.scala:38)
295        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.backwardcomp.ExecutedCommand.doExecute(sparkPlans.scala:54)
296        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:115)
297        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:115)
298        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:136)
299        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
300        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:133)
301        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:114)
302        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.QueryExecution.toRdd$lzycompute(QueryExecution.scala:86)
303        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.QueryExecution.toRdd(QueryExecution.scala:86)
304        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.Dataset.<init>(Dataset.scala:186)
305        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.Dataset.<init>(Dataset.scala:167)
306        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.Dataset$.ofRows(Dataset.scala:65)
307        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SparkSession.sql(SparkSession.scala:582)
308        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession.executeSQL(SnappySession.scala:166)
309        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anon$3.load(SnappySession.scala:1616)
310        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anon$3.load(SnappySession.scala:1611)
311        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3599)
312        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2379)
313        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2342)
314        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2257)
315        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache.get(LocalCache.java:4000)
316        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4004)
317        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4874)
318        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4880)
319        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$.getPlan(SnappySession.scala:1641)
320        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anonfun$sql$1.apply(SnappySession.scala:160)
321        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anonfun$sql$1.apply(SnappySession.scala:160)
322        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.aqp.SnappyContextFunctions.sql(SnappyContextFunctions.scala:91)
323        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession.sql(SnappySession.scala:160)
324        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in io.snappydata.gemxd.SparkSQLExecuteImpl.<init>(SparkSQLExecuteImpl.scala:68)
325        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in io.snappydata.gemxd.ClusterCallbacksImpl$.getSQLExecute(ClusterCallbacksImpl.scala:80)
326        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.message.LeadNodeExecutorMsg.execute(LeadNodeExecutorMsg.java:128)
327        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.message.GfxdFunctionMessage.processMessage(GfxdFunctionMessage.java:739)
328        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.GfxdMessage.basicProcess(GfxdMessage.java:406)
329        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.internal.cache.AbstractOperationMessage.process(AbstractOperationMessage.java:212)
330        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionMessage.scheduleAction(DistributionMessage.java:429)
331        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionMessage$1.run(DistributionMessage.java:501)
332        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
333        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
334        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionManager.runUntilShutdown(DistributionManager.java:728)
335        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionManager$9$1.run(DistributionManager.java:1178)
336        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in java.lang.Thread.run(Thread.java:745)
337
338        at io.snappydata.thrift.common.ThriftExceptionUtil.newSQLException(ThriftExceptionUtil.java:109)
339        at io.snappydata.thrift.internal.ClientPreparedStatement.execute(ClientPreparedStatement.java:220)
340        ... 34 more
341[ERROR] [08/21/2018 16:32:01.438] [slickSnappy.db-3] SnappyMigrator - Migration failed, see logs for detail
342java.lang.IllegalStateException: Migration 47 failed. Couldn't execute statement in script at position 29.64 SQL:
343DROP TABLE IF EXISTS APP.WAREHOUSE_SPEC
344        at ru.neoflex.pecom.slick.migration.manager.MigrationManager$$anonfun$ru$neoflex$pecom$slick$migration$manager$MigrationManager$$migrationToDbio$1.apply(MigrationManager.scala:102)
345        at ru.neoflex.pecom.slick.migration.manager.MigrationManager$$anonfun$ru$neoflex$pecom$slick$migration$manager$MigrationManager$$migrationToDbio$1.apply(MigrationManager.scala:96)
346        at slick.jdbc.SimpleJdbcAction.run(StreamingInvokerAction.scala:70)
347        at slick.jdbc.SimpleJdbcAction.run(StreamingInvokerAction.scala:69)
348        at slick.dbio.DBIOAction$$anon$4$$anonfun$run$3.apply(DBIOAction.scala:240)
349        at slick.dbio.DBIOAction$$anon$4$$anonfun$run$3.apply(DBIOAction.scala:240)
350        at scala.collection.Iterator$class.foreach(Iterator.scala:891)
351        at scala.collection.AbstractIterator.foreach(Iterator.scala:1334)
352        at scala.collection.IterableLike$class.foreach(IterableLike.scala:72)
353        at scala.collection.AbstractIterable.foreach(Iterable.scala:54)
354        at slick.dbio.DBIOAction$$anon$4.run(DBIOAction.scala:240)
355        at slick.dbio.DBIOAction$$anon$4.run(DBIOAction.scala:238)
356        at slick.dbio.SynchronousDatabaseAction$FusedAndThenAction$$anonfun$run$4.apply(DBIOAction.scala:534)
357        at slick.dbio.SynchronousDatabaseAction$FusedAndThenAction$$anonfun$run$4.apply(DBIOAction.scala:534)
358        at scala.collection.Iterator$class.foreach(Iterator.scala:891)
359        at scala.collection.AbstractIterator.foreach(Iterator.scala:1334)
360        at scala.collection.IterableLike$class.foreach(IterableLike.scala:72)
361        at scala.collection.AbstractIterable.foreach(Iterable.scala:54)
362        at slick.dbio.SynchronousDatabaseAction$FusedAndThenAction.run(DBIOAction.scala:534)
363        at slick.dbio.SynchronousDatabaseAction$$anon$11.run(DBIOAction.scala:571)
364        at slick.dbio.SynchronousDatabaseAction$$anon$6.run(DBIOAction.scala:470)
365        at slick.dbio.SynchronousDatabaseAction$$anon$10.run(DBIOAction.scala:562)
366        at slick.dbio.SynchronousDatabaseAction$$anon$7.run(DBIOAction.scala:487)
367        at slick.basic.BasicBackend$DatabaseDef$$anon$2.liftedTree1$1(BasicBackend.scala:240)
368        at slick.basic.BasicBackend$DatabaseDef$$anon$2.run(BasicBackend.scala:240)
369        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
370        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
371        at java.lang.Thread.run(Thread.java:748)
372Caused by: java.sql.SQLException: (SQLState=40XL1 Severity=30000) (Server=s-dcr-hdp-sl2.pecom.local/10.255.2.16[1529] Thread=pool-3-thread-3) A lock could not be obtained within the time requested
373        at io.snappydata.thrift.SnappyDataService$executePrepared_result$executePrepared_resultStandardScheme.read(SnappyDataService.java:12075)
374        at io.snappydata.thrift.SnappyDataService$executePrepared_result$executePrepared_resultStandardScheme.read(SnappyDataService.java:12052)
375        at io.snappydata.thrift.SnappyDataService$executePrepared_result.read(SnappyDataService.java:11991)
376        at io.snappydata.org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:86)
377        at io.snappydata.thrift.SnappyDataService$Client.recv_executePrepared(SnappyDataService.java:374)
378        at io.snappydata.thrift.SnappyDataService$Client.executePrepared(SnappyDataService.java:357)
379        at io.snappydata.thrift.internal.ClientService.executePrepared(ClientService.java:1051)
380        at io.snappydata.thrift.internal.ClientPreparedStatement.execute(ClientPreparedStatement.java:201)
381        at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
382        at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
383        at ru.neoflex.pecom.slick.migration.manager.MigrationManager$$anonfun$ru$neoflex$pecom$slick$migration$manager$MigrationManager$$migrationToDbio$1$$anonfun$1.apply$mcZ$sp(MigrationManager.scala:99)
384        at ru.neoflex.pecom.slick.migration.manager.MigrationManager$$anonfun$ru$neoflex$pecom$slick$migration$manager$MigrationManager$$migrationToDbio$1$$anonfun$1.apply(MigrationManager.scala:97)
385        at ru.neoflex.pecom.slick.migration.manager.MigrationManager$$anonfun$ru$neoflex$pecom$slick$migration$manager$MigrationManager$$migrationToDbio$1$$anonfun$1.apply(MigrationManager.scala:97)
386        at scala.util.Try$.apply(Try.scala:192)
387        at ru.neoflex.pecom.slick.migration.manager.MigrationManager$$anonfun$ru$neoflex$pecom$slick$migration$manager$MigrationManager$$migrationToDbio$1.apply(MigrationManager.scala:97)
388        ... 27 more
389Caused by: java.rmi.ServerException: Server STACK: java.sql.SQLTransactionRollbackException(40XL1): A lock could not be obtained within the time requested
390        at com.pivotal.gemfirexd.internal.iapi.error.StandardException.newPreLocalizedException(StandardException.java:614)
391        at com.pivotal.gemfirexd.internal.engine.Misc.wrapSQLException(Misc.java:1062)
392        at com.pivotal.gemfirexd.internal.engine.Misc.wrapRemoteSQLException(Misc.java:1039)
393        at com.pivotal.gemfirexd.internal.engine.Misc.processFunctionException(Misc.java:767)
394        at com.pivotal.gemfirexd.internal.engine.Misc.processFunctionException(Misc.java:753)
395        at com.pivotal.gemfirexd.internal.engine.sql.execute.SnappySelectResultSet.setup(SnappySelectResultSet.java:282)
396        at com.pivotal.gemfirexd.internal.engine.distributed.message.GfxdFunctionMessage.executeFunction(GfxdFunctionMessage.java:332)
397        at com.pivotal.gemfirexd.internal.engine.distributed.message.GfxdFunctionMessage.executeFunction(GfxdFunctionMessage.java:274)
398        at com.pivotal.gemfirexd.internal.engine.sql.execute.SnappyActivation.executeOnLeadNode(SnappyActivation.java:234)
399        at com.pivotal.gemfirexd.internal.engine.sql.execute.SnappyActivation.executeWithResultSet(SnappyActivation.java:123)
400        at com.pivotal.gemfirexd.internal.engine.sql.execute.SnappyActivation.execute(SnappyActivation.java:86)
401        at com.pivotal.gemfirexd.internal.impl.sql.GenericActivationHolder.execute(GenericActivationHolder.java:462)
402        at com.pivotal.gemfirexd.internal.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:586)
403        at com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:2159)
404        at com.pivotal.gemfirexd.internal.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1981)
405        at com.pivotal.gemfirexd.internal.impl.jdbc.EmbedCallableStatement.executeStatement(EmbedCallableStatement.java:133)
406        at com.pivotal.gemfirexd.internal.impl.jdbc.EmbedPreparedStatement.execute(EmbedPreparedStatement.java:1599)
407        at io.snappydata.thrift.server.SnappyDataServiceImpl.executePrepared(SnappyDataServiceImpl.java:2340)
408        at io.snappydata.thrift.SnappyDataService$Processor$executePrepared.getResult(SnappyDataService.java:1607)
409        at io.snappydata.thrift.SnappyDataService$Processor$executePrepared.getResult(SnappyDataService.java:1591)
410        at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
411        at io.snappydata.thrift.server.SnappyDataServiceImpl$Processor.process(SnappyDataServiceImpl.java:197)
412        at io.snappydata.thrift.server.SnappyThriftServerThreadPool$WorkerProcess.run(SnappyThriftServerThreadPool.java:270)
413        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
414        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
415        at java.lang.Thread.run(Thread.java:745)
416Caused by: com.pivotal.gemfirexd.internal.engine.jdbc.GemFireXDRuntimeException: myID: s-dcr-hdp-sl2(29612)<v2>:38802, caused by java.sql.SQLTransactionRollbackException(40XL1): A lock could not be obtained within the time requested
417        at com.pivotal.gemfirexd.internal.engine.distributed.GfxdQueryStreamingResultCollector$Itr.moveNext(GfxdQueryStreamingResultCollector.java:451)
418        at com.pivotal.gemfirexd.internal.engine.distributed.GfxdQueryStreamingResultCollector$Itr.<init>(GfxdQueryStreamingResultCollector.java:363)
419        at com.pivotal.gemfirexd.internal.engine.distributed.GfxdQueryStreamingResultCollector.iterator(GfxdQueryStreamingResultCollector.java:207)
420        at com.pivotal.gemfirexd.internal.engine.sql.execute.SnappySelectResultSet.setup(SnappySelectResultSet.java:276)
421        ... 20 more
422Caused by: java.sql.SQLTransactionRollbackException(40XL1): A lock could not be obtained within the time requested
423        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.iapi.error.StandardException.newException(StandardException.java:456)
424        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.locks.GfxdLocalLockService.getLockTimeoutException(GfxdLocalLockService.java:296)
425        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.locks.GfxdDRWLockService.getLockTimeoutException(GfxdDRWLockService.java:727)
426        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.utils.GemFireXDUtils.lockObject(GemFireXDUtils.java:1293)
427        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.catalog.GfxdDataDictionary.lockForWriting(GfxdDataDictionary.java:603)
428        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.catalog.GfxdDataDictionary.startWriting(GfxdDataDictionary.java:533)
429        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.catalog.GfxdDataDictionary.startWriting(GfxdDataDictionary.java:478)
430        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.execute.DropTableConstantAction.executeConstantAction(DropTableConstantAction.java:254)
431        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.execute.MiscResultSet.open(MiscResultSet.java:64)
432        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:593)
433        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:2159)
434        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:1283)
435        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:1005)
436        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.executeUpdate(EmbedStatement.java:502)
437        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.sources.JdbcExtendedUtils$.executeUpdate(jdbcExtensions.scala:88)
438        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.row.GemFireXDBaseDialect.dropTable(GemFireXDDialect.scala:150)
439        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.sources.JdbcExtendedUtils$.dropTable(jdbcExtensions.scala:197)
440        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.row.JDBCMutableRelation.destroy(JDBCMutableRelation.scala:291)
441        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession.dropTable(SnappySession.scala:1153)
442        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.DropTable.run(SnappyDDLParser.scala:647)
443        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.backwardcomp.ExecutedCommand.sideEffectResult$lzycompute(sparkPlans.scala:40)
444        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.backwardcomp.ExecutedCommand.sideEffectResult(sparkPlans.scala:38)
445        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.backwardcomp.ExecutedCommand.doExecute(sparkPlans.scala:54)
446        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:115)
447        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:115)
448        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:136)
449        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
450        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:133)
451        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:114)
452        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.QueryExecution.toRdd$lzycompute(QueryExecution.scala:86)
453        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.QueryExecution.toRdd(QueryExecution.scala:86)
454        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.Dataset.<init>(Dataset.scala:186)
455        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.Dataset.<init>(Dataset.scala:167)
456        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.Dataset$.ofRows(Dataset.scala:65)
457        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SparkSession.sql(SparkSession.scala:582)
458        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession.executeSQL(SnappySession.scala:166)
459        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anon$3.load(SnappySession.scala:1616)
460        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anon$3.load(SnappySession.scala:1611)
461        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3599)
462        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2379)
463        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2342)
464        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2257)
465        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache.get(LocalCache.java:4000)
466        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4004)
467        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4874)
468        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4880)
469        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$.getPlan(SnappySession.scala:1641)
470        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anonfun$sql$1.apply(SnappySession.scala:160)
471        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anonfun$sql$1.apply(SnappySession.scala:160)
472        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.aqp.SnappyContextFunctions.sql(SnappyContextFunctions.scala:91)
473        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession.sql(SnappySession.scala:160)
474        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in io.snappydata.gemxd.SparkSQLExecuteImpl.<init>(SparkSQLExecuteImpl.scala:68)
475        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in io.snappydata.gemxd.ClusterCallbacksImpl$.getSQLExecute(ClusterCallbacksImpl.scala:80)
476        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.message.LeadNodeExecutorMsg.execute(LeadNodeExecutorMsg.java:128)
477        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.message.GfxdFunctionMessage.processMessage(GfxdFunctionMessage.java:739)
478        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.GfxdMessage.basicProcess(GfxdMessage.java:406)
479        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.internal.cache.AbstractOperationMessage.process(AbstractOperationMessage.java:212)
480        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionMessage.scheduleAction(DistributionMessage.java:429)
481        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionMessage$1.run(DistributionMessage.java:501)
482        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
483        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
484        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionManager.runUntilShutdown(DistributionManager.java:728)
485        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionManager$9$1.run(DistributionManager.java:1178)
486        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in java.lang.Thread.run(Thread.java:745)
487        at com.pivotal.gemfirexd.internal.iapi.error.StandardException.fixUpRemoteException(StandardException.java:162)
488        at com.pivotal.gemfirexd.internal.engine.Misc.wrapRemoteSQLException(Misc.java:1038)
489        at com.pivotal.gemfirexd.internal.engine.Misc.processFunctionException(Misc.java:767)
490        at com.pivotal.gemfirexd.internal.engine.Misc.processFunctionException(Misc.java:753)
491        at com.pivotal.gemfirexd.internal.engine.sql.execute.SnappySelectResultSet.setup(SnappySelectResultSet.java:282)
492        ... 20 more
493Caused by: com.gemstone.gemfire.cache.LockTimeoutException: lock timeout for object: DefaultGfxdLockable@52bc4624:GfxdDataDictionary, for lock: GfxdReentrantReadWriteLock@4eb5c7d3,QSync@6c753c9f[name=GfxdDataDictionary] [readers=0], requested for owner: DistributedTXLockOwner(member=s-dcr-hdp-sl2(29918)<v3>:5552,XID=1502,ownerThread=Thread[Function Execution Processor1,10,DistributionManager Threads Interruptible],vmCreatorThread=Thread[Function Execution Processor1,10,DistributionManager Threads Interruptible])
494        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.locks.GfxdLocalLockService.getLockTimeoutRuntimeException(GfxdLocalLockService.java:291)
495        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.locks.GfxdLocalLockService.getLockTimeoutException(GfxdLocalLockService.java:297)
496        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.locks.GfxdDRWLockService.getLockTimeoutException(GfxdDRWLockService.java:727)
497        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.utils.GemFireXDUtils.lockObject(GemFireXDUtils.java:1293)
498        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.catalog.GfxdDataDictionary.lockForWriting(GfxdDataDictionary.java:603)
499        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.catalog.GfxdDataDictionary.startWriting(GfxdDataDictionary.java:533)
500        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.catalog.GfxdDataDictionary.startWriting(GfxdDataDictionary.java:478)
501        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.execute.DropTableConstantAction.executeConstantAction(DropTableConstantAction.java:254)
502        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.execute.MiscResultSet.open(MiscResultSet.java:64)
503        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:593)
504        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:2159)
505        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:1283)
506        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:1005)
507        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.executeUpdate(EmbedStatement.java:502)
508        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.sources.JdbcExtendedUtils$.executeUpdate(jdbcExtensions.scala:88)
509        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.row.GemFireXDBaseDialect.dropTable(GemFireXDDialect.scala:150)
510        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.sources.JdbcExtendedUtils$.dropTable(jdbcExtensions.scala:197)
511        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.row.JDBCMutableRelation.destroy(JDBCMutableRelation.scala:291)
512        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession.dropTable(SnappySession.scala:1153)
513        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.DropTable.run(SnappyDDLParser.scala:647)
514        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.backwardcomp.ExecutedCommand.sideEffectResult$lzycompute(sparkPlans.scala:40)
515        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.backwardcomp.ExecutedCommand.sideEffectResult(sparkPlans.scala:38)
516        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.backwardcomp.ExecutedCommand.doExecute(sparkPlans.scala:54)
517        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:115)
518        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:115)
519        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:136)
520        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
521        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:133)
522        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:114)
523        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.QueryExecution.toRdd$lzycompute(QueryExecution.scala:86)
524        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.QueryExecution.toRdd(QueryExecution.scala:86)
525        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.Dataset.<init>(Dataset.scala:186)
526        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.Dataset.<init>(Dataset.scala:167)
527        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.Dataset$.ofRows(Dataset.scala:65)
528        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SparkSession.sql(SparkSession.scala:582)
529        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession.executeSQL(SnappySession.scala:166)
530        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anon$3.load(SnappySession.scala:1616)
531        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anon$3.load(SnappySession.scala:1611)
532        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3599)
533        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2379)
534        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2342)
535        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2257)
536        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache.get(LocalCache.java:4000)
537        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4004)
538        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4874)
539        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4880)
540        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$.getPlan(SnappySession.scala:1641)
541        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anonfun$sql$1.apply(SnappySession.scala:160)
542        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anonfun$sql$1.apply(SnappySession.scala:160)
543        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.aqp.SnappyContextFunctions.sql(SnappyContextFunctions.scala:91)
544        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession.sql(SnappySession.scala:160)
545        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in io.snappydata.gemxd.SparkSQLExecuteImpl.<init>(SparkSQLExecuteImpl.scala:68)
546        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in io.snappydata.gemxd.ClusterCallbacksImpl$.getSQLExecute(ClusterCallbacksImpl.scala:80)
547        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.message.LeadNodeExecutorMsg.execute(LeadNodeExecutorMsg.java:128)
548        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.message.GfxdFunctionMessage.processMessage(GfxdFunctionMessage.java:739)
549        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.GfxdMessage.basicProcess(GfxdMessage.java:406)
550        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.internal.cache.AbstractOperationMessage.process(AbstractOperationMessage.java:212)
551        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionMessage.scheduleAction(DistributionMessage.java:429)
552        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionMessage$1.run(DistributionMessage.java:501)
553        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
554        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
555        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionManager.runUntilShutdown(DistributionManager.java:728)
556        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionManager$9$1.run(DistributionManager.java:1178)
557        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in java.lang.Thread.run(Thread.java:745)
558
559        at io.snappydata.thrift.common.ThriftExceptionUtil.newSQLException(ThriftExceptionUtil.java:109)
560        at io.snappydata.thrift.internal.ClientPreparedStatement.execute(ClientPreparedStatement.java:220)
561        ... 34 more
562[INFO] [08/21/2018 16:32:01.454] [main] HikariPool - slickSnappy.db - Close initiated...
563[INFO] [08/21/2018 16:32:01.483] [main] HikariPool - slickSnappy.db - Closed.
564[ERROR] [08/21/2018 16:32:01.491] [main] Migrator$ - Migrate database failed
565java.lang.IllegalStateException: Migration 47 failed. Couldn't execute statement in script at position 29.64 SQL:
566DROP TABLE IF EXISTS APP.WAREHOUSE_SPEC
567        at ru.neoflex.pecom.slick.migration.manager.MigrationManager$$anonfun$ru$neoflex$pecom$slick$migration$manager$MigrationManager$$migrationToDbio$1.apply(MigrationManager.scala:102)
568        at ru.neoflex.pecom.slick.migration.manager.MigrationManager$$anonfun$ru$neoflex$pecom$slick$migration$manager$MigrationManager$$migrationToDbio$1.apply(MigrationManager.scala:96)
569        at slick.jdbc.SimpleJdbcAction.run(StreamingInvokerAction.scala:70)
570        at slick.jdbc.SimpleJdbcAction.run(StreamingInvokerAction.scala:69)
571        at slick.dbio.DBIOAction$$anon$4$$anonfun$run$3.apply(DBIOAction.scala:240)
572        at slick.dbio.DBIOAction$$anon$4$$anonfun$run$3.apply(DBIOAction.scala:240)
573        at scala.collection.Iterator$class.foreach(Iterator.scala:891)
574        at scala.collection.AbstractIterator.foreach(Iterator.scala:1334)
575        at scala.collection.IterableLike$class.foreach(IterableLike.scala:72)
576        at scala.collection.AbstractIterable.foreach(Iterable.scala:54)
577        at slick.dbio.DBIOAction$$anon$4.run(DBIOAction.scala:240)
578        at slick.dbio.DBIOAction$$anon$4.run(DBIOAction.scala:238)
579        at slick.dbio.SynchronousDatabaseAction$FusedAndThenAction$$anonfun$run$4.apply(DBIOAction.scala:534)
580        at slick.dbio.SynchronousDatabaseAction$FusedAndThenAction$$anonfun$run$4.apply(DBIOAction.scala:534)
581        at scala.collection.Iterator$class.foreach(Iterator.scala:891)
582        at scala.collection.AbstractIterator.foreach(Iterator.scala:1334)
583        at scala.collection.IterableLike$class.foreach(IterableLike.scala:72)
584        at scala.collection.AbstractIterable.foreach(Iterable.scala:54)
585        at slick.dbio.SynchronousDatabaseAction$FusedAndThenAction.run(DBIOAction.scala:534)
586        at slick.dbio.SynchronousDatabaseAction$$anon$11.run(DBIOAction.scala:571)
587        at slick.dbio.SynchronousDatabaseAction$$anon$6.run(DBIOAction.scala:470)
588        at slick.dbio.SynchronousDatabaseAction$$anon$10.run(DBIOAction.scala:562)
589        at slick.dbio.SynchronousDatabaseAction$$anon$7.run(DBIOAction.scala:487)
590        at slick.basic.BasicBackend$DatabaseDef$$anon$2.liftedTree1$1(BasicBackend.scala:240)
591        at slick.basic.BasicBackend$DatabaseDef$$anon$2.run(BasicBackend.scala:240)
592        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
593        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
594        at java.lang.Thread.run(Thread.java:748)
595Caused by: java.sql.SQLException: (SQLState=40XL1 Severity=30000) (Server=s-dcr-hdp-sl2.pecom.local/10.255.2.16[1529] Thread=pool-3-thread-3) A lock could not be obtained within the time requested
596        at io.snappydata.thrift.SnappyDataService$executePrepared_result$executePrepared_resultStandardScheme.read(SnappyDataService.java:12075)
597        at io.snappydata.thrift.SnappyDataService$executePrepared_result$executePrepared_resultStandardScheme.read(SnappyDataService.java:12052)
598        at io.snappydata.thrift.SnappyDataService$executePrepared_result.read(SnappyDataService.java:11991)
599        at io.snappydata.org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:86)
600        at io.snappydata.thrift.SnappyDataService$Client.recv_executePrepared(SnappyDataService.java:374)
601        at io.snappydata.thrift.SnappyDataService$Client.executePrepared(SnappyDataService.java:357)
602        at io.snappydata.thrift.internal.ClientService.executePrepared(ClientService.java:1051)
603        at io.snappydata.thrift.internal.ClientPreparedStatement.execute(ClientPreparedStatement.java:201)
604        at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
605        at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
606        at ru.neoflex.pecom.slick.migration.manager.MigrationManager$$anonfun$ru$neoflex$pecom$slick$migration$manager$MigrationManager$$migrationToDbio$1$$anonfun$1.apply$mcZ$sp(MigrationManager.scala:99)
607        at ru.neoflex.pecom.slick.migration.manager.MigrationManager$$anonfun$ru$neoflex$pecom$slick$migration$manager$MigrationManager$$migrationToDbio$1$$anonfun$1.apply(MigrationManager.scala:97)
608        at ru.neoflex.pecom.slick.migration.manager.MigrationManager$$anonfun$ru$neoflex$pecom$slick$migration$manager$MigrationManager$$migrationToDbio$1$$anonfun$1.apply(MigrationManager.scala:97)
609        at scala.util.Try$.apply(Try.scala:192)
610        at ru.neoflex.pecom.slick.migration.manager.MigrationManager$$anonfun$ru$neoflex$pecom$slick$migration$manager$MigrationManager$$migrationToDbio$1.apply(MigrationManager.scala:97)
611        ... 27 more
612Caused by: java.rmi.ServerException: Server STACK: java.sql.SQLTransactionRollbackException(40XL1): A lock could not be obtained within the time requested
613        at com.pivotal.gemfirexd.internal.iapi.error.StandardException.newPreLocalizedException(StandardException.java:614)
614        at com.pivotal.gemfirexd.internal.engine.Misc.wrapSQLException(Misc.java:1062)
615        at com.pivotal.gemfirexd.internal.engine.Misc.wrapRemoteSQLException(Misc.java:1039)
616        at com.pivotal.gemfirexd.internal.engine.Misc.processFunctionException(Misc.java:767)
617        at com.pivotal.gemfirexd.internal.engine.Misc.processFunctionException(Misc.java:753)
618        at com.pivotal.gemfirexd.internal.engine.sql.execute.SnappySelectResultSet.setup(SnappySelectResultSet.java:282)
619        at com.pivotal.gemfirexd.internal.engine.distributed.message.GfxdFunctionMessage.executeFunction(GfxdFunctionMessage.java:332)
620        at com.pivotal.gemfirexd.internal.engine.distributed.message.GfxdFunctionMessage.executeFunction(GfxdFunctionMessage.java:274)
621        at com.pivotal.gemfirexd.internal.engine.sql.execute.SnappyActivation.executeOnLeadNode(SnappyActivation.java:234)
622        at com.pivotal.gemfirexd.internal.engine.sql.execute.SnappyActivation.executeWithResultSet(SnappyActivation.java:123)
623        at com.pivotal.gemfirexd.internal.engine.sql.execute.SnappyActivation.execute(SnappyActivation.java:86)
624        at com.pivotal.gemfirexd.internal.impl.sql.GenericActivationHolder.execute(GenericActivationHolder.java:462)
625        at com.pivotal.gemfirexd.internal.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:586)
626        at com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:2159)
627        at com.pivotal.gemfirexd.internal.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1981)
628        at com.pivotal.gemfirexd.internal.impl.jdbc.EmbedCallableStatement.executeStatement(EmbedCallableStatement.java:133)
629        at com.pivotal.gemfirexd.internal.impl.jdbc.EmbedPreparedStatement.execute(EmbedPreparedStatement.java:1599)
630        at io.snappydata.thrift.server.SnappyDataServiceImpl.executePrepared(SnappyDataServiceImpl.java:2340)
631        at io.snappydata.thrift.SnappyDataService$Processor$executePrepared.getResult(SnappyDataService.java:1607)
632        at io.snappydata.thrift.SnappyDataService$Processor$executePrepared.getResult(SnappyDataService.java:1591)
633        at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
634        at io.snappydata.thrift.server.SnappyDataServiceImpl$Processor.process(SnappyDataServiceImpl.java:197)
635        at io.snappydata.thrift.server.SnappyThriftServerThreadPool$WorkerProcess.run(SnappyThriftServerThreadPool.java:270)
636        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
637        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
638        at java.lang.Thread.run(Thread.java:745)
639Caused by: com.pivotal.gemfirexd.internal.engine.jdbc.GemFireXDRuntimeException: myID: s-dcr-hdp-sl2(29612)<v2>:38802, caused by java.sql.SQLTransactionRollbackException(40XL1): A lock could not be obtained within the time requested
640        at com.pivotal.gemfirexd.internal.engine.distributed.GfxdQueryStreamingResultCollector$Itr.moveNext(GfxdQueryStreamingResultCollector.java:451)
641        at com.pivotal.gemfirexd.internal.engine.distributed.GfxdQueryStreamingResultCollector$Itr.<init>(GfxdQueryStreamingResultCollector.java:363)
642        at com.pivotal.gemfirexd.internal.engine.distributed.GfxdQueryStreamingResultCollector.iterator(GfxdQueryStreamingResultCollector.java:207)
643        at com.pivotal.gemfirexd.internal.engine.sql.execute.SnappySelectResultSet.setup(SnappySelectResultSet.java:276)
644        ... 20 more
645Caused by: java.sql.SQLTransactionRollbackException(40XL1): A lock could not be obtained within the time requested
646        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.iapi.error.StandardException.newException(StandardException.java:456)
647        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.locks.GfxdLocalLockService.getLockTimeoutException(GfxdLocalLockService.java:296)
648        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.locks.GfxdDRWLockService.getLockTimeoutException(GfxdDRWLockService.java:727)
649        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.utils.GemFireXDUtils.lockObject(GemFireXDUtils.java:1293)
650        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.catalog.GfxdDataDictionary.lockForWriting(GfxdDataDictionary.java:603)
651        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.catalog.GfxdDataDictionary.startWriting(GfxdDataDictionary.java:533)
652        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.catalog.GfxdDataDictionary.startWriting(GfxdDataDictionary.java:478)
653        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.execute.DropTableConstantAction.executeConstantAction(DropTableConstantAction.java:254)
654        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.execute.MiscResultSet.open(MiscResultSet.java:64)
655        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:593)
656        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:2159)
657        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:1283)
658        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:1005)
659        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.executeUpdate(EmbedStatement.java:502)
660        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.sources.JdbcExtendedUtils$.executeUpdate(jdbcExtensions.scala:88)
661        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.row.GemFireXDBaseDialect.dropTable(GemFireXDDialect.scala:150)
662        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.sources.JdbcExtendedUtils$.dropTable(jdbcExtensions.scala:197)
663        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.row.JDBCMutableRelation.destroy(JDBCMutableRelation.scala:291)
664        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession.dropTable(SnappySession.scala:1153)
665        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.DropTable.run(SnappyDDLParser.scala:647)
666        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.backwardcomp.ExecutedCommand.sideEffectResult$lzycompute(sparkPlans.scala:40)
667        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.backwardcomp.ExecutedCommand.sideEffectResult(sparkPlans.scala:38)
668        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.backwardcomp.ExecutedCommand.doExecute(sparkPlans.scala:54)
669        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:115)
670        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:115)
671        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:136)
672        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
673        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:133)
674        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:114)
675        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.QueryExecution.toRdd$lzycompute(QueryExecution.scala:86)
676        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.QueryExecution.toRdd(QueryExecution.scala:86)
677        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.Dataset.<init>(Dataset.scala:186)
678        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.Dataset.<init>(Dataset.scala:167)
679        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.Dataset$.ofRows(Dataset.scala:65)
680        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SparkSession.sql(SparkSession.scala:582)
681        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession.executeSQL(SnappySession.scala:166)
682        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anon$3.load(SnappySession.scala:1616)
683        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anon$3.load(SnappySession.scala:1611)
684        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3599)
685        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2379)
686        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2342)
687        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2257)
688        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache.get(LocalCache.java:4000)
689        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4004)
690        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4874)
691        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4880)
692        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$.getPlan(SnappySession.scala:1641)
693        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anonfun$sql$1.apply(SnappySession.scala:160)
694        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anonfun$sql$1.apply(SnappySession.scala:160)
695        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.aqp.SnappyContextFunctions.sql(SnappyContextFunctions.scala:91)
696        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession.sql(SnappySession.scala:160)
697        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in io.snappydata.gemxd.SparkSQLExecuteImpl.<init>(SparkSQLExecuteImpl.scala:68)
698        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in io.snappydata.gemxd.ClusterCallbacksImpl$.getSQLExecute(ClusterCallbacksImpl.scala:80)
699        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.message.LeadNodeExecutorMsg.execute(LeadNodeExecutorMsg.java:128)
700        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.message.GfxdFunctionMessage.processMessage(GfxdFunctionMessage.java:739)
701        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.GfxdMessage.basicProcess(GfxdMessage.java:406)
702        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.internal.cache.AbstractOperationMessage.process(AbstractOperationMessage.java:212)
703        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionMessage.scheduleAction(DistributionMessage.java:429)
704        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionMessage$1.run(DistributionMessage.java:501)
705        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
706        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
707        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionManager.runUntilShutdown(DistributionManager.java:728)
708        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionManager$9$1.run(DistributionManager.java:1178)
709        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in java.lang.Thread.run(Thread.java:745)
710        at com.pivotal.gemfirexd.internal.iapi.error.StandardException.fixUpRemoteException(StandardException.java:162)
711        at com.pivotal.gemfirexd.internal.engine.Misc.wrapRemoteSQLException(Misc.java:1038)
712        at com.pivotal.gemfirexd.internal.engine.Misc.processFunctionException(Misc.java:767)
713        at com.pivotal.gemfirexd.internal.engine.Misc.processFunctionException(Misc.java:753)
714        at com.pivotal.gemfirexd.internal.engine.sql.execute.SnappySelectResultSet.setup(SnappySelectResultSet.java:282)
715        ... 20 more
716Caused by: com.gemstone.gemfire.cache.LockTimeoutException: lock timeout for object: DefaultGfxdLockable@52bc4624:GfxdDataDictionary, for lock: GfxdReentrantReadWriteLock@4eb5c7d3,QSync@6c753c9f[name=GfxdDataDictionary] [readers=0], requested for owner: DistributedTXLockOwner(member=s-dcr-hdp-sl2(29918)<v3>:5552,XID=1502,ownerThread=Thread[Function Execution Processor1,10,DistributionManager Threads Interruptible],vmCreatorThread=Thread[Function Execution Processor1,10,DistributionManager Threads Interruptible])
717        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.locks.GfxdLocalLockService.getLockTimeoutRuntimeException(GfxdLocalLockService.java:291)
718        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.locks.GfxdLocalLockService.getLockTimeoutException(GfxdLocalLockService.java:297)
719        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.locks.GfxdDRWLockService.getLockTimeoutException(GfxdDRWLockService.java:727)
720        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.utils.GemFireXDUtils.lockObject(GemFireXDUtils.java:1293)
721        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.catalog.GfxdDataDictionary.lockForWriting(GfxdDataDictionary.java:603)
722        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.catalog.GfxdDataDictionary.startWriting(GfxdDataDictionary.java:533)
723        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.catalog.GfxdDataDictionary.startWriting(GfxdDataDictionary.java:478)
724        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.execute.DropTableConstantAction.executeConstantAction(DropTableConstantAction.java:254)
725        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.execute.MiscResultSet.open(MiscResultSet.java:64)
726        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:593)
727        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:2159)
728        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:1283)
729        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:1005)
730        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.impl.jdbc.EmbedStatement.executeUpdate(EmbedStatement.java:502)
731        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.sources.JdbcExtendedUtils$.executeUpdate(jdbcExtensions.scala:88)
732        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.row.GemFireXDBaseDialect.dropTable(GemFireXDDialect.scala:150)
733        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.sources.JdbcExtendedUtils$.dropTable(jdbcExtensions.scala:197)
734        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.row.JDBCMutableRelation.destroy(JDBCMutableRelation.scala:291)
735        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession.dropTable(SnappySession.scala:1153)
736        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.DropTable.run(SnappyDDLParser.scala:647)
737        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.backwardcomp.ExecutedCommand.sideEffectResult$lzycompute(sparkPlans.scala:40)
738        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.backwardcomp.ExecutedCommand.sideEffectResult(sparkPlans.scala:38)
739        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.backwardcomp.ExecutedCommand.doExecute(sparkPlans.scala:54)
740        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:115)
741        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan$$anonfun$execute$1.apply(SparkPlan.scala:115)
742        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan$$anonfun$executeQuery$1.apply(SparkPlan.scala:136)
743        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.rdd.RDDOperationScope$.withScope(RDDOperationScope.scala:151)
744        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan.executeQuery(SparkPlan.scala:133)
745        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.SparkPlan.execute(SparkPlan.scala:114)
746        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.QueryExecution.toRdd$lzycompute(QueryExecution.scala:86)
747        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.execution.QueryExecution.toRdd(QueryExecution.scala:86)
748        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.Dataset.<init>(Dataset.scala:186)
749        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.Dataset.<init>(Dataset.scala:167)
750        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.Dataset$.ofRows(Dataset.scala:65)
751        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SparkSession.sql(SparkSession.scala:582)
752        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession.executeSQL(SnappySession.scala:166)
753        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anon$3.load(SnappySession.scala:1616)
754        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anon$3.load(SnappySession.scala:1611)
755        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3599)
756        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2379)
757        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2342)
758        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2257)
759        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache.get(LocalCache.java:4000)
760        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:4004)
761        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4874)
762        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.google.common.cache.LocalCache$LocalLoadingCache.getUnchecked(LocalCache.java:4880)
763        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$.getPlan(SnappySession.scala:1641)
764        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anonfun$sql$1.apply(SnappySession.scala:160)
765        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession$$anonfun$sql$1.apply(SnappySession.scala:160)
766        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.aqp.SnappyContextFunctions.sql(SnappyContextFunctions.scala:91)
767        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in org.apache.spark.sql.SnappySession.sql(SnappySession.scala:160)
768        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in io.snappydata.gemxd.SparkSQLExecuteImpl.<init>(SparkSQLExecuteImpl.scala:68)
769        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in io.snappydata.gemxd.ClusterCallbacksImpl$.getSQLExecute(ClusterCallbacksImpl.scala:80)
770        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.message.LeadNodeExecutorMsg.execute(LeadNodeExecutorMsg.java:128)
771        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.message.GfxdFunctionMessage.processMessage(GfxdFunctionMessage.java:739)
772        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.pivotal.gemfirexd.internal.engine.distributed.GfxdMessage.basicProcess(GfxdMessage.java:406)
773        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.internal.cache.AbstractOperationMessage.process(AbstractOperationMessage.java:212)
774        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionMessage.scheduleAction(DistributionMessage.java:429)
775        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionMessage$1.run(DistributionMessage.java:501)
776        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
777        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
778        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionManager.runUntilShutdown(DistributionManager.java:728)
779        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in com.gemstone.gemfire.distributed.internal.DistributionManager$9$1.run(DistributionManager.java:1178)
780        at Remote Member 's-dcr-hdp-sl2(29918)<v3>:5552' in java.lang.Thread.run(Thread.java:745)
781
782        at io.snappydata.thrift.common.ThriftExceptionUtil.newSQLException(ThriftExceptionUtil.java:109)
783        at io.snappydata.thrift.internal.ClientPreparedStatement.execute(ClientPreparedStatement.java:220)
784        ... 34 more
785[2018-08-21 16:32:02] [INFO] End migrator. Exit code = 0
786[2018-08-21 16:32:02] [ERROR] "SnappyMigrator - Database is up to date" string not found in /usr/snappydata/services/pecom-snappy-migration/migrator.log!
787[2018-08-21 16:32:02] [ERROR] "Migrator$ - Scheme validation successed" string not found in /usr/snappydata/services/pecom-snappy-migration/migrator.log!
788[2018-08-21 16:32:02] [INFO] End script.
789[2018-08-21 16:32:02] [WARN] Exit code = 2