tests/pgsql/pgsql-cancel-request/test.yaml

   1 requires:
   2    min-version: 7
   3 args:
   4 - -k none
   5 - --set stream.midstream=true
   6
   7 checks:
   8 - filter:
   9     count: 1
  10     match:
  11       dest_ip: 100.96.199.113
  12       dest_port: 5432
  13       event_type: pgsql
  14       pgsql.request.message: SSL Request
  15       pgsql.response.ssl_accepted: false
  16       pgsql.tx_id: 1
  17       src_ip: 100.88.2.140
  18       src_port: 39704
  19 - filter:
  20     count: 1
  21     match:
  22       dest_ip: 100.96.199.113
  23       dest_port: 5432
  24       event_type: pgsql
  25       pgsql.request.protocol_version: '3.0'
  26       pgsql.request.startup_parameters.optional_parameters[0].database: rules
  27       pgsql.request.startup_parameters.optional_parameters[1].application_name: psql
  28       pgsql.request.startup_parameters.optional_parameters[2].client_encoding: UTF8
  29       pgsql.request.startup_parameters.user: rules
  30       pgsql.tx_id: 2
  31       src_ip: 100.88.2.140
  32       src_port: 39704
  33 - filter:
  34     count: 1
  35     match:
  36       dest_ip: 100.96.199.113
  37       dest_port: 5432
  38       event_type: pgsql
  39       pgsql.response.message: authentication_ok
  40       pgsql.response.parameter_status[0].application_name: psql
  41       pgsql.response.process_id: 28954
  42       pgsql.response.secret_key: 889887985
  43       pgsql.tx_id: 3
  44       src_ip: 100.88.2.140
  45       src_port: 39704
  46 - filter:
  47     count: 1
  48     match:
  49       dest_ip: 100.96.199.113
  50       dest_port: 5432
  51       event_type: pgsql
  52       pcap_cnt: 23
  53       pgsql.request.simple_query: select pg_sleep(9)
  54       pgsql.response.code: '57014'
  55       pgsql.response.field_count: 1
  56       pgsql.response.file: postgres.c
  57       pgsql.response.line: '3211'
  58       pgsql.response.message: canceling statement due to user request
  59       pgsql.response.routine: ProcessInterrupts
  60       pgsql.response.severity_localizable: ERROR
  61       pgsql.response.severity_non_localizable: ERROR
  62       pgsql.tx_id: 4
  63       src_ip: 100.88.2.140
  64       src_port: 39704
  65 - filter:
  66     count: 1
  67     match:
  68       dest_ip: 100.96.199.113
  69       dest_port: 5432
  70       event_type: pgsql
  71       pgsql.request.message: termination_message
  72       pgsql.tx_id: 5
  73       src_ip: 100.88.2.140
  74       src_port: 39704
  75 - filter:
  76     count: 1
  77     match:
  78       dest_ip: 100.96.199.113
  79       dest_port: 5432
  80       event_type: pgsql
  81       pgsql.request.secret_key: 889887985
  82       pgsql.request.message: cancel_request
  83       pgsql.request.process_id: 28954
  84       pgsql.tx_id: 1
  85       src_ip: 100.88.2.140
  86       src_port: 39706
  87 - filter:
  88     count: 2
  89     match:
  90       app_proto: pgsql
  91       event_type: flow