Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 25.04.2022 12:56
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. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. 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 mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 11508608 kB
MemAvailable 31613048 kB
Buffers 0 kB
Cached 20106500 kB
SwapCached 2072 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs 

SERVER_MODE                     SuperServer 4.0.2
DB_NAME                         /home/bases/oltp40-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
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=/home/bases/oltp40-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp40-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb40/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
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=init_buff, val=10000
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_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3400
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=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp40-results-storage.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=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp40
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info 

FINISH_STATE                    CRASH DURING TEST RUN, 2022-04-25 12:56
DTS_END                         2022-04-25 12:56:16.1070
FB_GDSCODE                      
FB_MNEMONA                      
STACK                           script: ./oltp_isql_run_worker.sh, line: 1636
IP                              
TRN_ID                          172790
ATT_ID                          604
EXC_UNIT                        9

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 50

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 120 minutes: 6333.33 29134 759999
customer order: creation 112.37 501 13484
customer order: refuse 9.47 476 1136
order to supplier: creation 30.05 1501 3606
order to supplier: removal 2.36 227907 283
invoice (draft): creation 30.58 3389 3669
invoice (draft): removal 37.55 1336 4506
invoice accept: apply 27.82 26073 3338
invoice accept: cancel 34.05 1394 4086
customer reserve: creation 2528.24 245 303389
customer reserve: removal 3326.63 123 399195
realization accept: apply 52.98 337 6357
realization accept: cancel 55.79 192 6695
payment from customer: creation 39.53 215 4744
payment from customer: removal 3.96 133 475
payment to supplier: creation 31.28 262 3754
payment to supplier: removal 2.26 148 271
service: total inventory turnovers 2.43 5861 292
service: total monetary turnovers 5.42 438 650
service: aggregate perf. data 0.55 21332 66
service: refresh index statistics 0.03 290826 3

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 25-04-2022 12:56:47 to 25-04-2022 12:56:50.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 11787
TEST_TIME 2 8250
TEST_TIME 3 7082
TEST_TIME 4 6445
TEST_TIME 5 6030
TEST_TIME 6 5774
TEST_TIME 7 6142
TEST_TIME 8 6401
TEST_TIME 9 6645
TEST_TIME 10 6575
TEST_TIME 11 6714
TEST_TIME 12 6963
TEST_TIME 13 7485
TEST_TIME 14 7503
TEST_TIME 15 7493
TEST_TIME 16 7851
TEST_TIME 17 8035
TEST_TIME 18 8026
TEST_TIME 19 7960
TEST_TIME 20 7783
TEST_TIME 21 7712
TEST_TIME 22 8045
TEST_TIME 23 8104
TEST_TIME 24 8177
TEST_TIME 25 8203
TEST_TIME 26 8205
TEST_TIME 27 8306
TEST_TIME 28 8594
TEST_TIME 29 9825
TEST_TIME 30 9932
TEST_TIME 31 10130
TEST_TIME 32 10456
TEST_TIME 33 10977
TEST_TIME 34 11003
TEST_TIME 35 11111
TEST_TIME 36 11342
TEST_TIME 37 11389
TEST_TIME 38 11386
TEST_TIME 39 11353
TEST_TIME 40 11173
TEST_TIME 41 11086
TEST_TIME 42 10969
TEST_TIME 43 11059
TEST_TIME 44 11044
TEST_TIME 45 10971
TEST_TIME 46 10847
TEST_TIME 47 10657
TEST_TIME 48 10623
TEST_TIME 49 10492
TEST_TIME 50 10457
TEST_TIME 51 10359
TEST_TIME 52 10219
TEST_TIME 53 10123
TEST_TIME 54 10239
TEST_TIME 55 10149
TEST_TIME 56 10142
TEST_TIME 57 10105
TEST_TIME 58 10059
TEST_TIME 59 10161
TEST_TIME 60 10106
TEST_TIME 61 10146
TEST_TIME 62 10152
TEST_TIME 63 10153
TEST_TIME 64 10161
TEST_TIME 65 10094
TEST_TIME 66 10218
TEST_TIME 67 10146
TEST_TIME 68 10181
TEST_TIME 69 10183
TEST_TIME 70 10179
TEST_TIME 71 10170
TEST_TIME 72 10204
TEST_TIME 73 10138
TEST_TIME 74 10116
TEST_TIME 75 10027
TEST_TIME 76 10005
TEST_TIME 77 9927

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 25-04-2022 12:56:51 to 25-04-2022 12:56:54.

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 1039053 1039053 0 0.00 0 26229 15 0 0
doc_list_biud 1039043 1039043 0 0.00 0 23717 54 0 0
sp_add_invoice_to_stock 3374 3338 36 1.06 79 157520 26074 0 36
sp_cancel_adding_invoice 4086 4086 0 0.00 8 75441 1395 0 0
sp_cancel_client_order 1136 1136 0 0.00 6 10136 476 0 0
sp_cancel_customer_reserve 399195 399195 0 0.00 1 23720 124 0 0
sp_cancel_pay_from_customer 475 475 0 0.00 5 2667 133 0 0
sp_cancel_pay_to_supplier 271 271 0 0.00 5 2301 149 0 0
sp_cancel_supplier_invoice 4510 4506 4 0.08 3 12676 1337 0 4
sp_cancel_supplier_order 283 283 0 0.00 23 1662957 227907 0 0
sp_cancel_write_off 6695 6695 0 0.00 2 9468 193 0 0
sp_client_order 13484 13484 0 0.00 6 26871 501 0 0
sp_customer_reserve 303389 303389 0 0.00 1 85914 246 0 0
sp_fill_shopping_cart 20749 20749 0 0.00 1 8570 93 0 0
sp_fill_shopping_cart_clo_res 303355 303355 0 0.00 0 20556 19 0 0
sp_get_clo_for_invoice 3293 3293 0 0.00 0 26556 202 0 0
sp_kill_cost_storno 11527 11527 0 0.00 0 9464 91 0 0
sp_kill_qstorno_ret_qs2qd 809874 809874 0 0.00 0 23660 52 0 0
sp_kill_qty_storno 425549 425549 0 0.00 0 23717 121 0 0
sp_lock_selected_doc 13443 13443 0 0.00 0 10009 11 0 0
sp_make_cost_storno 18148 18148 0 0.00 0 26220 113 0 0
sp_multiply_rows_for_pdistr 18146 18146 0 0.00 0 19347 46 0 0
sp_multiply_rows_for_qdistr 13484 13484 0 0.00 0 13191 155 0 0
sp_pay_from_customer 4744 4744 0 0.00 6 13251 215 0 0
sp_pay_to_supplier 3754 3754 0 0.00 6 19383 262 0 0
sp_payment_common 8498 8498 0 0.00 2 9957 55 0 0
sp_qd_handle_on_cancel_clo 1136 1136 0 0.00 1 9852 374 0 0
sp_qd_handle_on_invoice_upd_sts 7379 7379 0 0.00 1 10749 643 0 0
sp_qd_handle_on_reserve_upd_sts 6354 6354 0 0.00 0 9244 65 0 0
sp_reserve_write_off 6357 6357 0 0.00 9 17960 337 0 0
sp_supplier_invoice 3669 3669 0 0.00 9 103528 3389 0 0
sp_supplier_order 3606 3606 0 0.00 8 26061 1501 0 0
srv_aggregate_perf_data 66 66 0 0.00 3054 161349 21332 0 0
srv_fill_mon_cache_memory 47 47 0 0.00 833 119378 30822 0 0
srv_find_qd_qs_mism 727687 727687 0 0.00 0 20989 10 0 0
srv_make_invnt_saldo 292 292 0 0.00 108 139507 5862 0 0
srv_make_money_saldo 650 650 0 0.00 1 15974 439 0 0
srv_recalc_idx_stat 3 3 0 0.00 55521 559086 290827 0 0
t$perf-abend:sp_add_invoice_to_stock 36 36 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 4 4 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 3347 3347 0 0.00 2 10540 1225 0 0
t$perf-norm:sp_cancel_adding_invoice 278 278 0 0.00 2 7827 624 0 0
t$perf-norm:sp_cancel_client_order 1136 1136 0 0.00 0 5333 45 0 0
t$perf-norm:sp_cancel_customer_reserve 457 457 0 0.00 0 2792 44 0 0
t$perf-norm:sp_cancel_pay_from_customer 475 475 0 0.00 0 2374 21 0 0
t$perf-norm:sp_cancel_pay_to_supplier 271 271 0 0.00 0 502 17 0 0
t$perf-norm:sp_cancel_supplier_invoice 240 240 0 0.00 0 744 46 0 0
t$perf-norm:sp_cancel_supplier_order 283 283 0 0.00 0 99724 10205 0 0
t$perf-norm:sp_cancel_write_off 662 662 0 0.00 0 4347 39 0 0
t$perf-norm:sp_client_order 13484 13484 0 0.00 0 12593 47 0 0
t$perf-norm:sp_customer_reserve 696 696 0 0.00 0 3099 23 0 0
t$perf-norm:sp_pay_from_customer 4744 4744 0 0.00 0 8077 25 0 0
t$perf-norm:sp_pay_to_supplier 3754 3754 0 0.00 0 2101 23 0 0
t$perf-norm:sp_reserve_write_off 6357 6357 0 0.00 0 5322 29 0 0
t$perf-norm:sp_supplier_invoice 3670 3670 0 0.00 0 1464 39 0 0
t$perf-norm:sp_supplier_order 3606 3606 0 0.00 0 1369 41 0 0
t$perf-norm:srv_aggregate_perf_data 66 66 0 0.00 0 164 13 0 0
t$perf-norm:srv_fill_mon_cache_memory 47 47 0 0.00 0 53 6 0 0
t$perf-norm:srv_make_invnt_saldo 292 292 0 0.00 0 660 25 0 0
t$perf-norm:srv_make_money_saldo 650 650 0 0.00 0 370 7 0 0
t$perf-norm:srv_recalc_idx_stat 3 3 0 0.00 17 195 80 0 0
v_add_invoice_to_stock 6644 6572 72 1.08 0 8864 34 0 72
v_all_customers 24852 24852 0 0.00 0 83 5 0 0
v_all_suppliers 19876 19876 0 0.00 0 144 5 0 0
v_all_wares 26960 26960 0 0.00 0 69 5 0 0
v_cancel_adding_invoice 556 556 0 0.00 0 4002 24 0 0
v_cancel_client_order 2272 2272 0 0.00 0 4420 15 0 0
v_cancel_customer_prepayment 950 950 0 0.00 0 2656 15 0 0
v_cancel_customer_reserve 914 914 0 0.00 0 1193 13 0 0
v_cancel_payment_to_supplier 542 542 0 0.00 0 1622 15 0 0
v_cancel_supplier_invoice 488 480 8 1.63 0 4591 39 0 8
v_cancel_supplier_order 566 566 0 0.00 0 4419 19 0 0
v_cancel_write_off 1324 1324 0 0.00 0 2671 29 0 0
v_max_id_clo_ord 3602 3602 0 0.00 0 5705 8 0 0
v_max_id_clo_res 696 696 0 0.00 0 1410 11 0 0
v_max_id_ord_sup 3664 3664 0 0.00 0 1008 7 0 0
v_max_non_paid_invoice 1081 1081 0 0.00 0 52 9 0 0
v_max_non_paid_realizn 2390 2390 0 0.00 0 1558 10 0 0
v_min_id_clo_ord 3602 3602 0 0.00 0 1858 11 0 0
v_min_id_clo_res 696 696 0 0.00 0 1787 11 0 0
v_min_id_ord_sup 3664 3664 0 0.00 0 5895 12 0 0
v_min_non_paid_invoice 3754 3754 0 0.00 0 5839 20 0 0
v_min_non_paid_realizn 4744 4744 0 0.00 0 1794 14 0 0
v_our_firm 6814 6814 0 0.00 0 143 6 0 0
v_reserve_write_off 12704 12704 0 0.00 0 4738 13 0 0
x_lock_depdocs_on_canc_invoice 8352 8352 0 0.00 0 22450 152 0 0
x_lock_depdocs_on_canc_sup_ord 283 283 0 0.00 0 21054 509 0 0
x_make_qstorno_1000_1200 3606 3606 0 0.00 3 26047 1287 0 0
x_make_qstorno_1200_2000 3669 3669 0 0.00 4 101431 3162 0 0
x_make_qstorno_2100_3300 303386 303386 0 0.00 0 85904 211 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 25-04-2022 12:56:55 to 25-04-2022 12:56:59.

Memory consumption, metadata cache, attachments activity 

Fields:
  page cache memo used            = page cache total size, 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        = metadata cache, 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: 1000000 for all connections, with total size: 8192000000
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
11:07:19 1 8192000000 8796669024 8807174144 3189120 0.038 1 1 2 0 3286736 61840 35776
11:08:20 23610 8192000000 9706036480 10003763200 786232752 8.757 100 86 172 0 814660704 7810160 20617792
11:09:47 13438 8192000000 9739424656 10044964864 816974768 9.068 100 87 174 0 850189936 11664400 21550768
11:11:05 18211 8192000000 9796865504 10115563520 863712896 9.537 100 85 169 1 903479072 19838864 19927312
11:12:25 10524 8192000000 9856402384 10190561280 910762576 10.005 100 82 165 0 969906960 40543280 18601104
11:13:40 7088 8192000000 9931915360 10273460224 956489344 10.455 100 92 181 1 1036881840 61409536 18982960
11:14:51 2948 8192000000 9986901776 10344042496 992839392 10.809 100 92 183 1 1106161424 95083744 18238288
11:15:57 891 8192000000 9976818160 10343563264 1021467824 11.086 100 92 178 0 1101556944 62693232 17395888
11:17:00 1020 8192000000 10015079568 10384539648 1040389200 11.268 100 97 192 0 1138905264 79340224 19175840
11:18:02 1244 8192000000 10026485136 10405785600 1063525472 11.490 100 96 185 1 1159289344 75460640 20303232
11:19:04 1333 8192000000 10066036976 10454691840 1067592048 11.529 100 87 167 1 1189387632 105069792 16725792
11:20:08 1400 8192000000 10039451152 10424115200 1075570816 11.605 100 88 163 3 1161627792 69811408 16245568
11:21:11 1271 8192000000 10052029584 10441965568 1087702432 11.721 100 87 172 0 1174555616 68406064 18447120
11:22:13 1140 8192000000 10079932928 10466365440 1094559024 11.786 100 95 184 2 1196223376 82904032 18760320
11:23:15 3251 8192000000 10051995712 10447269888 1094527504 11.786 100 73 137 2 1176698032 68232048 13938480
11:24:20 1181 8192000000 10059243440 10448379904 1098121312 11.820 100 92 173 1 1180584240 64640416 17822512
11:25:22 1309 8192000000 10083129968 10472873984 1101980560 11.856 100 91 172 1 1205922544 85476112 18465872
11:26:24 1068 8192000000 10048920400 10439639040 1095490816 11.795 100 91 175 0 1170811520 57419632 17901072
11:27:31 1268 8192000000 10049560384 10435796992 1086331696 11.708 100 97 186 1 1171137184 65430560 19374928
11:28:33 915 8192000000 10058349232 10444922880 1089323552 11.736 100 87 165 1 1179237264 73609424 16304288
11:29:35 1054 8192000000 10056929872 10447163392 1082604768 11.672 100 86 169 1 1184260848 83751824 17904256
11:30:37 901 8192000000 10020997744 10405298176 1065690192 11.511 100 87 163 0 1145551296 62646352 17214752
11:31:40 1294 8192000000 10014989648 10396745728 1062058624 11.476 100 84 161 0 1136005888 57420464 16526800
11:32:44 1620 8192000000 9989519568 10363011072 1041181856 11.276 100 86 159 1 1114014896 58524768 14308272
11:33:47 1673 8192000000 10006973120 10384007168 1041078560 11.275 100 87 172 1 1129413536 70432224 17902752
11:34:49 1036 8192000000 9979793840 10352586752 1025912736 11.129 99 89 173 0 1102588528 60111616 16564176
11:35:51 1399 8192000000 9951441744 10329124864 1023785424 11.109 100 74 149 0 1072976048 34007680 15182944
11:37:02 4838 8192000000 9970913888 10356715520 1031983184 11.188 99 68 127 0 1090876672 45995440 12898048
11:38:11 6451 8192000000 10006595248 10399023104 1069470832 11.547 100 60 115 1 1138128928 57088256 11569840
11:39:40 6966 8192000000 10056088272 10440212480 1083842464 11.684 100 71 133 1 1163277936 65971728 13463744
11:40:53 6125 8192000000 10067339232 10465406976 1102176416 11.858 100 57 104 2 1186255248 72843536 11235296
11:42:03 15113 8192000000 10084696912 10479112192 1104710864 11.882 100 58 112 0 1201661200 85200096 11750240
11:43:20 2273 8192000000 10135536320 10529406976 1119489248 12.022 100 76 145 4 1253356208 117865952 16001008
11:44:29 2543 8192000000 10186477664 10592755712 1121363072 12.040 99 79 146 1 1306238848 169225648 15650128
11:45:34 1064 8192000000 10218175296 10617499648 1134479200 12.164 100 92 180 1 1332923744 178597504 19847040
11:46:41 1987 8192000000 10229073440 10627211264 1148286592 12.293 100 83 166 1 1343063440 177059568 17717280
11:47:57 2024 8192000000 10270870112 10671165440 1159383328 12.397 100 85 164 0 1378903744 202075360 17445056
11:49:02 1660 8192000000 10305141424 10723291136 1168027712 12.478 100 86 160 0 1418901008 232134736 18738560
11:50:06 939 8192000000 10333030960 10759540736 1180024544 12.590 100 92 181 1 1445105520 244936912 20144064
11:51:12 893 8192000000 10338711328 10743087104 1185858992 12.645 100 98 186 1 1451408464 243289776 22259696
11:52:16 1157 8192000000 10372762720 10791571456 1180530368 12.595 100 97 191 2 1480862272 278958080 21373824
11:53:20 857 8192000000 10361840304 10812379136 1169332480 12.491 99 94 184 0 1473086064 282281488 21472096
11:54:23 1077 8192000000 10418161840 10834853888 1199396352 12.771 100 96 189 2 1527916976 306847360 21673264
11:55:27 1109 8192000000 10431749632 10850267136 1190314688 12.686 100 91 182 0 1536463712 324929344 21219680
11:56:32 1905 8192000000 10458199040 10873020416 1204630096 12.819 100 68 131 1 1569339024 346535568 18173360
11:57:46 827 8192000000 10528784480 10952417280 1213709248 12.903 100 98 194 1 1633635376 395986352 23939776
11:58:49 876 8192000000 10575852304 11015733248 1211566048 12.884 100 96 187 3 1678873776 444727536 22580192
11:59:53 874 8192000000 10604897808 11021750272 1202197472 12.797 100 97 189 1 1709031296 483525984 23307840
12:00:55 2137 8192000000 10628793200 11042164736 1194307280 12.723 100 76 148 1 1730914304 518133488 18473536
12:02:13 5229 8192000000 10649894224 11102908416 1195136528 12.731 100 64 128 1 1751031232 539251872 16642832
12:03:21 5972 8192000000 10670415328 11129888768 1186780384 12.653 100 59 117 0 1770763584 568104896 15878304
12:04:36 1116 8192000000 10697149792 11145760768 1178390384 12.575 100 92 174 1 1800976128 599443792 23141952
12:05:48 5341 8192000000 10563025776 11107520512 1168799728 12.486 100 55 110 0 1673681328 490638224 14243376
12:07:00 12079 8192000000 10404997664 10875375616 1171577920 12.512 100 34 68 1 1511211328 331363552 8269856
12:08:31 33676 8192000000 10286113440 10787868672 1137147904 12.189 99 25 46 2 1446760768 304022944 5589920
12:10:06 34201 8192000000 10188606000 10680778752 1145127280 12.264 100 20 39 0 1316137568 166443776 4566512
12:11:42 35715 8192000000 10173717408 10655682560 1138335184 12.200 99 28 56 1 1282461376 137701456 6424736
12:13:18 100760 8192000000 10104063104 10642264064 1093050384 11.772 96 4 8 0 1164408784 70891936 466464
12:16:00 107749 8192000000 10062400464 10494918656 1094119552 11.782 96 14 28 1 1136590080 39045792 3424736
12:18:48 73557 8192000000 10127651072 10573369344 1119279776 12.020 98 27 53 0 1201645248 77542960 4822512
12:22:14 79008 8192000000 10070373936 10503065600 1110133904 11.934 98 29 57 0 1153071712 36898384 6039424
12:24:40 105483 8192000000 10070259952 10510700544 1099076560 11.829 97 29 56 0 1139863696 34705632 6081504
12:27:39 119375 8192000000 10141086576 10589085696 1108048080 11.914 97 22 44 1 1209960016 96330800 5581136
12:31:44 22174 8192000000 10136016816 10564341760 1130363552 12.125 99 51 95 0 1218076400 76482144 11230704
12:33:09 45427 8192000000 10184152896 10659422208 1139152752 12.208 99 22 44 0 1277023168 132233760 5636656
12:35:05 31475 8192000000 10182870608 10647330816 1145286032 12.265 100 17 34 0 1287707424 138225456 4195936
12:36:40 100927 8192000000 10135131296 10615017472 1130413104 12.125 99 31 62 2 1218626816 81412560 6801152
12:39:26 55919 8192000000 10090762960 10552901632 1124429552 12.069 98 13 26 3 1183738064 56730128 2578384
12:41:29 42648 8192000000 10126327664 10569089024 1124189072 12.067 98 28 53 3 1198179120 68529568 5460480
12:43:16 45323 8192000000 10082165392 10570432512 1103696672 11.873 98 23 45 1 1204996208 96203232 5096304
12:45:02 23721 8192000000 10097961632 10558136320 1110982160 11.942 99 32 64 0 1176838688 59479936 6376592
12:46:31 94513 8192000000 10103437872 10548060160 1121993600 12.046 99 28 56 0 1168279360 41281648 5004112
12:49:06 96264 8192000000 10086764800 10510266368 1105311728 11.888 98 30 60 2 1186822832 75654512 5856592
12:51:47 84322 8192000000 10078752736 10531115008 1105044096 11.885 98 23 45 1 1167275328 57384400 4846832
12:54:15 27618 8192000000 10063181424 10539245568 1123233008 12.058 100 21 40 2 1169667824 42605952 3828864

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:14, from 25-04-2022 12:57:01 to 25-04-2022 12:57:15.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 36 v_add_invoice_to_stock 335544517
except 4 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 25-04-2022 12:57:16 to 25-04-2022 12:57:18.

Content of mon$database and FB version 

MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          171292
MON$OLDEST_ACTIVE               172894
MON$OLDEST_SNAPSHOT             172894
MON$NEXT_TRANSACTION            172894
MON$PAGE_BUFFERS                1000000
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               2020-04-30 07:30:08.6030 GMT
MON$PAGES                       2100096
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             699
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.2.2761 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.2.2761 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.2.2761 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.2.2761 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
on disk structure version 13.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 ---
:644: 
:645: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:646:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:647:     Uncommitted work may have been lost.
:648:     Error writing data to the connection.
:649:     send_packet/send
:650: 
:651: 
:652: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:653:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:654:     Uncommitted work may have been lost.
:655:     Error writing data to the connection.
:656:     send_packet/send
:657: 
:658: 
:659: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:660:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:661:     Uncommitted work may have been lost.
:662:     Error writing data to the connection.
:663:     send_packet/send
:664: 
:665: 
:666: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:667:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:668:     Uncommitted work may have been lost.
:669:     Error writing data to the connection.
:670:     send_packet/send
:671: 
:672: 
:673: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:674:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:675:     Uncommitted work may have been lost.
:676:     Error writing data to the connection.
:677:     send_packet/send
:678: 
:679: 
:680: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:681:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:682:     Uncommitted work may have been lost.
:683:     Error writing data to the connection.
:684:     send_packet/send
:685: 
:686: 
:687: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:688:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:689:     Uncommitted work may have been lost.
:690:     Error writing data to the connection.
:691:     send_packet/send
:692: 
:693: 
:694: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:695:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:696:     Uncommitted work may have been lost.
:697:     Error writing data to the connection.
:698:     send_packet/send
:699: 
:700: 
:701: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:702:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:703:     Uncommitted work may have been lost.
:704:     Error writing data to the connection.
:705:     send_packet/send
:706: 
:707: 
:708: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:709:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:710:     Uncommitted work may have been lost.
:711:     Error writing data to the connection.
:712:     send_packet/send
:713: 
:714: 
:715: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:716:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:717:     Uncommitted work may have been lost.
:718:     Error writing data to the connection.
:719:     send_packet/send
:720: 
:721: 
:722: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:723:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:724:     Uncommitted work may have been lost.
:725:     Error writing data to the connection.
:726:     send_packet/send
:727: 
:728: 
:729: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:730:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:731:     Uncommitted work may have been lost.
:732:     Error writing data to the connection.
:733:     send_packet/send
:734: 
:735: 
:736: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:737:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:738:     Uncommitted work may have been lost.
:739:     Error writing data to the connection.
:740:     send_packet/send
:741: 
:742: 
:743: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:744:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:745:     Uncommitted work may have been lost.
:746:     Error writing data to the connection.
:747:     send_packet/send
:748: 
:749: 
:750: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:751:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:752:     Uncommitted work may have been lost.
:753:     Error writing data to the connection.
:754:     send_packet/send
:755: 
:756: 
:757: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:758:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:759:     Uncommitted work may have been lost.
:760:     Error writing data to the connection.
:761:     send_packet/send
:762: 
:763: 
:764: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:765:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:766:     Uncommitted work may have been lost.
:767:     Error writing data to the connection.
:768:     send_packet/send
:769: 
:770: 
:771: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:772:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:773:     Uncommitted work may have been lost.
:774:     Error writing data to the connection.
:775:     send_packet/send
:776: 
:777: 
:778: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:779:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:780:     Uncommitted work may have been lost.
:781:     Error writing data to the connection.
:782:     send_packet/send
:783: 
:784: 
:785: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:786:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:787:     Uncommitted work may have been lost.
:788:     Error writing data to the connection.
:789:     send_packet/send
:790: 
:791: 
:792: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:793:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:794:     Uncommitted work may have been lost.
:795:     Error writing data to the connection.
:796:     send_packet/send
:797: 
:798: 
:799: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:800:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:801:     Uncommitted work may have been lost.
:802:     Error writing data to the connection.
:803:     send_packet/send
:804: 
:805: 
:806: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:807:     INET/inet_error: read errno = 104, server host = localhost, address = ::1/3400
:808: 
:809: 
:810: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:811:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:812:     Uncommitted work may have been lost.
:813:     Error writing data to the connection.
:814:     send_packet/send
:815: 
:816: 
:817: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:818:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:819:     Uncommitted work may have been lost.
:820:     Error writing data to the connection.
:821:     send_packet/send
:822: 
:823: 
:824: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:825:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:826:     Uncommitted work may have been lost.
:827:     Error writing data to the connection.
:828:     send_packet/send
:829: 
:830: 
:831: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:832:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:833:     Uncommitted work may have been lost.
:834:     Error writing data to the connection.
:835:     send_packet/send
:836: 
:837: 
:838: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:839:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:840:     Uncommitted work may have been lost.
:841:     Error writing data to the connection.
:842:     send_packet/send
:843: 
:844: 
:845: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:846:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:847:     Uncommitted work may have been lost.
:848:     Error writing data to the connection.
:849:     send_packet/send
:850: 
:851: 
:852: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:853:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:854:     Uncommitted work may have been lost.
:855:     Error writing data to the connection.
:856:     send_packet/send
:857: 
:858: 
:859: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:860:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:861:     Uncommitted work may have been lost.
:862:     Error writing data to the connection.
:863:     send_packet/send
:864: 
:865: 
:866: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:867:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:868:     Uncommitted work may have been lost.
:869:     Error writing data to the connection.
:870:     send_packet/send
:871: 
:872: 
:873: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:874:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:875:     Uncommitted work may have been lost.
:876:     Error writing data to the connection.
:877:     send_packet/send
:878: 
:879: 
:880: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:881:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:882:     Uncommitted work may have been lost.
:883:     Error writing data to the connection.
:884:     send_packet/send
:885: 
:886: 
:887: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:888:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:889:     Uncommitted work may have been lost.
:890:     Error writing data to the connection.
:891:     send_packet/send
:892: 
:893: 
:894: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:895:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:896:     Uncommitted work may have been lost.
:897:     Error writing data to the connection.
:898:     send_packet/send
:899: 
:900: 
:901: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:902:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:903:     Uncommitted work may have been lost.
:904:     Error writing data to the connection.
:905:     send_packet/send
:906: 
:907: 
:908: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:909:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:910:     Uncommitted work may have been lost.
:911:     Error writing data to the connection.
:912:     send_packet/send
:913: 
:914: 
:915: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:916:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:917:     Uncommitted work may have been lost.
:918:     Error writing data to the connection.
:919:     send_packet/send
:920: 
:921: 
:922: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:923:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:924:     Uncommitted work may have been lost.
:925:     Error writing data to the connection.
:926:     send_packet/send
:927: 
:928: 
:929: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:930:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:931:     Uncommitted work may have been lost.
:932:     Error writing data to the connection.
:933:     send_packet/send
:934: 
:935: 
:936: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:937:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:938:     Uncommitted work may have been lost.
:939:     Error writing data to the connection.
:940:     send_packet/send
:941: 
:942: 
:943: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:944:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:945:     Uncommitted work may have been lost.
:946:     Error writing data to the connection.
:947:     send_packet/send
:948: 
:949: 
:950: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:951:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:952:     Uncommitted work may have been lost.
:953:     Error writing data to the connection.
:954:     send_packet/send
:955: 
:956: 
:957: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:958:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:959:     Uncommitted work may have been lost.
:960:     Error writing data to the connection.
:961:     send_packet/send
:962: 
:963: 
:964: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:965:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:966:     Uncommitted work may have been lost.
:967:     Error writing data to the connection.
:968:     send_packet/send
:969: 
:970: 
:971: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:972:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:973:     Uncommitted work may have been lost.
:974:     Error writing data to the connection.
:975:     send_packet/send
:976: 
:977: 
:978: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:979:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:980:     Uncommitted work may have been lost.
:981:     Error writing data to the connection.
:982:     send_packet/send
:983: 
:984: 
:985: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:986:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:987:     Uncommitted work may have been lost.
:988:     Error writing data to the connection.
:989:     send_packet/send
:990: 
:991: 
:992: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:993:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:994:     Uncommitted work may have been lost.
:995:     Error writing data to the connection.
:996:     send_packet/send
:997: 
:998: 
:999: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1000:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1001:     Uncommitted work may have been lost.
:1002:     Error writing data to the connection.
:1003:     send_packet/send
:1004: 
:1005: 
:1006: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1007:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1008:     Uncommitted work may have been lost.
:1009:     Error writing data to the connection.
:1010:     send_packet/send
:1011: 
:1012: 
:1013: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1014:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1015:     Uncommitted work may have been lost.
:1016:     Error writing data to the connection.
:1017:     send_packet/send
:1018: 
:1019: 
:1020: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1021:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1022:     Uncommitted work may have been lost.
:1023:     Error writing data to the connection.
:1024:     send_packet/send
:1025: 
:1026: 
:1027: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1028:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1029:     Uncommitted work may have been lost.
:1030:     Error writing data to the connection.
:1031:     send_packet/send
:1032: 
:1033: 
:1034: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1035:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1036:     Uncommitted work may have been lost.
:1037:     Error writing data to the connection.
:1038:     send_packet/send
:1039: 
:1040: 
:1041: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1042:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1043:     Uncommitted work may have been lost.
:1044:     Error writing data to the connection.
:1045:     send_packet/send
:1046: 
:1047: 
:1048: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1049:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1050:     Uncommitted work may have been lost.
:1051:     Error writing data to the connection.
:1052:     send_packet/send
:1053: 
:1054: 
:1055: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1056:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1057:     Uncommitted work may have been lost.
:1058:     Error writing data to the connection.
:1059:     send_packet/send
:1060: 
:1061: 
:1062: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1063:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1064:     Uncommitted work may have been lost.
:1065:     Error writing data to the connection.
:1066:     send_packet/send
:1067: 
:1068: 
:1069: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1070:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1071:     Uncommitted work may have been lost.
:1072:     Error writing data to the connection.
:1073:     send_packet/send
:1074: 
:1075: 
:1076: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1077:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1078:     Uncommitted work may have been lost.
:1079:     Error writing data to the connection.
:1080:     send_packet/send
:1081: 
:1082: 
:1083: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1084:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1085:     Uncommitted work may have been lost.
:1086:     Error writing data to the connection.
:1087:     send_packet/send
:1088: 
:1089: 
:1090: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1091:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1092:     Uncommitted work may have been lost.
:1093:     Error writing data to the connection.
:1094:     send_packet/send
:1095: 
:1096: 
:1097: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1098:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1099:     Uncommitted work may have been lost.
:1100:     Error writing data to the connection.
:1101:     send_packet/send
:1102: 
:1103: 
:1104: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1105:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1106:     Uncommitted work may have been lost.
:1107:     Error writing data to the connection.
:1108:     send_packet/send
:1109: 
:1110: 
:1111: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1112:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1113:     Uncommitted work may have been lost.
:1114:     Error writing data to the connection.
:1115:     send_packet/send
:1116: 
:1117: 
:1118: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1119:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1120:     Uncommitted work may have been lost.
:1121:     Error writing data to the connection.
:1122:     send_packet/send
:1123: 
:1124: 
:1125: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1126:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1127:     Uncommitted work may have been lost.
:1128:     Error writing data to the connection.
:1129:     send_packet/send
:1130: 
:1131: 
:1132: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1133:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1134:     Uncommitted work may have been lost.
:1135:     Error writing data to the connection.
:1136:     send_packet/send
:1137: 
:1138: 
:1139: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1140:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1141:     Uncommitted work may have been lost.
:1142:     Error writing data to the connection.
:1143:     send_packet/send
:1144: 
:1145: 
:1146: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1147:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1148:     Uncommitted work may have been lost.
:1149:     Error writing data to the connection.
:1150:     send_packet/send
:1151: 
:1152: 
:1153: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1154:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1155:     Uncommitted work may have been lost.
:1156:     Error writing data to the connection.
:1157:     send_packet/send
:1158: 
:1159: 
:1160: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1161:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1162:     Uncommitted work may have been lost.
:1163:     Error writing data to the connection.
:1164:     send_packet/send
:1165: 
:1166: 
:1167: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1168:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1169:     Uncommitted work may have been lost.
:1170:     Error writing data to the connection.
:1171:     send_packet/send
:1172: 
:1173: 
:1174: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1175:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1176:     Uncommitted work may have been lost.
:1177:     Error writing data to the connection.
:1178:     send_packet/send
:1179: 
:1180: 
:1181: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1182:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1183:     Uncommitted work may have been lost.
:1184:     Error writing data to the connection.
:1185:     send_packet/send
:1186: 
:1187: 
:1188: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1189:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1190:     Uncommitted work may have been lost.
:1191:     Error writing data to the connection.
:1192:     send_packet/send
:1193: 
:1194: 
:1195: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1196:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1197:     Uncommitted work may have been lost.
:1198:     Error writing data to the connection.
:1199:     send_packet/send
:1200: 
:1201: 
:1202: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1203:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1204:     Uncommitted work may have been lost.
:1205:     Error writing data to the connection.
:1206:     send_packet/send
:1207: 
:1208: 
:1209: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1210:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1211:     Uncommitted work may have been lost.
:1212:     Error writing data to the connection.
:1213:     send_packet/send
:1214: 
:1215: 
:1216: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1217:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1218:     Uncommitted work may have been lost.
:1219:     Error writing data to the connection.
:1220:     send_packet/send
:1221: 
:1222: 
:1223: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1224:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1225:     Uncommitted work may have been lost.
:1226:     Error writing data to the connection.
:1227:     send_packet/send
:1228: 
:1229: 
:1230: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1231:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1232:     Uncommitted work may have been lost.
:1233:     Error writing data to the connection.
:1234:     send_packet/send
:1235: 
:1236: 
:1237: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1238:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1239:     Uncommitted work may have been lost.
:1240:     Error writing data to the connection.
:1241:     send_packet/send
:1242: 
:1243: 
:1244: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1245:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1246:     Uncommitted work may have been lost.
:1247:     Error writing data to the connection.
:1248:     send_packet/send
:1249: 
:1250: 
:1251: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1252:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1253:     Uncommitted work may have been lost.
:1254:     Error writing data to the connection.
:1255:     send_packet/send
:1256: 
:1257: 
:1258: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1259:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1260:     Uncommitted work may have been lost.
:1261:     Error writing data to the connection.
:1262:     send_packet/send
:1263: 
:1264: 
:1265: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1266:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1267:     Uncommitted work may have been lost.
:1268:     Error writing data to the connection.
:1269:     send_packet/send
:1270: 
:1271: 
:1272: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1273:     /opt/fb40/bin/fbguard: /opt/fb40/bin/firebird terminated abnormally (-1)
:1274: 
:1275: 
:1276: 
:1277: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1278:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1279:     Uncommitted work may have been lost.
:1280:     Error writing data to the connection.
:1281:     send_packet/send
:1282: 
:1283: 
:1284: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1285:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1286:     Uncommitted work may have been lost.
:1287:     Error writing data to the connection.
:1288:     send_packet/send
:1289: 
:1290: 
:1291: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1292:     /opt/fb40/bin/fbguard: guardian starting /opt/fb40/bin/firebird
:1293: 
:1294: 
:1295: 
:1296: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1297:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1298:     Uncommitted work may have been lost.
:1299:     Error writing data to the connection.
:1300:     send_packet/send
:1301: 
:1302: 
:1303: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1304:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1305:     Uncommitted work may have been lost.
:1306:     Error writing data to the connection.
:1307:     send_packet/send
:1308: 
:1309: 
:1310: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1311:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1312:     Uncommitted work may have been lost.
:1313:     Error writing data to the connection.
:1314:     send_packet/send
:1315: 
:1316: 
:1317: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1318:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1319:     Uncommitted work may have been lost.
:1320:     Error writing data to the connection.
:1321:     send_packet/send
:1322: 
:1323: 
:1324: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1325:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1326:     Uncommitted work may have been lost.
:1327:     Error writing data to the connection.
:1328:     send_packet/send
:1329: 
:1330: 
:1331: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1332:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1333:     Uncommitted work may have been lost.
:1334:     Error writing data to the connection.
:1335:     send_packet/send
:1336: 
:1337: 
:1338: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1339:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1340:     Uncommitted work may have been lost.
:1341:     Error writing data to the connection.
:1342:     send_packet/send
:1343: 
:1344: 
:1345: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1346:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1347:     Uncommitted work may have been lost.
:1348:     Error writing data to the connection.
:1349:     send_packet/send
:1350: 
:1351: 
:1352: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:11 2022
:1353:     REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
:1354:     Uncommitted work may have been lost.
:1355:     Error writing data to the connection.
:1356:     send_packet/send
:1357: 
:1358: 
:1359: mscs-test-161.budzdorov.ru    Mon Apr 25 12:56:13 2022
:1360:     INET/inet_error: send errno = 32, server host = localhost, address = ::1/3400
:1361: 
--- end of diff output ---

 Final processing ISQL logs in /var/tmp/logs-oltp40 according to config parameter 'remove_isql_logs'  

25.04.22 12:57:19. All 6 logs in /var/tmp/logs-oltp40 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
2022-04-25 12:57:21 No severe PSQL-related problems occured
25.04.22 12:57:23. End of report.