Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 27.12.2020 13:28
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 17088632 kB
MemAvailable 31400792 kB
Buffers 0 kB
Cached 14541588 kB
SwapCached 4820 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 2020-12-27 13:26:53
DTS_END                         2020-12-27 13:26:53.1500
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/58506
TRN_ID                          222970
ATT_ID                          650
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: 8544.17 26166 1025300
customer order: creation 159.54 442 19145
customer order: refuse 13.54 362 1625
order to supplier: creation 40.75 1493 4890
order to supplier: removal 3.28 117089 394
invoice (draft): creation 41.68 4179 5002
invoice (draft): removal 48.56 1011 5827
invoice accept: apply 38.66 19248 4639
invoice accept: cancel 43.51 963 5221
customer reserve: creation 3552.68 190 426321
customer reserve: removal 4330.73 70 519687
realization accept: apply 76.30 166 9156
realization accept: cancel 77.19 114 9263
payment from customer: creation 55.06 108 6607
payment from customer: removal 4.83 69 580
payment to supplier: creation 44.85 117 5382
payment to supplier: removal 2.98 111 357
service: total inventory turnovers 3.67 3365 440
service: total monetary turnovers 5.42 526 650
service: aggregate perf. data 0.93 11390 111
service: refresh index statistics 0.03 362298 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 27-12-2020 13:28:39 to 27-12-2020 13:28:41.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1443
TEST_TIME 2 3004
TEST_TIME 3 3978
TEST_TIME 4 4660
TEST_TIME 5 4255
TEST_TIME 6 3966
TEST_TIME 7 4226
TEST_TIME 8 4208
TEST_TIME 9 4258
TEST_TIME 10 4590
TEST_TIME 11 4764
TEST_TIME 12 5326
TEST_TIME 13 5684
TEST_TIME 14 5966
TEST_TIME 15 6456
TEST_TIME 16 7267
TEST_TIME 17 7443
TEST_TIME 18 7882
TEST_TIME 19 7946
TEST_TIME 20 7816
TEST_TIME 21 8202
TEST_TIME 22 8303
TEST_TIME 23 8660
TEST_TIME 24 9239
TEST_TIME 25 9761
TEST_TIME 26 10775
TEST_TIME 27 10657
TEST_TIME 28 10749
TEST_TIME 29 10482
TEST_TIME 30 10263
TEST_TIME 31 10148
TEST_TIME 32 10011
TEST_TIME 33 9961
TEST_TIME 34 9729
TEST_TIME 35 9465
TEST_TIME 36 9516
TEST_TIME 37 9604
TEST_TIME 38 9574
TEST_TIME 39 9437
TEST_TIME 40 9399
TEST_TIME 41 9407
TEST_TIME 42 9324
TEST_TIME 43 9210
TEST_TIME 44 9149
TEST_TIME 45 9098
TEST_TIME 46 9181
TEST_TIME 47 9144
TEST_TIME 48 9061
TEST_TIME 49 9174
TEST_TIME 50 9111
TEST_TIME 51 9142
TEST_TIME 52 9155
TEST_TIME 53 9175
TEST_TIME 54 9136
TEST_TIME 55 9326
TEST_TIME 56 9343
TEST_TIME 57 9370
TEST_TIME 58 9318
TEST_TIME 59 9200
TEST_TIME 60 9135
TEST_TIME 61 9064
TEST_TIME 62 9051
TEST_TIME 63 8972
TEST_TIME 64 8905
TEST_TIME 65 8931
TEST_TIME 66 8881
TEST_TIME 67 8884
TEST_TIME 68 8841
TEST_TIME 69 8829
TEST_TIME 70 8910
TEST_TIME 71 8989
TEST_TIME 72 9020
TEST_TIME 73 9010
TEST_TIME 74 9079
TEST_TIME 75 9110
TEST_TIME 76 9109
TEST_TIME 77 9127
TEST_TIME 78 9082
TEST_TIME 79 8995
TEST_TIME 80 8934
TEST_TIME 81 8866
TEST_TIME 82 8807
TEST_TIME 83 8758
TEST_TIME 84 8731
TEST_TIME 85 8716
TEST_TIME 86 8695
TEST_TIME 87 8690
TEST_TIME 88 8673
TEST_TIME 89 8631
TEST_TIME 90 8663
TEST_TIME 91 8694
TEST_TIME 92 8698
TEST_TIME 93 8759
TEST_TIME 94 8802
TEST_TIME 95 8789
TEST_TIME 96 8820
TEST_TIME 97 8758
TEST_TIME 98 8715
TEST_TIME 99 8669
TEST_TIME 100 8635
TEST_TIME 101 8595
TEST_TIME 102 8591
TEST_TIME 103 8552
TEST_TIME 104 8543
TEST_TIME 105 8564
TEST_TIME 106 8564
TEST_TIME 107 8545
TEST_TIME 108 8548
TEST_TIME 109 8615
TEST_TIME 110 8595
TEST_TIME 111 8648
TEST_TIME 112 8695
TEST_TIME 113 8652
TEST_TIME 114 8673
TEST_TIME 115 8734
TEST_TIME 116 8660
TEST_TIME 117 8623
TEST_TIME 118 8583
TEST_TIME 119 8571
TEST_TIME 120 8544

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 27-12-2020 13:28:42 to 27-12-2020 13:28:46.

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 1420065 1420065 0 0.00 0 27295 7 0 0
doc_list_biud 1420065 1420065 0 0.00 0 143711 33 0 0
sp_add_invoice_to_stock 4770 4639 131 2.74 40 184500 19248 0 131
sp_cancel_adding_invoice 5221 5221 0 0.00 6 63053 964 0 0
sp_cancel_client_order 1625 1625 0 0.00 4 9198 362 0 0
sp_cancel_customer_reserve 519687 519687 0 0.00 1 22857 70 0 0
sp_cancel_pay_from_customer 580 580 0 0.00 2 2217 69 0 0
sp_cancel_pay_to_supplier 357 357 0 0.00 3 8097 111 0 0
sp_cancel_supplier_invoice 5839 5827 12 0.20 1 143715 1012 0 12
sp_cancel_supplier_order 394 394 0 0.00 8 1093422 117090 0 0
sp_cancel_write_off 9263 9263 0 0.00 1 11063 115 0 0
sp_client_order 19145 19145 0 0.00 4 31341 442 0 0
sp_customer_reserve 426321 426321 0 0.00 0 52105 190 0 0
sp_fill_shopping_cart 29026 29026 0 0.00 1 27628 48 0 0
sp_fill_shopping_cart_clo_res 426316 426316 0 0.00 0 27385 21 0 0
sp_get_clo_for_invoice 4634 4634 0 0.00 0 48027 508 0 0
sp_kill_cost_storno 15421 15421 0 0.00 0 18213 59 0 0
sp_kill_qstorno_ret_qs2qd 1054858 1054858 0 0.00 0 143710 38 0 0
sp_kill_qty_storno 555805 555805 0 0.00 0 143711 83 0 0
sp_lock_selected_doc 19039 19039 0 0.00 0 11051 6 0 0
sp_make_cost_storno 25777 25777 0 0.00 0 16142 48 0 0
sp_multiply_rows_for_pdistr 25777 25777 0 0.00 0 15067 29 0 0
sp_multiply_rows_for_qdistr 19145 19145 0 0.00 0 31194 263 0 0
sp_pay_from_customer 6607 6607 0 0.00 4 15093 108 0 0
sp_pay_to_supplier 5382 5382 0 0.00 5 13981 117 0 0
sp_payment_common 11989 11989 0 0.00 1 6706 17 0 0
sp_qd_handle_on_cancel_clo 1625 1625 0 0.00 0 9186 329 0 0
sp_qd_handle_on_invoice_upd_sts 9853 9853 0 0.00 0 26960 430 0 0
sp_qd_handle_on_reserve_upd_sts 9156 9156 0 0.00 0 14896 53 0 0
sp_reserve_write_off 9156 9156 0 0.00 6 14961 166 0 0
sp_supplier_invoice 5002 5002 0 0.00 7 158833 4179 0 0
sp_supplier_order 4890 4890 0 0.00 6 77624 1494 0 0
srv_aggregate_perf_data 111 111 0 0.00 2151 100814 11390 0 0
srv_fill_mon_cache_memory 59 59 0 0.00 1756 241244 51736 0 0
srv_find_qd_qs_mism 981478 981478 0 0.00 0 27290 6 0 0
srv_make_invnt_saldo 440 440 0 0.00 35 105906 3366 0 0
srv_make_money_saldo 650 650 0 0.00 1 11728 526 0 0
srv_recalc_idx_stat 3 3 0 0.00 276237 477092 362298 0 0
t$perf-abend:sp_add_invoice_to_stock 131 131 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 12 12 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4639 4639 0 0.00 0 18400 163 0 0
t$perf-norm:sp_cancel_adding_invoice 380 380 0 0.00 0 9345 140 0 0
t$perf-norm:sp_cancel_client_order 1625 1625 0 0.00 0 2679 10 0 0
t$perf-norm:sp_cancel_customer_reserve 658 658 0 0.00 0 1067 9 0 0
t$perf-norm:sp_cancel_pay_from_customer 580 580 0 0.00 0 2428 9 0 0
t$perf-norm:sp_cancel_pay_to_supplier 357 357 0 0.00 0 6381 26 0 0
t$perf-norm:sp_cancel_supplier_invoice 345 345 0 0.00 0 2481 24 0 0
t$perf-norm:sp_cancel_supplier_order 394 394 0 0.00 0 21775 1348 0 0
t$perf-norm:sp_cancel_write_off 913 913 0 0.00 0 1258 4 0 0
t$perf-norm:sp_client_order 19145 19145 0 0.00 0 8818 17 0 0
t$perf-norm:sp_customer_reserve 946 946 0 0.00 0 2133 7 0 0
t$perf-norm:sp_pay_from_customer 6607 6607 0 0.00 0 8344 11 0 0
t$perf-norm:sp_pay_to_supplier 5382 5382 0 0.00 0 8234 11 0 0
t$perf-norm:sp_reserve_write_off 9156 9156 0 0.00 0 6962 10 0 0
t$perf-norm:sp_supplier_invoice 5002 5002 0 0.00 0 5821 15 0 0
t$perf-norm:sp_supplier_order 4890 4890 0 0.00 0 9093 15 0 0
t$perf-norm:srv_aggregate_perf_data 111 111 0 0.00 0 131 5 0 0
t$perf-norm:srv_fill_mon_cache_memory 59 59 0 0.00 0 66 2 0 0
t$perf-norm:srv_make_invnt_saldo 440 440 0 0.00 0 1280 11 0 0
t$perf-norm:srv_make_money_saldo 650 650 0 0.00 0 346 4 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 1 2 2 0 0
v_add_invoice_to_stock 9524 9262 262 2.75 0 7251 17 0 262
v_all_customers 35260 35260 0 0.00 0 23 1 0 0
v_all_suppliers 27566 27566 0 0.00 0 51 1 0 0
v_all_wares 38284 38284 0 0.00 0 20 1 0 0
v_cancel_adding_invoice 760 760 0 0.00 0 984 7 0 0
v_cancel_client_order 3250 3250 0 0.00 0 1845 5 0 0
v_cancel_customer_prepayment 1160 1160 0 0.00 0 884 6 0 0
v_cancel_customer_reserve 1316 1316 0 0.00 0 14246 31 0 0
v_cancel_payment_to_supplier 714 714 0 0.00 0 636 7 0 0
v_cancel_supplier_invoice 714 690 24 3.36 0 3104 17 0 24
v_cancel_supplier_order 788 788 0 0.00 0 118 3 0 0
v_cancel_write_off 1826 1826 0 0.00 0 3739 16 0 0
v_max_id_clo_ord 4887 4887 0 0.00 0 1018 1 0 0
v_max_id_clo_res 946 946 0 0.00 0 3943 28 0 0
v_max_id_ord_sup 4996 4996 0 0.00 0 6516 4 0 0
v_max_non_paid_invoice 1481 1481 0 0.00 0 57 2 0 0
v_max_non_paid_realizn 3286 3286 0 0.00 0 432 2 0 0
v_min_id_clo_ord 4887 4887 0 0.00 0 4937 9 0 0
v_min_id_clo_res 946 946 0 0.00 0 5976 18 0 0
v_min_id_ord_sup 4996 4996 0 0.00 0 8881 11 0 0
v_min_non_paid_invoice 5382 5382 0 0.00 0 6704 9 0 0
v_min_non_paid_realizn 6607 6607 0 0.00 0 6226 15 0 0
v_our_firm 9666 9666 0 0.00 0 27 1 0 0
v_reserve_write_off 18312 18312 0 0.00 0 12784 6 0 0
x_lock_depdocs_on_canc_invoice 10703 10703 0 0.00 0 11881 100 0 0
x_lock_depdocs_on_canc_sup_ord 394 394 0 0.00 0 3239 322 0 0
x_make_qstorno_1000_1200 4890 4890 0 0.00 2 77617 1421 0 0
x_make_qstorno_1200_2000 5002 5002 0 0.00 4 155025 3985 0 0
x_make_qstorno_2100_3300 426321 426321 0 0.00 0 52105 167 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 27-12-2020 13:28:47 to 27-12-2020 13:28:51.

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
10:56:56 4 8192000000 8796637808 8807108608 3167696 0.038 1 1 2 0 3265392 61840 35856
10:57:58 25124 8192000000 9727508544 10024300544 798539072 8.881 100 83 166 0 825660512 7069344 20052096
10:59:30 19173 8192000000 9774269696 10078543872 844657184 9.347 100 93 187 2 879121536 12451584 22012768
11:00:52 20923 8192000000 9798783072 10114355200 863077904 9.531 100 82 164 1 905225088 22958848 19188336
11:02:17 13431 8192000000 9867625584 10202587136 914761088 10.044 100 72 144 3 978012080 47395968 15855024
11:03:38 9503 8192000000 9935149280 10280022016 966694896 10.554 100 75 149 2 1043316576 61216944 15404736
11:04:49 7195 8192000000 9972516304 10327003136 1001573584 10.894 100 86 170 1 1080465536 62015392 16876560
11:05:58 2707 8192000000 10016319744 10379939840 1023608832 11.107 100 78 152 3 1117704352 79107424 14988096
11:07:02 1790 8192000000 10045975360 10412474368 1051048000 11.371 100 96 191 2 1162423472 91842976 19532496
11:08:06 1589 8192000000 10029488752 10402029568 1068554832 11.538 100 95 190 0 1144476448 56604960 19316656
11:09:08 3241 8192000000 9998704656 10377113600 1075021872 11.600 100 67 137 1 1116566608 26204896 15339840
11:10:12 5308 8192000000 9994621328 10388336640 1078504560 11.633 100 53 107 4 1110182736 20083296 11594880
11:11:20 8058 8192000000 10009198400 10417229824 1089113024 11.734 100 28 56 3 1124533680 29722832 5697824
11:12:29 5031 8192000000 9997590128 10398769152 1092325072 11.765 100 28 56 0 1111745648 13831200 5589376
11:13:36 67885 8192000000 10001136208 10417733632 1084081328 11.686 99 35 70 2 1121096448 30086720 6928400
11:15:44 3161 8192000000 10035755712 10432819200 1098861968 11.827 100 52 103 3 1141349776 31917488 10570320
11:16:48 6579 8192000000 10012044320 10407526400 1088819200 11.731 100 50 98 4 1113383472 12703616 11860656
11:17:55 8369 8192000000 9954955520 10354565120 982162528 10.705 92 28 54 1 1015197888 26881696 6153664
11:19:05 50018 8192000000 9977641472 10373926912 1024408912 11.115 97 28 56 0 1044740384 13987968 6343504
11:20:59 10099 8192000000 9931482976 10318655488 989667664 10.778 96 40 78 1 1016402080 17693872 9040544
11:22:10 10973 8192000000 9945506640 10340532224 1015732720 11.031 98 46 91 4 1055391408 29846368 9812320
11:23:23 8665 8192000000 9993800864 10385436672 1050667232 11.367 100 51 102 1 1094997360 32015056 12315072
11:24:34 51343 8192000000 9965413280 10369286144 1059507232 11.452 100 26 52 1 1088425680 23592176 5326272
11:26:28 6487 8192000000 9993056208 10390880256 1083746464 11.683 100 38 75 3 1108420464 15744368 8929632
11:27:38 19157 8192000000 10033619280 10431954944 1096271344 11.802 100 44 86 4 1143360176 37168304 9920528
11:29:00 8151 8192000000 10068752240 10466160640 1109761456 11.930 100 51 102 1 1177990512 57703104 10525952
11:30:14 16225 8192000000 10090244480 10493726720 1128685424 12.109 100 55 104 0 1204420832 64844896 10890512
11:31:34 111810 8192000000 10202921136 10633498624 1147724848 12.288 100 36 72 1 1278270048 121176672 9368528
11:34:50 16137 8192000000 10244337584 10656464896 1162281120 12.425 100 55 110 2 1358134400 183753280 12100000
11:36:11 8597 8192000000 10258628960 10669998080 1173899280 12.533 100 50 100 1 1367033888 181883328 11251280
11:37:24 3259 8192000000 10328365872 10735644672 1171462048 12.510 100 74 148 2 1425161664 237348800 16350816
11:38:33 17756 8192000000 10316956416 10766827520 1170856128 12.505 100 54 108 0 1431475840 247909168 12710544
11:40:01 3216 8192000000 10353839200 10755973120 1174216000 12.536 100 81 160 4 1456784816 263979088 18589728
11:41:10 2032 8192000000 10385885616 10791723008 1175340672 12.547 100 83 166 1 1488346352 293865792 19139888
11:42:17 2241 8192000000 10394456352 10815221760 1165109776 12.451 99 78 156 1 1483789648 300167968 18511904
11:43:23 6214 8192000000 10305110096 10740297728 1155865088 12.365 100 47 94 1 1418432848 251273536 11294224
11:44:34 5927 8192000000 10311363968 10737389568 1159207744 12.396 99 57 111 5 1396512576 223845328 13459504
11:45:44 7557 8192000000 10364226064 10787184640 1167621392 12.475 100 44 89 0 1470225280 291605264 10998624
11:46:58 1755 8192000000 10434331632 10842140672 1153943600 12.346 99 89 179 4 1519026368 344980688 20102080
11:48:07 4573 8192000000 10406846208 10824794112 1139265936 12.209 100 38 76 1 1508146800 359126656 9754208
11:49:18 15255 8192000000 10426551440 10865127424 1149603040 12.306 100 29 58 1 1526794432 369044640 8146752
11:50:35 24978 8192000000 10335013040 10785730560 1112985776 11.961 97 27 54 3 1461516864 340681024 7850064
11:52:12 32839 8192000000 10169897408 10727161856 1116369904 11.993 99 12 24 1 1331383168 211724368 3288896
11:53:47 29779 8192000000 10082194368 10510458880 1110676848 11.939 99 45 90 0 1171301168 50860064 9764256
11:55:35 47650 8192000000 10041930800 10466914304 1074173888 11.592 96 28 56 6 1123022928 43923104 4925936
11:57:45 61882 8192000000 10049934288 10512031744 1097469088 11.814 98 13 26 1 1152515440 52499600 2546752
11:59:48 241214 8192000000 10093449584 10648846336 1089645552 11.739 96 19 38 0 1175021984 81446816 3929616
12:04:50 29946 8192000000 10097414928 10525745152 1129742032 12.119 100 47 90 1 1180992448 41408480 9841936
12:06:29 39090 8192000000 10086131664 10570424320 1129352880 12.115 100 17 34 1 1236342864 103128112 3861872
12:09:03 76057 8192000000 10100235936 10583273472 1149097872 12.301 100 13 26 1 1218816144 66838384 2879888
12:11:20 55501 8192000000 10107218048 10580545536 1121509216 12.041 98 10 20 0 1227016352 102972704 2534432
12:13:23 33977 8192000000 10073637232 10512936960 1135921584 12.177 99 41 81 2 1172327136 27457184 8948368
12:15:01 43164 8192000000 10101531856 10559479808 1147686016 12.288 100 39 78 2 1225585600 70277728 7621856
12:16:45 53462 8192000000 10123350560 10568863744 1151065536 12.319 100 26 52 0 1216030464 59971232 4993696
12:18:44 50262 8192000000 10134207888 10589413376 1128128608 12.104 98 29 58 2 1200744576 66650512 5965456
12:21:05 76021 8192000000 10064960016 10559066112 1113912464 11.969 97 8 16 0 1264526672 148595664 2018544
12:23:23 59945 8192000000 10065793104 10524184576 1112722272 11.958 97 30 60 1 1175240928 56640096 5878560
12:25:23 110587 8192000000 10113431088 10571153408 1144586272 12.259 100 44 88 0 1231264976 78082928 8595776
12:28:14 48084 8192000000 10067211520 10541678592 1136203264 12.180 100 12 24 0 1178552048 40192592 2156192
12:30:24 63240 8192000000 10098295344 10577907712 1142968032 12.243 99 14 28 0 1198953984 52953376 3032576
12:32:32 31918 8192000000 10091695152 10530574336 1130439808 12.126 98 20 40 0 1188020896 53459424 4121664
12:34:05 34962 8192000000 10113673504 10552213504 1141855088 12.233 99 22 44 1 1200628272 53180400 5592784
12:35:44 64565 8192000000 10203936512 10691661824 1149753328 12.307 99 20 38 1 1283617344 128835184 5028832
12:39:02 95332 8192000000 10109891104 10619510784 1112625472 11.957 96 22 44 3 1186795616 69603088 4567056
12:41:37 32684 8192000000 10099001216 10567897088 1131627376 12.137 99 26 52 0 1211779728 74460224 5692128
12:43:44 82106 8192000000 10086242752 10574434304 1107262592 11.906 97 29 58 0 1182294240 68781552 6250096
12:46:33 43664 8192000000 10047001504 10499407872 1126013024 12.084 99 9 19 0 1145269392 17529728 1726640
12:48:17 83930 8192000000 10054217008 10505297920 1093729392 11.778 96 9 18 0 1121615056 26118624 1767040
12:50:41 86626 8192000000 10058116576 10522710016 1114810000 11.978 99 16 32 3 1161800416 43470048 3520368
12:53:08 45112 8192000000 10040410992 10476797952 1054719200 11.406 94 23 46 1 1115368720 56238528 4410992
12:54:53 52483 8192000000 10080636528 10514604032 1095559040 11.795 99 24 48 1 1164211600 63091328 5561232
12:57:13 57468 8192000000 10059744320 10485866496 1092903648 11.770 97 22 44 2 1149931184 52952096 4075440
12:59:11 70046 8192000000 10114350512 10599677952 1121207152 12.038 99 28 56 1 1186706272 60059856 5439264
13:01:29 42618 8192000000 10071516416 10486079488 1094046304 11.781 96 40 76 0 1121409392 19549472 7813616
13:03:16 128650 8192000000 10043427920 10487472128 1092356592 11.765 97 29 59 0 1128075360 29229920 6488848
13:06:31 78660 8192000000 10067882912 10524770304 1119554192 12.023 99 11 22 0 1169045568 47081408 2409968
13:09:16 62249 8192000000 10089554048 10528104448 1123595968 12.061 99 21 42 1 1162577152 34340944 4640240
13:11:19 101986 8192000000 10112666416 10567532544 1099245680 11.830 97 22 44 0 1185433744 81375072 4812992
13:14:17 76391 8192000000 10108332672 10573131776 1125138880 12.076 99 22 44 3 1205776144 76014768 4622496
13:16:36 49398 8192000000 10150718160 10592800768 1127956304 12.102 99 35 70 1 1224183024 88936928 7289792
13:18:40 90770 8192000000 10109409216 10566762496 1110987648 11.942 97 13 25 1 1163997168 49962784 3046736
13:21:17 133010 8192000000 10074896288 10536509440 1141362448 12.228 100 11 22 2 1191593712 48002160 2229104
13:24:38 80050 8192000000 10077381536 10524512256 1123439728 12.059 99 11 22 1 1157584992 32147504 1997760

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 27-12-2020 13:28:53 to 27-12-2020 13:29:07.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 131 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 27-12-2020 13:29:08 to 27-12-2020 13:29:10.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          222955
MON$OLDEST_ACTIVE               224196
MON$OLDEST_SNAPSHOT             224196
MON$NEXT_TRANSACTION            224196
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                       2063648
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                        {8C105897-B735-40F5-7D8B-A1F76E952B78}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             779
MON$NEXT_STATEMENT              53


ISQL Version: LI-V4.0.0.2307 Firebird 4.0 Release Candidate 1
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2307 Firebird 4.0 Release Candidate 1"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2307 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.2307 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 ---
:108: 
:109: mscs-test-161.budzdorov.ru    Sun Dec 27 13:27:04 2020
:110:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:111: 
:112: 
:113: mscs-test-161.budzdorov.ru    Sun Dec 27 13:27:10 2020
:114:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:115: 
--- end of diff output ---

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

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