[Info-ingres] Vector giving me the shits

[Karl and Betty Schendel]

The libMapRClient.so message is harmless / normal.
The query memory and bufferpool limits are pretty big.  :-)  Was it working with those limits
before?

I don't really see anything in the vectorwise.log that indicates an error.  How about the DBMS log?

Karl

> On Jul 24, 2017, at 7:49 AM, Martin Bowes <martin.bowes at ndph.ox.ac.uk> wrote:
> 
> 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
> _______________________________________________
> Info-ingres mailing list
> Info-ingres at lists.planetingres.org
> http://lists.planetingres.org/mailman/listinfo/info-ingres