Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 15.10.2020 07:38
Common Performance Final Results
  1. Hardware and OS info
  2. DB and 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, full
  3. Ratio "Versions / Records" for tables
  4. Database Validation Results
  5. New in firebird.log while test was run
  6. 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 e0e7b46250ba4f9795ceb55e0face73f
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 2020-09-25 13:42
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.00
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 16796236 kB
MemAvailable 31552896 kB
Buffers 0 kB
Cached 14830196 kB
SwapCached 5432 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.0
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 2020-10-15 07:37:23
DTS_END                         2020-10-15 07:37:23.2940
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(67:17)
IP                              ::1/32774
TRN_ID                          234643
ATT_ID                          623
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: 8776.37 19515 1053164
customer order: creation 169.91 411 20389
customer order: refuse 14.45 363 1734
order to supplier: creation 44.95 1394 5394
order to supplier: removal 3.59 92674 431
invoice (draft): creation 45.40 3366 5448
invoice (draft): removal 49.02 823 5882
invoice accept: apply 41.53 16521 4984
invoice accept: cancel 44.17 846 5300
customer reserve: creation 3729.71 165 447565
customer reserve: removal 4347.81 61 521737
realization accept: apply 81.95 188 9834
realization accept: cancel 79.72 113 9566
payment from customer: creation 57.75 120 6930
payment from customer: removal 5.18 119 622
payment to supplier: creation 47.45 146 5694
payment to supplier: removal 3.27 93 392
service: total inventory turnovers 3.90 3301 468
service: total monetary turnovers 5.83 504 699
service: aggregate perf. data 0.76 16889 91
service: refresh index statistics 0.03 252206 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 15-10-2020 07:38:34 to 15-10-2020 07:38:36.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4814
TEST_TIME 2 4107
TEST_TIME 3 3550
TEST_TIME 4 3941
TEST_TIME 5 4239
TEST_TIME 6 4649
TEST_TIME 7 4773
TEST_TIME 8 5142
TEST_TIME 9 5293
TEST_TIME 10 6364
TEST_TIME 11 7082
TEST_TIME 12 7302
TEST_TIME 13 7551
TEST_TIME 14 7672
TEST_TIME 15 7574
TEST_TIME 16 7772
TEST_TIME 17 8155
TEST_TIME 18 8308
TEST_TIME 19 8775
TEST_TIME 20 8986
TEST_TIME 21 9077
TEST_TIME 22 9243
TEST_TIME 23 9184
TEST_TIME 24 9566
TEST_TIME 25 9996
TEST_TIME 26 9805
TEST_TIME 27 9608
TEST_TIME 28 9788
TEST_TIME 29 10166
TEST_TIME 30 10217
TEST_TIME 31 10104
TEST_TIME 32 10087
TEST_TIME 33 10104
TEST_TIME 34 10055
TEST_TIME 35 10021
TEST_TIME 36 9999
TEST_TIME 37 9897
TEST_TIME 38 9916
TEST_TIME 39 9958
TEST_TIME 40 9990
TEST_TIME 41 9984
TEST_TIME 42 9966
TEST_TIME 43 9999
TEST_TIME 44 9990
TEST_TIME 45 10146
TEST_TIME 46 9929
TEST_TIME 47 9818
TEST_TIME 48 9670
TEST_TIME 49 9654
TEST_TIME 50 9687
TEST_TIME 51 9648
TEST_TIME 52 9629
TEST_TIME 53 9555
TEST_TIME 54 9538
TEST_TIME 55 9443
TEST_TIME 56 9448
TEST_TIME 57 9383
TEST_TIME 58 9356
TEST_TIME 59 9387
TEST_TIME 60 9384
TEST_TIME 61 9351
TEST_TIME 62 9409
TEST_TIME 63 9383
TEST_TIME 64 9502
TEST_TIME 65 9579
TEST_TIME 66 9549
TEST_TIME 67 9517
TEST_TIME 68 9547
TEST_TIME 69 9602
TEST_TIME 70 9677
TEST_TIME 71 9736
TEST_TIME 72 9736
TEST_TIME 73 9624
TEST_TIME 74 9499
TEST_TIME 75 9454
TEST_TIME 76 9423
TEST_TIME 77 9374
TEST_TIME 78 9295
TEST_TIME 79 9277
TEST_TIME 80 9218
TEST_TIME 81 9185
TEST_TIME 82 9158
TEST_TIME 83 9230
TEST_TIME 84 9215
TEST_TIME 85 9240
TEST_TIME 86 9205
TEST_TIME 87 9224
TEST_TIME 88 9239
TEST_TIME 89 9247
TEST_TIME 90 9325
TEST_TIME 91 9331
TEST_TIME 92 9277
TEST_TIME 93 9182
TEST_TIME 94 9126
TEST_TIME 95 9088
TEST_TIME 96 9086
TEST_TIME 97 9024
TEST_TIME 98 9043
TEST_TIME 99 9025
TEST_TIME 100 9009
TEST_TIME 101 8992
TEST_TIME 102 9005
TEST_TIME 103 8978
TEST_TIME 104 8988
TEST_TIME 105 8970
TEST_TIME 106 8999
TEST_TIME 107 9035
TEST_TIME 108 9037
TEST_TIME 109 9086
TEST_TIME 110 9014
TEST_TIME 111 8956
TEST_TIME 112 8903
TEST_TIME 113 8902
TEST_TIME 114 8873
TEST_TIME 115 8835
TEST_TIME 116 8845
TEST_TIME 117 8887
TEST_TIME 118 8860
TEST_TIME 119 8842
TEST_TIME 120 8782

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 15-10-2020 07:38:37 to 15-10-2020 07:38:41.

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 1469495 1469495 0 0.00 0 30013 6 0 0
doc_list_biud 1469494 1469494 0 0.00 0 40930 28 0 0
sp_add_invoice_to_stock 5062 4984 78 1.54 25 219503 16522 0 78
sp_cancel_adding_invoice 5300 5300 0 0.00 5 71940 847 0 0
sp_cancel_client_order 1734 1734 0 0.00 4 12286 363 0 0
sp_cancel_customer_reserve 521737 521737 0 0.00 1 26519 61 0 0
sp_cancel_pay_from_customer 622 622 0 0.00 3 29140 120 0 0
sp_cancel_pay_to_supplier 392 392 0 0.00 3 9683 93 0 0
sp_cancel_supplier_invoice 5889 5882 7 0.11 1 27401 823 0 7
sp_cancel_supplier_order 431 431 0 0.00 10 787452 92674 0 0
sp_cancel_write_off 9566 9566 0 0.00 1 11260 114 0 0
sp_client_order 20389 20389 0 0.00 4 22220 411 0 0
sp_customer_reserve 447565 447565 0 0.00 0 90265 165 0 0
sp_fill_shopping_cart 31231 31231 0 0.00 1 16268 42 0 0
sp_fill_shopping_cart_clo_res 447559 447559 0 0.00 0 17446 16 0 0
sp_get_clo_for_invoice 4975 4975 0 0.00 0 30756 398 0 0
sp_kill_cost_storno 15880 15880 0 0.00 0 29129 59 0 0
sp_kill_qstorno_ret_qs2qd 1059353 1059353 0 0.00 0 27398 33 0 0
sp_kill_qty_storno 559459 559459 0 0.00 0 40930 72 0 0
sp_lock_selected_doc 20419 20419 0 0.00 0 11089 4 0 0
sp_make_cost_storno 27433 27433 0 0.00 0 29733 65 0 0
sp_multiply_rows_for_pdistr 27433 27433 0 0.00 0 29162 34 0 0
sp_multiply_rows_for_qdistr 20389 20389 0 0.00 0 20905 209 0 0
sp_pay_from_customer 6930 6930 0 0.00 4 29413 121 0 0
sp_pay_to_supplier 5694 5694 0 0.00 5 26123 147 0 0
sp_payment_common 12624 12624 0 0.00 1 26564 29 0 0
sp_qd_handle_on_cancel_clo 1734 1734 0 0.00 0 12277 337 0 0
sp_qd_handle_on_invoice_upd_sts 10275 10275 0 0.00 0 40930 373 0 0
sp_qd_handle_on_reserve_upd_sts 9834 9834 0 0.00 0 13332 62 0 0
sp_reserve_write_off 9834 9834 0 0.00 7 26063 189 0 0
sp_supplier_invoice 5448 5448 0 0.00 8 85018 3367 0 0
sp_supplier_order 5394 5394 0 0.00 5 31501 1394 0 0
srv_aggregate_perf_data 91 91 0 0.00 3063 175335 16890 0 0
srv_fill_mon_cache_memory 63 63 0 0.00 1852 155118 42617 0 0
srv_find_qd_qs_mism 1007659 1007659 0 0.00 0 21316 5 0 0
srv_make_invnt_saldo 468 468 0 0.00 50 81874 3302 0 0
srv_make_money_saldo 699 699 0 0.00 1 12088 504 0 0
srv_recalc_idx_stat 4 4 0 0.00 215772 333947 252207 0 0
t$perf-abend:sp_add_invoice_to_stock 78 78 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 7 7 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4984 4984 0 0.00 0 16664 160 0 0
t$perf-norm:sp_cancel_adding_invoice 414 414 0 0.00 0 8776 117 0 0
t$perf-norm:sp_cancel_client_order 1734 1734 0 0.00 0 4882 22 0 0
t$perf-norm:sp_cancel_customer_reserve 663 663 0 0.00 0 1322 12 0 0
t$perf-norm:sp_cancel_pay_from_customer 622 622 0 0.00 0 2103 6 0 0
t$perf-norm:sp_cancel_pay_to_supplier 392 392 0 0.00 0 2613 9 0 0
t$perf-norm:sp_cancel_supplier_invoice 364 364 0 0.00 0 1812 23 0 0
t$perf-norm:sp_cancel_supplier_order 431 431 0 0.00 0 25329 1339 0 0
t$perf-norm:sp_cancel_write_off 990 990 0 0.00 0 1040 6 0 0
t$perf-norm:sp_client_order 20389 20389 0 0.00 0 8297 19 0 0
t$perf-norm:sp_customer_reserve 980 980 0 0.00 0 1806 5 0 0
t$perf-norm:sp_pay_from_customer 6930 6930 0 0.00 0 5937 9 0 0
t$perf-norm:sp_pay_to_supplier 5694 5694 0 0.00 0 17234 12 0 0
t$perf-norm:sp_reserve_write_off 9834 9834 0 0.00 0 9773 9 0 0
t$perf-norm:sp_supplier_invoice 5448 5448 0 0.00 0 4762 18 0 0
t$perf-norm:sp_supplier_order 5394 5394 0 0.00 0 6315 15 0 0
t$perf-norm:srv_aggregate_perf_data 91 91 0 0.00 0 644 18 0 0
t$perf-norm:srv_fill_mon_cache_memory 63 63 0 0.00 0 16 1 0 0
t$perf-norm:srv_make_invnt_saldo 468 468 0 0.00 0 2936 18 0 0
t$perf-norm:srv_make_money_saldo 699 699 0 0.00 0 465 6 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 88 24 0 0
v_add_invoice_to_stock 10106 9950 156 1.54 0 10862 17 0 156
v_all_customers 37198 37198 0 0.00 0 265 1 0 0
v_all_suppliers 29678 29678 0 0.00 0 17 1 0 0
v_all_wares 40778 40778 0 0.00 0 27 1 0 0
v_cancel_adding_invoice 828 828 0 0.00 0 6518 18 0 0
v_cancel_client_order 3468 3468 0 0.00 0 3065 5 0 0
v_cancel_customer_prepayment 1244 1244 0 0.00 0 5261 10 0 0
v_cancel_customer_reserve 1326 1326 0 0.00 0 430 3 0 0
v_cancel_payment_to_supplier 784 784 0 0.00 0 721 5 0 0
v_cancel_supplier_invoice 742 728 14 1.88 0 3756 17 0 14
v_cancel_supplier_order 862 862 0 0.00 0 925 4 0 0
v_cancel_write_off 1980 1980 0 0.00 0 634 12 0 0
v_max_id_clo_ord 5394 5394 0 0.00 0 1299 1 0 0
v_max_id_clo_res 980 980 0 0.00 0 1311 12 0 0
v_max_id_ord_sup 5448 5448 0 0.00 0 7533 5 0 0
v_max_non_paid_invoice 1697 1697 0 0.00 0 2260 3 0 0
v_max_non_paid_realizn 3684 3684 0 0.00 0 296 2 0 0
v_min_id_clo_ord 5394 5394 0 0.00 0 14064 8 0 0
v_min_id_clo_res 980 980 0 0.00 0 6203 16 0 0
v_min_id_ord_sup 5448 5448 0 0.00 0 3716 5 0 0
v_min_non_paid_invoice 5694 5694 0 0.00 0 25864 25 0 0
v_min_non_paid_realizn 6930 6930 0 0.00 0 26559 19 0 0
v_our_firm 10072 10072 0 0.00 0 11 1 0 0
v_reserve_write_off 19668 19668 0 0.00 0 5261 5 0 0
x_lock_depdocs_on_canc_invoice 10818 10818 0 0.00 0 14093 109 0 0
x_lock_depdocs_on_canc_sup_ord 431 431 0 0.00 0 23389 321 0 0
x_make_qstorno_1000_1200 5394 5394 0 0.00 2 28694 1317 0 0
x_make_qstorno_1200_2000 5448 5448 0 0.00 3 85007 3207 0 0
x_make_qstorno_2100_3300 447564 447564 0 0.00 0 90264 147 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 15-10-2020 07:38:42 to 15-10-2020 07:38:46.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
05:07:27 2 8192000000 8796624000 8807108608 3156752 0.038 1 1 2 0 3254112 61504 35856
05:08:27 32830 8192000000 9726997920 10025631744 804789216 8.945 100 91 183 1 834730800 7960480 21981104
05:10:07 23250 8192000000 9774398208 10084524032 845555984 9.356 100 87 173 1 879399120 13280576 20562560
05:11:36 14919 8192000000 9818723440 10139762688 877395712 9.674 100 86 172 2 925298928 28312288 19590928
05:12:57 12030 8192000000 9876787600 10214580224 918217424 10.078 100 79 159 1 982635024 46859312 17558288
05:14:14 7819 8192000000 9921432560 10269126656 972230848 10.608 100 81 161 2 1037169168 48619136 16319184
05:15:24 5667 8192000000 9988109856 10344828928 1001422672 10.892 100 87 174 2 1103139248 83703776 18012800
05:16:32 3028 8192000000 10001790288 10369515520 1025254528 11.123 100 71 142 1 1118802528 79518912 14029088
05:17:36 2020 8192000000 10006030144 10376036352 1053477472 11.394 100 83 165 2 1117118896 47265264 16376160
05:18:39 13556 8192000000 10021873776 10405298176 1067052288 11.524 100 63 125 0 1136776864 57151728 12572848
05:19:54 5433 8192000000 9987286944 10390265856 1071925504 11.570 100 56 113 2 1118403376 32987216 13490656
05:21:05 5355 8192000000 10018087088 10402811904 1080577712 11.653 100 42 84 0 1118433776 29501520 8354544
05:22:11 51487 8192000000 9990196336 10391846912 1083820928 11.684 100 40 77 2 1103182928 10903776 8458224
05:24:06 4655 8192000000 10020375856 10414501888 1091608576 11.758 100 47 94 1 1134122144 30679296 11834272
05:25:13 9194 8192000000 10002059648 10409910272 1089951408 11.742 100 29 57 2 1116652272 20918656 5782208
05:26:24 7117 8192000000 10003623568 10404601856 1080521008 11.652 99 36 72 2 1106928432 18318848 8088576
05:27:32 60465 8192000000 9988051664 10400968704 1028151824 11.151 95 30 60 4 1064801440 30471760 6177856
05:29:32 9483 8192000000 9954311984 10346467328 1020580496 11.078 97 36 73 3 1044262832 15414720 8267616
05:30:48 8129 8192000000 9909437744 10282405888 982988096 10.713 96 27 53 2 1016582144 27790720 5803328
05:32:00 8193 8192000000 9933639200 10321137664 1025091120 11.121 100 24 48 2 1050136144 19716928 5328096
05:33:08 30256 8192000000 9972207872 10356756480 1032023536 11.188 100 50 100 1 1077316448 35253472 10039440
05:34:40 13602 8192000000 9968786816 10359525376 1038886976 11.254 99 47 94 1 1074538384 24313168 11338240
05:35:56 8757 8192000000 9980994736 10374184960 1066881744 11.522 100 48 96 3 1091829184 13422608 11524832
05:37:06 10332 8192000000 9986656992 10386542592 1081263728 11.660 100 26 52 2 1100626752 14155984 5207040
05:38:24 40961 8192000000 10028426176 10432675840 1099407088 11.832 100 33 64 1 1143536880 37297376 6832416
05:40:29 50762 8192000000 10092097840 10498351104 1116994432 11.999 100 38 76 1 1183926672 58765904 8166336
05:42:29 4550 8192000000 10140638016 10539294720 1131303296 12.134 100 51 102 1 1251500528 108563696 11633536
05:43:41 11869 8192000000 10177702624 10573660160 1139515824 12.211 100 64 127 1 1271181248 117724560 13940864
05:45:00 1851 8192000000 10204092656 10610061312 1146999248 12.281 100 61 120 1 1310753040 150560944 13192848
05:46:05 5087 8192000000 10206404080 10608926720 1147921984 12.290 100 64 127 0 1313827424 152195776 13709664
05:47:15 7422 8192000000 10235503888 10660073472 1154811904 12.355 100 53 106 0 1338826608 171765520 12249184
05:48:27 4682 8192000000 10200096896 10614226944 1154653008 12.353 100 61 122 0 1311752656 143485104 13614544
05:49:36 2349 8192000000 10228871120 10631884800 1167513312 12.474 100 69 138 0 1322389216 140460320 14415584
05:50:46 4409 8192000000 10211876144 10612445184 1155241536 12.359 100 76 153 2 1316353088 144411264 16700288
05:51:57 3711 8192000000 10213927888 10609770496 1160695120 12.410 100 72 141 0 1318307792 142494384 15118288
05:53:06 3065 8192000000 10277653520 10679762944 1165319520 12.453 100 78 156 0 1379836128 196604112 17912496
05:54:18 4773 8192000000 10286746288 10702942208 1156555984 12.371 100 86 170 0 1392290176 215953072 19781120
05:55:27 4744 8192000000 10268301920 10675437568 1127084208 12.094 100 61 122 0 1372790768 230688128 15018432
05:56:39 5934 8192000000 10195723216 10607071232 1096189392 11.801 99 47 94 1 1285018592 178047072 10782128
05:57:48 11032 8192000000 10194567680 10606518272 1087057760 11.715 98 35 70 1 1278926416 183495776 8372880
05:59:05 1969 8192000000 10241833120 10641530880 1116182528 11.991 100 77 151 2 1332231104 198322752 17725824
06:00:10 17680 8192000000 10266395488 10684973056 1124623232 12.071 100 37 72 0 1364215360 230446608 9145520
06:01:31 18688 8192000000 10257520752 10702360576 1123128768 12.057 100 27 54 1 1368331728 237654416 7548544
06:02:57 25113 8192000000 10244282416 10663079936 1125187696 12.076 99 24 48 1 1344551600 213589392 5774512
06:04:27 24666 8192000000 10235154160 10676502528 1130242848 12.124 100 22 44 2 1335580816 200041232 5296736
06:05:53 22476 8192000000 10172743712 10716368896 1116916704 11.998 100 13 26 0 1312369312 191836944 3615664
06:07:38 46299 8192000000 10073226544 10505822208 1121454096 12.041 100 27 54 1 1152734768 25843088 5437584
06:09:25 46190 8192000000 10084003696 10515636224 1103269616 11.869 98 22 45 1 1178322912 70527984 4525312
06:11:41 54973 8192000000 10049723776 10489339904 1089933888 11.742 97 11 22 0 1114698720 22746048 2018784
06:13:42 23733 8192000000 10042642480 10458292224 1104944128 11.885 99 45 89 4 1135802448 21232896 9625424
06:15:10 44347 8192000000 10097573280 10562166784 1122071696 12.047 100 10 20 2 1178412464 53933344 2407424
06:16:59 100197 8192000000 10082096688 10520657920 1123964416 12.064 99 10 20 1 1161596288 35687696 1944176
06:19:49 83328 8192000000 10104010496 10572861440 1135463968 12.173 99 12 24 1 1180131728 42358608 2309152
06:22:20 102113 8192000000 10069756576 10524704768 1135070432 12.169 99 7 15 1 1181520624 44830192 1620000
06:25:34 32634 8192000000 10119129216 10558844928 1162538768 12.427 100 36 72 1 1222727664 52695392 7493504
06:27:10 40943 8192000000 10120011712 10611081216 1167285936 12.471 100 18 36 0 1241929344 70656720 3986688
06:29:28 29588 8192000000 10115009904 10557579264 1153723936 12.344 100 37 74 1 1205675296 43920208 8031152
06:30:59 102865 8192000000 10138304864 10596954112 1165385744 12.454 100 16 32 0 1232774880 63860624 3528512
06:33:48 3473 8192000000 10129888112 10583969792 1144758992 12.260 99 20 41 0 1223913152 74239968 4914192
06:36:20 51718 8192000000 10070631088 10540920832 1130585632 12.127 98 12 24 1 1165559184 32659264 2314288
06:38:17 88279 8192000000 10087051856 10537504768 1119897376 12.026 98 11 22 0 1160587840 38486416 2204048
06:40:46 71199 8192000000 10070732272 10545172480 1074171392 11.592 94 15 29 1 1139046192 61765920 3108880
06:42:59 67060 8192000000 10061454592 10503917568 1054999408 11.409 95 24 48 0 1100252672 40363776 4889488
06:45:48 62134 8192000000 10178336320 10609922048 1094970608 11.790 98 29 58 0 1200401440 99380032 6050800
06:47:55 155118 8192000000 10053492512 10545168384 1064927312 11.504 95 13 26 0 1140283888 72486368 2870208
06:52:58 30141 8192000000 10031478032 10521268224 1089770816 11.740 98 8 15 0 1125537648 33913776 1853056
06:55:19 63242 8192000000 10030575488 10491076608 1075234960 11.602 97 11 22 0 1132151760 54227792 2689008
06:57:25 38463 8192000000 10064593360 10497355776 1102798064 11.864 99 29 58 3 1164532432 55736576 5997792
06:59:04 64447 8192000000 10061603152 10547818496 1097228976 11.811 99 21 41 1 1187726416 85583104 4914336
07:01:10 49523 8192000000 10061089136 10493550592 1098417648 11.823 99 36 71 1 1150658000 45026720 7213632
07:03:04 55117 8192000000 10096063488 10541928448 1101168688 11.849 99 35 70 2 1164586256 55953616 7463952
07:05:03 50952 8192000000 10087255552 10550935552 1103652240 11.872 99 23 46 0 1156743728 47964880 5126608
07:07:01 58354 8192000000 10056738352 10511794176 1106324512 11.898 98 12 24 1 1170422448 61879536 2218400
07:09:03 74014 8192000000 10064474624 10495557632 1123546912 12.060 100 13 25 3 1150050640 23778400 2725328
07:12:15 61124 8192000000 10046826816 10532093952 1125284160 12.077 99 14 28 0 1171788128 43453184 3050784
07:14:16 53034 8192000000 10099900064 10578358272 1117669152 12.005 98 9 18 0 1176756320 56823088 2264080
07:16:10 51735 8192000000 10057641024 10516680704 1124708048 12.071 99 13 26 0 1148031184 20143408 3179728
07:18:07 41942 8192000000 10072860704 10511536128 1146330384 12.275 100 15 28 1 1177266768 27294272 3642112
07:19:56 31815 8192000000 10091234768 10525712384 1146921648 12.281 100 19 38 0 1177996784 27189008 3886128
07:21:28 59687 8192000000 10133710688 10583306240 1149398880 12.304 100 26 50 0 1225468320 70716192 5353248
07:23:57 95799 8192000000 10089058560 10577096704 1104867008 11.884 97 7 14 0 1150983616 44794080 1322528
07:26:33 75811 8192000000 10049599808 10526879744 1124189104 12.067 99 12 24 1 1158806256 32021312 2595840
07:29:00 67012 8192000000 10081798112 10551382016 1130009136 12.121 99 8 16 0 1179692496 47848272 1835088
07:31:14 60376 8192000000 10055508512 10512252928 1087227664 11.716 96 4 8 0 1129711472 41924960 558848
07:33:18 60055 8192000000 10134935232 10617126912 1142344704 12.238 100 13 26 0 1192657728 47521424 2791600
07:35:35 38588 8192000000 10069843856 10503520256 1073456416 11.585 94 24 48 2 1116782336 38247824 5078096
07:37:14 19598 8192000000 8941556896 9150513152 94192896 1.136 9 4 6 1 115490672 20452608 845168

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 15-10-2020 07:38:48 to 15-10-2020 07:39:02.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
user_exc 78 v_add_invoice_to_stock 335544517
user_exc 7 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 15-10-2020 07:39:03 to 15-10-2020 07:39:05.

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          234936
MON$OLDEST_ACTIVE               234937
MON$OLDEST_SNAPSHOT             234937
MON$NEXT_TRANSACTION            234937
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                       2115136
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                        {8C105897-B735-40F5-7D8B-A1F76E952B78}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             784
MON$NEXT_STATEMENT              53


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

15.10.20 07:39:06. 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
2020-10-15 07:39:09 No severe PSQL-related problems occured
15.10.20 07:39:10. End of report.