search

idno / known

A social publishing platform.
https://withknown.com/opensource
Other
1.06k stars 196 forks source link

Status never get posted - DEBUG - Setting resilient slug #1089

Closed pierreozoux closed 8 years ago

pierreozoux commented 9 years ago

It actually got posted to twitter, but it disappeared from my blog. https://twitter.com/pierreozoux/status/658373553868423168

Here is the status:

Odoo Upgrade... Odoo hell!

https://www.odoo.com/forum/help-1/question/upgrade-from-odoo-8-to-odoo-9-community-version-92251
https://www.odoo.com/forum/help-1/question/upgrades-to-future-versions-in-community-edition-92270
https://doc.therp.nl/openupgrade/migrate.py.html

So basically, I should never have choosed this piece of software? Developpers are so bad that they lock you in an outdated version if you don't pay? They call it open source? I think I'm nightmaring... I'll wake up soon.

It actually might be easier to migrate everything by hand...

Here are the logs from the server:

Oct 25 20:19:28 k4 docker-compose[31105]: web_1 | 2015/10/25 20:19:17 [error] 5#5: *1054 FastCGI sent in stderr: "PHP message: Known (microblog.pierre-o.fr): DEBUG - Setting resilient slug
Oct 25 20:19:28 k4 docker-compose[31105]: web_1 | PHP message: Known (microblog.pierre-o.fr): DEBUG - Set resilient slug
Oct 25 20:19:28 k4 docker-compose[31105]: web_1 | PHP message: Known (microblog.pierre-o.fr): INFO - SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'uuid' at row 1
Oct 25 20:19:28 k4 docker-compose[31105]: web_1 | PHP message: Known (microblog.pierre-o.fr): DEBUG - Setting resilient slug
Oct 25 20:19:28 k4 docker-compose[31105]: web_1 | PHP message: Known (microblog.pierre-o.fr): DEBUG - Set resilient slug" while reading response header from upstream, client: 172.17.0.75, server: , request: "POST /status/edit HTTP/1.1", upstream: "fastcgi://172.17.3.236:9000", host: "microblog.pierre-o.fr", referrer: "https://microblog.pierre-o.fr/content/all/"
Oct 25 20:19:28 k4 docker-compose[31105]: web_1 | 172.17.0.75 - - [25/Oct/2015:20:19:17 +0000] "POST /status/edit HTTP/1.1" 302 5 "https://microblog.pierre-o.fr/content/all/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.118 Safari/537.36"
Oct 25 20:19:28 k4 docker-compose[31105]: app_1 | 172.17.3.237 -  25/Oct/2015:20:19:17 +0000 "GET /index.php" 200
Oct 25 20:19:28 k4 docker-compose[31105]: web_1 | 172.17.0.75 - - [25/Oct/2015:20:19:18 +0000] "GET /content/all/ HTTP/1.1" 200 10331 "https://microblog.pierre-o.fr/content/all/" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2272.118 Safari/537.36"
Oct 25 20:19:28 k4 docker-compose[31105]: app_1 | 172.17.3.237 -  25/Oct/2015:20:19:18 +0000 "GET /index.php" 200
Oct 25 20:19:28 k4 docker-compose[31105]: web_1 | 172.17.0.75 - - [25/Oct/2015:20:19:18 +0000] "GET /content/all HTTP/1.1" 200 7857 "-" "Bridgy (https://brid.gy/about) AppEngine-Google; (+http://code.google.com/appengine; appid: s~brid-gy)"
Oct 25 20:19:28 k4 docker-compose[31105]: app_1 | 172.17.3.237 -  25/Oct/2015:20:19:19 +0000 "GET /index.php" 200
Oct 25 20:19:28 k4 docker-compose[31105]: web_1 | 172.17.0.75 - - [25/Oct/2015:20:19:20 +0000] "GET /profile/pierre-o HTTP/1.1" 200 8518 "-" "Bridgy (https://brid.gy/about) AppEngine-Google; (+http://code.google.com/appengine; appid: s~brid-gy)"
Oct 25 20:19:28 k4 docker-compose[31105]: app_1 | 172.17.3.237 -  25/Oct/2015:20:19:21 +0000 "GET /index.php" 200
Oct 25 20:19:28 k4 docker-compose[31105]: web_1 | 172.17.0.75 - - [25/Oct/2015:20:19:22 +0000] "GET /content/all HTTP/1.1" 200 7857 "-" "Bridgy (https://brid.gy/about) AppEngine-Google; (+http://code.google.com/appengine; appid: s~brid-gy)"
Oct 25 20:19:28 k4 docker-compose[31105]: app_1 | 172.17.3.237 -  25/Oct/2015:20:19:24 +0000 "GET /index.php" 200
Oct 25 20:19:28 k4 docker-compose[31105]: web_1 | 172.17.0.75 - - [25/Oct/2015:20:19:26 +0000] "GET /2015/odoo-upgrade-odoo-hellforumhelp-1questionupgrade-from-odoo-8-to-odoo-9-community-version-92251forumhelp-1questionupgrades-to-future-versions-in-community-edition-92270openupgrademigratepyhtmlso-basically-i-should-never-have-choosed HTTP/1.1" 200 5058 "-" "Bridgy (https://brid.gy/about) AppEngine-Google; (+http://code.google.com/appengine; appid: s~brid-gy)"
Oct 25 20:19:28 k4 docker-compose[31105]: app_1 | 172.17.3.237 -  25/Oct/2015:20:19:24 +0000 "GET /index.php" 200
Oct 25 20:19:28 k4 docker-compose[31105]: web_1 | 172.17.0.75 - - [25/Oct/2015:20:19:26 +0000] "GET / HTTP/1.1" 200 7839 "-" "Bridgy (https://brid.gy/about) AppEngine-Google; (+http://code.google.com/appengine; appid: s~brid-gy)"
Oct 25 20:19:28 k4 docker-compose[31105]: app_1 | 172.17.3.237 -  25/Oct/2015:20:19:28 +0000 "GET /index.php" 200
Oct 25 20:19:28 k4 docker-compose[31105]: web_1 | 172.17.0.75 - - [25/Oct/2015:20:19:28 +0000] "GET /content/all HTTP/1.1" 200 7857 "-" "Bridgy (https://brid.gy/about) AppEngine-Google; (+http://code.google.com/appengine; appid: s~brid-gy)"
Oct 25 20:19:28 k4 docker-compose[31105]: app_1 | [25-Oct-2015 20:19:28] WARNING: [pool www] child 34 said into stderr: "NOTICE: PHP message: Known (microblog.pierre-o.fr): DEBUG - Had slug: odoo-upgrade-odoo-hellforumhelp-1questionupgrade-from-odoo-8-to-odoo-9-community-version-92251forumhelp-1questionupgrades-to-future-versions-in-community-edition-92270openupgrademigratepyhtmlso-basically-i-should-never-have-choosed"
Oct 25 20:19:28 k4 docker-compose[31105]: app_1 | [25-Oct-2015 20:19:28] WARNING: [pool www] child 34 said into stderr: "NOTICE: PHP message: Known (microblog.pierre-o.fr): DEBUG - Had slug: odoo-upgrade-odoo-hellforumhelp-1questionupgrade-from-odoo-8-to-odoo-9-community-version-92251forumhelp-1questionupgrades-to-future-versions-in-community-edition-92270openupgrademigratepyhtmlso-basically-i-should-never-have-choosed"
Oct 25 20:19:28 k4 docker-compose[31105]: app_1 | 172.17.3.237 -  25/Oct/2015:20:19:26 +0000 "POST /index.php" 202
Oct 25 20:19:37 k4 docker-compose[31105]: web_1 | 2015/10/25 20:19:28 [error] 5#5: *1074 FastCGI sent in stderr: "PHP message: Known (microblog.pierre-o.fr): DEBUG - Had slug: odoo-upgrade-odoo-hellforumhelp-1questionupgrade-from-odoo-8-to-odoo-9-community-version-92251forumhelp-1questionupgrades-to-future-versions-in-community-edition-92270openupgrademigratepyhtmlso-basically-i-should-never-have-choosed
Oct 25 20:19:37 k4 docker-compose[31105]: web_1 | PHP message: Known (microblog.pierre-o.fr): DEBUG - Had slug: odoo-upgrade-odoo-hellforumhelp-1questionupgrade-from-odoo-8-to-odoo-9-community-version-92251forumhelp-1questionupgrades-to-future-versions-in-community-edition-92270openupgrademigratepyhtmlso-basically-i-should-never-have-choosed" while reading response header from upstream, client: 172.17.0.75, server: , request: "POST /webmention/ HTTP/1.1", upstream: "fastcgi://172.17.3.236:9000", host: "microblog.pierre-o.fr"
Oct 25 20:19:37 k4 docker-compose[31105]: web_1 | 172.17.0.75 - - [25/Oct/2015:20:19:28 +0000] "POST /webmention/ HTTP/1.1" 202 5 "-" "Bridgy (https://brid.gy/about) AppEngine-Google; (+http://code.google.com/appengine; appid: s~brid-gy)"
Oct 25 20:19:37 k4 docker-compose[31105]: app_1 | 172.17.3.237 -  25/Oct/2015:20:19:30 +0000 "HEAD /index.php" 200
Oct 25 20:19:37 k4 docker-compose[31105]: web_1 | 172.17.0.75 - - [25/Oct/2015:20:19:30 +0000] "HEAD /2015/this-v10docsuser-guidevolumeshtmltypes-of-volumes-supports-git-and-ceph-by-default-thats-why HTTP/1.1" 200 0 "-" "Bridgy (https://brid.gy/about) AppEngine-Google; (+http://code.google.com/appengine; appid: s~brid-gy)"
Oct 25 20:19:37 k4 docker-compose[31105]: app_1 | 172.17.3.237 -  25/Oct/2015:20:19:30 +0000 "GET /index.php" 200
Oct 25 20:19:37 k4 docker-compose[31105]: web_1 | 172.17.0.75 - - [25/Oct/2015:20:19:31 +0000] "GET /2015/this-v10docsuser-guidevolumeshtmltypes-of-volumes-supports-git-and-ceph-by-default-thats-why HTTP/1.1" 200 6715 "-" "Bridgy (https://brid.gy/about) AppEngine-Google; (+http://code.google.com/appengine; appid: s~brid-gy)"
Oct 25 20:19:37 k4 docker-compose[31105]: app_1 | 172.17.3.237 -  25/Oct/2015:20:19:32 +0000 "HEAD /index.php" 200
Oct 25 20:19:37 k4 docker-compose[31105]: web_1 | 172.17.0.75 - - [25/Oct/2015:20:19:32 +0000] "HEAD /2015/good-vibe-for-sunday-evening-watchv5iip5t6hob4-get-stoopid-directed-by HTTP/1.1" 200 0 "-" "Bridgy (https://brid.gy/about) AppEngine-Google; (+http://code.google.com/appengine; appid: s~brid-gy)"
Oct 25 20:19:37 k4 docker-compose[31105]: app_1 | 172.17.3.237 -  25/Oct/2015:20:19:32 +0000 "GET /index.php" 200
Oct 25 20:19:37 k4 docker-compose[31105]: web_1 | 172.17.0.75 - - [25/Oct/2015:20:19:33 +0000] "GET /2015/good-vibe-for-sunday-evening-watchv5iip5t6hob4-get-stoopid-directed-by HTTP/1.1" 200 6684 "-" "Bridgy (https://brid.gy/about) AppEngine-Google; (+http://code.google.com/appengine; appid: s~brid-gy)"
Oct 25 20:19:37 k4 docker-compose[31105]: web_1 | 172.17.0.75 - - [25/Oct/2015:20:19:34 +0000] "GET /2015/resharing-on-facebook- HTTP/1.1" 200 6332 "-" "Bridgy (https://brid.gy/about) AppEngine-Google; (+http://code.google.com/appengine; appid: s~brid-gy)"
Oct 25 20:19:37 k4 docker-compose[31105]: app_1 | 172.17.3.237 -  25/Oct/2015:20:19:34 +0000 "GET /index.php" 200
Oct 25 20:19:37 k4 docker-compose[31105]: app_1 | 172.17.3.237 -  25/Oct/2015:20:19:35 +0000 "GET /index.php" 200
Oct 25 20:19:37 k4 docker-compose[31105]: web_1 | 172.17.0.75 - - [25/Oct/2015:20:19:35 +0000] "GET /2015/unimos-in-lisbon-the-10th-of-niovember---unimos-- HTTP/1.1" 200 6423 "-" "Bridgy (https://brid.gy/about) AppEngine-Google; (+http://code.google.com/appengine; appid: s~brid-gy)"
Oct 25 20:19:37 k4 docker-compose[31105]: app_1 | [25-Oct-2015 20:19:35] WARNING: [pool www] child 34 said into stderr: "NOTICE: PHP message: Known (microblog.pierre-o.fr): DEBUG - Had slug: odoo-upgrade-odoo-hellforumhelp-1questionupgrade-from-odoo-8-to-odoo-9-community-version-92251forumhelp-1questionupgrades-to-future-versions-in-community-edition-92270openupgrademigratepyhtmlso-basically-i-should-never-have-choosed"
Oct 25 20:19:37 k4 docker-compose[31105]: app_1 | [25-Oct-2015 20:19:37] WARNING: [pool www] child 34 said into stderr: "NOTICE: PHP message: Known (microblog.pierre-o.fr): DEBUG - Had slug: odoo-upgrade-odoo-hellforumhelp-1questionupgrade-from-odoo-8-to-odoo-9-community-version-92251forumhelp-1questionupgrades-to-future-versions-in-community-edition-92270openupgrademigratepyhtmlso-basically-i-should-never-have-choosed"
Oct 25 20:19:37 k4 docker-compose[31105]: app_1 | 172.17.3.237 -  25/Oct/2015:20:19:36 +0000 "GET /index.php" 200

Do you need anything more to investigate?

kylewm commented 9 years ago

Posting that content has the same effect on my installation! The post is there in that the permalink returns 200 and has the content in the <title>, but otherwise it's missing.

mapkyca commented 9 years ago

My guess is that there's something there that's being stripped by the html sanitiser.

Try commenting out that hook on output and see if the content returns...

pierreozoux commented 9 years ago

@mapkyca what do you mean? Sorry, I don't understand.

mapkyca commented 9 years ago

Template.php:233...

pierreozoux commented 9 years ago

I commented, tried to repost, same behaviour. Do you want the logs? I mean for me this is not really crtiic, but I'm sure if I hit the issue, it will bite someone else.

kylewm commented 9 years ago

I suspect this has to do with the very long slug overrunning the column width. The uuid is 255 characters maximum, but with a non-trivial domain name, the URL ends up being longer, e.g.

http://known.kylewm.com/2015/odoo-upgrade-odoo-hellforumhelp-1questionupgrade-from-odoo-8-to-odoo-9-community-version-92251forumhelp-1questionupgrades-to-future-versions-in-community-edition-92270openupgrademigratepyhtmlso-basically-i-should-never-have-choosed

kylewm commented 9 years ago

Here's another repro case, post this status

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
bbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb
cccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc
dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd
eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee

Known makes a slug from the first 10 words of the status...bad news if those words are very long!