Thread: BUG #15905: FATAL: the database system is starting up

The following bug has been logged on the website:

Bug reference:      15905
Logged by:          Aayush chaturvedi
Email address:      chaturvedi98293@gmail.com
PostgreSQL version: 11.4
Operating system:   Windows 64 Bit
Description:

Hi Team,

I was working on server and suddenly my PC got off. When i restarted my PC i
am getting the error message "FATAL: the database system is starting up". I
am new to Postgre and this was the Master server having no backup at all.
With this server some of the users were connected as well.
Could anyone please help asap.

Some of the logs :
2019-07-12 12:25:53.720 IST [7856] LOG:  could not open file
"pg_tblspc/16817/DB2/BIN/db2compr.dll": sharing violation
2019-07-12 12:25:53.720 IST [7856] DETAIL:  Continuing to retry for 30
seconds.
2019-07-12 12:25:53.720 IST [7856] HINT:  You might have antivirus, backup,
or similar software interfering with the database system.
2019-07-12 12:26:28.460 IST [7856] LOG:  could not open file
"pg_tblspc/16817/DB2/BIN/db2dasapi64.dll": sharing violation
2019-07-12 12:26:28.460 IST [7856] DETAIL:  Continuing to retry for 30
seconds.
2019-07-12 12:26:28.460 IST [7856] HINT:  You might have antivirus, backup,
or similar software interfering with the database system.
2019-07-12 12:27:07.972 IST [7856] LOG:  could not open file
"pg_tblspc/16817/DB2/BIN/db2dascmn64.dll": sharing violation
2019-07-12 12:27:07.972 IST [7856] DETAIL:  Continuing to retry for 30
seconds.
2019-07-12 12:27:07.972 IST [7856] HINT:  You might have antivirus, backup,
or similar software interfering with the database system.

Thanks,
Aayush

On Fri, Jul 12, 2019 at 06:59:05AM +0000, PG Bug reporting form wrote:
> I was working on server and suddenly my PC got off. When i restarted my PC i
> am getting the error message "FATAL: the database system is starting up". I
> am new to Postgre and this was the Master server having no backup at all.
> With this server some of the users were connected as well.
> Could anyone please help asap.
>
> 2019-07-12 12:27:07.972 IST [7856] LOG:  could not open file
> "pg_tblspc/16817/DB2/BIN/db2dascmn64.dll": sharing violation

You should really double-check your installer and what you have on
this machine.  Postgres *never* adds any DLL files in a data folder.
--
Michael

On Sat, Jul 13, 2019 at 12:15:12AM +0530, Aayush Chaturvedi wrote:
> So I created tablespaces on my local system and I think that what was
> coming in the logs.

db2dascmn64.dll is a DLL coming from some stuff of IBM's DB2.  You may
want to check why you have executables in your data folder to begin
with.  These are *not* part of the original data folder created by
initdb.  So something in your installation is already not clear.  If a
DLL is being accessed for a reason or another, a base backup will
logically fail on it if another process out of PostgreSQL's backend
use it.  Postgres open() calls are shared-safe thanks to a custom
wrapper we have in the tree, but that's not the case of the native
implementation on Windows.
--
Michael