Latest post Tue, Oct 29 2019 1:40 PM by dlogneb. 8 replies.
Page 1 of 1 (9 items)
Sort Posts: Previous Next
  • Fri, Oct 18 2019 4:54 PM

    • chuckkahn
    • Top 500 Contributor
    • Joined on Thu, Oct 13 2005
    • Toronto
    • Posts 385
    • Points 4,225

    is deleting _SearchDB_ just a regular thing?

    I just deleted the _SearchDB_ file in my project for the third time since July.

     

    Is deleting _SearchDB_ just a regular part of maintenance for projects?   As in "Oh, search don't work.  Time to delete the _SearchDB_ file...."

     

     

    Avid Media Composer 2018.12.8 / MacOS High Sierra / iMac (Retina 5K, 27-inch, 2017) / 4.2 GHz Intel Core i7 / 64 GB 2400 MHz DDR4 [view my complete system specs]
  • Tue, Oct 22 2019 1:15 AM In reply to

    • Leo Baker
    • Top 500 Contributor
    • Joined on Wed, Oct 5 2011
    • London
    • Posts 443
    • Points 5,210

    Re: is deleting _SearchDB_ just a regular thing?

    Hi are you using Phrase find? What issue did you have why you needed to delete the search db? When you tried to do searches nothing showed for your search results?

     

    I've used Media Composer for a very long time and haven't needed to ever delete that. Dud you update Media Composer mid project then this issue started? If do could be your user settings.

     

    Look forward to hearing from you. 

     

    Kind regards,

     

    Leo

    MacPro6.1 Late 2013 Intel Xeon 12-Core 2.7GHz 64GB RAM AMD FirePro D700 6GB OSX Mojave 10.14.6. Media Composer 2019.12, Pro Tools 2019.12, Avid Artist... [view my complete system specs]
  • Tue, Oct 22 2019 6:05 PM In reply to

    • chuckkahn
    • Top 500 Contributor
    • Joined on Thu, Oct 13 2005
    • Toronto
    • Posts 385
    • Points 4,225

    Re: is deleting _SearchDB_ just a regular thing?

    Not using PhraseFind.   Using Script Sync.  Issues with searching in the Find Clips and Sequences tab.  Type a search term.  Click Find.  Big red error came up and would not search.  Deleting the _SearchDB_ file fixed it.   Until it happens again.

     

    Although last season I wasn't using Script Sync either on Mac Pro 2010 tower and the same error happened.   Was using ISIS storage in both cases for projects and media.   Don't recall this happening on local storage.

    Avid Media Composer 2018.12.8 / MacOS High Sierra / iMac (Retina 5K, 27-inch, 2017) / 4.2 GHz Intel Core i7 / 64 GB 2400 MHz DDR4 [view my complete system specs]
  • Tue, Oct 22 2019 11:47 PM In reply to

    • Leo Baker
    • Top 500 Contributor
    • Joined on Wed, Oct 5 2011
    • London
    • Posts 443
    • Points 5,210

    Re: is deleting _SearchDB_ just a regular thing?

    I haven't used Script sync in a long time, maybe you can report this to Avid incase they know chime in why this needs manually deleting?

    Kind regards,

    Leo

    MacPro6.1 Late 2013 Intel Xeon 12-Core 2.7GHz 64GB RAM AMD FirePro D700 6GB OSX Mojave 10.14.6. Media Composer 2019.12, Pro Tools 2019.12, Avid Artist... [view my complete system specs]
  • Wed, Oct 23 2019 4:32 PM In reply to

    • chuckkahn
    • Top 500 Contributor
    • Joined on Thu, Oct 13 2005
    • Toronto
    • Posts 385
    • Points 4,225

    Re: is deleting _SearchDB_ just a regular thing?

    It's random and I don't know how to re-create the issue so it would be difficult to get support on this unless support had a way to recreate it on their end.  Last season's Mac Pro was a Pivotal Post rental and when I contacted Pivotal about the issue I was told to delete the folder containing _SearchDB_ file in order to fix it.   After doing this so many time I realized that deleting just _SearchDB_ was enough to fix the issue without resetting all other non-Find related settings.   This season's iMac is mine but the project and media are still saved to Pivotal Post's ISIS.   And it's a new project this season, saved to the same location.   Script Sync wouldn't be a factor since I didn't use it last season and encountered the error then -- I just brought it up because you mentioned Phrase Find, which I don't have.

     

    Avid Media Composer 2018.12.8 / MacOS High Sierra / iMac (Retina 5K, 27-inch, 2017) / 4.2 GHz Intel Core i7 / 64 GB 2400 MHz DDR4 [view my complete system specs]
  • Sun, Oct 27 2019 2:24 PM In reply to

    • chuckkahn
    • Top 500 Contributor
    • Joined on Thu, Oct 13 2005
    • Toronto
    • Posts 385
    • Points 4,225

    Re: is deleting _SearchDB_ just a regular thing?

    Here's one of those random occurances -- #4 since July.

     

    "Search Error: SQL could not be executed"

     

    Avid Media Composer 2018.12.8 / MacOS High Sierra / iMac (Retina 5K, 27-inch, 2017) / 4.2 GHz Intel Core i7 / 64 GB 2400 MHz DDR4 [view my complete system specs]
  • Tue, Oct 29 2019 1:26 PM In reply to

    • dlogneb
    • Not Ranked
    • Joined on Wed, Aug 27 2014
    • Posts 48
    • Points 485

    Re: is deleting _SearchDB_ just a regular thing?

    Where is your SearchDB?  On the shared storage, or on your local drives?

    I find many SearchDB errors are fixed by moving the database to local.  In the find window click the gear-icon next to "Bin Index" in the lower left.  There's a pull down menu that says "Default", switch it to "Local Default".

    Avid MC 2018.9.0 Mac Os High Sierra (10.13.6) iMac Pro (2017) 2.3Ghz Intel Xeon W 128 GB 266 Mhz DDR4 Radeon Pro Vega 64 16368 MB [view my complete system specs]
  • Tue, Oct 29 2019 1:28 PM In reply to

    • chuckkahn
    • Top 500 Contributor
    • Joined on Thu, Oct 13 2005
    • Toronto
    • Posts 385
    • Points 4,225

    Re: is deleting _SearchDB_ just a regular thing?

    If the project is on shared ISIS storage, do I have such a choice as you illustrate?

    Avid Media Composer 2018.12.8 / MacOS High Sierra / iMac (Retina 5K, 27-inch, 2017) / 4.2 GHz Intel Core i7 / 64 GB 2400 MHz DDR4 [view my complete system specs]
  • Tue, Oct 29 2019 1:40 PM In reply to

    • dlogneb
    • Not Ranked
    • Joined on Wed, Aug 27 2014
    • Posts 48
    • Points 485

    Re: is deleting _SearchDB_ just a regular thing?

    Yes.   I believe it has little meaning except when working on shared storage (if you don't have shared storage the default and local are the same thing). 

    The last three places I worked at on shared-storage all had me do this.  

     

     

    Avid MC 2018.9.0 Mac Os High Sierra (10.13.6) iMac Pro (2017) 2.3Ghz Intel Xeon W 128 GB 266 Mhz DDR4 Radeon Pro Vega 64 16368 MB [view my complete system specs]
Page 1 of 1 (9 items)

© Copyright 2011 Avid Technology, Inc.  Terms of Use |  Privacy Policy |  Site Map |  Find a Reseller