Generated by /opt/oltp-emul/src/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 35. 20.04.2026 05:43
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 qa-test
Icon name computer-vm
Chassis vm 🖴
Machine ID daf74ba48b9144e6be6ad3de610736b0
Boot ID 32cdb01f987d4d7ea5582a2dc3adcc1f
Product UUID daf74ba4-8b91-44e6-be6a-d3de610736b0
AF_VSOCK CID 1
Virtualization kvm
Operating System Debian GNU/Linux 13 (trixie)
Kernel Linux 6.12.74+deb13+1-amd64
Architecture x86-64
Hardware Vendor Selectel
Hardware Model OpenStack Nova
Hardware Serial daf74ba4-8b91-44e6-be6a-d3de610736b0
Firmware Version 1.15.0-1
Firmware Date Tue 2014-04-01
Firmware Age 12y 2w 5d
Command: who -b
bootup_info system boot 2026-04-04 08:16
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) Silver 4214R CPU @ 2.40GHz
CPU family 6
Model 85
Thread(s) per core 1
Core(s) per socket 1
Socket(s) 4
Stepping 7
BogoMIPS 4800.00
Virtualization VT-x
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 Unknown: Dependent on hypervisor status
Vulnerability Indirect target selection Mitigation; Aligned branch/return thunks
Vulnerability Itlb multihit Not affected
Vulnerability L1tf Not affected
Vulnerability Mds Not affected
Vulnerability Meltdown Not affected
Vulnerability Mmio stale data Vulnerable: Clear CPU buffers attempted, no microcode; SMT Host state unknown
Vulnerability Reg file data sampling Not affected
Vulnerability Retbleed Mitigation; Enhanced IBRS
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; Enhanced / Automatic IBRS; IBPB conditional; PBRSB-eIBRS SW sequence; BHI SW loop, KVM SW loop
Vulnerability Srbds Not affected
Vulnerability Tsa Not affected
Vulnerability Tsx async abort Mitigation; TSX disabled
Vulnerability Vmscape Not affected
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 8138028 kB
MemFree 2486368 kB
MemAvailable 7467220 kB
Buffers 89868 kB
Cached 5027364 kB
SwapCached 12 kB
Command: fdisk -l
./oltp_isql_run_worker.sh: line 54: fdisk: command not found

Server and database settinfs 

Statement failed, SQLSTATE = 08006
Unable to complete network request to host "localhost".
-Failed to establish a connection.
After line 0 in file /var/tmp/logs.oltp-hq30/oltp30_qa-test-0001.performance_report.tmp

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=qa-test
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=/opt/oltp-emul/data/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=55
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 

Statement failed, SQLSTATE = 08006
Unable to complete network request to host "localhost".
-Failed to establish a connection.
After line 0 in file /var/tmp/logs.oltp-hq30/oltp30_qa-test-0001.performance_report.tmp

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 55 minutes: 9650.78 1341 530793
customer order: creation 604.87 82 33268
customer order: refuse 48.44 63 2664
order to supplier: creation 152.75 407 8401
order to supplier: removal 11.05 10271 608
invoice (draft): creation 153.27 636 8430
invoice (draft): removal 92.87 247 5108
invoice accept: apply 128.40 2066 7062
invoice accept: cancel 74.71 366 4109
customer reserve: creation 4572.98 49 251514
customer reserve: removal 2931.18 27 161215
realization accept: apply 279.69 59 15383
realization accept: cancel 138.04 34 7592
payment from customer: creation 201.16 65 11064
payment from customer: removal 19.13 28 1052
payment to supplier: creation 166.89 55 9179
payment to supplier: removal 11.44 26 629
service: total inventory turnovers 19.91 1171 1095
service: total monetary turnovers 39.89 29 2194
service: aggregate perf. data 4.07 2109 224
service: refresh index statistics 0.04 9024 2

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:01, from 20-04-2026 05:43:32 to 20-04-2026 05:43:33.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 17444
TEST_TIME 2 13846
TEST_TIME 3 12921
TEST_TIME 4 12317
TEST_TIME 5 12182
TEST_TIME 6 12035
TEST_TIME 7 11961
TEST_TIME 8 12024
TEST_TIME 9 11957
TEST_TIME 10 12054
TEST_TIME 11 12159
TEST_TIME 12 12075
TEST_TIME 13 12074
TEST_TIME 14 12132
TEST_TIME 15 12154
TEST_TIME 16 12220
TEST_TIME 17 12379
TEST_TIME 18 12419
TEST_TIME 19 12419
TEST_TIME 20 12395
TEST_TIME 21 12415
TEST_TIME 22 12446
TEST_TIME 23 12525
TEST_TIME 24 12476
TEST_TIME 25 12468
TEST_TIME 26 12396
TEST_TIME 27 12342
TEST_TIME 28 12327
TEST_TIME 29 12268
TEST_TIME 30 12388
TEST_TIME 31 12321
TEST_TIME 32 12384
TEST_TIME 33 12455
TEST_TIME 34 12449
TEST_TIME 35 12594
TEST_TIME 36 12663
TEST_TIME 37 12684
TEST_TIME 38 12732
TEST_TIME 39 12745
TEST_TIME 40 12775
TEST_TIME 41 12807
TEST_TIME 42 12638

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 20-04-2026 05:43:34 to 20-04-2026 05:43:37.

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 796979 796979 0 0.00 0 1625 3 0 0
doc_list_biud 796979 796979 0 0.00 0 2684 10 0 0
sp_add_invoice_to_stock 7062 7062 0 0.00 4 16567 2066 0 0
sp_cancel_adding_invoice 4109 4109 0 0.00 3 7668 367 0 0
sp_cancel_client_order 2664 2664 0 0.00 3 1374 64 0 0
sp_cancel_customer_reserve 161215 161215 0 0.00 1 2685 27 0 0
sp_cancel_pay_from_customer 1052 1052 0 0.00 2 337 28 0 0
sp_cancel_pay_to_supplier 629 629 0 0.00 2 330 27 0 0
sp_cancel_supplier_invoice 5108 5108 0 0.00 2 2248 247 0 0
sp_cancel_supplier_order 608 608 0 0.00 4 86293 10272 0 0
sp_cancel_write_off 7592 7592 0 0.00 1 1376 34 0 0
sp_client_order 33268 33268 0 0.00 3 1598 82 0 0
sp_customer_reserve 251514 251514 0 0.00 0 2025 50 0 0
sp_fill_shopping_cart 50099 50099 0 0.00 1 2427 29 0 0
sp_fill_shopping_cart_clo_res 251514 251514 0 0.00 0 1504 5 0 0
sp_get_clo_for_invoice 7062 7062 0 0.00 0 1309 46 0 0
sp_kill_cost_storno 13382 13382 0 0.00 0 1350 16 0 0
sp_kill_qstorno_ret_qs2qd 335738 335738 0 0.00 0 2601 16 0 0
sp_kill_qty_storno 203741 203741 0 0.00 0 2684 36 0 0
sp_lock_selected_doc 31040 31040 0 0.00 0 496 3 0 0
sp_make_cost_storno 42688 42688 0 0.00 0 1614 13 0 0
sp_multiply_rows_for_pdistr 42688 42688 0 0.00 0 1352 18 0 0
sp_multiply_rows_for_qdistr 33268 33268 0 0.00 0 990 40 0 0
sp_pay_from_customer 11064 11064 0 0.00 3 1242 66 0 0
sp_pay_to_supplier 9179 9179 0 0.00 3 1640 55 0 0
sp_payment_common 20243 20243 0 0.00 1 1181 16 0 0
sp_qd_handle_on_cancel_clo 2664 2664 0 0.00 0 1356 49 0 0
sp_qd_handle_on_invoice_upd_sts 11171 11171 0 0.00 0 2115 144 0 0
sp_qd_handle_on_reserve_upd_sts 15383 15383 0 0.00 0 1849 22 0 0
sp_reserve_write_off 15383 15383 0 0.00 3 1855 60 0 0
sp_supplier_invoice 8430 8430 0 0.00 5 4783 636 0 0
sp_supplier_order 8401 8401 0 0.00 5 4104 408 0 0
srv_aggregate_perf_data 224 224 0 0.00 22 28468 2110 0 0
srv_fill_mon_cache_memory 42 42 0 0.00 2 2364 554 0 0
srv_find_qd_qs_mism 489398 489398 0 0.00 0 1402 2 0 0
srv_make_invnt_saldo 1095 1095 0 0.00 0 29353 1171 0 0
srv_make_money_saldo 2194 2194 0 0.00 0 586 29 0 0
srv_recalc_idx_stat 2 2 0 0.00 220 17828 9024 0 0
v_add_invoice_to_stock 14124 14124 0 0.00 0 518 2 0 0
v_all_customers 50608 50608 0 0.00 0 55 0 0 0
v_all_suppliers 40312 40312 0 0.00 0 48 1 0 0
v_all_wares 66536 66536 0 0.00 0 40 1 0 0
v_cancel_adding_invoice 1178 1178 0 0.00 0 319 2 0 0
v_cancel_client_order 5328 5328 0 0.00 0 439 1 0 0
v_cancel_customer_prepayment 2104 2104 0 0.00 0 309 1 0 0
v_cancel_customer_reserve 2086 2086 0 0.00 0 232 2 0 0
v_cancel_payment_to_supplier 1258 1258 0 0.00 0 222 1 0 0
v_cancel_supplier_invoice 1142 1142 0 0.00 0 136 2 0 0
v_cancel_supplier_order 1216 1216 0 0.00 0 156 1 0 0
v_cancel_write_off 2878 2878 0 0.00 0 314 2 0 0
v_max_id_clo_ord 8401 8401 0 0.00 0 69 1 0 0
v_max_id_clo_res 1525 1525 0 0.00 0 441 3 0 0
v_max_id_ord_sup 8430 8430 0 0.00 0 676 2 0 0
v_max_non_paid_invoice 5854 5854 0 0.00 0 456 3 0 0
v_max_non_paid_realizn 10543 10543 0 0.00 0 967 3 0 0
v_min_id_clo_ord 8401 8401 0 0.00 0 624 4 0 0
v_min_id_clo_res 1525 1525 0 0.00 0 692 6 0 0
v_min_id_ord_sup 8430 8430 0 0.00 0 1187 9 0 0
v_min_non_paid_invoice 9179 9179 0 0.00 0 732 7 0 0
v_min_non_paid_realizn 11064 11064 0 0.00 0 1008 11 0 0
v_our_firm 16970 16970 0 0.00 0 52 1 0 0
v_reserve_write_off 30766 30766 0 0.00 0 432 1 0 0
x_lock_depdocs_on_canc_invoice 8646 8646 0 0.00 0 1409 16 0 0
x_lock_depdocs_on_canc_sup_ord 608 608 0 0.00 0 185 24 0 0
x_make_qstorno_1000_1200 8401 8401 0 0.00 1 4089 345 0 0
x_make_qstorno_1200_2000 8430 8430 0 0.00 1 4619 566 0 0
x_make_qstorno_2100_3300 251514 251514 0 0.00 0 2001 44 0 0

Completed "Performance in DETAILS". Done for 00:00:03, from 20-04-2026 05:43:37 to 20-04-2026 05:43:40.

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: 393216 for all connections, with total size: 3221225472
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:01:05 2 3221225472 3474881392 3485093888 3978640 0.123 1 1 2 0 4077328 55888 42800
05:02:06 217 3221225472 3987102912 4139319296 485624912 13.100 35 16 31 0 490399200 1250400 3523888
05:03:06 245 3221225472 3938226096 4076265472 435539120 11.910 35 26 52 0 442248320 1578448 5130752
05:04:07 218 3221225472 3982731664 4132687872 480988320 12.991 35 14 28 0 485051808 1326576 2736912
05:05:07 443 3221225472 3941474736 4083847168 434645104 11.888 33 19 37 1 440187584 1640480 3902000
05:06:08 572 3221225472 3975296464 4125020160 471957248 12.779 35 26 53 1 479190432 1845248 5387936
05:07:09 175 3221225472 3989528224 4143767552 486762000 13.127 35 17 34 0 492138240 2264864 3111376
05:08:10 414 3221225472 3939723648 4083675136 435473184 11.908 34 20 40 0 442086816 2541440 4072192
05:09:10 195 3221225472 3977275504 4131160064 475632160 12.865 35 14 27 0 480206576 2308064 2266352
05:10:11 395 3221225472 3981615600 4136562688 478290688 12.928 35 18 36 0 484292864 2046352 3955824
05:11:11 319 3221225472 3971902016 4124135424 468004688 12.685 35 19 38 0 473992944 1603168 4385088
05:12:12 219 3221225472 3969153488 4118827008 463336368 12.575 35 21 43 0 470971216 3001392 4633456
05:13:12 326 3221225472 3978152368 4131790848 473907760 12.825 35 18 36 0 479592144 2357728 3326656
05:14:13 299 3221225472 3970545200 4121489408 465698944 12.631 35 21 42 0 472706640 3218736 3788960
05:15:14 287 3221225472 3974929520 4126908416 470715824 12.749 35 18 35 0 477386832 3072880 3598128
05:16:15 247 3221225472 3983090528 4136812544 476232112 12.879 35 20 40 0 483590848 3061184 4297552
05:17:15 560 3221225472 3976453024 4135424000 475253792 12.856 35 6 12 0 479787600 2832256 1701552
05:18:17 256 3221225472 3985380000 4138344448 477393728 12.907 35 23 42 0 485394352 3567328 4433296
05:19:18 423 3221225472 3977996464 4131848192 473341424 12.811 35 19 39 0 479735120 2535168 3858528
05:20:18 938 3221225472 3964646176 4116967424 460350368 12.504 34 17 34 0 466428352 2197184 3880800
05:21:20 1262 3221225472 3978845248 4135251968 476092688 12.876 35 18 36 1 482362688 2716592 3553408
05:22:22 2171 3221225472 3982906224 4137676800 478393536 12.930 35 18 36 0 484350016 2614768 3341712
05:23:24 345 3221225472 3973295312 4125245440 467411008 12.671 35 15 30 1 473350272 2855616 3083648
05:24:25 735 3221225472 3977301056 4129181696 469340288 12.717 35 19 38 0 475921008 2843248 3737472
05:25:25 382 3221225472 3981187248 4133982208 475374688 12.859 35 22 45 1 482291104 2461440 4454976
05:26:26 452 3221225472 3973946800 4130271232 471044480 12.757 35 16 32 0 476723872 2744928 2934464
05:27:29 2359 3221225472 3982674432 4139810816 477655440 12.913 35 9 18 1 482513904 2909424 1949040
05:28:32 376 3221225472 3977004768 4132450304 473050496 12.804 35 19 38 1 478301200 2080368 3170336
05:29:32 340 3221225472 3985344688 4140752896 477425184 12.908 35 18 36 0 487561232 6574192 3561856
05:30:34 766 3221225472 3967277024 4122365952 456608400 12.415 34 12 23 0 461962720 2853920 2500400
05:31:35 566 3221225472 3984995408 4139048960 476164704 12.878 35 15 30 0 484317200 4936640 3215856
05:32:36 701 3221225472 3985117536 4142612480 481839072 13.011 35 19 37 0 487621536 1918704 3863760
05:33:37 546 3221225472 3986849424 4145618944 482935040 13.037 35 11 22 0 488703728 3309072 2459616
05:34:39 388 3221225472 3984298624 4140093440 476206384 12.879 35 19 38 0 485491152 5287456 3997312
05:35:40 258 3221225472 3985585344 4140552192 477727344 12.915 35 21 42 0 484594640 2306240 4561056
05:36:41 156 3221225472 3971514656 4125896704 465533008 12.627 35 19 36 0 474921872 5067856 4321008
05:37:42 613 3221225472 3978310352 4133699584 471679392 12.772 35 20 40 0 478494896 2974656 3840848
05:38:43 471 3221225472 3970066064 4123033600 464463712 12.601 34 18 35 0 471781600 3960752 3357136
05:39:43 781 3221225472 3982988496 4138930176 476389088 12.883 35 20 38 0 483567008 3248448 3929472
05:40:44 236 3221225472 3977339376 4130713600 468884224 12.706 35 20 40 1 475962960 2807696 4271040
05:41:45 1761 3221225472 3968378368 4118540288 460548112 12.508 35 24 47 0 468499776 3112528 4839136
05:42:47 590 3221225472 3983434128 4139900928 477763968 12.916 35 14 28 0 483655648 2796272 3095408

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:10, from 20-04-2026 05:43:41 to 20-04-2026 05:43:51.

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:02, from 20-04-2026 05:43:51 to 20-04-2026 05:43:53.

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          223689
MON$OLDEST_ACTIVE               225208
MON$OLDEST_SNAPSHOT             225208
MON$NEXT_TRANSACTION            225208
MON$PAGE_BUFFERS                393216
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-04-20 05:00:12.2260
MON$PAGES                       148352
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                       
MON$SEC_DATABASE                Default


ISQL Version: LI-V3.0.14.33856 Firebird 3.0 HQbird
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.14.33856 Firebird 3.0 HQbird"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.14.33856 Firebird 3.0 HQbird/tcp (qa-test)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.14.33856 Firebird 3.0 HQbird/tcp (qa-test)/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: qa-test    Mon Apr 20 05:43:22 2026
:8:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:9:     Uncommitted work may have been lost.
:10:     Error writing data to the connection.
:11: 
:12: 
:13: qa-test    Mon Apr 20 05:43:22 2026
:14:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:15:     Uncommitted work may have been lost.
:16:     Error writing data to the connection.
:17: 
:18: 
:19: qa-test    Mon Apr 20 05:43:22 2026
:20:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:21:     Uncommitted work may have been lost.
:22:     Error writing data to the connection.
:23: 
:24: 
:25: qa-test    Mon Apr 20 05:43:22 2026
:26:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:27:     Uncommitted work may have been lost.
:28:     Error writing data to the connection.
:29: 
:30: 
:31: qa-test    Mon Apr 20 05:43:22 2026
:32:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:33:     Uncommitted work may have been lost.
:34:     Error writing data to the connection.
:35: 
:36: 
:37: qa-test    Mon Apr 20 05:43:22 2026
:38:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:39:     Uncommitted work may have been lost.
:40:     Error writing data to the connection.
:41: 
:42: 
:43: qa-test    Mon Apr 20 05:43:22 2026
:44:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:45:     Uncommitted work may have been lost.
:46:     Error writing data to the connection.
:47: 
:48: 
:49: qa-test    Mon Apr 20 05:43:22 2026
:50:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:51:     Uncommitted work may have been lost.
:52:     Error writing data to the connection.
:53: 
:54: 
:55: qa-test    Mon Apr 20 05:43:22 2026
:56:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:57:     Uncommitted work may have been lost.
:58:     Error writing data to the connection.
:59: 
:60: 
:61: qa-test    Mon Apr 20 05:43:22 2026
:62:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:63:     Uncommitted work may have been lost.
:64:     Error writing data to the connection.
:65: 
:66: 
:67: qa-test    Mon Apr 20 05:43:22 2026
:68:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:69:     Uncommitted work may have been lost.
:70:     Error writing data to the connection.
:71: 
:72: 
:73: qa-test    Mon Apr 20 05:43:22 2026
:74:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:75:     Uncommitted work may have been lost.
:76:     Error writing data to the connection.
:77: 
:78: 
:79: qa-test    Mon Apr 20 05:43:22 2026
:80:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:81:     Uncommitted work may have been lost.
:82:     Error writing data to the connection.
:83: 
:84: 
:85: qa-test    Mon Apr 20 05:43:22 2026
:86:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:87:     Uncommitted work may have been lost.
:88:     Error writing data to the connection.
:89: 
:90: 
:91: qa-test    Mon Apr 20 05:43:22 2026
:92:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:93:     Uncommitted work may have been lost.
:94:     Error writing data to the connection.
:95: 
:96: 
:97: qa-test    Mon Apr 20 05:43:22 2026
:98:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:99:     Uncommitted work may have been lost.
:100:     Error writing data to the connection.
:101: 
:102: 
:103: qa-test    Mon Apr 20 05:43:22 2026
:104:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:105:     Uncommitted work may have been lost.
:106:     Error writing data to the connection.
:107: 
:108: 
:109: qa-test    Mon Apr 20 05:43:22 2026
:110:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:111:     Uncommitted work may have been lost.
:112:     Error writing data to the connection.
:113: 
:114: 
:115: qa-test    Mon Apr 20 05:43:22 2026
:116:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:117:     Uncommitted work may have been lost.
:118:     Error writing data to the connection.
:119: 
:120: 
:121: qa-test    Mon Apr 20 05:43:22 2026
:122:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:123:     Uncommitted work may have been lost.
:124:     Error writing data to the connection.
:125: 
:126: 
:127: qa-test    Mon Apr 20 05:43:22 2026
:128:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:129:     Uncommitted work may have been lost.
:130:     Error writing data to the connection.
:131: 
:132: 
:133: qa-test    Mon Apr 20 05:43:22 2026
:134:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:135:     Uncommitted work may have been lost.
:136:     Error writing data to the connection.
:137: 
:138: 
:139: qa-test    Mon Apr 20 05:43:22 2026
:140:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:141:     Uncommitted work may have been lost.
:142:     Error writing data to the connection.
:143: 
:144: 
:145: qa-test    Mon Apr 20 05:43:22 2026
:146:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:147:     Uncommitted work may have been lost.
:148:     Error writing data to the connection.
:149: 
:150: 
:151: qa-test    Mon Apr 20 05:43:22 2026
:152:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:153:     Uncommitted work may have been lost.
:154:     Error writing data to the connection.
:155: 
:156: 
:157: qa-test    Mon Apr 20 05:43:22 2026
:158:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:159:     Uncommitted work may have been lost.
:160:     Error writing data to the connection.
:161: 
:162: 
:163: qa-test    Mon Apr 20 05:43:22 2026
:164:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:165:     Uncommitted work may have been lost.
:166:     Error writing data to the connection.
:167: 
:168: 
:169: qa-test    Mon Apr 20 05:43:22 2026
:170:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:171:     Uncommitted work may have been lost.
:172:     Error writing data to the connection.
:173: 
:174: 
:175: qa-test    Mon Apr 20 05:43:22 2026
:176:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:177:     Uncommitted work may have been lost.
:178:     Error writing data to the connection.
:179: 
:180: 
:181: qa-test    Mon Apr 20 05:43:22 2026
:182:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:183:     Uncommitted work may have been lost.
:184:     Error writing data to the connection.
:185: 
:186: 
:187: qa-test    Mon Apr 20 05:43:22 2026
:188:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:189:     Uncommitted work may have been lost.
:190:     Error writing data to the connection.
:191: 
:192: 
:193: qa-test    Mon Apr 20 05:43:22 2026
:194:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:195:     Uncommitted work may have been lost.
:196:     Error writing data to the connection.
:197: 
:198: 
:199: qa-test    Mon Apr 20 05:43:22 2026
:200:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:201:     Uncommitted work may have been lost.
:202:     Error writing data to the connection.
:203: 
:204: 
:205: qa-test    Mon Apr 20 05:43:22 2026
:206:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:207:     Uncommitted work may have been lost.
:208:     Error writing data to the connection.
:209: 
:210: 
:211: qa-test    Mon Apr 20 05:43:22 2026
:212:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:213:     Uncommitted work may have been lost.
:214:     Error writing data to the connection.
:215: 
:216: 
:217: qa-test    Mon Apr 20 05:43:24 2026
:218:     /opt/hq30/bin/fbguard: /opt/hq30/bin/firebird terminated abnormally (-1)
:219: 
:220: 
:221: 
:222: qa-test    Mon Apr 20 05:43:24 2026
:223:     /opt/hq30/bin/fbguard: guardian starting /opt/hq30/bin/firebird
:224: 
:225: 
--- end of diff output ---

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

20.04.26 05:43:53. All 3 logs in /var/tmp/logs.oltp-hq30 are preserved, 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-04-20 05:43:55 No severe PSQL-related problems occured
20.04.26 05:43:55. End of report.