http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/utils/dbutils/updatescripts/updatescripts-3.x-to-3.1.0.sql ---------------------------------------------------------------------- diff --git a/utils/dbutils/updatescripts/updatescripts-3.x-to-3.1.0.sql b/utils/dbutils/updatescripts/updatescripts-3.x-to-3.1.0.sql deleted file mode 100644 index 9b7a1db..0000000 --- a/utils/dbutils/updatescripts/updatescripts-3.x-to-3.1.0.sql +++ /dev/null @@ -1,20 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- -ALTER TABLE WF_ACTIONS ADD USER_RETRY_COUNT NUMBER DEFAULT 0; -ALTER TABLE WF_ACTIONS ADD USER_RETRY_MAX NUMBER DEFAULT 0; -ALTER TABLE WF_ACTIONS ADD USER_RETRY_INTERVAL NUMBER DEFAULT 0; \ No newline at end of file
http://git-wip-us.apache.org/repos/asf/oozie/blob/abb2e186/utils/dbutils/updatescripts/upgradescript-2.x-to-3.0.0.sql ---------------------------------------------------------------------- diff --git a/utils/dbutils/updatescripts/upgradescript-2.x-to-3.0.0.sql b/utils/dbutils/updatescripts/upgradescript-2.x-to-3.0.0.sql deleted file mode 100644 index 7ad0546..0000000 --- a/utils/dbutils/updatescripts/upgradescript-2.x-to-3.0.0.sql +++ /dev/null @@ -1,37 +0,0 @@ --- --- Licensed to the Apache Software Foundation (ASF) under one --- or more contributor license agreements. See the NOTICE file --- distributed with this work for additional information --- regarding copyright ownership. The ASF licenses this file --- to you under the Apache License, Version 2.0 (the --- "License"); you may not use this file except in compliance --- with the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -# please replace "OOZIEDB" to your schema name - -UPDATE OOZIEDB.COORD_JOBS -SET STATUS = 'RUNNING',PENDING = 1 -WHERE ID IN -( -SELECT JOB_ID FROM COORD_ACTIONS WHERE JOB_ID IN ( -SELECT ID FROM COORD_JOBS WHERE STATUS = 'SUCCEEDED') AND (STATUS != 'FAILED' AND -STATUS != 'SUCCEEDED' AND STATUS != 'KILLED' AND STATUS != 'TIMEDOUT') -); - -UPDATE OOZIEDB.COORD_JOBS SET STATUS = 'RUNNING' WHERE STATUS = 'PREMATER'; - -UPDATE OOZIEDB.COORD_ACTIONS -SET STATUS = 'SUSPENDED' -WHERE ID IN( -SELECT A.ID FROM COORD_ACTIONS A, WF_JOBS B WHERE A.EXTERNAL_ID = B.ID -AND B.STATUS = 'SUSPENDED' AND A.STATUS = 'RUNNING' -);