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的大神給予指點，非常感謝。
uj5u.com熱心網友回復：
請問，問題解決了嗎？我也遇到了這個問題。。轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/101027.html
標籤：其他數據庫
上一篇：請教SQL執行效率問題