Jump to content


Photo

SQLite error 1 cannot vacuum SQL statement in progress

Database Tools

  • Please log in to reply
12 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
  • 8493 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
  • 8493 posts

Posted 04 February 2019 - 04:38 PM

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


Renee
RootsMagic

#5 lighthouse

lighthouse

    Advanced Member

  • Members
  • PipPipPip
  • 187 posts

Posted 27 March 2019 - 04:21 PM

Renee doing all of the above after opening RM I still cannot compact and still getting the message.

Regards



#6 zhangrau

zhangrau

    Advanced Member

  • Members
  • PipPipPip
  • 1522 posts

Posted 27 March 2019 - 05:03 PM

Whenever I decide it's time to Compact, I use this sequence:

 

A - Work for a while, including some merging of People and/or Sources

B - Backup

C - Database Tools

 c 1 - Check Integrity

 c 2 - Rebuild Indexes

 c 3 - Remove Phantoms

D - Backup

E - Close RM7

F - Open RM7

G - Database Tools

 g 1 - Compact

H - Backup

 

This sequence takes a bit of extra steps and time, but NEVER gives a vacuum error



#7 Renee Zamora

Renee Zamora

    Advanced Member

  • Support
  • PipPipPip
  • 8493 posts

Posted 28 March 2019 - 08:29 AM

Go to Tools>File Options>WebHints and turn them off.  Make sure TreeShare is also logged out. Then see if you can compact the database. 


Renee
RootsMagic

#8 lighthouse

lighthouse

    Advanced Member

  • Members
  • PipPipPip
  • 187 posts

Posted 29 March 2019 - 05:12 AM

Go to Tools>File Options>WebHints and turn them off.  Make sure TreeShare is also logged out. Then see if you can compact the database. 

Renee thanks for the reply.

Whilst working on the file, I turned off web hints and then got as far as compact and it did not work.

By closing down and reopen file with web hints off it worked.

 

It must have something to do with Web Hints.

 

Doing what zhangrau advised above (all due respect to zhangrau) that way did not work.



#9 zhangrau

zhangrau

    Advanced Member

  • Members
  • PipPipPip
  • 1522 posts

Posted 29 March 2019 - 07:24 AM


It must have something to do with Web Hints.

 

Doing what zhangrau advised above (all due respect to zhangrau) that way did not work.

 

Well, since I never use Web Hints, that makes sense. The conflict is with Web Hints, not Compact.
 



#10 Renee Zamora

Renee Zamora

    Advanced Member

  • Support
  • PipPipPip
  • 8493 posts

Posted 29 March 2019 - 11:22 AM

Interesting enough having WebHints on does not always mean you can't compact the database. I have WebHints, and FamilySearch on all the time and never have an issue Compacting. Yet, others do have an issue. So there must be something else going on the computer that causes the file not to compact with features that access the internet are turned on. I wish we knew what that was. 


Renee
RootsMagic

#11 lighthouse

lighthouse

    Advanced Member

  • Members
  • PipPipPip
  • 187 posts

Posted 29 March 2019 - 02:40 PM

Interesting enough having WebHints on does not always mean you can't compact the database. I have WebHints, and FamilySearch on all the time and never have an issue Compacting. Yet, others do have an issue. So there must be something else going on the computer that causes the file not to compact with features that access the internet are turned on. I wish we knew what that was. 

Renee last night I closed down RM and accepted and carried out the backup and it closed. I then ran Ccleaner.

 

This morning I opened RM and checked that web hints were on, and processed the 4 data base tools without any problems. So this problem does not always exist. We once before found that running Ccleaner before opening RM helped. :(



#12 Renee Zamora

Renee Zamora

    Advanced Member

  • Support
  • PipPipPip
  • 8493 posts

Posted 29 March 2019 - 02:50 PM

Maybe that's why I don't have an issue I run CCleaner regularly. 


Renee
RootsMagic

#13 lighthouse

lighthouse

    Advanced Member

  • Members
  • PipPipPip
  • 187 posts

Posted 06 April 2019 - 05:53 AM

Maybe that's why I don't have an issue I run CCleaner regularly. 

Yes I run it each day or 2







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