Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
448 views
in Technique[技术] by (71.8m points)

DolphinDB节点启动时初始化失败

我在启动DolphinDB database时出错,错误信息如下,

<ERROR>:Failed to unmarshall the job [schedulejob1]. Failed to deserialize assign statement.. Invalid message format

看起来跟定时作业有关,我的代码如下,

loadPlugin(loadPlugin(getHomeDir()+"\plugins\odbc\pluginOdbc.txt");
use odbc
def doJob(){
    connStr="Driver={MySQL ODBC 8.0 UNICODE Driver};Server=127.0.0.1;Database=ecimp_ver3;User=newuser;Password=dolphindb123;Option=3;" 
    conn1=odbc::connect(connStr)
}
scheduleJob("schedulejob1","init",doJob,15:00m, 2020.04.01, 2020.12.31, 'D')

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

这个是因为scheduled Job中用到了ODBC插件函数,而odbc插件在系统启动时没有加载,所以读取scheduled job的时候,因无法识别这个函数。解决办法是在启动脚本中加入下面这行即可:

loadPlugin("plugins/odbc/pluginOdbc.txt")

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...