Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 13.01.2023 01:40
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 | 15195700 kB |
MemAvailable | 30435076 kB |
Buffers | 0 kB |
Cached | 16540584 kB |
SwapCached | 4420 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 2023-01-13 01:38:32
DTS_END 2023-01-13 01:38:32.7620
FB_GDSCODE -1
FB_MNEMONA
STACK SP_CANCEL_SUPPLIER_ORDER(116:18) ==> SP_CANCEL_CUSTOMER_RESERVE(36:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(57:17)
IP ::1/48232
TRN_ID 241291
ATT_ID 644
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: |
9400.00 |
24067 |
1128000 |
customer order: creation |
174.91 |
351 |
20989 |
customer order: refuse |
15.40 |
354 |
1848 |
order to supplier: creation |
48.08 |
1257 |
5770 |
order to supplier: removal |
3.68 |
96614 |
442 |
invoice (draft): creation |
47.53 |
3306 |
5704 |
invoice (draft): removal |
54.63 |
840 |
6555 |
invoice accept: apply |
41.96 |
16934 |
5035 |
invoice accept: cancel |
48.93 |
783 |
5872 |
customer reserve: creation |
3851.73 |
168 |
462208 |
customer reserve: removal |
4810.32 |
57 |
577238 |
realization accept: apply |
86.03 |
197 |
10323 |
realization accept: cancel |
84.24 |
108 |
10109 |
payment from customer: creation |
61.10 |
139 |
7332 |
payment from customer: removal |
5.62 |
82 |
674 |
payment to supplier: creation |
50.38 |
126 |
6045 |
payment to supplier: removal |
3.59 |
101 |
431 |
service: total inventory turnovers |
4.90 |
1289 |
588 |
service: total monetary turnovers |
6.15 |
26 |
738 |
service: aggregate perf. data |
0.79 |
25777 |
95 |
service: refresh index statistics |
0.03 |
332829 |
4 |
Completed "Performance in TOTAL". Done for 00:00:02, from 13-01-2023 01:40:58 to 13-01-2023 01:41:00.
TEST_PHASE_NAME |
MINUTES_PASSED |
PERF_SCORE |
TEST_TIME |
1 |
5482 |
TEST_TIME |
2 |
3285 |
TEST_TIME |
3 |
3674 |
TEST_TIME |
4 |
3738 |
TEST_TIME |
5 |
4814 |
TEST_TIME |
6 |
4769 |
TEST_TIME |
7 |
5406 |
TEST_TIME |
8 |
6089 |
TEST_TIME |
9 |
5855 |
TEST_TIME |
10 |
6055 |
TEST_TIME |
11 |
6336 |
TEST_TIME |
12 |
6332 |
TEST_TIME |
13 |
6880 |
TEST_TIME |
14 |
6850 |
TEST_TIME |
15 |
7211 |
TEST_TIME |
16 |
7172 |
TEST_TIME |
17 |
7246 |
TEST_TIME |
18 |
7186 |
TEST_TIME |
19 |
7272 |
TEST_TIME |
20 |
7609 |
TEST_TIME |
21 |
7577 |
TEST_TIME |
22 |
7814 |
TEST_TIME |
23 |
7954 |
TEST_TIME |
24 |
8185 |
TEST_TIME |
25 |
8759 |
TEST_TIME |
26 |
9214 |
TEST_TIME |
27 |
9616 |
TEST_TIME |
28 |
11099 |
TEST_TIME |
29 |
11122 |
TEST_TIME |
30 |
11129 |
TEST_TIME |
31 |
10908 |
TEST_TIME |
32 |
10895 |
TEST_TIME |
33 |
10743 |
TEST_TIME |
34 |
10605 |
TEST_TIME |
35 |
10455 |
TEST_TIME |
36 |
10372 |
TEST_TIME |
37 |
10243 |
TEST_TIME |
38 |
10205 |
TEST_TIME |
39 |
10147 |
TEST_TIME |
40 |
10313 |
TEST_TIME |
41 |
10270 |
TEST_TIME |
42 |
10198 |
TEST_TIME |
43 |
10154 |
TEST_TIME |
44 |
10058 |
TEST_TIME |
45 |
10037 |
TEST_TIME |
46 |
9919 |
TEST_TIME |
47 |
9845 |
TEST_TIME |
48 |
9827 |
TEST_TIME |
49 |
9755 |
TEST_TIME |
50 |
9694 |
TEST_TIME |
51 |
9640 |
TEST_TIME |
52 |
9479 |
TEST_TIME |
53 |
9659 |
TEST_TIME |
54 |
9569 |
TEST_TIME |
55 |
9685 |
TEST_TIME |
56 |
9700 |
TEST_TIME |
57 |
9657 |
TEST_TIME |
58 |
9657 |
TEST_TIME |
59 |
9776 |
TEST_TIME |
60 |
9915 |
TEST_TIME |
61 |
9958 |
TEST_TIME |
62 |
9934 |
TEST_TIME |
63 |
10013 |
TEST_TIME |
64 |
9964 |
TEST_TIME |
65 |
10025 |
TEST_TIME |
66 |
9976 |
TEST_TIME |
67 |
9868 |
TEST_TIME |
68 |
9797 |
TEST_TIME |
69 |
9856 |
TEST_TIME |
70 |
9754 |
TEST_TIME |
71 |
9788 |
TEST_TIME |
72 |
9710 |
TEST_TIME |
73 |
9735 |
TEST_TIME |
74 |
9726 |
TEST_TIME |
75 |
9618 |
TEST_TIME |
76 |
9597 |
TEST_TIME |
77 |
9594 |
TEST_TIME |
78 |
9546 |
TEST_TIME |
79 |
9565 |
TEST_TIME |
80 |
9540 |
TEST_TIME |
81 |
9594 |
TEST_TIME |
82 |
9575 |
TEST_TIME |
83 |
9628 |
TEST_TIME |
84 |
9686 |
TEST_TIME |
85 |
9716 |
TEST_TIME |
86 |
9723 |
TEST_TIME |
87 |
9726 |
TEST_TIME |
88 |
9717 |
TEST_TIME |
89 |
9695 |
TEST_TIME |
90 |
9679 |
TEST_TIME |
91 |
9602 |
TEST_TIME |
92 |
9621 |
TEST_TIME |
93 |
9569 |
TEST_TIME |
94 |
9547 |
TEST_TIME |
95 |
9482 |
TEST_TIME |
96 |
9505 |
TEST_TIME |
97 |
9486 |
TEST_TIME |
98 |
9498 |
TEST_TIME |
99 |
9538 |
TEST_TIME |
100 |
9529 |
TEST_TIME |
101 |
9488 |
TEST_TIME |
102 |
9441 |
TEST_TIME |
103 |
9524 |
TEST_TIME |
104 |
9596 |
TEST_TIME |
105 |
9613 |
TEST_TIME |
106 |
9663 |
TEST_TIME |
107 |
9656 |
TEST_TIME |
108 |
9640 |
TEST_TIME |
109 |
9718 |
TEST_TIME |
110 |
9820 |
TEST_TIME |
111 |
9736 |
TEST_TIME |
112 |
9683 |
TEST_TIME |
113 |
9652 |
TEST_TIME |
114 |
9633 |
TEST_TIME |
115 |
9588 |
TEST_TIME |
116 |
9552 |
TEST_TIME |
117 |
9546 |
TEST_TIME |
118 |
9514 |
TEST_TIME |
119 |
9458 |
TEST_TIME |
120 |
9404 |
Completed "Performance for every MINUTE". Done for 00:00:04, from 13-01-2023 01:41:01 to 13-01-2023 01:41:05.
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 |
1556640 |
1556640 |
0 |
0.00 |
0 |
22826 |
6 |
0 |
0 |
doc_list_biud |
1556639 |
1556639 |
0 |
0.00 |
0 |
53059 |
28 |
0 |
0 |
sp_add_invoice_to_stock |
5135 |
5035 |
100 |
1.94 |
31 |
184630 |
16934 |
0 |
100 |
sp_cancel_adding_invoice |
5872 |
5872 |
0 |
0.00 |
4 |
64724 |
783 |
0 |
0 |
sp_cancel_client_order |
1848 |
1848 |
0 |
0.00 |
4 |
12951 |
355 |
0 |
0 |
sp_cancel_customer_reserve |
577238 |
577238 |
0 |
0.00 |
0 |
53060 |
58 |
0 |
0 |
sp_cancel_pay_from_customer |
674 |
674 |
0 |
0.00 |
2 |
15203 |
83 |
0 |
0 |
sp_cancel_pay_to_supplier |
431 |
431 |
0 |
0.00 |
3 |
5751 |
101 |
0 |
0 |
sp_cancel_supplier_invoice |
6561 |
6555 |
6 |
0.09 |
2 |
13468 |
841 |
0 |
6 |
sp_cancel_supplier_order |
442 |
442 |
0 |
0.00 |
6 |
1254067 |
96615 |
0 |
0 |
sp_cancel_write_off |
10109 |
10109 |
0 |
0.00 |
1 |
16116 |
109 |
0 |
0 |
sp_client_order |
20989 |
20989 |
0 |
0.00 |
3 |
18934 |
351 |
0 |
0 |
sp_customer_reserve |
462208 |
462208 |
0 |
0.00 |
0 |
49046 |
169 |
0 |
0 |
sp_fill_shopping_cart |
32454 |
32454 |
0 |
0.00 |
1 |
12140 |
34 |
0 |
0 |
sp_fill_shopping_cart_clo_res |
462204 |
462204 |
0 |
0.00 |
0 |
11853 |
12 |
0 |
0 |
sp_get_clo_for_invoice |
5030 |
5030 |
0 |
0.00 |
0 |
24822 |
261 |
0 |
0 |
sp_kill_cost_storno |
17086 |
17086 |
0 |
0.00 |
0 |
7813 |
51 |
0 |
0 |
sp_kill_qstorno_ret_qs2qd |
1171582 |
1171582 |
0 |
0.00 |
0 |
53057 |
32 |
0 |
0 |
sp_kill_qty_storno |
617417 |
617417 |
0 |
0.00 |
0 |
53059 |
69 |
0 |
0 |
sp_lock_selected_doc |
21309 |
21309 |
0 |
0.00 |
0 |
8454 |
9 |
0 |
0 |
sp_make_cost_storno |
28730 |
28730 |
0 |
0.00 |
0 |
19200 |
50 |
0 |
0 |
sp_multiply_rows_for_pdistr |
28730 |
28730 |
0 |
0.00 |
0 |
21866 |
31 |
0 |
0 |
sp_multiply_rows_for_qdistr |
20989 |
20989 |
0 |
0.00 |
0 |
12963 |
153 |
0 |
0 |
sp_pay_from_customer |
7332 |
7332 |
0 |
0.00 |
4 |
21889 |
140 |
0 |
0 |
sp_pay_to_supplier |
6045 |
6045 |
0 |
0.00 |
4 |
14547 |
126 |
0 |
0 |
sp_payment_common |
13377 |
13377 |
0 |
0.00 |
1 |
10594 |
30 |
0 |
0 |
sp_qd_handle_on_cancel_clo |
1848 |
1848 |
0 |
0.00 |
0 |
12945 |
318 |
0 |
0 |
sp_qd_handle_on_invoice_upd_sts |
10902 |
10902 |
0 |
0.00 |
0 |
24256 |
328 |
0 |
0 |
sp_qd_handle_on_reserve_upd_sts |
10323 |
10323 |
0 |
0.00 |
0 |
21170 |
70 |
0 |
0 |
sp_reserve_write_off |
10323 |
10323 |
0 |
0.00 |
6 |
21242 |
198 |
0 |
0 |
sp_supplier_invoice |
5704 |
5704 |
0 |
0.00 |
6 |
95287 |
3306 |
0 |
0 |
sp_supplier_order |
5770 |
5770 |
0 |
0.00 |
5 |
36803 |
1258 |
0 |
0 |
srv_aggregate_perf_data |
95 |
95 |
0 |
0.00 |
2745 |
498829 |
25778 |
0 |
0 |
srv_fill_mon_cache_memory |
66 |
66 |
0 |
0.00 |
2002 |
123151 |
41914 |
0 |
0 |
srv_find_qd_qs_mism |
1079791 |
1079791 |
0 |
0.00 |
0 |
22824 |
5 |
0 |
0 |
srv_make_invnt_saldo |
588 |
588 |
0 |
0.00 |
22 |
148986 |
1289 |
0 |
0 |
srv_make_money_saldo |
738 |
738 |
0 |
0.00 |
1 |
825 |
27 |
0 |
0 |
srv_recalc_idx_stat |
4 |
4 |
0 |
0.00 |
154001 |
504860 |
332830 |
0 |
0 |
t$perf-abend:sp_add_invoice_to_stock |
100 |
100 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-abend:sp_cancel_supplier_invoice |
6 |
6 |
0 |
0.00 |
0 |
0 |
0 |
0 |
0 |
t$perf-norm:sp_add_invoice_to_stock |
5036 |
5036 |
0 |
0.00 |
0 |
21981 |
199 |
0 |
0 |
t$perf-norm:sp_cancel_adding_invoice |
403 |
403 |
0 |
0.00 |
0 |
7300 |
116 |
0 |
0 |
t$perf-norm:sp_cancel_client_order |
1848 |
1848 |
0 |
0.00 |
0 |
6853 |
21 |
0 |
0 |
t$perf-norm:sp_cancel_customer_reserve |
730 |
730 |
0 |
0.00 |
0 |
3204 |
16 |
0 |
0 |
t$perf-norm:sp_cancel_pay_from_customer |
674 |
674 |
0 |
0.00 |
0 |
2858 |
12 |
0 |
0 |
t$perf-norm:sp_cancel_pay_to_supplier |
431 |
431 |
0 |
0.00 |
0 |
3164 |
18 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_invoice |
425 |
425 |
0 |
0.00 |
0 |
4965 |
26 |
0 |
0 |
t$perf-norm:sp_cancel_supplier_order |
442 |
442 |
0 |
0.00 |
0 |
37458 |
1552 |
0 |
0 |
t$perf-norm:sp_cancel_write_off |
1003 |
1003 |
0 |
0.00 |
0 |
3277 |
14 |
0 |
0 |
t$perf-norm:sp_client_order |
20989 |
20989 |
0 |
0.00 |
0 |
12268 |
16 |
0 |
0 |
t$perf-norm:sp_customer_reserve |
953 |
953 |
0 |
0.00 |
0 |
5913 |
10 |
0 |
0 |
t$perf-norm:sp_pay_from_customer |
7332 |
7332 |
0 |
0.00 |
0 |
21558 |
16 |
0 |
0 |
t$perf-norm:sp_pay_to_supplier |
6045 |
6045 |
0 |
0.00 |
0 |
11897 |
16 |
0 |
0 |
t$perf-norm:sp_reserve_write_off |
10323 |
10323 |
0 |
0.00 |
0 |
7680 |
13 |
0 |
0 |
t$perf-norm:sp_supplier_invoice |
5704 |
5704 |
0 |
0.00 |
0 |
5691 |
19 |
0 |
0 |
t$perf-norm:sp_supplier_order |
5770 |
5770 |
0 |
0.00 |
0 |
12114 |
20 |
0 |
0 |
t$perf-norm:srv_aggregate_perf_data |
95 |
95 |
0 |
0.00 |
0 |
334 |
9 |
0 |
0 |
t$perf-norm:srv_fill_mon_cache_memory |
66 |
66 |
0 |
0.00 |
0 |
124 |
4 |
0 |
0 |
t$perf-norm:srv_make_invnt_saldo |
588 |
588 |
0 |
0.00 |
0 |
2468 |
24 |
0 |
0 |
t$perf-norm:srv_make_money_saldo |
738 |
738 |
0 |
0.00 |
0 |
1185 |
15 |
0 |
0 |
t$perf-norm:srv_recalc_idx_stat |
4 |
4 |
0 |
0.00 |
1 |
2 |
2 |
0 |
0 |
v_add_invoice_to_stock |
10260 |
10060 |
200 |
1.94 |
0 |
7018 |
18 |
0 |
200 |
v_all_customers |
38316 |
38316 |
0 |
0.00 |
0 |
26 |
1 |
0 |
0 |
v_all_suppliers |
31720 |
31720 |
0 |
0.00 |
0 |
28 |
1 |
0 |
0 |
v_all_wares |
41978 |
41978 |
0 |
0.00 |
0 |
26 |
1 |
0 |
0 |
v_cancel_adding_invoice |
806 |
806 |
0 |
0.00 |
0 |
1358 |
8 |
0 |
0 |
v_cancel_client_order |
3696 |
3696 |
0 |
0.00 |
0 |
5598 |
8 |
0 |
0 |
v_cancel_customer_prepayment |
1348 |
1348 |
0 |
0.00 |
0 |
963 |
5 |
0 |
0 |
v_cancel_customer_reserve |
1460 |
1460 |
0 |
0.00 |
0 |
2451 |
8 |
0 |
0 |
v_cancel_payment_to_supplier |
862 |
862 |
0 |
0.00 |
0 |
2179 |
9 |
0 |
0 |
v_cancel_supplier_invoice |
862 |
850 |
12 |
1.39 |
0 |
594 |
12 |
0 |
12 |
v_cancel_supplier_order |
884 |
884 |
0 |
0.00 |
0 |
1973 |
6 |
0 |
0 |
v_cancel_write_off |
2006 |
2006 |
0 |
0.00 |
0 |
5309 |
17 |
0 |
0 |
v_max_id_clo_ord |
5766 |
5766 |
0 |
0.00 |
0 |
632 |
1 |
0 |
0 |
v_max_id_clo_res |
953 |
953 |
0 |
0.00 |
0 |
5765 |
25 |
0 |
0 |
v_max_id_ord_sup |
5699 |
5699 |
0 |
0.00 |
0 |
4371 |
4 |
0 |
0 |
v_max_non_paid_invoice |
1650 |
1650 |
0 |
0.00 |
0 |
595 |
3 |
0 |
0 |
v_max_non_paid_realizn |
3908 |
3908 |
0 |
0.00 |
0 |
2667 |
4 |
0 |
0 |
v_min_id_clo_ord |
5766 |
5766 |
0 |
0.00 |
0 |
5841 |
8 |
0 |
0 |
v_min_id_clo_res |
953 |
953 |
0 |
0.00 |
0 |
1831 |
6 |
0 |
0 |
v_min_id_ord_sup |
5699 |
5699 |
0 |
0.00 |
0 |
4432 |
7 |
0 |
0 |
v_min_non_paid_invoice |
6045 |
6045 |
0 |
0.00 |
0 |
8231 |
22 |
0 |
0 |
v_min_non_paid_realizn |
7332 |
7332 |
0 |
0.00 |
0 |
7477 |
24 |
0 |
0 |
v_our_firm |
10510 |
10510 |
0 |
0.00 |
0 |
75 |
1 |
0 |
0 |
v_reserve_write_off |
20646 |
20646 |
0 |
0.00 |
0 |
3311 |
6 |
0 |
0 |
x_lock_depdocs_on_canc_invoice |
12002 |
12002 |
0 |
0.00 |
0 |
13136 |
112 |
0 |
0 |
x_lock_depdocs_on_canc_sup_ord |
442 |
442 |
0 |
0.00 |
0 |
30031 |
394 |
0 |
0 |
x_make_qstorno_1000_1200 |
5770 |
5770 |
0 |
0.00 |
1 |
36792 |
1183 |
0 |
0 |
x_make_qstorno_1200_2000 |
5704 |
5704 |
0 |
0.00 |
3 |
90843 |
3192 |
0 |
0 |
x_make_qstorno_2100_3300 |
462208 |
462208 |
0 |
0.00 |
0 |
39863 |
154 |
0 |
0 |
Completed "Performance in DETAILS". Done for 00:00:04, from 13-01-2023 01:41:06 to 13-01-2023 01:41:10.
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 |
23:08:36 |
3 |
8192000000 |
8797116400 |
8807743488 |
3955424 |
0.048 |
1 |
1 |
2 |
0 |
4053696 |
55488 |
42784 |
23:09:37 |
26796 |
8192000000 |
9897629504 |
10206121984 |
976454432 |
10.650 |
100 |
87 |
175 |
0 |
1005886560 |
6086752 |
23345376 |
23:11:12 |
20851 |
8192000000 |
9945225552 |
10267295744 |
1023981440 |
11.110 |
100 |
87 |
174 |
0 |
1054790976 |
8272800 |
22536736 |
23:12:37 |
10700 |
8192000000 |
9981836944 |
10314162176 |
1062752928 |
11.483 |
100 |
83 |
165 |
0 |
1092454304 |
9396688 |
20304688 |
23:13:51 |
10142 |
8192000000 |
10026045408 |
10370961408 |
1114851360 |
11.978 |
100 |
78 |
156 |
0 |
1144320032 |
11184992 |
18283680 |
23:15:04 |
5739 |
8192000000 |
10060017104 |
10415484928 |
1150153856 |
12.311 |
100 |
75 |
150 |
0 |
1180022672 |
12575840 |
17292976 |
23:16:12 |
5275 |
8192000000 |
10108219536 |
10474639360 |
1199897568 |
12.775 |
100 |
75 |
148 |
0 |
1228184112 |
11427904 |
16858640 |
23:17:19 |
1711 |
8192000000 |
10146598576 |
10517250048 |
1237201904 |
13.120 |
100 |
84 |
167 |
0 |
1270266560 |
14124880 |
18939776 |
23:18:22 |
2415 |
8192000000 |
10180728912 |
10553303040 |
1261305088 |
13.342 |
100 |
89 |
175 |
2 |
1294782336 |
14490432 |
18986816 |
23:19:26 |
1420 |
8192000000 |
10205751360 |
10589675520 |
1292063040 |
13.623 |
100 |
92 |
182 |
1 |
1325650672 |
12262896 |
21324736 |
23:20:29 |
42307 |
8192000000 |
10179595072 |
10594000896 |
1301714192 |
13.711 |
100 |
31 |
63 |
0 |
1315196928 |
6652000 |
6830736 |
23:22:15 |
11970 |
8192000000 |
10201206976 |
10613407744 |
1312816736 |
13.812 |
100 |
21 |
42 |
1 |
1323653184 |
6356512 |
4479936 |
23:23:27 |
7522 |
8192000000 |
10205353968 |
10621177856 |
1318606080 |
13.864 |
100 |
17 |
34 |
0 |
1328725104 |
6524096 |
3594928 |
23:24:35 |
14680 |
8192000000 |
10213678096 |
10630901760 |
1327450432 |
13.944 |
100 |
29 |
57 |
0 |
1339308288 |
5349792 |
6508064 |
23:25:51 |
27366 |
8192000000 |
10237237440 |
10645172224 |
1329676384 |
13.964 |
100 |
49 |
98 |
2 |
1346844528 |
5312768 |
11855376 |
23:27:19 |
8411 |
8192000000 |
10221218448 |
10643673088 |
1331998144 |
13.985 |
100 |
23 |
44 |
0 |
1346670480 |
10027056 |
4645280 |
23:28:27 |
6207 |
8192000000 |
10223124336 |
10641485824 |
1330102768 |
13.968 |
100 |
30 |
58 |
1 |
1343013120 |
6470512 |
6439840 |
23:29:37 |
58819 |
8192000000 |
10169608192 |
10564890624 |
1232694000 |
13.079 |
95 |
44 |
84 |
0 |
1248234016 |
5200480 |
10339536 |
23:31:37 |
3243 |
8192000000 |
10139599440 |
10544451584 |
1253294496 |
13.268 |
99 |
20 |
37 |
2 |
1263237712 |
5862624 |
4080592 |
23:32:41 |
6801 |
8192000000 |
10140456944 |
10542112768 |
1239566912 |
13.142 |
99 |
22 |
44 |
0 |
1250284192 |
5996912 |
4720368 |
23:33:49 |
10981 |
8192000000 |
10158581184 |
10564157440 |
1266472864 |
13.389 |
100 |
19 |
38 |
0 |
1276178704 |
5069792 |
4636048 |
23:35:03 |
29182 |
8192000000 |
10167132832 |
10574249984 |
1275823776 |
13.475 |
100 |
21 |
42 |
0 |
1286111648 |
5740656 |
4547216 |
23:36:32 |
6590 |
8192000000 |
10178159904 |
10587299840 |
1286697360 |
13.574 |
100 |
16 |
32 |
0 |
1295278272 |
5117552 |
3463360 |
23:37:42 |
12593 |
8192000000 |
10181664736 |
10595246080 |
1293247520 |
13.634 |
100 |
14 |
28 |
0 |
1302024048 |
5435104 |
3341424 |
23:39:06 |
8353 |
8192000000 |
10227541248 |
10632609792 |
1322045984 |
13.895 |
100 |
43 |
85 |
1 |
1337700432 |
6248592 |
9405856 |
23:40:19 |
76312 |
8192000000 |
10238915776 |
10659667968 |
1339019008 |
14.049 |
100 |
44 |
89 |
0 |
1360032704 |
10515456 |
10498240 |
23:42:57 |
15191 |
8192000000 |
10260970480 |
10683039744 |
1354106272 |
14.184 |
100 |
34 |
68 |
0 |
1377145008 |
14839200 |
8199536 |
23:44:22 |
12184 |
8192000000 |
10278929584 |
10699321344 |
1366382416 |
14.295 |
100 |
48 |
93 |
1 |
1393887280 |
16598624 |
10906240 |
23:45:39 |
7919 |
8192000000 |
10287061216 |
10706825216 |
1372385312 |
14.348 |
100 |
60 |
118 |
1 |
1406944144 |
20740928 |
13817904 |
23:46:52 |
4206 |
8192000000 |
10286082928 |
10707992576 |
1370648608 |
14.333 |
100 |
53 |
103 |
0 |
1403011936 |
19452784 |
12910544 |
23:48:03 |
5018 |
8192000000 |
10318831344 |
10736340992 |
1386128480 |
14.471 |
100 |
57 |
110 |
0 |
1428042400 |
29150000 |
12763920 |
23:49:11 |
4253 |
8192000000 |
10322917680 |
10743685120 |
1381186256 |
14.427 |
99 |
47 |
94 |
0 |
1428318672 |
34907024 |
12225392 |
23:50:20 |
8296 |
8192000000 |
10321244272 |
10736025600 |
1373030848 |
14.354 |
99 |
55 |
108 |
0 |
1425951360 |
39921360 |
12999152 |
23:51:38 |
2357 |
8192000000 |
10339900240 |
10759000064 |
1395647440 |
14.556 |
100 |
68 |
131 |
3 |
1456806896 |
46078368 |
15081088 |
23:52:45 |
3665 |
8192000000 |
10343975808 |
10760671232 |
1368426064 |
14.313 |
98 |
62 |
124 |
0 |
1426074864 |
42499136 |
15149664 |
23:53:58 |
18056 |
8192000000 |
10320983824 |
10734809088 |
1351899888 |
14.165 |
98 |
47 |
93 |
0 |
1405970464 |
42313552 |
11757024 |
23:55:25 |
2000 |
8192000000 |
10342354544 |
10750468096 |
1378213952 |
14.401 |
100 |
71 |
139 |
2 |
1444527440 |
48947008 |
17366480 |
23:56:31 |
2014 |
8192000000 |
10359092384 |
10765185024 |
1384473152 |
14.457 |
100 |
75 |
150 |
0 |
1457347456 |
54173008 |
18701296 |
23:57:53 |
2811 |
8192000000 |
10358302048 |
10763440128 |
1381694864 |
14.432 |
100 |
76 |
152 |
2 |
1459949616 |
58599968 |
19654784 |
23:58:59 |
12579 |
8192000000 |
10364205328 |
10780856320 |
1394957360 |
14.550 |
100 |
45 |
89 |
1 |
1465778656 |
58425792 |
12395504 |
00:00:18 |
5675 |
8192000000 |
10378858112 |
10793680896 |
1396452512 |
14.563 |
100 |
71 |
142 |
0 |
1484817520 |
69763776 |
18601232 |
00:01:28 |
17379 |
8192000000 |
10358851824 |
10786398208 |
1384386032 |
14.456 |
99 |
38 |
76 |
0 |
1464212512 |
68960224 |
10866256 |
00:02:50 |
14143 |
8192000000 |
10359188928 |
10785693696 |
1387272720 |
14.482 |
100 |
36 |
72 |
0 |
1465427808 |
67093760 |
11061328 |
00:04:17 |
19186 |
8192000000 |
10338114752 |
10773622784 |
1372565568 |
14.350 |
100 |
40 |
78 |
0 |
1446568160 |
62335600 |
11666992 |
00:05:42 |
22577 |
8192000000 |
10317394992 |
10761928704 |
1354717552 |
14.190 |
99 |
26 |
52 |
0 |
1411000592 |
48940736 |
7342304 |
00:07:12 |
44697 |
8192000000 |
10280965456 |
10729975808 |
1356425808 |
14.205 |
99 |
10 |
18 |
0 |
1369078944 |
10426928 |
2226208 |
00:08:57 |
71997 |
8192000000 |
10291555056 |
10728816640 |
1337676080 |
14.036 |
97 |
19 |
36 |
0 |
1354699952 |
13176576 |
3847296 |
00:11:10 |
77173 |
8192000000 |
10275351424 |
10719158272 |
1341337168 |
14.069 |
97 |
29 |
58 |
0 |
1359566672 |
11305072 |
6924432 |
00:13:28 |
57171 |
8192000000 |
10291965216 |
10738692096 |
1376729152 |
14.387 |
100 |
39 |
78 |
0 |
1392781200 |
7521712 |
8530336 |
00:15:28 |
24305 |
8192000000 |
10289844464 |
10742173696 |
1386277376 |
14.473 |
100 |
10 |
20 |
0 |
1395443376 |
6887744 |
2278256 |
00:16:53 |
30323 |
8192000000 |
10298608576 |
10756734976 |
1392437104 |
14.528 |
100 |
16 |
32 |
1 |
1411096032 |
14539952 |
4118976 |
00:18:25 |
19118 |
8192000000 |
10297489808 |
10731270144 |
1356793120 |
14.209 |
98 |
54 |
102 |
1 |
1380323824 |
10276224 |
13254480 |
00:20:00 |
31333 |
8192000000 |
10298929088 |
10750083072 |
1386280128 |
14.473 |
100 |
18 |
36 |
0 |
1400611424 |
10030496 |
4300800 |
00:21:36 |
41386 |
8192000000 |
10287219920 |
10749194240 |
1388958000 |
14.497 |
100 |
10 |
20 |
0 |
1400818448 |
9814560 |
2045888 |
00:23:18 |
38899 |
8192000000 |
10293259056 |
10747793408 |
1384088320 |
14.453 |
99 |
16 |
31 |
0 |
1397796432 |
10180128 |
3527984 |
00:25:31 |
70552 |
8192000000 |
10281834656 |
10740420608 |
1371751536 |
14.343 |
99 |
12 |
25 |
0 |
1381522128 |
6936880 |
2833712 |
00:27:51 |
37334 |
8192000000 |
10273714192 |
10727284736 |
1359822352 |
14.236 |
98 |
18 |
36 |
0 |
1376676288 |
12719792 |
4134144 |
00:29:41 |
57077 |
8192000000 |
10281662192 |
10749317120 |
1382279728 |
14.437 |
100 |
8 |
16 |
0 |
1401227536 |
17074832 |
1872976 |
00:32:02 |
48021 |
8192000000 |
10293286192 |
10739101696 |
1343150608 |
14.086 |
97 |
9 |
17 |
0 |
1358474224 |
13471008 |
1852608 |
00:33:51 |
59378 |
8192000000 |
10285207360 |
10751471616 |
1385845280 |
14.469 |
100 |
14 |
28 |
0 |
1397358592 |
8603504 |
2909808 |
00:35:51 |
54999 |
8192000000 |
10323473792 |
10767806464 |
1380748096 |
14.423 |
99 |
30 |
60 |
0 |
1402094336 |
14549504 |
6796736 |
00:37:48 |
60744 |
8192000000 |
10289776448 |
10749595648 |
1353540864 |
14.179 |
97 |
7 |
14 |
0 |
1378087568 |
23071328 |
1475376 |
00:39:50 |
55999 |
8192000000 |
10264658976 |
10712748032 |
1281864832 |
13.530 |
93 |
14 |
28 |
0 |
1297734304 |
13102464 |
2767008 |
00:41:54 |
78564 |
8192000000 |
10270230960 |
10706579456 |
1260952240 |
13.339 |
92 |
19 |
38 |
0 |
1275233856 |
10391312 |
3890304 |
00:44:17 |
57744 |
8192000000 |
10254959376 |
10701942784 |
1352322384 |
14.168 |
100 |
19 |
38 |
0 |
1363061440 |
6394448 |
4344608 |
00:46:45 |
84199 |
8192000000 |
10249387200 |
10712186880 |
1331595136 |
13.982 |
98 |
31 |
61 |
0 |
1351481504 |
12958736 |
6927632 |
00:49:35 |
65005 |
8192000000 |
10238367280 |
10687332352 |
1298785408 |
13.684 |
96 |
15 |
30 |
0 |
1311721360 |
9545648 |
3390304 |
00:51:40 |
32515 |
8192000000 |
10252979408 |
10717745152 |
1356307232 |
14.204 |
100 |
8 |
16 |
0 |
1371217776 |
12941120 |
1969424 |
00:53:18 |
50078 |
8192000000 |
10256257376 |
10715971584 |
1362602224 |
14.261 |
100 |
7 |
14 |
0 |
1372270832 |
8203712 |
1464896 |
00:55:16 |
58760 |
8192000000 |
10247413360 |
10715779072 |
1330382112 |
13.971 |
98 |
7 |
14 |
0 |
1342431664 |
10844416 |
1205136 |
00:57:15 |
59375 |
8192000000 |
10268224416 |
10728534016 |
1345050704 |
14.103 |
98 |
26 |
52 |
0 |
1360744688 |
10438592 |
5255392 |
00:59:14 |
66465 |
8192000000 |
10270478624 |
10717917184 |
1335240656 |
14.014 |
97 |
20 |
38 |
0 |
1349294880 |
9741568 |
4312656 |
01:01:21 |
67289 |
8192000000 |
10285229232 |
10752729088 |
1357533760 |
14.215 |
98 |
10 |
20 |
1 |
1387051744 |
27423760 |
2094224 |
01:03:35 |
45036 |
8192000000 |
10273593072 |
10725900288 |
1337848128 |
14.038 |
97 |
10 |
18 |
0 |
1363070944 |
23199152 |
2023664 |
01:05:33 |
56944 |
8192000000 |
10272238576 |
10723676160 |
1347248960 |
14.123 |
98 |
14 |
29 |
0 |
1363407376 |
13322976 |
2835440 |
01:07:33 |
16109 |
8192000000 |
10280307280 |
10722127872 |
1365916960 |
14.290 |
100 |
56 |
110 |
1 |
1388232784 |
8804304 |
13511520 |
01:08:54 |
123151 |
8192000000 |
10268138800 |
10727972864 |
1346034528 |
14.112 |
98 |
28 |
56 |
0 |
1364113344 |
11595184 |
6483632 |
01:12:01 |
64176 |
8192000000 |
10288392464 |
10754494464 |
1390244480 |
14.508 |
100 |
24 |
48 |
0 |
1410587712 |
15385312 |
4957920 |
01:14:11 |
51401 |
8192000000 |
10284472688 |
10746085376 |
1378397280 |
14.402 |
99 |
14 |
28 |
0 |
1397278176 |
15339280 |
3541616 |
01:16:07 |
29454 |
8192000000 |
10289701552 |
10750664704 |
1371330224 |
14.339 |
99 |
11 |
22 |
0 |
1382011568 |
8671024 |
2010320 |
01:17:40 |
97343 |
8192000000 |
10283108224 |
10737008640 |
1322100800 |
13.896 |
95 |
11 |
22 |
0 |
1334885968 |
10399600 |
2385568 |
01:20:29 |
28836 |
8192000000 |
10303106816 |
10745159680 |
1360962368 |
14.246 |
98 |
36 |
72 |
0 |
1385729856 |
15532448 |
9235040 |
01:22:09 |
85597 |
8192000000 |
10265757344 |
10723577856 |
1295779920 |
13.657 |
94 |
8 |
16 |
0 |
1317050816 |
19681520 |
1589376 |
01:24:36 |
65097 |
8192000000 |
10271500320 |
10721124352 |
1290138768 |
13.605 |
94 |
24 |
48 |
0 |
1308329536 |
12417904 |
5772864 |
01:26:42 |
26226 |
8192000000 |
10273737152 |
10712580096 |
1331629296 |
13.982 |
98 |
32 |
64 |
1 |
1353697392 |
14200672 |
7867424 |
01:28:24 |
74648 |
8192000000 |
10267158336 |
10754310144 |
1353679296 |
14.181 |
100 |
7 |
14 |
0 |
1386788256 |
31293040 |
1815920 |
01:30:46 |
48374 |
8192000000 |
10265929408 |
10718568448 |
1341435152 |
14.070 |
98 |
18 |
35 |
0 |
1354301600 |
9125824 |
3740624 |
01:32:34 |
85844 |
8192000000 |
10258530272 |
10719784960 |
1337718496 |
14.037 |
98 |
6 |
12 |
0 |
1345299200 |
6367648 |
1213056 |
01:35:00 |
49350 |
8192000000 |
10256404400 |
10720391168 |
1342731456 |
14.082 |
98 |
7 |
14 |
0 |
1351070832 |
6885584 |
1453792 |
01:37:28 |
53910 |
8192000000 |
10285392080 |
10746175488 |
1366134752 |
14.292 |
99 |
24 |
48 |
0 |
1384368400 |
12441872 |
5791776 |
Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:15, from 13-01-2023 01:41:12 to 13-01-2023 01:41:27.
FB_MNEMONA |
CNT |
UNIT |
FB_GDSCODE |
except |
100 |
v_add_invoice_to_stock |
335544517 |
except |
6 |
v_cancel_supplier_invoice |
335544517 |
Completed "Exceptions occured during test was in run". Done for 00:00:02, from 13-01-2023 01:41:28 to 13-01-2023 01:41:30.
MON$DATABASE_NAME /home/bases/oltp30-etalone.fdb
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 12
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 241290
MON$OLDEST_ACTIVE 243819
MON$OLDEST_SNAPSHOT 243819
MON$NEXT_TRANSACTION 243819
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 2046752
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.33653 Firebird 3.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V3.0.11.33653 Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V3.0.11.33653 Firebird 3.0/tcp (mscs-test-161.budzdorov.ru)/P15:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V3.0.11.33653 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 ---
:121:
:122: mscs-test-161.budzdorov.ru Fri Jan 13 01:38:48 2023
:123: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:124:
:125:
:126: mscs-test-161.budzdorov.ru Fri Jan 13 01:38:55 2023
:127: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:128:
:129:
:130: mscs-test-161.budzdorov.ru Fri Jan 13 01:38:56 2023
:131: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:132:
:133:
:134: mscs-test-161.budzdorov.ru Fri Jan 13 01:38:57 2023
:135: INET/inet_error: send errno = 32, server host = localhost, address = ::1/3333
:136:
--- end of diff output ---
13.01.23 01:41:31. 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 |
2023-01-13 01:41:34 |
No severe PSQL-related problems occured |
13.01.23 01:41:35. End of report.