By type
start init db ... You are now connected to database "datalake" as user "datalake". psql:/datalake/init_db.sql:30: ERROR: relation "topic_name" already exists psql:/datalake/init_db.sql:37: ERROR: relation "db_type" already exists psql:/datalake/init_db.sql:38: ERROR: relation "db_seq" already exists psql:/datalake/init_db.sql:57: ERROR: relation "db" already exists psql:/datalake/init_db.sql:59: ERROR: relation "fk3njadtw43ieph7ftt4kxdhcko" already exists psql:/datalake/init_db.sql:67: ERROR: relation "design_type" already exists psql:/datalake/init_db.sql:69: ERROR: relation "fkm8rkv2qkq01gsmeq1c3y4w02x" already exists psql:/datalake/init_db.sql:70: ERROR: relation "design_seq" already exists psql:/datalake/init_db.sql:83: ERROR: relation "design" already exists psql:/datalake/init_db.sql:85: ERROR: relation "fko43yi6aputq6kwqqu8eqbspm5" already exists psql:/datalake/init_db.sql:86: ERROR: relation "fkabb8e74230glxpaiai4aqsr34" already exists psql:/datalake/init_db.sql:87: ERROR: relation "kafka_seq" already exists psql:/datalake/init_db.sql:105: ERROR: relation "kafka" already exists psql:/datalake/init_db.sql:106: ERROR: relation "topic_seq" already exists psql:/datalake/init_db.sql:123: ERROR: relation "topic" already exists psql:/datalake/init_db.sql:125: ERROR: relation "fkj3pldlfaokdhqjfva8n3pkjca" already exists psql:/datalake/init_db.sql:132: ERROR: relation "map_db_design" already exists psql:/datalake/init_db.sql:134: ERROR: relation "fkhpn49r94k05mancjtn301m2p0" already exists psql:/datalake/init_db.sql:141: ERROR: relation "map_db_topic" already exists psql:/datalake/init_db.sql:143: ERROR: relation "fkq1jon185jnrr7dv1dd8214uw0" already exists psql:/datalake/init_db.sql:150: ERROR: relation "map_kafka_topic" already exists psql:/datalake/init_db.sql:152: ERROR: relation "fktdrme4h7rxfh04u2i2wqu23g5" already exists CREATE TABLE CREATE INDEX You are now connected to database "datalake" as user "datalake". psql:/datalake/init_db_data.sql:51: ERROR: duplicate key value violates unique constraint "kafka_pkey" DETAIL: Key (id)=(1) already exists. psql:/datalake/init_db_data.sql:52: ERROR: duplicate key value violates unique constraint "db_type_pkey" DETAIL: Key (id)=(CB) already exists. psql:/datalake/init_db_data.sql:53: ERROR: duplicate key value violates unique constraint "db_type_pkey" DETAIL: Key (id)=(ES) already exists. psql:/datalake/init_db_data.sql:54: ERROR: duplicate key value violates unique constraint "db_type_pkey" DETAIL: Key (id)=(MONGO) already exists. psql:/datalake/init_db_data.sql:55: ERROR: duplicate key value violates unique constraint "db_type_pkey" DETAIL: Key (id)=(DRUID) already exists. psql:/datalake/init_db_data.sql:56: ERROR: duplicate key value violates unique constraint "db_type_pkey" DETAIL: Key (id)=(HDFS) already exists. psql:/datalake/init_db_data.sql:57: ERROR: duplicate key value violates unique constraint "db_type_pkey" DETAIL: Key (id)=(KIBANA) already exists. psql:/datalake/init_db_data.sql:58: ERROR: duplicate key value violates unique constraint "db_type_pkey" DETAIL: Key (id)=(SUPERSET) already exists. psql:/datalake/init_db_data.sql:59: ERROR: duplicate key value violates unique constraint "db_pkey" DETAIL: Key (id)=(1) already exists. psql:/datalake/init_db_data.sql:60: ERROR: duplicate key value violates unique constraint "db_pkey" DETAIL: Key (id)=(2) already exists. psql:/datalake/init_db_data.sql:61: ERROR: column "presto_catalog" of relation "db" does not exist LINE 1: ...d, enabled, encrypt, name,host,port,database_name,presto_cat... ^ psql:/datalake/init_db_data.sql:62: ERROR: duplicate key value violates unique constraint "db_pkey" DETAIL: Key (id)=(4) already exists. psql:/datalake/init_db_data.sql:63: ERROR: duplicate key value violates unique constraint "db_pkey" DETAIL: Key (id)=(5) already exists. psql:/datalake/init_db_data.sql:64: ERROR: duplicate key value violates unique constraint "db_pkey" DETAIL: Key (id)=(6) already exists. INSERT 0 1 psql:/datalake/init_db_data.sql:66: ERROR: duplicate key value violates unique constraint "topic_name_pkey" DETAIL: Key (id)=(_DL_DEFAULT_) already exists. psql:/datalake/init_db_data.sql:67: ERROR: duplicate key value violates unique constraint "topic_name_pkey" DETAIL: Key (id)=(unauthenticated.SEC_FAULT_OUTPUT) already exists. psql:/datalake/init_db_data.sql:68: ERROR: duplicate key value violates unique constraint "topic_name_pkey" DETAIL: Key (id)=(unauthenticated.VES_MEASUREMENT_OUTPUT) already exists. psql:/datalake/init_db_data.sql:69: ERROR: duplicate key value violates unique constraint "topic_name_pkey" DETAIL: Key (id)=(EPC) already exists. psql:/datalake/init_db_data.sql:70: ERROR: duplicate key value violates unique constraint "topic_name_pkey" DETAIL: Key (id)=(HW) already exists. psql:/datalake/init_db_data.sql:72: ERROR: duplicate key value violates unique constraint "topic_pkey" DETAIL: Key (id)=(1) already exists. psql:/datalake/init_db_data.sql:74: ERROR: duplicate key value violates unique constraint "topic_pkey" DETAIL: Key (id)=(2) already exists. psql:/datalake/init_db_data.sql:79: ERROR: duplicate key value violates unique constraint "topic_pkey" DETAIL: Key (id)=(3) already exists. psql:/datalake/init_db_data.sql:81: ERROR: duplicate key value violates unique constraint "topic_pkey" DETAIL: Key (id)=(4) already exists. psql:/datalake/init_db_data.sql:85: ERROR: duplicate key value violates unique constraint "topic_pkey" DETAIL: Key (id)=(5) already exists. psql:/datalake/init_db_data.sql:86: ERROR: duplicate key value violates unique constraint "map_db_topic_pkey" DETAIL: Key (db_id, topic_id)=(1, 1) already exists. psql:/datalake/init_db_data.sql:87: ERROR: duplicate key value violates unique constraint "map_kafka_topic_pkey" DETAIL: Key (topic_id, kafka_id)=(1, 1) already exists. psql:/datalake/init_db_data.sql:88: ERROR: duplicate key value violates unique constraint "design_type_pkey" DETAIL: Key (id)=(KIBANA_DB) already exists. psql:/datalake/init_db_data.sql:89: ERROR: duplicate key value violates unique constraint "design_type_pkey" DETAIL: Key (id)=(KIBANA_SEARCH) already exists. psql:/datalake/init_db_data.sql:90: ERROR: duplicate key value violates unique constraint "design_type_pkey" DETAIL: Key (id)=(KIBANA_VISUAL) already exists. psql:/datalake/init_db_data.sql:91: ERROR: duplicate key value violates unique constraint "design_type_pkey" DETAIL: Key (id)=(ES_MAPPING) already exists. psql:/datalake/init_db_data.sql:92: ERROR: duplicate key value violates unique constraint "design_type_pkey" DETAIL: Key (id)=(DRUID_KAFKA_SPEC) already exists. psql:/datalake/init_db_data.sql:93: ERROR: duplicate key value violates unique constraint "design_pkey" DETAIL: Key (id)=(1) already exists. psql:/datalake/init_db_data.sql:94: ERROR: duplicate key value violates unique constraint "map_db_design_pkey" DETAIL: Key (design_id, db_id)=(1, 6) already exists. INSERT 0 1 INSERT 0 1 INSERT 0 1 finish init db 04:44:12,506 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback-test.xml] 04:44:12,507 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback.groovy] 04:44:12,508 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Found resource [logback.xml] at [jar:file:/datalake/des-1.1.1-execute.jar!/BOOT-INF/classes!/logback.xml] 04:44:12,537 |-INFO in ch.qos.logback.core.joran.spi.ConfigurationWatchList@6b0c2d26 - URL [jar:file:/datalake/des-1.1.1-execute.jar!/BOOT-INF/classes!/logback.xml] is not of type file 04:44:12,631 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - debug attribute not set 04:44:12,634 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.core.ConsoleAppender] 04:44:12,645 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [STDOUT] 04:44:12,722 |-WARN in ch.qos.logback.core.ConsoleAppender[STDOUT] - This appender no longer admits a layout as a sub-component, set an encoder instead. 04:44:12,722 |-WARN in ch.qos.logback.core.ConsoleAppender[STDOUT] - To ensure compatibility, wrapping your layout in LayoutWrappingEncoder. 04:44:12,722 |-WARN in ch.qos.logback.core.ConsoleAppender[STDOUT] - See also http://logback.qos.ch/codes.html#layoutInsteadOfEncoder for details 04:44:12,725 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting level of logger [org.onap.datalake] to DEBUG 04:44:12,725 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [org.onap.datalake] to false 04:44:12,725 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [STDOUT] to Logger[org.onap.datalake] 04:44:12,726 |-INFO in ch.qos.logback.classic.joran.action.RootLoggerAction - Setting level of ROOT logger to ERROR 04:44:12,726 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [STDOUT] to Logger[ROOT] 04:44:12,726 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - End of configuration. 04:44:12,728 |-INFO in ch.qos.logback.classic.joran.JoranConfigurator@3d3fcdb0 - Registering current configuration as safe fallback point . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v2.1.0.RELEASE) 2022-09-22 04:44:13,751 |INFO | [ main] org.onap.datalake.des.DesApplication:50 - Starting DesApplication on dcae-datalake-des with PID 11 (/datalake/des-1.1.1-execute.jar started by datalake in /datalake) 2022-09-22 04:44:13,760 |DEBUG| [ main] org.onap.datalake.des.DesApplication:53 - Running with Spring Boot v2.1.0.RELEASE, Spring v5.1.2.RELEASE 2022-09-22 04:44:13,765 |INFO | [ main] org.onap.datalake.des.DesApplication:675 - No active profile set, falling back to default profiles: default 2022-09-22 04:44:26,133 |INFO | [ main] org.onap.datalake.des.DesApplication:59 - Started DesApplication in 13.28 seconds (JVM running for 14.258) 2022-09-22 04:46:13,994 |INFO | [http-nio-1681-exec-1] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 04:47:43,437 |INFO | [http-nio-1681-exec-2] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 04:49:13,416 |INFO | [http-nio-1681-exec-3] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 04:50:43,424 |INFO | [http-nio-1681-exec-4] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 04:52:13,432 |INFO | [http-nio-1681-exec-5] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 04:53:43,421 |INFO | [http-nio-1681-exec-6] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 04:55:13,415 |INFO | [http-nio-1681-exec-7] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 04:56:43,434 |INFO | [http-nio-1681-exec-8] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 04:58:13,430 |INFO | [http-nio-1681-exec-9] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 04:59:43,416 |INFO | [ttp-nio-1681-exec-10] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:01:13,413 |INFO | [http-nio-1681-exec-1] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:02:43,423 |INFO | [http-nio-1681-exec-2] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:04:13,412 |INFO | [http-nio-1681-exec-3] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:05:43,411 |INFO | [http-nio-1681-exec-4] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:07:13,413 |INFO | [http-nio-1681-exec-5] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:08:43,414 |INFO | [http-nio-1681-exec-6] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:10:13,429 |INFO | [http-nio-1681-exec-7] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:11:43,413 |INFO | [http-nio-1681-exec-8] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:13:13,411 |INFO | [http-nio-1681-exec-9] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:14:43,436 |INFO | [ttp-nio-1681-exec-10] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:16:13,412 |INFO | [http-nio-1681-exec-1] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:17:43,439 |INFO | [http-nio-1681-exec-2] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:19:13,416 |INFO | [http-nio-1681-exec-3] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:20:43,417 |INFO | [http-nio-1681-exec-4] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:22:13,411 |INFO | [http-nio-1681-exec-5] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:23:43,422 |INFO | [http-nio-1681-exec-6] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:25:13,415 |INFO | [http-nio-1681-exec-7] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:26:43,422 |INFO | [http-nio-1681-exec-8] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:28:13,419 |INFO | [http-nio-1681-exec-9] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:29:43,416 |INFO | [ttp-nio-1681-exec-10] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:31:13,409 |INFO | [http-nio-1681-exec-1] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:32:43,421 |INFO | [http-nio-1681-exec-2] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:34:13,410 |INFO | [http-nio-1681-exec-3] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:35:43,410 |INFO | [http-nio-1681-exec-4] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:37:13,414 |INFO | [http-nio-1681-exec-5] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:38:43,410 |INFO | [http-nio-1681-exec-6] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:40:13,419 |INFO | [http-nio-1681-exec-7] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:41:43,413 |INFO | [http-nio-1681-exec-8] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:43:13,427 |INFO | [http-nio-1681-exec-9] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:44:43,424 |INFO | [ttp-nio-1681-exec-10] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:46:13,415 |INFO | [http-nio-1681-exec-1] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:47:43,421 |INFO | [http-nio-1681-exec-2] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:49:13,415 |INFO | [http-nio-1681-exec-3] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:50:43,417 |INFO | [http-nio-1681-exec-4] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:52:13,412 |INFO | [http-nio-1681-exec-5] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:53:43,414 |INFO | [http-nio-1681-exec-6] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:55:13,442 |INFO | [http-nio-1681-exec-7] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:56:43,413 |INFO | [http-nio-1681-exec-8] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:58:13,413 |INFO | [http-nio-1681-exec-9] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 05:59:43,411 |INFO | [ttp-nio-1681-exec-10] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:01:13,410 |INFO | [http-nio-1681-exec-1] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:02:43,424 |INFO | [http-nio-1681-exec-2] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:04:13,415 |INFO | [http-nio-1681-exec-3] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:05:43,411 |INFO | [http-nio-1681-exec-4] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:07:13,411 |INFO | [http-nio-1681-exec-5] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:08:43,411 |INFO | [http-nio-1681-exec-6] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:10:13,431 |INFO | [http-nio-1681-exec-7] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:11:43,412 |INFO | [http-nio-1681-exec-8] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:13:13,423 |INFO | [http-nio-1681-exec-9] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:14:43,429 |INFO | [ttp-nio-1681-exec-10] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:16:13,414 |INFO | [http-nio-1681-exec-1] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:17:43,413 |INFO | [http-nio-1681-exec-2] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:19:13,426 |INFO | [http-nio-1681-exec-3] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:20:43,419 |INFO | [http-nio-1681-exec-4] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:22:13,413 |INFO | [http-nio-1681-exec-5] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:23:43,411 |INFO | [http-nio-1681-exec-6] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:25:13,412 |INFO | [http-nio-1681-exec-7] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:26:43,426 |INFO | [http-nio-1681-exec-8] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:28:13,418 |INFO | [http-nio-1681-exec-9] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:29:43,415 |INFO | [ttp-nio-1681-exec-10] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:31:13,423 |INFO | [http-nio-1681-exec-1] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:32:43,418 |INFO | [http-nio-1681-exec-2] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:34:13,414 |INFO | [http-nio-1681-exec-3] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:35:43,433 |INFO | [http-nio-1681-exec-4] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:37:13,430 |INFO | [http-nio-1681-exec-5] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:38:43,414 |INFO | [http-nio-1681-exec-6] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null 2022-09-22 06:40:13,410 |INFO | [http-nio-1681-exec-7] org.onap.datalake.des.service.DataExposureService:76 - DataExposureList is not null