Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 16.12.2022 22:40
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 14900808 kB
MemAvailable 30107668 kB
Buffers 0 kB
Cached 16831416 kB
SwapCached 3928 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 3.0.11
DB_NAME                         /home/bases/oltp30-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

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

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2022-12-16 22:38:31
DTS_END                         2022-12-16 22:38:31.6050
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP                              ::1/56498
TRN_ID                          247029
ATT_ID                          710
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: 9613.38 19626 1153605
customer order: creation 182.14 347 21857
customer order: refuse 15.43 353 1851
order to supplier: creation 48.08 1227 5770
order to supplier: removal 3.55 87474 426
invoice (draft): creation 48.62 3294 5834
invoice (draft): removal 54.09 684 6491
invoice accept: apply 44.06 16349 5287
invoice accept: cancel 49.26 775 5911
customer reserve: creation 4054.48 162 486537
customer reserve: removal 4805.93 51 576711
realization accept: apply 87.96 180 10555
realization accept: cancel 83.36 98 10003
payment from customer: creation 62.21 116 7465
payment from customer: removal 6.16 115 739
payment to supplier: creation 52.07 129 6248
payment to supplier: removal 3.61 93 433
service: total inventory turnovers 4.72 1256 567
service: total monetary turnovers 6.87 31 824
service: aggregate perf. data 0.77 26995 92
service: refresh index statistics 0.03 252790 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 16-12-2022 22:40:20 to 16-12-2022 22:40:23.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 4615
TEST_TIME 2 4707
TEST_TIME 3 4892
TEST_TIME 4 4756
TEST_TIME 5 5240
TEST_TIME 6 4911
TEST_TIME 7 5985
TEST_TIME 8 6062
TEST_TIME 9 6293
TEST_TIME 10 5997
TEST_TIME 11 6243
TEST_TIME 12 6485
TEST_TIME 13 6802
TEST_TIME 14 7186
TEST_TIME 15 7131
TEST_TIME 16 7444
TEST_TIME 17 7684
TEST_TIME 18 7823
TEST_TIME 19 8260
TEST_TIME 20 8466
TEST_TIME 21 8280
TEST_TIME 22 8752
TEST_TIME 23 8765
TEST_TIME 24 8884
TEST_TIME 25 9069
TEST_TIME 26 8879
TEST_TIME 27 8888
TEST_TIME 28 9403
TEST_TIME 29 9728
TEST_TIME 30 10088
TEST_TIME 31 10482
TEST_TIME 32 10503
TEST_TIME 33 10432
TEST_TIME 34 10557
TEST_TIME 35 10525
TEST_TIME 36 10484
TEST_TIME 37 10407
TEST_TIME 38 10207
TEST_TIME 39 10107
TEST_TIME 40 10314
TEST_TIME 41 10155
TEST_TIME 42 10165
TEST_TIME 43 10078
TEST_TIME 44 9939
TEST_TIME 45 9939
TEST_TIME 46 9884
TEST_TIME 47 9791
TEST_TIME 48 9868
TEST_TIME 49 9766
TEST_TIME 50 9746
TEST_TIME 51 9750
TEST_TIME 52 9780
TEST_TIME 53 9645
TEST_TIME 54 9627
TEST_TIME 55 9551
TEST_TIME 56 9511
TEST_TIME 57 9461
TEST_TIME 58 9469
TEST_TIME 59 9430
TEST_TIME 60 9458
TEST_TIME 61 9493
TEST_TIME 62 9582
TEST_TIME 63 9671
TEST_TIME 64 9681
TEST_TIME 65 9763
TEST_TIME 66 9821
TEST_TIME 67 9862
TEST_TIME 68 9810
TEST_TIME 69 9845
TEST_TIME 70 9936
TEST_TIME 71 9949
TEST_TIME 72 9878
TEST_TIME 73 9778
TEST_TIME 74 9807
TEST_TIME 75 9715
TEST_TIME 76 9705
TEST_TIME 77 9633
TEST_TIME 78 9614
TEST_TIME 79 9634
TEST_TIME 80 9598
TEST_TIME 81 9542
TEST_TIME 82 9545
TEST_TIME 83 9529
TEST_TIME 84 9554
TEST_TIME 85 9544
TEST_TIME 86 9552
TEST_TIME 87 9562
TEST_TIME 88 9600
TEST_TIME 89 9609
TEST_TIME 90 9649
TEST_TIME 91 9700
TEST_TIME 92 9718
TEST_TIME 93 9736
TEST_TIME 94 9746
TEST_TIME 95 9756
TEST_TIME 96 9688
TEST_TIME 97 9650
TEST_TIME 98 9604
TEST_TIME 99 9607
TEST_TIME 100 9610
TEST_TIME 101 9564
TEST_TIME 102 9500
TEST_TIME 103 9538
TEST_TIME 104 9629
TEST_TIME 105 9604
TEST_TIME 106 9591
TEST_TIME 107 9612
TEST_TIME 108 9613
TEST_TIME 109 9592
TEST_TIME 110 9636
TEST_TIME 111 9664
TEST_TIME 112 9684
TEST_TIME 113 9780
TEST_TIME 114 9778
TEST_TIME 115 9783
TEST_TIME 116 9764
TEST_TIME 117 9697
TEST_TIME 118 9670
TEST_TIME 119 9662
TEST_TIME 120 9618

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:04, from 16-12-2022 22:40:24 to 16-12-2022 22:40:28.

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 1604177 1604177 0 0.00 0 26064 5 0 0
doc_list_biud 1604171 1604171 0 0.00 0 24978 23 0 0
sp_add_invoice_to_stock 5386 5287 99 1.83 35 187203 16349 0 99
sp_cancel_adding_invoice 5911 5911 0 0.00 2 55970 775 0 0
sp_cancel_client_order 1851 1851 0 0.00 4 14994 353 0 0
sp_cancel_customer_reserve 576711 576711 0 0.00 0 20271 51 0 0
sp_cancel_pay_from_customer 739 739 0 0.00 2 8028 116 0 0
sp_cancel_pay_to_supplier 433 433 0 0.00 2 5613 93 0 0
sp_cancel_supplier_invoice 6501 6491 10 0.15 2 16697 685 0 10
sp_cancel_supplier_order 426 426 0 0.00 7 822647 87474 0 0
sp_cancel_write_off 10003 10003 0 0.00 1 15832 99 0 0
sp_client_order 21857 21857 0 0.00 3 17146 347 0 0
sp_customer_reserve 486537 486537 0 0.00 0 45464 162 0 0
sp_fill_shopping_cart 33452 33452 0 0.00 1 11244 32 0 0
sp_fill_shopping_cart_clo_res 486528 486528 0 0.00 0 18799 14 0 0
sp_get_clo_for_invoice 5277 5277 0 0.00 0 24381 305 0 0
sp_kill_cost_storno 17086 17086 0 0.00 0 5797 49 0 0
sp_kill_qstorno_ret_qs2qd 1170342 1170342 0 0.00 0 20096 28 0 0
sp_kill_qty_storno 617221 617221 0 0.00 0 24977 60 0 0
sp_lock_selected_doc 21845 21845 0 0.00 0 9819 7 0 0
sp_make_cost_storno 29545 29545 0 0.00 0 25835 53 0 0
sp_multiply_rows_for_pdistr 29543 29543 0 0.00 0 9171 29 0 0
sp_multiply_rows_for_qdistr 21857 21857 0 0.00 0 15763 159 0 0
sp_pay_from_customer 7465 7465 0 0.00 4 10165 117 0 0
sp_pay_to_supplier 6248 6248 0 0.00 4 10995 129 0 0
sp_payment_common 13711 13711 0 0.00 1 5342 25 0 0
sp_qd_handle_on_cancel_clo 1851 1851 0 0.00 0 14988 318 0 0
sp_qd_handle_on_invoice_upd_sts 11185 11185 0 0.00 0 24975 295 0 0
sp_qd_handle_on_reserve_upd_sts 10553 10553 0 0.00 0 13147 56 0 0
sp_reserve_write_off 10555 10555 0 0.00 6 13165 181 0 0
sp_supplier_invoice 5834 5834 0 0.00 6 108509 3295 0 0
sp_supplier_order 5770 5770 0 0.00 4 55154 1228 0 0
srv_aggregate_perf_data 92 92 0 0.00 3002 406695 26995 0 0
srv_fill_mon_cache_memory 64 64 0 0.00 1358 121245 44933 0 0
srv_find_qd_qs_mism 1103264 1103264 0 0.00 0 15687 4 0 0
srv_make_invnt_saldo 567 567 0 0.00 34 87325 1257 0 0
srv_make_money_saldo 824 824 0 0.00 1 5734 31 0 0
srv_recalc_idx_stat 4 4 0 0.00 107089 415854 252791 0 0
t$perf-abend:sp_add_invoice_to_stock 99 99 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 10 10 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 5287 5287 0 0.00 0 21628 171 0 0
t$perf-norm:sp_cancel_adding_invoice 431 431 0 0.00 0 2206 78 0 0
t$perf-norm:sp_cancel_client_order 1851 1851 0 0.00 0 4497 16 0 0
t$perf-norm:sp_cancel_customer_reserve 733 733 0 0.00 0 12583 44 0 0
t$perf-norm:sp_cancel_pay_from_customer 739 739 0 0.00 0 1319 7 0 0
t$perf-norm:sp_cancel_pay_to_supplier 433 433 0 0.00 0 2252 8 0 0
t$perf-norm:sp_cancel_supplier_invoice 412 412 0 0.00 0 2449 18 0 0
t$perf-norm:sp_cancel_supplier_order 426 426 0 0.00 0 19571 1497 0 0
t$perf-norm:sp_cancel_write_off 993 993 0 0.00 0 1063 7 0 0
t$perf-norm:sp_client_order 21857 21857 0 0.00 0 19955 21 0 0
t$perf-norm:sp_customer_reserve 1055 1055 0 0.00 0 2821 8 0 0
t$perf-norm:sp_pay_from_customer 7465 7465 0 0.00 0 15546 15 0 0
t$perf-norm:sp_pay_to_supplier 6248 6248 0 0.00 0 16998 16 0 0
t$perf-norm:sp_reserve_write_off 10555 10555 0 0.00 0 16932 11 0 0
t$perf-norm:sp_supplier_invoice 5834 5834 0 0.00 0 6406 17 0 0
t$perf-norm:sp_supplier_order 5770 5770 0 0.00 0 9484 20 0 0
t$perf-norm:srv_aggregate_perf_data 92 92 0 0.00 0 29 1 0 0
t$perf-norm:srv_fill_mon_cache_memory 64 64 0 0.00 0 2195 56 0 0
t$perf-norm:srv_make_invnt_saldo 567 567 0 0.00 0 1436 20 0 0
t$perf-norm:srv_make_money_saldo 824 824 0 0.00 0 1234 13 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 1 36 11 0 0
v_add_invoice_to_stock 10746 10548 198 1.84 0 7922 18 0 198
v_all_customers 39654 39654 0 0.00 0 21 0 0 0
v_all_suppliers 32170 32170 0 0.00 0 29 1 0 0
v_all_wares 43712 43712 0 0.00 0 22 1 0 0
v_cancel_adding_invoice 862 862 0 0.00 0 4860 13 0 0
v_cancel_client_order 3702 3702 0 0.00 0 5094 8 0 0
v_cancel_customer_prepayment 1478 1478 0 0.00 0 7918 27 0 0
v_cancel_customer_reserve 1466 1466 0 0.00 0 3105 6 0 0
v_cancel_payment_to_supplier 866 866 0 0.00 0 5443 11 0 0
v_cancel_supplier_invoice 844 824 20 2.36 0 2459 23 0 20
v_cancel_supplier_order 852 852 0 0.00 0 3005 11 0 0
v_cancel_write_off 1986 1986 0 0.00 0 5890 17 0 0
v_max_id_clo_ord 5767 5767 0 0.00 0 430 1 0 0
v_max_id_clo_res 1055 1055 0 0.00 0 5423 26 0 0
v_max_id_ord_sup 5829 5829 0 0.00 0 4049 5 0 0
v_max_non_paid_invoice 1757 1757 0 0.00 0 403 3 0 0
v_max_non_paid_realizn 4105 4105 0 0.00 0 2752 5 0 0
v_min_id_clo_ord 5767 5767 0 0.00 0 2195 4 0 0
v_min_id_clo_res 1055 1055 0 0.00 0 8848 22 0 0
v_min_id_ord_sup 5829 5829 0 0.00 0 4878 7 0 0
v_min_non_paid_invoice 6246 6246 0 0.00 0 4887 16 0 0
v_min_non_paid_realizn 7465 7465 0 0.00 0 5331 19 0 0
v_our_firm 10778 10778 0 0.00 0 16 1 0 0
v_reserve_write_off 21106 21106 0 0.00 0 7932 10 0 0
x_lock_depdocs_on_canc_invoice 11990 11990 0 0.00 0 14523 112 0 0
x_lock_depdocs_on_canc_sup_ord 426 426 0 0.00 0 21484 338 0 0
x_make_qstorno_1000_1200 5770 5770 0 0.00 1 55122 1159 0 0
x_make_qstorno_1200_2000 5834 5834 0 0.00 3 103505 3176 0 0
x_make_qstorno_2100_3300 486537 486537 0 0.00 0 45460 146 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 16-12-2022 22:40:29 to 16-12-2022 22:40:33.

Memory consumption, metadata cache, attachments activity

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


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

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
20:08:35 1 8192000000 8797116400 8807743488 3955424 0.048 1 1 2 0 4053696 55488 42784
20:09:36 7201 8192000000 9888250144 10196299776 978779536 10.672 100 86 172 0 1007245184 5745120 22720528
20:10:50 30684 8192000000 9940460112 10259034112 1017374944 11.047 100 88 176 0 1047701568 7567728 22758896
20:12:30 13138 8192000000 9967138624 10298318848 1055001120 11.409 100 83 166 0 1084692368 8880784 20810464
20:13:49 6266 8192000000 10017347520 10362540032 1106658336 11.901 100 76 152 0 1135162640 9952256 18552048
20:14:59 6968 8192000000 10070627984 10425290752 1157495008 12.380 100 75 151 0 1185963984 11213728 17255248
20:16:09 3641 8192000000 10117622608 10482282496 1202173296 12.797 100 79 155 0 1232272352 12283744 17815312
20:17:16 2546 8192000000 10149158544 10523086848 1235097232 13.101 100 74 145 1 1264630192 14009488 15523472
20:18:20 1862 8192000000 10186197056 10572201984 1275198736 13.469 100 77 148 2 1307825072 15228512 17397824
20:19:24 1260 8192000000 10212674304 10597081088 1299770784 13.693 100 88 174 0 1331904000 11768240 20364976
20:20:28 4529 8192000000 10192815808 10598436864 1303685760 13.729 100 35 70 0 1319686192 8695472 7304960
20:21:33 8429 8192000000 10199246784 10610171904 1315801152 13.839 100 23 46 1 1331552000 10913024 4837824
20:22:44 48162 8192000000 10238409504 10638086144 1321700480 13.892 100 62 124 0 1341810368 5176432 14933456
20:24:33 4798 8192000000 10222281856 10636206080 1326009520 13.931 100 36 72 0 1341761232 8200560 7551152
20:25:38 9949 8192000000 10223409024 10647740416 1337080672 14.031 100 15 31 0 1346265136 5891440 3293024
20:26:49 53032 8192000000 10240947344 10660622336 1345328608 14.105 100 34 68 0 1359307504 5477952 8500944
20:28:48 4651 8192000000 10216007424 10633007104 1307436800 13.763 98 26 53 1 1323844208 10510976 5896432
20:29:53 7866 8192000000 10172414528 10582568960 1273828256 13.457 99 19 37 1 1282829248 5215936 3785056
20:31:02 8052 8192000000 10139555424 10539679744 1210417808 12.873 96 20 38 1 1220190176 5715632 4056736
20:32:11 22587 8192000000 10132428128 10524901376 1177608400 12.568 94 44 90 1 1193274976 5695824 9970752
20:33:36 4638 8192000000 10133106912 10533429248 1233585216 13.087 99 20 39 0 1243052528 5003264 4464048
20:34:42 6856 8192000000 10160500400 10567274496 1261646640 13.345 99 18 36 0 1271614384 5966800 4000944
20:35:49 10229 8192000000 10185615472 10594869248 1279226224 13.506 99 20 40 0 1289702432 5967776 4508432
20:37:04 9269 8192000000 10214913792 10609065984 1298513440 13.682 100 63 127 0 1323841680 10057776 15270464
20:38:14 7954 8192000000 10209754896 10625429504 1319558176 13.873 100 23 46 0 1330521968 6064528 4899264
20:39:29 8853 8192000000 10245688304 10652966912 1341221792 14.068 100 52 99 0 1360340480 8401040 10717648
20:40:43 22704 8192000000 10261386112 10674176000 1354831616 14.191 100 41 83 1 1374074560 9018768 10224176
20:42:12 46642 8192000000 10272020784 10694242304 1366255712 14.293 100 37 72 0 1386726736 12106400 8364624
20:44:59 23890 8192000000 10291766864 10713829376 1380257632 14.419 100 38 76 0 1404204752 14408752 9538368
20:46:28 14883 8192000000 10301191920 10725318656 1391040576 14.515 100 51 102 2 1417825456 14618288 12166592
20:47:52 16797 8192000000 10304888240 10739515392 1398612800 14.583 100 45 86 2 1423232832 14160688 10459344
20:49:16 3144 8192000000 10322349392 10744889344 1398367904 14.580 100 56 112 0 1427933328 15850816 13714608
20:50:24 6170 8192000000 10330382096 10752110592 1396409472 14.563 99 63 124 1 1430735712 18986800 15339440
20:51:38 4300 8192000000 10326680032 10750656512 1398045248 14.578 99 49 98 0 1435483072 24917680 12520144
20:52:49 5402 8192000000 10337916848 10753761280 1401763184 14.611 100 79 154 1 1443761488 23944528 18053776
20:54:02 2235 8192000000 10338786624 10748194816 1396193360 14.561 100 83 165 0 1443049984 26827008 20029616
20:55:08 2445 8192000000 10356520320 10765377536 1404210608 14.632 100 86 170 1 1457121328 31697136 21213584
20:56:14 12923 8192000000 10311530592 10738659328 1382930432 14.443 100 43 86 0 1422440480 28346528 11163520
20:57:35 10971 8192000000 10300338464 10734342144 1361979440 14.255 98 41 83 0 1400647968 28651920 10016608
20:58:49 3853 8192000000 10269510112 10692882432 1329880080 13.966 97 39 78 0 1366002944 25793216 10329648
21:00:02 1356 8192000000 10319187520 10736025600 1374025680 14.363 100 67 132 1 1425220512 34748656 16446176
21:01:08 11599 8192000000 10303156544 10728620032 1356086304 14.202 99 36 73 0 1396928432 31040688 9801440
21:02:28 13595 8192000000 10297402304 10727350272 1363233792 14.266 100 34 69 0 1404142416 32294096 8614528
21:03:45 46170 8192000000 10266559104 10691309568 1314795904 13.830 97 25 50 1 1351159344 29527936 6835504
21:05:35 19163 8192000000 10289091280 10710515712 1332724832 13.992 99 29 57 0 1383588784 42673360 8190592
21:06:56 33649 8192000000 10300860432 10737987584 1362879888 14.263 100 26 50 0 1404012736 34620896 6511952
21:08:36 28786 8192000000 10265882800 10728894464 1343135248 14.086 99 13 26 0 1383103520 36350048 3618224
21:10:06 86707 8192000000 10265790960 10709872640 1359609216 14.234 98 18 31 0 1375596176 12096128 3890832
21:12:40 121245 8192000000 10288412672 10737840128 1350379248 14.151 98 8 16 0 1367108560 15209504 1519808
21:16:11 36589 8192000000 10311792784 10742857728 1385117168 14.462 100 38 75 0 1405548288 11649216 8781904
21:17:48 33614 8192000000 10308511056 10745946112 1385593264 14.467 100 26 54 0 1407254448 15765760 5895424
21:19:24 100552 8192000000 10310010032 10766340096 1400161536 14.596 100 40 80 2 1418200960 8264976 9774448
21:22:09 42434 8192000000 10309713456 10755850240 1393566048 14.538 100 32 64 2 1407366096 7195200 6604848
21:23:57 19670 8192000000 10314984368 10770698240 1404757232 14.637 100 16 32 0 1417621552 8994208 3870112
21:25:18 28410 8192000000 10330605760 10778951680 1396449088 14.563 99 36 72 1 1417411584 11903264 9059232
21:26:47 19948 8192000000 10318449680 10784534528 1406862032 14.656 100 21 42 0 1427535344 15996624 4676688
21:28:09 63117 8192000000 10315059856 10774261760 1399023008 14.586 99 14 28 0 1419075120 16562064 3490048
21:30:15 41824 8192000000 10296703696 10763677696 1401517488 14.609 100 11 22 0 1413958272 9268416 3172368
21:32:05 58202 8192000000 10296786048 10771214336 1404676096 14.637 100 21 42 1 1423991232 14402512 4912624
21:34:06 49527 8192000000 10289106320 10754764800 1362350016 14.258 97 15 28 0 1376814928 10901520 3563392
21:36:07 66475 8192000000 10266731280 10732302336 1338941680 14.048 96 8 16 0 1350105008 9525616 1637712
21:38:22 41109 8192000000 10278254928 10740674560 1354641568 14.189 98 20 40 0 1370648352 11656800 4349984
21:40:03 55044 8192000000 10258062528 10716758016 1281416992 13.526 93 13 26 0 1298416240 13999504 2999744
21:42:00 102031 8192000000 10257238176 10711474176 1271899008 13.439 93 8 16 1 1291374448 17721504 1753936
21:44:42 59890 8192000000 10254792304 10710220800 1307626320 13.765 96 11 22 1 1324142976 14049232 2467424
21:46:42 13014 8192000000 10286096016 10720059392 1355809888 14.200 99 47 92 1 1375581328 9565072 10206368
21:47:55 67084 8192000000 10277570432 10741108736 1321448480 13.890 96 25 47 0 1342765200 16351920 4964800
21:50:02 73217 8192000000 10252111728 10705399808 1306040928 13.750 96 25 49 0 1325371296 13548576 5781792
21:52:29 83413 8192000000 10250779424 10695987200 1299123712 13.687 96 22 44 0 1318008592 14291792 4593088
21:55:03 59538 8192000000 10254397680 10710577152 1347704720 14.127 100 15 30 0 1363265904 12385680 3175504
21:57:04 27516 8192000000 10255029648 10706853888 1337910096 14.039 98 27 54 2 1351166592 7369968 5886528
21:58:39 56605 8192000000 10260452160 10719596544 1366469904 14.295 100 15 30 0 1378485680 8508784 3506992
22:01:44 67310 8192000000 10282236864 10734776320 1340596336 14.063 97 20 40 0 1359371728 14014816 4760576
22:03:58 42785 8192000000 10276990880 10730725376 1361269680 14.249 99 25 50 1 1378314992 11514608 5530704
22:05:45 48486 8192000000 10298965472 10752159744 1370845168 14.335 99 31 62 0 1387565648 10120096 6600384
22:07:45 109559 8192000000 10307780464 10765692928 1376660768 14.387 99 21 42 0 1395967600 14691008 4615824
22:10:35 38794 8192000000 10305100432 10766921728 1402258848 14.615 100 10 20 0 1410856384 6598640 1998896
22:12:15 75356 8192000000 10315791168 10776109056 1403832864 14.629 100 11 22 1 1419413120 12783680 2796576
22:14:35 111973 8192000000 10285527104 10739650560 1355612832 14.198 97 20 40 0 1366231072 6194256 4423984
22:17:30 42762 8192000000 10272136752 10740736000 1357585584 14.216 98 14 28 0 1374083840 12601968 3896288
22:19:41 50908 8192000000 10310229264 10772627456 1401099856 14.605 100 10 20 0 1413673792 10227072 2346864
22:21:36 99279 8192000000 10274119248 10741452800 1303139456 13.724 93 9 18 0 1324803056 19635696 2027904
22:24:18 37497 8192000000 10265240752 10715955200 1320009920 13.877 96 22 46 0 1334917280 10002624 4904736
22:26:01 62258 8192000000 10273255040 10716827648 1309886032 13.785 95 17 32 0 1326640720 13028928 3725760
22:28:03 68671 8192000000 10288439904 10749882368 1356883024 14.209 99 23 46 0 1381834864 19952272 4999568
22:30:27 67347 8192000000 10273953248 10725642240 1333256752 13.997 97 21 42 0 1351026432 12936400 4833280
22:32:40 89655 8192000000 10268686080 10716024832 1309246624 13.779 96 11 22 0 1322533664 11210128 2076912
22:35:11 71749 8192000000 10268528688 10715422720 1325938448 13.930 97 20 40 0 1338381952 7417968 5025536
22:37:25 44930 8192000000 10243547808 10694610944 1324743360 13.920 98 23 46 0 1343826960 13287120 5796480

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 16-12-2022 22:40:35 to 16-12-2022 22:40:50.

Exceptions occured during test was in run

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

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 16-12-2022 22:40:51 to 16-12-2022 22:40:53.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          246943
MON$OLDEST_ACTIVE               248576
MON$OLDEST_SNAPSHOT             248576
MON$NEXT_TRANSACTION            248576
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-03 16:41:55.3470
MON$PAGES                       2045536
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.11.33648 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.11.33648 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.11.33648 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.11.33648 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
:754: 
:755: mscs-test-161.budzdorov.ru    Fri Dec 16 22:38:42 2022
:756:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:757: 
--- end of diff output ---

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

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