When are database changes flushed to disk?

You find a bug! You post it here!

When are database changes flushed to disk?

Postby S Pittaway on Tue Oct 25, 2011 2:28 pm

My htpc as recently passed away, while it was in its final death throws it was very unstable...

I save play info on my music/movies and i was losing a lot of updates.

When are database changes flushed to disk?

I guess you mark items has dirty when they are modified?

I was expecting you to flush the changes to disk in the background (when system is idle etc), but i am not sure that you do.

if i don't explicitly save the database using the save db command if anything happens to xlobby i was loosing my updates.

I have save to item disabled if that is any use.


Sean.
S Pittaway
 
Posts: 713
Joined: Wed Jan 25, 2006 11:08 am
Location: Manchester, England

Re: When are database changes flushed to disk?

Postby S Pittaway on Fri Dec 09, 2011 1:33 pm

Bump, Anyone had chance to check this, i am sure my databases do not get saved as expected?
Last edited by S Pittaway on Wed Jan 11, 2012 2:03 pm, edited 1 time in total.
S Pittaway
 
Posts: 713
Joined: Wed Jan 25, 2006 11:08 am
Location: Manchester, England

Re: When are database changes flushed to disk?

Postby S Pittaway on Mon Dec 12, 2011 12:36 pm

I have added a mantis entry: http://xlobby.com/mantis/view.php?id=981
S Pittaway
 
Posts: 713
Joined: Wed Jan 25, 2006 11:08 am
Location: Manchester, England

Re: When are database changes flushed to disk?

Postby S Pittaway on Wed Jan 04, 2012 1:35 pm

new year, new bump :)
S Pittaway
 
Posts: 713
Joined: Wed Jan 25, 2006 11:08 am
Location: Manchester, England

Re: When are database changes flushed to disk?

Postby S Pittaway on Tue Jan 10, 2012 10:50 am

and again
S Pittaway
 
Posts: 713
Joined: Wed Jan 25, 2006 11:08 am
Location: Manchester, England

Re: When are database changes flushed to disk?

Postby lar282 on Tue Jan 10, 2012 12:10 pm

S Pittaway wrote:and again


I like to know too -:)

//Lasse
Image
lar282
 
Posts: 1682
Joined: Thu Apr 01, 2004 4:13 pm
Location: Helsingborg, Sweden

Re: When are database changes flushed to disk?

Postby stevenhanna6 on Tue Jan 17, 2012 7:19 pm

Should be every three hours of inactivity it saves data, I replied on mantis for the command you are using to save the data. When I exit after saving info from a spider its there on a reload, so I think it might be a command you are using that doesn't have the new save code.
stevenhanna6
 
Posts: 934
Joined: Tue Feb 18, 2003 10:39 am
Location: Ontario, Canada

Re: When are database changes flushed to disk?

Postby S Pittaway on Fri Jan 20, 2012 3:16 pm

3 hours is quite a long time, i tend have mt pc go to sleep when its not doing anything or i go to bed...

Could the timeout be added to the options page so i could tweek it?

Also do the changes always get flushed when xlobby is closed?
S Pittaway
 
Posts: 713
Joined: Wed Jan 25, 2006 11:08 am
Location: Manchester, England

Re: When are database changes flushed to disk?

Postby stevenhanna6 on Fri Jan 20, 2012 3:43 pm

//posted to mantins, but i'll post here also just because

ok I've made some changes to make it save right away instead, if this causes some unforeseen issue I'll switch it back to the old way but lower the 3hrs to something like 10min.

Yes all changes did get flushed on exit, but that wont matter now, they will save within a couple seconds.

It's in the latest bleeding edge if you want to test it.
stevenhanna6
 
Posts: 934
Joined: Tue Feb 18, 2003 10:39 am
Location: Ontario, Canada

Re: When are database changes flushed to disk?

Postby S Pittaway on Fri Jan 20, 2012 5:01 pm

will do, cheers.
S Pittaway
 
Posts: 713
Joined: Wed Jan 25, 2006 11:08 am
Location: Manchester, England

Re: When are database changes flushed to disk?

Postby S Pittaway on Tue Jan 24, 2012 12:11 pm

Not sure what i am missing, but i did a bleeding edge update played left it playing some music...

the track played times where updated and i could see the changes on the playlist...

i also set a few ratings manually, agian i could see the new values on the playlist...

But the music.xml file was never updated.

When i exited xlobby the file was not updated (clicked close on the system bar, not an exit option on the main menu).

Had similar results when i played a movie - i could see the changes on the screen, but the movies.xml file was not updated.

if i force a save using the event command it is saved.



not sure it it effects any code paths, but i have save to item.xml disabled in the options tab...
S Pittaway
 
Posts: 713
Joined: Wed Jan 25, 2006 11:08 am
Location: Manchester, England


Return to Bug Tracking / Reports

Who is online

Users browsing this forum: Yahoo [Bot] and 0 guests

cron