Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 13.03.2021 10:29
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 df9f488d08424df294c459d6c283e9c3
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-03-04 16:07
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.26
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 16828704 kB
MemAvailable 31620540 kB
Buffers 0 kB
Cached 14861024 kB
SwapCached 0 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.0
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-03-13 10:26:56
DTS_END                         2021-03-13 10:26:56.2380
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/52846
TRN_ID                          230529
ATT_ID                          662
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: 8994.43 22583 1079332
customer order: creation 170.21 460 20425
customer order: refuse 14.29 357 1715
order to supplier: creation 44.48 1572 5338
order to supplier: removal 3.35 129648 402
invoice (draft): creation 42.78 3790 5133
invoice (draft): removal 51.39 955 6167
invoice accept: apply 40.45 19601 4854
invoice accept: cancel 46.93 901 5631
customer reserve: creation 3715.93 193 445912
customer reserve: removal 4582.01 75 549841
realization accept: apply 82.55 191 9906
realization accept: cancel 76.06 141 9127
payment from customer: creation 56.80 111 6816
payment from customer: removal 5.61 99 673
payment to supplier: creation 47.67 145 5720
payment to supplier: removal 3.20 98 384
service: total inventory turnovers 3.85 3656 462
service: total monetary turnovers 5.98 682 717
service: aggregate perf. data 0.88 14731 105
service: refresh index statistics 0.03 274248 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 13-03-2021 10:29:52 to 13-03-2021 10:29:55.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3808
TEST_TIME 2 3096
TEST_TIME 3 3635
TEST_TIME 4 5010
TEST_TIME 5 5444
TEST_TIME 6 5339
TEST_TIME 7 5795
TEST_TIME 8 5904
TEST_TIME 9 5633
TEST_TIME 10 5828
TEST_TIME 11 5663
TEST_TIME 12 6020
TEST_TIME 13 6000
TEST_TIME 14 6259
TEST_TIME 15 6480
TEST_TIME 16 6391
TEST_TIME 17 6637
TEST_TIME 18 6826
TEST_TIME 19 6994
TEST_TIME 20 6986
TEST_TIME 21 7288
TEST_TIME 22 7790
TEST_TIME 23 7819
TEST_TIME 24 8177
TEST_TIME 25 8370
TEST_TIME 26 8760
TEST_TIME 27 8861
TEST_TIME 28 8914
TEST_TIME 29 8966
TEST_TIME 30 9394
TEST_TIME 31 9790
TEST_TIME 32 10840
TEST_TIME 33 10667
TEST_TIME 34 10757
TEST_TIME 35 10762
TEST_TIME 36 10549
TEST_TIME 37 10325
TEST_TIME 38 10074
TEST_TIME 39 9943
TEST_TIME 40 9813
TEST_TIME 41 9851
TEST_TIME 42 9803
TEST_TIME 43 9921
TEST_TIME 44 9810
TEST_TIME 45 9767
TEST_TIME 46 9718
TEST_TIME 47 9617
TEST_TIME 48 9690
TEST_TIME 49 9642
TEST_TIME 50 9627
TEST_TIME 51 9646
TEST_TIME 52 9657
TEST_TIME 53 9592
TEST_TIME 54 9620
TEST_TIME 55 9717
TEST_TIME 56 9673
TEST_TIME 57 9730
TEST_TIME 58 9693
TEST_TIME 59 9812
TEST_TIME 60 9696
TEST_TIME 61 9696
TEST_TIME 62 9599
TEST_TIME 63 9521
TEST_TIME 64 9490
TEST_TIME 65 9467
TEST_TIME 66 9445
TEST_TIME 67 9429
TEST_TIME 68 9411
TEST_TIME 69 9408
TEST_TIME 70 9356
TEST_TIME 71 9382
TEST_TIME 72 9489
TEST_TIME 73 9411
TEST_TIME 74 9525
TEST_TIME 75 9571
TEST_TIME 76 9558
TEST_TIME 77 9586
TEST_TIME 78 9583
TEST_TIME 79 9658
TEST_TIME 80 9568
TEST_TIME 81 9473
TEST_TIME 82 9407
TEST_TIME 83 9354
TEST_TIME 84 9296
TEST_TIME 85 9262
TEST_TIME 86 9220
TEST_TIME 87 9210
TEST_TIME 88 9191
TEST_TIME 89 9195
TEST_TIME 90 9192
TEST_TIME 91 9168
TEST_TIME 92 9138
TEST_TIME 93 9110
TEST_TIME 94 9142
TEST_TIME 95 9207
TEST_TIME 96 9225
TEST_TIME 97 9254
TEST_TIME 98 9287
TEST_TIME 99 9290
TEST_TIME 100 9211
TEST_TIME 101 9158
TEST_TIME 102 9110
TEST_TIME 103 9053
TEST_TIME 104 8992
TEST_TIME 105 8958
TEST_TIME 106 8922
TEST_TIME 107 8959
TEST_TIME 108 9003
TEST_TIME 109 8975
TEST_TIME 110 8953
TEST_TIME 111 9012
TEST_TIME 112 8988
TEST_TIME 113 8987
TEST_TIME 114 9020
TEST_TIME 115 9004
TEST_TIME 116 9042
TEST_TIME 117 9065
TEST_TIME 118 9103
TEST_TIME 119 9038
TEST_TIME 120 8996

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 13-03-2021 10:29:56 to 13-03-2021 10:29:59.

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 1492428 1492428 0 0.00 0 19080 7 0 0
doc_list_biud 1492426 1492426 0 0.00 0 108361 35 0 0
sp_add_invoice_to_stock 5050 4854 196 3.88 35 214319 19602 0 196
sp_cancel_adding_invoice 5631 5631 0 0.00 4 90564 902 0 0
sp_cancel_client_order 1715 1715 0 0.00 4 8696 357 0 0
sp_cancel_customer_reserve 549841 549841 0 0.00 1 108374 76 0 0
sp_cancel_pay_from_customer 673 673 0 0.00 3 12455 100 0 0
sp_cancel_pay_to_supplier 384 384 0 0.00 3 3079 98 0 0
sp_cancel_supplier_invoice 6184 6167 17 0.27 1 14080 956 0 17
sp_cancel_supplier_order 402 402 0 0.00 7 1348558 129648 0 0
sp_cancel_write_off 9127 9127 0 0.00 1 8058 141 0 0
sp_client_order 20425 20425 0 0.00 4 40016 460 0 0
sp_customer_reserve 445912 445912 0 0.00 0 133592 193 0 0
sp_fill_shopping_cart 30887 30887 0 0.00 1 12957 44 0 0
sp_fill_shopping_cart_clo_res 445905 445905 0 0.00 0 53445 18 0 0
sp_get_clo_for_invoice 4847 4847 0 0.00 0 58228 460 0 0
sp_kill_cost_storno 15815 15815 0 0.00 0 8458 64 0 0
sp_kill_qstorno_ret_qs2qd 1115378 1115378 0 0.00 0 108346 41 0 0
sp_kill_qty_storno 587634 587634 0 0.00 0 108360 87 0 0
sp_lock_selected_doc 20385 20385 0 0.00 0 7675 4 0 0
sp_make_cost_storno 27289 27289 0 0.00 0 14450 59 0 0
sp_multiply_rows_for_pdistr 27289 27289 0 0.00 0 9676 36 0 0
sp_multiply_rows_for_qdistr 20425 20425 0 0.00 0 39609 246 0 0
sp_pay_from_customer 6816 6816 0 0.00 4 13305 111 0 0
sp_pay_to_supplier 5720 5720 0 0.00 5 19815 146 0 0
sp_payment_common 12536 12536 0 0.00 1 7486 20 0 0
sp_qd_handle_on_cancel_clo 1715 1715 0 0.00 0 8689 326 0 0
sp_qd_handle_on_invoice_upd_sts 10477 10477 0 0.00 0 34018 391 0 0
sp_qd_handle_on_reserve_upd_sts 9905 9905 0 0.00 0 11249 54 0 0
sp_reserve_write_off 9906 9906 0 0.00 7 19728 191 0 0
sp_supplier_invoice 5133 5133 0 0.00 7 121768 3790 0 0
sp_supplier_order 5338 5338 0 0.00 5 98202 1573 0 0
srv_aggregate_perf_data 105 105 0 0.00 3036 176377 14732 0 0
srv_fill_mon_cache_memory 64 64 0 0.00 1143 201096 42478 0 0
srv_find_qd_qs_mism 1033240 1033240 0 0.00 0 19079 6 0 0
srv_make_invnt_saldo 462 462 0 0.00 33 105132 3657 0 0
srv_make_money_saldo 717 717 0 0.00 1 19585 683 0 0
srv_recalc_idx_stat 4 4 0 0.00 171972 425382 274249 0 0
t$perf-abend:sp_add_invoice_to_stock 196 196 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 17 17 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4854 4854 0 0.00 0 20002 186 0 0
t$perf-norm:sp_cancel_adding_invoice 388 388 0 0.00 1 2742 104 0 0
t$perf-norm:sp_cancel_client_order 1715 1715 0 0.00 0 4873 17 0 0
t$perf-norm:sp_cancel_customer_reserve 700 700 0 0.00 0 4239 26 0 0
t$perf-norm:sp_cancel_pay_from_customer 673 673 0 0.00 0 1065 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 384 384 0 0.00 0 9197 31 0 0
t$perf-norm:sp_cancel_supplier_invoice 386 386 0 0.00 0 1015 21 0 0
t$perf-norm:sp_cancel_supplier_order 402 402 0 0.00 0 28462 1617 0 0
t$perf-norm:sp_cancel_write_off 988 988 0 0.00 0 2028 9 0 0
t$perf-norm:sp_client_order 20425 20425 0 0.00 0 33835 22 0 0
t$perf-norm:sp_customer_reserve 997 997 0 0.00 0 6481 12 0 0
t$perf-norm:sp_pay_from_customer 6816 6816 0 0.00 0 7728 9 0 0
t$perf-norm:sp_pay_to_supplier 5720 5720 0 0.00 0 3427 8 0 0
t$perf-norm:sp_reserve_write_off 9906 9906 0 0.00 0 3447 10 0 0
t$perf-norm:sp_supplier_invoice 5133 5133 0 0.00 0 3850 18 0 0
t$perf-norm:sp_supplier_order 5338 5338 0 0.00 0 26684 26 0 0
t$perf-norm:srv_aggregate_perf_data 105 105 0 0.00 0 74 2 0 0
t$perf-norm:srv_fill_mon_cache_memory 64 64 0 0.00 0 846 17 0 0
t$perf-norm:srv_make_invnt_saldo 462 462 0 0.00 0 1946 16 0 0
t$perf-norm:srv_make_money_saldo 717 717 0 0.00 0 9797 19 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 5 4 0 0
v_add_invoice_to_stock 10080 9688 392 3.88 0 5882 18 0 392
v_all_customers 36496 36496 0 0.00 0 48 1 0 0
v_all_suppliers 29212 29212 0 0.00 0 47 1 0 0
v_all_wares 40848 40848 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 776 776 0 0.00 0 727 7 0 0
v_cancel_client_order 3430 3430 0 0.00 0 4396 6 0 0
v_cancel_customer_prepayment 1346 1346 0 0.00 0 7353 14 0 0
v_cancel_customer_reserve 1400 1400 0 0.00 0 5528 11 0 0
v_cancel_payment_to_supplier 768 768 0 0.00 0 3073 14 0 0
v_cancel_supplier_invoice 806 772 34 4.21 0 753 17 0 34
v_cancel_supplier_order 804 804 0 0.00 0 681 4 0 0
v_cancel_write_off 1976 1976 0 0.00 0 7078 19 0 0
v_max_id_clo_ord 5337 5337 0 0.00 0 1547 2 0 0
v_max_id_clo_res 997 997 0 0.00 0 5679 26 0 0
v_max_id_ord_sup 5124 5124 0 0.00 0 4713 5 0 0
v_max_non_paid_invoice 1575 1575 0 0.00 0 347 3 0 0
v_max_non_paid_realizn 3835 3835 0 0.00 0 476 3 0 0
v_min_id_clo_ord 5337 5337 0 0.00 0 6747 12 0 0
v_min_id_clo_res 997 997 0 0.00 0 3379 9 0 0
v_min_id_ord_sup 5124 5124 0 0.00 0 9404 9 0 0
v_min_non_paid_invoice 5720 5720 0 0.00 0 7481 15 0 0
v_min_non_paid_realizn 6816 6816 0 0.00 0 6467 13 0 0
v_our_firm 10314 10314 0 0.00 0 15 1 0 0
v_reserve_write_off 19810 19810 0 0.00 0 7882 8 0 0
x_lock_depdocs_on_canc_invoice 11412 11412 0 0.00 0 21720 124 0 0
x_lock_depdocs_on_canc_sup_ord 402 402 0 0.00 0 14527 463 0 0
x_make_qstorno_1000_1200 5338 5338 0 0.00 2 98182 1483 0 0
x_make_qstorno_1200_2000 5133 5133 0 0.00 4 112345 3621 0 0
x_make_qstorno_2100_3300 445912 445912 0 0.00 0 133582 172 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 13-03-2021 10:30:00 to 13-03-2021 10:30: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
07:56:59 2 8192000000 8796668848 8807174144 3189104 0.038 1 1 2 0 3286720 61840 35776
07:58:01 22347 8192000000 9718748656 10012254208 793663424 8.832 100 86 173 0 822016448 7316320 21036704
07:59:31 21006 8192000000 9764354272 10066649088 833473632 9.234 100 85 170 0 866071088 12348576 20248880
08:00:59 19536 8192000000 9802586528 10118184960 861483872 9.515 100 87 174 3 911298272 29542816 20271584
08:02:23 11473 8192000000 9863953424 10200223744 923165024 10.127 100 81 162 0 975847680 35079184 17603472
08:03:36 8958 8192000000 9932181712 10276880384 959583424 10.485 100 78 154 1 1037608112 62387360 15637328
08:04:48 5579 8192000000 9970609120 10322309120 992834208 10.809 100 80 158 0 1080322880 71305296 16183376
08:05:56 2497 8192000000 9984090592 10344648704 1022371488 11.095 100 86 172 1 1104334016 64544944 17417584
08:07:01 2103 8192000000 10027760336 10396708864 1050798704 11.368 100 86 173 3 1145721600 77507392 17415504
08:08:04 1660 8192000000 10040846864 10408591360 1072336144 11.574 100 89 180 1 1150476880 59340272 18800464
08:09:07 3676 8192000000 10026244176 10407583744 1073620800 11.587 100 71 140 1 1141162528 53306480 14235248
08:10:12 6298 8192000000 9996457744 10398425088 1081323504 11.660 100 44 87 2 1117623872 27767520 8532848
08:11:20 6748 8192000000 10003945168 10407636992 1088717776 11.730 100 48 96 0 1129710992 30287408 10705808
08:12:34 84830 8192000000 10004053680 10417582080 1095229344 11.792 100 21 42 0 1124683456 25317632 4136480
08:14:59 3918 8192000000 10012283968 10412400640 1095662080 11.796 100 46 92 1 1126649264 20359216 10627968
08:16:05 5848 8192000000 10020153088 10421207040 1094303488 11.784 100 27 55 1 1130404992 30141088 5960416
08:17:16 8032 8192000000 10003954864 10406895616 1075538176 11.605 99 28 54 2 1099903504 18310208 6055120
08:18:29 58497 8192000000 9958200528 10355294208 1000127216 10.880 93 18 35 1 1024694192 20767312 3799664
08:20:31 9651 8192000000 9935207808 10326007808 967544272 10.563 93 37 73 1 996094384 20758160 7791952
08:21:45 7770 8192000000 9951014320 10336690176 1010742208 10.983 98 51 102 1 1032633056 10850464 11040384
08:22:57 10876 8192000000 9957594512 10352865280 1020061120 11.073 98 31 62 2 1048169408 21254320 6853968
08:24:46 10979 8192000000 9958292544 10355748864 1046277008 11.325 100 20 40 1 1066349136 15626192 4445936
08:26:00 6341 8192000000 9981849280 10373980160 1059953952 11.456 100 38 76 2 1097332736 29585152 7793632
08:27:09 6594 8192000000 10002869152 10392965120 1082370688 11.670 100 55 107 2 1114046992 20182512 11493792
08:28:21 75288 8192000000 10061351008 10468999168 1104182016 11.877 100 52 101 0 1178380624 63799056 10399552
08:30:43 6329 8192000000 10104777424 10514055168 1120218848 12.029 100 58 114 0 1215171456 82960288 11992320
08:31:53 2687 8192000000 10101271344 10501582848 1128502928 12.107 100 61 121 0 1205584128 64359696 12721504
08:33:01 7702 8192000000 10154475664 10560045056 1141904096 12.233 100 61 121 0 1257435904 103055664 12476144
08:34:16 6784 8192000000 10159890512 10571026432 1150620048 12.315 100 53 106 1 1276504672 114623552 11261072
08:35:29 15061 8192000000 10215864800 10625298432 1165911904 12.459 100 61 122 0 1316196944 137028960 13256080
08:36:48 8160 8192000000 10193879360 10613846016 1170820256 12.504 100 54 105 2 1298853824 116013760 12019808
08:38:02 14366 8192000000 10244392768 10682720256 1181275936 12.602 100 54 107 4 1350700192 156766800 12657456
08:39:20 5231 8192000000 10281731248 10698268672 1163336704 12.435 99 60 120 2 1378925264 202038496 13550064
08:40:29 2200 8192000000 10339475824 10743939072 1186249552 12.648 100 93 186 0 1438299600 231505696 20544352
08:41:37 7296 8192000000 10337030528 10752176128 1171215600 12.508 100 68 135 1 1435124384 249175008 14733776
08:42:56 3182 8192000000 10333855296 10755829760 1184279200 12.630 100 77 153 2 1433460784 231689600 17491984
08:44:07 2118 8192000000 10350361344 10747473920 1151263360 12.321 99 84 168 0 1442952480 271767968 19921152
08:45:14 2844 8192000000 10398236752 10799271936 1163462848 12.436 100 77 153 0 1484673392 303211440 17999104
08:46:24 1143 8192000000 10445396240 10845384704 1162021600 12.422 100 89 173 3 1543505920 360170512 21313808
08:47:33 5671 8192000000 10489969504 10903695360 1164197152 12.443 100 64 127 1 1589304848 408843888 16263808
08:48:51 5820 8192000000 10443043504 10892443648 1157226272 12.377 100 56 112 1 1543292560 372745584 13320704
08:50:09 11511 8192000000 10416752704 10877726720 1151807984 12.326 99 39 78 0 1537513232 375935936 9769312
08:51:40 4752 8192000000 10432867600 10854166528 1171956128 12.515 100 50 99 2 1532386864 347931616 12499120
08:52:57 14996 8192000000 10385083632 10809536512 1158911936 12.393 100 42 84 2 1496958752 326630160 11416656
08:54:20 24499 8192000000 10421337328 10894991360 1161172464 12.414 100 34 68 0 1533817504 363800144 8844896
08:55:49 13691 8192000000 10472688816 10936578048 1155018464 12.357 100 29 58 1 1576038304 413126160 7893680
08:57:20 29882 8192000000 10326084992 10809176064 1118715312 12.015 99 20 40 0 1464314240 339879616 5719312
08:58:50 68498 8192000000 10083388464 10500931584 1060210464 11.458 93 20 39 0 1108614848 44148064 4256320
09:01:01 47451 8192000000 10097533120 10539409408 1102967088 11.866 98 27 55 0 1167167392 58430400 5769904
09:02:56 201096 8192000000 10115918592 10552381440 1091911520 11.761 96 26 52 1 1155907280 58193280 5802480
09:07:22 42992 8192000000 10141996672 10585497600 1128359584 12.106 99 28 56 1 1226539392 91980896 6198912
09:09:06 48081 8192000000 10091312880 10586546176 1131004928 12.131 99 13 26 1 1207950448 73940352 3005168
09:10:54 30324 8192000000 10093005440 10565349376 1136904128 12.186 100 11 22 0 1202416304 63206720 2305456
09:12:29 35196 8192000000 10081148864 10554867712 1142132592 12.236 100 14 28 0 1185675568 40674528 2868448
09:14:17 40491 8192000000 10107111008 10622742528 1155861056 12.364 100 5 10 0 1229471712 72547248 1063408
09:16:08 18922 8192000000 10099726304 10546642944 1141239632 12.227 100 33 66 1 1179698720 31740480 6718608
09:17:31 53902 8192000000 10070714272 10521886720 1122703888 12.053 98 28 56 1 1166762432 38292032 5766512
09:19:30 39775 8192000000 10143259552 10589941760 1125004144 12.074 98 33 65 0 1187913648 54912432 7997072
09:21:24 85310 8192000000 10130201392 10585292800 1134249904 12.161 99 17 33 0 1206049744 68823760 2976080
09:24:06 94853 8192000000 10158586320 10605158400 1092859744 11.770 95 25 51 2 1177839792 79632688 5347360
09:28:06 46545 8192000000 10077981984 10535288832 1134625152 12.165 100 26 53 1 1166148048 26138224 5384672
09:29:56 64061 8192000000 10062137600 10536779776 1109129520 11.924 98 12 24 0 1148568768 36775104 2664144
09:32:00 78601 8192000000 10075580256 10514935808 1088171648 11.725 96 15 30 1 1140446672 49406144 2868880
09:34:25 46663 8192000000 10096514032 10532679680 1080349776 11.651 95 32 61 2 1113211456 26190208 6671472
09:36:12 42898 8192000000 10101576256 10527723520 1107446768 11.908 99 23 46 1 1161830112 49489152 4894192
09:38:01 88771 8192000000 10088410416 10539102208 1071747136 11.569 95 15 30 0 1118911392 44135344 3028912
09:40:34 49926 8192000000 10102790720 10555179008 1130092208 12.122 100 27 54 0 1220659456 83849824 6717424
09:42:30 25948 8192000000 10063761952 10487037952 1103315792 11.869 99 35 68 2 1134098416 23720336 7062288
09:43:56 53447 8192000000 10122538544 10551783424 1098601776 11.824 98 34 68 1 1141013552 35282240 7129536
09:45:56 126627 8192000000 10033842896 10492379136 1067721680 11.530 96 10 20 0 1118224256 48351872 2150704
09:51:59 58035 8192000000 10056056992 10515849216 1117720096 12.005 100 20 40 1 1151100096 29299808 4080192
09:54:30 42112 8192000000 10050174928 10503536640 1099580560 11.834 98 32 64 2 1145337856 39321472 6435824
09:56:19 46907 8192000000 10075406224 10518708224 1112241280 11.954 99 15 30 2 1152565216 37386864 2937072
09:58:21 78055 8192000000 10143980880 10588971008 1114551072 11.975 98 20 40 1 1199432192 80290640 4590480
10:00:43 82042 8192000000 10096774736 10592923648 1101533392 11.852 97 18 36 1 1186036352 81467264 3035696
10:03:09 50075 8192000000 10086768720 10513252352 1120395936 12.031 99 15 30 0 1154862320 31624320 2842064
10:05:04 114360 8192000000 10072800192 10549870592 1136615328 12.184 100 21 41 2 1180031616 39170944 4245344
10:08:10 43612 8192000000 10079639120 10546331648 1142489056 12.239 100 9 18 1 1186917856 42576832 1851968
10:10:06 72369 8192000000 10107956912 10584616960 1138389152 12.200 99 10 20 0 1207881088 67445936 2046000
10:12:22 36389 8192000000 10132841136 10588364800 1102830752 11.864 97 20 40 1 1199626368 92127632 4667984
10:14:08 63988 8192000000 10054171584 10513186816 1111669632 11.948 98 12 24 0 1170828544 56650176 2508736
10:16:12 48032 8192000000 10128676336 10577711104 1126141456 12.085 99 25 50 1 1197099408 66093424 4864528
10:18:06 46476 8192000000 10093231248 10538319872 1128825712 12.110 99 30 60 2 1193500848 58275744 6399392
10:19:55 39792 8192000000 10139229616 10602008576 1116324816 11.992 98 29 58 3 1194591776 72093504 6173456
10:21:41 40765 8192000000 10125294032 10586021888 1095543712 11.795 97 33 66 3 1200024544 97071744 7409088
10:23:32 67615 8192000000 10081137888 10628337664 1114802816 11.978 99 12 23 2 1195758816 78479232 2476768
10:25:40 79712 8192000000 9778420496 10185072640 852258128 9.423 75 15 28 2 889478656 34153840 3066688

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 13-03-2021 10:30:06 to 13-03-2021 10:30:21.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 196 v_add_invoice_to_stock 335544517
except 17 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-03-2021 10:30:22 to 13-03-2021 10:30: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          231039
MON$OLDEST_ACTIVE               231040
MON$OLDEST_SNAPSHOT             231040
MON$NEXT_TRANSACTION            231040
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                       2115648
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             792
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.0.2387 Firebird 4.0 Release Candidate 1
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2387 Firebird 4.0 Release Candidate 1"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2387 Firebird 4.0 Release Candidate 1/tcp (mscs-test-161.budzdorov.ru)/P16:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.0.2387 Firebird 4.0 Release Candidate 1/tcp (mscs-test-161.budzdorov.ru)/P16: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 ---
:11: 
:12: mscs-test-161.budzdorov.ru    Sat Mar 13 10:27:12 2021
:13:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:14: 
--- end of diff output ---

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

13.03.21 10:30: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-03-13 10:30:28 No severe PSQL-related problems occured
13.03.21 10:30:29. End of report.