Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 26.07.2022 16:38
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 | 15784972 kB |
MemAvailable | 31013848 kB |
Buffers | 0 kB |
Cached | 15910008 kB |
SwapCached | 2552 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_MODE SuperServer 3.0.11
DB_NAME /home/bases/oltp30-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/oltp30-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp30-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb30/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=3333
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/oltp30-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-oltp30
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|
FINISH_STATE NORMAL: TEST_TIME EXPIRED AT 2022-07-26 16:38:24
DTS_END 2022-07-26 16:38:24.7350
FB_GDSCODE -1
FB_MNEMONA
STACK SP_RESERVE_WRITE_OFF(34:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP ::1/43448
TRN_ID 252239
ATT_ID 711
EXC_UNIT 2
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 |
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 |
ACTION |
AVG_TIMES_PER_MINUTE |
AVG_ELAPSED_MS |
SUCCESSFUL_TIMES_DONE |
*** OVERALL *** for 120 minutes: |
9650.39 |
23988 |
1158047 |
customer order: creation |
181.67 |
336 |
21800 |
customer order: refuse |
15.48 |
323 |
1858 |
order to supplier: creation |
48.54 |
1167 |
5825 |
order to supplier: removal |
3.49 |
99396 |
419 |
invoice (draft): creation |
48.01 |
3066 |
5761 |
invoice (draft): removal |
53.92 |
786 |
6470 |
invoice accept: apply |
44.38 |
17087 |
5325 |
invoice accept: cancel |
48.58 |
817 |
5829 |
customer reserve: creation |
4116.94 |
168 |
494033 |
customer reserve: removal |
4780.24 |
56 |
573629 |
realization accept: apply |
89.23 |
169 |
10708 |
realization accept: cancel |
82.60 |
109 |
9912 |
payment from customer: creation |
62.65 |
117 |
7518 |
payment from customer: removal |
6.06 |
69 |
727 |
payment to supplier: creation |
52.86 |
134 |
6343 |
payment to supplier: removal |
3.41 |
81 |
409 |
service: total inventory turnovers |
4.67 |
1235 |
560 |
service: total monetary turnovers |
6.82 |
36 |
818 |
service: aggregate perf. data |
0.83 |
23837 |
99 |
service: refresh index statistics |
0.03 |
330770 |
4 |
Completed "Performance in TOTAL". Done for 00:00:03, from 26-07-2022 16:39:18 to 26-07-2022 16:39:21.
TEST_PHASE_NAME |
MINUTES_PASSED |
PERF_SCORE |
TEST_TIME |
1 |
4603 |
TEST_TIME |
2 |
2319 |
TEST_TIME |
3 |
2052 |
TEST_TIME |
4 |
4038 |
TEST_TIME |
5 |
5363 |
TEST_TIME |
6 |
5873 |
TEST_TIME |
7 |
6104 |
TEST_TIME |
8 |
5875 |
TEST_TIME |
9 |
6041 |
TEST_TIME |
10 |
6403 |
TEST_TIME |
11 |
6582 |
TEST_TIME |
12 |
6395 |
TEST_TIME |
13 |
6578 |
TEST_TIME |
14 |
6866 |
TEST_TIME |
15 |
6923 |
TEST_TIME |
16 |
7021 |
TEST_TIME |
17 |
7301 |
TEST_TIME |
18 |
7325 |
TEST_TIME |
19 |
7698 |
TEST_TIME |
20 |
7863 |
TEST_TIME |
21 |
8257 |
TEST_TIME |
22 |
8642 |
TEST_TIME |
23 |
8641 |
TEST_TIME |
24 |
8737 |
TEST_TIME |
25 |
8758 |
TEST_TIME |
26 |
9340 |
TEST_TIME |
27 |
9234 |
TEST_TIME |
28 |
9307 |
TEST_TIME |
29 |
10164 |
TEST_TIME |
30 |
10668 |
TEST_TIME |
31 |
10921 |
TEST_TIME |
32 |
10941 |
TEST_TIME |
33 |
11076 |
TEST_TIME |
34 |
10935 |
TEST_TIME |
35 |
10829 |
TEST_TIME |
36 |
10861 |
TEST_TIME |
37 |
10853 |
TEST_TIME |
38 |
10796 |
TEST_TIME |
39 |
10684 |
TEST_TIME |
40 |
10627 |
TEST_TIME |
41 |
10481 |
TEST_TIME |
42 |
10626 |
TEST_TIME |
43 |
10522 |
TEST_TIME |
44 |
10506 |
TEST_TIME |
45 |
10381 |
TEST_TIME |
46 |
10223 |
TEST_TIME |
47 |
10051 |
TEST_TIME |
48 |
10166 |
TEST_TIME |
49 |
10231 |
TEST_TIME |
50 |
10046 |
TEST_TIME |
51 |
10099 |
TEST_TIME |
52 |
10022 |
TEST_TIME |
53 |
9997 |
TEST_TIME |
54 |
9980 |
TEST_TIME |
55 |
10029 |
TEST_TIME |
56 |
9969 |
TEST_TIME |
57 |
9945 |
TEST_TIME |
58 |
9923 |
TEST_TIME |
59 |
9812 |
TEST_TIME |
60 |
9746 |
TEST_TIME |
61 |
9748 |
TEST_TIME |
62 |
9695 |
TEST_TIME |
63 |
9609 |
TEST_TIME |
64 |
9589 |
TEST_TIME |
65 |
9603 |
TEST_TIME |
66 |
9598 |
TEST_TIME |
67 |
9632 |
TEST_TIME |
68 |
9676 |
TEST_TIME |
69 |
9773 |
TEST_TIME |
70 |
9809 |
TEST_TIME |
71 |
9868 |
TEST_TIME |
72 |
9792 |
TEST_TIME |
73 |
9985 |
TEST_TIME |
74 |
9926 |
TEST_TIME |
75 |
10037 |
TEST_TIME |
76 |
9976 |
TEST_TIME |
77 |
10081 |
TEST_TIME |
78 |
9976 |
TEST_TIME |
79 |
9920 |
TEST_TIME |
80 |
9869 |
TEST_TIME |
81 |
9854 |
TEST_TIME |
82 |
9857 |
TEST_TIME |
83 |
9829 |
TEST_TIME |
84 |
9777 |
TEST_TIME |
85 |
9758 |
TEST_TIME |
86 |
9696 |
TEST_TIME |
87 |
9672 |
TEST_TIME |
88 |
9672 |
TEST_TIME |
89 |
9669 |
TEST_TIME |
90 |
9685 |
TEST_TIME |
91 |
9694 |
TEST_TIME |
92 |
9724 |
TEST_TIME |
93 |
9690 |
TEST_TIME |
94 |
9734 |
TEST_TIME |
95 |
9747 |
TEST_TIME |
96 |
9719 |
TEST_TIME |
97 |
9726 |
TEST_TIME |
98 |
9801 |
TEST_TIME |
99 |
9816 |
TEST_TIME |
100 |
9876 |
TEST_TIME |
101 |
9874 |
TEST_TIME |
102 |
9884 |
TEST_TIME |
103 |
9798 |
TEST_TIME |
104 |
9771 |
TEST_TIME |
105 |
9722 |
TEST_TIME |
106 |
9726 |
TEST_TIME |
107 |
9694 |
TEST_TIME |
108 |
9642 |
TEST_TIME |
109 |
9634 |
TEST_TIME |
110 |
9679 |
TEST_TIME |
111 |
9639 |
TEST_TIME |
112 |
9655 |
TEST_TIME |
113 |
9630 |
TEST_TIME |
114 |
9628 |
TEST_TIME |
115 |
9601 |
TEST_TIME |
116 |
9633 |
TEST_TIME |
117 |
9695 |
TEST_TIME |
118 |
9698 |
TEST_TIME |
119 |
9694 |
TEST_TIME |
120 |
9652 |
Completed "Performance for every MINUTE". Done for 00:00:04, from 26-07-2022 16:39:22 to 26-07-2022 16:39:26.
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 |
1614649 |
1614649 |
0 |
0.00 |
0 |
59767 |
6 |
0 |
0 |
doc_list_biud |
1614643 |
1614643 |
0 |
0.00 |
0 |
27490 |
26 |
0 |
0 |
sp_add_invoice_to_stock |
5433 |
5325 |
108 |
1.98 |
14 |
215004 |
17087 |
0 |
108 |
sp_cancel_adding_invoice |
5829 |
5829 |
0 |
0.00 |
4 |
87271 |
818 |
0 |
0 |
sp_cancel_client_order |
1858 |
1858 |
0 |
0.00 |
4 |
7148 |
324 |
0 |
0 |
sp_cancel_customer_reserve |
573629 |
573629 |
0 |
0.00 |
0 |
20116 |
56 |
0 |
0 |
sp_cancel_pay_from_customer |
727 |
727 |
0 |
0.00 |
3 |
5169 |
70 |
0 |
0 |
sp_cancel_pay_to_supplier |
409 |
409 |
0 |
0.00 |
2 |
3883 |
82 |
0 |
0 |
sp_cancel_supplier_invoice |
6479 |
6470 |
9 |
0.13 |
1 |
17396 |
786 |
0 |
9 |
sp_cancel_supplier_order |
419 |
419 |
0 |
0.00 |
9 |
1075347 |
99397 |
0 |
0 |
sp_cancel_write_off |
9912 |
9912 |
0 |
0.00 |
1 |
10845 |
110 |
0 |
0 |
sp_client_order |
21800 |
21800 |
0 |
0.00 |
3 |
70398 |
337 |
0 |
0 |
sp_customer_reserve |
494033 |
494033 |
0 |
0.00 |
0 |
101822 |
168 |
0 |
0 |
sp_fill_shopping_cart |
33382 |
33382 |
0 |
0.00 |
1 |
13019 |
35 |
0 |
0 |
sp_fill_shopping_cart_clo_res |
494031 |
494031 |
0 |
0.00 |
0 |
29475 |
15 |
0 |
0 |
sp_get_clo_for_invoice |
5314 |
5314 |
0 |
0.00 |
0 |
31042 |
292 |
0 |
0 |
sp_kill_cost_storno |
16877 |
16877 |
0 |
0.00 |
0 |
10821 |
53 |
0 |
0 |
sp_kill_qstorno_ret_qs2qd |
1164059 |
1164059 |
0 |
0.00 |
0 |
20088 |
31 |
0 |
0 |
sp_kill_qty_storno |
614134 |
614134 |
0 |
0.00 |
0 |
27489 |
66 |
0 |
0 |
sp_lock_selected_doc |
22113 |
22113 |
0 |
0.00 |
0 |
7423 |
6 |
0 |
0 |
sp_make_cost_storno |
29883 |
29883 |
0 |
0.00 |
0 |
12726 |
57 |
0 |
0 |
sp_multiply_rows_for_pdistr |
29881 |
29881 |
0 |
0.00 |
0 |
10315 |
27 |
0 |
0 |
sp_multiply_rows_for_qdistr |
21800 |
21800 |
0 |
0.00 |
0 |
70391 |
141 |
0 |
0 |
sp_pay_from_customer |
7518 |
7518 |
0 |
0.00 |
4 |
10700 |
117 |
0 |
0 |
sp_pay_to_supplier |
6343 |
6343 |
0 |
0.00 |
4 |
14297 |
135 |
0 |
0 |
sp_payment_common |
13860 |
13860 |
0 |
0.00 |
1 |
10598 |
31 |
0 |
0 |
sp_qd_handle_on_cancel_clo |
1858 |
1858 |
0 |
0.00 |
0 |
6259 |
284 |
0 |
0 |
sp_qd_handle_on_invoice_upd_sts |
11143 |
11143 |
0 |
0.00 |
0 |
27488 |
334 |
0 |
0 |
sp_qd_handle_on_reserve_upd_sts |
10703 |
10703 |
0 |
0.00 |
0 |
19165 |
55 |
0 |
0 |
sp_reserve_write_off |
10708 |
10708 |
0 |
0.00 |
5 |
19183 |
170 |
0 |
0 |
sp_supplier_invoice |
5761 |
5761 |
0 |
0.00 |
7 |
151621 |
3066 |
0 |
0 |
sp_supplier_order |
5825 |
5825 |
0 |
0.00 |
4 |
42159 |
1168 |
0 |
0 |
srv_aggregate_perf_data |
99 |
99 |
0 |
0.00 |
2307 |
750706 |
23837 |
0 |
0 |
srv_fill_mon_cache_memory |
64 |
64 |
0 |
0.00 |
831 |
111774 |
41946 |
0 |
0 |
srv_find_qd_qs_mism |
1106893 |
1106893 |
0 |
0.00 |
0 |
59623 |
5 |
0 |
0 |
srv_make_invnt_saldo |
560 |
560 |
0 |
0.00 |
40 |
161981 |
1236 |
0 |
0 |
srv_make_money_saldo |
818 |
818 |
0 |
0.00 |
0 |
8803 |
36 |
0 |
0 |
srv_recalc_idx_stat |
4 |
4 |
0 |
0.00 |
154331 |
537984 |
330770 |
0 |
0 |
t$perf-abend:sp_add_invoice_to_stock |
108 |
108 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-abend:sp_cancel_supplier_invoice |
9 |
9 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-norm:sp_add_invoice_to_stock |
5325 |
5325 |
0 |
0.00 |
0 |
11030 |
172 |
0 |
0 |
t$perf-norm:sp_cancel_adding_invoice |
435 |
435 |
0 |
0.00 |
0 |
9823 |
136 |
0 |
0 |
t$perf-norm:sp_cancel_client_order |
1858 |
1858 |
0 |
0.00 |
0 |
5813 |
17 |
0 |
0 |
t$perf-norm:sp_cancel_customer_reserve |
720 |
720 |
0 |
0.00 |
0 |
2408 |
17 |
0 |
0 |
t$perf-norm:sp_cancel_pay_from_customer |
727 |
727 |
0 |
0.00 |
0 |
3084 |
11 |
0 |
0 |
t$perf-norm:sp_cancel_pay_to_supplier |
409 |
409 |
0 |
0.00 |
0 |
10822 |
41 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_invoice |
434 |
434 |
0 |
0.00 |
0 |
1431 |
18 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_order |
419 |
419 |
0 |
0.00 |
0 |
22339 |
1721 |
0 |
0 |
t$perf-norm:sp_cancel_write_off |
1094 |
1094 |
0 |
0.00 |
0 |
4251 |
12 |
0 |
0 |
t$perf-norm:sp_client_order |
21800 |
21800 |
0 |
0.00 |
0 |
17533 |
22 |
0 |
0 |
t$perf-norm:sp_customer_reserve |
1060 |
1060 |
0 |
0.00 |
0 |
3408 |
7 |
0 |
0 |
t$perf-norm:sp_pay_from_customer |
7518 |
7518 |
0 |
0.00 |
0 |
5764 |
8 |
0 |
0 |
t$perf-norm:sp_pay_to_supplier |
6343 |
6343 |
0 |
0.00 |
0 |
9428 |
18 |
0 |
0 |
t$perf-norm:sp_reserve_write_off |
10708 |
10708 |
0 |
0.00 |
0 |
14998 |
17 |
0 |
0 |
t$perf-norm:sp_supplier_invoice |
5761 |
5761 |
0 |
0.00 |
0 |
11755 |
23 |
0 |
0 |
t$perf-norm:sp_supplier_order |
5825 |
5825 |
0 |
0.00 |
0 |
10647 |
18 |
0 |
0 |
t$perf-norm:srv_aggregate_perf_data |
99 |
99 |
0 |
0.00 |
0 |
427 |
8 |
0 |
0 |
t$perf-norm:srv_fill_mon_cache_memory |
64 |
64 |
0 |
0.00 |
0 |
741 |
22 |
0 |
0 |
t$perf-norm:srv_make_invnt_saldo |
560 |
560 |
0 |
0.00 |
0 |
3532 |
31 |
0 |
0 |
t$perf-norm:srv_make_money_saldo |
818 |
818 |
0 |
0.00 |
0 |
3361 |
28 |
0 |
0 |
t$perf-norm:srv_recalc_idx_stat |
4 |
4 |
0 |
0.00 |
1 |
6 |
3 |
0 |
0 |
v_add_invoice_to_stock |
10844 |
10628 |
216 |
1.99 |
0 |
8121 |
19 |
0 |
216 |
v_all_customers |
40152 |
40152 |
0 |
0.00 |
0 |
54 |
1 |
0 |
0 |
v_all_suppliers |
32500 |
32500 |
0 |
0.00 |
0 |
207 |
1 |
0 |
0 |
v_all_wares |
43600 |
43600 |
0 |
0.00 |
0 |
22 |
1 |
0 |
0 |
v_cancel_adding_invoice |
870 |
870 |
0 |
0.00 |
0 |
2906 |
12 |
0 |
0 |
v_cancel_client_order |
3716 |
3716 |
0 |
0.00 |
0 |
6733 |
8 |
0 |
0 |
v_cancel_customer_prepayment |
1454 |
1454 |
0 |
0.00 |
0 |
2416 |
7 |
0 |
0 |
v_cancel_customer_reserve |
1440 |
1440 |
0 |
0.00 |
0 |
3240 |
7 |
0 |
0 |
v_cancel_payment_to_supplier |
818 |
818 |
0 |
0.00 |
0 |
230 |
3 |
0 |
0 |
v_cancel_supplier_invoice |
886 |
868 |
18 |
2.03 |
0 |
6726 |
27 |
0 |
18 |
v_cancel_supplier_order |
838 |
838 |
0 |
0.00 |
0 |
3374 |
11 |
0 |
0 |
v_cancel_write_off |
2188 |
2188 |
0 |
0.00 |
0 |
2375 |
15 |
0 |
0 |
v_max_id_clo_ord |
5825 |
5825 |
0 |
0.00 |
0 |
249 |
1 |
0 |
0 |
v_max_id_clo_res |
1060 |
1060 |
0 |
0.00 |
0 |
1394 |
11 |
0 |
0 |
v_max_id_ord_sup |
5757 |
5757 |
0 |
0.00 |
0 |
5076 |
6 |
0 |
0 |
v_max_non_paid_invoice |
1675 |
1675 |
0 |
0.00 |
0 |
916 |
3 |
0 |
0 |
v_max_non_paid_realizn |
3874 |
3874 |
0 |
0.00 |
0 |
9923 |
6 |
0 |
0 |
v_min_id_clo_ord |
5825 |
5825 |
0 |
0.00 |
0 |
4371 |
5 |
0 |
0 |
v_min_id_clo_res |
1060 |
1060 |
0 |
0.00 |
0 |
3475 |
7 |
0 |
0 |
v_min_id_ord_sup |
5757 |
5757 |
0 |
0.00 |
0 |
4129 |
7 |
0 |
0 |
v_min_non_paid_invoice |
6343 |
6343 |
0 |
0.00 |
0 |
9887 |
20 |
0 |
0 |
v_min_non_paid_realizn |
7515 |
7515 |
0 |
0.00 |
0 |
10594 |
25 |
0 |
0 |
v_our_firm |
10730 |
10730 |
0 |
0.00 |
0 |
18 |
1 |
0 |
0 |
v_reserve_write_off |
21402 |
21402 |
0 |
0.00 |
0 |
3948 |
5 |
0 |
0 |
x_lock_depdocs_on_canc_invoice |
11865 |
11865 |
0 |
0.00 |
0 |
27571 |
117 |
0 |
0 |
x_lock_depdocs_on_canc_sup_ord |
419 |
419 |
0 |
0.00 |
0 |
15311 |
458 |
0 |
0 |
x_make_qstorno_1000_1200 |
5825 |
5825 |
0 |
0.00 |
1 |
42142 |
1096 |
0 |
0 |
x_make_qstorno_1200_2000 |
5761 |
5761 |
0 |
0.00 |
3 |
151587 |
2940 |
0 |
0 |
x_make_qstorno_2100_3300 |
494033 |
494033 |
0 |
0.00 |
0 |
97870 |
151 |
0 |
0 |
Completed "Performance in DETAILS". Done for 00:00:04, from 26-07-2022 16:39:27 to 26-07-2022 16:39:31.
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 |
14:08:28 |
1 |
8192000000 |
8797116400 |
8807743488 |
3955424 |
0.048 |
1 |
1 |
2 |
0 |
4053696 |
55488 |
42784 |
14:09:29 |
20831 |
8192000000 |
9893758560 |
10201047040 |
977417456 |
10.659 |
100 |
86 |
172 |
0 |
1006050672 |
5823120 |
22810096 |
14:11:01 |
3643 |
8192000000 |
9928653728 |
10247942144 |
1017110688 |
11.044 |
100 |
88 |
176 |
0 |
1047178320 |
7343120 |
22724512 |
14:12:13 |
11384 |
8192000000 |
9973260688 |
10302255104 |
1058586048 |
11.443 |
100 |
82 |
164 |
0 |
1087782176 |
9034960 |
20161168 |
14:13:30 |
10625 |
8192000000 |
10038778864 |
10386780160 |
1125415088 |
12.078 |
100 |
81 |
162 |
0 |
1154572704 |
10324848 |
18832768 |
14:14:47 |
8809 |
8192000000 |
10083479872 |
10443661312 |
1173570896 |
12.530 |
100 |
80 |
160 |
0 |
1203691152 |
11753200 |
18367056 |
14:15:59 |
3404 |
8192000000 |
10122191168 |
10489597952 |
1211752352 |
12.885 |
100 |
83 |
167 |
0 |
1244039648 |
13756464 |
18530832 |
14:17:06 |
1685 |
8192000000 |
10164699872 |
10540707840 |
1253307296 |
13.269 |
100 |
86 |
172 |
1 |
1284822720 |
13390800 |
18124624 |
14:18:10 |
881 |
8192000000 |
10190641664 |
10569949184 |
1278758704 |
13.502 |
100 |
90 |
178 |
1 |
1312989600 |
14697872 |
19533024 |
14:19:13 |
956 |
8192000000 |
10209402800 |
10596462592 |
1301365280 |
13.708 |
100 |
87 |
169 |
0 |
1331836848 |
11766720 |
18704848 |
14:20:15 |
16100 |
8192000000 |
10208705968 |
10607652864 |
1305805872 |
13.748 |
100 |
49 |
97 |
0 |
1323038976 |
6500672 |
10732432 |
14:21:32 |
7650 |
8192000000 |
10200639136 |
10612903936 |
1316815712 |
13.848 |
100 |
32 |
66 |
0 |
1330376560 |
6365792 |
7195056 |
14:22:45 |
13578 |
8192000000 |
10208546896 |
10626535424 |
1325571376 |
13.927 |
100 |
13 |
24 |
0 |
1334269568 |
6280896 |
2417296 |
14:24:01 |
50472 |
8192000000 |
10215737392 |
10637967360 |
1328044064 |
13.949 |
100 |
27 |
54 |
2 |
1338912112 |
4954784 |
5913264 |
14:25:52 |
5461 |
8192000000 |
10235680352 |
10653007872 |
1336487248 |
14.026 |
100 |
47 |
94 |
2 |
1353153360 |
4956624 |
11709488 |
14:26:58 |
14264 |
8192000000 |
10224407312 |
10642214912 |
1299958656 |
13.695 |
97 |
18 |
36 |
0 |
1309378256 |
5450672 |
3968928 |
14:28:16 |
12391 |
8192000000 |
10234754368 |
10647482368 |
1334563680 |
14.008 |
100 |
31 |
63 |
0 |
1348364496 |
5728144 |
8072672 |
14:29:31 |
20850 |
8192000000 |
10173814096 |
10586443776 |
1212381360 |
12.891 |
92 |
22 |
44 |
0 |
1222934032 |
6214928 |
4337744 |
14:30:53 |
6122 |
8192000000 |
10151363120 |
10553208832 |
1249779984 |
13.236 |
99 |
26 |
51 |
0 |
1261608576 |
6287184 |
5541408 |
14:32:01 |
6871 |
8192000000 |
10120924400 |
10511900672 |
1184146272 |
12.629 |
96 |
28 |
58 |
0 |
1197134320 |
5322000 |
7666048 |
14:33:08 |
13021 |
8192000000 |
10173293568 |
10565550080 |
1268361472 |
13.407 |
100 |
15 |
30 |
0 |
1277418528 |
5742288 |
3314768 |
14:34:22 |
16304 |
8192000000 |
10178722624 |
10587996160 |
1283003344 |
13.540 |
100 |
27 |
54 |
0 |
1294935536 |
6299968 |
5632224 |
14:35:38 |
9818 |
8192000000 |
10190843168 |
10601566208 |
1296844288 |
13.667 |
100 |
16 |
30 |
1 |
1305907376 |
5696800 |
3366288 |
14:36:49 |
12159 |
8192000000 |
10203095120 |
10615197696 |
1308402848 |
13.772 |
100 |
13 |
26 |
0 |
1317006016 |
5091040 |
3512128 |
14:38:01 |
12323 |
8192000000 |
10215432368 |
10634637312 |
1323555712 |
13.909 |
100 |
17 |
36 |
2 |
1336354256 |
9304192 |
3494352 |
14:39:20 |
23299 |
8192000000 |
10258591632 |
10665259008 |
1345114112 |
14.103 |
100 |
37 |
73 |
1 |
1360390512 |
7465168 |
7811232 |
14:41:08 |
97329 |
8192000000 |
10256980864 |
10694127616 |
1361792784 |
14.253 |
100 |
27 |
50 |
0 |
1383583328 |
15928656 |
5861888 |
14:43:51 |
23434 |
8192000000 |
10296732704 |
10713931776 |
1378353872 |
14.402 |
100 |
54 |
107 |
0 |
1406727008 |
16423904 |
11949232 |
14:45:18 |
11670 |
8192000000 |
10307886896 |
10731347968 |
1390042528 |
14.506 |
100 |
53 |
103 |
0 |
1423453216 |
21013856 |
12396832 |
14:46:41 |
6414 |
8192000000 |
10318965344 |
10737696768 |
1392231264 |
14.526 |
100 |
54 |
106 |
1 |
1427273744 |
22073824 |
12968656 |
14:47:52 |
3356 |
8192000000 |
10327379712 |
10750541824 |
1402609264 |
14.618 |
100 |
55 |
108 |
1 |
1439440768 |
23237616 |
13593888 |
14:49:00 |
4430 |
8192000000 |
10345998784 |
10775703552 |
1420720320 |
14.779 |
100 |
54 |
104 |
0 |
1459054560 |
25185840 |
13148400 |
14:50:07 |
5537 |
8192000000 |
10331005856 |
10754338816 |
1399922544 |
14.594 |
100 |
58 |
116 |
2 |
1440160144 |
26568304 |
13669296 |
14:51:19 |
2124 |
8192000000 |
10352157056 |
10773696512 |
1412554704 |
14.707 |
100 |
58 |
113 |
0 |
1458680384 |
31993120 |
14132560 |
14:52:26 |
10146 |
8192000000 |
10341255824 |
10761601024 |
1400645408 |
14.601 |
100 |
64 |
126 |
1 |
1448393904 |
31980144 |
15768352 |
14:53:43 |
3436 |
8192000000 |
10354720272 |
10768936960 |
1406142160 |
14.650 |
100 |
67 |
134 |
0 |
1460859040 |
38232176 |
16484704 |
14:55:09 |
1282 |
8192000000 |
10354104544 |
10766635008 |
1394925808 |
14.550 |
100 |
78 |
156 |
0 |
1455519792 |
41225136 |
19368848 |
14:56:17 |
1687 |
8192000000 |
10350471616 |
10761404416 |
1394500304 |
14.546 |
100 |
77 |
152 |
1 |
1458028848 |
44894880 |
18633664 |
14:57:31 |
3132 |
8192000000 |
10354402000 |
10764492800 |
1389796160 |
14.504 |
100 |
72 |
140 |
1 |
1455739664 |
48440880 |
17502624 |
14:58:42 |
1656 |
8192000000 |
10371235280 |
10783645696 |
1397992848 |
14.577 |
100 |
78 |
156 |
0 |
1472473216 |
54453104 |
20027264 |
14:59:49 |
8978 |
8192000000 |
10360829136 |
10784817152 |
1401501936 |
14.608 |
100 |
53 |
103 |
0 |
1468798704 |
54081888 |
13214880 |
15:01:05 |
6170 |
8192000000 |
10349779936 |
10771251200 |
1376803472 |
14.388 |
99 |
52 |
101 |
0 |
1439958896 |
49718768 |
13436656 |
15:02:14 |
20802 |
8192000000 |
10357127328 |
10789556224 |
1404355360 |
14.634 |
100 |
39 |
77 |
0 |
1472210736 |
57096656 |
10758720 |
15:03:40 |
831 |
8192000000 |
10340315280 |
10754109440 |
1364968592 |
14.282 |
98 |
54 |
107 |
3 |
1434141344 |
55152784 |
14019968 |
15:04:44 |
23750 |
8192000000 |
10330691360 |
10764935168 |
1373649872 |
14.360 |
99 |
22 |
44 |
0 |
1425425424 |
45220544 |
6555008 |
15:07:00 |
39009 |
8192000000 |
10308777920 |
10749177856 |
1354810848 |
14.191 |
99 |
20 |
40 |
0 |
1419421568 |
58399472 |
6211248 |
15:08:40 |
32469 |
8192000000 |
10285905984 |
10736095232 |
1321938048 |
13.894 |
96 |
18 |
36 |
0 |
1359539584 |
33166544 |
4434992 |
15:10:14 |
41860 |
8192000000 |
10291354800 |
10742280192 |
1374165872 |
14.364 |
99 |
11 |
20 |
0 |
1397542128 |
21193808 |
2182448 |
15:11:56 |
91642 |
8192000000 |
10285422176 |
10736455680 |
1351984768 |
14.165 |
98 |
8 |
17 |
0 |
1367056624 |
13597936 |
1473920 |
15:14:28 |
108477 |
8192000000 |
10277390816 |
10724286464 |
1303338960 |
13.726 |
94 |
5 |
10 |
0 |
1319059808 |
14794176 |
926672 |
15:17:24 |
37346 |
8192000000 |
10306264080 |
10738814976 |
1383095328 |
14.444 |
100 |
31 |
60 |
0 |
1396956672 |
6679392 |
7181952 |
15:19:10 |
35649 |
8192000000 |
10304314560 |
10742972416 |
1375882896 |
14.380 |
99 |
26 |
53 |
0 |
1389205536 |
7897232 |
5425408 |
15:20:52 |
93859 |
8192000000 |
10322506576 |
10759577600 |
1381226848 |
14.428 |
99 |
15 |
30 |
0 |
1394446480 |
10020544 |
3199088 |
15:23:55 |
10555 |
8192000000 |
10295293424 |
10729709568 |
1368500432 |
14.314 |
99 |
42 |
82 |
0 |
1384672064 |
6963360 |
9208272 |
15:25:07 |
68170 |
8192000000 |
10308489728 |
10762088448 |
1403543504 |
14.627 |
100 |
49 |
98 |
0 |
1428755152 |
13431184 |
11780464 |
15:27:26 |
54135 |
8192000000 |
10319982736 |
10764427264 |
1403532656 |
14.626 |
100 |
39 |
78 |
1 |
1423148928 |
10847056 |
8769216 |
15:30:40 |
56473 |
8192000000 |
10319823088 |
10778464256 |
1404574704 |
14.636 |
100 |
22 |
42 |
0 |
1420852848 |
11171232 |
5106912 |
15:32:37 |
37127 |
8192000000 |
10283410944 |
10749927424 |
1365216000 |
14.284 |
98 |
34 |
68 |
2 |
1387527888 |
15079312 |
7232576 |
15:34:58 |
50008 |
8192000000 |
10297953840 |
10755989504 |
1384238032 |
14.454 |
99 |
8 |
16 |
0 |
1396417968 |
10361104 |
1818832 |
15:37:12 |
64464 |
8192000000 |
10249331248 |
10695618560 |
1324759424 |
13.920 |
96 |
30 |
55 |
1 |
1337091984 |
5970272 |
6362288 |
15:39:17 |
43439 |
8192000000 |
10274133920 |
10736287744 |
1362320512 |
14.258 |
99 |
19 |
38 |
1 |
1385044384 |
18748976 |
3974896 |
15:41:09 |
39658 |
8192000000 |
10262830640 |
10722078720 |
1346314688 |
14.114 |
98 |
8 |
14 |
0 |
1353907824 |
6281712 |
1311424 |
15:43:03 |
30709 |
8192000000 |
10263880784 |
10712719360 |
1311566688 |
13.800 |
95 |
26 |
52 |
0 |
1325160608 |
8088496 |
5505424 |
15:44:34 |
66670 |
8192000000 |
10275574880 |
10743009280 |
1358693888 |
14.226 |
99 |
16 |
32 |
0 |
1380845328 |
18119664 |
4031776 |
15:46:41 |
43441 |
8192000000 |
10265988832 |
10718912512 |
1337698448 |
14.037 |
98 |
23 |
46 |
0 |
1358778304 |
16017728 |
5062128 |
15:48:25 |
64262 |
8192000000 |
10285504896 |
10741272576 |
1336743504 |
14.028 |
98 |
9 |
17 |
0 |
1351722112 |
13149120 |
1829488 |
15:50:29 |
66269 |
8192000000 |
10273224224 |
10736844800 |
1351342048 |
14.160 |
99 |
36 |
72 |
0 |
1379707648 |
20150576 |
8215024 |
15:52:59 |
61828 |
8192000000 |
10268483504 |
10720776192 |
1311411568 |
13.799 |
96 |
17 |
35 |
0 |
1334197168 |
18619072 |
4166528 |
15:55:02 |
77256 |
8192000000 |
10257444880 |
10711388160 |
1315171760 |
13.833 |
96 |
14 |
28 |
0 |
1327269008 |
8622768 |
3474480 |
15:57:20 |
70431 |
8192000000 |
10275222576 |
10724528128 |
1346983584 |
14.120 |
99 |
18 |
36 |
0 |
1358495856 |
7494288 |
4017984 |
15:59:34 |
51553 |
8192000000 |
10262522432 |
10734665728 |
1370340592 |
14.330 |
100 |
18 |
36 |
1 |
1383474656 |
8686704 |
4447360 |
16:01:26 |
70648 |
8192000000 |
10256718880 |
10711748608 |
1337198096 |
14.032 |
97 |
8 |
16 |
0 |
1348554064 |
9488816 |
1867152 |
16:03:57 |
59731 |
8192000000 |
10270987616 |
10732834816 |
1377923648 |
14.398 |
100 |
14 |
28 |
0 |
1388144160 |
7124816 |
3095696 |
16:06:16 |
53362 |
8192000000 |
10279426880 |
10747019264 |
1372343392 |
14.348 |
99 |
15 |
30 |
0 |
1387214304 |
11254688 |
3616224 |
16:08:30 |
22855 |
8192000000 |
10301545584 |
10747850752 |
1391792720 |
14.522 |
100 |
31 |
62 |
0 |
1406636000 |
8366256 |
6477024 |
16:09:53 |
46337 |
8192000000 |
10297153200 |
10750484480 |
1353582928 |
14.180 |
97 |
23 |
46 |
0 |
1367174272 |
8961040 |
4630304 |
16:12:03 |
20181 |
8192000000 |
10308333232 |
10756247552 |
1395386800 |
14.554 |
100 |
43 |
86 |
0 |
1415277824 |
10559488 |
9331536 |
16:13:25 |
56504 |
8192000000 |
10298842944 |
10749464576 |
1343062816 |
14.085 |
96 |
17 |
34 |
0 |
1357232672 |
10519680 |
3650176 |
16:15:24 |
68779 |
8192000000 |
10307559904 |
10771468288 |
1378532480 |
14.403 |
99 |
20 |
39 |
0 |
1397590960 |
14973376 |
4085104 |
16:17:33 |
47972 |
8192000000 |
10312695792 |
10770771968 |
1386044032 |
14.471 |
99 |
23 |
46 |
0 |
1407304176 |
16359216 |
4900928 |
16:19:28 |
111774 |
8192000000 |
10282203584 |
10740432896 |
1323721360 |
13.910 |
95 |
13 |
26 |
1 |
1336441120 |
9464528 |
3255232 |
16:22:57 |
64347 |
8192000000 |
10252625216 |
10706173952 |
1312319408 |
13.807 |
96 |
23 |
46 |
0 |
1326706128 |
9144272 |
5242448 |
16:25:02 |
78295 |
8192000000 |
10266078592 |
10723303424 |
1347110768 |
14.121 |
98 |
8 |
16 |
0 |
1358651216 |
9634176 |
1906272 |
16:27:24 |
42841 |
8192000000 |
10260008464 |
10709438464 |
1317519824 |
13.854 |
96 |
25 |
50 |
0 |
1336997280 |
12784160 |
6693296 |
16:29:08 |
55570 |
8192000000 |
10249670528 |
10703753216 |
1340325040 |
14.060 |
98 |
17 |
34 |
0 |
1353541008 |
9635376 |
3580592 |
16:31:03 |
30198 |
8192000000 |
10228362624 |
10666901504 |
1260845568 |
13.338 |
93 |
29 |
59 |
1 |
1276565904 |
8901280 |
6819056 |
16:32:39 |
39280 |
8192000000 |
10261596208 |
10703032320 |
1319550272 |
13.873 |
98 |
19 |
36 |
0 |
1330927168 |
6994304 |
4382592 |
16:34:23 |
78105 |
8192000000 |
10269495744 |
10722549760 |
1334963488 |
14.012 |
98 |
13 |
26 |
0 |
1354749936 |
16474976 |
3311472 |
16:36:42 |
41450 |
8192000000 |
10274290032 |
10726064128 |
1351772880 |
14.163 |
99 |
27 |
55 |
1 |
1371957328 |
13780752 |
6403696 |
Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 26-07-2022 16:39:32 to 26-07-2022 16:39:47.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
except |
108 |
v_add_invoice_to_stock |
335544517 |
except |
9 |
v_cancel_supplier_invoice |
335544517 |
Completed "Exceptions occured during test was in run". Done for 00:00:02, from 26-07-2022 16:39:48 to 26-07-2022 16:39:50.
MON$DATABASE_NAME /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 251505
MON$OLDEST_ACTIVE 252353
MON$OLDEST_SNAPSHOT 252353
MON$NEXT_TRANSACTION 252353
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-03 16:41:55.3470
MON$PAGES 2059552
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: LI-V3.0.11.33613 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.11.33613 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.11.33613 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.11.33613 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
on disk structure version 12.0
Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================
Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================
--- start of diff output ---
--- end of diff output ---
26.07.22 16:39:51. There are 3 logs in /var/tmp/logs-oltp30 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 |
2022-07-26 16:39:53 |
No severe PSQL-related problems occured |
26.07.22 16:39:55. End of report.