Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 20.02.2021 04:27
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 e0e7b46250ba4f9795ceb55e0face73f
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 2020-09-25 13:42
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.00
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 16485592 kB
MemAvailable 31070728 kB
Buffers 20 kB
Cached 15113832 kB
SwapCached 3904 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-02-20 04:26:58
DTS_END                         2021-02-20 04:26:58.0950
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_PAY_FROM_CUSTOMER(24:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/53324
TRN_ID                          227643
ATT_ID                          627
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: 8660.68 21707 1039282
customer order: creation 167.29 394 20075
customer order: refuse 13.88 391 1666
order to supplier: creation 44.55 1511 5346
order to supplier: removal 3.38 117240 406
invoice (draft): creation 45.87 3773 5504
invoice (draft): removal 49.48 993 5938
invoice accept: apply 40.15 19003 4818
invoice accept: cancel 44.21 1004 5305
customer reserve: creation 3683.80 187 442056
customer reserve: removal 4282.85 73 513942
realization accept: apply 80.16 210 9619
realization accept: cancel 81.78 137 9813
payment from customer: creation 56.98 142 6837
payment from customer: removal 5.39 94 647
payment to supplier: creation 46.92 153 5630
payment to supplier: removal 3.43 110 412
service: total inventory turnovers 3.79 3875 455
service: total monetary turnovers 5.78 544 694
service: aggregate perf. data 0.96 13252 115
service: refresh index statistics 0.03 271047 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-02-2021 04:27:45 to 20-02-2021 04:27:47.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2132
TEST_TIME 2 2669
TEST_TIME 3 3028
TEST_TIME 4 3107
TEST_TIME 5 3393
TEST_TIME 6 3349
TEST_TIME 7 3460
TEST_TIME 8 3746
TEST_TIME 9 4065
TEST_TIME 10 4711
TEST_TIME 11 4927
TEST_TIME 12 5184
TEST_TIME 13 5427
TEST_TIME 14 5576
TEST_TIME 15 5963
TEST_TIME 16 6326
TEST_TIME 17 6433
TEST_TIME 18 6696
TEST_TIME 19 6831
TEST_TIME 20 7917
TEST_TIME 21 7831
TEST_TIME 22 8048
TEST_TIME 23 8219
TEST_TIME 24 8607
TEST_TIME 25 9014
TEST_TIME 26 8813
TEST_TIME 27 8814
TEST_TIME 28 9027
TEST_TIME 29 8971
TEST_TIME 30 9491
TEST_TIME 31 9968
TEST_TIME 32 10133
TEST_TIME 33 9935
TEST_TIME 34 9967
TEST_TIME 35 10179
TEST_TIME 36 10058
TEST_TIME 37 9891
TEST_TIME 38 9634
TEST_TIME 39 9397
TEST_TIME 40 9475
TEST_TIME 41 9343
TEST_TIME 42 9453
TEST_TIME 43 9396
TEST_TIME 44 9539
TEST_TIME 45 9422
TEST_TIME 46 9320
TEST_TIME 47 9238
TEST_TIME 48 9157
TEST_TIME 49 9131
TEST_TIME 50 9100
TEST_TIME 51 9036
TEST_TIME 52 8939
TEST_TIME 53 8873
TEST_TIME 54 8872
TEST_TIME 55 8873
TEST_TIME 56 8851
TEST_TIME 57 8797
TEST_TIME 58 8855
TEST_TIME 59 8802
TEST_TIME 60 8787
TEST_TIME 61 8880
TEST_TIME 62 9121
TEST_TIME 63 9116
TEST_TIME 64 9120
TEST_TIME 65 9104
TEST_TIME 66 9200
TEST_TIME 67 9224
TEST_TIME 68 9133
TEST_TIME 69 9063
TEST_TIME 70 9081
TEST_TIME 71 9047
TEST_TIME 72 9012
TEST_TIME 73 8926
TEST_TIME 74 8896
TEST_TIME 75 8912
TEST_TIME 76 8921
TEST_TIME 77 8928
TEST_TIME 78 8879
TEST_TIME 79 8839
TEST_TIME 80 8865
TEST_TIME 81 8882
TEST_TIME 82 8871
TEST_TIME 83 8958
TEST_TIME 84 9017
TEST_TIME 85 9010
TEST_TIME 86 8983
TEST_TIME 87 8965
TEST_TIME 88 8871
TEST_TIME 89 8830
TEST_TIME 90 8771
TEST_TIME 91 8687
TEST_TIME 92 8716
TEST_TIME 93 8755
TEST_TIME 94 8762
TEST_TIME 95 8763
TEST_TIME 96 8734
TEST_TIME 97 8753
TEST_TIME 98 8807
TEST_TIME 99 8797
TEST_TIME 100 8780
TEST_TIME 101 8770
TEST_TIME 102 8801
TEST_TIME 103 8821
TEST_TIME 104 8840
TEST_TIME 105 8940
TEST_TIME 106 8929
TEST_TIME 107 8890
TEST_TIME 108 8812
TEST_TIME 109 8769
TEST_TIME 110 8778
TEST_TIME 111 8733
TEST_TIME 112 8736
TEST_TIME 113 8714
TEST_TIME 114 8699
TEST_TIME 115 8692
TEST_TIME 116 8669
TEST_TIME 117 8676
TEST_TIME 118 8674
TEST_TIME 119 8698
TEST_TIME 120 8667

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 20-02-2021 04:27:49 to 20-02-2021 04:27:52.

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 1448466 1448466 0 0.00 0 30327 7 0 0
doc_list_biud 1448464 1448464 0 0.00 0 102154 33 0 0
sp_add_invoice_to_stock 4959 4818 141 2.84 32 216543 19004 0 141
sp_cancel_adding_invoice 5305 5305 0 0.00 4 66960 1004 0 0
sp_cancel_client_order 1666 1666 0 0.00 5 9387 392 0 0
sp_cancel_customer_reserve 513942 513942 0 0.00 1 42115 73 0 0
sp_cancel_pay_from_customer 647 647 0 0.00 3 5818 94 0 0
sp_cancel_pay_to_supplier 412 412 0 0.00 3 7989 111 0 0
sp_cancel_supplier_invoice 5953 5938 15 0.25 2 102158 994 0 15
sp_cancel_supplier_order 406 406 0 0.00 12 1105511 117241 0 0
sp_cancel_write_off 9813 9813 0 0.00 1 29870 138 0 0
sp_client_order 20075 20075 0 0.00 4 18463 395 0 0
sp_customer_reserve 442056 442056 0 0.00 0 60895 188 0 0
sp_fill_shopping_cart 30904 30904 0 0.00 1 21192 40 0 0
sp_fill_shopping_cart_clo_res 442043 442043 0 0.00 0 26224 19 0 0
sp_get_clo_for_invoice 4805 4805 0 0.00 0 48816 349 0 0
sp_kill_cost_storno 16177 16177 0 0.00 0 10986 66 0 0
sp_kill_qstorno_ret_qs2qd 1044041 1044041 0 0.00 0 102153 40 0 0
sp_kill_qty_storno 551492 551492 0 0.00 0 102154 86 0 0
sp_lock_selected_doc 19954 19954 0 0.00 0 8024 5 0 0
sp_make_cost_storno 26890 26890 0 0.00 0 12484 61 0 0
sp_multiply_rows_for_pdistr 26889 26889 0 0.00 0 8802 41 0 0
sp_multiply_rows_for_qdistr 20075 20075 0 0.00 0 14576 214 0 0
sp_pay_from_customer 6837 6837 0 0.00 4 14112 142 0 0
sp_pay_to_supplier 5630 5630 0 0.00 4 13867 154 0 0
sp_payment_common 12467 12467 0 0.00 1 7908 31 0 0
sp_qd_handle_on_cancel_clo 1666 1666 0 0.00 0 9378 359 0 0
sp_qd_handle_on_invoice_upd_sts 10108 10108 0 0.00 0 54005 423 0 0
sp_qd_handle_on_reserve_upd_sts 9619 9619 0 0.00 0 9408 52 0 0
sp_reserve_write_off 9619 9619 0 0.00 7 15443 210 0 0
sp_supplier_invoice 5504 5504 0 0.00 6 122767 3773 0 0
sp_supplier_order 5346 5346 0 0.00 5 30923 1512 0 0
srv_aggregate_perf_data 115 115 0 0.00 2617 95748 13252 0 0
srv_fill_mon_cache_memory 64 64 0 0.00 1519 164379 44699 0 0
srv_find_qd_qs_mism 993232 993232 0 0.00 0 30326 6 0 0
srv_make_invnt_saldo 455 455 0 0.00 76 123231 3876 0 0
srv_make_money_saldo 694 694 0 0.00 0 15078 544 0 0
srv_recalc_idx_stat 4 4 0 0.00 154461 350799 271048 0 0
t$perf-abend:sp_add_invoice_to_stock 141 141 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 15 15 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4818 4818 0 0.00 0 11532 194 0 0
t$perf-norm:sp_cancel_adding_invoice 394 394 0 0.00 1 4321 93 0 0
t$perf-norm:sp_cancel_client_order 1666 1666 0 0.00 0 3656 11 0 0
t$perf-norm:sp_cancel_customer_reserve 666 666 0 0.00 0 942 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 647 647 0 0.00 0 1834 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 412 412 0 0.00 0 999 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 372 372 0 0.00 0 2083 27 0 0
t$perf-norm:sp_cancel_supplier_order 406 406 0 0.00 0 39623 1549 0 0
t$perf-norm:sp_cancel_write_off 969 969 0 0.00 0 5468 11 0 0
t$perf-norm:sp_client_order 20075 20075 0 0.00 0 15889 25 0 0
t$perf-norm:sp_customer_reserve 996 996 0 0.00 0 5405 15 0 0
t$perf-norm:sp_pay_from_customer 6837 6837 0 0.00 0 8150 8 0 0
t$perf-norm:sp_pay_to_supplier 5630 5630 0 0.00 0 6010 10 0 0
t$perf-norm:sp_reserve_write_off 9619 9619 0 0.00 0 10891 12 0 0
t$perf-norm:sp_supplier_invoice 5504 5504 0 0.00 0 10954 19 0 0
t$perf-norm:sp_supplier_order 5346 5346 0 0.00 0 2923 15 0 0
t$perf-norm:srv_aggregate_perf_data 115 115 0 0.00 0 381 12 0 0
t$perf-norm:srv_fill_mon_cache_memory 64 64 0 0.00 0 2173 34 0 0
t$perf-norm:srv_make_invnt_saldo 455 455 0 0.00 0 2822 14 0 0
t$perf-norm:srv_make_money_saldo 694 694 0 0.00 0 729 8 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 4 2 0 0
v_add_invoice_to_stock 9888 9606 282 2.85 0 12080 22 0 282
v_all_customers 36800 36800 0 0.00 0 134 1 0 0
v_all_suppliers 29782 29782 0 0.00 0 45 1 0 0
v_all_wares 40144 40144 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 788 788 0 0.00 0 2002 13 0 0
v_cancel_client_order 3332 3332 0 0.00 0 2164 5 0 0
v_cancel_customer_prepayment 1294 1294 0 0.00 0 2734 8 0 0
v_cancel_customer_reserve 1332 1332 0 0.00 0 1447 6 0 0
v_cancel_payment_to_supplier 824 824 0 0.00 0 465 4 0 0
v_cancel_supplier_invoice 774 744 30 3.87 0 2088 21 0 30
v_cancel_supplier_order 812 812 0 0.00 0 4362 9 0 0
v_cancel_write_off 1938 1938 0 0.00 0 2289 15 0 0
v_max_id_clo_ord 5341 5341 0 0.00 0 122 1 0 0
v_max_id_clo_res 996 996 0 0.00 0 4440 32 0 0
v_max_id_ord_sup 5489 5489 0 0.00 0 9026 4 0 0
v_max_non_paid_invoice 1569 1569 0 0.00 0 308 2 0 0
v_max_non_paid_realizn 3565 3565 0 0.00 0 2934 4 0 0
v_min_id_clo_ord 5341 5341 0 0.00 0 2627 7 0 0
v_min_id_clo_res 996 996 0 0.00 0 3195 17 0 0
v_min_id_ord_sup 5489 5489 0 0.00 0 10489 8 0 0
v_min_non_paid_invoice 5630 5630 0 0.00 0 7787 25 0 0
v_min_non_paid_realizn 6837 6837 0 0.00 0 7902 21 0 0
v_our_firm 9888 9888 0 0.00 0 19 1 0 0
v_reserve_write_off 19238 19238 0 0.00 0 12084 12 0 0
x_lock_depdocs_on_canc_invoice 10871 10871 0 0.00 0 22274 123 0 0
x_lock_depdocs_on_canc_sup_ord 406 406 0 0.00 0 14223 403 0 0
x_make_qstorno_1000_1200 5346 5346 0 0.00 2 30837 1427 0 0
x_make_qstorno_1200_2000 5504 5504 0 0.00 3 112249 3632 0 0
x_make_qstorno_2100_3300 442056 442056 0 0.00 0 60065 166 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 20-02-2021 04:27:53 to 20-02-2021 04:27:57.

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
01:57:01 9 8192000000 8796668848 8807174144 3189104 0.038 1 1 2 0 3286720 61840 35776
01:58:02 36102 8192000000 9739832800 10039582720 812891728 9.027 100 84 167 0 840417872 7741328 19784816
01:59:44 21425 8192000000 9776769536 10083454976 848652720 9.387 100 92 182 2 883967120 13865136 21449264
02:01:10 22429 8192000000 9803912256 10124136448 868201664 9.582 100 77 152 0 912182992 26858544 17122784
02:02:40 19353 8192000000 9868500304 10201112576 911169744 10.009 100 81 162 1 977710000 48802208 17738048
02:04:03 10791 8192000000 9921770528 10266742784 952278320 10.413 100 77 154 1 1033725104 65102816 16343968
02:05:19 7141 8192000000 9966618960 10317443072 993292800 10.813 100 84 168 1 1074139344 64283920 16562624
02:06:29 4056 8192000000 9997456032 10356047872 1017930448 11.052 100 91 182 0 1115730080 79574848 18224784
02:07:35 3740 8192000000 10022233488 10386493440 1038763520 11.253 100 88 177 0 1148301504 91587360 17950624
02:08:41 2632 8192000000 10032192064 10399412224 1055308528 11.412 100 91 184 2 1149113856 75617936 18187392
02:09:45 38454 8192000000 10008557728 10389229568 1067616032 11.529 100 64 123 4 1135699776 55602288 12481456
02:11:26 2491 8192000000 10014733664 10412257280 1078414784 11.632 100 51 103 0 1137952224 48811408 10726032
02:12:30 7816 8192000000 9994764368 10399031296 1085463536 11.700 100 40 75 2 1112452080 17733728 9254816
02:13:41 6310 8192000000 10001764080 10408263680 1092185232 11.763 100 29 57 2 1121306320 22922384 6198704
02:14:49 15581 8192000000 10023310384 10407591936 1100271696 11.840 100 71 143 0 1132411008 16813664 15325648
02:16:07 2426 8192000000 10036175728 10440491008 1100865232 11.846 100 52 102 0 1157659280 45611856 11182192
02:17:10 5302 8192000000 10002372432 10406305792 1088108704 11.725 99 36 73 0 1125588080 29699312 7780064
02:18:15 57024 8192000000 9980835296 10394771456 1070165680 11.554 98 36 71 3 1087510400 9706800 7637920
02:20:13 5742 8192000000 9981080800 10371047424 1051061920 11.371 99 55 109 0 1092689760 30089312 11538528
02:21:23 8654 8192000000 9916000144 10302115840 958062112 10.470 93 33 66 1 988187360 23398256 6726992
02:22:33 8562 8192000000 9930757360 10315984896 1006540096 10.942 99 43 86 1 1031007616 14785504 9682016
02:23:45 39315 8192000000 9945066800 10337824768 992461488 10.805 96 39 79 0 1015095536 14246784 8387264
02:25:25 8579 8192000000 9966239600 10356375552 1054440048 11.403 100 49 99 1 1092695952 26737328 11518576
02:26:35 12863 8192000000 9975017344 10377637888 1060810144 11.464 100 40 80 3 1095191344 25245136 9136064
02:27:58 29115 8192000000 10019902512 10409385984 1088595504 11.729 100 42 80 3 1121837056 24311696 8929856
02:29:31 65228 8192000000 10070851536 10475364352 1114906560 11.979 100 27 54 0 1174851872 54304272 5641040
02:31:42 19229 8192000000 10104700896 10525929472 1127390608 12.097 100 31 62 2 1224654112 90434352 6829152
02:33:05 34404 8192000000 10159043904 10573742080 1136897584 12.186 100 40 78 5 1255497904 109677552 8922768
02:35:12 6754 8192000000 10199011616 10607923200 1153953232 12.347 100 49 98 1 1292826688 128267088 10606368
02:36:23 2732 8192000000 10233511984 10637754368 1156533136 12.371 100 77 153 0 1336097840 162955488 16609216
02:37:31 1518 8192000000 10273028960 10680872960 1166486016 12.464 100 83 165 2 1379316752 194691008 18139728
02:38:38 9452 8192000000 10291275424 10703712256 1171123248 12.507 100 74 146 0 1395371056 207940880 16306928
02:39:57 9674 8192000000 10294907056 10716803072 1175863568 12.552 100 65 128 0 1403810416 212710496 15236352
02:41:11 2889 8192000000 10332188400 10753093632 1184973392 12.637 100 62 123 2 1438476272 239296544 14206336
02:42:18 4745 8192000000 10343851200 10758508544 1182641392 12.615 100 74 148 1 1444882576 245430368 16810816
02:43:32 2227 8192000000 10333753488 10740359168 1168697488 12.485 100 83 166 2 1430038544 242585920 18755136
02:44:40 2860 8192000000 10346705456 10756292608 1162793776 12.429 100 84 163 0 1448808432 267604608 18410048
02:45:47 1784 8192000000 10355052464 10764107776 1144179840 12.255 100 79 156 1 1455874848 294065168 17629840
02:46:52 15912 8192000000 10246736160 10675781632 1139190864 12.208 99 27 55 0 1332249056 186337040 6721152
02:48:12 6653 8192000000 10306556032 10718265344 1134818848 12.167 100 62 124 0 1390816144 241514656 14482640
02:49:22 9930 8192000000 10292938816 10734841856 1132805024 12.148 100 41 82 1 1412234688 268507120 10922544
02:50:42 3985 8192000000 10250891600 10689339392 1126661840 12.090 99 59 117 2 1350647472 210706048 13279584
02:51:53 13751 8192000000 10196334560 10622111744 1123612736 12.061 99 29 58 1 1305208192 174180160 7415296
02:53:21 15707 8192000000 10237953712 10666946560 1117465040 12.003 99 32 64 1 1348076480 222329248 8282192
02:54:39 20249 8192000000 10244609616 10699341824 1112345872 11.955 99 25 49 1 1328676976 210275328 6055776
02:56:02 16233 8192000000 10260023824 10744852480 1112764624 11.959 100 20 40 0 1371340624 253194080 5381920
02:57:21 30242 8192000000 10116269696 10673668096 1105387376 11.889 100 16 32 0 1300033600 190783248 3862976
02:58:55 65247 8192000000 10086718400 10506952704 1103038592 11.866 98 28 54 2 1140403472 31324400 6040480
03:01:23 125820 8192000000 10072817072 10500923392 1111808848 11.950 98 17 34 0 1177807392 62838528 3160016
03:04:30 164379 8192000000 10138542944 10607046656 1137676640 12.194 100 30 58 2 1222829920 79618624 5534656
03:08:36 29096 8192000000 10116139232 10556100608 1125924160 12.083 99 42 82 1 1195687568 60326416 9436992
03:10:11 46171 8192000000 10054591232 10542419968 1118894208 12.017 98 11 22 0 1183596832 62071984 2630640
03:11:59 31958 8192000000 10068890416 10503000064 1120251760 12.029 98 24 48 1 1156411920 30092144 6068016
03:13:41 46397 8192000000 10094977296 10540433408 1139106176 12.207 100 10 20 0 1229023248 87635904 2281168
03:15:28 88651 8192000000 10059365360 10528931840 1141361712 12.228 100 18 36 1 1208206672 62118656 4726304
03:18:03 50283 8192000000 10092483136 10562621440 1146313344 12.275 100 14 28 0 1195480416 46194496 2972576
03:20:21 47916 8192000000 10072233904 10517721088 1117847584 12.007 98 15 31 0 1184305232 63196576 3261072
03:22:17 25155 8192000000 10103514352 10558763008 1131162240 12.132 99 27 54 1 1209465312 72470880 5832192
03:23:47 38500 8192000000 10157152336 10600501248 1146128864 12.273 100 36 73 0 1238265216 84148400 7987952
03:25:26 32467 8192000000 10171623888 10617282560 1132159824 12.142 98 29 56 4 1248003520 109767344 6076352
03:26:59 57638 8192000000 10190901248 10664398848 1140435680 12.220 99 17 34 1 1274371120 129865168 4070272
03:29:04 12464 8192000000 10086792080 10518487040 1134315808 12.162 99 46 89 2 1169336544 25403424 9617312
03:30:17 19042 8192000000 10138511472 10574512128 1139950928 12.215 99 48 94 0 1216854096 67559712 9343456
03:31:47 16795 8192000000 10150424080 10574151680 1138169856 12.198 100 55 112 0 1218322288 69218336 10934096
03:33:06 55318 8192000000 10098917968 10537820160 1115983088 11.989 98 23 46 1 1181356848 60359904 5013856
03:35:04 92202 8192000000 10112118624 10550476800 1139715424 12.213 100 34 66 1 1214432288 67548384 7168480
03:37:54 62717 8192000000 10043767680 10527895552 1120598144 12.033 99 10 20 2 1164059808 41145344 2316320
03:40:14 85554 8192000000 10108727872 10573508608 1095750288 11.797 96 24 48 2 1164103968 63101712 5251968
03:43:02 43883 8192000000 10067292608 10512322560 1096823216 11.807 98 20 40 0 1129462816 28541008 4098592
03:44:52 67139 8192000000 10070917264 10502524928 1067356320 11.527 95 21 42 1 1123888368 51932832 4599216
03:47:05 64850 8192000000 10070453008 10538295296 1062839888 11.484 95 12 24 0 1143845632 78389424 2616320
03:49:19 78372 8192000000 10063632032 10532655104 1076994240 11.619 97 14 28 0 1164393872 84405824 2993808
03:51:46 57238 8192000000 10086012704 10550595584 1101825936 11.855 99 19 38 0 1140893600 35199104 3868560
03:53:45 98953 8192000000 10024280032 10466701312 1081898816 11.666 98 22 44 1 1115323632 28943664 4481152
03:56:28 83635 8192000000 10099062624 10552668160 1112041728 11.952 99 11 22 1 1202972656 88511424 2419504
03:58:54 45974 8192000000 10138439744 10648125440 1126522544 12.089 100 11 24 0 1240458608 111583744 2352320
04:00:59 53055 8192000000 10090796240 10543325184 1130231792 12.124 100 28 56 0 1196945952 61115952 5598208
04:03:12 64084 8192000000 10099170928 10568712192 1122970448 12.055 98 20 40 0 1171708880 44312320 4426112
04:05:26 59351 8192000000 10098343264 10530893824 1136679104 12.184 99 37 73 0 1176932416 32919312 7334000
04:07:27 65669 8192000000 10122033360 10602139648 1128164240 12.104 98 22 44 1 1186443648 53623344 4656064
04:09:33 17489 8192000000 10087873040 10523500544 1136578672 12.183 99 44 88 2 1173034880 27173216 9282992
04:10:50 157941 8192000000 10084725264 10586595328 1115921232 11.988 97 12 24 0 1155414000 37195744 2297024
04:14:28 118702 8192000000 10129573248 10589515776 1140788544 12.223 99 19 38 0 1234146096 89006064 4351488
04:17:40 37856 8192000000 10088083088 10617810944 1138890304 12.205 100 6 12 1 1205927584 65757552 1279728
04:19:18 61254 8192000000 10063478384 10503663616 1104288864 11.878 97 26 53 0 1130743440 21042112 5412464
04:21:32 55606 8192000000 10096059072 10537844736 1118510592 12.013 98 25 49 2 1151204080 27901088 4792400
04:23:33 55852 8192000000 10088474432 10527121408 1107972240 11.913 97 10 20 0 1170073792 60018432 2083120
04:25:29 54684 8192000000 10094704928 10515574784 1101402464 11.851 97 27 54 1 1140240464 33283264 5554736

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 20-02-2021 04:27:59 to 20-02-2021 04:28:14.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 141 v_add_invoice_to_stock 335544517
except 15 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 20-02-2021 04:28:15 to 20-02-2021 04:28:17.

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          225814
MON$OLDEST_ACTIVE               227753
MON$OLDEST_SNAPSHOT             227753
MON$NEXT_TRANSACTION            227753
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                       2087840
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             783
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.0.2370 Firebird 4.0 Release Candidate 1
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2370 Firebird 4.0 Release Candidate 1"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2370 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.2370 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 ---
:41: 
:42: mscs-test-161.budzdorov.ru    Sat Feb 20 04:27:04 2021
:43:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:44: 
--- end of diff output ---

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

20.02.21 04:28:18. 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-02-20 04:28:21 No severe PSQL-related problems occured
20.02.21 04:28:22. End of report.