Forum Stats

  • 3,874,444 Users
  • 2,266,734 Discussions
  • 7,911,851 Comments

Discussions

lb update does not insert into DATABASECHANGELOG_ACTIONS

Agustin Conejos
Agustin Conejos Member Posts: 15 Red Ribbon

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: [email protected]: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