error processing inbound activity: `QueryFailedError: invalid input syntax for type boolean: ""`
This activity:
{
"jobData": {
"activity": {
"@context": [
"https://www.w3.org/ns/activitystreams",
"https://app.wafrn.net/contexts/litepub-0.1.jsonld"
],
"id": "https://app.wafrn.net/fediverse/activity/post/53d32d60-595a-4f01-9f16-cac8668ee8a5",
"type": "Create",
"actor": "https://app.wafrn.net/fediverse/blog/gabboman",
"published": "2024-07-24T09:48:30.000Z",
"to": [
"https://app.wafrn.net/fediverse/blog/gabboman/followers",
"https://s.thenautilus.net/users/900rccolig",
"https://toot.kif.rocks/users/ruhrscholz",
"https://plasmatrap.com/users/8zntigkbuy"
],
"cc": [
"https://www.w3.org/ns/activitystreams#Public"
],
"object": {
"id": "https://app.wafrn.net/fediverse/post/53d32d60-595a-4f01-9f16-cac8668ee8a5",
"actor": "https://app.wafrn.net/fediverse/blog/gabboman",
"type": "Note",
"inReplyTo": "https://s.thenautilus.net/notes/9w3868jblr",
"published": "2024-07-24T09:48:30.000Z",
"url": "https://app.wafrn.net/fediverse/post/53d32d60-595a-4f01-9f16-cac8668ee8a5",
"attributedTo": "https://app.wafrn.net/fediverse/blog/gabboman",
"to": [
"https://app.wafrn.net/fediverse/blog/gabboman/followers",
"https://s.thenautilus.net/users/900rccolig",
"https://toot.kif.rocks/users/ruhrscholz",
"https://plasmatrap.com/users/8zntigkbuy"
],
"cc": [
"https://www.w3.org/ns/activitystreams#Public"
],
"atomUri": "https://app.wafrn.net/fediverse/post/53d32d60-595a-4f01-9f16-cac8668ee8a5",
"inReplyToAtomUri": "https://s.thenautilus.net/notes/9w3868jblr",
"content": "<p><span class=\"h-card\" translate=\"no\"><a href=\"https://s.thenautilus.net/@dakkar\" class=\"u-url mention\">@<span>dakkar</span></a></span> <span class=\"h-card\" translate=\"no\"><a href=\"https://toot.kif.rocks/@ruhrscholz\" class=\"u-url mention\">@<span>ruhrscholz</span></a></span> <span class=\"h-card\" translate=\"no\"><a href=\"https://plasmatrap.com/@privateger\" class=\"u-url mention\">@<span>privateger</span></a></span> hmmm. woot woot!</p>",
"attachment": [
{
"type": "Document",
"mediaType": "image/webp",
"url": "https://media.wafrn.net/1721814474796_4850360d5671e816b68601b5b7d1b1efca927daa.webp",
"sensitive": "",
"name": "wafrn screenshot. publish post button that says \"publish reply to woot\""
}
],
"tag": [
{
"type": "Mention",
"name": "@dakkar@s.thenautilus.net",
"href": "https://s.thenautilus.net/users/900rccolig"
},
{
"type": "Mention",
"name": "@ruhrscholz@toot.kif.rocks",
"href": "https://toot.kif.rocks/users/ruhrscholz"
},
{
"type": "Mention",
"name": "@privateger@plasmatrap.com",
"href": "https://plasmatrap.com/users/8zntigkbuy"
}
],
"replies": {
"id": "https://app.wafrn.net/fediverse/post/53d32d60-595a-4f01-9f16-cac8668ee8a5/replies",
"type": "Collection",
"first": {
"type": "CollectionPage",
"partOf": "https://app.wafrn.net/fediverse/post/53d32d60-595a-4f01-9f16-cac8668ee8a5/replies",
"items": []
}
}
},
"signature": {
"type": "RsaSignature2017",
"creator": "https://app.wafrn.net/fediverse/blog/gabboman",
"domain": "app.wafrn.net",
"nonce": "c9e0d1278a509be2d1b993e87253b3ce",
"created": "2024-07-24T09:48:30.000Z",
"signatureValue": "KPSAx9Bc/i7wM9FN0PvY/w1ChivkfBopI4V5aWpqLPq6g+RisW2Ma/x91QamHBp2oaqCoCbAUS2YyMDDMi3yFZ0EGS8xrLInD/WOC6srS818FpDaiNXs4IFMrXriXEUxcMQjrwwA1fpsCXvHSR9HI/HiV/CREHTrodcc2XpQ++iCCF7357ZlKhrWv7pt/iDmBg1ShKiVgBcBRW7H8X8RS36Nqpg+aQoytqO0CqTY2DH1unpmhOI6mCT2/nxE2qG4it67B84UMoqRfgbA5kReFcGLLV1ZqpFpuvPzQJzhTd7ch8m3NReqjYjmupkjs3AH5YTvz9HlQAe/5zYlr8gcM/wbK8ILjxytLsSPC2qLXGwRsx4AN+uW71UbNlMTiWgOpySJkYw8HrH3CLkaR7QH7WTMIOYa7MhwaHUIUG2Sr71zVn05Qvo3Y5kOBTTD+szo44tj5z5on8Wh/Dc0qq+w7e1Qk/Pb0bX97MxzSHsb3Kr9RCTOSn0AwAU/RMLTuVKxzPBZ/1+yvlmnrXK1DE9YMBByIyKB4+diGrw7zfoWL81IU+ddcNAYcXBbBQ/lfCuy3aqNdGXHu4NVocFUKjtcLuxHb+eILbCFy3hfdOWKWxDFty0UsqI9RVpn3921n07IQzkPDYPEK6Bcy0xRrsIQGNWHb8okL/aZWdxib7LWufc="
}
},
"signature": {
"scheme": "Signature",
"params": {
"keyId": "https://app.wafrn.net/fediverse/blog/gabboman#main-key",
"algorithm": "rsa-sha256",
"headers": [
"(request-target)",
"host",
"date",
"algorithm",
"digest"
],
"signature": "M/hY+nx0NmUTbTg07/eIsd22QlFUPbLD1bFBuVrxjeTAshnUbwWwgBYm9Qifaeik4Ve4T7Jq6VOoG88BArujpkp8CLgzjoBihHxb0n8M/BUlgBWLKvQtf5dQ0RUO5+3EKtXUEE95oECG2rNWOVgaDa1vk199y4CHnKQpXlHKXlBu2x5R5HlO5PAjs6t1P/j/ai6355rhgfp7JOaLc9X5uRcZg4Hw6yQBMOCWJIpzVdETqYAjbRWs04lreQ/eZMPRPayTAeNBYCyIFaTb7UtyfE9Z32v6mOr9XPSznpmjwvhW2rLyrgf13KIOtAUUE3+qaB4uhioLqJDNGFJoNBhtpoXv1p7WxFAzc+fVPwbw1CK8mcfq/uvBvDnQv1axSPHrMDWFGLcONkhc0USiV1qTE8ws/8qIMNUUxlYCY19+t5JwkT8Oc0wlgrtkL4TpN4xIjWerAZ+zRRaYCfhO7sDZYM2ga8C+bzsmR845w2dWk3unlixM5befRIB9PcEjFaT1xQRxfcqWyuckqfbF14D4iqZ8BicU5o/LXaVOUPpoUHC7wZkomqj8wgeRTSXdcC+YV/oV7jbHXqqKjCih9U5/aktciufz+lGpqDo8a5kghra8Nj/oL2rgUKgllQSZ28Yjq6FDxRCnFp7yB3SwJ8CLuVCszOb6JgREEilLQlpYLO4="
},
"signingString": "(request-target): post /users/900rccolig/inbox\nhost: s.thenautilus.net\ndate: Wed, 24 Jul 2024 09:48:32 GMT\nalgorithm: rsa-sha256\ndigest: SHA-256=r0e564R6YR9fsNwStW1Zb2ahZZcnrfDOnE0bFA6WBDs=",
"algorithm": "RSA-SHA256",
"keyId": "https://app.wafrn.net/fediverse/blog/gabboman#main-key"
}
},
"returnValue": null
}
produced this error:
QueryFailedError: invalid input syntax for type boolean: ""
at PostgresQueryRunner.query (/opt/misskey/misskey/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async InsertQueryBuilder.execute (/opt/misskey/misskey/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5/node_modules/typeorm/query-builder/InsertQueryBuilder.js:106:33)
at async DriveService.save (file:///opt/misskey/misskey/packages/backend/built/core/DriveService.js:210:20)
at async DriveService.addFile (file:///opt/misskey/misskey/packages/backend/built/core/DriveService.js:502:20)
at async DriveService.uploadFromUrl (file:///opt/misskey/misskey/packages/backend/built/core/DriveService.js:690:31)
at async ApImageService.createImage (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/models/ApImageService.js:76:22)
at async ApImageService.resolveImage (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/models/ApImageService.js:103:16)
at async ApNoteService.createNote (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/models/ApNoteService.js:198:26)
at async ApInboxService.createNote (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/ApInboxService.js:382:13)
at async ApInboxService.create (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/ApInboxService.js:361:13)
at async ApInboxService.performOneActivity (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/ApInboxService.js:149:20)
at async ApInboxService.performActivity (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/ApInboxService.js:134:22)
at async InboxProcessorService.process (file:///opt/misskey/misskey/packages/backend/built/queue/processors/InboxProcessorService.js:190:28)
at async Worker.processJob (/opt/misskey/misskey/node_modules/.pnpm/bullmq@5.7.8/node_modules/bullmq/dist/cjs/classes/worker.js:441:28)
at async Worker.retryIfFailed (/opt/misskey/misskey/node_modules/.pnpm/bullmq@5.7.8/node_modules/bullmq/dist/cjs/classes/worker.js:630:24)
QueryFailedError: invalid input syntax for type boolean: ""
at PostgresQueryRunner.query (/opt/misskey/misskey/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async InsertQueryBuilder.execute (/opt/misskey/misskey/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5/node_modules/typeorm/query-builder/InsertQueryBuilder.js:106:33)
at async DriveService.save (file:///opt/misskey/misskey/packages/backend/built/core/DriveService.js:210:20)
at async DriveService.addFile (file:///opt/misskey/misskey/packages/backend/built/core/DriveService.js:502:20)
at async DriveService.uploadFromUrl (file:///opt/misskey/misskey/packages/backend/built/core/DriveService.js:690:31)
at async ApImageService.createImage (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/models/ApImageService.js:76:22)
at async ApImageService.resolveImage (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/models/ApImageService.js:103:16)
at async ApNoteService.createNote (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/models/ApNoteService.js:198:26)
at async ApInboxService.createNote (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/ApInboxService.js:382:13)
at async ApInboxService.create (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/ApInboxService.js:361:13)
at async ApInboxService.performOneActivity (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/ApInboxService.js:149:20)
at async ApInboxService.performActivity (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/ApInboxService.js:134:22)
at async InboxProcessorService.process (file:///opt/misskey/misskey/packages/backend/built/queue/processors/InboxProcessorService.js:190:28)
at async Worker.processJob (/opt/misskey/misskey/node_modules/.pnpm/bullmq@5.7.8/node_modules/bullmq/dist/cjs/classes/worker.js:441:28)
at async Worker.retryIfFailed (/opt/misskey/misskey/node_modules/.pnpm/bullmq@5.7.8/node_modules/bullmq/dist/cjs/classes/worker.js:630:24)
QueryFailedError: invalid input syntax for type boolean: ""
at PostgresQueryRunner.query (/opt/misskey/misskey/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async InsertQueryBuilder.execute (/opt/misskey/misskey/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5/node_modules/typeorm/query-builder/InsertQueryBuilder.js:106:33)
at async DriveService.save (file:///opt/misskey/misskey/packages/backend/built/core/DriveService.js:210:20)
at async DriveService.addFile (file:///opt/misskey/misskey/packages/backend/built/core/DriveService.js:502:20)
at async DriveService.uploadFromUrl (file:///opt/misskey/misskey/packages/backend/built/core/DriveService.js:690:31)
at async ApImageService.createImage (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/models/ApImageService.js:76:22)
at async ApImageService.resolveImage (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/models/ApImageService.js:103:16)
at async ApNoteService.createNote (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/models/ApNoteService.js:198:26)
at async ApInboxService.createNote (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/ApInboxService.js:382:13)
at async ApInboxService.create (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/ApInboxService.js:361:13)
at async ApInboxService.performOneActivity (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/ApInboxService.js:149:20)
at async ApInboxService.performActivity (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/ApInboxService.js:134:22)
at async InboxProcessorService.process (file:///opt/misskey/misskey/packages/backend/built/queue/processors/InboxProcessorService.js:190:28)
at async Worker.processJob (/opt/misskey/misskey/node_modules/.pnpm/bullmq@5.7.8/node_modules/bullmq/dist/cjs/classes/worker.js:441:28)
at async Worker.retryIfFailed (/opt/misskey/misskey/node_modules/.pnpm/bullmq@5.7.8/node_modules/bullmq/dist/cjs/classes/worker.js:630:24)
QueryFailedError: invalid input syntax for type boolean: ""
at PostgresQueryRunner.query (/opt/misskey/misskey/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async InsertQueryBuilder.execute (/opt/misskey/misskey/node_modules/.pnpm/typeorm@0.3.20_ioredis@5.4.1_pg@8.11.5/node_modules/typeorm/query-builder/InsertQueryBuilder.js:106:33)
at async DriveService.save (file:///opt/misskey/misskey/packages/backend/built/core/DriveService.js:210:20)
at async DriveService.addFile (file:///opt/misskey/misskey/packages/backend/built/core/DriveService.js:502:20)
at async DriveService.uploadFromUrl (file:///opt/misskey/misskey/packages/backend/built/core/DriveService.js:690:31)
at async ApImageService.createImage (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/models/ApImageService.js:76:22)
at async ApImageService.resolveImage (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/models/ApImageService.js:103:16)
at async ApNoteService.createNote (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/models/ApNoteService.js:198:26)
at async ApInboxService.createNote (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/ApInboxService.js:382:13)
at async ApInboxService.create (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/ApInboxService.js:361:13)
at async ApInboxService.performOneActivity (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/ApInboxService.js:149:20)
at async ApInboxService.performActivity (file:///opt/misskey/misskey/packages/backend/built/core/activitypub/ApInboxService.js:134:22)
at async InboxProcessorService.process (file:///opt/misskey/misskey/packages/backend/built/queue/processors/InboxProcessorService.js:190:28)
at async Worker.processJob (/opt/misskey/misskey/node_modules/.pnpm/bullmq@5.7.8/node_modules/bullmq/dist/cjs/classes/worker.js:441:28)
at async Worker.retryIfFailed (/opt/misskey/misskey/node_modules/.pnpm/bullmq@5.7.8/node_modules/bullmq/dist/cjs/classes/worker.js:630:24)
something is wonky in DriveService
!