[Info-ingres] Vector giving me the shits

[Martin Bowes]

What's the relationship between vwlog.conf and vwlog.conf_TMPL?

Marty

From: Dean Vernon [mailto:Dean.Vernon at actian.com]
Sent: 24 July 2017 14:04
To: Martin Bowes
Subject: RE: [Info-ingres] Vector giving me the shits

Default=warn is the usual setting , I always have set to info.

Dean Vernon
Principal Support Engineer
Actian | Support
M +34 678 564 097
O +44 (0)1753 559552
actian.com


From: Martin Bowes [mailto:martin.bowes at ndph.ox.ac.uk]
Sent: 24 July 2017 14:45
To: Dean Vernon <Dean.Vernon at actian.com<mailto:Dean.Vernon at actian.com>>
Subject: RE: [Info-ingres] Vector giving me the shits

I did not know that. That may be very useful.

Thanks Dean.

Marty

From: Dean Vernon [mailto:Dean.Vernon at actian.com]
Sent: 24 July 2017 13:24
To: Martin Bowes
Subject: RE: [Info-ingres] Vector giving me the shits

Sure you know but ...

In vwlog.conf

default = info:file

Call vectorwise (vwlog_reload) \g


Dean Vernon
Principal Support Engineer
Actian | Support
M +34 678 564 097
O +44 (0)1753 559552
actian.com


From: info-ingres-bounces at lists.planetingres.org<mailto:info-ingres-bounces at lists.planetingres.org> [mailto:info-ingres-bounces at lists.planetingres.org] On Behalf Of Martin Bowes
Sent: 24 July 2017 13:50
To: info-ingres at lists.planetingres.org<mailto:info-ingres at lists.planetingres.org>
Subject: [Info-ingres] Vector giving me the shits

Hi All,

VW 5.0.0 (a64.lnx/402) + p40205

Having massive problems with Vector giving up with error:
E_VW1036 Vector database is temporarily unavailable.
    Please check Vector logs (such as vectorwise.log) for more information.

The vectorwise.log shows:
2017-07-24 12:45:40 PID 73520:TID 140427600516992: INFO:SYSTEM:X100 Server version x100-gcc-OPTXPROF-64-r12350 (branches/vw5.0) built on Sep 16 2016 15:27:40 with GCC 4.9.1
2017-07-24 12:45:40 PID 73520:TID 140427600516992: INFO:SYSTEM:Loaded 'libhugetlbfs.so'.
2017-07-24 12:45:40 PID 73520:TID 140427600516992: INFO:SYSTEM:Loaded 'libnuma.so.1'.
2017-07-24 12:45:40 PID 73520:TID 140427600516992: INFO:SYSTEM:Not loaded 'libMapRClient.so': libMapRClient.so: cannot open shared object file: No such file or directory
2017-07-24 12:45:40 PID 73520:TID 140427600516992: INFO:SYSTEM:Started for database 'ace_report_live' in '/dbdata1/II/ingres/data/vectorwise' with vectorsize = 1024
2017-07-24 12:45:40 PID 73520:TID 140427600516992: INFO:SYSTEM:Setting the query memory limit to 734003200000 bytes
2017-07-24 12:45:40 PID 73520:TID 140427600516992: INFO:SYSTEM:rank = 0, num_nodes = 1
2017-07-24 12:45:40 PID 73520:TID 140427600516992: INFO:SYSTEM:Vector nodes: (0, vw2.ndph.ox.ac.uk)
2017-07-24 12:45:47 PID 73520:TID 140427600516992: INFO:CBM:columnspace_create: nrblks 128
2017-07-24 12:45:47 PID 73520:TID 140427600516992: INFO:CBM:columnspace_create: nrblks 128
2017-07-24 12:45:47 PID 73520:TID 140427600516992: INFO:CBM:columnspace_create: nrblks 128
2017-07-24 12:45:55 PID 73520:TID 140427600516992: INFO:CBM:Setting the bufferpool limit to 202831298560 bytes
2017-07-24 12:45:55 PID 73520:TID 140427600516992: INFO:CBM:iobp_create: blksz=524288 nrblks=386870
2017-07-24 12:45:55 PID 73520:TID 140427600516992: INFO:CBM:NUMA interleave bufferpool memory.
2017-07-24 12:45:55 PID 73520:TID 140427600516992: INFO:X100SERVER:Log levels: default=warn,SYSTEM=info,SYSCALL=info,CBM=info,QUERYERROR=warn.

I've removed the parallel sorting.

I've ensure stacksize is at 8M.

Anyone got any other ideas?

Martin Bowes
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20170724/9dfc54f2/attachment.html>