Oracle error on create initial project #13771

bernatvadell · 2022-06-07T16:05:03Z

Describe the Bug

When you start the project for the first time, and the migrations are executed, in ORACLE the default values are being assigned for some reason with a space at the end.

This causes that when you want to access the login, and the server/info method is invoked, it does not return the default values of the project:

{"data":{"project":{"project_color":"null ","default_language":"en-US","project_name":"Directus"}}}

I can fix, executing first time:

ALTER TABLE SECRETSYSUSER."directus_settings" MODIFY "default_language" VARCHAR2(255) DEFAULT 'en-US';
ALTER TABLE SECRETSYSUSER."directus_settings" MODIFY "project_color" VARCHAR2(50) DEFAULT null;
ALTER TABLE SECRETSYSUSER."directus_settings" MODIFY "project_name" VARCHAR2(100) DEFAULT 'Directus';

Knex output on migration pipeline executed:

Debugger attached.

> directus-oracle@1.0.0 bootstrap
> directus bootstrap

Debugger attached.
18:15:12 ✨ Initializing bootstrap...
2022-06-07T16:15:12.308Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:12.310Z knex:query select 1 from DUAL undefined
2022-06-07T16:15:12.310Z knex:bindings [] undefined
2022-06-07T16:15:12.317Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:12.321Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:12.323Z knex:query select * from (select count(*) "count" from "USER_TABLES" where "TABLE_NAME" = :1) where rownum <= :2 undefined
2022-06-07T16:15:12.323Z knex:bindings [ 'directus_collections', 1 ] undefined
2022-06-07T16:15:12.370Z knex:client releasing connection to pool: __knexUid1
18:15:12 ✨ Installing Directus system tables...
2022-06-07T16:15:12.371Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:12.372Z knex:query select TABLE_NAME from USER_TABLES where TABLE_NAME = :1 undefined
2022-06-07T16:15:12.372Z knex:bindings [ 'directus_collections' ] undefined
2022-06-07T16:15:12.469Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:12.470Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:12.473Z knex:query create table "directus_collections" ("collection" varchar2(64) not null, "icon" varchar2(30), "note" clob, "display_template" varchar2(255), "hidden" number(1, 0) default '0' not null check ("hidden" in ('0', '1')), "singleton" number(1, 0) default '0' not null check ("singleton" in ('0', '1')), "translations" varchar2(4000) check ("translations" is json), "archive_field" varchar2(64), "archive_app_filter" number(1, 0) default '1' not null check ("archive_app_filter" in ('0', '1')), "archive_value" varchar2(255), "unarchive_value" varchar2(255), "sort_field" varchar2(64)) undefined
2022-06-07T16:15:12.473Z knex:bindings [] undefined
2022-06-07T16:15:12.523Z knex:query alter table "directus_collections" add constraint "directus_collections_pkey" primary key ("collection") undefined
2022-06-07T16:15:12.524Z knex:bindings [] undefined
2022-06-07T16:15:12.553Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:12.554Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:12.555Z knex:query create table "directus_roles" ("id" char(36) not null, "name" varchar2(100) not null, "icon" varchar2(30) default 'supervised_user_circle' not null, "description" clob, "ip_access" clob, "enforce_tfa" number(1, 0) default '0' not null check ("enforce_tfa" in ('0', '1')), "module_list" varchar2(4000) check ("module_list" is json), "collection_list" varchar2(4000) check ("collection_list" is json), "admin_access" number(1, 0) default '0' not null check ("admin_access" in ('0', '1')), "app_access" number(1, 0) default '1' not null check ("app_access" in ('0', '1'))) undefined
2022-06-07T16:15:12.555Z knex:bindings [] undefined
2022-06-07T16:15:12.578Z knex:query alter table "directus_roles" add constraint "directus_roles_pkey" primary key ("id") undefined
2022-06-07T16:15:12.579Z knex:bindings [] undefined
2022-06-07T16:15:12.592Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:12.593Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:12.595Z knex:query create table "directus_users" ("id" char(36) not null, "first_name" varchar2(50), "last_name" varchar2(50), "email" varchar2(128) not null, "password" varchar2(255), "location" varchar2(255), "title" varchar2(50), "description" clob, "tags" varchar2(4000) check ("tags" is json), "avatar" char(36), "language" varchar2(8) default 'en-US', "theme" varchar2(20) default 'auto', "tfa_secret" varchar2(255), "status" varchar2(16) default 'active' not null, "role" char(36), "token" varchar2(255), "last_access" timestamp with local time zone, "last_page" varchar2(255)) undefined
2022-06-07T16:15:12.595Z knex:bindings [] undefined
2022-06-07T16:15:12.609Z knex:query alter table "directus_users" add constraint "directus_users_pkey" primary key ("id") undefined
2022-06-07T16:15:12.609Z knex:bindings [] undefined
2022-06-07T16:15:12.623Z knex:query alter table "directus_users" add constraint "directus_users_email_unique" unique ("email") undefined
2022-06-07T16:15:12.623Z knex:bindings [] undefined
2022-06-07T16:15:12.643Z knex:query alter table "directus_users" add constraint "directus_users_role_foreign" foreign key ("role") references "directus_roles" ("id") undefined
2022-06-07T16:15:12.643Z knex:bindings [] undefined
2022-06-07T16:15:12.655Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:12.656Z knex:client acquired connection from pool: __knexUid1
18:15:12 ⚠️  Automatically generated name "directus_fields_collection_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:12.658Z knex:query create table "directus_fields" ("id" integer not null primary key, "collection" varchar2(64) not null, "field" varchar2(64) not null, "special" varchar2(64), "interface" varchar2(64), "options" varchar2(4000) check ("options" is json), "display" varchar2(64), "display_options" varchar2(4000) check ("display_options" is json), "locked" number(1, 0) default '0' not null check ("locked" in ('0', '1')), "readonly" number(1, 0) default '0' not null check ("readonly" in ('0', '1')), "hidden" number(1, 0) default '0' not null check ("hidden" in ('0', '1')), "sort" integer, "width" varchar2(30) default 'full', "group" integer, "translations" varchar2(4000) check ("translations" is json), "note" clob) undefined
2022-06-07T16:15:12.658Z knex:bindings [] undefined
2022-06-07T16:15:12.680Z knex:query DECLARE PK_NAME VARCHAR(200); BEGIN  EXECUTE IMMEDIATE ('CREATE SEQUENCE "directus_fields_seq"');  SELECT cols.column_name INTO PK_NAME  FROM all_constraints cons, all_cons_columns cols  WHERE cons.constraint_type = 'P'  AND cons.constraint_name = cols.constraint_name  AND cons.owner = cols.owner  AND cols.table_name = 'directus_fields';  execute immediate ('create or replace trigger "directus_fields_autoinc_trg"  BEFORE INSERT on "directus_fields"  for each row  declare  checking number := 1;  begin    if (:new."' || PK_NAME || '" is null) then      while checking >= 1 loop        select "directus_fields_seq".nextval into :new."' || PK_NAME || '" from dual;        select count("' || PK_NAME || '") into checking from "directus_fields"        where "' || PK_NAME || '" = :new."' || PK_NAME || '";      end loop;    end if;  end;'); END; undefined
2022-06-07T16:15:12.680Z knex:bindings [] undefined
2022-06-07T16:15:12.873Z knex:query alter table "directus_fields" add constraint "LGlJQDaU7IoF0K6MgRPzpiN0Nl0" foreign key ("collection") references "directus_collections" ("collection") undefined
2022-06-07T16:15:12.873Z knex:bindings [] undefined
2022-06-07T16:15:12.885Z knex:query alter table "directus_fields" add constraint "directus_fields_group_foreign" foreign key ("group") references "directus_fields" ("id") undefined
2022-06-07T16:15:12.885Z knex:bindings [] undefined
2022-06-07T16:15:12.896Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:12.898Z knex:client acquired connection from pool: __knexUid1
18:15:12 ⚠️  Automatically generated name "directus_activity_collection_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:12.899Z knex:query create table "directus_activity" ("id" integer not null primary key, "action" varchar2(45) not null, "user" char(36), "timestamp" timestamp with local time zone default CURRENT_TIMESTAMP not null, "ip" varchar2(50) not null, "user_agent" varchar2(255), "collection" varchar2(64) not null, "item" varchar2(255) not null, "comment" clob) undefined
2022-06-07T16:15:12.899Z knex:bindings [] undefined
2022-06-07T16:15:12.918Z knex:query DECLARE PK_NAME VARCHAR(200); BEGIN  EXECUTE IMMEDIATE ('CREATE SEQUENCE "directus_activity_seq"');  SELECT cols.column_name INTO PK_NAME  FROM all_constraints cons, all_cons_columns cols  WHERE cons.constraint_type = 'P'  AND cons.constraint_name = cols.constraint_name  AND cons.owner = cols.owner  AND cols.table_name = 'directus_activity';  execute immediate ('create or replace trigger "directus_activity_autoinc_trg"  BEFORE INSERT on "directus_activity"  for each row  declare  checking number := 1;  begin    if (:new."' || PK_NAME || '" is null) then      while checking >= 1 loop        select "directus_activity_seq".nextval into :new."' || PK_NAME || '" from dual;        select count("' || PK_NAME || '") into checking from "directus_activity"        where "' || PK_NAME || '" = :new."' || PK_NAME || '";      end loop;    end if;  end;'); END; undefined
2022-06-07T16:15:12.918Z knex:bindings [] undefined
2022-06-07T16:15:13.057Z knex:query alter table "directus_activity" add constraint "pUDT7XybuTZJNFEyAATWWAiUpgk" foreign key ("collection") references "directus_collections" ("collection") undefined
2022-06-07T16:15:13.057Z knex:bindings [] undefined
2022-06-07T16:15:13.067Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:13.068Z knex:client acquired connection from pool: __knexUid1
18:15:13 ⚠️  Automatically generated name "directus_folders_parent_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:13.069Z knex:query create table "directus_folders" ("id" char(36) not null, "name" varchar2(255) not null, "parent" char(36)) undefined
2022-06-07T16:15:13.069Z knex:bindings [] undefined
2022-06-07T16:15:13.099Z knex:query alter table "directus_folders" add constraint "directus_folders_pkey" primary key ("id") undefined
2022-06-07T16:15:13.099Z knex:bindings [] undefined
2022-06-07T16:15:13.132Z knex:query alter table "directus_folders" add constraint "kImEAqYVsLg20GPIfbitsy29KDw" foreign key ("parent") references "directus_folders" ("id") undefined
2022-06-07T16:15:13.133Z knex:bindings [] undefined
2022-06-07T16:15:13.143Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:13.145Z knex:client acquired connection from pool: __knexUid1
18:15:13 ⚠️  Automatically generated name "directus_files_uploaded_by_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:13 ⚠️  Automatically generated name "directus_files_modified_by_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:13.146Z knex:query create table "directus_files" ("id" char(36) not null, "storage" varchar2(255) not null, "filename_disk" varchar2(255), "filename_download" varchar2(255) not null, "title" varchar2(255), "type" varchar2(255), "folder" char(36), "uploaded_by" char(36), "uploaded_on" timestamp with local time zone default CURRENT_TIMESTAMP not null, "modified_by" char(36), "modified_on" timestamp with local time zone default CURRENT_TIMESTAMP not null, "charset" varchar2(50), "filesize" integer default '0' not null, "width" integer, "height" integer, "duration" integer, "embed" varchar2(200), "description" clob, "location" clob, "tags" clob, "metadata" varchar2(4000) check ("metadata" is json)) undefined
2022-06-07T16:15:13.146Z knex:bindings [] undefined
2022-06-07T16:15:13.278Z knex:query alter table "directus_files" add constraint "directus_files_pkey" primary key ("id") undefined
2022-06-07T16:15:13.279Z knex:bindings [] undefined
2022-06-07T16:15:13.325Z knex:query alter table "directus_files" add constraint "directus_files_folder_foreign" foreign key ("folder") references "directus_folders" ("id") undefined
2022-06-07T16:15:13.325Z knex:bindings [] undefined
2022-06-07T16:15:13.358Z knex:query alter table "directus_files" add constraint "TKKj3qiUE18a0/06um4eEiNyke8" foreign key ("uploaded_by") references "directus_users" ("id") undefined
2022-06-07T16:15:13.358Z knex:bindings [] undefined
2022-06-07T16:15:13.371Z knex:query alter table "directus_files" add constraint "mZTfetyKG+WvvZuUcDtvxBYhD4k" foreign key ("modified_by") references "directus_users" ("id") undefined
2022-06-07T16:15:13.371Z knex:bindings [] undefined
2022-06-07T16:15:13.382Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:13.383Z knex:client acquired connection from pool: __knexUid1
18:15:13 ⚠️  Automatically generated name "directus_permissions_autoinc_trg" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:13 ⚠️  Automatically generated name "directus_permissions_role_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:13 ⚠️  Automatically generated name "directus_permissions_collection_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:13.384Z knex:query create table "directus_permissions" ("id" integer not null primary key, "role" char(36), "collection" varchar2(64) not null, "action" varchar2(10) not null, "permissions" varchar2(4000) check ("permissions" is json), "validation" varchar2(4000) check ("validation" is json), "presets" varchar2(4000) check ("presets" is json), "fields" clob, "limit" integer) undefined
2022-06-07T16:15:13.384Z knex:bindings [] undefined
2022-06-07T16:15:13.464Z knex:query DECLARE PK_NAME VARCHAR(200); BEGIN  EXECUTE IMMEDIATE ('CREATE SEQUENCE "directus_permissions_seq"');  SELECT cols.column_name INTO PK_NAME  FROM all_constraints cons, all_cons_columns cols  WHERE cons.constraint_type = 'P'  AND cons.constraint_name = cols.constraint_name  AND cons.owner = cols.owner  AND cols.table_name = 'directus_permissions';  execute immediate ('create or replace trigger "algbJ4xOpQFxBVZuDnvBxmpXW+Y"  BEFORE INSERT on "directus_permissions"  for each row  declare  checking number := 1;  begin    if (:new."' || PK_NAME || '" is null) then      while checking >= 1 loop        select "directus_permissions_seq".nextval into :new."' || PK_NAME || '" from dual;        select count("' || PK_NAME || '") into checking from "directus_permissions"        where "' || PK_NAME || '" = :new."' || PK_NAME || '";      end loop;    end if;  end;'); END; undefined
2022-06-07T16:15:13.464Z knex:bindings [] undefined
2022-06-07T16:15:13.607Z knex:query alter table "directus_permissions" add constraint "b0MEIbON78xw+8mvKvN5Y4uJ+/c" foreign key ("role") references "directus_roles" ("id") undefined
2022-06-07T16:15:13.608Z knex:bindings [] undefined
2022-06-07T16:15:13.620Z knex:query alter table "directus_permissions" add constraint "VoOI34dBmFAJOm2lRIIVriSvxdY" foreign key ("collection") references "directus_collections" ("collection") undefined
2022-06-07T16:15:13.620Z knex:bindings [] undefined
2022-06-07T16:15:13.631Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:13.632Z knex:client acquired connection from pool: __knexUid1
18:15:13 ⚠️  Automatically generated name "directus_presets_collection_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:13.633Z knex:query create table "directus_presets" ("id" integer not null primary key, "bookmark" varchar2(255), "user" char(36), "role" char(36), "collection" varchar2(64), "search" varchar2(100), "filters" varchar2(4000) check ("filters" is json), "layout" varchar2(100) default 'tabular', "layout_query" varchar2(4000) check ("layout_query" is json), "layout_options" varchar2(4000) check ("layout_options" is json)) undefined
2022-06-07T16:15:13.633Z knex:bindings [] undefined
2022-06-07T16:15:13.678Z knex:query DECLARE PK_NAME VARCHAR(200); BEGIN  EXECUTE IMMEDIATE ('CREATE SEQUENCE "directus_presets_seq"');  SELECT cols.column_name INTO PK_NAME  FROM all_constraints cons, all_cons_columns cols  WHERE cons.constraint_type = 'P'  AND cons.constraint_name = cols.constraint_name  AND cons.owner = cols.owner  AND cols.table_name = 'directus_presets';  execute immediate ('create or replace trigger "directus_presets_autoinc_trg"  BEFORE INSERT on "directus_presets"  for each row  declare  checking number := 1;  begin    if (:new."' || PK_NAME || '" is null) then      while checking >= 1 loop        select "directus_presets_seq".nextval into :new."' || PK_NAME || '" from dual;        select count("' || PK_NAME || '") into checking from "directus_presets"        where "' || PK_NAME || '" = :new."' || PK_NAME || '";      end loop;    end if;  end;'); END; undefined
2022-06-07T16:15:13.679Z knex:bindings [] undefined
2022-06-07T16:15:13.830Z knex:query alter table "directus_presets" add constraint "directus_presets_user_foreign" foreign key ("user") references "directus_users" ("id") undefined
2022-06-07T16:15:13.831Z knex:bindings [] undefined
2022-06-07T16:15:13.843Z knex:query alter table "directus_presets" add constraint "directus_presets_role_foreign" foreign key ("role") references "directus_roles" ("id") undefined
2022-06-07T16:15:13.843Z knex:bindings [] undefined
2022-06-07T16:15:13.854Z knex:query alter table "directus_presets" add constraint "2lBqSd2rgZglyl6o//f/PKt7C+4" foreign key ("collection") references "directus_collections" ("collection") undefined
2022-06-07T16:15:13.854Z knex:bindings [] undefined
2022-06-07T16:15:13.866Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:13.867Z knex:client acquired connection from pool: __knexUid1
18:15:13 ⚠️  Automatically generated name "directus_relations_many_collection_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:13 ⚠️  Automatically generated name "directus_relations_one_collection_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:13.868Z knex:query create table "directus_relations" ("id" integer not null primary key, "many_collection" varchar2(64) not null, "many_field" varchar2(64) not null, "many_primary" varchar2(64) not null, "one_collection" varchar2(64), "one_field" varchar2(64), "one_primary" varchar2(64), "one_collection_field" varchar2(64), "one_allowed_collections" clob, "junction_field" varchar2(64)) undefined
2022-06-07T16:15:13.868Z knex:bindings [] undefined
2022-06-07T16:15:13.957Z knex:query DECLARE PK_NAME VARCHAR(200); BEGIN  EXECUTE IMMEDIATE ('CREATE SEQUENCE "directus_relations_seq"');  SELECT cols.column_name INTO PK_NAME  FROM all_constraints cons, all_cons_columns cols  WHERE cons.constraint_type = 'P'  AND cons.constraint_name = cols.constraint_name  AND cons.owner = cols.owner  AND cols.table_name = 'directus_relations';  execute immediate ('create or replace trigger "directus_relations_autoinc_trg"  BEFORE INSERT on "directus_relations"  for each row  declare  checking number := 1;  begin    if (:new."' || PK_NAME || '" is null) then      while checking >= 1 loop        select "directus_relations_seq".nextval into :new."' || PK_NAME || '" from dual;        select count("' || PK_NAME || '") into checking from "directus_relations"        where "' || PK_NAME || '" = :new."' || PK_NAME || '";      end loop;    end if;  end;'); END; undefined
2022-06-07T16:15:13.957Z knex:bindings [] undefined
2022-06-07T16:15:14.096Z knex:query alter table "directus_relations" add constraint "Tgv0EOuZ1AtTmPhZYq2WDowez40" foreign key ("many_collection") references "directus_collections" ("collection") undefined
2022-06-07T16:15:14.096Z knex:bindings [] undefined
2022-06-07T16:15:14.107Z knex:query alter table "directus_relations" add constraint "qWvyy5s/Alp3vMlLPGZnJTyChPo" foreign key ("one_collection") references "directus_collections" ("collection") undefined
2022-06-07T16:15:14.107Z knex:bindings [] undefined
2022-06-07T16:15:14.118Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:14.119Z knex:client acquired connection from pool: __knexUid1
18:15:14 ⚠️  Automatically generated name "directus_revisions_activity_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:14 ⚠️  Automatically generated name "directus_revisions_collection_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:14 ⚠️  Automatically generated name "directus_revisions_parent_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:14.121Z knex:query create table "directus_revisions" ("id" integer not null primary key, "activity" integer not null, "collection" varchar2(64) not null, "item" varchar2(255) not null, "data" varchar2(4000) check ("data" is json), "delta" varchar2(4000) check ("delta" is json), "parent" integer) undefined
2022-06-07T16:15:14.121Z knex:bindings [] undefined
2022-06-07T16:15:14.175Z knex:query DECLARE PK_NAME VARCHAR(200); BEGIN  EXECUTE IMMEDIATE ('CREATE SEQUENCE "directus_revisions_seq"');  SELECT cols.column_name INTO PK_NAME  FROM all_constraints cons, all_cons_columns cols  WHERE cons.constraint_type = 'P'  AND cons.constraint_name = cols.constraint_name  AND cons.owner = cols.owner  AND cols.table_name = 'directus_revisions';  execute immediate ('create or replace trigger "directus_revisions_autoinc_trg"  BEFORE INSERT on "directus_revisions"  for each row  declare  checking number := 1;  begin    if (:new."' || PK_NAME || '" is null) then      while checking >= 1 loop        select "directus_revisions_seq".nextval into :new."' || PK_NAME || '" from dual;        select count("' || PK_NAME || '") into checking from "directus_revisions"        where "' || PK_NAME || '" = :new."' || PK_NAME || '";      end loop;    end if;  end;'); END; undefined
2022-06-07T16:15:14.176Z knex:bindings [] undefined
2022-06-07T16:15:14.312Z knex:query alter table "directus_revisions" add constraint "nCTcIkb8L+ktcIMKh8lknbnQOBI" foreign key ("activity") references "directus_activity" ("id") undefined
2022-06-07T16:15:14.312Z knex:bindings [] undefined
2022-06-07T16:15:14.325Z knex:query alter table "directus_revisions" add constraint "gEE5PfVGYOYPAFzJmtTI1770C/Y" foreign key ("collection") references "directus_collections" ("collection") undefined
2022-06-07T16:15:14.325Z knex:bindings [] undefined
2022-06-07T16:15:14.337Z knex:query alter table "directus_revisions" add constraint "W77KLEbo73Wh/5LMcEoMmxkKs6A" foreign key ("parent") references "directus_revisions" ("id") undefined
2022-06-07T16:15:14.337Z knex:bindings [] undefined
2022-06-07T16:15:14.348Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:14.349Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:14.349Z knex:query create table "directus_sessions" ("token" varchar2(64) not null, "user" char(36) not null, "expires" timestamp with local time zone not null, "ip" varchar2(255), "user_agent" varchar2(255)) undefined
2022-06-07T16:15:14.349Z knex:bindings [] undefined
2022-06-07T16:15:14.376Z knex:query alter table "directus_sessions" add constraint "directus_sessions_pkey" primary key ("token") undefined
2022-06-07T16:15:14.376Z knex:bindings [] undefined
2022-06-07T16:15:14.404Z knex:query alter table "directus_sessions" add constraint "directus_sessions_user_foreign" foreign key ("user") references "directus_users" ("id") undefined
2022-06-07T16:15:14.404Z knex:bindings [] undefined
2022-06-07T16:15:14.415Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:14.416Z knex:client acquired connection from pool: __knexUid1
18:15:14 ⚠️  Automatically generated name "directus_settings_project_logo_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:14 ⚠️  Automatically generated name "directus_settings_public_foreground_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:14 ⚠️  Automatically generated name "directus_settings_public_background_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:14.418Z knex:query create table "directus_settings" ("id" integer not null primary key, "project_name" varchar2(100) default 'Directus' not null, "project_url" varchar2(255), "project_color" varchar2(10) default '#00C897', "project_logo" char(36), "public_foreground" char(36), "public_background" char(36), "public_note" clob, "auth_login_attempts" integer default '25', "auth_password_policy" varchar2(100), "storage_asset_transform" varchar2(7) default 'all', "storage_asset_presets" varchar2(4000) check ("storage_asset_presets" is json), "custom_css" clob) undefined
2022-06-07T16:15:14.418Z knex:bindings [] undefined
2022-06-07T16:15:14.549Z knex:query DECLARE PK_NAME VARCHAR(200); BEGIN  EXECUTE IMMEDIATE ('CREATE SEQUENCE "directus_settings_seq"');  SELECT cols.column_name INTO PK_NAME  FROM all_constraints cons, all_cons_columns cols  WHERE cons.constraint_type = 'P'  AND cons.constraint_name = cols.constraint_name  AND cons.owner = cols.owner  AND cols.table_name = 'directus_settings';  execute immediate ('create or replace trigger "directus_settings_autoinc_trg"  BEFORE INSERT on "directus_settings"  for each row  declare  checking number := 1;  begin    if (:new."' || PK_NAME || '" is null) then      while checking >= 1 loop        select "directus_settings_seq".nextval into :new."' || PK_NAME || '" from dual;        select count("' || PK_NAME || '") into checking from "directus_settings"        where "' || PK_NAME || '" = :new."' || PK_NAME || '";      end loop;    end if;  end;'); END; undefined
2022-06-07T16:15:14.549Z knex:bindings [] undefined
2022-06-07T16:15:14.706Z knex:query alter table "directus_settings" add constraint "BFvOPViBJta32GAWEosAaxN1BzA" foreign key ("project_logo") references "directus_files" ("id") undefined
2022-06-07T16:15:14.706Z knex:bindings [] undefined
2022-06-07T16:15:14.719Z knex:query alter table "directus_settings" add constraint "OsyXgngFJmtq9B+fW1OSUTMaAUA" foreign key ("public_foreground") references "directus_files" ("id") undefined
2022-06-07T16:15:14.719Z knex:bindings [] undefined
2022-06-07T16:15:14.729Z knex:query alter table "directus_settings" add constraint "g8Mr8lh/J6qE8W0/k/zyAr8/fGo" foreign key ("public_background") references "directus_files" ("id") undefined
2022-06-07T16:15:14.729Z knex:bindings [] undefined
2022-06-07T16:15:14.740Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:14.741Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:14.742Z knex:query create table "directus_webhooks" ("id" integer not null primary key, "name" varchar2(255) not null, "method" varchar2(10) default 'POST' not null, "url" varchar2(255) not null, "status" varchar2(10) default 'active' not null, "data" number(1, 0) default '1' not null check ("data" in ('0', '1')), "actions" varchar2(100) not null, "collections" varchar2(255) not null) undefined
2022-06-07T16:15:14.742Z knex:bindings [] undefined
2022-06-07T16:15:14.792Z knex:query DECLARE PK_NAME VARCHAR(200); BEGIN  EXECUTE IMMEDIATE ('CREATE SEQUENCE "directus_webhooks_seq"');  SELECT cols.column_name INTO PK_NAME  FROM all_constraints cons, all_cons_columns cols  WHERE cons.constraint_type = 'P'  AND cons.constraint_name = cols.constraint_name  AND cons.owner = cols.owner  AND cols.table_name = 'directus_webhooks';  execute immediate ('create or replace trigger "directus_webhooks_autoinc_trg"  BEFORE INSERT on "directus_webhooks"  for each row  declare  checking number := 1;  begin    if (:new."' || PK_NAME || '" is null) then      while checking >= 1 loop        select "directus_webhooks_seq".nextval into :new."' || PK_NAME || '" from dual;        select count("' || PK_NAME || '") into checking from "directus_webhooks"        where "' || PK_NAME || '" = :new."' || PK_NAME || '";      end loop;    end if;  end;'); END; undefined
2022-06-07T16:15:14.792Z knex:bindings [] undefined
2022-06-07T16:15:14.933Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:14.934Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:14.934Z knex:query create table "directus_migrations" ("version" varchar2(255) not null, "name" varchar2(255) not null, "timestamp" timestamp with local time zone default CURRENT_TIMESTAMP) undefined
2022-06-07T16:15:14.934Z knex:bindings [] undefined
2022-06-07T16:15:14.960Z knex:query alter table "directus_migrations" add constraint "directus_migrations_pkey" primary key ("version") undefined
2022-06-07T16:15:14.961Z knex:bindings [] undefined
2022-06-07T16:15:14.986Z knex:client releasing connection to pool: __knexUid1
18:15:14 ✨ Running migrations...
2022-06-07T16:15:14.987Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:14.988Z knex:query select * from "directus_migrations" order by "version" asc undefined
2022-06-07T16:15:14.988Z knex:bindings [] undefined
2022-06-07T16:15:15.004Z knex:client releasing connection to pool: __knexUid1
18:15:15 ✨ Applying Remove Collection Foreign Keys...
2022-06-07T16:15:15.007Z knex:client acquired connection from pool: __knexUid1
18:15:15 ⚠️  Automatically generated name "directus_fields_collection_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:15.008Z knex:query alter table "directus_fields" drop constraint "LGlJQDaU7IoF0K6MgRPzpiN0Nl0" undefined
2022-06-07T16:15:15.008Z knex:bindings [] undefined
2022-06-07T16:15:15.024Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:15.025Z knex:client acquired connection from pool: __knexUid1
18:15:15 ⚠️  Automatically generated name "directus_activity_collection_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:15.025Z knex:query alter table "directus_activity" drop constraint "pUDT7XybuTZJNFEyAATWWAiUpgk" undefined
2022-06-07T16:15:15.025Z knex:bindings [] undefined
2022-06-07T16:15:15.034Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:15.035Z knex:client acquired connection from pool: __knexUid1
18:15:15 ⚠️  Automatically generated name "directus_permissions_collection_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:15.035Z knex:query alter table "directus_permissions" drop constraint "VoOI34dBmFAJOm2lRIIVriSvxdY" undefined
2022-06-07T16:15:15.035Z knex:bindings [] undefined
2022-06-07T16:15:15.045Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:15.045Z knex:client acquired connection from pool: __knexUid1
18:15:15 ⚠️  Automatically generated name "directus_presets_collection_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:15.045Z knex:query alter table "directus_presets" drop constraint "2lBqSd2rgZglyl6o//f/PKt7C+4" undefined
2022-06-07T16:15:15.045Z knex:bindings [] undefined
2022-06-07T16:15:15.053Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:15.053Z knex:client acquired connection from pool: __knexUid1
18:15:15 ⚠️  Automatically generated name "directus_relations_one_collection_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:15 ⚠️  Automatically generated name "directus_relations_many_collection_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:15.054Z knex:query alter table "directus_relations" drop constraint "qWvyy5s/Alp3vMlLPGZnJTyChPo" undefined
2022-06-07T16:15:15.054Z knex:bindings [] undefined
2022-06-07T16:15:15.064Z knex:query alter table "directus_relations" drop constraint "Tgv0EOuZ1AtTmPhZYq2WDowez40" undefined
2022-06-07T16:15:15.064Z knex:bindings [] undefined
2022-06-07T16:15:15.072Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:15.073Z knex:client acquired connection from pool: __knexUid1
18:15:15 ⚠️  Automatically generated name "directus_revisions_collection_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:15.073Z knex:query alter table "directus_revisions" drop constraint "gEE5PfVGYOYPAFzJmtTI1770C/Y" undefined
2022-06-07T16:15:15.073Z knex:bindings [] undefined
2022-06-07T16:15:15.082Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:15.082Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:15.083Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:15.083Z knex:bindings [ 'Remove Collection Foreign Keys', '20201028A' ] undefined
2022-06-07T16:15:15.090Z knex:client releasing connection to pool: __knexUid1
18:15:15 ✨ Applying Remove System Relations...
2022-06-07T16:15:15.091Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:15.091Z knex:query delete from "directus_relations" where "many_collection" like :1 and "one_collection" like :2 undefined
2022-06-07T16:15:15.091Z knex:bindings [ 'directus_%', 'directus_%' ] undefined
2022-06-07T16:15:15.103Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:15.103Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:15.104Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:15.104Z knex:bindings [ 'Remove System Relations', '20201029A' ] undefined
2022-06-07T16:15:15.109Z knex:client releasing connection to pool: __knexUid1
18:15:15 ✨ Applying Remove System Collections...
2022-06-07T16:15:15.110Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:15.110Z knex:query delete from "directus_collections" where "collection" like :1 undefined
2022-06-07T16:15:15.110Z knex:bindings [ 'directus_%' ] undefined
2022-06-07T16:15:15.124Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:15.125Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:15.125Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:15.125Z knex:bindings [ 'Remove System Collections', '20201029B' ] undefined
2022-06-07T16:15:15.129Z knex:client releasing connection to pool: __knexUid1
18:15:15 ✨ Applying Remove System Fields...
2022-06-07T16:15:15.133Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:15.134Z knex:query delete from "directus_fields" where "collection" like :1 and "field" in (:2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94) undefined
2022-06-07T16:15:15.134Z knex:bindings [
  'directus_%',
  'collection_divider',
  'collection',
  'icon',
  'note',
  'display_template',
  'hidden',
  'singleton',
  'translations',
  'archive_divider',
  'archive_field',
  'archive_app_filter',
  'archive_value',
  'unarchive_value',
  'sort_divider',
  'sort_field',
  'id',
  'name',
  'description',
  'app_access',
  'admin_access',
  'ip_access',
  'enforce_tfa',
  'users',
  'module_list',
  'collection_list',
  'options',
  'display_options',
  'locked',
  'readonly',
  'special',
  'first_name',
  'last_name',
  'email',
  'password',
  'avatar',
  'location',
  'title',
  'tags',
  'preferences_divider',
  'language',
  'theme',
  'tfa_secret',
  'admin_divider',
  'status',
  'role',
  'token',
  'storage',
  'storage_divider',
  'filename_disk',
  'filename_download',
  'metadata',
  'type',
  'filesize',
  'modified_by',
  'modified_on',
  'created_on',
  'created_by',
  'permissions',
  'presets',
  'filters',
  'layout_query',
  'layout_options',
  'data',
  'delta',
  'project_name',
  'project_url',
  'project_color',
  'project_logo',
  'public_divider',
  'public_foreground',
  'public_background',
  'public_note',
  'security_divider',
  'auth_password_policy',
  'auth_login_attempts',
  'files_divider',
  'storage_asset_presets',
  'storage_asset_transform',
  'overrides_divider',
  'custom_css',
  'method',
  'url',
  'triggers_divider',
  'actions',
  'collections',
  'action',
  'timestamp',
  'user',
  'comment',
  'user_agent',
  'ip',
  'revisions',
  'one_allowed_collections'
] undefined
2022-06-07T16:15:15.152Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:15.153Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:15.153Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:15.153Z knex:bindings [ 'Remove System Fields', '20201029C' ] undefined
2022-06-07T16:15:15.158Z knex:client releasing connection to pool: __knexUid1
18:15:15 ✨ Applying Add Cascade System Relations...
2022-06-07T16:15:15.159Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:15.159Z knex:query alter table "directus_fields" drop constraint "directus_fields_group_foreign" undefined
2022-06-07T16:15:15.159Z knex:bindings [] undefined
2022-06-07T16:15:15.166Z knex:query alter table "directus_fields" add constraint "directus_fields_group_foreign" foreign key ("group") references "directus_fields" ("id") undefined
2022-06-07T16:15:15.166Z knex:bindings [] undefined
2022-06-07T16:15:15.178Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:15.179Z knex:client acquired connection from pool: __knexUid1
18:15:15 ⚠️  Automatically generated name "directus_files_uploaded_by_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:15 ⚠️  Automatically generated name "directus_files_uploaded_by_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:15 ⚠️  Automatically generated name "directus_files_modified_by_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:15 ⚠️  Automatically generated name "directus_files_modified_by_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:15.180Z knex:query alter table "directus_files" drop constraint "directus_files_folder_foreign" undefined
2022-06-07T16:15:15.180Z knex:bindings [] undefined
2022-06-07T16:15:15.190Z knex:query alter table "directus_files" add constraint "directus_files_folder_foreign" foreign key ("folder") references "directus_folders" ("id") undefined
2022-06-07T16:15:15.190Z knex:bindings [] undefined
2022-06-07T16:15:15.203Z knex:query alter table "directus_files" drop constraint "TKKj3qiUE18a0/06um4eEiNyke8" undefined
2022-06-07T16:15:15.203Z knex:bindings [] undefined
2022-06-07T16:15:15.212Z knex:query alter table "directus_files" add constraint "TKKj3qiUE18a0/06um4eEiNyke8" foreign key ("uploaded_by") references "directus_users" ("id") undefined
2022-06-07T16:15:15.212Z knex:bindings [] undefined
2022-06-07T16:15:15.226Z knex:query alter table "directus_files" drop constraint "mZTfetyKG+WvvZuUcDtvxBYhD4k" undefined
2022-06-07T16:15:15.226Z knex:bindings [] undefined
2022-06-07T16:15:15.235Z knex:query alter table "directus_files" add constraint "mZTfetyKG+WvvZuUcDtvxBYhD4k" foreign key ("modified_by") references "directus_users" ("id") undefined
2022-06-07T16:15:15.235Z knex:bindings [] undefined
2022-06-07T16:15:15.246Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:15.246Z knex:client acquired connection from pool: __knexUid1
18:15:15 ⚠️  Automatically generated name "directus_folders_parent_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:15 ⚠️  Automatically generated name "directus_folders_parent_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:15.246Z knex:query alter table "directus_folders" drop constraint "kImEAqYVsLg20GPIfbitsy29KDw" undefined
2022-06-07T16:15:15.247Z knex:bindings [] undefined
2022-06-07T16:15:15.256Z knex:query alter table "directus_folders" add constraint "kImEAqYVsLg20GPIfbitsy29KDw" foreign key ("parent") references "directus_folders" ("id") undefined
2022-06-07T16:15:15.256Z knex:bindings [] undefined
2022-06-07T16:15:15.272Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:15.272Z knex:client acquired connection from pool: __knexUid1
18:15:15 ⚠️  Automatically generated name "directus_permissions_role_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:15 ⚠️  Automatically generated name "directus_permissions_role_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:15.273Z knex:query alter table "directus_permissions" drop constraint "b0MEIbON78xw+8mvKvN5Y4uJ+/c" undefined
2022-06-07T16:15:15.273Z knex:bindings [] undefined
2022-06-07T16:15:15.283Z knex:query alter table "directus_permissions" add constraint "b0MEIbON78xw+8mvKvN5Y4uJ+/c" foreign key ("role") references "directus_roles" ("id") undefined
2022-06-07T16:15:15.283Z knex:bindings [] undefined
2022-06-07T16:15:15.297Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:15.297Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:15.297Z knex:query alter table "directus_presets" drop constraint "directus_presets_user_foreign" undefined
2022-06-07T16:15:15.297Z knex:bindings [] undefined
2022-06-07T16:15:15.305Z knex:query alter table "directus_presets" add constraint "directus_presets_user_foreign" foreign key ("user") references "directus_users" ("id") undefined
2022-06-07T16:15:15.306Z knex:bindings [] undefined
2022-06-07T16:15:15.318Z knex:query alter table "directus_presets" drop constraint "directus_presets_role_foreign" undefined
2022-06-07T16:15:15.318Z knex:bindings [] undefined
2022-06-07T16:15:15.327Z knex:query alter table "directus_presets" add constraint "directus_presets_role_foreign" foreign key ("role") references "directus_roles" ("id") undefined
2022-06-07T16:15:15.327Z knex:bindings [] undefined
2022-06-07T16:15:15.339Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:15.339Z knex:client acquired connection from pool: __knexUid1
18:15:15 ⚠️  Automatically generated name "directus_revisions_activity_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:15 ⚠️  Automatically generated name "directus_revisions_activity_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:15 ⚠️  Automatically generated name "directus_revisions_parent_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:15 ⚠️  Automatically generated name "directus_revisions_parent_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:15.339Z knex:query alter table "directus_revisions" drop constraint "nCTcIkb8L+ktcIMKh8lknbnQOBI" undefined
2022-06-07T16:15:15.340Z knex:bindings [] undefined
2022-06-07T16:15:15.349Z knex:query alter table "directus_revisions" add constraint "nCTcIkb8L+ktcIMKh8lknbnQOBI" foreign key ("activity") references "directus_activity" ("id") undefined
2022-06-07T16:15:15.349Z knex:bindings [] undefined
2022-06-07T16:15:15.362Z knex:query alter table "directus_revisions" drop constraint "W77KLEbo73Wh/5LMcEoMmxkKs6A" undefined
2022-06-07T16:15:15.363Z knex:bindings [] undefined
2022-06-07T16:15:15.371Z knex:query alter table "directus_revisions" add constraint "W77KLEbo73Wh/5LMcEoMmxkKs6A" foreign key ("parent") references "directus_revisions" ("id") undefined
2022-06-07T16:15:15.371Z knex:bindings [] undefined
2022-06-07T16:15:15.384Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:15.384Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:15.384Z knex:query alter table "directus_sessions" drop constraint "directus_sessions_user_foreign" undefined
2022-06-07T16:15:15.384Z knex:bindings [] undefined
2022-06-07T16:15:15.393Z knex:query alter table "directus_sessions" add constraint "directus_sessions_user_foreign" foreign key ("user") references "directus_users" ("id") undefined
2022-06-07T16:15:15.393Z knex:bindings [] undefined
2022-06-07T16:15:15.404Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:15.404Z knex:client acquired connection from pool: __knexUid1
18:15:15 ⚠️  Automatically generated name "directus_settings_project_logo_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:15 ⚠️  Automatically generated name "directus_settings_project_logo_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:15 ⚠️  Automatically generated name "directus_settings_public_foreground_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:15 ⚠️  Automatically generated name "directus_settings_public_foreground_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:15 ⚠️  Automatically generated name "directus_settings_public_background_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:15 ⚠️  Automatically generated name "directus_settings_public_background_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:15.405Z knex:query alter table "directus_settings" drop constraint "BFvOPViBJta32GAWEosAaxN1BzA" undefined
2022-06-07T16:15:15.405Z knex:bindings [] undefined
2022-06-07T16:15:15.415Z knex:query alter table "directus_settings" add constraint "BFvOPViBJta32GAWEosAaxN1BzA" foreign key ("project_logo") references "directus_files" ("id") undefined
2022-06-07T16:15:15.415Z knex:bindings [] undefined
2022-06-07T16:15:15.429Z knex:query alter table "directus_settings" drop constraint "OsyXgngFJmtq9B+fW1OSUTMaAUA" undefined
2022-06-07T16:15:15.429Z knex:bindings [] undefined
2022-06-07T16:15:15.438Z knex:query alter table "directus_settings" add constraint "OsyXgngFJmtq9B+fW1OSUTMaAUA" foreign key ("public_foreground") references "directus_files" ("id") undefined
2022-06-07T16:15:15.438Z knex:bindings [] undefined
2022-06-07T16:15:15.450Z knex:query alter table "directus_settings" drop constraint "g8Mr8lh/J6qE8W0/k/zyAr8/fGo" undefined
2022-06-07T16:15:15.451Z knex:bindings [] undefined
2022-06-07T16:15:15.459Z knex:query alter table "directus_settings" add constraint "g8Mr8lh/J6qE8W0/k/zyAr8/fGo" foreign key ("public_background") references "directus_files" ("id") undefined
2022-06-07T16:15:15.459Z knex:bindings [] undefined
2022-06-07T16:15:15.471Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:15.471Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:15.471Z knex:query alter table "directus_users" drop constraint "directus_users_role_foreign" undefined
2022-06-07T16:15:15.471Z knex:bindings [] undefined
2022-06-07T16:15:15.480Z knex:query alter table "directus_users" add constraint "directus_users_role_foreign" foreign key ("role") references "directus_roles" ("id") undefined
2022-06-07T16:15:15.480Z knex:bindings [] undefined
2022-06-07T16:15:15.492Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:15.492Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:15.493Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:15.493Z knex:bindings [ 'Add Cascade System Relations', '20201105A' ] undefined
2022-06-07T16:15:15.497Z knex:client releasing connection to pool: __knexUid1
18:15:15 ✨ Applying Change Webhook URL Type...
2022-06-07T16:15:15.498Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:15.499Z knex:query alter table "directus_webhooks" add "url__temp" clob null undefined
2022-06-07T16:15:15.499Z knex:bindings [] undefined
2022-06-07T16:15:15.570Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:15.570Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:15.571Z knex:query update "directus_webhooks" set "url__temp" = "url" undefined
2022-06-07T16:15:15.572Z knex:bindings [] undefined
2022-06-07T16:15:15.581Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:15.581Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:15.582Z knex:query alter table "directus_webhooks" drop ("url") undefined
2022-06-07T16:15:15.582Z knex:bindings [] undefined
2022-06-07T16:15:15.792Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:15.792Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:15.792Z knex:query DECLARE PK_NAME VARCHAR(200); IS_AUTOINC NUMBER := 0; BEGIN  EXECUTE IMMEDIATE ('ALTER TABLE "directus_webhooks" RENAME COLUMN "url__temp" TO "url"');  SELECT COUNT(*) INTO IS_AUTOINC from "USER_TRIGGERS" where trigger_name = 'directus_webhooks_autoinc_trg';  IF (IS_AUTOINC > 0) THEN    SELECT cols.column_name INTO PK_NAME    FROM all_constraints cons, all_cons_columns cols    WHERE cons.constraint_type = 'P'    AND cons.constraint_name = cols.constraint_name    AND cons.owner = cols.owner    AND cols.table_name = 'directus_webhooks';    IF ('url' = PK_NAME) THEN      EXECUTE IMMEDIATE ('DROP TRIGGER "directus_webhooks_autoinc_trg"');      EXECUTE IMMEDIATE ('create or replace trigger "directus_webhooks_autoinc_trg"      BEFORE INSERT on "directus_webhooks" for each row        declare        checking number := 1;        begin          if (:new."url" is null) then            while checking >= 1 loop              select "directus_webhooks_seq".nextval into :new."url" from dual;              select count("url") into checking from "directus_webhooks"              where "url" = :new."url";            end loop;          end if;        end;');    end if;  end if;END; undefined
2022-06-07T16:15:15.792Z knex:bindings [] undefined
2022-06-07T16:15:15.992Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:15.992Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:15.992Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:15.992Z knex:bindings [ 'Change Webhook URL Type', '20201105B' ] undefined
2022-06-07T16:15:15.996Z knex:client releasing connection to pool: __knexUid1
18:15:15 ✨ Applying Add Relations Sort Field...
2022-06-07T16:15:15.997Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:15.997Z knex:query alter table "directus_relations" add "sort_field" varchar2(255) undefined
2022-06-07T16:15:15.997Z knex:bindings [] undefined
2022-06-07T16:15:16.011Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.011Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.011Z knex:query select "collection", "field", "options" from "directus_fields" where "interface" in (:1, :2, :3) undefined
2022-06-07T16:15:16.012Z knex:bindings [ 'one-to-many', 'm2a-builder', 'many-to-many' ] undefined
2022-06-07T16:15:16.020Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.020Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.021Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:16.021Z knex:bindings [ 'Add Relations Sort Field', '20210225A' ] undefined
2022-06-07T16:15:16.025Z knex:client releasing connection to pool: __knexUid1
18:15:16 ✨ Applying Remove Locked Fields...
2022-06-07T16:15:16.026Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.027Z knex:query alter table "directus_fields" drop ("locked") undefined
2022-06-07T16:15:16.027Z knex:bindings [] undefined
2022-06-07T16:15:16.049Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.050Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.050Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:16.050Z knex:bindings [ 'Remove Locked Fields', '20210304A' ] undefined
2022-06-07T16:15:16.054Z knex:client releasing connection to pool: __knexUid1
18:15:16 ✨ Applying Webhooks Collections Text...
2022-06-07T16:15:16.056Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.056Z knex:query alter table "directus_webhooks" add "collections__temp" clob null undefined
2022-06-07T16:15:16.056Z knex:bindings [] undefined
2022-06-07T16:15:16.097Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.097Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.097Z knex:query update "directus_webhooks" set "collections__temp" = "collections" undefined
2022-06-07T16:15:16.097Z knex:bindings [] undefined
2022-06-07T16:15:16.105Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.105Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.105Z knex:query alter table "directus_webhooks" drop ("collections") undefined
2022-06-07T16:15:16.105Z knex:bindings [] undefined
2022-06-07T16:15:16.122Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.122Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.122Z knex:query DECLARE PK_NAME VARCHAR(200); IS_AUTOINC NUMBER := 0; BEGIN  EXECUTE IMMEDIATE ('ALTER TABLE "directus_webhooks" RENAME COLUMN "collections__temp" TO "collections"');  SELECT COUNT(*) INTO IS_AUTOINC from "USER_TRIGGERS" where trigger_name = 'directus_webhooks_autoinc_trg';  IF (IS_AUTOINC > 0) THEN    SELECT cols.column_name INTO PK_NAME    FROM all_constraints cons, all_cons_columns cols    WHERE cons.constraint_type = 'P'    AND cons.constraint_name = cols.constraint_name    AND cons.owner = cols.owner    AND cols.table_name = 'directus_webhooks';    IF ('collections' = PK_NAME) THEN      EXECUTE IMMEDIATE ('DROP TRIGGER "directus_webhooks_autoinc_trg"');      EXECUTE IMMEDIATE ('create or replace trigger "directus_webhooks_autoinc_trg"      BEFORE INSERT on "directus_webhooks" for each row        declare        checking number := 1;        begin          if (:new."collections" is null) then            while checking >= 1 loop              select "directus_webhooks_seq".nextval into :new."collections" from dual;              select count("collections") into checking from "directus_webhooks"              where "collections" = :new."collections";            end loop;          end if;        end;');    end if;  end if;END; undefined
2022-06-07T16:15:16.122Z knex:bindings [] undefined
2022-06-07T16:15:16.255Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.255Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.255Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:16.255Z knex:bindings [ 'Webhooks Collections Text', '20210312A' ] undefined
2022-06-07T16:15:16.260Z knex:client releasing connection to pool: __knexUid1
18:15:16 ✨ Applying Add Refresh Interval...
2022-06-07T16:15:16.260Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.261Z knex:query alter table "directus_presets" add "refresh_interval" integer undefined
2022-06-07T16:15:16.261Z knex:bindings [] undefined
2022-06-07T16:15:16.273Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.273Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.273Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:16.273Z knex:bindings [ 'Add Refresh Interval', '20210331A' ] undefined
2022-06-07T16:15:16.278Z knex:client releasing connection to pool: __knexUid1
18:15:16 ✨ Applying Make Filesize Nullable...
2022-06-07T16:15:16.280Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.280Z knex:query alter table "directus_files" modify "filesize" integer default null null undefined
2022-06-07T16:15:16.280Z knex:bindings [] undefined
2022-06-07T16:15:16.295Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.295Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.295Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:16.295Z knex:bindings [ 'Make Filesize Nullable', '20210415A' ] undefined
2022-06-07T16:15:16.299Z knex:client releasing connection to pool: __knexUid1
18:15:16 ✨ Applying Add Collections Accountability...
2022-06-07T16:15:16.300Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.301Z knex:query alter table "directus_collections" add "accountability" varchar2(255) default 'all' undefined
2022-06-07T16:15:16.301Z knex:bindings [] undefined
2022-06-07T16:15:16.389Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.389Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.389Z knex:query update "directus_collections" set "accountability" = :1 undefined
2022-06-07T16:15:16.389Z knex:bindings [ 'all' ] undefined
2022-06-07T16:15:16.400Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.400Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.401Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:16.401Z knex:bindings [ 'Add Collections Accountability', '20210416A' ] undefined
2022-06-07T16:15:16.405Z knex:client releasing connection to pool: __knexUid1
18:15:16 ✨ Applying Remove Files Interface...
2022-06-07T16:15:16.406Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.406Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.406Z knex:bindings [ 'many-to-many', 'files' ] undefined
2022-06-07T16:15:16.412Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.413Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.413Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:16.413Z knex:bindings [ 'Remove Files Interface', '20210422A' ] undefined
2022-06-07T16:15:16.417Z knex:client releasing connection to pool: __knexUid1
18:15:16 ✨ Applying Rename Interfaces...
2022-06-07T16:15:16.418Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.418Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.418Z knex:bindings [ 'presentation-links', 'button-links' ] undefined
2022-06-07T16:15:16.422Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.422Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.423Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.423Z knex:bindings [ 'select-multiple-checkbox', 'checkboxes' ] undefined
2022-06-07T16:15:16.425Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.425Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.425Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.425Z knex:bindings [ 'input-code', 'code' ] undefined
2022-06-07T16:15:16.427Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.427Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.428Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.428Z knex:bindings [ 'select-color', 'color' ] undefined
2022-06-07T16:15:16.430Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.430Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.430Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.430Z knex:bindings [ 'datetime', 'datetime' ] undefined
2022-06-07T16:15:16.432Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.432Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.432Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.432Z knex:bindings [ 'presentation-divider', 'divider' ] undefined
2022-06-07T16:15:16.434Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.435Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.435Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.435Z knex:bindings [ 'select-dropdown', 'dropdown' ] undefined
2022-06-07T16:15:16.437Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.437Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.437Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.437Z knex:bindings [ 'select-multiple-dropdown', 'dropdown-multiselect' ] undefined
2022-06-07T16:15:16.439Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.439Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.440Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.440Z knex:bindings [ 'file', 'file' ] undefined
2022-06-07T16:15:16.442Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.442Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.442Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.442Z knex:bindings [ 'input-hash', 'hash' ] undefined
2022-06-07T16:15:16.444Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.444Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.444Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.445Z knex:bindings [ 'select-icon', 'icon' ] undefined
2022-06-07T16:15:16.446Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.446Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.447Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.447Z knex:bindings [ 'file-image', 'image' ] undefined
2022-06-07T16:15:16.448Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.449Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.449Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.449Z knex:bindings [ 'list-m2a', 'm2a-builder' ] undefined
2022-06-07T16:15:16.451Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.451Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.451Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.451Z knex:bindings [ 'list-m2m', 'many-to-many' ] undefined
2022-06-07T16:15:16.453Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.453Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.453Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.453Z knex:bindings [ 'select-dropdown-m2o', 'many-to-one' ] undefined
2022-06-07T16:15:16.455Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.455Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.456Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.456Z knex:bindings [ 'input-rich-text-md', 'markdown' ] undefined
2022-06-07T16:15:16.457Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.457Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.458Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.458Z knex:bindings [ 'presentation-notice', 'notice' ] undefined
2022-06-07T16:15:16.459Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.460Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.460Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.460Z knex:bindings [ 'input', 'numeric' ] undefined
2022-06-07T16:15:16.461Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.462Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.462Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.462Z knex:bindings [ 'list-o2m', 'one-to-many' ] undefined
2022-06-07T16:15:16.463Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.464Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.464Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.464Z knex:bindings [ 'select-radio', 'radio-buttons' ] undefined
2022-06-07T16:15:16.466Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.466Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.466Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.466Z knex:bindings [ 'list', 'repeater' ] undefined
2022-06-07T16:15:16.467Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.468Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.468Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.468Z knex:bindings [ 'slider', 'slider' ] undefined
2022-06-07T16:15:16.470Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.470Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.470Z knex:query select "id", "options" from "directus_fields" where "interface" = :1 undefined
2022-06-07T16:15:16.470Z knex:bindings [ 'slug' ] undefined
2022-06-07T16:15:16.474Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.474Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.475Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.475Z knex:bindings [ 'tags', 'tags' ] undefined
2022-06-07T16:15:16.477Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.477Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.477Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.477Z knex:bindings [ 'input', 'text-input' ] undefined
2022-06-07T16:15:16.479Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.479Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.479Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.479Z knex:bindings [ 'input-multiline', 'textarea' ] undefined
2022-06-07T16:15:16.481Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.481Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.481Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.481Z knex:bindings [ 'boolean', 'toggle' ] undefined
2022-06-07T16:15:16.483Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.483Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.484Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.484Z knex:bindings [ 'translations', 'translations' ] undefined
2022-06-07T16:15:16.485Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.486Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.486Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.486Z knex:bindings [ 'list-o2m-tree-view', 'tree-view' ] undefined
2022-06-07T16:15:16.487Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.488Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.488Z knex:query select "id", "options" from "directus_fields" where "interface" = :1 undefined
2022-06-07T16:15:16.488Z knex:bindings [ 'user' ] undefined
2022-06-07T16:15:16.490Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.490Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.490Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.490Z knex:bindings [ 'input-rich-text-html', 'wysiwyg' ] undefined
2022-06-07T16:15:16.492Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.492Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.492Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.492Z knex:bindings [ 'system-collection', 'collection' ] undefined
2022-06-07T16:15:16.494Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.494Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.494Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.494Z knex:bindings [ 'system-collection-multiple', 'collections' ] undefined
2022-06-07T16:15:16.496Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.496Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.497Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.497Z knex:bindings [ 'system-display-template', 'display-template' ] undefined
2022-06-07T16:15:16.499Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.499Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.499Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.499Z knex:bindings [ 'system-field', 'field' ] undefined
2022-06-07T16:15:16.501Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.501Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.501Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.501Z knex:bindings [ 'system-interface', 'interface' ] undefined
2022-06-07T16:15:16.503Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.503Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.503Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.503Z knex:bindings [ 'system-interface-options', 'interface-options' ] undefined
2022-06-07T16:15:16.505Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.505Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.505Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.505Z knex:bindings [ 'system-scope', 'scope' ] undefined
2022-06-07T16:15:16.507Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.507Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.507Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.507Z knex:bindings [ 'system-language', 'system-language' ] undefined
2022-06-07T16:15:16.509Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.509Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.510Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:16.510Z knex:bindings [ 'system-mfa-setup', 'tfa-setup' ] undefined
2022-06-07T16:15:16.511Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.511Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.512Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:16.512Z knex:bindings [ 'Rename Interfaces', '20210506A' ] undefined
2022-06-07T16:15:16.515Z knex:client releasing connection to pool: __knexUid1
18:15:16 ✨ Applying Restructure Relations...
2022-06-07T16:15:16.516Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.517Z knex:query alter table "directus_relations" add "one_deselect_action" varchar2(255) default 'nullify' undefined
2022-06-07T16:15:16.517Z knex:bindings [] undefined
2022-06-07T16:15:16.530Z knex:query alter table "directus_relations" drop ("many_primary", "one_primary") undefined
2022-06-07T16:15:16.530Z knex:bindings [] undefined
2022-06-07T16:15:16.661Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.661Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.662Z knex:query update "directus_relations" set "one_deselect_action" = :1 undefined
2022-06-07T16:15:16.662Z knex:bindings [ 'nullify' ] undefined
2022-06-07T16:15:16.671Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.671Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.671Z knex:query alter table "directus_relations" add "sort_field__temp" varchar2(64) null undefined
2022-06-07T16:15:16.671Z knex:bindings [] undefined
2022-06-07T16:15:16.680Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.681Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.681Z knex:query update "directus_relations" set "sort_field__temp" = "sort_field" undefined
2022-06-07T16:15:16.681Z knex:bindings [] undefined
2022-06-07T16:15:16.690Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.690Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.690Z knex:query alter table "directus_relations" drop ("sort_field") undefined
2022-06-07T16:15:16.690Z knex:bindings [] undefined
2022-06-07T16:15:16.702Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.703Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.703Z knex:query DECLARE PK_NAME VARCHAR(200); IS_AUTOINC NUMBER := 0; BEGIN  EXECUTE IMMEDIATE ('ALTER TABLE "directus_relations" RENAME COLUMN "sort_field__temp" TO "sort_field"');  SELECT COUNT(*) INTO IS_AUTOINC from "USER_TRIGGERS" where trigger_name = 'directus_relations_autoinc_trg';  IF (IS_AUTOINC > 0) THEN    SELECT cols.column_name INTO PK_NAME    FROM all_constraints cons, all_cons_columns cols    WHERE cons.constraint_type = 'P'    AND cons.constraint_name = cols.constraint_name    AND cons.owner = cols.owner    AND cols.table_name = 'directus_relations';    IF ('sort_field' = PK_NAME) THEN      EXECUTE IMMEDIATE ('DROP TRIGGER "directus_relations_autoinc_trg"');      EXECUTE IMMEDIATE ('create or replace trigger "directus_relations_autoinc_trg"      BEFORE INSERT on "directus_relations" for each row        declare        checking number := 1;        begin          if (:new."sort_field" is null) then            while checking >= 1 loop              select "directus_relations_seq".nextval into :new."sort_field" from dual;              select count("sort_field") into checking from "directus_relations"              where "sort_field" = :new."sort_field";            end loop;          end if;        end;');    end if;  end if;END; undefined
2022-06-07T16:15:16.703Z knex:bindings [] undefined
2022-06-07T16:15:16.920Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.920Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.920Z knex:query alter table "directus_relations" add "one_deselect_action__temp" varchar2(255) default 'nullify' null undefined
2022-06-07T16:15:16.920Z knex:bindings [] undefined
2022-06-07T16:15:16.939Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.939Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.940Z knex:query update "directus_relations" set "one_deselect_action__temp" = "one_deselect_action" undefined
2022-06-07T16:15:16.940Z knex:bindings [] undefined
2022-06-07T16:15:16.946Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.946Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.946Z knex:query alter table "directus_relations" drop ("one_deselect_action") undefined
2022-06-07T16:15:16.946Z knex:bindings [] undefined
2022-06-07T16:15:16.963Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.963Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.964Z knex:query DECLARE PK_NAME VARCHAR(200); IS_AUTOINC NUMBER := 0; BEGIN  EXECUTE IMMEDIATE ('ALTER TABLE "directus_relations" RENAME COLUMN "one_deselect_action__temp" TO "one_deselect_action"');  SELECT COUNT(*) INTO IS_AUTOINC from "USER_TRIGGERS" where trigger_name = 'directus_relations_autoinc_trg';  IF (IS_AUTOINC > 0) THEN    SELECT cols.column_name INTO PK_NAME    FROM all_constraints cons, all_cons_columns cols    WHERE cons.constraint_type = 'P'    AND cons.constraint_name = cols.constraint_name    AND cons.owner = cols.owner    AND cols.table_name = 'directus_relations';    IF ('one_deselect_action' = PK_NAME) THEN      EXECUTE IMMEDIATE ('DROP TRIGGER "directus_relations_autoinc_trg"');      EXECUTE IMMEDIATE ('create or replace trigger "directus_relations_autoinc_trg"      BEFORE INSERT on "directus_relations" for each row        declare        checking number := 1;        begin          if (:new."one_deselect_action" is null) then            while checking >= 1 loop              select "directus_relations_seq".nextval into :new."one_deselect_action" from dual;              select count("one_deselect_action") into checking from "directus_relations"              where "one_deselect_action" = :new."one_deselect_action";            end loop;          end if;        end;');    end if;  end if;END; undefined
2022-06-07T16:15:16.964Z knex:bindings [] undefined
2022-06-07T16:15:16.981Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.982Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.982Z knex:query alter table "directus_relations" modify ("one_deselect_action" NOT NULL) undefined
2022-06-07T16:15:16.982Z knex:bindings [] undefined
2022-06-07T16:15:16.998Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:16.998Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:16.998Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:16.998Z knex:bindings [ 'Restructure Relations', '20210510A' ] undefined
2022-06-07T16:15:17.003Z knex:client releasing connection to pool: __knexUid1
18:15:17 ✨ Applying Add Foreign Key Constraints...
2022-06-07T16:15:17.005Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.005Z knex:query with "ucc" as (SELECT /*+ materialize */ "TABLE_NAME", "COLUMN_NAME", "CONSTRAINT_NAME" FROM "USER_CONS_COLUMNS") select "uc"."TABLE_NAME" "table", "cc"."COLUMN_NAME" "column", "rcc"."TABLE_NAME" "foreign_key_table", "rcc"."COLUMN_NAME" "foreign_key_column", "uc"."CONSTRAINT_NAME" "constraint_name", NULL as "on_update", "uc"."DELETE_RULE" "on_delete" from "USER_CONSTRAINTS" "uc" left join "ucc" "cc" on "uc"."CONSTRAINT_NAME" = "cc"."CONSTRAINT_NAME" left join "ucc" "rcc" on "uc"."R_CONSTRAINT_NAME" = "rcc"."CONSTRAINT_NAME" where "uc"."CONSTRAINT_TYPE" = :1 undefined
2022-06-07T16:15:17.005Z knex:bindings [ 'R' ] undefined
2022-06-07T16:15:17.215Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.215Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.215Z knex:query select "id", "many_collection", "many_field", "one_collection" from "directus_relations" undefined
2022-06-07T16:15:17.215Z knex:bindings [] undefined
2022-06-07T16:15:17.225Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.225Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.225Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:17.225Z knex:bindings [ 'Add Foreign Key Constraints', '20210518A' ] undefined
2022-06-07T16:15:17.230Z knex:client releasing connection to pool: __knexUid1
18:15:17 ✨ Applying Add System Fk Triggers...
2022-06-07T16:15:17.231Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.231Z knex:query with "ucc" as (SELECT /*+ materialize */ "TABLE_NAME", "COLUMN_NAME", "CONSTRAINT_NAME" FROM "USER_CONS_COLUMNS") select "uc"."TABLE_NAME" "table", "cc"."COLUMN_NAME" "column", "rcc"."TABLE_NAME" "foreign_key_table", "rcc"."COLUMN_NAME" "foreign_key_column", "uc"."CONSTRAINT_NAME" "constraint_name", NULL as "on_update", "uc"."DELETE_RULE" "on_delete" from "USER_CONSTRAINTS" "uc" left join "ucc" "cc" on "uc"."CONSTRAINT_NAME" = "cc"."CONSTRAINT_NAME" left join "ucc" "rcc" on "uc"."R_CONSTRAINT_NAME" = "rcc"."CONSTRAINT_NAME" where "uc"."CONSTRAINT_TYPE" = :1 undefined
2022-06-07T16:15:17.231Z knex:bindings [ 'R' ] undefined
2022-06-07T16:15:17.259Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.259Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.260Z knex:query alter table "directus_files" drop constraint "directus_files_folder_foreign" undefined
2022-06-07T16:15:17.260Z knex:bindings [] undefined
2022-06-07T16:15:17.268Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.269Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.269Z knex:query alter table "directus_files" add constraint "directus_files_folder_foreign" foreign key ("folder") references "directus_folders" ("id") on delete SET NULL undefined
2022-06-07T16:15:17.269Z knex:bindings [] undefined
2022-06-07T16:15:17.282Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.283Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.283Z knex:query alter table "directus_permissions" drop constraint "b0MEIbON78xw+8mvKvN5Y4uJ+/c" undefined
2022-06-07T16:15:17.283Z knex:bindings [] undefined
2022-06-07T16:15:17.292Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.292Z knex:client acquired connection from pool: __knexUid1
18:15:17 ⚠️  Automatically generated name "directus_permissions_role_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:17.292Z knex:query alter table "directus_permissions" add constraint "b0MEIbON78xw+8mvKvN5Y4uJ+/c" foreign key ("role") references "directus_roles" ("id") on delete CASCADE undefined
2022-06-07T16:15:17.292Z knex:bindings [] undefined
2022-06-07T16:15:17.304Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.304Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.304Z knex:query alter table "directus_presets" drop constraint "directus_presets_user_foreign" undefined
2022-06-07T16:15:17.304Z knex:bindings [] undefined
2022-06-07T16:15:17.314Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.314Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.314Z knex:query alter table "directus_presets" add constraint "directus_presets_user_foreign" foreign key ("user") references "directus_users" ("id") on delete CASCADE undefined
2022-06-07T16:15:17.314Z knex:bindings [] undefined
2022-06-07T16:15:17.328Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.328Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.328Z knex:query alter table "directus_presets" drop constraint "directus_presets_role_foreign" undefined
2022-06-07T16:15:17.328Z knex:bindings [] undefined
2022-06-07T16:15:17.337Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.337Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.338Z knex:query alter table "directus_presets" add constraint "directus_presets_role_foreign" foreign key ("role") references "directus_roles" ("id") on delete CASCADE undefined
2022-06-07T16:15:17.338Z knex:bindings [] undefined
2022-06-07T16:15:17.351Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.351Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.351Z knex:query alter table "directus_revisions" drop constraint "nCTcIkb8L+ktcIMKh8lknbnQOBI" undefined
2022-06-07T16:15:17.351Z knex:bindings [] undefined
2022-06-07T16:15:17.360Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.360Z knex:client acquired connection from pool: __knexUid1
18:15:17 ⚠️  Automatically generated name "directus_revisions_activity_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:17.361Z knex:query alter table "directus_revisions" add constraint "nCTcIkb8L+ktcIMKh8lknbnQOBI" foreign key ("activity") references "directus_activity" ("id") on delete CASCADE undefined
2022-06-07T16:15:17.361Z knex:bindings [] undefined
2022-06-07T16:15:17.373Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.374Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.374Z knex:query alter table "directus_sessions" drop constraint "directus_sessions_user_foreign" undefined
2022-06-07T16:15:17.374Z knex:bindings [] undefined
2022-06-07T16:15:17.382Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.382Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.383Z knex:query alter table "directus_sessions" add constraint "directus_sessions_user_foreign" foreign key ("user") references "directus_users" ("id") on delete CASCADE undefined
2022-06-07T16:15:17.383Z knex:bindings [] undefined
2022-06-07T16:15:17.396Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.396Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.396Z knex:query alter table "directus_users" drop constraint "directus_users_role_foreign" undefined
2022-06-07T16:15:17.396Z knex:bindings [] undefined
2022-06-07T16:15:17.407Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.408Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.408Z knex:query alter table "directus_users" add constraint "directus_users_role_foreign" foreign key ("role") references "directus_roles" ("id") on delete SET NULL undefined
2022-06-07T16:15:17.408Z knex:bindings [] undefined
2022-06-07T16:15:17.417Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.417Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.418Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:17.418Z knex:bindings [ 'Add System Fk Triggers', '20210519A' ] undefined
2022-06-07T16:15:17.422Z knex:client releasing connection to pool: __knexUid1
18:15:17 ✨ Applying Add Collections Icon Color...
2022-06-07T16:15:17.423Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.423Z knex:query alter table "directus_collections" add "color" varchar2(255) null undefined
2022-06-07T16:15:17.423Z knex:bindings [] undefined
2022-06-07T16:15:17.435Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.435Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.436Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:17.436Z knex:bindings [ 'Add Collections Icon Color', '20210521A' ] undefined
2022-06-07T16:15:17.440Z knex:client releasing connection to pool: __knexUid1
18:15:17 ✨ Applying Add Insights...
2022-06-07T16:15:17.441Z knex:client acquired connection from pool: __knexUid1
18:15:17 ⚠️  Automatically generated name "directus_dashboards_user_created_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:17.442Z knex:query create table "directus_dashboards" ("id" char(36) not null, "name" varchar2(255) not null, "icon" varchar2(30) default 'dashboard' not null, "note" clob, "date_created" timestamp with local time zone default CURRENT_TIMESTAMP, "user_created" char(36)) undefined
2022-06-07T16:15:17.442Z knex:bindings [] undefined
2022-06-07T16:15:17.491Z knex:query alter table "directus_dashboards" add constraint "directus_dashboards_pkey" primary key ("id") undefined
2022-06-07T16:15:17.491Z knex:bindings [] undefined
2022-06-07T16:15:17.529Z knex:query alter table "directus_dashboards" add constraint "apDeJPEzhmmLH0V6oWJ7DbYKGvA" foreign key ("user_created") references "directus_users" ("id") on delete SET NULL undefined
2022-06-07T16:15:17.529Z knex:bindings [] undefined
2022-06-07T16:15:17.542Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.543Z knex:client acquired connection from pool: __knexUid1
18:15:17 ⚠️  Automatically generated name "directus_panels_dashboard_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:17 ⚠️  Automatically generated name "directus_panels_user_created_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:17.544Z knex:query create table "directus_panels" ("id" char(36) not null, "dashboard" char(36) not null, "name" varchar2(255), "icon" varchar2(30) default 'insert_chart', "color" varchar2(10), "show_header" number(1, 0) default '0' not null check ("show_header" in ('0', '1')), "note" clob, "type" varchar2(255) not null, "position_x" integer not null, "position_y" integer not null, "width" integer not null, "height" integer not null, "options" varchar2(4000) check ("options" is json), "date_created" timestamp with local time zone default CURRENT_TIMESTAMP, "user_created" char(36)) undefined
2022-06-07T16:15:17.544Z knex:bindings [] undefined
2022-06-07T16:15:17.614Z knex:query alter table "directus_panels" add constraint "directus_panels_pkey" primary key ("id") undefined
2022-06-07T16:15:17.614Z knex:bindings [] undefined
2022-06-07T16:15:17.644Z knex:query alter table "directus_panels" add constraint "5PsjTjuwWead1Jf0C1jPTuX5Ifs" foreign key ("dashboard") references "directus_dashboards" ("id") on delete CASCADE undefined
2022-06-07T16:15:17.644Z knex:bindings [] undefined
2022-06-07T16:15:17.656Z knex:query alter table "directus_panels" add constraint "ygB3Vb5ngZSTo4dk7EqamY8Cp6Y" foreign key ("user_created") references "directus_users" ("id") on delete SET NULL undefined
2022-06-07T16:15:17.656Z knex:bindings [] undefined
2022-06-07T16:15:17.669Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.670Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.670Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:17.670Z knex:bindings [ 'Add Insights', '20210525A' ] undefined
2022-06-07T16:15:17.674Z knex:client releasing connection to pool: __knexUid1
18:15:17 ✨ Applying Add Deep Clone Config...
2022-06-07T16:15:17.675Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.676Z knex:query alter table "directus_collections" add "item_duplication_fields" varchar2(4000) check ("item_duplication_fields" is json) null undefined
2022-06-07T16:15:17.676Z knex:bindings [] undefined
2022-06-07T16:15:17.685Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.685Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.685Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:17.685Z knex:bindings [ 'Add Deep Clone Config', '20210608A' ] undefined
2022-06-07T16:15:17.690Z knex:client releasing connection to pool: __knexUid1
18:15:17 ✨ Applying Change Filesize Bigint...
2022-06-07T16:15:17.692Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.692Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:17.692Z knex:bindings [ 'Change Filesize Bigint', '20210626A' ] undefined
2022-06-07T16:15:17.696Z knex:client releasing connection to pool: __knexUid1
18:15:17 ✨ Applying Add Conditions to Fields...
2022-06-07T16:15:17.697Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.697Z knex:query alter table "directus_fields" add "conditions" varchar2(4000) check ("conditions" is json) undefined
2022-06-07T16:15:17.697Z knex:bindings [] undefined
2022-06-07T16:15:17.709Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.709Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.709Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:17.709Z knex:bindings [ 'Add Conditions to Fields', '20210716A' ] undefined
2022-06-07T16:15:17.714Z knex:client releasing connection to pool: __knexUid1
18:15:17 ✨ Applying Add Default Folder...
2022-06-07T16:15:17.715Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.715Z knex:query alter table "directus_settings" add "storage_default_folder" char(36) undefined
2022-06-07T16:15:17.715Z knex:bindings [] undefined
2022-06-07T16:15:17.729Z knex:query alter table "directus_settings" add constraint "directus_settings_storage_default_folder_foreign" foreign key ("storage_default_folder") references "directus_folders" ("id") on delete SET NULL undefined
2022-06-07T16:15:17.729Z knex:bindings [] undefined
2022-06-07T16:15:17.741Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.741Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.741Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:17.741Z knex:bindings [ 'Add Default Folder', '20210721A' ] undefined
2022-06-07T16:15:17.746Z knex:client releasing connection to pool: __knexUid1
18:15:17 ✨ Applying Replace Groups...
2022-06-07T16:15:17.747Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.747Z knex:query select * from "directus_fields" where "interface" = :1 undefined
2022-06-07T16:15:17.747Z knex:bindings [ 'group-divider' ] undefined
2022-06-07T16:15:17.759Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.760Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.760Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 undefined
2022-06-07T16:15:17.760Z knex:bindings [ 'group-standard', 'group-raw' ] undefined
2022-06-07T16:15:17.763Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.763Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.764Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:17.764Z knex:bindings [ 'Replace Groups', '20210802A' ] undefined
2022-06-07T16:15:17.769Z knex:client releasing connection to pool: __knexUid1
18:15:17 ✨ Applying Add Required to Fields...
2022-06-07T16:15:17.770Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.770Z knex:query alter table "directus_fields" add "required" number(1, 0) default '0' check ("required" in ('0', '1')) undefined
2022-06-07T16:15:17.770Z knex:bindings [] undefined
2022-06-07T16:15:17.810Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.810Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.810Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:17.810Z knex:bindings [ 'Add Required to Fields', '20210803A' ] undefined
2022-06-07T16:15:17.815Z knex:client releasing connection to pool: __knexUid1
18:15:17 ✨ Applying Update Groups...
2022-06-07T16:15:17.816Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.816Z knex:query select * from "directus_fields" where "interface" = :1 undefined
2022-06-07T16:15:17.816Z knex:bindings [ 'group-standard' ] undefined
2022-06-07T16:15:17.826Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.827Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.827Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:17.827Z knex:bindings [ 'Update Groups', '20210805A' ] undefined
2022-06-07T16:15:17.832Z knex:client releasing connection to pool: __knexUid1
18:15:17 ✨ Applying Change Image Metadata Structure...
2022-06-07T16:15:17.833Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.833Z knex:query select "id", "metadata" from "directus_files" where "metadata" is not null undefined
2022-06-07T16:15:17.833Z knex:bindings [] undefined
2022-06-07T16:15:17.844Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.844Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.844Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:17.845Z knex:bindings [ 'Change Image Metadata Structure', '20210805B' ] undefined
2022-06-07T16:15:17.850Z knex:client releasing connection to pool: __knexUid1
18:15:17 ✨ Applying Add Geometry Config...
2022-06-07T16:15:17.851Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.851Z knex:query alter table "directus_settings" add ("basemaps" varchar2(4000) check ("basemaps" is json), "mapbox_key" varchar2(255)) undefined
2022-06-07T16:15:17.851Z knex:bindings [] undefined
2022-06-07T16:15:17.861Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.862Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.862Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:17.862Z knex:bindings [ 'Add Geometry Config', '20210811A' ] undefined
2022-06-07T16:15:17.867Z knex:client releasing connection to pool: __knexUid1
18:15:17 ✨ Applying Remove Limit Column...
2022-06-07T16:15:17.868Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.868Z knex:query alter table "directus_permissions" drop ("limit") undefined
2022-06-07T16:15:17.868Z knex:bindings [] undefined
2022-06-07T16:15:17.883Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.883Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.884Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:17.884Z knex:bindings [ 'Remove Limit Column', '20210831A' ] undefined
2022-06-07T16:15:17.888Z knex:client releasing connection to pool: __knexUid1
18:15:17 ✨ Applying Add Auth Provider...
2022-06-07T16:15:17.890Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:17.890Z knex:query alter table "directus_users" drop constraint "directus_users_email_unique" undefined
2022-06-07T16:15:17.890Z knex:bindings [] undefined
2022-06-07T16:15:17.975Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:17.975Z knex:client acquired connection from pool: __knexUid1
18:15:17 ⚠️  Automatically generated name "directus_users_external_identifier_unique" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:17.976Z knex:query alter table "directus_users" add ("provider" varchar2(128) default 'default' not null, "external_identifier" varchar2(255)) undefined
2022-06-07T16:15:17.976Z knex:bindings [] undefined
2022-06-07T16:15:17.992Z knex:query alter table "directus_users" add constraint "cQpmB9CE+Npjdw3JlzfbSR1O+GI" unique ("external_identifier") undefined
2022-06-07T16:15:17.992Z knex:bindings [] undefined
2022-06-07T16:15:18.006Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.006Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.007Z knex:query alter table "directus_users" add "email__temp" varchar2(128) null undefined
2022-06-07T16:15:18.007Z knex:bindings [] undefined
2022-06-07T16:15:18.018Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.018Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.018Z knex:query update "directus_users" set "email__temp" = "email" undefined
2022-06-07T16:15:18.018Z knex:bindings [] undefined
2022-06-07T16:15:18.027Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.027Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.028Z knex:query alter table "directus_users" drop ("email") undefined
2022-06-07T16:15:18.028Z knex:bindings [] undefined
2022-06-07T16:15:18.048Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.049Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.049Z knex:query DECLARE PK_NAME VARCHAR(200); IS_AUTOINC NUMBER := 0; BEGIN  EXECUTE IMMEDIATE ('ALTER TABLE "directus_users" RENAME COLUMN "email__temp" TO "email"');  SELECT COUNT(*) INTO IS_AUTOINC from "USER_TRIGGERS" where trigger_name = 'directus_users_autoinc_trg';  IF (IS_AUTOINC > 0) THEN    SELECT cols.column_name INTO PK_NAME    FROM all_constraints cons, all_cons_columns cols    WHERE cons.constraint_type = 'P'    AND cons.constraint_name = cols.constraint_name    AND cons.owner = cols.owner    AND cols.table_name = 'directus_users';    IF ('email' = PK_NAME) THEN      EXECUTE IMMEDIATE ('DROP TRIGGER "directus_users_autoinc_trg"');      EXECUTE IMMEDIATE ('create or replace trigger "directus_users_autoinc_trg"      BEFORE INSERT on "directus_users" for each row        declare        checking number := 1;        begin          if (:new."email" is null) then            while checking >= 1 loop              select "directus_users_seq".nextval into :new."email" from dual;              select count("email") into checking from "directus_users"              where "email" = :new."email";            end loop;          end if;        end;');    end if;  end if;END; undefined
2022-06-07T16:15:18.049Z knex:bindings [] undefined
2022-06-07T16:15:18.132Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.132Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.132Z knex:query alter table "directus_users" add constraint "directus_users_email_unique" unique ("email") undefined
2022-06-07T16:15:18.132Z knex:bindings [] undefined
2022-06-07T16:15:18.145Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.145Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.145Z knex:query alter table "directus_sessions" add "data" varchar2(4000) check ("data" is json) undefined
2022-06-07T16:15:18.145Z knex:bindings [] undefined
2022-06-07T16:15:18.156Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.156Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.156Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:18.156Z knex:bindings [ 'Add Auth Provider', '20210903A' ] undefined
2022-06-07T16:15:18.161Z knex:client releasing connection to pool: __knexUid1
18:15:18 ✨ Applying Webhooks Collections Not Null...
2022-06-07T16:15:18.162Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.162Z knex:query alter table "directus_webhooks" add "collections__temp" clob null undefined
2022-06-07T16:15:18.162Z knex:bindings [] undefined
2022-06-07T16:15:18.220Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.221Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.221Z knex:query update "directus_webhooks" set "collections__temp" = "collections" undefined
2022-06-07T16:15:18.221Z knex:bindings [] undefined
2022-06-07T16:15:18.229Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.229Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.229Z knex:query alter table "directus_webhooks" drop ("collections") undefined
2022-06-07T16:15:18.229Z knex:bindings [] undefined
2022-06-07T16:15:18.263Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.263Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.264Z knex:query DECLARE PK_NAME VARCHAR(200); IS_AUTOINC NUMBER := 0; BEGIN  EXECUTE IMMEDIATE ('ALTER TABLE "directus_webhooks" RENAME COLUMN "collections__temp" TO "collections"');  SELECT COUNT(*) INTO IS_AUTOINC from "USER_TRIGGERS" where trigger_name = 'directus_webhooks_autoinc_trg';  IF (IS_AUTOINC > 0) THEN    SELECT cols.column_name INTO PK_NAME    FROM all_constraints cons, all_cons_columns cols    WHERE cons.constraint_type = 'P'    AND cons.constraint_name = cols.constraint_name    AND cons.owner = cols.owner    AND cols.table_name = 'directus_webhooks';    IF ('collections' = PK_NAME) THEN      EXECUTE IMMEDIATE ('DROP TRIGGER "directus_webhooks_autoinc_trg"');      EXECUTE IMMEDIATE ('create or replace trigger "directus_webhooks_autoinc_trg"      BEFORE INSERT on "directus_webhooks" for each row        declare        checking number := 1;        begin          if (:new."collections" is null) then            while checking >= 1 loop              select "directus_webhooks_seq".nextval into :new."collections" from dual;              select count("collections") into checking from "directus_webhooks"              where "collections" = :new."collections";            end loop;          end if;        end;');    end if;  end if;END; undefined
2022-06-07T16:15:18.264Z knex:bindings [] undefined
2022-06-07T16:15:18.483Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.483Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.483Z knex:query alter table "directus_webhooks" modify ("collections" NOT NULL) undefined
2022-06-07T16:15:18.483Z knex:bindings [] undefined
2022-06-07T16:15:18.498Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.498Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.498Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:18.498Z knex:bindings [ 'Webhooks Collections Not Null', '20210907A' ] undefined
2022-06-07T16:15:18.502Z knex:client releasing connection to pool: __knexUid1
18:15:18 ✨ Applying Move Module Setup...
2022-06-07T16:15:18.503Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.503Z knex:query alter table "directus_roles" drop ("module_list") undefined
2022-06-07T16:15:18.503Z knex:bindings [] undefined
2022-06-07T16:15:18.522Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.523Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.523Z knex:query alter table "directus_settings" add "module_bar" varchar2(4000) check ("module_bar" is json) undefined
2022-06-07T16:15:18.523Z knex:bindings [] undefined
2022-06-07T16:15:18.533Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.533Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.534Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:18.534Z knex:bindings [ 'Move Module Setup', '20210910A' ] undefined
2022-06-07T16:15:18.537Z knex:client releasing connection to pool: __knexUid1
18:15:18 ✨ Applying Webhooks URL Not Null...
2022-06-07T16:15:18.538Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.538Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:18.539Z knex:bindings [ 'Webhooks URL Not Null', '20210920A' ] undefined
2022-06-07T16:15:18.543Z knex:client releasing connection to pool: __knexUid1
18:15:18 ✨ Applying Add Collection Organization...
2022-06-07T16:15:18.544Z knex:client acquired connection from pool: __knexUid1
18:15:18 ⚠️  Automatically generated name "directus_collections_group_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:18.544Z knex:query alter table "directus_collections" add ("sort" integer, "group" varchar2(64), "collapse" varchar2(255) default 'open' not null) undefined
2022-06-07T16:15:18.545Z knex:bindings [] undefined
2022-06-07T16:15:18.561Z knex:query alter table "directus_collections" add constraint "Z6D5Kxi9Ywmz7eqjX6O7QAUdEMg" foreign key ("group") references "directus_collections" ("collection") undefined
2022-06-07T16:15:18.561Z knex:bindings [] undefined
2022-06-07T16:15:18.572Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.572Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.573Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:18.573Z knex:bindings [ 'Add Collection Organization', '20210924A' ] undefined
2022-06-07T16:15:18.576Z knex:client releasing connection to pool: __knexUid1
18:15:18 ✨ Applying Replace Fields Group...
2022-06-07T16:15:18.577Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.578Z knex:query select "id", "group" from "directus_fields" where "group" is not null undefined
2022-06-07T16:15:18.578Z knex:bindings [] undefined
2022-06-07T16:15:18.585Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.585Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.585Z knex:query select "id", "field" from "directus_fields" where 1 = :1 undefined
2022-06-07T16:15:18.585Z knex:bindings [ 0 ] undefined
2022-06-07T16:15:18.590Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.590Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.590Z knex:query alter table "directus_fields" drop constraint "directus_fields_group_foreign" undefined
2022-06-07T16:15:18.591Z knex:bindings [] undefined
2022-06-07T16:15:18.597Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.597Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.598Z knex:query alter table "directus_fields" drop ("group") undefined
2022-06-07T16:15:18.598Z knex:bindings [] undefined
2022-06-07T16:15:18.614Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.614Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.614Z knex:query alter table "directus_fields" add "group" varchar2(64) undefined
2022-06-07T16:15:18.614Z knex:bindings [] undefined
2022-06-07T16:15:18.625Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.625Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.626Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:18.626Z knex:bindings [ 'Replace Fields Group', '20210927A' ] undefined
2022-06-07T16:15:18.630Z knex:client releasing connection to pool: __knexUid1
18:15:18 ✨ Applying Replace M2M Interface...
2022-06-07T16:15:18.631Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.631Z knex:query update "directus_fields" set "interface" = :1 where "interface" = :2 and "special" = :3 undefined
2022-06-07T16:15:18.631Z knex:bindings [ 'files', 'list-m2m', 'files' ] undefined
2022-06-07T16:15:18.637Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.637Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.638Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:18.638Z knex:bindings [ 'Replace M2M Interface', '20210927B' ] undefined
2022-06-07T16:15:18.642Z knex:client releasing connection to pool: __knexUid1
18:15:18 ✨ Applying Rename Login Action...
2022-06-07T16:15:18.643Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.644Z knex:query update "directus_activity" set "action" = :1 where "action" = :2 undefined
2022-06-07T16:15:18.644Z knex:bindings [ 'login', 'authenticate' ] undefined
2022-06-07T16:15:18.651Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.651Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.651Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:18.652Z knex:bindings [ 'Rename Login Action', '20210929A' ] undefined
2022-06-07T16:15:18.655Z knex:client releasing connection to pool: __knexUid1
18:15:18 ✨ Applying Update Presets...
2022-06-07T16:15:18.657Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.657Z knex:query alter table "directus_presets" add "filter" varchar2(4000) check ("filter" is json) undefined
2022-06-07T16:15:18.657Z knex:bindings [] undefined
2022-06-07T16:15:18.667Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.667Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.668Z knex:query select "id", "filters", "layout_query" from "directus_presets" undefined
2022-06-07T16:15:18.668Z knex:bindings [] undefined
2022-06-07T16:15:18.675Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.675Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.675Z knex:query alter table "directus_presets" drop ("filters") undefined
2022-06-07T16:15:18.675Z knex:bindings [] undefined
2022-06-07T16:15:18.692Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.692Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.692Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:18.692Z knex:bindings [ 'Update Presets', '20211007A' ] undefined
2022-06-07T16:15:18.696Z knex:client releasing connection to pool: __knexUid1
18:15:18 ✨ Applying Add Auth Data...
2022-06-07T16:15:18.697Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.697Z knex:query alter table "directus_users" add "auth_data" varchar2(4000) check ("auth_data" is json) undefined
2022-06-07T16:15:18.697Z knex:bindings [] undefined
2022-06-07T16:15:18.707Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.707Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.708Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:18.708Z knex:bindings [ 'Add Auth Data', '20211009A' ] undefined
2022-06-07T16:15:18.711Z knex:client releasing connection to pool: __knexUid1
18:15:18 ✨ Applying Add Webhook Headers...
2022-06-07T16:15:18.712Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.712Z knex:query alter table "directus_webhooks" add "headers" varchar2(4000) check ("headers" is json) undefined
2022-06-07T16:15:18.712Z knex:bindings [] undefined
2022-06-07T16:15:18.722Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.722Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.722Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:18.722Z knex:bindings [ 'Add Webhook Headers', '20211016A' ] undefined
2022-06-07T16:15:18.726Z knex:client releasing connection to pool: __knexUid1
18:15:18 ✨ Applying Set Unique to User Token...
2022-06-07T16:15:18.727Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.728Z knex:query alter table "directus_users" add constraint "directus_users_token_unique" unique ("token") undefined
2022-06-07T16:15:18.728Z knex:bindings [] undefined
2022-06-07T16:15:18.742Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.742Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.742Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:18.743Z knex:bindings [ 'Set Unique to User Token', '20211103A' ] undefined
2022-06-07T16:15:18.747Z knex:client releasing connection to pool: __knexUid1
18:15:18 ✨ Applying Update Special Geometry...
2022-06-07T16:15:18.748Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.749Z knex:query update "directus_fields" set "special" = REPLACE("special", 'geometry,', 'geometry.') where "special" like :1 or "special" like :2 or "special" like :3 or "special" like :4 or "special" like :5 or "special" like :6 undefined
2022-06-07T16:15:18.749Z knex:bindings [
  '%geometry,Point%',
  '%geometry,LineString%',
  '%geometry,Polygon%',
  '%geometry,MultiPoint%',
  '%geometry,MultiLineString%',
  '%geometry,MultiPolygon%'
] undefined
2022-06-07T16:15:18.753Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.754Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.754Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:18.754Z knex:bindings [ 'Update Special Geometry', '20211103B' ] undefined
2022-06-07T16:15:18.758Z knex:client releasing connection to pool: __knexUid1
18:15:18 ✨ Applying Remove Collections Listing...
2022-06-07T16:15:18.759Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.759Z knex:query alter table "directus_roles" drop ("collection_list") undefined
2022-06-07T16:15:18.759Z knex:bindings [] undefined
2022-06-07T16:15:18.775Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:18.775Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:18.775Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:18.775Z knex:bindings [ 'Remove Collections Listing', '20211104A' ] undefined
2022-06-07T16:15:18.779Z knex:client releasing connection to pool: __knexUid1
18:15:18 ✨ Applying Add Notifications...
2022-06-07T16:15:18.780Z knex:client acquired connection from pool: __knexUid1
18:15:18 ⚠️  Automatically generated name "directus_notifications_autoinc_trg" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:18 ⚠️  Automatically generated name "directus_notifications_recipient_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:18 ⚠️  Automatically generated name "directus_notifications_sender_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:18.781Z knex:query create table "directus_notifications" ("id" integer not null primary key, "timestamp" timestamp with local time zone not null, "status" varchar2(255) default 'inbox', "recipient" char(36) not null, "sender" char(36) not null, "subject" varchar2(255) not null, "message" clob, "collection" varchar2(64), "item" varchar2(255)) undefined
2022-06-07T16:15:18.781Z knex:bindings [] undefined
2022-06-07T16:15:18.879Z knex:query DECLARE PK_NAME VARCHAR(200); BEGIN  EXECUTE IMMEDIATE ('CREATE SEQUENCE "directus_notifications_seq"');  SELECT cols.column_name INTO PK_NAME  FROM all_constraints cons, all_cons_columns cols  WHERE cons.constraint_type = 'P'  AND cons.constraint_name = cols.constraint_name  AND cons.owner = cols.owner  AND cols.table_name = 'directus_notifications';  execute immediate ('create or replace trigger "UrsbmFWH+umXZ2vrlFkXOW1Tcl4"  BEFORE INSERT on "directus_notifications"  for each row  declare  checking number := 1;  begin    if (:new."' || PK_NAME || '" is null) then      while checking >= 1 loop        select "directus_notifications_seq".nextval into :new."' || PK_NAME || '" from dual;        select count("' || PK_NAME || '") into checking from "directus_notifications"        where "' || PK_NAME || '" = :new."' || PK_NAME || '";      end loop;    end if;  end;'); END; undefined
2022-06-07T16:15:18.879Z knex:bindings [] undefined
2022-06-07T16:15:19.057Z knex:query alter table "directus_notifications" add constraint "wKcQuQ8zeRb4zBdENjyvARfOvMQ" foreign key ("recipient") references "directus_users" ("id") on delete CASCADE undefined
2022-06-07T16:15:19.057Z knex:bindings [] undefined
2022-06-07T16:15:19.069Z knex:query alter table "directus_notifications" add constraint "YGXEG4r6GR7lTll4ICVLyaHKlZI" foreign key ("sender") references "directus_users" ("id") undefined
2022-06-07T16:15:19.069Z knex:bindings [] undefined
2022-06-07T16:15:19.080Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.081Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.081Z knex:query alter table "directus_users" add "email_notifications" number(1, 0) default '1' check ("email_notifications" in ('0', '1')) undefined
2022-06-07T16:15:19.081Z knex:bindings [] undefined
2022-06-07T16:15:19.117Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.117Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.118Z knex:query update "directus_users" set "email_notifications" = :1 undefined
2022-06-07T16:15:19.118Z knex:bindings [ 1 ] undefined
2022-06-07T16:15:19.127Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.128Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.128Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:19.128Z knex:bindings [ 'Add Notifications', '20211118A' ] undefined
2022-06-07T16:15:19.132Z knex:client releasing connection to pool: __knexUid1
18:15:19 ✨ Applying Add Shares...
2022-06-07T16:15:19.133Z knex:client acquired connection from pool: __knexUid1
18:15:19 ⚠️  Automatically generated name "directus_shares_collection_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
18:15:19 ⚠️  Automatically generated name "directus_shares_user_created_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:19.134Z knex:query create table "directus_shares" ("id" char(36) not null, "name" varchar2(255), "collection" varchar2(64), "item" varchar2(255), "role" char(36), "password" varchar2(255), "user_created" char(36), "date_created" timestamp with local time zone default CURRENT_TIMESTAMP, "date_start" timestamp with local time zone default null null, "date_end" timestamp with local time zone default null null, "times_used" integer default '0', "max_uses" integer) undefined
2022-06-07T16:15:19.134Z knex:bindings [] undefined
2022-06-07T16:15:19.148Z knex:query alter table "directus_shares" add constraint "directus_shares_pkey" primary key ("id") undefined
2022-06-07T16:15:19.148Z knex:bindings [] undefined
2022-06-07T16:15:19.174Z knex:query alter table "directus_shares" add constraint "R7C0vwo7g3WW2s81F/3rDqzmGnI" foreign key ("collection") references "directus_collections" ("collection") on delete CASCADE undefined
2022-06-07T16:15:19.174Z knex:bindings [] undefined
2022-06-07T16:15:19.186Z knex:query alter table "directus_shares" add constraint "directus_shares_role_foreign" foreign key ("role") references "directus_roles" ("id") on delete CASCADE undefined
2022-06-07T16:15:19.187Z knex:bindings [] undefined
2022-06-07T16:15:19.198Z knex:query alter table "directus_shares" add constraint "s3jd6ITCezUv9bPFuSLB0w2jJeA" foreign key ("user_created") references "directus_users" ("id") on delete SET NULL undefined
2022-06-07T16:15:19.199Z knex:bindings [] undefined
2022-06-07T16:15:19.209Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.209Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.209Z knex:query alter table "directus_sessions" drop ("data") undefined
2022-06-07T16:15:19.210Z knex:bindings [] undefined
2022-06-07T16:15:19.222Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.222Z knex:client acquired connection from pool: __knexUid1
18:15:19 ⚠️  Automatically generated name "directus_sessions_share_foreign" exceeds 30 character limit for Oracle. Using base64 encoded sha1 of that name instead.
2022-06-07T16:15:19.223Z knex:query alter table "directus_sessions" add "share" char(36) undefined
2022-06-07T16:15:19.223Z knex:bindings [] undefined
2022-06-07T16:15:19.232Z knex:query alter table "directus_sessions" modify ("user" NULL) undefined
2022-06-07T16:15:19.232Z knex:bindings [] undefined
2022-06-07T16:15:19.245Z knex:query alter table "directus_sessions" add constraint "w8x3ZQPXURaj0mSPfPcToVpwSwA" foreign key ("share") references "directus_shares" ("id") on delete CASCADE undefined
2022-06-07T16:15:19.245Z knex:bindings [] undefined
2022-06-07T16:15:19.258Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.258Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.258Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:19.258Z knex:bindings [ 'Add Shares', '20211211A' ] undefined
2022-06-07T16:15:19.262Z knex:client releasing connection to pool: __knexUid1
18:15:19 ✨ Applying Add Project Descriptor...
2022-06-07T16:15:19.263Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.263Z knex:query alter table "directus_settings" add "project_descriptor" varchar2(100) null undefined
2022-06-07T16:15:19.263Z knex:bindings [] undefined
2022-06-07T16:15:19.277Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.278Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.278Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:19.278Z knex:bindings [ 'Add Project Descriptor', '20211230A' ] undefined
2022-06-07T16:15:19.282Z knex:client releasing connection to pool: __knexUid1
18:15:19 ✨ Applying Remove Default Project Color...
2022-06-07T16:15:19.283Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.284Z knex:query alter table "directus_settings" add "project_color__temp" varchar2(50) default null null undefined
2022-06-07T16:15:19.284Z knex:bindings [] undefined
2022-06-07T16:15:19.296Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.297Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.297Z knex:query update "directus_settings" set "project_color__temp" = "project_color" undefined
2022-06-07T16:15:19.297Z knex:bindings [] undefined
2022-06-07T16:15:19.307Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.307Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.307Z knex:query alter table "directus_settings" drop ("project_color") undefined
2022-06-07T16:15:19.307Z knex:bindings [] undefined
2022-06-07T16:15:19.326Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.326Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.327Z knex:query DECLARE PK_NAME VARCHAR(200); IS_AUTOINC NUMBER := 0; BEGIN  EXECUTE IMMEDIATE ('ALTER TABLE "directus_settings" RENAME COLUMN "project_color__temp" TO "project_color"');  SELECT COUNT(*) INTO IS_AUTOINC from "USER_TRIGGERS" where trigger_name = 'directus_settings_autoinc_trg';  IF (IS_AUTOINC > 0) THEN    SELECT cols.column_name INTO PK_NAME    FROM all_constraints cons, all_cons_columns cols    WHERE cons.constraint_type = 'P'    AND cons.constraint_name = cols.constraint_name    AND cons.owner = cols.owner    AND cols.table_name = 'directus_settings';    IF ('project_color' = PK_NAME) THEN      EXECUTE IMMEDIATE ('DROP TRIGGER "directus_settings_autoinc_trg"');      EXECUTE IMMEDIATE ('create or replace trigger "directus_settings_autoinc_trg"      BEFORE INSERT on "directus_settings" for each row        declare        checking number := 1;        begin          if (:new."project_color" is null) then            while checking >= 1 loop              select "directus_settings_seq".nextval into :new."project_color" from dual;              select count("project_color") into checking from "directus_settings"              where "project_color" = :new."project_color";            end loop;          end if;        end;');    end if;  end if;END; undefined
2022-06-07T16:15:19.327Z knex:bindings [] undefined
2022-06-07T16:15:19.559Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.559Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.559Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:19.560Z knex:bindings [ 'Remove Default Project Color', '20220303A' ] undefined
2022-06-07T16:15:19.563Z knex:client releasing connection to pool: __knexUid1
18:15:19 ✨ Applying Add Bookmark Icon and Color...
2022-06-07T16:15:19.564Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.565Z knex:query alter table "directus_presets" add ("icon" varchar2(30) default 'bookmark_outline' not null, "color" varchar2(255) null) undefined
2022-06-07T16:15:19.565Z knex:bindings [] undefined
2022-06-07T16:15:19.602Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.602Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.603Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:19.603Z knex:bindings [ 'Add Bookmark Icon and Color', '20220308A' ] undefined
2022-06-07T16:15:19.607Z knex:client releasing connection to pool: __knexUid1
18:15:19 ✨ Applying Add Translation Strings...
2022-06-07T16:15:19.607Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.608Z knex:query alter table "directus_settings" add "translation_strings" varchar2(4000) check ("translation_strings" is json) undefined
2022-06-07T16:15:19.608Z knex:bindings [] undefined
2022-06-07T16:15:19.617Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.617Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.618Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:19.618Z knex:bindings [ 'Add Translation Strings', '20220314A' ] undefined
2022-06-07T16:15:19.622Z knex:client releasing connection to pool: __knexUid1
18:15:19 ✨ Applying Rename Field Typecast Flags...
2022-06-07T16:15:19.624Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.624Z knex:query select "id", "special" from "directus_fields" where "special" is not null or "special" <> :1 undefined
2022-06-07T16:15:19.624Z knex:bindings [ '' ] undefined
2022-06-07T16:15:19.631Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.631Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.632Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:19.632Z knex:bindings [ 'Rename Field Typecast Flags', '20220322A' ] undefined
2022-06-07T16:15:19.635Z knex:client releasing connection to pool: __knexUid1
18:15:19 ✨ Applying Add Field Validation...
2022-06-07T16:15:19.637Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.637Z knex:query alter table "directus_fields" add ("validation" varchar2(4000) check ("validation" is json), "validation_message" clob) undefined
2022-06-07T16:15:19.637Z knex:bindings [] undefined
2022-06-07T16:15:19.664Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.665Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.665Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:19.665Z knex:bindings [ 'Add Field Validation', '20220323A' ] undefined
2022-06-07T16:15:19.668Z knex:client releasing connection to pool: __knexUid1
18:15:19 ✨ Applying Fix Typecast Flags...
2022-06-07T16:15:19.670Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.670Z knex:query select "id", "special" from "directus_fields" where "special" is not null or "special" <> :1 undefined
2022-06-07T16:15:19.670Z knex:bindings [ '' ] undefined
2022-06-07T16:15:19.677Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.677Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.677Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:19.677Z knex:bindings [ 'Fix Typecast Flags', '20220325A' ] undefined
2022-06-07T16:15:19.681Z knex:client releasing connection to pool: __knexUid1
18:15:19 ✨ Applying Add Default Language...
2022-06-07T16:15:19.682Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.682Z knex:query alter table "directus_settings" add "default_language" varchar2(255) default 'en-US' not null undefined
2022-06-07T16:15:19.682Z knex:bindings [] undefined
2022-06-07T16:15:19.767Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.767Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.768Z knex:query alter table "directus_users" add "language__temp" varchar2(255) default null null undefined
2022-06-07T16:15:19.768Z knex:bindings [] undefined
2022-06-07T16:15:19.778Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.779Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.779Z knex:query update "directus_users" set "language__temp" = "language" undefined
2022-06-07T16:15:19.779Z knex:bindings [] undefined
2022-06-07T16:15:19.787Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.788Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.788Z knex:query alter table "directus_users" drop ("language") undefined
2022-06-07T16:15:19.788Z knex:bindings [] undefined
2022-06-07T16:15:19.806Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.806Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.806Z knex:query DECLARE PK_NAME VARCHAR(200); IS_AUTOINC NUMBER := 0; BEGIN  EXECUTE IMMEDIATE ('ALTER TABLE "directus_users" RENAME COLUMN "language__temp" TO "language"');  SELECT COUNT(*) INTO IS_AUTOINC from "USER_TRIGGERS" where trigger_name = 'directus_users_autoinc_trg';  IF (IS_AUTOINC > 0) THEN    SELECT cols.column_name INTO PK_NAME    FROM all_constraints cons, all_cons_columns cols    WHERE cons.constraint_type = 'P'    AND cons.constraint_name = cols.constraint_name    AND cons.owner = cols.owner    AND cols.table_name = 'directus_users';    IF ('language' = PK_NAME) THEN      EXECUTE IMMEDIATE ('DROP TRIGGER "directus_users_autoinc_trg"');      EXECUTE IMMEDIATE ('create or replace trigger "directus_users_autoinc_trg"      BEFORE INSERT on "directus_users" for each row        declare        checking number := 1;        begin          if (:new."language" is null) then            while checking >= 1 loop              select "directus_users_seq".nextval into :new."language" from dual;              select count("language") into checking from "directus_users"              where "language" = :new."language";            end loop;          end if;        end;');    end if;  end if;END; undefined
2022-06-07T16:15:19.806Z knex:bindings [] undefined
2022-06-07T16:15:19.883Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.883Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.884Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:19.884Z knex:bindings [ 'Add Default Language', '20220325B' ] undefined
2022-06-07T16:15:19.889Z knex:client releasing connection to pool: __knexUid1
18:15:19 ✨ Applying Remove Default Value Panel Icon...
2022-06-07T16:15:19.889Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.890Z knex:query alter table "directus_panels" add "icon__temp" varchar2(30) default null null undefined
2022-06-07T16:15:19.890Z knex:bindings [] undefined
2022-06-07T16:15:19.903Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.904Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.904Z knex:query update "directus_panels" set "icon__temp" = "icon" undefined
2022-06-07T16:15:19.904Z knex:bindings [] undefined
2022-06-07T16:15:19.913Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.913Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.913Z knex:query alter table "directus_panels" drop ("icon") undefined
2022-06-07T16:15:19.913Z knex:bindings [] undefined
2022-06-07T16:15:19.932Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:19.933Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:19.933Z knex:query DECLARE PK_NAME VARCHAR(200); IS_AUTOINC NUMBER := 0; BEGIN  EXECUTE IMMEDIATE ('ALTER TABLE "directus_panels" RENAME COLUMN "icon__temp" TO "icon"');  SELECT COUNT(*) INTO IS_AUTOINC from "USER_TRIGGERS" where trigger_name = 'directus_panels_autoinc_trg';  IF (IS_AUTOINC > 0) THEN    SELECT cols.column_name INTO PK_NAME    FROM all_constraints cons, all_cons_columns cols    WHERE cons.constraint_type = 'P'    AND cons.constraint_name = cols.constraint_name    AND cons.owner = cols.owner    AND cols.table_name = 'directus_panels';    IF ('icon' = PK_NAME) THEN      EXECUTE IMMEDIATE ('DROP TRIGGER "directus_panels_autoinc_trg"');      EXECUTE IMMEDIATE ('create or replace trigger "directus_panels_autoinc_trg"      BEFORE INSERT on "directus_panels" for each row        declare        checking number := 1;        begin          if (:new."icon" is null) then            while checking >= 1 loop              select "directus_panels_seq".nextval into :new."icon" from dual;              select count("icon") into checking from "directus_panels"              where "icon" = :new."icon";            end loop;          end if;        end;');    end if;  end if;END; undefined
2022-06-07T16:15:19.933Z knex:bindings [] undefined
2022-06-07T16:15:20.015Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:20.015Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:20.016Z knex:query insert into "directus_migrations" ("name", "version") values (:1, :2) undefined
2022-06-07T16:15:20.016Z knex:bindings [ 'Remove Default Value Panel Icon', '20220402A' ] undefined
2022-06-07T16:15:20.021Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:20.023Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:20.023Z knex:query 
			WITH "uc" AS (
				SELECT /*+ MATERIALIZE */
					"uc"."TABLE_NAME",
					"ucc"."COLUMN_NAME",
					"uc"."CONSTRAINT_TYPE",
					COUNT(*) OVER(
						PARTITION BY
							"uc"."CONSTRAINT_NAME"
					) "CONSTRAINT_COUNT"
				FROM "USER_CONSTRAINTS" "uc"
				INNER JOIN "USER_CONS_COLUMNS" "ucc"
					ON "uc"."CONSTRAINT_NAME" = "ucc"."CONSTRAINT_NAME"
					AND "uc"."CONSTRAINT_TYPE" = 'P'
			)
			SELECT /*+ OPTIMIZER_FEATURES_ENABLE('11.2.0.4') */
				"c"."TABLE_NAME" "table_name",
				"c"."COLUMN_NAME" "column_name",
				"c"."DATA_DEFAULT" "default_value",
				"c"."NULLABLE" "is_nullable",
				"c"."DATA_TYPE" "data_type",
				"c"."DATA_PRECISION" "numeric_precision",
				"c"."DATA_SCALE" "numeric_scale",
				"ct"."CONSTRAINT_TYPE" "column_key",
				"c"."CHAR_LENGTH" "max_length",
				"c"."VIRTUAL_COLUMN" "is_generated"
			FROM "USER_TAB_COLS" "c"
			LEFT JOIN "uc" "ct"
				ON "c"."TABLE_NAME" = "ct"."TABLE_NAME"
				AND "c"."COLUMN_NAME" = "ct"."COLUMN_NAME"
				AND "ct"."CONSTRAINT_COUNT" = 1
			WHERE "c"."HIDDEN_COLUMN" = 'NO'
		 undefined
2022-06-07T16:15:20.023Z knex:bindings [] undefined
2022-06-07T16:15:20.403Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:20.404Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:20.404Z knex:query select "collection", "singleton", "note", "sort_field", "accountability" from "directus_collections" undefined
2022-06-07T16:15:20.405Z knex:bindings [] undefined
2022-06-07T16:15:20.414Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:20.415Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:20.416Z knex:query select "id", "collection", "field", "special", "note", "validation" from "directus_fields" undefined
2022-06-07T16:15:20.416Z knex:bindings [] undefined
2022-06-07T16:15:20.424Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:20.428Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:20.428Z knex:query select "directus_relations"."one_deselect_action", "directus_relations"."sort_field", "directus_relations"."id", "directus_relations"."many_collection", "directus_relations"."many_field", "directus_relations"."one_collection", "directus_relations"."one_field", "directus_relations"."one_collection_field", "directus_relations"."one_allowed_collections", "directus_relations"."junction_field" from "directus_relations" order by "directus_relations"."id" asc undefined
2022-06-07T16:15:20.428Z knex:bindings [] undefined
2022-06-07T16:15:20.441Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:20.442Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:20.442Z knex:query with "ucc" as (SELECT /*+ materialize */ "TABLE_NAME", "COLUMN_NAME", "CONSTRAINT_NAME" FROM "USER_CONS_COLUMNS") select "uc"."TABLE_NAME" "table", "cc"."COLUMN_NAME" "column", "rcc"."TABLE_NAME" "foreign_key_table", "rcc"."COLUMN_NAME" "foreign_key_column", "uc"."CONSTRAINT_NAME" "constraint_name", NULL as "on_update", "uc"."DELETE_RULE" "on_delete" from "USER_CONSTRAINTS" "uc" left join "ucc" "cc" on "uc"."CONSTRAINT_NAME" = "cc"."CONSTRAINT_NAME" left join "ucc" "rcc" on "uc"."R_CONSTRAINT_NAME" = "rcc"."CONSTRAINT_NAME" where "uc"."CONSTRAINT_TYPE" = :1 undefined
2022-06-07T16:15:20.442Z knex:bindings [ 'R' ] undefined
2022-06-07T16:15:20.640Z knex:client releasing connection to pool: __knexUid1
18:15:20 ✨ Setting up first admin role...
2022-06-07T16:15:20.645Z knex:tx trx2: Starting top level transaction
2022-06-07T16:15:20.645Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:20.648Z knex:query insert into "directus_roles" ("admin_access", "description", "icon", "id", "name") values (:1, :2, :3, :4, :5) returning "id" into :6 trx2
2022-06-07T16:15:20.648Z knex:bindings [
  1,
  '$t:admin_description',
  'verified',
  'a4565ecd-b88c-404b-9520-36d922d0e078',
  'Administrator',
  { type: 2001, dir: 3003 }
] trx2
2022-06-07T16:15:20.660Z knex:tx trx2: releasing connection
2022-06-07T16:15:20.662Z knex:client releasing connection to pool: __knexUid1
18:15:20 ✨ Adding first admin user...
2022-06-07T16:15:20.663Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:20.663Z knex:query select "email" from "directus_users" where LOWER("email") IN (:1) trx2
2022-06-07T16:15:20.663Z knex:bindings [ 'admin@example.com' ] trx2
2022-06-07T16:15:20.672Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:20.672Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:20.673Z knex:query select * from (select "directus_settings"."auth_password_policy", "directus_settings"."id" from "directus_settings" order by "directus_settings"."id" asc) where rownum <= :1 trx2
2022-06-07T16:15:20.673Z knex:bindings [ 1 ] trx2
2022-06-07T16:15:20.682Z knex:client releasing connection to pool: __knexUid1
2022-06-07T16:15:20.683Z knex:tx trx3: Starting top level transaction
2022-06-07T16:15:20.683Z knex:client acquired connection from pool: __knexUid1
2022-06-07T16:15:20.684Z knex:tx trx4: Starting nested transaction
2022-06-07T16:15:20.684Z knex:query SAVEPOINT trx4 trx4
2022-06-07T16:15:20.684Z knex:bindings [] trx4
2022-06-07T16:15:20.694Z knex:query insert into "directus_users" ("email", "first_name", "id", "last_name", "password", "role", "status") values (:1, :2, :3, :4, :5, :6, :7) returning "id" into :8 trx4
2022-06-07T16:15:20.695Z knex:bindings [
  'admin@example.com',
  'Admin',
  '308b2646-13bb-4996-aeb8-20f03d42bdac',
  'User',
  '$argon2i$v=19$m=4096,t=3,p=1$XhcTIv7osVfXUeYEi9C8Rw$sFAoV7xrtvw6HXnVIdrUtTFxJP+IfxMtfe++Cv2uUl8',
  'a4565ecd-b88c-404b-9520-36d922d0e078',
  'active',
  { type: 2001, dir: 3003 }
] trx4
2022-06-07T16:15:20.704Z knex:tx trx4: releasing connection
2022-06-07T16:15:20.707Z knex:tx trx3: releasing connection
2022-06-07T16:15:20.708Z knex:client releasing connection to pool: __knexUid1
18:15:20 ✨ Done
Waiting for the debugger to disconnect...
Waiting for the debugger to disconnect...

To Reproduce

package.json

{
  "name": "directus-oracle",
  "version": "1.0.0",
  "description": "",
  "main": "index.js",
  "scripts": {
    "bootstrap": "directus bootstrap",
    "start": "directus start",
    "test": "echo \"Error: no test specified\" && exit 1"
  },
  "author": "",
  "license": "ISC",
  "dependencies": {
    "directus": "^9.10.0",
    "oracledb": "^5.3.0"
  }
}

Custom Dockerfile with instantclient dep:

FROM node:16

USER root

RUN apt-get update && apt-get -y upgrade && apt-get -y dist-upgrade && apt-get install -y libaio1

RUN cd /tmp && \
    curl -o instantclient-basiclite.zip https://download.oracle.com/otn_software/linux/instantclient/instantclient-basiclite-linuxx64.zip -SL && \
    unzip instantclient-basiclite.zip && \
    mv instantclient*/ /usr/lib/instantclient && \
    rm instantclient-basiclite.zip && \
    ln -s /usr/lib/instantclient/libclntsh.so.19.1 /usr/lib/libclntsh.so && \
    ln -s /usr/lib/instantclient/libocci.so.19.1 /usr/lib/libocci.so && \
    ln -s /usr/lib/instantclient/libociicus.so /usr/lib/libociicus.so && \
    ln -s /usr/lib/instantclient/libnnz19.so /usr/lib/libnnz19.so && \
    ln -s /usr/lib/libnsl.so.2 /usr/lib/libnsl.so.1 && \
    ln -s /lib/libc.so.6 /usr/lib/libresolv.so.2 && \
    ln -s /lib64/ld-linux-x86-64.so.2 /usr/lib/ld-linux-x86-64.so.2

ENV LD_LIBRARY_PATH /usr/lib/instantclient

RUN mkdir /directus && chown -R 1000:1000 /directus

USER 1000

WORKDIR /directus

COPY --chown=1000:1000 package.json package-lock.json ./

RUN npm install

CMD npm run bootstrap && npm run start

Example docker-compose.yml

version: '3'

volumes:
  db:

services:
  database:
    image: quillbuilduser/oracle-18-xe-micro-sq
    volumes:
      - db:/opt/oracle/oradata
    ports:
      - 1521:1521
    environment:
      - OPATCH_JRE_MEMORY_OPTIONS=-Xms128m -Xmx256m -XX:PermSize=16m -XX:MaxPermSize=32m -Xss1m
      - ORACLE_ALLOW_REMOTE=true
    shm_size: '1gb'

  directus:
    build: .
    ports:
      - 8055:8055
    depends_on:
      database:
        condition: service_healthy
    volumes:
      - ./extensions:/directus/extensions
      - ./uploads:/directus/uploads
    environment:
      TELEMETRY: 'false'
      KEY: '255d861b-5ea1-5996-9aa3-922530ec40b1'
      SECRET: '6116487b-cda1-52c2-b5b5-c8022c45e263'

      DB_CLIENT: 'oracledb'
      DB_HOST: 'database'
      DB_PORT: '1521'
      DB_DATABASE: 'XE'
      DB_USER: 'secretsysuser'
      DB_PASSWORD: 'secretpassword'

      CACHE_ENABLED: 'false'

      ADMIN_EMAIL: 'admin@example.com'
      ADMIN_PASSWORD: 'd1r3ctu5'
      # Make sure to set this in production
      # (see https://docs.directus.io/configuration/config-options/#general)
      # PUBLIC_URL: 'https://directus.example.com'

Up docker-compose, try to access to login & explore network requests to capture server/info request.

Errors Shown


vendor.e0a21029.js:5 
        
       Error: Unable to parse color from string: null 
    at new bu (vendor.e0a21029.js:2851:29026)
    at bu (vendor.e0a21029.js:2851:28718)
    at Gv.fn (index.cee72373.entry.js:540:81604)
    at Gv.run (vendor.e0a21029.js:2:12019)
    at get value [as value] (vendor.e0a21029.js:2:20264)
    at Um (vendor.e0a21029.js:2:19290)
    at Proxy.<anonymous> (index.cee72373.entry.js:540:83561)
    at Xy (vendor.e0a21029.js:2:22303)
    at Gv.St [as fn] (vendor.e0a21029.js:2:51269)
    at Gv.run (vendor.e0a21029.js:2:12019)
CU @ vendor.e0a21029.js:5
z0 @ vendor.e0a21029.js:5
Xy @ vendor.e0a21029.js:2
St @ vendor.e0a21029.js:2
run @ vendor.e0a21029.js:2
gt @ vendor.e0a21029.js:2
Fe @ vendor.e0a21029.js:2
je @ vendor.e0a21029.js:2
x @ vendor.e0a21029.js:2
St @ vendor.e0a21029.js:2
run @ vendor.e0a21029.js:2
gt @ vendor.e0a21029.js:2
Fe @ vendor.e0a21029.js:2
je @ vendor.e0a21029.js:2
x @ vendor.e0a21029.js:2
St @ vendor.e0a21029.js:2
run @ vendor.e0a21029.js:2
id @ vendor.e0a21029.js:5
Bk @ vendor.e0a21029.js:5
Promise.then (asincrónica)
jk @ vendor.e0a21029.js:5
Fk @ vendor.e0a21029.js:5
u9 @ vendor.e0a21029.js:5
YE @ vendor.e0a21029.js:2
T @ vendor.e0a21029.js:5
xb @ vendor.e0a21029.js:2
qy @ vendor.e0a21029.js:2
(anónimo) @ vendor.e0a21029.js:2
xb @ vendor.e0a21029.js:2
qy @ vendor.e0a21029.js:2
(anónimo) @ vendor.e0a21029.js:2
xb @ vendor.e0a21029.js:2
qy @ vendor.e0a21029.js:2
set value @ vendor.e0a21029.js:2
ue @ vendor.e0a21029.js:74
(anónimo) @ vendor.e0a21029.js:74
Promise.then (asincrónica)
q @ vendor.e0a21029.js:74
S @ vendor.e0a21029.js:74
install @ vendor.e0a21029.js:74
use @ vendor.e0a21029.js:2
coe @ index.cee72373.entry.js:541
(anónimo) @ index.cee72373.entry.js:540
vendor.e0a21029.js:5 
        
       TypeError: Cannot read properties of undefined (reading 'primary')
    at Proxy.<anonymous> (index.cee72373.entry.js:540:83565)
    at Xy (vendor.e0a21029.js:2:22303)
    at Gv.St [as fn] (vendor.e0a21029.js:2:50749)
    at Gv.run (vendor.e0a21029.js:2:12019)
    at id (vendor.e0a21029.js:5:664)
    at Bk (vendor.e0a21029.js:5:2360)

What version of Directus are you using?

9.10.0

What version of Node.js are you using?

16

What database are you using?

Oracle

What browser are you using?

Edge

How are you deploying Directus?

Docker

The text was updated successfully, but these errors were encountered:

rijkvanzanten · 2022-06-07T17:40:05Z

@aidenfoxx another wild Oracle default value bug appeared!

aidenfoxx · 2022-06-07T18:44:52Z

@rijkvanzanten This is solved by this knex/knex-schema-inspector#117 (with the fix also applied in Directus).

When you change the default value to null with Knex the value stored as the default in the Oracle schema is null (this is technically valid as a nullable column default). This is different from a string value which would return as 'null '.

aidenfoxx · 2022-06-29T08:20:09Z

@rijkvanzanten This should be solved by #13873 in 9.13.0.

rijkvanzanten added the 🕋 Oracle label Jun 7, 2022

rijkvanzanten added API labels Jun 7, 2022

rijkvanzanten closed this as completed Jun 29, 2022

github-actions bot locked as resolved and limited conversation to collaborators Feb 2, 2024

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Oracle error on create initial project #13771

Oracle error on create initial project #13771

bernatvadell commented Jun 7, 2022 •

edited by rijkvanzanten

rijkvanzanten commented Jun 7, 2022

aidenfoxx commented Jun 7, 2022 •

edited

aidenfoxx commented Jun 29, 2022

Oracle error on create initial project #13771

Oracle error on create initial project #13771

Comments

bernatvadell commented Jun 7, 2022 • edited by rijkvanzanten

Describe the Bug

To Reproduce

Errors Shown

What version of Directus are you using?

What version of Node.js are you using?

What database are you using?

What browser are you using?

How are you deploying Directus?

rijkvanzanten commented Jun 7, 2022

aidenfoxx commented Jun 7, 2022 • edited

aidenfoxx commented Jun 29, 2022

bernatvadell commented Jun 7, 2022 •

edited by rijkvanzanten

aidenfoxx commented Jun 7, 2022 •

edited