Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 10.11.2026 05: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 2036052 kB
MemAvailable 7316020 kB
Buffers 79420 kB
Cached 5325908 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 05:50:55
DTS_END                         2026-11-10 05:50:55.6250
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/40970
TRN_ID                          233065
ATT_ID                          481
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: 15299.34 834 764967
customer order: creation 691.62 45 34581
customer order: refuse 56.44 49 2822
order to supplier: creation 174.22 205 8711
order to supplier: removal 12.32 9310 616
invoice (draft): creation 175.16 341 8758
invoice (draft): removal 122.16 152 6108
invoice accept: apply 151.04 1571 7552
invoice accept: cancel 101.48 220 5074
customer reserve: creation 7398.14 27 369907
customer reserve: removal 5355.18 15 267759
realization accept: apply 325.40 39 16270
realization accept: cancel 187.76 20 9388
payment from customer: creation 228.68 32 11434
payment from customer: removal 20.36 18 1018
payment to supplier: creation 186.86 29 9343
payment to supplier: removal 12.92 18 646
service: total inventory turnovers 40.18 436 2009
service: total monetary turnovers 54.42 8 2721
service: aggregate perf. data 4.96 1857 248
service: refresh index statistics 0.04 2294 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 10-11-2026 05:51:10 to 10-11-2026 05:51:11.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 8995
TEST_TIME 2 10657
TEST_TIME 3 11926
TEST_TIME 4 12177
TEST_TIME 5 12568
TEST_TIME 6 12748
TEST_TIME 7 13004
TEST_TIME 8 13230
TEST_TIME 9 13239
TEST_TIME 10 13449
TEST_TIME 11 13552
TEST_TIME 12 13600
TEST_TIME 13 13633
TEST_TIME 14 13752
TEST_TIME 15 13777
TEST_TIME 16 13827
TEST_TIME 17 13926
TEST_TIME 18 13966
TEST_TIME 19 14025
TEST_TIME 20 14142
TEST_TIME 21 14035
TEST_TIME 22 14099
TEST_TIME 23 14145
TEST_TIME 24 14102
TEST_TIME 25 14278
TEST_TIME 26 14329
TEST_TIME 27 14409
TEST_TIME 28 14367
TEST_TIME 29 14451
TEST_TIME 30 14379
TEST_TIME 31 14387
TEST_TIME 32 14485
TEST_TIME 33 14531
TEST_TIME 34 14581
TEST_TIME 35 14637
TEST_TIME 36 14813
TEST_TIME 37 14785
TEST_TIME 38 14863
TEST_TIME 39 14851
TEST_TIME 40 14891
TEST_TIME 41 14959
TEST_TIME 42 15000
TEST_TIME 43 14996
TEST_TIME 44 15070
TEST_TIME 45 15051
TEST_TIME 46 15117
TEST_TIME 47 15155
TEST_TIME 48 15261
TEST_TIME 49 15268
TEST_TIME 50 15299

Performance per minute, chart


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

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 1129286 1129286 0 0.00 0 1057 2 0 0
doc_list_biud 1129286 1129286 0 0.00 0 1410 5 0 0
sp_add_invoice_to_stock 7552 7552 0 0.00 10 13827 1571 0 0
sp_cancel_adding_invoice 5074 5074 0 0.00 3 5746 221 0 0
sp_cancel_client_order 2822 2822 0 0.00 3 1137 49 0 0
sp_cancel_customer_reserve 267759 267759 0 0.00 1 1412 15 0 0
sp_cancel_pay_from_customer 1018 1018 0 0.00 2 194 19 0 0
sp_cancel_pay_to_supplier 646 646 0 0.00 2 240 19 0 0
sp_cancel_supplier_invoice 6108 6108 0 0.00 2 1214 152 0 0
sp_cancel_supplier_order 616 616 0 0.00 10 50374 9311 0 0
sp_cancel_write_off 9388 9388 0 0.00 1 758 21 0 0
sp_client_order 34581 34581 0 0.00 4 1593 45 0 0
sp_customer_reserve 369907 369907 0 0.00 0 2286 27 0 0
sp_fill_shopping_cart 52050 52050 0 0.00 1 1583 20 0 0
sp_fill_shopping_cart_clo_res 369907 369907 0 0.00 0 1009 2 0 0
sp_get_clo_for_invoice 7552 7552 0 0.00 0 1448 38 0 0
sp_kill_cost_storno 16126 16126 0 0.00 0 864 10 0 0
sp_kill_qstorno_ret_qs2qd 551630 551630 0 0.00 0 1279 8 0 0
sp_kill_qty_storno 315589 315589 0 0.00 0 1409 18 0 0
sp_lock_selected_doc 32787 32787 0 0.00 0 275 2 0 0
sp_make_cost_storno 44599 44599 0 0.00 0 761 7 0 0
sp_multiply_rows_for_pdistr 44599 44599 0 0.00 0 1027 10 0 0
sp_multiply_rows_for_qdistr 34581 34581 0 0.00 0 1035 17 0 0
sp_pay_from_customer 11434 11434 0 0.00 3 589 33 0 0
sp_pay_to_supplier 9343 9343 0 0.00 3 1078 30 0 0
sp_payment_common 20777 20777 0 0.00 1 478 7 0 0
sp_qd_handle_on_cancel_clo 2822 2822 0 0.00 0 1134 32 0 0
sp_qd_handle_on_invoice_upd_sts 12626 12626 0 0.00 0 1040 71 0 0
sp_qd_handle_on_reserve_upd_sts 16270 16270 0 0.00 0 994 10 0 0
sp_reserve_write_off 16270 16270 0 0.00 3 1134 39 0 0
sp_supplier_invoice 8758 8758 0 0.00 5 3683 342 0 0
sp_supplier_order 8711 8711 0 0.00 4 1786 205 0 0
srv_aggregate_perf_data 248 248 0 0.00 70 12000 1858 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 2 1471 251 0 0
srv_find_qd_qs_mism 711217 711217 0 0.00 0 1057 1 0 0
srv_make_invnt_saldo 2009 2009 0 0.00 1 54834 436 0 0
srv_make_money_saldo 2721 2721 0 0.00 0 181 8 0 0
srv_recalc_idx_stat 2 2 0 0.00 263 4326 2295 0 0
v_add_invoice_to_stock 15104 15104 0 0.00 0 494 3 0 0
v_all_customers 52754 52754 0 0.00 0 37 1 0 0
v_all_suppliers 42778 42778 0 0.00 0 51 1 0 0
v_all_wares 69162 69162 0 0.00 0 37 1 0 0
v_cancel_adding_invoice 1158 1158 0 0.00 0 55 2 0 0
v_cancel_client_order 5644 5644 0 0.00 0 226 1 0 0
v_cancel_customer_prepayment 2036 2036 0 0.00 0 55 1 0 0
v_cancel_customer_reserve 2214 2214 0 0.00 0 342 2 0 0
v_cancel_payment_to_supplier 1292 1292 0 0.00 0 141 2 0 0
v_cancel_supplier_invoice 1148 1148 0 0.00 0 168 3 0 0
v_cancel_supplier_order 1232 1232 0 0.00 0 27 1 0 0
v_cancel_write_off 3206 3206 0 0.00 0 637 2 0 0
v_max_id_clo_ord 8711 8711 0 0.00 0 128 1 0 0
v_max_id_clo_res 1568 1568 0 0.00 0 109 1 0 0
v_max_id_ord_sup 8758 8758 0 0.00 0 287 2 0 0
v_max_non_paid_invoice 5423 5423 0 0.00 0 162 2 0 0
v_max_non_paid_realizn 11021 11021 0 0.00 0 54 2 0 0
v_min_id_clo_ord 8711 8711 0 0.00 0 256 3 0 0
v_min_id_clo_res 1568 1568 0 0.00 0 427 3 0 0
v_min_id_ord_sup 8758 8758 0 0.00 0 1026 4 0 0
v_min_non_paid_invoice 9343 9343 0 0.00 0 474 3 0 0
v_min_non_paid_realizn 11434 11434 0 0.00 0 453 2 0 0
v_our_firm 17234 17234 0 0.00 0 34 1 0 0
v_reserve_write_off 32540 32540 0 0.00 0 1120 1 0 0
x_lock_depdocs_on_canc_invoice 10608 10608 0 0.00 0 1681 10 0 0
x_lock_depdocs_on_canc_sup_ord 616 616 0 0.00 0 280 12 0 0
x_make_qstorno_1000_1200 8711 8711 0 0.00 1 1591 147 0 0
x_make_qstorno_1200_2000 8758 8758 0 0.00 1 3625 298 0 0
x_make_qstorno_2100_3300 369907 369907 0 0.00 0 2277 23 0 0

Completed "Performance in DETAILS". Done for 00:00:03, from 10-11-2026 05:51:15 to 10-11-2026 05:51:18.

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
05:00:59 2 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
05:01:59 203 2147483648 2592891568 2675924992 259806096 10.792 20 13 28 2 262672896 685104 2181696
05:02:59 172 2147483648 2588958928 2670694400 255239088 10.622 19 14 24 0 259175712 1187792 2748832
05:04:00 253 2147483648 2599765376 2687590400 268939280 11.129 20 6 11 0 270624752 624464 1061008
05:05:00 157 2147483648 2594965344 2680455168 262862912 10.905 20 7 14 0 265550672 1259776 1427984
05:06:01 241 2147483648 2587585840 2673246208 256095776 10.654 20 7 14 0 258877552 1225056 1556720
05:07:01 166 2147483648 2591953984 2676117504 258342576 10.738 20 10 19 0 262615568 2036416 2236576
05:08:02 272 2147483648 2594205056 2681446400 261875360 10.869 20 9 19 0 264902672 1249680 1777632
05:09:02 149 2147483648 2583421200 2666098688 248253232 10.362 19 14 28 1 253210176 1821456 3135488
05:10:02 181 2147483648 2586017648 2677112832 247292304 10.326 19 9 18 0 250788864 1472256 2024304
05:11:03 140 2147483648 2596700064 2683400192 262830944 10.904 20 12 25 1 267037312 2098912 2107456
05:12:03 254 2147483648 2604102704 2691817472 270045840 11.170 20 12 25 0 274162976 1544240 2572896
05:13:04 228 2147483648 2589090880 2673651712 254026752 10.577 19 12 24 0 258892512 2474320 2391440
05:14:06 99 2147483648 2608669568 2697564160 271669536 11.229 20 11 24 0 278296464 4119648 2507280
05:15:06 143 2147483648 2604942688 2692026368 266656736 11.045 20 14 28 0 274871264 5186992 3027536
05:16:07 177 2147483648 2596044048 2683625472 261678496 10.861 20 14 26 0 265092736 1102816 2311424
05:17:07 136 2147483648 2601683712 2690879488 268529728 11.114 20 8 16 0 271499824 1417728 1552368
05:18:08 332 2147483648 2591495904 2678571008 258193632 10.732 20 12 24 0 262464560 1481472 2789456
05:19:08 170 2147483648 2604253024 2690707456 266791696 11.050 20 15 30 0 273084112 3333552 2958864
05:20:10 188 2147483648 2598921616 2685526016 261907888 10.870 20 15 30 1 267377456 1738256 3731312
05:21:10 183 2147483648 2593023472 2681036800 259234800 10.771 20 12 24 0 263285808 1306496 2744512
05:22:11 173 2147483648 2602370272 2692050944 267365856 11.071 20 9 19 0 271441392 2559984 1515552
05:23:11 257 2147483648 2602404736 2690838528 267288080 11.068 20 12 25 0 271274016 1158320 2827616
05:24:12 128 2147483648 2594372896 2681131008 258485008 10.743 20 9 18 0 262278688 1382288 2411392
05:25:14 175 2147483648 2605787168 2691727360 269227376 11.140 20 17 35 0 275131936 2711680 3192880
05:26:14 566 2147483648 2592235008 2681643008 258677056 10.750 20 7 14 0 261914224 1650960 1586208
05:27:16 171 2147483648 2600432656 2689310720 265665408 11.009 20 10 20 1 269293600 1501120 2127072
05:28:16 84 2147483648 2601741840 2690236416 267200128 11.065 20 9 18 0 270539488 1656816 1682544
05:29:16 383 2147483648 2601008768 2691485696 265643616 11.008 20 9 16 0 271801936 4375088 1783232
05:30:17 309 2147483648 2583646576 2670600192 251422032 10.480 19 9 18 0 254588304 1147616 2018656
05:31:17 178 2147483648 2601176800 2688126976 265212272 10.992 20 13 26 0 270121488 2473568 2435648
05:32:18 390 2147483648 2598189040 2684788736 261142720 10.841 20 15 30 0 265954304 2177872 2633712
05:33:19 162 2147483648 2596650064 2685116416 261399104 10.851 20 11 22 1 265670800 1538176 2733520
05:34:20 186 2147483648 2601077904 2688782336 263120800 10.915 20 14 27 0 267890992 1990432 2779760
05:35:20 339 2147483648 2600528624 2689437696 264909120 10.981 20 13 27 0 269597136 1918736 2769280
05:36:20 264 2147483648 2601751616 2689634304 263873360 10.942 20 11 22 0 270571552 4091552 2606640
05:37:21 147 2147483648 2596226160 2686779392 262702240 10.899 20 6 13 0 264712096 1015488 994368
05:38:22 391 2147483648 2600182672 2690482176 266151072 11.026 20 9 16 0 269541072 1829920 1560080
05:39:23 232 2147483648 2594267840 2683154432 259722384 10.789 20 11 22 0 263146720 1349456 2074880
05:40:23 93 2147483648 2592966624 2679955456 256761536 10.679 20 14 28 0 261162704 1597552 2803616
05:41:23 233 2147483648 2599648512 2687275008 262134944 10.878 20 11 22 1 268211248 3973600 2102704
05:42:24 117 2147483648 2598214464 2687651840 264019936 10.948 20 10 19 2 267172704 1154400 1998368
05:43:24 215 2147483648 2592410320 2683559936 260025632 10.800 20 5 10 0 261974304 1140272 808400
05:44:24 1471 2147483648 2608516992 2697338880 270085200 11.171 20 15 30 0 275946576 2544032 3317344
05:45:27 237 2147483648 2594458544 2682556416 260215232 10.807 20 13 26 0 264024688 1542656 2266800
05:46:27 293 2147483648 2585562496 2674180096 252446224 10.518 20 5 10 0 254640496 1359856 834416
05:47:27 674 2147483648 2605381920 2692677632 268535248 11.114 20 15 30 0 273301312 1796672 2969392
05:48:28 265 2147483648 2585522736 2669850624 247016144 10.315 19 12 23 0 253225008 3912704 2296160
05:49:29 255 2147483648 2597618768 2685833216 261969408 10.872 20 14 29 0 265869328 1845152 2054768
05:50:29 124 2147483648 2601423024 2690486272 264246944 10.956 20 12 24 0 269494288 2835744 2411600

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:12, from 10-11-2026 05:51:19 to 10-11-2026 05:51:31.

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 05:51:32 to 10-11-2026 05:51:33.

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          231750
MON$OLDEST_ACTIVE               233281
MON$OLDEST_SNAPSHOT             233281
MON$NEXT_TRANSACTION            233281
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 05:00:09.1620
MON$PAGES                       149760
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 ---
--- end of diff output ---

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

10.11.26 05:51:33. 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 05:51:34 No severe PSQL-related problems occured
10.11.26 05:51:35. End of report.