Jump to content


Photo

SQLite error 1 cannot vacuum SQL statement in progress

Database Tools

  • Please log in to reply
3 replies to this topic

#1 lrrichey

lrrichey

    New Member

  • Members
  • Pip
  • 2 posts

Posted 19 January 2019 - 11:07 AM

when attempting to compact the database i get the above error. i close program and reboot computer and get the same message.

any suggestions of how to resolve this issur.



#2 Renee Zamora

Renee Zamora

    Advanced Member

  • Support
  • PipPipPip
  • 8206 posts

Posted 21 January 2019 - 09:04 AM

Make sure the database file is not inside any folder that is being synced to the cloud, like Dropbox, OneDrive or GoogleDrive. If it is move it out of there and then run all the Database Tools. 


Renee
RootsMagic

#3 Boninml

Boninml

    Member

  • Members
  • PipPip
  • 11 posts

Posted 04 February 2019 - 12:01 PM

Renee

 

I've notice that if i don't give a few extra seconds after doing the clean phantom records before doing the compact database, i will get that error.

 

so i give about 15 secs between each steps and i haven't got any problems since.

 

Maurice



#4 Renee Zamora

Renee Zamora

    Advanced Member

  • Support
  • PipPipPip
  • 8206 posts

Posted 04 February 2019 - 04:38 PM

Database Tools are best run after a fresh restart of RootsMagic. 


Renee
RootsMagic





Also tagged with one or more of these keywords: Database Tools