Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 29.03.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 16623584 kB
MemAvailable 31618472 kB
Buffers 0 kB
Cached 15099208 kB
SwapCached 2196 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-03-29 13:37:10
DTS_END                         2022-03-29 13:37:10.7330
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/59758
TRN_ID                          209003
ATT_ID                          654
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: 8745.23 26188 1049427
customer order: creation 159.51 511 19141
customer order: refuse 13.78 466 1653
order to supplier: creation 42.89 1492 5147
order to supplier: removal 3.13 193162 375
invoice (draft): creation 42.09 3449 5051
invoice (draft): removal 49.00 1092 5880
invoice accept: apply 39.67 27550 4761
invoice accept: cancel 44.76 1212 5371
customer reserve: creation 3692.41 261 443089
customer reserve: removal 4383.94 108 526073
realization accept: apply 77.53 297 9304
realization accept: cancel 76.60 172 9192
payment from customer: creation 53.23 190 6388
payment from customer: removal 5.20 160 624
payment to supplier: creation 46.40 198 5568
payment to supplier: removal 3.33 125 400
service: total inventory turnovers 3.59 4451 431
service: total monetary turnovers 7.19 367 863
service: aggregate perf. data 0.93 16217 111
service: refresh index statistics 0.04 272280 5

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 29-03-2022 13:38:37 to 29-03-2022 13:38:40.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7330
TEST_TIME 2 5174
TEST_TIME 3 5308
TEST_TIME 4 5152
TEST_TIME 5 5209
TEST_TIME 6 5726
TEST_TIME 7 5566
TEST_TIME 8 5809
TEST_TIME 9 5758
TEST_TIME 10 5797
TEST_TIME 11 5745
TEST_TIME 12 5860
TEST_TIME 13 6224
TEST_TIME 14 6512
TEST_TIME 15 6593
TEST_TIME 16 6976
TEST_TIME 17 7071
TEST_TIME 18 7282
TEST_TIME 19 7319
TEST_TIME 20 7617
TEST_TIME 21 7866
TEST_TIME 22 7824
TEST_TIME 23 7926
TEST_TIME 24 8102
TEST_TIME 25 8387
TEST_TIME 26 8478
TEST_TIME 27 8465
TEST_TIME 28 8631
TEST_TIME 29 9285
TEST_TIME 30 9517
TEST_TIME 31 9468
TEST_TIME 32 9781
TEST_TIME 33 10249
TEST_TIME 34 10464
TEST_TIME 35 10392
TEST_TIME 36 10402
TEST_TIME 37 10245
TEST_TIME 38 10099
TEST_TIME 39 10176
TEST_TIME 40 10091
TEST_TIME 41 9975
TEST_TIME 42 9874
TEST_TIME 43 9868
TEST_TIME 44 9767
TEST_TIME 45 9783
TEST_TIME 46 9708
TEST_TIME 47 9691
TEST_TIME 48 9744
TEST_TIME 49 9613
TEST_TIME 50 9500
TEST_TIME 51 9473
TEST_TIME 52 9519
TEST_TIME 53 9457
TEST_TIME 54 9553
TEST_TIME 55 9522
TEST_TIME 56 9504
TEST_TIME 57 9575
TEST_TIME 58 9501
TEST_TIME 59 9494
TEST_TIME 60 9396
TEST_TIME 61 9589
TEST_TIME 62 9532
TEST_TIME 63 9581
TEST_TIME 64 9675
TEST_TIME 65 9755
TEST_TIME 66 9646
TEST_TIME 67 9545
TEST_TIME 68 9530
TEST_TIME 69 9532
TEST_TIME 70 9441
TEST_TIME 71 9339
TEST_TIME 72 9259
TEST_TIME 73 9240
TEST_TIME 74 9151
TEST_TIME 75 9055
TEST_TIME 76 9042
TEST_TIME 77 9102
TEST_TIME 78 9062
TEST_TIME 79 9011
TEST_TIME 80 8960
TEST_TIME 81 8917
TEST_TIME 82 8906
TEST_TIME 83 8954
TEST_TIME 84 8961
TEST_TIME 85 8899
TEST_TIME 86 8903
TEST_TIME 87 9012
TEST_TIME 88 9125
TEST_TIME 89 9248
TEST_TIME 90 9272
TEST_TIME 91 9216
TEST_TIME 92 9132
TEST_TIME 93 9134
TEST_TIME 94 9180
TEST_TIME 95 9134
TEST_TIME 96 9098
TEST_TIME 97 9042
TEST_TIME 98 9036
TEST_TIME 99 8989
TEST_TIME 100 9016
TEST_TIME 101 9001
TEST_TIME 102 8990
TEST_TIME 103 8971
TEST_TIME 104 8961
TEST_TIME 105 8964
TEST_TIME 106 8983
TEST_TIME 107 8961
TEST_TIME 108 9045
TEST_TIME 109 9035
TEST_TIME 110 9042
TEST_TIME 111 9040
TEST_TIME 112 9010
TEST_TIME 113 8955
TEST_TIME 114 8943
TEST_TIME 115 8919
TEST_TIME 116 8867
TEST_TIME 117 8845
TEST_TIME 118 8847
TEST_TIME 119 8818
TEST_TIME 120 8769

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 29-03-2022 13:38:41 to 29-03-2022 13:38:44.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1457168 1457168 0 0.00 0 16656 14 0 0
doc_list_biud 1457162 1457162 0 0.00 0 62251 45 0 0
sp_add_invoice_to_stock 4883 4761 122 2.49 79 279391 27551 0 122
sp_cancel_adding_invoice 5371 5371 0 0.00 7 89772 1212 0 0
sp_cancel_client_order 1653 1653 0 0.00 5 13429 467 0 0
sp_cancel_customer_reserve 526073 526073 0 0.00 1 47378 108 0 0
sp_cancel_pay_from_customer 624 624 0 0.00 4 11285 161 0 0
sp_cancel_pay_to_supplier 400 400 0 0.00 3 4965 125 0 0
sp_cancel_supplier_invoice 5888 5880 8 0.13 3 62258 1093 0 8
sp_cancel_supplier_order 375 375 0 0.00 6 1371622 193162 0 0
sp_cancel_write_off 9192 9192 0 0.00 2 11594 172 0 0
sp_client_order 19141 19141 0 0.00 6 47884 511 0 0
sp_customer_reserve 443089 443089 0 0.00 1 42212 261 0 0
sp_fill_shopping_cart 29331 29331 0 0.00 1 19989 86 0 0
sp_fill_shopping_cart_clo_res 443067 443067 0 0.00 0 11455 22 0 0
sp_get_clo_for_invoice 4728 4728 0 0.00 0 34242 320 0 0
sp_kill_cost_storno 15587 15587 0 0.00 0 6989 81 0 0
sp_kill_qstorno_ret_qs2qd 1067593 1067593 0 0.00 0 62249 48 0 0
sp_kill_qty_storno 562575 562575 0 0.00 0 62251 109 0 0
sp_lock_selected_doc 19413 19413 0 0.00 0 11521 10 0 0
sp_make_cost_storno 25987 25987 0 0.00 0 10959 89 0 0
sp_multiply_rows_for_pdistr 25986 25986 0 0.00 0 16640 43 0 0
sp_multiply_rows_for_qdistr 19141 19141 0 0.00 0 34809 197 0 0
sp_pay_from_customer 6388 6388 0 0.00 6 11415 191 0 0
sp_pay_to_supplier 5568 5568 0 0.00 6 16661 199 0 0
sp_payment_common 11955 11955 0 0.00 2 8116 45 0 0
sp_qd_handle_on_cancel_clo 1653 1653 0 0.00 0 13416 389 0 0
sp_qd_handle_on_invoice_upd_sts 10098 10098 0 0.00 0 43677 541 0 0
sp_qd_handle_on_reserve_upd_sts 9304 9304 0 0.00 0 24082 64 0 0
sp_reserve_write_off 9304 9304 0 0.00 9 24149 298 0 0
sp_supplier_invoice 5051 5051 0 0.00 12 106855 3450 0 0
sp_supplier_order 5147 5147 0 0.00 8 63223 1493 0 0
srv_aggregate_perf_data 111 111 0 0.00 2412 135425 16217 0 0
srv_fill_mon_cache_memory 73 73 0 0.00 776 151748 33289 0 0
srv_find_qd_qs_mism 1003394 1003394 0 0.00 0 12181 11 0 0
srv_make_invnt_saldo 431 431 0 0.00 91 57221 4451 0 0
srv_make_money_saldo 863 863 0 0.00 1 11159 368 0 0
srv_recalc_idx_stat 5 5 0 0.00 81327 527230 272280 0 0
t$perf-abend:sp_add_invoice_to_stock 122 122 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4767 4767 0 0.00 1 11035 950 0 0
t$perf-norm:sp_cancel_adding_invoice 397 397 0 0.00 2 6864 471 0 0
t$perf-norm:sp_cancel_client_order 1653 1653 0 0.00 0 4057 30 0 0
t$perf-norm:sp_cancel_customer_reserve 662 662 0 0.00 0 1716 28 0 0
t$perf-norm:sp_cancel_pay_from_customer 624 624 0 0.00 0 1611 16 0 0
t$perf-norm:sp_cancel_pay_to_supplier 400 400 0 0.00 0 878 16 0 0
t$perf-norm:sp_cancel_supplier_invoice 367 367 0 0.00 0 2592 55 0 0
t$perf-norm:sp_cancel_supplier_order 375 375 0 0.00 0 109196 8469 0 0
t$perf-norm:sp_cancel_write_off 906 906 0 0.00 0 1486 21 0 0
t$perf-norm:sp_client_order 19141 19141 0 0.00 0 8930 39 0 0
t$perf-norm:sp_customer_reserve 940 940 0 0.00 0 746 13 0 0
t$perf-norm:sp_pay_from_customer 6390 6390 0 0.00 0 5316 22 0 0
t$perf-norm:sp_pay_to_supplier 5568 5568 0 0.00 0 4767 21 0 0
t$perf-norm:sp_reserve_write_off 9304 9304 0 0.00 0 10282 27 0 0
t$perf-norm:sp_supplier_invoice 5051 5051 0 0.00 0 8958 36 0 0
t$perf-norm:sp_supplier_order 5147 5147 0 0.00 0 6956 35 0 0
t$perf-norm:srv_aggregate_perf_data 111 111 0 0.00 0 538 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 73 73 0 0.00 0 547 11 0 0
t$perf-norm:srv_make_invnt_saldo 431 431 0 0.00 0 1029 16 0 0
t$perf-norm:srv_make_money_saldo 863 863 0 0.00 0 774 6 0 0
t$perf-norm:srv_recalc_idx_stat 5 5 0 0.00 3 217 55 0 0
v_add_invoice_to_stock 9694 9450 244 2.51 0 7037 26 0 244
v_all_customers 35278 35278 0 0.00 0 117 4 0 0
v_all_suppliers 28734 28734 0 0.00 0 74 4 0 0
v_all_wares 38282 38282 0 0.00 0 70 4 0 0
v_cancel_adding_invoice 794 794 0 0.00 0 2220 19 0 0
v_cancel_client_order 3306 3306 0 0.00 0 2159 10 0 0
v_cancel_customer_prepayment 1248 1248 0 0.00 0 5293 20 0 0
v_cancel_customer_reserve 1324 1324 0 0.00 0 5822 14 0 0
v_cancel_payment_to_supplier 800 800 0 0.00 0 888 11 0 0
v_cancel_supplier_invoice 750 734 16 2.13 0 3314 29 0 16
v_cancel_supplier_order 750 750 0 0.00 0 2964 16 0 0
v_cancel_write_off 1812 1812 0 0.00 0 4171 24 0 0
v_max_id_clo_ord 5142 5142 0 0.00 0 136 5 0 0
v_max_id_clo_res 940 940 0 0.00 0 3877 17 0 0
v_max_id_ord_sup 5046 5046 0 0.00 0 9271 8 0 0
v_max_non_paid_invoice 1388 1388 0 0.00 0 120 7 0 0
v_max_non_paid_realizn 3160 3160 0 0.00 0 3060 8 0 0
v_min_id_clo_ord 5142 5142 0 0.00 0 3042 8 0 0
v_min_id_clo_res 940 940 0 0.00 0 1271 10 0 0
v_min_id_ord_sup 5046 5046 0 0.00 0 12853 11 0 0
v_min_non_paid_invoice 5567 5567 0 0.00 0 6968 18 0 0
v_min_non_paid_realizn 6388 6388 0 0.00 0 8107 15 0 0
v_our_firm 9460 9460 0 0.00 0 86 4 0 0
v_reserve_write_off 18608 18608 0 0.00 0 3409 10 0 0
x_lock_depdocs_on_canc_invoice 10884 10884 0 0.00 0 13399 120 0 0
x_lock_depdocs_on_canc_sup_ord 375 375 0 0.00 0 17266 453 0 0
x_make_qstorno_1000_1200 5147 5147 0 0.00 3 63197 1322 0 0
x_make_qstorno_1200_2000 5051 5051 0 0.00 5 106801 3209 0 0
x_make_qstorno_2100_3300 443088 443088 0 0.00 0 42205 226 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 29-03-2022 13:38:45 to 29-03-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:14 2 8192000000 8796669024 8807174144 3189120 0.038 1 1 2 0 3286736 61840 35776
11:08:15 21543 8192000000 9709812608 10004037632 787772176 8.772 100 90 180 0 818172368 7433616 22966576
11:09:42 28346 8192000000 9759107280 10063314944 828015072 9.179 100 92 184 0 861814576 11460240 22339264
11:11:19 16075 8192000000 9792084192 10108227584 855773184 9.458 100 86 172 0 899009296 23322896 19913216
11:12:39 15041 8192000000 9854731904 10187771904 907990544 9.977 100 79 158 1 964192736 38402592 17799600
11:13:59 8741 8192000000 9919987376 10264248320 958072480 10.470 100 75 150 0 1032110000 58440096 15597424
11:15:11 3396 8192000000 9953119072 10306940928 992682080 10.808 100 90 177 0 1067515872 57355648 17478144
11:16:19 4001 8192000000 9986730816 10347806720 1015279824 11.026 100 93 178 1 1112968592 80382608 17306160
11:17:26 1031 8192000000 10022324512 10393255936 1046211504 11.324 100 95 183 1 1140211952 75598528 18401920
11:18:28 1352 8192000000 10040636208 10413256704 1059063728 11.448 100 98 185 0 1158327728 81045440 18218560
11:19:32 899 8192000000 10054239232 10428350464 1071814272 11.569 100 98 192 1 1173696384 83435008 18447104
11:20:34 1147 8192000000 10017058352 10396475392 1069903248 11.551 100 86 167 0 1139680800 52472384 17305168
11:21:36 1136 8192000000 10054105984 10441052160 1077219504 11.621 100 97 185 1 1179656640 83701360 18735776
11:22:39 1258 8192000000 10061267152 10446876672 1086471360 11.709 100 94 178 0 1181363024 76506400 18385264
11:23:41 966 8192000000 10061942256 10456514560 1093649712 11.777 100 85 173 0 1181691952 70790944 17251296
11:24:43 1462 8192000000 10041434816 10432819200 1100863504 11.846 100 83 162 1 1170734144 53099120 16771520
11:25:45 1411 8192000000 10070365552 10462916608 1100054128 11.838 100 82 149 2 1192379792 76652688 15672976
11:26:48 1086 8192000000 10065979408 10461253632 1101595248 11.853 100 78 149 0 1184010912 66690320 15725344
11:27:50 1084 8192000000 10049448720 10441494528 1100264928 11.840 100 82 157 1 1173065024 55375824 17424272
11:28:52 927 8192000000 10067394608 10457899008 1102281920 11.859 100 97 187 2 1189156304 68092144 18782240
11:29:54 6175 8192000000 10034698752 10432446464 1093792128 11.779 100 75 144 1 1158666880 50208368 14666384
11:31:02 1027 8192000000 10068682016 10454548480 1089763264 11.740 100 96 188 1 1189679536 80316128 19600144
11:32:03 931 8192000000 10036059776 10421796864 1056823296 11.426 100 81 149 2 1159181088 86911152 15446640
11:33:06 1103 8192000000 10043489440 10424782848 1067294384 11.526 100 90 169 2 1170545840 85482000 17769456
11:34:08 1266 8192000000 9995020816 10372714496 1042589520 11.290 100 80 156 0 1110265632 51653152 16022960
11:35:10 1349 8192000000 9984230416 10361212928 1039369216 11.259 99 76 141 1 1107213648 52703488 15140944
11:36:13 1999 8192000000 9954286960 10329198592 1011420832 10.989 99 73 134 3 1085203968 58802416 14980720
11:37:17 774 8192000000 9965023840 10339475456 1028773136 11.157 100 75 134 1 1091367888 49540448 13054304
11:38:30 5308 8192000000 9989565360 10371862528 1041009184 11.274 100 62 111 3 1109095968 56631200 11455584
11:39:43 16489 8192000000 10033442064 10416332800 1063666464 11.492 100 66 130 2 1149661056 73170912 12823680
11:41:05 8958 8192000000 10077360864 10459447296 1077147872 11.620 100 72 138 1 1190592032 99260528 14183632
11:42:21 8126 8192000000 10110384864 10491715584 1097274448 11.812 100 76 149 4 1229655280 115341968 17038864
11:43:34 5632 8192000000 10124349568 10519089152 1114197552 11.972 100 82 151 0 1238701824 109609600 14894672
11:44:45 2760 8192000000 10179090896 10579943424 1121410096 12.040 100 85 163 0 1305980336 166190640 18379600
11:45:54 2693 8192000000 10178658064 10589175808 1127814128 12.101 100 56 112 0 1297358528 156709696 12834704
11:47:04 4695 8192000000 10246528720 10644525056 1144177456 12.255 100 69 138 0 1354558256 194742400 15638400
11:48:16 6028 8192000000 10269382656 10668720128 1156082656 12.367 100 81 160 0 1382530944 207193184 19255104
11:49:28 2736 8192000000 10306565824 10713657344 1170814640 12.504 100 81 160 0 1419613424 229784960 19013824
11:50:33 1292 8192000000 10318967664 10730967040 1172922112 12.524 100 87 166 1 1428743552 236598528 19222912
11:51:38 1336 8192000000 10364667264 10771701760 1186316544 12.649 100 93 179 2 1473995744 267166656 20512544
11:52:43 1189 8192000000 10393871680 10818121728 1183138320 12.619 100 90 178 0 1501012064 297574096 20299648
11:53:47 1242 8192000000 10408242512 10815639552 1183656576 12.624 100 99 191 2 1517818864 311320448 22841840
11:54:53 1506 8192000000 10424513760 10843553792 1192139248 12.703 100 95 185 0 1533016032 319339184 21537600
11:55:56 1071 8192000000 10453991776 10869899264 1187315328 12.658 100 95 186 1 1557411296 348253840 21842128
11:57:02 924 8192000000 10460877248 10903941120 1191489440 12.697 100 98 194 0 1566507488 352411440 22606608
11:58:06 1429 8192000000 10450074032 10870345728 1186790688 12.653 100 93 183 2 1558998128 348750256 23457184
11:59:10 2842 8192000000 10471188624 10905165824 1189555584 12.679 100 76 144 1 1578451968 370729616 18166768
12:00:21 6082 8192000000 10497116800 10940334080 1178598864 12.577 100 64 124 0 1603787840 408258096 16930880
12:01:31 5205 8192000000 10501779024 10969485312 1181620512 12.605 100 75 144 0 1608157440 408259888 18277040
12:02:41 824 8192000000 10486025696 10937901056 1182635344 12.615 100 65 123 0 1589050080 391899344 14515392
12:03:49 6993 8192000000 10450394608 10895908864 1167984288 12.478 100 57 110 2 1553399280 371726368 13688624
12:05:24 3138 8192000000 10469467024 10939039744 1151787200 12.326 100 72 140 1 1587037168 418456336 16793632
12:06:30 16965 8192000000 10342175248 10778578944 1127546432 12.098 99 47 87 1 1451204560 312467488 11190640
12:08:06 16983 8192000000 10316275712 10812506112 1132941216 12.149 100 30 59 1 1447687920 307205536 7541168
12:09:28 24543 8192000000 10169177312 10682978304 1111837648 11.950 99 19 36 2 1330041488 213839392 4364448
12:10:58 28265 8192000000 10101062832 10540711936 1131375824 12.134 100 19 38 0 1222484096 87209040 3899232
12:12:31 12517 8192000000 10119330016 10548326400 1146482032 12.276 100 60 114 2 1208359200 47929008 13948160
12:13:47 33065 8192000000 10126572032 10566807552 1145126016 12.264 100 38 72 1 1222050880 69156096 7768768
12:15:21 27359 8192000000 10170527792 10601713664 1099258048 11.831 97 35 70 0 1240733520 133410352 8065120
12:16:49 151748 8192000000 10084220432 10557022208 1115273568 11.982 99 28 52 1 1173858208 52379312 6205328
12:20:24 40032 8192000000 10115089776 10555101184 1140396048 12.219 100 41 77 2 1222343056 73318768 8628240
12:22:05 35576 8192000000 10160354496 10625343488 1145241968 12.265 100 34 62 1 1251387648 99219888 6925792
12:23:57 58201 8192000000 10139984928 10619392000 1138212928 12.199 99 16 32 0 1243424160 101947872 3263360
12:25:57 42243 8192000000 10100947936 10555621376 1126150016 12.085 99 16 32 0 1196107888 66370752 3587120
12:28:26 66573 8192000000 10151890768 10615459840 1124560896 12.070 99 26 51 2 1237289216 107024560 5703760
12:30:34 80757 8192000000 10088858464 10552950784 1117106304 12.000 99 19 38 1 1183196704 61224112 4866288
12:33:04 12268 8192000000 10081521008 10526887936 1126409376 12.088 100 48 93 1 1179803856 43551968 9842512
12:34:17 29106 8192000000 10070871600 10523340800 1113754448 11.968 99 25 50 0 1163269760 44107840 5407472
12:36:11 52444 8192000000 10158941472 10621009920 1138529728 12.202 100 21 42 0 1265570624 122639472 4401424
12:38:10 33282 8192000000 10123133184 10568499200 1128532768 12.108 99 21 41 1 1203881312 70063264 5285280
12:40:13 22318 8192000000 10148418288 10588381184 1154540976 12.352 100 31 62 0 1246259520 85446464 6272080
12:41:40 56806 8192000000 10076591296 10543894528 1124668112 12.071 98 18 36 3 1193202176 64918224 3615840
12:43:38 103261 8192000000 10130674192 10574635008 1135373200 12.172 99 32 64 0 1222549936 80581280 6595456
12:46:23 41971 8192000000 10038443744 10516844544 1118405360 12.012 99 9 18 0 1153906656 33867280 1634016
12:48:07 52499 8192000000 10084958512 10535395328 1121875952 12.045 98 23 45 2 1158365360 30889232 5600176
12:50:02 101095 8192000000 10122720016 10604306432 1112719440 11.958 97 17 32 3 1171321808 54717216 3885152
12:52:43 89165 8192000000 10116450224 10600009728 1150401344 12.313 100 31 63 0 1239049200 82226400 6421456
12:55:16 49431 8192000000 10058790512 10495221760 1091310752 11.755 95 16 32 0 1125446352 30865216 3270384
12:57:05 32943 8192000000 10153820288 10592493568 1154461184 12.351 100 32 64 1 1245564352 84420256 6682912
12:58:39 18225 8192000000 10192488528 10626625536 1155736624 12.363 100 45 87 1 1289188896 124148672 9303600
13:00:07 35442 8192000000 10215381824 10669817856 1127008368 12.093 98 37 74 1 1311563168 176092048 8462752
13:01:47 48979 8192000000 10246567712 10670579712 1127810272 12.101 99 50 100 1 1298354944 159698816 10845856
13:03:40 59956 8192000000 10251072544 10763317248 1147546784 12.286 100 32 64 1 1381149552 226390736 7212032
13:06:06 49400 8192000000 10110694288 10577756160 1082482736 11.671 96 18 36 0 1198216896 111886800 3847360
13:07:59 123940 8192000000 10158563024 10592256000 1124420000 12.069 99 55 109 0 1228896528 92909824 11566704
13:11:04 35734 8192000000 10083232240 10577043456 1130857776 12.129 100 27 54 0 1239953072 103020656 6074640
13:12:40 64478 8192000000 10053134080 10516738048 1113863968 11.969 98 11 21 0 1148052976 32438784 1750224
13:14:47 60587 8192000000 10069841392 10529333248 1093859792 11.779 96 15 30 0 1122581808 25792464 2929552
13:16:48 33316 8192000000 10068168160 10544226304 1125611392 12.080 99 22 44 3 1189896816 58680736 5604688
13:18:32 25886 8192000000 10097485968 10540486656 1143624736 12.250 100 28 56 1 1198487024 48937040 5925248
13:19:58 28102 8192000000 10136309072 10577223680 1147294000 12.284 99 37 73 2 1223584896 68103120 8187776
13:21:27 23105 8192000000 10164377776 10595794944 1137329408 12.190 98 53 102 3 1234755888 85291792 12134688
13:22:57 53373 8192000000 10166131344 10616696832 1115368448 11.983 96 35 70 1 1244689904 121496096 7825360
13:25:06 51853 8192000000 10063593664 10516525056 1102769728 11.864 97 29 58 1 1182731520 73356368 6605424
13:27:02 14582 8192000000 10109021632 10532040704 1132560592 12.145 100 56 112 1 1197940096 53855408 11524096
13:28:18 22455 8192000000 10122272480 10578558976 1124364672 12.068 99 49 94 1 1207058256 73053056 9640528
13:29:48 104354 8192000000 10075504864 10531426304 1108375840 11.917 98 44 88 1 1163776624 46386752 9014032
13:32:35 78599 8192000000 10061139376 10524569600 1106865888 11.903 99 8 16 1 1154657280 46098992 1692400
13:34:54 53880 8192000000 10055681344 10529787904 1126613392 12.089 100 13 27 0 1162144128 32879920 2650816
13:36:48 32815 8192000000 8955219040 9148141568 105761552 1.274 10 3 6 0 129857824 23465584 630688

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:17, from 29-03-2022 13:38:51 to 29-03-2022 13:39:08.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 122 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 29-03-2022 13:39:09 to 29-03-2022 13:39:10.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          206909
MON$OLDEST_ACTIVE               209474
MON$OLDEST_SNAPSHOT             209474
MON$NEXT_TRANSACTION            209474
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                       2047072
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             755
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.2.2745 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.2.2745 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.2.2745 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.2.2745 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 ---
:184: 
:185: mscs-test-161.budzdorov.ru    Tue Mar 29 13:37:24 2022
:186:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:187: 
--- end of diff output ---

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

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