Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 31.05.2022 10:39
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 16101760 kB
MemAvailable 31395700 kB
Buffers 0 kB
Cached 15639356 kB
SwapCached 2440 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 4.0.2
DB_NAME                         /home/bases/oltp40-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/oltp40-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp40-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb40/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=3400
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/oltp40-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-oltp40
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-31 10:37:15
DTS_END                         2022-05-31 10:37:15.9050
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(68:17)
IP                              ::1/45368
TRN_ID                          228349
ATT_ID                          639
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: 8941.13 26050 1072935
customer order: creation 177.50 454 21300
customer order: refuse 15.17 402 1820
order to supplier: creation 48.69 1390 5843
order to supplier: removal 3.25 154527 390
invoice (draft): creation 47.73 3379 5728
invoice (draft): removal 46.95 1037 5634
invoice accept: apply 43.54 27190 5225
invoice accept: cancel 42.83 1408 5139
customer reserve: creation 4023.89 260 482867
customer reserve: removal 4194.73 95 503367
realization accept: apply 87.48 279 10497
realization accept: cancel 74.80 163 8976
payment from customer: creation 61.75 179 7410
payment from customer: removal 6.11 147 733
payment to supplier: creation 50.21 219 6025
payment to supplier: removal 3.36 107 403
service: total inventory turnovers 4.21 4047 505
service: total monetary turnovers 7.91 306 949
service: aggregate perf. data 0.99 15699 119
service: refresh index statistics 0.04 309702 5

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 31-05-2022 10:39:50 to 31-05-2022 10:39:52.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8693
TEST_TIME 2 6477
TEST_TIME 3 6837
TEST_TIME 4 6323
TEST_TIME 5 6451
TEST_TIME 6 6630
TEST_TIME 7 6734
TEST_TIME 8 6796
TEST_TIME 9 6996
TEST_TIME 10 7129
TEST_TIME 11 7613
TEST_TIME 12 7821
TEST_TIME 13 7990
TEST_TIME 14 7885
TEST_TIME 15 8008
TEST_TIME 16 8306
TEST_TIME 17 8393
TEST_TIME 18 8523
TEST_TIME 19 8580
TEST_TIME 20 8541
TEST_TIME 21 8541
TEST_TIME 22 8559
TEST_TIME 23 8674
TEST_TIME 24 8657
TEST_TIME 25 8835
TEST_TIME 26 8790
TEST_TIME 27 9126
TEST_TIME 28 9429
TEST_TIME 29 9669
TEST_TIME 30 10015
TEST_TIME 31 10223
TEST_TIME 32 10342
TEST_TIME 33 10444
TEST_TIME 34 10718
TEST_TIME 35 11016
TEST_TIME 36 10873
TEST_TIME 37 10741
TEST_TIME 38 10811
TEST_TIME 39 10748
TEST_TIME 40 10623
TEST_TIME 41 10488
TEST_TIME 42 10400
TEST_TIME 43 10551
TEST_TIME 44 10400
TEST_TIME 45 10390
TEST_TIME 46 10206
TEST_TIME 47 10144
TEST_TIME 48 10049
TEST_TIME 49 10001
TEST_TIME 50 9897
TEST_TIME 51 9863
TEST_TIME 52 9868
TEST_TIME 53 9823
TEST_TIME 54 9901
TEST_TIME 55 9785
TEST_TIME 56 9679
TEST_TIME 57 9636
TEST_TIME 58 9626
TEST_TIME 59 9519
TEST_TIME 60 9646
TEST_TIME 61 9667
TEST_TIME 62 9709
TEST_TIME 63 9712
TEST_TIME 64 9693
TEST_TIME 65 9657
TEST_TIME 66 9663
TEST_TIME 67 9680
TEST_TIME 68 9663
TEST_TIME 69 9692
TEST_TIME 70 9700
TEST_TIME 71 9726
TEST_TIME 72 9690
TEST_TIME 73 9677
TEST_TIME 74 9621
TEST_TIME 75 9570
TEST_TIME 76 9505
TEST_TIME 77 9470
TEST_TIME 78 9453
TEST_TIME 79 9364
TEST_TIME 80 9355
TEST_TIME 81 9345
TEST_TIME 82 9336
TEST_TIME 83 9321
TEST_TIME 84 9290
TEST_TIME 85 9320
TEST_TIME 86 9292
TEST_TIME 87 9307
TEST_TIME 88 9275
TEST_TIME 89 9373
TEST_TIME 90 9320
TEST_TIME 91 9442
TEST_TIME 92 9450
TEST_TIME 93 9418
TEST_TIME 94 9327
TEST_TIME 95 9333
TEST_TIME 96 9318
TEST_TIME 97 9292
TEST_TIME 98 9212
TEST_TIME 99 9181
TEST_TIME 100 9152
TEST_TIME 101 9148
TEST_TIME 102 9103
TEST_TIME 103 9179
TEST_TIME 104 9154
TEST_TIME 105 9132
TEST_TIME 106 9124
TEST_TIME 107 9132
TEST_TIME 108 9181
TEST_TIME 109 9171
TEST_TIME 110 9269
TEST_TIME 111 9248
TEST_TIME 112 9251
TEST_TIME 113 9246
TEST_TIME 114 9187
TEST_TIME 115 9144
TEST_TIME 116 9131
TEST_TIME 117 9087
TEST_TIME 118 9031
TEST_TIME 119 9030
TEST_TIME 120 8961

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 31-05-2022 10:39:53 to 31-05-2022 10:39:57.

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 1518435 1518435 0 0.00 0 18595 14 0 0
doc_list_biud 1518422 1518422 0 0.00 0 48550 38 0 0
sp_add_invoice_to_stock 5386 5225 161 2.98 59 208859 27190 0 161
sp_cancel_adding_invoice 5139 5139 0 0.00 4 98289 1408 0 0
sp_cancel_client_order 1820 1820 0 0.00 6 10629 403 0 0
sp_cancel_customer_reserve 503367 503367 0 0.00 1 48553 96 0 0
sp_cancel_pay_from_customer 733 733 0 0.00 3 3879 148 0 0
sp_cancel_pay_to_supplier 403 403 0 0.00 4 4062 108 0 0
sp_cancel_supplier_invoice 5647 5634 13 0.23 2 45597 1038 0 13
sp_cancel_supplier_order 390 390 0 0.00 7 1302504 154528 0 0
sp_cancel_write_off 8976 8976 0 0.00 2 10758 163 0 0
sp_client_order 21300 21300 0 0.00 6 21636 455 0 0
sp_customer_reserve 482867 482867 0 0.00 0 101934 261 0 0
sp_fill_shopping_cart 32862 32862 0 0.00 2 16338 90 0 0
sp_fill_shopping_cart_clo_res 482844 482844 0 0.00 0 18570 20 0 0
sp_get_clo_for_invoice 5195 5195 0 0.00 0 18683 302 0 0
sp_kill_cost_storno 15251 15251 0 0.00 0 9721 67 0 0
sp_kill_qstorno_ret_qs2qd 1021734 1021734 0 0.00 0 48547 42 0 0
sp_kill_qty_storno 541017 541017 0 0.00 0 48550 97 0 0
sp_lock_selected_doc 21673 21673 0 0.00 0 11718 9 0 0
sp_make_cost_storno 29126 29126 0 0.00 0 18540 84 0 0
sp_multiply_rows_for_pdistr 29124 29124 0 0.00 0 10012 40 0 0
sp_multiply_rows_for_qdistr 21299 21299 0 0.00 0 12045 174 0 0
sp_pay_from_customer 7410 7410 0 0.00 5 8461 179 0 0
sp_pay_to_supplier 6025 6025 0 0.00 6 13027 220 0 0
sp_payment_common 13433 13433 0 0.00 2 6179 47 0 0
sp_qd_handle_on_cancel_clo 1820 1820 0 0.00 1 7717 311 0 0
sp_qd_handle_on_invoice_upd_sts 10334 10334 0 0.00 0 9752 529 0 0
sp_qd_handle_on_reserve_upd_sts 10496 10496 0 0.00 0 23763 53 0 0
sp_reserve_write_off 10497 10497 0 0.00 8 23895 279 0 0
sp_supplier_invoice 5728 5728 0 0.00 10 91256 3380 0 0
sp_supplier_order 5843 5843 0 0.00 8 30386 1390 0 0
srv_aggregate_perf_data 119 119 0 0.00 2452 229836 15700 0 0
srv_fill_mon_cache_memory 71 71 0 0.00 702 147511 36804 0 0
srv_find_qd_qs_mism 1022449 1022449 0 0.00 0 14706 11 0 0
srv_make_invnt_saldo 505 505 0 0.00 82 71372 4048 0 0
srv_make_money_saldo 949 949 0 0.00 1 17858 307 0 0
srv_recalc_idx_stat 5 5 0 0.00 243997 435521 309702 0 0
t$perf-abend:sp_add_invoice_to_stock 161 161 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5227 5227 0 0.00 0 36778 1001 0 0
t$perf-norm:sp_cancel_adding_invoice 461 461 0 0.00 1 6718 522 0 0
t$perf-norm:sp_cancel_client_order 1820 1820 0 0.00 0 32090 47 0 0
t$perf-norm:sp_cancel_customer_reserve 739 739 0 0.00 0 1796 28 0 0
t$perf-norm:sp_cancel_pay_from_customer 733 733 0 0.00 0 1327 18 0 0
t$perf-norm:sp_cancel_pay_to_supplier 403 403 0 0.00 0 305 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 417 417 0 0.00 0 1351 39 0 0
t$perf-norm:sp_cancel_supplier_order 390 390 0 0.00 0 90502 6675 0 0
t$perf-norm:sp_cancel_write_off 1021 1021 0 0.00 0 1378 20 0 0
t$perf-norm:sp_client_order 21300 21300 0 0.00 0 6366 35 0 0
t$perf-norm:sp_customer_reserve 1062 1062 0 0.00 0 6356 22 0 0
t$perf-norm:sp_pay_from_customer 7410 7410 0 0.00 0 4333 20 0 0
t$perf-norm:sp_pay_to_supplier 6026 6026 0 0.00 0 6735 23 0 0
t$perf-norm:sp_reserve_write_off 10498 10498 0 0.00 0 4265 23 0 0
t$perf-norm:sp_supplier_invoice 5729 5729 0 0.00 0 2157 30 0 0
t$perf-norm:sp_supplier_order 5843 5843 0 0.00 0 5042 36 0 0
t$perf-norm:srv_aggregate_perf_data 119 119 0 0.00 0 687 21 0 0
t$perf-norm:srv_fill_mon_cache_memory 71 71 0 0.00 0 564 16 0 0
t$perf-norm:srv_make_invnt_saldo 505 505 0 0.00 0 711 11 0 0
t$perf-norm:srv_make_money_saldo 949 949 0 0.00 0 2185 10 0 0
t$perf-norm:srv_recalc_idx_stat 5 5 0 0.00 3 183 96 0 0
v_add_invoice_to_stock 10708 10386 322 3.00 0 7837 29 0 322
v_all_customers 38654 38654 0 0.00 0 183 4 0 0
v_all_suppliers 31850 31850 0 0.00 0 86 4 0 0
v_all_wares 42588 42588 0 0.00 0 106 4 0 0
v_cancel_adding_invoice 922 922 0 0.00 0 2992 22 0 0
v_cancel_client_order 3640 3640 0 0.00 0 5796 16 0 0
v_cancel_customer_prepayment 1466 1466 0 0.00 0 2078 17 0 0
v_cancel_customer_reserve 1478 1478 0 0.00 1 4354 15 0 0
v_cancel_payment_to_supplier 806 806 0 0.00 0 284 10 0 0
v_cancel_supplier_invoice 860 834 26 3.02 0 2692 29 0 26
v_cancel_supplier_order 780 780 0 0.00 0 339 12 0 0
v_cancel_write_off 2042 2042 0 0.00 0 5583 26 0 0
v_max_id_clo_ord 5842 5842 0 0.00 0 301 5 0 0
v_max_id_clo_res 1062 1062 0 0.00 0 1425 15 0 0
v_max_id_ord_sup 5726 5726 0 0.00 0 8533 9 0 0
v_max_non_paid_invoice 1666 1666 0 0.00 0 145 8 0 0
v_max_non_paid_realizn 4046 4046 0 0.00 0 3269 9 0 0
v_min_id_clo_ord 5842 5842 0 0.00 0 1743 9 0 0
v_min_id_clo_res 1062 1062 0 0.00 0 4863 17 0 0
v_min_id_ord_sup 5726 5726 0 0.00 0 8560 15 0 0
v_min_non_paid_invoice 6024 6024 0 0.00 0 5250 14 0 0
v_min_non_paid_realizn 7409 7409 0 0.00 0 6155 16 0 0
v_our_firm 10660 10660 0 0.00 0 74 5 0 0
v_reserve_write_off 20992 20992 0 0.00 0 7837 12 0 0
x_lock_depdocs_on_canc_invoice 10356 10356 0 0.00 0 11779 128 0 0
x_lock_depdocs_on_canc_sup_ord 390 390 0 0.00 0 4728 350 0 0
x_make_qstorno_1000_1200 5843 5843 0 0.00 3 30368 1201 0 0
x_make_qstorno_1200_2000 5728 5728 0 0.00 4 89461 3148 0 0
x_make_qstorno_2100_3300 482866 482866 0 0.00 0 101918 228 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 31-05-2022 10:39:58 to 31-05-2022 10:40:02.

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
08:07:19 8 8192000000 8799252064 8810516480 5260816 0.064 2 1 2 0 5360240 63648 35776
08:08:20 33422 8192000000 9735438048 10036723712 807481712 8.972 100 89 177 1 837262160 7960016 21820432
08:10:07 26555 8192000000 9771367984 10081923072 841112096 9.311 100 91 182 0 878006912 15319152 21575664
08:11:43 12502 8192000000 9812615552 10140192768 874738928 9.647 100 79 158 1 926707856 34128688 17840240
08:13:00 6919 8192000000 9896271200 10230288384 923565840 10.131 100 87 172 0 1001948304 59416528 18965936
08:14:08 2600 8192000000 9929464736 10273001472 964155008 10.530 100 91 182 0 1042822256 59222512 19444736
08:15:14 1343 8192000000 9975909184 10331521024 998657488 10.866 100 90 179 2 1095539728 79305360 17576880
08:16:17 1070 8192000000 10007315824 10371899392 1028402800 11.153 100 93 180 3 1126771184 79643648 18724736
08:17:19 957 8192000000 10020097184 10399326208 1050660816 11.367 100 93 180 1 1137385536 69584544 17140176
08:18:21 1103 8192000000 10026690704 10401456128 1061548336 11.471 100 97 193 0 1151592448 69737600 20306512
08:19:24 1509 8192000000 10049567264 10433449984 1065568320 11.510 100 89 170 1 1171543328 87950432 18024576
08:20:26 2110 8192000000 10048736944 10430943232 1072212592 11.573 100 85 156 1 1165639136 77351024 16075520
08:21:29 768 8192000000 10061337936 10449801216 1080812272 11.655 100 84 156 0 1179844048 83205696 15826080
08:22:31 1205 8192000000 10054318528 10441068544 1083357136 11.679 100 94 174 0 1171903744 69516240 19030368
08:23:33 1326 8192000000 10056210672 10442362880 1087486112 11.719 100 96 185 0 1174805616 69076976 18242528
08:24:35 1171 8192000000 10062019600 10447355904 1093300576 11.774 100 89 175 1 1184136432 72876352 17959504
08:25:37 3266 8192000000 10053775472 10446462976 1093730560 11.778 100 76 152 1 1179547152 70342272 15474320
08:26:41 1294 8192000000 10072662128 10458918912 1096230512 11.802 100 97 192 0 1191618880 76160624 19227744
08:27:43 1332 8192000000 10058497088 10449444864 1093996704 11.781 100 96 175 1 1179696896 66512784 19187408
08:28:46 938 8192000000 10074099824 10467315712 1089323088 11.736 100 98 191 3 1199224896 89467984 20433824
08:29:48 1459 8192000000 10011130592 10402672640 1083084128 11.677 100 75 145 2 1130002720 31175968 15742624
08:30:50 1001 8192000000 10020350880 10399432704 1073583488 11.586 100 92 179 1 1141547456 50399712 17564256
08:31:52 2726 8192000000 10007785936 10388365312 1054735712 11.406 100 75 141 2 1122462288 53273664 14452912
08:32:56 2020 8192000000 10004440928 10381336576 1053230432 11.392 99 83 156 4 1129158480 58367008 17561040
08:33:58 6903 8192000000 9973342176 10346635264 1039688992 11.262 99 74 136 1 1102125072 49256432 13179648
08:35:06 4332 8192000000 9988517296 10360705024 1020716080 11.079 99 70 136 0 1106185488 71942896 13526512
08:36:12 986 8192000000 10023926128 10400280576 1046956256 11.331 100 90 167 1 1145125040 80760736 17408048
08:37:14 2324 8192000000 9982857936 10365919232 1044790640 11.311 100 61 111 0 1108498816 53460640 10247536
08:38:24 1764 8192000000 10010978000 10384261120 1052966272 11.389 100 90 169 3 1129203216 58830000 17406944
08:39:31 9468 8192000000 10049194912 10439643136 1070741376 11.559 100 68 135 1 1172101888 87883552 13476960
08:40:48 4595 8192000000 10048941664 10434875392 1088442800 11.728 100 85 151 2 1168438016 65723456 14271760
08:41:59 11547 8192000000 10107013040 10502782976 1088188160 11.725 99 66 131 0 1212744096 110320656 14235280
08:43:17 7185 8192000000 10121913792 10519441408 1104636864 11.882 100 67 130 0 1242348000 123669584 14041552
08:44:32 7628 8192000000 10151314448 10549194752 1115360032 11.983 100 67 130 0 1262455920 133708016 13387872
08:45:44 1820 8192000000 10158761376 10548023296 1121445120 12.041 100 94 176 3 1271315504 131999376 17871008
08:46:49 2202 8192000000 10201734752 10595438592 1144244464 12.255 100 96 184 0 1313918176 151610416 18063296
08:47:55 1985 8192000000 10206790544 10610991104 1140338576 12.219 100 69 134 0 1319857664 165003280 14515808
08:49:00 1921 8192000000 10215921168 10621300736 1154312704 12.350 100 95 178 3 1322061408 147850016 19898688
08:50:06 8370 8192000000 10220495904 10624098304 1164308752 12.444 100 74 146 1 1331540384 151137632 16094000
08:51:20 1004 8192000000 10267350880 10669330432 1172871024 12.524 100 94 184 1 1377144736 184405184 19868528
08:52:24 1201 8192000000 10268974752 10693562368 1176370992 12.556 100 80 155 0 1379749088 186373296 17004800
08:53:27 1542 8192000000 10296101520 10709258240 1176134752 12.554 100 86 166 0 1402893776 207675376 19083648
08:54:35 979 8192000000 10332110544 10742317056 1188727488 12.672 100 95 183 0 1434247376 225309152 20210736
08:55:42 860 8192000000 10306336944 10714685440 1178637664 12.577 99 94 189 4 1409557744 209273328 21646752
08:56:45 1052 8192000000 10357735552 10768347136 1199933088 12.776 100 94 185 0 1460754448 239519856 21301504
08:57:51 786 8192000000 10382277376 10783465472 1200127872 12.778 100 98 192 0 1484650720 261817216 22705632
08:58:54 1175 8192000000 10434389776 10855497728 1206935408 12.841 100 96 187 0 1538912416 308968384 23008624
08:59:59 837 8192000000 10438720304 10859175936 1195231504 12.732 100 97 193 1 1545288272 325882240 24174528
09:01:02 1040 8192000000 10460057056 10889510912 1194031872 12.721 100 95 188 2 1564262800 347834320 22396608
09:02:07 689 8192000000 10477088208 10914967552 1182722112 12.616 100 97 186 0 1575872624 371583344 21567168
09:03:10 2373 8192000000 10483127648 10902175744 1170019696 12.497 99 76 150 0 1580110320 391598352 18492272
09:04:16 6484 8192000000 10493745808 10959732736 1179246048 12.583 100 63 123 0 1598977504 404399392 15332064
09:05:32 12316 8192000000 10413309808 10886569984 1183833664 12.626 100 43 86 0 1551986208 356982640 11169904
09:06:46 8983 8192000000 10332669872 10840129536 1156793888 12.373 98 34 68 1 1437921408 272579264 8548256
09:07:57 24273 8192000000 10293677152 10789597184 1139218800 12.208 98 30 58 4 1409326016 263144752 6962464
09:09:44 29676 8192000000 10242051872 10668429312 1122651728 12.052 98 52 100 1 1325579936 190073648 12854560
09:11:24 51201 8192000000 10143456192 10695913472 1117353776 12.002 98 7 14 0 1253947088 134838544 1754768
09:13:46 51036 8192000000 10119234256 10577293312 1110565968 11.938 98 9 18 0 1167730352 55245440 1918944
09:15:38 104856 8192000000 10071190032 10528641024 1105752864 11.892 98 18 35 1 1174536704 64959648 3824192
09:18:24 33040 8192000000 10092379808 10519388160 1126068496 12.084 99 32 62 0 1177021920 44239648 6713776
09:19:58 106369 8192000000 10070169568 10501619712 1081518944 11.662 95 18 35 0 1122608528 36823920 4265664
09:22:46 147508 8192000000 10071434320 10534051840 1120359840 12.030 98 25 48 1 1176771168 51349616 5061712
09:26:18 99695 8192000000 10069440816 10493378560 1109717520 11.930 96 71 125 2 1151626896 26652352 15257024
09:28:58 13213 8192000000 10133549376 10577010688 1154160272 12.349 100 35 69 2 1230725888 69514720 7050896
09:30:13 24801 8192000000 10131655904 10582933504 1157131520 12.376 100 39 74 1 1218861600 54275184 7454896
09:31:42 23750 8192000000 10095370352 10585153536 1149510912 12.305 100 14 28 0 1196912608 44595792 2805904
09:33:06 57417 8192000000 10134510480 10583695360 1104118960 11.877 96 14 28 0 1176215744 69309120 2787664
09:35:04 38375 8192000000 10098583872 10553962496 1106573648 11.900 98 26 52 0 1206589040 93491616 6523776
09:36:43 73289 8192000000 10116728880 10652237824 1102505840 11.861 98 15 30 1 1245744832 139471312 3767680
09:38:58 80143 8192000000 10071318480 10504708096 1068951568 11.542 94 23 46 0 1109491616 35246784 5293264
09:41:19 22406 8192000000 10075952816 10511962112 1089705136 11.740 96 50 92 0 1140440800 41458032 9277632
09:42:45 41230 8192000000 10115690608 10545496064 1129395440 12.116 100 37 74 0 1198972512 61650592 7926480
09:44:28 74169 8192000000 10099444048 10563846144 1101240384 11.849 97 19 38 0 1204229264 99164208 3824672
09:46:43 50098 8192000000 10079686576 10529529856 1107627872 11.910 98 13 24 0 1136143424 26384416 2131136
09:48:37 53483 8192000000 10131998464 10591318016 1091921232 11.761 96 31 62 0 1160597936 62578752 6097952
09:50:52 86343 8192000000 10073082848 10540482560 1109034624 11.923 99 28 56 0 1184743008 69764048 5944336
09:53:18 25429 8192000000 10065684656 10517315584 1118891632 12.017 99 35 68 1 1174024672 48883088 6249952
09:54:46 58073 8192000000 10096086176 10568732672 1143472480 12.248 100 29 58 1 1209894832 60661152 5761200
09:56:46 87676 8192000000 10091521680 10600058880 1113967264 11.970 97 12 24 0 1184302048 67542848 2791936
09:59:19 22530 8192000000 10116360752 10564407296 1154123168 12.348 100 32 61 1 1204174960 43813920 6237872
10:00:42 15947 8192000000 10139723040 10582466560 1159006672 12.394 100 38 76 2 1243027952 75879744 8141536
10:02:02 79548 8192000000 10134150304 10577416192 1109370144 11.926 96 24 48 1 1206743376 91148512 6224720
10:04:21 37604 8192000000 10173360416 10658689024 1153827600 12.345 100 27 54 4 1269566048 109391344 6347104
10:06:17 22719 8192000000 10143587504 10589696000 1135445072 12.173 99 50 101 1 1240792848 94290208 11057568
10:08:19 82040 8192000000 10082456544 10565869568 1141887536 12.233 100 27 54 0 1267390320 119802208 5700576
10:10:41 75790 8192000000 10143951328 10585845760 1145761776 12.270 100 50 90 2 1211583584 55890384 9931424
10:13:11 33011 8192000000 10101931216 10559623168 1125928480 12.083 99 42 84 1 1202242304 67057168 9256656
10:14:51 77167 8192000000 10091322480 10546417664 1126043264 12.084 99 12 24 0 1188913456 60527888 2342304
10:17:13 70517 8192000000 10099162272 10553872384 1139670720 12.212 100 14 28 0 1185605920 42808944 3126256
10:19:30 73933 8192000000 10080408208 10574393344 1110544800 11.938 97 33 66 0 1219618352 101064336 8009216
10:22:10 43782 8192000000 10126712000 10575323136 1126288752 12.086 99 36 71 3 1204728624 71256224 7183648
10:23:54 42981 8192000000 10131515344 10575630336 1122370768 12.049 98 40 79 1 1214949824 84229008 8350048
10:25:38 54856 8192000000 10126094720 10579279872 1124641664 12.071 99 35 70 0 1210202320 78858208 6702448
10:27:33 66476 8192000000 10069827904 10522034176 1090047024 11.743 96 23 46 0 1134446544 39690352 4709168
10:29:41 53161 8192000000 10073299904 10512470016 1101992000 11.857 97 39 78 0 1164367712 54662784 7712928
10:31:36 82500 8192000000 10051085344 10498879488 1125751328 12.081 100 22 44 0 1168209456 37606048 4852080
10:34:04 52034 8192000000 10090750352 10549886976 1113854032 11.969 98 19 37 1 1187369072 69666656 3848384
10:36:01 66571 8192000000 10127573936 10623012864 1133907680 12.158 100 14 28 1 1206988432 69918016 3162736

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:16, from 31-05-2022 10:40:04 to 31-05-2022 10:40:20.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 161 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 31-05-2022 10:40:21 to 31-05-2022 10:40:23.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          228348
MON$OLDEST_ACTIVE               230562
MON$OLDEST_SNAPSHOT             230562
MON$NEXT_TRANSACTION            230562
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-30 07:30:08.6030 GMT
MON$PAGES                       2073888
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             792
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.2.2770 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.2.2770 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.2.2770 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.2.2770 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
on disk structure version 13.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 ---
:279: 
:280: mscs-test-161.budzdorov.ru    Tue May 31 10:37:42 2022
:281:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:282: 
:283: 
:284: mscs-test-161.budzdorov.ru    Tue May 31 10:37:42 2022
:285:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:286: 
--- end of diff output ---

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

31.05.22 10:40:24. There are 3 logs in /var/tmp/logs-oltp40 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-31 10:40:26 No severe PSQL-related problems occured
31.05.22 10:40:28. End of report.