2024-12-11 20:28:20 [debug] Executing (default): SELECT status, count() AS count FROM users_jobs AS users_jobs WHERE users_jobs.job_id = 187 GROUP BY status; app=main reqId=2e021f7a-f461-4ba8-92bb-6166a7b93b5c
2024-12-11 20:28:20 [debug] manual resume job and next status: 1
2024-12-11 20:28:20 [debug] Executing (default): UPDATE jobs SET status=?,result=?,updated_at=? WHERE id = ? app=main reqId=2e021f7a-f461-4ba8-92bb-6166a7b93b5c
2024-12-11 20:28:20 [info] execution (97) run instruction [manual] for node (225) finished as status: 1
2024-12-11 20:28:20 [debug] result of node data={“mhivypurthk”:{“ys_money”:123,“status”:“2”},“_”:“resolve”}
2024-12-11 20:28:20 [debug] run next node (231)
2024-12-11 20:28:20 [info] execution (97) run instruction [calculation] for node (231)
2024-12-11 20:28:20 [debug] config of node data={“engine”:“formula.js”,“expression”:"{{$context.data.ys_money}}{{$context.data.obj.obj_fax}}*{{$context.data.aw_fax}}“}
2024-12-11 20:28:20 [debug] Executing (default): INSERT INTO jobs (id,created_at,updated_at,execution_id,node_id,node_key,upstream_id,status,result) VALUES (DEFAULT,?,?,?,?,?,?,?,?);… app=main reqId=2e021f7a-f461-4ba8-92bb-6166a7b93b5c
2024-12-11 20:28:20 [error] execution (97) error: Cannot create a JSON value from a string with CHARACTER SET ‘binary’. Cannot create a JSON value from a string with CHARACTER SET ‘binary’. name=SequelizeDatabaseError parent={“code”:“ER_INVALID_JSON_CHARSET”,“errno”:3144,“sqlState”:“22032”,“sqlMessage”:“Cannot create a JSON value from a string with CHARACTER SET ‘binary’.”,“sql”:“INSERT INTO jobs (id,created_at,updated_at,execution_id,node_id,node_key,upstream_id,status,result) VALUES (DEFAULT,?,?,?,?,?,?,?,?);”,“parameters”:[“2024-12-11 20:28:20”,“2024-12-11 20:28:20”,97,231,“r6ybeye1u4h”,187,1,“0”]} original={“code”:“ER_INVALID_JSON_CHARSET”,“errno”:3144,“sqlState”:“22032”,“sqlMessage”:“Cannot create a JSON value from a string with CHARACTER SET ‘binary’.”,“sql”:“INSERT INTO jobs (id,created_at,updated_at,execution_id,node_id,node_key,upstream_id,status,result) VALUES (DEFAULT,?,?,?,?,?,?,?,?);”,“parameters”:[“2024-12-11 20:28:20”,“2024-12-11 20:28:20”,97,231,“r6ybeye1u4h”,187,1,“0”]} sql=INSERT INTO jobs (id,created_at,updated_at,execution_id,node_id,node_key,upstream_id,status,result) VALUES (DEFAULT,?,?,?,?,?,?,?,?); parameters=[“2024-12-11 20:28:20”,“2024-12-11 20:28:20”,97,231,“r6ybeye1u4h”,187,1,“0”] stack=Error
at Query.run (/www/wwwroot/nocobase/my-nocobase-app/node_modules/sequelize/lib/dialects/mysql/query.js:52:25)
at /www/wwwroot/nocobase/my-nocobase-app/node_modules/sequelize/lib/sequelize.js:315:28
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async MySQLQueryInterface.insert (/www/wwwroot/nocobase/my-nocobase-app/node_modules/sequelize/lib/dialects/abstract/query-interface.js:308:21)
at async model.save (/www/wwwroot/nocobase/my-nocobase-app/node_modules/sequelize/lib/model.js:2490:35)
at async jobs.create (/www/wwwroot/nocobase/my-nocobase-app/node_modules/sequelize/lib/model.js:1362:12)
at async Processor.saveJob (/www/wwwroot/nocobase/my-nocobase-app/node_modules/@nocobase/plugin-workflow/dist/server/Processor.js:258:13)
at async Processor.exec (/www/wwwroot/nocobase/my-nocobase-app/node_modules/@nocobase/plugin-workflow/dist/server/Processor.js:186:22)
at async Processor.resume (/www/wwwroot/nocobase/my-nocobase-app/node_modules/@nocobase/plugin-workflow/dist/server/Processor.js:153:5)
at async PluginWorkflowServer.process (/www/wwwroot/nocobase/my-nocobase-app/node_modules/@nocobase/plugin-workflow/dist/server/Plugin.js:510:7)
2024-12-11 20:28:20 [debug] Executing (default): SELECT executions.id, executions.created_at AS createdAt, executions.updated_at AS updatedAt, executions.key, executions.event_key AS eventKey, executions.context, executions.status, executions.workflow_id AS workflowId, workflow.id AS workflow.id, workflow.created_at AS workflow.createdAt, workflow.updated_at AS workflow.updatedAt, workflow.key AS workflow.key, workflow.title AS workflow.title, workflow.enabled AS workflow.enabled, workflow.description AS workflow.description, workflow.type AS workflow.type, workflow.trigger_title AS workflow.triggerTitle, workflow.config AS workflow.config, workflow.executed AS workflow.executed, workflow.all_executed AS workflow.allExecuted, workflow.current AS workflow.current, workflow.sync AS workflow.sync, workflow.options AS workflow.options FROM executions AS executions LEFT OUTER JOIN workflows AS workflow ON executions.workflow_id = workflow.id WHERE executions.status IS NULL AND workflow.enabled = true AND workflow.id IS NOT NULL ORDER BY ISNULL(executions.id), executions.id ASC LIMIT 1; app=main reqId=2e021f7a-f461-4ba8-92bb-6166a7b93b5c
2024-12-11 20:28:21 [info] request GET /api/users_jobs:list?pageSize=20&sort=-createdAt&appends=user&appends=node&appends=workflow&appends=execution.status&except=node.config&except=workflow.config&except=workflow.options&filter=%7B%22$and%22:[%7B%22status%22:%7B%22$eq%22:0%7D%7D]%7D method=GET path=/api/users_jobs:list?pageSize=20&sort=-createdAt&appends=user&appends=node&appends=workflow&appends=execution.status&except=node.config&except=workflow.config&except=workflow.options&filter=%7B%22$and%22:[%7B%22status%22:%7B%22$eq%22:0%7D%7D]%7D req={“header”:{“x-role”:“admin”,“x-hostname”:“111.231.64.22”,“x-timezone”:”+08:00",“x-locale”:“zh-CN”,“x-authenticator”:“basic”}} app=main reqId=6d697480-3e7b-4ff1-ad1d-a5533d210695