By type
[38;5;6mmariadb [38;5;5m06:26:07.41 [0m
[38;5;6mmariadb [38;5;5m06:26:07.45 [0m[1mWelcome to the Bitnami mariadb-galera container[0m
[38;5;6mmariadb [38;5;5m06:26:07.47 [0mSubscribe to project updates by watching [1mhttps://github.com/bitnami/bitnami-docker-mariadb-galera[0m
[38;5;6mmariadb [38;5;5m06:26:07.52 [0mSubmit issues and feature requests at [1mhttps://github.com/bitnami/bitnami-docker-mariadb-galera/issues[0m
[38;5;6mmariadb [38;5;5m06:26:07.55 [0m
[38;5;6mmariadb [38;5;5m06:26:07.58 [0m[38;5;2mINFO [0m ==> ** Starting MariaDB setup **
[38;5;6mmariadb [38;5;5m06:26:07.82 [0m[38;5;2mINFO [0m ==> Validating settings in MYSQL_*/MARIADB_* env vars
[38;5;6mmariadb [38;5;5m06:26:08.29 [0m[38;5;2mINFO [0m ==> Initializing mariadb database
[38;5;6mmariadb [38;5;5m06:26:08.33 [0m[38;5;5mDEBUG[0m ==> Ensuring expected directories/files exist
[38;5;6mmariadb [38;5;5m06:26:08.56 [0m[38;5;2mINFO [0m ==> Updating 'my.cnf' with custom configuration
[38;5;6mmariadb [38;5;5m06:26:08.63 [0m[38;5;2mINFO [0m ==> Setting user option
[38;5;6mmariadb [38;5;5m06:26:08.66 [0m[38;5;5mDEBUG[0m ==> Setting user to 'policy_user' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m06:26:08.79 [0m[38;5;2mINFO [0m ==> Setting wsrep_node_name option
[38;5;6mmariadb [38;5;5m06:26:08.82 [0m[38;5;5mDEBUG[0m ==> Setting wsrep_node_name to 'onap-policy-mariadb-0' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m06:26:08.92 [0m[38;5;2mINFO [0m ==> Setting wsrep_node_address option
[38;5;6mmariadb [38;5;5m06:26:08.96 [0m[38;5;5mDEBUG[0m ==> Setting wsrep_node_address to '10.233.68.224' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m06:26:09.31 [0m[38;5;2mINFO [0m ==> Setting wsrep_sst_auth option
[38;5;6mmariadb [38;5;5m06:26:09.34 [0m[38;5;5mDEBUG[0m ==> Setting wsrep_sst_auth to 'mariabackup:Woc74ZuP' in mariadb configuration file /opt/bitnami/mariadb/conf/my.cnf
[38;5;6mmariadb [38;5;5m06:26:09.43 [0m[38;5;2mINFO [0m ==> Persisted data detected. Restoring
[38;5;6mmariadb [38;5;5m06:26:09.75 [0m[38;5;2mINFO [0m ==> ** MariaDB setup finished! **
[38;5;6mmariadb [38;5;5m06:26:10.01 [0m[38;5;2mINFO [0m ==> ** Starting MariaDB **
[38;5;6mmariadb [38;5;5m06:26:10.04 [0m[38;5;2mINFO [0m ==> Setting previous boot
2022-03-22 6:26:10 0 [Warning] WSREP: option --wsrep-causal-reads is deprecated
2022-03-22 6:26:10 0 [Warning] WSREP: --wsrep-causal-reads=ON takes precedence over --wsrep-sync-wait=0. WSREP_SYNC_WAIT_BEFORE_READ is on
2022-03-22 6:26:10 0 [Note] /opt/bitnami/mariadb/sbin/mysqld (mysqld 10.5.8-MariaDB-log) starting as process 1 ...
2022-03-22 6:26:10 0 [Note] WSREP: Loading provider /opt/bitnami/mariadb/lib/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1
2022-03-22 6:26:10 0 [Note] WSREP: wsrep_load(): loading provider library '/opt/bitnami/mariadb/lib/libgalera_smm.so'
2022-03-22 6:26:10 0 [Note] WSREP: wsrep_load(): Galera 4.7(rXXXX) by Codership Oy loaded successfully.
2022-03-22 6:26:10 0 [Note] WSREP: CRC-32C: using 64-bit x86 acceleration.
2022-03-22 6:26:10 0 [Note] WSREP: Found saved state: b3857b06-a98c-11ec-82cb-e3d020540c65:1905, safe_to_bootstrap: 1
2022-03-22 6:26:10 0 [Note] WSREP: GCache DEBUG: opened preamble:
Version: 2
UUID: b3857b06-a98c-11ec-82cb-e3d020540c65
Seqno: 1 - 1905
Offset: 1280
Synced: 1
2022-03-22 6:26:10 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: b3857b06-a98c-11ec-82cb-e3d020540c65, offset: 1280
2022-03-22 6:26:10 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/134217752 bytes) complete.
2022-03-22 6:26:10 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (134217752/134217752 bytes) complete.
2022-03-22 6:26:10 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 1-1905
2022-03-22 6:26:10 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/2688008 bytes) complete.
2022-03-22 6:26:10 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (2688008/2688008 bytes) complete.
2022-03-22 6:26:10 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 0/1905 locked buffers
2022-03-22 6:26:10 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): free space: 131529720/134217728
2022-03-22 6:26:10 0 [Note] WSREP: Passing config to GCS: base_dir = /bitnami/mariadb/data/; base_host = 10.233.68.224; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /bitnami/mariadb/data/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S;
2022-03-22 6:26:10 0 [Note] WSREP: Service thread queue flushed.
2022-03-22 6:26:10 0 [Note] WSREP: ####### Assign initial position for certification: b3857b06-a98c-11ec-82cb-e3d020540c65:1905, protocol version: -1
2022-03-22 6:26:10 0 [Note] WSREP: Start replication
2022-03-22 6:26:10 0 [Note] WSREP: Connecting with bootstrap option: 1
2022-03-22 6:26:10 0 [Note] WSREP: Setting GCS initial position to b3857b06-a98c-11ec-82cb-e3d020540c65:1905
2022-03-22 6:26:10 0 [Note] WSREP: protonet asio version 0
2022-03-22 6:26:10 0 [Note] WSREP: Using CRC-32C for message checksums.
2022-03-22 6:26:10 0 [Note] WSREP: backend: asio
2022-03-22 6:26:10 0 [Note] WSREP: gcomm thread scheduling priority set to other:0
2022-03-22 6:26:10 0 [Warning] WSREP: access file(/bitnami/mariadb/data//gvwstate.dat) failed(No such file or directory)
2022-03-22 6:26:10 0 [Note] WSREP: restore pc from disk failed
2022-03-22 6:26:10 0 [Note] WSREP: GMCast version 0
2022-03-22 6:26:10 0 [Note] WSREP: (f6fb686a-bc47, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2022-03-22 6:26:10 0 [Note] WSREP: (f6fb686a-bc47, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2022-03-22 6:26:10 0 [Note] WSREP: EVS version 1
2022-03-22 6:26:10 0 [Note] WSREP: gcomm: bootstrapping new group 'galera'
2022-03-22 6:26:10 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery
2022-03-22 6:26:10 0 [Note] WSREP: EVS version upgrade 0 -> 1
2022-03-22 6:26:10 0 [Note] WSREP: PC protocol upgrade 0 -> 1
2022-03-22 6:26:10 0 [Note] WSREP: Node f6fb686a-bc47 state prim
2022-03-22 6:26:10 0 [Note] WSREP: view(view_id(PRIM,f6fb686a-bc47,1) memb {
f6fb686a-bc47,0
} joined {
} left {
} partitioned {
})
2022-03-22 6:26:10 0 [Note] WSREP: save pc into disk
2022-03-22 6:26:10 0 [Note] WSREP: gcomm: connected
2022-03-22 6:26:10 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2022-03-22 6:26:10 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2022-03-22 6:26:10 0 [Note] WSREP: Opened channel 'galera'
2022-03-22 6:26:10 1 [Note] WSREP: Starting rollbacker thread 1
2022-03-22 6:26:10 2 [Note] WSREP: Starting applier thread 2
2022-03-22 6:26:10 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
2022-03-22 6:26:10 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: f6fd46aa-a9a8-11ec-9d9d-da091ae5918f
2022-03-22 6:26:10 0 [Note] WSREP: STATE EXCHANGE: sent state msg: f6fd46aa-a9a8-11ec-9d9d-da091ae5918f
2022-03-22 6:26:10 0 [Note] WSREP: STATE EXCHANGE: got state msg: f6fd46aa-a9a8-11ec-9d9d-da091ae5918f from 0 (onap-policy-mariadb-0)
2022-03-22 6:26:10 0 [Note] WSREP: Quorum results:
version = 6,
component = PRIMARY,
conf_id = 0,
members = 1/1 (joined/total),
act_id = 1905,
last_appl. = 1905,
protocols = 2/10/4 (gcs/repl/appl),
vote policy= 0,
group UUID = b3857b06-a98c-11ec-82cb-e3d020540c65
2022-03-22 6:26:10 0 [Note] WSREP: Flow-control interval: [16, 16]
2022-03-22 6:26:10 0 [Note] WSREP: Restored state OPEN -> JOINED (1906)
2022-03-22 6:26:10 0 [Note] WSREP: Member 0.0 (onap-policy-mariadb-0) synced with group.
2022-03-22 6:26:10 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 1906)
2022-03-22 6:26:10 2 [Note] WSREP: ####### processing CC 1906, local, ordered
2022-03-22 6:26:10 2 [Note] WSREP: Process first view: b3857b06-a98c-11ec-82cb-e3d020540c65 my uuid: f6fb686a-a9a8-11ec-bc47-762a6c741557
2022-03-22 6:26:10 2 [Note] WSREP: Server onap-policy-mariadb-0 connected to cluster at position b3857b06-a98c-11ec-82cb-e3d020540c65:1906 with ID f6fb686a-a9a8-11ec-bc47-762a6c741557
2022-03-22 6:26:10 2 [Note] WSREP: Server status change disconnected -> connected
2022-03-22 6:26:10 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-22 6:26:10 2 [Note] WSREP: ####### My UUID: f6fb686a-a9a8-11ec-bc47-762a6c741557
2022-03-22 6:26:10 2 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: no
2022-03-22 6:26:10 0 [Note] WSREP: Service thread queue flushed.
2022-03-22 6:26:10 2 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1
2022-03-22 6:26:10 2 [Note] WSREP: REPL Protocols: 10 (5)
2022-03-22 6:26:10 2 [Note] WSREP: ####### Adjusting cert position: -1 -> 1906
2022-03-22 6:26:10 0 [Note] WSREP: Service thread queue flushed.
2022-03-22 6:26:10 2 [Note] WSREP: ================================================
View:
id: b3857b06-a98c-11ec-82cb-e3d020540c65:1906
status: primary
protocol_version: 4
capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
final: no
own_index: 0
members(1):
0: f6fb686a-a9a8-11ec-bc47-762a6c741557, onap-policy-mariadb-0
=================================================
2022-03-22 6:26:10 2 [Note] WSREP: Server status change connected -> joiner
2022-03-22 6:26:10 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-22 6:26:10 2 [Note] WSREP: Server status change joiner -> initializing
2022-03-22 6:26:10 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-22 6:26:10 0 [Warning] The parameter innodb_file_format is deprecated and has no effect. It may be removed in future releases. See https://mariadb.com/kb/en/library/xtradbinnodb-file-format/
2022-03-22 6:26:10 0 [Warning] The parameter innodb_log_files_in_group is deprecated and has no effect.
2022-03-22 6:26:10 0 [Note] InnoDB: Using Linux native AIO
2022-03-22 6:26:10 0 [Note] InnoDB: Uses event mutexes
2022-03-22 6:26:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-03-22 6:26:10 0 [Note] InnoDB: Number of pools: 1
2022-03-22 6:26:10 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-03-22 6:26:10 0 [Note] mysqld: O_TMPFILE is not supported on /opt/bitnami/mariadb/tmp (disabling future attempts)
2022-03-22 6:26:10 0 [Note] InnoDB: Initializing buffer pool, total size = 2147483648, chunk size = 134217728
2022-03-22 6:26:11 0 [Note] InnoDB: Completed initialization of buffer pool
2022-03-22 6:26:11 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-03-22 6:26:12 0 [Note] InnoDB: 128 rollback segments are active.
2022-03-22 6:26:15 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-03-22 6:26:15 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-03-22 6:26:30 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-03-22 6:26:30 0 [Note] InnoDB: 10.5.8 started; log sequence number 4868417; transaction id 6745
2022-03-22 6:26:30 0 [Note] InnoDB: Loading buffer pool(s) from /bitnami/mariadb/data/ib_buffer_pool
2022-03-22 6:26:30 0 [Note] Plugin 'FEEDBACK' is disabled.
/opt/bitnami/mariadb/sbin/mysqld, Version: 10.5.8-MariaDB-log (Source distribution). started with:
Tcp port: 3306 Unix socket: /opt/bitnami/mariadb/tmp/mysql.sock
Time Id Command Argument
2022-03-22 6:26:30 0 [Note] Server socket created on IP: '0.0.0.0'.
2022-03-22 6:26:30 0 [Warning] 'proxies_priv' entry '@% root@onap-policy-mariadb-0' ignored in --skip-name-resolve mode.
2022-03-22 6:26:30 0 [Note] WSREP: wsrep_init_schema_and_SR 0x0
2022-03-22 6:26:30 0 [Note] WSREP: Server initialized
2022-03-22 6:26:30 0 [Note] WSREP: Server status change initializing -> initialized
2022-03-22 6:26:30 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-22 6:26:30 2 [Note] WSREP: Bootstrapping a new cluster, setting initial position to 00000000-0000-0000-0000-000000000000:-1
2022-03-22 6:26:30 6 [Note] WSREP: Starting applier thread 6
2022-03-22 6:26:30 7 [Note] WSREP: Starting applier thread 7
2022-03-22 6:26:30 8 [Note] WSREP: Starting applier thread 8
2022-03-22 6:26:30 5 [Note] WSREP: Recovered cluster id b3857b06-a98c-11ec-82cb-e3d020540c65
2022-03-22 6:26:30 2 [Note] WSREP: Server status change initialized -> joined
2022-03-22 6:26:30 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-22 6:26:30 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2022-03-22 6:26:30 0 [Note] Reading of all Master_info entries succeeded
2022-03-22 6:26:30 0 [Note] Added new Master_info '' to hash table
2022-03-22 6:26:30 0 [Note] /opt/bitnami/mariadb/sbin/mysqld: ready for connections.
Version: '10.5.8-MariaDB-log' socket: '/opt/bitnami/mariadb/tmp/mysql.sock' port: 3306 Source distribution
2022-03-22 6:26:30 2 [Note] WSREP: Lowest cert index boundary for CC from group: 1906
2022-03-22 6:26:30 2 [Note] WSREP: Min available from gcache for CC from group: 1
2022-03-22 6:26:30 2 [Note] WSREP: Server onap-policy-mariadb-0 synced with group
2022-03-22 6:26:30 2 [Note] WSREP: Server status change joined -> synced
2022-03-22 6:26:30 2 [Note] WSREP: Synchronized with group, ready for connections
2022-03-22 6:26:30 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
# Time: 220322 6:26:37
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 12 Schema: QC_hit: No
# Query_time: 0.000771 Lock_time: 0.000621 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930397;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 12 Schema: QC_hit: No
# Query_time: 0.000362 Lock_time: 0.000263 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930397;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 11 Schema: QC_hit: No
# Query_time: 0.003039 Lock_time: 0.002675 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930397;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 11 Schema: QC_hit: No
# Query_time: 0.000373 Lock_time: 0.000286 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930397;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
2022-03-22 6:26:38 0 [Note] InnoDB: Buffer pool(s) load completed at 220322 6:26:38
# Time: 220322 6:26:47
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 15 Schema: QC_hit: No
# Query_time: 0.011684 Lock_time: 0.000466 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930407;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 15 Schema: QC_hit: No
# Query_time: 0.001204 Lock_time: 0.001032 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930407;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 16 Schema: QC_hit: No
# Query_time: 0.004015 Lock_time: 0.003811 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930407;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 16 Schema: QC_hit: No
# Query_time: 0.000456 Lock_time: 0.000304 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930407;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
2022-03-22 6:26:49 19 [Warning] Aborted connection 19 to db: 'policyadmin' user: 'policy_user' host: '10.233.65.85' (Got an error reading communication packets)
# Time: 220322 6:26:51
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.963655 Lock_time: 0.962986 Rows_sent: 3 Rows_examined: 3
# Rows_affected: 0 Bytes_sent: 616
use policyadmin;
SET timestamp=1647930411;
SELECT t1.CURRENTINSTANCECOUNT, t1.DESIREDINSTANCECOUNT, t1.parentLocalName, t1.localName, t1.parentKeyVersion, t1.parentKeyName FROM PdpGroup_PdpSubGroup t0, PdpSubGroup t1 WHERE ((t0.version = '0.0.0') AND ((t0.name = 'defaultGroup') AND ((t1.parentKeyName = t0.parentKeyName) AND ((t1.parentKeyVersion = t0.parentKeyVersion) AND ((t1.localName = t0.localName) AND (t1.parentLocalName = t0.parentLocalName))))));
# Time: 220322 6:26:52
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.010990 Lock_time: 0.010719 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 186
SET timestamp=1647930412;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaPdpGroup_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'defaultGroup'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.021598 Lock_time: 0.021095 Rows_sent: 2 Rows_examined: 24
# Rows_affected: 0 Bytes_sent: 940
SET timestamp=1647930412;
SELECT name, version, parentLocalName, localName, parentKeyVersion, parentKeyName FROM JpaPdpSubGroup_SUPPORTEDPOLICYTYPES WHERE ((parentLocalName = 'NULL') AND ((localName = 'apex') AND ((parentKeyName = 'defaultGroup') AND (parentKeyVersion = '0.0.0'))));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.003744 Lock_time: 0.003342 Rows_sent: 0 Rows_examined: 1
# Rows_affected: 0 Bytes_sent: 642
SET timestamp=1647930412;
SELECT name, version, parentLocalName, localName, parentKeyVersion, parentKeyName FROM JpaPdpSubGroup_POLICIES WHERE ((parentLocalName = 'NULL') AND ((localName = 'apex') AND ((parentKeyName = 'defaultGroup') AND (parentKeyVersion = '0.0.0'))));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.003885 Lock_time: 0.003595 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 192
SET timestamp=1647930412;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaPdpSubGroup_PROPERTIES t0 WHERE ((t0.parentKeyName = 'defaultGroup') AND ((t0.parentKeyVersion = '0.0.0') AND ((t0.localName = 'apex') AND (t0.parentLocalName = 'NULL'))));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000793 Lock_time: 0.000351 Rows_sent: 3 Rows_examined: 24
# Rows_affected: 0 Bytes_sent: 1037
SET timestamp=1647930412;
SELECT name, version, parentLocalName, localName, parentKeyVersion, parentKeyName FROM JpaPdpSubGroup_SUPPORTEDPOLICYTYPES WHERE ((parentLocalName = 'NULL') AND ((localName = 'drools') AND ((parentKeyName = 'defaultGroup') AND (parentKeyVersion = '0.0.0'))));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001081 Lock_time: 0.000809 Rows_sent: 0 Rows_examined: 1
# Rows_affected: 0 Bytes_sent: 642
SET timestamp=1647930412;
SELECT name, version, parentLocalName, localName, parentKeyVersion, parentKeyName FROM JpaPdpSubGroup_POLICIES WHERE ((parentLocalName = 'NULL') AND ((localName = 'drools') AND ((parentKeyName = 'defaultGroup') AND (parentKeyVersion = '0.0.0'))));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000673 Lock_time: 0.000322 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 192
SET timestamp=1647930412;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaPdpSubGroup_PROPERTIES t0 WHERE ((t0.parentKeyName = 'defaultGroup') AND ((t0.parentKeyVersion = '0.0.0') AND ((t0.localName = 'drools') AND (t0.parentLocalName = 'NULL'))));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000379 Lock_time: 0.000186 Rows_sent: 19 Rows_examined: 24
# Rows_affected: 0 Bytes_sent: 2370
SET timestamp=1647930412;
SELECT name, version, parentLocalName, localName, parentKeyVersion, parentKeyName FROM JpaPdpSubGroup_SUPPORTEDPOLICYTYPES WHERE ((parentLocalName = 'NULL') AND ((localName = 'xacml') AND ((parentKeyName = 'defaultGroup') AND (parentKeyVersion = '0.0.0'))));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000330 Lock_time: 0.000173 Rows_sent: 1 Rows_examined: 1
# Rows_affected: 0 Bytes_sent: 719
SET timestamp=1647930412;
SELECT name, version, parentLocalName, localName, parentKeyVersion, parentKeyName FROM JpaPdpSubGroup_POLICIES WHERE ((parentLocalName = 'NULL') AND ((localName = 'xacml') AND ((parentKeyName = 'defaultGroup') AND (parentKeyVersion = '0.0.0'))));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000247 Lock_time: 0.000139 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 192
SET timestamp=1647930412;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaPdpSubGroup_PROPERTIES t0 WHERE ((t0.parentKeyName = 'defaultGroup') AND ((t0.parentKeyVersion = '0.0.0') AND ((t0.localName = 'xacml') AND (t0.parentLocalName = 'NULL'))));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.011765 Lock_time: 0.011192 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 198
SET timestamp=1647930412;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaServiceTemplate_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'ToscaServiceTemplateSimple'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.026591 Lock_time: 0.025056 Rows_sent: 38 Rows_examined: 76
# Rows_affected: 0 Bytes_sent: 5224
SET timestamp=1647930412;
SELECT t1.DESCRIPTION, t1.derived_from_name, t1.derived_from_version, t1.name, t1.version, t0.name, t0.version FROM ToscaDataTypes_ToscaDataType t0, ToscaDataType t1 WHERE ((t0.concpetContainerMapVersion = '1.0.0') AND ((t0.conceptContainerMapName = 'ToscaDataTypesSimple') AND ((t1.version = t0.conceptContainerVersion) AND (t1.name = t0.conceptContainerName))));
# Time: 220322 6:26:53
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.842139 Lock_time: 0.841883 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930413;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.subscriberProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.018555 Lock_time: 0.017805 Rows_sent: 3 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 4109
SET timestamp=1647930413;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.subscriberProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.008878 Lock_time: 0.008626 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930413;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.subscriberProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.004276 Lock_time: 0.003985 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930413;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.rules_artifact'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.002104 Lock_time: 0.001346 Rows_sent: 3 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 3235
SET timestamp=1647930413;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.rules_artifact'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.002042 Lock_time: 0.001746 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930413;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.rules_artifact'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000645 Lock_time: 0.000433 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930413;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.engineservice.engine.Context'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000942 Lock_time: 0.000285 Rows_sent: 4 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 4755
SET timestamp=1647930413;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.engineservice.engine.Context'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000618 Lock_time: 0.000351 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930413;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.engineservice.engine.Context'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.004689 Lock_time: 0.004375 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930413;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.directives_attributes_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.004751 Lock_time: 0.004121 Rows_sent: 2 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 2192
SET timestamp=1647930413;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.directives_attributes_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000618 Lock_time: 0.000323 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930413;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.directives_attributes_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000601 Lock_time: 0.000302 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930413;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.dmaap.custom_serialization'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000973 Lock_time: 0.000283 Rows_sent: 2 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 2349
SET timestamp=1647930413;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.dmaap.custom_serialization'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.005394 Lock_time: 0.005096 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930413;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.dmaap.custom_serialization'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.004456 Lock_time: 0.004144 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930413;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.Plugin'));
# Time: 220322 6:26:54
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 21 Schema: QC_hit: No
# Query_time: 0.000673 Lock_time: 0.000546 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930414;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 21 Schema: QC_hit: No
# Query_time: 0.000243 Lock_time: 0.000161 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930414;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.833546 Lock_time: 0.818759 Rows_sent: 2 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 2269
SET timestamp=1647930414;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.Plugin'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.009921 Lock_time: 0.009628 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930414;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.Plugin'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.006881 Lock_time: 0.006565 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930414;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.distance_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001028 Lock_time: 0.000457 Rows_sent: 3 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 3951
SET timestamp=1647930414;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.distance_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000377 Lock_time: 0.000204 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930414;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.distance_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.002011 Lock_time: 0.001812 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930414;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.objectiveParameter_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001214 Lock_time: 0.000526 Rows_sent: 2 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 2806
SET timestamp=1647930414;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.objectiveParameter_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000497 Lock_time: 0.000307 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930414;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.objectiveParameter_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001279 Lock_time: 0.000244 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930414;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.CarrierTechnology'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001942 Lock_time: 0.000305 Rows_sent: 2 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 2437
SET timestamp=1647930414;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.CarrierTechnology'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000367 Lock_time: 0.000196 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930414;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.CarrierTechnology'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000335 Lock_time: 0.000221 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930414;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.drools.controller.relation'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000812 Lock_time: 0.000216 Rows_sent: 1 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 1208
SET timestamp=1647930414;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.drools.controller.relation'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000265 Lock_time: 0.000158 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930414;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.drools.controller.relation'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000244 Lock_time: 0.000144 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930414;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.hpa-feature-attributes_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000711 Lock_time: 0.000155 Rows_sent: 4 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 4633
SET timestamp=1647930414;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.hpa-feature-attributes_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000425 Lock_time: 0.000241 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930414;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.hpa-feature-attributes_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000278 Lock_time: 0.000157 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930414;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.queryProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000758 Lock_time: 0.000162 Rows_sent: 3 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 3149
SET timestamp=1647930414;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.queryProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000307 Lock_time: 0.000175 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930414;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.queryProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000544 Lock_time: 0.000417 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930414;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.capacityProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000950 Lock_time: 0.000324 Rows_sent: 2 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 2162
SET timestamp=1647930414;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.capacityProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000493 Lock_time: 0.000331 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930414;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.capacityProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000548 Lock_time: 0.000360 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930414;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.affinityProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.002365 Lock_time: 0.000571 Rows_sent: 2 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 2439
SET timestamp=1647930414;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.affinityProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.003179 Lock_time: 0.002882 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930414;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.affinityProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000542 Lock_time: 0.000345 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930414;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.EngineService'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.002385 Lock_time: 0.001432 Rows_sent: 9 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 9677
SET timestamp=1647930414;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.EngineService'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.006792 Lock_time: 0.006490 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930414;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.EngineService'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000756 Lock_time: 0.000446 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930414;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.EventProtocol'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001027 Lock_time: 0.000371 Rows_sent: 2 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 2423
SET timestamp=1647930414;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.EventProtocol'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000347 Lock_time: 0.000186 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930414;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.EventProtocol'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000437 Lock_time: 0.000258 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930414;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.parameterAttributes_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001089 Lock_time: 0.000354 Rows_sent: 5 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 5568
SET timestamp=1647930414;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.parameterAttributes_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000572 Lock_time: 0.000312 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930414;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.parameterAttributes_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000407 Lock_time: 0.000252 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930414;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.monitoring.metricsPerEventName'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000727 Lock_time: 0.000178 Rows_sent: 6 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 6842
SET timestamp=1647930414;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.monitoring.metricsPerEventName'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000488 Lock_time: 0.000222 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930414;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.monitoring.metricsPerEventName'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000277 Lock_time: 0.000163 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930414;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatype.controlloop.Target'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000700 Lock_time: 0.000174 Rows_sent: 2 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 2951
SET timestamp=1647930414;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatype.controlloop.Target'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000603 Lock_time: 0.000429 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930414;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatype.controlloop.Target'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000267 Lock_time: 0.000155 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930414;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.dmaap.events'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000962 Lock_time: 0.000433 Rows_sent: 3 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 3361
SET timestamp=1647930414;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.dmaap.events'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000426 Lock_time: 0.000267 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930414;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.dmaap.events'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000348 Lock_time: 0.000248 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930414;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.increment-sequence'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000771 Lock_time: 0.000136 Rows_sent: 6 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 6965
SET timestamp=1647930414;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.increment-sequence'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000500 Lock_time: 0.000304 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930414;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.increment-sequence'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000441 Lock_time: 0.000314 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930414;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.EventHandler'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000627 Lock_time: 0.000133 Rows_sent: 11 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 12556
SET timestamp=1647930414;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.EventHandler'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000600 Lock_time: 0.000382 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930414;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.EventHandler'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000415 Lock_time: 0.000272 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930414;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.guard.filter'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000899 Lock_time: 0.000258 Rows_sent: 4 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 5223
SET timestamp=1647930414;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.guard.filter'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000634 Lock_time: 0.000356 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930414;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.guard.filter'));
# Time: 220322 6:26:55
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.818355 Lock_time: 0.818090 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930415;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.dmaap.topic'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001494 Lock_time: 0.000728 Rows_sent: 2 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 2353
SET timestamp=1647930415;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.dmaap.topic'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000629 Lock_time: 0.000409 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930415;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.dmaap.topic'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.021921 Lock_time: 0.021504 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930415;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.monitoring.tca_policy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001775 Lock_time: 0.000366 Rows_sent: 2 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 2993
SET timestamp=1647930415;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.monitoring.tca_policy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000599 Lock_time: 0.000135 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930415;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.monitoring.tca_policy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000431 Lock_time: 0.000156 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930415;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.engineservice.Engine'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.007189 Lock_time: 0.000177 Rows_sent: 2 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 2600
SET timestamp=1647930415;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.engineservice.Engine'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000569 Lock_time: 0.000294 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930415;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.engineservice.Engine'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000266 Lock_time: 0.000136 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930415;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.vnfProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000880 Lock_time: 0.000201 Rows_sent: 4 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 4609
SET timestamp=1647930415;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.vnfProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000522 Lock_time: 0.000280 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930415;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.vnfProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000311 Lock_time: 0.000167 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930415;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.naming-property'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001312 Lock_time: 0.000150 Rows_sent: 6 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 6263
SET timestamp=1647930415;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.naming-property'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000677 Lock_time: 0.000209 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930415;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.naming-property'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000740 Lock_time: 0.000280 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930415;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.directives_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.002206 Lock_time: 0.000202 Rows_sent: 2 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 2333
SET timestamp=1647930415;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.directives_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001054 Lock_time: 0.000271 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930415;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.directives_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000548 Lock_time: 0.000282 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930415;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatype.controlloop.Operation'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001813 Lock_time: 0.000241 Rows_sent: 11 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 11945
SET timestamp=1647930415;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatype.controlloop.Operation'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000984 Lock_time: 0.000249 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930415;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatype.controlloop.Operation'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000585 Lock_time: 0.000239 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930415;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.pciProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000975 Lock_time: 0.000177 Rows_sent: 5 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 5227
SET timestamp=1647930415;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.pciProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000497 Lock_time: 0.000245 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930415;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.pciProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000444 Lock_time: 0.000219 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930415;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.naming-model-entity'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000773 Lock_time: 0.000117 Rows_sent: 5 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 5572
SET timestamp=1647930415;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.naming-model-entity'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.002727 Lock_time: 0.000196 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930415;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.naming-model-entity'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000767 Lock_time: 0.000297 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930415;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.flavorFeatures_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000748 Lock_time: 0.000130 Rows_sent: 4 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 4478
SET timestamp=1647930415;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.flavorFeatures_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000711 Lock_time: 0.000207 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930415;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.flavorFeatures_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000680 Lock_time: 0.000146 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930415;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatype.controlloop.Actor'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000883 Lock_time: 0.000110 Rows_sent: 4 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 5057
SET timestamp=1647930415;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatype.controlloop.Actor'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000511 Lock_time: 0.000253 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930415;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatype.controlloop.Actor'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000336 Lock_time: 0.000156 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930415;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.Environment'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000950 Lock_time: 0.000189 Rows_sent: 2 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 2217
SET timestamp=1647930415;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.Environment'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000378 Lock_time: 0.000207 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930415;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.native.apex.Environment'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000334 Lock_time: 0.000133 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930415;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.distanceProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000780 Lock_time: 0.000142 Rows_sent: 2 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 2375
SET timestamp=1647930415;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.distanceProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000454 Lock_time: 0.000193 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930415;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.distanceProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000446 Lock_time: 0.000162 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930415;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.monitoring.thresholds'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000920 Lock_time: 0.000171 Rows_sent: 7 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 12379
SET timestamp=1647930415;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.monitoring.thresholds'));
# Time: 220322 6:26:56
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.810992 Lock_time: 0.810660 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930416;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'onap.datatypes.monitoring.thresholds'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000500 Lock_time: 0.000244 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 184
SET timestamp=1647930416;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaDataType_METADATA t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.flavorProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000953 Lock_time: 0.000244 Rows_sent: 7 Rows_examined: 148
# Rows_affected: 0 Bytes_sent: 7480
SET timestamp=1647930416;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaDataType_PROPERTIES t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.flavorProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001237 Lock_time: 0.000949 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 105
SET timestamp=1647930416;
SELECT t0.CONSTRAINTS FROM JpaToscaDataType_CONSTRAINTS t0 WHERE ((t0.version = '0.0.0') AND (t0.name = 'policy.data.flavorProperties_properties'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.084714 Lock_time: 0.084055 Rows_sent: 34 Rows_examined: 68
# Rows_affected: 0 Bytes_sent: 6699
SET timestamp=1647930416;
SELECT t1.DESCRIPTION, t1.derived_from_name, t1.derived_from_version, t1.name, t1.version, t0.name, t0.version FROM ToscaPolicyTypes_ToscaPolicyType t0, ToscaPolicyType t1 WHERE ((t0.concpetContainerMapVersion = '1.0.0') AND ((t0.conceptContainerMapName = 'ToscaPolicyTypesSimple') AND ((t1.version = t0.conceptContainerVersion) AND (t1.name = t0.conceptContainerName))));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.021539 Lock_time: 0.012549 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930416;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.resource.VnfPolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.004146 Lock_time: 0.003453 Rows_sent: 2 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 2820
SET timestamp=1647930416;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.resource.VnfPolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.003672 Lock_time: 0.003375 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930416;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.optimization.resource.VnfPolicy') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.009504 Lock_time: 0.009124 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930416;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.resource.VnfPolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000483 Lock_time: 0.000283 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930416;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.guard.common.MinMax'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001063 Lock_time: 0.000319 Rows_sent: 3 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 3268
SET timestamp=1647930416;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.guard.common.MinMax'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000515 Lock_time: 0.000254 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930416;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.controlloop.guard.common.MinMax') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000621 Lock_time: 0.000262 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930416;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.guard.common.MinMax'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000640 Lock_time: 0.000367 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930416;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.guard.coordination.FirstBlocksSecond'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000957 Lock_time: 0.000254 Rows_sent: 1 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 1420
SET timestamp=1647930416;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.guard.coordination.FirstBlocksSecond'));
# Time: 220322 6:26:57
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.809835 Lock_time: 0.809550 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930417;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.controlloop.guard.coordination.FirstBlocksSecond') AND (version = '1.0.0'));
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 24 Schema: QC_hit: No
# Query_time: 0.000645 Lock_time: 0.000463 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930417;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 24 Schema: QC_hit: No
# Query_time: 0.000277 Lock_time: 0.000185 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930417;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000736 Lock_time: 0.000365 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930417;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.guard.coordination.FirstBlocksSecond'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000761 Lock_time: 0.000482 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930417;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.resource.HpaPolicy'));
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 23 Schema: QC_hit: No
# Query_time: 0.001114 Lock_time: 0.000968 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930417;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 23 Schema: QC_hit: No
# Query_time: 0.000350 Lock_time: 0.000290 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930417;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.004471 Lock_time: 0.003894 Rows_sent: 1 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 1387
SET timestamp=1647930417;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.resource.HpaPolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.002975 Lock_time: 0.002136 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930417;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.optimization.resource.HpaPolicy') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000624 Lock_time: 0.000372 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930417;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.resource.HpaPolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.004379 Lock_time: 0.004087 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930417;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.operational.common.Apex'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.005186 Lock_time: 0.004683 Rows_sent: 4 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 4473
SET timestamp=1647930417;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.operational.common.Apex'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000818 Lock_time: 0.000542 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930417;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.controlloop.operational.common.Apex') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.004093 Lock_time: 0.003728 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930417;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.operational.common.Apex'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.013966 Lock_time: 0.013672 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930417;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.service.QueryPolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.005367 Lock_time: 0.004817 Rows_sent: 1 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 1391
SET timestamp=1647930417;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.service.QueryPolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000428 Lock_time: 0.000268 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930417;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.optimization.service.QueryPolicy') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001389 Lock_time: 0.001237 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930417;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.service.QueryPolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.005692 Lock_time: 0.004891 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930417;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.resource.AffinityPolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001086 Lock_time: 0.000438 Rows_sent: 2 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 2690
SET timestamp=1647930417;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.resource.AffinityPolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.005990 Lock_time: 0.004790 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930417;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.optimization.resource.AffinityPolicy') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.004010 Lock_time: 0.003580 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930417;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.resource.AffinityPolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001139 Lock_time: 0.000581 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930417;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.Guard'));
# Time: 220322 6:26:58
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.809936 Lock_time: 0.800402 Rows_sent: 0 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 200
SET timestamp=1647930418;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.Guard'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.002539 Lock_time: 0.002240 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930418;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.controlloop.Guard') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000451 Lock_time: 0.000240 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930418;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.Guard'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.008717 Lock_time: 0.001239 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930418;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.resource.Vim_fit'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000829 Lock_time: 0.000272 Rows_sent: 2 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 2676
SET timestamp=1647930418;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.resource.Vim_fit'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.006374 Lock_time: 0.006051 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930418;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.optimization.resource.Vim_fit') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001695 Lock_time: 0.001118 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930418;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.resource.Vim_fit'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001579 Lock_time: 0.001281 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930418;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.guard.common.Blacklist'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001330 Lock_time: 0.000574 Rows_sent: 1 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 1418
SET timestamp=1647930418;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.guard.common.Blacklist'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.006937 Lock_time: 0.006523 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930418;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.controlloop.guard.common.Blacklist') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.002364 Lock_time: 0.001608 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930418;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.guard.common.Blacklist'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001515 Lock_time: 0.000994 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930418;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.resource.OptimizationPolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.003287 Lock_time: 0.002281 Rows_sent: 2 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 2688
SET timestamp=1647930418;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.resource.OptimizationPolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001562 Lock_time: 0.001173 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930418;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.optimization.resource.OptimizationPolicy') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.007767 Lock_time: 0.007458 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930418;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.resource.OptimizationPolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.009616 Lock_time: 0.000732 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930418;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.guard.common.FrequencyLimiter'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001633 Lock_time: 0.000595 Rows_sent: 3 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 4062
SET timestamp=1647930418;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.guard.common.FrequencyLimiter'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000867 Lock_time: 0.000498 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930418;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.controlloop.guard.common.FrequencyLimiter') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.010883 Lock_time: 0.010332 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930418;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.guard.common.FrequencyLimiter'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.005688 Lock_time: 0.003579 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930418;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.operational.Common'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001014 Lock_time: 0.000457 Rows_sent: 5 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 5728
SET timestamp=1647930418;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.operational.Common'));
# Time: 220322 6:26:59
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.822258 Lock_time: 0.821929 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930419;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.controlloop.operational.Common') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000561 Lock_time: 0.000283 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930419;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.operational.Common'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.002749 Lock_time: 0.002436 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930419;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.resource.DistancePolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000624 Lock_time: 0.000212 Rows_sent: 2 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 2690
SET timestamp=1647930419;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.resource.DistancePolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000560 Lock_time: 0.000318 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930419;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.optimization.resource.DistancePolicy') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.005207 Lock_time: 0.004892 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930419;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.resource.DistancePolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000517 Lock_time: 0.000278 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930419;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.service.SubscriberPolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000799 Lock_time: 0.000204 Rows_sent: 1 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 1256
SET timestamp=1647930419;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.service.SubscriberPolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000680 Lock_time: 0.000348 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930419;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.optimization.service.SubscriberPolicy') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000822 Lock_time: 0.000312 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930419;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.service.SubscriberPolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000561 Lock_time: 0.000306 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930419;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.monitoring.dcaegen2.collectors.datafile.datafile-app-server'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000868 Lock_time: 0.000325 Rows_sent: 2 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 2376
SET timestamp=1647930419;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.monitoring.dcaegen2.collectors.datafile.datafile-app-server'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000889 Lock_time: 0.000303 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930419;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.monitoring.dcaegen2.collectors.datafile.datafile-app-server') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001609 Lock_time: 0.000298 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930419;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.monitoring.dcaegen2.collectors.datafile.datafile-app-server'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000904 Lock_time: 0.000441 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930419;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.guard.common.Filter'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.011380 Lock_time: 0.010875 Rows_sent: 2 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 2763
SET timestamp=1647930419;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.guard.common.Filter'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000726 Lock_time: 0.000461 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930419;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.controlloop.guard.common.Filter') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.004527 Lock_time: 0.004222 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930419;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.guard.common.Filter'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.004717 Lock_time: 0.004387 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930419;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.resource.PciPolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000759 Lock_time: 0.000281 Rows_sent: 1 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 1384
SET timestamp=1647930419;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.resource.PciPolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000865 Lock_time: 0.000431 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930419;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.optimization.resource.PciPolicy') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000790 Lock_time: 0.000293 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930419;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.resource.PciPolicy'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001515 Lock_time: 0.001242 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930419;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.Naming'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000527 Lock_time: 0.000234 Rows_sent: 2 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 2342
SET timestamp=1647930419;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.Naming'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.007682 Lock_time: 0.007354 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930419;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.Naming') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.002371 Lock_time: 0.002073 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930419;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.Naming'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000653 Lock_time: 0.000333 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930419;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.native.Xacml'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000632 Lock_time: 0.000206 Rows_sent: 1 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 1355
SET timestamp=1647930419;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.native.Xacml'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000500 Lock_time: 0.000239 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930419;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.native.Xacml') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001549 Lock_time: 0.001273 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930419;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.native.Xacml'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001096 Lock_time: 0.000629 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930419;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.operational.common.Drools'));
# Time: 220322 6:27:00
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.800515 Lock_time: 0.799942 Rows_sent: 1 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 1237
SET timestamp=1647930420;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.operational.common.Drools'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000751 Lock_time: 0.000465 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930420;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.controlloop.operational.common.Drools') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001904 Lock_time: 0.001588 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930420;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.operational.common.Drools'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000728 Lock_time: 0.000350 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930420;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.guard.Coordination'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001519 Lock_time: 0.000420 Rows_sent: 0 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 200
SET timestamp=1647930420;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.guard.Coordination'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.002594 Lock_time: 0.002281 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930420;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.controlloop.guard.Coordination') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000800 Lock_time: 0.000463 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930420;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.guard.Coordination'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000663 Lock_time: 0.000359 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930420;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.Service'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000467 Lock_time: 0.000184 Rows_sent: 1 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 1532
SET timestamp=1647930420;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.Service'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000786 Lock_time: 0.000530 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930420;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.optimization.Service') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001000 Lock_time: 0.000751 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930420;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.Service'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001102 Lock_time: 0.000788 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930420;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.Resource'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000896 Lock_time: 0.000377 Rows_sent: 2 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 2873
SET timestamp=1647930420;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.Resource'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000565 Lock_time: 0.000316 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930420;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.optimization.Resource') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001181 Lock_time: 0.000956 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930420;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.optimization.Resource'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.012496 Lock_time: 0.012204 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930420;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.Monitoring'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000754 Lock_time: 0.000369 Rows_sent: 0 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 200
SET timestamp=1647930420;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.Monitoring'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000417 Lock_time: 0.000251 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930420;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.Monitoring') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000288 Lock_time: 0.000163 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930420;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.Monitoring'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000765 Lock_time: 0.000509 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930420;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.native.drools.Artifact'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000658 Lock_time: 0.000300 Rows_sent: 2 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 2352
SET timestamp=1647930420;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.native.drools.Artifact'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000453 Lock_time: 0.000294 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930420;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.native.drools.Artifact') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000752 Lock_time: 0.000499 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930420;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.native.drools.Artifact'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000376 Lock_time: 0.000177 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930420;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.guard.Common'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000488 Lock_time: 0.000215 Rows_sent: 4 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 4367
SET timestamp=1647930420;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.guard.Common'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000644 Lock_time: 0.000384 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930420;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.controlloop.guard.Common') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000910 Lock_time: 0.000647 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930420;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.controlloop.guard.Common'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000591 Lock_time: 0.000337 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930420;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.native.drools.Controller'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000500 Lock_time: 0.000226 Rows_sent: 4 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 4836
SET timestamp=1647930420;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.native.drools.Controller'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000473 Lock_time: 0.000231 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930420;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.native.drools.Controller') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000345 Lock_time: 0.000211 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930420;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.native.drools.Controller'));
# Time: 220322 6:27:01
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.797738 Lock_time: 0.797477 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930421;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.Match'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000639 Lock_time: 0.000250 Rows_sent: 0 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 200
SET timestamp=1647930421;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.Match'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000417 Lock_time: 0.000267 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930421;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.Match') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001087 Lock_time: 0.000954 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930421;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.Match'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000377 Lock_time: 0.000266 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930421;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.Native'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000695 Lock_time: 0.000317 Rows_sent: 0 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 200
SET timestamp=1647930421;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.Native'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.008013 Lock_time: 0.007438 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930421;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.Native') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001661 Lock_time: 0.001395 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930421;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.Native'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000616 Lock_time: 0.000410 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930421;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.monitoring.tcagen2'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000844 Lock_time: 0.000303 Rows_sent: 1 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 1227
SET timestamp=1647930421;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.monitoring.tcagen2'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000585 Lock_time: 0.000328 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930421;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.monitoring.tcagen2') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000246 Lock_time: 0.000140 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930421;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.monitoring.tcagen2'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000388 Lock_time: 0.000262 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930421;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.native.Apex'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000395 Lock_time: 0.000166 Rows_sent: 4 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 4876
SET timestamp=1647930421;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.native.Apex'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000368 Lock_time: 0.000228 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930421;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.native.Apex') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000626 Lock_time: 0.000521 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930421;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.native.Apex'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000506 Lock_time: 0.000316 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930421;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.native.Drools'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.002474 Lock_time: 0.002077 Rows_sent: 0 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 200
SET timestamp=1647930421;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.native.Drools'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.001450 Lock_time: 0.001235 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930421;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.native.Drools') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000336 Lock_time: 0.000219 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930421;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.native.Drools'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000255 Lock_time: 0.000167 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930421;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicyType_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.Optimization'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000516 Lock_time: 0.000181 Rows_sent: 3 Rows_examined: 60
# Rows_affected: 0 Bytes_sent: 4118
SET timestamp=1647930421;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicyType_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.Optimization'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000340 Lock_time: 0.000197 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 416
SET timestamp=1647930421;
SELECT name, version, name, version FROM JpaToscaPolicyType_TARGETS WHERE ((name = 'onap.policies.Optimization') AND (version = '1.0.0'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.000258 Lock_time: 0.000165 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 98
SET timestamp=1647930421;
SELECT t0.TRIGGERS FROM JpaToscaPolicyType_TRIGGERS t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'onap.policies.Optimization'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.005331 Lock_time: 0.005080 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 188
SET timestamp=1647930421;
SELECT t0.INPUTS, t0.INPUTS_KEY FROM JpaToscaTopologyTemplate_INPUTS t0 WHERE ((t0.parentKeyName = 'ToscaServiceTemplateSimple') AND ((t0.parentKeyVersion = '1.0.0') AND ((t0.localName = 'ToscaTopologyTemplateSimple') AND (t0.parentLocalName = 'NULL'))));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.003361 Lock_time: 0.002883 Rows_sent: 2 Rows_examined: 2
# Rows_affected: 0 Bytes_sent: 256
SET timestamp=1647930421;
SELECT t0.METADATA, t0.METADATA_KEY FROM JpaToscaPolicy_METADATA t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'SDNC_Policy.ONAP_NF_NAMING_TIMESTAMP'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.011670 Lock_time: 0.011336 Rows_sent: 2 Rows_examined: 2
# Rows_affected: 0 Bytes_sent: 1520
SET timestamp=1647930421;
SELECT t0.PROPERTIES, t0.PROPERTIES_KEY FROM JpaToscaPolicy_PROPERTIES t0 WHERE ((t0.version = '1.0.0') AND (t0.name = 'SDNC_Policy.ONAP_NF_NAMING_TIMESTAMP'));
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 20 Schema: policyadmin QC_hit: No
# Query_time: 0.008496 Lock_time: 0.008225 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 384
SET timestamp=1647930421;
SELECT name, version, name, version FROM JpaToscaPolicy_TARGETS WHERE ((name = 'SDNC_Policy.ONAP_NF_NAMING_TIMESTAMP') AND (version = '1.0.0'));
# Time: 220322 6:27:07
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 28 Schema: QC_hit: No
# Query_time: 0.000941 Lock_time: 0.000778 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930427;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 28 Schema: QC_hit: No
# Query_time: 0.000745 Lock_time: 0.000632 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930427;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 27 Schema: QC_hit: No
# Query_time: 0.003538 Lock_time: 0.003395 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930427;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 27 Schema: QC_hit: No
# Query_time: 0.003984 Lock_time: 0.003578 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930427;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
2022-03-22 6:27:12 32 [Warning] Aborted connection 32 to db: 'pooling' user: 'policy_user' host: '10.233.68.83' (Got an error reading communication packets)
# Time: 220322 6:27:17
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 34 Schema: QC_hit: No
# Query_time: 0.011974 Lock_time: 0.011750 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930437;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 33 Schema: QC_hit: No
# Query_time: 0.000384 Lock_time: 0.000240 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930437;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 33 Schema: QC_hit: No
# Query_time: 0.000413 Lock_time: 0.000221 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930437;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 34 Schema: QC_hit: No
# Query_time: 0.005843 Lock_time: 0.005664 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930437;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:27:24
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 37 Schema: QC_hit: No
# Query_time: 0.010586 Lock_time: 0.010358 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930444;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 37 Schema: QC_hit: No
# Query_time: 0.001631 Lock_time: 0.001400 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930444;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:27:27
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 39 Schema: QC_hit: No
# Query_time: 0.000497 Lock_time: 0.000320 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930447;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 39 Schema: QC_hit: No
# Query_time: 0.003055 Lock_time: 0.002891 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930447;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 38 Schema: QC_hit: No
# Query_time: 0.004530 Lock_time: 0.004335 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930447;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 38 Schema: QC_hit: No
# Query_time: 0.007082 Lock_time: 0.006846 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930447;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:27:33
# User@Host: policy_user[policy_user] @ [10.233.72.84]
# Thread_id: 22 Schema: controlloop QC_hit: No
# Query_time: 0.456403 Lock_time: 0.456126 Rows_sent: 3 Rows_examined: 3
# Rows_affected: 0 Bytes_sent: 1148
use controlloop;
SET timestamp=1647930453;
SELECT DESCRIPTION, HEALTHSTATUS, PARTICIPANTSTATE, definition_name, definition_version, name, version, participant_type_name, participant_type_version FROM Participant;
# Time: 220322 6:27:37
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 44 Schema: QC_hit: No
# Query_time: 0.000377 Lock_time: 0.000234 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930457;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 43 Schema: QC_hit: No
# Query_time: 0.011743 Lock_time: 0.011425 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930457;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 44 Schema: QC_hit: No
# Query_time: 0.000410 Lock_time: 0.000287 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930457;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 43 Schema: QC_hit: No
# Query_time: 0.001278 Lock_time: 0.000928 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930457;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:27:47
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 47 Schema: QC_hit: No
# Query_time: 0.001096 Lock_time: 0.000699 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930467;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 48 Schema: QC_hit: No
# Query_time: 0.002545 Lock_time: 0.002364 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930467;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 47 Schema: QC_hit: No
# Query_time: 0.000532 Lock_time: 0.000228 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930467;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 48 Schema: QC_hit: No
# Query_time: 0.004645 Lock_time: 0.004483 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930467;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:27:54
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 51 Schema: QC_hit: No
# Query_time: 0.002046 Lock_time: 0.001856 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930474;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 51 Schema: QC_hit: No
# Query_time: 0.000393 Lock_time: 0.000254 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930474;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:27:57
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 52 Schema: QC_hit: No
# Query_time: 0.002819 Lock_time: 0.002500 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930477;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 52 Schema: QC_hit: No
# Query_time: 0.000605 Lock_time: 0.000389 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930477;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 53 Schema: QC_hit: No
# Query_time: 0.000381 Lock_time: 0.000224 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930477;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 53 Schema: QC_hit: No
# Query_time: 0.000235 Lock_time: 0.000154 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930477;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:28:07
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 58 Schema: QC_hit: No
# Query_time: 0.003491 Lock_time: 0.003303 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930487;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 57 Schema: QC_hit: No
# Query_time: 0.003548 Lock_time: 0.003468 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930487;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 58 Schema: QC_hit: No
# Query_time: 0.001033 Lock_time: 0.000855 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930487;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 57 Schema: QC_hit: No
# Query_time: 0.004490 Lock_time: 0.004367 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930487;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:28:17
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 63 Schema: QC_hit: No
# Query_time: 0.000407 Lock_time: 0.000255 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930497;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 62 Schema: QC_hit: No
# Query_time: 0.000701 Lock_time: 0.000517 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930497;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 62 Schema: QC_hit: No
# Query_time: 0.002090 Lock_time: 0.001878 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930497;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 63 Schema: QC_hit: No
# Query_time: 0.000630 Lock_time: 0.000465 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930497;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
2022-03-22 6:28:22 66 [Warning] Aborted connection 66 to db: 'policyadmin' user: 'policy_user' host: '10.233.65.85' (Got an error reading communication packets)
# Time: 220322 6:28:22
# User@Host: policy_user[policy_user] @ [10.233.65.85]
# Thread_id: 67 Schema: policyadmin QC_hit: No
# Query_time: 0.001674 Lock_time: 0.001309 Rows_sent: 1 Rows_examined: 1
# Rows_affected: 0 Bytes_sent: 393
use policyadmin;
SET timestamp=1647930502;
SELECT DESCRIPTION, PDPGROUPSTATE, name, version FROM PdpGroup;
# Time: 220322 6:28:25
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 68 Schema: QC_hit: No
# Query_time: 0.954565 Lock_time: 0.954367 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930505;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 68 Schema: QC_hit: No
# Query_time: 0.000391 Lock_time: 0.000257 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930505;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:28:27
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 70 Schema: QC_hit: No
# Query_time: 0.000575 Lock_time: 0.000355 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930507;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:28:28
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 70 Schema: QC_hit: No
# Query_time: 0.899804 Lock_time: 0.899629 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930508;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 69 Schema: QC_hit: No
# Query_time: 0.891001 Lock_time: 0.890833 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930508;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 69 Schema: QC_hit: No
# Query_time: 0.000317 Lock_time: 0.000245 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930508;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:28:37
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 74 Schema: QC_hit: No
# Query_time: 0.017726 Lock_time: 0.017479 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930517;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 73 Schema: QC_hit: No
# Query_time: 0.004951 Lock_time: 0.004754 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930517;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 73 Schema: QC_hit: No
# Query_time: 0.002238 Lock_time: 0.002090 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930517;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 74 Schema: QC_hit: No
# Query_time: 0.000557 Lock_time: 0.000394 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930517;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:28:47
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 77 Schema: QC_hit: No
# Query_time: 0.000564 Lock_time: 0.000355 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930527;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 77 Schema: QC_hit: No
# Query_time: 0.004537 Lock_time: 0.004340 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930527;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 78 Schema: QC_hit: No
# Query_time: 0.007361 Lock_time: 0.007156 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930527;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 78 Schema: QC_hit: No
# Query_time: 0.000371 Lock_time: 0.000288 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930527;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:28:55
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 82 Schema: QC_hit: No
# Query_time: 0.637972 Lock_time: 0.637780 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930535;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 82 Schema: QC_hit: No
# Query_time: 0.000503 Lock_time: 0.000313 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930535;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:28:58
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 83 Schema: QC_hit: No
# Query_time: 0.923252 Lock_time: 0.923009 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930538;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 84 Schema: QC_hit: No
# Query_time: 0.926360 Lock_time: 0.921331 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930538;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 84 Schema: QC_hit: No
# Query_time: 0.002754 Lock_time: 0.002562 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930538;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 83 Schema: QC_hit: No
# Query_time: 0.004883 Lock_time: 0.004783 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930538;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:29:07
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 87 Schema: QC_hit: No
# Query_time: 0.000370 Lock_time: 0.000292 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930547;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 88 Schema: QC_hit: No
# Query_time: 0.010005 Lock_time: 0.009754 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930547;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 88 Schema: QC_hit: No
# Query_time: 0.000722 Lock_time: 0.000413 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930547;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:29:08
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 87 Schema: QC_hit: No
# Query_time: 0.003018 Lock_time: 0.002797 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930548;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:29:17
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 92 Schema: QC_hit: No
# Query_time: 0.000329 Lock_time: 0.000190 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930557;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 93 Schema: QC_hit: No
# Query_time: 0.000508 Lock_time: 0.000341 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930557;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 92 Schema: QC_hit: No
# Query_time: 0.000450 Lock_time: 0.000286 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930557;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 93 Schema: QC_hit: No
# Query_time: 0.000489 Lock_time: 0.000309 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930557;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:29:24
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 96 Schema: QC_hit: No
# Query_time: 0.014460 Lock_time: 0.014254 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930564;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 96 Schema: QC_hit: No
# Query_time: 0.011135 Lock_time: 0.010936 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930564;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:29:27
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 98 Schema: QC_hit: No
# Query_time: 0.000968 Lock_time: 0.000317 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930567;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 98 Schema: QC_hit: No
# Query_time: 0.000486 Lock_time: 0.000295 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930567;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 97 Schema: QC_hit: No
# Query_time: 0.000469 Lock_time: 0.000315 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930567;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 97 Schema: QC_hit: No
# Query_time: 0.000226 Lock_time: 0.000153 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930567;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:29:33
# User@Host: policy_user[policy_user] @ [10.233.72.84]
# Thread_id: 42 Schema: controlloop QC_hit: No
# Query_time: 0.691273 Lock_time: 0.690968 Rows_sent: 3 Rows_examined: 3
# Rows_affected: 0 Bytes_sent: 1148
use controlloop;
SET timestamp=1647930573;
SELECT DESCRIPTION, HEALTHSTATUS, PARTICIPANTSTATE, definition_name, definition_version, name, version, participant_type_name, participant_type_version FROM Participant;
# Time: 220322 6:29:38
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 102 Schema: QC_hit: No
# Query_time: 0.004240 Lock_time: 0.004053 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930578;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 102 Schema: QC_hit: No
# Query_time: 0.004165 Lock_time: 0.003963 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930578;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 101 Schema: QC_hit: No
# Query_time: 0.000371 Lock_time: 0.000215 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930578;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 101 Schema: QC_hit: No
# Query_time: 0.000449 Lock_time: 0.000266 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930578;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:29:47
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 105 Schema: QC_hit: No
# Query_time: 0.001549 Lock_time: 0.001343 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930587;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 105 Schema: QC_hit: No
# Query_time: 0.001525 Lock_time: 0.001358 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930587;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:29:48
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 106 Schema: QC_hit: No
# Query_time: 0.009723 Lock_time: 0.001018 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930588;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 106 Schema: QC_hit: No
# Query_time: 0.001331 Lock_time: 0.001078 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930588;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:29:54
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 109 Schema: QC_hit: No
# Query_time: 0.000390 Lock_time: 0.000249 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930594;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 109 Schema: QC_hit: No
# Query_time: 0.000231 Lock_time: 0.000159 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930594;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:29:57
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 111 Schema: QC_hit: No
# Query_time: 0.000334 Lock_time: 0.000232 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930597;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 111 Schema: QC_hit: No
# Query_time: 0.000761 Lock_time: 0.000619 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930597;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:29:58
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 110 Schema: QC_hit: No
# Query_time: 0.000893 Lock_time: 0.000712 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930598;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 110 Schema: QC_hit: No
# Query_time: 0.000279 Lock_time: 0.000207 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930598;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
2022-03-22 6:30:05 114 [Warning] Aborted connection 114 to db: 'policyadmin' user: 'policy_user' host: '10.233.65.85' (Got an error reading communication packets)
# Time: 220322 6:30:07
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 116 Schema: QC_hit: No
# Query_time: 0.003457 Lock_time: 0.003335 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930607;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 116 Schema: QC_hit: No
# Query_time: 0.000465 Lock_time: 0.000239 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930607;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:30:08
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 117 Schema: QC_hit: No
# Query_time: 0.000788 Lock_time: 0.000616 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930608;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 117 Schema: QC_hit: No
# Query_time: 0.011212 Lock_time: 0.011007 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930608;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:30:17
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 121 Schema: QC_hit: No
# Query_time: 0.000396 Lock_time: 0.000281 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930617;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 120 Schema: QC_hit: No
# Query_time: 0.002310 Lock_time: 0.002102 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930617;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 120 Schema: QC_hit: No
# Query_time: 0.001577 Lock_time: 0.001466 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930617;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:30:18
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 121 Schema: QC_hit: No
# Query_time: 0.002162 Lock_time: 0.001976 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930618;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:30:25
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 124 Schema: QC_hit: No
# Query_time: 0.004527 Lock_time: 0.004358 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930625;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 124 Schema: QC_hit: No
# Query_time: 0.001741 Lock_time: 0.001624 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930625;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:30:28
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 126 Schema: QC_hit: No
# Query_time: 0.013028 Lock_time: 0.012753 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930628;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 126 Schema: QC_hit: No
# Query_time: 0.003900 Lock_time: 0.003717 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930628;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 125 Schema: QC_hit: No
# Query_time: 0.008484 Lock_time: 0.008290 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930628;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 125 Schema: QC_hit: No
# Query_time: 0.000299 Lock_time: 0.000222 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930628;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:30:37
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 131 Schema: QC_hit: No
# Query_time: 0.001966 Lock_time: 0.001749 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930637;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:30:38
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 130 Schema: QC_hit: No
# Query_time: 0.008540 Lock_time: 0.008306 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930638;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 131 Schema: QC_hit: No
# Query_time: 0.009220 Lock_time: 0.009036 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930638;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 130 Schema: QC_hit: No
# Query_time: 0.001642 Lock_time: 0.001455 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930638;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:30:48
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 134 Schema: QC_hit: No
# Query_time: 0.002244 Lock_time: 0.002062 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930648;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 135 Schema: QC_hit: No
# Query_time: 0.003814 Lock_time: 0.003631 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930648;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 135 Schema: QC_hit: No
# Query_time: 0.002574 Lock_time: 0.002368 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930648;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 134 Schema: QC_hit: No
# Query_time: 0.000685 Lock_time: 0.000425 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930648;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:30:54
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 139 Schema: QC_hit: No
# Query_time: 0.002717 Lock_time: 0.002520 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930654;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 139 Schema: QC_hit: No
# Query_time: 0.000488 Lock_time: 0.000411 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930654;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:30:58
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 140 Schema: QC_hit: No
# Query_time: 0.002411 Lock_time: 0.002290 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930658;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 141 Schema: QC_hit: No
# Query_time: 0.002769 Lock_time: 0.002634 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930658;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 140 Schema: QC_hit: No
# Query_time: 0.002040 Lock_time: 0.001729 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930658;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 141 Schema: QC_hit: No
# Query_time: 0.003922 Lock_time: 0.000502 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930658;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:31:07
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 146 Schema: QC_hit: No
# Query_time: 0.008431 Lock_time: 0.008208 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930667;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 145 Schema: QC_hit: No
# Query_time: 0.002678 Lock_time: 0.002416 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930667;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 145 Schema: QC_hit: No
# Query_time: 0.001806 Lock_time: 0.001515 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930667;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 146 Schema: QC_hit: No
# Query_time: 0.001299 Lock_time: 0.001024 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930667;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:31:15
# User@Host: policy_user[policy_user] @ [10.233.65.148]
# Thread_id: 150 Schema: policyclamp QC_hit: No
# Query_time: 0.001840 Lock_time: 0.000509 Rows_sent: 34 Rows_examined: 34
# Rows_affected: 0 Bytes_sent: 145793
use policyclamp;
SET timestamp=1647930675;
select policymode0_.policy_model_type as policy_m1_12_, policymode0_.version as version2_12_, policymode0_.created_by as created_3_12_, policymode0_.created_timestamp as created_4_12_, policymode0_.updated_by as updated_5_12_, policymode0_.updated_timestamp as updated_6_12_, policymode0_.policy_acronym as policy_a7_12_, policymode0_.policy_tosca as policy_t8_12_, policymode0_.policy_pdp_group as policy_p9_12_ from policy_models policymode0_;
2022-03-22 6:31:17 161 [Warning] Aborted connection 161 to db: 'policyadmin' user: 'policy_user' host: '10.233.71.105' (Got an error reading communication packets)
# Time: 220322 6:31:18
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 163 Schema: QC_hit: No
# Query_time: 0.000308 Lock_time: 0.000170 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930678;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 164 Schema: QC_hit: No
# Query_time: 0.000457 Lock_time: 0.000271 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930678;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 164 Schema: QC_hit: No
# Query_time: 0.000241 Lock_time: 0.000156 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930678;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 163 Schema: QC_hit: No
# Query_time: 0.000561 Lock_time: 0.000384 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930678;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:31:24
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 167 Schema: QC_hit: No
# Query_time: 0.000588 Lock_time: 0.000406 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930684;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:31:25
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 167 Schema: QC_hit: No
# Query_time: 0.741813 Lock_time: 0.741612 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930685;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:31:28
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 169 Schema: QC_hit: No
# Query_time: 0.005042 Lock_time: 0.004844 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930688;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 168 Schema: QC_hit: No
# Query_time: 0.006291 Lock_time: 0.006087 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930688;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 168 Schema: QC_hit: No
# Query_time: 0.002169 Lock_time: 0.001848 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930688;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 169 Schema: QC_hit: No
# Query_time: 0.002136 Lock_time: 0.001960 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930688;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:31:33
# User@Host: policy_user[policy_user] @ [10.233.72.84]
# Thread_id: 42 Schema: controlloop QC_hit: No
# Query_time: 0.060524 Lock_time: 0.060209 Rows_sent: 3 Rows_examined: 3
# Rows_affected: 0 Bytes_sent: 1148
use controlloop;
SET timestamp=1647930693;
SELECT DESCRIPTION, HEALTHSTATUS, PARTICIPANTSTATE, definition_name, definition_version, name, version, participant_type_name, participant_type_version FROM Participant;
# Time: 220322 6:31:38
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 172 Schema: QC_hit: No
# Query_time: 0.000601 Lock_time: 0.000393 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930698;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 172 Schema: QC_hit: No
# Query_time: 0.001732 Lock_time: 0.001527 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930698;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 173 Schema: QC_hit: No
# Query_time: 0.000971 Lock_time: 0.000793 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930698;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:31:39
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 173 Schema: QC_hit: No
# Query_time: 0.686052 Lock_time: 0.685837 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930699;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
2022-03-22 6:31:44 176 [Warning] Aborted connection 176 to db: 'policyadmin' user: 'policy_user' host: '10.233.65.85' (Got an error reading communication packets)
# Time: 220322 6:31:44
# User@Host: policy_user[policy_user] @ [10.233.65.148]
# Thread_id: 150 Schema: policyclamp QC_hit: No
# Query_time: 0.009870 Lock_time: 0.008816 Rows_sent: 34 Rows_examined: 34
# Rows_affected: 0 Bytes_sent: 145793
use policyclamp;
SET timestamp=1647930704;
select policymode0_.policy_model_type as policy_m1_12_, policymode0_.version as version2_12_, policymode0_.created_by as created_3_12_, policymode0_.created_timestamp as created_4_12_, policymode0_.updated_by as updated_5_12_, policymode0_.updated_timestamp as updated_6_12_, policymode0_.policy_acronym as policy_a7_12_, policymode0_.policy_tosca as policy_t8_12_, policymode0_.policy_pdp_group as policy_p9_12_ from policy_models policymode0_;
# Time: 220322 6:31:48
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 178 Schema: QC_hit: No
# Query_time: 0.002140 Lock_time: 0.001959 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930708;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 178 Schema: QC_hit: No
# Query_time: 0.001399 Lock_time: 0.000538 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930708;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 179 Schema: QC_hit: No
# Query_time: 0.000393 Lock_time: 0.000257 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930708;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 179 Schema: QC_hit: No
# Query_time: 0.000304 Lock_time: 0.000186 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930708;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:31:55
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 182 Schema: QC_hit: No
# Query_time: 0.000519 Lock_time: 0.000333 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930715;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 182 Schema: QC_hit: No
# Query_time: 0.000862 Lock_time: 0.000710 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930715;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:31:58
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 183 Schema: QC_hit: No
# Query_time: 0.006058 Lock_time: 0.005864 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930718;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 183 Schema: QC_hit: No
# Query_time: 0.001128 Lock_time: 0.000699 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930718;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 184 Schema: QC_hit: No
# Query_time: 0.000628 Lock_time: 0.000479 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930718;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:31:59
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 184 Schema: QC_hit: No
# Query_time: 0.750782 Lock_time: 0.750447 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930719;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
2022-03-22 6:32:06 187 [Warning] Aborted connection 187 to db: 'policyadmin' user: 'policy_user' host: '10.233.65.85' (Got an error reading communication packets)
# Time: 220322 6:32:08
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 190 Schema: QC_hit: No
# Query_time: 0.000588 Lock_time: 0.000418 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930728;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 189 Schema: QC_hit: No
# Query_time: 0.000603 Lock_time: 0.000511 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930728;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:32:09
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 190 Schema: QC_hit: No
# Query_time: 0.734077 Lock_time: 0.733676 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930729;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 189 Schema: QC_hit: No
# Query_time: 0.860218 Lock_time: 0.859991 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930729;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:32:18
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 193 Schema: QC_hit: No
# Query_time: 0.012395 Lock_time: 0.012214 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930738;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:32:19
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 194 Schema: QC_hit: No
# Query_time: 0.909852 Lock_time: 0.909522 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930739;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 193 Schema: QC_hit: No
# Query_time: 0.796600 Lock_time: 0.795594 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930739;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 194 Schema: QC_hit: No
# Query_time: 0.018489 Lock_time: 0.018281 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930739;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:32:24
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 197 Schema: QC_hit: No
# Query_time: 0.000591 Lock_time: 0.000416 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930744;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 197 Schema: QC_hit: No
# Query_time: 0.002173 Lock_time: 0.002067 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930744;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:32:28
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 199 Schema: QC_hit: No
# Query_time: 0.003513 Lock_time: 0.003313 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930748;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 199 Schema: QC_hit: No
# Query_time: 0.001045 Lock_time: 0.000936 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930748;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
2022-03-22 6:32:29 202 [Warning] Aborted connection 202 to db: 'policyadmin' user: 'policy_user' host: '10.233.65.85' (Got an error reading communication packets)
# Time: 220322 6:32:29
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 198 Schema: QC_hit: No
# Query_time: 0.824091 Lock_time: 0.823940 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930749;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 198 Schema: QC_hit: No
# Query_time: 0.000668 Lock_time: 0.000482 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930749;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:32:38
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 204 Schema: QC_hit: No
# Query_time: 0.005211 Lock_time: 0.005038 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930758;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 204 Schema: QC_hit: No
# Query_time: 0.000465 Lock_time: 0.000377 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930758;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:32:39
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 205 Schema: QC_hit: No
# Query_time: 0.825840 Lock_time: 0.825629 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930759;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 205 Schema: QC_hit: No
# Query_time: 0.004130 Lock_time: 0.003936 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930759;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:32:49
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 209 Schema: QC_hit: No
# Query_time: 0.858056 Lock_time: 0.857857 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930769;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
2022-03-22 6:32:49 212 [Warning] Aborted connection 212 to db: 'policyadmin' user: 'policy_user' host: '10.233.65.85' (Got an error reading communication packets)
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 208 Schema: QC_hit: No
# Query_time: 0.776564 Lock_time: 0.776466 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930769;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 208 Schema: QC_hit: No
# Query_time: 0.016879 Lock_time: 0.016421 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930769;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 209 Schema: QC_hit: No
# Query_time: 0.003279 Lock_time: 0.002964 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930769;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:32:54
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 214 Schema: QC_hit: No
# Query_time: 0.000492 Lock_time: 0.000260 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930774;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 214 Schema: QC_hit: No
# Query_time: 0.004435 Lock_time: 0.004227 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930774;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:32:57
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 216 Schema: QC_hit: No
# Query_time: 0.000392 Lock_time: 0.000239 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930777;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 216 Schema: QC_hit: No
# Query_time: 0.000394 Lock_time: 0.000253 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930777;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 215 Schema: QC_hit: No
# Query_time: 0.000477 Lock_time: 0.000269 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930777;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 215 Schema: QC_hit: No
# Query_time: 0.000536 Lock_time: 0.000384 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930777;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:33:07
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 219 Schema: QC_hit: No
# Query_time: 0.000291 Lock_time: 0.000184 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930787;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 220 Schema: QC_hit: No
# Query_time: 0.006763 Lock_time: 0.006563 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930787;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 220 Schema: QC_hit: No
# Query_time: 0.003116 Lock_time: 0.002908 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930787;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 219 Schema: QC_hit: No
# Query_time: 0.000456 Lock_time: 0.000279 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930787;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:33:17
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 225 Schema: QC_hit: No
# Query_time: 0.000403 Lock_time: 0.000279 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930797;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 224 Schema: QC_hit: No
# Query_time: 0.000495 Lock_time: 0.000408 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930797;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 225 Schema: QC_hit: No
# Query_time: 0.002332 Lock_time: 0.002110 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930797;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 224 Schema: QC_hit: No
# Query_time: 0.001260 Lock_time: 0.001076 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930797;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:33:24
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 228 Schema: QC_hit: No
# Query_time: 0.000374 Lock_time: 0.000224 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930804;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 228 Schema: QC_hit: No
# Query_time: 0.000296 Lock_time: 0.000175 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930804;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:33:27
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 230 Schema: QC_hit: No
# Query_time: 0.000864 Lock_time: 0.000729 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930807;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 229 Schema: QC_hit: No
# Query_time: 0.000919 Lock_time: 0.000742 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930807;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 229 Schema: QC_hit: No
# Query_time: 0.000439 Lock_time: 0.000307 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930807;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 230 Schema: QC_hit: No
# Query_time: 0.001180 Lock_time: 0.000986 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930807;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:33:33
# User@Host: policy_user[policy_user] @ [10.233.72.84]
# Thread_id: 42 Schema: controlloop QC_hit: No
# Query_time: 0.292901 Lock_time: 0.292601 Rows_sent: 3 Rows_examined: 3
# Rows_affected: 0 Bytes_sent: 1148
use controlloop;
SET timestamp=1647930813;
SELECT DESCRIPTION, HEALTHSTATUS, PARTICIPANTSTATE, definition_name, definition_version, name, version, participant_type_name, participant_type_version FROM Participant;
# Time: 220322 6:33:37
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 233 Schema: QC_hit: No
# Query_time: 0.000820 Lock_time: 0.000598 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930817;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 233 Schema: QC_hit: No
# Query_time: 0.000263 Lock_time: 0.000174 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930817;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:33:38
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 234 Schema: QC_hit: No
# Query_time: 0.819425 Lock_time: 0.819198 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930818;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 234 Schema: QC_hit: No
# Query_time: 0.000324 Lock_time: 0.000243 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930818;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:33:47
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 237 Schema: QC_hit: No
# Query_time: 0.000696 Lock_time: 0.000513 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930827;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 237 Schema: QC_hit: No
# Query_time: 0.002923 Lock_time: 0.002700 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930827;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 238 Schema: QC_hit: No
# Query_time: 0.000496 Lock_time: 0.000273 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930827;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 238 Schema: QC_hit: No
# Query_time: 0.000374 Lock_time: 0.000230 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930827;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:33:54
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 241 Schema: QC_hit: No
# Query_time: 0.004683 Lock_time: 0.004435 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930834;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 241 Schema: QC_hit: No
# Query_time: 0.001694 Lock_time: 0.001521 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930834;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:33:57
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 242 Schema: QC_hit: No
# Query_time: 0.001559 Lock_time: 0.001334 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930837;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 242 Schema: QC_hit: No
# Query_time: 0.000240 Lock_time: 0.000170 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930837;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 243 Schema: QC_hit: No
# Query_time: 0.002465 Lock_time: 0.002274 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930837;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 243 Schema: QC_hit: No
# Query_time: 0.000895 Lock_time: 0.000723 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930837;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
2022-03-22 6:34:06 247 [Warning] Aborted connection 247 to db: 'unconnected' user: 'unauthenticated' host: '127.0.0.1' (This connection closed normally without authentication)
# Time: 220322 6:34:07
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 248 Schema: QC_hit: No
# Query_time: 0.000465 Lock_time: 0.000297 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930847;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 249 Schema: QC_hit: No
# Query_time: 0.000344 Lock_time: 0.000232 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930847;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 248 Schema: QC_hit: No
# Query_time: 0.002778 Lock_time: 0.002613 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930847;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 249 Schema: QC_hit: No
# Query_time: 0.002679 Lock_time: 0.002484 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930847;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
2022-03-22 6:34:07 0 [Warning] WSREP: unserialize error invalid protocol version 5: 71 (Protocol error)
at /bitnami/blacksmith-sandox/libgalera-26.4.7/gcomm/src/gcomm/datagram.hpp:unserialize():133
# Time: 220322 6:34:17
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 252 Schema: QC_hit: No
# Query_time: 0.000737 Lock_time: 0.000531 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930857;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 252 Schema: QC_hit: No
# Query_time: 0.000519 Lock_time: 0.000447 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930857;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 253 Schema: QC_hit: No
# Query_time: 0.002100 Lock_time: 0.001921 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930857;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 253 Schema: QC_hit: No
# Query_time: 0.002308 Lock_time: 0.002139 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930857;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:34:24
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 256 Schema: QC_hit: No
# Query_time: 0.003393 Lock_time: 0.003171 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930864;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 256 Schema: QC_hit: No
# Query_time: 0.005056 Lock_time: 0.004848 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930864;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:34:27
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 258 Schema: QC_hit: No
# Query_time: 0.001275 Lock_time: 0.001085 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930867;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 257 Schema: QC_hit: No
# Query_time: 0.028856 Lock_time: 0.020845 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930867;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 257 Schema: QC_hit: No
# Query_time: 0.000343 Lock_time: 0.000265 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930867;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 258 Schema: QC_hit: No
# Query_time: 0.004435 Lock_time: 0.004250 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930867;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:34:37
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 262 Schema: QC_hit: No
# Query_time: 0.000521 Lock_time: 0.000424 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930877;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 263 Schema: QC_hit: No
# Query_time: 0.000798 Lock_time: 0.000664 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930877;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 263 Schema: QC_hit: No
# Query_time: 0.000250 Lock_time: 0.000168 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930877;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 262 Schema: QC_hit: No
# Query_time: 0.000495 Lock_time: 0.000313 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930877;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:34:47
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 266 Schema: QC_hit: No
# Query_time: 0.011967 Lock_time: 0.011802 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930887;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 267 Schema: QC_hit: No
# Query_time: 0.013775 Lock_time: 0.000356 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930887;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 267 Schema: QC_hit: No
# Query_time: 0.008346 Lock_time: 0.008129 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930887;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 266 Schema: QC_hit: No
# Query_time: 0.000499 Lock_time: 0.000299 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930887;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:34:54
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 271 Schema: QC_hit: No
# Query_time: 0.000396 Lock_time: 0.000231 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930894;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 271 Schema: QC_hit: No
# Query_time: 0.000205 Lock_time: 0.000131 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930894;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:34:57
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 272 Schema: QC_hit: No
# Query_time: 0.000640 Lock_time: 0.000471 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930897;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 273 Schema: QC_hit: No
# Query_time: 0.000330 Lock_time: 0.000254 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930897;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 272 Schema: QC_hit: No
# Query_time: 0.000319 Lock_time: 0.000210 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930897;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 273 Schema: QC_hit: No
# Query_time: 0.004310 Lock_time: 0.004105 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930897;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:35:07
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 276 Schema: QC_hit: No
# Query_time: 0.000470 Lock_time: 0.000336 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930907;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 277 Schema: QC_hit: No
# Query_time: 0.000890 Lock_time: 0.000815 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930907;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 276 Schema: QC_hit: No
# Query_time: 0.000239 Lock_time: 0.000163 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930907;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 277 Schema: QC_hit: No
# Query_time: 0.001599 Lock_time: 0.001410 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930907;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:35:17
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 281 Schema: QC_hit: No
# Query_time: 0.016243 Lock_time: 0.016051 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930917;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 281 Schema: QC_hit: No
# Query_time: 0.010289 Lock_time: 0.010096 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930917;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 282 Schema: QC_hit: No
# Query_time: 0.060073 Lock_time: 0.059847 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930917;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 282 Schema: QC_hit: No
# Query_time: 0.006672 Lock_time: 0.006430 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930917;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:35:24
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 285 Schema: QC_hit: No
# Query_time: 0.000459 Lock_time: 0.000276 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930924;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 285 Schema: QC_hit: No
# Query_time: 0.000511 Lock_time: 0.000317 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930924;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:35:27
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 286 Schema: QC_hit: No
# Query_time: 0.006856 Lock_time: 0.006657 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930927;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 287 Schema: QC_hit: No
# Query_time: 0.003737 Lock_time: 0.003534 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930927;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 287 Schema: QC_hit: No
# Query_time: 0.000478 Lock_time: 0.000299 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930927;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 286 Schema: QC_hit: No
# Query_time: 0.000532 Lock_time: 0.000336 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930927;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:35:33
# User@Host: policy_user[policy_user] @ [10.233.72.84]
# Thread_id: 42 Schema: controlloop QC_hit: No
# Query_time: 0.502401 Lock_time: 0.502108 Rows_sent: 3 Rows_examined: 3
# Rows_affected: 0 Bytes_sent: 1148
SET timestamp=1647930933;
SELECT DESCRIPTION, HEALTHSTATUS, PARTICIPANTSTATE, definition_name, definition_version, name, version, participant_type_name, participant_type_version FROM Participant;
# Time: 220322 6:35:37
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 291 Schema: QC_hit: No
# Query_time: 0.000428 Lock_time: 0.000275 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930937;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:35:38
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 291 Schema: QC_hit: No
# Query_time: 0.841522 Lock_time: 0.841218 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930938;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 290 Schema: QC_hit: No
# Query_time: 0.893334 Lock_time: 0.893234 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930938;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:35:39
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 290 Schema: QC_hit: No
# Query_time: 0.859518 Lock_time: 0.859406 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930939;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:35:47
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 295 Schema: QC_hit: No
# Query_time: 0.000791 Lock_time: 0.000687 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930947;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 294 Schema: QC_hit: No
# Query_time: 0.001017 Lock_time: 0.000844 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930947;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 294 Schema: QC_hit: No
# Query_time: 0.000519 Lock_time: 0.000439 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930947;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 295 Schema: QC_hit: No
# Query_time: 0.001055 Lock_time: 0.000837 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930947;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:35:54
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 298 Schema: QC_hit: No
# Query_time: 0.000663 Lock_time: 0.000472 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930954;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 298 Schema: QC_hit: No
# Query_time: 0.000207 Lock_time: 0.000135 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930954;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:35:57
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 299 Schema: QC_hit: No
# Query_time: 0.001539 Lock_time: 0.001047 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930957;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 299 Schema: QC_hit: No
# Query_time: 0.000660 Lock_time: 0.000575 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930957;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 300 Schema: QC_hit: No
# Query_time: 0.001667 Lock_time: 0.001512 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930957;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 300 Schema: QC_hit: No
# Query_time: 0.000453 Lock_time: 0.000399 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930957;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
2022-03-22 6:36:07 304 [Warning] Aborted connection 304 to db: 'policyadmin' user: 'policy_user' host: '10.233.71.105' (Got an error reading communication packets)
# Time: 220322 6:36:07
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 306 Schema: QC_hit: No
# Query_time: 0.004509 Lock_time: 0.004111 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930967;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:36:08
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 307 Schema: QC_hit: No
# Query_time: 0.944141 Lock_time: 0.943954 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930968;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 306 Schema: QC_hit: No
# Query_time: 0.858155 Lock_time: 0.858071 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930968;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 307 Schema: QC_hit: No
# Query_time: 0.000935 Lock_time: 0.000858 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930968;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:36:17
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 311 Schema: QC_hit: No
# Query_time: 0.000841 Lock_time: 0.000623 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930977;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 310 Schema: QC_hit: No
# Query_time: 0.000592 Lock_time: 0.000299 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930977;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 310 Schema: QC_hit: No
# Query_time: 0.007106 Lock_time: 0.006900 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930977;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 311 Schema: QC_hit: No
# Query_time: 0.002036 Lock_time: 0.001883 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930977;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:36:24
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 314 Schema: QC_hit: No
# Query_time: 0.007341 Lock_time: 0.007158 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930984;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 314 Schema: QC_hit: No
# Query_time: 0.003956 Lock_time: 0.003771 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930984;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:36:27
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 316 Schema: QC_hit: No
# Query_time: 0.025970 Lock_time: 0.025286 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930987;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 315 Schema: QC_hit: No
# Query_time: 0.002764 Lock_time: 0.002389 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930987;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 315 Schema: QC_hit: No
# Query_time: 0.000463 Lock_time: 0.000295 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930987;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 316 Schema: QC_hit: No
# Query_time: 0.002811 Lock_time: 0.002667 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930987;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:36:37
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 320 Schema: QC_hit: No
# Query_time: 0.000350 Lock_time: 0.000218 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930997;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 320 Schema: QC_hit: No
# Query_time: 0.000538 Lock_time: 0.000348 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930997;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 321 Schema: QC_hit: No
# Query_time: 0.036305 Lock_time: 0.036134 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647930997;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 321 Schema: QC_hit: No
# Query_time: 0.000610 Lock_time: 0.000440 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647930997;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:36:43
# User@Host: policy_user[policy_user] @ [10.233.65.148]
# Thread_id: 150 Schema: policyclamp QC_hit: No
# Query_time: 0.004969 Lock_time: 0.003444 Rows_sent: 34 Rows_examined: 34
# Rows_affected: 0 Bytes_sent: 145793
use policyclamp;
SET timestamp=1647931003;
select policymode0_.policy_model_type as policy_m1_12_, policymode0_.version as version2_12_, policymode0_.created_by as created_3_12_, policymode0_.created_timestamp as created_4_12_, policymode0_.updated_by as updated_5_12_, policymode0_.updated_timestamp as updated_6_12_, policymode0_.policy_acronym as policy_a7_12_, policymode0_.policy_tosca as policy_t8_12_, policymode0_.policy_pdp_group as policy_p9_12_ from policy_models policymode0_;
2022-03-22 6:36:46 325 [Warning] Aborted connection 325 to db: 'policyadmin' user: 'policy_user' host: '10.233.71.105' (Got an error reading communication packets)
# Time: 220322 6:36:47
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 327 Schema: QC_hit: No
# Query_time: 0.002171 Lock_time: 0.001982 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647931007;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:36:48
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 328 Schema: QC_hit: No
# Query_time: 0.023986 Lock_time: 0.023796 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647931008;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 327 Schema: QC_hit: No
# Query_time: 0.000625 Lock_time: 0.000433 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647931008;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 328 Schema: QC_hit: No
# Query_time: 0.000483 Lock_time: 0.000325 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647931008;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:36:54
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 332 Schema: QC_hit: No
# Query_time: 0.007400 Lock_time: 0.007144 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647931014;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 332 Schema: QC_hit: No
# Query_time: 0.476556 Lock_time: 0.476333 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647931014;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# Time: 220322 6:36:57
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 334 Schema: QC_hit: No
# Query_time: 0.000504 Lock_time: 0.000319 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647931017;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 333 Schema: QC_hit: No
# Query_time: 0.015835 Lock_time: 0.015622 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647931017;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 334 Schema: QC_hit: No
# Query_time: 0.005692 Lock_time: 0.005469 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647931017;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 333 Schema: QC_hit: No
# Query_time: 0.000887 Lock_time: 0.000709 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647931017;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:37:02
# User@Host: policy_user[policy_user] @ [10.233.65.148]
# Thread_id: 150 Schema: policyclamp QC_hit: No
# Query_time: 0.001466 Lock_time: 0.000430 Rows_sent: 34 Rows_examined: 34
# Rows_affected: 0 Bytes_sent: 145793
SET timestamp=1647931022;
select policymode0_.policy_model_type as policy_m1_12_, policymode0_.version as version2_12_, policymode0_.created_by as created_3_12_, policymode0_.created_timestamp as created_4_12_, policymode0_.updated_by as updated_5_12_, policymode0_.updated_timestamp as updated_6_12_, policymode0_.policy_acronym as policy_a7_12_, policymode0_.policy_tosca as policy_t8_12_, policymode0_.policy_pdp_group as policy_p9_12_ from policy_models policymode0_;
# Time: 220322 6:37:07
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 338 Schema: QC_hit: No
# Query_time: 0.000354 Lock_time: 0.000203 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647931027;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 338 Schema: QC_hit: No
# Query_time: 0.000774 Lock_time: 0.000610 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647931027;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:37:08
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 339 Schema: QC_hit: No
# Query_time: 0.001548 Lock_time: 0.001390 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647931028;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 339 Schema: QC_hit: No
# Query_time: 0.000596 Lock_time: 0.000330 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647931028;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:37:17
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 343 Schema: QC_hit: No
# Query_time: 0.000879 Lock_time: 0.000714 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647931037;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# Time: 220322 6:37:18
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 344 Schema: QC_hit: No
# Query_time: 0.022836 Lock_time: 0.022637 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647931038;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 344 Schema: QC_hit: No
# Query_time: 0.004619 Lock_time: 0.004439 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 695
SET timestamp=1647931038;
SELECT
page_size, buffer_pool_instance, pages_used, pages_free, relocation_ops, relocation_time
FROM information_schema.innodb_cmpmem;
# User@Host: root[root] @ [127.0.0.1]
# Thread_id: 343 Schema: QC_hit: No
# Query_time: 0.007139 Lock_time: 0.006945 Rows_sent: 5 Rows_examined: 5
# Rows_affected: 0 Bytes_sent: 659
SET timestamp=1647931038;
SELECT
page_size, compress_ops, compress_ops_ok, compress_time, uncompress_ops, uncompress_time
FROM information_schema.innodb_cmp;