You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Marco Jorge (Jira)" <ji...@apache.org> on 2021/12/23 17:22:00 UTC
[jira] [Commented] (CALCITE-4962) Protobuf debug does not show request/response type
[ https://issues.apache.org/jira/browse/CALCITE-4962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17464713#comment-17464713 ]
Marco Jorge commented on CALCITE-4962:
--------------------------------------
Please see https://github.com/apache/calcite-avatica/pull/169.
> Protobuf debug does not show request/response type
> --------------------------------------------------
>
> Key: CALCITE-4962
> URL: https://issues.apache.org/jira/browse/CALCITE-4962
> Project: Calcite
> Issue Type: Improvement
> Components: avatica
> Reporter: Marco Jorge
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> _(nicetities first - great project and thanks all for the great work)_
> The ProtobufTranslationImpl is able to debug the content of the messages encoded/decoded but it does not show the request/response type which is critical to identify anormal situations.
> The current output is:
> {code:java}
> 2021-12-23 16:31:36 | TRACE | ProtobufTranslationImpl:108 - Deserialized request 'connection_id: "ef7886f8-4800-4ddc-86c7-b01f6e7bd61b" info { key: "password" value: "" } info { key: "user" value: "" }'
> 2021-12-23 16:31:36 | TRACE | ProtobufTranslationImpl:351 - Serializing response 'metadata { server_address: "container-queryengine-tenant-be62-1792c303378a-677fcbfcc7-kvlz5:8080" }'
> 2021-12-23 16:31:36 | TRACE | ProtobufTranslationImpl:108 - Deserialized request 'connection_id: "ef7886f8-4800-4ddc-86c7-b01f6e7bd61b" conn_props { is_dirty: true auto_commit: true has_auto_commit: true }'
> 2021-12-23 16:31:36 | TRACE | ProtobufTranslationImpl:351 - Serializing response 'conn_props { auto_commit: true has_auto_commit: true has_read_only: true } metadata { server_address: "container-queryengine-tenant-be62-1792c303378a-677fcbfcc7-kvlz5:8080" }'
> 2021-12-23 16:31:36 | TRACE | ProtobufTranslationImpl:108 - Deserialized request 'connection_id: "ef7886f8-4800-4ddc-86c7-b01f6e7bd61b"'
> 2021-12-23 16:31:36 | TRACE | ProtobufTranslationImpl:351 - Serializing response 'props { key { name: "GET_NUMERIC_FUNCTIONS" } value { type: STRING string_value: "ABS,ACOS,ASIN,ATAN,ATAN2,CBRT,CEILING,COS,COT,DEGREES,EXP,FLOOR,LOG,LOG10,MOD,PI,POWER,RADIANS,RAND,ROUND,SIGN,SIN,SQRT,TAN,TRUNCATE" } } props { key { name: "GET_S_Q_L_KEYWORDS" } value { type: STRING string_value: "ABS,ALLOW,ARRAY,ARRAY_MAX_CARDINALITY,ASENSITIVE,ASYMMETRIC,ATOMIC,BEGIN_FRAME,BEGIN_PARTITION,BIGINT,BINARY,BLOB,BOOLEAN,CALLED,CARDINALITY,CEIL,CEILING,CLASSIFIER,CLOB,COLLECT,CORR,COVAR_POP,COVAR_SAMP,CUBE,CUME_DIST,CURRENT_CATALOG,CURRENT_DEFAULT_TRANSFORM_GROUP,CURRENT_ROLE,CURRENT_ROW,CURRENT_SCHEMA,CURRENT_TRANSFORM_GROUP_FOR_TYPE,CYCLE,DEFINE,DENSE_RANK,DEREF,DISALLOW,DYNAMIC,EACH,ELEMENT,EMPTY,END-EXEC,END_FRAME,END_PARTITION,EQUALS,EVERY,EXP,EXPLAIN,EXTEND,FILTER,FIRST_VALUE,FLOOR,FRAME_ROW,FREE,FUSION,GROUPING,GROUPS,HOLD,IMPORT,INITIAL,INTERSECTION,JSON_ARRAY,JSON_ARRAYAGG,JSON_EXISTS,JSON_OBJECT,JSON_OBJECTAGG,JSON_QUERY,JSON_VALUE,LAG,LARGE,LAST_VALUE,LATERAL,LEAD,LIKE_REGEX,LIMIT,LN,LOCALTIME,LOCALTIMESTAMP,MATCHES,MATCH_NUMBER,MATCH_RECOGNIZE,MEASURES,MEMBER,MERGE,METHOD,MINUS,MOD,MODIFIES,MULTISET,NCLOB,NEW,NONE,NORMALIZE,NTH_VALUE,NTILE,OCCURRENCES_REGEX,OFFSET,OLD,OMIT,ONE,OVER,OVERLAY,PARTITION,PATTERN,PER,PERCENT,PERCENTILE_CONT,PERCENTILE_DISC,PERCENT_RANK,PERIOD,PERMUTE,PORTION,POSITION_REGEX,POWER,PRECEDES,PREV,RANGE,RANK,READS,RECURSIVE,REF,REFERENCING,REGR_AVGX,REGR_AVGY,REGR_COUNT,REGR_INTERCEPT,REGR_R2,REGR_SLOPE,REGR_SXX,REGR_SXY,REGR_SYY,RELEASE,RESET,RESULT,ROLLUP,ROW,ROW_NUMBER,RUNNING,SAVEPOINT,SCOPE,SEARCH,SEEK,SENSITIVE,SHOW,SIMILAR,SKIP,SPECIFICTYPE,SQRT,START,STATIC,STDDEV_POP,STDDEV_SAMP,STREAM,SUBMULTISET,SUBSET,SUBSTRING_REGEX,SUCCEEDS,SYMMETRIC,SYSTEM,SYSTEM_TIME,TABLESAMPLE,TINYINT,TRANSLATE_REGEX,TREAT,TRIGGER,TRIM_ARRAY,TRUNCATE,UESCAPE,UNNEST,UPSERT,VALUE_OF,VARBINARY,VAR_POP,VAR_SAMP,VERSIONING,WIDTH_BUCKET,WINDOW,WITHIN,WITHOUT" } } props { key { name: "GET_DEFAULT_TRANSACTION_ISOLATION" } value { type: INTEGER } } props { key { name: "GET_TIME_DATE_FUNCTIONS" } value { type: STRING string_value: "CONVERT_TIMEZONE,CURDATE,CURTIME,DAYNAME,DAYOFMONTH,DAYOFWEEK,DAYOFYEAR,HOUR,MINUTE,MONTH,MONTHNAME,NOW,QUARTER,SECOND,TIMESTAMPADD,TIMESTAMPDIFF,TO_DATE,TO_TIMESTAMP,WEEK,YEAR" } } props { key { name: "GET_DRIVER_MAJOR_VERSION" } value { type: INTEGER number_value: 1 } } props { key { name: "GET_DRIVER_VERSION" } value { type: STRING string_value: "1.27.0" } } props { key { name: "GET_DATABASE_PRODUCT_VERSION" } value { type: STRING string_value: "1.27.0" } } props { key { name: "GET_SYSTEM_FUNCTIONS" } value { type: STRING string_value: "CONVERT,DATABASE,IFNULL,USER" } } props { key { name: "GET_STRING_FUNCTIONS" } value { type: STRING string_value: "ASCII,CONCAT,DIFFERENCE,INSERT,LCASE,LEFT,LENGTH,LOCATE,LTRIM,REPEAT,REPLACE,RIGHT,RTRIM,SOUNDEX,SPACE,SUBSTRING,UCASE" } } props { key { name: "GET_DRIVER_NAME" } value { type: STRING string_value: "Calcite JDBC Driver" } } props { key { name: "GET_DATABASE_MINOR_VERSION" } value { type: INTEGER number_value: 27 } } props { key { name: "GET_DATABASE_PRODUCT_NAME" } value { type: STRING string_value: "Calcite" } } props { key { name: "AVATICA_VERSION" } value { type: STRING string_value: "1.19.0" } } props { key { name: "GET_DRIVER_MINOR_VERSION" } value { type: INTEGER number_value: 27 } } props { key { name: "GET_DATABASE_MAJOR_VERSION" } value { type: INTEGER number_value: 1 } } metadata { server_address: "container-queryengine-tenant-be62-1792c303378a-677fcbfcc7-kvlz5:8080" }'
> 2021-12-23 16:31:46 | TRACE | ProtobufTranslationImpl:108 - Deserialized request 'connection_id: "ef7886f8-4800-4ddc-86c7-b01f6e7bd61b"'
> 2021-12-23 16:31:46 | TRACE | ProtobufTranslationImpl:351 - Serializing response 'metadata { server_address: "container-queryengine-tenant-be62-1792c303378a-677fcbfcc7-kvlz5:8080" }'{code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)