|
1
|
-[ RECORD 1 ]----+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
|
2
|
datid | 375640
|
|
3
|
datname | euro_test
|
|
4
|
pid | 14074
|
|
5
|
usesysid | 16393
|
|
6
|
usename | adempiere
|
|
7
|
application_name | PostgreSQL JDBC Driver
|
|
8
|
client_addr | 127.0.0.1
|
|
9
|
client_hostname |
|
|
10
|
client_port | 43718
|
|
11
|
backend_start | 2023-01-26 19:14:45.997147+04
|
|
12
|
xact_start |
|
|
13
|
query_start | 2023-01-27 10:54:51.429579+04
|
|
14
|
state_change | 2023-01-27 10:54:51.4373+04
|
|
15
|
waiting | f
|
|
16
|
state | idle
|
|
17
|
backend_xid |
|
|
18
|
backend_xmin |
|
|
19
|
query | COMMIT
|
|
20
|
-[ RECORD 2 ]----+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
|
21
|
datid | 375640
|
|
22
|
datname | euro_test
|
|
23
|
pid | 12918
|
|
24
|
usesysid | 16393
|
|
25
|
usename | adempiere
|
|
26
|
application_name | PostgreSQL JDBC Driver
|
|
27
|
client_addr | 127.0.0.1
|
|
28
|
client_hostname |
|
|
29
|
client_port | 43218
|
|
30
|
backend_start | 2023-01-26 18:33:46.730206+04
|
|
31
|
xact_start |
|
|
32
|
query_start | 2023-01-26 18:34:59.719732+04
|
|
33
|
state_change | 2023-01-26 18:34:59.725462+04
|
|
34
|
waiting | f
|
|
35
|
state | idle
|
|
36
|
backend_xid |
|
|
37
|
backend_xmin |
|
|
38
|
query | select ppo.m_product_id,ppo.c_bpartner_id,iscurrentvendor,royaltyamt,royaltypercentage,bp.name,m_product_po_id,validfrom, ppo.order_min,ppo.reorderpoint,ppo.manufacturer,ppo.description,ppo.upc, mfr.c_bpartner_id as mfrid from m_product_po ppo join m_product pro on ppo.m_product_id = pro.m_product_id join c_bpartner bp on ppo.c_bpartner_id = bp.c_bpartner_id left join c_bpartner mfr on (mfr.name = ppo.manufacturer and mfr.isVendor = 'Y') where ppo.m_product_id =780000869 and ppo.ad_client_id =1000000 and ppo.ad_org_id in (0,1000000)order by validfrom desc,ppo.created desc
|
|
39
|
-[ RECORD 3 ]----+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
|
40
|
datid | 375640
|
|
41
|
datname | euro_test
|
|
42
|
pid | 12640
|
|
43
|
usesysid | 16393
|
|
44
|
usename | adempiere
|
|
45
|
application_name | PostgreSQL JDBC Driver
|
|
46
|
client_addr | 127.0.0.1
|
|
47
|
client_hostname |
|
|
48
|
client_port | 43036
|
|
49
|
backend_start | 2023-01-26 18:25:20.76352+04
|
|
50
|
xact_start |
|
|
51
|
query_start | 2023-01-26 18:35:02.787621+04
|
|
52
|
state_change | 2023-01-26 18:35:02.787652+04
|
|
53
|
waiting | f
|
|
54
|
state | idle
|
|
55
|
backend_xid |
|
|
56
|
backend_xmin |
|
|
57
|
query | select value from m_locator where m_locator_id = (select m_locator_id from m_warehouse_product_po where m_product_id = $1 and isactive = 'Y' and m_warehouse_id = $2 and ad_client_id = $3 )
|
|
58
|
-[ RECORD 4 ]----+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
|
59
|
datid | 77307
|
|
60
|
datname | euro
|
|
61
|
pid | 17459
|
|
62
|
usesysid | 16393
|
|
63
|
usename | adempiere
|
|
64
|
application_name | PostgreSQL JDBC Driver
|
|
65
|
client_addr | 127.0.0.1
|
|
66
|
client_hostname |
|
|
67
|
client_port | 47158
|
|
68
|
backend_start | 2023-01-27 10:51:13.469683+04
|
|
69
|
xact_start |
|
|
70
|
query_start | 2023-01-27 10:54:16.731884+04
|
|
71
|
state_change | 2023-01-27 10:54:16.731917+04
|
|
72
|
waiting | f
|
|
73
|
state | idle
|
|
74
|
backend_xid |
|
|
75
|
backend_xmin |
|
|
76
|
query | select coalesce(aa.isserno , 'N') hasserialno, coalesce(aa.islot, 'N') haslot, coalesce(aa.isguaranteedate, 'N') hasguarantee from m_product p left join m_attributeset aa ON (p.m_attributeset_id = aa.m_attributeset_id) where p.m_product_id = $1
|
|
77
|
-[ RECORD 5 ]----+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
|
78
|
datid | 77307
|
|
79
|
datname | euro
|
|
80
|
pid | 17338
|
|
81
|
usesysid | 16393
|
|
82
|
usename | adempiere
|
|
83
|
application_name | PostgreSQL JDBC Driver
|
|
84
|
client_addr | 127.0.0.1
|
|
85
|
client_hostname |
|
|
86
|
client_port | 47124
|
|
87
|
backend_start | 2023-01-27 10:49:13.791834+04
|
|
88
|
xact_start |
|
|
89
|
query_start | 2023-01-27 10:54:07.907674+04
|
|
90
|
state_change | 2023-01-27 10:54:07.911439+04
|
|
91
|
waiting | f
|
|
92
|
state | idle
|
|
93
|
backend_xid |
|
|
94
|
backend_xmin |
|
|
95
|
query | SELECT COALESCE(SUM(s.qtyonhand),0) - COALESCE((SELECT SUM(movementqty) AS qty_intransit FROM m_movementline mml JOIN m_movement mm ON (mm.m_movement_id = mml.m_movement_id) WHERE docstatus = 'IP' AND mml.m_locator_id IN (SELECT m_locator_id FROM m_locator WHERE m_warehouse_id = 1010036) AND m_product_id = s.m_product_id), 0) - COALESCE(SUM(s.qtyReserved),0) AS qty_available, ( COALESCE(SUM(s.qtyonhand),0) - COALESCE((SELECT SUM(movementqty) AS qty_intransit FROM m_movementline mml JOIN m_movement mm ON (mm.m_movement_id = mml.m_movement_id) WHERE docstatus = 'IP' AND mml.m_locator_id IN (SELECT m_locator_id FROM m_locator WHERE m_warehouse_id = 1010036) AND m_product_id = s.m_product_id), 0) - COALESCE(SUM(s.qtyReserved),0))/dividerate AS uom_qty_available, u.uomsymbol from M_Storage s join m_locator l on s.m_locator_id = l.m_locator_id inner join M_AttributeSetInstance i on s.M_AttributeSetInstance_id = i.M_AttributeSetInstance_id LEFT JOIN LATERAL (SELECT DISTINCT ON (dividerate) dividerate, c_uom_to_i
|
|
96
|
-[ RECORD 6 ]----+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
|
97
|
datid | 77307
|
|
98
|
datname | euro
|
|
99
|
pid | 17374
|
|
100
|
usesysid | 16393
|
|
101
|
usename | adempiere
|
|
102
|
application_name | PostgreSQL JDBC Driver
|
|
103
|
client_addr | 127.0.0.1
|
|
104
|
client_hostname |
|
|
105
|
client_port | 47144
|
|
106
|
backend_start | 2023-01-27 10:50:06.853178+04
|
|
107
|
xact_start |
|
|
108
|
query_start | 2023-01-27 10:54:51.263275+04
|
|
109
|
state_change | 2023-01-27 10:54:51.270618+04
|
|
110
|
waiting | f
|
|
111
|
state | idle
|
|
112
|
backend_xid |
|
|
113
|
backend_xmin |
|
|
114
|
query | COMMIT
|
|
115
|
-[ RECORD 7 ]----+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
|
116
|
datid | 77307
|
|
117
|
datname | euro
|
|
118
|
pid | 17132
|
|
119
|
usesysid | 16393
|
|
120
|
usename | adempiere
|
|
121
|
application_name | PostgreSQL JDBC Driver
|
|
122
|
client_addr | 127.0.0.1
|
|
123
|
client_hostname |
|
|
124
|
client_port | 47078
|
|
125
|
backend_start | 2023-01-27 10:43:27.651672+04
|
|
126
|
xact_start |
|
|
127
|
query_start | 2023-01-27 10:54:51.254763+04
|
|
128
|
state_change | 2023-01-27 10:54:51.26229+04
|
|
129
|
waiting | f
|
|
130
|
state | idle
|
|
131
|
backend_xid |
|
|
132
|
backend_xmin |
|
|
133
|
query | COMMIT
|
|
134
|
-[ RECORD 8 ]----+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
|
135
|
datid | 77307
|
|
136
|
datname | euro
|
|
137
|
pid | 17596
|
|
138
|
usesysid | 16393
|
|
139
|
usename | adempiere
|
|
140
|
application_name | psql.bin
|
|
141
|
client_addr |
|
|
142
|
client_hostname |
|
|
143
|
client_port | -1
|
|
144
|
backend_start | 2023-01-27 10:54:13.816506+04
|
|
145
|
xact_start | 2023-01-27 10:54:51.632029+04
|
|
146
|
query_start | 2023-01-27 10:54:51.632029+04
|
|
147
|
state_change | 2023-01-27 10:54:51.632031+04
|
|
148
|
waiting | f
|
|
149
|
state | active
|
|
150
|
backend_xid |
|
|
151
|
backend_xmin | 44234329
|
|
152
|
query | select * from pg_stat_activity;
|
|
153
|
-[ RECORD 9 ]----+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|
|
154
|
datid | 375640
|
|
155
|
datname | euro_test
|
|
156
|
pid | 16246
|
|
157
|
usesysid | 16393
|
|
158
|
usename | adempiere
|
|
159
|
application_name | PostgreSQL JDBC Driver
|
|
160
|
client_addr | 127.0.0.1
|
|
161
|
client_hostname |
|
|
162
|
client_port | 46774
|
|
163
|
backend_start | 2023-01-27 10:16:51.050285+04
|
|
164
|
xact_start |
|
|
165
|
query_start | 2023-01-27 10:54:10.270274+04
|
|
166
|
state_change | 2023-01-27 10:54:10.2818+04
|
|
167
|
waiting | f
|
|
168
|
state | idle
|
|
169
|
backend_xid |
|
|
170
|
backend_xmin |
|
|
171
|
query | INSERT INTO TrxReplicationStatus (trxname,producedby,failedin,reason,issent,isself,iscorrected,AD_Client_ID) values ('POSIBOLT1379_1674802445702','EuroCentral_euro','Eurotest_euro_test','ERROR: insert or update on table "c_orderline" violates foreign key constraint "mwarehouse_corderline" +
|
|
172
|
| Detail: Key (m_warehouse_id)=(1010036) is not present in table "m_warehouse".','N','N','N',1000000)
|
|
173
|
|
