Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 19.01.2021 07: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 16953352 kB
MemAvailable 31207304 kB
Buffers 0 kB
Cached 14615108 kB
SwapCached 4864 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-01-19 07:27:32
DTS_END                         2021-01-19 07:26:53.8640
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_FILL_MON_CACHE_MEMORY(20:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/40330
TRN_ID                          223124
ATT_ID                          259
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 8359.59 21872 1003151
customer order: creation 161.21 442 19345
customer order: refuse 13.88 392 1666
order to supplier: creation 42.68 1374 5122
order to supplier: removal 3.08 137437 370
invoice (draft): creation 42.47 3803 5096
invoice (draft): removal 45.94 1164 5513
invoice accept: apply 39.47 18594 4736
invoice accept: cancel 41.28 1181 4954
customer reserve: creation 3672.70 178 440724
customer reserve: removal 4022.45 84 482694
realization accept: apply 79.62 207 9554
realization accept: cancel 74.68 137 8962
payment from customer: creation 55.49 138 6659
payment from customer: removal 5.38 122 645
payment to supplier: creation 45.57 155 5468
payment to supplier: removal 3.55 123 426
service: total inventory turnovers 3.72 4056 446
service: total monetary turnovers 5.48 689 657
service: aggregate perf. data 0.91 12055 109
service: refresh index statistics 0.04 255116 5

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 19-01-2021 07:28:14 to 19-01-2021 07:28:16.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2506
TEST_TIME 2 3361
TEST_TIME 3 3118
TEST_TIME 4 3472
TEST_TIME 5 4028
TEST_TIME 6 3777
TEST_TIME 7 4208
TEST_TIME 8 4409
TEST_TIME 9 4792
TEST_TIME 10 4790
TEST_TIME 11 4652
TEST_TIME 12 4672
TEST_TIME 13 4708
TEST_TIME 14 4894
TEST_TIME 15 5006
TEST_TIME 16 5113
TEST_TIME 17 5791
TEST_TIME 18 6162
TEST_TIME 19 6602
TEST_TIME 20 7109
TEST_TIME 21 6943
TEST_TIME 22 7202
TEST_TIME 23 7416
TEST_TIME 24 7395
TEST_TIME 25 7568
TEST_TIME 26 8274
TEST_TIME 27 8731
TEST_TIME 28 9955
TEST_TIME 29 10225
TEST_TIME 30 10031
TEST_TIME 31 9859
TEST_TIME 32 9647
TEST_TIME 33 9559
TEST_TIME 34 9704
TEST_TIME 35 9603
TEST_TIME 36 9423
TEST_TIME 37 9420
TEST_TIME 38 9326
TEST_TIME 39 9245
TEST_TIME 40 9168
TEST_TIME 41 9069
TEST_TIME 42 9119
TEST_TIME 43 9261
TEST_TIME 44 9134
TEST_TIME 45 9134
TEST_TIME 46 9163
TEST_TIME 47 9064
TEST_TIME 48 8992
TEST_TIME 49 8959
TEST_TIME 50 9250
TEST_TIME 51 9183
TEST_TIME 52 9289
TEST_TIME 53 9194
TEST_TIME 54 9285
TEST_TIME 55 9220
TEST_TIME 56 9081
TEST_TIME 57 8976
TEST_TIME 58 8922
TEST_TIME 59 8854
TEST_TIME 60 8795
TEST_TIME 61 8706
TEST_TIME 62 8692
TEST_TIME 63 8678
TEST_TIME 64 8661
TEST_TIME 65 8635
TEST_TIME 66 8689
TEST_TIME 67 8752
TEST_TIME 68 8849
TEST_TIME 69 8815
TEST_TIME 70 8795
TEST_TIME 71 8866
TEST_TIME 72 8846
TEST_TIME 73 8817
TEST_TIME 74 8887
TEST_TIME 75 8954
TEST_TIME 76 8910
TEST_TIME 77 8807
TEST_TIME 78 8752
TEST_TIME 79 8699
TEST_TIME 80 8631
TEST_TIME 81 8576
TEST_TIME 82 8569
TEST_TIME 83 8553
TEST_TIME 84 8536
TEST_TIME 85 8551
TEST_TIME 86 8576
TEST_TIME 87 8548
TEST_TIME 88 8551
TEST_TIME 89 8544
TEST_TIME 90 8508
TEST_TIME 91 8604
TEST_TIME 92 8627
TEST_TIME 93 8675
TEST_TIME 94 8625
TEST_TIME 95 8554
TEST_TIME 96 8542
TEST_TIME 97 8517
TEST_TIME 98 8486
TEST_TIME 99 8482
TEST_TIME 100 8447
TEST_TIME 101 8442
TEST_TIME 102 8418
TEST_TIME 103 8405
TEST_TIME 104 8449
TEST_TIME 105 8460
TEST_TIME 106 8450
TEST_TIME 107 8488
TEST_TIME 108 8553
TEST_TIME 109 8543
TEST_TIME 110 8552
TEST_TIME 111 8612
TEST_TIME 112 8550
TEST_TIME 113 8481
TEST_TIME 114 8461
TEST_TIME 115 8415
TEST_TIME 116 8387
TEST_TIME 117 8391
TEST_TIME 118 8366
TEST_TIME 119 8354
TEST_TIME 120 8364

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 19-01-2021 07:28:18 to 19-01-2021 07:28:21.

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 1409842 1409842 0 0.00 0 14948 7 0 0
doc_list_biud 1409841 1409841 0 0.00 0 49196 36 0 0
sp_add_invoice_to_stock 4869 4736 133 2.73 29 207080 18595 0 133
sp_cancel_adding_invoice 4954 4954 0 0.00 5 106221 1182 0 0
sp_cancel_client_order 1666 1666 0 0.00 4 22159 392 0 0
sp_cancel_customer_reserve 482694 482694 0 0.00 1 47183 84 0 0
sp_cancel_pay_from_customer 645 645 0 0.00 3 13195 123 0 0
sp_cancel_pay_to_supplier 426 426 0 0.00 3 7632 123 0 0
sp_cancel_supplier_invoice 5526 5513 13 0.23 2 49203 1164 0 13
sp_cancel_supplier_order 370 370 0 0.00 9 1555357 137438 0 0
sp_cancel_write_off 8962 8962 0 0.00 1 17413 138 0 0
sp_client_order 19345 19345 0 0.00 4 23141 442 0 0
sp_customer_reserve 440724 440724 0 0.00 0 61771 178 0 0
sp_fill_shopping_cart 29555 29555 0 0.00 1 19971 48 0 0
sp_fill_shopping_cart_clo_res 440713 440713 0 0.00 0 30019 23 0 0
sp_get_clo_for_invoice 4725 4725 0 0.00 0 45381 519 0 0
sp_kill_cost_storno 14987 14987 0 0.00 0 10834 76 0 0
sp_kill_qstorno_ret_qs2qd 980233 980233 0 0.00 0 49193 46 0 0
sp_kill_qty_storno 518438 518438 0 0.00 0 49195 98 0 0
sp_lock_selected_doc 19696 19696 0 0.00 0 7327 7 0 0
sp_make_cost_storno 26406 26406 0 0.00 0 12412 70 0 0
sp_multiply_rows_for_pdistr 26406 26406 0 0.00 0 12014 41 0 0
sp_multiply_rows_for_qdistr 19345 19345 0 0.00 0 23124 251 0 0
sp_pay_from_customer 6659 6659 0 0.00 4 17593 138 0 0
sp_pay_to_supplier 5468 5468 0 0.00 5 13138 156 0 0
sp_payment_common 12127 12127 0 0.00 1 14092 31 0 0
sp_qd_handle_on_cancel_clo 1666 1666 0 0.00 0 22143 367 0 0
sp_qd_handle_on_invoice_upd_sts 9679 9679 0 0.00 0 30604 462 0 0
sp_qd_handle_on_reserve_upd_sts 9554 9554 0 0.00 0 9238 54 0 0
sp_reserve_write_off 9554 9554 0 0.00 6 18606 207 0 0
sp_supplier_invoice 5096 5096 0 0.00 7 94269 3804 0 0
sp_supplier_order 5122 5122 0 0.00 5 49775 1375 0 0
srv_aggregate_perf_data 109 109 0 0.00 2501 101056 12056 0 0
srv_fill_mon_cache_memory 59 59 0 0.00 907 157724 47651 0 0
srv_find_qd_qs_mism 957547 957547 0 0.00 0 12833 5 0 0
srv_make_invnt_saldo 446 446 0 0.00 36 181732 4057 0 0
srv_make_money_saldo 657 657 0 0.00 1 14965 690 0 0
srv_recalc_idx_stat 5 5 0 0.00 75175 461611 255117 0 0
t$perf-abend:sp_add_invoice_to_stock 133 133 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4737 4737 0 0.00 0 13046 186 0 0
t$perf-norm:sp_cancel_adding_invoice 393 393 0 0.00 0 2592 86 0 0
t$perf-norm:sp_cancel_client_order 1666 1666 0 0.00 0 2555 15 0 0
t$perf-norm:sp_cancel_customer_reserve 622 622 0 0.00 0 3514 18 0 0
t$perf-norm:sp_cancel_pay_from_customer 645 645 0 0.00 0 1025 4 0 0
t$perf-norm:sp_cancel_pay_to_supplier 426 426 0 0.00 0 6943 46 0 0
t$perf-norm:sp_cancel_supplier_invoice 393 393 0 0.00 0 1545 25 0 0
t$perf-norm:sp_cancel_supplier_order 370 370 0 0.00 0 20653 1641 0 0
t$perf-norm:sp_cancel_write_off 903 903 0 0.00 0 2736 8 0 0
t$perf-norm:sp_client_order 19345 19345 0 0.00 0 5847 19 0 0
t$perf-norm:sp_customer_reserve 920 920 0 0.00 0 3483 11 0 0
t$perf-norm:sp_pay_from_customer 6659 6659 0 0.00 0 8028 11 0 0
t$perf-norm:sp_pay_to_supplier 5468 5468 0 0.00 0 5333 12 0 0
t$perf-norm:sp_reserve_write_off 9554 9554 0 0.00 0 5633 10 0 0
t$perf-norm:sp_supplier_invoice 5096 5096 0 0.00 0 13343 30 0 0
t$perf-norm:sp_supplier_order 5122 5122 0 0.00 0 6756 18 0 0
t$perf-norm:srv_aggregate_perf_data 109 109 0 0.00 0 283 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 59 59 0 0.00 0 318 9 0 0
t$perf-norm:srv_make_invnt_saldo 446 446 0 0.00 0 1848 11 0 0
t$perf-norm:srv_make_money_saldo 657 657 0 0.00 0 5468 13 0 0
t$perf-norm:srv_recalc_idx_stat 5 5 0 0.00 2 5 4 0 0
v_add_invoice_to_stock 9714 9448 266 2.73 0 5598 17 0 266
v_all_customers 34904 34904 0 0.00 0 73 1 0 0
v_all_suppliers 28310 28310 0 0.00 0 29 1 0 0
v_all_wares 38690 38690 0 0.00 0 17 1 0 0
v_cancel_adding_invoice 786 786 0 0.00 0 1578 8 0 0
v_cancel_client_order 3332 3332 0 0.00 0 2642 6 0 0
v_cancel_customer_prepayment 1290 1290 0 0.00 0 6169 13 0 0
v_cancel_customer_reserve 1244 1244 0 0.00 0 885 4 0 0
v_cancel_payment_to_supplier 852 852 0 0.00 0 6040 14 0 0
v_cancel_supplier_invoice 812 786 26 3.20 0 2115 19 0 26
v_cancel_supplier_order 740 740 0 0.00 0 1774 11 0 0
v_cancel_write_off 1806 1806 0 0.00 0 4894 15 0 0
v_max_id_clo_ord 5122 5122 0 0.00 0 462 1 0 0
v_max_id_clo_res 920 920 0 0.00 0 2904 15 0 0
v_max_id_ord_sup 5088 5088 0 0.00 0 3645 4 0 0
v_max_non_paid_invoice 1523 1523 0 0.00 0 2843 5 0 0
v_max_non_paid_realizn 3650 3650 0 0.00 0 997 3 0 0
v_min_id_clo_ord 5122 5122 0 0.00 0 6113 8 0 0
v_min_id_clo_res 920 920 0 0.00 0 8825 25 0 0
v_min_id_ord_sup 5088 5088 0 0.00 0 5603 7 0 0
v_min_non_paid_invoice 5468 5468 0 0.00 0 10265 27 0 0
v_min_non_paid_realizn 6659 6659 0 0.00 0 7820 18 0 0
v_our_firm 9804 9804 0 0.00 0 16 1 0 0
v_reserve_write_off 19108 19108 0 0.00 0 4246 6 0 0
x_lock_depdocs_on_canc_invoice 10074 10074 0 0.00 0 19286 127 0 0
x_lock_depdocs_on_canc_sup_ord 370 370 0 0.00 0 7266 408 0 0
x_make_qstorno_1000_1200 5122 5122 0 0.00 2 49765 1292 0 0
x_make_qstorno_1200_2000 5096 5096 0 0.00 4 92916 3611 0 0
x_make_qstorno_2100_3300 440724 440724 0 0.00 0 61770 153 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 19-01-2021 07:28:22 to 19-01-2021 07:28:26.

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
04:56:57 10 8192000000 8797424800 8808288256 3168016 0.038 1 1 2 0 3265632 61840 35776
04:57:58 26778 8192000000 9712212048 10007031808 787881056 8.773 100 88 175 1 817037600 7502272 21654272
04:59:33 27304 8192000000 9762585328 10069069824 837844448 9.278 100 89 178 0 870661248 11569696 21247104
05:01:09 22016 8192000000 9810329008 10127888384 874100096 9.641 100 82 162 1 912353504 19822032 18431376
05:02:34 18127 8192000000 9875799632 10212093952 928313712 10.178 100 73 146 1 983293056 39556992 15422352
05:03:56 10962 8192000000 9927162992 10273517568 978569776 10.670 100 82 165 0 1040538304 45227216 16741312
05:05:11 5079 8192000000 9966409888 10321047552 998845008 10.867 100 88 176 0 1076068240 59180416 18042816
05:06:20 4449 8192000000 10007550768 10369781760 1021468560 11.086 100 86 170 1 1132266896 93411536 17386800
05:07:27 6800 8192000000 10007384928 10373414912 1041516560 11.279 100 85 171 0 1117350624 58559504 17274560
05:08:37 1840 8192000000 10032411968 10401964032 1064611184 11.501 100 92 186 0 1150382400 65665744 20105472
05:09:40 6676 8192000000 10019693632 10402095104 1068843584 11.541 100 60 120 1 1139806192 58781456 12181152
05:10:48 5343 8192000000 10004073008 10388996096 1073840288 11.589 100 51 103 0 1138915088 55305664 9769136
05:11:56 7121 8192000000 10001955456 10393792512 1078477664 11.633 100 42 82 0 1115095632 27097760 9520208
05:13:04 4709 8192000000 9999237456 10394234880 1087394576 11.718 100 41 86 1 1116145184 19144192 9606416
05:14:12 28899 8192000000 10015061680 10399072256 1091130784 11.753 100 77 154 4 1120756432 13463376 16162272
05:15:41 4474 8192000000 10037289952 10438340608 1095760192 11.797 100 47 94 0 1157110304 51735584 9614528
05:16:49 6399 8192000000 10030499872 10424971264 1086563808 11.710 99 42 83 3 1125283104 29649728 9069568
05:17:57 15014 8192000000 9990271552 10403819520 1087886064 11.723 100 31 62 2 1110009344 15499760 6623520
05:19:14 22137 8192000000 9980535760 10384121856 1051755376 11.378 97 27 53 0 1076448896 18354192 6339328
05:20:37 12079 8192000000 9958579872 10352390144 957148208 10.461 91 28 56 2 1008953040 45954016 5850816
05:21:51 3221 8192000000 9921145776 10286518272 994612672 10.826 99 48 99 0 1018620736 12359168 11648896
05:22:56 56271 8192000000 9955983040 10356531200 1006492352 10.941 97 37 74 0 1034587792 19660592 8434848
05:24:54 8952 8192000000 9970461120 10370633728 1044719328 11.310 100 39 76 1 1077981264 25073168 8188768
05:26:05 17704 8192000000 9981205120 10387185664 1069056016 11.543 100 33 66 1 1091140816 14084432 8000368
05:27:28 37718 8192000000 10023696448 10418778112 1093271568 11.774 100 45 89 2 1136794256 34091776 9430912
05:29:29 62891 8192000000 10078616976 10492469248 1113150848 11.962 100 35 69 1 1195514304 75069248 7294208
05:31:44 32868 8192000000 10122255952 10529452032 1128392208 12.106 100 46 92 1 1214427632 76073536 9961888
05:33:25 16136 8192000000 10167961008 10582007808 1139761664 12.213 100 50 100 0 1273392448 122860048 10770736
05:34:44 18724 8192000000 10234434000 10651271168 1160232704 12.405 100 62 121 0 1344546256 170778880 13534672
05:36:06 18048 8192000000 10243079344 10656329728 1170233520 12.499 100 48 93 2 1343267184 162410224 10623440
05:37:28 14474 8192000000 10288405008 10697674752 1182950064 12.618 100 59 117 0 1393862992 197152992 13759936
05:38:51 5535 8192000000 10350060080 10765017088 1189045264 12.674 100 58 115 0 1455863792 253748992 13069536
05:40:03 3074 8192000000 10402305648 10814394368 1202872256 12.803 100 68 137 2 1504859312 286553136 15433920
05:41:11 1080 8192000000 10454610448 10857623552 1201445472 12.790 100 86 174 1 1552416912 331252432 19719008
05:42:17 3704 8192000000 10481859056 10895749120 1199972032 12.776 100 76 150 1 1586128032 368601712 17554288
05:43:28 7118 8192000000 10481634672 10911002624 1190139184 12.685 100 80 159 1 1587195520 378033504 19022832
05:44:39 3416 8192000000 10469086400 10892599296 1175020912 12.544 99 78 154 0 1561584784 367230864 19333008
05:45:49 1503 8192000000 10449074256 10855219200 1173883696 12.533 100 84 166 0 1544283728 350873568 19526464
05:46:55 8302 8192000000 10422094624 10858131456 1152706384 12.335 99 41 80 2 1506377984 343992064 9679536
05:48:09 906 8192000000 10499607856 10917183488 1177130800 12.563 100 97 188 1 1590430192 390807456 22491936
05:49:15 9466 8192000000 10451417008 10881703936 1138150752 12.198 99 41 82 1 1538078720 388927728 11000240
05:50:32 12873 8192000000 10503052240 10934968320 1143950288 12.253 100 36 72 0 1602067872 448454464 9663120
05:51:53 3928 8192000000 10482698960 10894168064 1113529744 11.966 98 75 149 0 1577118048 444938832 18649472
05:53:00 19382 8192000000 10424873312 10868686848 1109455600 11.927 99 27 54 0 1515971584 399124704 7391280
05:54:45 33726 8192000000 10077617856 10595721216 1111320368 11.945 100 14 28 0 1225671408 111333472 3017568
05:56:20 107184 8192000000 10062557504 10500845568 1088972656 11.733 97 38 74 3 1143626272 46959856 7693760
05:59:29 61353 8192000000 10080032496 10565062656 1100856256 11.846 98 16 32 1 1199307296 94853328 3597712
06:01:39 69102 8192000000 10121951152 10557648896 1125515904 12.079 99 31 62 0 1211682992 79809184 6357904
06:03:50 53454 8192000000 10111433968 10561286144 1127914304 12.102 99 17 33 0 1212050672 80219392 3916976
06:05:44 37015 8192000000 10104244784 10553712640 1130448784 12.126 100 17 34 0 1208933744 75022576 3462384
06:08:35 103577 8192000000 10057287344 10573602816 1115892336 11.988 98 17 34 0 1202645456 83345536 3407584
06:11:19 103851 8192000000 10070045632 10556977152 1119279136 12.020 98 16 33 0 1178772560 56107856 3385568
06:14:07 53583 8192000000 10152152144 10595966976 1141785568 12.232 99 20 40 1 1229053344 82867040 4400736
06:16:22 103428 8192000000 10122435920 10588733440 1133825936 12.157 98 15 30 2 1177119648 40416752 2876960
06:19:34 157723 8192000000 10074621696 10527174656 1102799616 11.864 95 19 38 1 1143862640 36886992 4176032
06:24:18 78309 8192000000 10062175152 10532302848 1143008704 12.244 100 17 33 0 1166787136 20542448 3235984
06:26:43 44140 8192000000 10090223664 10548641792 1152696976 12.335 100 4 8 0 1197451008 44075104 678928
06:28:55 53210 8192000000 10081183840 10543435776 1134994384 12.168 99 14 28 0 1165918656 28138624 2785648
06:30:49 36718 8192000000 10121410160 10566332416 1156229024 12.368 100 19 38 1 1206044704 45765184 4050496
06:32:28 73115 8192000000 10126451152 10623217664 1138626336 12.203 99 23 46 1 1245763104 101487424 5649344
06:34:49 42487 8192000000 10067191600 10495037440 1098967376 11.828 96 31 62 1 1130975216 25296720 6711120
06:36:46 89054 8192000000 10064840368 10530451456 1100755200 11.845 97 30 59 3 1167505392 60726352 6023840
06:39:16 50842 8192000000 10129485296 10561994752 1098337344 11.822 96 30 60 1 1184887264 80402864 6147056
06:41:12 106280 8192000000 10018926608 10464169984 1072967728 11.580 95 27 52 1 1110195440 31742016 5485696
06:44:24 65600 8192000000 10019198320 10480336896 1082960480 11.676 98 13 26 0 1127329984 41468464 2901040
06:46:30 26466 8192000000 10013133024 10462474240 1091475392 11.757 99 2 4 0 1111037744 19103536 458816
06:47:57 60006 8192000000 10038583728 10495365120 1057045440 11.428 95 13 26 0 1098840048 39382416 2412192
06:50:38 97196 8192000000 10055426912 10540326912 1074232640 11.592 97 22 44 1 1148963264 69454336 5276288
06:53:56 53235 8192000000 10092703408 10532167680 1074800544 11.598 97 33 66 1 1134171312 52652784 6717984
06:55:52 73735 8192000000 10092969840 10574553088 1092376160 11.765 98 31 62 0 1200195024 100968448 6850416
06:58:07 65585 8192000000 10077143728 10532515840 1092187952 11.763 98 15 30 0 1149067584 54075984 2803648
07:00:12 29858 8192000000 10076485600 10492862464 1118071952 12.009 100 39 77 0 1149152784 22741552 8339280
07:02:44 93328 8192000000 10060547872 10532261888 1128287056 12.105 100 12 25 0 1179455952 48608512 2560384
07:05:18 37871 8192000000 10045444560 10510929920 1106236896 11.897 98 5 10 1 1142636944 34925408 1474640
07:07:10 50432 8192000000 10075427504 10515492864 1102299344 11.859 97 31 59 3 1155328768 46289072 6740352
07:09:06 86219 8192000000 10101494000 10586849280 1125395360 12.078 99 20 39 0 1210843808 80881760 4566688
07:11:40 44551 8192000000 10128385904 10572554240 1131237888 12.133 99 47 94 1 1212278336 71159360 9881088
07:13:31 57936 8192000000 10120605568 10566045696 1120434592 12.031 98 20 40 0 1216497184 91712592 4350000
07:15:32 34543 8192000000 10079159984 10530844672 1138174624 12.198 100 31 62 1 1182181200 37330448 6676128
07:17:07 42034 8192000000 10118427856 10602762240 1135796208 12.176 99 34 68 2 1215845616 72996272 7053136
07:20:18 49284 8192000000 10064419568 10518888448 1134725936 12.166 99 10 20 0 1167230256 30713136 1791184
07:23:33 68612 8192000000 10087024464 10574340096 1127308272 12.096 98 10 20 0 1161788000 32432656 2047072
07:25:52 35494 8192000000 10120622848 10568761344 1155586656 12.362 100 22 44 1 1221227968 61147344 4493968

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 19-01-2021 07:28:28 to 19-01-2021 07:28:43.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 133 v_add_invoice_to_stock 335544517
except 13 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 19-01-2021 07:28:44 to 19-01-2021 07:28:46.

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          241123
MON$OLDEST_ACTIVE               241124
MON$OLDEST_SNAPSHOT             241124
MON$NEXT_TRANSACTION            241124
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                       2054304
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             772
MON$NEXT_STATEMENT              53


ISQL Version: LI-V4.0.0.2325 Firebird 4.0 Release Candidate 1
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2325 Firebird 4.0 Release Candidate 1"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2325 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.2325 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 ---
--- end of diff output ---

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

19.01.21 07:28:47. 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-01-19 07:28:49 No severe PSQL-related problems occured
19.01.21 07:28:50. End of report.