Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 07.12.2022 19: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 15147416 kB
MemAvailable 30105284 kB
Buffers 0 kB
Cached 16550396 kB
SwapCached 1656 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.11
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 2022-12-07 19:38:33
DTS_END                         2022-12-07 19:38:33.3630
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/59482
TRN_ID                          244708
ATT_ID                          731
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: 9422.53 20959 1130703
customer order: creation 179.43 333 21532
customer order: refuse 14.54 346 1745
order to supplier: creation 46.75 1170 5610
order to supplier: removal 3.56 92867 427
invoice (draft): creation 48.52 2940 5822
invoice (draft): removal 55.27 721 6632
invoice accept: apply 43.15 17123 5178
invoice accept: cancel 48.94 684 5873
customer reserve: creation 3961.12 171 475334
customer reserve: removal 4722.15 54 566658
realization accept: apply 85.74 155 10289
realization accept: cancel 79.48 116 9538
payment from customer: creation 61.71 94 7405
payment from customer: removal 5.96 69 715
payment to supplier: creation 50.32 118 6038
payment to supplier: removal 3.51 68 421
service: total inventory turnovers 5.03 1010 603
service: total monetary turnovers 6.51 72 781
service: aggregate perf. data 0.82 21822 98
service: refresh index statistics 0.03 279248 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 07-12-2022 19:39:24 to 07-12-2022 19:39:26.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 2803
TEST_TIME 2 3580
TEST_TIME 3 3512
TEST_TIME 4 4372
TEST_TIME 5 4094
TEST_TIME 6 4232
TEST_TIME 7 4352
TEST_TIME 8 4450
TEST_TIME 9 4969
TEST_TIME 10 5306
TEST_TIME 11 5912
TEST_TIME 12 6318
TEST_TIME 13 6539
TEST_TIME 14 6512
TEST_TIME 15 6987
TEST_TIME 16 7112
TEST_TIME 17 7527
TEST_TIME 18 7736
TEST_TIME 19 7589
TEST_TIME 20 7632
TEST_TIME 21 8612
TEST_TIME 22 8774
TEST_TIME 23 9184
TEST_TIME 24 9360
TEST_TIME 25 9681
TEST_TIME 26 9623
TEST_TIME 27 10567
TEST_TIME 28 10444
TEST_TIME 29 10383
TEST_TIME 30 10243
TEST_TIME 31 10146
TEST_TIME 32 10015
TEST_TIME 33 9973
TEST_TIME 34 9803
TEST_TIME 35 9847
TEST_TIME 36 9784
TEST_TIME 37 9659
TEST_TIME 38 9772
TEST_TIME 39 9948
TEST_TIME 40 9820
TEST_TIME 41 9784
TEST_TIME 42 9621
TEST_TIME 43 9520
TEST_TIME 44 9674
TEST_TIME 45 9668
TEST_TIME 46 9642
TEST_TIME 47 9625
TEST_TIME 48 9686
TEST_TIME 49 9768
TEST_TIME 50 9840
TEST_TIME 51 9902
TEST_TIME 52 9881
TEST_TIME 53 9857
TEST_TIME 54 9847
TEST_TIME 55 9879
TEST_TIME 56 9954
TEST_TIME 57 10026
TEST_TIME 58 9878
TEST_TIME 59 9833
TEST_TIME 60 9723
TEST_TIME 61 9706
TEST_TIME 62 9674
TEST_TIME 63 9655
TEST_TIME 64 9585
TEST_TIME 65 9492
TEST_TIME 66 9496
TEST_TIME 67 9555
TEST_TIME 68 9473
TEST_TIME 69 9476
TEST_TIME 70 9603
TEST_TIME 71 9592
TEST_TIME 72 9622
TEST_TIME 73 9643
TEST_TIME 74 9691
TEST_TIME 75 9710
TEST_TIME 76 9758
TEST_TIME 77 9806
TEST_TIME 78 9759
TEST_TIME 79 9791
TEST_TIME 80 9680
TEST_TIME 81 9664
TEST_TIME 82 9630
TEST_TIME 83 9607
TEST_TIME 84 9559
TEST_TIME 85 9507
TEST_TIME 86 9472
TEST_TIME 87 9412
TEST_TIME 88 9409
TEST_TIME 89 9405
TEST_TIME 90 9497
TEST_TIME 91 9486
TEST_TIME 92 9503
TEST_TIME 93 9487
TEST_TIME 94 9508
TEST_TIME 95 9581
TEST_TIME 96 9601
TEST_TIME 97 9587
TEST_TIME 98 9629
TEST_TIME 99 9593
TEST_TIME 100 9673
TEST_TIME 101 9621
TEST_TIME 102 9590
TEST_TIME 103 9534
TEST_TIME 104 9506
TEST_TIME 105 9480
TEST_TIME 106 9465
TEST_TIME 107 9447
TEST_TIME 108 9438
TEST_TIME 109 9399
TEST_TIME 110 9400
TEST_TIME 111 9403
TEST_TIME 112 9396
TEST_TIME 113 9428
TEST_TIME 114 9403
TEST_TIME 115 9423
TEST_TIME 116 9457
TEST_TIME 117 9451
TEST_TIME 118 9463
TEST_TIME 119 9465
TEST_TIME 120 9424

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 07-12-2022 19:39:28 to 07-12-2022 19:39:31.

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 1571064 1571064 0 0.00 0 28990 6 0 0
doc_list_biud 1571064 1571064 0 0.00 0 28694 25 0 0
sp_add_invoice_to_stock 5249 5178 71 1.35 47 156078 17123 0 71
sp_cancel_adding_invoice 5873 5873 0 0.00 4 50601 685 0 0
sp_cancel_client_order 1745 1745 0 0.00 4 11195 347 0 0
sp_cancel_customer_reserve 566658 566658 0 0.00 0 22683 55 0 0
sp_cancel_pay_from_customer 715 715 0 0.00 2 4236 69 0 0
sp_cancel_pay_to_supplier 421 421 0 0.00 3 4456 69 0 0
sp_cancel_supplier_invoice 6642 6632 10 0.15 1 19676 721 0 10
sp_cancel_supplier_order 427 427 0 0.00 11 1027708 92867 0 0
sp_cancel_write_off 9538 9538 0 0.00 1 14866 117 0 0
sp_client_order 21532 21532 0 0.00 3 21918 334 0 0
sp_customer_reserve 475334 475334 0 0.00 0 48237 171 0 0
sp_fill_shopping_cart 32947 32947 0 0.00 1 17489 36 0 0
sp_fill_shopping_cart_clo_res 475332 475332 0 0.00 0 10537 13 0 0
sp_get_clo_for_invoice 5176 5176 0 0.00 0 20199 292 0 0
sp_kill_cost_storno 16547 16547 0 0.00 0 6183 49 0 0
sp_kill_qstorno_ret_qs2qd 1149913 1149913 0 0.00 0 28693 30 0 0
sp_kill_qty_storno 606338 606338 0 0.00 0 28693 64 0 0
sp_lock_selected_doc 21408 21408 0 0.00 0 8257 5 0 0
sp_make_cost_storno 28908 28908 0 0.00 0 27519 52 0 0
sp_multiply_rows_for_pdistr 28908 28908 0 0.00 0 10291 23 0 0
sp_multiply_rows_for_qdistr 21532 21532 0 0.00 0 13039 160 0 0
sp_pay_from_customer 7405 7405 0 0.00 4 10476 95 0 0
sp_pay_to_supplier 6038 6038 0 0.00 4 12213 119 0 0
sp_payment_common 13443 13443 0 0.00 1 7434 25 0 0
sp_qd_handle_on_cancel_clo 1745 1745 0 0.00 0 11185 313 0 0
sp_qd_handle_on_invoice_upd_sts 11049 11049 0 0.00 0 28385 280 0 0
sp_qd_handle_on_reserve_upd_sts 10289 10289 0 0.00 0 21567 50 0 0
sp_reserve_write_off 10289 10289 0 0.00 6 21682 155 0 0
sp_supplier_invoice 5822 5822 0 0.00 5 86433 2940 0 0
sp_supplier_order 5610 5610 0 0.00 4 38074 1170 0 0
srv_aggregate_perf_data 98 98 0 0.00 2349 371432 21822 0 0
srv_fill_mon_cache_memory 64 64 0 0.00 1397 125580 43799 0 0
srv_find_qd_qs_mism 1081420 1081420 0 0.00 0 28988 6 0 0
srv_make_invnt_saldo 603 603 0 0.00 52 98504 1011 0 0
srv_make_money_saldo 781 781 0 0.00 1 20377 72 0 0
srv_recalc_idx_stat 4 4 0 0.00 214420 373284 279248 0 0
t$perf-abend:sp_add_invoice_to_stock 71 71 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 5178 5178 0 0.00 0 12371 145 0 0
t$perf-norm:sp_cancel_adding_invoice 416 416 0 0.00 0 2415 67 0 0
t$perf-norm:sp_cancel_client_order 1745 1745 0 0.00 0 5529 15 0 0
t$perf-norm:sp_cancel_customer_reserve 729 729 0 0.00 0 776 8 0 0
t$perf-norm:sp_cancel_pay_from_customer 715 715 0 0.00 0 1484 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 421 421 0 0.00 0 433 3 0 0
t$perf-norm:sp_cancel_supplier_invoice 426 426 0 0.00 0 1005 13 0 0
t$perf-norm:sp_cancel_supplier_order 427 427 0 0.00 0 28144 1409 0 0
t$perf-norm:sp_cancel_write_off 1065 1065 0 0.00 0 3917 12 0 0
t$perf-norm:sp_client_order 21532 21532 0 0.00 0 8220 14 0 0
t$perf-norm:sp_customer_reserve 1009 1009 0 0.00 0 358 2 0 0
t$perf-norm:sp_pay_from_customer 7405 7405 0 0.00 0 6378 8 0 0
t$perf-norm:sp_pay_to_supplier 6038 6038 0 0.00 0 6031 9 0 0
t$perf-norm:sp_reserve_write_off 10289 10289 0 0.00 0 14265 12 0 0
t$perf-norm:sp_supplier_invoice 5822 5822 0 0.00 0 14366 22 0 0
t$perf-norm:sp_supplier_order 5610 5610 0 0.00 0 5101 14 0 0
t$perf-norm:srv_aggregate_perf_data 98 98 0 0.00 0 476 6 0 0
t$perf-norm:srv_fill_mon_cache_memory 64 64 0 0.00 0 12 1 0 0
t$perf-norm:srv_make_invnt_saldo 603 603 0 0.00 0 8057 33 0 0
t$perf-norm:srv_make_money_saldo 781 781 0 0.00 0 1202 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 3 2 0 0
v_add_invoice_to_stock 10492 10350 142 1.35 0 3769 14 0 142
v_all_customers 39334 39334 0 0.00 0 92 1 0 0
v_all_suppliers 31612 31612 0 0.00 0 72 1 0 0
v_all_wares 43064 43064 0 0.00 0 28 1 0 0
v_cancel_adding_invoice 832 832 0 0.00 0 2010 9 0 0
v_cancel_client_order 3490 3490 0 0.00 0 963 3 0 0
v_cancel_customer_prepayment 1430 1430 0 0.00 0 1775 6 0 0
v_cancel_customer_reserve 1458 1458 0 0.00 0 1272 4 0 0
v_cancel_payment_to_supplier 842 842 0 0.00 0 4450 10 0 0
v_cancel_supplier_invoice 872 852 20 2.29 0 1984 12 0 20
v_cancel_supplier_order 854 854 0 0.00 0 6010 10 0 0
v_cancel_write_off 2130 2130 0 0.00 0 1339 13 0 0
v_max_id_clo_ord 5610 5610 0 0.00 0 1565 1 0 0
v_max_id_clo_res 1009 1009 0 0.00 0 1535 12 0 0
v_max_id_ord_sup 5805 5805 0 0.00 0 5169 4 0 0
v_max_non_paid_invoice 1647 1647 0 0.00 0 1250 3 0 0
v_max_non_paid_realizn 3870 3870 0 0.00 0 4136 7 0 0
v_min_id_clo_ord 5610 5610 0 0.00 0 3024 5 0 0
v_min_id_clo_res 1009 1009 0 0.00 0 935 3 0 0
v_min_id_ord_sup 5805 5805 0 0.00 0 11270 15 0 0
v_min_non_paid_invoice 6038 6038 0 0.00 0 4127 14 0 0
v_min_non_paid_realizn 7405 7405 0 0.00 0 7430 17 0 0
v_our_firm 10800 10800 0 0.00 0 23 1 0 0
v_reserve_write_off 20577 20577 0 0.00 0 3362 4 0 0
x_lock_depdocs_on_canc_invoice 12079 12079 0 0.00 0 16210 115 0 0
x_lock_depdocs_on_canc_sup_ord 427 427 0 0.00 0 10519 332 0 0
x_make_qstorno_1000_1200 5610 5610 0 0.00 1 38060 1106 0 0
x_make_qstorno_1200_2000 5822 5822 0 0.00 2 86425 2803 0 0
x_make_qstorno_2100_3300 475334 475334 0 0.00 0 48235 156 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 07-12-2022 19:39:32 to 07-12-2022 19:39:36.

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
17:08:37 2 8192000000 8797116400 8807743488 3955424 0.048 1 1 2 0 4053696 55488 42784
17:09:38 28913 8192000000 9888127728 10199920640 968373008 10.571 100 85 168 1 996569664 5892848 22303808
17:11:12 27829 8192000000 9948821168 10270113792 1026201296 11.132 100 90 180 0 1058000624 8611424 23187904
17:12:53 8477 8192000000 9977327520 10307403776 1062017440 11.476 100 84 167 1 1092945328 9746928 21180960
17:14:06 9744 8192000000 10013159184 10357309440 1101454384 11.851 100 74 148 0 1129684512 10624288 17605840
17:15:19 5129 8192000000 10063183600 10419654656 1157393968 12.379 100 68 136 0 1184210880 11588112 15228800
17:16:27 3971 8192000000 10109091456 10475986944 1197199600 12.750 100 80 156 0 1228032288 12948688 17884000
17:17:33 2804 8192000000 10141848368 10514259968 1228558480 13.041 100 76 150 0 1257583408 12480448 16544480
17:18:39 2934 8192000000 10166259664 10545111040 1254800848 13.282 100 76 152 0 1285418560 13980960 16636752
17:19:44 1926 8192000000 10192184320 10580557824 1283669440 13.547 100 72 144 1 1312103296 12700032 15733824
17:20:47 9088 8192000000 10200892912 10592579584 1295720752 13.656 100 70 140 1 1322627424 11255440 15651232
17:21:58 5883 8192000000 10178707360 10593394688 1299303728 13.689 100 24 48 0 1315455136 10987712 5163696
17:23:09 10006 8192000000 10196460192 10611150848 1311638656 13.801 100 17 34 1 1321024640 5278176 4107808
17:24:23 11186 8192000000 10197883312 10617888768 1318550688 13.864 100 11 23 0 1325858064 4874944 2432432
17:25:34 49571 8192000000 10204310000 10628902912 1321301760 13.888 100 17 32 1 1330229616 4403968 4523888
17:27:25 2644 8192000000 10224192400 10639720448 1325539488 13.927 100 42 85 0 1343135360 8263584 9332288
17:28:29 12312 8192000000 10204057136 10621562880 1297097184 13.669 98 19 38 0 1306935360 5700944 4137232
17:29:43 9307 8192000000 10172925296 10580463616 1229786464 13.052 94 21 42 1 1239949536 5456416 4706656
17:30:54 15564 8192000000 10164848208 10576412672 1206471584 12.836 93 22 44 0 1217709504 6367840 4870080
17:32:10 4425 8192000000 10132441872 10525626368 1221235968 12.973 98 35 70 0 1236333056 5999024 9098064
17:33:17 3028 8192000000 10143112528 10535342080 1245231760 13.194 100 29 58 1 1257893920 5831200 6830960
17:34:20 16455 8192000000 10165783728 10566078464 1258207504 13.314 99 16 33 0 1268110432 5571616 4331312
17:35:37 22728 8192000000 10160734496 10572824576 1262742224 13.355 99 18 36 0 1276010096 9185472 4082400
17:37:00 4859 8192000000 10189140960 10595745792 1289874496 13.603 100 22 44 1 1299240624 4478480 4887648
17:38:08 5843 8192000000 10199116288 10615435264 1310490784 13.791 100 16 32 0 1318756096 5203856 3061456
17:39:20 18288 8192000000 10242961904 10651820032 1331216016 13.978 100 43 84 0 1350109760 9431552 9462192
17:40:44 59391 8192000000 10265185424 10680537088 1349886016 14.146 100 41 82 0 1376256400 16873808 9496576
17:42:51 19121 8192000000 10265683568 10695245824 1356554336 14.206 100 22 42 0 1379180000 17308016 5317648
17:44:21 24179 8192000000 10297127008 10713989120 1376833824 14.388 100 39 78 0 1407778592 21113600 9831168
17:45:53 10321 8192000000 10299690400 10728386560 1381582720 14.431 100 41 82 0 1417714480 26168800 9962960
17:47:07 2842 8192000000 10332862880 10750332928 1397440496 14.572 100 64 125 0 1443702512 31155488 15106528
17:48:12 7091 8192000000 10329592016 10748796928 1390075024 14.507 100 54 108 0 1435521456 32086784 13359648
17:49:26 1396 8192000000 10339901024 10756636672 1394905328 14.550 100 81 158 1 1448400256 34417200 19077728
17:50:32 4966 8192000000 10345749376 10763792384 1397077200 14.569 100 61 119 0 1449075200 37096000 14902000
17:51:43 6957 8192000000 10338459952 10764652544 1398136160 14.578 100 50 100 0 1448222640 36988912 13097568
17:52:56 2033 8192000000 10380955200 10795237376 1418485984 14.759 100 73 145 0 1477893504 41429552 17977968
17:54:03 10182 8192000000 10350882736 10768871424 1389020016 14.497 98 62 124 0 1442971120 37934448 16016656
17:55:22 2325 8192000000 10359169296 10778820608 1409282944 14.678 100 63 122 1 1464983488 39488608 16211936
17:56:31 17591 8192000000 10336520704 10764640256 1358081504 14.220 96 34 67 2 1405769024 38748816 8938704
17:57:55 3971 8192000000 10350334336 10769567744 1374006944 14.363 98 61 116 1 1434276912 44866784 15403184
17:59:04 3087 8192000000 10345148544 10751115264 1371804032 14.343 98 77 148 0 1442783392 51858064 19121296
18:00:08 11141 8192000000 10320801232 10753961984 1381269296 14.428 100 29 56 1 1423913824 34559616 8084912
18:01:26 16546 8192000000 10301089968 10737909760 1372354656 14.348 100 26 52 1 1417220400 37816672 7049072
18:02:44 23816 8192000000 10294315296 10731720704 1354870496 14.191 99 26 51 0 1394602128 32515312 7216320
18:05:18 38577 8192000000 10283385200 10719580160 1353665472 14.180 99 25 49 0 1374005152 14167424 6172256
18:06:57 43431 8192000000 10274856208 10710224896 1327918400 13.948 97 28 56 0 1342633024 9071904 5642720
18:09:02 57247 8192000000 10285953488 10735747072 1386151120 14.472 100 19 38 1 1400420032 10035472 4233440
18:11:54 62456 8192000000 10276044000 10723127296 1345459536 14.107 97 13 24 0 1358715152 10316176 2939440
18:14:04 45528 8192000000 10297193600 10736078848 1346274624 14.114 97 22 42 0 1363768512 12905456 4588432
18:15:54 14859 8192000000 10303270224 10751668224 1388596096 14.493 100 46 92 1 1418547664 19120000 10831568
18:17:15 25388 8192000000 10290720272 10754011136 1383752176 14.450 100 10 20 0 1402377392 16394032 2231184
18:18:42 47337 8192000000 10292994624 10749878272 1380775184 14.423 99 9 18 0 1392932448 9994336 2162928
18:20:37 79595 8192000000 10290186944 10745344000 1358222272 14.221 97 21 42 1 1378830768 15770736 4837760
18:22:59 56035 8192000000 10293970400 10754314240 1385440592 14.465 100 9 18 0 1398469216 11327856 1700768
18:24:55 12928 8192000000 10312464112 10757857280 1396658736 14.565 100 54 104 0 1418699040 9806064 12234240
18:26:09 48485 8192000000 10297429456 10749210624 1357616512 14.216 97 17 34 1 1371993296 10186784 4190000
18:27:58 72024 8192000000 10296363744 10755784704 1353000064 14.174 97 9 19 0 1375546688 20409328 2137296
18:30:11 32909 8192000000 10299037968 10750050304 1389904096 14.505 100 39 78 1 1406952672 7753664 9294912
18:31:44 29813 8192000000 10296111280 10740973568 1371080256 14.337 99 25 50 0 1385625280 9276784 5268240
18:33:20 30304 8192000000 10304771696 10750259200 1372792816 14.352 99 25 50 2 1392670080 14357616 5519648
18:34:51 95883 8192000000 10271839600 10725007360 1332226256 13.987 96 18 35 1 1351179024 14971968 3980800
18:37:51 82078 8192000000 10278329520 10738946048 1356540352 14.206 98 11 22 0 1368839920 10080272 2219296
18:40:14 25736 8192000000 10282648480 10734182400 1361113888 14.247 98 22 45 0 1374012160 8245840 4652432
18:41:40 36997 8192000000 10251295008 10711429120 1332833264 13.993 97 3 6 0 1339719568 6511680 374624
18:43:21 54211 8192000000 10284049312 10743537664 1374888896 14.371 100 11 22 1 1387326144 9937504 2499744
18:45:16 50857 8192000000 10275176752 10727604224 1320831904 13.884 95 10 20 0 1330350960 7310272 2208784
18:47:09 63635 8192000000 10292954512 10739576832 1351701872 14.163 98 19 38 0 1370850816 14624528 4524416
18:49:16 52648 8192000000 10297230640 10747338752 1355208592 14.194 98 22 42 0 1376170496 16234096 4727808
18:51:29 35098 8192000000 10292876688 10742714368 1369826784 14.325 99 26 52 0 1387789504 12190976 5771744
18:53:05 36729 8192000000 10299869888 10752401408 1375387008 14.375 100 32 65 0 1401124400 18582608 7154784
18:54:48 46561 8192000000 10291681728 10740965376 1357975984 14.219 98 30 60 2 1375587872 10174176 7437712
18:56:41 24339 8192000000 10289425056 10722291712 1354465920 14.188 99 33 65 1 1369551344 7742112 7343312
18:58:06 108696 8192000000 10296490080 10754973696 1376852464 14.388 100 24 48 0 1392798464 10882960 5063040
19:02:13 56233 8192000000 10279894096 10743943168 1376926176 14.389 99 7 14 0 1387241680 8455888 1859616
19:04:09 61432 8192000000 10249287776 10698747904 1335253328 14.015 97 21 42 0 1352065344 11443296 5368720
19:06:29 54517 8192000000 10262133216 10731118592 1365300880 14.285 100 17 33 0 1383090144 13992736 3796528
19:08:45 125580 8192000000 10270853216 10722320384 1314186672 13.824 95 12 20 0 1327581872 10800128 2595072
19:11:51 18554 8192000000 10315610096 10754895872 1378355152 14.402 99 47 94 0 1400123296 11481728 10286416
19:13:10 69194 8192000000 10296202832 10769260544 1354288896 14.186 98 18 36 0 1382691408 24631440 3771072
19:15:21 114274 8192000000 10284635296 10727399424 1325863456 13.930 96 19 38 0 1345666944 15741536 4061952
19:18:18 98862 8192000000 10301205120 10733903872 1333469088 13.998 97 20 38 0 1352527312 14878624 4179600
19:21:02 92701 8192000000 10278378752 10733932544 1352813456 14.173 98 31 62 0 1370244192 10373520 7057216
19:24:04 62761 8192000000 10257361248 10721906688 1328425168 13.953 96 5 10 0 1339835328 10350272 1059888
19:26:40 68089 8192000000 10247075456 10706026496 1324987472 13.922 97 10 20 2 1337503616 10048112 2468032
19:28:52 97618 8192000000 10267793088 10720800768 1307329456 13.762 95 17 34 0 1323021808 11635376 4056976
19:31:52 18359 8192000000 10290494384 10727976960 1364973728 14.282 100 36 70 0 1380213520 7426592 7813200
19:33:13 105443 8192000000 10266911760 10727100416 1304323904 13.735 95 19 38 0 1321253808 12683936 4245968
19:36:01 68438 8192000000 10272222544 10732929024 1332823920 13.993 97 27 54 0 1352439392 13709712 5905760
19:38:14 35398 8192000000 9049296736 9260343296 210101600 2.500 16 2 4 0 214711152 4325248 284304

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 07-12-2022 19:39:38 to 07-12-2022 19:39:53.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 71 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 07-12-2022 19:39:54 to 07-12-2022 19:39:56.

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          245037
MON$OLDEST_ACTIVE               245038
MON$OLDEST_SNAPSHOT             245038
MON$NEXT_TRANSACTION            245038
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                       2020608
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.11.33646 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.11.33646 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.11.33646 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.11.33646 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 ---
--- end of diff output ---

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

07.12.22 19:39:57. 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
2022-12-07 19:40:00 No severe PSQL-related problems occured
07.12.22 19:40:01. End of report.