[apeg]

I have an odd setup, on my main computer (windows) i have a Jarvis instance running and that's where i scan my nas for updates

I have 3x Rpi2 running Jarvis and i copy the MyVideos99.db from the windows machine to each Pi.

There are small problems like watch status and bookmarks but the reason i do this and not mySQL is complicated.

The problem is after updating each box the Pi boxes start going crazy and hammering my Nas:

Code:

10:05:32 T:2816992144   DEBUG: DoWork - trying to extract filestream details from video file -NAS LOCATION OF FILE-
10:05:32 T:2816992144   DEBUG: CFileCache::Open - opening <-NAS LOCATION OF FILE-> using cache
10:05:32 T:2590512016   DEBUG: Thread FileCache start, auto delete: false
10:05:32 T:2816992144   DEBUG: Open - probing detected format [mov,mp4,m4a,3gp,3g2,mj2]
10:05:37 T:2816992144   DEBUG: Seek - waiting for position 1554497611.
10:05:37 T:2590512016    INFO: CFileCache::Process - Hit eof.
10:05:37 T:2816992144    INFO: ffmpeg[A7E7E390]: [mov,mp4,m4a,3gp,3g2,mj2] Protocol name not provided, cannot determine if input is local or a network protocol, buffers and access patterns cannot be configured optimally without knowing the protocol
10:05:38 T:2816992144   DEBUG: Open - avformat_find_stream_info starting
10:05:38 T:2816992144   DEBUG: Open - av_find_stream_info finished
10:05:38 T:2816992144    INFO: ffmpeg[A7E7E390]: Input #0, mov,mp4,m4a,3gp,3g2,mj2, -NAS LOCATION OF FILE-':
10:05:38 T:2816992144    INFO: ffmpeg[A7E7E390]:   Metadata:
10:05:38 T:2816992144    INFO: ffmpeg[A7E7E390]:     major_brand     : isom
10:05:38 T:2816992144    INFO: ffmpeg[A7E7E390]:     minor_version   : 1
10:05:38 T:2816992144    INFO: ffmpeg[A7E7E390]:     compatible_brands: isomavc1
10:05:38 T:2816992144    INFO: ffmpeg[A7E7E390]:     creation_time   : 2015-09-11 04:12:32
10:05:38 T:2816992144    INFO: ffmpeg[A7E7E390]:   Duration: 01:40:53.33, start: 0.000000, bitrate: 2054 kb/s
10:05:38 T:2816992144    INFO: ffmpeg[A7E7E390]:     Stream #0:0(und): Video: h264 (High) (avc1 / 0x31637661), yuv420p(tv, bt709/bt709/unknown), 1920x800, 1956 kb/s, 23.98 fps, 23.98 tbr, 24k tbn, 47.95 tbc (default)
10:05:38 T:2816992144    INFO: ffmpeg[A7E7E390]:     Metadata:
10:05:38 T:2816992144    INFO: ffmpeg[A7E7E390]:       creation_time   : 2015-09-11 04:12:32
10:05:38 T:2816992144    INFO: ffmpeg[A7E7E390]:       handler_name    : video.264#trackID=1:fps=23.976 - Imported with GPAC 0.5.0-rev
10:05:38 T:2816992144    INFO: ffmpeg[A7E7E390]:     Stream #0:1(eng): Audio: aac (LC) (mp4a / 0x6134706D), 48000 Hz, stereo, fltp, 93 kb/s (default)
10:05:38 T:2816992144    INFO: ffmpeg[A7E7E390]:     Metadata:
10:05:38 T:2816992144    INFO: ffmpeg[A7E7E390]:       creation_time   : 2015-09-11 04:12:44
10:05:38 T:2816992144    INFO: ffmpeg[A7E7E390]:       handler_name    : GPAC ISO Audio Handler
10:05:38 T:2816992144   DEBUG: CDVDDemuxFFmpeg::AddStream(0, ...) -> 0
10:05:38 T:2816992144   DEBUG: CDVDDemuxFFmpeg::AddStream(1, ...) -> 1
10:05:38 T:2590512016   DEBUG: Thread FileCache 2590512016 terminating

Each box tries to do this for every video, when i leave my windows instance idle it doesn't try at all? I monitored the *.db on the Pi's and it looks like its populating the streamdetails table?

why doesn't the windows instance do it?

Thanks!

[apeg]

So it looks like my problem is:

Code:

Container.Refresh()

I call that on the movies collection each box after the new video library is copied over. That seems to trigger a full refresh of the streamdetails table.

back to the drawing board lol

[nickr]

Mysql is not complicated. Just do it.

[apeg]

Mysql is not complicated. Just do it.

I didn't mean mySQL is too complicated, i meant the reason for not using it is complicated. I have used mySQL for years... but there are advantages to a local DB.

I ended up preserving the streamdetails table on DB swap and problem solved. It hammers the 1st time but never again after that.

Thanks,