Generated by /mnt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 20. 13.11.2026 23: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 6d
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 1718188 kB
MemAvailable 7268548 kB
Buffers 82052 kB
Cached 5586784 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-13 23:51:02
DTS_END                         2026-11-13 23:51:02.4000
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/49096
TRN_ID                          197086
ATT_ID                          410
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: 12133.04 875 606652
customer order: creation 585.44 55 29272
customer order: refuse 47.70 50 2385
order to supplier: creation 146.80 231 7340
order to supplier: removal 11.04 9000 552
invoice (draft): creation 145.56 377 7278
invoice (draft): removal 104.44 151 5222
invoice accept: apply 124.68 1722 6234
invoice accept: cancel 86.40 227 4320
customer reserve: creation 5734.02 32 286701
customer reserve: removal 4264.94 17 213247
realization accept: apply 269.52 41 13476
realization accept: cancel 148.06 23 7403
payment from customer: creation 192.86 38 9643
payment from customer: removal 18.98 20 949
payment to supplier: creation 158.46 33 7923
payment to supplier: removal 11.44 19 572
service: total inventory turnovers 31.98 584 1599
service: total monetary turnovers 46.42 8 2321
service: aggregate perf. data 4.26 1845 213
service: refresh index statistics 0.04 3033 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 13-11-2026 23:51:17 to 13-11-2026 23:51:18.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 15588
TEST_TIME 2 13159
TEST_TIME 3 12115
TEST_TIME 4 11562
TEST_TIME 5 11536
TEST_TIME 6 11341
TEST_TIME 7 11426
TEST_TIME 8 11269
TEST_TIME 9 11128
TEST_TIME 10 11092
TEST_TIME 11 11066
TEST_TIME 12 11131
TEST_TIME 13 11189
TEST_TIME 14 11216
TEST_TIME 15 11318
TEST_TIME 16 11356
TEST_TIME 17 11308
TEST_TIME 18 11339
TEST_TIME 19 11318
TEST_TIME 20 11343
TEST_TIME 21 11290
TEST_TIME 22 11306
TEST_TIME 23 11303
TEST_TIME 24 11305
TEST_TIME 25 11340
TEST_TIME 26 11359
TEST_TIME 27 11321
TEST_TIME 28 11408
TEST_TIME 29 11477
TEST_TIME 30 11597
TEST_TIME 31 11596
TEST_TIME 32 11659
TEST_TIME 33 11684
TEST_TIME 34 11640
TEST_TIME 35 11721
TEST_TIME 36 11732
TEST_TIME 37 11916
TEST_TIME 38 11890
TEST_TIME 39 11944
TEST_TIME 40 11943
TEST_TIME 41 11859
TEST_TIME 42 11894
TEST_TIME 43 11996
TEST_TIME 44 12043
TEST_TIME 45 12057
TEST_TIME 46 12207
TEST_TIME 47 12247
TEST_TIME 48 12322
TEST_TIME 49 12368
TEST_TIME 50 12133

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:02, from 13-11-2026 23:51:19 to 13-11-2026 23:51:21.

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 892788 892788 0 0.00 0 1114 2 0 0
doc_list_biud 892788 892788 0 0.00 0 1809 6 0 0
sp_add_invoice_to_stock 6234 6234 0 0.00 6 16570 1722 0 0
sp_cancel_adding_invoice 4320 4320 0 0.00 3 4578 227 0 0
sp_cancel_client_order 2385 2385 0 0.00 3 752 51 0 0
sp_cancel_customer_reserve 213247 213247 0 0.00 1 1811 17 0 0
sp_cancel_pay_from_customer 949 949 0 0.00 2 286 21 0 0
sp_cancel_pay_to_supplier 572 572 0 0.00 2 289 20 0 0
sp_cancel_supplier_invoice 5222 5222 0 0.00 1 1475 152 0 0
sp_cancel_supplier_order 552 552 0 0.00 6 50361 9000 0 0
sp_cancel_write_off 7403 7403 0 0.00 1 945 23 0 0
sp_client_order 29272 29272 0 0.00 4 1436 55 0 0
sp_customer_reserve 286701 286701 0 0.00 0 4014 32 0 0
sp_fill_shopping_cart 43890 43890 0 0.00 1 1956 21 0 0
sp_fill_shopping_cart_clo_res 286701 286701 0 0.00 0 1345 3 0 0
sp_get_clo_for_invoice 6234 6234 0 0.00 0 1186 37 0 0
sp_kill_cost_storno 13244 13244 0 0.00 0 859 10 0 0
sp_kill_qstorno_ret_qs2qd 439671 439671 0 0.00 0 1619 9 0 0
sp_kill_qty_storno 252839 252839 0 0.00 0 1809 20 0 0
sp_lock_selected_doc 27545 27545 0 0.00 0 237 2 0 0
sp_make_cost_storno 37276 37276 0 0.00 0 769 8 0 0
sp_multiply_rows_for_pdistr 37276 37276 0 0.00 0 631 11 0 0
sp_multiply_rows_for_qdistr 29272 29272 0 0.00 0 1230 22 0 0
sp_pay_from_customer 9643 9643 0 0.00 3 979 38 0 0
sp_pay_to_supplier 7923 7923 0 0.00 3 694 34 0 0
sp_payment_common 17566 17566 0 0.00 1 497 8 0 0
sp_qd_handle_on_cancel_clo 2385 2385 0 0.00 0 748 33 0 0
sp_qd_handle_on_invoice_upd_sts 10554 10554 0 0.00 0 1247 74 0 0
sp_qd_handle_on_reserve_upd_sts 13476 13476 0 0.00 0 1126 13 0 0
sp_reserve_write_off 13476 13476 0 0.00 3 1136 42 0 0
sp_supplier_invoice 7278 7278 0 0.00 6 3771 378 0 0
sp_supplier_order 7340 7340 0 0.00 6 2451 231 0 0
srv_aggregate_perf_data 213 213 0 0.00 73 43461 1845 0 0
srv_fill_mon_cache_memory 50 50 0 0.00 3 1309 310 0 0
srv_find_qd_qs_mism 563270 563270 0 0.00 0 1099 2 0 0
srv_make_invnt_saldo 1599 1599 0 0.00 0 48408 584 0 0
srv_make_money_saldo 2321 2321 0 0.00 0 175 9 0 0
srv_recalc_idx_stat 2 2 0 0.00 263 5803 3033 0 0
v_add_invoice_to_stock 12468 12468 0 0.00 0 611 3 0 0
v_all_customers 44912 44912 0 0.00 0 60 1 0 0
v_all_suppliers 35810 35810 0 0.00 0 46 1 0 0
v_all_wares 58544 58544 0 0.00 0 51 1 0 0
v_cancel_adding_invoice 1110 1110 0 0.00 0 250 2 0 0
v_cancel_client_order 4770 4770 0 0.00 0 564 2 0 0
v_cancel_customer_prepayment 1898 1898 0 0.00 0 282 2 0 0
v_cancel_customer_reserve 1946 1946 0 0.00 0 267 2 0 0
v_cancel_payment_to_supplier 1144 1144 0 0.00 0 270 2 0 0
v_cancel_supplier_invoice 1030 1030 0 0.00 0 112 3 0 0
v_cancel_supplier_order 1104 1104 0 0.00 0 132 2 0 0
v_cancel_write_off 2668 2668 0 0.00 0 517 2 0 0
v_max_id_clo_ord 7340 7340 0 0.00 0 85 1 0 0
v_max_id_clo_res 1343 1343 0 0.00 0 96 2 0 0
v_max_id_ord_sup 7278 7278 0 0.00 0 779 2 0 0
v_max_non_paid_invoice 4636 4636 0 0.00 0 38 2 0 0
v_max_non_paid_realizn 9167 9167 0 0.00 0 83 2 0 0
v_min_id_clo_ord 7340 7340 0 0.00 0 270 3 0 0
v_min_id_clo_res 1343 1343 0 0.00 0 479 7 0 0
v_min_id_ord_sup 7278 7278 0 0.00 0 954 6 0 0
v_min_non_paid_invoice 7923 7923 0 0.00 0 491 3 0 0
v_min_non_paid_realizn 9643 9643 0 0.00 0 378 3 0 0
v_our_firm 14584 14584 0 0.00 0 61 1 0 0
v_reserve_write_off 26952 26952 0 0.00 0 716 2 0 0
x_lock_depdocs_on_canc_invoice 9027 9027 0 0.00 0 1360 10 0 0
x_lock_depdocs_on_canc_sup_ord 552 552 0 0.00 0 180 11 0 0
x_make_qstorno_1000_1200 7340 7340 0 0.00 1 2416 177 0 0
x_make_qstorno_1200_2000 7278 7278 0 0.00 1 3752 329 0 0
x_make_qstorno_2100_3300 286701 286701 0 0.00 0 4012 28 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 13-11-2026 23:51:22 to 13-11-2026 23:51:26.

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
23:01:06 3 2147483648 2318244288 2325499904 3922944 0.182 1 1 2 0 4021632 55888 42800
23:02:06 187 2147483648 2604699344 2691657728 273543248 11.298 20 9 13 0 275401616 660224 1198144
23:03:07 171 2147483648 2601615792 2687135744 269152528 11.137 20 9 19 0 271879808 875120 1852160
23:04:07 125 2147483648 2577509616 2661302272 246830080 10.309 20 6 12 1 248504128 782128 891920
23:05:07 239 2147483648 2603846080 2691067904 272259760 11.251 20 10 20 0 274973024 1066144 1647120
23:06:08 137 2147483648 2582595520 2666037248 250597712 10.449 20 8 14 0 253062976 749392 1715872
23:07:08 603 2147483648 2604809856 2692313088 272425440 11.257 20 8 15 0 274806416 819552 1561424
23:08:09 208 2147483648 2588898352 2674880512 257180368 10.695 20 5 10 0 259065936 1048448 837120
23:09:10 515 2147483648 2601745424 2689355776 269523104 11.151 20 9 18 2 272280416 967360 1789952
23:10:11 109 2147483648 2596134144 2681860096 261628080 10.859 20 14 26 0 265624448 1459136 2537232
23:11:11 195 2147483648 2591123888 2678820864 256449088 10.667 20 9 18 0 263381856 4136384 2796384
23:12:11 675 2147483648 2587073600 2672775168 250937472 10.462 19 9 18 0 254319008 1645952 1735584
23:13:13 190 2147483648 2600672544 2687733760 265433968 11.000 20 14 27 0 269568912 1462112 2672832
23:14:13 386 2147483648 2587320112 2672463872 253382880 10.553 20 12 24 0 257325296 1718864 2223552
23:15:14 218 2147483648 2597227504 2683416576 262974704 10.909 20 11 20 0 267087744 1637552 2475488
23:16:15 413 2147483648 2594933456 2682044416 260944480 10.834 20 12 23 0 264390864 1445616 2000768
23:17:16 308 2147483648 2599285472 2687209472 264466720 10.964 20 13 26 0 269545840 2496432 2582688
23:18:16 441 2147483648 2604859184 2694356992 271608496 11.227 20 10 18 1 274821824 860096 2353232
23:19:17 94 2147483648 2589357152 2675499008 255112256 10.618 20 12 25 0 258996720 1611664 2272800
23:20:17 216 2147483648 2586908816 2675130368 255601104 10.636 20 8 15 0 258400672 953696 1845872
23:21:18 157 2147483648 2597032464 2684715008 262012768 10.874 20 11 22 0 266050880 1720976 2317136
23:22:19 182 2147483648 2583406128 2668716032 248156976 10.358 19 10 20 0 251701344 1416160 2128208
23:23:19 158 2147483648 2598157808 2686287872 265025344 10.985 20 8 16 0 267790624 1110864 1654416
23:24:19 211 2147483648 2595886304 2682904576 261494688 10.855 20 11 21 0 264757856 1244032 2019136
23:25:20 610 2147483648 2596383728 2682695680 261312096 10.848 20 13 28 0 265843104 1516592 3014416
23:26:21 192 2147483648 2603146064 2690740224 266546016 11.041 20 9 18 0 272964384 4250944 2167424
23:27:22 235 2147483648 2602252448 2692325376 267637792 11.081 20 8 16 0 270701792 1325008 1738992
23:28:22 589 2147483648 2594882336 2683813888 261047056 10.838 20 10 20 1 264634224 1728192 1858976
23:29:23 380 2147483648 2594828000 2681593856 259277472 10.772 20 13 25 0 263831680 2391248 2162960
23:30:24 91 2147483648 2601590544 2689056768 264636224 10.971 20 13 26 0 270789888 3522048 2631616
23:31:25 107 2147483648 2609188528 2698502144 273699568 11.304 20 11 22 0 278139904 2406656 2033680
23:32:25 112 2147483648 2578909568 2663849984 244361904 10.216 19 12 23 0 248262560 1642384 2258272
23:33:25 243 2147483648 2599810128 2687676416 265984288 11.020 20 10 20 1 269108016 1196096 1927632
23:34:26 727 2147483648 2601564112 2692177920 267928368 11.092 20 6 13 0 271033728 2040608 1064752
23:35:27 267 2147483648 2589983168 2678677504 257346912 10.701 20 12 24 0 261270864 1257408 2666544
23:36:28 91 2147483648 2598527424 2686808064 263846816 10.941 20 12 24 0 267502320 1752432 1903072
23:37:28 200 2147483648 2599737536 2689245184 264808448 10.977 20 13 26 0 269585904 1741392 3036064
23:38:29 138 2147483648 2604620128 2694156288 268169520 11.101 20 13 22 0 273766896 3418336 2179040
23:39:29 1295 2147483648 2593505552 2684231680 261786080 10.865 20 4 8 0 263714448 1312384 615984
23:40:31 122 2147483648 2600890208 2689695744 266220000 11.029 20 9 18 0 269653664 1413264 2020400
23:41:31 246 2147483648 2598758272 2688643072 264550352 10.967 20 6 12 0 267997520 2134368 1312800
23:42:32 337 2147483648 2594117760 2685026304 262195360 10.880 20 5 10 0 264044784 1125216 724208
23:43:32 286 2147483648 2597711760 2687586304 264212496 10.955 20 6 12 0 267399424 2084320 1102608
23:44:33 1308 2147483648 2605168624 2694062080 268690464 11.120 20 11 22 0 272747392 1975872 2081056
23:45:36 176 2147483648 2594865152 2682814464 259772672 10.791 20 10 20 0 264212928 2309152 2131104
23:46:36 368 2147483648 2594775632 2682806272 259317552 10.774 20 9 18 0 264110000 2800080 1992368
23:47:38 185 2147483648 2605423344 2693898240 267614480 11.080 20 11 22 0 274039200 4173168 2251552
23:48:39 435 2147483648 2607458448 2697703424 271025728 11.206 20 11 22 0 276155312 2901232 2228352
23:49:39 161 2147483648 2594657232 2685353984 261331072 10.848 20 7 14 0 264893984 2204016 1358896
23:50:40 208 2147483648 2595936448 2686619648 263594720 10.932 20 6 12 0 266005968 1271328 1139920

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:12, from 13-11-2026 23:51:27 to 13-11-2026 23:51:39.

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 13-11-2026 23:51:40 to 13-11-2026 23:51:41.

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          195951
MON$OLDEST_ACTIVE               197331
MON$OLDEST_SNAPSHOT             197331
MON$NEXT_TRANSACTION            197331
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-13 23:00:10.1260
MON$PAGES                       126176
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'

13.11.26 23:51:41. 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-13 23:51:43 No severe PSQL-related problems occured
13.11.26 23:51:43. End of report.