Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 23.10.2021 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 58e1ddde69c44dad93d327777e5becec
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-05-09 08:45
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 4793.92
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 15715708 kB
MemAvailable 30661452 kB
Buffers 0 kB
Cached 16016332 kB
SwapCached 3704 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.1
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 2021-10-23 07:47:02
DTS_END                         2021-10-23 07:47:02.0150
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_AGGREGATE_PERF_DATA(83:5) ==> TMP_AGGREGATE_PERF_DATA_AUTOGEN(376:13) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/39208
TRN_ID                          229537
ATT_ID                          651
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: 9354.60 20229 1122552
customer order: creation 169.77 395 20372
customer order: refuse 14.69 306 1763
order to supplier: creation 46.28 1377 5553
order to supplier: removal 3.47 124428 416
invoice (draft): creation 44.83 3385 5379
invoice (draft): removal 53.59 963 6431
invoice accept: apply 40.87 17911 4904
invoice accept: cancel 48.87 941 5864
customer reserve: creation 3867.15 171 464058
customer reserve: removal 4771.48 71 572578
realization accept: apply 82.25 193 9870
realization accept: cancel 85.42 129 10250
payment from customer: creation 57.61 134 6913
payment from customer: removal 5.55 83 666
payment to supplier: creation 48.94 160 5873
payment to supplier: removal 3.49 98 419
service: total inventory turnovers 3.81 3549 457
service: total monetary turnovers 5.61 585 673
service: aggregate perf. data 0.91 17709 109
service: refresh index statistics 0.03 231985 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 23-10-2021 07:49:10 to 23-10-2021 07:49:13.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6204
TEST_TIME 2 6178
TEST_TIME 3 6842
TEST_TIME 4 6380
TEST_TIME 5 6276
TEST_TIME 6 5900
TEST_TIME 7 5919
TEST_TIME 8 5834
TEST_TIME 9 5636
TEST_TIME 10 5737
TEST_TIME 11 5975
TEST_TIME 12 6209
TEST_TIME 13 6253
TEST_TIME 14 6496
TEST_TIME 15 6635
TEST_TIME 16 6944
TEST_TIME 17 7178
TEST_TIME 18 7531
TEST_TIME 19 8082
TEST_TIME 20 8522
TEST_TIME 21 8770
TEST_TIME 22 8885
TEST_TIME 23 9999
TEST_TIME 24 10918
TEST_TIME 25 12029
TEST_TIME 26 11744
TEST_TIME 27 11427
TEST_TIME 28 11239
TEST_TIME 29 11077
TEST_TIME 30 11090
TEST_TIME 31 10920
TEST_TIME 32 10773
TEST_TIME 33 10673
TEST_TIME 34 10569
TEST_TIME 35 10416
TEST_TIME 36 10395
TEST_TIME 37 10403
TEST_TIME 38 10263
TEST_TIME 39 10259
TEST_TIME 40 10316
TEST_TIME 41 10279
TEST_TIME 42 10474
TEST_TIME 43 10508
TEST_TIME 44 10455
TEST_TIME 45 10574
TEST_TIME 46 10380
TEST_TIME 47 10221
TEST_TIME 48 10202
TEST_TIME 49 10092
TEST_TIME 50 9999
TEST_TIME 51 9941
TEST_TIME 52 9961
TEST_TIME 53 9951
TEST_TIME 54 9833
TEST_TIME 55 9812
TEST_TIME 56 9849
TEST_TIME 57 9861
TEST_TIME 58 9898
TEST_TIME 59 9847
TEST_TIME 60 9857
TEST_TIME 61 9926
TEST_TIME 62 9931
TEST_TIME 63 9986
TEST_TIME 64 9950
TEST_TIME 65 10062
TEST_TIME 66 10122
TEST_TIME 67 10101
TEST_TIME 68 10054
TEST_TIME 69 10124
TEST_TIME 70 10151
TEST_TIME 71 10186
TEST_TIME 72 10101
TEST_TIME 73 9982
TEST_TIME 74 9960
TEST_TIME 75 9882
TEST_TIME 76 9796
TEST_TIME 77 9823
TEST_TIME 78 9778
TEST_TIME 79 9725
TEST_TIME 80 9698
TEST_TIME 81 9619
TEST_TIME 82 9544
TEST_TIME 83 9618
TEST_TIME 84 9666
TEST_TIME 85 9644
TEST_TIME 86 9684
TEST_TIME 87 9657
TEST_TIME 88 9623
TEST_TIME 89 9656
TEST_TIME 90 9640
TEST_TIME 91 9669
TEST_TIME 92 9702
TEST_TIME 93 9730
TEST_TIME 94 9718
TEST_TIME 95 9792
TEST_TIME 96 9781
TEST_TIME 97 9715
TEST_TIME 98 9660
TEST_TIME 99 9598
TEST_TIME 100 9628
TEST_TIME 101 9578
TEST_TIME 102 9534
TEST_TIME 103 9479
TEST_TIME 104 9431
TEST_TIME 105 9468
TEST_TIME 106 9462
TEST_TIME 107 9438
TEST_TIME 108 9448
TEST_TIME 109 9483
TEST_TIME 110 9478
TEST_TIME 111 9503
TEST_TIME 112 9481
TEST_TIME 113 9484
TEST_TIME 114 9520
TEST_TIME 115 9533
TEST_TIME 116 9504
TEST_TIME 117 9526
TEST_TIME 118 9455
TEST_TIME 119 9434
TEST_TIME 120 9355

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 23-10-2021 07:49:14 to 23-10-2021 07:49:17.

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 1550605 1550605 0 0.00 0 28075 7 0 0
doc_list_biud 1550603 1550603 0 0.00 0 37898 33 0 0
sp_add_invoice_to_stock 5012 4904 108 2.15 60 191012 17911 0 108
sp_cancel_adding_invoice 5864 5864 0 0.00 5 95807 942 0 0
sp_cancel_client_order 1763 1763 0 0.00 4 16611 307 0 0
sp_cancel_customer_reserve 572578 572578 0 0.00 1 23461 71 0 0
sp_cancel_pay_from_customer 666 666 0 0.00 3 7310 83 0 0
sp_cancel_pay_to_supplier 419 419 0 0.00 3 9353 99 0 0
sp_cancel_supplier_invoice 6438 6431 7 0.10 2 37906 963 0 7
sp_cancel_supplier_order 416 416 0 0.00 8 1186364 124428 0 0
sp_cancel_write_off 10250 10250 0 0.00 1 20443 129 0 0
sp_client_order 20372 20372 0 0.00 4 26048 396 0 0
sp_customer_reserve 464058 464058 0 0.00 0 135200 172 0 0
sp_fill_shopping_cart 31290 31290 0 0.00 1 11521 44 0 0
sp_fill_shopping_cart_clo_res 464053 464053 0 0.00 0 13707 15 0 0
sp_get_clo_for_invoice 4898 4898 0 0.00 0 33013 403 0 0
sp_kill_cost_storno 17199 17199 0 0.00 0 20437 68 0 0
sp_kill_qstorno_ret_qs2qd 1162253 1162253 0 0.00 0 37897 38 0 0
sp_kill_qty_storno 612069 612069 0 0.00 0 37898 82 0 0
sp_lock_selected_doc 20520 20520 0 0.00 0 8674 4 0 0
sp_make_cost_storno 27554 27554 0 0.00 0 28072 66 0 0
sp_multiply_rows_for_pdistr 27554 27554 0 0.00 0 12845 38 0 0
sp_multiply_rows_for_qdistr 20372 20372 0 0.00 0 18802 175 0 0
sp_pay_from_customer 6913 6913 0 0.00 4 17951 134 0 0
sp_pay_to_supplier 5873 5873 0 0.00 5 28097 160 0 0
sp_payment_common 12785 12785 0 0.00 1 21289 28 0 0
sp_qd_handle_on_cancel_clo 1763 1763 0 0.00 0 16367 272 0 0
sp_qd_handle_on_invoice_upd_sts 10762 10762 0 0.00 0 23212 366 0 0
sp_qd_handle_on_reserve_upd_sts 9869 9869 0 0.00 0 19216 56 0 0
sp_reserve_write_off 9870 9870 0 0.00 6 23240 193 0 0
sp_supplier_invoice 5379 5379 0 0.00 6 111053 3385 0 0
sp_supplier_order 5553 5553 0 0.00 6 32914 1378 0 0
srv_aggregate_perf_data 109 109 0 0.00 2997 346261 17709 0 0
srv_fill_mon_cache_memory 64 64 0 0.00 818 155337 47016 0 0
srv_find_qd_qs_mism 1074410 1074410 0 0.00 0 21692 6 0 0
srv_make_invnt_saldo 457 457 0 0.00 40 136617 3550 0 0
srv_make_money_saldo 673 673 0 0.00 1 16190 586 0 0
srv_recalc_idx_stat 4 4 0 0.00 135347 340692 231985 0 0
t$perf-abend:sp_add_invoice_to_stock 108 108 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4904 4904 0 0.00 0 34296 156 0 0
t$perf-norm:sp_cancel_adding_invoice 424 424 0 0.00 1 3640 90 0 0
t$perf-norm:sp_cancel_client_order 1763 1763 0 0.00 0 19384 31 0 0
t$perf-norm:sp_cancel_customer_reserve 648 648 0 0.00 0 1408 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 666 666 0 0.00 0 15358 35 0 0
t$perf-norm:sp_cancel_pay_to_supplier 419 419 0 0.00 0 1613 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 383 383 0 0.00 0 711 13 0 0
t$perf-norm:sp_cancel_supplier_order 416 416 0 0.00 0 19306 1604 0 0
t$perf-norm:sp_cancel_write_off 1035 1035 0 0.00 0 462 3 0 0
t$perf-norm:sp_client_order 20372 20372 0 0.00 0 21687 21 0 0
t$perf-norm:sp_customer_reserve 968 968 0 0.00 0 18456 45 0 0
t$perf-norm:sp_pay_from_customer 6913 6913 0 0.00 0 2844 8 0 0
t$perf-norm:sp_pay_to_supplier 5873 5873 0 0.00 0 11234 15 0 0
t$perf-norm:sp_reserve_write_off 9870 9870 0 0.00 0 19727 15 0 0
t$perf-norm:sp_supplier_invoice 5379 5379 0 0.00 0 7077 19 0 0
t$perf-norm:sp_supplier_order 5553 5553 0 0.00 0 5557 16 0 0
t$perf-norm:srv_aggregate_perf_data 109 109 0 0.00 0 138 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 64 64 0 0.00 0 2874 53 0 0
t$perf-norm:srv_make_invnt_saldo 457 457 0 0.00 0 4875 16 0 0
t$perf-norm:srv_make_money_saldo 673 673 0 0.00 0 820 8 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 6 3 0 0
v_add_invoice_to_stock 10006 9790 216 2.15 0 8894 20 0 216
v_all_customers 37472 37472 0 0.00 0 70 1 0 0
v_all_suppliers 30556 30556 0 0.00 0 70 1 0 0
v_all_wares 40742 40742 0 0.00 0 41 1 0 0
v_cancel_adding_invoice 848 848 0 0.00 0 2312 10 0 0
v_cancel_client_order 3526 3526 0 0.00 0 4937 9 0 0
v_cancel_customer_prepayment 1332 1332 0 0.00 0 2326 10 0 0
v_cancel_customer_reserve 1296 1296 0 0.00 0 1904 7 0 0
v_cancel_payment_to_supplier 838 838 0 0.00 0 5772 17 0 0
v_cancel_supplier_invoice 780 766 14 1.79 0 2259 19 0 14
v_cancel_supplier_order 832 832 0 0.00 0 1020 8 0 0
v_cancel_write_off 2070 2070 0 0.00 0 1639 15 0 0
v_max_id_clo_ord 5546 5546 0 0.00 0 815 1 0 0
v_max_id_clo_res 968 968 0 0.00 0 1988 12 0 0
v_max_id_ord_sup 5372 5372 0 0.00 0 2675 4 0 0
v_max_non_paid_invoice 1512 1512 0 0.00 0 774 2 0 0
v_max_non_paid_realizn 3433 3433 0 0.00 0 11956 9 0 0
v_min_id_clo_ord 5546 5546 0 0.00 0 988 5 0 0
v_min_id_clo_res 968 968 0 0.00 0 5071 22 0 0
v_min_id_ord_sup 5372 5372 0 0.00 0 6559 10 0 0
v_min_non_paid_invoice 5872 5872 0 0.00 0 21285 18 0 0
v_min_non_paid_realizn 6913 6913 0 0.00 0 12757 21 0 0
v_our_firm 10230 10230 0 0.00 0 16 1 0 0
v_reserve_write_off 19738 19738 0 0.00 0 5085 7 0 0
x_lock_depdocs_on_canc_invoice 11912 11912 0 0.00 0 24896 123 0 0
x_lock_depdocs_on_canc_sup_ord 416 416 0 0.00 0 6510 321 0 0
x_make_qstorno_1000_1200 5553 5553 0 0.00 2 32910 1305 0 0
x_make_qstorno_1200_2000 5379 5379 0 0.00 3 111026 3207 0 0
x_make_qstorno_2100_3300 464057 464057 0 0.00 0 135183 154 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 23-10-2021 07:49:18 to 23-10-2021 07:49:23.

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:17:05 2 8192000000 8796669024 8807174144 3189120 0.038 1 1 2 0 3286736 61840 35776
05:18:06 34364 8192000000 9711093824 10007420928 787964624 8.774 100 88 176 0 817295520 7644368 21686528
05:19:49 26538 8192000000 9750298864 10055000064 821665552 9.115 100 88 176 0 857050272 13792368 21592352
05:21:23 20343 8192000000 9811006288 10130223104 860039936 9.501 100 88 176 2 910901136 30264160 20597040
05:22:48 20541 8192000000 9890451504 10227552256 926378672 10.159 100 74 147 1 994746208 52598240 15769296
05:24:10 9010 8192000000 9923615200 10271117312 970265744 10.589 100 79 158 1 1037789168 51459504 16063920
05:25:22 5381 8192000000 9968081536 10321977344 1004723296 10.924 100 82 164 1 1083131680 61659504 16748880
05:26:38 3557 8192000000 10007082352 10376687616 1035562928 11.222 100 71 142 0 1125846336 76031440 14251968
05:27:42 2688 8192000000 10024272464 10392408064 1051333936 11.373 100 80 160 2 1125549568 58146832 16068800
05:28:46 14262 8192000000 10018092192 10397577216 1061144896 11.467 100 60 118 1 1134455776 60859360 12451520
05:30:00 3759 8192000000 9987507872 10379489280 1071141232 11.563 100 53 109 0 1106580560 23863040 11576288
05:31:06 51252 8192000000 9978021072 10385166336 1076552672 11.615 100 42 84 1 1103970256 17751856 9665728
05:33:01 8042 8192000000 10001245696 10404515840 1083678784 11.683 100 30 60 2 1115389056 25697408 6012864
05:34:11 10401 8192000000 9992988064 10400964608 1088918256 11.732 100 31 61 1 1112649680 16736048 6995376
05:35:24 8781 8192000000 10013851328 10421129216 1088983056 11.733 100 30 60 1 1124090880 28842032 6265792
05:36:34 43167 8192000000 10002870256 10413330432 1081402368 11.661 99 18 36 1 1108906896 23231024 4273504
05:38:18 8538 8192000000 10018717072 10412744704 1076784400 11.617 99 42 84 1 1125737776 39237008 9716368
05:39:27 8856 8192000000 9957746944 10339090432 1018798960 11.060 96 32 62 1 1044074320 17990784 7284576
05:40:42 58691 8192000000 9921662464 10297139200 984897136 10.732 96 52 99 1 1004284704 8120960 11266608
05:42:44 4467 8192000000 9958014144 10335477760 1013953696 11.014 99 48 99 1 1052941344 28552864 10434784
05:43:49 4467 8192000000 9965179296 10345660416 1037825488 11.244 100 46 90 1 1066456496 18686496 9944512
05:44:56 9929 8192000000 9986777200 10389155840 1059659792 11.453 100 36 72 2 1092708896 25054496 7994608
05:46:10 58295 8192000000 9984352416 10389716992 1062841728 11.484 100 30 60 0 1089019872 20432768 5745376
05:48:14 23920 8192000000 10035418272 10434629632 1093338640 11.774 100 47 90 2 1143092768 40692352 9061776
05:49:42 17568 8192000000 10085484928 10485358592 1113887088 11.969 100 57 110 4 1201521040 76331760 11302192
05:51:02 32213 8192000000 10108957632 10513874944 1131149536 12.132 100 45 89 5 1217495136 76676672 9668928
05:52:41 22595 8192000000 10166864080 10578944000 1144206320 12.255 100 47 95 1 1279303056 125031952 10064784
05:54:10 5972 8192000000 10213458448 10617839616 1148474320 12.295 99 67 134 0 1315625872 152252592 14898960
05:55:28 3486 8192000000 10261910112 10667470848 1172173392 12.517 100 61 122 1 1363422352 177348352 13900608
05:56:37 4201 8192000000 10325548544 10739150848 1185849472 12.645 100 58 116 0 1429891824 230797024 13245328
05:57:51 3612 8192000000 10389639792 10799529984 1199910032 12.775 100 79 157 0 1497221344 279449712 17861600
05:58:58 3057 8192000000 10452442960 10856431616 1191847296 12.701 100 76 152 0 1557971968 348022864 18101808
06:00:10 3381 8192000000 10491876864 10895994880 1203454048 12.808 100 82 164 0 1593116992 371087536 18575408
06:01:20 817 8192000000 10511760288 10916728832 1195548912 12.735 100 83 166 0 1612729152 397261312 19918928
06:02:27 1379 8192000000 10586027136 10996420608 1180536624 12.595 99 86 169 0 1676755824 475149728 21069472
06:03:34 2808 8192000000 10593847632 11012100096 1178610304 12.577 100 64 128 2 1688290432 493827984 15852144
06:04:45 5907 8192000000 10608949200 11025707008 1193790736 12.719 99 71 143 0 1700839552 489200880 17847936
06:06:02 7219 8192000000 10615790512 11073695744 1206419792 12.836 100 50 100 0 1748168576 528124976 13623808
06:07:16 9089 8192000000 10617876672 11060875264 1186879376 12.654 100 46 92 0 1728192960 528797200 12516384
06:08:27 14208 8192000000 10562126304 11038674944 1160216080 12.405 99 39 78 1 1670930672 500282320 10432272
06:09:48 7410 8192000000 10593666544 11047538688 1144316480 12.256 100 37 74 0 1696783584 541720080 10747024
06:10:56 41356 8192000000 10343024144 10884788224 1137296880 12.190 100 18 36 0 1542417008 400035280 5084848
06:12:38 36466 8192000000 10075473712 10510925824 1072371184 11.575 94 12 24 1 1120519472 45397696 2750592
06:14:15 64167 8192000000 10090120368 10568376320 1118527968 12.013 99 25 50 4 1174193408 50107424 5558016
06:16:21 97255 8192000000 10082857536 10556518400 1112376368 11.955 98 39 78 1 1201488416 80568288 8543760
06:19:08 50408 8192000000 10082096320 10510073856 1104545968 11.881 97 33 64 2 1132314880 21630208 6138704
06:21:05 65324 8192000000 10086701248 10525773824 1070243424 11.554 94 12 24 1 1105807488 33299584 2264480
06:23:15 41917 8192000000 10085721600 10505867264 1112193264 11.953 98 45 90 0 1147213632 24918656 10101712
06:25:01 32643 8192000000 10091347072 10523070464 1122857216 12.054 99 21 40 0 1160218080 33480320 3880544
06:26:43 127345 8192000000 10153400880 10622824448 1116456416 11.994 98 12 24 1 1182883488 63856048 2571024
06:29:59 70826 8192000000 10092051936 10584059904 1139353712 12.209 99 24 48 0 1202251232 58035312 4862208
06:32:17 74159 8192000000 10122716128 10625343488 1107859968 11.912 97 17 34 0 1174346016 62872768 3613280
06:34:32 57595 8192000000 10099232528 10513616896 1124297040 12.068 99 57 114 1 1181802000 44853392 12651568
06:36:31 88954 8192000000 10144018624 10581700608 1153409584 12.341 100 35 70 0 1227006320 65666768 7929968
06:39:00 42766 8192000000 10155870176 10598703104 1142732992 12.241 99 30 58 1 1268771984 119889264 6149728
06:40:52 155337 8192000000 10175824464 10686951424 1143698096 12.250 99 10 21 0 1263628240 117593184 2336960
06:44:31 33490 8192000000 10153634096 10634313728 1156782768 12.373 100 15 30 0 1240584928 79919088 3883072
06:46:16 69969 8192000000 10108157968 10604933120 1124195072 12.067 97 17 32 1 1188545792 61142928 3207792
06:48:28 34616 8192000000 10049572080 10485321728 1076421520 11.613 94 31 62 0 1105733936 22791488 6520928
06:50:04 52378 8192000000 10092564272 10566762496 1130993504 12.131 99 24 48 0 1201151840 64650576 5507760
06:51:59 84245 8192000000 10126479584 10639200256 1123244864 12.058 98 10 20 0 1188202416 63238512 1719040
06:54:23 36307 8192000000 10073430384 10512031744 1099618544 11.834 96 27 54 0 1130058176 24775776 5663856
06:55:59 60299 8192000000 10089814448 10565308416 1116480192 11.994 98 17 34 1 1193212544 73158112 3574240
06:58:00 104776 8192000000 10062321168 10486595584 1083067568 11.677 95 22 43 2 1118213872 29719856 5426448
07:00:58 89306 8192000000 10049449728 10475548672 1071269328 11.564 95 32 63 1 1109110224 30895856 6945040
07:03:29 20777 8192000000 10102449872 10523836416 1129229824 12.114 100 40 80 0 1200474672 63216384 8028464
07:04:51 41946 8192000000 10076817984 10515521536 1110036176 11.933 98 12 24 0 1164024416 51296960 2691280
07:06:40 53703 8192000000 10093463104 10530709504 1100810640 11.845 98 12 24 0 1164811904 61371504 2629760
07:09:14 49113 8192000000 10139845264 10590298112 1120110144 12.028 100 14 28 0 1236266464 112892912 3263408
07:11:19 78146 8192000000 10064532944 10518024192 1078358608 11.632 96 12 24 0 1117873904 37170720 2344576
07:13:39 30627 8192000000 10053881616 10482761728 1115979184 11.989 99 30 59 2 1157163616 34416272 6768160
07:15:11 45151 8192000000 10081692672 10517368832 1108777888 11.921 99 31 62 1 1149660704 34823568 6059248
07:16:59 17538 8192000000 10066502368 10479489024 1099248144 11.831 99 49 97 0 1153136752 44742432 9146176
07:18:18 56930 8192000000 10104232736 10538848256 1101396432 11.851 98 34 68 0 1174979296 66475872 7106992
07:20:20 42956 8192000000 10057905808 10484465664 1086868880 11.713 97 22 44 0 1138688096 47725328 4093888
07:22:06 42473 8192000000 10111586176 10587353088 1113885536 11.969 100 20 40 1 1200824528 82910336 4028656
07:23:49 129403 8192000000 10044385504 10499330048 1123572560 12.061 100 25 50 0 1151577968 22163728 5841680
07:27:57 59119 8192000000 10043101936 10526056448 1121452576 12.041 100 6 12 0 1154596464 32094656 1049232
07:30:25 82092 8192000000 10107572256 10566721536 1112324560 11.954 98 21 40 1 1178242304 61014704 4903040
07:32:55 34930 8192000000 10067681584 10511175680 1108484992 11.918 98 18 36 0 1146866672 34424448 3957232
07:34:49 45682 8192000000 10102360656 10563923968 1134043824 12.159 100 27 54 1 1205458448 65918960 5495664
07:36:39 48109 8192000000 10087019760 10532016128 1127210624 12.095 98 24 49 1 1170561248 38288272 5062352
07:38:27 48366 8192000000 10086232480 10512195584 1121512080 12.041 98 24 48 0 1164235712 37407248 5316384
07:40:16 31746 8192000000 10133210448 10590883840 1143101600 12.245 100 33 66 1 1211941200 62203216 6636384
07:41:49 82522 8192000000 10085469888 10509529088 1074461152 11.595 93 22 44 1 1117121424 38178528 4481744
07:44:17 128551 8192000000 10096943472 10551513088 1116824752 11.997 98 23 46 1 1187704080 66223520 4655808

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 23-10-2021 07:49:24 to 23-10-2021 07:49:39.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 108 v_add_invoice_to_stock 335544517
except 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 23-10-2021 07:49:40 to 23-10-2021 07:49:42.

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          227968
MON$OLDEST_ACTIVE               230547
MON$OLDEST_SNAPSHOT             230547
MON$NEXT_TRANSACTION            230547
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                       2051040
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             789
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.1.2639 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2639 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.1.2639 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.1.2639 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    Sat Oct 23 07:47:23 2021
: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'

23.10.21 07:49:43. 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
2021-10-23 07:49:45 No severe PSQL-related problems occured
23.10.21 07:49:47. End of report.