Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 14.01.2023 13: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 15055284 kB
MemAvailable 30423772 kB
Buffers 0 kB
Cached 16674488 kB
SwapCached 4152 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.3
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 2023-01-14 13:37:24
DTS_END                         2023-01-14 13:37:24.8120
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/57508
TRN_ID                          217473
ATT_ID                          601
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: 8577.83 21163 1029339
customer order: creation 167.43 521 20091
customer order: refuse 14.21 399 1705
order to supplier: creation 44.71 1343 5365
order to supplier: removal 3.12 161430 374
invoice (draft): creation 44.72 3368 5366
invoice (draft): removal 47.67 900 5720
invoice accept: apply 39.55 25559 4746
invoice accept: cancel 43.24 1113 5189
customer reserve: creation 3665.91 242 439909
customer reserve: removal 4219.77 94 506373
realization accept: apply 81.40 274 9768
realization accept: cancel 82.33 161 9880
payment from customer: creation 56.93 188 6831
payment from customer: removal 5.28 141 634
payment to supplier: creation 46.82 211 5618
payment to supplier: removal 3.10 114 372
service: total inventory turnovers 3.71 4298 445
service: total monetary turnovers 7.03 315 843
service: aggregate perf. data 0.88 14276 105
service: refresh index statistics 0.04 208316 5

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 14-01-2023 13:39:26 to 14-01-2023 13:39:29.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4508
TEST_TIME 2 5145
TEST_TIME 3 4747
TEST_TIME 4 4947
TEST_TIME 5 5199
TEST_TIME 6 5227
TEST_TIME 7 5640
TEST_TIME 8 6316
TEST_TIME 9 6622
TEST_TIME 10 6589
TEST_TIME 11 6446
TEST_TIME 12 6603
TEST_TIME 13 6896
TEST_TIME 14 7070
TEST_TIME 15 7262
TEST_TIME 16 7582
TEST_TIME 17 7658
TEST_TIME 18 7617
TEST_TIME 19 7970
TEST_TIME 20 8045
TEST_TIME 21 8216
TEST_TIME 22 8871
TEST_TIME 23 8816
TEST_TIME 24 9154
TEST_TIME 25 9213
TEST_TIME 26 9399
TEST_TIME 27 9448
TEST_TIME 28 9530
TEST_TIME 29 10107
TEST_TIME 30 9976
TEST_TIME 31 10156
TEST_TIME 32 10350
TEST_TIME 33 10373
TEST_TIME 34 10394
TEST_TIME 35 10133
TEST_TIME 36 10251
TEST_TIME 37 10452
TEST_TIME 38 10469
TEST_TIME 39 10329
TEST_TIME 40 10320
TEST_TIME 41 10142
TEST_TIME 42 9959
TEST_TIME 43 9940
TEST_TIME 44 9933
TEST_TIME 45 9970
TEST_TIME 46 9821
TEST_TIME 47 9746
TEST_TIME 48 9650
TEST_TIME 49 9576
TEST_TIME 50 9522
TEST_TIME 51 9496
TEST_TIME 52 9522
TEST_TIME 53 9474
TEST_TIME 54 9359
TEST_TIME 55 9332
TEST_TIME 56 9180
TEST_TIME 57 9205
TEST_TIME 58 9112
TEST_TIME 59 9118
TEST_TIME 60 8992
TEST_TIME 61 8942
TEST_TIME 62 8919
TEST_TIME 63 8852
TEST_TIME 64 8869
TEST_TIME 65 8841
TEST_TIME 66 8834
TEST_TIME 67 8872
TEST_TIME 68 8898
TEST_TIME 69 8866
TEST_TIME 70 8895
TEST_TIME 71 8932
TEST_TIME 72 8922
TEST_TIME 73 8994
TEST_TIME 74 9013
TEST_TIME 75 8985
TEST_TIME 76 8997
TEST_TIME 77 9006
TEST_TIME 78 8896
TEST_TIME 79 8881
TEST_TIME 80 8828
TEST_TIME 81 8794
TEST_TIME 82 8803
TEST_TIME 83 8792
TEST_TIME 84 8727
TEST_TIME 85 8701
TEST_TIME 86 8712
TEST_TIME 87 8729
TEST_TIME 88 8678
TEST_TIME 89 8700
TEST_TIME 90 8662
TEST_TIME 91 8687
TEST_TIME 92 8740
TEST_TIME 93 8791
TEST_TIME 94 8803
TEST_TIME 95 8795
TEST_TIME 96 8813
TEST_TIME 97 8812
TEST_TIME 98 8823
TEST_TIME 99 8795
TEST_TIME 100 8756
TEST_TIME 101 8738
TEST_TIME 102 8747
TEST_TIME 103 8719
TEST_TIME 104 8685
TEST_TIME 105 8645
TEST_TIME 106 8613
TEST_TIME 107 8609
TEST_TIME 108 8580
TEST_TIME 109 8551
TEST_TIME 110 8558
TEST_TIME 111 8563
TEST_TIME 112 8565
TEST_TIME 113 8609
TEST_TIME 114 8655
TEST_TIME 115 8633
TEST_TIME 116 8698
TEST_TIME 117 8688
TEST_TIME 118 8707
TEST_TIME 119 8667
TEST_TIME 120 8598

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 14-01-2023 13:39:30 to 14-01-2023 13:39:33.

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 1435665 1435665 0 0.00 0 30132 13 0 0
doc_list_biud 1435659 1435659 0 0.00 0 36790 39 0 0
sp_add_invoice_to_stock 4848 4746 102 2.10 35 211222 25560 0 102
sp_cancel_adding_invoice 5189 5189 0 0.00 5 86582 1113 0 0
sp_cancel_client_order 1705 1705 0 0.00 5 10033 400 0 0
sp_cancel_customer_reserve 506373 506373 0 0.00 1 25146 95 0 0
sp_cancel_pay_from_customer 634 634 0 0.00 4 8114 142 0 0
sp_cancel_pay_to_supplier 372 372 0 0.00 4 3273 115 0 0
sp_cancel_supplier_invoice 5729 5720 9 0.15 3 36802 901 0 9
sp_cancel_supplier_order 374 374 0 0.00 9 1214135 161431 0 0
sp_cancel_write_off 9880 9880 0 0.00 2 11134 162 0 0
sp_client_order 20091 20091 0 0.00 5 33938 521 0 0
sp_customer_reserve 439909 439909 0 0.00 0 62524 243 0 0
sp_fill_shopping_cart 30818 30818 0 0.00 1 22119 90 0 0
sp_fill_shopping_cart_clo_res 439886 439886 0 0.00 0 15319 19 0 0
sp_get_clo_for_invoice 4717 4717 0 0.00 0 48360 389 0 0
sp_kill_cost_storno 16075 16075 0 0.00 0 15946 71 0 0
sp_kill_qstorno_ret_qs2qd 1028720 1028720 0 0.00 0 36789 42 0 0
sp_kill_qty_storno 543725 543725 0 0.00 0 36790 95 0 0
sp_lock_selected_doc 19949 19949 0 0.00 0 11191 8 0 0
sp_make_cost_storno 26934 26934 0 0.00 0 17584 83 0 0
sp_multiply_rows_for_pdistr 26933 26933 0 0.00 0 26052 39 0 0
sp_multiply_rows_for_qdistr 20091 20091 0 0.00 0 33879 198 0 0
sp_pay_from_customer 6831 6831 0 0.00 5 30138 188 0 0
sp_pay_to_supplier 5618 5618 0 0.00 7 19253 211 0 0
sp_payment_common 12448 12448 0 0.00 2 21087 53 0 0
sp_qd_handle_on_cancel_clo 1705 1705 0 0.00 0 10022 328 0 0
sp_qd_handle_on_invoice_upd_sts 9905 9905 0 0.00 1 22167 493 0 0
sp_qd_handle_on_reserve_upd_sts 9768 9768 0 0.00 0 23789 64 0 0
sp_reserve_write_off 9768 9768 0 0.00 8 23849 275 0 0
sp_supplier_invoice 5366 5366 0 0.00 8 94517 3369 0 0
sp_supplier_order 5365 5365 0 0.00 8 36826 1344 0 0
srv_aggregate_perf_data 105 105 0 0.00 2595 155995 14277 0 0
srv_fill_mon_cache_memory 69 69 0 0.00 700 145197 36189 0 0
srv_find_qd_qs_mism 982974 982974 0 0.00 0 18239 9 0 0
srv_make_invnt_saldo 445 445 0 0.00 61 112746 4298 0 0
srv_make_money_saldo 843 843 0 0.00 1 9040 315 0 0
srv_recalc_idx_stat 5 5 0 0.00 80632 367470 208317 0 0
t$perf-abend:sp_add_invoice_to_stock 102 102 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 9 9 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4750 4750 0 0.00 1 21742 933 0 0
t$perf-norm:sp_cancel_adding_invoice 387 387 0 0.00 1 8538 433 0 0
t$perf-norm:sp_cancel_client_order 1705 1705 0 0.00 0 2853 24 0 0
t$perf-norm:sp_cancel_customer_reserve 659 659 0 0.00 0 14129 46 0 0
t$perf-norm:sp_cancel_pay_from_customer 634 634 0 0.00 0 4620 18 0 0
t$perf-norm:sp_cancel_pay_to_supplier 372 372 0 0.00 0 5915 38 0 0
t$perf-norm:sp_cancel_supplier_invoice 353 353 0 0.00 0 3789 48 0 0
t$perf-norm:sp_cancel_supplier_order 374 374 0 0.00 0 87250 7168 0 0
t$perf-norm:sp_cancel_write_off 983 983 0 0.00 0 1571 16 0 0
t$perf-norm:sp_client_order 20091 20091 0 0.00 0 11721 38 0 0
t$perf-norm:sp_customer_reserve 957 957 0 0.00 0 2887 17 0 0
t$perf-norm:sp_pay_from_customer 6831 6831 0 0.00 0 9293 20 0 0
t$perf-norm:sp_pay_to_supplier 5618 5618 0 0.00 0 16708 28 0 0
t$perf-norm:sp_reserve_write_off 9768 9768 0 0.00 0 7825 25 0 0
t$perf-norm:sp_supplier_invoice 5366 5366 0 0.00 0 4055 35 0 0
t$perf-norm:sp_supplier_order 5365 5365 0 0.00 0 17124 33 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 252 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 69 69 0 0.00 0 210 10 0 0
t$perf-norm:srv_make_invnt_saldo 445 445 0 0.00 0 809 17 0 0
t$perf-norm:srv_make_money_saldo 843 843 0 0.00 0 2163 8 0 0
t$perf-norm:srv_recalc_idx_stat 5 5 0 0.00 2 285 115 0 0
v_add_invoice_to_stock 9634 9430 204 2.11 0 8832 25 0 204
v_all_customers 36950 36950 0 0.00 0 196 4 0 0
v_all_suppliers 29732 29732 0 0.00 0 199 4 0 0
v_all_wares 40176 40176 0 0.00 0 189 4 0 0
v_cancel_adding_invoice 774 774 0 0.00 0 305 13 0 0
v_cancel_client_order 3410 3410 0 0.00 0 2031 10 0 0
v_cancel_customer_prepayment 1268 1268 0 0.00 0 2093 11 0 0
v_cancel_customer_reserve 1318 1318 0 0.00 1 2068 11 0 0
v_cancel_payment_to_supplier 744 744 0 0.00 0 907 13 0 0
v_cancel_supplier_invoice 724 706 18 2.48 0 1682 27 0 18
v_cancel_supplier_order 748 748 0 0.00 0 307 12 0 0
v_cancel_write_off 1966 1966 0 0.00 0 11033 29 0 0
v_max_id_clo_ord 5365 5365 0 0.00 0 76 5 0 0
v_max_id_clo_res 957 957 0 0.00 0 1331 15 0 0
v_max_id_ord_sup 5363 5363 0 0.00 0 4365 9 0 0
v_max_non_paid_invoice 1479 1479 0 0.00 0 630 8 0 0
v_max_non_paid_realizn 3466 3466 0 0.00 0 2652 9 0 0
v_min_id_clo_ord 5365 5365 0 0.00 0 3790 9 0 0
v_min_id_clo_res 957 957 0 0.00 0 992 10 0 0
v_min_id_ord_sup 5362 5362 0 0.00 0 5753 14 0 0
v_min_non_paid_invoice 5618 5618 0 0.00 0 17876 25 0 0
v_min_non_paid_realizn 6829 6829 0 0.00 0 21080 27 0 0
v_our_firm 9954 9954 0 0.00 0 188 4 0 0
v_reserve_write_off 19534 19534 0 0.00 0 3494 10 0 0
x_lock_depdocs_on_canc_invoice 10556 10556 0 0.00 0 12808 120 0 0
x_lock_depdocs_on_canc_sup_ord 374 374 0 0.00 0 4451 358 0 0
x_make_qstorno_1000_1200 5365 5365 0 0.00 3 36816 1179 0 0
x_make_qstorno_1200_2000 5366 5366 0 0.00 4 94052 3101 0 0
x_make_qstorno_2100_3300 439909 439909 0 0.00 0 62520 212 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 14-01-2023 13:39:34 to 14-01-2023 13:39:39.

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
11:07:28 2 8192000000 8796669344 8807108608 3189136 0.038 1 1 2 0 3286752 61840 35776
11:08:30 27097 8192000000 9730124928 10030518272 800281648 8.899 100 89 178 0 829228496 7647728 21299120
11:10:07 11361 8192000000 9761702992 10069876736 837482560 9.274 100 89 178 0 872278368 13851600 20944208
11:11:30 11332 8192000000 9807694256 10127409152 869302960 9.593 100 88 176 0 916738832 27419792 20016080
11:12:48 2878 8192000000 9863763008 10197188608 916512512 10.062 100 83 166 0 983800208 48253216 19034480
11:13:53 6105 8192000000 9916276304 10262847488 955914960 10.449 100 81 160 0 1033999248 60640768 17443520
11:15:04 2888 8192000000 9956387840 10308530176 988271824 10.765 100 83 156 1 1079860960 75481824 16107312
11:16:10 3796 8192000000 10000015840 10369282048 1012686976 11.001 100 80 160 1 1112833344 84266672 15879696
11:17:16 781 8192000000 10014394448 10380959744 1039372080 11.259 100 84 164 3 1128725088 73638000 15715008
11:18:19 1318 8192000000 10026307696 10397409280 1053531728 11.395 100 90 173 2 1145113424 74548576 17033120
11:19:21 1075 8192000000 10028658736 10402795520 1059166272 11.449 100 93 180 1 1149783024 72601392 18015360
11:20:23 1053 8192000000 10023564160 10403860480 1070147680 11.553 100 92 181 1 1151876672 63079856 18649136
11:21:25 1147 8192000000 10052123920 10434633728 1080774032 11.655 100 96 183 0 1175268992 76269056 18225904
11:22:28 1326 8192000000 10048359168 10433327104 1084784960 11.693 100 93 175 0 1166934688 65021168 17128560
11:23:30 4199 8192000000 10038597328 10419494912 1092076912 11.762 100 87 151 1 1156393696 49824656 14492128
11:24:35 1283 8192000000 10065955600 10451980288 1099235248 11.830 100 96 181 1 1188257392 70240064 18782080
11:25:37 1030 8192000000 10074643200 10464727040 1099290656 11.831 100 99 188 1 1195501360 78066064 18144640
11:26:39 1274 8192000000 10074431488 10466447360 1109028064 11.923 100 97 188 1 1194964688 67068512 18868112
11:27:42 1003 8192000000 10091488640 10483765248 1106925440 11.903 100 98 188 1 1215599552 87870464 20803648
11:28:44 1086 8192000000 10073547472 10457763840 1094091280 11.782 100 97 192 1 1194501760 80853936 19556544
11:29:45 969 8192000000 10037401232 10427400192 1087253648 11.717 100 84 155 0 1159519840 56451936 15814256
11:30:47 1166 8192000000 10024428912 10407563264 1074596448 11.596 99 92 180 1 1144703712 51438480 18668784
11:31:49 952 8192000000 10021142048 10404249600 1066447888 11.518 100 87 169 0 1145742688 62532576 16762224
11:32:51 1169 8192000000 10018120672 10398666752 1045794112 11.320 99 77 151 2 1140698112 80345872 14558128
11:33:54 1369 8192000000 10026609104 10409443328 1053836864 11.397 100 89 168 2 1147804832 76421600 17546368
11:34:56 1179 8192000000 9984049232 10358071296 1034646848 11.213 100 92 177 5 1102764944 49971008 18147088
11:35:58 928 8192000000 10008751600 10384400384 1046248960 11.325 100 95 184 1 1130764000 63824288 20690752
11:37:00 1843 8192000000 10030737936 10411905024 1037660816 11.242 99 73 145 1 1143472544 91750112 14061616
11:38:11 25338 8192000000 10016424224 10409201664 1071402240 11.565 100 57 109 1 1126486752 44567152 10517360
11:39:41 4893 8192000000 10040371472 10430717952 1082226080 11.669 100 72 135 0 1164667792 69008336 13433376
11:40:55 5559 8192000000 10078418752 10475216896 1104721728 11.882 100 70 133 1 1197342480 78822304 13798448
11:42:04 1013 8192000000 10125387456 10515341312 1114279408 11.973 100 94 173 2 1239712896 107247984 18185504
11:43:09 4253 8192000000 10161973728 10553380864 1122364688 12.049 100 78 152 0 1274198096 135605008 16228400
11:44:17 857 8192000000 10190182304 10586247168 1130627152 12.127 100 97 187 2 1311247280 160842880 19777248
11:45:20 1391 8192000000 10198569552 10611625984 1142318976 12.237 100 93 178 0 1318033952 156074400 19640576
11:46:23 1951 8192000000 10171383024 10573918208 1143566656 12.249 100 74 142 2 1289257968 129673504 16017808
11:47:30 1368 8192000000 10227710448 10632351744 1160657728 12.409 100 94 180 3 1340072256 158706560 20707968
11:48:36 1880 8192000000 10263525664 10667085824 1167716576 12.475 100 88 161 0 1378059616 192373376 17969664
11:49:42 1212 8192000000 10280176528 10699370496 1179173776 12.582 100 88 162 1 1387315936 190120368 18021792
11:50:46 1565 8192000000 10309822848 10721239040 1181718256 12.606 100 92 184 0 1417532512 214457056 21357200
11:51:52 1243 8192000000 10312198688 10737942528 1182806896 12.616 100 88 175 0 1428376896 225400048 20169952
11:52:56 867 8192000000 10358693088 10778021888 1185369408 12.640 100 96 182 0 1469893936 263026320 21498208
11:53:59 887 8192000000 10374469280 10787852288 1188107088 12.666 100 92 178 0 1481732032 274161600 19463344
11:55:05 1468 8192000000 10384818672 10800017408 1188550048 12.670 100 91 176 1 1497079392 287103840 21425504
11:56:10 903 8192000000 10413416880 10854076416 1182592000 12.614 100 97 186 1 1518283696 314160256 21531440
11:57:13 851 8192000000 10402170192 10835353600 1175353136 12.547 99 96 190 2 1507905104 309240592 23311376
11:58:16 694 8192000000 10407238720 10882383872 1179870416 12.589 100 89 176 1 1510944608 310551312 20522880
11:59:18 14773 8192000000 10371358992 10795978752 1171354976 12.509 99 46 85 1 1476362240 294046368 10960896
12:00:51 2968 8192000000 10352183968 10796318720 1166396784 12.463 99 70 133 2 1456325232 272277504 17650944
12:01:56 22958 8192000000 10347325104 10794041344 1173143232 12.526 100 37 74 0 1461784240 279533840 9107168
12:03:20 17278 8192000000 10370203616 10813530112 1152781792 12.336 99 42 84 1 1448670512 286020736 9867984
12:05:08 22537 8192000000 10292294400 10802700288 1125835904 12.082 99 32 62 0 1421137056 287293120 8008032
12:06:36 11633 8192000000 10273289152 10749775872 1145896720 12.271 100 50 96 0 1360547616 203636512 11014384
12:07:51 15791 8192000000 10301946880 10734288896 1153420640 12.342 99 48 95 1 1396444880 232677104 10347136
12:09:29 14741 8192000000 10224236592 10729897984 1153505104 12.342 100 34 64 1 1369818992 208854896 7458992
12:10:53 39483 8192000000 10242470816 10723479552 1161313600 12.416 100 35 71 0 1390454240 220673120 8467520
12:12:53 41218 8192000000 10246117568 10727968768 1142557984 12.240 99 36 72 0 1334762768 183787776 8417008
12:15:29 69022 8192000000 10123009856 10597535744 1100302576 11.841 97 20 41 0 1209153328 104374592 4476160
12:17:47 47175 8192000000 10102433296 10531086336 1113714976 11.968 98 43 81 3 1185247552 61884544 9648032
12:19:43 101909 8192000000 10145312624 10591350784 1111640576 11.948 98 41 80 0 1206536160 85749264 9146320
12:22:26 72608 8192000000 10068218256 10515570688 1106764544 11.902 98 21 41 0 1164433200 53580512 4088144
12:24:44 763 8192000000 10076556464 10487341056 1114604768 11.976 99 95 182 1 1180468672 42491040 23372864
12:25:46 33614 8192000000 10104347856 10550849536 1110811088 11.940 99 36 69 0 1219075888 100971296 7293504
12:27:33 47829 8192000000 10161496832 10622533632 1124357472 12.068 100 13 26 0 1281381840 154091888 2932480
12:29:42 25042 8192000000 10107680480 10601287680 1132593296 12.146 100 8 17 0 1215806112 81311760 1901056
12:31:07 54514 8192000000 10077125952 10536882176 1120221248 12.029 99 12 23 1 1178263136 55884448 2157440
12:33:09 77566 8192000000 10075901328 10555695104 1137497472 12.192 100 44 83 0 1184458304 37659520 9301312
12:35:33 88338 8192000000 10047253824 10534289408 1111491792 11.947 98 13 24 0 1177422720 63415632 2515296
12:39:06 93207 8192000000 10068791952 10581594112 1111446864 11.946 98 8 16 0 1145198272 32364784 1386624
12:41:39 50795 8192000000 10085645392 10546323456 1114551280 11.975 97 11 22 0 1173004112 55865680 2587152
12:44:06 99926 8192000000 10105089360 10584207360 1121488560 12.041 98 19 38 0 1198931616 73211792 4231264
12:46:47 37523 8192000000 10128138000 10580099072 1146978784 12.281 100 30 60 0 1236235168 83139344 6117040
12:48:34 27410 8192000000 10092487888 10539941888 1149053472 12.301 100 41 80 1 1192268880 35393888 7821520
12:50:10 59451 8192000000 10083644624 10558025728 1128958320 12.112 98 27 54 0 1179253328 45042016 5252992
12:52:09 27327 8192000000 10078687328 10509475840 1146869680 12.280 100 49 86 2 1165904560 9677024 9357856
12:53:37 39615 8192000000 10120372624 10569355264 1112095184 11.952 97 29 58 0 1185968096 67867856 6005056
12:55:17 84777 8192000000 10064327888 10534027264 1124054624 12.065 99 17 32 0 1176992800 49253648 3684528
12:57:42 17764 8192000000 10088259952 10534707200 1114631600 11.976 98 44 86 0 1187806384 63889824 9284960
12:59:00 66249 8192000000 10055293488 10525921280 1109795824 11.930 98 16 32 1 1155274128 42294816 3183488
13:01:07 62170 8192000000 10084850176 10551967744 1133973680 12.159 100 14 27 0 1182701744 45205440 3522624
13:03:10 104534 8192000000 10067372272 10539134976 1121221920 12.039 98 14 25 0 1168293216 44695120 2376176
13:05:55 15943 8192000000 10122008880 10565435392 1150426688 12.314 100 37 72 0 1215724080 57629616 7667776
13:07:17 66253 8192000000 10112760384 10590576640 1112089008 11.952 97 39 76 0 1199254288 79124096 8041184
13:09:26 55861 8192000000 10107626448 10554884096 1102884880 11.865 96 19 36 0 1176476672 69571664 4020128
13:11:22 53733 8192000000 10075272128 10536878080 1116120272 11.990 98 17 31 0 1157445696 38569984 2755440
13:13:21 29375 8192000000 10067942736 10507890688 1109639248 11.929 98 28 54 0 1147079968 32342608 5098112
13:14:54 22785 8192000000 10067436576 10512330752 1096414048 11.804 98 49 91 2 1150788848 43728352 10646448
13:16:18 100244 8192000000 10036062048 10502561792 1092180832 11.763 98 37 70 2 1155833120 55086272 8566016
13:19:02 18094 8192000000 10084486176 10511437824 1089562992 11.739 98 45 90 1 1152363088 54022720 8777376
13:21:09 93906 8192000000 10041117392 10487541760 1090361216 11.746 98 11 22 0 1114618960 21930096 2327648
13:23:47 31538 8192000000 10045188064 10492076032 1101857648 11.855 99 15 30 0 1152949024 47441088 3650288
13:25:21 46815 8192000000 10076513632 10504560640 1080254096 11.650 96 33 64 0 1140753552 53467808 7031648
13:27:13 35729 8192000000 10136387584 10593214464 1116162320 11.991 99 29 58 0 1246942288 123942544 6837424
13:28:53 56505 8192000000 10177850544 10616500224 1119370688 12.021 99 36 68 2 1246829616 120289360 7169568
13:30:50 145197 8192000000 10122761888 10563735552 1090372576 11.746 96 25 48 0 1181523056 86102384 5048096
13:34:15 18764 8192000000 10097599360 10519580672 1130364112 12.125 100 49 96 0 1186111600 46119760 9627728
13:35:36 55351 8192000000 10080812032 10524389376 1117752784 12.006 99 36 70 0 1195251984 70557216 6941984

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:16, from 14-01-2023 13:39:41 to 14-01-2023 13:39:57.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 102 v_add_invoice_to_stock 335544517
except 9 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 14-01-2023 13:39:58 to 14-01-2023 13:40:00.

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          213982
MON$OLDEST_ACTIVE               218104
MON$OLDEST_SNAPSHOT             218104
MON$NEXT_TRANSACTION            218104
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                       2069280
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             771
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.3.2890 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.3.2890 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.3.2890 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.3.2890 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 ---
:44: 
:45: mscs-test-161.budzdorov.ru    Sat Jan 14 13:37:39 2023
:46:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:47: 
:48: 
:49: mscs-test-161.budzdorov.ru    Sat Jan 14 13:37:39 2023
:50:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:51: 
:52: 
:53: mscs-test-161.budzdorov.ru    Sat Jan 14 13:37:41 2023
:54:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:55: 
--- end of diff output ---

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

14.01.23 13:40:01. 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
2023-01-14 13:40:04 No severe PSQL-related problems occured
14.01.23 13:40:05. End of report.