Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 09.10.2021 13:37
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 15569680 kB
MemAvailable 30678556 kB
Buffers 0 kB
Cached 16102540 kB
SwapCached 3840 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-09 13:37:24
DTS_END                         2021-10-09 13:37:06.8590
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_FILL_MON_CACHE_MEMORY(20:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/48130
TRN_ID                          235030
ATT_ID                          259
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: 9231.92 24298 1107831
customer order: creation 166.46 431 19975
customer order: refuse 15.10 313 1812
order to supplier: creation 45.71 1298 5485
order to supplier: removal 3.33 120587 399
invoice (draft): creation 44.90 3469 5388
invoice (draft): removal 53.38 895 6405
invoice accept: apply 41.58 17767 4990
invoice accept: cancel 48.55 869 5826
customer reserve: creation 3802.17 176 456260
customer reserve: removal 4713.22 68 565586
realization accept: apply 81.27 172 9752
realization accept: cancel 90.76 113 10891
payment from customer: creation 57.83 106 6940
payment from customer: removal 5.45 68 654
payment to supplier: creation 47.74 133 5729
payment to supplier: removal 3.38 107 405
service: total inventory turnovers 4.14 3207 497
service: total monetary turnovers 6.12 486 734
service: aggregate perf. data 0.83 16152 99
service: refresh index statistics 0.03 319537 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 09-10-2021 13:37:53 to 09-10-2021 13:37:55.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6415
TEST_TIME 2 4144
TEST_TIME 3 3595
TEST_TIME 4 3895
TEST_TIME 5 4438
TEST_TIME 6 4270
TEST_TIME 7 4441
TEST_TIME 8 4605
TEST_TIME 9 4903
TEST_TIME 10 5103
TEST_TIME 11 5695
TEST_TIME 12 6225
TEST_TIME 13 6789
TEST_TIME 14 7286
TEST_TIME 15 7769
TEST_TIME 16 8099
TEST_TIME 17 8797
TEST_TIME 18 9074
TEST_TIME 19 9541
TEST_TIME 20 9379
TEST_TIME 21 9793
TEST_TIME 22 9851
TEST_TIME 23 9766
TEST_TIME 24 9799
TEST_TIME 25 10061
TEST_TIME 26 10077
TEST_TIME 27 10384
TEST_TIME 28 11247
TEST_TIME 29 12058
TEST_TIME 30 11901
TEST_TIME 31 11654
TEST_TIME 32 11473
TEST_TIME 33 11263
TEST_TIME 34 10983
TEST_TIME 35 10950
TEST_TIME 36 10721
TEST_TIME 37 10645
TEST_TIME 38 10711
TEST_TIME 39 10730
TEST_TIME 40 10533
TEST_TIME 41 10442
TEST_TIME 42 10419
TEST_TIME 43 10354
TEST_TIME 44 10341
TEST_TIME 45 10215
TEST_TIME 46 10124
TEST_TIME 47 10028
TEST_TIME 48 9954
TEST_TIME 49 9824
TEST_TIME 50 9666
TEST_TIME 51 9672
TEST_TIME 52 9768
TEST_TIME 53 9732
TEST_TIME 54 9692
TEST_TIME 55 9757
TEST_TIME 56 9780
TEST_TIME 57 9767
TEST_TIME 58 9701
TEST_TIME 59 9685
TEST_TIME 60 9834
TEST_TIME 61 9990
TEST_TIME 62 10002
TEST_TIME 63 9970
TEST_TIME 64 9842
TEST_TIME 65 9846
TEST_TIME 66 9753
TEST_TIME 67 9696
TEST_TIME 68 9622
TEST_TIME 69 9609
TEST_TIME 70 9569
TEST_TIME 71 9503
TEST_TIME 72 9538
TEST_TIME 73 9607
TEST_TIME 74 9631
TEST_TIME 75 9566
TEST_TIME 76 9532
TEST_TIME 77 9484
TEST_TIME 78 9577
TEST_TIME 79 9556
TEST_TIME 80 9571
TEST_TIME 81 9520
TEST_TIME 82 9432
TEST_TIME 83 9382
TEST_TIME 84 9340
TEST_TIME 85 9287
TEST_TIME 86 9225
TEST_TIME 87 9240
TEST_TIME 88 9248
TEST_TIME 89 9244
TEST_TIME 90 9211
TEST_TIME 91 9176
TEST_TIME 92 9217
TEST_TIME 93 9263
TEST_TIME 94 9378
TEST_TIME 95 9354
TEST_TIME 96 9352
TEST_TIME 97 9392
TEST_TIME 98 9362
TEST_TIME 99 9431
TEST_TIME 100 9479
TEST_TIME 101 9496
TEST_TIME 102 9409
TEST_TIME 103 9344
TEST_TIME 104 9340
TEST_TIME 105 9310
TEST_TIME 106 9256
TEST_TIME 107 9190
TEST_TIME 108 9225
TEST_TIME 109 9207
TEST_TIME 110 9188
TEST_TIME 111 9186
TEST_TIME 112 9161
TEST_TIME 113 9155
TEST_TIME 114 9141
TEST_TIME 115 9197
TEST_TIME 116 9194
TEST_TIME 117 9277
TEST_TIME 118 9276
TEST_TIME 119 9304
TEST_TIME 120 9235

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 09-10-2021 13:37:57 to 09-10-2021 13:38:00.

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 1530017 1530017 0 0.00 0 33925 7 0 0
doc_list_biud 1530017 1530017 0 0.00 0 48674 31 0 0
sp_add_invoice_to_stock 5092 4990 102 2.00 43 199483 17768 0 102
sp_cancel_adding_invoice 5826 5826 0 0.00 6 80972 869 0 0
sp_cancel_client_order 1812 1812 0 0.00 4 8635 313 0 0
sp_cancel_customer_reserve 565586 565586 0 0.00 1 34334 68 0 0
sp_cancel_pay_from_customer 654 654 0 0.00 3 4769 68 0 0
sp_cancel_pay_to_supplier 405 405 0 0.00 3 7067 108 0 0
sp_cancel_supplier_invoice 6417 6405 12 0.18 3 40883 895 0 12
sp_cancel_supplier_order 399 399 0 0.00 7 996593 120587 0 0
sp_cancel_write_off 10891 10891 0 0.00 1 31753 113 0 0
sp_client_order 19975 19975 0 0.00 4 32635 432 0 0
sp_customer_reserve 456260 456260 0 0.00 0 119582 176 0 0
sp_fill_shopping_cart 30844 30844 0 0.00 1 25132 43 0 0
sp_fill_shopping_cart_clo_res 456255 456255 0 0.00 0 36537 18 0 0
sp_get_clo_for_invoice 4985 4985 0 0.00 0 36020 405 0 0
sp_kill_cost_storno 17776 17776 0 0.00 0 13093 56 0 0
sp_kill_qstorno_ret_qs2qd 1148867 1148867 0 0.00 0 40875 37 0 0
sp_kill_qty_storno 605656 605656 0 0.00 0 48674 78 0 0
sp_lock_selected_doc 20464 20464 0 0.00 0 7063 4 0 0
sp_make_cost_storno 27406 27406 0 0.00 0 30191 54 0 0
sp_multiply_rows_for_pdistr 27406 27406 0 0.00 0 11512 36 0 0
sp_multiply_rows_for_qdistr 19975 19975 0 0.00 0 25126 215 0 0
sp_pay_from_customer 6940 6940 0 0.00 4 16271 106 0 0
sp_pay_to_supplier 5729 5729 0 0.00 5 19346 133 0 0
sp_payment_common 12669 12669 0 0.00 1 15172 24 0 0
sp_qd_handle_on_cancel_clo 1812 1812 0 0.00 0 8627 293 0 0
sp_qd_handle_on_invoice_upd_sts 10811 10811 0 0.00 0 48674 363 0 0
sp_qd_handle_on_reserve_upd_sts 9752 9752 0 0.00 0 13400 56 0 0
sp_reserve_write_off 9752 9752 0 0.00 7 30223 173 0 0
sp_supplier_invoice 5388 5388 0 0.00 7 88703 3470 0 0
sp_supplier_order 5485 5485 0 0.00 5 25127 1299 0 0
srv_aggregate_perf_data 100 99 1 1.00 2977 123342 16153 0 1
srv_fill_mon_cache_memory 62 62 0 0.00 1247 145196 48164 0 0
srv_find_qd_qs_mism 1060976 1060976 0 0.00 0 33925 6 0 0
srv_make_invnt_saldo 497 497 0 0.00 58 114806 3208 0 0
srv_make_money_saldo 734 734 0 0.00 0 11243 486 0 0
srv_recalc_idx_stat 4 4 0 0.00 175114 411806 319538 0 0
t$perf-abend:sp_add_invoice_to_stock 102 102 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4990 4990 0 0.00 0 43172 194 0 0
t$perf-norm:sp_cancel_adding_invoice 400 400 0 0.00 0 7309 154 0 0
t$perf-norm:sp_cancel_client_order 1812 1812 0 0.00 0 41828 35 0 0
t$perf-norm:sp_cancel_customer_reserve 678 678 0 0.00 0 1414 11 0 0
t$perf-norm:sp_cancel_pay_from_customer 654 654 0 0.00 0 2557 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 405 405 0 0.00 0 1942 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 402 402 0 0.00 0 4344 21 0 0
t$perf-norm:sp_cancel_supplier_order 399 399 0 0.00 0 21867 1570 0 0
t$perf-norm:sp_cancel_write_off 977 977 0 0.00 0 546 4 0 0
t$perf-norm:sp_client_order 19975 19975 0 0.00 0 36290 18 0 0
t$perf-norm:sp_customer_reserve 981 981 0 0.00 0 1578 5 0 0
t$perf-norm:sp_pay_from_customer 6940 6940 0 0.00 0 7977 15 0 0
t$perf-norm:sp_pay_to_supplier 5729 5729 0 0.00 0 42263 17 0 0
t$perf-norm:sp_reserve_write_off 9752 9752 0 0.00 0 12218 11 0 0
t$perf-norm:sp_supplier_invoice 5388 5388 0 0.00 0 7861 18 0 0
t$perf-norm:sp_supplier_order 5485 5485 0 0.00 0 40762 22 0 0
t$perf-norm:srv_aggregate_perf_data 99 99 0 0.00 0 287 4 0 0
t$perf-norm:srv_fill_mon_cache_memory 62 62 0 0.00 0 7 1 0 0
t$perf-norm:srv_make_invnt_saldo 497 497 0 0.00 0 330 5 0 0
t$perf-norm:srv_make_money_saldo 734 734 0 0.00 0 2461 8 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 1091 300 0 0
v_add_invoice_to_stock 10174 9970 204 2.00 0 10621 17 0 204
v_all_customers 36408 36408 0 0.00 0 16 1 0 0
v_all_suppliers 29946 29946 0 0.00 0 22 1 0 0
v_all_wares 39950 39950 0 0.00 0 110 1 0 0
v_cancel_adding_invoice 800 800 0 0.00 0 132 6 0 0
v_cancel_client_order 3624 3624 0 0.00 0 732 3 0 0
v_cancel_customer_prepayment 1308 1308 0 0.00 0 1087 5 0 0
v_cancel_customer_reserve 1356 1356 0 0.00 0 2069 6 0 0
v_cancel_payment_to_supplier 810 810 0 0.00 0 598 4 0 0
v_cancel_supplier_invoice 828 804 24 2.89 0 2836 18 0 24
v_cancel_supplier_order 798 798 0 0.00 0 327 4 0 0
v_cancel_write_off 1954 1954 0 0.00 0 2048 14 0 0
v_max_id_clo_ord 5484 5484 0 0.00 0 430 1 0 0
v_max_id_clo_res 981 981 0 0.00 0 2336 12 0 0
v_max_id_ord_sup 5385 5385 0 0.00 0 5699 6 0 0
v_max_non_paid_invoice 1625 1625 0 0.00 0 302 2 0 0
v_max_non_paid_realizn 3665 3665 0 0.00 0 7556 5 0 0
v_min_id_clo_ord 5484 5484 0 0.00 0 6233 8 0 0
v_min_id_clo_res 981 981 0 0.00 0 6067 14 0 0
v_min_id_ord_sup 5385 5385 0 0.00 0 8320 11 0 0
v_min_non_paid_invoice 5729 5729 0 0.00 0 6259 17 0 0
v_min_non_paid_realizn 6940 6940 0 0.00 0 9365 17 0 0
v_our_firm 10092 10092 0 0.00 0 18 1 0 0
v_reserve_write_off 19504 19504 0 0.00 0 1846 4 0 0
x_lock_depdocs_on_canc_invoice 11829 11829 0 0.00 0 21113 111 0 0
x_lock_depdocs_on_canc_sup_ord 399 399 0 0.00 0 11360 370 0 0
x_make_qstorno_1000_1200 5485 5485 0 0.00 2 25120 1211 0 0
x_make_qstorno_1200_2000 5388 5388 0 0.00 4 88679 3318 0 0
x_make_qstorno_2100_3300 456260 456260 0 0.00 0 119581 156 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 09-10-2021 13:38:01 to 09-10-2021 13:38:05.

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:10 3 8192000000 8796669024 8807174144 3189120 0.038 1 1 2 0 3286736 61840 35776
11:08:11 23471 8192000000 9732024640 10033405952 810301216 9.001 100 88 176 0 838298112 7525232 20471664
11:09:37 29374 8192000000 9777432176 10088759296 850213520 9.402 100 87 174 0 882710688 11942544 20554624
11:11:15 18442 8192000000 9828630736 10150334464 888083248 9.780 100 93 186 0 935315936 25922800 21309888
11:12:39 12615 8192000000 9892146528 10229788672 922342288 10.119 100 81 163 1 1000891536 60704128 17845120
11:13:53 6940 8192000000 9933783936 10279112704 956113104 10.451 100 83 166 1 1044303024 71052496 17137424
11:15:03 4588 8192000000 9970534944 10324455424 994752768 10.828 100 85 169 0 1081109456 69207280 17149408
11:16:08 2439 8192000000 9985771584 10351816704 1018989168 11.062 100 72 142 1 1108340528 73547968 15803392
11:17:12 2111 8192000000 10032818832 10400260096 1047286048 11.335 100 89 178 0 1142226704 75527536 19413120
11:18:16 2433 8192000000 10031583968 10401918976 1069289424 11.545 100 91 183 1 1147765936 59201904 19274608
11:19:19 14453 8192000000 9974430656 10375012352 1072916816 11.580 100 30 61 1 1094525856 14751424 6857616
11:20:36 7390 8192000000 10009581632 10410319872 1079898624 11.647 100 29 56 2 1117167408 31490896 5777888
11:21:44 8879 8192000000 10008768016 10414149632 1082335856 11.670 100 34 69 0 1115870512 26064560 7470096
11:22:53 16385 8192000000 9998506720 10408640512 1089210720 11.735 100 35 69 2 1136255440 39286528 7758192
11:24:10 22321 8192000000 10019254224 10408407040 1091957984 11.761 100 64 129 1 1115872272 10281904 13632384
11:25:32 6354 8192000000 10009047376 10427969536 1097454128 11.813 100 45 90 0 1139108288 32213056 9441104
11:26:39 8341 8192000000 10008436800 10414501888 1085342288 11.698 99 32 64 3 1116105904 23039552 7724064
11:27:49 17330 8192000000 9971793760 10374766592 1043326384 11.297 96 34 68 0 1088503440 38181824 6995232
11:29:06 13650 8192000000 9971144960 10375569408 1008535264 10.961 95 30 59 0 1033264848 18094000 6635584
11:30:21 2947 8192000000 9966770624 10348863488 1012402992 10.999 99 51 100 1 1078749936 55366992 10979952
11:31:25 5974 8192000000 9931791920 10307088384 1002831248 10.906 98 36 67 1 1020724288 10073584 7819456
11:32:32 7162 8192000000 9957355056 10339319808 1038872000 11.254 100 39 80 0 1060405104 13099776 8433328
11:33:41 21967 8192000000 9962829408 10357374976 1032363008 11.191 99 15 30 0 1057201888 21967936 2870944
11:35:05 4989 8192000000 9980204400 10362101760 1058953680 11.446 100 50 101 3 1082271104 13547008 9770416
11:36:11 6631 8192000000 9982274544 10386845696 1066307328 11.517 100 42 84 0 1096382752 20460768 9614656
11:37:26 28520 8192000000 10008982096 10405265408 1091409712 11.756 100 39 76 2 1125876848 27282640 7184496
11:39:02 122417 8192000000 10100903280 10511618048 1117631504 12.005 100 31 61 0 1205541904 81571120 6339280
11:42:10 7785 8192000000 10146492640 10557108224 1141870768 12.233 100 43 83 1 1248040336 98031520 8138048
11:43:31 8082 8192000000 10193545632 10610847744 1156374832 12.369 100 40 81 2 1308838912 143717040 8747040
11:44:47 12223 8192000000 10257251840 10677460992 1166027664 12.460 100 55 109 1 1359580368 181502016 12050688
11:46:09 5582 8192000000 10292248064 10704281600 1167158608 12.470 100 64 127 1 1398495280 217624160 13712512
11:47:17 7115 8192000000 10331046896 10744283136 1171389872 12.510 100 56 112 1 1435873040 252234592 12248576
11:48:27 6247 8192000000 10366966176 10787131392 1173170656 12.526 100 68 136 0 1465017808 276733600 15113552
11:49:39 2393 8192000000 10352919440 10763304960 1178209584 12.573 100 85 169 0 1453474864 256164480 19100800
11:50:45 1245 8192000000 10358748416 10771238912 1167781936 12.476 100 88 176 0 1458638032 270118992 20737104
11:51:50 11047 8192000000 10350596816 10773180416 1148678656 12.297 100 56 112 1 1460403312 298739392 12985264
11:53:08 3683 8192000000 10343292272 10757668864 1114547072 11.975 98 87 176 0 1433989552 299901664 19540816
11:54:19 7247 8192000000 10321157952 10756788224 1142805568 12.242 100 61 122 2 1422951872 265202112 14944192
11:55:29 20984 8192000000 10274225760 10699976704 1115295888 11.983 98 37 75 0 1330237472 205201216 9740368
11:57:01 10999 8192000000 10257713280 10695327744 1138244272 12.199 100 31 62 1 1367039296 221281488 7513536
11:58:24 9839 8192000000 10298210832 10730024960 1133586352 12.155 100 37 74 0 1400891104 257655152 9649600
11:59:38 6556 8192000000 10317561392 10767560704 1146251728 12.274 100 44 87 2 1433891520 277313264 10326528
12:00:51 16645 8192000000 10349874464 10784047104 1151199040 12.321 100 33 66 2 1445567280 285943872 8424368
12:02:12 13834 8192000000 10375115648 10815479808 1147119040 12.282 99 36 72 0 1478045904 322028432 8898432
12:03:35 19133 8192000000 10416681808 10869604352 1155128256 12.358 100 25 50 1 1513223952 351070224 7025472
12:05:32 15466 8192000000 10282057456 10878468096 1139796080 12.214 100 16 32 2 1399138368 255250544 4091744
12:07:03 45189 8192000000 10052154896 10480922624 1114846976 11.978 99 14 29 2 1149705808 31279232 3579600
12:08:51 15744 8192000000 10094436416 10517889024 1125658704 12.080 100 50 100 4 1182375600 46216080 10500816
12:10:12 126479 8192000000 10063154608 10519035904 1108723184 11.920 98 32 64 2 1173264336 58334912 6206240
12:13:28 106346 8192000000 10145312256 10617974784 1138165024 12.198 100 21 42 0 1250804656 107946464 4693168
12:16:15 88194 8192000000 10093858224 10537570304 1123998992 12.065 98 14 28 1 1173281776 46239344 3043440
12:19:18 44822 8192000000 10107557024 10571128832 1126892656 12.092 99 20 40 0 1205169792 73569312 4707824
12:21:09 136158 8192000000 10074523152 10534047744 1131555712 12.136 99 18 36 0 1187297072 51810720 3930640
12:25:26 53756 8192000000 10083811760 10550210560 1131211312 12.133 99 16 32 0 1186141360 51987168 2942880
12:27:20 66009 8192000000 10144310016 10610552832 1151750560 12.326 100 16 32 0 1256783936 100968736 4064640
12:30:07 67632 8192000000 10116075600 10613051392 1155810656 12.364 100 23 44 1 1215949952 55869280 4270016
12:32:27 63604 8192000000 10084792320 10544238592 1113815232 11.969 97 25 49 1 1185127280 65642544 5669504
12:34:35 43769 8192000000 10132598352 10579046400 1105569968 11.890 96 25 50 0 1194094112 82990336 5533808
12:36:21 48436 8192000000 10167245312 10617192448 1102335824 11.860 97 25 50 0 1236813216 128960720 5516672
12:38:15 73776 8192000000 10096119680 10562363392 1102418704 11.861 97 14 28 0 1166261136 61446368 2396064
12:40:51 85266 8192000000 10074246240 10524172288 1113754832 11.968 99 29 58 0 1186547248 66732672 6059744
12:43:21 74041 8192000000 10072030528 10545119232 1115850176 11.988 99 18 36 0 1170538192 50762192 3925824
12:46:08 80812 8192000000 10075971952 10578120704 1099322112 11.831 97 13 26 0 1163199360 61004624 2872624
12:48:31 70186 8192000000 10122935344 10614988800 1123052720 12.056 99 26 52 0 1227997152 99663888 5280544
12:50:59 122456 8192000000 10051250144 10480062464 1054328000 11.402 93 12 24 0 1079203936 22490400 2385536
12:54:12 15362 8192000000 10078616176 10500108288 1100724736 11.845 98 47 94 0 1148280128 38153840 9401552
12:55:29 56804 8192000000 10048075424 10483298304 1094010688 11.781 98 31 62 0 1160789920 60163744 6615488
12:57:28 52054 8192000000 10058616848 10495094784 1091223440 11.754 97 41 82 1 1122795296 23515680 8056176
12:59:20 70108 8192000000 10036313584 10484514816 1087594512 11.720 98 27 53 2 1123499312 30760224 5144576
13:01:30 56041 8192000000 10058664592 10525728768 1117905808 12.007 100 6 12 0 1167455856 48468384 1081664
13:03:26 28115 8192000000 10066954176 10546147328 1122288448 12.049 100 8 16 0 1181274416 57149008 1836960
13:04:55 60882 8192000000 10047027680 10509762560 1070543216 11.557 96 8 16 0 1111815360 39667072 1605072
13:06:56 39153 8192000000 10095650336 10535247872 1122652640 12.052 100 29 58 0 1175662432 46278400 6731392
13:08:49 56592 8192000000 10137604112 10596741120 1111729664 11.949 98 26 52 1 1236601408 119206192 5665552
13:10:45 55107 8192000000 10088300000 10601885696 1119105536 12.019 99 25 50 0 1183804928 58992192 5707200
13:12:42 42350 8192000000 10116846768 10563629056 1126491456 12.088 99 36 71 1 1163379264 29571440 7316368
13:14:25 28356 8192000000 10086299024 10529550336 1143126560 12.245 100 26 52 1 1179625392 31222512 5276320
13:15:57 43673 8192000000 10152105744 10617823232 1142507584 12.239 99 34 68 2 1232442144 82837040 7097520
13:17:51 145196 8192000000 10091127376 10545672192 1140766624 12.223 99 14 28 1 1246959440 102985008 3207808
13:21:16 38065 8192000000 10089527952 10579558400 1149310992 12.303 100 16 32 0 1185972496 33325280 3336224
13:23:05 60129 8192000000 10096301424 10573877248 1129199680 12.114 98 12 23 0 1175699632 44237200 2262752
13:25:14 61003 8192000000 10074548208 10568196096 1146947920 12.281 100 18 36 0 1216148656 65311936 3888800
13:27:15 76213 8192000000 10080141440 10536263680 1046064688 11.323 91 23 46 0 1093117664 42270688 4782288
13:29:32 63957 8192000000 10130257744 10582941696 1115469248 11.984 98 39 77 1 1225796816 101737840 8589728
13:31:37 47126 8192000000 10161123056 10613829632 1109515696 11.928 98 23 46 1 1235888336 121377744 4994896
13:33:32 57971 8192000000 10093118224 10572046336 1113796960 11.968 98 29 58 1 1193156944 73251680 6108304
13:35:33 82161 8192000000 10078186544 10562912256 1079853184 11.646 96 29 58 1 1137304320 51553600 5897536

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 09-10-2021 13:38:07 to 09-10-2021 13:38:21.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 102 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 09-10-2021 13:38:22 to 09-10-2021 13:38:24.

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          241632
MON$OLDEST_ACTIVE               241633
MON$OLDEST_SNAPSHOT             241633
MON$NEXT_TRANSACTION            241633
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                       2072736
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             800
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.1.2624 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.1.2624 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.1.2624 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.1.2624 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
on disk structure version 13.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

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

09.10.21 13:38:25. 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-09 13:38:28 No severe PSQL-related problems occured
09.10.21 13:38:29. End of report.