Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 23.06.2022 04: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 15703908 kB
MemAvailable 31223116 kB
Buffers 20 kB
Cached 15966408 kB
SwapCached 2492 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 4.0.2
DB_NAME                         /home/bases/oltp40-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp40-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp40-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb40/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3400
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp40-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp40
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2022-06-23 04:37:19
DTS_END                         2022-06-23 04:37:19.1530
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/56646
TRN_ID                          215570
ATT_ID                          598
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: 8657.60 26032 1038912
customer order: creation 165.93 505 19912
customer order: refuse 14.32 508 1718
order to supplier: creation 43.88 1431 5265
order to supplier: removal 3.28 190432 394
invoice (draft): creation 44.04 3389 5285
invoice (draft): removal 48.40 1163 5808
invoice accept: apply 39.43 27343 4732
invoice accept: cancel 43.58 1426 5230
customer reserve: creation 3690.83 255 442899
customer reserve: removal 4282.07 114 513848
realization accept: apply 80.46 307 9655
realization accept: cancel 77.33 183 9280
payment from customer: creation 56.01 198 6721
payment from customer: removal 5.68 144 681
payment to supplier: creation 46.28 217 5553
payment to supplier: removal 3.53 145 424
service: total inventory turnovers 3.69 4934 443
service: total monetary turnovers 7.91 371 949
service: aggregate perf. data 0.93 19194 111
service: refresh index statistics 0.03 268381 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 23-06-2022 04:38:47 to 23-06-2022 04:38:50.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7838
TEST_TIME 2 6913
TEST_TIME 3 6287
TEST_TIME 4 6011
TEST_TIME 5 5959
TEST_TIME 6 5640
TEST_TIME 7 6270
TEST_TIME 8 6228
TEST_TIME 9 6701
TEST_TIME 10 6650
TEST_TIME 11 6726
TEST_TIME 12 6616
TEST_TIME 13 6741
TEST_TIME 14 6812
TEST_TIME 15 6946
TEST_TIME 16 7068
TEST_TIME 17 7217
TEST_TIME 18 7304
TEST_TIME 19 7262
TEST_TIME 20 7227
TEST_TIME 21 7471
TEST_TIME 22 7920
TEST_TIME 23 7973
TEST_TIME 24 8323
TEST_TIME 25 8301
TEST_TIME 26 8366
TEST_TIME 27 8423
TEST_TIME 28 8706
TEST_TIME 29 8785
TEST_TIME 30 8867
TEST_TIME 31 9134
TEST_TIME 32 9542
TEST_TIME 33 9430
TEST_TIME 34 9669
TEST_TIME 35 9895
TEST_TIME 36 10259
TEST_TIME 37 10201
TEST_TIME 38 10054
TEST_TIME 39 10081
TEST_TIME 40 10004
TEST_TIME 41 10046
TEST_TIME 42 10281
TEST_TIME 43 10380
TEST_TIME 44 10284
TEST_TIME 45 10163
TEST_TIME 46 10059
TEST_TIME 47 9912
TEST_TIME 48 9785
TEST_TIME 49 9638
TEST_TIME 50 9492
TEST_TIME 51 9719
TEST_TIME 52 9783
TEST_TIME 53 9763
TEST_TIME 54 9682
TEST_TIME 55 9649
TEST_TIME 56 9612
TEST_TIME 57 9509
TEST_TIME 58 9428
TEST_TIME 59 9337
TEST_TIME 60 9333
TEST_TIME 61 9320
TEST_TIME 62 9288
TEST_TIME 63 9284
TEST_TIME 64 9256
TEST_TIME 65 9218
TEST_TIME 66 9211
TEST_TIME 67 9191
TEST_TIME 68 9101
TEST_TIME 69 9027
TEST_TIME 70 9132
TEST_TIME 71 9141
TEST_TIME 72 9094
TEST_TIME 73 9075
TEST_TIME 74 9078
TEST_TIME 75 9044
TEST_TIME 76 9114
TEST_TIME 77 9197
TEST_TIME 78 9135
TEST_TIME 79 9107
TEST_TIME 80 9127
TEST_TIME 81 9136
TEST_TIME 82 9138
TEST_TIME 83 9193
TEST_TIME 84 9180
TEST_TIME 85 9160
TEST_TIME 86 9065
TEST_TIME 87 8970
TEST_TIME 88 8977
TEST_TIME 89 8919
TEST_TIME 90 8906
TEST_TIME 91 8884
TEST_TIME 92 8815
TEST_TIME 93 8780
TEST_TIME 94 8752
TEST_TIME 95 8755
TEST_TIME 96 8811
TEST_TIME 97 8781
TEST_TIME 98 8792
TEST_TIME 99 8804
TEST_TIME 100 8841
TEST_TIME 101 8859
TEST_TIME 102 8928
TEST_TIME 103 8986
TEST_TIME 104 8995
TEST_TIME 105 8993
TEST_TIME 106 8989
TEST_TIME 107 8925
TEST_TIME 108 8896
TEST_TIME 109 8857
TEST_TIME 110 8896
TEST_TIME 111 8846
TEST_TIME 112 8810
TEST_TIME 113 8786
TEST_TIME 114 8773
TEST_TIME 115 8739
TEST_TIME 116 8715
TEST_TIME 117 8692
TEST_TIME 118 8743
TEST_TIME 119 8743
TEST_TIME 120 8683

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 23-06-2022 04:38:51 to 23-06-2022 04:38:54.

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 1447309 1447309 0 0.00 0 38558 14 0 0
doc_list_biud 1447303 1447303 0 0.00 0 36219 47 0 0
sp_add_invoice_to_stock 4866 4732 134 2.75 57 206081 27343 0 134
sp_cancel_adding_invoice 5230 5230 0 0.00 7 77919 1427 0 0
sp_cancel_client_order 1718 1718 0 0.00 5 11124 508 0 0
sp_cancel_customer_reserve 513848 513848 0 0.00 1 34034 114 0 0
sp_cancel_pay_from_customer 681 681 0 0.00 3 6409 145 0 0
sp_cancel_pay_to_supplier 424 424 0 0.00 4 3080 146 0 0
sp_cancel_supplier_invoice 5820 5808 12 0.20 3 16803 1163 0 12
sp_cancel_supplier_order 394 394 0 0.00 11 1578235 190433 0 0
sp_cancel_write_off 9280 9280 0 0.00 2 36322 184 0 0
sp_client_order 19912 19912 0 0.00 6 19556 506 0 0
sp_customer_reserve 442899 442899 0 0.00 1 131027 256 0 0
sp_fill_shopping_cart 30453 30453 0 0.00 1 16873 88 0 0
sp_fill_shopping_cart_clo_res 442878 442878 0 0.00 0 14225 20 0 0
sp_get_clo_for_invoice 4705 4705 0 0.00 0 27877 296 0 0
sp_kill_cost_storno 15615 15615 0 0.00 0 12161 89 0 0
sp_kill_qstorno_ret_qs2qd 1043178 1043178 0 0.00 0 36214 50 0 0
sp_kill_qty_storno 550637 550637 0 0.00 0 36216 115 0 0
sp_lock_selected_doc 20017 20017 0 0.00 0 10381 9 0 0
sp_make_cost_storno 26634 26634 0 0.00 0 22738 97 0 0
sp_multiply_rows_for_pdistr 26633 26633 0 0.00 0 9221 43 0 0
sp_multiply_rows_for_qdistr 19910 19910 0 0.00 0 17496 187 0 0
sp_pay_from_customer 6721 6721 0 0.00 6 17916 199 0 0
sp_pay_to_supplier 5553 5553 0 0.00 7 20106 218 0 0
sp_payment_common 12273 12273 0 0.00 2 17815 54 0 0
sp_qd_handle_on_cancel_clo 1718 1718 0 0.00 1 11033 420 0 0
sp_qd_handle_on_invoice_upd_sts 9935 9935 0 0.00 0 15890 599 0 0
sp_qd_handle_on_reserve_upd_sts 9654 9654 0 0.00 0 18821 71 0 0
sp_reserve_write_off 9655 9655 0 0.00 9 18865 308 0 0
sp_supplier_invoice 5285 5285 0 0.00 10 84657 3389 0 0
sp_supplier_order 5265 5265 0 0.00 8 23096 1432 0 0
srv_aggregate_perf_data 111 111 0 0.00 2596 238623 19194 0 0
srv_fill_mon_cache_memory 72 72 0 0.00 876 149061 34683 0 0
srv_find_qd_qs_mism 992291 992291 0 0.00 0 38555 10 0 0
srv_make_invnt_saldo 443 443 0 0.00 87 121704 4935 0 0
srv_make_money_saldo 949 949 0 0.00 1 10378 372 0 0
srv_recalc_idx_stat 4 4 0 0.00 106083 377057 268381 0 0
t$perf-abend:sp_add_invoice_to_stock 134 134 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4738 4738 0 0.00 0 24958 1081 0 0
t$perf-norm:sp_cancel_adding_invoice 410 410 0 0.00 2 7205 554 0 0
t$perf-norm:sp_cancel_client_order 1718 1718 0 0.00 0 4870 32 0 0
t$perf-norm:sp_cancel_customer_reserve 698 698 0 0.00 0 9549 57 0 0
t$perf-norm:sp_cancel_pay_from_customer 681 681 0 0.00 0 19102 51 0 0
t$perf-norm:sp_cancel_pay_to_supplier 424 424 0 0.00 0 2562 24 0 0
t$perf-norm:sp_cancel_supplier_invoice 388 388 0 0.00 0 1462 39 0 0
t$perf-norm:sp_cancel_supplier_order 394 394 0 0.00 0 120166 8879 0 0
t$perf-norm:sp_cancel_write_off 947 947 0 0.00 0 2163 29 0 0
t$perf-norm:sp_client_order 19912 19912 0 0.00 0 19233 41 0 0
t$perf-norm:sp_customer_reserve 953 953 0 0.00 0 2185 21 0 0
t$perf-norm:sp_pay_from_customer 6721 6721 0 0.00 0 12854 26 0 0
t$perf-norm:sp_pay_to_supplier 5553 5553 0 0.00 0 3893 21 0 0
t$perf-norm:sp_reserve_write_off 9655 9655 0 0.00 0 25015 26 0 0
t$perf-norm:sp_supplier_invoice 5285 5285 0 0.00 0 7987 38 0 0
t$perf-norm:sp_supplier_order 5265 5265 0 0.00 0 11137 37 0 0
t$perf-norm:srv_aggregate_perf_data 111 111 0 0.00 0 327 24 0 0
t$perf-norm:srv_fill_mon_cache_memory 72 72 0 0.00 0 250 7 0 0
t$perf-norm:srv_make_invnt_saldo 443 443 0 0.00 0 384 12 0 0
t$perf-norm:srv_make_money_saldo 949 949 0 0.00 0 1023 5 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 7 195 79 0 0
v_add_invoice_to_stock 9674 9406 268 2.77 0 13796 26 0 268
v_all_customers 36158 36158 0 0.00 0 109 4 0 0
v_all_suppliers 29252 29252 0 0.00 0 115 4 0 0
v_all_wares 39814 39814 0 0.00 0 134 4 0 0
v_cancel_adding_invoice 820 820 0 0.00 0 575 14 0 0
v_cancel_client_order 3436 3436 0 0.00 0 2724 12 0 0
v_cancel_customer_prepayment 1362 1362 0 0.00 0 1127 11 0 0
v_cancel_customer_reserve 1396 1396 0 0.00 0 830 11 0 0
v_cancel_payment_to_supplier 848 848 0 0.00 0 3035 16 0 0
v_cancel_supplier_invoice 800 776 24 3.00 0 3305 29 0 24
v_cancel_supplier_order 788 788 0 0.00 0 2482 15 0 0
v_cancel_write_off 1894 1894 0 0.00 0 2895 24 0 0
v_max_id_clo_ord 5261 5261 0 0.00 0 558 5 0 0
v_max_id_clo_res 953 953 0 0.00 0 3259 16 0 0
v_max_id_ord_sup 5281 5281 0 0.00 0 1655 5 0 0
v_max_non_paid_invoice 1469 1469 0 0.00 0 141 7 0 0
v_max_non_paid_realizn 3621 3621 0 0.00 0 5003 13 0 0
v_min_id_clo_ord 5261 5261 0 0.00 0 3571 8 0 0
v_min_id_clo_res 953 953 0 0.00 0 960 10 0 0
v_min_id_ord_sup 5281 5281 0 0.00 0 6099 8 0 0
v_min_non_paid_invoice 5553 5553 0 0.00 0 9715 19 0 0
v_min_non_paid_realizn 6720 6720 0 0.00 0 8150 24 0 0
v_our_firm 9852 9852 0 0.00 0 59 5 0 0
v_reserve_write_off 19308 19308 0 0.00 0 2981 11 0 0
x_lock_depdocs_on_canc_invoice 10650 10650 0 0.00 0 37894 142 0 0
x_lock_depdocs_on_canc_sup_ord 394 394 0 0.00 0 9328 438 0 0
x_make_qstorno_1000_1200 5265 5265 0 0.00 3 23056 1250 0 0
x_make_qstorno_1200_2000 5285 5285 0 0.00 4 76423 3153 0 0
x_make_qstorno_2100_3300 442897 442897 0 0.00 0 131025 222 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 23-06-2022 04:38:55 to 23-06-2022 04:38:59.

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
02:07:23 22 8192000000 8807788320 8822321152 10615904 0.129 4 3 4 0 10837344 134464 86976
02:08:24 28511 8192000000 9731944640 10035077120 810756752 9.005 100 88 176 0 838926800 7215088 20954960
02:09:58 28750 8192000000 9784140304 10097553408 857631296 9.476 100 84 168 1 888854160 11487504 19735360
02:11:32 11224 8192000000 9818689424 10140393472 884279472 9.742 100 84 168 1 925119440 21715632 19124336
02:12:54 8912 8192000000 9879810896 10216398848 926927232 10.164 100 73 144 0 987319936 45036288 15356416
02:14:09 4737 8192000000 9922847840 10272256000 971959936 10.606 100 87 168 1 1038232400 48117264 18155200
02:15:17 4031 8192000000 9977408752 10332733440 1001594896 10.894 100 90 176 0 1082548128 62714288 18238944
02:16:23 2712 8192000000 9996215648 10363088896 1024698016 11.117 100 77 152 1 1119102048 79218704 15185328
02:17:29 1536 8192000000 10016693456 10387554304 1040418912 11.269 100 98 190 0 1131650816 71681536 19550368
02:18:32 1012 8192000000 10017841664 10392858624 1053926000 11.398 100 92 180 1 1138714192 66201280 18586912
02:19:34 869 8192000000 10040019152 10417184768 1058753216 11.445 100 98 193 1 1161039472 83250224 19036032
02:20:37 1203 8192000000 10037152864 10421919744 1069893424 11.551 100 97 192 0 1163117616 73451520 19772672
02:21:41 1248 8192000000 10050191344 10433048576 1076669152 11.616 100 94 177 3 1172568432 78748000 17151280
02:22:44 1447 8192000000 10064010960 10447749120 1083459248 11.680 100 97 190 0 1191110160 88371264 19279648
02:23:47 1168 8192000000 10053790592 10437308416 1084542400 11.691 100 94 172 0 1173624416 70641568 18440448
02:24:50 1186 8192000000 10058750112 10450141184 1083711776 11.683 100 92 180 1 1178981952 76929168 18341008
02:25:52 992 8192000000 10040358544 10426155008 1085893968 11.704 100 90 172 1 1162395168 58997760 17503440
02:26:54 1321 8192000000 10052490064 10443739136 1091230544 11.754 100 84 163 2 1173972048 66478992 16262512
02:27:56 1481 8192000000 10074087040 10463408128 1091643952 11.758 100 98 187 2 1190331472 80033584 18653936
02:28:59 1599 8192000000 10031973584 10420928512 1084633920 11.692 100 85 166 0 1159960592 59011744 16314928
02:30:01 1771 8192000000 10026701200 10414751744 1085108768 11.696 100 76 147 1 1149638560 48712496 15817296
02:31:04 1843 8192000000 10017145776 10403733504 1062487568 11.480 100 78 142 3 1142450336 65923232 14039536
02:32:07 1023 8192000000 10014792784 10395070464 1062527152 11.481 100 92 171 0 1136209296 53187824 20494320
02:33:09 1383 8192000000 9987402000 10363547648 1042491040 11.289 100 86 161 5 1109171520 49294672 17385808
02:34:12 916 8192000000 9997449504 10370482176 1035030080 11.217 100 90 175 2 1123661616 69979568 18651968
02:35:13 1237 8192000000 9986956896 10360090624 1042058208 11.284 99 95 179 0 1108556160 47554624 18943328
02:36:16 1064 8192000000 10004536640 10381737984 1048752416 11.349 100 90 172 0 1126040336 57879408 19408512
02:37:18 3274 8192000000 9995477712 10370719744 1042881392 11.292 100 73 135 3 1114492000 58777904 12832704
02:38:28 1196 8192000000 10007818352 10387152896 1064035856 11.495 100 91 172 0 1134872896 52202176 18634864
02:39:33 16406 8192000000 10041634800 10437386240 1089419696 11.737 100 77 149 0 1171159200 66863792 14875712
02:40:53 8453 8192000000 10087718736 10484977664 1101505184 11.852 100 65 126 0 1221155936 106848752 12802000
02:42:08 2507 8192000000 10134606032 10521964544 1117312048 12.002 100 83 158 0 1248442336 114717616 16412672
02:43:15 6777 8192000000 10151265792 10546708480 1122456048 12.050 100 73 139 0 1269238544 131610512 15171984
02:44:25 2802 8192000000 10169088080 10568048640 1128427152 12.107 100 74 143 1 1287268352 143036960 15804240
02:45:33 1041 8192000000 10190740576 10585817088 1134776880 12.166 100 92 175 2 1305963312 151007792 20178640
02:46:38 1838 8192000000 10216202832 10616729600 1147781232 12.289 100 86 161 2 1332900016 166044656 19074128
02:47:44 2950 8192000000 10236618624 10635988992 1159619040 12.400 100 77 150 0 1351476432 175453840 16403552
02:48:52 1168 8192000000 10267419408 10669244416 1162979072 12.431 100 87 164 0 1375349200 193554848 18815280
02:49:58 1877 8192000000 10312312912 10713755648 1172038688 12.516 100 90 172 1 1424437360 232778976 19619696
02:51:04 4905 8192000000 10312867968 10720055296 1174002432 12.534 100 79 154 0 1430070032 237744208 18323392
02:52:15 1164 8192000000 10373757840 10777882624 1183820128 12.626 100 93 181 2 1485012096 280911248 20280720
02:53:19 865 8192000000 10363190432 10791002112 1181471632 12.604 100 92 183 1 1476648384 272709984 22466768
02:54:25 1207 8192000000 10397409648 10806374400 1192633200 12.708 100 86 165 3 1507124768 295602320 18889248
02:55:30 1341 8192000000 10442328208 10862702592 1195177872 12.732 100 94 183 0 1547313040 330137072 21998096
02:56:37 1916 8192000000 10480378944 10891886592 1199058848 12.768 100 93 183 1 1584823504 364143776 21620880
02:57:42 965 8192000000 10501939600 10938216448 1199221984 12.769 100 97 190 1 1605307360 383876640 22208736
02:58:46 1056 8192000000 10479803008 10964279296 1202894176 12.803 100 95 182 0 1590217456 364162000 23161280
02:59:51 1483 8192000000 10479315408 10944425984 1207131296 12.843 100 98 194 0 1583706032 353221920 23352816
03:00:55 1061 8192000000 10497949936 10939498496 1199375552 12.771 100 99 194 2 1601111456 378320960 23414944
03:01:59 1678 8192000000 10490322960 10935214080 1203883072 12.812 100 65 125 0 1599558528 379666112 16009344
03:03:23 6597 8192000000 10507538912 10946695168 1195548432 12.735 100 65 128 1 1607870736 396179072 16143232
03:04:31 15863 8192000000 10496492368 10946805760 1197348352 12.752 100 51 100 0 1594815680 383332016 14135312
03:05:50 21616 8192000000 10460118176 10917953536 1192247808 12.704 100 43 86 1 1592377120 388676448 11452864
03:07:22 16427 8192000000 10425422912 10862571520 1157505776 12.380 100 36 72 0 1529132528 362418752 9208000
03:08:48 16939 8192000000 10337920144 10859028480 1164238560 12.443 100 38 73 1 1479443504 305701952 9502992
03:10:09 8652 8192000000 10341349232 10768252928 1158489152 12.389 100 47 93 0 1446218848 277240112 10489584
03:11:21 10992 8192000000 10319939808 10813472768 1150475312 12.314 100 39 78 0 1433308144 272628464 10204368
03:12:33 5158 8192000000 10285205008 10805981184 1162430768 12.426 100 60 120 2 1414890400 238163408 14296224
03:13:44 37855 8192000000 10182243632 10628468736 1156184880 12.368 99 40 78 2 1325466320 159458944 9822496
03:15:24 11304 8192000000 10213107600 10627198976 1148949152 12.300 99 64 122 2 1300811392 138527008 13335232
03:16:39 37631 8192000000 10250498224 10706423808 1147377712 12.285 99 19 38 2 1351684320 199702848 4603760
03:18:38 59303 8192000000 10174638880 10726076416 1129850768 12.120 99 17 33 0 1247408032 113478208 4079056
03:20:37 64094 8192000000 10062792560 10504142848 1092486928 11.766 96 33 65 0 1140918880 41471984 6959968
03:23:08 55274 8192000000 10064219472 10509660160 1127596432 12.099 100 28 53 0 1154366768 21856992 4913344
03:25:04 79605 8192000000 10108124976 10549432320 1086495312 11.709 96 11 22 1 1137814288 48668944 2650032
03:27:52 78218 8192000000 10089584784 10545987584 1109804672 11.931 98 15 28 1 1235409520 122725184 2879664
03:30:15 123991 8192000000 10107698800 10571120640 1116300432 11.992 98 11 22 0 1152765296 34628000 1836864
03:33:28 99427 8192000000 10098823552 10554175488 1136224976 12.180 99 34 66 1 1191709008 48010592 7473440
03:36:33 44208 8192000000 10155860848 10612269056 1144938592 12.262 100 51 97 0 1243733840 88361152 10434096
03:38:23 61242 8192000000 10084947056 10548613120 1151537920 12.324 100 28 56 2 1197965520 40964400 5463200
03:40:26 12889 8192000000 10082088176 10515992576 1113187520 11.963 98 43 81 2 1169085712 47055568 8842624
03:41:44 4006 8192000000 10124678640 10545143808 1132897936 12.149 100 70 134 1 1222198032 75487552 13812544
03:42:49 149060 8192000000 10135450896 10593357824 1097026704 11.809 96 33 66 0 1200725328 96752480 6946144
03:46:22 107760 8192000000 10098206832 10565312512 1119098816 12.018 99 19 38 1 1255488192 132200064 4189312
03:49:14 70513 8192000000 10067762000 10563833856 1121497840 12.041 99 9 18 0 1180081264 57030800 1552624
03:51:25 94582 8192000000 10145005120 10593435648 1121214352 12.038 97 18 36 2 1176363568 51373248 3775968
03:54:09 89944 8192000000 10060837888 10491346944 1076319952 11.612 94 18 36 1 1116171184 35969472 3881760
03:56:41 31418 8192000000 10113193168 10557345792 1100744064 11.845 97 47 94 2 1187434816 76632720 10058032
03:58:13 33984 8192000000 10067883056 10511888384 1116643792 11.995 99 37 74 0 1192270256 67782432 7844032
03:59:48 39293 8192000000 10120742720 10586300416 1112070832 11.952 98 32 64 0 1203535024 85036816 6427376
04:01:28 18563 8192000000 10074416032 10501087232 1098515376 11.824 97 29 56 3 1122017888 17406752 6095760
04:02:55 129171 8192000000 10097359952 10535849984 1123392400 12.059 99 31 60 1 1195034752 64937104 6705248
04:06:04 89874 8192000000 10074996288 10550538240 1125053584 12.075 99 6 12 0 1167935296 41584288 1297424
04:08:35 51479 8192000000 10079321792 10526773248 1110161872 11.934 97 19 35 3 1145320944 31382784 3776288
04:10:51 40885 8192000000 10133509088 10576945152 1111129856 11.943 97 25 50 1 1200353168 83648816 5574496
04:12:38 31755 8192000000 10155960080 10591670272 1110441232 11.937 97 25 50 1 1219068832 102971808 5655792
04:14:18 26717 8192000000 10163676672 10606022656 1145902448 12.271 100 27 50 1 1264626864 110499616 8224800
04:15:45 29803 8192000000 10184554688 10615808000 1139631056 12.212 99 38 76 1 1275701888 127329024 8741808
04:17:15 52007 8192000000 10155262816 10586877952 1117186096 12.000 98 35 70 0 1230329408 105653552 7489760
04:19:34 71974 8192000000 10093828768 10568949760 1123173744 12.057 100 18 36 0 1239319136 111480784 4664608
04:21:47 33162 8192000000 10090997696 10544574464 1120065968 12.028 99 43 86 2 1211625744 82878960 8680816
04:23:23 20427 8192000000 10119148080 10555068416 1127617392 12.099 99 44 87 0 1191918688 55611024 8690272
04:24:47 67374 8192000000 10111107680 10556403712 1138666112 12.203 100 37 74 1 1204041296 58137712 7237472
04:27:02 37012 8192000000 10078380720 10560782336 1145724432 12.269 100 22 44 0 1211783568 61062112 4997024
04:28:41 59405 8192000000 10085063952 10539282432 1141070032 12.226 99 12 25 0 1180166432 36598848 2497552
04:30:41 42767 8192000000 10065415536 10524151808 1132167728 12.142 99 12 24 0 1167089616 32572816 2349072
04:32:24 68533 8192000000 10106356640 10562113536 1120244736 12.029 98 13 25 1 1202886880 79386752 3255392
04:34:36 19424 8192000000 10163285216 10610049024 1149830592 12.308 100 23 46 2 1256487824 101809600 4847632
04:35:56 50710 8192000000 10150683680 10624438272 1133782768 12.157 98 25 51 1 1259170832 120072720 5315344

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:16, from 23-06-2022 04:39:01 to 23-06-2022 04:39:17.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 134 v_add_invoice_to_stock 335544517
except 12 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 23-06-2022 04:39:18 to 23-06-2022 04:39:20.

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          208450
MON$OLDEST_ACTIVE               215694
MON$OLDEST_SNAPSHOT             215694
MON$NEXT_TRANSACTION            215694
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                       2095424
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             763
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.2.2782 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.2.2782 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.2.2782 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.2.2782 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 ---
:77: 
:78: mscs-test-161.budzdorov.ru    Thu Jun 23 04:37:20 2022
:79:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:80: 
:81: 
:82: mscs-test-161.budzdorov.ru    Thu Jun 23 04:37:27 2022
:83:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:84: 
:85: 
:86: mscs-test-161.budzdorov.ru    Thu Jun 23 04:37:29 2022
:87:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:88: 
:89: 
:90: mscs-test-161.budzdorov.ru    Thu Jun 23 04:37:31 2022
:91:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:92: 
--- end of diff output ---

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

23.06.22 04:39:21. There are 3 logs in /var/tmp/logs-oltp40 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2022-06-23 04:39:24 No severe PSQL-related problems occured
23.06.22 04:39:25. End of report.