Skip to content

[Bug] [Master] Data too long for column 'task_params' at row 1 #7520

@SbloodyS

Description

@SbloodyS

Search before asking

  • I had searched in the issues and found no similar issues.

What happened

[INFO] 2021-12-20 12:44:29.923 org.apache.dolphinscheduler.service.process.ProcessService:[1060] - start submit task : 依赖检查, instance id:176379, state: RUNNING_EXECUTION
[ERROR] 2021-12-20 12:44:29.933 org.apache.dolphinscheduler.service.process.ProcessService:[1043] - task commit to mysql failed
org.springframework.dao.DataIntegrityViolationException: 
### Error updating database.  Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'task_params' at row 1
### The error may exist in org/apache/dolphinscheduler/dao/mapper/TaskInstanceMapper.java (best guess)
### The error may involve org.apache.dolphinscheduler.dao.mapper.TaskInstanceMapper.insert-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO t_ds_task_instance  ( dry_run, flag, environment_code, pid, task_params,  task_type, task_instance_priority, task_code,     worker_group, state, process_instance_id, executor_id, alert_flag,  first_submit_time, max_retry_times, retry_times,  submit_time, name, task_definition_version, delay_time, retry_interval )  VALUES  ( ?, ?, ?, ?, ?,  ?, ?, ?,     ?, ?, ?, ?, ?,  ?, ?, ?,  ?, ?, ?, ?, ? )
### Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'task_params' at row 1
; Data truncation: Data too long for column 'task_params' at row 1; nested exception is com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'task_params' at row 1
        at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
        at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:74)
        at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
        at com.sun.proxy.$Proxy83.insert(Unknown Source)
        at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:271)
        at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:58)
        at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:61)
        at com.sun.proxy.$Proxy90.insert(Unknown Source)
        at org.apache.dolphinscheduler.service.process.ProcessService.createTaskInstance(ProcessService.java:1445)
        at org.apache.dolphinscheduler.service.process.ProcessService.saveTaskInstance(ProcessService.java:1434)
        at org.apache.dolphinscheduler.service.process.ProcessService.submitTaskInstanceToDB(ProcessService.java:1326)
        at org.apache.dolphinscheduler.service.process.ProcessService.submitTask(ProcessService.java:1063)
        at org.apache.dolphinscheduler.service.process.ProcessService.submitTask(ProcessService.java:1032)
        at org.apache.dolphinscheduler.service.process.ProcessService$$FastClassBySpringCGLIB$$ed138739.invoke(<generated>)
        at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
        at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
        at org.apache.dolphinscheduler.service.process.ProcessService$$EnhancerBySpringCGLIB$$b8f3698c.submitTask(<generated>)
        at org.apache.dolphinscheduler.server.master.runner.task.DependentTaskProcessor.submit(DependentTaskProcessor.java:86)
        at org.apache.dolphinscheduler.server.master.runner.WorkflowExecuteThread.submitTaskExec(WorkflowExecuteThread.java:620)
        at org.apache.dolphinscheduler.server.master.runner.WorkflowExecuteThread.submitStandByTask(WorkflowExecuteThread.java:1273)
        at org.apache.dolphinscheduler.server.master.runner.WorkflowExecuteThread.submitPostNode(WorkflowExecuteThread.java:888)
        at org.apache.dolphinscheduler.server.master.runner.WorkflowExecuteThread.startProcess(WorkflowExecuteThread.java:505)
        at org.apache.dolphinscheduler.server.master.runner.WorkflowExecuteThread.run(WorkflowExecuteThread.java:227)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)

What you expected to happen

run job successfully

How to reproduce

above

Anything else

No response

Version

2.0.1-release

Are you willing to submit PR?

  • Yes I am willing to submit a PR!

Code of Conduct

Metadata

Metadata

Assignees

No one assigned

    Labels

    Waiting for replyWaiting for replybugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions