Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 28.08.2021 22: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 58e1ddde69c44dad93d327777e5becec
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-05-09 08:45
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 4793.92
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 16365232 kB
MemAvailable 30947568 kB
Buffers 0 kB
Cached 15347868 kB
SwapCached 1324 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.8
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3333
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp30-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2021-08-28 22:37:49
DTS_END                         2021-08-28 22:37:49.7170
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/42684
TRN_ID                          234141
ATT_ID                          636
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: 9084.21 22570 1090105
customer order: creation 164.94 373 19793
customer order: refuse 14.30 372 1716
order to supplier: creation 42.85 1373 5142
order to supplier: removal 3.39 107600 407
invoice (draft): creation 44.82 3635 5378
invoice (draft): removal 51.46 835 6175
invoice accept: apply 41.20 19977 4944
invoice accept: cancel 46.58 780 5590
customer reserve: creation 3796.42 198 455570
customer reserve: removal 4590.99 63 550919
realization accept: apply 79.91 192 9589
realization accept: cancel 84.48 112 10138
payment from customer: creation 56.38 142 6766
payment from customer: removal 5.38 78 645
payment to supplier: creation 45.82 132 5498
payment to supplier: removal 3.27 81 392
service: total inventory turnovers 4.64 1128 557
service: total monetary turnovers 6.58 45 790
service: aggregate perf. data 0.77 24382 92
service: refresh index statistics 0.03 289909 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 28-08-2021 22:40:02 to 28-08-2021 22:40:04.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 3219
TEST_TIME 2 3373
TEST_TIME 3 3951
TEST_TIME 4 4473
TEST_TIME 5 4633
TEST_TIME 6 4993
TEST_TIME 7 5485
TEST_TIME 8 5597
TEST_TIME 9 5427
TEST_TIME 10 5496
TEST_TIME 11 5554
TEST_TIME 12 5581
TEST_TIME 13 5789
TEST_TIME 14 6185
TEST_TIME 15 6402
TEST_TIME 16 6946
TEST_TIME 17 7449
TEST_TIME 18 7627
TEST_TIME 19 7978
TEST_TIME 20 8041
TEST_TIME 21 8497
TEST_TIME 22 8684
TEST_TIME 23 9106
TEST_TIME 24 9198
TEST_TIME 25 9708
TEST_TIME 26 10407
TEST_TIME 27 10564
TEST_TIME 28 11062
TEST_TIME 29 10973
TEST_TIME 30 10814
TEST_TIME 31 10765
TEST_TIME 32 10508
TEST_TIME 33 10615
TEST_TIME 34 10550
TEST_TIME 35 10369
TEST_TIME 36 10168
TEST_TIME 37 10074
TEST_TIME 38 9948
TEST_TIME 39 9809
TEST_TIME 40 9655
TEST_TIME 41 9457
TEST_TIME 42 9585
TEST_TIME 43 9880
TEST_TIME 44 9941
TEST_TIME 45 9852
TEST_TIME 46 9756
TEST_TIME 47 9617
TEST_TIME 48 9647
TEST_TIME 49 9475
TEST_TIME 50 9403
TEST_TIME 51 9399
TEST_TIME 52 9327
TEST_TIME 53 9285
TEST_TIME 54 9162
TEST_TIME 55 9136
TEST_TIME 56 9145
TEST_TIME 57 9184
TEST_TIME 58 9162
TEST_TIME 59 9217
TEST_TIME 60 9236
TEST_TIME 61 9259
TEST_TIME 62 9337
TEST_TIME 63 9329
TEST_TIME 64 9331
TEST_TIME 65 9499
TEST_TIME 66 9441
TEST_TIME 67 9512
TEST_TIME 68 9468
TEST_TIME 69 9554
TEST_TIME 70 9495
TEST_TIME 71 9386
TEST_TIME 72 9340
TEST_TIME 73 9327
TEST_TIME 74 9293
TEST_TIME 75 9236
TEST_TIME 76 9195
TEST_TIME 77 9261
TEST_TIME 78 9185
TEST_TIME 79 9216
TEST_TIME 80 9214
TEST_TIME 81 9289
TEST_TIME 82 9282
TEST_TIME 83 9319
TEST_TIME 84 9293
TEST_TIME 85 9316
TEST_TIME 86 9344
TEST_TIME 87 9326
TEST_TIME 88 9322
TEST_TIME 89 9346
TEST_TIME 90 9369
TEST_TIME 91 9372
TEST_TIME 92 9410
TEST_TIME 93 9374
TEST_TIME 94 9357
TEST_TIME 95 9327
TEST_TIME 96 9256
TEST_TIME 97 9247
TEST_TIME 98 9243
TEST_TIME 99 9203
TEST_TIME 100 9227
TEST_TIME 101 9195
TEST_TIME 102 9173
TEST_TIME 103 9191
TEST_TIME 104 9165
TEST_TIME 105 9157
TEST_TIME 106 9190
TEST_TIME 107 9202
TEST_TIME 108 9204
TEST_TIME 109 9211
TEST_TIME 110 9275
TEST_TIME 111 9256
TEST_TIME 112 9246
TEST_TIME 113 9277
TEST_TIME 114 9264
TEST_TIME 115 9285
TEST_TIME 116 9230
TEST_TIME 117 9186
TEST_TIME 118 9161
TEST_TIME 119 9103
TEST_TIME 120 9085

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 28-08-2021 22:40:06 to 28-08-2021 22:40:09.

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 1511357 1511357 0 0.00 0 19427 7 0 0
doc_list_biud 1511357 1511357 0 0.00 0 43525 29 0 0
sp_add_invoice_to_stock 5047 4944 103 2.04 16 214069 19977 0 103
sp_cancel_adding_invoice 5590 5590 0 0.00 4 83702 780 0 0
sp_cancel_client_order 1716 1716 0 0.00 5 13126 372 0 0
sp_cancel_customer_reserve 550919 550919 0 0.00 1 43526 63 0 0
sp_cancel_pay_from_customer 645 645 0 0.00 2 5684 78 0 0
sp_cancel_pay_to_supplier 392 392 0 0.00 3 4176 82 0 0
sp_cancel_supplier_invoice 6188 6175 13 0.21 1 17004 835 0 13
sp_cancel_supplier_order 407 407 0 0.00 8 1019597 107600 0 0
sp_cancel_write_off 10138 10138 0 0.00 1 16372 113 0 0
sp_client_order 19793 19793 0 0.00 3 44032 373 0 0
sp_customer_reserve 455570 455570 0 0.00 0 49169 199 0 0
sp_fill_shopping_cart 30287 30287 0 0.00 1 16900 41 0 0
sp_fill_shopping_cart_clo_res 455568 455568 0 0.00 0 21876 14 0 0
sp_get_clo_for_invoice 4941 4941 0 0.00 0 29885 367 0 0
sp_kill_cost_storno 16765 16765 0 0.00 0 6018 54 0 0
sp_kill_qstorno_ret_qs2qd 1118558 1118558 0 0.00 0 43242 34 0 0
sp_kill_qty_storno 589475 589475 0 0.00 0 43525 74 0 0
sp_lock_selected_doc 20219 20219 0 0.00 0 6431 4 0 0
sp_make_cost_storno 26794 26794 0 0.00 0 15076 60 0 0
sp_multiply_rows_for_pdistr 26794 26794 0 0.00 0 7902 29 0 0
sp_multiply_rows_for_qdistr 19793 19793 0 0.00 0 38527 164 0 0
sp_pay_from_customer 6766 6766 0 0.00 4 36363 142 0 0
sp_pay_to_supplier 5498 5498 0 0.00 5 14681 133 0 0
sp_payment_common 12264 12264 0 0.00 1 36303 37 0 0
sp_qd_handle_on_cancel_clo 1716 1716 0 0.00 0 13050 345 0 0
sp_qd_handle_on_invoice_upd_sts 10531 10531 0 0.00 0 31303 347 0 0
sp_qd_handle_on_reserve_upd_sts 9589 9589 0 0.00 0 12645 69 0 0
sp_reserve_write_off 9589 9589 0 0.00 6 12757 192 0 0
sp_supplier_invoice 5378 5378 0 0.00 7 115220 3635 0 0
sp_supplier_order 5142 5142 0 0.00 5 36445 1374 0 0
srv_aggregate_perf_data 92 92 0 0.00 2336 397280 24383 0 0
srv_fill_mon_cache_memory 62 62 0 0.00 2580 108808 46198 0 0
srv_find_qd_qs_mism 1043778 1043778 0 0.00 0 19426 6 0 0
srv_make_invnt_saldo 557 557 0 0.00 26 31044 1128 0 0
srv_make_money_saldo 790 790 0 0.00 1 14849 46 0 0
srv_recalc_idx_stat 4 4 0 0.00 142970 579826 289909 0 0
t$perf-abend:sp_add_invoice_to_stock 103 103 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 13 13 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4944 4944 0 0.00 0 20447 180 0 0
t$perf-norm:sp_cancel_adding_invoice 400 400 0 0.00 0 6302 125 0 0
t$perf-norm:sp_cancel_client_order 1716 1716 0 0.00 0 3922 19 0 0
t$perf-norm:sp_cancel_customer_reserve 707 707 0 0.00 0 3439 13 0 0
t$perf-norm:sp_cancel_pay_from_customer 645 645 0 0.00 0 1090 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 392 392 0 0.00 0 1171 6 0 0
t$perf-norm:sp_cancel_supplier_invoice 383 383 0 0.00 0 7674 42 0 0
t$perf-norm:sp_cancel_supplier_order 407 407 0 0.00 0 18871 1680 0 0
t$perf-norm:sp_cancel_write_off 1039 1039 0 0.00 0 6503 23 0 0
t$perf-norm:sp_client_order 19793 19793 0 0.00 0 16121 19 0 0
t$perf-norm:sp_customer_reserve 970 970 0 0.00 0 1549 7 0 0
t$perf-norm:sp_pay_from_customer 6766 6766 0 0.00 0 9610 9 0 0
t$perf-norm:sp_pay_to_supplier 5498 5498 0 0.00 0 7516 15 0 0
t$perf-norm:sp_reserve_write_off 9589 9589 0 0.00 0 8290 15 0 0
t$perf-norm:sp_supplier_invoice 5378 5378 0 0.00 0 7415 23 0 0
t$perf-norm:sp_supplier_order 5142 5142 0 0.00 0 4531 17 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 799 18 0 0
t$perf-norm:srv_fill_mon_cache_memory 62 62 0 0.00 0 316 7 0 0
t$perf-norm:srv_make_invnt_saldo 557 557 0 0.00 0 2787 26 0 0
t$perf-norm:srv_make_money_saldo 790 790 0 0.00 0 1026 15 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 11 6 0 0
v_add_invoice_to_stock 10088 9882 206 2.04 0 5551 19 0 206
v_all_customers 36008 36008 0 0.00 0 15 1 0 0
v_all_suppliers 29060 29060 0 0.00 0 22 1 0 0
v_all_wares 39586 39586 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 800 800 0 0.00 0 1382 9 0 0
v_cancel_client_order 3432 3432 0 0.00 0 3233 7 0 0
v_cancel_customer_prepayment 1290 1290 0 0.00 0 718 5 0 0
v_cancel_customer_reserve 1414 1414 0 0.00 0 1640 6 0 0
v_cancel_payment_to_supplier 784 784 0 0.00 0 2298 9 0 0
v_cancel_supplier_invoice 792 766 26 3.28 0 3225 20 0 26
v_cancel_supplier_order 814 814 0 0.00 0 2499 11 0 0
v_cancel_write_off 2078 2078 0 0.00 0 9623 19 0 0
v_max_id_clo_ord 5134 5134 0 0.00 0 3473 2 0 0
v_max_id_clo_res 970 970 0 0.00 0 902 6 0 0
v_max_id_ord_sup 5360 5360 0 0.00 0 5791 4 0 0
v_max_non_paid_invoice 1462 1462 0 0.00 0 49 2 0 0
v_max_non_paid_realizn 3643 3643 0 0.00 0 3595 4 0 0
v_min_id_clo_ord 5134 5134 0 0.00 0 4778 7 0 0
v_min_id_clo_res 970 970 0 0.00 0 4747 12 0 0
v_min_id_ord_sup 5360 5360 0 0.00 0 4753 9 0 0
v_min_non_paid_invoice 5498 5498 0 0.00 0 10330 19 0 0
v_min_non_paid_realizn 6766 6766 0 0.00 0 6594 26 0 0
v_our_firm 9824 9824 0 0.00 0 21 1 0 0
v_reserve_write_off 19178 19178 0 0.00 0 4433 7 0 0
x_lock_depdocs_on_canc_invoice 11382 11382 0 0.00 0 25260 121 0 0
x_lock_depdocs_on_canc_sup_ord 407 407 0 0.00 0 3411 326 0 0
x_make_qstorno_1000_1200 5142 5142 0 0.00 1 36406 1291 0 0
x_make_qstorno_1200_2000 5378 5378 0 0.00 3 115155 3486 0 0
x_make_qstorno_2100_3300 455570 455570 0 0.00 0 49166 183 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 28-08-2021 22:40:10 to 28-08-2021 22:40:14.

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
20:07:53 11 8192000000 8805059664 8817315840 9090000 0.110 3 1 2 0 9210704 58144 62560
20:08:54 30300 8192000000 10369550144 10688032768 1409296608 14.678 100 83 166 0 1442797424 6380064 27120752
20:10:31 26798 8192000000 10438965680 10769694720 1492968240 15.415 100 88 176 1 1529699344 8731632 27999472
20:12:08 23011 8192000000 10495020080 10843029504 1551494832 15.923 100 81 162 0 1587127648 10359040 25273776
20:13:38 15005 8192000000 10581345280 10936643584 1633760320 16.627 100 84 168 0 1670796960 11829424 25207216
20:14:57 9217 8192000000 10659268064 11029958656 1715749008 17.317 100 82 162 0 1752569472 12644480 24175984
20:16:08 4489 8192000000 10714379120 11088445440 1772201984 17.785 100 88 175 2 1810921504 13042624 25676896
20:17:15 1346 8192000000 10753181120 11133394944 1812850112 18.119 100 91 181 0 1852182528 14454992 24877424
20:18:19 1919 8192000000 10799852240 11185790976 1855959280 18.471 100 91 183 2 1893752240 11762944 26030016
20:19:22 23889 8192000000 10807742128 11211202560 1870634352 18.589 100 56 108 1 1892233952 6771248 14828352
20:20:46 6085 8192000000 10800878800 11223740416 1882471200 18.685 100 32 64 1 1899350928 7726848 9152880
20:21:54 12356 8192000000 10794553952 11230793728 1889090464 18.738 100 17 34 1 1900054528 6313088 4650976
20:23:07 5579 8192000000 10811777840 11238625280 1898421808 18.814 100 24 47 0 1911111584 5671760 7018016
20:24:17 52347 8192000000 10860889584 11268108288 1914129808 18.940 100 62 126 0 1938203936 5476144 18597984
20:26:10 4661 8192000000 10825284688 11248046080 1891860400 18.761 99 30 59 5 1906898640 6477776 8560464
20:27:16 6622 8192000000 10814060016 11248046080 1886471328 18.717 99 36 72 2 1903001024 5952544 10577152
20:28:26 38437 8192000000 10778072992 11205906432 1765813856 17.732 93 18 36 1 1779919584 9347568 4758160
20:30:07 4669 8192000000 10734311744 11154214912 1818527872 18.166 100 15 30 0 1829081360 6057872 4495616
20:31:16 8873 8192000000 10694145648 11113082880 1771645392 17.781 99 25 50 1 1784571120 5687216 7238512
20:32:27 58879 8192000000 10712038944 11132125184 1755966864 17.651 97 19 38 0 1766689136 5444080 5278192
20:34:27 6179 8192000000 10750794016 11174338560 1839839152 18.339 100 32 64 0 1856249360 6848192 9562016
20:35:37 10383 8192000000 10772843056 11198009344 1854904736 18.462 100 28 55 2 1868825792 6258480 7662576
20:36:52 13025 8192000000 10787935696 11208921088 1870867872 18.591 100 42 84 2 1890081696 6040256 13173568
20:38:06 15741 8192000000 10835573264 11251425280 1908244208 18.893 100 47 92 2 1927147952 5344512 13559232
20:39:33 30819 8192000000 10865136864 11287048192 1928452352 19.055 100 55 108 3 1955448608 11813616 15182640
20:41:06 9772 8192000000 10897832464 11320451072 1952183408 19.244 100 56 112 2 1985330976 17004912 16142656
20:42:24 15264 8192000000 10909641648 11335970816 1964940352 19.345 100 46 90 2 1998437168 19962624 13534192
20:43:44 5166 8192000000 10928143136 11351560192 1976824608 19.440 100 56 107 2 2012973488 20677568 15471312
20:44:56 6812 8192000000 10938952016 11366764544 1984733520 19.502 100 62 124 3 2026315584 23305360 18276704
20:46:07 2579 8192000000 10960876608 11379326976 1997397488 19.602 100 72 140 0 2044732160 27014976 20319696
20:47:12 6754 8192000000 10951754864 11385004032 1998751808 19.613 100 54 106 1 2044884208 29967840 16164560
20:48:27 8032 8192000000 10978077536 11395309568 2000671776 19.628 100 67 134 0 2057803504 36139520 20992208
20:49:38 4345 8192000000 10969803072 11393728512 1998856144 19.614 100 65 130 2 2057236080 38590048 19789888
20:50:48 3688 8192000000 11001215696 11416928256 2013142880 19.726 100 82 160 1 2082939392 45214368 24582144
20:51:57 4951 8192000000 10998690416 11424882688 2019588832 19.777 100 76 150 1 2089740624 46644864 23506928
20:53:06 5685 8192000000 10926362368 11347238912 1939447264 19.142 98 71 142 0 2010117264 47659008 23010992
20:54:20 3296 8192000000 10960850736 11375411200 1956157168 19.275 98 89 178 0 2027645680 43570848 27917664
20:55:30 4208 8192000000 10954070336 11374854144 1971044288 19.394 99 66 132 1 2033804640 41712848 21047504
20:56:40 12763 8192000000 10934787632 11383193600 1958130960 19.291 99 39 78 0 2012640688 40748256 13761472
20:58:06 6392 8192000000 10941200368 11383472128 1972345184 19.404 100 47 94 2 2029676000 42253776 15077040
20:59:36 15468 8192000000 10910006576 11346833408 1915446960 18.950 98 38 77 2 1975113744 46825696 12841088
21:00:54 20429 8192000000 10874323920 11328851968 1904463248 18.862 99 26 51 0 1955916688 42351568 9101872
21:02:16 13127 8192000000 10899362896 11345207296 1934337392 19.102 100 36 72 0 1994328656 46663408 13327856
21:04:00 50859 8192000000 10889533440 11351371776 1931048016 19.075 99 15 30 0 1965028992 29289328 4691648
21:05:53 57964 8192000000 10892202800 11346726912 1918009232 18.971 98 37 72 2 1949401680 19936880 11455568
21:08:33 10342 8192000000 10902510992 11358658560 1964850656 19.345 100 50 97 4 1995385312 15757648 14777008
21:09:44 21033 8192000000 10919617424 11375919104 1983415792 19.492 100 53 107 2 2013789328 15135840 15237696
21:11:06 87736 8192000000 10863346848 11333849088 1908720368 18.896 98 11 22 1 1925530240 13881184 2928688
21:13:38 63702 8192000000 10874658688 11332272128 1922065744 19.003 98 18 35 0 1937172320 10215760 4890816
21:17:21 66558 8192000000 10928991472 11394392064 1981281840 19.475 100 19 38 0 2016471728 28799360 6390528
21:19:29 108807 8192000000 10904986608 11404144640 1945728864 19.192 98 17 36 0 1975088320 24469648 4889808
21:22:20 90638 8192000000 10896939008 11375902720 1953759552 19.256 99 14 27 0 1971159760 14034944 3365264
21:25:19 52794 8192000000 10887043216 11374616576 1971998288 19.401 100 13 26 1 1991698624 16164768 3535568
21:27:35 68458 8192000000 10887951648 11365404672 1941389984 19.158 98 29 58 0 1959536160 9975440 8170736
21:29:52 49792 8192000000 10883667024 11358486528 1920545968 18.991 97 9 18 0 1932549840 9509392 2494480
21:31:43 80902 8192000000 10905195696 11383644160 1979734592 19.463 100 13 26 1 1999111520 15480160 3896768
21:35:00 49042 8192000000 10927770128 11390021632 1986135552 19.513 100 21 42 2 2000013504 8151056 5726896
21:36:56 98403 8192000000 10904193024 11367223296 1914565216 18.943 96 16 32 0 1927798000 8991408 4241376
21:39:37 30167 8192000000 10907642256 11373776896 1970052768 19.386 99 20 40 0 1987664400 12805248 4806384
21:41:11 69823 8192000000 10913357376 11404054528 1963677088 19.335 99 17 34 0 1985062224 16629104 4756032
21:44:19 66520 8192000000 10908827504 11382247424 1923225888 19.013 97 12 24 1 1938201184 11341120 3634176
21:46:26 68215 8192000000 10893944608 11351859200 1912861264 18.930 97 22 44 2 1931064912 11770160 6433488
21:48:41 105116 8192000000 10893597792 11355512832 1917266128 18.965 97 44 88 1 1940718704 10649904 12802672
21:51:36 36580 8192000000 10870721104 11344314368 1911151408 18.916 97 14 28 0 1927267664 11949760 4166496
21:53:32 75610 8192000000 10847267904 11334168576 1892836384 18.769 97 13 26 2 1917123904 20896896 3390624
21:55:55 46514 8192000000 10872113696 11360444416 1956248608 19.276 100 13 26 0 1975949632 15827008 3874016
21:57:43 70598 8192000000 10879768592 11372552192 1957477696 19.286 100 10 19 2 1971706576 11064896 3163984
22:00:32 57476 8192000000 10872799920 11333144576 1896252496 18.796 97 17 34 2 1909106048 7382864 5470688
22:02:30 101413 8192000000 10871041296 11334909952 1836546880 18.313 94 14 28 1 1853773872 12885440 4341552
22:05:13 75535 8192000000 10885812592 11342381056 1882620256 18.686 96 25 49 4 1901166144 11354672 7191216
22:07:31 48794 8192000000 10902720256 11359432704 1926696704 19.040 98 22 44 1 1941621616 9175872 5749040
22:09:27 75112 8192000000 10890643696 11347836928 1893532016 18.774 96 26 52 2 1911135408 10305872 7297520
22:11:43 69315 8192000000 10873815408 11344629760 1923639824 19.016 98 33 66 1 1940892288 7694688 9557776
22:13:53 55499 8192000000 10898877536 11373465600 1977153536 19.442 100 31 62 4 1994819456 8921680 8744240
22:16:16 73042 8192000000 10889679136 11373211648 1954794624 19.265 99 14 28 0 1975435120 16253760 4386736
22:18:36 68038 8192000000 10886917488 11362279424 1947204160 19.204 98 18 36 2 1960259456 8290416 4764880
22:20:44 78456 8192000000 10909604928 11369820160 1879331888 18.660 95 16 32 0 1892565248 9023792 4209568
22:23:04 52356 8192000000 10900700528 11383463936 1930749360 19.073 97 28 57 1 1955426896 15875216 8802320
22:24:58 44698 8192000000 10881705920 11351822336 1862405680 18.523 94 24 48 2 1888334976 19144752 6784544
22:26:47 80287 8192000000 10871667024 11344883712 1907397808 18.886 97 16 32 0 1930175136 17766928 5010400
22:29:09 29255 8192000000 10913525168 11373076480 1968579328 19.374 100 33 66 0 1996075536 18751008 8745200
22:30:39 46372 8192000000 10924616480 11374542848 1975068144 19.426 100 44 88 3 1999256704 11923376 12265184
22:32:54 84270 8192000000 10897040016 11359854592 1945363056 19.190 99 37 75 2 1970594336 14663744 10567536
22:35:25 71397 8192000000 10894337968 11377061888 1978171216 19.450 100 8 16 0 1991163552 10093632 2898704
22:37:39 31411 8192000000 10071898752 10471952384 1187670352 12.662 60 4 8 0 1200121232 11882672 568208

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 28-08-2021 22:40:16 to 28-08-2021 22:40:30.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 28-08-2021 22:40:31 to 28-08-2021 22:40:33.

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          233698
MON$OLDEST_ACTIVE               234342
MON$OLDEST_SNAPSHOT             234342
MON$NEXT_TRANSACTION            234342
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                       2016640
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


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

28.08.21 22:40:34. There are 3 logs in /var/tmp/logs-oltp30 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2021-08-28 22:40:37 No severe PSQL-related problems occured
28.08.21 22:40:38. End of report.