Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 12.11.2021 10: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 16735108 kB
MemAvailable 31683156 kB
Buffers 0 kB
Cached 14996960 kB
SwapCached 0 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.1
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 2021-11-12 10:37:53
DTS_END                         2021-11-12 10:37:06.7120
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SRV_FILL_MON_CACHE_MEMORY(20:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/36770
TRN_ID                          228498
ATT_ID                          259
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: 9016.10 23518 1081932
customer order: creation 162.73 372 19528
customer order: refuse 13.56 385 1627
order to supplier: creation 43.94 1423 5273
order to supplier: removal 3.38 120542 405
invoice (draft): creation 44.18 3701 5302
invoice (draft): removal 52.21 977 6265
invoice accept: apply 40.41 19497 4849
invoice accept: cancel 47.59 963 5711
customer reserve: creation 3665.05 195 439806
customer reserve: removal 4663.84 67 559661
realization accept: apply 79.15 213 9498
realization accept: cancel 77.84 123 9341
payment from customer: creation 56.42 127 6770
payment from customer: removal 5.49 108 659
payment to supplier: creation 46.33 137 5559
payment to supplier: removal 3.58 68 429
service: total inventory turnovers 3.70 4070 444
service: total monetary turnovers 5.71 661 685
service: aggregate perf. data 0.97 14012 116
service: refresh index statistics 0.03 302727 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 12-11-2021 10:39:22 to 12-11-2021 10:39:24.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4170
TEST_TIME 2 3955
TEST_TIME 3 4657
TEST_TIME 4 4122
TEST_TIME 5 4401
TEST_TIME 6 4463
TEST_TIME 7 4904
TEST_TIME 8 4798
TEST_TIME 9 4857
TEST_TIME 10 5145
TEST_TIME 11 5538
TEST_TIME 12 5855
TEST_TIME 13 6219
TEST_TIME 14 6732
TEST_TIME 15 7110
TEST_TIME 16 7190
TEST_TIME 17 7296
TEST_TIME 18 7390
TEST_TIME 19 7606
TEST_TIME 20 7847
TEST_TIME 21 8374
TEST_TIME 22 8583
TEST_TIME 23 8706
TEST_TIME 24 9002
TEST_TIME 25 9113
TEST_TIME 26 8988
TEST_TIME 27 8937
TEST_TIME 28 9478
TEST_TIME 29 9504
TEST_TIME 30 10323
TEST_TIME 31 10882
TEST_TIME 32 10758
TEST_TIME 33 11006
TEST_TIME 34 10841
TEST_TIME 35 10588
TEST_TIME 36 10344
TEST_TIME 37 10201
TEST_TIME 38 10129
TEST_TIME 39 10133
TEST_TIME 40 10138
TEST_TIME 41 10068
TEST_TIME 42 9977
TEST_TIME 43 9818
TEST_TIME 44 9759
TEST_TIME 45 9715
TEST_TIME 46 9674
TEST_TIME 47 9710
TEST_TIME 48 9622
TEST_TIME 49 9572
TEST_TIME 50 9455
TEST_TIME 51 9305
TEST_TIME 52 9343
TEST_TIME 53 9478
TEST_TIME 54 9417
TEST_TIME 55 9348
TEST_TIME 56 9285
TEST_TIME 57 9279
TEST_TIME 58 9288
TEST_TIME 59 9286
TEST_TIME 60 9388
TEST_TIME 61 9371
TEST_TIME 62 9477
TEST_TIME 63 9445
TEST_TIME 64 9533
TEST_TIME 65 9517
TEST_TIME 66 9502
TEST_TIME 67 9484
TEST_TIME 68 9747
TEST_TIME 69 9703
TEST_TIME 70 9716
TEST_TIME 71 9627
TEST_TIME 72 9528
TEST_TIME 73 9448
TEST_TIME 74 9538
TEST_TIME 75 9493
TEST_TIME 76 9499
TEST_TIME 77 9448
TEST_TIME 78 9406
TEST_TIME 79 9391
TEST_TIME 80 9357
TEST_TIME 81 9322
TEST_TIME 82 9357
TEST_TIME 83 9334
TEST_TIME 84 9347
TEST_TIME 85 9331
TEST_TIME 86 9336
TEST_TIME 87 9366
TEST_TIME 88 9338
TEST_TIME 89 9336
TEST_TIME 90 9352
TEST_TIME 91 9436
TEST_TIME 92 9438
TEST_TIME 93 9446
TEST_TIME 94 9453
TEST_TIME 95 9386
TEST_TIME 96 9349
TEST_TIME 97 9301
TEST_TIME 98 9269
TEST_TIME 99 9284
TEST_TIME 100 9223
TEST_TIME 101 9209
TEST_TIME 102 9235
TEST_TIME 103 9271
TEST_TIME 104 9236
TEST_TIME 105 9256
TEST_TIME 106 9255
TEST_TIME 107 9254
TEST_TIME 108 9258
TEST_TIME 109 9302
TEST_TIME 110 9290
TEST_TIME 111 9344
TEST_TIME 112 9278
TEST_TIME 113 9207
TEST_TIME 114 9177
TEST_TIME 115 9179
TEST_TIME 116 9154
TEST_TIME 117 9107
TEST_TIME 118 9124
TEST_TIME 119 9092
TEST_TIME 120 9023

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 12-11-2021 10:39:26 to 12-11-2021 10:39:29.

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 1489633 1489633 0 0.00 0 18861 7 0 0
doc_list_biud 1489633 1489633 0 0.00 0 43730 32 0 0
sp_add_invoice_to_stock 5006 4849 157 3.13 32 245154 19497 0 157
sp_cancel_adding_invoice 5711 5711 0 0.00 6 50180 963 0 0
sp_cancel_client_order 1627 1627 0 0.00 4 8781 385 0 0
sp_cancel_customer_reserve 559661 559661 0 0.00 1 32954 67 0 0
sp_cancel_pay_from_customer 659 659 0 0.00 3 7141 109 0 0
sp_cancel_pay_to_supplier 429 429 0 0.00 3 1508 68 0 0
sp_cancel_supplier_invoice 6285 6265 20 0.31 2 27998 978 0 20
sp_cancel_supplier_order 405 405 0 0.00 12 1193259 120542 0 0
sp_cancel_write_off 9341 9341 0 0.00 1 17363 123 0 0
sp_client_order 19528 19528 0 0.00 4 27442 372 0 0
sp_customer_reserve 439806 439806 0 0.00 0 44313 195 0 0
sp_fill_shopping_cart 30086 30086 0 0.00 1 25340 56 0 0
sp_fill_shopping_cart_clo_res 439797 439797 0 0.00 0 16420 16 0 0
sp_get_clo_for_invoice 4837 4837 0 0.00 0 49695 372 0 0
sp_kill_cost_storno 16140 16140 0 0.00 0 17348 71 0 0
sp_kill_qstorno_ret_qs2qd 1135333 1135333 0 0.00 0 28681 37 0 0
sp_kill_qty_storno 597345 597345 0 0.00 0 43729 80 0 0
sp_lock_selected_doc 19877 19877 0 0.00 0 8199 5 0 0
sp_make_cost_storno 26664 26664 0 0.00 0 18846 67 0 0
sp_multiply_rows_for_pdistr 26664 26664 0 0.00 0 9248 37 0 0
sp_multiply_rows_for_qdistr 19528 19528 0 0.00 0 19341 187 0 0
sp_pay_from_customer 6770 6770 0 0.00 4 12582 128 0 0
sp_pay_to_supplier 5559 5559 0 0.00 5 12792 138 0 0
sp_payment_common 12329 12329 0 0.00 1 11523 30 0 0
sp_qd_handle_on_cancel_clo 1627 1627 0 0.00 0 8755 355 0 0
sp_qd_handle_on_invoice_upd_sts 10548 10548 0 0.00 0 43729 426 0 0
sp_qd_handle_on_reserve_upd_sts 9498 9498 0 0.00 0 17460 67 0 0
sp_reserve_write_off 9498 9498 0 0.00 5 17497 214 0 0
sp_supplier_invoice 5302 5302 0 0.00 9 87346 3702 0 0
sp_supplier_order 5273 5273 0 0.00 6 54124 1423 0 0
srv_aggregate_perf_data 116 116 0 0.00 2593 142622 14012 0 0
srv_fill_mon_cache_memory 66 66 0 0.00 1251 170664 43513 0 0
srv_find_qd_qs_mism 1036791 1036791 0 0.00 0 14074 5 0 0
srv_make_invnt_saldo 444 444 0 0.00 70 97784 4070 0 0
srv_make_money_saldo 685 685 0 0.00 1 21639 662 0 0
srv_recalc_idx_stat 4 4 0 0.00 183358 429737 302728 0 0
t$perf-abend:sp_add_invoice_to_stock 157 157 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 20 20 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4849 4849 0 0.00 0 7788 172 0 0
t$perf-norm:sp_cancel_adding_invoice 396 396 0 0.00 0 4163 83 0 0
t$perf-norm:sp_cancel_client_order 1627 1627 0 0.00 0 5761 22 0 0
t$perf-norm:sp_cancel_customer_reserve 688 688 0 0.00 0 2421 15 0 0
t$perf-norm:sp_cancel_pay_from_customer 659 659 0 0.00 0 556 3 0 0
t$perf-norm:sp_cancel_pay_to_supplier 429 429 0 0.00 0 1867 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 364 364 0 0.00 0 2237 23 0 0
t$perf-norm:sp_cancel_supplier_order 405 405 0 0.00 0 26359 1724 0 0
t$perf-norm:sp_cancel_write_off 975 975 0 0.00 0 591 5 0 0
t$perf-norm:sp_client_order 19528 19528 0 0.00 0 8640 22 0 0
t$perf-norm:sp_customer_reserve 961 961 0 0.00 0 2493 7 0 0
t$perf-norm:sp_pay_from_customer 6770 6770 0 0.00 0 6539 10 0 0
t$perf-norm:sp_pay_to_supplier 5559 5559 0 0.00 0 9183 15 0 0
t$perf-norm:sp_reserve_write_off 9498 9498 0 0.00 0 9879 12 0 0
t$perf-norm:sp_supplier_invoice 5302 5302 0 0.00 0 5021 17 0 0
t$perf-norm:sp_supplier_order 5273 5273 0 0.00 0 12725 19 0 0
t$perf-norm:srv_aggregate_perf_data 116 116 0 0.00 0 162 8 0 0
t$perf-norm:srv_fill_mon_cache_memory 66 66 0 0.00 0 391 12 0 0
t$perf-norm:srv_make_invnt_saldo 444 444 0 0.00 0 587 9 0 0
t$perf-norm:srv_make_money_saldo 685 685 0 0.00 0 1824 12 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 3 4 3 0 0
v_add_invoice_to_stock 9986 9672 314 3.14 0 3138 18 0 314
v_all_customers 35508 35508 0 0.00 0 36 1 0 0
v_all_suppliers 29374 29374 0 0.00 0 25 1 0 0
v_all_wares 39056 39056 0 0.00 0 19 1 0 0
v_cancel_adding_invoice 792 792 0 0.00 0 2809 9 0 0
v_cancel_client_order 3254 3254 0 0.00 0 1262 4 0 0
v_cancel_customer_prepayment 1318 1318 0 0.00 0 890 4 0 0
v_cancel_customer_reserve 1376 1376 0 0.00 0 117 3 0 0
v_cancel_payment_to_supplier 858 858 0 0.00 0 657 5 0 0
v_cancel_supplier_invoice 768 728 40 5.20 0 333 15 0 40
v_cancel_supplier_order 810 810 0 0.00 0 6888 13 0 0
v_cancel_write_off 1950 1950 0 0.00 0 1599 15 0 0
v_max_id_clo_ord 5272 5272 0 0.00 0 555 2 0 0
v_max_id_clo_res 961 961 0 0.00 0 2023 14 0 0
v_max_id_ord_sup 5286 5286 0 0.00 0 8077 7 0 0
v_max_non_paid_invoice 1430 1430 0 0.00 0 8482 10 0 0
v_max_non_paid_realizn 3572 3572 0 0.00 0 4946 6 0 0
v_min_id_clo_ord 5272 5272 0 0.00 0 14382 19 0 0
v_min_id_clo_res 961 961 0 0.00 0 5922 13 0 0
v_min_id_ord_sup 5286 5286 0 0.00 0 9178 21 0 0
v_min_non_paid_invoice 5559 5559 0 0.00 0 7902 16 0 0
v_min_non_paid_realizn 6770 6770 0 0.00 0 10503 21 0 0
v_our_firm 9944 9944 0 0.00 0 53 1 0 0
v_reserve_write_off 18996 18996 0 0.00 0 4257 6 0 0
x_lock_depdocs_on_canc_invoice 11612 11612 0 0.00 0 16398 127 0 0
x_lock_depdocs_on_canc_sup_ord 405 405 0 0.00 0 2942 334 0 0
x_make_qstorno_1000_1200 5273 5273 0 0.00 2 52486 1320 0 0
x_make_qstorno_1200_2000 5302 5302 0 0.00 3 80194 3485 0 0
x_make_qstorno_2100_3300 439805 439805 0 0.00 0 37493 176 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 12-11-2021 10:39:30 to 12-11-2021 10:39:34.

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
08:07:10 2 8192000000 8796669024 8807174144 3189120 0.038 1 1 2 0 3286736 61840 35776
08:08:12 34344 8192000000 9737733936 10039463936 813639760 9.034 100 89 176 1 842989856 7939488 21410608
08:09:55 34021 8192000000 9779454400 10091565056 854898672 9.449 100 87 174 1 888730672 13706112 20125888
08:11:32 14839 8192000000 9820120640 10140372992 878779296 9.688 100 85 170 1 926504512 28443552 19281664
08:12:55 11643 8192000000 9877684032 10210066432 915504432 10.052 100 79 156 1 987449216 54769376 17175408
08:14:10 12825 8192000000 9913720880 10257981440 950231904 10.393 100 86 172 1 1027139120 58449216 18458000
08:15:25 6948 8192000000 9947533648 10302365696 985120480 10.734 100 74 148 0 1063573760 62686864 15766416
08:16:34 2731 8192000000 9998238176 10358255616 1020734896 11.079 100 85 170 0 1107162336 69192912 17234528
08:17:39 1846 8192000000 10025370176 10391666688 1046724592 11.329 100 91 182 0 1134661392 69125088 18811712
08:18:43 1884 8192000000 10038143728 10409717760 1061221824 11.468 100 89 178 1 1145126272 65135040 18769408
08:19:45 21006 8192000000 9989649408 10381377536 1071351008 11.565 100 59 117 2 1117746496 32780784 13614704
08:21:08 12032 8192000000 9974485872 10379231232 1071399312 11.565 100 18 36 0 1102989680 28006768 3583600
08:22:21 7460 8192000000 9996805120 10404311040 1077883088 11.627 100 30 62 2 1113598704 28761024 6954592
08:23:30 5454 8192000000 9985077424 10384875520 1083868560 11.684 100 38 74 0 1100695568 9273296 7553712
08:24:36 8960 8192000000 9991057168 10409504768 1086919024 11.713 100 26 52 1 1115599552 23447408 5233120
08:25:47 37103 8192000000 10014326832 10409324544 1093659648 11.777 100 64 125 3 1117124304 8874064 14590592
08:27:25 9882 8192000000 10001399424 10403147776 1065248096 11.507 98 31 62 0 1098161088 25654656 7258336
08:28:36 4535 8192000000 9997291712 10379235328 1063888800 11.494 99 54 110 2 1085366064 8282192 13195072
08:29:41 7364 8192000000 9951670128 10337722368 1014083792 11.015 97 43 87 0 1042744432 18635040 10025600
08:30:49 13561 8192000000 9939174352 10310893568 998566048 10.865 97 71 140 2 1023180768 10153584 14461136
08:32:03 1933 8192000000 9967553856 10342105088 1015858752 11.032 99 42 86 0 1062984944 37326592 9799600
08:33:05 4034 8192000000 9955492576 10333229056 1030781808 11.176 100 41 82 0 1059015712 18836000 9397904
08:34:10 61002 8192000000 9962562944 10365407232 1044110064 11.304 100 26 50 2 1072696160 23421744 5164352
08:36:11 6638 8192000000 9968102304 10360754176 1059214816 11.449 100 48 95 0 1083144240 13469440 10459984
08:37:27 65016 8192000000 10030032704 10417115136 1087255184 11.717 100 45 90 0 1121312208 24772896 9284128
08:39:36 23954 8192000000 10061380176 10456125440 1100415392 11.842 100 36 73 2 1167302528 59506736 7380400
08:41:02 76492 8192000000 10065819552 10470457344 1113144480 11.962 100 27 52 1 1171754272 53202016 5407776
08:43:31 18950 8192000000 10128726560 10533806080 1132305904 12.143 100 52 104 0 1230182016 86184944 11691168
08:44:56 3948 8192000000 10128838048 10550194176 1143159968 12.245 100 50 100 0 1237918528 83719328 11039232
08:46:04 2944 8192000000 10198196992 10602938368 1157655424 12.381 100 68 136 2 1305266512 133300240 14310848
08:47:12 2779 8192000000 10223827184 10627325952 1150834288 12.317 99 71 139 0 1325836784 158836112 16166384
08:48:22 7075 8192000000 10276813536 10675994624 1156862288 12.374 100 72 144 0 1380001536 207012144 16127104
08:49:37 1249 8192000000 10291061536 10690285568 1174215456 12.536 100 88 175 0 1394808608 200619536 19973616
08:50:44 5138 8192000000 10324765008 10746916864 1179836928 12.589 100 82 161 2 1430804752 232955824 18012000
08:51:52 1546 8192000000 10293764544 10699849728 1163741904 12.438 100 85 170 0 1391929696 208349952 19837840
08:53:00 3552 8192000000 10289952816 10698072064 1174263040 12.537 100 69 137 0 1386707632 197030912 15413680
08:54:09 3652 8192000000 10331494000 10734628864 1162376560 12.426 100 73 145 1 1427417200 248270912 16769728
08:55:22 4162 8192000000 10382507392 10787377152 1168280544 12.481 100 89 176 2 1471762816 283150288 20331984
08:56:32 4710 8192000000 10367876128 10775769088 1165610400 12.456 100 86 170 0 1465920528 279334688 20975440
08:57:42 8230 8192000000 10410437360 10837372928 1152402960 12.332 100 58 116 1 1515118432 348188560 14526912
08:58:57 3289 8192000000 10362588864 10780495872 1169536496 12.492 100 52 99 1 1459385520 277978128 11870896
09:00:08 7201 8192000000 10342981168 10753708032 1133177184 12.151 98 57 115 1 1426780048 279717568 13885296
09:01:21 5100 8192000000 10354983696 10766446592 1136087616 12.179 99 51 101 0 1447946480 299880592 11978272
09:02:33 9810 8192000000 10331034224 10742059008 1123874080 12.064 99 55 111 0 1424143520 285922192 14347248
09:03:52 10191 8192000000 10370110192 10794401792 1142669696 12.241 100 34 68 2 1471488336 319819920 8998720
09:05:15 33561 8192000000 10366046752 10912276480 1122101536 12.047 99 22 44 1 1510101488 381876496 6123456
09:06:50 29473 8192000000 10243424448 10754387968 1109737040 11.930 99 15 30 1 1386702560 272793712 4171808
09:08:21 50491 8192000000 10083152768 10508992512 1131611904 12.137 100 15 28 2 1175887872 40802080 3473888
09:10:12 83716 8192000000 10057363616 10519609344 1090670176 11.749 96 12 24 0 1162870944 69049520 3151248
09:12:37 170663 8192000000 10068478784 10536509440 1070326192 11.555 95 37 74 0 1150277504 71436816 8514496
09:16:32 19090 8192000000 10089116688 10515656704 1117311280 12.002 100 61 124 1 1199795616 69432080 13052256
09:17:55 26305 8192000000 10085297952 10542915584 1127869200 12.101 100 28 57 0 1187901856 54262336 5770320
09:19:39 23369 8192000000 10121072592 10568781824 1145263344 12.265 100 17 34 0 1229640752 80705872 3671536
09:21:13 46374 8192000000 10128293776 10592378880 1129290464 12.115 99 10 21 0 1223394896 91874496 2229936
09:23:06 64655 8192000000 10111994176 10578399232 1129376960 12.115 99 12 24 0 1229853600 97693344 2783296
09:25:27 39043 8192000000 10088736144 10561843200 1143194768 12.246 100 18 36 0 1193942736 47207520 3540448
09:27:14 65669 8192000000 10165620896 10626408448 1154319520 12.350 100 19 38 0 1241218672 82172784 4726368
09:29:21 78902 8192000000 10091582576 10623991808 1141901840 12.233 99 17 34 0 1262832416 116643952 4286624
09:31:40 58042 8192000000 10061252912 10524921856 1113541936 11.966 97 18 36 1 1160779264 43420384 3816944
09:33:40 39020 8192000000 10101842384 10555187200 1134294224 12.162 99 19 38 0 1173409984 35581008 3534752
09:35:22 74936 8192000000 10130378944 10607128576 1154004896 12.347 100 21 42 0 1232351184 73762160 4584128
09:37:39 64149 8192000000 10122748080 10592624640 1160154928 12.405 100 15 30 1 1245782736 82503632 3124176
09:39:45 28162 8192000000 10079922416 10516361216 1124605504 12.070 97 31 62 0 1160881216 30672176 5603536
09:41:16 43081 8192000000 10098832992 10595893248 1152572000 12.334 100 25 50 1 1207934336 50070720 5291616
09:43:05 89084 8192000000 10179245536 10627547136 1134350368 12.162 98 18 36 0 1224911760 86943424 3617968
09:45:44 78612 8192000000 10073774160 10523344896 1090082464 11.743 95 16 32 0 1156134848 63248464 2803920
09:48:09 87193 8192000000 10124232928 10555101184 1132661328 12.146 100 37 74 0 1187738080 47810304 7266448
09:50:47 35019 8192000000 10116706512 10573414400 1119946128 12.026 99 23 46 1 1239778608 114893488 4938992
09:52:23 32523 8192000000 10064627040 10504859648 1094347088 11.784 96 15 30 0 1157978064 60607136 3023840
09:53:55 86376 8192000000 10053065408 10494410752 1082467568 11.671 96 16 32 1 1123325664 37624896 3233200
09:56:22 46635 8192000000 10032516304 10510753792 1083118704 11.677 98 6 13 0 1137568448 53088096 1361648
09:58:09 61363 8192000000 10081166032 10540593152 1109080432 11.924 99 19 37 1 1169257376 55823056 4353888
10:00:12 32472 8192000000 10060253120 10516520960 1116615344 11.995 99 28 54 0 1149879120 27828128 5435648
10:01:58 63540 8192000000 10092506560 10546446336 1093149488 11.773 96 22 44 0 1160202288 62488288 4564512
10:04:06 33929 8192000000 10058232272 10492268544 1101290960 11.850 97 22 43 2 1140031744 34281296 4459488
10:05:40 57905 8192000000 10077591328 10519826432 1073848032 11.589 95 36 72 0 1141199072 59970576 7380464
10:07:40 43019 8192000000 10117113936 10571448320 1123823696 12.063 99 22 44 0 1220060352 91489760 4746896
10:09:24 47422 8192000000 10078419312 10509692928 1097890368 11.818 97 24 48 0 1143163248 40555648 4717232
10:11:13 26259 8192000000 10077127504 10516037632 1099057904 11.829 97 34 68 1 1153729824 48228640 6443280
10:12:42 82264 8192000000 10057093584 10517467136 1131483696 12.135 100 23 46 0 1170692000 34818624 4389680
10:15:39 63625 8192000000 10076374272 10560131072 1115297104 11.983 98 19 37 2 1168566720 49128416 4141200
10:17:56 30581 8192000000 10124283568 10570342400 1122074272 12.047 98 48 95 1 1212068080 79798000 10195808
10:19:33 85854 8192000000 10069875920 10527133696 1127513808 12.098 99 16 32 0 1177843312 46640656 3688848
10:22:11 103477 8192000000 10109385408 10595835904 1149455008 12.304 100 11 22 0 1237739808 85978512 2306288
10:25:09 19375 8192000000 10132151264 10563280896 1155562400 12.362 100 39 78 0 1217814512 54452752 7799360
10:26:32 61406 8192000000 10109319136 10558095360 1124515072 12.070 98 25 50 1 1166684784 37233648 4936064
10:28:39 134169 8192000000 10057799024 10506833920 1127240496 12.095 99 14 28 0 1162208096 32067600 2900000
10:31:55 47005 8192000000 10066790160 10554081280 1107372688 11.908 98 14 28 1 1178780000 68122928 3284384
10:33:59 47348 8192000000 10062845328 10526580736 1114386048 11.974 99 13 26 0 1171064976 53876064 2802864
10:35:47 67622 8192000000 10074634688 10549399552 1100010192 11.838 97 15 30 1 1144070288 40969456 3090640

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 12-11-2021 10:39:36 to 12-11-2021 10:39:51.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 157 v_add_invoice_to_stock 335544517
except 20 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 12-11-2021 10:39:52 to 12-11-2021 10:39: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          242810
MON$OLDEST_ACTIVE               242811
MON$OLDEST_SNAPSHOT             242811
MON$NEXT_TRANSACTION            242811
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                       2055008
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             785
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


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

12.11.21 10:39:55. 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
2021-11-12 10:39:57 No severe PSQL-related problems occured
12.11.21 10:39:58. End of report.