Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 14.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 2w
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 2233468 kB
MemAvailable 7402852 kB
Buffers 81596 kB
Cached 5203484 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-14 17:50:55
DTS_END                         2026-11-14 17:50:55.5410
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/57482
TRN_ID                          230021
ATT_ID                          464
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: 16054.50 963 802725
customer order: creation 683.32 46 34166
customer order: refuse 54.36 47 2718
order to supplier: creation 171.38 210 8569
order to supplier: removal 13.68 8687 684
invoice (draft): creation 171.90 358 8595
invoice (draft): removal 127.10 146 6355
invoice accept: apply 146.10 1624 7305
invoice accept: cancel 105.30 220 5265
customer reserve: creation 7742.70 26 387135
customer reserve: removal 5775.70 14 288785
realization accept: apply 318.76 36 15938
realization accept: cancel 197.24 19 9862
payment from customer: creation 225.64 37 11282
payment from customer: removal 21.88 18 1094
payment to supplier: creation 186.42 30 9321
payment to supplier: removal 12.52 17 626
service: total inventory turnovers 40.68 447 2034
service: total monetary turnovers 54.80 9 2740
service: aggregate perf. data 4.98 2157 249
service: refresh index statistics 0.04 5104 2

Performance in TOTAL, chart


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

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8526
TEST_TIME 2 10650
TEST_TIME 3 11590
TEST_TIME 4 12249
TEST_TIME 5 12564
TEST_TIME 6 12915
TEST_TIME 7 13185
TEST_TIME 8 13483
TEST_TIME 9 13669
TEST_TIME 10 13856
TEST_TIME 11 13858
TEST_TIME 12 14023
TEST_TIME 13 14090
TEST_TIME 14 14216
TEST_TIME 15 14267
TEST_TIME 16 14329
TEST_TIME 17 14521
TEST_TIME 18 14555
TEST_TIME 19 14616
TEST_TIME 20 14619
TEST_TIME 21 14588
TEST_TIME 22 14673
TEST_TIME 23 14729
TEST_TIME 24 14748
TEST_TIME 25 14740
TEST_TIME 26 14829
TEST_TIME 27 14828
TEST_TIME 28 14902
TEST_TIME 29 14995
TEST_TIME 30 15010
TEST_TIME 31 15050
TEST_TIME 32 15153
TEST_TIME 33 15177
TEST_TIME 34 15267
TEST_TIME 35 15371
TEST_TIME 36 15410
TEST_TIME 37 15504
TEST_TIME 38 15571
TEST_TIME 39 15637
TEST_TIME 40 15708
TEST_TIME 41 15751
TEST_TIME 42 15816
TEST_TIME 43 15806
TEST_TIME 44 15768
TEST_TIME 45 15893
TEST_TIME 46 15868
TEST_TIME 47 15913
TEST_TIME 48 16019
TEST_TIME 49 16073
TEST_TIME 50 16054

Performance per minute, chart


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

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 1175795 1175795 0 0.00 0 1375 2 0 0
doc_list_biud 1175795 1175795 0 0.00 0 1584 5 0 0
sp_add_invoice_to_stock 7305 7305 0 0.00 10 14992 1625 0 0
sp_cancel_adding_invoice 5265 5265 0 0.00 2 5211 220 0 0
sp_cancel_client_order 2718 2718 0 0.00 3 764 47 0 0
sp_cancel_customer_reserve 288785 288785 0 0.00 1 1596 15 0 0
sp_cancel_pay_from_customer 1094 1094 0 0.00 2 325 19 0 0
sp_cancel_pay_to_supplier 626 626 0 0.00 2 528 18 0 0
sp_cancel_supplier_invoice 6355 6355 0 0.00 1 1414 147 0 0
sp_cancel_supplier_order 684 684 0 0.00 4 52908 8688 0 0
sp_cancel_write_off 9862 9862 0 0.00 1 730 19 0 0
sp_client_order 34166 34166 0 0.00 4 1112 46 0 0
sp_customer_reserve 387135 387135 0 0.00 0 2557 26 0 0
sp_fill_shopping_cart 51330 51330 0 0.00 1 1774 20 0 0
sp_fill_shopping_cart_clo_res 387135 387135 0 0.00 0 1098 2 0 0
sp_get_clo_for_invoice 7305 7305 0 0.00 0 1053 39 0 0
sp_kill_cost_storno 16847 16847 0 0.00 0 606 9 0 0
sp_kill_qstorno_ret_qs2qd 594471 594471 0 0.00 0 1566 7 0 0
sp_kill_qty_storno 336912 336912 0 0.00 0 1584 17 0 0
sp_lock_selected_doc 32229 32229 0 0.00 0 381 2 0 0
sp_make_cost_storno 43846 43846 0 0.00 0 453 7 0 0
sp_multiply_rows_for_pdistr 43846 43846 0 0.00 0 395 10 0 0
sp_multiply_rows_for_qdistr 34166 34166 0 0.00 0 878 18 0 0
sp_pay_from_customer 11282 11282 0 0.00 3 993 38 0 0
sp_pay_to_supplier 9321 9321 0 0.00 3 494 31 0 0
sp_payment_common 20603 20603 0 0.00 1 428 10 0 0
sp_qd_handle_on_cancel_clo 2718 2718 0 0.00 0 756 31 0 0
sp_qd_handle_on_invoice_upd_sts 12570 12570 0 0.00 0 1144 74 0 0
sp_qd_handle_on_reserve_upd_sts 15938 15938 0 0.00 0 726 10 0 0
sp_reserve_write_off 15938 15938 0 0.00 4 742 36 0 0
sp_supplier_invoice 8595 8595 0 0.00 6 4203 358 0 0
sp_supplier_order 8569 8569 0 0.00 5 2197 211 0 0
srv_aggregate_perf_data 249 249 0 0.00 132 56481 2158 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 1520 276 0 0
srv_find_qd_qs_mism 745192 745192 0 0.00 0 1371 1 0 0
srv_make_invnt_saldo 2034 2034 0 0.00 1 144677 448 0 0
srv_make_money_saldo 2740 2740 0 0.00 0 228 9 0 0
srv_recalc_idx_stat 2 2 0 0.00 205 10004 5105 0 0
v_add_invoice_to_stock 14610 14610 0 0.00 0 578 3 0 0
v_all_customers 52324 52324 0 0.00 0 36 1 0 0
v_all_suppliers 42686 42686 0 0.00 0 37 1 0 0
v_all_wares 68332 68332 0 0.00 0 50 1 0 0
v_cancel_adding_invoice 1236 1236 0 0.00 0 234 2 0 0
v_cancel_client_order 5436 5436 0 0.00 0 270 1 0 0
v_cancel_customer_prepayment 2188 2188 0 0.00 0 101 1 0 0
v_cancel_customer_reserve 2150 2150 0 0.00 0 239 2 0 0
v_cancel_payment_to_supplier 1252 1252 0 0.00 0 525 2 0 0
v_cancel_supplier_invoice 1180 1180 0 0.00 0 92 3 0 0
v_cancel_supplier_order 1368 1368 0 0.00 0 453 2 0 0
v_cancel_write_off 3162 3162 0 0.00 0 246 2 0 0
v_max_id_clo_ord 8569 8569 0 0.00 0 41 1 0 0
v_max_id_clo_res 1599 1599 0 0.00 0 48 1 0 0
v_max_id_ord_sup 8595 8595 0 0.00 0 545 2 0 0
v_max_non_paid_invoice 5142 5142 0 0.00 0 86 2 0 0
v_max_non_paid_realizn 10890 10890 0 0.00 0 204 2 0 0
v_min_id_clo_ord 8569 8569 0 0.00 0 172 3 0 0
v_min_id_clo_res 1599 1599 0 0.00 0 654 4 0 0
v_min_id_ord_sup 8595 8595 0 0.00 0 1138 4 0 0
v_min_non_paid_invoice 9321 9321 0 0.00 0 426 4 0 0
v_min_non_paid_realizn 11282 11282 0 0.00 0 398 6 0 0
v_our_firm 16792 16792 0 0.00 0 40 1 0 0
v_reserve_write_off 31876 31876 0 0.00 0 547 1 0 0
x_lock_depdocs_on_canc_invoice 11030 11030 0 0.00 0 1097 10 0 0
x_lock_depdocs_on_canc_sup_ord 684 684 0 0.00 0 218 11 0 0
x_make_qstorno_1000_1200 8569 8569 0 0.00 1 2098 153 0 0
x_make_qstorno_1200_2000 8595 8595 0 0.00 1 4184 316 0 0
x_make_qstorno_2100_3300 387135 387135 0 0.00 0 2555 22 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 14-11-2026 17:51:12 to 14-11-2026 17:51:16.

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:00:59 1 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
17:01:59 227 2147483648 2583671696 2666950656 239477728 10.032 18 13 26 1 242781424 785264 2518432
17:02:59 226 2147483648 2604208736 2688413696 269762688 11.159 20 11 22 0 273941136 1643488 2534960
17:04:00 218 2147483648 2602688240 2687590400 269653696 11.155 20 14 27 3 273397808 1076832 2667280
17:05:00 187 2147483648 2586652464 2668552192 252322912 10.514 20 14 28 0 256656144 1532336 2800896
17:06:01 146 2147483648 2596651408 2681573376 263457136 10.927 20 14 28 0 267522560 1392400 2673024
17:07:01 211 2147483648 2598583584 2685440000 265699088 11.010 20 7 12 1 268736608 1193248 1844272
17:08:02 210 2147483648 2587740800 2673127424 253982512 10.576 20 10 19 0 257188496 1344016 1861968
17:09:02 165 2147483648 2599755920 2687066112 266292288 11.032 20 11 19 2 269546480 1666192 1588000
17:10:03 331 2147483648 2602328304 2691461120 268163712 11.101 20 8 16 1 271907104 2141200 1602192
17:11:03 207 2147483648 2598737616 2687471616 266530288 11.040 20 6 12 0 269052080 1464160 1057632
17:12:03 192 2147483648 2580107248 2664263680 247360576 10.328 20 10 18 0 250752944 1523936 1868432
17:13:04 178 2147483648 2597446096 2685689856 263495056 10.928 20 10 20 0 268150960 2455792 2200112
17:14:04 298 2147483648 2582859152 2669236224 250306928 10.439 19 10 19 0 254334368 1987136 2040304
17:15:05 514 2147483648 2592735216 2680369152 259995648 10.799 20 8 15 0 263027600 1732176 1299776
17:16:06 311 2147483648 2601493600 2689269760 266460032 11.038 20 14 28 0 271020400 1456864 3103504
17:17:06 125 2147483648 2594073664 2680713216 258611120 10.748 20 11 21 0 263844688 2780624 2452944
17:18:07 95 2147483648 2599087504 2688516096 266291712 11.032 20 9 18 0 269358384 1666112 1400560
17:19:08 182 2147483648 2601595520 2689970176 267305280 11.069 20 13 25 0 271161872 1386528 2470064
17:20:08 153 2147483648 2597500000 2685763584 263156032 10.916 20 10 17 0 267432432 2353824 1922576
17:21:09 132 2147483648 2583412768 2668781568 249993360 10.427 19 13 25 0 254585328 1542080 3049888
17:22:09 209 2147483648 2603691712 2691870720 268322240 11.106 20 15 30 0 273432688 2285728 2824720
17:23:10 208 2147483648 2592923696 2679877632 257620272 10.711 20 11 22 0 262617296 2812384 2184640
17:24:12 183 2147483648 2595057040 2682019840 259877472 10.795 20 12 24 0 264104400 1941184 2285744
17:25:12 180 2147483648 2599176080 2685800448 262971872 10.909 20 15 29 0 267562272 1725824 2864576
17:26:12 159 2147483648 2601141584 2689118208 263144960 10.916 20 11 23 0 269591696 4000688 2446048
17:27:13 309 2147483648 2590027344 2680127488 249482128 10.408 19 6 12 0 251561024 1080368 998528
17:28:13 177 2147483648 2602078192 2688917504 265546240 11.004 20 13 24 1 271014768 2879456 2589072
17:29:14 412 2147483648 2596564816 2686943232 263839840 10.941 20 10 19 0 266806896 1356960 1610096
17:30:15 214 2147483648 2603628112 2691911680 267108992 11.062 20 11 23 0 272708512 3267552 2331968
17:31:15 125 2147483648 2592634400 2679586816 257555600 10.708 20 15 28 0 261844384 1992000 2296784
17:32:16 135 2147483648 2595837920 2682327040 257355040 10.701 20 13 26 0 263798656 3622960 2820656
17:33:16 139 2147483648 2603111984 2691616768 267351312 11.071 20 14 28 1 271709184 1387744 2970128
17:34:16 228 2147483648 2580785440 2666631168 246291296 10.288 19 10 20 0 250188672 1870272 2027104
17:35:17 374 2147483648 2595475968 2684047360 260607168 10.822 20 9 18 0 264642688 2342272 1693248
17:36:18 92 2147483648 2598594720 2688421888 265871632 11.016 20 6 12 0 268432304 1461200 1099472
17:37:18 249 2147483648 2603283376 2691231744 266033040 11.022 20 14 28 0 272388496 3043984 3311472
17:38:19 488 2147483648 2594032320 2683777024 260173472 10.806 20 10 18 0 264032192 1806224 2052496
17:39:19 271 2147483648 2602195120 2693218304 267780992 11.087 20 7 14 0 271521312 1657792 2082528
17:40:20 934 2147483648 2603333648 2692894720 266978576 11.057 20 11 20 0 271883088 2480704 2423808
17:41:21 217 2147483648 2596222352 2684968960 261992944 10.873 20 10 20 1 265408000 1408256 2006800
17:42:21 203 2147483648 2604421760 2692640768 267777808 11.086 20 7 14 0 270017744 1032256 1207680
17:43:22 1520 2147483648 2594558672 2684121088 260601280 10.821 20 9 18 1 264291520 1823296 1866944
17:44:24 735 2147483648 2595374192 2687016960 258643072 10.749 20 5 10 0 264045184 4593552 808560
17:45:24 219 2147483648 2595665648 2683129856 257639936 10.712 20 14 27 0 264756768 4150288 2966544
17:46:26 452 2147483648 2597701472 2690064384 265804352 11.014 20 4 8 0 267554080 1001968 747760
17:47:27 161 2147483648 2599671616 2686521344 264267728 10.957 20 14 28 1 269028864 2160256 2600880
17:48:27 175 2147483648 2601541232 2690449408 266270512 11.031 20 12 21 0 270239664 1983776 1985376
17:49:27 385 2147483648 2608847984 2700476416 268611312 11.117 20 6 12 0 275865456 5987632 1266512
17:50:28 215 2147483648 2597265216 2685681664 261352624 10.849 20 15 27 1 266132304 2178272 2601408

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


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

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 14-11-2026 17:51:29 to 14-11-2026 17:51:30.

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          229531
MON$OLDEST_ACTIVE               230481
MON$OLDEST_SNAPSHOT             230481
MON$NEXT_TRANSACTION            230481
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-14 17:00:08.8210
MON$PAGES                       160512
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    Sat Nov 14 17:50:56 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'

14.11.26 17:51:31. 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-14 17:51:32 No severe PSQL-related problems occured
14.11.26 17:51:32. End of report.