vertica 数据库挂掉问题error SP_receive: Connection closed by spread

r_zhao 2017-10-23 01:29:58

vertica.log上面的日志发现以下报错信息
<WARNING> error SP_receive: Connection closed by spread
..................................
<WARNING> error SP_receive: The network socket experienced an error. This Spread mailbox will no longer work until the connection is disconnected and then reconnected
<INFO> stop: disconnecting #node_a#N015041009057 from spread daemon, Mbox=13
.....................................
<WARNING> VSpread disconnected: lost connection to daemon /opt/vertica/spread/tmp/4803
......................................
[Shutdown] <INFO> Shutting down this node
.....................................

查看vertica.log其他日志信息
在COPY入库或者是查询系统表时候在vertica.log日志中经常会报类似以下信息
sortmanager found maxmerges 7 too small(0MB assigned)
after disabling optimization,maxmerges become 15
..........................
sortmanager found maxmerges 2 too small(64MB assigned)
after disabling optimization,maxmerges become 15
..........................
个人理解，在copy入库ROS文件会进行排序，查询系统表涉及到排序sort时才会有这个信息，我尝试调整资源池配置增加syaquery和sysdata资源配置,但该信息仍然存在，但不知道这个信息是否是导致spread进程挂掉的原因，也不知道为何后台spread进程会挂掉
希望各位vertica的大神给予指点，非常感谢。

...全文