senooken JP Social
  • FAQ
  • Login
senooken JP Socialはsenookenの専用分散SNSです。

  • Public

    • Public
    • Network
    • Groups
    • Popular
    • People

Notices by mimikun (mimikun@mstdn.mimikun.jp@mstdn.mimikun.jp), page 43

  1. mimikun (mimikun@mstdn.mimikun.jp@mstdn.mimikun.jp)'s status on Wednesday, 06-Feb-2019 19:33:45 JST mimikun mimikun

    writefreelyの縦書きのやつverticl-rlか

    In conversation Wednesday, 06-Feb-2019 19:33:45 JST from mstdn.mimikun.jp permalink
  2. mimikun (mimikun@mstdn.mimikun.jp@mstdn.mimikun.jp)'s status on Wednesday, 06-Feb-2019 19:17:33 JST mimikun mimikun

    単発3回

    In conversation Wednesday, 06-Feb-2019 19:17:33 JST from mstdn.mimikun.jp permalink

    Attachments


    1. https://s3-ap-northeast-1.amazonaws.com/mstdn.mimikun.jp/media_attachments/files/000/453/229/original/80662c629f8e5e69.jpg
  3. mimikun (mimikun@mstdn.mimikun.jp@mstdn.mimikun.jp)'s status on Wednesday, 06-Feb-2019 07:50:49 JST mimikun mimikun

    おはようの民おはよう

    In conversation Wednesday, 06-Feb-2019 07:50:49 JST from mstdn.mimikun.jp permalink
  4. けい＠箕面どん (xink21@minohdon.jp)'s status on Wednesday, 06-Feb-2019 00:04:07 JST けい＠箕面どん けい＠箕面どん

    正直、教育系のマストドンがもっと活発になればなぁ。と思ったりする。そうしたら、僕の少ない知見でもなんでもシェアしていきたいんだけどなぁ。他の人の話も聞きたいし。個人的には、文科省がやってた熟議サイトよかったのになぁ。

    In conversation Wednesday, 06-Feb-2019 00:04:07 JST from minohdon.jp permalink Repeated by mimikun@mstdn.mimikun.jp
  5. mimikun (mimikun@mstdn.mimikun.jp@mstdn.mimikun.jp)'s status on Wednesday, 06-Feb-2019 00:02:22 JST mimikun mimikun

    つlightsail な感じになる

    が、高い

    In conversation Wednesday, 06-Feb-2019 00:02:22 JST from mstdn.mimikun.jp permalink
  6. mimikun (mimikun@mstdn.mimikun.jp@mstdn.mimikun.jp)'s status on Wednesday, 06-Feb-2019 00:00:01 JST mimikun mimikun

    02-05のtoot数：63 (うちboost：9)

    In conversation Wednesday, 06-Feb-2019 00:00:01 JST from mstdn.mimikun.jp permalink
  7. おさ (osapon@mstdn.nere9.help@mstdn.nere9.help)'s status on Tuesday, 05-Feb-2019 23:07:31 JST おさ おさ

    重複レコードはステータスIDが違う状態で複数の同一内容があるので、DISTINCT *だと纏まらない。ユニークインデックスを貼ろうとしている項目が重複しているので、この様な（1枚目）テーブルがあるときは、group byとhavingで絞り込んで（2枚目）、出てきたデータを引いてどれを消すか検討が必要（3枚目）

    In conversation Tuesday, 05-Feb-2019 23:07:31 JST from mstdn.nere9.help permalink Repeated by mimikun@mstdn.mimikun.jp

    Attachments


    1. https://s3-ap-northeast-1.amazonaws.com/mstdn.mimikun.jp/media_attachments/files/000/451/951/original/7239792fbef4ea54.png

    2. https://s3-ap-northeast-1.amazonaws.com/mstdn.mimikun.jp/media_attachments/files/000/451/952/original/a5d1af91a4c84ab5.png

    3. https://s3-ap-northeast-1.amazonaws.com/mstdn.mimikun.jp/media_attachments/files/000/451/953/original/afab7b40ad0b30e4.png
  8. mimikun (mimikun@mstdn.mimikun.jp@mstdn.mimikun.jp)'s status on Tuesday, 05-Feb-2019 23:07:34 JST mimikun mimikun

    https://gist.github.com/mimikun/a53415146ed5a83dab2726944112f489

    これ正常なテーブルなんだろうか

    In conversation Tuesday, 05-Feb-2019 23:07:34 JST from mstdn.mimikun.jp permalink

    Attachments


  9. mimikun (mimikun@mstdn.mimikun.jp@mstdn.mimikun.jp)'s status on Tuesday, 05-Feb-2019 23:04:57 JST mimikun mimikun

    Macbookアツアツになってり

    In conversation Tuesday, 05-Feb-2019 23:04:57 JST from mstdn.mimikun.jp permalink
  10. mimikun (mimikun@mstdn.mimikun.jp@mstdn.mimikun.jp)'s status on Tuesday, 05-Feb-2019 23:04:06 JST mimikun mimikun

    REINDEX TABLE statuses;

    In conversation Tuesday, 05-Feb-2019 23:04:06 JST from mstdn.mimikun.jp permalink
  11. mimikun (mimikun@mstdn.mimikun.jp@mstdn.mimikun.jp)'s status on Tuesday, 05-Feb-2019 23:02:49 JST mimikun mimikun

    reindex database postgres

    In conversation Tuesday, 05-Feb-2019 23:02:49 JST from mstdn.mimikun.jp permalink
  12. mimikun (mimikun@mstdn.mimikun.jp@mstdn.mimikun.jp)'s status on Tuesday, 05-Feb-2019 22:58:56 JST mimikun mimikun

    postgres で INSERT時に 「id(主キー) がユニークじゃないよ」と怒られる。 - Qiita
    https://qiita.com/gekkoukisi/items/1a621522f34e902511c2

    101517199691404923
    4679348

    つまり…?

    In conversation Tuesday, 05-Feb-2019 22:58:56 JST from mstdn.mimikun.jp permalink

    Attachments


  13. mimikun (mimikun@mstdn.mimikun.jp@mstdn.mimikun.jp)'s status on Tuesday, 05-Feb-2019 22:56:17 JST mimikun mimikun

    SELECT DISTINCT * FROM statuses; かな
    違うかも
    #みみくんメモ

    In conversation Tuesday, 05-Feb-2019 22:56:17 JST from mstdn.mimikun.jp permalink
  14. mimikun (mimikun@mstdn.mimikun.jp@mstdn.mimikun.jp)'s status on Tuesday, 05-Feb-2019 22:53:05 JST mimikun mimikun

    WARNING: errors ignored on restore: 231

    In conversation Tuesday, 05-Feb-2019 22:53:05 JST from mstdn.mimikun.jp permalink
  15. mimikun (mimikun@mstdn.mimikun.jp@mstdn.mimikun.jp)'s status on Tuesday, 05-Feb-2019 22:52:20 JST mimikun mimikun

    ローカルマシンのDockerで立ち上げた環境で動かしてる

    In conversation Tuesday, 05-Feb-2019 22:52:20 JST from mstdn.mimikun.jp permalink
  16. mimikun (mimikun@mstdn.mimikun.jp@mstdn.mimikun.jp)'s status on Tuesday, 05-Feb-2019 22:51:08 JST mimikun mimikun

    これだ。

    pg_restore -C -d postgres mastodon_db_backup.dump

    #みみくんメモ

    In conversation Tuesday, 05-Feb-2019 22:51:08 JST from mstdn.mimikun.jp permalink
  17. mimikun (mimikun@mstdn.mimikun.jp@mstdn.mimikun.jp)'s status on Tuesday, 05-Feb-2019 22:40:33 JST mimikun mimikun

    postgres=# REINDEX DATABASE postgres;
    REINDEX

    これ成功してんのかな

    In conversation Tuesday, 05-Feb-2019 22:40:33 JST from mstdn.mimikun.jp permalink
  18. mimikun (mimikun@mstdn.mimikun.jp@mstdn.mimikun.jp)'s status on Tuesday, 05-Feb-2019 22:39:04 JST mimikun mimikun

    use database って打ってあっこれpostgresだってなる

    In conversation Tuesday, 05-Feb-2019 22:39:04 JST from mstdn.mimikun.jp permalink
  19. mimikun (mimikun@mstdn.mimikun.jp@mstdn.mimikun.jp)'s status on Tuesday, 05-Feb-2019 22:31:46 JST mimikun mimikun

    でてるエラーは

    ERROR: pg_stat_statements must be loaded via shared_preload_libraries

    と

    ERROR: duplicate key value violates unique constraint "index_status_stats_on_status_id"

    か

    In conversation Tuesday, 05-Feb-2019 22:31:46 JST from mstdn.mimikun.jp permalink
  20. mimikun (mimikun@mstdn.mimikun.jp@mstdn.mimikun.jp)'s status on Tuesday, 05-Feb-2019 22:28:19 JST mimikun mimikun

    これほんとよくわかる

    In conversation Tuesday, 05-Feb-2019 22:28:19 JST from mstdn.mimikun.jp permalink
  • After
  • Before

User actions

    mimikun

    mimikun

    <p>Admin of mstdn.mimikun.jp<br />mstdn.mimikun.jpの管理人</p><p>I&apos;m deaf<br />ろう者</p><p>卑猥な単語を含む投稿をよく行うので注意してください</p><p>うそをうそと見分けられない人間はうんぬんかんぬん</p><p><a href="https://mstdn.mimikun.jp/tags/splatoon2" class="mention hashtag" rel="tag">#<span>splatoon2</span></a> <a href="https://mstdn.mimikun.jp/tags/%E3%83%9D%E3%82%B1%E3%83%A2%E3%83%B3%E5%89%A3%E7%9B%BE" class="mention hashtag" rel="tag">#<span>ポケモン剣盾</span></a> <a href="https://mstdn.mimikun.jp/tags/ACNH" class="mention hashtag" rel="tag">#<span>ACNH</span></a> <a href="https://mstdn.mimikun.jp/tags/VRChat" class="mention hashtag" rel="tag">#<span>VRChat</span></a></p>

    Tags
    • (None)
    WebSub

    Following 1

    • せのお (妹尾 賢)

    Followers 0

      Groups 0

        Statistics

        User ID
        831
        Member since
        22 Jun 2018
        Notices
        6454
        Daily average
        2

        Feeds

        • Atom
        • Help
        • About
        • FAQ
        • TOS
        • Privacy
        • Source
        • Version
        • Contact

        senooken JP Social is a social network, courtesy of senooken. It runs on GNU social, version 2.0.2-beta0, available under the GNU Affero General Public License.

        Creative Commons Attribution 3.0 All senooken JP Social content and data are available under the Creative Commons Attribution 3.0 license.