How to fix git error when refreshing changes

• 
  Do you by any chance have any of the files open/selected/locked in any other programs? (E.g. file explorer/text editor).
  
  Do you have full access to the filesystem where your git repo is located?

  AlexYates January 22, 2020 21:38

  - 0 +
• 
  Yes I have full access. I'm linking the database to an empty subdirectory. I already have another database linked to the same repository in a different directory and that one works fine.
  

  dsbert January 23, 2020 15:13

  - 0 +
• 
  Have you tried deleting the local repo and pulling down a fresh clone?
  
  (Obviously commit and push or otherwise save any local updates/commits before deleting the local repo to avoid losing work.)

  AlexYates January 23, 2020 16:10

  - 0 +
• 
  I cloned the repo again to a different directory, unlinked the db and linked it again with the new path. Now it works - but the entire DB is showing up as a change. I'm guessing something went wrong when I first linked it?

  
  

  Just noticed when i tried to delete the original repo, I'm getting an error. Looks like something is holding a file lock. Maybe that was the issue.
  

  dsbert January 24, 2020 17:54

  - 0 +
• 
  Is there a redgate.ssc file at the exact path you committed to?
  
  Does the code in the repo match the code in the DB?

  AlexYates January 24, 2020 18:01

  - 0 +
• 
  Yes there is a redgate.ssc file. It is the same one from when I first linked this database and I have not made any changes to it because of the issues discussed in this thread.
  

  dsbert January 24, 2020 18:04

  - 0 +
• 
  So the entire DB is showing as a change... What sort of change? New objects? Modified objects? Deleted objects?
  
  I'm assuming you were expecting them to be in sync?

  AlexYates January 24, 2020 18:15

  - 0 +
• 
  I tried renaming my new cloned folder and then relinking the same database again to the new path. I received the same error about not being able to execute git clean.

  
  

  Does SQL Source Control support multiple databases in the same git repository?
  

  dsbert January 24, 2020 18:16

  - 0 +
• 
  It should do. Most of my clients use Git repos that contain multiple DBs.
  
  Have you tried opening a command prompt to the DB directory and running a git status and a git clean?
  
  Does that give you any more feedback or provide any unexpected surprises?

  AlexYates January 24, 2020 20:09

  - 0 +
• 
  I can run git clean without any issues from both the directory that I linked to and the root of the repository.
  

  dsbert January 25, 2020 00:44

  - 0 +
• 
  After running git clean, did your issues persist? (I'm assuming so).
  
  At this point I think I'm out of suggestions. I suspect it's one for Redgate tech support. Good luck!

  AlexYates January 25, 2020 07:19

  - 0 +
• 
  Sorry to bring up an old thread, but I see nothing newer.  Was there any resolution to this?  I am experiencing this same exact issue.
  

  tinterqh May 21, 2020 17:47

  - 0 +
• 
  I do not recall what finally resolved this issue for me but at some point it stopped being a problem. Sorry I can't offer more info.
  

  dsbert May 21, 2020 18:18

  - 0 +

Add comment

Please sign in to leave a comment.