[Info-ingres] Vector giving me the shits

[Martin Bowes]

> The libMapRClient.so message is harmless / normal.
That's comforting.

> The query memory and bufferpool limits are pretty big.  :-)  Was it working with those limits before?
Yes.

> I don't really see anything in the vectorwise.log that indicates an error.  How about the DBMS log?
DBMS log simply holds the E_VW1036 message...
VW2_NDPH_OX_AC_UK ::[37433             , 72209     ,  00007fea5c904540, vwerror.c:838         ]: Mon Jul 24 12:45:40 2017 E_VW1036_NETWORK  Vector database is temporarily unavailable.
   Please check Vector logs (such as vectorwise.log) for more information.

FYI. The query is a large table pivot involving 40 columns, so there is a hideous where clause anda grouping. Over the years the number of columns involved has dropped from 99. I now seem to be having success (process still running) having reduced it further to 30 columns.

DECLARE GLOBAL TEMPORARY TABLE session.gtt_a_val_real_p35 as SELECT pid,
    max(case when v.field_id = 20011 and v.arr_index = 25 and v.ins_index = 1 then v.value else cast(null as float4) end) as field20011_ii1_ai25,
    max(case when v.field_id = 20011 and v.arr_index = 26 and v.ins_index = 1 then v.value else cast(null as float4) end) as field20011_ii1_ai26,
    max(case when v.field_id = 20011 and v.arr_index = 27 and v.ins_index = 1 th
...
FROM val_real v
WHERE v.status = 0
  AND (
       (v.field_id = 20011 and v.arr_index = 25 and v.ins_index = 1)
       OR (v.field_id = 20011 and v.arr_index = 26 and v.ins_index = 1)
       OR (v.field_id = 20011 and v.arr_index = 27 and v.ins_index = 1)
...
GROUP BY v.pid
ON COMMIT PRESERVE ROWS WITH NORECOVERY, STRUCTURE = VECTORWISE;