[Info-ingres] Vector giving me the shits

[Paul White]

Hey Marty

 

Is this normal?

Not loaded 'libMapRClient.so': libMapRClient.so: cannot open shared object
file: No such file or directory

 

Paul

 

From: info-ingres-bounces at lists.planetingres.org
[mailto:info-ingres-bounces at lists.planetingres.org] On Behalf Of Martin
Bowes
Sent: Monday, 24 July 2017 9:50 PM
To: 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/34e85c4e/attachment.html>