PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15743
PG Version11.1
OSWindows 10
Opened2019-04-09 13:59:04+00
Reported byAdam Mar
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15743
Logged by:          Adam Mar
Email address:      (redacted)
PostgreSQL version: 11.1
Operating system:   Windows 10
Description:        

Hi,

I have a hard time restarting the postgreSQL server because as it can be
seen in the logs it has sharing violation with MSSQL Server:

2019-04-09 13:48:45.467 CEST [18984] LOG:  database system was interrupted;
last known up at 2019-04-09 12:54:05 CEST
2019-04-09 13:48:51.565 CEST [18984] LOG:  could not open file
"./pg_tblspc/30577/Project_TagLoggingDatabase.mdf": sharing violation
2019-04-09 13:48:51.565 CEST [18984] DETAIL:  Continuing to retry for 30
seconds.
2019-04-09 13:48:51.565 CEST [18984] HINT:  You might have antivirus,
backup, or similar software interfering with the database system.
2019-04-09 13:49:21.959 CEST [18984] LOG:  could not open file
"./pg_tblspc/30577/Project_TagLogging_0_log.ldf": sharing violation
2019-04-09 13:49:21.959 CEST [18984] DETAIL:  Continuing to retry for 30
seconds.
2019-04-09 13:49:21.959 CEST [18984] HINT:  You might have antivirus,
backup, or similar software interfering with the database system.
2019-04-09 13:49:52.324 CEST [18984] LOG:  could not open file
"./pg_tblspc/30577/Project_TLG1/Project_TLG1_20190408_151505.mdf": sharing
violation
2019-04-09 13:49:52.324 CEST [18984] DETAIL:  Continuing to retry for 30
seconds.
2019-04-09 13:49:52.324 CEST [18984] HINT:  You might have antivirus,
backup, or similar software interfering with the database system.

In our project we are working with both MSSQL and PSQL too and using
tablespaces to define where to create the databases, but I can not wrap my
hand around that the pg_tblspc is linking to the mdf files, even if I have
mdf files in the same directory I do not get why the PSQL has knowledge
about tablespaces which was created by MSSQL.

Thanks in advance,
Best Regards,
Adam

Messages

DateAuthorSubject
2019-04-09 13:59:04+00PG Bug reporting formBUG #15743: pg_tblspc Sharing violation with MSSQL, therefore PostgreSQL is running into Timeout at startup