[teiid-issues] [JBoss JIRA] (TEIID-5963) Teiid imported all schemas from PG

Renat Eskenin (Jira) issues at jboss.org
Tue Jun 2 04:12:00 EDT 2020 

    [ https://issues.redhat.com/browse/TEIID-5963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14129709#comment-14129709 ] 

Renat Eskenin edited comment on TEIID-5963 at 6/2/20 4:11 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 at 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=)
  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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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}

> Teiid imported all schemas from PG
> ----------------------------------
>
>                 Key: TEIID-5963
>                 URL: https://issues.redhat.com/browse/TEIID-5963
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 14.0
>            Reporter: Renat Eskenin
>            Assignee: Steven Hawkins
>            Priority: Major
>
> When we started teiid spring boot app, we have long start time.



--
This message was sent by Atlassian Jira
(v7.13.8#713008)

More information about the teiid-issues mailing list