Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 10.05.2022 01:40
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 16711472 kB
MemAvailable 31513560 kB
Buffers 0 kB
Cached 15036588 kB
SwapCached 2576 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.10
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-05-10 01:38:11
DTS_END                         2022-05-10 01:38:11.8720
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/42476
TRN_ID                          232091
ATT_ID                          691
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: 8924.37 26433 1070924
customer order: creation 162.14 385 19457
customer order: refuse 13.50 353 1620
order to supplier: creation 43.73 1363 5247
order to supplier: removal 3.13 108100 375
invoice (draft): creation 42.99 3663 5159
invoice (draft): removal 51.59 763 6191
invoice accept: apply 39.42 17277 4730
invoice accept: cancel 46.51 773 5581
customer reserve: creation 3693.41 167 443209
customer reserve: removal 4549.88 58 545985
realization accept: apply 77.18 194 9261
realization accept: cancel 78.48 106 9418
payment from customer: creation 56.04 122 6725
payment from customer: removal 5.66 77 679
payment to supplier: creation 46.11 148 5533
payment to supplier: removal 3.46 74 415
service: total inventory turnovers 4.54 1148 545
service: total monetary turnovers 5.78 25 693
service: aggregate perf. data 0.81 19471 97
service: refresh index statistics 0.03 374398 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-05-2022 01:40:37 to 10-05-2022 01:40:39.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6230
TEST_TIME 2 4004
TEST_TIME 3 3658
TEST_TIME 4 4018
TEST_TIME 5 4045
TEST_TIME 6 3813
TEST_TIME 7 4284
TEST_TIME 8 4608
TEST_TIME 9 4915
TEST_TIME 10 5190
TEST_TIME 11 5112
TEST_TIME 12 5333
TEST_TIME 13 5433
TEST_TIME 14 5597
TEST_TIME 15 6173
TEST_TIME 16 6616
TEST_TIME 17 6658
TEST_TIME 18 6554
TEST_TIME 19 7406
TEST_TIME 20 7412
TEST_TIME 21 8157
TEST_TIME 22 8950
TEST_TIME 23 9007
TEST_TIME 24 9484
TEST_TIME 25 9886
TEST_TIME 26 10152
TEST_TIME 27 10946
TEST_TIME 28 10853
TEST_TIME 29 10635
TEST_TIME 30 10505
TEST_TIME 31 10173
TEST_TIME 32 9937
TEST_TIME 33 10039
TEST_TIME 34 9978
TEST_TIME 35 9974
TEST_TIME 36 9973
TEST_TIME 37 9914
TEST_TIME 38 9740
TEST_TIME 39 9545
TEST_TIME 40 9466
TEST_TIME 41 9620
TEST_TIME 42 9506
TEST_TIME 43 9389
TEST_TIME 44 9348
TEST_TIME 45 9307
TEST_TIME 46 9370
TEST_TIME 47 9299
TEST_TIME 48 9145
TEST_TIME 49 9150
TEST_TIME 50 9069
TEST_TIME 51 9106
TEST_TIME 52 9065
TEST_TIME 53 9076
TEST_TIME 54 9107
TEST_TIME 55 9112
TEST_TIME 56 9133
TEST_TIME 57 9105
TEST_TIME 58 9162
TEST_TIME 59 9192
TEST_TIME 60 9285
TEST_TIME 61 9341
TEST_TIME 62 9338
TEST_TIME 63 9386
TEST_TIME 64 9260
TEST_TIME 65 9153
TEST_TIME 66 9129
TEST_TIME 67 9080
TEST_TIME 68 8981
TEST_TIME 69 8947
TEST_TIME 70 8911
TEST_TIME 71 9000
TEST_TIME 72 9038
TEST_TIME 73 8987
TEST_TIME 74 9045
TEST_TIME 75 9053
TEST_TIME 76 9005
TEST_TIME 77 8995
TEST_TIME 78 9027
TEST_TIME 79 9044
TEST_TIME 80 9036
TEST_TIME 81 9191
TEST_TIME 82 9233
TEST_TIME 83 9195
TEST_TIME 84 9108
TEST_TIME 85 9064
TEST_TIME 86 9035
TEST_TIME 87 9008
TEST_TIME 88 9039
TEST_TIME 89 9045
TEST_TIME 90 8979
TEST_TIME 91 8918
TEST_TIME 92 8862
TEST_TIME 93 8948
TEST_TIME 94 8958
TEST_TIME 95 8966
TEST_TIME 96 9013
TEST_TIME 97 8992
TEST_TIME 98 8984
TEST_TIME 99 9046
TEST_TIME 100 9077
TEST_TIME 101 9054
TEST_TIME 102 9023
TEST_TIME 103 9152
TEST_TIME 104 9132
TEST_TIME 105 9186
TEST_TIME 106 9258
TEST_TIME 107 9248
TEST_TIME 108 9214
TEST_TIME 109 9192
TEST_TIME 110 9124
TEST_TIME 111 9136
TEST_TIME 112 9092
TEST_TIME 113 9060
TEST_TIME 114 9035
TEST_TIME 115 9061
TEST_TIME 116 9020
TEST_TIME 117 8969
TEST_TIME 118 9011
TEST_TIME 119 8998
TEST_TIME 120 8927

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 10-05-2022 01:40:40 to 10-05-2022 01:40:44.

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 1481646 1481646 0 0.00 0 32116 6 0 0
doc_list_biud 1481646 1481646 0 0.00 0 55139 27 0 0
sp_add_invoice_to_stock 4829 4730 99 2.05 33 182866 17277 0 99
sp_cancel_adding_invoice 5581 5581 0 0.00 5 51885 774 0 0
sp_cancel_client_order 1620 1620 0 0.00 4 9520 354 0 0
sp_cancel_customer_reserve 545985 545985 0 0.00 1 55142 59 0 0
sp_cancel_pay_from_customer 679 679 0 0.00 2 10809 78 0 0
sp_cancel_pay_to_supplier 415 415 0 0.00 2 4719 74 0 0
sp_cancel_supplier_invoice 6199 6191 8 0.12 2 52230 764 0 8
sp_cancel_supplier_order 375 375 0 0.00 6 1056604 108101 0 0
sp_cancel_write_off 9418 9418 0 0.00 1 11827 107 0 0
sp_client_order 19457 19457 0 0.00 3 18369 386 0 0
sp_customer_reserve 443209 443209 0 0.00 0 47048 168 0 0
sp_fill_shopping_cart 29862 29862 0 0.00 1 22763 50 0 0
sp_fill_shopping_cart_clo_res 443207 443207 0 0.00 0 24136 15 0 0
sp_get_clo_for_invoice 4728 4728 0 0.00 0 25660 333 0 0
sp_kill_cost_storno 16093 16093 0 0.00 0 7107 53 0 0
sp_kill_qstorno_ret_qs2qd 1107954 1107954 0 0.00 0 55131 32 0 0
sp_kill_qty_storno 583159 583159 0 0.00 0 55139 69 0 0
sp_lock_selected_doc 19454 19454 0 0.00 0 6884 6 0 0
sp_make_cost_storno 26247 26247 0 0.00 0 32089 66 0 0
sp_multiply_rows_for_pdistr 26247 26247 0 0.00 0 6723 28 0 0
sp_multiply_rows_for_qdistr 19457 19457 0 0.00 0 17524 171 0 0
sp_pay_from_customer 6725 6725 0 0.00 4 11918 123 0 0
sp_pay_to_supplier 5533 5533 0 0.00 5 12196 148 0 0
sp_payment_common 12258 12258 0 0.00 1 11282 34 0 0
sp_qd_handle_on_cancel_clo 1620 1620 0 0.00 0 9093 319 0 0
sp_qd_handle_on_invoice_upd_sts 10309 10309 0 0.00 0 42609 348 0 0
sp_qd_handle_on_reserve_upd_sts 9261 9261 0 0.00 0 15775 66 0 0
sp_reserve_write_off 9261 9261 0 0.00 6 15819 194 0 0
sp_supplier_invoice 5159 5159 0 0.00 7 145978 3663 0 0
sp_supplier_order 5247 5247 0 0.00 5 48289 1364 0 0
srv_aggregate_perf_data 97 97 0 0.00 2732 270742 19471 0 0
srv_fill_mon_cache_memory 57 57 0 0.00 2257 142392 56221 0 0
srv_find_qd_qs_mism 1025727 1025727 0 0.00 0 15262 5 0 0
srv_make_invnt_saldo 545 545 0 0.00 42 102705 1149 0 0
srv_make_money_saldo 693 693 0 0.00 1 1888 26 0 0
srv_recalc_idx_stat 4 4 0 0.00 249108 572831 374399 0 0
t$perf-abend:sp_add_invoice_to_stock 99 99 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4731 4731 0 0.00 0 24297 194 0 0
t$perf-norm:sp_cancel_adding_invoice 366 366 0 0.00 1 7980 101 0 0
t$perf-norm:sp_cancel_client_order 1620 1620 0 0.00 0 3809 15 0 0
t$perf-norm:sp_cancel_customer_reserve 639 639 0 0.00 0 2785 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 679 679 0 0.00 0 966 5 0 0
t$perf-norm:sp_cancel_pay_to_supplier 415 415 0 0.00 0 1444 7 0 0
t$perf-norm:sp_cancel_supplier_invoice 374 374 0 0.00 0 1217 16 0 0
t$perf-norm:sp_cancel_supplier_order 375 375 0 0.00 0 16731 1429 0 0
t$perf-norm:sp_cancel_write_off 997 997 0 0.00 0 2389 11 0 0
t$perf-norm:sp_client_order 19457 19457 0 0.00 0 18099 20 0 0
t$perf-norm:sp_customer_reserve 938 938 0 0.00 0 7446 23 0 0
t$perf-norm:sp_pay_from_customer 6725 6725 0 0.00 0 13999 11 0 0
t$perf-norm:sp_pay_to_supplier 5533 5533 0 0.00 0 17218 11 0 0
t$perf-norm:sp_reserve_write_off 9261 9261 0 0.00 0 6906 13 0 0
t$perf-norm:sp_supplier_invoice 5159 5159 0 0.00 0 7848 25 0 0
t$perf-norm:sp_supplier_order 5247 5247 0 0.00 0 7178 17 0 0
t$perf-norm:srv_aggregate_perf_data 97 97 0 0.00 0 114 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 57 57 0 0.00 0 174 3 0 0
t$perf-norm:srv_make_invnt_saldo 545 545 0 0.00 0 3670 24 0 0
t$perf-norm:srv_make_money_saldo 693 693 0 0.00 0 2841 23 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 5 2 0 0
v_add_invoice_to_stock 9652 9454 198 2.05 0 4849 16 0 198
v_all_customers 35402 35402 0 0.00 0 37 0 0 0
v_all_suppliers 28566 28566 0 0.00 0 30 1 0 0
v_all_wares 38914 38914 0 0.00 0 74 1 0 0
v_cancel_adding_invoice 732 732 0 0.00 0 1596 9 0 0
v_cancel_client_order 3240 3240 0 0.00 0 2864 4 0 0
v_cancel_customer_prepayment 1358 1358 0 0.00 0 2335 5 0 0
v_cancel_customer_reserve 1278 1278 0 0.00 0 3363 9 0 0
v_cancel_payment_to_supplier 830 830 0 0.00 0 1699 9 0 0
v_cancel_supplier_invoice 764 748 16 2.09 0 276 12 0 16
v_cancel_supplier_order 750 750 0 0.00 0 2779 7 0 0
v_cancel_write_off 1994 1994 0 0.00 0 4779 17 0 0
v_max_id_clo_ord 5246 5246 0 0.00 0 1616 2 0 0
v_max_id_clo_res 938 938 0 0.00 0 2373 12 0 0
v_max_id_ord_sup 5159 5159 0 0.00 0 5525 6 0 0
v_max_non_paid_invoice 1655 1655 0 0.00 0 817 3 0 0
v_max_non_paid_realizn 3653 3653 0 0.00 0 1944 4 0 0
v_min_id_clo_ord 5246 5246 0 0.00 0 15873 20 0 0
v_min_id_clo_res 938 938 0 0.00 0 1858 6 0 0
v_min_id_ord_sup 5159 5159 0 0.00 0 22697 26 0 0
v_min_non_paid_invoice 5533 5533 0 0.00 0 9497 20 0 0
v_min_non_paid_realizn 6725 6725 0 0.00 0 11248 29 0 0
v_our_firm 9656 9656 0 0.00 0 12 1 0 0
v_reserve_write_off 18522 18522 0 0.00 0 4707 6 0 0
x_lock_depdocs_on_canc_invoice 11398 11398 0 0.00 0 23034 117 0 0
x_lock_depdocs_on_canc_sup_ord 375 375 0 0.00 0 7308 354 0 0
x_make_qstorno_1000_1200 5247 5247 0 0.00 1 48282 1264 0 0
x_make_qstorno_1200_2000 5159 5159 0 0.00 2 130040 3479 0 0
x_make_qstorno_2100_3300 443209 443209 0 0.00 0 47019 151 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-05-2022 01:40:45 to 10-05-2022 01:40:49.

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:08:15 2 8192000000 8799337984 8810758144 3955424 0.048 1 1 2 0 4053696 55488 42784
23:09:16 35883 8192000000 9910938080 10220732416 985707136 10.740 100 88 176 0 1014567872 6019296 22841440
23:11:02 28032 8192000000 9952678400 10276114432 1036406720 11.230 100 86 172 0 1067557536 8745008 22405808
23:12:35 21508 8192000000 9990489824 10321182720 1068318480 11.536 100 88 176 0 1100473664 10610976 21544208
23:14:06 10322 8192000000 10035078368 10381377536 1120918096 12.036 100 81 160 1 1151437504 11714304 18805104
23:15:17 8982 8192000000 10094090912 10453770240 1176080464 12.554 100 80 160 1 1207989312 13599184 18309664
23:16:29 5418 8192000000 10137458368 10509946880 1226519424 13.022 100 83 166 0 1258913536 13384496 19009616
23:17:36 2869 8192000000 10179076048 10557431808 1261444960 13.343 100 87 173 1 1294460608 14537248 18478400
23:18:41 1543 8192000000 10213949728 10598301696 1295589504 13.655 100 95 191 1 1329663920 12510496 21563920
23:19:45 9209 8192000000 10224981648 10615443456 1311381696 13.799 100 77 155 1 1339882976 11108080 17393200
23:20:55 5483 8192000000 10204831104 10622984192 1322514864 13.899 100 26 52 0 1335978416 7600176 5863376
23:22:02 8484 8192000000 10209377856 10631294976 1329470352 13.962 100 23 46 0 1340369440 5518080 5381008
23:23:11 6800 8192000000 10222660560 10639654912 1333499904 13.999 100 22 44 2 1343873664 5653296 4720464
23:24:23 38950 8192000000 10239559648 10659635200 1338443744 14.043 100 39 77 0 1352458224 5572256 8442224
23:26:03 3425 8192000000 10242541856 10662899712 1342976400 14.084 100 34 66 4 1360362304 9465984 7919920
23:27:10 10090 8192000000 10221477360 10641653760 1310015440 13.786 98 21 42 1 1320077648 5407344 4654864
23:28:21 52432 8192000000 10205726208 10614280192 1306797056 13.757 100 42 85 0 1322108736 5278960 10032720
23:30:14 7357 8192000000 10162331712 10571796480 1247640128 13.217 97 20 40 0 1257555680 5579504 4336048
23:31:22 8994 8192000000 10150881712 10553569280 1228420000 13.039 97 23 45 4 1239162096 5094064 5648032
23:32:32 10847 8192000000 10165236480 10573676544 1250343648 13.241 98 15 30 0 1263461488 9663856 3453984
23:33:43 36096 8192000000 10167980240 10575835136 1257421344 13.306 98 28 56 1 1269906064 5842384 6642336
23:35:20 8046 8192000000 10185425312 10595663872 1290534128 13.609 100 27 54 1 1303435232 6681440 6219664
23:36:30 8050 8192000000 10196397488 10611736576 1303274592 13.725 100 17 34 0 1312525344 5213312 4037440
23:37:38 7007 8192000000 10197823824 10618331136 1309437040 13.781 100 9 18 0 1317205424 5481536 2286848
23:38:51 135235 8192000000 10254480016 10677235712 1346599552 14.117 100 46 93 3 1364921744 7197440 11124752
23:42:18 11421 8192000000 10276194224 10696781824 1370826752 14.334 100 37 72 3 1388876224 9533136 8516336
23:43:34 29067 8192000000 10302664976 10726100992 1387936640 14.487 100 44 88 0 1416527312 18604928 9985744
23:45:14 26227 8192000000 10322431600 10747314176 1396755424 14.566 100 50 100 1 1433938672 24935392 12247856
23:46:53 4955 8192000000 10352807504 10779500544 1419464528 14.768 100 53 99 0 1464692544 33071632 12156384
23:48:01 3753 8192000000 10357179056 10777358336 1416239712 14.739 100 59 118 2 1465801968 34888656 14673600
23:49:08 6727 8192000000 10359934816 10778427392 1417942832 14.754 100 66 131 3 1466382352 32917232 15522288
23:50:18 9061 8192000000 10360728832 10773905408 1403591072 14.627 99 65 129 1 1459874112 40249088 16033952
23:51:32 5806 8192000000 10356471232 10768310272 1403788096 14.629 99 64 128 0 1460571648 41183568 15599984
23:52:43 3860 8192000000 10383088160 10792857600 1417987504 14.755 100 80 160 1 1484669600 47352192 19329904
23:53:59 15174 8192000000 10375173792 10803884032 1413694832 14.717 99 44 87 3 1476098176 50355104 12048240
23:55:22 12742 8192000000 10351776800 10772955136 1364512240 14.278 97 49 98 0 1432939648 55123968 13303440
23:56:40 2256 8192000000 10363534608 10763919360 1375352016 14.375 99 86 171 4 1460401728 62981056 22068656
23:57:45 13250 8192000000 10365663792 10791907328 1386797728 14.477 99 41 83 0 1459906992 61664816 11444448
23:59:05 10485 8192000000 10348076432 10774212608 1384098528 14.453 100 41 82 2 1461541072 65258304 12184240
00:00:20 11395 8192000000 10348195264 10784210944 1388925568 14.496 100 30 60 0 1457948688 61040320 7982800
00:01:35 40742 8192000000 10336703104 10792140800 1379448224 14.412 99 25 50 0 1446638576 60120992 7069360
00:03:17 51380 8192000000 10322018704 10778800128 1370598336 14.332 99 19 38 1 1423410768 47385360 5427072
00:05:23 40805 8192000000 10282470528 10741993472 1342523456 14.080 99 12 24 1 1376383168 30912912 2946800
00:07:06 60177 8192000000 10275563856 10720645120 1314333136 13.825 96 11 22 1 1331226816 14307296 2586384
00:09:08 94473 8192000000 10281228464 10731446272 1369427232 14.322 100 28 57 2 1392913408 17158752 6327424
00:11:46 74935 8192000000 10278101840 10728235008 1331459648 13.980 96 25 48 1 1352306016 14042976 6803392
00:14:37 76407 8192000000 10279745296 10742075392 1352416176 14.169 99 8 16 1 1365918864 11736080 1766608
00:16:54 71018 8192000000 10291894256 10739068928 1377143920 14.391 100 11 22 0 1397287504 17098192 3045392
00:19:30 45541 8192000000 10271994240 10708951040 1336014944 14.021 97 34 67 0 1354316144 10330336 7970864
00:21:28 45769 8192000000 10276328816 10722271232 1369953552 14.327 100 25 50 0 1387815088 12022496 5839040
00:23:15 59115 8192000000 10273322736 10734333952 1357678672 14.217 98 24 49 2 1377630416 13498528 6453216
00:25:21 69651 8192000000 10283154480 10742398976 1382099392 14.435 100 13 25 1 1392763120 7745920 2917808
00:27:31 50293 8192000000 10274849216 10734374912 1355711872 14.199 98 15 30 1 1370773072 11943136 3118064
00:29:23 64884 8192000000 10294672624 10749804544 1387777696 14.486 100 16 32 0 1398981872 7942976 3261200
00:31:28 47611 8192000000 10306486032 10762915840 1386564192 14.475 99 33 66 3 1404337568 10591952 7181424
00:33:20 64963 8192000000 10287906320 10737852416 1323832016 13.911 95 21 42 2 1337166736 8627632 4707088
00:36:39 99493 8192000000 10286926112 10747752448 1336877904 14.029 96 14 28 1 1358278784 18362064 3038816
00:39:28 135714 8192000000 10265618960 10721681408 1202189616 12.797 86 13 26 1 1217322768 12397680 2735472
00:42:50 66921 8192000000 10268770944 10705825792 1313777664 13.820 96 18 36 0 1322724112 4639360 4307088
00:44:58 81438 8192000000 10255359952 10710994944 1319470192 13.872 96 16 32 1 1335146368 12157872 3518304
00:47:40 83795 8192000000 10287808480 10744156160 1348752464 14.136 99 16 32 0 1373556528 21069440 3734624
00:50:04 95259 8192000000 10263498464 10715983872 1298377824 13.680 95 8 16 1 1318757216 18456384 1923008
00:52:40 98154 8192000000 10263834384 10717827072 1311211344 13.797 96 14 28 1 1327025488 12590176 3223968
00:55:18 40724 8192000000 10270741648 10721312768 1359915408 14.237 99 22 44 2 1375538144 10851664 4771072
00:57:00 89882 8192000000 10270510512 10717642752 1291964560 13.622 94 9 18 0 1306066144 12236352 1865232
00:59:51 142392 8192000000 10264691824 10707927040 1269772032 13.420 92 11 22 3 1286612880 14502528 2338320
01:03:51 57228 8192000000 10286643568 10731130880 1354174544 14.185 98 38 75 1 1371042976 8106944 8761488
01:06:01 84006 8192000000 10276030016 10746847232 1369589424 14.323 99 17 34 2 1385972464 12107536 4275504
01:09:15 76426 8192000000 10290822816 10744311808 1371879168 14.344 98 17 34 0 1387043104 11298784 3865152
01:13:01 42891 8192000000 10309209664 10761519104 1395885520 14.558 100 24 48 0 1408795888 7771840 5138528
01:14:44 65853 8192000000 10307573840 10766794752 1383836608 14.451 99 13 26 1 1396842592 9928736 3077248
01:16:52 82111 8192000000 10307782576 10784645120 1382134080 14.436 98 12 24 1 1402162512 17042608 2985824
01:19:14 58168 8192000000 10328433136 10785456128 1400390064 14.598 99 16 32 1 1417735744 13741600 3604080
01:21:13 74212 8192000000 10344642064 10796224512 1412652832 14.708 100 14 28 0 1436898016 21247632 2997552
01:23:30 59718 8192000000 10330890336 10805125120 1394201536 14.543 98 11 22 0 1422299472 25946112 2151824
01:25:30 124630 8192000000 10324787296 10772701184 1365477184 14.287 97 18 36 0 1387173200 17815392 3880624
01:29:09 46180 8192000000 10283173488 10747375616 1359071952 14.229 98 14 28 0 1370155088 8168944 2914192
01:30:56 82676 8192000000 10276938416 10742087680 1351523760 14.161 97 15 29 0 1366328288 11162880 3641648
01:34:04 101458 8192000000 10285445264 10744057856 1362538576 14.260 99 18 33 1 1375753392 9127408 4087408
01:36:49 19629 8192000000 10279449184 10748772352 1377435568 14.394 100 20 40 1 1396136064 14139136 4561360
01:38:09 36370 8192000000 9024678128 9234640896 195325984 2.328 15 1 2 0 199394736 4026400 42352

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 10-05-2022 01:40:51 to 10-05-2022 01:41:05.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 99 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 10-05-2022 01:41:06 to 10-05-2022 01:41:08.

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          233024
MON$OLDEST_ACTIVE               233025
MON$OLDEST_SNAPSHOT             233025
MON$NEXT_TRANSACTION            233025
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                       2019648
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.10.33587 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.10.33587 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.10.33587 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.10.33587 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 ---
:101: 
:102: mscs-test-161.budzdorov.ru    Tue May 10 01:38:51 2022
:103:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:104: 
--- end of diff output ---

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

10.05.22 01:41:09. 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-05-10 01:41:11 No severe PSQL-related problems occured
10.05.22 01:41:12. End of report.