Miscellaneous error/warning log items #1119

melroy89 · 2024-09-12T16:57:37Z

Describe the bug

I see a long list of errors and warnings in the prod log.

We really need to clean-up some of those and try to fix the PHP warning or PHP or Twig errors we see...

I could make 20+ GitHub Issues out of this single ticket, but that won't help us. And will only cause more overhead. See the list of warnings/errors below under "List of issues".

On which Mbin instance did you find the bug?
kbin.melroy.org

Which Mbin version was running on the instance?
1.7.1

To Reproduce
Steps to reproduce the behavior:

Check-out the log: tail -f var/log/prod-xx-x-x-x.log
And follow it for a while...

Expected behavior

Minimal amount of errors and warnings in the production log. Only some error messages make sense if there is a real error and we still want to keep reporting it to admin of the instance.

Let's just see how much we can resolve in the first 1.7.2 milestone..

List of issues

Directly from the production log output:

the first - missing null check, see PR: Check if EntryComment is defined and not null #1129

{"message":"Uncaught PHP Exception Twig\\Error\\RuntimeError: \"Error rendering \"entry_comment\" component: Expected argument of type \"App\\Entity\\EntryComment\", \"null\" given at property path \"comment\".\" at view.html.twig line 49","context":{"exception":{"class":"Twig\\Error\\RuntimeError","message":"Error rendering \"entry_comment\" component: Expected argument of type \"App\\Entity\\EntryComment\", \"null\" given at property path \"comment\".","code":0,"file":"/var/www/kbin.melroy.org/html/templates/entry/comment/view.html.twig:49","previous":{"class":"Symfony\\Component\\PropertyAccess\\Exception\\InvalidTypeException","message":"Expected argument of type \"App\\Entity\\EntryComment\", \"null\" given at property path \"comment\".","code":0,"file":"/var/www/kbin.melroy.org/html/vendor/symfony/property-access/PropertyAccessor.php:203","previous":{"class":"TypeError","message":"Cannot assign null to property App\\Twig\\Components\\EntryCommentComponent::$comment of type App\\Entity\\EntryComment","code":0,"file":"/var/www/kbin.melroy.org/html/vendor/symfony/property-access/PropertyAccessor.php:520"}}}},"level":500,"level_name":"CRITICAL","channel":"request","datetime":"2024-09-12T12:18:16.360410+02:00","extra":{}}

the second Fix 2nd miscellaneous bug #1124

{"message":"Error thrown while handling message App\\Message\\ActivityPub\\Inbox\\ChainActivityMessage. Sending for retry #1 using 300000 ms delay. Error: \"Handling \"App\\Message\\ActivityPub\\Inbox\\ChainActivityMessage\" failed: An exception occurred while executing a query: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint \"uniq_2b219d70904f155e\"\nDETAIL:  Key (ap_id)=(https://lemmy.world/post/19549932) already exists.\"","context":{"class":"App\\Message\\ActivityPub\\Inbox\\ChainActivityMessage","message_id":null,"retryCount":1,"delay":300000,"error":"Handling \"App\\Message\\ActivityPub\\Inbox\\ChainActivityMessage\" failed: An exception occurred while executing a query: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint \"uniq_2b219d70904f155e\"\nDETAIL:  Key (ap_id)=(https://lemmy.world/post/19549932) already exists.","exception":{"class":"Symfony\\Component\\Messenger\\Exception\\HandlerFailedException","message":"Handling \"App\\Message\\ActivityPub\\Inbox\\ChainActivityMessage\" failed: An exception occurred while executing a query: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint \"uniq_2b219d70904f155e\"\nDETAIL:  Key (ap_id)=(https://lemmy.world/post/19549932) already exists.","code":7,"file":"/var/www/kbin.melroy.org/html/vendor/symfony/messenger/Middleware/HandleMessageMiddleware.php:124","previous":{"class":"Doctrine\\DBAL\\Exception\\UniqueConstraintViolationException","message":"An exception occurred while executing a query: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint \"uniq_2b219d70904f155e\"\nDETAIL:  Key (ap_id)=(https://lemmy.world/post/19549932) already exists.","code":7,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:53","previous":{"class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","message":"SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint \"uniq_2b219d70904f155e\"\nDETAIL:  Key (ap_id)=(https://lemmy.world/post/19549932) already exists.","code":7,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28","previous":{"class":"PDOException","message":"SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint \"uniq_2b219d70904f155e\"\nDETAIL:  Key (ap_id)=(https://lemmy.world/post/19549932) already exists.","code":23505,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130"}}}}},"level":300,"level_name":"WARNING","channel":"messenger","datetime":"2024-09-08T23:58:40.008877+02:00","extra":{}}

the third Fix 3rd miscellaneous bug #1120

{"message":"Warning: Undefined array key \"attributedTo\"","context":{"exception":{"class":"ErrorException","message":"Warning: Undefined array key \"attributedTo\"","code":0,"file":"/var/www/kbin.melroy.org/html/src/Service/ActivityPubManager.php:554"}},"level":400,"level_name":"ERROR","channel":"php","datetime":"2024-09-08T23:58:47.966836+02:00","extra":{}}
{"message":"Warning: Undefined array key \"attributedTo\"","context":{"exception":{"class":"ErrorException","message":"Warning: Undefined array key \"attributedTo\"","code":0,"file":"/var/www/kbin.melroy.org/html/src/Service/ActivityPubManager.php:582"}},"level":400,"level_name":"ERROR","channel":"php","datetime":"2024-09-08T23:58:48.338044+02:00","extra":{}}

the fourth Fix 4th miscellaneous bug #1121

{"message":"Warning: Undefined array key \"publicKey\"","context":{"exception":{"class":"ErrorException","message":"Warning: Undefined array key \"publicKey\"","code":0,"file":"/var/www/kbin.melroy.org/html/src/Service/ActivityPub/SignatureValidator.php:116"}},"level":400,"level_name":"ERROR","channel":"php","datetime":"2024-09-12T12:19:29.121860+02:00","extra":{}}
{"message":"Warning: Trying to access array offset on null","context":{"exception":{"class":"ErrorException","message":"Warning: Trying to access array offset on null","code":0,"file":"/var/www/kbin.melroy.org/html/src/Service/ActivityPub/SignatureValidator.php:116"}},"level":400,"level_name":"ERROR","channel":"php","datetime":"2024-09-12T12:19:29.122088+02:00","extra":{}}
{"message":"Unable to extract public key for 'https://mastodon.sdf.org/users/TomCox'.","context":{"user":"https://mastodon.sdf.org/users/TomCox"},"level":300,"level_name":"WARNING","channel":"app","datetime":"2024-09-12T12:19:29.122196+02:00","extra":{}}

I added "feddit.de" to block list (in the admin panel). Why do I still see?

{"message":"ApHttpClient:getActorObject get fail: https://feddit.de/u/Hellschwarz, ex: Symfony\\Component\\HttpClient\\Exception\\TransportException: Could not resolve host: feddit.de for \"https://feddit.de/u/Hellschwarz\". - there was an exception while getting the content, Symfony\\Component\\HttpClient\\Exception\\TransportException: Could not resolve host: feddit.de for \"https://feddit.de/u/Hellschwarz\".","context":{"type":"ApHttpClient:getActorObject","address":"https://feddit.de/u/Hellschwarz","e":"Symfony\\Component\\HttpClient\\Exception\\TransportException","msg":"Could not resolve host: feddit.de for \"https://feddit.de/u/Hellschwarz\".","content":"there was an exception while getting the content, Symfony\\Component\\HttpClient\\Exception\\TransportException: Could not resolve host: feddit.de for \"https://feddit.de/u/Hellschwarz\"."},"level":400,"level_name":"ERROR","channel":"app","datetime":"2024-09-12T12:20:37.666017+02:00","extra":{}}
{"message":"Error thrown while handling message App\\Message\\ActivityPub\\UpdateActorMessage. Removing from transport after 7 retries. Error: \"Handling \"App\\Message\\ActivityPub\\UpdateActorMessage\" failed: Could not resolve host: feddit.de for \"https://feddit.de/u/Hellschwarz\".\"","context":{"class":"App\\Message\\ActivityPub\\UpdateActorMessage","message_id":null,"retryCount":7,"error":"Handling \"App\\Message\\ActivityPub\\UpdateActorMessage\" failed: Could not resolve host: feddit.de for \"https://feddit.de/u/Hellschwarz\".","exception":{"class":"Symfony\\Component\\Messenger\\Exception\\HandlerFailedException","message":"Handling \"App\\Message\\ActivityPub\\UpdateActorMessage\" failed: Could not resolve host: feddit.de for \"https://feddit.de/u/Hellschwarz\".","code":0,"file":"/var/www/kbin.melroy.org/html/vendor/symfony/messenger/Middleware/HandleMessageMiddleware.php:124","previous":{"class":"Symfony\\Component\\HttpClient\\Exception\\TransportException","message":"Could not resolve host: feddit.de for \"https://feddit.de/u/Hellschwarz\".","code":0,"file":"/var/www/kbin.melroy.org/html/vendor/symfony/http-client/Response/CommonResponseTrait.php:140"}}},"level":500,"level_name":"CRITICAL","channel":"messenger","datetime":"2024-09-12T12:20:37.666575+02:00","extra":{}}
{"message":"ApHttpClient:getActorObject get fail: https://feddit.de/u/Hellschwarz, ex: Symfony\\Component\\HttpClient\\Exception\\TransportException: Could not resolve host: feddit.de for \"https://feddit.de/u/Hellschwarz\". - there was an exception while getting the content, Symfony\\Component\\HttpClient\\Exception\\TransportException: Could not resolve host: feddit.de for \"https://feddit.de/u/Hellschwarz\".","context":{"type":"ApHttpClient:getActorObject","address":"https://feddit.de/u/Hellschwarz","e":"Symfony\\Component\\HttpClient\\Exception\\TransportException","msg":"Could not resolve host: feddit.de for \"https://feddit.de/u/Hellschwarz\".","content":"there was an exception while getting the content, Symfony\\Component\\HttpClient\\Exception\\TransportException: Could not resolve host: feddit.de for \"https://feddit.de/u/Hellschwarz\"."},"level":400,"level_name":"ERROR","channel":"app","datetime":"2024-09-12T12:20:37.991473+02:00","extra":{}}
{"message":"Error thrown while handling message App\\Message\\ActivityPub\\UpdateActorMessage. Sending for retry #1 using 1800000 ms delay. Error: \"Handling \"App\\Message\\ActivityPub\\UpdateActorMessage\" failed: Could not resolve host: feddit.de for \"https://feddit.de/u/Hellschwarz\".\"","context":{"class":"App\\Message\\ActivityPub\\UpdateActorMessage","message_id":3468087,"retryCount":1,"delay":1800000,"error":"Handling \"App\\Message\\ActivityPub\\UpdateActorMessage\" failed: Could not resolve host: feddit.de for \"https://feddit.de/u/Hellschwarz\".","exception":{"class":"Symfony\\Component\\Messenger\\Exception\\HandlerFailedException","message":"Handling \"App\\Message\\ActivityPub\\UpdateActorMessage\" failed: Could not resolve host: feddit.de for \"https://feddit.de/u/Hellschwarz\".","code":0,"file":"/var/www/kbin.melroy.org/html/vendor/symfony/messenger/Middleware/HandleMessageMiddleware.php:124","previous":{"class":"Symfony\\Component\\HttpClient\\Exception\\TransportException","message":"Could not resolve host: feddit.de for \"https://feddit.de/u/Hellschwarz\".","code":0,"file":"/var/www/kbin.melroy.org/html/vendor/symfony/http-client/Response/CommonResponseTrait.php:140"}}},"level":300,"level_name":"WARNING","channel":"messenger","datetime":"2024-09-12T12:20:37.992118+02:00","extra":{}}

the sixth: I also blocked kbin.social. Why is this still happening? Fix 6th miscellaneous bug #1125

{"message":"Error thrown while handling message App\\Message\\ActivityPub\\Inbox\\ChainActivityMessage. Removing from transport after 3 retries. Error: \"Handling \"App\\Message\\ActivityPub\\Inbox\\ChainActivityMessage\" failed: Invalid status code while getting: https://kbin.social/m/[email protected]/t/994217/-/comment/6435263 : 503, <html lang=\"en\" style=\"font-size: 100%\">\n<head>\n    <title>Error 50x - kbin.social</title>\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n    <meta name=\"keywords\"\n          content=\"kbin, link aggregator, mikroblog, socialmedia, wykop, reddit, twitter, open source, fediverse, makigi\">\n    <meta name=\"description\" content=\"Explore Fediverse\">\n    <meta property=\"og:url\" content=\"https://kbin.social/asdf\">\n    <meta property=\"og:type\" content=\"article\">\n    <meta property=\"og:title\" content=\"Error 404 - kbin.social\">\n    <meta property=\"og:description\" content=\"Explore Fediverse\">\n    <meta property=\"og:image\" content=\"https://kbin.social/kbin-og.png\">\n    <link rel=\"shortcut icon\" href=\"https://kbin.social/favicon.ico\">\n    <link rel=\"icon\" href=\"https://kbin.social/favicon.ico\" sizes=\"any\">\n    <link rel=\"icon\" href=\"https://kbin.social/favicon.svg\" type=\"image/svg+xml\">\n    <link rel=\"stylesheet\" href=\"https://kbin.pub/kbin.css\">\n<body class=\"theme--kbin fix\"","context":{"class":"App\\Message\\ActivityPub\\Inbox\\ChainActivityMessage","message_id":3467688,"retryCount":3,"error":"Handling \"App\\Message\\ActivityPub\\Inbox\\ChainActivityMessage\" failed: Invalid status code while getting: https://kbin.social/m/[email protected]/t/994217/-/comment/6435263 : 503, <html lang=\"en\" style=\"font-size: 100%\">\n<head>\n    <title>Error 50x - kbin.social</title>\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n    <meta name=\"keywords\"\n          content=\"kbin, link aggregator, mikroblog, socialmedia, wykop, reddit, twitter, open source, fediverse, makigi\">\n    <meta name=\"description\" content=\"Explore Fediverse\">\n    <meta property=\"og:url\" content=\"https://kbin.social/asdf\">\n    <meta property=\"og:type\" content=\"article\">\n    <meta property=\"og:title\" content=\"Error 404 - kbin.social\">\n    <meta property=\"og:description\" content=\"Explore Fediverse\">\n    <meta property=\"og:image\" content=\"https://kbin.social/kbin-og.png\">\n    <link rel=\"shortcut icon\" href=\"https://kbin.social/favicon.ico\">\n    <link rel=\"icon\" href=\"https://kbin.social/favicon.ico\" sizes=\"any\">\n    <link rel=\"icon\" href=\"https://kbin.social/favicon.svg\" type=\"image/svg+xml\">\n    <link rel=\"stylesheet\" href=\"https://kbin.pub/kbin.css\">\n<body class=\"theme--kbin fix","exception":{"class":"Symfony\\Component\\Messenger\\Exception\\HandlerFailedException","message":"Handling \"App\\Message\\ActivityPub\\Inbox\\ChainActivityMessage\" failed: Invalid status code while getting: https://kbin.social/m/[email protected]/t/994217/-/comment/6435263 : 503, <html lang=\"en\" style=\"font-size: 100%\">\n<head>\n    <title>Error 50x - kbin.social</title>\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n    <meta name=\"keywords\"\n          content=\"kbin, link aggregator, mikroblog, socialmedia, wykop, reddit, twitter, open source, fediverse, makigi\">\n    <meta name=\"description\" content=\"Explore Fediverse\">\n    <meta property=\"og:url\" content=\"https://kbin.social/asdf\">\n    <meta property=\"og:type\" content=\"article\">\n    <meta property=\"og:title\" content=\"Error 404 - kbin.social\">\n    <meta property=\"og:description\" content=\"Explore Fediverse\">\n    <meta property=\"og:image\" content=\"https://kbin.social/kbin-og.png\">\n    <link rel=\"shortcut icon\" href=\"https://kbin.social/favicon.ico\">\n    <link rel=\"icon\" href=\"https://kbin.social/favicon.ico\" sizes=\"any\">\n    <link rel=\"icon\" href=\"https://kbin.social/favicon.svg\" type=\"image/svg+xml\">\n    <link rel=\"stylesheet\" href=\"https://kbin.pub/kbin.css\">\n<body class=\"theme--kbin fix","code":0,"file":"/var/www/kbin.melroy.org/html/vendor/symfony/messenger/Middleware/HandleMessageMiddleware.php:124","previous":{"class":"App\\Exception\\InvalidApPostException","message":"Invalid status code while getting: https://kbin.social/m/[email protected]/t/994217/-/comment/6435263 : 503, <html lang=\"en\" style=\"font-size: 100%\">\n<head>\n    <title>Error 50x - kbin.social</title>\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n    <meta name=\"keywords\"\n          content=\"kbin, link aggregator, mikroblog, socialmedia, wykop, reddit, twitter, open source, fediverse, makigi\">\n    <meta name=\"description\" content=\"Explore Fediverse\">\n    <meta property=\"og:url\" content=\"https://kbin.social/asdf\">\n    <meta property=\"og:type\" content=\"article\">\n    <meta property=\"og:title\" content=\"Error 404 - kbin.social\">\n    <meta property=\"og:description\" content=\"Explore Fediverse\">\n    <meta property=\"og:image\" content=\"https://kbin.social/kbin-og.png\">\n    <link rel=\"shortcut icon\" href=\"https://kbin.social/favicon.ico\">\n    <link rel=\"icon\" href=\"https://kbin.social/favicon.ico\" sizes=\"any\">\n    <link rel=\"icon\" href=\"https://kbin.social/favicon.svg\" type=\"image/svg+xml\">\n    <link rel=\"stylesheet\" href=\"https://kbin.pub/kbin.css\">\n<body class=\"theme--kbin fix","code":0,"file":"/var/www/kbin.melroy.org/html/src/Service/ActivityPub/ApHttpClient.php:104"}}},"level":500,"level_name":"CRITICAL","channel":"messenger","datetime":"2024-09-12T12:38:53.000175+02:00","extra":{}}

the seventh: also maybe do not return the whole HTML page.. >< Fix 7th miscellaneous bug #1123

{"message":"could not retrieve all the dependencies of array{\"@context\":[\"https://join-lemmy.org/context.json\",\"https://www.w3.org/ns/activitystreams\"],\"type\":\"Note\",\"id\":\"https://lemmy.world/comment/12312933\",\"attributedTo\":\"https://lemmy.world/u/aaaa\",\"to\":[\"https://www.w3.org/ns/activitystreams#Public\"],\"cc\":[\"https://lemmy.world/c/memes\",\"https://piefed.social/u/socsa\"],\"content\":\"<p>The NSFW tag is part of the mechanism to curate the feed.</p>\\n<p>I’m not sure why people get offended by people wanting to use social media but not wanting to view content that can get them fired. If the content doesn’t bother you, then you shouldn’t filter NSFW content. It’s not like the NSFW tag is censoring the content and preventing you from seeing it if you click it.</p>\\n<p>For people with jobs, why not make it easier to filter the things that companies don’t like? It doesn’t affect you any.</p>\\n\",\"inReplyTo\":\"https://piefed.social/comment/2799685\",\"mediaType\":\"text/html\",\"source\":{\"content\":\"The NSFW tag is part of the mechanism to curate the feed. \\n\\nI'm not sure why people get offended by people wanting to use social media but not wanting to view content that can get them fired. If the content doesn't bother you, then you shouldn't filter NSFW content. It's not like the NSFW tag is censoring the content and preventing you from seeing it if you click it.\\n\\nFor people with jobs, why not make it easier to filter the things that companies don't like? It doesn't affect you any.\",\"mediaType\":\"text/markdown\"},\"published\":\"2024-09-12T05:15:44.456255Z\",\"updated\":\"2024-09-12T05:22:16.215331Z\",\"tag\":[{\"href\":\"https://piefed.social/u/socsa\",\"name\":\"@[email protected]\",\"type\":\"Mention\"}],\"distinguished\":false,\"audience\":\"https://lemmy.world/c/memes\"}","context":{"o":{"@context":["https://join-lemmy.org/context.json","https://www.w3.org/ns/activitystreams"],"type":"Note","id":"https://lemmy.world/comment/12312933","attributedTo":"https://lemmy.world/u/aaaa","to":["https://www.w3.org/ns/activitystreams#Public"],"cc":["https://lemmy.world/c/memes","https://piefed.social/u/socsa"],"content":"<p>The NSFW tag is part of the mechanism to curate the feed.</p>\n<p>I’m not sure why people get offended by people wanting to use social media but not wanting to view content that can get them fired. If the content doesn’t bother you, then you shouldn’t filter NSFW content. It’s not like the NSFW tag is censoring the content and preventing you from seeing it if you click it.</p>\n<p>For people with jobs, why not make it easier to filter the things that companies don’t like? It doesn’t affect you any.</p>\n","inReplyTo":"https://piefed.social/comment/2799685","mediaType":"text/html","source":{"content":"The NSFW tag is part of the mechanism to curate the feed. \n\nI'm not sure why people get offended by people wanting to use social media but not wanting to view content that can get them fired. If the content doesn't bother you, then you shouldn't filter NSFW content. It's not like the NSFW tag is censoring the content and preventing you from seeing it if you click it.\n\nFor people with jobs, why not make it easier to filter the things that companies don't like? It doesn't affect you any.","mediaType":"text/markdown"},"published":"2024-09-12T05:15:44.456255Z","updated":"2024-09-12T05:22:16.215331Z","tag":[{"href":"https://piefed.social/u/socsa","name":"@[email protected]","type":"Mention"}],"distinguished":false,"audience":"https://lemmy.world/c/memes"}},"level":400,"level_name":"ERROR","channel":"app","datetime":"2024-09-12T12:32:54.916901+02:00","extra":{}}

the eigth (BentiGorlich: same as the fourth)

{"message":"Warning: Trying to access array offset on null","context":{"exception":{"class":"ErrorException","message":"Warning: Trying to access array offset on null","code":0,"file":"/var/www/kbin.melroy.org/html/src/Service/ActivityPub/SignatureValidator.php:116"}},"level":400,"level_name":"ERROR","channel":"php","datetime":"2024-09-12T12:39:00.481703+02:00","extra":{}}

the nineth Fix 9th miscellaneous bug #1122

{"message":"Warning: Trying to access array offset on null","context":{"exception":{"class":"ErrorException","message":"Warning: Trying to access array offset on null","code":0,"file":"/var/www/kbin.melroy.org/html/src/Service/ActivityPubManager.php:290"}},"level":400,"level_name":"ERROR","channel":"php","datetime":"2024-09-12T12:33:45.029513+02:00","extra":{}}
{"message":"ApHttpClient:getActivityObject get fail: https://social.vivaldi.net/users/OutOfExileIDR/statuses/113105981784505849/activity, ex: App\\Exception\\InvalidApPostException: Invalid status code while getting: https://social.vivaldi.net/users/OutOfExileIDR/statuses/113105981784505849/activity : 404, {\"error\":\"Not Found\"} - {\"error\":\"Not Found\"}","context":{"type":"ApHttpClient:getActivityObject","address":"https://social.vivaldi.net/users/OutOfExileIDR/statuses/113105981784505849/activity","e":"App\\Exception\\InvalidApPostException","msg":"Invalid status code while getting: https://social.vivaldi.net/users/OutOfExileIDR/statuses/113105981784505849/activity : 404, {\"error\":\"Not Found\"}","content":"{\"error\":\"Not Found\"}"},"level":400,"level_name":"ERROR","channel":"app","datetime":"2024-09-12T12:33:50.288473+02:00","extra":{}}

the tenth - same as the 1st.

{"message":"Uncaught PHP Exception Twig\\Error\\RuntimeError: \"Error rendering \"entry_comment\" component: Expected argument of type \"App\\Entity\\EntryComment\", \"null\" given at property path \"comment\".\" at view.html.twig line 49","context":{"exception":{"class":"Twig\\Error\\RuntimeError","message":"Error rendering \"entry_comment\" component: Expected argument of type \"App\\Entity\\EntryComment\", \"null\" given at property path \"comment\".","code":0,"file":"/var/www/kbin.melroy.org/html/templates/entry/comment/view.html.twig:49","previous":{"class":"Symfony\\Component\\PropertyAccess\\Exception\\InvalidTypeException","message":"Expected argument of type \"App\\Entity\\EntryComment\", \"null\" given at property path \"comment\".","code":0,"file":"/var/www/kbin.melroy.org/html/vendor/symfony/property-access/PropertyAccessor.php:203","previous":{"class":"TypeError","message":"Cannot assign null to property App\\Twig\\Components\\EntryCommentComponent::$comment of type App\\Entity\\EntryComment","code":0,"file":"/var/www/kbin.melroy.org/html/vendor/symfony/property-access/PropertyAccessor.php:534"}}}},"level":500,"level_name":"CRITICAL","channel":"request","datetime":"2024-09-12T12:36:13.835930+02:00","extra":{}}

the eleventh - checking on empty/null image: Check on empty/null filePath image #1128

./bin/console mbin:cache:build

23:13:28 CRITICAL  [console] Error thrown while running command "mbin:cache:build". Message: "Liip\ImagineBundle\Command\ResolveCacheCommand::runCacheImageResolve(): Argument #1 ($image) must be of type string, null given, called in /var/www/kbin.melroy.org/html/vendor/liip/imagine-bundle/Command/ResolveCacheCommand.php on line 95" ["exception" => TypeError { …},"command" => "mbin:cache:build","message" => "Liip\ImagineBundle\Command\ResolveCacheCommand::runCacheImageResolve(): Argument #1 ($image) must be of type string, null given, called in /var/www/kbin.melroy.org/html/vendor/liip/imagine-bundle/Command/ResolveCacheCommand.php on line 95"]
{"message":"Uncaught Error: Liip\\ImagineBundle\\Command\\ResolveCacheCommand::runCacheImageResolve(): Argument #1 ($image) must be of type string, null given, called in /var/www/kbin.melroy.org/html/vendor/liip/imagine-bundle/Command/ResolveCacheCommand.php on line 95","context":{"exception":{"class":"TypeError","message":"Liip\\ImagineBundle\\Command\\ResolveCacheCommand::runCacheImageResolve(): Argument #1 ($image) must be of type string, null given, called in /var/www/kbin.melroy.org/html/vendor/liip/imagine-bundle/Command/ResolveCacheCommand.php on line 95","code":0,"file":"/var/www/kbin.melroy.org/html/vendor/liip/imagine-bundle/Command/ResolveCacheCommand.php:104"}},"level":500,"level_name":"CRITICAL","channel":"php","datetime":"2024-09-11T23:13:28.060044+02:00","extra":{}}

the 12th NotFoundHttpException App\Entity\Entry and App\Entity\Post object not found.. :

Full stack trace

[2024-09-12T20:35:38.330174+02:00] request.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: ""App\Entity\Entry" object not found by "Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver"." at EntityValueResolver.php line 76 {"exception":"[object] (Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException(code: 0): \"App\\Entity\\Entry\" object not found by \"Symfony\\Bridge\\Doctrine\\ArgumentResolver\\EntityValueResolver\". at /var/www/kbin.melroy.org/html/vendor/symfony/doctrine-bridge/ArgumentResolver/EntityValueResolver.php:76)
[stacktrace]
#0 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/Controller/ArgumentResolver/TraceableValueResolver.php(37): Symfony\\Bridge\\Doctrine\\ArgumentResolver\\EntityValueResolver->resolve()
#1 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/Controller/ArgumentResolver.php(90): Symfony\\Component\\HttpKernel\\Controller\\ArgumentResolver\\TraceableValueResolver->resolve()
#2 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/Controller/TraceableArgumentResolver.php(33): Symfony\\Component\\HttpKernel\\Controller\\ArgumentResolver->getArguments()
#3 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/HttpKernel.php(175): Symfony\\Component\\HttpKernel\\Controller\\TraceableArgumentResolver->getArguments()
#4 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw()
#5 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/Kernel.php(182): Symfony\\Component\\HttpKernel\\HttpKernel->handle()
#6 /var/www/kbin.melroy.org/html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\\Component\\HttpKernel\\Kernel->handle()
#7 /var/www/kbin.melroy.org/html/vendor/autoload_runtime.php(29): Symfony\\Component\\Runtime\\Runner\\Symfony\\HttpKernelRunner->run()
#8 /var/www/kbin.melroy.org/html/public/index.php(7): require_once('...')
#9 {main}
"} []
[2024-09-12T20:35:55.620106+02:00] request.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: ""App\Entity\Entry" object not found by "Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver"." at EntityValueResolver.php line 76 {"exception":"[object] (Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException(code: 0): \"App\\Entity\\Entry\" object not found by \"Symfony\\Bridge\\Doctrine\\ArgumentResolver\\EntityValueResolver\". at /var/www/kbin.melroy.org/html/vendor/symfony/doctrine-bridge/ArgumentResolver/EntityValueResolver.php:76)
[stacktrace]
#0 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/Controller/ArgumentResolver/TraceableValueResolver.php(37): Symfony\\Bridge\\Doctrine\\ArgumentResolver\\EntityValueResolver->resolve()
#1 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/Controller/ArgumentResolver.php(90): Symfony\\Component\\HttpKernel\\Controller\\ArgumentResolver\\TraceableValueResolver->resolve()
#2 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/Controller/TraceableArgumentResolver.php(33): Symfony\\Component\\HttpKernel\\Controller\\ArgumentResolver->getArguments()
#3 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/HttpKernel.php(175): Symfony\\Component\\HttpKernel\\Controller\\TraceableArgumentResolver->getArguments()
#4 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw()
#5 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/Kernel.php(182): Symfony\\Component\\HttpKernel\\HttpKernel->handle()
#6 /var/www/kbin.melroy.org/html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\\Component\\HttpKernel\\Kernel->handle()
#7 /var/www/kbin.melroy.org/html/vendor/autoload_runtime.php(29): Symfony\\Component\\Runtime\\Runner\\Symfony\\HttpKernelRunner->run()
#8 /var/www/kbin.melroy.org/html/public/index.php(7): require_once('...')
#9 {main}

And also seems to be related:

[2024-09-12T20:50:38.827422+02:00] request.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: ""App\Entity\Post" object not found by "Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver"." at EntityValueResolver.php line 76 {"exception":"[object] (Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException(code: 0): \"App\\Entity\\Post\" object not found by \"Symfony\\Bridge\\Doctrine\\ArgumentResolver\\EntityValueResolver\". at /var/www/kbin.melroy.org/html/vendor/symfony/doctrine-bridge/ArgumentResolver/EntityValueResolver.php:76)
[stacktrace]
#0 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/Controller/ArgumentResolver/TraceableValueResolver.php(37): Symfony\\Bridge\\Doctrine\\ArgumentResolver\\EntityValueResolver->resolve()
#1 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/Controller/ArgumentResolver.php(90): Symfony\\Component\\HttpKernel\\Controller\\ArgumentResolver\\TraceableValueResolver->resolve()
#2 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/Controller/TraceableArgumentResolver.php(33): Symfony\\Component\\HttpKernel\\Controller\\ArgumentResolver->getArguments()
#3 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/HttpKernel.php(175): Symfony\\Component\\HttpKernel\\Controller\\TraceableArgumentResolver->getArguments()
#4 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw()
#5 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/Kernel.php(182): Symfony\\Component\\HttpKernel\\HttpKernel->handle()
#6 /var/www/kbin.melroy.org/html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\\Component\\HttpKernel\\Kernel->handle()
#7 /var/www/kbin.melroy.org/html/vendor/autoload_runtime.php(29): Symfony\\Component\\Runtime\\Runner\\Symfony\\HttpKernelRunner->run()
#8 /var/www/kbin.melroy.org/html/public/index.php(7): require_once('...')
#9 {main}
"} []

the 13th - Invalid CSRF token (could be cause of vote errors etc. In fact @Jerry-infosecexchange also reported this issue). PR: Disable CSRF checks on some most-used forms #1136 and another PR: Store sessions in DB + improve cookies/sessions #1145

Most seen CSRF IDs causing issues are:

down_vote (previously called vote)
up_vote (previously called favourite)
boost
subscribe

Possible solution directions:

Removing Twig templating cache
Remove CSRF tokens from these forms (no big risk with vote or subscribe manipulation via CSRF attacks)
.. Any other ideas are welcome..?

Full stack trace

During my testing in DEV mode:

[2024-09-12T20:42:54.414611+02:00] request.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\BadRequestHttpException: "Invalid CSRF token" at AbstractController.php line 39 {"exception":"[object] (Symfony\\Component\\HttpKernel\\Exception\\BadRequestHttpException(code: 0): Invalid CSRF token at /var/www/kbin.melroy.org/html/src/Controller/AbstractController.php:39)
[stacktrace]
#0 /var/www/kbin.melroy.org/html/src/Controller/FavouriteController.php(24): App\\Controller\\AbstractController->validateCsrf()
#1 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/HttpKernel.php(183): App\\Controller\\FavouriteController->__invoke()
#2 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw()
#3 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/Kernel.php(182): Symfony\\Component\\HttpKernel\\HttpKernel->handle()
#4 /var/www/kbin.melroy.org/html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\\Component\\HttpKernel\\Kernel->handle()
#5 /var/www/kbin.melroy.org/html/vendor/autoload_runtime.php(29): Symfony\\Component\\Runtime\\Runner\\Symfony\\HttpKernelRunner->run()
#6 /var/www/kbin.melroy.org/html/public/index.php(7): require_once('...')
#7 {main}
"} []
[2024-09-12T20:42:54.657138+02:00] request.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\BadRequestHttpException: "Invalid CSRF token" at AbstractController.php line 39 {"exception":"[object] (Symfony\\Component\\HttpKernel\\Exception\\BadRequestHttpException(code: 0): Invalid CSRF token at /var/www/kbin.melroy.org/html/src/Controller/AbstractController.php:39)
[stacktrace]
#0 /var/www/kbin.melroy.org/html/src/Controller/FavouriteController.php(24): App\\Controller\\AbstractController->validateCsrf()
#1 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/HttpKernel.php(183): App\\Controller\\FavouriteController->__invoke()
#2 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw()
#3 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/Kernel.php(182): Symfony\\Component\\HttpKernel\\HttpKernel->handle()
#4 /var/www/kbin.melroy.org/html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\\Component\\HttpKernel\\Kernel->handle()
#5 /var/www/kbin.melroy.org/html/vendor/autoload_runtime.php(29): Symfony\\Component\\Runtime\\Runner\\Symfony\\HttpKernelRunner->run()
#6 /var/www/kbin.melroy.org/html/public/index.php(7): require_once('...')
#7 {main}
"} []

And from Jerry during PRD mode:

{"message":"Uncaught PHP Exception Symfony\\Component\\HttpKernel\\Exception\\BadRequestHttpException: \"Invalid CSRF token\" at AbstractController.php line 39","context":{"exception":{"class":"Symfony\\Component\\HttpKernel\\Exception\\BadRequestHttpException","message":"Invalid CSRF token","code":0,"file":"/var/www/mbin/src/Controller/AbstractController.php:39"}},"level":400,"level_name":"ERROR","channel":"request","datetime":"2024-09-12T18:54:45.620576+00:00","extra":{}}
{"message":"Uncaught PHP Exception Symfony\\Component\\HttpKernel\\Exception\\BadRequestHttpException: \"Invalid CSRF token\" at AbstractController.php line 39","context":{"exception":{"class":"Symfony\\Component\\HttpKernel\\Exception\\BadRequestHttpException","message":"Invalid CSRF token","code":0,"file":"/var/www/mbin/src/Controller/AbstractController.php:39"}},"level":400,"level_name":"ERROR","channel":"request","datetime":"2024-09-12T18:54:45.803347+00:00","extra":{}}

14th - NotFoundHttpException at EntryCommentRepository.php:

Full stack trace

[2024-09-12T20:46:45.049039+02:00] request.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "" at EntryCommentRepository.php line 70 {"exception":"[object] (Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException(code: 0):  at /var/www/kbin.melroy.org/html/src/Repository/EntryCommentRepository.php:70)
[stacktrace]
#0 /var/www/kbin.melroy.org/html/src/Controller/Entry/Comment/EntryCommentFrontController.php(34): App\\Repository\\EntryCommentRepository->findByCriteria()
#1 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/HttpKernel.php(183): App\\Controller\\Entry\\Comment\\EntryCommentFrontController->front()
#2 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\\Component\\HttpKernel\\HttpKernel->handleRaw()
#3 /var/www/kbin.melroy.org/html/vendor/symfony/http-kernel/Kernel.php(182): Symfony\\Component\\HttpKernel\\HttpKernel->handle()
#4 /var/www/kbin.melroy.org/html/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php(35): Symfony\\Component\\HttpKernel\\Kernel->handle()
#5 /var/www/kbin.melroy.org/html/vendor/autoload_runtime.php(29): Symfony\\Component\\Runtime\\Runner\\Symfony\\HttpKernelRunner->run()
#6 /var/www/kbin.melroy.org/html/public/index.php(7): require_once('...')
#7 {main}
"} []

15th - During getActivityObject error, is returning the whole HTML page by a 404 request. Basically polluting the logging a too much. Don't log full html pages (stop error log pollution) #1134

{"message":"ApHttpClient:getActivityObject get fail: https://fedia.io/m/[email protected]/t/1164332/-/comment/7154817, ex: App\\Exception\\InvalidApPostException: Invalid status code while getting: https://fedia.io/m/[email protected]/t/1164332/-/comment/7154817 : 404, <!DOCTYPE html>\n<html lang=\"en\"\n      style=\"font-size: 100%\">\n<head>\n 
.. whole HTML page...

{"type":"ApHttpClient:getActivityObject","address":"https://fedia.io/m/[email protected]/t/1164332/-/comment/7154817","e":"App\\Exception\\InvalidApPostException","msg":"Invalid status code while getting: https://fedia.io/m/[email protected]/t/1164332/-/comment/7154817 : 404, <!DOCTYPE html>\n<html lang=\"en\"\n      style=\"font-size: 100%\">\n<head>\n    <meta charset=\"UTF-8\">\n    <title>Error 404 - Fedia</title>\n\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n  .. the whole HTML Page...

16th - Also reduce the HTML content of this non-JSON content dump during DeliverMessage error (cause too much log pollution). PR: Reduce error pollution even more on post request failures #1140

{"message":"Error thrown while handling message App\\Message\\ActivityPub\\Outbox\\DeliverMessage. Removing from transport after 7 retries. Error: \"Handling \"App\\Message\\ActivityPub\\Outbox\\DeliverMessage\" failed: Post fail: https://lemmy.chitter.club/inbox, <!DOCTYPE html>\n<!--[if lt IE 7]> <html class=\"no-js ie6 oldie\" lang=\"en-US\"> <![endif]-->\n<!--[if IE 7]>    <html class=\"no-js ie7 oldie\" lang=\"en-US\"> <![endif]-->\n<!--[if IE 8]>    <html class=\"no-js ie8 oldie\" lang=\"en-US\"> <![endif]-->\n<!--[if gt IE 8]><!--> <html class=\"no-js\" lang=\"en-US\"> <!--<![endif]-->\n<head>\n<title>Attention Required! | Cloudflare</title>\n<meta charset=\"UTF-8\" />\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />\n<meta http-equiv=\"X-UA-Compatible\" content=\"IE=Edge\" />\n<meta name=\"robots\" content=\"noindex, nofollow\" />\n<meta name=\"viewport\" content=\"width=device-width,initial-scale=1\" />\n<link rel=\"stylesheet\" id=\"cf_styles-css\" href=\"/cdn-cgi/styles/cf.errors.css\" />\n<!--[if lt IE 9]><link rel=\"stylesheet\" id='cf_styles-ie-css' href=\"/cdn-cgi/styles/cf.errors.ie.css\" /><![endif]-->\n<style>body{margin:0;padding:0}</style>\n\n\n<!--[if gte IE 10]><!-->\n<script>\n  if (!navigator.cookieEnabled) {\n    window.addEventListener('DOMContentLoaded', f {\"@context\":\"https:\\/\\/www.w3.org\\/ns\\/activitystreams\",\"id\":\"https:\\/\\/kbin.melroy.org\\/f\\/object\\/010c3bd0-1b7a-4ddd-990a-c65ab7492034\",\"type\":\"Announce\",\"actor\":\"https:\\/\\/kbin.melroy.org\\/m\\/random\",\"object\":{\"@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:\\/\\/mastodon.social\\/users\\/nixCraft\\/statuses\\/113099788493600682#updates\\/1725948661\",\"type\":\"Update\",\"actor\":\"https:\\/\\/mastodon.social\\/users\\/nixCraft\",\"to\":[\"https:\\/\\/www.w3.org\\/ns\\/activitystreams#Public\"],\"object\":{\"id\":\"https:\\/\\/mastodon.social\\/users\\/nixCraft\\/statuses\\/113099788493600682\",\"type\":\"Question\",\"summary\":null,\"inReplyTo\":null,\"published\":\"2024-09-08T03:23:35Z\",\"url\":\"https:\\/\\/mastodon.social\\/@nixCraft\\/113099788493600682\",\"attributedTo\":\"https:\\/\\/mastodon.social\\/users\\/nixCraft\",\"to\":[\"https:\\/\\/www.w3.org\\/ns\\/activitystreams#Public\"],\"cc\":[\"https:\\/\\/mastodon.social\\/users\\/nixCraft\\/followers\"],\"sensitive\":false,\"atomUri\":\"https:\\/\\/mastodon.social\\/users\\/nixCraft\\/statuses\\/113099788493600682\",\"inReplyToAtomUri\":null,\"conversation\":\"tag:mastodon.social,2024-09-08:objectId=794215693:objectType=Conversation\",\"content\":\"<p>Poll \\ud83e\\udee3<\\/p>\",\"contentMap\":{\"en\":\"<p>Poll \\ud83e\\udee3<\\/p>\"},\"endTime\":\"2024-09-11T03:23:35Z\",\"votersCount\":715,\"attachment\":[],\"tag\":[],\"replies\":{\"id\":\"https:\\/\\/mastodon.social\\/users\\/nixCraft\\/statuses\\/1130 ..... Full HTML......."}

17th - User already deleted errors.. Why is this an error? We could just check if the user is present or not, before trying to delete a user which isn't present anyways.

{"message":"Error thrown while handling message App\\Message\\DeleteUserMessage. Removing from transport after 0 retries. Error: \"Handling \"App\\Message\\DeleteUserMessage\" failed: User already deleted\"","context":{"class":"App\\Message\\DeleteUserMessage","message_id":null,"retryCount":0,"error":"Handling \"App\\Message\\DeleteUserMessage\" failed: User already deleted","exception":{"class":"Symfony\\Component\\Messenger\\Exception\\HandlerFailedException","message":"Handling \"App\\Message\\DeleteUserMessage\" failed: User already deleted","code":0,"file":"/var/www/kbin.melroy.org/html/vendor/symfony/messenger/Middleware/HandleMessageMiddleware.php:124","previous":{"class":"Symfony\\Component\\Messenger\\Exception\\UnrecoverableMessageHandlingException","message":"User already deleted","code":0,"file":"/var/www/kbin.melroy.org/html/src/MessageHandler/DeleteUserHandler.php:53"}}},"level":500,"level_name":"CRITICAL","channel":"messenger","datetime":"2024-09-13T12:57:13.578196+02:00","extra":{}}

18th - (running now on the latest main) I still see getActivityObject failed on a domain name that I blocked (because kbin.social is down). I despite I this domain name is part of the federation block list, it still give me 503 errors:

{"message":"ApHttpClient:getActivityObject get fail: https://kbin.social/m/[email protected]/t/213768/-/comment/902712, ex: App\\Exception\\InvalidApPostException: Invalid status code while getting: https://kbin.social/m/[email protected]/t/213768/-/comment/902712 : 503, <html lang=\"en\" style=\"font-size: 100%\">\n<head>\n    <title>Error 50x - kbin.social</title>\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n    <meta name=\"keywords\"\n          content=\"kbin, link aggregator, mikroblog, socialmedia, wykop, reddit, twitter, open source, fediverse, makigi\">\n    <meta name=\"description\" content=\"Explore Fediverse\">\n    <meta property=\"og:url\" content=\"https://kbin.social/asdf\">\n    <meta property=\"og:type\" content=\"article\">\n    <meta property=\"og:title\" content=\"Error 404 - kbin.social\">\n    <meta property=\"og:description\" content=\"Explore Fediverse\">\n    <meta property=\"og:image\" content=\"https://kbin.social/kbin-og.png\">\n    <link rel=\"shortcut icon\" href=\"https://kbin.social/favicon.ico\">\n    <link rel=\"icon\" href=\"https://kbin.social/favicon.ico\" sizes=\"any\">\n    <link rel=\"icon\" href=\"https://kbin.social/favicon.svg\" type=\"image/svg+xml\">\n    <link rel=\"stylesheet\" href=\"https://kbin.pub/kbin.css\">\n<body class=\"theme--kbin fix - <html lang=\"en\" style=\"font-size: 100%\">\n<head>\n    <title>Error 50x - kbin.social</title>\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n    <meta name=\"keywords\"\n          content=\"kbin, link aggregator, mikroblog, socialmedia, wykop, reddit, twitter, open source, fediverse, makigi\">\n    <meta name=\"description\" content=\"Explore Fediverse\">\n    <meta property=\"og:url\" content=\"https://kbin.social/asdf\">\n    <meta property=\"og:type\" content=\"article\">\n    <meta property=\"og:title\" content=\"Error 404 - kbin.social\">\n    <meta property=\"og:description\" content=\"Explore Fediverse\">\n    <meta property=\"og:image\" content=\"https://kbin.social/kbin-og.png\">\n    <link rel=\"shortcut icon\" href=\"https://kbin.social/favicon.ico\">\n    <link rel=\"icon\" href=\"https://kbin.social/favicon.ico\" sizes=\"any\">\n    <link rel=\"icon\" href=\"https://kbin.social/favicon.svg\" type=\"image/svg+xml\">\n    <link rel=\"stylesheet\" href=\"https://kbin.pub/kbin.css\">\n<body class=\"theme--kbin fixed-navbar\" data-controller=\"kbin notifications\" cz-shortcut-listen=\"true\">\n<header id=\"header\" class=\"header\">\n    <div class=\"kbin-container\">\n        <div class=\"sr-nav\">\n            <a href=\"https://kbin.social#content\">Go to content</a>\n            <a href=\"https://kbin.social#options\">Go to filters</a>\n            <a href=\"https://kbin.social/search\">Go to search</a>\n            <a href=\"https://kbin.social#footer\">Go to footer</a>\n        </div>\n        <nav class=\"head-nav\" data-action=\"click->kbin#toggleNav\">\n            <div class=\"brand\">\n                <div><i class=\"fa-solid fa-bars\"></i></div>\n                <a href=\"https://kbin.social/\">\n                    <img id=\"logo\" src=\"https://kbin.social/kbin_logo.svg\" alt=\"kbin\">\n                </a>\n            </div>\n            <menu class=\"head-nav__menu\">\n                <li>\n                </li>\n                <li>\n                    <a href=\"https://kbin.social/\" class=\"active\">\n                        Threads </a>\n                </li>\n                <li>\n                    <a href=\"https

19th - The famous couldnt_find_person. Can we try to debug what this means? Solve the problem? Or handle the error better..?

{"message":"ApHttpClient:getActivityObject get fail: https://lemmy.ca/post/28871883, ex: App\\Exception\\InvalidApPostException: Invalid status code while getting: https://lemmy.ca/post/28871883 : 400, {\"error\":\"couldnt_find_person\"} - {\"error\":\"couldnt_find_person\"}","context":{"type":"ApHttpClient:getActivityObject","address":"https://lemmy.ca/post/28871883","e":"App\\Exception\\InvalidApPostException","msg":"Invalid status code while getting: https://lemmy.ca/post/28871883 : 400, {\"error\":\"couldnt_find_person\"}","content":"{\"error\":\"couldnt_find_person\"}"},"level":400,"level_name":"ERROR","channel":"app","datetime":"2024-09-14T13:05:02.098634+02:00","extra":{}}

20th - Invalid text representation invalid input syntax for type integer: \"{user_id}\":

{"message":"Uncaught PHP Exception Doctrine\\DBAL\\Exception\\DriverException: \"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"{user_id}\"\nCONTEXT:  unnamed portal parameter $1 = '...'\" at ExceptionConverter.php line 87","context":{"exception":{"class":"Doctrine\\DBAL\\Exception\\DriverException","message":"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"{user_id}\"\nCONTEXT:  unnamed portal parameter $1 = '...'","code":7,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87","previous":{"class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","message":"SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"{user_id}\"\nCONTEXT:  unnamed portal parameter $1 = '...'","code":7,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28","previous":{"class":"PDOException","message":"SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"{user_id}\"\nCONTEXT:  unnamed portal parameter $1 = '...'","code":22,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130"}}}},"level":500,"level_name":"CRITICAL","channel":"request","datetime":"2024-09-16T22:22:06.622198+02:00","extra":{}}

This error also can be seens if the email confirmation URL is wrong or wrongly interpreted by the client or whatever is wrong.. (using the verify/email/.. path):

{"message":"Uncaught PHP Exception Doctrine\\DBAL\\Exception\\DriverException: \"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"3D628316\"\nCONTEXT:  unnamed portal parameter $1 = '...'\" at ExceptionConverter.php line 87","context":{"exception":{"class":"Doctrine\\DBAL\\Exception\\DriverException","message":"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"3D628316\"\nCONTEXT:  unnamed portal parameter $1 = '...'","code":7,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87","previous":{"class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","message":"SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"3D628316\"\nCONTEXT:  unnamed portal parameter $1 = '...'","code":7,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28","previous":{"class":"PDOException","message":"SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"3D628316\"\nCONTEXT:  unnamed portal parameter $1 = '...'","code":22,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130"}}}},"level":500,"level_name":"CRITICAL","channel":"request","datetime":"2024-09-19T17:08:55.106238+02:00","extra":{}}

The logs are missing a request URL (path) for sure, otherwise it's very hard to debug the above messages, without any clue which kind of request we are talking about. But for sure it could trigger this error above by the confirmation email link.

21st - could not retrieve all the dependencies

{"message":"could not retrieve all the dependencies of https://lemmy.world/comment/12469030","context":{"o":"https://lemmy.world/comment/12469030"},"level":400,"level_name":"ERROR","channel":"app","datetime":"2024-09-20T17:20:25.864264+02:00","extra":{}}

22nd - Fetched remote object https://kbin.melroy.org/u/RmDebArk_5 which was deleted. Is this is error? Can we fix it in a better way? If not, why do we log it?

{"message":"ApHttpClient:post failed: https://sh.itjust.works/inbox, ex: App\\Exception\\InvalidApPostException: Post failed: https://sh.itjust.works/inbox, status code: 400, request body: {\"@context\":\"https:\\/\\/www.w3.org\\/ns\\/activitystreams\",\"id\":\"https:\\/\\/kbin.melroy.org\\/f\\/object\\/a89df69f-9296-4c6d-9f27-085ccfc90539\",\"type\":\"Delete\",\"actor\":\"https:\\/\\/kbin.melroy.org\\/u\\/RmDebArk_5\",\"object\":\"https:\\/\\/kbin.melroy.org\\/u\\/RmDebArk_5\",\"to\":[\"https:\\/\\/www.w3.org\\/ns\\/activitystreams#Public\"],\"cc\":[\"https:\\/\\/kbin.melroy.org\\/u\\/RmDebArk_5\\/followers\"],\"removeData\":true}. Truncated content: {\"error\":\"unknown\",\"message\":\"Fetched remote object https://kbin.melroy.org/u/RmDebArk_5 which was deleted\"}","context":{"type":"ApHttpClient:post","address":"https://sh.itjust.works/inbox","e":"App\\Exception\\InvalidApPostException","msg":"Post failed: https://sh.itjust.works/inbox, status code: 400, request body: {\"@context\":\"https:\\/\\/www.w3.org\\/ns\\/activitystreams\",\"id\":\"https:\\/\\/kbin.melroy.org\\/f\\/object\\/a89df69f-9296-4c6d-9f27-085ccfc90539\",\"type\":\"Delete\",\"actor\":\"https:\\/\\/kbin.melroy.org\\/u\\/RmDebArk_5\",\"object\":\"https:\\/\\/kbin.melroy.org\\/u\\/RmDebArk_5\",\"to\":[\"https:\\/\\/www.w3.org\\/ns\\/activitystreams#Public\"],\"cc\":[\"https:\\/\\/kbin.melroy.org\\/u\\/RmDebArk_5\\/followers\"],\"removeData\":true}","content":"{\"error\":\"unknown\",\"message\":\"Fetched remote object https://kbin.melroy.org/u/RmDebArk_5 which was deleted\"}"},"level":400,"level_name":"ERROR","channel":"app","datetime":"2024-09-20T17:18:18.702108+02:00","extra":{}}

{"message":"Error thrown while handling message App\\Message\\ActivityPub\\Outbox\\DeliverMessage. Sending for retry #3 using 4800000 ms delay. Error: \"Handling \"App\\Message\\ActivityPub\\Outbox\\DeliverMessage\" failed: Post failed: https://sh.itjust.works/inbox, status code: 400, request body: {\"@context\":\"https:\\/\\/www.w3.org\\/ns\\/activitystreams\",\"id\":\"https:\\/\\/kbin.melroy.org\\/f\\/object\\/a89df69f-9296-4c6d-9f27-085ccfc90539\",\"type\":\"Delete\",\"actor\":\"https:\\/\\/kbin.melroy.org\\/u\\/RmDebArk_5\",\"object\":\"https:\\/\\/kbin.melroy.org\\/u\\/RmDebArk_5\",\"to\":[\"https:\\/\\/www.w3.org\\/ns\\/activitystreams#Public\"],\"cc\":[\"https:\\/\\/kbin.melroy.org\\/u\\/RmDebArk_5\\/followers\"],\"removeData\":true}\"","context":{"class":"App\\Message\\ActivityPub\\Outbox\\DeliverMessage","message_id":null,"retryCount":3,"delay":4800000,"error":"Handling \"App\\Message\\ActivityPub\\Outbox\\DeliverMessage\" failed: Post failed: https://sh.itjust.works/inbox, status code: 400, request body: {\"@context\":\"https:\\/\\/www.w3.org\\/ns\\/activitystreams\",\"id\":\"https:\\/\\/kbin.melroy.org\\/f\\/object\\/a89df69f-9296-4c6d-9f27-085ccfc90539\",\"type\":\"Delete\",\"actor\":\"https:\\/\\/kbin.melroy.org\\/u\\/RmDebArk_5\",\"object\":\"https:\\/\\/kbin.melroy.org\\/u\\/RmDebArk_5\",\"to\":[\"https:\\/\\/www.w3.org\\/ns\\/activitystreams#Public\"],\"cc\":[\"https:\\/\\/kbin.melroy.org\\/u\\/RmDebArk_5\\/followers\"],\"removeData\":true}","exception":{"class":"Symfony\\Component\\Messenger\\Exception\\HandlerFailedException","message":"Handling \"App\\Message\\ActivityPub\\Outbox\\DeliverMessage\" failed: Post failed: https://sh.itjust.works/inbox, status code: 400, request body: {\"@context\":\"https:\\/\\/www.w3.org\\/ns\\/activitystreams\",\"id\":\"https:\\/\\/kbin.melroy.org\\/f\\/object\\/a89df69f-9296-4c6d-9f27-085ccfc90539\",\"type\":\"Delete\",\"actor\":\"https:\\/\\/kbin.melroy.org\\/u\\/RmDebArk_5\",\"object\":\"https:\\/\\/kbin.melroy.org\\/u\\/RmDebArk_5\",\"to\":[\"https:\\/\\/www.w3.org\\/ns\\/activitystreams#Public\"],\"cc\":[\"https:\\/\\/kbin.melroy.org\\/u\\/RmDebArk_5\\/followers\"],\"removeData\":true}","code":0,"file":"/var/www/kbin.melroy.org/html/vendor/symfony/messenger/Middleware/HandleMessageMiddleware.php:124","previous":{"class":"App\\Exception\\InvalidApPostException","message":"Post failed: https://sh.itjust.works/inbox, status code: 400, request body: {\"@context\":\"https:\\/\\/www.w3.org\\/ns\\/activitystreams\",\"id\":\"https:\\/\\/kbin.melroy.org\\/f\\/object\\/a89df69f-9296-4c6d-9f27-085ccfc90539\",\"type\":\"Delete\",\"actor\":\"https:\\/\\/kbin.melroy.org\\/u\\/RmDebArk_5\",\"object\":\"https:\\/\\/kbin.melroy.org\\/u\\/RmDebArk_5\",\"to\":[\"https:\\/\\/www.w3.org\\/ns\\/activitystreams#Public\"],\"cc\":[\"https:\\/\\/kbin.melroy.org\\/u\\/RmDebArk_5\\/followers\"],\"removeData\":true}","code":0,"file":"/var/www/kbin.melroy.org/html/src/Service/ActivityPub/ApHttpClient.php:410"}}},"level":300,"level_name":"WARNING","channel":"messenger","datetime":"2024-09-20T17:18:18.704266+02:00","extra":{}}

23rd - Language string in URL / Select query.... invalid input syntax for type integer: "el" (el is a language literal) - PR: Add stricter requirements to existing routes #1150

{"message":"Uncaught PHP Exception Doctrine\\DBAL\\Exception\\DriverException: \"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"el\"\nCONTEXT:  unnamed portal parameter $1 = '...'\" at ExceptionConverter.php line 87","context":{"exception":{"class":"Doctrine\\DBAL\\Exception\\DriverException","message":"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"el\"\nCONTEXT:  unnamed portal parameter $1 = '...'","code":7,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87","previous":{"class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","message":"SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"el\"\nCONTEXT:  unnamed portal parameter $1 = '...'","code":7,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28","previous":{"class":"PDOException","message":"SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"el\"\nCONTEXT:  unnamed portal parameter $1 = '...'","code":22,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130"}}}},"level":500,"level_name":"CRITICAL","channel":"request","datetime":"2024-09-29T13:05:17.247414+02:00","extra":{}}
{"message":"Uncaught PHP Exception Doctrine\\DBAL\\Exception\\DriverException: \"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"es\"\nCONTEXT:  unnamed portal parameter $1 = '...'\" at ExceptionConverter.php line 87","context":{"exception":{"class":"Doctrine\\DBAL\\Exception\\DriverException","message":"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"es\"\nCONTEXT:  unnamed portal parameter $1 = '...'","code":7,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87","previous":{"class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","message":"SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"es\"\nCONTEXT:  unnamed portal parameter $1 = '...'","code":7,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28","previous":{"class":"PDOException","message":"SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"es\"\nCONTEXT:  unnamed portal parameter $1 = '...'","code":22,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130"}}}},"level":500,"level_name":"CRITICAL","channel":"request","datetime":"2024-09-29T13:05:32.198035+02:00","extra":{}}
{"message":"Uncaught PHP Exception Doctrine\\DBAL\\Exception\\DriverException: \"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"pt_BR\"\nCONTEXT:  unnamed portal parameter $1 = '...'\" at ExceptionConverter.php line 87","context":{"exception":{"class":"Doctrine\\DBAL\\Exception\\DriverException","message":"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"pt_BR\"\nCONTEXT:  unnamed portal parameter $1 = '...'","code":7,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87","previous":{"class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","message":"SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"pt_BR\"\nCONTEXT:  unnamed portal parameter $1 = '...'","code":7,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28","previous":{"class":"PDOException","message":"SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"pt_BR\"\nCONTEXT:  unnamed portal parameter $1 = '...'","code":22,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130"}}}},"level":500,"level_name":"CRITICAL","channel":"request","datetime":"2024-09-29T13:24:05.185252+02:00","extra":{}}
{"message":"Uncaught PHP Exception Doctrine\\DBAL\\Exception\\DriverException: \"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"pt\"\nCONTEXT:  unnamed portal parameter $1 = '...'\" at ExceptionConverter.php line 87","context":{"exception":{"class":"Doctrine\\DBAL\\Exception\\DriverException","message":"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"pt\"\nCONTEXT:  unnamed portal parameter $1 = '...'","code":7,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87","previous":{"class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","message":"SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"pt\"\nCONTEXT:  unnamed portal parameter $1 = '...'","code":7,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28","previous":{"class":"PDOException","message":"SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"pt\"\nCONTEXT:  unnamed portal parameter $1 = '...'","code":22,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130"}}}},"level":500,"level_name":"CRITICAL","channel":"request","datetime":"2024-09-29T13:27:07.804965+02:00","extra":{}}
{"message":"Uncaught PHP Exception Doctrine\\DBAL\\Exception\\DriverException: \"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"el\"\nCONTEXT:  unnamed portal parameter $1 = '...'\" at ExceptionConverter.php line 87","context":{"exception":{"class":"Doctrine\\DBAL\\Exception\\DriverException","message":"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"el\"\nCONTEXT:  unnamed portal parameter $1 = '...'","code":7,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:87","previous":{"class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","message":"SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"el\"\nCONTEXT:  unnamed portal parameter $1 = '...'","code":7,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28","previous":{"class":"PDOException","message":"SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type integer: \"el\"\nCONTEXT:  unnamed portal parameter $1 = '...'","code":22,"file":"/var/www/kbin.melroy.org/html/vendor/doctrine/dbal/src/Driver/PDO/Statement.php:130"}}}},"level":500,"level_name":"CRITICAL","channel":"request","datetime":"2024-09-29T13:28:07.306013+02:00","extra":{}}

PostgreSQL log:

Press here for more postgresql log info

2024-09-30 22:31:28.256 CEST [89841] kbin@kbin ERROR:  invalid input syntax for type integer: "uk"
2024-09-30 22:31:28.256 CEST [89841] kbin@kbin CONTEXT:  unnamed portal parameter $1 = '...'
2024-09-30 22:31:28.256 CEST [89841] kbin@kbin STATEMENT:  SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.mentions AS mentions_7, t0.id AS id_8, t0.body_ts AS body_ts_9, t0.up_votes AS up_votes_10, t0.down_votes AS down_votes_11, t0.ap_like_count AS ap_like_count_12, t0.ap_dislike_count AS ap_dislike_count_13, t0.ap_share_count AS ap_share_count_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.entry_id AS entry_id_20, t0.magazine_id AS magazine_id_21, t0.image_id AS image_id_22, t0.parent_id AS parent_id_23, t0.root_id AS root_id_24 FROM entry_comment t0 WHERE t0.id = $1
2024-09-30 22:31:33.315 CEST [89998] kbin@kbin ERROR:  invalid input syntax for type integer: "zh_TW"
2024-09-30 22:31:33.315 CEST [89998] kbin@kbin CONTEXT:  unnamed portal parameter $1 = '...'
2024-09-30 22:31:33.315 CEST [89998] kbin@kbin STATEMENT:  SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.mentions AS mentions_7, t0.id AS id_8, t0.body_ts AS body_ts_9, t0.up_votes AS up_votes_10, t0.down_votes AS down_votes_11, t0.ap_like_count AS ap_like_count_12, t0.ap_dislike_count AS ap_dislike_count_13, t0.ap_share_count AS ap_share_count_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.entry_id AS entry_id_20, t0.magazine_id AS magazine_id_21, t0.image_id AS image_id_22, t0.parent_id AS parent_id_23, t0.root_id AS root_id_24 FROM entry_comment t0 WHERE t0.id = $1
2024-09-30 22:31:46.275 CEST [90266] kbin@kbin ERROR:  invalid input syntax for type integer: "uk"
2024-09-30 22:31:46.275 CEST [90266] kbin@kbin CONTEXT:  unnamed portal parameter $1 = '...'
2024-09-30 22:31:46.275 CEST [90266] kbin@kbin STATEMENT:  SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.mentions AS mentions_7, t0.id AS id_8, t0.body_ts AS body_ts_9, t0.up_votes AS up_votes_10, t0.down_votes AS down_votes_11, t0.ap_like_count AS ap_like_count_12, t0.ap_dislike_count AS ap_dislike_count_13, t0.ap_share_count AS ap_share_count_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.entry_id AS entry_id_20, t0.magazine_id AS magazine_id_21, t0.image_id AS image_id_22, t0.parent_id AS parent_id_23, t0.root_id AS root_id_24 FROM entry_comment t0 WHERE t0.id = $1

2024-09-30 22:31:48.404 CEST [90311] kbin@kbin ERROR:  invalid input syntax for type integer: "nl"
2024-09-30 22:31:48.404 CEST [90311] kbin@kbin CONTEXT:  unnamed portal parameter $1 = '...'
2024-09-30 22:31:48.404 CEST [90311] kbin@kbin STATEMENT:  SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.mentions AS mentions_7, t0.id AS id_8, t0.body_ts AS body_ts_9, t0.up_votes AS up_votes_10, t0.down_votes AS down_votes_11, t0.ap_like_count AS ap_like_count_12, t0.ap_dislike_count AS ap_dislike_count_13, t0.ap_share_count AS ap_share_count_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.entry_id AS entry_id_20, t0.magazine_id AS magazine_id_21, t0.image_id AS image_id_22, t0.parent_id AS parent_id_23, t0.root_id AS root_id_24 FROM entry_comment t0 WHERE t0.id = $1


2024-09-30 22:32:00.897 CEST [90868] kbin@kbin ERROR:  duplicate key value violates unique constraint "uniq_b892fdfb904f155e"
2024-09-30 22:32:00.897 CEST [90868] kbin@kbin DETAIL:  Key (ap_id)=(https://beehaw.org/comment/3964470) already exists.
2024-09-30 22:32:00.897 CEST [90868] kbin@kbin STATEMENT:  INSERT INTO entry_comment (body, lang, is_adult, favourite_count, last_active, ip, mentions, id, up_votes, down_votes, ap_like_count, ap_dislike_count, ap_share_count, visibility, ap_id, edited_at, created_at, user_id, entry_id, magazine_id, image_id, parent_id, root_id) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23)


2024-09-30 22:32:04.114 CEST [90979] root@root FATAL:  role "root" does not exist
2024-09-30 22:32:12.169 CEST [91158] kbin@kbin ERROR:  invalid input syntax for type integer: "da"
2024-09-30 22:32:12.169 CEST [91158] kbin@kbin CONTEXT:  unnamed portal parameter $1 = '...'
2024-09-30 22:32:12.169 CEST [91158] kbin@kbin STATEMENT:  SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.mentions AS mentions_7, t0.id AS id_8, t0.body_ts AS body_ts_9, t0.up_votes AS up_votes_10, t0.down_votes AS down_votes_11, t0.ap_like_count AS ap_like_count_12, t0.ap_dislike_count AS ap_dislike_count_13, t0.ap_share_count AS ap_share_count_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.entry_id AS entry_id_20, t0.magazine_id AS magazine_id_21, t0.image_id AS image_id_22, t0.parent_id AS parent_id_23, t0.root_id AS root_id_24 FROM entry_comment t0 WHERE t0.id = $1

2024-09-30 22:32:33.857 CEST [92018] kbin@kbin ERROR:  invalid input syntax for type integer: "es"
2024-09-30 22:32:33.857 CEST [92018] kbin@kbin CONTEXT:  unnamed portal parameter $1 = '...'
2024-09-30 22:32:33.857 CEST [92018] kbin@kbin STATEMENT:  SELECT t0.body AS body_1, t0.lang AS lang_2, t0.is_adult AS is_adult_3, t0.favourite_count AS favourite_count_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.mentions AS mentions_7, t0.id AS id_8, t0.body_ts AS body_ts_9, t0.up_votes AS up_votes_10, t0.down_votes AS down_votes_11, t0.ap_like_count AS ap_like_count_12, t0.ap_dislike_count AS ap_dislike_count_13, t0.ap_share_count AS ap_share_count_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.entry_id AS entry_id_20, t0.magazine_id AS magazine_id_21, t0.image_id AS image_id_22, t0.parent_id AS parent_id_23, t0.root_id AS root_id_24 FROM entry_comment t0 WHERE t0.id = $1

24th - Still seeing duplicate key value violates unique constraint issues:

2024-09-30 22:32:16.426 CEST [91229] kbin@kbin ERROR:  duplicate key value violates unique constraint "favourite_user_entry_unique_idx"
2024-09-30 22:32:16.426 CEST [91229] kbin@kbin DETAIL:  Key (entry_id, user_id)=(485746, 14727) already exists.
2024-09-30 22:32:16.426 CEST [91229] kbin@kbin STATEMENT:  INSERT INTO favourite (id, created_at, magazine_id, user_id, entry_id, favourite_type) VALUES ($1, $2, $3, $4, $5, $6)
2024-09-30 22:32:16.428 CEST [91230] kbin@kbin ERROR:  duplicate key value violates unique constraint "favourite_user_entry_unique_idx"
2024-09-30 22:32:16.428 CEST [91230] kbin@kbin DETAIL:  Key (entry_id, user_id)=(485746, 14727) already exists.
2024-09-30 22:32:16.428 CEST [91230] kbin@kbin STATEMENT:  INSERT INTO favourite (id, created_at, magazine_id, user_id, entry_id, favourite_type) VALUES ($1, $2, $3, $4, $5, $6)
2024-09-30 22:31:55.768 CEST [90763] kbin@kbin ERROR:  duplicate key value violates unique constraint "uniq_a99ce55f904f155e"
2024-09-30 22:31:55.768 CEST [90763] kbin@kbin DETAIL:  Key (ap_id)=(https://pol.social/users/aemstuz/statuses/113227586068832264) already exists.
2024-09-30 22:31:55.768 CEST [90763] kbin@kbin STATEMENT:  INSERT INTO post_comment (body, lang, favourite_count, last_active, ip, mentions, is_adult, update_mark, id, up_votes, down_votes, ap_like_count, ap_dislike_count, ap_share_count, visibility, ap_id, edited_at, created_at, user_id, post_id, magazine_id, parent_id, root_id, image_id) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24)

See also: #1072 (which I will not mention here)

The text was updated successfully, but these errors were encountered:

BentiGorlich · 2024-09-12T18:05:27Z

the first: I can't reproduce it
the fifth: could be a follow up of the second, but I am not sure
the eigth: same as the fourth
the eleventh: not my area 😅

melroy89 · 2024-09-16T20:27:59Z

Regarding 18th: We might need to add more blocked domain checks (isBannedInstance) where there are getActivityObject calls. In the following files:

src/MessageHandler/ActivityPub/Inbox/ActivityHandler.php
src/MessageHandler/ActivityPub/Inbox/AddHandler.php
src/Service/ActivityPubManager.php

melroy89 added the bug Something isn't working label Sep 12, 2024

melroy89 added this to the v1.7.2 milestone Sep 12, 2024

This comment was marked as outdated.

Sign in to view

melroy89 mentioned this issue Sep 13, 2024

Check on empty/null filePath image #1128

Merged

This comment was marked as outdated.

Sign in to view

This comment was marked as off-topic.

Sign in to view

This was referenced Sep 27, 2024

Store sessions in DB + improve cookies/sessions #1145

Merged

Add stricter requirements to existing routes #1150

Merged

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Miscellaneous error/warning log items #1119

Miscellaneous error/warning log items #1119

melroy89 commented Sep 12, 2024 •

edited

Loading

BentiGorlich commented Sep 12, 2024

This comment was marked as outdated.

This comment was marked as outdated.

This comment was marked as outdated.

This comment was marked as outdated.

This comment was marked as outdated.

This comment was marked as off-topic.

melroy89 commented Sep 16, 2024

Miscellaneous error/warning log items #1119

Miscellaneous error/warning log items #1119

Comments

melroy89 commented Sep 12, 2024 • edited Loading

BentiGorlich commented Sep 12, 2024

This comment was marked as outdated.

This comment was marked as outdated.

This comment was marked as outdated.

This comment was marked as outdated.

This comment was marked as outdated.

This comment was marked as off-topic.

melroy89 commented Sep 16, 2024

melroy89 commented Sep 12, 2024 •

edited

Loading