ITADN

Unable to insert jobs into "queues-database-hooks"

#567Closeduphv 创建于 2025-06-25
bug
U
uphvcommented
### Describe the issue Unable to insert jobs into "queues-database-hooks" ### Vapor version 4.115.0 ### Operating system and version macOS 15.5 ### Swift version 6.1.2 ### Steps to reproduce Trying to use vapor-community/queues-database-hooks. vapor-community/vapor-queues-fluent-driver works fine. I can see jobs queued, dispatched , etc. When the jobs is dispatched the insert to the "_queue_job_completions" table fails with the message in the outcome. Thanks! ### Outcome [ WARNING ] Failed to send notification [error: PSQLError(code: server, serverInfo: [sqlState: 42804, file: parse_target.c, hint: You will need to rewrite or cast the expression., line: 586, message: column "payload" is of type jsonb but expression is of type bytea, position: 236, routine: transformAssignedExpr, localizedSeverity: ERROR, severity: ERROR], triggeredFromRequestInFile: PostgresKit/PostgresDatabase+SQL.swift, line: 57, query: PostgresQuery(sql: INSERT INTO "_queue_job_completions" ("id", "jobId", "jobName", "queueName", "payload", "maxRetryCount", "delayUntil", "queuedAt", "dequeuedAt", "completedAt", "errorString", "status", "createdAt", "updatedAt") VALUES ($1, $2, $3, $4, $5, $6, NULL, $7, DEFAULT, NULL, NULL, $8, $9, $10) RETURNING "id", binds: [(****; UUID; format: binary), (****; TEXT; format: binary), (****; TEXT; format: binary), (****; TEXT; format: binary), (****; BYTEA; format: binary), (****; BIGINT; format: binary), (****; TIMESTAMPTZ; format: binary), (****; BIGINT; format: binary), (****; TIMESTAMPTZ; format: binary), (****; TIMESTAMPTZ; format: binary)])), job-id: C69E17DE-A6EB-44EE-BFCC-B0C37E8CDBD8, job-name: ProcessInstanceJob, kind: dispatch, queue: processrawinstance, request-id: CFFB7A85-BB4E-448C-A7CE-17B5105BB51B] ### Additional notes _No response_
关闭于 2025-06-26 2 条评论