|
0
Undefined
19.11.15
✎
16:12
|
Периодически отваливается процесс постгри.
В логах всегда нахожу вот это
2015-11-19 16:27:39 MSK DETAIL: Failed process was running: INSERT INTO tt32 (_Fld9479RRef) SELECT
T1.Fld9375RRef
FROM (SELECT
T2._Period AS Period_,
T2._RecorderTRef AS RecorderTRef,
T2._RecorderRRef AS RecorderRRef,
T2._Fld9375RRef AS Fld9375RRef,
SUM(CASE WHEN T2._RecordKind = 0 THEN T2._Fld9380 ELSE 0 END) AS Fld9380Receipt_
FROM _AccumRg9374 T2
WHERE T2._Active = TRUE AND ((CASE WHEN (NOT ((T2._Fld9375RRef IN
(SELECT
T3._Q_001_F_000RRef AS Q_001_F_000RRef
FROM tt11 T3)))) THEN TRUE ELSE FALSE END = TRUE AND (T2._Fld9375RRef IN
(SELECT
T4._REFFIELDRRef AS REFFIELDRRef
FROM tt46 T4)))) AND T2._RecordKind = 0
GROUP BY T2._Period,
T2._RecorderTRef,
T2._RecorderRRef,
T2._Fld9375RRef
HAVING (SUM(CASE WHEN T2._RecordKind = 0 THEN T2._Fld9380 ELSE 0 END)) <> 0) T1
WHERE (T1.Fld9380Receipt_ > 0) AND (T1.RecorderTRef = '\\000\\000\\000\\356'::bytea)
На сервере крутится несколько баз.
Как узнать, какая это база?
|
|