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

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: csusza(at)gmail(dot)com
Subject: BUG #15743: pg_tblspc Sharing violation with MSSQL, therefore PostgreSQL is running into Timeout at startup
Date: 2019-04-09 13:59:04
Message-ID: 15743-5374bc002e7d1ae5@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15743
Logged by: Adam Mar
Email address: csusza(at)gmail(dot)com
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

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2019-04-09 17:23:22 Re: BUG #15698: to_char doesn't return expected value with negative INTERVAL
Previous Message Julien Rouhaud 2019-04-09 10:06:35 Re: EXT: Re: PostgreSQL 9.5 service stopped intermittently on windows 10 Pro version 1703.