Re: BUG #16161: pg_ctl stop fails sometimes (on Windows)
От
Kyotaro Horiguchi
Тема
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows)
Дата
Msg-id
20191220.123237.432497214732463092.horikyota.ntt@gmail.com
Ответ на
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) (Alexander Lakhin)
Список
Дерево обсуждения
BUG #16161: pg_ctl stop fails sometimes (on Windows) PG Bug reporting form <noreply@postgresql.org>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Alexander Lakhin <exclusion@gmail.com>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Alexander Lakhin <exclusion@gmail.com>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Alexander Lakhin <exclusion@gmail.com>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Alexander Lakhin <exclusion@gmail.com>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Alexander Lakhin <exclusion@gmail.com>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Alexander Lakhin <exclusion@gmail.com>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Alexander Lakhin <exclusion@gmail.com>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Juan José Santamaría Flecha <juanjo.santamaria@gmail.com>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Michael Paquier <michael@paquier.xyz>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Tom Lane <tgl@sss.pgh.pa.us>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Alexander Lakhin <exclusion@gmail.com>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Alexander Lakhin <exclusion@gmail.com>
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) Tom Lane <tgl@sss.pgh.pa.us>
At Fri, 20 Dec 2019 05:40:00 +0300, Alexander Lakhin wrote in > 19.12.2019 23:09, Tom Lane wrote: > > Alexander Lakhin writes: > >> Maybe we should change the condition to 'if (stat(fileName, &st) != 0 && > >> (err = GetLastError()) == ERROR_ACCESS_DENIED)' to avoid unnecessary > >> sleep with a loop iteration... > > Well, we have to loop back on file-not-found too ... > I think, if the file is not found on stat() we can safely return the > updated err (set errno with _dosmapper(err), to be exact). If we'll loop > back, we'll get the same err = GetLastError() after next CreateFile(). I think Tom is mentinoing for O_CREAT case. If CreateFile returned ERROR_ACCESS_DENIED, then stat() returns ERROR_FILE_NOT_FOUND, it means the next CreateFile can success. > >> It seems that the check for ERROR_DELETE_PENDING was added to > >> pgwin32_safestat() blindly, the issue wasn't reproduced at that time: > >> https://www.postgresql.org/message-id/CAB7nPqRJV6trFta-Qzgi6j2feuYR2ZC%2BKHvWdHnbpDG2scTrxw%40mail.gmail.com > > Hmm, makes one wonder whether that's actually live code. > I'll try to research this matter meantime. regards. -- Kyotaro Horiguchi NTT Open Source Software Center
В списке pgsql-bugs по дате отправления
От: Kyotaro Horiguchi
Дата:
От: Tomas Zubiri
Дата: