SQL> lb updatesql -changelog f105/controller.xml -debug -log
[{log=true, replace=false, type=, password=, enable=true, context=, grants=false, silent=false, debug=true, runalways=false, synonyms=false, emit_schema=false, count=, changelog=f105/controller.xml, label=, runonchange=false, url=, command=updatesql, fail=false, help=false, filename=, report=true, name=, privs=true, user=, isSqlCl=true}]
-- *********************************************************************
-- Update Database Script
-- *********************************************************************
-- Change Log: f105/controller.xml
-- Ran at: 6/15/21 12:02 PM
-- Against: APEX_DEV@jdbc:oracle:thin:@host.com:1522/orcl
-- Liquibase version: 4.3.1
-- *********************************************************************
-- Create Database Lock Table
CREATE TABLE APEX_DEV.DATABASECHANGELOGLOCK (ID INTEGER NOT NULL, LOCKED NUMBER(1) NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR2(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID));
-- Initialize Database Lock Table
DELETE FROM APEX_DEV.DATABASECHANGELOGLOCK;
INSERT INTO APEX_DEV.DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, 0);
-- Lock Database
UPDATE APEX_DEV.DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = 'WKS0001086738 (10.212.134.203)', LOCKGRANTED = TO_TIMESTAMP('2021-06-15 12:02:33.155', 'YYYY-MM-DD HH24:MI:SS.FF') WHERE ID = 1 AND LOCKED = 0;
-- Create Database Change Log Table
CREATE TABLE APEX_DEV.DATABASECHANGELOG (ID VARCHAR2(255) NOT NULL, AUTHOR VARCHAR2(255) NOT NULL, FILENAME VARCHAR2(255) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INTEGER NOT NULL, EXECTYPE VARCHAR2(10) NOT NULL, MD5SUM VARCHAR2(35), DESCRIPTION
VARCHAR2(255), COMMENTS VARCHAR2(255), TAG VARCHAR2(255), LIQUIBASE VARCHAR2(20), CONTEXTS VARCHAR2(255), LABELS VARCHAR2(255), DEPLOYMENT_ID VARCHAR2(10));
-- Changeset f105/application/init.xml::4ae7fde6b1280d24f6684fcfbdbe655c6015b29d::Generated
INSERT INTO APEX_DEV.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('4ae7fde6b1280d24f6684fcfbdbe655c6015b29d', 'Generated', 'f105/application/init.xml', SYSTIMESTAMP, 1, '8:d41d8cd98f00b204e9800998ecf8427e', 'empty', '', 'EXECUTED', NULL, NULL, '4.3.1', '3751351894');
-- Changeset f105/application/set_environment.xml::da94d47226b7888e60066fdc64420e40015cad00::Generated
INSERT INTO APEX_DEV.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('da94d47226b7888e60066fdc64420e40015cad00', 'Generated', 'f105/application/set_environment.xml', SYSTIMESTAMP, 2, '8:d41d8cd98f00b204e9800998ecf8427e', 'empty', '', 'EXECUTED', NULL, NULL, '4.3.1', '3751351894');
-- Changeset f105/application/ui_types.xml::56653bfe1f8280c1901a94554ae6b713c3cc1f33::Generated
INSERT INTO APEX_DEV.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('56653bfe1f8280c1901a94554ae6b713c3cc1f33', 'Generated', 'f105/application/ui_types.xml', SYSTIMESTAMP, 4, '8:d41d8cd98f00b204e9800998ecf8427e', 'empty', '', 'EXECUTED', NULL, NULL, '4.3.1', '3751351894');
-- Changeset f105/application/create_application.xml::ced3653543e3b889a75230632d71c9997f6a8033::Generated
INSERT INTO APEX_DEV.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('ced3653543e3b889a75230632d71c9997f6a8033', 'Generated', 'f105/application/create_application.xml', SYSTIMESTAMP, 5, '8:d41d8cd98f00b204e9800998ecf8427e', 'empty', '', 'EXECUTED', NULL, NULL, '4.3.1', '3751351894');
.................................................................................................................................................................................
-- Changeset f105/application/end_environment.xml::ecd82bcb4ba66b04bbef247f5d943e8dfe54e49c::Generated
INSERT INTO APEX_DEV.DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('ecd82bcb4ba66b04bbef247f5d943e8dfe54e49c', 'Generated', 'f105/application/end_environment.xml', SYSTIMESTAMP, 44, '8:d41d8cd98f00b204e9800998ecf8427e', 'empty', '', 'EXECUTED', NULL, NULL, '4.3.1', '3751351894');
-- Release Database Lock
UPDATE APEX_DEV.DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;
######## ERROR SUMMARY ##################
Errors encountered:0
SQL> lb update -changelog f105/controller.xml -debug -log[{log=true, replace=false, type=, password=, enable=true, context=, grants=false, silent=false, debug=true, runalways=false, synonyms=false, emit_schema=false, count=, changelog=f105/controller.xml, label=, runonchange=false, url=, command=update, fail=false, help=false, filename=, report=true, name=, privs=true, user=, isSqlCl=true}]
######## ERROR SUMMARY ##################
Errors encountered:0
SQL>
SQL>
SQL>
SQL> select * from DATABASECHANGELOG_ACTIONS;
no rows selected
i have tried deleting all databasechangelog tables, restarting the client, restarting the database...
IT DOES insert into DATABASECHANGELOG
SQL> select count(1) from DATABASECHANGELOG;
COUNT(1)
__________
44
But no actions are applied...
also tried diferent sqlcl versions..
This is agains a 18c database.. I think i will have to go into other direction and stop using this tool