眠いに一票
This account is not set to public on notestock.
This account is not set to public on notestock.
翼は授からなかったけど
775e835ed (upstream/master) Bump rubocop from 0.64.0 to 0.65.0 (#10112)
c07e59031 Bump dotenv-rails from 2.6.0 to 2.7.1 (#10114)
66adca611 Bump sidekiq-unique-jobs from 6.0.9 to 6.0.11 (#10113)
9dd54ffb1 Avoid redundant HTTP request on some error cases (#10115)
16fb39cff Fix fail health check due to missing wget (#10110)
ますたー ますたー
Merged tootsuite/mastodon at 775e835ed6e30c95d628abe11aaae7bfc66fde23.
@i_sparkling 証明書の置き間違いか、DNSの設定間違いかですかねー。
$ :| openssl s_client -connect typemoon.wiki.cre.jp:443 -servername typemoon.wiki.cre.jp 2>/dev/null | openssl x509 -noout -text
Certificate:
(中略)
Signature Algorithm: sha256WithRSAEncryption
Issuer: C=US, O=Let's Encrypt, CN=Let's Encrypt Authority X3
Validity
Not Before: Dec 23 19:15:10 2018 GMT
Not After : Mar 23 19:15:10 2019 GMT
Subject: CN=log.irc.cre.jp
(中略)
ubject Alternative Name:
DNS:d.trpg.net, DNS:d2.trpg.net, DNS:gyazo.trpg.net, DNS:log.irc.cre.jp, DNS:webirc.cre.jp
(後略)
$ dig +noall +answer typemoon.wiki.cre.jp
typemoon.wiki.cre.jp. 57 IN CNAME srv4.cre.jp.
srv4.cre.jp. 57 IN CNAME srv5.cre.jp.
srv5.cre.jp. 57 IN A 153.120.40.59
$ dig +noall +answer wiki.cre.jp
wiki.cre.jp. 300 IN CNAME srv2.cre.jp.
srv2.cre.jp. 300 IN A 153.120.8.114
This account is not set to public on notestock.
@i_sparkling srv2さんの証明書もなんか変ですねい
$ :| openssl s_client -connect srv2.cre.jp:443 -servername typemoon.wiki.cre.jp 2>/dev/null | openssl x509 -noout -text
Certificate:
(中略)
Signature Algorithm: sha256WithRSAEncryption
Issuer: C=US, O=Let's Encrypt, CN=Let's Encrypt Authority X1
Validity
Not Before: Dec 29 04:44:00 2015 GMT
Not After : Mar 28 04:44:00 2016 GMT
Subject: CN=kataribe.jp
(中略)
X509v3 Subject Alternative Name:
DNS:kataribe.jp
(後略)
一週間かけてメンテナンスするのかあ。オンプレのハードウェアにOSの再インストールからやり直す感じだったりするのかな?
This account is not set to public on notestock.
This account is not set to public on notestock.
This account is not set to public on notestock.
This account is not set to public on notestock.
This account is not set to public on notestock.
https://mastodon.zunda.ninja/ はアカウントが1つだけのぼっちインスタンスです。若い人はインスタンスじゃなくてサーバーって言います #インスタンス紹介
This account is not set to public on notestock.
This account is not set to public on notestock.
This account is not set to public on notestock.
@tadd ポスグレをちゃんとマネージドにするとどこでも結構高いっす https://github.com/zunda/mastodon/wiki/CostConsiderationsOnHeroku
This account is not set to public on notestock.
This account is not set to public on notestock.
This account is not set to public on notestock.
This account is not set to public on notestock.
inboxの応答、どれも2秒以内には返しているはずなのだが、応答速度(囲ってあるところ)に偏りがある理由、誰か分かる?確認している中で速いのは、けもフレ・qiitadon・misskey.xyz・m544だけ
世の中には2種類のHTTPSエンドポイントがある。SNIが必要なのと不必要なのだ。
って思ったんだけど関係なさそうですたw
飯テロ大好きだけど、ごち鯖にアカウント作るのはちょっと・・・な人は、 #gochisou_photo タグを付けて投稿しよう! https://gochisou.photo/tags/gochisou_photo
全文検索、SearchBox ElasticSearchを使えば$9/月で何とかなるかもだけどus-east-1からじゃないとレイテンシに殺されたりするんかな? https://github.com/zunda/mastodon/wiki/InstanceWithElasticsearch
ちなみに弊ぼっちインスタンスではポスグレが高くなったので焼け石に水な感じ使うのをあきらめました(´・ω・`)
This account is not set to public on notestock.
This account is not set to public on notestock.
This account is not set to public on notestock.
> SELECT uri FROM statuses WHERE text LIKE '%ビール%' AND text LIKE '%カシャプシュ%' AND account_id = 1;
uri
-----------------------------------------------------------------------
https://mastodon.zunda.ninja/users/zundan/statuses/100677037428233292
https://mastodon.zunda.ninja/users/zundan/statuses/101175100701978272
https://mastodon.zunda.ninja/users/zundan/statuses/101321083942687775
https://mastodon.zunda.ninja/users/zundan/statuses/101294078420616139
https://mastodon.zunda.ninja/users/zundan/statuses/101390448847124261
https://mastodon.zunda.ninja/users/zundan/statuses/101425269663952853
https://mastodon.zunda.ninja/users/zundan/statuses/101486483534076258
(7 rows)
Time: 178.331 ms
> SELECT uri FROM statuses WHERE text LIKE '%ビール%' AND text LIKE '%カシャプシュ%' AND NOT account_id = 1;
uri
-----
(0 rows)
Time: 17695.790 ms (00:17.696)
たぶんシーケンシャルスキャンのCPU負荷(高い子なのでよゆーだった)(しかしburstableなので0.2超えが続くと遅くなるよ)
This account is not set to public on notestock.
This account is not set to public on notestock.
This account is not set to public on notestock.
This account is not set to public on notestock.
レイテンシを考え始めると光ファイバーの中の光速を考えないかんし、きっとメモリとかCPUとかまで掘ると固体物理学とか量子力学とか顔を出しそうだし、楽しい(?)
This account is not set to public on notestock.