Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 12.12.2020 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 16927988 kB
MemAvailable 31404596 kB
Buffers 20 kB
Cached 14581324 kB
SwapCached 3708 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-12 04:26:52
DTS_END                         2020-12-12 04:26:52.3030
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_SUPPLIER_INVOICE(39:5) ==> X_MAKE_QSTORNO_1200_2000(279:25) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/42332
TRN_ID                          237007
ATT_ID                          703
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: 8767.78 26791 1052134
customer order: creation 168.67 441 20240
customer order: refuse 15.26 319 1831
order to supplier: creation 46.92 1321 5630
order to supplier: removal 3.21 114339 385
invoice (draft): creation 45.43 3283 5452
invoice (draft): removal 48.40 1004 5808
invoice accept: apply 41.83 16627 5019
invoice accept: cancel 43.60 882 5232
customer reserve: creation 3826.73 163 459208
customer reserve: removal 4235.05 69 508206
realization accept: apply 84.38 161 10126
realization accept: cancel 80.13 133 9615
payment from customer: creation 59.24 109 7109
payment from customer: removal 5.93 94 711
payment to supplier: creation 49.13 132 5896
payment to supplier: removal 3.43 98 411
service: total inventory turnovers 3.68 3344 442
service: total monetary turnovers 6.05 458 726
service: aggregate perf. data 0.69 23082 83
service: refresh index statistics 0.03 369762 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-12-2020 04:27:57 to 12-12-2020 04:27:59.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1540
TEST_TIME 2 2535
TEST_TIME 3 3517
TEST_TIME 4 4401
TEST_TIME 5 4810
TEST_TIME 6 4795
TEST_TIME 7 5317
TEST_TIME 8 5758
TEST_TIME 9 5911
TEST_TIME 10 6320
TEST_TIME 11 6563
TEST_TIME 12 6855
TEST_TIME 13 6865
TEST_TIME 14 7071
TEST_TIME 15 7717
TEST_TIME 16 8156
TEST_TIME 17 8454
TEST_TIME 18 8757
TEST_TIME 19 8811
TEST_TIME 20 9273
TEST_TIME 21 9760
TEST_TIME 22 9974
TEST_TIME 23 10751
TEST_TIME 24 11456
TEST_TIME 25 11272
TEST_TIME 26 11221
TEST_TIME 27 10978
TEST_TIME 28 10716
TEST_TIME 29 10767
TEST_TIME 30 10656
TEST_TIME 31 10330
TEST_TIME 32 10254
TEST_TIME 33 10157
TEST_TIME 34 9941
TEST_TIME 35 9907
TEST_TIME 36 9983
TEST_TIME 37 9830
TEST_TIME 38 9790
TEST_TIME 39 9806
TEST_TIME 40 9665
TEST_TIME 41 9651
TEST_TIME 42 9610
TEST_TIME 43 9580
TEST_TIME 44 9497
TEST_TIME 45 9426
TEST_TIME 46 9475
TEST_TIME 47 9515
TEST_TIME 48 9579
TEST_TIME 49 9605
TEST_TIME 50 9685
TEST_TIME 51 9805
TEST_TIME 52 9790
TEST_TIME 53 9808
TEST_TIME 54 9673
TEST_TIME 55 9542
TEST_TIME 56 9498
TEST_TIME 57 9468
TEST_TIME 58 9412
TEST_TIME 59 9323
TEST_TIME 60 9296
TEST_TIME 61 9281
TEST_TIME 62 9381
TEST_TIME 63 9347
TEST_TIME 64 9352
TEST_TIME 65 9468
TEST_TIME 66 9426
TEST_TIME 67 9504
TEST_TIME 68 9523
TEST_TIME 69 9583
TEST_TIME 70 9648
TEST_TIME 71 9572
TEST_TIME 72 9575
TEST_TIME 73 9478
TEST_TIME 74 9420
TEST_TIME 75 9337
TEST_TIME 76 9271
TEST_TIME 77 9259
TEST_TIME 78 9234
TEST_TIME 79 9173
TEST_TIME 80 9172
TEST_TIME 81 9164
TEST_TIME 82 9112
TEST_TIME 83 9086
TEST_TIME 84 9165
TEST_TIME 85 9107
TEST_TIME 86 9128
TEST_TIME 87 9115
TEST_TIME 88 9130
TEST_TIME 89 9146
TEST_TIME 90 9227
TEST_TIME 91 9248
TEST_TIME 92 9152
TEST_TIME 93 9116
TEST_TIME 94 9071
TEST_TIME 95 9019
TEST_TIME 96 9000
TEST_TIME 97 8970
TEST_TIME 98 8972
TEST_TIME 99 8965
TEST_TIME 100 8966
TEST_TIME 101 8966
TEST_TIME 102 8931
TEST_TIME 103 8965
TEST_TIME 104 8920
TEST_TIME 105 8981
TEST_TIME 106 9000
TEST_TIME 107 8975
TEST_TIME 108 8997
TEST_TIME 109 8936
TEST_TIME 110 8884
TEST_TIME 111 8838
TEST_TIME 112 8793
TEST_TIME 113 8798
TEST_TIME 114 8771
TEST_TIME 115 8765
TEST_TIME 116 8759
TEST_TIME 117 8732
TEST_TIME 118 8773
TEST_TIME 119 8781
TEST_TIME 120 8769

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 12-12-2020 04:28:01 to 12-12-2020 04:28:04.

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 1476891 1476891 0 0.00 0 21115 6 0 0
doc_list_biud 1476891 1476891 0 0.00 0 84985 30 0 0
sp_add_invoice_to_stock 5168 5019 149 2.88 40 155598 16628 0 149
sp_cancel_adding_invoice 5232 5232 0 0.00 5 77177 883 0 0
sp_cancel_client_order 1831 1831 0 0.00 4 9014 319 0 0
sp_cancel_customer_reserve 508206 508206 0 0.00 1 22226 69 0 0
sp_cancel_pay_from_customer 711 711 0 0.00 3 7934 94 0 0
sp_cancel_pay_to_supplier 411 411 0 0.00 3 14144 99 0 0
sp_cancel_supplier_invoice 5823 5808 15 0.25 2 85029 1004 0 15
sp_cancel_supplier_order 385 385 0 0.00 8 996227 114340 0 0
sp_cancel_write_off 9615 9615 0 0.00 1 22980 134 0 0
sp_client_order 20240 20240 0 0.00 4 50751 441 0 0
sp_customer_reserve 459208 459208 0 0.00 0 89137 163 0 0
sp_fill_shopping_cart 31322 31322 0 0.00 1 19199 42 0 0
sp_fill_shopping_cart_clo_res 459205 459205 0 0.00 0 28020 18 0 0
sp_get_clo_for_invoice 5016 5016 0 0.00 0 30659 400 0 0
sp_kill_cost_storno 15969 15969 0 0.00 0 6152 58 0 0
sp_kill_qstorno_ret_qs2qd 1032220 1032220 0 0.00 0 84985 38 0 0
sp_kill_qty_storno 546219 546219 0 0.00 0 84985 81 0 0
sp_lock_selected_doc 20957 20957 0 0.00 0 8288 7 0 0
sp_make_cost_storno 28147 28147 0 0.00 0 17954 50 0 0
sp_multiply_rows_for_pdistr 28147 28147 0 0.00 0 9166 29 0 0
sp_multiply_rows_for_qdistr 20240 20240 0 0.00 0 50707 261 0 0
sp_pay_from_customer 7109 7109 0 0.00 4 14258 110 0 0
sp_pay_to_supplier 5896 5896 0 0.00 5 18076 133 0 0
sp_payment_common 13005 13005 0 0.00 1 9682 22 0 0
sp_qd_handle_on_cancel_clo 1831 1831 0 0.00 0 9005 285 0 0
sp_qd_handle_on_invoice_upd_sts 10248 10248 0 0.00 0 34426 357 0 0
sp_qd_handle_on_reserve_upd_sts 10126 10126 0 0.00 0 9715 49 0 0
sp_reserve_write_off 10126 10126 0 0.00 6 14460 161 0 0
sp_supplier_invoice 5452 5452 0 0.00 6 94134 3284 0 0
sp_supplier_order 5630 5630 0 0.00 6 36622 1322 0 0
srv_aggregate_perf_data 83 83 0 0.00 2721 379121 23082 0 0
srv_fill_mon_cache_memory 62 62 0 0.00 2248 158945 49490 0 0
srv_find_qd_qs_mism 1004493 1004493 0 0.00 0 21115 6 0 0
srv_make_invnt_saldo 442 442 0 0.00 38 86537 3345 0 0
srv_make_money_saldo 726 726 0 0.00 1 11014 459 0 0
srv_recalc_idx_stat 4 4 0 0.00 249641 481859 369763 0 0
t$perf-abend:sp_add_invoice_to_stock 149 149 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 5019 5019 0 0.00 0 15477 148 0 0
t$perf-norm:sp_cancel_adding_invoice 406 406 0 0.00 0 5323 93 0 0
t$perf-norm:sp_cancel_client_order 1831 1831 0 0.00 0 2547 9 0 0
t$perf-norm:sp_cancel_customer_reserve 695 695 0 0.00 0 476 7 0 0
t$perf-norm:sp_cancel_pay_from_customer 711 711 0 0.00 0 1584 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 411 411 0 0.00 0 122 2 0 0
t$perf-norm:sp_cancel_supplier_invoice 396 396 0 0.00 0 3417 19 0 0
t$perf-norm:sp_cancel_supplier_order 385 385 0 0.00 0 30220 1339 0 0
t$perf-norm:sp_cancel_write_off 980 980 0 0.00 0 4267 11 0 0
t$perf-norm:sp_client_order 20240 20240 0 0.00 0 14682 16 0 0
t$perf-norm:sp_customer_reserve 990 990 0 0.00 0 2309 9 0 0
t$perf-norm:sp_pay_from_customer 7109 7109 0 0.00 0 3348 8 0 0
t$perf-norm:sp_pay_to_supplier 5896 5896 0 0.00 0 2955 6 0 0
t$perf-norm:sp_reserve_write_off 10126 10126 0 0.00 0 8005 9 0 0
t$perf-norm:sp_supplier_invoice 5452 5452 0 0.00 0 11386 18 0 0
t$perf-norm:sp_supplier_order 5630 5630 0 0.00 0 4703 12 0 0
t$perf-norm:srv_aggregate_perf_data 83 83 0 0.00 0 481 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 62 62 0 0.00 0 110 3 0 0
t$perf-norm:srv_make_invnt_saldo 442 442 0 0.00 0 2379 20 0 0
t$perf-norm:srv_make_money_saldo 726 726 0 0.00 0 2610 7 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 2 2 0 0
v_add_invoice_to_stock 10330 10032 298 2.88 0 4911 19 0 298
v_all_customers 37048 37048 0 0.00 0 28 1 0 0
v_all_suppliers 30642 30642 0 0.00 0 48 1 0 0
v_all_wares 40480 40480 0 0.00 0 67 1 0 0
v_cancel_adding_invoice 812 812 0 0.00 0 7461 15 0 0
v_cancel_client_order 3662 3662 0 0.00 0 2351 6 0 0
v_cancel_customer_prepayment 1422 1422 0 0.00 0 2098 7 0 0
v_cancel_customer_reserve 1390 1390 0 0.00 0 1769 7 0 0
v_cancel_payment_to_supplier 822 822 0 0.00 0 7987 16 0 0
v_cancel_supplier_invoice 822 792 30 3.64 0 1595 17 0 30
v_cancel_supplier_order 770 770 0 0.00 0 890 4 0 0
v_cancel_write_off 1960 1960 0 0.00 0 4291 15 0 0
v_max_id_clo_ord 5630 5630 0 0.00 0 1453 2 0 0
v_max_id_clo_res 990 990 0 0.00 0 1050 8 0 0
v_max_id_ord_sup 5452 5452 0 0.00 0 4022 7 0 0
v_max_non_paid_invoice 1657 1657 0 0.00 0 3369 4 0 0
v_max_non_paid_realizn 3795 3795 0 0.00 0 3037 4 0 0
v_min_id_clo_ord 5630 5630 0 0.00 0 5367 5 0 0
v_min_id_clo_res 990 990 0 0.00 0 470 2 0 0
v_min_id_ord_sup 5452 5452 0 0.00 0 5427 9 0 0
v_min_non_paid_invoice 5896 5896 0 0.00 0 9677 12 0 0
v_min_non_paid_realizn 7109 7109 0 0.00 0 7296 14 0 0
v_our_firm 10060 10060 0 0.00 0 17 1 0 0
v_reserve_write_off 20252 20252 0 0.00 0 4697 6 0 0
x_lock_depdocs_on_canc_invoice 10644 10644 0 0.00 0 27173 120 0 0
x_lock_depdocs_on_canc_sup_ord 385 385 0 0.00 0 14847 419 0 0
x_make_qstorno_1000_1200 5630 5630 0 0.00 2 36607 1254 0 0
x_make_qstorno_1200_2000 5452 5452 0 0.00 3 88389 3120 0 0
x_make_qstorno_2100_3300 459208 459208 0 0.00 0 89095 143 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-12-2020 04:28:05 to 12-12-2020 04:28:09.

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:56:56 8 8192000000 8796641776 8807108608 3168704 0.038 1 1 2 0 3266400 61840 35856
01:57:56 29412 8192000000 9728635696 10027749376 808343120 8.981 100 88 176 1 837233248 7435680 21454448
01:59:32 13376 8192000000 9777034544 10083655680 851486928 9.415 100 94 187 0 886201968 12856096 21858944
02:00:49 11325 8192000000 9801200976 10117455872 870955824 9.610 100 85 171 0 909561424 18724016 19881584
02:02:03 14531 8192000000 9858032944 10187632640 907551488 9.973 100 79 158 0 968751696 44011808 17188400
02:03:22 9413 8192000000 9917627760 10261118976 951795488 10.409 100 85 170 1 1029214560 59433024 17986048
02:04:35 8137 8192000000 9951894368 10307891200 993350880 10.814 100 77 155 0 1061726288 51401296 16974112
02:05:46 2895 8192000000 10005062304 10362478592 1016772640 11.041 100 86 171 2 1117117232 83224640 17119952
02:06:51 3856 8192000000 10004110576 10368266240 1039151024 11.257 100 88 176 2 1124864144 67966240 17746880
02:07:56 1561 8192000000 10032781648 10403446784 1061529952 11.471 100 93 184 0 1148997680 68644832 18822896
02:09:00 5048 8192000000 10013098656 10403631104 1070593952 11.558 100 59 118 0 1142202256 59372000 12236304
02:10:05 6984 8192000000 10006504672 10403221504 1072765136 11.578 100 34 68 1 1126349568 46185584 7398848
02:11:13 5831 8192000000 10007029184 10400800768 1078727200 11.635 100 35 71 0 1114646000 28871872 7046928
02:12:21 45128 8192000000 9981487136 10384629760 1080570144 11.653 100 36 69 1 1110194496 21849760 7774592
02:14:30 8876 8192000000 10016130896 10414333952 1081365328 11.660 99 44 89 2 1118777104 27508720 9903056
02:15:39 4768 8192000000 10004473728 10405539840 1093126768 11.772 100 39 79 2 1112848784 10659424 9062592
02:16:47 57742 8192000000 10011177344 10394800128 1069896368 11.551 99 54 109 2 1106585344 25393104 11295872
02:18:45 8058 8192000000 9971185008 10369597440 1013827488 11.012 96 36 71 1 1045848496 25015040 7005968
02:19:55 7914 8192000000 9946549440 10335305728 1007383680 10.950 97 42 83 1 1028388432 11845328 9159424
02:21:04 6546 8192000000 9950613408 10340950016 997029088 10.850 96 48 96 2 1017271904 9481600 10761216
02:22:11 20199 8192000000 9940148464 10328690688 983575392 10.719 95 18 36 1 1011012544 23975824 3461328
02:23:32 6595 8192000000 9980966416 10366754816 1053366816 11.393 100 54 106 4 1086858864 20403072 13088976
02:24:41 8846 8192000000 9996449280 10393108480 1061286816 11.469 100 40 80 1 1080796784 10267760 9242208
02:25:50 63936 8192000000 9964565104 10376237056 1070217168 11.554 100 33 66 0 1096738240 19558320 6962752
02:28:01 20756 8192000000 10035174352 10434981888 1092580272 11.767 100 43 84 2 1131924128 30676048 8667808
02:29:36 16321 8192000000 10086788736 10492182528 1113311520 11.964 100 41 82 2 1193846944 71889072 8646352
02:30:56 10892 8192000000 10112939296 10526437376 1129141120 12.113 100 53 106 0 1221317472 79530320 12646032
02:32:22 3783 8192000000 10168668144 10575708160 1144168400 12.255 100 61 122 0 1270258560 113035888 13054272
02:33:31 13311 8192000000 10221000272 10626719744 1152667712 12.335 100 63 125 1 1326196112 159561600 13966800
02:34:55 7120 8192000000 10255605712 10668417024 1149772832 12.307 98 52 104 0 1345907888 184643584 11491472
02:36:05 26963 8192000000 10292590704 10708156416 1174646368 12.540 100 55 108 0 1387720544 200561456 12512720
02:37:37 5062 8192000000 10314903248 10725998592 1194568000 12.726 100 70 140 1 1418522240 208626832 15327408
02:38:45 2357 8192000000 10383481616 10786816000 1192359168 12.705 100 86 172 2 1476752912 265366304 19027440
02:39:51 6881 8192000000 10378960560 10791477248 1164208960 12.443 99 67 134 1 1473994528 294033216 15752352
02:41:05 2247 8192000000 10423707392 10850123776 1184545616 12.633 100 84 166 0 1522890688 319996496 18348576
02:42:09 3853 8192000000 10333969472 10760245248 1143425744 12.248 100 54 107 2 1431098528 274669344 13003440
02:43:17 10385 8192000000 10373644016 10819485696 1164539136 12.446 99 52 98 1 1504398816 327380640 12479040
02:44:29 8675 8192000000 10346160304 10767626240 1100855568 11.846 97 36 71 0 1419060160 309331792 8872800
02:45:43 4718 8192000000 10411160144 10824298496 1146643968 12.278 100 80 160 2 1499125376 334055600 18425808
02:46:52 22096 8192000000 10316534128 10787262464 1120514832 12.032 99 37 74 1 1433829200 303769408 9544960
02:48:44 14259 8192000000 10272401600 10720047104 1114241152 11.973 99 28 56 2 1387950464 266623664 7085648
02:50:07 90374 8192000000 10043456032 10467794944 1064739504 11.502 95 11 22 0 1113260304 46316720 2204080
02:52:42 55361 8192000000 10071508016 10501095424 1112726736 11.958 99 11 22 0 1149724880 34134080 2864064
02:54:53 23274 8192000000 10098989856 10532966400 1108455920 11.918 98 20 40 0 1183575968 70235088 4884960
02:56:31 158931 8192000000 10074238752 10533986304 1093930688 11.780 97 24 47 1 1136568752 37814992 4823072
03:00:10 46775 8192000000 10089305376 10529914880 1100605552 11.843 97 17 34 2 1172056192 68254688 3195952
03:02:07 36445 8192000000 10101684496 10585653248 1140246912 12.218 100 37 72 3 1234681536 86654992 7779632
03:03:46 53244 8192000000 10119747552 10581749760 1147408816 12.285 100 22 44 1 1241792992 89496736 4887440
03:05:41 63069 8192000000 10092199872 10552578048 1137563200 12.193 99 23 45 3 1181202704 39083008 4556496
03:07:56 38507 8192000000 10087006288 10538913792 1142919776 12.243 100 14 28 2 1191143984 45644608 2579600
03:09:41 41339 8192000000 10067420576 10513358848 1118170464 12.010 98 19 38 1 1142514832 20476160 3868208
03:11:28 76141 8192000000 10159051200 10639015936 1140781840 12.223 99 23 46 2 1261388608 115091920 5514848
03:13:46 51695 8192000000 10140885664 10629926912 1139862640 12.214 99 17 34 1 1251342336 107569072 3910624
03:15:46 73332 8192000000 10132642528 10607927296 1129040064 12.112 98 24 49 0 1256087168 121409056 5638048
03:18:03 52590 8192000000 10085102064 10546245632 1134512720 12.164 99 19 38 0 1168216240 30045952 3657568
03:20:02 23688 8192000000 10080915664 10498469888 1094441552 11.785 97 40 81 1 1136314224 33516720 8355952
03:21:30 101847 8192000000 10109626752 10593112064 1121817488 12.044 100 28 55 4 1239329664 111360720 6151456
03:25:40 82909 8192000000 10072310160 10508693504 1048300864 11.344 93 13 27 0 1091845872 41055184 2489824
03:28:03 46892 8192000000 10046922880 10499465216 1069527488 11.548 96 14 28 4 1100897184 28348192 3021504
03:29:51 60110 8192000000 10112313360 10552520704 1083597184 11.682 96 28 55 1 1175455808 85916432 5942192
03:32:03 46831 8192000000 10085382928 10527449088 1098846256 11.827 98 19 38 0 1160590912 58063152 3681504
03:33:50 24076 8192000000 10099463520 10576646144 1119245440 12.020 99 31 62 0 1184506656 58610512 6650704
03:35:14 21628 8192000000 10120433824 10556813312 1112675120 11.958 99 65 126 3 1191205984 65460688 13070176
03:36:36 54471 8192000000 10051172128 10465914880 1100431360 11.842 98 23 46 0 1157957280 52006960 5518960
03:38:36 147817 8192000000 10034029632 10497060864 1075412592 11.604 96 22 44 1 1124933808 44753408 4767808
03:42:11 46209 8192000000 10048801424 10503598080 1112325280 11.954 100 6 12 0 1156224128 42746464 1152384
03:43:57 79356 8192000000 10042212592 10502328320 1082307104 11.669 97 17 34 1 1118611664 33058848 3245712
03:46:18 33763 8192000000 10061506080 10483552256 1090040096 11.743 98 22 44 0 1151456928 56539520 4877312
03:47:52 39987 8192000000 10104886928 10532450304 1120214688 12.029 100 42 84 1 1191811568 62181936 9414944
03:49:33 92264 8192000000 10093126032 10579726336 1097066208 11.810 98 23 46 1 1174458000 72020800 5370992
03:52:12 42990 8192000000 10069915984 10494869504 1108134448 11.915 99 18 36 0 1152325488 40570928 3620112
03:53:56 46278 8192000000 10088813392 10535215104 1113363680 11.964 99 14 28 0 1170734800 54573312 2797808
03:55:48 36359 8192000000 10136877488 10580422656 1126215680 12.086 99 27 53 3 1192649792 61351856 5082256
03:58:13 136346 8192000000 10077490544 10544226304 1124658128 12.071 99 26 51 3 1156265392 26083328 5523936
04:01:37 71814 8192000000 10063420368 10534846464 1127826576 12.101 99 8 16 1 1152504592 22771008 1907008
04:03:49 79523 8192000000 10107112640 10569932800 1147603168 12.287 100 20 40 2 1193288464 41313888 4371408
04:06:08 58328 8192000000 10098106944 10561589248 1086526256 11.710 95 17 34 1 1142459536 52482432 3450848
04:08:07 105934 8192000000 10089830464 10561781760 1088608336 11.729 95 24 48 0 1156081120 62163008 5309776
04:10:56 50593 8192000000 10067782864 10525392896 1118234784 12.010 99 31 62 1 1184693136 60493376 5964976
04:12:54 60422 8192000000 10071475504 10499346432 1105298096 11.888 98 36 72 1 1138967008 25834704 7834208
04:14:55 97103 8192000000 10058062464 10498572288 1102809408 11.864 98 29 57 3 1145540496 36925424 5805664
04:17:47 85770 8192000000 10069995648 10510819328 1067835024 11.531 95 7 14 1 1114166096 44599232 1731840
04:20:19 115443 8192000000 10061804656 10504859648 1066594592 11.520 96 8 16 0 1119644064 51667616 1381856
04:23:21 46333 8192000000 10109600880 10545840128 1085409792 11.699 97 29 57 0 1174349792 82255872 6684128
04:25:30 28557 8192000000 10077216528 10523910144 1106856320 11.903 99 35 70 0 1178279984 63498688 7924976

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 12-12-2020 04:28:11 to 12-12-2020 04:28:26.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 149 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 12-12-2020 04:28:27 to 12-12-2020 04:28:29.

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          231513
MON$OLDEST_ACTIVE               237128
MON$OLDEST_SNAPSHOT             237128
MON$NEXT_TRANSACTION            237128
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                       2074080
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             804
MON$NEXT_STATEMENT              53


ISQL Version: LI-V4.0.0.2296 Firebird 4.0 Release Candidate 1
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2296 Firebird 4.0 Release Candidate 1"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2296 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.2296 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 ---
:109: 
:110: mscs-test-161.budzdorov.ru    Sat Dec 12 04:26:59 2020
:111:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:112: 
:113: 
:114: mscs-test-161.budzdorov.ru    Sat Dec 12 04:27:03 2020
:115:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:116: 
:117: 
:118: mscs-test-161.budzdorov.ru    Sat Dec 12 04:27:04 2020
:119:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:120: 
--- end of diff output ---

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

12.12.20 04:28:30. 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-12 04:28:32 No severe PSQL-related problems occured
12.12.20 04:28:33. End of report.