Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 20.01.2023 07: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 14902960 kB
MemAvailable 30460364 kB
Buffers 0 kB
Cached 16823636 kB
SwapCached 1784 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.3
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 2023-01-20 07:37:23
DTS_END                         2023-01-20 07:37:23.9410
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/60512
TRN_ID                          223460
ATT_ID                          591
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: 9290.24 23628 1114829
customer order: creation 172.38 468 20685
customer order: refuse 14.44 391 1733
order to supplier: creation 45.84 1389 5501
order to supplier: removal 3.23 173286 388
invoice (draft): creation 46.53 2927 5583
invoice (draft): removal 51.06 1101 6127
invoice accept: apply 42.44 25476 5093
invoice accept: cancel 46.84 1239 5621
customer reserve: creation 3969.85 239 476382
customer reserve: removal 4598.12 94 551774
realization accept: apply 83.43 295 10011
realization accept: cancel 88.92 159 10670
payment from customer: creation 57.52 188 6902
payment from customer: removal 5.63 132 675
payment to supplier: creation 48.09 197 5771
payment to supplier: removal 3.58 157 430
service: total inventory turnovers 3.79 4518 455
service: total monetary turnovers 7.54 363 905
service: aggregate perf. data 0.99 15732 119
service: refresh index statistics 0.03 244212 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 20-01-2023 07:40:19 to 20-01-2023 07:40:21.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 9323
TEST_TIME 2 8456
TEST_TIME 3 6901
TEST_TIME 4 6112
TEST_TIME 5 6113
TEST_TIME 6 5606
TEST_TIME 7 5884
TEST_TIME 8 6398
TEST_TIME 9 6499
TEST_TIME 10 6709
TEST_TIME 11 6825
TEST_TIME 12 7185
TEST_TIME 13 7115
TEST_TIME 14 7561
TEST_TIME 15 7794
TEST_TIME 16 7936
TEST_TIME 17 7811
TEST_TIME 18 7910
TEST_TIME 19 8095
TEST_TIME 20 8090
TEST_TIME 21 8074
TEST_TIME 22 8125
TEST_TIME 23 8073
TEST_TIME 24 8179
TEST_TIME 25 8417
TEST_TIME 26 8417
TEST_TIME 27 8822
TEST_TIME 28 9276
TEST_TIME 29 9608
TEST_TIME 30 10136
TEST_TIME 31 10403
TEST_TIME 32 10553
TEST_TIME 33 10733
TEST_TIME 34 11148
TEST_TIME 35 11105
TEST_TIME 36 11035
TEST_TIME 37 10842
TEST_TIME 38 10950
TEST_TIME 39 10867
TEST_TIME 40 10786
TEST_TIME 41 10741
TEST_TIME 42 10740
TEST_TIME 43 10793
TEST_TIME 44 10701
TEST_TIME 45 10539
TEST_TIME 46 10447
TEST_TIME 47 10389
TEST_TIME 48 10381
TEST_TIME 49 10232
TEST_TIME 50 10171
TEST_TIME 51 10159
TEST_TIME 52 10094
TEST_TIME 53 10010
TEST_TIME 54 10000
TEST_TIME 55 9890
TEST_TIME 56 9944
TEST_TIME 57 9874
TEST_TIME 58 9766
TEST_TIME 59 9792
TEST_TIME 60 9789
TEST_TIME 61 9776
TEST_TIME 62 10089
TEST_TIME 63 10146
TEST_TIME 64 10191
TEST_TIME 65 10100
TEST_TIME 66 10102
TEST_TIME 67 10090
TEST_TIME 68 9998
TEST_TIME 69 10107
TEST_TIME 70 10180
TEST_TIME 71 10087
TEST_TIME 72 10009
TEST_TIME 73 9937
TEST_TIME 74 9842
TEST_TIME 75 9802
TEST_TIME 76 9822
TEST_TIME 77 9755
TEST_TIME 78 9749
TEST_TIME 79 9714
TEST_TIME 80 9654
TEST_TIME 81 9597
TEST_TIME 82 9557
TEST_TIME 83 9582
TEST_TIME 84 9538
TEST_TIME 85 9520
TEST_TIME 86 9541
TEST_TIME 87 9617
TEST_TIME 88 9564
TEST_TIME 89 9607
TEST_TIME 90 9548
TEST_TIME 91 9509
TEST_TIME 92 9658
TEST_TIME 93 9659
TEST_TIME 94 9706
TEST_TIME 95 9720
TEST_TIME 96 9638
TEST_TIME 97 9589
TEST_TIME 98 9565
TEST_TIME 99 9569
TEST_TIME 100 9551
TEST_TIME 101 9509
TEST_TIME 102 9460
TEST_TIME 103 9455
TEST_TIME 104 9395
TEST_TIME 105 9371
TEST_TIME 106 9318
TEST_TIME 107 9297
TEST_TIME 108 9291
TEST_TIME 109 9298
TEST_TIME 110 9313
TEST_TIME 111 9322
TEST_TIME 112 9297
TEST_TIME 113 9281
TEST_TIME 114 9282
TEST_TIME 115 9273
TEST_TIME 116 9265
TEST_TIME 117 9293
TEST_TIME 118 9369
TEST_TIME 119 9389
TEST_TIME 120 9311
TEST_TIME 121 9234

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 20-01-2023 07:40:23 to 20-01-2023 07:40:26.

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 1552687 1552687 0 0.00 0 19603 13 0 0
doc_list_biud 1552676 1552676 0 0.00 0 65050 40 0 0
sp_add_invoice_to_stock 5203 5093 110 2.11 74 227146 25477 0 110
sp_cancel_adding_invoice 5621 5621 0 0.00 7 103567 1239 0 0
sp_cancel_client_order 1733 1733 0 0.00 6 13226 391 0 0
sp_cancel_customer_reserve 551774 551774 0 0.00 1 31476 95 0 0
sp_cancel_pay_from_customer 675 675 0 0.00 3 4228 132 0 0
sp_cancel_pay_to_supplier 430 430 0 0.00 4 5766 157 0 0
sp_cancel_supplier_invoice 6131 6127 4 0.06 3 65102 1102 0 4
sp_cancel_supplier_order 388 388 0 0.00 10 1464928 173287 0 0
sp_cancel_write_off 10670 10670 0 0.00 2 13585 159 0 0
sp_client_order 20685 20685 0 0.00 5 20657 469 0 0
sp_customer_reserve 476382 476382 0 0.00 1 92537 239 0 0
sp_fill_shopping_cart 31757 31757 0 0.00 1 12855 87 0 0
sp_fill_shopping_cart_clo_res 476362 476362 0 0.00 0 13030 18 0 0
sp_get_clo_for_invoice 5059 5059 0 0.00 0 34947 275 0 0
sp_kill_cost_storno 17396 17396 0 0.00 0 5490 69 0 0
sp_kill_qstorno_ret_qs2qd 1120733 1120733 0 0.00 0 65048 42 0 0
sp_kill_qty_storno 591379 591379 0 0.00 0 65049 97 0 0
sp_lock_selected_doc 20843 20843 0 0.00 0 10303 10 0 0
sp_make_cost_storno 27741 27741 0 0.00 0 19522 85 0 0
sp_multiply_rows_for_pdistr 27739 27739 0 0.00 0 9491 38 0 0
sp_multiply_rows_for_qdistr 20684 20684 0 0.00 0 12481 182 0 0
sp_pay_from_customer 6902 6902 0 0.00 5 15683 188 0 0
sp_pay_to_supplier 5771 5771 0 0.00 6 16497 197 0 0
sp_payment_common 12672 12672 0 0.00 2 11416 48 0 0
sp_qd_handle_on_cancel_clo 1733 1733 0 0.00 1 13204 319 0 0
sp_qd_handle_on_invoice_upd_sts 10677 10677 0 0.00 0 19428 535 0 0
sp_qd_handle_on_reserve_upd_sts 10010 10010 0 0.00 0 19832 64 0 0
sp_reserve_write_off 10011 10011 0 0.00 7 19922 296 0 0
sp_supplier_invoice 5583 5583 0 0.00 11 96631 2928 0 0
sp_supplier_order 5501 5501 0 0.00 7 34325 1390 0 0
srv_aggregate_perf_data 119 119 0 0.00 2321 151004 15732 0 0
srv_fill_mon_cache_memory 72 72 0 0.00 730 134725 34191 0 0
srv_find_qd_qs_mism 1065151 1065151 0 0.00 0 11096 10 0 0
srv_make_invnt_saldo 455 455 0 0.00 70 59236 4519 0 0
srv_make_money_saldo 905 905 0 0.00 1 9195 364 0 0
srv_recalc_idx_stat 4 4 0 0.00 33150 336953 244212 0 0
t$perf-abend:sp_add_invoice_to_stock 110 110 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5095 5095 0 0.00 1 11133 969 0 0
t$perf-norm:sp_cancel_adding_invoice 431 431 0 0.00 2 8564 430 0 0
t$perf-norm:sp_cancel_client_order 1733 1733 0 0.00 0 2736 28 0 0
t$perf-norm:sp_cancel_customer_reserve 668 668 0 0.00 0 6179 42 0 0
t$perf-norm:sp_cancel_pay_from_customer 675 675 0 0.00 0 1688 15 0 0
t$perf-norm:sp_cancel_pay_to_supplier 430 430 0 0.00 0 520 13 0 0
t$perf-norm:sp_cancel_supplier_invoice 429 429 0 0.00 0 1128 36 0 0
t$perf-norm:sp_cancel_supplier_order 388 388 0 0.00 0 75745 6860 0 0
t$perf-norm:sp_cancel_write_off 1023 1023 0 0.00 0 6012 22 0 0
t$perf-norm:sp_client_order 20686 20686 0 0.00 0 8640 36 0 0
t$perf-norm:sp_customer_reserve 1077 1077 0 0.00 0 2428 17 0 0
t$perf-norm:sp_pay_from_customer 6902 6902 0 0.00 0 7232 20 0 0
t$perf-norm:sp_pay_to_supplier 5771 5771 0 0.00 0 4902 22 0 0
t$perf-norm:sp_reserve_write_off 10011 10011 0 0.00 0 11769 23 0 0
t$perf-norm:sp_supplier_invoice 5583 5583 0 0.00 0 3093 29 0 0
t$perf-norm:sp_supplier_order 5501 5501 0 0.00 0 5391 32 0 0
t$perf-norm:srv_aggregate_perf_data 119 119 0 0.00 0 246 10 0 0
t$perf-norm:srv_fill_mon_cache_memory 72 72 0 0.00 0 3749 59 0 0
t$perf-norm:srv_make_invnt_saldo 455 455 0 0.00 0 976 18 0 0
t$perf-norm:srv_make_money_saldo 905 905 0 0.00 0 354 5 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 4 191 60 0 0
v_add_invoice_to_stock 10332 10112 220 2.12 0 9350 29 0 220
v_all_customers 37726 37726 0 0.00 0 83 4 0 0
v_all_suppliers 30122 30122 0 0.00 0 70 5 0 0
v_all_wares 41368 41368 0 0.00 0 128 4 0 0
v_cancel_adding_invoice 862 862 0 0.00 0 2259 20 0 0
v_cancel_client_order 3466 3466 0 0.00 0 3143 11 0 0
v_cancel_customer_prepayment 1350 1350 0 0.00 0 2366 13 0 0
v_cancel_customer_reserve 1336 1336 0 0.00 0 174 10 0 0
v_cancel_payment_to_supplier 860 860 0 0.00 0 712 13 0 0
v_cancel_supplier_invoice 866 858 8 0.92 0 889 27 0 8
v_cancel_supplier_order 776 776 0 0.00 0 2725 17 0 0
v_cancel_write_off 2046 2046 0 0.00 0 3598 30 0 0
v_max_id_clo_ord 5498 5498 0 0.00 0 522 5 0 0
v_max_id_clo_res 1077 1077 0 0.00 0 1139 11 0 0
v_max_id_ord_sup 5575 5575 0 0.00 0 6425 10 0 0
v_max_non_paid_invoice 1781 1781 0 0.00 0 206 8 0 0
v_max_non_paid_realizn 3606 3606 0 0.00 0 4980 10 0 0
v_min_id_clo_ord 5497 5497 0 0.00 0 3632 8 0 0
v_min_id_clo_res 1077 1077 0 0.00 0 1528 8 0 0
v_min_id_ord_sup 5575 5575 0 0.00 0 6490 15 0 0
v_min_non_paid_invoice 5770 5770 0 0.00 0 4057 12 0 0
v_min_non_paid_realizn 6902 6902 0 0.00 0 10281 19 0 0
v_our_firm 10233 10233 0 0.00 0 72 5 0 0
v_reserve_write_off 20018 20018 0 0.00 0 2907 11 0 0
x_lock_depdocs_on_canc_invoice 11319 11319 0 0.00 0 21672 137 0 0
x_lock_depdocs_on_canc_sup_ord 388 388 0 0.00 0 25699 456 0 0
x_make_qstorno_1000_1200 5501 5501 0 0.00 3 34315 1216 0 0
x_make_qstorno_1200_2000 5583 5583 0 0.00 5 96604 2694 0 0
x_make_qstorno_2100_3300 476382 476382 0 0.00 0 92512 209 0 0

Completed "Performance in DETAILS". Done for 00:00:05, from 20-01-2023 07:40:27 to 20-01-2023 07:40:32.

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
05:07:28 6 8192000000 8808955344 8824348672 11951040 0.145 5 2 4 0 12162352 136512 74800
05:08:28 26080 8192000000 9715922752 10013986816 795568496 8.851 100 83 166 0 823897920 8268768 20060656
05:10:04 19326 8192000000 9761797536 10070511616 835885120 9.258 100 90 178 1 869862832 12702640 21275072
05:11:38 14384 8192000000 9812419392 10130259968 871842512 9.618 100 91 182 1 917550864 24817936 20890416
05:12:55 5560 8192000000 9879707664 10214539264 919241888 10.089 100 86 171 0 990466880 52190496 19034496
05:14:04 3568 8192000000 9921195344 10265698304 964974688 10.538 100 88 172 0 1036927808 53801072 18152048
05:15:10 2464 8192000000 9968248688 10322526208 995487776 10.835 100 86 159 3 1077376832 66236832 15652224
05:16:14 848 8192000000 10006850752 10371526656 1017816848 11.051 100 96 190 1 1124048976 86556224 19675904
05:17:17 980 8192000000 10005146704 10375077888 1045928320 11.322 100 94 179 1 1126975920 62094832 18952768
05:18:19 988 8192000000 10018212496 10391076864 1055496192 11.413 100 98 193 4 1140417152 65186944 19734016
05:19:21 1052 8192000000 10047671040 10424594432 1063532688 11.490 100 97 185 2 1169916992 88661744 17722560
05:20:23 1670 8192000000 10037737920 10416242688 1067719248 11.530 100 89 170 1 1156487376 70714112 18054016
05:21:25 1046 8192000000 10032899984 10417426432 1076265408 11.612 100 90 174 1 1155533616 62545472 16722736
05:22:29 975 8192000000 10027513776 10419224576 1081324640 11.660 100 72 134 2 1152725600 57828672 13572288
05:23:31 847 8192000000 10057872272 10450190336 1085446096 11.699 100 89 165 1 1182937568 79085280 18406192
05:24:33 1175 8192000000 10070542592 10457153536 1089293984 11.736 100 98 179 3 1191690064 84131760 18264320
05:25:35 1447 8192000000 10053307152 10438561792 1091157824 11.754 100 95 179 0 1172855072 64541680 17155568
05:26:37 1065 8192000000 10050534800 10440089600 1096785776 11.807 100 88 161 5 1170887792 56729776 17372240
05:27:39 1200 8192000000 10079641888 10468323328 1093089904 11.772 100 85 165 0 1198358272 88547456 16720912
05:28:42 1558 8192000000 10031325104 10420723712 1079650992 11.644 99 84 153 5 1159749088 63673824 16424272
05:29:45 1466 8192000000 10040589808 10426839040 1080162544 11.649 100 76 144 0 1157902608 62362320 15377744
05:30:47 1100 8192000000 10015363904 10391961600 1060621904 11.462 100 88 168 2 1136649712 57171664 18856144
05:31:53 925 8192000000 9981510608 10357899264 1037867904 11.244 99 86 166 0 1107248720 54412672 14968144
05:32:55 819 8192000000 9997830656 10373533696 1051856592 11.378 100 87 164 2 1122434224 54099600 16478032
05:33:56 1056 8192000000 10002210128 10374434816 1036638384 11.232 100 87 160 1 1121545568 68139136 16768048
05:35:05 1129 8192000000 9995522304 10363490304 1019516368 11.067 99 98 183 0 1112421680 74372704 18532608
05:36:07 1176 8192000000 9983373472 10359939072 1027232064 11.142 99 81 149 1 1104617840 62135600 15250176
05:37:09 1180 8192000000 10004459104 10381664256 1057312864 11.431 100 96 167 1 1129389088 53050448 19025776
05:38:17 29056 8192000000 10039240608 10424836096 1060175824 11.458 99 78 145 1 1152231376 77691280 14364272
05:39:51 993 8192000000 10016830512 10397347840 1075860112 11.608 100 83 152 4 1135219136 41751312 17607712
05:40:55 27277 8192000000 10070262448 10471202816 1091056464 11.753 100 58 116 0 1178718608 75705472 11956672
05:42:30 5120 8192000000 10101019248 10496720896 1103174064 11.868 100 63 120 1 1218595600 102227872 13193664
05:43:38 2202 8192000000 10124489600 10511568896 1101994400 11.857 99 79 154 2 1240015040 121396192 16624448
05:44:45 3840 8192000000 10158103584 10565226496 1126458080 12.088 100 78 148 0 1275766624 132900000 16408544
05:45:52 2712 8192000000 10188312160 10581184512 1141347952 12.228 100 87 162 1 1303633488 145829312 16456224
05:46:57 1095 8192000000 10241408064 10637246464 1143412336 12.248 100 99 192 2 1353278160 188932224 20933600
05:48:01 6434 8192000000 10252655472 10663821312 1153059120 12.338 100 76 151 0 1370214192 200365712 16789360
05:49:11 939 8192000000 10275973056 10688421888 1143385088 12.247 100 96 188 1 1388998704 224995040 20618576
05:50:14 962 8192000000 10309830080 10709061632 1156849344 12.374 99 97 187 0 1426244160 248485664 20909152
05:51:18 1161 8192000000 10316085824 10749485056 1162209600 12.424 100 81 156 1 1425778496 245526960 18041936
05:52:23 2186 8192000000 10303646960 10728009728 1155526128 12.361 99 80 156 0 1417725328 245388736 16810464
05:53:34 3357 8192000000 10349151552 10765041664 1178113392 12.573 100 76 141 1 1456047776 261320624 16613760
05:54:43 832 8192000000 10366475296 10770632704 1186582000 12.652 100 94 179 2 1476497216 268889712 21025504
05:55:48 773 8192000000 10393532512 10813468672 1189423616 12.678 100 96 187 1 1502633296 291560736 21648944
05:56:50 921 8192000000 10437593520 10852237312 1192689504 12.708 100 96 180 1 1543408160 329985056 20733600
05:57:54 723 8192000000 10497750304 10901057536 1192227232 12.704 100 95 186 0 1603220304 389706816 21286256
05:58:57 1035 8192000000 10540758432 10954231808 1199148560 12.768 100 99 196 0 1643989664 421551808 23289296
06:00:00 1127 8192000000 10552632016 10955411456 1185052528 12.637 99 96 191 1 1656681920 449475488 22153904
06:01:05 803 8192000000 10575721808 10995724288 1179633008 12.587 99 94 181 2 1681518848 479650064 22235776
06:02:08 1067 8192000000 10589790336 11049336832 1192397808 12.706 100 82 159 1 1702085744 488640096 21047840
06:03:11 15401 8192000000 10555962992 11033550848 1161425744 12.417 98 52 100 0 1659153376 484408976 13318656
06:04:33 5393 8192000000 10577569712 11040190464 1164701024 12.447 100 63 124 0 1685512368 504700704 16110640
06:06:01 9075 8192000000 10442269552 10932457472 1155314992 12.359 100 39 76 0 1549062448 383426064 10321392
06:07:13 16365 8192000000 10345228848 10840408064 1152923584 12.337 99 40 76 1 1461674592 298295760 10455248
06:08:35 34793 8192000000 10253348160 10744229888 1143393328 12.247 99 32 62 0 1370326912 219617456 7316128
06:10:10 33889 8192000000 10196687408 10684067840 1129397888 12.116 99 25 44 2 1299447376 163525920 6523568
06:11:45 36608 8192000000 10067734880 10541694976 1099954896 11.837 97 12 24 0 1168197776 65900656 2342224
06:14:02 29258 8192000000 10122527088 10544320512 1135379904 12.172 99 43 84 0 1205420352 60943008 9097440
06:15:40 70228 8192000000 10098106064 10574360576 1126511520 12.088 98 22 39 1 1164819008 34718208 3589280
06:17:58 134720 8192000000 10138315808 10627391488 1137021120 12.188 99 9 19 0 1200141536 61316896 1803520
06:21:26 119072 8192000000 10096350400 10577616896 1127222144 12.095 98 29 56 0 1194390432 60630896 6537392
06:24:31 6462 8192000000 10067988544 10486046720 1109939392 11.932 98 74 134 3 1154764400 32729936 12095072
06:25:39 84600 8192000000 10079796192 10521657344 1133902320 12.158 99 27 50 0 1172136352 33339136 4894896
06:28:08 21645 8192000000 10127475824 10559172608 1117950064 12.008 98 30 58 1 1196568288 71678192 6940032
06:29:35 11275 8192000000 10146322608 10576289792 1151120336 12.320 100 47 88 1 1239638000 78338864 10178800
06:30:47 31525 8192000000 10192395856 10637873152 1131684784 12.137 98 41 81 0 1274572064 133953328 8933952
06:32:21 57067 8192000000 10201680416 10659233792 1118909136 12.017 97 23 44 0 1288884320 164788928 5186256
06:34:18 26301 8192000000 10219148784 10683101184 1125270096 12.077 99 23 44 1 1318838400 187907040 5661264
06:35:45 62015 8192000000 10230321440 10703278080 1126397184 12.087 99 21 43 0 1324826944 193284144 5145616
06:37:50 34072 8192000000 10259716768 10707177472 1132222752 12.142 99 27 52 0 1330178704 191971984 5983968
06:39:46 46007 8192000000 10111349568 10568814592 1149208080 12.302 100 21 40 0 1218012272 64250544 4553648
06:41:37 40433 8192000000 10086222928 10523324416 1110080656 11.933 97 18 34 1 1151470384 38213680 3176048
06:43:20 11958 8192000000 10149838672 10579353600 1132602960 12.146 99 72 140 1 1235139952 87540624 14996368
06:44:34 63742 8192000000 10143257840 10601529344 1106248144 11.897 97 30 57 0 1229879120 116934848 6696128
06:46:39 34910 8192000000 10139485360 10576154624 1129283200 12.115 99 19 38 1 1199462416 66445536 3733680
06:49:04 103070 8192000000 10060484112 10509819904 1119589936 12.023 98 22 42 0 1143244768 19711296 3943536
06:51:48 17077 8192000000 10101273952 10537746432 1138995200 12.206 100 50 89 2 1200211200 52184816 9031184
06:53:05 56813 8192000000 10108999136 10595401728 1116975392 11.998 98 18 32 0 1221781408 100968912 3837104
06:55:03 70207 8192000000 10070974464 10561552384 1115499856 11.984 98 16 32 0 1167297648 48617728 3180064
06:57:21 67946 8192000000 10075584832 10546073600 1125752048 12.081 99 14 28 0 1177871472 49198768 2920656
06:59:29 102044 8192000000 10104110896 10596352000 1121944352 12.045 98 12 24 0 1220714512 96010688 2759472
07:02:11 45354 8192000000 10136842528 10602102784 1111093792 11.943 97 24 48 1 1206597776 90476992 5026992
07:04:09 43736 8192000000 10118819392 10612281344 1151155488 12.320 100 32 65 0 1265294592 106672128 7466976
07:06:26 19794 8192000000 10153340176 10599485440 1155133408 12.358 100 39 75 0 1259651328 96266448 8251472
07:07:47 20529 8192000000 10205390112 10638352384 1145729360 12.269 99 55 108 0 1265308032 108552912 11025760
07:09:12 60217 8192000000 10140614896 10650013696 1113895552 11.969 97 16 30 0 1211449104 94673392 2880160
07:11:14 80848 8192000000 10092618416 10559131648 1135536304 12.174 99 19 39 1 1190897248 51365456 3995488
07:13:35 90083 8192000000 10133523568 10593132544 1116234432 11.991 97 20 40 0 1217463648 96505616 4723600
07:16:12 39981 8192000000 10096502816 10549993472 1120658960 12.033 98 17 34 0 1174784928 50886272 3239696
07:18:14 46097 8192000000 10065781776 10519691264 1119200400 12.019 99 13 19 0 1166000864 44742144 2058320
07:20:03 84609 8192000000 10047471152 10502889472 1123400736 12.059 99 12 23 0 1169364608 43353168 2610704
07:22:29 64523 8192000000 10064200736 10533474304 1130905712 12.130 100 18 36 0 1180613648 45253680 4454256
07:25:23 51623 8192000000 10102365040 10557280256 1136516032 12.183 100 24 48 2 1196776992 55202560 5058400
07:27:19 51568 8192000000 10070973856 10533429248 1113827968 11.969 98 21 42 0 1167188896 49014992 4345936
07:29:13 15735 8192000000 10100743776 10542039040 1122693328 12.052 99 45 89 0 1179323664 47648592 8981744
07:30:35 15551 8192000000 10142173376 10576605184 1144581520 12.259 100 42 80 0 1228698768 76115536 8001712
07:31:53 34795 8192000000 10164718272 10619764736 1127987456 12.102 99 39 78 1 1241528064 105333472 8207136
07:33:29 78729 8192000000 10139681488 10612826112 1056888128 11.427 93 23 46 0 1199695088 138005968 4800992
07:35:50 21946 8192000000 10128009248 10558328832 1105887232 11.893 98 46 92 0 1192768416 77785136 9096048
07:37:13 47154 8192000000 8997496528 9224798208 159957072 1.915 15 4 8 0 175202160 14570288 674800

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:16, from 20-01-2023 07:40:34 to 20-01-2023 07:40:50.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 110 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 20-01-2023 07:40:51 to 20-01-2023 07:40:53.

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          223912
MON$OLDEST_ACTIVE               223913
MON$OLDEST_SNAPSHOT             223913
MON$NEXT_TRANSACTION            223913
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                       2087264
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                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             786
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.3.2890 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.3.2890 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.3.2890 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.3.2890 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17: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'

20.01.23 07:40:54. 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
2023-01-20 07:40:57 No severe PSQL-related problems occured
20.01.23 07:40:58. End of report.