Re: Commit fest site - suspect changes

Lists: Postg스포츠 토토SQL : Postg스포츠 토토SQL 메일 링리스트 : 2023-09-30 이후 PGSQL WWW 12:23
From: Adrien Nayrat <adrien(dot)nayrat(at)anayrat(dot)info>
To: pgsql-www(at)lists(dot)postgresql(dot)org
Subject: Commit fest site - suspect changes
Date: 2023-09-30 09:44:55
Message-ID: 4fa83946-300d-4c4d-a11e-c4a1335c2f2f@anayrat.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-www

Hello,

It seems a user (Antwon Phillips twonpuncho23) has made suspect changes:

He changed authors, reviewers on many entries :

https://commitfest.postgresql.org/21/1869/
https://commitfest.postgresql.org/3/55/
https://commitfest.postgresql.org/21/1869/

Regards,

--
Adrien NAYRAT
https://blog.anayrat.info

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: adrien(dot)nayrat(at)anayrat(dot)info
Cc: pgsql-www(at)lists(dot)postgresql(dot)org
Subject: Re: Commit fest site - suspect changes
Date: 2023-09-30 10:09:53
Message-ID: 20230930.190953.380388371726658847.t-ishii@sranhm.sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-www

> Hello,
>
> It seems a user (Antwon Phillips twonpuncho23) has made suspect
> changes:
>
> He changed authors, reviewers on many entries :
>
> https://commitfest.postgresql.org/21/1869/
> https://commitfest.postgresql.org/3/55/
> https://commitfest.postgresql.org/21/1869/

I found many more too. Can we recover the data?

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp

From: Joe Conway <mail(at)joeconway(dot)com>
To: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>, adrien(dot)nayrat(at)anayrat(dot)info
Cc: pgsql-www(at)lists(dot)postgresql(dot)org
Subject: Re: Commit fest site - suspect changes
Date: 2023-09-30 12:23:07
Message-ID: cc9c27bf-c2de-a9c1-2856-5aa766dbb296@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: Postg스포츠 토토SQL : Postg스포츠 토토SQL 메일 링리스트 : 2023-09-30 이후 PGSQL WWW 12:23

On 9/30/23 06:09, Tatsuo Ishii wrote:
>> Hello,
>>
>> It seems a user (Antwon Phillips twonpuncho23) has made suspect
>> changes:
>>
>> He changed authors, reviewers on many entries :
>>
>> https://commitfest.postgresql.org/21/1869/
>> https://commitfest.postgresql.org/3/55/
>> https://commitfest.postgresql.org/21/1869/
>
> I found many more too. Can we recover the data?

Yep -- working on it. Looks like we will have to restore from previous
night's backup so we will be reset about a day

--
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com

From: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
To: mail(at)joeconway(dot)com
Cc: adrien(dot)nayrat(at)anayrat(dot)info, pgsql-www(at)lists(dot)postgresql(dot)org
Subject: Re: Commit fest site - suspect changes
Date: 2023-09-30 12:31:29
Message-ID: 20230930.213129.628004807956030299.t-ishii@sranhm.sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-www

> On 9/30/23 06:09, Tatsuo Ishii wrote:
>>> Hello,
>>> It seems a user (Antwon Phillips twonpuncho23) has made suspect
>>> changes:
>>> He changed authors, reviewers on many entries :
>>> https://commitfest.postgresql.org/21/1869/
>>> https://commitfest.postgresql.org/3/55/
>>> https://commitfest.postgresql.org/21/1869/
>> I found many more too. Can we recover the data?
>
> Yep -- working on it. Looks like we will have to restore from previous
> night's backup so we will be reset about a day

Thank you!
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp

From: Joe Conway <mail(at)joeconway(dot)com>
To: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
Cc: adrien(dot)nayrat(at)anayrat(dot)info, pgsql-www(at)lists(dot)postgresql(dot)org
Subject: Re: Commit fest site - suspect changes
Date: 2023-09-30 13:25:45
Message-ID: d15d4669-43b0-e53b-5202-0ce39942d6b6@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-www

On 9/30/23 08:31, Tatsuo Ishii wrote:
>> On 9/30/23 06:09, Tatsuo Ishii wrote:
>>>> Hello,
>>>> It seems a user (Antwon Phillips twonpuncho23) has made suspect
>>>> changes:
>>>> He changed authors, reviewers on many entries :
>>>> https://commitfest.postgresql.org/21/1869/
>>>> https://commitfest.postgresql.org/3/55/
>>>> https://commitfest.postgresql.org/21/1869/
>>> I found many more too. Can we recover the data?
>>
>> Yep -- working on it. Looks like we will have to restore from previous
>> night's backup so we will be reset about a day

Restored to backup from one day prior. We will take a look at what
changed in between, but it might be up to folks to redo some things.

A cooling off period was added to the commitfest app for new community
accounts, similar to what was done with the wiki a few years ago.

--
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com