Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 07.05.2022 13:38
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 16198592 kB
MemAvailable 31500448 kB
Buffers 0 kB
Cached 15512956 kB
SwapCached 2568 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-07 13:37:14
DTS_END                         2022-05-07 13:37:14.7190
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/47070
TRN_ID                          219784
ATT_ID                          622
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: 9288.83 32036 1114659
customer order: creation 165.51 429 19861
customer order: refuse 14.96 358 1795
order to supplier: creation 46.26 1265 5551
order to supplier: removal 3.18 174570 381
invoice (draft): creation 44.19 3045 5303
invoice (draft): removal 53.50 999 6420
invoice accept: apply 41.48 24270 4978
invoice accept: cancel 48.65 1146 5838
customer reserve: creation 3865.16 232 463819
customer reserve: removal 4714.13 91 565695
realization accept: apply 81.20 249 9744
realization accept: cancel 83.10 144 9972
payment from customer: creation 58.44 158 7013
payment from customer: removal 5.95 120 714
payment to supplier: creation 47.84 202 5741
payment to supplier: removal 3.43 142 411
service: total inventory turnovers 3.83 3993 459
service: total monetary turnovers 7.19 342 863
service: aggregate perf. data 0.80 19615 96
service: refresh index statistics 0.04 409340 5

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-05-2022 13:38:38 to 07-05-2022 13:38:40.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9055
TEST_TIME 2 7034
TEST_TIME 3 5906
TEST_TIME 4 6360
TEST_TIME 5 5942
TEST_TIME 6 5856
TEST_TIME 7 5691
TEST_TIME 8 5867
TEST_TIME 9 5954
TEST_TIME 10 5914
TEST_TIME 11 6075
TEST_TIME 12 6316
TEST_TIME 13 6672
TEST_TIME 14 6879
TEST_TIME 15 7071
TEST_TIME 16 7152
TEST_TIME 17 7275
TEST_TIME 18 7224
TEST_TIME 19 7251
TEST_TIME 20 7433
TEST_TIME 21 7771
TEST_TIME 22 7940
TEST_TIME 23 7938
TEST_TIME 24 7946
TEST_TIME 25 8340
TEST_TIME 26 8700
TEST_TIME 27 9001
TEST_TIME 28 9468
TEST_TIME 29 10036
TEST_TIME 30 9993
TEST_TIME 31 9927
TEST_TIME 32 10323
TEST_TIME 33 10444
TEST_TIME 34 11029
TEST_TIME 35 10954
TEST_TIME 36 10905
TEST_TIME 37 10751
TEST_TIME 38 10804
TEST_TIME 39 10838
TEST_TIME 40 10672
TEST_TIME 41 10725
TEST_TIME 42 10693
TEST_TIME 43 10717
TEST_TIME 44 10605
TEST_TIME 45 10401
TEST_TIME 46 10254
TEST_TIME 47 10187
TEST_TIME 48 10080
TEST_TIME 49 10091
TEST_TIME 50 10033
TEST_TIME 51 10016
TEST_TIME 52 10002
TEST_TIME 53 10039
TEST_TIME 54 9957
TEST_TIME 55 10039
TEST_TIME 56 9955
TEST_TIME 57 9860
TEST_TIME 58 9846
TEST_TIME 59 9839
TEST_TIME 60 9778
TEST_TIME 61 9721
TEST_TIME 62 9693
TEST_TIME 63 9723
TEST_TIME 64 9720
TEST_TIME 65 9660
TEST_TIME 66 9622
TEST_TIME 67 9671
TEST_TIME 68 9727
TEST_TIME 69 9765
TEST_TIME 70 9778
TEST_TIME 71 9821
TEST_TIME 72 9862
TEST_TIME 73 9953
TEST_TIME 74 9828
TEST_TIME 75 9755
TEST_TIME 76 9828
TEST_TIME 77 9769
TEST_TIME 78 9689
TEST_TIME 79 9631
TEST_TIME 80 9612
TEST_TIME 81 9584
TEST_TIME 82 9500
TEST_TIME 83 9494
TEST_TIME 84 9468
TEST_TIME 85 9435
TEST_TIME 86 9375
TEST_TIME 87 9321
TEST_TIME 88 9340
TEST_TIME 89 9385
TEST_TIME 90 9412
TEST_TIME 91 9453
TEST_TIME 92 9444
TEST_TIME 93 9428
TEST_TIME 94 9499
TEST_TIME 95 9459
TEST_TIME 96 9438
TEST_TIME 97 9449
TEST_TIME 98 9526
TEST_TIME 99 9585
TEST_TIME 100 9532
TEST_TIME 101 9478
TEST_TIME 102 9437
TEST_TIME 103 9401
TEST_TIME 104 9409
TEST_TIME 105 9369
TEST_TIME 106 9335
TEST_TIME 107 9337
TEST_TIME 108 9317
TEST_TIME 109 9310
TEST_TIME 110 9299
TEST_TIME 111 9289
TEST_TIME 112 9314
TEST_TIME 113 9298
TEST_TIME 114 9293
TEST_TIME 115 9324
TEST_TIME 116 9316
TEST_TIME 117 9309
TEST_TIME 118 9405
TEST_TIME 119 9368
TEST_TIME 120 9309

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 07-05-2022 13:38:42 to 07-05-2022 13:38:45.

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 1541263 1541263 0 0.00 0 39486 12 0 0
doc_list_biud 1541263 1541263 0 0.00 0 39055 39 0 0
sp_add_invoice_to_stock 5114 4978 136 2.65 33 218964 24271 0 136
sp_cancel_adding_invoice 5838 5838 0 0.00 5 99152 1147 0 0
sp_cancel_client_order 1795 1795 0 0.00 6 4982 359 0 0
sp_cancel_customer_reserve 565695 565695 0 0.00 1 39106 92 0 0
sp_cancel_pay_from_customer 714 714 0 0.00 4 6427 120 0 0
sp_cancel_pay_to_supplier 411 411 0 0.00 4 15654 142 0 0
sp_cancel_supplier_invoice 6430 6420 10 0.15 2 13690 1000 0 10
sp_cancel_supplier_order 381 381 0 0.00 13 1424011 174571 0 0
sp_cancel_write_off 9972 9972 0 0.00 2 12819 145 0 0
sp_client_order 19861 19861 0 0.00 6 24997 430 0 0
sp_customer_reserve 463819 463819 0 0.00 1 95536 232 0 0
sp_fill_shopping_cart 30701 30701 0 0.00 1 11112 74 0 0
sp_fill_shopping_cart_clo_res 463790 463790 0 0.00 0 16219 16 0 0
sp_get_clo_for_invoice 4946 4946 0 0.00 0 28661 286 0 0
sp_kill_cost_storno 16935 16935 0 0.00 0 8300 67 0 0
sp_kill_qstorno_ret_qs2qd 1148163 1148163 0 0.00 0 39000 41 0 0
sp_kill_qty_storno 604789 604789 0 0.00 0 39052 93 0 0
sp_lock_selected_doc 20587 20587 0 0.00 0 9935 8 0 0
sp_make_cost_storno 27442 27442 0 0.00 0 14650 78 0 0
sp_multiply_rows_for_pdistr 27442 27442 0 0.00 0 39472 40 0 0
sp_multiply_rows_for_qdistr 19861 19861 0 0.00 0 17608 157 0 0
sp_pay_from_customer 7013 7013 0 0.00 5 12050 158 0 0
sp_pay_to_supplier 5741 5741 0 0.00 7 39492 203 0 0
sp_payment_common 12754 12754 0 0.00 2 6835 42 0 0
sp_qd_handle_on_cancel_clo 1795 1795 0 0.00 0 4964 302 0 0
sp_qd_handle_on_invoice_upd_sts 10782 10782 0 0.00 0 32688 492 0 0
sp_qd_handle_on_reserve_upd_sts 9744 9744 0 0.00 0 27821 53 0 0
sp_reserve_write_off 9744 9744 0 0.00 8 27858 249 0 0
sp_supplier_invoice 5303 5303 0 0.00 11 89470 3046 0 0
sp_supplier_order 5551 5551 0 0.00 8 41884 1266 0 0
srv_aggregate_perf_data 96 96 0 0.00 2896 133041 19616 0 0
srv_fill_mon_cache_memory 69 69 0 0.00 773 142696 38416 0 0
srv_find_qd_qs_mism 1066108 1066108 0 0.00 0 9310 10 0 0
srv_make_invnt_saldo 459 459 0 0.00 69 77920 3993 0 0
srv_make_money_saldo 863 863 0 0.00 1 13064 342 0 0
srv_recalc_idx_stat 5 5 0 0.00 236858 600233 409341 0 0
t$perf-abend:sp_add_invoice_to_stock 136 136 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4980 4980 0 0.00 1 14847 749 0 0
t$perf-norm:sp_cancel_adding_invoice 445 445 0 0.00 1 7216 353 0 0
t$perf-norm:sp_cancel_client_order 1795 1795 0 0.00 0 2393 25 0 0
t$perf-norm:sp_cancel_customer_reserve 749 749 0 0.00 0 3695 28 0 0
t$perf-norm:sp_cancel_pay_from_customer 714 714 0 0.00 0 3340 19 0 0
t$perf-norm:sp_cancel_pay_to_supplier 411 411 0 0.00 0 1993 15 0 0
t$perf-norm:sp_cancel_supplier_invoice 398 398 0 0.00 0 1120 43 0 0
t$perf-norm:sp_cancel_supplier_order 381 381 0 0.00 0 85405 7325 0 0
t$perf-norm:sp_cancel_write_off 1006 1006 0 0.00 0 448 14 0 0
t$perf-norm:sp_client_order 19861 19861 0 0.00 0 7236 32 0 0
t$perf-norm:sp_customer_reserve 997 997 0 0.00 0 1427 14 0 0
t$perf-norm:sp_pay_from_customer 7013 7013 0 0.00 0 4901 16 0 0
t$perf-norm:sp_pay_to_supplier 5741 5741 0 0.00 0 9016 20 0 0
t$perf-norm:sp_reserve_write_off 9744 9744 0 0.00 0 3901 19 0 0
t$perf-norm:sp_supplier_invoice 5303 5303 0 0.00 0 2802 25 0 0
t$perf-norm:sp_supplier_order 5551 5551 0 0.00 0 7265 27 0 0
t$perf-norm:srv_aggregate_perf_data 96 96 0 0.00 0 724 22 0 0
t$perf-norm:srv_fill_mon_cache_memory 69 69 0 0.00 0 581 11 0 0
t$perf-norm:srv_make_invnt_saldo 459 459 0 0.00 0 814 16 0 0
t$perf-norm:srv_make_money_saldo 863 863 0 0.00 0 7804 14 0 0
t$perf-norm:srv_recalc_idx_stat 5 5 0 0.00 4 98 45 0 0
v_add_invoice_to_stock 10160 9888 272 2.67 0 6573 22 0 272
v_all_customers 36722 36722 0 0.00 0 158 3 0 0
v_all_suppliers 30312 30312 0 0.00 0 159 3 0 0
v_all_wares 39720 39720 0 0.00 0 47 3 0 0
v_cancel_adding_invoice 890 890 0 0.00 0 4392 19 0 0
v_cancel_client_order 3590 3590 0 0.00 0 1795 8 0 0
v_cancel_customer_prepayment 1428 1428 0 0.00 0 1313 11 0 0
v_cancel_customer_reserve 1498 1498 0 0.00 0 3756 15 0 0
v_cancel_payment_to_supplier 822 822 0 0.00 0 595 9 0 0
v_cancel_supplier_invoice 816 796 20 2.45 0 477 22 0 20
v_cancel_supplier_order 762 762 0 0.00 0 1726 17 0 0
v_cancel_write_off 2012 2012 0 0.00 0 2525 22 0 0
v_max_id_clo_ord 5550 5550 0 0.00 0 303 4 0 0
v_max_id_clo_res 997 997 0 0.00 0 3168 14 0 0
v_max_id_ord_sup 5291 5291 0 0.00 0 6187 8 0 0
v_max_non_paid_invoice 1426 1426 0 0.00 0 4220 12 0 0
v_max_non_paid_realizn 3564 3564 0 0.00 0 2922 8 0 0
v_min_id_clo_ord 5550 5550 0 0.00 0 1581 8 0 0
v_min_id_clo_res 997 997 0 0.00 0 4586 11 0 0
v_min_id_ord_sup 5291 5291 0 0.00 0 5610 7 0 0
v_min_non_paid_invoice 5741 5741 0 0.00 0 6261 16 0 0
v_min_non_paid_realizn 7013 7013 0 0.00 0 6824 18 0 0
v_our_firm 9896 9896 0 0.00 0 158 4 0 0
v_reserve_write_off 19488 19488 0 0.00 0 5378 10 0 0
x_lock_depdocs_on_canc_invoice 11860 11860 0 0.00 0 17716 117 0 0
x_lock_depdocs_on_canc_sup_ord 381 381 0 0.00 0 16897 446 0 0
x_make_qstorno_1000_1200 5551 5551 0 0.00 3 41799 1105 0 0
x_make_qstorno_1200_2000 5303 5303 0 0.00 6 81969 2851 0 0
x_make_qstorno_2100_3300 463819 463819 0 0.00 0 95534 206 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-05-2022 13:38:46 to 07-05-2022 13:38:50.

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:18 9 8192000000 8799373472 8810975232 4478816 0.054 2 1 2 0 4578208 63616 35776
11:08:19 21449 8192000000 9701918320 9998151680 783772608 8.732 100 83 166 0 812244384 7880432 20591344
11:09:43 24820 8192000000 9761038000 10068328448 833366240 9.233 100 87 174 0 865962272 12410384 20185648
11:11:12 15630 8192000000 9800679776 10116644864 863773552 9.538 100 86 172 0 902020176 18462880 19783744
11:12:32 10890 8192000000 9864045488 10193760256 911015056 10.007 100 85 168 2 969403136 40149504 18238576
11:13:47 8445 8192000000 9895494304 10234576896 945158112 10.344 100 89 175 0 1013885824 50704144 18023568
11:14:58 2533 8192000000 9966542672 10316619776 981892000 10.703 100 89 175 3 1086004304 86385936 17726368
11:16:03 1292 8192000000 9983881184 10346995712 1016843296 11.042 100 90 179 1 1104605712 69804432 17957984
11:17:06 1173 8192000000 10016276784 10386079744 1045592368 11.318 100 93 177 2 1138892128 76640656 16659104
11:18:08 1085 8192000000 10033963552 10408308736 1057390320 11.432 100 98 195 1 1153321360 76619792 19311248
11:19:10 984 8192000000 10065557776 10442108928 1062169024 11.477 100 100 191 2 1187520592 106759568 18592000
11:20:13 1067 8192000000 10037642048 10419855360 1067040688 11.524 100 96 191 2 1155791424 70101248 18649488
11:21:16 960 8192000000 10060709504 10447233024 1078066800 11.629 100 92 181 1 1177580736 81183456 18330480
11:22:19 1407 8192000000 10045556336 10435489792 1080602096 11.653 100 89 173 0 1166114864 68401632 17111136
11:23:22 1595 8192000000 10062703072 10451521536 1086563280 11.710 100 92 176 6 1180609904 75897808 18148816
11:24:25 1421 8192000000 10064769120 10454134784 1095602400 11.796 100 97 187 1 1189155728 74816688 18736640
11:25:28 1278 8192000000 10052700960 10439458816 1101399136 11.851 100 91 180 0 1176608960 57250352 17959472
11:26:30 890 8192000000 10059691168 10448154624 1105269040 11.888 100 92 176 1 1176298448 52979312 18050096
11:27:32 2328 8192000000 10061396064 10452385792 1103813136 11.874 100 81 150 2 1178290112 60570848 13906128
11:28:36 8370 8192000000 10045510224 10442506240 1092553952 11.767 100 64 118 0 1173920320 69151984 12214384
11:29:45 1420 8192000000 10063874912 10452451328 1087766704 11.721 100 79 150 2 1185426480 82874336 14785440
11:30:48 1449 8192000000 10044429056 10433458176 1087265456 11.717 100 82 156 0 1165072112 61942576 15864080
11:31:50 998 8192000000 10009927120 10386223104 1054791088 11.407 100 98 189 3 1128554704 54046992 19716624
11:32:52 1034 8192000000 9990556400 10362834944 1038179344 11.247 100 98 179 1 1116149472 58988656 18981472
11:33:54 1132 8192000000 9999109744 10375593984 1041734784 11.281 99 87 165 1 1123607904 64255920 17617200
11:34:55 10249 8192000000 9975485312 10359025664 1022533392 11.096 98 60 118 0 1093606064 59459616 11613056
11:36:07 1112 8192000000 10006733168 10382544896 1051695744 11.377 100 89 166 2 1127619488 58952480 16971264
11:37:08 3501 8192000000 9994449184 10373627904 1042236880 11.286 99 78 144 4 1112260128 53823072 16200176
11:38:20 27255 8192000000 10016446096 10403672064 1070638160 11.558 100 64 125 0 1135062560 51910384 12514016
11:39:58 19890 8192000000 10059347712 10438803456 1084627536 11.692 100 74 144 3 1174600400 75790256 14182608
11:41:23 1255 8192000000 10096816864 10481369088 1102388832 11.860 100 88 168 2 1214834032 94244160 18201040
11:42:30 4815 8192000000 10109775536 10496663552 1107484944 11.909 100 74 145 0 1223538992 100399680 15654368
11:43:41 6309 8192000000 10148174432 10546601984 1126262000 12.086 100 67 128 1 1263761344 122615264 14884080
11:44:57 3832 8192000000 10202685264 10595282944 1131890208 12.139 100 82 161 0 1311112912 162116512 17106192
11:46:07 1497 8192000000 10231203392 10624507904 1139784896 12.214 100 79 154 0 1343068176 187207968 16075312
11:47:16 2701 8192000000 10251248816 10652635136 1157617040 12.381 100 71 133 1 1362271920 189609168 15045712
11:48:22 798 8192000000 10289805104 10698760192 1169049120 12.488 100 93 180 1 1402865568 212064272 21752176
11:49:26 910 8192000000 10311541504 10723749888 1181229072 12.602 100 88 172 0 1422320064 221739024 19351968
11:50:31 4414 8192000000 10341346864 10747277312 1188972544 12.674 100 83 157 1 1453228064 246091680 18163840
11:51:45 1101 8192000000 10342515568 10743103488 1183400224 12.622 99 96 190 3 1449674800 244586128 21688448
11:52:48 1414 8192000000 10362493728 10782511104 1203204176 12.806 100 96 189 0 1469977056 245736416 21036464
11:53:50 1265 8192000000 10403684128 10821591040 1202054048 12.795 99 94 186 0 1511600464 286870000 22676416
11:54:55 2388 8192000000 10470387568 10886914048 1226910016 13.026 100 79 154 1 1580736480 335237280 18589184
11:56:03 2609 8192000000 10473312192 10908106752 1218857568 12.951 100 75 144 0 1583177216 346454320 17865328
11:57:10 1582 8192000000 10540171856 10971066368 1213811216 12.904 100 85 170 1 1645503904 411131200 20561488
11:58:17 764 8192000000 10523876688 10975113216 1212328464 12.891 100 93 180 2 1628250176 393562688 22359024
11:59:19 7774 8192000000 10513023120 10941730816 1215154576 12.917 100 47 92 0 1623985840 396798240 12033024
12:00:33 10299 8192000000 10560442272 10990280704 1195954304 12.739 99 52 104 0 1658186000 448496640 13735056
12:01:51 1338 8192000000 10597374880 11030822912 1203824096 12.812 100 85 166 0 1697897600 474762752 19310752
12:02:57 11052 8192000000 10492201840 11033501696 1196455472 12.743 100 39 77 0 1605700544 398669232 10575840
12:04:13 4522 8192000000 10533193296 10986876928 1194669408 12.727 100 61 121 0 1649156224 439526560 14960256
12:05:28 17304 8192000000 10401426304 10844786688 1168567040 12.483 99 41 82 0 1486545104 307369680 10608384
12:07:03 20974 8192000000 10307148624 10760548352 1164321744 12.444 98 26 52 1 1392567296 221292400 6953152
12:08:36 48327 8192000000 10260104784 10760736768 1130668848 12.128 97 23 44 3 1391437808 255067968 5700992
12:10:30 42965 8192000000 10157142800 10772926464 1153332704 12.341 100 17 34 1 1285166192 127895232 3938256
12:12:22 73168 8192000000 10098963216 10588057600 1110196576 11.934 96 23 44 4 1190915008 76125568 4592864
12:15:00 75065 8192000000 10095227472 10601873408 1125538352 12.079 99 15 27 0 1183971680 55809664 2623664
12:17:21 142693 8192000000 10067420592 10515632128 1070237456 11.554 94 8 14 1 1124247760 52669376 1340928
12:20:44 118431 8192000000 10073600656 10512838656 1120202784 12.029 98 21 41 2 1159699936 35162128 4335024
12:23:43 46950 8192000000 10058196880 10492739584 1084382000 11.689 96 31 56 0 1112931360 22742704 5806656
12:26:28 37346 8192000000 10111961536 10556100608 1096563072 11.805 97 23 46 0 1184300320 82642496 5094752
12:28:08 14392 8192000000 10101443616 10557669376 1121906944 12.045 100 71 135 0 1228062848 90526960 15628944
12:29:23 44132 8192000000 10144614736 10608238592 1122378128 12.049 99 16 32 0 1239995824 114030256 3587440
12:31:08 63777 8192000000 10094342672 10547830784 1102498160 11.861 98 19 38 0 1174016256 67657744 3860352
12:33:12 36549 8192000000 10057371568 10514210816 1111577344 11.947 99 7 14 0 1152988016 39863328 1547344
12:34:58 55741 8192000000 10047954016 10535387136 1111900528 11.950 99 5 10 0 1151019856 38305120 814208
12:36:56 85044 8192000000 10035216400 10482278400 1070074944 11.553 96 10 20 1 1118894192 46792752 2026496
12:39:34 19282 8192000000 10069507040 10504740864 1117309696 12.002 99 42 79 2 1172204928 44767600 10127632
12:40:59 56952 8192000000 10086715232 10543640576 1115404192 11.984 98 14 28 1 1164475360 45907296 3163872
12:43:00 79704 8192000000 10171997536 10628743168 1129709040 12.119 98 22 44 2 1239590752 104622144 5259568
12:45:21 41242 8192000000 10132117440 10575478784 1102305488 11.860 97 20 40 2 1200281552 93546080 4429984
12:47:11 59486 8192000000 10120743808 10600660992 1117556064 12.004 98 13 26 0 1198640624 78241264 2843296
12:49:12 66575 8192000000 10149346896 10629857280 1125363152 12.078 99 24 48 1 1209437504 78981728 5092624
12:51:18 95054 8192000000 10156549680 10610974720 1125551760 12.079 99 25 50 0 1246410960 115005376 5853824
12:54:10 53799 8192000000 10040497648 10484056064 1093436496 11.775 97 18 33 2 1136041232 39525776 3078960
12:56:09 60935 8192000000 10069800624 10526892032 1105178016 11.887 98 10 18 1 1155412320 48271888 1962416
12:58:20 68484 8192000000 10071838608 10527027200 1102030624 11.857 98 11 22 0 1160846768 56444928 2371216
13:00:30 33294 8192000000 10099998144 10534354944 1124638080 12.071 99 50 100 2 1188378464 53253056 10487328
13:02:03 51233 8192000000 10111523120 10567081984 1105203088 11.887 97 22 43 3 1179571856 69132144 5236624
13:03:55 81662 8192000000 10157999120 10638364672 1126264464 12.086 98 27 54 1 1245695952 112572384 6859104
13:06:34 62924 8192000000 10147070112 10656030720 1133839648 12.158 100 7 14 0 1255039328 119585440 1614240
13:08:38 83078 8192000000 10109855760 10578100224 1119283920 12.020 98 18 35 3 1172230496 48954816 3991760
13:11:02 61896 8192000000 10089381552 10523533312 1100793248 11.845 98 46 86 0 1198882192 89280848 8808096
13:13:08 6279 8192000000 10092681760 10507968512 1099166368 11.830 99 65 130 0 1170949792 58389584 13393840
13:14:16 28372 8192000000 10112468832 10558996480 1111403264 11.946 100 42 82 2 1193008128 73491648 8113216
13:15:49 74961 8192000000 10082613632 10600275968 1098392288 11.822 98 20 40 0 1200228576 98042544 3793744
13:18:04 98525 8192000000 10037296032 10507378688 1074668624 11.597 96 28 54 0 1119039536 39289824 5081088
13:20:43 45695 8192000000 10044937280 10509893632 1109362656 11.926 99 27 52 0 1171815504 56979584 5473264
13:22:45 82162 8192000000 10075150016 10546606080 1103702320 11.873 99 16 32 1 1172166320 64646880 3817120
13:25:15 37854 8192000000 10075611360 10518446080 1121010256 12.037 100 28 55 1 1178468176 51715520 5742400
13:26:56 29242 8192000000 10073676336 10514427904 1085033024 11.695 97 34 68 0 1139795312 48103056 6659232
13:28:28 34754 8192000000 10102439984 10536062976 1108665664 11.920 100 34 67 0 1181899904 66308208 6926032
13:30:05 34303 8192000000 10091234848 10517606400 1113099968 11.962 100 45 90 0 1176072528 54163024 8809536
13:31:40 18179 8192000000 10122344176 10553810944 1109780448 11.930 99 44 86 0 1210636960 92444944 8411568
13:32:59 39896 8192000000 10119417248 10567176192 1121967216 12.046 99 43 86 0 1206760672 75828880 8964576
13:34:43 65323 8192000000 10109424368 10633117696 1121274608 12.039 98 31 60 2 1250933456 123443984 6214864
13:36:55 36744 8192000000 8981282512 9209679872 127026160 1.526 12 2 4 0 140241872 12987216 228496

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:16, from 07-05-2022 13:38:52 to 07-05-2022 13:39:08.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 136 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 07-05-2022 13:39:09 to 07-05-2022 13:39:11.

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          221829
MON$OLDEST_ACTIVE               221830
MON$OLDEST_SNAPSHOT             221830
MON$NEXT_TRANSACTION            221830
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                       2076832
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             777
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.2.2763 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.2.2763 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.2.2763 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.2.2763 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 ---
--- end of diff output ---

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

07.05.22 13:39:12. 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-07 13:39:15 No severe PSQL-related problems occured
07.05.22 13:39:16. End of report.