BUG #15743: pg_tblspc Sharing violation with MSSQL, therefore PostgreSQL is running into Timeout at startup

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

BUG #15743: pg_tblspc Sharing violation with MSSQL, therefore PostgreSQL is running into Timeout at startup

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

Bug reference:      15743
Logged by:          Adam Mar
Email address:      [hidden email]
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