Error: value too long for type character varying(512)
What happened? (Please give us a brief description of what happened.)
In the Delayed Inbox queue I have noticed this error appearing many times over the last few days:
Not sure what else I can give you, but here's the JSON from a couple of the failures. The current ones I am seeing all seem to have https://mstdn.social/users/GreenFire as the actor
{
"jobData": {
"activity": {
"@context": "https://www.w3.org/ns/activitystreams",
"id": "https://mstdn.social/users/GreenFire/statuses/112722965060731604/activity",
"type": "Announce",
"actor": "https://mstdn.social/users/GreenFire",
"published": "2024-07-03T14:12:26Z",
"to": [
"https://www.w3.org/ns/activitystreams#Public"
],
"cc": [
"https://threads.net/ap/users/17841400639480053/",
"https://mstdn.social/users/GreenFire/followers"
],
"object": "https://threads.net/ap/users/17841400639480053/post/18100360045424314/"
},
"signature": {
"scheme": "Signature",
"params": {
"keyId": "https://mstdn.social/users/GreenFire#main-key",
"algorithm": "rsa-sha256",
"headers": [
"(request-target)",
"host",
"date",
"digest",
"content-type"
],
"signature": "1FlvbI3/4tPv5CBXfliKkEj8yWwEdG0lFjeB6530QPUe0CAIlTtsUoCBq9UP0Fz3HpH5oku0eWeIMM2Sp6nB6OufvNXlGBSlq2Xv8Z0putSbg236AXon0scxXgyKSzAm62GQffphvScgB+VHRfnyp/n02D97n164ocTG9CAXBcgksCUEmVKKLWbrRgOHD6IEJO79bReR4/5Hq2ndDK/4vEQv2uu6hJ4ljbASD2fmTp+UyZcJghvhl0fs4nwYKlVHtZG8rXg8qgV1a41LuujNsxikVlRG34aRPhivBAwq12Vhtc8Zc86pQ39x2ykLw9ahu7bthj+VRIHILG77tj++aw=="
},
"signingString": "(request-target): post /inbox\nhost: ibe.social\ndate: Wed, 03 Jul 2024 14:12:26 GMT\ndigest: SHA-256=920VouLD+cb40Vwn+v9C6GFdAvD7X5OI9FgpodkMMgc=\ncontent-type: application/activity+json",
"algorithm": "RSA-SHA256",
"keyId": "https://mstdn.social/users/GreenFire#main-key"
}
},
"returnValue": null
}{
"jobData": {
"activity": {
"@context": [
"https://www.w3.org/ns/activitystreams",
{
"ostatus": "http://ostatus.org#",
"atomUri": "ostatus:atomUri",
"inReplyToAtomUri": "ostatus:inReplyToAtomUri",
"conversation": "ostatus:conversation",
"sensitive": "as:sensitive",
"toot": "http://joinmastodon.org/ns#",
"votersCount": "toot:votersCount"
}
],
"id": "https://mstdn.social/users/GreenFire/statuses/112723373004278784/activity",
"type": "Create",
"actor": "https://mstdn.social/users/GreenFire",
"published": "2024-07-03T15:56:11Z",
"to": [
"https://www.w3.org/ns/activitystreams#Public"
],
"cc": [
"https://mstdn.social/users/GreenFire/followers",
"https://threads.net/ap/users/17841400815700014/"
],
"object": {
"id": "https://mstdn.social/users/GreenFire/statuses/112723373004278784",
"type": "Note",
"summary": null,
"inReplyTo": "https://threads.net/ap/users/17841400815700014/post/18056745787568815/",
"published": "2024-07-03T15:56:11Z",
"url": "https://mstdn.social/@GreenFire/112723373004278784",
"attributedTo": "https://mstdn.social/users/GreenFire",
"to": [
"https://www.w3.org/ns/activitystreams#Public"
],
"cc": [
"https://mstdn.social/users/GreenFire/followers",
"https://threads.net/ap/users/17841400815700014/"
],
"sensitive": false,
"atomUri": "https://mstdn.social/users/GreenFire/statuses/112723373004278784",
"inReplyToAtomUri": "https://threads.net/ap/users/17841400815700014/post/18056745787568815/",
"conversation": "tag:mstdn.social,2024-07-03:objectId=401490394:objectType=Conversation",
"content": "<p><span class=\"h-card\" translate=\"no\"><a href=\"https://threads.net/@brianstelter/\" class=\"u-url mention\">@<span>brianstelter</span></a></span> <br />Congratulations mainstream media and their paid pundits. You've succeeded in painting Joe Biden in a bad light while successfully hiding what the Federalist Society, Heritage Foundation, and the GOP are doing to undermine democracy and the rule of law in the USA.</p><p>I expect your proud, but you're going to regret the choices you've made.</p>",
"contentMap": {
"en": "<p><span class=\"h-card\" translate=\"no\"><a href=\"https://threads.net/@brianstelter/\" class=\"u-url mention\">@<span>brianstelter</span></a></span> <br />Congratulations mainstream media and their paid pundits. You've succeeded in painting Joe Biden in a bad light while successfully hiding what the Federalist Society, Heritage Foundation, and the GOP are doing to undermine democracy and the rule of law in the USA.</p><p>I expect your proud, but you're going to regret the choices you've made.</p>"
},
"attachment": [],
"tag": [
{
"type": "Mention",
"href": "https://threads.net/ap/users/17841400815700014/",
"name": "@brianstelter@threads.net"
}
],
"replies": {
"id": "https://mstdn.social/users/GreenFire/statuses/112723373004278784/replies",
"type": "Collection",
"first": {
"type": "CollectionPage",
"next": "https://mstdn.social/users/GreenFire/statuses/112723373004278784/replies?only_other_accounts=true&page=true",
"partOf": "https://mstdn.social/users/GreenFire/statuses/112723373004278784/replies",
"items": []
}
}
},
"signature": {
"type": "RsaSignature2017",
"creator": "https://mstdn.social/users/GreenFire#main-key",
"created": "2024-07-03T15:56:11Z",
"signatureValue": "BDZKEHeC2NQz0XGldMFCki/WlEZL6ToSN/C0JIjrVqaxGaFu3MC93XcdYd3OqWAXhN27MHy9LE4/XfnA32K3duVZlkIHwux7S+T2+Fg9s+Jcu42g5hORYDES4vCqUv5/a8Ex7lsgCF8rywac411EkaaGJOXlXOdBrVShOJag+X956BNMedSYCBWqC7TlbZ7SrqCGEyFY+U7sqH15dXe0yebvcKIM6yF5YSBRs6COh8k2RUHUt848JGJcD0gxT1d7gM7icWLBy4f6LiAn6irUI/ssjSW/OmWq8IJ93bVz1iRNNHBL9C6+XpllzCELMqLoB0ddXVTMrRdW9Oj4+JdNUQ=="
}
},
"signature": {
"scheme": "Signature",
"params": {
"keyId": "https://mstdn.social/users/GreenFire#main-key",
"algorithm": "rsa-sha256",
"headers": [
"(request-target)",
"host",
"date",
"digest",
"content-type"
],
"signature": "VnkBfrJca4APsx3g5iLB70Fj7GbknRgVO5Sq9J8lBM3AjkkOOzYTkV47LwhXUO6iBLJVGdwtTXsBmMidziuGNMEtvKlNDq8JPDwfyIDOxrLsSb49Cl012Il74Tn3uv3hGBNmsu0eVH0OxrE9gUaXSUEF9YraFT2QR0G/VwWG1y3dwqb5ts4oiI2BDQiznZqp0lNvouRZCzXPvHi1xxzT9g+qe1JlshsNqXxd5rDDUocy3DIjaR3jbHkecHp8QgOQkLYhPXAx3LkTVoaIPJaYFoqoPoURRFqHFBIByh59EkuPZ03nZgZ15huT/EytcfHA9Bbh9cxokMcAX2JXiUXlHw=="
},
"signingString": "(request-target): post /inbox\nhost: ibe.social\ndate: Wed, 03 Jul 2024 15:56:11 GMT\ndigest: SHA-256=MqeDGK5uKvHq7kd0z8XfRg1mOOLEPa94WtxiUFlMdUU=\ncontent-type: application/activity+json",
"algorithm": "RSA-SHA256",
"keyId": "https://mstdn.social/users/GreenFire#main-key"
}
},
"returnValue": null
}What did you expect to happen? (Please give us a brief description of what you expected to happen.)
The job to be processed without error!
Version (What version of Sharkey is your instance running? You can find this by clicking your instance's logo at the top left and then clicking instance information.)
2024.5.1
Instance (What instance of Sharkey are you using?)
ibe.social
What type of issue is this? (If this happens on your device and has to do with the user interface, it's client-side. If this happens on either with the API or the backend, or you got a server-side error in the client, it's server-side.)
Server side
How do you deploy Sharkey on your server? (Server-side issues only)
Bare metal, non-docker
What operating system are you using? (Server-side issues only)
Ubuntu 22.03.3 LTS
Contribution Guidelines By submitting this issue, you agree to follow our Contribution Guidelines
- I agree to follow this project's Contribution Guidelines
- I have searched the issue tracker for similar issues, and this is not a duplicate.
Activity
@bumble Is there any error logged on the backend?
added bugbackend label
added federation label
mentioned in issue #880 (closed)
this may have been resolved by 2024.9.1
@bumble is this still a problem with the latest code?
Please register or sign in to reply