ZE3kr
V2EX  ›  GitLab

GitLab.com 误删了数据,现在彻底挂了

  •  
  •   ZE3kr · Feb 1, 2017 · 11713 views
    This topic created in 3568 days ago, the information mentioned may be changed or developed.
    已经宕机两个多小时,预计还会继续。



    他们发了个Google Docs,里面一些内容也是值得学习的

    https://docs.google.com/document/d/1GCK53YDcBWQveod9kfzW-VCxIABGiryG7_z_6jHdVik/pub
    Supplement 1  ·  Feb 1, 2017
    The incident affected the database (including issues and merge requests) but not the git repo's (repositories and wikis).

    看来是💊,数据库再也恢复不出来的节奏!影响重大啊
    30 replies  •  2017-02-03 10:28:27 +08:00
    yangqi
    yangqi
    Feb 1, 2017❤️1
    1
    太好笑了, 5 种备份方式没有一个备份正确的。这平时没人检查,一帮人居然没人意识到备份的重要性
    dzxx36gyy
    dzxx36gyy
    Feb 1, 2017 via Android❤️1
    2
    噗噗噗
    ZE3kr
    ZE3kr
    OP
    Feb 1, 2017
    3
    看到 “ 5 backup/replication techniques deployed none are working reliably or set up in the first place ” 时我也很惊讶,至少我都会定期检查备份是否更新,是否有大小(经常因为配置问题备份是空的)
    ZE3kr
    ZE3kr
    OP
    Feb 1, 2017
    4
    之前就是因为自己维护 GitLab 太麻烦,用了 GitLab.com 的公共服务,没想到它们的公共服务现在出了问题……
    EPr2hh6LADQWqRVH
    EPr2hh6LADQWqRVH
    Feb 1, 2017 via Android
    5
    堪忧啊, Ruby 党
    AstroProfundis
    AstroProfundis
    Feb 1, 2017
    6
    最后那句结论真是看着血淋淋的...
    deleted
    deleted
    Feb 1, 2017 via Android
    7
    gitlab 粗事了…
    wzxjohn
    wzxjohn
    Feb 1, 2017
    8
    吃惊。。。还好我用的是自建的。。。
    Busy
    Busy
    Feb 1, 2017
    9
    汗...
    Unknwon
    Unknwon
    Feb 1, 2017❤️2
    10
    感觉这是个植入广告的完美时机。。我觉得我不能错过。。

    https://gogs.io/ 你值得拥有。。。
    DoraJDJ
    DoraJDJ
    Feb 1, 2017 via Android
    11
    rm -rf / 又发威了

    幸好提前转到了 Coding Pages
    yangqi
    yangqi
    Feb 1, 2017
    12
    @Unknwon 呵呵,你需要把你们备份方案晒出来才能抓住这个完美时机
    neilp
    neilp
    Feb 1, 2017
    13
    5 个方案竟然都失败了.
    也是没谁了
    irainsoft
    irainsoft
    Feb 1, 2017
    14
    5 个都不工作也真是厉害 这么久还没发现....
    Sharuru
    Sharuru
    Feb 1, 2017
    15
    五个备份除了最后的 S3 存储不正确以外,其他的都是因为备份周期过长( 24 小时)导致的。

    备份是为了能够在系统失效后尽快的回复可用状态的最后手段,
    如果是为了失效后快速恢复,那是 HA 做的事;
    ZE3kr
    ZE3kr
    OP
    Feb 1, 2017 via iPhone
    16
    @Sharuru Regular backups 是找不到存在了哪个地方
    Disk snapshots 没有备份数据库

    总之就是倒霉的事情都碰上了,不然不至于宕机那么久
    yangqi
    yangqi
    Feb 1, 2017
    17
    @Sharuru 24 小时可用的备份只有 LVM 快照,其他都无效

    "2. Regular backups seem to also only be taken once per 24 hours, though YP has not yet been able to figure out where they are stored. According to JN these don ’ t appear to be working, producing files only a few bytes in size."
    "3. Disk snapshots in Azure are enabled for the NFS server, but not for the DB servers."
    "4. The synchronisation process removes webhooks once it has synchronised data to staging. "
    "5. The replication procedure is super fragile, prone to error, relies on a handful of random shell scripts, and is badly documented"
    ZE3kr
    ZE3kr
    OP
    Feb 1, 2017 via iPhone
    18
    话说我最近也弄丢个非常重要的代码文件,正在我特别着急,是不是要重新写一遍代码时,发现我有一个一天前的 snapshot ,瞬间如释重负
    DaCong
    DaCong
    Feb 1, 2017 via Android
    19
    怪不得我今天更新 aur 上的一个包的时候从 gitlab 下载源代码总是出错。
    matrix67
    matrix67
    Feb 1, 2017
    20
    好消息是 This incident affected the database (including issues and merge requests) but not the git repo's (repositories and wikis).
    matrix67
    matrix67
    Feb 1, 2017
    21
    主要原因是手快

    YP thinks that perhaps pg_basebackup is being super pedantic about there being an empty data directory, decides to remove the directory. After a second or two he notices he ran it on db1.cluster.gitlab.com, instead of db2.cluster.gitlab.com


    2017/01/31 23:27 YP - terminates the removal, but it ’ s too late. Of around 310 GB only about 4.5 GB is left - Slack

    然后他们还想用这个方法 恢复。难道他们是现场 google 的?应该不会吧。

    JEJ: Probably too late, but isn't it sometimes possible if you make the disk read-only quickly enough? Also might still have file descriptor if the file was in use by a running process according to http://unix.stackexchange.com/a/101247/213510


    Azure 这个删的快。想到 adobe 那个梗。 mac 要放个 adobe 压压惊。

    Also, Azure is apparently also really good in removing data quickly, but not at sending it over to replicas.
    wanghanlin
    wanghanlin
    Feb 1, 2017
    22
    没人关注这个点吗
    Removed a user for using a repository as some form of CDN, resulting in 47 000 IPs signing in using the same account
    nomaka
    nomaka
    Feb 1, 2017
    23
    The incident affected the database (including issues and merge requests) but not the git repo's (repositories and wikis). 文件存储的东西还在
    ZE3kr
    ZE3kr
    OP
    Feb 1, 2017 via iPhone
    24
    @nomaka 感觉没什么用, git 一般本地都有,而就本地没有的那些它反而丢了,所以💊的节奏,数据库里还有用户账号和各种认证信息等等。
    Drops
    Drops
    Feb 1, 2017 via Android
    25
    @yangqi 这个好像只有自建,自己搞定备份
    syhsyh9696
    syhsyh9696
    Feb 1, 2017
    26
    @avastms 莫名奇妙,是数据库的问题,怎么又说 ruby 堪忧?犯不着这样踩吧。
    EPr2hh6LADQWqRVH
    EPr2hh6LADQWqRVH
    Feb 1, 2017
    27
    @syhsyh9696 浮躁,踏实的公司出不了这个问题
    okampfer
    okampfer
    Feb 2, 2017
    28
    请教各位一个问题,国内的大家使用哪家的呢?
    1. git.oschina.net(我正在用)
    2. coding.net
    3. code.csdn.net
    4. code.aliyun.com
    ZE3kr
    ZE3kr
    OP
    Feb 2, 2017
    29
    stevenkang
    stevenkang
    Feb 3, 2017
    30
    @okampfer code.aliyun.com 主要是快,稳定,可靠(至少比 CSDN )。
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   3392 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 73ms · UTC 10:12 · PVG 18:12 · LAX 02:12 · JFK 05:12
    ♥ Do have faith in what you're doing.