Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 15.07.2022 22: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 | 15794132 kB |
MemAvailable | 31076968 kB |
Buffers | 0 kB |
Cached | 15896224 kB |
SwapCached | 2500 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-15 22:38:20
DTS_END 2022-07-15 22:38:20.1970
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/47376
TRN_ID 241395
ATT_ID 696
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: |
9661.29 |
24426 |
1159355 |
customer order: creation |
175.21 |
360 |
21025 |
customer order: refuse |
15.23 |
371 |
1827 |
order to supplier: creation |
47.82 |
1195 |
5738 |
order to supplier: removal |
3.93 |
100187 |
471 |
invoice (draft): creation |
47.12 |
3248 |
5654 |
invoice (draft): removal |
56.73 |
770 |
6808 |
invoice accept: apply |
42.53 |
17349 |
5103 |
invoice accept: cancel |
51.16 |
844 |
6139 |
customer reserve: creation |
3910.54 |
171 |
469265 |
customer reserve: removal |
5006.52 |
62 |
600783 |
realization accept: apply |
85.05 |
201 |
10206 |
realization accept: cancel |
86.30 |
119 |
10356 |
payment from customer: creation |
61.04 |
119 |
7325 |
payment from customer: removal |
5.91 |
90 |
709 |
payment to supplier: creation |
50.20 |
132 |
6024 |
payment to supplier: removal |
3.65 |
83 |
438 |
service: total inventory turnovers |
4.71 |
1171 |
565 |
service: total monetary turnovers |
6.92 |
47 |
830 |
service: aggregate perf. data |
0.71 |
25122 |
85 |
service: refresh index statistics |
0.03 |
336870 |
4 |
Completed "Performance in TOTAL". Done for 00:00:02, from 15-07-2022 22:39:10 to 15-07-2022 22:39:12.
TEST_PHASE_NAME |
MINUTES_PASSED |
PERF_SCORE |
TEST_TIME |
1 |
2960 |
TEST_TIME |
2 |
3230 |
TEST_TIME |
3 |
4502 |
TEST_TIME |
4 |
4670 |
TEST_TIME |
5 |
4614 |
TEST_TIME |
6 |
4603 |
TEST_TIME |
7 |
4836 |
TEST_TIME |
8 |
4934 |
TEST_TIME |
9 |
5683 |
TEST_TIME |
10 |
6043 |
TEST_TIME |
11 |
6033 |
TEST_TIME |
12 |
6206 |
TEST_TIME |
13 |
6394 |
TEST_TIME |
14 |
6665 |
TEST_TIME |
15 |
7072 |
TEST_TIME |
16 |
7302 |
TEST_TIME |
17 |
7397 |
TEST_TIME |
18 |
7560 |
TEST_TIME |
19 |
7642 |
TEST_TIME |
20 |
7604 |
TEST_TIME |
21 |
8109 |
TEST_TIME |
22 |
8498 |
TEST_TIME |
23 |
8575 |
TEST_TIME |
24 |
8856 |
TEST_TIME |
25 |
9080 |
TEST_TIME |
26 |
9309 |
TEST_TIME |
27 |
9562 |
TEST_TIME |
28 |
9566 |
TEST_TIME |
29 |
9649 |
TEST_TIME |
30 |
9873 |
TEST_TIME |
31 |
10066 |
TEST_TIME |
32 |
11046 |
TEST_TIME |
33 |
10988 |
TEST_TIME |
34 |
10791 |
TEST_TIME |
35 |
10715 |
TEST_TIME |
36 |
10862 |
TEST_TIME |
37 |
10746 |
TEST_TIME |
38 |
10887 |
TEST_TIME |
39 |
10829 |
TEST_TIME |
40 |
10706 |
TEST_TIME |
41 |
10581 |
TEST_TIME |
42 |
10604 |
TEST_TIME |
43 |
10454 |
TEST_TIME |
44 |
10261 |
TEST_TIME |
45 |
10098 |
TEST_TIME |
46 |
10266 |
TEST_TIME |
47 |
10235 |
TEST_TIME |
48 |
10146 |
TEST_TIME |
49 |
10071 |
TEST_TIME |
50 |
10054 |
TEST_TIME |
51 |
10014 |
TEST_TIME |
52 |
9885 |
TEST_TIME |
53 |
9978 |
TEST_TIME |
54 |
10087 |
TEST_TIME |
55 |
10052 |
TEST_TIME |
56 |
9985 |
TEST_TIME |
57 |
9901 |
TEST_TIME |
58 |
9809 |
TEST_TIME |
59 |
9836 |
TEST_TIME |
60 |
9851 |
TEST_TIME |
61 |
9825 |
TEST_TIME |
62 |
9764 |
TEST_TIME |
63 |
9774 |
TEST_TIME |
64 |
9759 |
TEST_TIME |
65 |
9711 |
TEST_TIME |
66 |
9649 |
TEST_TIME |
67 |
9711 |
TEST_TIME |
68 |
9715 |
TEST_TIME |
69 |
9803 |
TEST_TIME |
70 |
9790 |
TEST_TIME |
71 |
9823 |
TEST_TIME |
72 |
9818 |
TEST_TIME |
73 |
9791 |
TEST_TIME |
74 |
9967 |
TEST_TIME |
75 |
9957 |
TEST_TIME |
76 |
9942 |
TEST_TIME |
77 |
9923 |
TEST_TIME |
78 |
9888 |
TEST_TIME |
79 |
9805 |
TEST_TIME |
80 |
9846 |
TEST_TIME |
81 |
9768 |
TEST_TIME |
82 |
9729 |
TEST_TIME |
83 |
9691 |
TEST_TIME |
84 |
9644 |
TEST_TIME |
85 |
9662 |
TEST_TIME |
86 |
9685 |
TEST_TIME |
87 |
9687 |
TEST_TIME |
88 |
9661 |
TEST_TIME |
89 |
9660 |
TEST_TIME |
90 |
9672 |
TEST_TIME |
91 |
9692 |
TEST_TIME |
92 |
9789 |
TEST_TIME |
93 |
9777 |
TEST_TIME |
94 |
9797 |
TEST_TIME |
95 |
9857 |
TEST_TIME |
96 |
9876 |
TEST_TIME |
97 |
9885 |
TEST_TIME |
98 |
9841 |
TEST_TIME |
99 |
9872 |
TEST_TIME |
100 |
9866 |
TEST_TIME |
101 |
9808 |
TEST_TIME |
102 |
9783 |
TEST_TIME |
103 |
9732 |
TEST_TIME |
104 |
9700 |
TEST_TIME |
105 |
9656 |
TEST_TIME |
106 |
9669 |
TEST_TIME |
107 |
9665 |
TEST_TIME |
108 |
9668 |
TEST_TIME |
109 |
9620 |
TEST_TIME |
110 |
9597 |
TEST_TIME |
111 |
9624 |
TEST_TIME |
112 |
9627 |
TEST_TIME |
113 |
9623 |
TEST_TIME |
114 |
9674 |
TEST_TIME |
115 |
9667 |
TEST_TIME |
116 |
9671 |
TEST_TIME |
117 |
9658 |
TEST_TIME |
118 |
9661 |
TEST_TIME |
119 |
9686 |
TEST_TIME |
120 |
9661 |
Completed "Performance for every MINUTE". Done for 00:00:04, from 15-07-2022 22:39:13 to 15-07-2022 22:39:17.
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 |
1596248 |
1596248 |
0 |
0.00 |
0 |
19791 |
6 |
0 |
0 |
doc_list_biud |
1596235 |
1596235 |
0 |
0.00 |
0 |
26572 |
29 |
0 |
0 |
sp_add_invoice_to_stock |
5226 |
5103 |
123 |
2.35 |
45 |
172539 |
17349 |
0 |
123 |
sp_cancel_adding_invoice |
6139 |
6139 |
0 |
0.00 |
3 |
56726 |
845 |
0 |
0 |
sp_cancel_client_order |
1827 |
1827 |
0 |
0.00 |
4 |
8052 |
371 |
0 |
0 |
sp_cancel_customer_reserve |
600783 |
600783 |
0 |
0.00 |
0 |
26543 |
62 |
0 |
0 |
sp_cancel_pay_from_customer |
709 |
709 |
0 |
0.00 |
2 |
4259 |
91 |
0 |
0 |
sp_cancel_pay_to_supplier |
438 |
438 |
0 |
0.00 |
3 |
5273 |
84 |
0 |
0 |
sp_cancel_supplier_invoice |
6818 |
6808 |
10 |
0.14 |
1 |
16698 |
770 |
0 |
10 |
sp_cancel_supplier_order |
471 |
471 |
0 |
0.00 |
5 |
1166631 |
100188 |
0 |
0 |
sp_cancel_write_off |
10356 |
10356 |
0 |
0.00 |
1 |
23179 |
119 |
0 |
0 |
sp_client_order |
21025 |
21025 |
0 |
0.00 |
3 |
20590 |
361 |
0 |
0 |
sp_customer_reserve |
469265 |
469265 |
0 |
0.00 |
0 |
35852 |
171 |
0 |
0 |
sp_fill_shopping_cart |
32410 |
32410 |
0 |
0.00 |
1 |
15000 |
34 |
0 |
0 |
sp_fill_shopping_cart_clo_res |
469264 |
469264 |
0 |
0.00 |
0 |
24071 |
14 |
0 |
0 |
sp_get_clo_for_invoice |
5102 |
5102 |
0 |
0.00 |
0 |
33288 |
272 |
0 |
0 |
sp_kill_cost_storno |
17642 |
17642 |
0 |
0.00 |
0 |
18507 |
58 |
0 |
0 |
sp_kill_qstorno_ret_qs2qd |
1219201 |
1219201 |
0 |
0.00 |
0 |
24283 |
33 |
0 |
0 |
sp_kill_qty_storno |
641684 |
641684 |
0 |
0.00 |
0 |
26572 |
72 |
0 |
0 |
sp_lock_selected_doc |
21250 |
21250 |
0 |
0.00 |
0 |
9732 |
6 |
0 |
0 |
sp_make_cost_storno |
28657 |
28657 |
0 |
0.00 |
0 |
19786 |
58 |
0 |
0 |
sp_multiply_rows_for_pdistr |
28644 |
28644 |
0 |
0.00 |
0 |
6510 |
26 |
0 |
0 |
sp_multiply_rows_for_qdistr |
21025 |
21025 |
0 |
0.00 |
0 |
20581 |
159 |
0 |
0 |
sp_pay_from_customer |
7325 |
7325 |
0 |
0.00 |
4 |
17031 |
120 |
0 |
0 |
sp_pay_to_supplier |
6024 |
6024 |
0 |
0.00 |
4 |
12013 |
133 |
0 |
0 |
sp_payment_common |
13344 |
13344 |
0 |
0.00 |
1 |
16942 |
30 |
0 |
0 |
sp_qd_handle_on_cancel_clo |
1827 |
1827 |
0 |
0.00 |
0 |
7102 |
330 |
0 |
0 |
sp_qd_handle_on_invoice_upd_sts |
11236 |
11236 |
0 |
0.00 |
0 |
22220 |
342 |
0 |
0 |
sp_qd_handle_on_reserve_upd_sts |
10203 |
10203 |
0 |
0.00 |
0 |
26571 |
66 |
0 |
0 |
sp_reserve_write_off |
10206 |
10206 |
0 |
0.00 |
6 |
26587 |
201 |
0 |
0 |
sp_supplier_invoice |
5654 |
5654 |
0 |
0.00 |
5 |
99257 |
3249 |
0 |
0 |
sp_supplier_order |
5738 |
5738 |
0 |
0.00 |
5 |
34249 |
1196 |
0 |
0 |
srv_aggregate_perf_data |
85 |
85 |
0 |
0.00 |
2770 |
576654 |
25123 |
0 |
0 |
srv_fill_mon_cache_memory |
64 |
64 |
0 |
0.00 |
1691 |
108164 |
43202 |
0 |
0 |
srv_find_qd_qs_mism |
1111717 |
1111717 |
0 |
0.00 |
0 |
17243 |
5 |
0 |
0 |
srv_make_invnt_saldo |
565 |
565 |
0 |
0.00 |
47 |
128941 |
1172 |
0 |
0 |
srv_make_money_saldo |
830 |
830 |
0 |
0.00 |
1 |
15556 |
47 |
0 |
0 |
srv_recalc_idx_stat |
4 |
4 |
0 |
0.00 |
194851 |
600289 |
336871 |
0 |
0 |
t$perf-abend:sp_add_invoice_to_stock |
123 |
123 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-abend:sp_cancel_supplier_invoice |
10 |
10 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-norm:sp_add_invoice_to_stock |
5103 |
5103 |
0 |
0.00 |
0 |
11385 |
187 |
0 |
0 |
t$perf-norm:sp_cancel_adding_invoice |
420 |
420 |
0 |
0.00 |
0 |
7818 |
132 |
0 |
0 |
t$perf-norm:sp_cancel_client_order |
1827 |
1827 |
0 |
0.00 |
0 |
3113 |
15 |
0 |
0 |
t$perf-norm:sp_cancel_customer_reserve |
691 |
691 |
0 |
0.00 |
0 |
4342 |
21 |
0 |
0 |
t$perf-norm:sp_cancel_pay_from_customer |
709 |
709 |
0 |
0.00 |
0 |
2064 |
7 |
0 |
0 |
t$perf-norm:sp_cancel_pay_to_supplier |
438 |
438 |
0 |
0.00 |
0 |
1126 |
5 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_invoice |
404 |
404 |
0 |
0.00 |
0 |
727 |
19 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_order |
471 |
471 |
0 |
0.00 |
0 |
15357 |
1462 |
0 |
0 |
t$perf-norm:sp_cancel_write_off |
990 |
990 |
0 |
0.00 |
0 |
10260 |
23 |
0 |
0 |
t$perf-norm:sp_client_order |
21025 |
21025 |
0 |
0.00 |
0 |
7932 |
19 |
0 |
0 |
t$perf-norm:sp_customer_reserve |
1027 |
1027 |
0 |
0.00 |
0 |
4078 |
19 |
0 |
0 |
t$perf-norm:sp_pay_from_customer |
7325 |
7325 |
0 |
0.00 |
0 |
7079 |
9 |
0 |
0 |
t$perf-norm:sp_pay_to_supplier |
6024 |
6024 |
0 |
0.00 |
0 |
9050 |
13 |
0 |
0 |
t$perf-norm:sp_reserve_write_off |
10206 |
10206 |
0 |
0.00 |
0 |
7655 |
12 |
0 |
0 |
t$perf-norm:sp_supplier_invoice |
5654 |
5654 |
0 |
0.00 |
0 |
7581 |
20 |
0 |
0 |
t$perf-norm:sp_supplier_order |
5738 |
5738 |
0 |
0.00 |
0 |
4517 |
18 |
0 |
0 |
t$perf-norm:srv_aggregate_perf_data |
85 |
85 |
0 |
0.00 |
0 |
653 |
12 |
0 |
0 |
t$perf-norm:srv_fill_mon_cache_memory |
64 |
64 |
0 |
0.00 |
0 |
54 |
2 |
0 |
0 |
t$perf-norm:srv_make_invnt_saldo |
565 |
565 |
0 |
0.00 |
0 |
864 |
20 |
0 |
0 |
t$perf-norm:srv_make_money_saldo |
830 |
830 |
0 |
0.00 |
0 |
1523 |
24 |
0 |
0 |
t$perf-norm:srv_recalc_idx_stat |
4 |
4 |
0 |
0.00 |
1 |
20 |
7 |
0 |
0 |
v_add_invoice_to_stock |
10440 |
10194 |
246 |
2.35 |
0 |
7937 |
21 |
0 |
246 |
v_all_customers |
38744 |
38744 |
0 |
0.00 |
0 |
32 |
1 |
0 |
0 |
v_all_suppliers |
31698 |
31698 |
0 |
0.00 |
0 |
20 |
1 |
0 |
0 |
v_all_wares |
42050 |
42050 |
0 |
0.00 |
0 |
35 |
1 |
0 |
0 |
v_cancel_adding_invoice |
840 |
840 |
0 |
0.00 |
0 |
10039 |
20 |
0 |
0 |
v_cancel_client_order |
3654 |
3654 |
0 |
0.00 |
0 |
6318 |
9 |
0 |
0 |
v_cancel_customer_prepayment |
1418 |
1418 |
0 |
0.00 |
0 |
3364 |
10 |
0 |
0 |
v_cancel_customer_reserve |
1382 |
1382 |
0 |
0.00 |
0 |
2164 |
6 |
0 |
0 |
v_cancel_payment_to_supplier |
876 |
876 |
0 |
0.00 |
0 |
307 |
4 |
0 |
0 |
v_cancel_supplier_invoice |
828 |
808 |
20 |
2.41 |
0 |
2150 |
20 |
0 |
20 |
v_cancel_supplier_order |
942 |
942 |
0 |
0.00 |
0 |
1892 |
9 |
0 |
0 |
v_cancel_write_off |
1980 |
1980 |
0 |
0.00 |
0 |
10454 |
23 |
0 |
0 |
v_max_id_clo_ord |
5738 |
5738 |
0 |
0.00 |
0 |
346 |
1 |
0 |
0 |
v_max_id_clo_res |
1027 |
1027 |
0 |
0.00 |
0 |
3020 |
13 |
0 |
0 |
v_max_id_ord_sup |
5647 |
5647 |
0 |
0.00 |
0 |
3114 |
3 |
0 |
0 |
v_max_non_paid_invoice |
1558 |
1558 |
0 |
0.00 |
0 |
1090 |
4 |
0 |
0 |
v_max_non_paid_realizn |
3748 |
3748 |
0 |
0.00 |
0 |
2740 |
5 |
0 |
0 |
v_min_id_clo_ord |
5738 |
5738 |
0 |
0.00 |
0 |
6271 |
10 |
0 |
0 |
v_min_id_clo_res |
1027 |
1027 |
0 |
0.00 |
0 |
3261 |
10 |
0 |
0 |
v_min_id_ord_sup |
5647 |
5647 |
0 |
0.00 |
0 |
4702 |
8 |
0 |
0 |
v_min_non_paid_invoice |
6022 |
6022 |
0 |
0.00 |
0 |
8026 |
22 |
0 |
0 |
v_min_non_paid_realizn |
7322 |
7322 |
0 |
0.00 |
0 |
9375 |
22 |
0 |
0 |
v_our_firm |
10454 |
10454 |
0 |
0.00 |
0 |
18 |
1 |
0 |
0 |
v_reserve_write_off |
20406 |
20406 |
0 |
0.00 |
0 |
10028 |
9 |
0 |
0 |
x_lock_depdocs_on_canc_invoice |
12543 |
12543 |
0 |
0.00 |
0 |
19083 |
115 |
0 |
0 |
x_lock_depdocs_on_canc_sup_ord |
471 |
471 |
0 |
0.00 |
0 |
9585 |
364 |
0 |
0 |
x_make_qstorno_1000_1200 |
5738 |
5738 |
0 |
0.00 |
1 |
34240 |
1116 |
0 |
0 |
x_make_qstorno_1200_2000 |
5654 |
5654 |
0 |
0.00 |
2 |
99242 |
3132 |
0 |
0 |
x_make_qstorno_2100_3300 |
469265 |
469265 |
0 |
0.00 |
0 |
35850 |
154 |
0 |
0 |
Completed "Performance in DETAILS". Done for 00:00:04, from 15-07-2022 22:39:18 to 15-07-2022 22:39:22.
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 |
20:08:23 |
1 |
8192000000 |
8797619040 |
8808398848 |
3955424 |
0.048 |
1 |
1 |
2 |
0 |
4053696 |
55488 |
42784 |
20:09:25 |
3378 |
8192000000 |
9867162512 |
10169139200 |
957068944 |
10.460 |
100 |
84 |
168 |
0 |
984801104 |
5448816 |
22283344 |
20:10:32 |
16551 |
8192000000 |
9918814272 |
10231095296 |
1001452512 |
10.893 |
100 |
90 |
180 |
0 |
1032592112 |
7519056 |
23620544 |
20:11:54 |
14025 |
8192000000 |
9944761520 |
10266128384 |
1026024448 |
11.130 |
100 |
87 |
174 |
0 |
1057642848 |
9161648 |
22456752 |
20:13:12 |
11022 |
8192000000 |
9995176224 |
10331676672 |
1074299952 |
11.593 |
100 |
79 |
156 |
0 |
1103016512 |
9927552 |
18789008 |
20:14:25 |
6179 |
8192000000 |
10048273296 |
10397835264 |
1136931824 |
12.187 |
100 |
87 |
172 |
0 |
1168965344 |
12185360 |
19848160 |
20:15:36 |
6901 |
8192000000 |
10090940576 |
10451197952 |
1176930720 |
12.562 |
100 |
78 |
156 |
0 |
1207082784 |
12320688 |
17831376 |
20:16:44 |
4081 |
8192000000 |
10128192304 |
10499084288 |
1219169184 |
12.954 |
100 |
90 |
176 |
1 |
1252307456 |
13123504 |
20014768 |
20:17:51 |
1841 |
8192000000 |
10156640592 |
10533306368 |
1246666288 |
13.208 |
100 |
83 |
164 |
0 |
1279119824 |
14294416 |
18159120 |
20:19:02 |
1931 |
8192000000 |
10190086064 |
10572636160 |
1278812400 |
13.502 |
100 |
86 |
173 |
2 |
1310163392 |
11761040 |
19589952 |
20:20:06 |
1833 |
8192000000 |
10212077200 |
10592337920 |
1290936576 |
13.613 |
100 |
86 |
172 |
1 |
1323155232 |
13315008 |
18903648 |
20:21:10 |
7782 |
8192000000 |
10210427296 |
10599133184 |
1300804896 |
13.703 |
100 |
78 |
156 |
1 |
1330512992 |
12348896 |
17359200 |
20:22:19 |
3313 |
8192000000 |
10211012640 |
10609819648 |
1305925104 |
13.749 |
100 |
62 |
124 |
1 |
1332443824 |
12367744 |
14150976 |
20:23:24 |
5573 |
8192000000 |
10210584112 |
10621886464 |
1318948592 |
13.867 |
100 |
37 |
73 |
0 |
1334649392 |
7794224 |
7906576 |
20:24:33 |
4679 |
8192000000 |
10211004928 |
10623913984 |
1322398672 |
13.898 |
100 |
27 |
52 |
2 |
1334693984 |
6260560 |
6034752 |
20:25:39 |
5026 |
8192000000 |
10227644720 |
10633424896 |
1324362720 |
13.916 |
100 |
53 |
104 |
0 |
1343528352 |
6849840 |
12315792 |
20:26:47 |
4508 |
8192000000 |
10214699824 |
10632196096 |
1318534928 |
13.863 |
100 |
34 |
68 |
0 |
1338316992 |
12289248 |
7492816 |
20:27:54 |
8067 |
8192000000 |
10223814592 |
10638544896 |
1328771024 |
13.956 |
100 |
23 |
46 |
0 |
1339211488 |
5391936 |
5048528 |
20:29:04 |
6771 |
8192000000 |
10205006224 |
10616832000 |
1300243216 |
13.697 |
99 |
20 |
39 |
0 |
1310271312 |
5963776 |
4064320 |
20:30:17 |
11574 |
8192000000 |
10185501504 |
10598645760 |
1277393280 |
13.489 |
98 |
31 |
62 |
1 |
1290569200 |
6044064 |
7131856 |
20:31:30 |
5903 |
8192000000 |
10151768608 |
10554052608 |
1225874160 |
13.016 |
96 |
24 |
49 |
0 |
1237761456 |
6226416 |
5660880 |
20:32:41 |
9095 |
8192000000 |
10173506864 |
10577473536 |
1267242064 |
13.396 |
100 |
20 |
38 |
0 |
1290264848 |
19055872 |
3966912 |
20:33:53 |
49994 |
8192000000 |
10140354512 |
10529009664 |
1221451312 |
12.975 |
98 |
33 |
66 |
0 |
1234306352 |
4628176 |
8226864 |
20:35:49 |
4116 |
8192000000 |
10169609888 |
10574004224 |
1276307328 |
13.479 |
100 |
37 |
74 |
0 |
1292396448 |
7165632 |
8923488 |
20:36:55 |
3523 |
8192000000 |
10197432384 |
10603585536 |
1298678192 |
13.683 |
100 |
39 |
80 |
2 |
1312814544 |
4680016 |
9456336 |
20:38:01 |
7623 |
8192000000 |
10207286432 |
10621632512 |
1315894720 |
13.840 |
100 |
21 |
42 |
1 |
1326259376 |
5056400 |
5308256 |
20:39:10 |
23130 |
8192000000 |
10239794880 |
10649935872 |
1338495440 |
14.044 |
100 |
53 |
105 |
1 |
1356931040 |
6312000 |
12123600 |
20:40:53 |
8531 |
8192000000 |
10254943664 |
10669809664 |
1352718336 |
14.172 |
100 |
49 |
98 |
1 |
1376543440 |
13196768 |
10628336 |
20:42:10 |
12420 |
8192000000 |
10274183440 |
10694197248 |
1366970656 |
14.300 |
100 |
43 |
86 |
0 |
1386129472 |
9356496 |
9802320 |
20:43:27 |
9225 |
8192000000 |
10290484784 |
10706620416 |
1368452848 |
14.313 |
99 |
43 |
81 |
0 |
1388181792 |
10134896 |
9594048 |
20:44:45 |
23341 |
8192000000 |
10288908080 |
10723008512 |
1386150992 |
14.472 |
100 |
36 |
72 |
0 |
1408225600 |
12682784 |
9391824 |
20:46:16 |
6860 |
8192000000 |
10318877488 |
10741198848 |
1398050736 |
14.578 |
100 |
56 |
111 |
1 |
1429235072 |
18070320 |
13114016 |
20:47:27 |
10588 |
8192000000 |
10323071184 |
10754404352 |
1406482928 |
14.653 |
100 |
58 |
115 |
1 |
1440633632 |
18919104 |
15231600 |
20:48:41 |
4949 |
8192000000 |
10336470640 |
10762403840 |
1412723968 |
14.708 |
100 |
57 |
114 |
1 |
1447770320 |
21087856 |
13958496 |
20:49:50 |
34105 |
8192000000 |
10337908992 |
10771111936 |
1419538896 |
14.769 |
100 |
43 |
86 |
0 |
1451563504 |
20829792 |
11194816 |
20:51:47 |
3460 |
8192000000 |
10347935920 |
10771148800 |
1408336128 |
14.669 |
99 |
72 |
142 |
1 |
1447401760 |
22372160 |
16693472 |
20:52:57 |
3004 |
8192000000 |
10364641632 |
10784497664 |
1421999568 |
14.790 |
100 |
84 |
165 |
0 |
1468906784 |
27133792 |
19773424 |
20:54:03 |
3371 |
8192000000 |
10364259088 |
10793234432 |
1429942832 |
14.861 |
100 |
67 |
134 |
2 |
1473374544 |
26885216 |
16546496 |
20:55:17 |
2170 |
8192000000 |
10358370464 |
10778914816 |
1428314208 |
14.846 |
100 |
76 |
150 |
0 |
1470309088 |
24084288 |
17910592 |
20:56:27 |
6295 |
8192000000 |
10330531536 |
10745470976 |
1383177232 |
14.445 |
99 |
68 |
135 |
0 |
1430176528 |
30106352 |
16892944 |
20:57:40 |
1691 |
8192000000 |
10319152256 |
10723667968 |
1367729888 |
14.307 |
99 |
82 |
161 |
1 |
1421852288 |
33727168 |
20395232 |
20:58:47 |
4155 |
8192000000 |
10352218896 |
10757144576 |
1390947360 |
14.514 |
100 |
83 |
166 |
0 |
1455254544 |
43409440 |
20897744 |
20:59:55 |
9089 |
8192000000 |
10338877696 |
10757963776 |
1392290272 |
14.526 |
100 |
44 |
86 |
1 |
1443269008 |
39089312 |
11889424 |
21:01:13 |
3521 |
8192000000 |
10330289360 |
10739380224 |
1378353024 |
14.402 |
100 |
70 |
140 |
0 |
1432942656 |
36519952 |
18069680 |
21:02:26 |
8213 |
8192000000 |
10346510976 |
10767175680 |
1391405728 |
14.518 |
100 |
48 |
94 |
2 |
1451987344 |
46762112 |
13819504 |
21:03:41 |
12568 |
8192000000 |
10342342208 |
10772819968 |
1394816096 |
14.549 |
100 |
35 |
70 |
0 |
1449990848 |
45069968 |
10104784 |
21:05:01 |
8231 |
8192000000 |
10370483872 |
10800852992 |
1411503744 |
14.697 |
100 |
48 |
94 |
1 |
1474054624 |
48641680 |
13909200 |
21:06:23 |
30289 |
8192000000 |
10351252160 |
10787221504 |
1400346912 |
14.598 |
100 |
34 |
68 |
0 |
1457510112 |
47149360 |
10013840 |
21:08:40 |
19368 |
8192000000 |
10329283040 |
10782896128 |
1387792384 |
14.486 |
100 |
18 |
36 |
0 |
1433378112 |
40598752 |
4986976 |
21:11:01 |
85355 |
8192000000 |
10293938864 |
10734456832 |
1343534320 |
14.089 |
97 |
10 |
18 |
0 |
1356973584 |
11705200 |
1734064 |
21:13:34 |
78610 |
8192000000 |
10265753296 |
10706059264 |
1331058608 |
13.977 |
97 |
11 |
22 |
0 |
1348000176 |
14587568 |
2354000 |
21:15:54 |
60877 |
8192000000 |
10279130848 |
10730786816 |
1356138112 |
14.203 |
99 |
10 |
20 |
0 |
1371227600 |
12806816 |
2282672 |
21:17:56 |
66957 |
8192000000 |
10295429888 |
10734706688 |
1377761616 |
14.397 |
100 |
15 |
30 |
0 |
1391227696 |
9721040 |
3745040 |
21:20:06 |
71508 |
8192000000 |
10296232208 |
10739789824 |
1377823264 |
14.397 |
100 |
21 |
40 |
1 |
1399440304 |
17323296 |
4293744 |
21:22:21 |
67707 |
8192000000 |
10312614816 |
10749489152 |
1371745024 |
14.343 |
99 |
39 |
75 |
0 |
1398804896 |
18601552 |
8458320 |
21:24:32 |
70993 |
8192000000 |
10299167728 |
10750398464 |
1382496832 |
14.439 |
100 |
18 |
35 |
0 |
1398335728 |
11580400 |
4258496 |
21:26:49 |
42866 |
8192000000 |
10277110912 |
10738700288 |
1354971040 |
14.192 |
98 |
11 |
22 |
0 |
1369419904 |
12121600 |
2327264 |
21:28:34 |
46347 |
8192000000 |
10296355040 |
10751995904 |
1386371888 |
14.473 |
100 |
17 |
36 |
0 |
1403661008 |
13301680 |
3987440 |
21:30:52 |
25753 |
8192000000 |
10328759472 |
10766536704 |
1395382912 |
14.554 |
100 |
57 |
114 |
0 |
1430911664 |
21198576 |
14330176 |
21:32:19 |
43420 |
8192000000 |
10289293328 |
10761703424 |
1392665872 |
14.530 |
100 |
12 |
24 |
0 |
1406176272 |
10966704 |
2543696 |
21:34:14 |
47655 |
8192000000 |
10283298352 |
10743554048 |
1355004896 |
14.192 |
97 |
8 |
16 |
0 |
1362822400 |
6245232 |
1572272 |
21:36:11 |
93492 |
8192000000 |
10283430480 |
10746982400 |
1374881216 |
14.371 |
99 |
18 |
37 |
0 |
1390565280 |
11499968 |
4184096 |
21:38:50 |
81623 |
8192000000 |
10273362112 |
10728939520 |
1307690224 |
13.765 |
94 |
15 |
29 |
0 |
1317721968 |
7022624 |
3009120 |
21:41:13 |
66963 |
8192000000 |
10250800816 |
10715222016 |
1333037712 |
13.995 |
97 |
12 |
24 |
0 |
1345532560 |
9580816 |
2914032 |
21:43:39 |
32288 |
8192000000 |
10260028144 |
10709368832 |
1328183424 |
13.951 |
97 |
14 |
26 |
0 |
1337599216 |
6961440 |
2454352 |
21:45:13 |
63890 |
8192000000 |
10277056896 |
10733842432 |
1356401456 |
14.205 |
99 |
19 |
38 |
0 |
1376364384 |
15709376 |
4253552 |
21:47:34 |
62823 |
8192000000 |
10259024896 |
10707472384 |
1304720880 |
13.738 |
96 |
14 |
28 |
0 |
1318803776 |
10789184 |
3293712 |
21:49:41 |
70838 |
8192000000 |
10283650400 |
10728976384 |
1332334096 |
13.988 |
98 |
30 |
60 |
0 |
1354647936 |
16021104 |
6292736 |
21:51:55 |
67031 |
8192000000 |
10265987712 |
10743394304 |
1339241984 |
14.051 |
98 |
15 |
30 |
0 |
1366311712 |
23653536 |
3416192 |
21:54:03 |
76801 |
8192000000 |
10276167872 |
10722074624 |
1339444400 |
14.052 |
98 |
18 |
35 |
2 |
1351793232 |
8229280 |
4119552 |
21:56:22 |
87315 |
8192000000 |
10270159808 |
10710065152 |
1339478688 |
14.053 |
98 |
26 |
52 |
0 |
1355588384 |
10597952 |
5511744 |
21:58:52 |
72010 |
8192000000 |
10287477824 |
10734895104 |
1366842368 |
14.299 |
99 |
27 |
54 |
2 |
1389276560 |
15989856 |
6444336 |
22:01:04 |
64743 |
8192000000 |
10262890192 |
10720288768 |
1335173120 |
14.014 |
98 |
14 |
28 |
0 |
1358100912 |
19922240 |
3005552 |
22:03:10 |
66452 |
8192000000 |
10268969360 |
10739777536 |
1353723328 |
14.181 |
99 |
12 |
24 |
0 |
1386112544 |
29346048 |
3043168 |
22:05:19 |
41158 |
8192000000 |
10264842192 |
10717167616 |
1333542832 |
13.999 |
98 |
14 |
28 |
0 |
1345232176 |
8497232 |
3192112 |
22:07:22 |
47035 |
8192000000 |
10268315408 |
10717036544 |
1345990736 |
14.111 |
99 |
20 |
40 |
0 |
1362187536 |
11779952 |
4416848 |
22:09:11 |
70352 |
8192000000 |
10284925536 |
10752782336 |
1379452496 |
14.412 |
100 |
16 |
32 |
0 |
1395226400 |
12384848 |
3389056 |
22:11:51 |
62534 |
8192000000 |
10304762640 |
10769113088 |
1379736336 |
14.414 |
99 |
13 |
26 |
0 |
1400040688 |
17211168 |
3093184 |
22:13:54 |
33200 |
8192000000 |
10290470384 |
10739630080 |
1347007872 |
14.121 |
97 |
28 |
56 |
0 |
1363630160 |
9987648 |
6634640 |
22:15:44 |
58565 |
8192000000 |
10311775888 |
10759958528 |
1381232912 |
14.428 |
99 |
30 |
60 |
1 |
1399758560 |
11967152 |
6558496 |
22:17:50 |
18735 |
8192000000 |
10317799728 |
10769080320 |
1400220608 |
14.597 |
100 |
27 |
53 |
0 |
1418630048 |
12398528 |
6010912 |
22:19:17 |
108164 |
8192000000 |
10304307760 |
10774454272 |
1402741024 |
14.619 |
100 |
23 |
46 |
0 |
1416206288 |
8741024 |
4724240 |
22:22:14 |
67772 |
8192000000 |
10294081856 |
10760454144 |
1374700976 |
14.369 |
98 |
16 |
32 |
0 |
1385706336 |
7364944 |
3640416 |
22:24:31 |
82240 |
8192000000 |
10293241296 |
10759839744 |
1391717552 |
14.521 |
100 |
15 |
30 |
0 |
1406701728 |
11219264 |
3764912 |
22:27:31 |
38354 |
8192000000 |
10300171552 |
10759323648 |
1381821504 |
14.433 |
99 |
26 |
49 |
2 |
1397777536 |
10604608 |
5351424 |
22:29:28 |
59863 |
8192000000 |
10285763216 |
10755567616 |
1363561056 |
14.269 |
98 |
9 |
18 |
0 |
1377469872 |
12042576 |
1866240 |
22:31:35 |
49812 |
8192000000 |
10288521808 |
10754412544 |
1372405408 |
14.349 |
99 |
17 |
34 |
0 |
1389118112 |
12232432 |
4480272 |
22:33:25 |
28305 |
8192000000 |
10286348032 |
10742034432 |
1358348752 |
14.223 |
98 |
38 |
76 |
1 |
1376612448 |
9505056 |
8758640 |
22:35:01 |
40326 |
8192000000 |
10297567008 |
10749304832 |
1359282208 |
14.231 |
98 |
19 |
36 |
0 |
1371182176 |
7878992 |
4020976 |
22:36:44 |
95551 |
8192000000 |
10283315712 |
10742333440 |
1315440960 |
13.835 |
95 |
24 |
48 |
0 |
1335755200 |
15436016 |
4878224 |
Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:16, from 15-07-2022 22:39:23 to 15-07-2022 22:39:39.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
except |
123 |
v_add_invoice_to_stock |
335544517 |
except |
10 |
v_cancel_supplier_invoice |
335544517 |
Completed "Exceptions occured during test was in run". Done for 00:00:01, from 15-07-2022 22:39:40 to 15-07-2022 22:39:41.
MON$DATABASE_NAME /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 240301
MON$OLDEST_ACTIVE 241562
MON$OLDEST_SNAPSHOT 241562
MON$NEXT_TRANSACTION 241562
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 2063008
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.33608 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.11.33608 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.11.33608 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.11.33608 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 ---
:1136:
:1137: mscs-test-161.budzdorov.ru Fri Jul 15 22:38:36 2022
:1138: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:1139:
--- end of diff output ---
15.07.22 22:39:42. 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-15 22:39:45 |
No severe PSQL-related problems occured |
15.07.22 22:39:46. End of report.