Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 26.12.2021 01:39
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 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
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.33
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 16374064 kB
MemAvailable 31402992 kB
Buffers 0 kB
Cached 15319384 kB
SwapCached 440 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 3.0.9
DB_NAME                         /home/bases/oltp30-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/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/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=3333
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/oltp30-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-oltp30
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-12-26 01:37:54
DTS_END                         2021-12-26 01:37:54.7440
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/56696
TRN_ID                          234929
ATT_ID                          635
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: 9331.33 22476 1119759
customer order: creation 168.89 345 20267
customer order: refuse 14.58 389 1749
order to supplier: creation 44.53 1390 5344
order to supplier: removal 3.55 107119 426
invoice (draft): creation 44.48 3190 5337
invoice (draft): removal 53.94 829 6473
invoice accept: apply 41.96 19062 5035
invoice accept: cancel 48.97 830 5876
customer reserve: creation 3808.31 192 456997
customer reserve: removal 4808.20 61 576984
realization accept: apply 83.48 175 10017
realization accept: cancel 81.99 119 9839
payment from customer: creation 57.98 133 6958
payment from customer: removal 5.61 86 673
payment to supplier: creation 48.92 156 5870
payment to supplier: removal 3.41 78 409
service: total inventory turnovers 5.16 1228 619
service: total monetary turnovers 6.64 33 797
service: aggregate perf. data 0.71 30188 85
service: refresh index statistics 0.03 283918 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 26-12-2021 01:39:44 to 26-12-2021 01:39:46.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2408
TEST_TIME 2 3699
TEST_TIME 3 4365
TEST_TIME 4 4423
TEST_TIME 5 4522
TEST_TIME 6 4601
TEST_TIME 7 5481
TEST_TIME 8 5798
TEST_TIME 9 5675
TEST_TIME 10 5758
TEST_TIME 11 5880
TEST_TIME 12 6352
TEST_TIME 13 6372
TEST_TIME 14 6471
TEST_TIME 15 6546
TEST_TIME 16 6730
TEST_TIME 17 6887
TEST_TIME 18 6925
TEST_TIME 19 7148
TEST_TIME 20 7593
TEST_TIME 21 8015
TEST_TIME 22 8014
TEST_TIME 23 8252
TEST_TIME 24 8321
TEST_TIME 25 8199
TEST_TIME 26 8434
TEST_TIME 27 8439
TEST_TIME 28 8729
TEST_TIME 29 8685
TEST_TIME 30 8812
TEST_TIME 31 9193
TEST_TIME 32 9707
TEST_TIME 33 10647
TEST_TIME 34 10761
TEST_TIME 35 10560
TEST_TIME 36 10688
TEST_TIME 37 10652
TEST_TIME 38 10466
TEST_TIME 39 10369
TEST_TIME 40 10379
TEST_TIME 41 10214
TEST_TIME 42 10230
TEST_TIME 43 10153
TEST_TIME 44 10122
TEST_TIME 45 10059
TEST_TIME 46 10042
TEST_TIME 47 10078
TEST_TIME 48 10070
TEST_TIME 49 10136
TEST_TIME 50 10106
TEST_TIME 51 10038
TEST_TIME 52 9925
TEST_TIME 53 9863
TEST_TIME 54 9767
TEST_TIME 55 9782
TEST_TIME 56 9734
TEST_TIME 57 9722
TEST_TIME 58 9742
TEST_TIME 59 9713
TEST_TIME 60 9652
TEST_TIME 61 9579
TEST_TIME 62 9610
TEST_TIME 63 9498
TEST_TIME 64 9590
TEST_TIME 65 9560
TEST_TIME 66 9532
TEST_TIME 67 9550
TEST_TIME 68 9556
TEST_TIME 69 9545
TEST_TIME 70 9577
TEST_TIME 71 9551
TEST_TIME 72 9573
TEST_TIME 73 9596
TEST_TIME 74 9629
TEST_TIME 75 9670
TEST_TIME 76 9623
TEST_TIME 77 9679
TEST_TIME 78 9643
TEST_TIME 79 9769
TEST_TIME 80 9759
TEST_TIME 81 9712
TEST_TIME 82 9659
TEST_TIME 83 9646
TEST_TIME 84 9578
TEST_TIME 85 9557
TEST_TIME 86 9519
TEST_TIME 87 9530
TEST_TIME 88 9525
TEST_TIME 89 9473
TEST_TIME 90 9405
TEST_TIME 91 9429
TEST_TIME 92 9405
TEST_TIME 93 9415
TEST_TIME 94 9466
TEST_TIME 95 9415
TEST_TIME 96 9497
TEST_TIME 97 9502
TEST_TIME 98 9502
TEST_TIME 99 9507
TEST_TIME 100 9569
TEST_TIME 101 9521
TEST_TIME 102 9565
TEST_TIME 103 9610
TEST_TIME 104 9568
TEST_TIME 105 9670
TEST_TIME 106 9635
TEST_TIME 107 9561
TEST_TIME 108 9513
TEST_TIME 109 9538
TEST_TIME 110 9518
TEST_TIME 111 9463
TEST_TIME 112 9460
TEST_TIME 113 9448
TEST_TIME 114 9409
TEST_TIME 115 9372
TEST_TIME 116 9377
TEST_TIME 117 9363
TEST_TIME 118 9343
TEST_TIME 119 9289
TEST_TIME 120 9332

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 26-12-2021 01:39:48 to 26-12-2021 01:39:51.

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 1543270 1543270 0 0.00 0 21652 6 0 0
doc_list_biud 1543270 1543270 0 0.00 0 31870 29 0 0
sp_add_invoice_to_stock 5162 5035 127 2.46 22 235609 19062 0 127
sp_cancel_adding_invoice 5876 5876 0 0.00 4 80022 830 0 0
sp_cancel_client_order 1749 1749 0 0.00 3 14173 389 0 0
sp_cancel_customer_reserve 576984 576984 0 0.00 1 31877 62 0 0
sp_cancel_pay_from_customer 673 673 0 0.00 2 7093 86 0 0
sp_cancel_pay_to_supplier 409 409 0 0.00 3 6416 79 0 0
sp_cancel_supplier_invoice 6483 6473 10 0.15 2 15680 829 0 10
sp_cancel_supplier_order 426 426 0 0.00 11 1265709 107119 0 0
sp_cancel_write_off 9839 9839 0 0.00 1 14728 120 0 0
sp_client_order 20267 20267 0 0.00 3 22106 346 0 0
sp_customer_reserve 456997 456997 0 0.00 0 124159 192 0 0
sp_fill_shopping_cart 30941 30941 0 0.00 1 13471 39 0 0
sp_fill_shopping_cart_clo_res 456993 456993 0 0.00 0 14722 12 0 0
sp_get_clo_for_invoice 5031 5031 0 0.00 0 20847 262 0 0
sp_kill_cost_storno 16797 16797 0 0.00 0 7105 64 0 0
sp_kill_qstorno_ret_qs2qd 1170706 1170706 0 0.00 0 31868 33 0 0
sp_kill_qty_storno 616395 616395 0 0.00 0 31868 72 0 0
sp_lock_selected_doc 20781 20781 0 0.00 0 11273 5 0 0
sp_make_cost_storno 27876 27876 0 0.00 0 16672 55 0 0
sp_multiply_rows_for_pdistr 27876 27876 0 0.00 0 7598 30 0 0
sp_multiply_rows_for_qdistr 20267 20267 0 0.00 0 13832 137 0 0
sp_pay_from_customer 6958 6958 0 0.00 4 19435 133 0 0
sp_pay_to_supplier 5870 5870 0 0.00 5 21941 156 0 0
sp_payment_common 12828 12828 0 0.00 1 13699 31 0 0
sp_qd_handle_on_cancel_clo 1749 1749 0 0.00 0 14167 360 0 0
sp_qd_handle_on_invoice_upd_sts 10907 10907 0 0.00 0 22713 364 0 0
sp_qd_handle_on_reserve_upd_sts 10017 10017 0 0.00 0 12683 55 0 0
sp_reserve_write_off 10017 10017 0 0.00 6 16383 175 0 0
sp_supplier_invoice 5337 5337 0 0.00 5 86273 3191 0 0
sp_supplier_order 5344 5344 0 0.00 6 85431 1390 0 0
srv_aggregate_perf_data 85 85 0 0.00 2998 502282 30188 0 0
srv_fill_mon_cache_memory 64 64 0 0.00 1888 170615 44442 0 0
srv_find_qd_qs_mism 1072883 1072883 0 0.00 0 21652 5 0 0
srv_make_invnt_saldo 619 619 0 0.00 45 162392 1228 0 0
srv_make_money_saldo 797 797 0 0.00 1 4176 34 0 0
srv_recalc_idx_stat 4 4 0 0.00 61851 487371 283918 0 0
t$perf-abend:sp_add_invoice_to_stock 127 127 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5035 5035 0 0.00 0 7385 175 0 0
t$perf-norm:sp_cancel_adding_invoice 389 389 0 0.00 0 7763 104 0 0
t$perf-norm:sp_cancel_client_order 1749 1749 0 0.00 0 8684 14 0 0
t$perf-norm:sp_cancel_customer_reserve 678 678 0 0.00 0 920 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 673 673 0 0.00 0 1767 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 409 409 0 0.00 0 2268 14 0 0
t$perf-norm:sp_cancel_supplier_invoice 391 391 0 0.00 0 1173 16 0 0
t$perf-norm:sp_cancel_supplier_order 426 426 0 0.00 0 24777 1790 0 0
t$perf-norm:sp_cancel_write_off 1020 1020 0 0.00 0 3898 12 0 0
t$perf-norm:sp_client_order 20267 20267 0 0.00 0 5082 18 0 0
t$perf-norm:sp_customer_reserve 1015 1015 0 0.00 0 4521 16 0 0
t$perf-norm:sp_pay_from_customer 6958 6958 0 0.00 0 10922 12 0 0
t$perf-norm:sp_pay_to_supplier 5870 5870 0 0.00 0 5683 10 0 0
t$perf-norm:sp_reserve_write_off 10017 10017 0 0.00 0 4580 13 0 0
t$perf-norm:sp_supplier_invoice 5337 5337 0 0.00 0 6173 19 0 0
t$perf-norm:sp_supplier_order 5344 5344 0 0.00 0 3769 19 0 0
t$perf-norm:srv_aggregate_perf_data 85 85 0 0.00 0 1054 24 0 0
t$perf-norm:srv_fill_mon_cache_memory 64 64 0 0.00 0 59 2 0 0
t$perf-norm:srv_make_invnt_saldo 619 619 0 0.00 0 2326 35 0 0
t$perf-norm:srv_make_money_saldo 797 797 0 0.00 0 6451 25 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 30 10 0 0
v_add_invoice_to_stock 10314 10060 254 2.46 0 6368 21 0 254
v_all_customers 36978 36978 0 0.00 0 18 1 0 0
v_all_suppliers 29594 29594 0 0.00 0 21 1 0 0
v_all_wares 40534 40534 0 0.00 0 23 1 0 0
v_cancel_adding_invoice 778 778 0 0.00 0 4219 15 0 0
v_cancel_client_order 3498 3498 0 0.00 0 6263 7 0 0
v_cancel_customer_prepayment 1346 1346 0 0.00 0 1770 5 0 0
v_cancel_customer_reserve 1356 1356 0 0.00 0 3987 9 0 0
v_cancel_payment_to_supplier 818 818 0 0.00 0 6408 12 0 0
v_cancel_supplier_invoice 802 782 20 2.49 0 2050 22 0 20
v_cancel_supplier_order 852 852 0 0.00 0 5996 11 0 0
v_cancel_write_off 2040 2040 0 0.00 0 1808 14 0 0
v_max_id_clo_ord 5343 5343 0 0.00 0 2131 2 0 0
v_max_id_clo_res 1015 1015 0 0.00 0 1642 10 0 0
v_max_id_ord_sup 5331 5331 0 0.00 0 6361 4 0 0
v_max_non_paid_invoice 1747 1747 0 0.00 0 407 3 0 0
v_max_non_paid_realizn 3680 3680 0 0.00 0 2498 5 0 0
v_min_id_clo_ord 5343 5343 0 0.00 0 3457 8 0 0
v_min_id_clo_res 1015 1015 0 0.00 0 4522 20 0 0
v_min_id_ord_sup 5331 5331 0 0.00 0 10133 7 0 0
v_min_non_paid_invoice 5870 5870 0 0.00 0 13665 22 0 0
v_min_non_paid_realizn 6958 6958 0 0.00 0 6719 20 0 0
v_our_firm 10112 10112 0 0.00 0 16 1 0 0
v_reserve_write_off 20032 20032 0 0.00 0 6408 6 0 0
x_lock_depdocs_on_canc_invoice 11958 11958 0 0.00 0 21366 125 0 0
x_lock_depdocs_on_canc_sup_ord 426 426 0 0.00 0 21321 431 0 0
x_make_qstorno_1000_1200 5344 5344 0 0.00 2 84357 1298 0 0
x_make_qstorno_1200_2000 5337 5337 0 0.00 3 84886 3062 0 0
x_make_qstorno_2100_3300 456997 456997 0 0.00 0 124158 177 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 26-12-2021 01:39:52 to 26-12-2021 01:39:56.

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
23:07:58 2 8192000000 8797116400 8807743488 3955424 0.048 1 1 2 0 4053696 55488 42784
23:08:59 15007 8192000000 9906183168 10217082880 986556352 10.748 100 89 178 0 1015687264 5719232 23411680
23:10:26 23700 8192000000 9958408592 10280787968 1037144032 11.237 100 92 184 0 1069262640 8573792 23544816
23:11:53 14092 8192000000 9980071312 10315239424 1067588144 11.529 100 86 172 1 1099454048 9979184 21886720
23:13:11 10157 8192000000 10027675264 10378862592 1118436976 12.012 100 80 160 1 1149044512 11402176 19205360
23:14:25 10933 8192000000 10072068512 10429984768 1155568960 12.362 100 79 158 0 1186256464 12204656 18482848
23:15:39 7750 8192000000 10114744624 10485149696 1204272896 12.816 100 76 152 2 1232757168 11686016 16798256
23:16:49 2629 8192000000 10152725744 10527449088 1241442192 13.160 100 72 144 1 1269655712 12177344 16036176
23:18:00 2607 8192000000 10187381008 10566615040 1271291520 13.433 100 94 189 0 1306291904 13802928 21197456
23:19:05 2065 8192000000 10207300352 10589491200 1293331328 13.635 100 93 184 1 1325762624 11628464 20802832
23:20:09 3470 8192000000 10216046240 10602029056 1304468592 13.736 100 89 177 3 1337191232 13352272 19370368
23:21:16 1879 8192000000 10210907504 10611675136 1307449376 13.763 100 60 120 2 1331948160 10773552 13725232
23:22:21 5477 8192000000 10212362848 10622349312 1322542608 13.900 100 32 63 0 1337501904 7975344 6983952
23:23:31 44635 8192000000 10234357648 10644525056 1331098432 13.977 100 46 92 0 1348248016 5957248 11192336
23:25:18 6733 8192000000 10242441792 10655485952 1337596640 14.036 100 35 71 2 1353586336 8325744 7663952
23:26:28 3640 8192000000 10238750048 10654466048 1337758336 14.037 100 38 74 2 1353998128 7712480 8527312
23:27:38 60183 8192000000 10212505568 10633920512 1289328624 13.598 96 27 54 0 1301430064 6264944 5836496
23:29:44 4019 8192000000 10174833936 10587541504 1288720048 13.593 99 28 54 2 1301949088 6919920 6309120
23:30:50 9309 8192000000 10162202816 10558771200 1253996800 13.275 99 31 60 2 1267276000 5347632 7931568
23:32:04 45457 8192000000 10183690816 10564907008 1263160320 13.359 100 53 106 0 1281122048 5075328 12886400
23:33:51 8074 8192000000 10146159104 10539974656 1235915968 13.109 98 32 64 1 1250065696 6192912 7956816
23:34:59 10007 8192000000 10186826448 10576556032 1255362416 13.287 98 37 75 1 1269891696 4480848 10048432
23:36:10 7845 8192000000 10176640512 10584596480 1286758496 13.575 100 21 41 2 1297413312 5871200 4783616
23:37:20 2986 8192000000 10207580976 10615689216 1311223712 13.797 100 38 74 1 1324882896 4887088 8772096
23:38:35 15295 8192000000 10230333744 10638651392 1329948208 13.967 100 57 114 1 1351554848 8331408 13275232
23:39:54 42020 8192000000 10247244368 10663280640 1344045584 14.094 100 43 86 0 1364462544 10430192 9986768
23:41:57 6932 8192000000 10278971472 10694258688 1361943984 14.255 100 51 102 2 1388083968 14901232 11238752
23:43:13 10254 8192000000 10285114656 10701299712 1372387504 14.348 100 55 108 1 1399101584 14795680 11918400
23:44:35 6107 8192000000 10301585904 10718679040 1382040144 14.435 100 58 113 3 1413586208 18229152 13316912
23:45:47 15936 8192000000 10289190960 10717970432 1372578912 14.350 99 36 72 0 1396241600 15534336 8128352
23:47:09 3650 8192000000 10317079504 10734968832 1391777680 14.522 100 52 102 1 1423291536 18672032 12841824
23:48:25 2783 8192000000 10334647312 10751315968 1400087568 14.596 100 70 140 2 1440421232 24194464 16139200
23:49:34 8651 8192000000 10331754912 10761416704 1405382144 14.643 100 54 108 0 1442557840 23403456 13772240
23:50:48 5757 8192000000 10359336688 10780184576 1408099440 14.667 99 70 139 0 1451773344 26877760 16796144
23:52:01 3720 8192000000 10346934016 10764935168 1409404512 14.679 100 76 152 2 1457463120 29474704 18583904
23:53:09 1885 8192000000 10335025024 10743676928 1385213024 14.463 100 86 169 1 1440356016 34176400 20966592
23:54:17 6144 8192000000 10334731744 10741932032 1382538944 14.439 100 73 142 2 1438837248 38179872 18118432
23:55:30 10174 8192000000 10349576992 10757767168 1386581504 14.475 100 76 151 1 1451502832 45238608 19682720
23:56:43 6452 8192000000 10362898400 10783715328 1400047936 14.595 100 62 124 2 1469071648 53321888 15701824
23:57:55 10181 8192000000 10378718848 10791022592 1409063504 14.676 100 83 166 1 1479477088 49931824 20481760
23:59:11 4563 8192000000 10363129152 10779799552 1392064032 14.524 99 73 144 1 1456744368 46951104 17729232
00:00:23 7800 8192000000 10368860144 10798845952 1413831104 14.718 100 46 92 0 1478823648 52500544 12492000
00:01:34 10144 8192000000 10365438288 10787295232 1395676912 14.556 99 55 111 0 1462861856 53039680 14145264
00:02:51 5624 8192000000 10355479808 10777346048 1389254176 14.499 100 46 90 1 1459789552 58291408 12243968
00:04:03 11322 8192000000 10350664016 10779729920 1391097712 14.516 100 36 72 0 1458216592 57205920 9912960
00:05:55 19756 8192000000 10336486880 10771484672 1376765072 14.388 100 30 60 2 1443087152 57694320 8627760
00:07:21 29738 8192000000 10352555664 10787143680 1371217152 14.338 100 25 50 0 1452835872 74352464 7266256
00:08:54 28977 8192000000 10317214400 10756247552 1336189152 14.023 99 19 38 1 1416065056 74189504 5686400
00:10:24 86817 8192000000 10273683808 10726301696 1352105088 14.166 100 6 12 0 1382675312 29177392 1392832
00:12:52 34756 8192000000 10262768752 10706223104 1327638848 13.946 97 22 44 0 1343158656 10503248 5016560
00:14:37 69379 8192000000 10295214336 10740428800 1361494432 14.251 99 15 30 1 1382868848 18664752 2709664
00:17:11 85927 8192000000 10287997088 10742632448 1349983968 14.147 98 17 34 0 1367810736 13855104 3971664
00:19:41 111108 8192000000 10293377456 10733441024 1334062048 14.004 96 28 59 2 1351502608 10809520 6631040
00:22:33 67179 8192000000 10289472896 10729897984 1351311312 14.159 98 26 52 0 1366511680 9116240 6084128
00:24:44 111438 8192000000 10319398208 10769956864 1376833328 14.388 99 12 24 1 1394753296 15300176 2619792
00:27:38 99462 8192000000 10317564528 10769612800 1392754304 14.530 100 25 50 0 1411823824 13233952 5835568
00:30:26 117121 8192000000 10294662288 10744696832 1369393024 14.322 98 44 88 1 1387857936 9451568 9013344
00:33:25 29003 8192000000 10305914160 10760851456 1397165808 14.570 100 25 50 0 1413481712 10486528 5829376
00:34:57 8262 8192000000 10295077648 10739150848 1377986400 14.399 99 42 85 1 1397623152 9694176 9942576
00:36:08 53805 8192000000 10288058176 10754088960 1389133456 14.498 100 18 36 0 1404897056 10947424 4816176
00:38:04 170614 8192000000 10288753952 10752233472 1334797616 14.010 96 15 29 2 1348546080 10749328 2999136
00:41:55 23458 8192000000 10265942624 10717405184 1343922032 14.093 97 34 68 0 1357470768 5866352 7682384
00:43:19 65632 8192000000 10257966480 10724814848 1326829072 13.938 96 19 38 0 1339793856 9148176 3816608
00:45:35 45861 8192000000 10282714944 10740776960 1351052928 14.157 98 9 18 0 1363811392 10898512 1859952
00:48:03 18532 8192000000 10294262048 10742050816 1380252400 14.419 100 33 66 0 1399201952 11661920 7287632
00:49:27 61935 8192000000 10281133424 10745315328 1352782016 14.173 98 9 18 0 1366108048 11421136 1904896
00:51:29 50152 8192000000 10264479792 10728169472 1319350816 13.871 96 25 50 0 1341812096 16380096 6081184
00:53:22 58010 8192000000 10268470400 10722091008 1349527216 14.143 99 17 34 1 1366045248 12544944 3973088
00:55:21 44325 8192000000 10277543888 10722705408 1329071504 13.959 98 15 30 2 1347041776 14781456 3188816
00:57:09 104101 8192000000 10245778352 10695139328 1270218208 13.424 93 11 22 0 1281338448 8532752 2587488
01:01:17 39829 8192000000 10261075664 10709315584 1341961696 14.075 99 33 65 2 1360615536 11099760 7554080
01:02:58 66295 8192000000 10264458688 10724069376 1353163152 14.176 99 8 16 0 1368274720 13203552 1908016
01:05:04 76993 8192000000 10249354656 10714918912 1319237184 13.870 97 15 30 1 1334410352 11631376 3541792
01:07:24 26742 8192000000 10264668464 10734940160 1359043136 14.229 100 8 15 1 1376888624 16638528 1206960
01:08:51 84633 8192000000 10280937136 10738114560 1338761312 14.046 97 20 40 3 1352887680 9883920 4242448
01:11:24 56695 8192000000 10288274512 10746515456 1365260320 14.285 99 15 31 0 1377842448 8527648 4054480
01:13:26 86973 8192000000 10280882464 10738003968 1342260928 14.078 97 26 52 2 1364397344 15824384 6312032
01:15:54 34711 8192000000 10290366848 10747060224 1365873312 14.290 99 21 42 0 1381484912 10893664 4717936
01:17:29 61410 8192000000 10292630896 10737053696 1354547760 14.188 98 18 34 1 1373100832 14119760 4433312
01:19:32 38077 8192000000 10295085648 10764353536 1377356432 14.393 99 24 48 2 1399055536 16138432 5560672
01:21:15 40305 8192000000 10297618192 10748469248 1347049440 14.121 97 23 46 0 1363886384 11880656 4956288
01:22:56 112013 8192000000 10294364976 10742296576 1332043264 13.986 96 13 26 0 1346846400 11953152 2849984
01:25:59 49347 8192000000 10284941584 10752499712 1378795904 14.406 100 11 22 0 1391893536 10731472 2366160
01:28:00 45575 8192000000 10292444064 10748096512 1377661856 14.396 99 4 8 0 1385977392 7594192 721344
01:30:02 48619 8192000000 10290195648 10757648384 1393547696 14.538 100 25 49 0 1406960208 6901200 6511312
01:31:54 98504 8192000000 10285627776 10752004096 1375427216 14.376 99 13 26 0 1390495568 11779840 3288512
01:34:32 19661 8192000000 10281315584 10736332800 1380940672 14.425 100 24 48 0 1394348144 8020768 5386704
01:35:52 67003 8192000000 10259324144 10719694848 1333311712 13.997 96 22 44 1 1348813328 10462720 5038896

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 26-12-2021 01:39:58 to 26-12-2021 01:40:13.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 127 v_add_invoice_to_stock 335544517
except 10 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 26-12-2021 01:40:14 to 26-12-2021 01:40:16.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          234251
MON$OLDEST_ACTIVE               235064
MON$OLDEST_SNAPSHOT             235064
MON$NEXT_TRANSACTION            235064
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-03 16:41:55.3470
MON$PAGES                       2054112
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.9.33547 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.9.33547 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.9.33547 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.9.33547 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.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 ---
:153: 
:154: mscs-test-161.budzdorov.ru    Sun Dec 26 01:38:07 2021
:155:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:156: 
:157: 
:158: mscs-test-161.budzdorov.ru    Sun Dec 26 01:38:08 2021
:159:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:160: 
:161: 
:162: mscs-test-161.budzdorov.ru    Sun Dec 26 01:38:08 2021
:163:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:164: 
:165: 
:166: mscs-test-161.budzdorov.ru    Sun Dec 26 01:38:08 2021
:167:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:168: 
:169: 
:170: mscs-test-161.budzdorov.ru    Sun Dec 26 01:38:08 2021
:171:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:172: 
--- end of diff output ---

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

26.12.21 01:40:17. There are 3 logs in /var/tmp/logs-oltp30 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-12-26 01:40:19 No severe PSQL-related problems occured
26.12.21 01:40:20. End of report.