[ https://issues.redhat.com/browse/TEIID-5963?page=com.atlassian.jira.plugi... ] Renat Eskenin edited comment on TEIID-5963 at 6/2/20 4:10 AM: -------------------------------------------------------------- I get logs from start of loading metdata {code} CREATE SCHEMA schpostgresql ; HikariPool-1 - Starting... Loading driver configuration via classloader sun.misc.Launcher$AppClassLoader@764c12b6 5432/dwh PostgreSQL JDBC Driver 42.2.6 setDefaultFetchSize = 0 setPrepareThreshold = 5 5432 Creating new Encoding UTF-8 with fastASCIINumbers true Creating new Encoding UTF-8 with fastASCIINumbers true Creating new Encoding UTF-8 with fastASCIINumbers true FE=> SSLRequest <=BE SSLOk converting regular socket connection to ssl Receive Buffer Size is 65 536 Send Buffer Size is 34 560 FE=> StartupPacket(user=esb, database=dwh, client_encoding=UTF8, DateStyle=ISO, TimeZone=Europe/Prague, extra_float_digits=2) <=BE AuthenticationReqMD5(salt=9ab5a23a) FE=> Password(md5digest=) <=BE AuthenticationOk <=BE ParameterStatus(application_name = ) <=BE ParameterStatus(client_encoding = UTF8) <=BE ParameterStatus(DateStyle = ISO, MDY) <=BE ParameterStatus(integer_datetimes = on) <=BE ParameterStatus(IntervalStyle = postgres) <=BE ParameterStatus(is_superuser = off) <=BE ParameterStatus(server_encoding = UTF8) <=BE ParameterStatus(server_version = 11.1) <=BE ParameterStatus(session_authorization = ) <=BE ParameterStatus(standard_conforming_strings = on) <=BE ParameterStatus(TimeZone = Europe/Prague) <=BE BackendKeyData(pid=27 472,ckey=-1 415 578 489) <=BE ReadyForQuery(I) simple execute, handler=org.postgresql.core.SetupQueryRunner$SimpleResultHandler@c474a29, maxRows=0, fetchSize=0, flags=1 047 FE=> Parse(stmt=null,query="SET extra_float_digits = 3",oids={}) FE=> Bind(stmt=null,portal=null) FE=> Execute(portal=null,limit=1) FE=> Sync <=BE ParseComplete [null] <=BE BindComplete [unnamed] <=BE CommandStatus(SET) <=BE ReadyForQuery(I) simple execute, handler=org.postgresql.core.SetupQueryRunner$SimpleResultHandler@139d160c, maxRows=0, fetchSize=0, flags=1 047 FE=> Parse(stmt=null,query="SET application_name = 'PostgreSQL JDBC Driver'",oids={}) FE=> Bind(stmt=null,portal=null) FE=> Execute(portal=null,limit=1) FE=> Sync <=BE ParseComplete [null] <=BE BindComplete [unnamed] <=BE ParameterStatus(application_name = PostgreSQL JDBC Driver) <=BE CommandStatus(SET) <=BE ReadyForQuery(I) types using binary send = TIMESTAMPTZ,UUID,INT2_ARRAY,INT4_ARRAY,BYTEA,TEXT_ARRAY,TIMETZ,INT8,INT2,INT4,VARCHAR_ARRAY,INT8_ARRAY,POINT,TIMESTAMP,TIME,BOX,FLOAT4,FLOAT8,FLOAT4_ARRAY,FLOAT8_ARRAY types using binary receive = TIMESTAMPTZ,UUID,INT2_ARRAY,INT4_ARRAY,BYTEA,TEXT_ARRAY,TIMETZ,INT8,INT2,INT4,VARCHAR_ARRAY,INT8_ARRAY,POINT,DATE,TIMESTAMP,TIME,BOX,FLOAT4,FLOAT8,FLOAT4_ARRAY,FLOAT8_ARRAY integer date/time = true simple execute, handler=org.postgresql.jdbc.PgStatement$StatementResultHandler@15cbf325, maxRows=0, fetchSize=0, flags=21 FE=> Parse(stmt=null,query="",oids={}) FE=> Bind(stmt=null,portal=null) FE=> Describe(portal=null) FE=> Execute(portal=null,limit=1) FE=> Sync <=BE ParseComplete [null] <=BE BindComplete [unnamed] <=BE NoData <=BE EmptyQuery <=BE ReadyForQuery(I) simple execute, handler=org.postgresql.jdbc.PgStatement$StatementResultHandler@52e605bb, maxRows=0, fetchSize=0, flags=17 FE=> Parse(stmt=null,query="SHOW TRANSACTION ISOLATION LEVEL",oids={}) FE=> Bind(stmt=null,portal=null) FE=> Describe(portal=null) FE=> Execute(portal=null,limit=0) FE=> Sync <=BE ParseComplete [null] <=BE BindComplete [unnamed] <=BE RowDescription(1) Field(transaction_isolation,TEXT,65535,T) <=BE DataRow(len=14) <=BE CommandStatus(SHOW) <=BE ReadyForQuery(I) 1 HikariPool-1 - Start completed. PostgreSQLExecutionFactory Commit=true;DatabaseProductName=PostgreSQL;DatabaseProductVersion=11.1;DriverMajorVersion=42;DriverMajorVersion=2;DriverName=PostgreSQL JDBC Driver;DriverVersion=42.2.6;IsolationLevel=2 simple execute, handler=org.postgresql.jdbc.PgStatement$StatementResultHandler@1116c4d1, maxRows=0, fetchSize=0, flags=17 FE=> Parse(stmt=null,query="SELECT t.typname,t.oid FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON (t.typnamespace = n.oid) WHERE n.nspname != 'pg_toast' AND (t.typrelid = 0 OR (SELECT c.relkind = 'c' FROM pg_catalog.pg_class c WHERE c.oid = t.typrelid))",oids={}) FE=> Bind(stmt=null,portal=null) FE=> Describe(portal=null) FE=> Execute(portal=null,limit=0) FE=> Sync 5432/dwh PostgreSQL JDBC Driver 42.2.6 setDefaultFetchSize = 0 setPrepareThreshold = 5 5432 <=BE ParseComplete [null] <=BE BindComplete [unnamed] <=BE RowDescription(2) Field(typname,NAME,64,T) Field(oid,OID,4,T) <=BE DataRow(len=6) <=BE DataRow(len=7) <=BE DataRow(len=6) <=BE DataRow(len=6) <=BE DataRow(len=6) <=BE DataRow(len=6) <=BE DataRow(len=12) <=BE DataRow(len=6) <=BE DataRow(len=9) <=BE DataRow(len=6) <=BE DataRow(len=5) <=BE DataRow(len=5) <=BE DataRow(len=5) {code} was (Author: i3draven): I get logs from start of loading metdata {code} CREATE SCHEMA schpostgresql ; HikariPool-1 - Starting... Loading driver configuration via classloader sun.misc.Launcher$AppClassLoader@764c12b6 5432/dwh PostgreSQL JDBC Driver 42.2.6 setDefaultFetchSize = 0 setPrepareThreshold = 5 5432 Creating new Encoding UTF-8 with fastASCIINumbers true Creating new Encoding UTF-8 with fastASCIINumbers true Creating new Encoding UTF-8 with fastASCIINumbers true FE=> SSLRequest <=BE SSLOk converting regular socket connection to ssl Receive Buffer Size is 65 536 Send Buffer Size is 34 560 FE=> StartupPacket(user=esb, database=dwh, client_encoding=UTF8, DateStyle=ISO, TimeZone=Europe/Prague, extra_float_digits=2) <=BE AuthenticationReqMD5(salt=9ab5a23a) FE=> Password(md5digest=md546c3564fd138692177070179f0dcb87b) <=BE AuthenticationOk <=BE ParameterStatus(application_name = ) <=BE ParameterStatus(client_encoding = UTF8) <=BE ParameterStatus(DateStyle = ISO, MDY) <=BE ParameterStatus(integer_datetimes = on) <=BE ParameterStatus(IntervalStyle = postgres) <=BE ParameterStatus(is_superuser = off) <=BE ParameterStatus(server_encoding = UTF8) <=BE ParameterStatus(server_version = 11.1) <=BE ParameterStatus(session_authorization = esb) <=BE ParameterStatus(standard_conforming_strings = on) <=BE ParameterStatus(TimeZone = Europe/Prague) <=BE BackendKeyData(pid=27 472,ckey=-1 415 578 489) <=BE ReadyForQuery(I) simple execute, handler=org.postgresql.core.SetupQueryRunner$SimpleResultHandler@c474a29, maxRows=0, fetchSize=0, flags=1 047 FE=> Parse(stmt=null,query="SET extra_float_digits = 3",oids={}) FE=> Bind(stmt=null,portal=null) FE=> Execute(portal=null,limit=1) FE=> Sync <=BE ParseComplete [null] <=BE BindComplete [unnamed] <=BE CommandStatus(SET) <=BE ReadyForQuery(I) simple execute, handler=org.postgresql.core.SetupQueryRunner$SimpleResultHandler@139d160c, maxRows=0, fetchSize=0, flags=1 047 FE=> Parse(stmt=null,query="SET application_name = 'PostgreSQL JDBC Driver'",oids={}) FE=> Bind(stmt=null,portal=null) FE=> Execute(portal=null,limit=1) FE=> Sync <=BE ParseComplete [null] <=BE BindComplete [unnamed] <=BE ParameterStatus(application_name = PostgreSQL JDBC Driver) <=BE CommandStatus(SET) <=BE ReadyForQuery(I) types using binary send = TIMESTAMPTZ,UUID,INT2_ARRAY,INT4_ARRAY,BYTEA,TEXT_ARRAY,TIMETZ,INT8,INT2,INT4,VARCHAR_ARRAY,INT8_ARRAY,POINT,TIMESTAMP,TIME,BOX,FLOAT4,FLOAT8,FLOAT4_ARRAY,FLOAT8_ARRAY types using binary receive = TIMESTAMPTZ,UUID,INT2_ARRAY,INT4_ARRAY,BYTEA,TEXT_ARRAY,TIMETZ,INT8,INT2,INT4,VARCHAR_ARRAY,INT8_ARRAY,POINT,DATE,TIMESTAMP,TIME,BOX,FLOAT4,FLOAT8,FLOAT4_ARRAY,FLOAT8_ARRAY integer date/time = true simple execute, handler=org.postgresql.jdbc.PgStatement$StatementResultHandler@15cbf325, maxRows=0, fetchSize=0, flags=21 FE=> Parse(stmt=null,query="",oids={}) FE=> Bind(stmt=null,portal=null) FE=> Describe(portal=null) FE=> Execute(portal=null,limit=1) FE=> Sync <=BE ParseComplete [null] <=BE BindComplete [unnamed] <=BE NoData <=BE EmptyQuery <=BE ReadyForQuery(I) simple execute, handler=org.postgresql.jdbc.PgStatement$StatementResultHandler@52e605bb, maxRows=0, fetchSize=0, flags=17 FE=> Parse(stmt=null,query="SHOW TRANSACTION ISOLATION LEVEL",oids={}) FE=> Bind(stmt=null,portal=null) FE=> Describe(portal=null) FE=> Execute(portal=null,limit=0) FE=> Sync <=BE ParseComplete [null] <=BE BindComplete [unnamed] <=BE RowDescription(1) Field(transaction_isolation,TEXT,65535,T) <=BE DataRow(len=14) <=BE CommandStatus(SHOW) <=BE ReadyForQuery(I) 1 HikariPool-1 - Start completed. PostgreSQLExecutionFactory Commit=true;DatabaseProductName=PostgreSQL;DatabaseProductVersion=11.1;DriverMajorVersion=42;DriverMajorVersion=2;DriverName=PostgreSQL JDBC Driver;DriverVersion=42.2.6;IsolationLevel=2 simple execute, handler=org.postgresql.jdbc.PgStatement$StatementResultHandler@1116c4d1, maxRows=0, fetchSize=0, flags=17 FE=> Parse(stmt=null,query="SELECT t.typname,t.oid FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON (t.typnamespace = n.oid) WHERE n.nspname != 'pg_toast' AND (t.typrelid = 0 OR (SELECT c.relkind = 'c' FROM pg_catalog.pg_class c WHERE c.oid = t.typrelid))",oids={}) FE=> Bind(stmt=null,portal=null) FE=> Describe(portal=null) FE=> Execute(portal=null,limit=0) FE=> Sync 5432/dwh PostgreSQL JDBC Driver 42.2.6 setDefaultFetchSize = 0 setPrepareThreshold = 5 5432 <=BE ParseComplete [null] <=BE BindComplete [unnamed] <=BE RowDescription(2) Field(typname,NAME,64,T) Field(oid,OID,4,T) <=BE DataRow(len=6) <=BE DataRow(len=7) <=BE DataRow(len=6) <=BE DataRow(len=6) <=BE DataRow(len=6) <=BE DataRow(len=6) <=BE DataRow(len=12) <=BE DataRow(len=6) <=BE DataRow(len=9) <=BE DataRow(len=6) <=BE DataRow(len=5) <=BE DataRow(len=5) <=BE DataRow(len=5) {code} -- This message was sent by Atlassian Jira (v7.13.8#713008)