Miscellaneous error/warning log items

Open melroy89 opened this issue 1 year ago • 8 comments

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:

[x] the first - missing null check, see PR: https://github.com/MbinOrg/mbin/pull/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":{}}

[x] the second #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":{}}

[x] the third #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":{}}

[x] the fourth #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":{}}

[x] the sixth: I also blocked kbin.social. Why is this still happening? #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":{}}

[x] the seventh: also maybe do not return the whole HTML page.. >< #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":{}}

[x] 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":{}}

[x] the nineth #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":{}}

[x] 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":{}}

[x] the eleventh - checking on empty/null image: https://github.com/MbinOrg/mbin/pull/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}
"} []

[x] the 13th - Invalid CSRF token (could be cause of vote errors etc. In fact @Jerry-infosecexchange also reported this issue). PR: https://github.com/MbinOrg/mbin/pull/1136 and another PR: https://github.com/MbinOrg/mbin/pull/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}
"} []

[x] 15th - During getActivityObject error, is returning the whole HTML page by a 404 request. Basically polluting the logging a too much. https://github.com/MbinOrg/mbin/pull/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...

[x] 16th - Also reduce the HTML content of this non-JSON content dump during DeliverMessage error (cause too much log pollution). PR: https://github.com/MbinOrg/mbin/pull/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":{}}

[x] 23rd - Language string in URL / Select query.... invalid input syntax for type integer: "el" (el is a language literal) - PR: https://github.com/MbinOrg/mbin/pull/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)

Sep 12 '24 16:09 melroy89

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 :sweat_smile:

Sep 12 '24 18:09 BentiGorlich

the eleventh (mbin:cache:build) did work in the past, right? It's executing the following script: src/Command/ImageCacheCommand.php actually. I really think we forget to update some of those SQL queries in buildEntriesCache, buildEntryCommentsCache, buildPostsCache or something..

I still think we store empty filePaths in the DB.. But this check would prevent errors now: https://github.com/MbinOrg/mbin/pull/1128

Sep 12 '24 18:09 melroy89

the first: I can't reproduce it

Let me try to investigate that one..

Sep 12 '24 18:09 melroy89

ow F*K GitHub replaced the old content.

Sep 12 '24 18:09 melroy89

the first: I can't reproduce it

Let me try to investigate that one..

It seems not fully reproducible always...

However I believe this line 50 is still the issue: https://github.com/MbinOrg/mbin/blob/main/templates/entry/comment/view.html.twig#L50. And I think that this is still (in some very rare cases) resulting into null as input:

comment.root ?? comment

Sep 12 '24 20:09 melroy89

However I believe this line 50 is still the issue: https://github.com/MbinOrg/mbin/blob/main/templates/entry/comment/view.html.twig#L50. And I think that this is still (in some very rare cases) resulting into null as input:
comment.root ?? comment 

I also noticed this TODO: https://github.com/MbinOrg/mbin/blob/4d930f6c8cf276bb2ec14ed5e579f4400af4222c/src/Controller/Entry/Comment/EntryCommentViewController.php#L40

This EntryCommentViewController.php is calling the entry/comment/view.html.twig with an null comment object.

Also the comment object seems to be an optional parameter: https://github.com/MbinOrg/mbin/blob/4d930f6c8cf276bb2ec14ed5e579f4400af4222c/src/Controller/Entry/Comment/EntryCommentViewController.php#L35

PR created: https://github.com/MbinOrg/mbin/pull/1129

Sep 13 '24 12:09 melroy89

the first: I can't reproduce it

Try to go to a comment from a thread. And click on the date of the comment, so you watch the comment('s thread). Then in the URL remove the comment ID. Which simulate the error 100% for sure.

Sep 13 '24 13:09 melroy89

All issues mentioned above in the description are now fixed in 1.7.2.

Follow-up issue creating with the remaining issues for v1.7.3: https://github.com/MbinOrg/mbin/issues/1175

Oct 08 '24 10:10 melroy89