Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 08.06.2022 07:48
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 15994128 kB
MemAvailable 31339732 kB
Buffers 0 kB
Cached 15736104 kB
SwapCached 2448 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-06-08 07:46:47
DTS_END                         2022-06-08 07:46:47.6780
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/53906
TRN_ID                          221993
ATT_ID                          664
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: 8672.50 23823 1040700
customer order: creation 172.88 506 20746
customer order: refuse 14.99 446 1799
order to supplier: creation 45.50 1470 5460
order to supplier: removal 3.13 205020 376
invoice (draft): creation 44.74 3486 5369
invoice (draft): removal 47.68 1156 5721
invoice accept: apply 42.03 27364 5043
invoice accept: cancel 43.68 1452 5241
customer reserve: creation 3763.72 266 451646
customer reserve: removal 4203.16 121 504379
realization accept: apply 83.39 311 10007
realization accept: cancel 78.39 189 9407
payment from customer: creation 59.38 194 7126
payment from customer: removal 5.80 160 696
payment to supplier: creation 47.80 207 5736
payment to supplier: removal 3.41 159 409
service: total inventory turnovers 3.94 4778 473
service: total monetary turnovers 7.85 453 942
service: aggregate perf. data 1.00 14742 120
service: refresh index statistics 0.03 213984 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 08-06-2022 07:48:37 to 08-06-2022 07:48:39.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6889
TEST_TIME 2 6268
TEST_TIME 3 7232
TEST_TIME 4 7216
TEST_TIME 5 7548
TEST_TIME 6 6943
TEST_TIME 7 6605
TEST_TIME 8 6757
TEST_TIME 9 6878
TEST_TIME 10 6884
TEST_TIME 11 6944
TEST_TIME 12 7052
TEST_TIME 13 6983
TEST_TIME 14 6843
TEST_TIME 15 6717
TEST_TIME 16 6895
TEST_TIME 17 6840
TEST_TIME 18 6851
TEST_TIME 19 6817
TEST_TIME 20 7046
TEST_TIME 21 7210
TEST_TIME 22 7382
TEST_TIME 23 7417
TEST_TIME 24 7395
TEST_TIME 25 7517
TEST_TIME 26 7718
TEST_TIME 27 7743
TEST_TIME 28 7801
TEST_TIME 29 8115
TEST_TIME 30 8301
TEST_TIME 31 8493
TEST_TIME 32 8638
TEST_TIME 33 9277
TEST_TIME 34 9321
TEST_TIME 35 9424
TEST_TIME 36 9999
TEST_TIME 37 10599
TEST_TIME 38 10488
TEST_TIME 39 10418
TEST_TIME 40 10257
TEST_TIME 41 10135
TEST_TIME 42 10153
TEST_TIME 43 9930
TEST_TIME 44 9854
TEST_TIME 45 9932
TEST_TIME 46 9762
TEST_TIME 47 9670
TEST_TIME 48 9618
TEST_TIME 49 9496
TEST_TIME 50 9432
TEST_TIME 51 9338
TEST_TIME 52 9389
TEST_TIME 53 9438
TEST_TIME 54 9394
TEST_TIME 55 9323
TEST_TIME 56 9566
TEST_TIME 57 9531
TEST_TIME 58 9679
TEST_TIME 59 9614
TEST_TIME 60 9687
TEST_TIME 61 9719
TEST_TIME 62 9689
TEST_TIME 63 9731
TEST_TIME 64 9669
TEST_TIME 65 9682
TEST_TIME 66 9648
TEST_TIME 67 9530
TEST_TIME 68 9410
TEST_TIME 69 9431
TEST_TIME 70 9386
TEST_TIME 71 9350
TEST_TIME 72 9288
TEST_TIME 73 9277
TEST_TIME 74 9196
TEST_TIME 75 9136
TEST_TIME 76 9118
TEST_TIME 77 9156
TEST_TIME 78 9122
TEST_TIME 79 9145
TEST_TIME 80 9105
TEST_TIME 81 9119
TEST_TIME 82 9061
TEST_TIME 83 9148
TEST_TIME 84 9177
TEST_TIME 85 9199
TEST_TIME 86 9278
TEST_TIME 87 9221
TEST_TIME 88 9208
TEST_TIME 89 9149
TEST_TIME 90 9093
TEST_TIME 91 9060
TEST_TIME 92 8992
TEST_TIME 93 8939
TEST_TIME 94 8966
TEST_TIME 95 8983
TEST_TIME 96 8975
TEST_TIME 97 8956
TEST_TIME 98 8942
TEST_TIME 99 8935
TEST_TIME 100 8937
TEST_TIME 101 8920
TEST_TIME 102 8941
TEST_TIME 103 9018
TEST_TIME 104 9037
TEST_TIME 105 9039
TEST_TIME 106 9030
TEST_TIME 107 9032
TEST_TIME 108 8963
TEST_TIME 109 8941
TEST_TIME 110 8883
TEST_TIME 111 8842
TEST_TIME 112 8821
TEST_TIME 113 8793
TEST_TIME 114 8757
TEST_TIME 115 8756
TEST_TIME 116 8734
TEST_TIME 117 8754
TEST_TIME 118 8738
TEST_TIME 119 8712
TEST_TIME 120 8698

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 08-06-2022 07:48:41 to 08-06-2022 07:48:44.

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 1457796 1457796 0 0.00 0 17638 15 0 0
doc_list_biud 1457796 1457796 0 0.00 0 96784 48 0 0
sp_add_invoice_to_stock 5163 5043 120 2.32 60 243871 27365 0 120
sp_cancel_adding_invoice 5241 5241 0 0.00 6 96673 1452 0 0
sp_cancel_client_order 1799 1799 0 0.00 7 11670 447 0 0
sp_cancel_customer_reserve 504379 504379 0 0.00 1 31776 121 0 0
sp_cancel_pay_from_customer 696 696 0 0.00 3 9069 161 0 0
sp_cancel_pay_to_supplier 409 409 0 0.00 4 7903 159 0 0
sp_cancel_supplier_invoice 5726 5721 5 0.08 3 96842 1156 0 5
sp_cancel_supplier_order 376 376 0 0.00 15 1847673 205020 0 0
sp_cancel_write_off 9407 9407 0 0.00 2 32641 190 0 0
sp_client_order 20746 20746 0 0.00 6 19627 506 0 0
sp_customer_reserve 451646 451646 0 0.00 1 49132 267 0 0
sp_fill_shopping_cart 31572 31572 0 0.00 2 16358 92 0 0
sp_fill_shopping_cart_clo_res 451617 451617 0 0.00 0 20276 21 0 0
sp_get_clo_for_invoice 5001 5001 0 0.00 0 44475 347 0 0
sp_kill_cost_storno 15753 15753 0 0.00 0 17579 83 0 0
sp_kill_qstorno_ret_qs2qd 1024262 1024262 0 0.00 0 96782 53 0 0
sp_kill_qty_storno 541926 541926 0 0.00 0 96784 120 0 0
sp_lock_selected_doc 20849 20849 0 0.00 0 10761 8 0 0
sp_make_cost_storno 27865 27865 0 0.00 0 17371 93 0 0
sp_multiply_rows_for_pdistr 27865 27865 0 0.00 0 8832 42 0 0
sp_multiply_rows_for_qdistr 20746 20746 0 0.00 0 10476 204 0 0
sp_pay_from_customer 7126 7126 0 0.00 6 14658 194 0 0
sp_pay_to_supplier 5736 5736 0 0.00 7 15508 208 0 0
sp_payment_common 12862 12862 0 0.00 2 11323 49 0 0
sp_qd_handle_on_cancel_clo 1799 1799 0 0.00 1 11662 374 0 0
sp_qd_handle_on_invoice_upd_sts 10237 10237 0 0.00 0 40300 573 0 0
sp_qd_handle_on_reserve_upd_sts 10007 10007 0 0.00 0 21770 72 0 0
sp_reserve_write_off 10007 10007 0 0.00 8 21860 312 0 0
sp_supplier_invoice 5369 5369 0 0.00 8 97405 3486 0 0
sp_supplier_order 5460 5460 0 0.00 7 24398 1471 0 0
srv_aggregate_perf_data 120 120 0 0.00 2648 232591 14742 0 0
srv_fill_mon_cache_memory 74 74 0 0.00 836 128034 30163 0 0
srv_find_qd_qs_mism 992885 992885 0 0.00 0 11517 12 0 0
srv_make_invnt_saldo 473 473 0 0.00 68 133570 4779 0 0
srv_make_money_saldo 942 942 0 0.00 1 24800 454 0 0
srv_recalc_idx_stat 4 4 0 0.00 54920 284139 213984 0 0
t$perf-abend:sp_add_invoice_to_stock 120 120 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5043 5043 0 0.00 1 28701 1067 0 0
t$perf-norm:sp_cancel_adding_invoice 445 445 0 0.00 1 8534 555 0 0
t$perf-norm:sp_cancel_client_order 1799 1799 0 0.00 0 942 27 0 0
t$perf-norm:sp_cancel_customer_reserve 707 707 0 0.00 0 2630 33 0 0
t$perf-norm:sp_cancel_pay_from_customer 696 696 0 0.00 0 651 16 0 0
t$perf-norm:sp_cancel_pay_to_supplier 409 409 0 0.00 0 254 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 404 404 0 0.00 0 2840 51 0 0
t$perf-norm:sp_cancel_supplier_order 376 376 0 0.00 0 84370 8304 0 0
t$perf-norm:sp_cancel_write_off 1010 1010 0 0.00 0 4687 30 0 0
t$perf-norm:sp_client_order 20746 20746 0 0.00 0 5743 41 0 0
t$perf-norm:sp_customer_reserve 1017 1017 0 0.00 0 1413 15 0 0
t$perf-norm:sp_pay_from_customer 7126 7126 0 0.00 0 5586 25 0 0
t$perf-norm:sp_pay_to_supplier 5736 5736 0 0.00 0 7469 23 0 0
t$perf-norm:sp_reserve_write_off 10007 10007 0 0.00 0 22494 26 0 0
t$perf-norm:sp_supplier_invoice 5369 5369 0 0.00 0 4533 37 0 0
t$perf-norm:sp_supplier_order 5460 5460 0 0.00 0 6455 36 0 0
t$perf-norm:srv_aggregate_perf_data 120 120 0 0.00 0 2476 45 0 0
t$perf-norm:srv_fill_mon_cache_memory 74 74 0 0.00 0 1448 33 0 0
t$perf-norm:srv_make_invnt_saldo 473 473 0 0.00 0 1303 18 0 0
t$perf-norm:srv_make_money_saldo 942 942 0 0.00 0 320 5 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 4 268 117 0 0
v_add_invoice_to_stock 10232 9992 240 2.34 0 7605 29 0 240
v_all_customers 38000 38000 0 0.00 0 70 4 0 0
v_all_suppliers 29758 29758 0 0.00 0 81 5 0 0
v_all_wares 41492 41492 0 0.00 0 93 4 0 0
v_cancel_adding_invoice 890 890 0 0.00 0 568 13 0 0
v_cancel_client_order 3598 3598 0 0.00 0 671 9 0 0
v_cancel_customer_prepayment 1392 1392 0 0.00 0 749 12 0 0
v_cancel_customer_reserve 1414 1414 0 0.00 0 1826 12 0 0
v_cancel_payment_to_supplier 818 818 0 0.00 0 746 17 0 0
v_cancel_supplier_invoice 818 808 10 1.22 0 3201 30 0 10
v_cancel_supplier_order 752 752 0 0.00 0 300 11 0 0
v_cancel_write_off 2020 2020 0 0.00 0 1100 24 0 0
v_max_id_clo_ord 5460 5460 0 0.00 0 228 5 0 0
v_max_id_clo_res 1017 1017 0 0.00 0 1862 12 0 0
v_max_id_ord_sup 5366 5366 0 0.00 0 3390 7 0 0
v_max_non_paid_invoice 1683 1683 0 0.00 0 134 8 0 0
v_max_non_paid_realizn 3660 3660 0 0.00 0 794 8 0 0
v_min_id_clo_ord 5460 5460 0 0.00 0 5741 13 0 0
v_min_id_clo_res 1017 1017 0 0.00 0 712 8 0 0
v_min_id_ord_sup 5366 5366 0 0.00 0 8591 12 0 0
v_min_non_paid_invoice 5736 5736 0 0.00 0 7721 17 0 0
v_min_non_paid_realizn 7126 7126 0 0.00 0 11301 17 0 0
v_our_firm 10424 10424 0 0.00 0 85 5 0 0
v_reserve_write_off 20014 20014 0 0.00 0 7688 12 0 0
x_lock_depdocs_on_canc_invoice 10558 10558 0 0.00 0 34706 149 0 0
x_lock_depdocs_on_canc_sup_ord 376 376 0 0.00 0 11692 441 0 0
x_make_qstorno_1000_1200 5460 5460 0 0.00 2 24389 1275 0 0
x_make_qstorno_1200_2000 5369 5369 0 0.00 3 97306 3237 0 0
x_make_qstorno_2100_3300 451646 451646 0 0.00 0 41522 232 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 08-06-2022 07:48:45 to 08-06-2022 07:48:49.

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
05:16:51 23 8192000000 8803485712 8816414720 7058048 0.086 4 1 2 0 7160992 67168 35776
05:17:52 26195 8192000000 9716439120 10013761536 794027952 8.836 100 83 166 0 822395792 7696064 20671776
05:19:21 24097 8192000000 9760902992 10068574208 834871616 9.248 100 91 182 0 869061488 12028304 22161568
05:20:52 18177 8192000000 9807991520 10125766656 871140400 9.611 100 85 171 0 910306320 19674208 19491712
05:22:16 10796 8192000000 9861646848 10195529728 914894816 10.046 100 75 150 0 975806336 44756032 16155488
05:23:31 6329 8192000000 9903028448 10251071488 965816000 10.546 100 73 146 0 1026694384 45871696 15006688
05:24:41 1774 8192000000 9985713712 10339356672 1004621840 10.923 100 96 189 0 1103692688 79806288 19264560
05:25:45 1521 8192000000 10005041456 10368409600 1030504720 11.173 100 94 178 0 1126014256 77821728 17687808
05:26:49 1132 8192000000 10012710864 10381651968 1052278000 11.383 100 94 183 1 1133328928 62126496 18924432
05:27:51 2371 8192000000 10028112336 10408861696 1066440080 11.518 100 89 165 1 1152009728 68627600 16942048
05:28:55 1315 8192000000 10063778592 10444623872 1070138832 11.553 100 91 174 1 1183631392 96120128 17372432
05:29:58 1051 8192000000 10040533760 10419412992 1076350880 11.613 100 97 181 1 1160648128 65039280 19257968
05:31:01 1077 8192000000 10074092592 10461204480 1082049648 11.667 100 86 172 1 1194009744 94860272 17099824
05:32:04 1155 8192000000 10059712000 10446389248 1087945504 11.723 100 96 188 0 1182992112 75622816 19423792
05:33:07 1523 8192000000 10070926912 10464342016 1096060656 11.800 100 78 152 1 1189167872 77924432 15182784
05:34:09 1192 8192000000 10102596064 10495778816 1104775200 11.883 100 98 186 4 1224325696 100906880 18643616
05:35:11 1088 8192000000 10061713200 10454994944 1110610464 11.938 100 83 157 1 1182380912 55016560 16753888
05:36:13 1074 8192000000 10086295392 10480775168 1109760608 11.930 100 91 181 0 1208516032 79635984 19119440
05:37:15 1880 8192000000 10071637952 10464096256 1106788880 11.902 100 95 182 1 1194027776 69989312 17249584
05:38:18 1137 8192000000 10060882208 10448584704 1088958176 11.733 100 92 178 0 1184156336 77114096 18084064
05:39:20 2857 8192000000 10042597184 10438897664 1084795168 11.693 100 68 134 2 1163387648 65451840 13140640
05:40:23 1370 8192000000 10064530736 10451415040 1090724528 11.750 100 83 156 0 1184796352 78187808 15884016
05:41:25 2001 8192000000 10014495872 10393112576 1056876752 11.427 99 88 168 2 1143262224 68898304 17487168
05:42:28 1827 8192000000 9994880832 10376298496 1034630128 11.213 99 72 135 0 1113617648 65785440 13202080
05:43:31 1007 8192000000 10008088144 10388803584 1042893200 11.292 100 91 174 0 1130275456 70101536 17280720
05:44:33 1114 8192000000 10037830496 10414395392 1054581952 11.405 100 95 185 0 1159081520 84446928 20052640
05:45:35 11512 8192000000 10013044608 10402988032 1061923536 11.475 100 60 116 0 1134053088 60305200 11824352
05:46:48 1546 8192000000 10002438768 10378960896 1052009536 11.380 100 76 138 1 1124905472 59336368 13559568
05:47:58 29573 8192000000 10023058880 10408603648 1071094704 11.563 100 63 110 3 1140803776 58817280 10891792
05:49:34 1495 8192000000 10092030544 10480349184 1101519632 11.852 100 93 179 0 1211012640 91332368 18160640
05:50:39 1133 8192000000 10102254048 10486996992 1104466096 11.880 100 96 180 1 1221617280 97757072 19394112
05:51:47 2686 8192000000 10099704304 10497110016 1115988752 11.989 100 74 136 0 1217930912 88600976 13341184
05:52:54 2578 8192000000 10118529360 10515013632 1118482800 12.013 99 80 153 1 1240246544 104883952 16879792
05:54:00 1112 8192000000 10185219216 10578915328 1134784560 12.166 100 92 177 0 1299347248 144784176 19778512
05:55:06 7303 8192000000 10173531408 10591072256 1142616080 12.240 100 68 129 2 1294636864 138185712 13835072
05:56:20 841 8192000000 10202018224 10605043712 1159131536 12.395 100 91 179 0 1320723088 140313952 21277600
05:57:25 1380 8192000000 10232102352 10635329536 1158999840 12.394 100 83 155 0 1347568000 170029920 18538240
05:58:30 976 8192000000 10265890064 10667143168 1173965968 12.534 100 97 192 1 1378374480 183316336 21092176
05:59:34 1037 8192000000 10304603136 10706513920 1182182064 12.611 100 89 176 0 1416552352 214176400 20193888
06:00:43 1008 8192000000 10322314256 10727886848 1186540448 12.651 100 93 177 5 1435528464 228200672 20787344
06:01:49 998 8192000000 10364000016 10782314496 1200689440 12.783 100 84 159 1 1475159552 254530944 19939168
06:02:54 1745 8192000000 10395542960 10807443456 1208447456 12.855 100 89 174 1 1508024208 278010800 21565952
06:03:58 999 8192000000 10436155712 10844991488 1206824192 12.840 100 84 166 0 1546360736 320438544 19098000
06:05:02 901 8192000000 10446018160 10862972928 1200373408 12.780 100 95 184 0 1566370992 343688928 22308656
06:06:06 1375 8192000000 10461125920 10892906496 1181040480 12.600 100 94 182 1 1570381024 366897760 22442784
06:07:11 1098 8192000000 10497703232 10912391168 1196358912 12.743 100 96 188 1 1600377248 382359632 21658704
06:08:17 1600 8192000000 10494092016 10920611840 1194921520 12.729 100 98 191 2 1600771232 381672848 24176864
06:09:22 927 8192000000 10499266272 10899386368 1162382656 12.426 99 90 177 1 1602583136 418291008 21909472
06:10:26 826 8192000000 10536214336 10947825664 1171412912 12.510 99 96 184 0 1640344000 446143632 22787456
06:11:30 2288 8192000000 10541073408 10999508992 1189519136 12.679 100 84 162 0 1646039328 437115600 19404592
06:12:36 1232 8192000000 10583512032 10992103424 1190008256 12.683 100 91 179 1 1684414192 473385056 21020880
06:13:42 2456 8192000000 10615435200 11054108672 1185452064 12.641 100 73 144 0 1717194576 513165648 18576864
06:14:51 1851 8192000000 10612711280 11075551232 1193842640 12.719 100 81 159 3 1717780800 503932832 20005328
06:15:57 4801 8192000000 10587663264 11072798720 1199905472 12.775 100 66 127 2 1688070496 472354560 15810464
06:17:08 1544 8192000000 10557993872 10992066560 1181228336 12.602 100 87 160 1 1656548288 456141824 19178128
06:18:12 1439 8192000000 10515624032 10994360320 1178535648 12.577 100 81 152 2 1613524608 417192176 17796784
06:19:16 7022 8192000000 10433591520 10890301440 1165357520 12.453 100 47 94 0 1542240288 364661168 12221600
06:20:32 12152 8192000000 10456551392 10921824256 1173071904 12.526 100 40 80 0 1552502256 368881008 10549344
06:21:47 37161 8192000000 10324701568 10865352704 1144463760 12.258 100 18 36 2 1470736000 321013648 5258592
06:23:29 51403 8192000000 10077057904 10502909952 1136138128 12.179 99 33 65 1 1170677040 26686608 7852304
06:25:26 61520 8192000000 10098184352 10545299456 1122961776 12.055 98 30 59 1 1159541792 30689216 5890800
06:27:28 86338 8192000000 10107061040 10589368320 1130713264 12.128 99 22 45 0 1216225520 79977568 5534688
06:29:58 69808 8192000000 10141724992 10601816064 1126341856 12.087 99 29 58 1 1248595856 115369216 6884784
06:32:37 29278 8192000000 10113537648 10563141632 1143179440 12.245 100 29 58 3 1208357968 59491968 5686560
06:34:08 41151 8192000000 10147424576 10597199872 1148999104 12.300 100 29 58 1 1246583232 91031552 6552576
06:36:10 6779 8192000000 10218279584 10655064064 1154319456 12.350 100 57 106 1 1320073904 154625328 11129120
06:37:25 48407 8192000000 10216659056 10698244096 1142519680 12.239 100 29 57 2 1318044720 168152720 7372320
06:41:16 44630 8192000000 10213345584 10683285504 1134597472 12.165 99 27 54 1 1312527456 170960816 6969168
06:43:02 42717 8192000000 10137667616 10586718208 1126018592 12.084 99 33 61 1 1223698160 90884832 6794736
06:44:46 20473 8192000000 10104445696 10553544704 1137418304 12.191 99 44 85 1 1187512016 41394880 8698832
06:46:18 102570 8192000000 10109594528 10602196992 1086352512 11.708 95 17 34 2 1193150176 103188912 3608752
06:49:02 88348 8192000000 10059342352 10484998144 1101851008 11.855 97 30 61 0 1153994992 46129280 6014704
06:51:35 14301 8192000000 10091654736 10516684800 1111074272 11.943 99 51 102 0 1166032848 44709664 10248912
06:52:52 84084 8192000000 10112034192 10557247488 1131809280 12.138 100 38 76 2 1198185008 58242384 8133344
06:55:34 22994 8192000000 10092745904 10568015872 1130323840 12.124 100 28 56 2 1201573616 64452912 6796864
06:57:24 57518 8192000000 10076424976 10547720192 1128207216 12.104 100 16 31 1 1183031360 51318304 3505840
06:59:38 49153 8192000000 10084461312 10538692608 1120215184 12.029 98 16 32 0 1178463936 54396592 3852160
07:01:28 46949 8192000000 10127429360 10584862720 1139798800 12.214 100 27 52 0 1225376032 79749808 5827424
07:03:21 70818 8192000000 10105203264 10574667776 1131986368 12.140 99 10 20 0 1196171840 61751504 2433968
07:05:32 22154 8192000000 10084095664 10523267072 1133032176 12.150 99 20 40 0 1164034048 26673376 4328496
07:06:59 52615 8192000000 10087989968 10543861760 1114596256 11.976 98 26 52 2 1169486000 49774608 5115136
07:08:56 68853 8192000000 10114675056 10549284864 1105781232 11.892 97 30 60 1 1181136816 68327088 7028496
07:11:12 42706 8192000000 10128335680 10589143040 1136504128 12.183 100 28 54 3 1245119936 102087184 6528624
07:12:56 19900 8192000000 10086213296 10506612736 1121890304 12.045 98 54 109 0 1162549952 29005872 11653776
07:14:17 15258 8192000000 10123876688 10547523584 1126031424 12.084 99 64 128 0 1212670720 73998144 12641152
07:15:39 56982 8192000000 10043753760 10491809792 1104148240 11.877 98 38 68 1 1145271232 34638656 6484336
07:17:36 39760 8192000000 10056810336 10502156288 1118295952 12.011 99 8 16 0 1148377200 28649184 1432064
07:19:20 48541 8192000000 10066479552 10551148544 1108125168 11.915 98 10 20 0 1163598128 53526928 1946032
07:21:10 75969 8192000000 10020198192 10471985152 1048454320 11.346 93 22 41 1 1091140096 38763232 3922544
07:23:27 16504 8192000000 10089978608 10522263552 1122016336 12.046 100 38 76 2 1171116336 41527216 7572784
07:24:50 46981 8192000000 10132568768 10560704512 1141934032 12.234 100 28 56 1 1208446832 59788896 6723904
07:26:44 58338 8192000000 10159836128 10614517760 1130686944 12.128 99 23 46 1 1257670128 121957728 5025456
07:28:50 68090 8192000000 10107352512 10576113664 1129910176 12.121 99 21 42 1 1212555776 78320160 4325440
07:31:36 18746 8192000000 10111105248 10528354304 1128927728 12.111 100 56 112 2 1189099488 48726512 11445248
07:32:57 128031 8192000000 10062462688 10493063168 1107498448 11.909 98 32 64 0 1160738496 45784432 7455616
07:36:06 76687 8192000000 10072826752 10537013248 1127637408 12.099 99 11 22 0 1165338704 34927344 2773952
07:38:50 99026 8192000000 10097920416 10545483776 1069421120 11.547 94 7 12 1 1121202352 50278336 1502896
07:41:34 24806 8192000000 10129736784 10579030016 1140931968 12.224 100 21 42 0 1230676288 84769280 4975040
07:43:04 27059 8192000000 10155572304 10586832896 1102740224 11.864 97 35 70 1 1218862480 107980240 8142016
07:44:35 32150 8192000000 10167494416 10604523520 1127028608 12.093 99 35 70 2 1261824736 126363168 8432960
07:46:08 18347 8192000000 10239460480 10683580416 1136198752 12.180 99 51 102 0 1316572272 168728064 11645456

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:16, from 08-06-2022 07:48:51 to 08-06-2022 07:49:07.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 120 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 08-06-2022 07:49:08 to 08-06-2022 07:49:10.

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          212051
MON$OLDEST_ACTIVE               222301
MON$OLDEST_SNAPSHOT             222301
MON$NEXT_TRANSACTION            222301
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                       2078048
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             780
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.2.2774 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.2.2774 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.2.2774 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.2.2774 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 ---
:6: 
:7: mscs-test-161.budzdorov.ru    Wed Jun  8 07:47:17 2022
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:9: 
--- end of diff output ---

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

08.06.22 07:49:11. 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-06-08 07:49:13 No severe PSQL-related problems occured
08.06.22 07:49:15. End of report.