Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 05.04.2021 04:27
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 df9f488d08424df294c459d6c283e9c3
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-03-04 16:07
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.26
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 16542312 kB
MemAvailable 31356112 kB
Buffers 20 kB
Cached 14998260 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.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 2021-04-05 04:27:11
DTS_END                         2021-04-05 04:26:58.0760
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/37280
TRN_ID                          231516
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: 9191.88 26257 1103025
customer order: creation 160.70 405 19284
customer order: refuse 13.53 310 1624
order to supplier: creation 44.12 1339 5294
order to supplier: removal 3.34 121166 401
invoice (draft): creation 43.28 3425 5193
invoice (draft): removal 54.82 875 6578
invoice accept: apply 39.41 16525 4729
invoice accept: cancel 49.82 860 5978
customer reserve: creation 3650.74 160 438089
customer reserve: removal 4850.49 67 582059
realization accept: apply 77.28 187 9273
realization accept: cancel 83.56 111 10027
payment from customer: creation 55.18 123 6621
payment from customer: removal 5.11 90 613
payment to supplier: creation 46.84 136 5621
payment to supplier: removal 3.21 95 385
service: total inventory turnovers 3.51 3243 421
service: total monetary turnovers 5.93 477 712
service: aggregate perf. data 0.99 13155 119
service: refresh index statistics 0.03 362386 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 05-04-2021 04:27:37 to 05-04-2021 04:27:39.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 1180
TEST_TIME 2 2030
TEST_TIME 3 2158
TEST_TIME 4 2300
TEST_TIME 5 2862
TEST_TIME 6 3302
TEST_TIME 7 3520
TEST_TIME 8 4084
TEST_TIME 9 4663
TEST_TIME 10 4870
TEST_TIME 11 5029
TEST_TIME 12 5118
TEST_TIME 13 6020
TEST_TIME 14 6487
TEST_TIME 15 6874
TEST_TIME 16 7377
TEST_TIME 17 7729
TEST_TIME 18 7907
TEST_TIME 19 7999
TEST_TIME 20 8261
TEST_TIME 21 8742
TEST_TIME 22 8836
TEST_TIME 23 8684
TEST_TIME 24 9187
TEST_TIME 25 9478
TEST_TIME 26 9538
TEST_TIME 27 9839
TEST_TIME 28 10020
TEST_TIME 29 11429
TEST_TIME 30 11460
TEST_TIME 31 11509
TEST_TIME 32 11434
TEST_TIME 33 11298
TEST_TIME 34 11142
TEST_TIME 35 10843
TEST_TIME 36 10706
TEST_TIME 37 10630
TEST_TIME 38 10662
TEST_TIME 39 10513
TEST_TIME 40 10563
TEST_TIME 41 10549
TEST_TIME 42 10430
TEST_TIME 43 10277
TEST_TIME 44 10179
TEST_TIME 45 10199
TEST_TIME 46 10184
TEST_TIME 47 10189
TEST_TIME 48 10068
TEST_TIME 49 10142
TEST_TIME 50 10023
TEST_TIME 51 9917
TEST_TIME 52 9868
TEST_TIME 53 9821
TEST_TIME 54 9846
TEST_TIME 55 9731
TEST_TIME 56 9725
TEST_TIME 57 9724
TEST_TIME 58 9784
TEST_TIME 59 9782
TEST_TIME 60 9762
TEST_TIME 61 9813
TEST_TIME 62 9898
TEST_TIME 63 9956
TEST_TIME 64 9965
TEST_TIME 65 9940
TEST_TIME 66 9854
TEST_TIME 67 9769
TEST_TIME 68 9694
TEST_TIME 69 9606
TEST_TIME 70 9526
TEST_TIME 71 9481
TEST_TIME 72 9452
TEST_TIME 73 9415
TEST_TIME 74 9376
TEST_TIME 75 9371
TEST_TIME 76 9367
TEST_TIME 77 9385
TEST_TIME 78 9444
TEST_TIME 79 9381
TEST_TIME 80 9333
TEST_TIME 81 9465
TEST_TIME 82 9569
TEST_TIME 83 9536
TEST_TIME 84 9441
TEST_TIME 85 9359
TEST_TIME 86 9313
TEST_TIME 87 9261
TEST_TIME 88 9216
TEST_TIME 89 9157
TEST_TIME 90 9121
TEST_TIME 91 9094
TEST_TIME 92 9086
TEST_TIME 93 9108
TEST_TIME 94 9224
TEST_TIME 95 9224
TEST_TIME 96 9226
TEST_TIME 97 9166
TEST_TIME 98 9254
TEST_TIME 99 9277
TEST_TIME 100 9295
TEST_TIME 101 9276
TEST_TIME 102 9336
TEST_TIME 103 9386
TEST_TIME 104 9332
TEST_TIME 105 9250
TEST_TIME 106 9211
TEST_TIME 107 9164
TEST_TIME 108 9113
TEST_TIME 109 9070
TEST_TIME 110 9097
TEST_TIME 111 9089
TEST_TIME 112 9085
TEST_TIME 113 9065
TEST_TIME 114 9087
TEST_TIME 115 9108
TEST_TIME 116 9107
TEST_TIME 117 9121
TEST_TIME 118 9131
TEST_TIME 119 9150
TEST_TIME 120 9195

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 05-04-2021 04:27:40 to 05-04-2021 04:27:43.

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 1508933 1508933 0 0.00 0 13454 6 0 0
doc_list_biud 1508933 1508933 0 0.00 0 59044 32 0 0
sp_add_invoice_to_stock 4799 4729 70 1.45 37 164706 16526 0 70
sp_cancel_adding_invoice 5978 5978 0 0.00 5 88479 861 0 0
sp_cancel_client_order 1624 1624 0 0.00 5 16907 310 0 0
sp_cancel_customer_reserve 582059 582059 0 0.00 1 59046 68 0 0
sp_cancel_pay_from_customer 613 613 0 0.00 3 13453 91 0 0
sp_cancel_pay_to_supplier 385 385 0 0.00 3 7680 95 0 0
sp_cancel_supplier_invoice 6583 6578 5 0.07 2 54016 876 0 5
sp_cancel_supplier_order 401 401 0 0.00 8 1176484 121167 0 0
sp_cancel_write_off 10027 10027 0 0.00 1 12280 112 0 0
sp_client_order 19284 19284 0 0.00 4 19100 406 0 0
sp_customer_reserve 438089 438089 0 0.00 0 95058 161 0 0
sp_fill_shopping_cart 29763 29763 0 0.00 1 9893 42 0 0
sp_fill_shopping_cart_clo_res 438087 438087 0 0.00 0 20377 17 0 0
sp_get_clo_for_invoice 4725 4725 0 0.00 0 40368 416 0 0
sp_kill_cost_storno 17003 17003 0 0.00 0 11220 52 0 0
sp_kill_qstorno_ret_qs2qd 1181124 1181124 0 0.00 0 59039 36 0 0
sp_kill_qty_storno 620665 620665 0 0.00 0 59044 78 0 0
sp_lock_selected_doc 19443 19443 0 0.00 0 9203 6 0 0
sp_make_cost_storno 26240 26240 0 0.00 0 10476 64 0 0
sp_multiply_rows_for_pdistr 26240 26240 0 0.00 0 5750 31 0 0
sp_multiply_rows_for_qdistr 19284 19284 0 0.00 0 19093 239 0 0
sp_pay_from_customer 6621 6621 0 0.00 4 15289 123 0 0
sp_pay_to_supplier 5621 5621 0 0.00 5 12359 136 0 0
sp_payment_common 12242 12242 0 0.00 1 9429 25 0 0
sp_qd_handle_on_cancel_clo 1624 1624 0 0.00 0 16899 282 0 0
sp_qd_handle_on_invoice_upd_sts 10703 10703 0 0.00 0 30129 379 0 0
sp_qd_handle_on_reserve_upd_sts 9273 9273 0 0.00 0 12328 54 0 0
sp_reserve_write_off 9273 9273 0 0.00 7 14071 187 0 0
sp_supplier_invoice 5193 5193 0 0.00 8 89324 3425 0 0
sp_supplier_order 5294 5294 0 0.00 5 35243 1339 0 0
srv_aggregate_perf_data 119 119 0 0.00 2453 93978 13156 0 0
srv_fill_mon_cache_memory 64 64 0 0.00 1401 120830 44440 0 0
srv_find_qd_qs_mism 1058184 1058184 0 0.00 0 13453 5 0 0
srv_make_invnt_saldo 421 421 0 0.00 43 106325 3243 0 0
srv_make_money_saldo 712 712 0 0.00 1 10550 478 0 0
srv_recalc_idx_stat 4 4 0 0.00 261495 503158 362386 0 0
t$perf-abend:sp_add_invoice_to_stock 70 70 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 5 5 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4729 4729 0 0.00 0 7809 142 0 0
t$perf-norm:sp_cancel_adding_invoice 405 405 0 0.00 0 4962 106 0 0
t$perf-norm:sp_cancel_client_order 1624 1624 0 0.00 0 2510 11 0 0
t$perf-norm:sp_cancel_customer_reserve 634 634 0 0.00 0 2213 14 0 0
t$perf-norm:sp_cancel_pay_from_customer 613 613 0 0.00 0 2257 11 0 0
t$perf-norm:sp_cancel_pay_to_supplier 385 385 0 0.00 0 609 5 0 0
t$perf-norm:sp_cancel_supplier_invoice 391 391 0 0.00 0 1602 22 0 0
t$perf-norm:sp_cancel_supplier_order 401 401 0 0.00 0 15321 1372 0 0
t$perf-norm:sp_cancel_write_off 992 992 0 0.00 0 5870 14 0 0
t$perf-norm:sp_client_order 19284 19284 0 0.00 0 9637 21 0 0
t$perf-norm:sp_customer_reserve 959 959 0 0.00 0 2390 8 0 0
t$perf-norm:sp_pay_from_customer 6621 6621 0 0.00 0 3440 7 0 0
t$perf-norm:sp_pay_to_supplier 5621 5621 0 0.00 0 7019 10 0 0
t$perf-norm:sp_reserve_write_off 9273 9273 0 0.00 0 6077 8 0 0
t$perf-norm:sp_supplier_invoice 5193 5193 0 0.00 0 7691 19 0 0
t$perf-norm:sp_supplier_order 5294 5294 0 0.00 0 8578 19 0 0
t$perf-norm:srv_aggregate_perf_data 119 119 0 0.00 0 165 3 0 0
t$perf-norm:srv_fill_mon_cache_memory 64 64 0 0.00 0 84 3 0 0
t$perf-norm:srv_make_invnt_saldo 421 421 0 0.00 0 6313 20 0 0
t$perf-norm:srv_make_money_saldo 712 712 0 0.00 0 1226 7 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 2 31 11 0 0
v_add_invoice_to_stock 9590 9450 140 1.45 0 5694 15 0 140
v_all_customers 35272 35272 0 0.00 0 23 1 0 0
v_all_suppliers 29528 29528 0 0.00 0 27 1 0 0
v_all_wares 38568 38568 0 0.00 0 18 1 0 0
v_cancel_adding_invoice 810 810 0 0.00 0 4009 14 0 0
v_cancel_client_order 3248 3248 0 0.00 0 1248 4 0 0
v_cancel_customer_prepayment 1226 1226 0 0.00 0 2223 6 0 0
v_cancel_customer_reserve 1268 1268 0 0.00 0 380 3 0 0
v_cancel_payment_to_supplier 770 770 0 0.00 0 5945 12 0 0
v_cancel_supplier_invoice 792 782 10 1.26 0 214 12 0 10
v_cancel_supplier_order 802 802 0 0.00 0 173 3 0 0
v_cancel_write_off 1984 1984 0 0.00 0 4676 15 0 0
v_max_id_clo_ord 5294 5294 0 0.00 0 2245 2 0 0
v_max_id_clo_res 959 959 0 0.00 0 1417 11 0 0
v_max_id_ord_sup 5185 5185 0 0.00 0 4306 6 0 0
v_max_non_paid_invoice 1335 1335 0 0.00 0 1055 3 0 0
v_max_non_paid_realizn 3475 3475 0 0.00 0 7522 7 0 0
v_min_id_clo_ord 5294 5294 0 0.00 0 8371 10 0 0
v_min_id_clo_res 959 959 0 0.00 0 4210 16 0 0
v_min_id_ord_sup 5185 5185 0 0.00 0 5547 11 0 0
v_min_non_paid_invoice 5621 5621 0 0.00 0 8941 14 0 0
v_min_non_paid_realizn 6621 6621 0 0.00 0 5725 20 0 0
v_our_firm 9588 9588 0 0.00 0 22 1 0 0
v_reserve_write_off 18546 18546 0 0.00 0 5156 6 0 0
x_lock_depdocs_on_canc_invoice 12165 12165 0 0.00 0 13763 105 0 0
x_lock_depdocs_on_canc_sup_ord 401 401 0 0.00 0 9511 363 0 0
x_make_qstorno_1000_1200 5294 5294 0 0.00 2 35203 1255 0 0
x_make_qstorno_1200_2000 5193 5193 0 0.00 3 86367 3278 0 0
x_make_qstorno_2100_3300 438089 438089 0 0.00 0 95054 141 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 05-04-2021 04:27:44 to 05-04-2021 04:27:48.

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
01:57:01 5 8192000000 8796668848 8807174144 3189104 0.038 1 1 2 0 3286720 61840 35776
01:58:03 19322 8192000000 9716351376 10012889088 797942992 8.875 100 86 172 1 825953472 7500000 20510480
01:59:26 23289 8192000000 9758466160 10060808192 833941152 9.239 100 88 176 1 866840000 11730160 21168688
02:00:55 17964 8192000000 9800425328 10116448256 866779824 9.568 100 86 172 0 904142656 17037936 20324896
02:02:21 15171 8192000000 9881722656 10214981632 927323120 10.168 100 85 170 2 990064432 43755760 18985552
02:03:43 9260 8192000000 9904287952 10247319552 957994576 10.469 100 79 157 0 1023931104 49448384 16488144
02:04:56 5906 8192000000 9976468832 10331439104 992620128 10.807 100 86 172 1 1090758544 80648352 17490064
02:06:05 3131 8192000000 9979910544 10344177664 1019415264 11.066 100 81 162 3 1096258000 60572896 16269840
02:07:10 2520 8192000000 10012100544 10379612160 1046893504 11.331 100 88 177 0 1126739472 61603120 18242848
02:08:14 1610 8192000000 10040953184 10412417024 1065792416 11.512 100 88 174 0 1150084576 65904928 18387232
02:09:16 11004 8192000000 10002769824 10400079872 1070847168 11.560 100 49 97 1 1116271568 35581440 9842960
02:10:29 4156 8192000000 9998328224 10397188096 1077636208 11.625 100 39 79 2 1117024128 31206960 8180960
02:11:35 9597 8192000000 9996061520 10404593664 1082927408 11.675 100 34 66 2 1104827632 14909104 6991120
02:12:48 9888 8192000000 10001457328 10415730688 1086455952 11.709 100 28 56 3 1127271152 34562064 6253136
02:13:59 39694 8192000000 10007953968 10428604416 1091793408 11.760 100 46 92 1 1131129536 29366800 9969328
02:15:48 5719 8192000000 10008806128 10407813120 1102735312 11.864 100 38 75 1 1126013568 13585040 9693216
02:16:54 8152 8192000000 9995833888 10403168256 1084809696 11.693 99 23 44 2 1113410896 23383072 5218128
02:18:05 9809 8192000000 9992534000 10387591168 1049181376 11.353 98 31 60 3 1071149584 15317360 6650848
02:19:15 29404 8192000000 9929971376 10325807104 955739504 10.447 90 33 62 1 976354976 14156496 6458976
02:20:45 4175 8192000000 9959498928 10337198080 1038324144 11.249 100 58 117 1 1072101328 20957120 12820064
02:21:50 6473 8192000000 9952351728 10333368320 1017297904 11.046 99 48 96 1 1050167216 21890752 10978560
02:22:59 54558 8192000000 9969512032 10364674048 1053982112 11.399 100 46 92 2 1083104768 19348400 9774256
02:24:55 5182 8192000000 9991307152 10393915392 1068084320 11.534 100 42 84 0 1096410448 18967824 9358304
02:26:01 3511 8192000000 9993597072 10388176896 1071936768 11.571 100 40 80 2 1099479200 18793344 8749088
02:27:10 54890 8192000000 9998336272 10398826496 1088842800 11.732 100 33 65 5 1105867120 9451024 7573296
02:29:11 80140 8192000000 10081593904 10490048512 1117755664 12.006 100 31 62 0 1169148080 44919504 6472912
02:32:00 20189 8192000000 10104236016 10515288064 1138680320 12.203 100 38 76 1 1228845968 81588736 8576912
02:33:26 7730 8192000000 10168656896 10573918208 1157928736 12.384 100 66 131 2 1278984736 106855680 14200320
02:34:37 17939 8192000000 10190866208 10597605376 1158768752 12.392 100 61 120 1 1291695680 119402304 13524624
02:35:59 3397 8192000000 10212913744 10619985920 1165884352 12.458 100 66 132 2 1317300400 137310592 14105456
02:37:05 5492 8192000000 10265500688 10677420032 1175823600 12.551 100 58 115 0 1364113152 175334864 12954688
02:38:16 8949 8192000000 10280206464 10696245248 1174430944 12.538 100 58 117 1 1396123536 207853632 13838960
02:39:31 1865 8192000000 10292846320 10704605184 1152387888 12.332 100 78 155 0 1394279760 224277136 17614736
02:40:37 1399 8192000000 10303215280 10711216128 1164946624 12.450 100 81 160 1 1410718336 227848096 17923616
02:41:42 2417 8192000000 10279576544 10680389632 1134933888 12.168 98 75 149 1 1361070688 209568576 16568224
02:42:48 5988 8192000000 10265289248 10684841984 1152963552 12.337 100 48 94 0 1372978480 208923168 11091760
02:43:57 3712 8192000000 10281765904 10693111808 1140834464 12.223 99 56 112 0 1386746544 233401104 12510976
02:45:06 3020 8192000000 10341997296 10746765312 1164244384 12.443 100 73 148 2 1436285056 255153056 16887616
02:46:13 3175 8192000000 10370330032 10806751232 1162427936 12.426 100 62 123 1 1480098240 302930032 14740272
02:47:24 6518 8192000000 10377095072 10806435840 1155205264 12.358 100 47 93 0 1484142496 317047808 11889424
02:48:31 5111 8192000000 10410990592 10829737984 1163649552 12.437 100 52 104 1 1501151664 324330032 13172080
02:49:45 5536 8192000000 10427597920 10851213312 1148145104 12.292 100 48 96 2 1527208784 366514352 12549328
02:50:57 11950 8192000000 10376604352 10919284736 1162159344 12.423 100 28 56 0 1518399072 348026704 8213024
02:52:11 19130 8192000000 10399652752 10833043456 1146022768 12.272 99 29 58 1 1477566848 323771376 7772704
02:53:31 26151 8192000000 10403663232 10902990848 1142815120 12.242 100 20 40 1 1551356336 402703040 5838176
02:55:05 17421 8192000000 10318979136 10923401216 1117733744 12.006 99 12 24 0 1428131200 306881920 3515536
02:57:54 16431 8192000000 10092793408 10514919424 1141788256 12.232 100 49 98 2 1187569424 34364384 11416784
02:59:13 109839 8192000000 10101857456 10586238976 1138265184 12.199 99 26 53 2 1180689616 37241168 5183264
03:02:28 72408 8192000000 10118720224 10573127680 1120070768 12.028 97 16 32 1 1176329712 53090256 3168688
03:05:58 67170 8192000000 10115108336 10613407744 1137952064 12.196 99 13 26 0 1242463792 101498528 3013200
03:08:05 33184 8192000000 10091952416 10548494336 1132952960 12.149 98 13 25 0 1181659968 45733328 2973680
03:09:40 60422 8192000000 10132661760 10595667968 1131866256 12.139 98 13 26 0 1205621856 70924144 2831456
03:11:50 56959 8192000000 10150842320 10626633728 1150703840 12.316 100 16 32 1 1249073632 94526112 3843680
03:14:12 55625 8192000000 10128587024 10605920256 1147842128 12.289 100 17 34 1 1239288560 87639840 3806592
03:16:20 42257 8192000000 10104170368 10563690496 1137531840 12.192 99 15 30 1 1194354720 53410720 3412160
03:18:12 65732 8192000000 10138111504 10625179648 1147474960 12.286 100 13 26 0 1235934144 85632192 2826992
03:20:18 51735 8192000000 10077613760 10528428032 1115180128 11.981 97 17 34 0 1159889056 40980944 3727984
03:22:11 55875 8192000000 10103804000 10609901568 1122647072 12.052 98 17 34 1 1209150864 82973552 3530240
03:24:24 67102 8192000000 10099217984 10569617408 1134855936 12.167 99 21 42 0 1221078576 81529264 4693376
03:26:31 70533 8192000000 10130952080 10602225664 1101196896 11.849 96 16 32 0 1170510400 66030608 3282896
03:28:52 78370 8192000000 10096822576 10607370240 1104043040 11.876 97 20 40 1 1180693264 72864608 3785616
03:31:20 43068 8192000000 10069509184 10499125248 1083233008 11.678 95 34 68 0 1139469760 49341856 6894896
03:33:07 61817 8192000000 10048665328 10508021760 1118329968 12.011 99 22 44 0 1166419504 43845968 4243568
03:35:09 74169 8192000000 10065946592 10527412224 1101531328 11.852 98 8 16 0 1134612720 31331520 1749872
03:37:24 65639 8192000000 10041518592 10552483840 1104795104 11.883 98 7 14 0 1155012032 49056800 1160128
03:39:30 36981 8192000000 10051295696 10492465152 1079356288 11.641 96 19 38 0 1113532032 29179648 4996096
03:41:07 46838 8192000000 10107579584 10559868928 1126474128 12.088 99 25 50 0 1190830496 59206240 5150128
03:42:54 54907 8192000000 10101445632 10560114688 1129460080 12.116 100 16 32 0 1214436336 81188336 3787920
03:44:49 43268 8192000000 10075323872 10509365248 1098538112 11.824 97 25 50 0 1144464544 40884176 5042256
03:46:33 35819 8192000000 10193631840 10618593280 1115185664 11.981 98 47 94 0 1232045248 106993840 9865744
03:48:51 120830 8192000000 10038639840 10484555776 1104311296 11.879 98 10 20 1 1143182496 36728608 2142592
03:51:53 80367 8192000000 10052613984 10513276928 1128117744 12.104 100 5 10 1 1152029984 22930144 982096
03:54:15 68397 8192000000 10089612336 10549108736 1138443600 12.201 100 8 14 1 1170261952 29615632 2202720
03:56:28 76438 8192000000 10183463648 10650902528 1144920768 12.262 99 20 38 1 1257166688 107886128 4359792
03:58:49 53640 8192000000 10211283184 10665402368 1161550224 12.418 100 25 50 1 1294314400 127147504 5616672
04:00:59 68892 8192000000 10053187632 10504716288 1098745536 11.826 95 10 19 1 1134323152 33913744 1663872
04:03:16 49892 8192000000 10142313040 10587443200 1145695392 12.269 99 41 81 1 1208518800 54723152 8100256
04:05:14 45299 8192000000 10119992720 10605711360 1154141088 12.348 100 18 36 2 1198093920 40526496 3426336
04:07:00 53724 8192000000 10093033408 10536894464 1118461072 12.012 96 11 22 0 1143073104 22480256 2131776
04:08:54 89136 8192000000 10072483568 10555305984 1083681728 11.683 94 5 10 1 1129583488 45213008 688752
04:11:25 39188 8192000000 10067808624 10525868032 1142879856 12.243 100 18 36 1 1172858752 25908688 4070208
04:13:11 77400 8192000000 10076787920 10545778688 1120674800 12.033 98 7 14 1 1162055072 39924016 1456256
04:15:39 83480 8192000000 10071562992 10573754368 1106120864 11.896 97 11 22 0 1160418464 51605008 2692592
04:18:03 34311 8192000000 10068661360 10543525888 1127746176 12.100 99 38 76 1 1166436736 30125392 8565168
04:19:40 47990 8192000000 10125695808 10574041088 1142106144 12.235 100 27 54 1 1216178192 68278512 5793536
04:21:31 75213 8192000000 10106478640 10568335360 1134443696 12.163 99 17 33 1 1195447360 57295648 3708016
04:23:56 28183 8192000000 10110306560 10562002944 1119803808 12.025 97 44 88 0 1178628144 49751376 9072960
04:25:26 73428 8192000000 10088138800 10606252032 1105987712 11.894 97 25 50 0 1208132976 97369424 4775840

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 05-04-2021 04:27:50 to 05-04-2021 04:28:05.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 70 v_add_invoice_to_stock 335544517
except 5 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 05-04-2021 04:28:06 to 05-04-2021 04:28:08.

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          241914
MON$OLDEST_ACTIVE               241915
MON$OLDEST_SNAPSHOT             241915
MON$NEXT_TRANSACTION            241915
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                       2112960
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             795
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.0.2404 Firebird 4.0 Release Candidate 1
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.0.2404 Firebird 4.0 Release Candidate 1"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.0.2404 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.2404 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'

05.04.21 04:28:09. 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-04-05 04:28:11 No severe PSQL-related problems occured
05.04.21 04:28:12. End of report.