Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 10.11.2026 17:51
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. External connections pool: DISABLED. Test config parameter 'use_es' must be 2; ExtConnPoolSize must be ^> 0.
  4. Performance, DETAILS per units
  5. Memory consumption, metadata cache, attachments activity    as table    as chart
  6. Monitoring data: STATEMENTS activity, as chart
  7. 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 test-0
Icon name computer-vm
Chassis vm 🖴
Machine ID de98ff4ed95945a6974b0c761b9e398f
Boot ID cc11645eec8340f48398c8a2eb858648
Product UUID de98ff4e-d959-45a6-974b-0c761b9e398f
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.116+deb13-amd64
Architecture x86-64
Hardware Vendor Selectel
Hardware Model OpenStack Nova
Hardware Serial de98ff4e-d959-45a6-974b-0c761b9e398f
Firmware Version 1.15.0-1
Firmware Date Tue 2014-04-01
Firmware Age 12y 7month 1w 3d
Command: who -b
bootup_info system boot 2026-11-09 10:54
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
./oltp_isql_run_worker.sh line 54: dmidecode: command not found
Command: dmesg | grep DMI
[ 0.000000] DMI Selectel OpenStack Nova, BIOS 1.15.0-1 04/01/2014
[ 0.000000] DMI Memory slots populated: 1/1
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Address sizes 46 bits physical, 48 bits virtual
Byte Order Little Endian
CPU(s) 4
On-line CPU(s) list 0-3
Vendor ID GenuineIntel
Model name Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz
CPU family 6
Model 63
Thread(s) per core 1
Core(s) per socket 1
Socket(s) 4
Stepping 2
BogoMIPS 4799.99
Hypervisor vendor KVM
Virtualization type full
L1d cache 128 KiB (4 instances)
L1i cache 128 KiB (4 instances)
L2 cache 16 MiB (4 instances)
L3 cache 64 MiB (4 instances)
NUMA node(s) 1
NUMA node0 CPU(s) 0-3
Vulnerability Gather data sampling Not affected
Vulnerability Indirect target selection Mitigation; Aligned branch/return thunks
Vulnerability Itlb multihit Not affected
Vulnerability L1tf Mitigation; PTE Inversion
Vulnerability Mds Mitigation; Clear CPU buffers; SMT Host state unknown
Vulnerability Meltdown Mitigation; PTI
Vulnerability Mmio stale data Vulnerable: Clear CPU buffers attempted, no microcode; SMT Host state unknown
Vulnerability Reg file data sampling Not affected
Vulnerability Retbleed Not affected
Vulnerability Spec rstack overflow Not affected
Vulnerability Spec store bypass Mitigation; Speculative Store Bypass disabled via prctl
Vulnerability Spectre v1 Mitigation; usercopy/swapgs barriers and __user pointer sanitization
Vulnerability Spectre v2 Mitigation; Retpolines; IBPB conditional; IBRS_FW; STIBP disabled; RSB filling; PBRSB-eIBRS Not affected; BHI Retpoline
Vulnerability Srbds Not affected
Vulnerability Tsa Not affected
Vulnerability Tsx async abort Not affected
Vulnerability Vmscape Not affected
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 8138016 kB
MemFree 1942448 kB
MemAvailable 7289996 kB
Buffers 80064 kB
Cached 5389284 kB
SwapCached 12 kB
Command: fdisk -l
./oltp_isql_run_worker.sh: line 54: fdisk: command not found

Server and database settinfs


SERVER_MODE                     SuperServer 3.0.15
DB_NAME                         /var/db/oltp-emul/oltp-hq30.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    262144
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=/var/db/oltp-emul/oltp-hq30.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/var/db/oltp-emul/oltp_30.etalone.fdb
param=expected_workers, val=100
param=fbc, val=/opt/hq30/bin
param=file_name_this_host_info, val=test-0
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=html_chart_color_memo_all, val=magenta
param=html_chart_color_memo_att, val=magenta
param=html_chart_color_memo_stm, val=magenta
param=html_chart_color_memo_trn, val=magenta
param=html_chart_color_perf_score, val=magenta
param=init_buff, val=4096
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_passwd, val=0Ltp-Emu1
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=30300
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=results_storage_fbk, val=/mnt/oltp-emul/reports/oltp-hq30-results.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=sleep_min, val=0
param=test_intervals, val=30
param=test_time, val=50
param=tmpdir, val=/var/tmp/logs.oltp-hq30
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=use_es, val=0
param=used_in_replication, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=0
param=wait_if_not_exists, val=0
param=warm_time, val=0
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 2026-11-10 17:50:59
DTS_END                         2026-11-10 17:50:59.5320
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(292:30) ==> SP_CUSTOMER_RESERVE(63:5) ==> SP_CHECK_TO_STOP_WORK(35:12) ==> SP_HALT_ON_ERROR(95:17)
IP                              ::1/32804
TRN_ID                          216359
ATT_ID                          439
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 1000

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 50 minutes: 13978.16 1080 698908
customer order: creation 642.68 47 32134
customer order: refuse 51.00 48 2550
order to supplier: creation 163.06 210 8153
order to supplier: removal 11.84 9130 592
invoice (draft): creation 164.00 349 8200
invoice (draft): removal 115.94 147 5797
invoice accept: apply 141.02 1618 7051
invoice accept: cancel 95.82 226 4791
customer reserve: creation 6711.20 29 335560
customer reserve: removal 4914.28 16 245714
realization accept: apply 293.14 36 14657
realization accept: cancel 166.76 20 8338
payment from customer: creation 210.14 33 10507
payment from customer: removal 20.42 19 1021
payment to supplier: creation 173.38 29 8669
payment to supplier: removal 12.58 17 629
service: total inventory turnovers 36.56 467 1828
service: total monetary turnovers 49.96 8 2498
service: aggregate perf. data 4.34 1693 217
service: refresh index statistics 0.04 7453 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:02, from 10-11-2026 17:51:14 to 10-11-2026 17:51:16.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 6709
TEST_TIME 2 8811
TEST_TIME 3 9959
TEST_TIME 4 10651
TEST_TIME 5 11102
TEST_TIME 6 11237
TEST_TIME 7 11523
TEST_TIME 8 11652
TEST_TIME 9 11804
TEST_TIME 10 12066
TEST_TIME 11 12221
TEST_TIME 12 12243
TEST_TIME 13 12367
TEST_TIME 14 12407
TEST_TIME 15 12446
TEST_TIME 16 12402
TEST_TIME 17 12697
TEST_TIME 18 12691
TEST_TIME 19 12755
TEST_TIME 20 12783
TEST_TIME 21 12931
TEST_TIME 22 12954
TEST_TIME 23 12934
TEST_TIME 24 12906
TEST_TIME 25 13024
TEST_TIME 26 13105
TEST_TIME 27 13158
TEST_TIME 28 13101
TEST_TIME 29 13122
TEST_TIME 30 13174
TEST_TIME 31 13167
TEST_TIME 32 13217
TEST_TIME 33 13191
TEST_TIME 34 13289
TEST_TIME 35 13247
TEST_TIME 36 13353
TEST_TIME 37 13359
TEST_TIME 38 13493
TEST_TIME 39 13528
TEST_TIME 40 13641
TEST_TIME 41 13611
TEST_TIME 42 13683
TEST_TIME 43 13731
TEST_TIME 44 13833
TEST_TIME 45 13810
TEST_TIME 46 13835
TEST_TIME 47 13871
TEST_TIME 48 13917
TEST_TIME 49 13962
TEST_TIME 50 13978

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 10-11-2026 17:51:17 to 10-11-2026 17:51:19.

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 1031854 1031854 0 0.00 0 1224 2 0 0
doc_list_biud 1031854 1031854 0 0.00 0 1678 5 0 0
sp_add_invoice_to_stock 7051 7051 0 0.00 4 11950 1618 0 0
sp_cancel_adding_invoice 4791 4791 0 0.00 4 5551 226 0 0
sp_cancel_client_order 2550 2550 0 0.00 3 821 48 0 0
sp_cancel_customer_reserve 245714 245714 0 0.00 1 1679 16 0 0
sp_cancel_pay_from_customer 1021 1021 0 0.00 2 412 19 0 0
sp_cancel_pay_to_supplier 629 629 0 0.00 2 314 17 0 0
sp_cancel_supplier_invoice 5797 5797 0 0.00 2 1013 148 0 0
sp_cancel_supplier_order 592 592 0 0.00 8 51904 9130 0 0
sp_cancel_write_off 8338 8338 0 0.00 1 777 21 0 0
sp_client_order 32134 32134 0 0.00 4 1162 48 0 0
sp_customer_reserve 335560 335560 0 0.00 0 2232 29 0 0
sp_fill_shopping_cart 48487 48487 0 0.00 1 2297 21 0 0
sp_fill_shopping_cart_clo_res 335560 335560 0 0.00 0 936 3 0 0
sp_get_clo_for_invoice 7051 7051 0 0.00 0 1081 36 0 0
sp_kill_cost_storno 14779 14779 0 0.00 0 518 9 0 0
sp_kill_qstorno_ret_qs2qd 506155 506155 0 0.00 0 1559 8 0 0
sp_kill_qty_storno 289490 289490 0 0.00 0 1678 18 0 0
sp_lock_selected_doc 30204 30204 0 0.00 0 595 2 0 0
sp_make_cost_storno 40884 40884 0 0.00 0 722 7 0 0
sp_multiply_rows_for_pdistr 40884 40884 0 0.00 0 796 10 0 0
sp_multiply_rows_for_qdistr 32134 32134 0 0.00 0 929 19 0 0
sp_pay_from_customer 10507 10507 0 0.00 3 965 33 0 0
sp_pay_to_supplier 8669 8669 0 0.00 3 1228 30 0 0
sp_payment_common 19176 19176 0 0.00 1 580 7 0 0
sp_qd_handle_on_cancel_clo 2550 2550 0 0.00 0 816 32 0 0
sp_qd_handle_on_invoice_upd_sts 11842 11842 0 0.00 0 940 71 0 0
sp_qd_handle_on_reserve_upd_sts 14657 14657 0 0.00 0 1082 11 0 0
sp_reserve_write_off 14657 14657 0 0.00 3 1174 36 0 0
sp_supplier_invoice 8200 8200 0 0.00 6 3644 349 0 0
sp_supplier_order 8153 8153 0 0.00 6 1724 210 0 0
srv_aggregate_perf_data 217 217 0 0.00 30 8299 1694 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 1007 273 0 0
srv_find_qd_qs_mism 650259 650259 0 0.00 0 888 1 0 0
srv_make_invnt_saldo 1828 1828 0 0.00 0 79428 468 0 0
srv_make_money_saldo 2498 2498 0 0.00 0 429 9 0 0
srv_recalc_idx_stat 2 2 0 0.00 253 14654 7454 0 0
v_add_invoice_to_stock 14102 14102 0 0.00 0 475 3 0 0
v_all_customers 48966 48966 0 0.00 0 56 1 0 0
v_all_suppliers 39840 39840 0 0.00 0 50 1 0 0
v_all_wares 64268 64268 0 0.00 0 63 1 0 0
v_cancel_adding_invoice 1266 1266 0 0.00 0 92 2 0 0
v_cancel_client_order 5100 5100 0 0.00 0 288 1 0 0
v_cancel_customer_prepayment 2042 2042 0 0.00 0 407 2 0 0
v_cancel_customer_reserve 2118 2118 0 0.00 0 586 2 0 0
v_cancel_payment_to_supplier 1258 1258 0 0.00 0 86 1 0 0
v_cancel_supplier_invoice 1136 1136 0 0.00 0 50 3 0 0
v_cancel_supplier_order 1184 1184 0 0.00 0 150 2 0 0
v_cancel_write_off 2888 2888 0 0.00 0 194 2 0 0
v_max_id_clo_ord 8153 8153 0 0.00 0 102 1 0 0
v_max_id_clo_res 1476 1476 0 0.00 0 147 1 0 0
v_max_id_ord_sup 8200 8200 0 0.00 0 951 2 0 0
v_max_non_paid_invoice 5102 5102 0 0.00 0 105 2 0 0
v_max_non_paid_realizn 10150 10150 0 0.00 0 219 1 0 0
v_min_id_clo_ord 8153 8153 0 0.00 0 415 3 0 0
v_min_id_clo_res 1476 1476 0 0.00 0 506 4 0 0
v_min_id_ord_sup 8200 8200 0 0.00 0 936 5 0 0
v_min_non_paid_invoice 8669 8669 0 0.00 0 347 3 0 0
v_min_non_paid_realizn 10507 10507 0 0.00 0 523 2 0 0
v_our_firm 16016 16016 0 0.00 0 39 1 0 0
v_reserve_write_off 29314 29314 0 0.00 0 519 2 0 0
x_lock_depdocs_on_canc_invoice 10020 10020 0 0.00 0 669 9 0 0
x_lock_depdocs_on_canc_sup_ord 592 592 0 0.00 0 132 11 0 0
x_make_qstorno_1000_1200 8153 8153 0 0.00 1 1698 155 0 0
x_make_qstorno_1200_2000 8200 8200 0 0.00 1 3626 303 0 0
x_make_qstorno_2100_3300 335560 335560 0 0.00 0 2231 25 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 10-11-2026 17:51:19 to 10-11-2026 17:51:23.

Memory consumption, metadata cache, attachments activity

Data in this report:
  page cache memo used            = total size of page cache, 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        = size of cache for metadata, 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: 262144 for all connections, with total size: 2147483648                                                                                                                                                                      

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
17:01:04 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
17:02:04 285 2147483648 2605343200 2691325952 273218832 11.286 20 6 12 0 275857520 745968 1892720
17:03:04 207 2147483648 2603692016 2689560576 271608896 11.227 20 11 16 3 274608304 876080 2123328
17:04:05 623 2147483648 2598635984 2682957824 265675904 11.009 20 10 19 0 267982624 583456 1723264
17:05:06 216 2147483648 2573585248 2653556736 241942176 10.125 19 14 27 0 245223120 1029200 2251744
17:06:06 403 2147483648 2599319664 2686554112 266931376 11.055 20 9 19 0 269680336 1064208 1684752
17:07:07 868 2147483648 2570945232 2652299264 237351280 9.952 19 11 22 0 240972976 1485968 2135728
17:08:09 231 2147483648 2603675648 2690363392 270070672 11.171 20 13 24 0 273274480 1259872 1943936
17:09:09 181 2147483648 2596061552 2682118144 262554592 10.894 20 12 24 0 265979712 1089216 2335904
17:10:10 850 2147483648 2599901648 2688258048 267088336 11.061 20 10 18 0 270150864 1481536 1580992
17:11:11 209 2147483648 2599324624 2687275008 265252672 10.993 20 10 19 0 269424864 2245616 1926576
17:12:11 161 2147483648 2590347360 2674413568 254139280 10.581 20 17 31 0 258672864 1698976 2834608
17:13:12 143 2147483648 2597222112 2683891712 262122304 10.878 20 13 26 1 266755872 1939008 2694560
17:14:12 167 2147483648 2582034000 2668769280 249838064 10.421 19 8 16 0 253094416 1704608 1551744
17:15:13 158 2147483648 2603394272 2691891200 268289360 11.105 20 11 22 0 272964976 2532544 2143072
17:16:13 187 2147483648 2578747744 2663985152 244458064 10.220 19 6 12 0 246384032 1008096 917872
17:17:13 109 2147483648 2597590976 2685702144 263348208 10.923 20 10 18 0 267319520 2536928 1434384
17:18:14 162 2147483648 2605160272 2693341184 267975392 11.094 20 14 27 0 273215472 2288768 2951312
17:19:14 183 2147483648 2600098720 2690297856 266518384 11.040 20 9 19 0 270014816 1681232 1815200
17:20:15 210 2147483648 2589274976 2677239808 255595344 10.636 20 10 20 0 259556112 1989456 1971312
17:21:15 108 2147483648 2587699280 2675134464 254660320 10.601 19 12 23 0 257704912 977312 2067280
17:22:15 157 2147483648 2596932320 2686222336 264652160 10.971 20 5 10 0 266677248 1205744 819344
17:23:16 134 2147483648 2590031984 2678431744 257170080 10.694 20 8 14 0 259597488 994016 1433392
17:24:16 194 2147483648 2595442288 2682552320 262527488 10.893 20 9 16 1 265451792 1289584 1634720
17:25:16 140 2147483648 2608240128 2696855552 271077968 11.208 20 12 24 0 277340064 3851856 2410240
17:26:17 185 2147483648 2600505472 2688425984 262514384 10.892 20 12 23 1 269414160 4933856 1965920
17:27:17 98 2147483648 2600983632 2689507328 266438032 11.037 20 9 16 0 270907232 2423824 2045376
17:28:18 151 2147483648 2586817968 2674049024 253527776 10.559 20 10 17 1 256327104 1193104 1606224
17:29:18 222 2147483648 2598981360 2687246336 263290432 10.921 20 14 28 0 268128000 1983552 2854016
17:30:19 276 2147483648 2601792176 2689445888 265082208 10.987 20 11 22 0 270720288 3404096 2233984
17:31:19 709 2147483648 2604826176 2692595712 269790544 11.160 20 9 18 1 272986576 1592864 1603168
17:32:20 154 2147483648 2605955840 2693013504 271392800 11.219 20 12 25 0 275163632 1344704 2426128
17:33:20 159 2147483648 2600367648 2691301376 267335152 11.070 20 7 14 0 269755056 1151552 1268352
17:34:21 204 2147483648 2604000912 2693312512 267890144 11.091 20 10 20 0 273127328 2910944 2326240
17:35:21 1006 2147483648 2596412896 2686144512 265138224 10.989 20 10 20 0 268309888 1386608 1785056
17:36:24 133 2147483648 2599553248 2687664128 264512336 10.966 20 14 27 0 269149856 1789936 2847584
17:37:25 502 2147483648 2591027280 2677006336 255035568 10.615 20 14 28 0 259307904 1628352 2643984
17:38:25 242 2147483648 2604430176 2693701632 267977200 11.094 20 12 24 1 273212304 2797760 2437344
17:39:26 251 2147483648 2592405840 2681434112 259202144 10.770 20 10 16 0 262755392 1727632 1825616
17:40:27 111 2147483648 2603058784 2694123520 266589968 11.043 20 6 12 0 272499568 4335168 1574432
17:41:27 212 2147483648 2597147040 2685624320 261169088 10.842 20 13 26 0 265574448 1961008 2444352
17:42:28 678 2147483648 2602457808 2691158016 266573216 11.042 20 15 29 0 271684864 2327728 2783920
17:43:29 133 2147483648 2581064512 2667798528 247002160 10.315 19 12 23 0 251245088 1846992 2395936
17:44:29 121 2147483648 2596756048 2686279680 261359984 10.850 20 9 18 0 266168112 2909600 1898528
17:45:29 127 2147483648 2603173824 2691891200 266370816 11.035 20 15 30 0 271820976 2149584 3300576
17:46:30 292 2147483648 2605264848 2696445952 271310336 11.216 20 11 22 0 274491872 1396000 1785536
17:47:30 246 2147483648 2599320432 2689429504 263233584 10.919 20 10 20 0 268641120 3256848 2150688
17:48:31 605 2147483648 2603845392 2692235264 266026832 11.022 20 14 28 0 270302608 1399104 2876672
17:49:31 99 2147483648 2604587344 2695213056 269607136 11.154 20 10 20 0 273404080 1836176 1960768
17:50:32 230 2147483648 2604002560 2694434816 267975456 11.094 20 11 22 0 271798416 1994336 1828624

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 10-11-2026 17:51:24 to 10-11-2026 17:51:38.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE

Completed "Exceptions occured during test was in run". Done for 00:00:01, from 10-11-2026 17:51:38 to 10-11-2026 17:51:39.

Content of mon$database and FB version


MON$DATABASE_NAME               /var/db/oltp-emul/oltp-hq30.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   12
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          214790
MON$OLDEST_ACTIVE               216514
MON$OLDEST_SNAPSHOT             216514
MON$NEXT_TRANSACTION            216514
MON$PAGE_BUFFERS                262144
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               2026-11-10 17:00:10.1060
MON$PAGES                       143104
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.15.33893 Firebird 3.0 HQbird
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.15.33893 Firebird 3.0 HQbird"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.15.33893 Firebird 3.0 HQbird/tcp (test-0)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.15.33893 Firebird 3.0 HQbird/tcp (test-0)/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 ---
:6: 
:7: test-0    Tue Nov 10 17:51:00 2026
:8:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/30300
:9: 
--- end of diff output ---

Final processing ISQL logs in /var/tmp/logs.oltp-hq30 according to config parameter 'remove_isql_logs'

10.11.26 17:51:40. There are 3 logs in /var/tmp/logs.oltp-hq30 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
2026-11-10 17:51:41 No severe PSQL-related problems occured
10.11.26 17:51:42. End of report.