system.zookeeper_log

    For requests, only columns with request parameters are filled in, and the remaining columns are filled with default values ( or NULL). When the response arrives, the data from the response is added to the other columns.

    • type (Enum) — Event type in the ZooKeeper client. Can have one of the following values:
      • Request — The request has been sent.
      • Response — The response was received.
      • Finalize — The connection is lost, no response was received.
    • event_date () — The date when the event happened.
    • event_time (DateTime64) — The date and time when the event happened.
    • address () — IP address of ZooKeeper server that was used to make the request.
    • port (UInt16) — The port of ZooKeeper server that was used to make the request.
    • session_id () — The session ID that the ZooKeeper server sets for each connection.
    • xid (Int32) — The ID of the request within the session. This is usually a sequential request number. It is the same for the request row and the paired response/finalize row.
    • has_watch () — The request whether the watch has been set.
    • op_num () — The type of request or response.
    • path (String) — The path to the ZooKeeper node specified in the request, or an empty string if the request not requires specifying a path.
    • data () — The data written to the ZooKeeper node (for the SET and CREATE requests — what the request wanted to write, for the response to the GET request — what was read) or an empty string.
    • is_ephemeral (UInt8) — Is the ZooKeeper node being created as an .
    • is_sequential (UInt8) — Is the ZooKeeper node being created as an .
    • version (Nullable(Int32)) — The version of the ZooKeeper node that the request expects when executing. This is supported for CHECK, SET, REMOVE requests (is relevant -1 if the request does not check the version or NULL for other requests that do not support version checking).
    • requests_size () — The number of requests included in the multi request (this is a special request that consists of several consecutive ordinary requests and executes them atomically). All requests included in multi request will have the same xid.
    • request_idx (UInt32) — The number of the request included in multi request (for multi request — 0, then in order from 1).

    Columns with request response parameters:

    • zxid () — ZooKeeper transaction ID. The serial number issued by the ZooKeeper server in response to a successfully executed request (0 if the request was not executed/returned an error/the client does not know whether the request was executed).
    • error (Nullable(Enum)) — Error code. Can have many values, here are just some of them:
      • ZOK — The request was executed seccessfully.
      • ZCONNECTIONLOSS — The connection was lost.
      • ZOPERATIONTIMEOUT — The request execution timeout has expired.
      • ZSESSIONEXPIRED — The session has expired.
      • NULL — The request is completed.
    • watch_type () — The type of the event (for responses with op_num = Watch), for the remaining responses: NULL.
    • watch_state (Nullable(Enum)) — The status of the watch event (for responses with op_num = Watch), for the remaining responses: NULL.
    • path_created () — The path to the created ZooKeeper node (for responses to the CREATE request), may differ from the path if the node is created as a sequential.
    • stat_czxid (Int64) — The zxid of the change that caused this ZooKeeper node to be created.
    • stat_mzxid () — The zxid of the change that last modified this ZooKeeper node.
    • stat_pzxid (Int64) — The transaction ID of the change that last modified childern of this ZooKeeper node.
    • stat_version () — The number of changes to the data of this ZooKeeper node.
    • stat_dataLength (Int32) — The length of the data field of this ZooKeeper node.
    • stat_numChildren () — The number of children of this ZooKeeper node.
    • children (Array(String)) — The list of child ZooKeeper nodes (for responses to LIST request).

    Query:

    1. Row 1:
    2. ──────
    3. type:             Request
    4. event_date:       2021-08-09
    5. event_time:       2021-08-09 21:38:30.291792
    6. address:          ::
    7. port:             2181
    8. session_id:       106662742089334927
    9. xid:              10858
    10. has_watch:        1
    11. op_num:           List
    12. path:             /clickhouse/task_queue/ddl
    13. data:             
    14. is_ephemeral:     0
    15. is_sequential:    0
    16. version:          ᴺᵁᴸᴸ
    17. requests_size:    0
    18. request_idx:      0
    19. zxid:             0
    21. watch_type:       ᴺᵁᴸᴸ
    22. watch_state:      ᴺᵁᴸᴸ
    23. path_created:     
    24. stat_czxid:       0
    25. stat_mzxid:       0
    26. stat_pzxid:       0
    27. stat_version:     0
    28. stat_cversion:    0
    29. stat_dataLength:  0
    30. stat_numChildren: 0
    32. Row 2:
    33. ──────
    34. type:             Response
    35. event_date:       2021-08-09
    36. event_time:       2021-08-09 21:38:30.292086
    37. address:          ::
    38. port:             2181
    39. session_id:       106662742089334927
    40. xid:              10858
    41. has_watch:        1
    42. op_num:           List
    43. path:             /clickhouse/task_queue/ddl
    44. data:             
    45. is_ephemeral:     0
    46. is_sequential:    0
    47. version:          ᴺᵁᴸᴸ
    48. requests_size:    0
    49. request_idx:      0
    50. zxid:             16926267
    51. error:            ZOK
    52. watch_type:       ᴺᵁᴸᴸ
    53. watch_state:      ᴺᵁᴸᴸ
    54. path_created:     
    55. stat_czxid:       16925469
    56. stat_mzxid:       16925469
    57. stat_pzxid:       16926179
    58. stat_version:     0
    59. stat_cversion:    7
    60. stat_dataLength:  0
    61. stat_numChildren: 7

    See Also