Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 17.05.2022 16:44
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 16688884 kB
MemAvailable 31466180 kB
Buffers 0 kB
Cached 15061288 kB
SwapCached 2616 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.10
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2022-05-17 16:42:29
DTS_END                         2022-05-17 16:42:29.7020
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/45602
TRN_ID                          234402
ATT_ID                          633
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 8945.25 23168 1073430
customer order: creation 166.73 399 20007
customer order: refuse 14.23 367 1707
order to supplier: creation 45.38 1303 5446
order to supplier: removal 3.43 104288 412
invoice (draft): creation 44.17 3570 5300
invoice (draft): removal 51.57 826 6188
invoice accept: apply 40.14 19368 4817
invoice accept: cancel 47.23 880 5668
customer reserve: creation 3650.91 194 438109
customer reserve: removal 4599.08 61 551889
realization accept: apply 81.46 188 9775
realization accept: cancel 74.00 117 8880
payment from customer: creation 56.88 121 6826
payment from customer: removal 5.92 140 710
payment to supplier: creation 48.39 131 5807
payment to supplier: removal 3.43 75 412
service: total inventory turnovers 4.83 1032 580
service: total monetary turnovers 6.60 26 792
service: aggregate perf. data 0.84 23449 101
service: refresh index statistics 0.03 306819 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 17-05-2022 16:44:32 to 17-05-2022 16:44:34.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 5191
TEST_TIME 2 3733
TEST_TIME 3 4362
TEST_TIME 4 5125
TEST_TIME 5 5034
TEST_TIME 6 4996
TEST_TIME 7 4938
TEST_TIME 8 5394
TEST_TIME 9 5461
TEST_TIME 10 5513
TEST_TIME 11 5596
TEST_TIME 12 5812
TEST_TIME 13 5786
TEST_TIME 14 6064
TEST_TIME 15 6437
TEST_TIME 16 6711
TEST_TIME 17 7413
TEST_TIME 18 7780
TEST_TIME 19 8067
TEST_TIME 20 8441
TEST_TIME 21 8816
TEST_TIME 22 9065
TEST_TIME 23 9285
TEST_TIME 24 9356
TEST_TIME 25 9851
TEST_TIME 26 10170
TEST_TIME 27 11291
TEST_TIME 28 11171
TEST_TIME 29 10863
TEST_TIME 30 10608
TEST_TIME 31 10534
TEST_TIME 32 10407
TEST_TIME 33 10231
TEST_TIME 34 10117
TEST_TIME 35 10229
TEST_TIME 36 10057
TEST_TIME 37 9949
TEST_TIME 38 9926
TEST_TIME 39 9867
TEST_TIME 40 9752
TEST_TIME 41 9615
TEST_TIME 42 9711
TEST_TIME 43 9587
TEST_TIME 44 9413
TEST_TIME 45 9385
TEST_TIME 46 9340
TEST_TIME 47 9321
TEST_TIME 48 9291
TEST_TIME 49 9167
TEST_TIME 50 9052
TEST_TIME 51 9044
TEST_TIME 52 9219
TEST_TIME 53 9157
TEST_TIME 54 9089
TEST_TIME 55 9203
TEST_TIME 56 9293
TEST_TIME 57 9281
TEST_TIME 58 9305
TEST_TIME 59 9365
TEST_TIME 60 9306
TEST_TIME 61 9368
TEST_TIME 62 9441
TEST_TIME 63 9466
TEST_TIME 64 9399
TEST_TIME 65 9468
TEST_TIME 66 9468
TEST_TIME 67 9357
TEST_TIME 68 9377
TEST_TIME 69 9294
TEST_TIME 70 9324
TEST_TIME 71 9269
TEST_TIME 72 9214
TEST_TIME 73 9137
TEST_TIME 74 9155
TEST_TIME 75 9166
TEST_TIME 76 9127
TEST_TIME 77 9094
TEST_TIME 78 9147
TEST_TIME 79 9112
TEST_TIME 80 9134
TEST_TIME 81 9107
TEST_TIME 82 9212
TEST_TIME 83 9224
TEST_TIME 84 9193
TEST_TIME 85 9189
TEST_TIME 86 9246
TEST_TIME 87 9284
TEST_TIME 88 9325
TEST_TIME 89 9397
TEST_TIME 90 9346
TEST_TIME 91 9271
TEST_TIME 92 9246
TEST_TIME 93 9245
TEST_TIME 94 9236
TEST_TIME 95 9196
TEST_TIME 96 9136
TEST_TIME 97 9153
TEST_TIME 98 9155
TEST_TIME 99 9105
TEST_TIME 100 9086
TEST_TIME 101 9040
TEST_TIME 102 9035
TEST_TIME 103 9040
TEST_TIME 104 9022
TEST_TIME 105 9041
TEST_TIME 106 9082
TEST_TIME 107 9078
TEST_TIME 108 9081
TEST_TIME 109 9129
TEST_TIME 110 9116
TEST_TIME 111 9109
TEST_TIME 112 9130
TEST_TIME 113 9194
TEST_TIME 114 9174
TEST_TIME 115 9139
TEST_TIME 116 9113
TEST_TIME 117 9066
TEST_TIME 118 9034
TEST_TIME 119 8998
TEST_TIME 120 8947

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 17-05-2022 16:44:36 to 17-05-2022 16:44:39.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1482285 1482285 0 0.00 0 18411 7 0 0
doc_list_biud 1482285 1482285 0 0.00 0 54463 29 0 0
sp_add_invoice_to_stock 4935 4817 118 2.39 30 167326 19369 0 118
sp_cancel_adding_invoice 5668 5668 0 0.00 5 70015 880 0 0
sp_cancel_client_order 1707 1707 0 0.00 4 12434 368 0 0
sp_cancel_customer_reserve 551889 551889 0 0.00 1 54464 62 0 0
sp_cancel_pay_from_customer 710 710 0 0.00 2 19397 140 0 0
sp_cancel_pay_to_supplier 412 412 0 0.00 2 4155 76 0 0
sp_cancel_supplier_invoice 6196 6188 8 0.12 2 40578 827 0 8
sp_cancel_supplier_order 412 412 0 0.00 7 1238548 104288 0 0
sp_cancel_write_off 8880 8880 0 0.00 1 17939 118 0 0
sp_client_order 20007 20007 0 0.00 3 28551 400 0 0
sp_customer_reserve 438109 438109 0 0.00 0 37692 195 0 0
sp_fill_shopping_cart 30735 30735 0 0.00 1 12981 39 0 0
sp_fill_shopping_cart_clo_res 438107 438107 0 0.00 0 22042 14 0 0
sp_get_clo_for_invoice 4812 4812 0 0.00 0 22665 346 0 0
sp_kill_cost_storno 15670 15670 0 0.00 0 18407 62 0 0
sp_kill_qstorno_ret_qs2qd 1119258 1119258 0 0.00 0 54460 33 0 0
sp_kill_qty_storno 589330 589330 0 0.00 0 54461 72 0 0
sp_lock_selected_doc 20283 20283 0 0.00 0 7854 5 0 0
sp_make_cost_storno 27219 27219 0 0.00 0 17931 59 0 0
sp_multiply_rows_for_pdistr 27219 27219 0 0.00 0 9571 27 0 0
sp_multiply_rows_for_qdistr 20007 20007 0 0.00 0 12944 161 0 0
sp_pay_from_customer 6826 6826 0 0.00 4 17945 121 0 0
sp_pay_to_supplier 5807 5807 0 0.00 5 18361 132 0 0
sp_payment_common 12633 12633 0 0.00 2 12879 30 0 0
sp_qd_handle_on_cancel_clo 1707 1707 0 0.00 0 12426 331 0 0
sp_qd_handle_on_invoice_upd_sts 10479 10479 0 0.00 0 17417 350 0 0
sp_qd_handle_on_reserve_upd_sts 9775 9775 0 0.00 0 15947 63 0 0
sp_reserve_write_off 9775 9775 0 0.00 6 17624 189 0 0
sp_supplier_invoice 5300 5300 0 0.00 6 86214 3571 0 0
sp_supplier_order 5446 5446 0 0.00 5 60646 1304 0 0
srv_aggregate_perf_data 101 101 0 0.00 2524 257013 23449 0 0
srv_fill_mon_cache_memory 63 63 0 0.00 1852 148981 47505 0 0
srv_find_qd_qs_mism 1028939 1028939 0 0.00 0 15772 6 0 0
srv_make_invnt_saldo 580 580 0 0.00 39 36219 1032 0 0
srv_make_money_saldo 792 792 0 0.00 1 636 27 0 0
srv_recalc_idx_stat 4 4 0 0.00 165508 543119 306819 0 0
t$perf-abend:sp_add_invoice_to_stock 118 118 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4817 4817 0 0.00 0 17591 239 0 0
t$perf-norm:sp_cancel_adding_invoice 450 450 0 0.00 0 6151 125 0 0
t$perf-norm:sp_cancel_client_order 1707 1707 0 0.00 0 4640 20 0 0
t$perf-norm:sp_cancel_customer_reserve 656 656 0 0.00 0 3768 17 0 0
t$perf-norm:sp_cancel_pay_from_customer 710 710 0 0.00 0 3742 19 0 0
t$perf-norm:sp_cancel_pay_to_supplier 412 412 0 0.00 0 1535 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 395 395 0 0.00 0 853 17 0 0
t$perf-norm:sp_cancel_supplier_order 412 412 0 0.00 0 26886 1908 0 0
t$perf-norm:sp_cancel_write_off 957 957 0 0.00 0 2791 14 0 0
t$perf-norm:sp_client_order 20007 20007 0 0.00 0 7402 19 0 0
t$perf-norm:sp_customer_reserve 952 952 0 0.00 0 3141 14 0 0
t$perf-norm:sp_pay_from_customer 6826 6826 0 0.00 0 9917 13 0 0
t$perf-norm:sp_pay_to_supplier 5807 5807 0 0.00 0 7836 13 0 0
t$perf-norm:sp_reserve_write_off 9775 9775 0 0.00 0 8308 18 0 0
t$perf-norm:sp_supplier_invoice 5300 5300 0 0.00 0 13061 24 0 0
t$perf-norm:sp_supplier_order 5446 5446 0 0.00 0 6288 18 0 0
t$perf-norm:srv_aggregate_perf_data 101 101 0 0.00 0 5089 75 0 0
t$perf-norm:srv_fill_mon_cache_memory 63 63 0 0.00 0 2406 39 0 0
t$perf-norm:srv_make_invnt_saldo 580 580 0 0.00 0 1114 20 0 0
t$perf-norm:srv_make_money_saldo 792 792 0 0.00 0 1165 16 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 9854 9618 236 2.39 0 17577 22 0 236
v_all_customers 36266 36266 0 0.00 0 17 1 0 0
v_all_suppliers 30100 30100 0 0.00 0 29 1 0 0
v_all_wares 40014 40014 0 0.00 0 118 1 0 0
v_cancel_adding_invoice 900 900 0 0.00 0 2104 9 0 0
v_cancel_client_order 3414 3414 0 0.00 0 5085 4 0 0
v_cancel_customer_prepayment 1420 1420 0 0.00 0 19374 36 0 0
v_cancel_customer_reserve 1312 1312 0 0.00 0 1846 6 0 0
v_cancel_payment_to_supplier 824 824 0 0.00 0 1089 4 0 0
v_cancel_supplier_invoice 806 790 16 1.98 0 2263 15 0 16
v_cancel_supplier_order 824 824 0 0.00 0 3451 13 0 0
v_cancel_write_off 1914 1914 0 0.00 0 17606 38 0 0
v_max_id_clo_ord 5445 5445 0 0.00 0 705 2 0 0
v_max_id_clo_res 952 952 0 0.00 0 2432 11 0 0
v_max_id_ord_sup 5279 5279 0 0.00 0 9488 6 0 0
v_max_non_paid_invoice 1481 1481 0 0.00 0 876 3 0 0
v_max_non_paid_realizn 3702 3702 0 0.00 0 7642 8 0 0
v_min_id_clo_ord 5445 5445 0 0.00 0 1688 6 0 0
v_min_id_clo_res 952 952 0 0.00 0 971 3 0 0
v_min_id_ord_sup 5279 5279 0 0.00 0 6784 5 0 0
v_min_non_paid_invoice 5807 5807 0 0.00 0 12877 23 0 0
v_min_non_paid_realizn 6826 6826 0 0.00 0 12733 21 0 0
v_our_firm 9996 9996 0 0.00 0 27 1 0 0
v_reserve_write_off 19550 19550 0 0.00 0 17570 9 0 0
x_lock_depdocs_on_canc_invoice 11461 11461 0 0.00 0 22164 128 0 0
x_lock_depdocs_on_canc_sup_ord 412 412 0 0.00 0 11391 385 0 0
x_make_qstorno_1000_1200 5446 5446 0 0.00 2 60403 1219 0 0
x_make_qstorno_1200_2000 5300 5300 0 0.00 3 86207 3434 0 0
x_make_qstorno_2100_3300 438109 438109 0 0.00 0 31950 179 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 17-05-2022 16:44:40 to 17-05-2022 16:44:44.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
14:12:33 1 8192000000 8797116400 8807743488 3955424 0.048 1 1 2 0 4053696 55488 42784
14:13:34 23130 8192000000 9903423616 10211135488 973337232 10.619 100 89 179 0 1002846608 6009504 23499872
14:15:00 29008 8192000000 9934379456 10252353536 1013393760 11.008 100 90 180 0 1045485168 8205776 23885632
14:16:43 18084 8192000000 9971528992 10304290816 1053320800 11.393 100 79 158 0 1082824640 9555216 19948624
14:18:03 13477 8192000000 10035427984 10385596416 1126290896 12.086 100 79 158 0 1155361584 10097776 18972912
14:19:18 6249 8192000000 10093321808 10452516864 1177864496 12.570 100 78 157 0 1207960240 12344576 17751168
14:20:26 4633 8192000000 10130575984 10500435968 1215577648 12.921 100 78 154 1 1246288192 13087456 17623088
14:21:33 10498 8192000000 10150993504 10530627584 1241686880 13.162 100 76 152 1 1273497888 15327616 16483392
14:22:47 1783 8192000000 10190468688 10568826880 1272790896 13.447 100 87 174 1 1305492144 13877424 18823824
14:23:51 1202 8192000000 10207955248 10591584256 1293972880 13.640 100 92 184 3 1327175936 12777600 20425456
14:24:53 5606 8192000000 10192033184 10597216256 1302827488 13.721 100 17 34 0 1316761984 10212752 3721744
14:26:01 8197 8192000000 10198079920 10607161344 1312261744 13.807 100 32 64 2 1326670592 7226288 7182560
14:27:11 64918 8192000000 10209723120 10624327680 1318249456 13.861 100 34 68 1 1331957456 5237408 8470592
14:29:17 4417 8192000000 10221710896 10633101312 1323986400 13.913 100 34 66 0 1336865872 5143360 7736112
14:30:22 6960 8192000000 10222012224 10640494592 1332444224 13.989 100 37 74 6 1346979856 6170976 8364656
14:31:29 24135 8192000000 10206114432 10614956032 1299261824 13.689 98 24 48 2 1310492576 5970912 5259840
14:32:56 14608 8192000000 10202878720 10621394944 1309252192 13.779 99 25 49 2 1321838512 6760512 5825808
14:34:11 5945 8192000000 10175484960 10583150592 1257593120 13.308 97 30 60 1 1270439376 5681056 7165200
14:35:19 10151 8192000000 10148075072 10547601408 1216175600 12.926 96 13 26 1 1223926128 5156416 2594112
14:36:31 10669 8192000000 10141340912 10540654592 1251046016 13.248 100 30 58 2 1262667520 5436640 6184864
14:37:43 19107 8192000000 10147663104 10557767680 1250772752 13.245 99 18 36 1 1260446016 5611664 4061600
14:39:06 6818 8192000000 10181992656 10587246592 1285205248 13.561 100 31 62 0 1298521312 6263904 7052160
14:40:16 8255 8192000000 10194366912 10605985792 1301344688 13.707 100 15 30 1 1309684800 4997920 3342192
14:41:24 38218 8192000000 10194709872 10616266752 1300036624 13.696 99 20 38 0 1309901728 5380656 4484448
14:43:17 10218 8192000000 10241162000 10648977408 1333752560 14.001 100 54 108 1 1353516000 7304736 12458704
14:44:33 17182 8192000000 10264517856 10675494912 1354109776 14.184 100 53 105 1 1375990592 10371808 11509008
14:45:59 42888 8192000000 10285102912 10714746880 1373116240 14.355 100 32 64 0 1397556496 17016064 7424192
14:47:44 15248 8192000000 10317554528 10734690304 1393440528 14.537 100 48 97 3 1424992768 20586576 10965664
14:49:13 25330 8192000000 10329216320 10755371008 1409982624 14.684 100 55 110 2 1448334736 24271088 14081024
14:50:44 7329 8192000000 10350544464 10770247680 1417694480 14.752 100 60 120 1 1457986912 25851984 14440448
14:51:58 4039 8192000000 10349322944 10770984960 1416315280 14.740 100 55 110 0 1459251376 29268608 13667488
14:53:08 5731 8192000000 10348137520 10762350592 1387274480 14.482 98 74 148 0 1437644400 33204592 17165328
14:54:20 2559 8192000000 10357823504 10774855680 1410753664 14.691 100 63 125 0 1465170512 39223216 15193632
14:55:30 6900 8192000000 10359317056 10769899520 1400869504 14.603 100 83 164 0 1464607136 43337248 20400384
14:56:43 5076 8192000000 10343217088 10750132224 1380661744 14.422 100 73 145 2 1447231728 47763376 18806608
14:57:58 2281 8192000000 10364275584 10770518016 1393883424 14.541 100 82 164 0 1466658576 51260256 21514896
14:59:03 1850 8192000000 10361707920 10768449536 1377952768 14.398 99 86 173 0 1452200272 51825248 22422256
15:00:09 2314 8192000000 10363456704 10770182144 1378713824 14.405 99 86 168 2 1452005984 53442288 19849872
15:01:20 4362 8192000000 10377023744 10783670272 1404969056 14.639 100 86 168 2 1479646176 53508992 21168128
15:02:28 14550 8192000000 10359696160 10783277056 1396517376 14.564 100 49 97 0 1467857504 57909952 13430176
15:03:46 17812 8192000000 10334074880 10757054464 1376885472 14.389 100 40 81 3 1440256688 52448624 10922592
15:05:04 20386 8192000000 10347791664 10787811328 1396179984 14.561 100 32 64 0 1454421056 49358144 8882928
15:06:26 20040 8192000000 10343826560 10776825856 1384156128 14.454 100 29 58 0 1442458688 49599216 8703344
15:08:04 34635 8192000000 10309851392 10751082496 1347921968 14.129 99 22 44 0 1406056816 51369376 6765472
15:09:41 32954 8192000000 10266892816 10720538624 1336795680 14.029 98 18 36 0 1360251136 19225280 4230176
15:11:33 48807 8192000000 10257180192 10697216000 1343016304 14.085 98 16 30 0 1352618704 6343536 3258864
15:13:29 61108 8192000000 10281409152 10735992832 1366218240 14.293 99 9 18 0 1378395072 10171200 2005632
15:15:58 34965 8192000000 10276633120 10732605440 1379274400 14.410 100 12 24 0 1395294960 13228224 2792336
15:18:21 74125 8192000000 10273529808 10723426304 1367053600 14.301 99 16 32 0 1380555952 9928384 3573968
15:20:36 37886 8192000000 10278884160 10731626496 1376311008 14.384 100 28 56 0 1392957968 10530976 6115984
15:22:15 96886 8192000000 10295752992 10746200064 1382264144 14.437 100 27 52 0 1402914400 14361248 6289008
15:24:54 68459 8192000000 10276598384 10738282496 1357690176 14.217 98 9 18 0 1372440544 12684688 2065680
15:27:04 6641 8192000000 10300381648 10742329344 1387844304 14.487 100 66 131 1 1411188032 7936528 15407200
15:28:13 39090 8192000000 10298378032 10754777088 1393684768 14.539 100 35 71 1 1415544096 13131968 8727360
15:30:15 63460 8192000000 10311992224 10773598208 1401486800 14.608 100 14 28 0 1420811536 16067216 3257520
15:32:48 72985 8192000000 10289594576 10760458240 1384808288 14.460 99 21 42 1 1410678656 20466880 5403488
15:35:05 44755 8192000000 10311939216 10755395584 1375900304 14.380 99 23 46 0 1393878448 12815360 5162784
15:36:57 87557 8192000000 10293073008 10767302656 1375055760 14.372 98 17 34 1 1392533232 13477888 3999584
15:39:26 73688 8192000000 10303333152 10762088448 1378515824 14.403 98 26 52 0 1398825008 14566656 5742528
15:41:45 35329 8192000000 10295416336 10737602560 1360032192 14.238 98 24 48 3 1373439712 7845776 5561744
15:43:22 99762 8192000000 10288299888 10747981824 1306351008 13.753 94 20 40 0 1324049200 13778288 3919904
15:46:23 40793 8192000000 10301894912 10738331648 1350646400 14.153 98 42 84 1 1375259456 15076032 9537024
15:48:10 96743 8192000000 10282091040 10724536320 1345890576 14.110 97 23 46 0 1367812400 16348912 5572912
15:50:47 68635 8192000000 10265750752 10710405120 1306162560 13.751 95 22 42 0 1321704656 10981552 4560544
15:53:00 54422 8192000000 10257130544 10715537408 1325263712 13.924 97 6 12 0 1334439696 8138720 1037264
15:54:55 68178 8192000000 10271172512 10721161216 1337979136 14.039 97 16 32 0 1351160592 9500400 3681056
15:57:03 65014 8192000000 10257404384 10720501760 1352807968 14.173 99 7 14 0 1364509872 10331856 1370048
15:59:09 50698 8192000000 10263380752 10721394688 1332337376 13.988 97 11 22 1 1349665056 14638960 2688720
16:01:02 44940 8192000000 10274573264 10717609984 1344481984 14.098 98 30 60 0 1361780192 10463984 6834224
16:02:48 75030 8192000000 10257892480 10717855744 1335835792 14.020 98 22 44 0 1356853040 15775424 5241824
16:05:07 77374 8192000000 10266756912 10719891456 1329111200 13.959 97 8 17 0 1340874656 10402880 1360576
16:07:29 46815 8192000000 10297088400 10730651648 1359419728 14.232 99 40 80 0 1389559328 21293104 8846496
16:09:17 148980 8192000000 10289485264 10752221184 1373090848 14.355 100 10 20 1 1393759136 18579744 2088544
16:12:47 115304 8192000000 10298594288 10748862464 1375592128 14.377 99 31 62 2 1391324688 9154432 6578128
16:15:43 36042 8192000000 10300454320 10740240384 1381970304 14.434 100 45 88 6 1400040048 8159408 9910336
16:17:20 53248 8192000000 10289534736 10745446400 1381961248 14.434 99 16 32 0 1396375856 10691344 3723264
16:19:19 65253 8192000000 10281331408 10752212992 1373524048 14.359 99 8 16 1 1387390080 11982336 1883696
16:21:29 83985 8192000000 10295466640 10760577024 1370001376 14.327 98 17 34 1 1386325520 12934496 3389648
16:23:54 57329 8192000000 10295341696 10766761984 1385677488 14.467 99 17 34 0 1403710752 13724672 4308592
16:26:00 49016 8192000000 10304097424 10759290880 1385500592 14.466 99 15 30 0 1399000992 9926400 3574000
16:27:58 69266 8192000000 10270651008 10740449280 1333824864 14.002 96 7 14 0 1345215616 9735536 1655216
16:30:09 107799 8192000000 10292038848 10753085440 1352464800 14.170 97 15 30 1 1369754656 13988288 3301568
16:33:02 34737 8192000000 10291437824 10735628288 1341403952 14.070 97 30 60 0 1363776032 15527984 6844096
16:34:57 32919 8192000000 10274950608 10714378240 1314165536 13.824 96 36 72 0 1332719744 10918304 7635904
16:36:31 32494 8192000000 10284163168 10723454976 1330009408 13.967 97 33 66 0 1351441376 14351952 7080016
16:38:07 133873 8192000000 10258455792 10718404608 1336659728 14.027 97 22 43 0 1347897344 5864416 5373200
16:42:01 44633 8192000000 9648827568 10011467776 785098544 8.745 58 2 4 0 790218256 4756560 363152

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 17-05-2022 16:44:46 to 17-05-2022 16:45:01.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 118 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 17-05-2022 16:45:02 to 17-05-2022 16:45:04.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          235955
MON$OLDEST_ACTIVE               235956
MON$OLDEST_SNAPSHOT             235956
MON$NEXT_TRANSACTION            235956
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       2010944
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.10.33592 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.10.33592 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.10.33592 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.10.33592 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

Final processing ISQL logs in /var/tmp/logs-oltp30 according to config parameter 'remove_isql_logs'

17.05.22 16:45:05. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2022-05-17 16:45:07 No severe PSQL-related problems occured
17.05.22 16:45:08. End of report.