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

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

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

PG Bug reporting form
The following bug has been logged on the website:

Bug reference:      15905
Logged by:          Aayush chaturvedi
Email address:      [hidden email]
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

Reply | Threaded
Open this post in threaded view
|

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

Michael Paquier-2
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

signature.asc (849 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

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

Aayush Chaturvedi
Hi Michael,

So I created tablespaces on my local system and I think that what was coming in the logs.

Thanks,
Aayush

On Fri, 12 Jul, 2019, 1:27 PM Michael Paquier, <[hidden email]> wrote:
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
Reply | Threaded
Open this post in threaded view
|

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

Michael Paquier-2
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

signature.asc (849 bytes) Download Attachment