Davinci Keeps saying database already in use

Get answers to your questions about color grading, editing and finishing with DaVinci Resolve.
  • Author
  • Message
Offline

TheWiredWorld

  • Posts: 1
  • Joined: Wed Apr 11, 2018 8:45 am
  • Real Name: Jonathan Means

Davinci Keeps saying database already in use

PostWed Nov 28, 2018 10:31 pm

Anyone run into this? I'm trying to create a new database but it keeps saying that data base is already in use.

This is a fresh install with no previous versions of Davinci on it. There are no databases in existence on this computer except maybe a default one if that exists.

What is happening?
Offline
User avatar

Igor Riđanović

  • Posts: 1630
  • Joined: Thu Jul 02, 2015 5:11 am
  • Location: Los Angeles, Calif.

Re: Davinci Keeps saying database already in use

PostThu Nov 29, 2018 12:42 am

Resolve PostgreSQL databases are not really deleted when you delete them in the project manager. They are only made invisible to Resolve users. I haven't seen what you describe, but it's possible you have a DB of the same name. Try connecting to it instead of creating a new one.

You can also use pgAdminIII to show you all the databases on the server.
www.metafide.com - DaVinci Resolve™ Apps
Offline
User avatar

Dwaine Maggart

Blackmagic Design

  • Posts: 12763
  • Joined: Wed Aug 22, 2012 2:53 pm

Re: Davinci Keeps saying database already in use

PostThu Nov 29, 2018 1:44 am

PostgreSQL or Disk database?
Dwaine Maggart
Blackmagic Design DaVinci Support
Offline

beaurosario

  • Posts: 40
  • Joined: Wed Feb 13, 2019 8:48 pm
  • Real Name: Beau Rosario

Re: Davinci Keeps saying database already in use

PostFri Dec 04, 2020 6:30 pm

]I'm having a similar issue. I created the postgres server on the host machine (kept DaVinci's default settings for its setup), enabled sharing, and created an access key on a shared folder.

On the client machine, I dragged the access key file into the project manager, at which point it did nothing. When I tried dragging it in again, a dialogue popped up saying "Database already Exists" but it does not show up in the left-hand database list.

Screen Shot 2020-12-04 at 1.07.01 PM.png
Screen Shot 2020-12-04 at 1.07.01 PM.png (435.47 KiB) Viewed 1510 times


So, I tried connecting to it manually, and noticed the "Location" field is greyed out. (I cannot figure out how to manually change this. I know this was greyed out in DR16 and before as a means of locking Free users out of the collab functions, but don't know how to change this in DR17.)

Screen Shot 2020-12-04 at 1.07.42 PM.png
Screen Shot 2020-12-04 at 1.07.42 PM.png (249.14 KiB) Viewed 1510 times


Anyway, I just typed in "resolve" (the project server name) in the Name field and hit enter, and then I get the error:

Screen Shot 2020-12-04 at 1.09.07 PM.png
Screen Shot 2020-12-04 at 1.09.07 PM.png (158.49 KiB) Viewed 1510 times


I'm not a genius on postgres, but I'm hoping there's something simple I'm doing wrong here. Thoughts?
MacBook Pro M1 Max, 64GB Ram, 2TB Storage, Sonoma 14.5
Offline
User avatar

Dwaine Maggart

Blackmagic Design

  • Posts: 12763
  • Joined: Wed Aug 22, 2012 2:53 pm

Re: Davinci Keeps saying database already in use

PostFri Dec 04, 2020 6:40 pm

The location field being grayed out is a helpful indication that you are using the free version of Resolve.

It does not support remote PostgreSQL database access.
Dwaine Maggart
Blackmagic Design DaVinci Support
Offline

beaurosario

  • Posts: 40
  • Joined: Wed Feb 13, 2019 8:48 pm
  • Real Name: Beau Rosario

Re: Davinci Keeps saying database already in use

PostFri Dec 04, 2020 6:45 pm

Hmm... Everywhere I look, DR17 is being touted as including the collaboration tools even in the free version, (ie, articles like this: https://nofilmschool.com/heres-whats-new-davinci-resolve-17) and there doesn't seem to be a clear delineation between the two versions regarding the collaboration tools on the BM site. (Even on the phone today, the rep wasn't sure which version had what.)

Am I misunderstanding what is meant by "collaboration tools" or are all these publications just wrong in saying it's a feature in the free version? I'm excited to use this feature- I ordered license keys weeks ago but still on backorder :(
MacBook Pro M1 Max, 64GB Ram, 2TB Storage, Sonoma 14.5
Offline
User avatar

Dwaine Maggart

Blackmagic Design

  • Posts: 12763
  • Joined: Wed Aug 22, 2012 2:53 pm

Re: Davinci Keeps saying database already in use

PostFri Dec 04, 2020 6:55 pm

You are not misunderstanding, but collab functionality has not yet been added to the free 17 beta. It's a work in progress.
Dwaine Maggart
Blackmagic Design DaVinci Support
Offline

beaurosario

  • Posts: 40
  • Joined: Wed Feb 13, 2019 8:48 pm
  • Real Name: Beau Rosario

Re: Davinci Keeps saying database already in use

PostFri Dec 04, 2020 6:56 pm

Ahh, that makes sense. I'll standby for license keys then. Thanks for your help!
MacBook Pro M1 Max, 64GB Ram, 2TB Storage, Sonoma 14.5
Offline

DwyerCine

  • Posts: 4
  • Joined: Mon Dec 14, 2020 10:50 pm
  • Real Name: Joseph Dwyer

Re: Davinci Keeps saying database already in use

PostMon Dec 14, 2020 10:53 pm

Dwaine Maggart wrote:You are not misunderstanding, but collab functionality has not yet been added to the free 17 beta. It's a work in progress.


Good to know – this was throwing me for a loop all morning trying to get a client's machine running the free version of 17 beta to connect to my primary workstation running 17 studio. Thank you for the clarification.
Offline

eddmag9027

  • Posts: 3
  • Joined: Mon Jan 11, 2021 12:45 am
  • Real Name: Eduardo Martinez

Re: Davinci Keeps saying database already in use

PostMon Jan 11, 2021 12:49 am

Is there any solution? I am having the same problem and I can't find that database in my computer to delete it....
Offline

officialmjsmith

  • Posts: 1
  • Joined: Tue Jan 12, 2021 12:26 pm
  • Real Name: Markel Smith

Re: Davinci Keeps saying database already in use

PostTue Jan 12, 2021 12:30 pm

I too am having the same issue. But instead of the server, I'm using the Disk. I located the folder where the file is supposed to be contained, but the attachment below is all that was contained.

Screenshot 2021-01-12 072850.png
The only file inside.
Screenshot 2021-01-12 072850.png (36.38 KiB) Viewed 1406 times


Just to be safe, I deleted the entire folder and I'm still having the same issue.
Offline
User avatar

Dwaine Maggart

Blackmagic Design

  • Posts: 12763
  • Joined: Wed Aug 22, 2012 2:53 pm

Re: Davinci Keeps saying database already in use

PostTue Jan 12, 2021 6:40 pm

What is your specific issue?

If the oldest version of Resolve you've ever had installed on your system is 16, then that's not the database location.
Dwaine Maggart
Blackmagic Design DaVinci Support
Offline

eddmag9027

  • Posts: 3
  • Joined: Mon Jan 11, 2021 12:45 am
  • Real Name: Eduardo Martinez

Re: Davinci Keeps saying database already in use

PostWed Jan 13, 2021 6:35 pm

I am trying to connect disk database with an old name database but this message shows up “This database is already in use”. But has no sense to me since that database name was disconnected a long time ago... Any idea?
Offline
User avatar

Dwaine Maggart

Blackmagic Design

  • Posts: 12763
  • Joined: Wed Aug 22, 2012 2:53 pm

Re: Davinci Keeps saying database already in use

PostThu Jan 14, 2021 12:32 am

Tell us the name of the database you are trying to connect to, and it's file path.

In the Resolve Help menu, select "Create Diagnostics Log on Desktop" and send us that file.
Dwaine Maggart
Blackmagic Design DaVinci Support
Offline

eddmag9027

  • Posts: 3
  • Joined: Mon Jan 11, 2021 12:45 am
  • Real Name: Eduardo Martinez

Re: Davinci Keeps saying database already in use

PostTue Jan 19, 2021 1:44 pm

Thank you for your help...

Return to DaVinci Resolve

Who is online

Users browsing this forum: dirk-pel, Fully_Loaded34, Mads Johansen, qsipher, Robert John and 262 guests