Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - bulek

Pages: 1 [2] 3 4 ... 60
16
Users / Re: Huge query in pluto_media : taking my disk down to crawling
« on: September 21, 2013, 11:15:05 pm »
Hi,

here are the results for my database:

Quote
mysql> select count(*) from Picture_File;
+----------+
| count(*) |
+----------+
|     3999 |
+----------+
1 row in set (0.04 sec)

mysql> select count(*) from File;
+----------+
| count(*) |
+----------+
|  2422647 |
+----------+
1 row in set (1.37 sec)

mysql> select count(*) from File_Attribute;
+----------+
| count(*) |
+----------+
|    41181 |
+----------+
1 row in set (0.34 sec)

mysql> select count(*) from LongAttribute;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.02 sec)


Regards,
Bulek.

17
Users / Re: Huge query in pluto_media : taking my disk down to crawling
« on: September 21, 2013, 10:20:49 am »
Hi,

I'm sorry I cannot help on this one. Thanks for your efforts...

Regards,

Bulek.

18
Users / Re: Huge query in pluto_media : taking my disk down to crawling
« on: September 21, 2013, 12:58:32 am »
Hi,

both disks are sata. First is system disk, the second is for media (2T)... First one is about half full, second aroung 75%. I doubt I have the biggest media collection. When disk is fast enough (when that huge query is not slowing it down), then Orbiter doesn't crash. It probably gets all data within timeout... But I have a feeling, that all media is retrieved at that moment, although only subset will be shown on screen...

I've disabled UpdateMediaDaemon from command line (Radu just gave me a hint that check in web-admin is broken) and will see if that query will come back again....



Thanks in advance,

regards,

Bulek.
 

19
Hi,

thanks for info. Does this mean that Raspberry PI with xbmc can be used as a sort of light Media browser/player for Dianemo and that media can be pushed to it ?

How do you find Raspberry PI as media player? Can it cope with videos ?

Thanks in advance,
regards,
Bulek.

20
Users / Huge query in pluto_media : taking my disk down to crawling
« on: September 20, 2013, 09:51:05 am »
Hi,

I've posted a thread about freqent crashes when clicking on Video button on main Orbiter screen... Crash came out of data not being available in reasonable time - and cause is that my disk is so slooow...

But I guess this is not the HW problem, but more SW. if I do this :
Code: [Select]
hdparm -tT /dev/sda
/dev/sda:
 Timing cached reads:   3548 MB in  2.00 seconds = 1771.32 MB/sec
 Timing buffered disk reads:  10 MB in  3.17 seconds =   3.15 MB/sec

When this happens, I get frequent crashes in media browsers on Orbiter, have unresponsive Orbiter (needs 30+ secs to get from screensaver to Orbiter screen), etc....

When second parameter is >60MB/sec, everything is working much faster and ok...

Now what is slowing my disk down ?
when I do
Code: [Select]
iotop -oP I see that mysqld is producing massive amount of disk writes and reads (I always thought this is pretty normal, till Radu didn't check his machines and we compared...) - approx. 5-10 M/s...

when I check what mysql is doing with :
Code: [Select]
mysql
show full processlist;

I see that there is a massive sql query going on, probably taking all that massive amount of disk accesses...

Quote
|   594 | root   | localhost | pluto_media    | Query   |  1623 | Sorting result | SELECT PK_File, Path, Filename, INode,
MAX(PSC_MOD) As CurrentDbAttrDate,
(1000000 * SUM(BOOKMARKS) + 10000 * SUM(ATTRIBUTES) + 100 * SUM(LONG_ATTRIBUTES) + SUM(PICTURES)) AS CurrentDbAttrCount,
(SUM(ATTRIBUTES) + SUM(LONG_ATTRIBUTES)) AS HasAttributes,
AttrDate AS OldDbAttrDate, AttrCount AS OldDbAttrCount, ModificationDate AS OldFileDate,
Source
FROM
(
        (
                SELECT PK_File, Path, Filename, INode, Source, Missing,
                        AttrDate, AttrCount, ModificationDate,
                        MAX(IF(Bookmark.psc_mod IS NULL,CAST('0000-00-00 00:00:00' AS DATE), Bookmark.psc_mod)) AS PSC_MOD,
                        COUNT(Bookmark.PK_Bookmark) AS BOOKMARKS,
                        0 AS ATTRIBUTES, 0 AS LONG_ATTRIBUTES, 0 AS PICTURES
                FROM File
                LEFT JOIN Bookmark ON Bookmark.FK_File = PK_File
                WHERE 1 = 1 AND (Path LIKE '/home/public/data%' OR (Path = '/home/public' AND Filename = 'data' )  OR Path LIKE '/home/user_1/data%' OR (Path = '/home/user_1' AND Filename = 'data' )  OR Path LIKE '/home/user_2/data%' OR (Path = '/home/user_2' AND Filename = 'data' )  OR Path LIKE '/home/user_3/data%' OR (Path = '/home/user_3' AND Filename = 'data' )  OR Path LIKE '/home/user_4/data%' OR (Path = '/home/user_4' AND Filename = 'data' )  OR Path LIKE '/home/user_5/data%' OR (Path = '/home/user_5' AND Filename = 'data' )  OR Path LIKE '/home/user_6/data%' OR (Path = '/home/user_6' AND Filename = 'data' )  OR Path LIKE '/home/user_7/data%' OR (Path = '/home/user_7' AND Filename = 'data' )  OR Path LIKE '/home/user_8/data%' OR (Path = '/home/user_8' AND Filename = 'data' )  )  AND Missing = 0
                GROUP BY PK_File, Path, Filename, INode,  AttrDate, AttrCount, ModificationDate
        )
UNION
        (
                SELECT PK_File, Path, Filename, INode, Source, Missing,
                        AttrDate, AttrCount, ModificationDate,
                        MAX(IF(Attribute.psc_mod IS NULL,CAST('0000-00-00 00:00:00' AS DATE), Attribute.psc_mod)) AS PSC_MOD,
                        0 AS BOOKMARKS,
                        COUNT(PK_Attribute) AS ATTRIBUTES,
                        0 AS LONG_ATTRIBUTES, 0 AS PICTURES
                FROM File
                LEFT JOIN File_Attribute ON File_Attribute.FK_File = PK_File
                LEFT JOIN Attribute ON File_Attribute.FK_Attribute = PK_Attribute
                WHERE 1 = 1 AND (Path LIKE '/home/public/data%' OR (Path = '/home/public' AND Filename = 'data' )  OR Path LIKE '/home/user_1/data%' OR (Path = '/home/user_1' AND Filename = 'data' )  OR Path LIKE '/home/user_2/data%' OR (Path = '/home/user_2' AND Filename = 'data' )  OR Path LIKE '/home/user_3/data%' OR (Path = '/home/user_3' AND Filename = 'data' )  OR Path LIKE '/home/user_4/data%' OR (Path = '/home/user_4' AND Filename = 'data' )  OR Path LIKE '/home/user_5/data%' OR (Path = '/home/user_5' AND Filename = 'data' )  OR Path LIKE '/home/user_6/data%' OR (Path = '/home/user_6' AND Filename = 'data' )  OR Path LIKE '/home/user_7/data%' OR (Path = '/home/user_7' AND Filename = 'data' )  OR Path LIKE '/home/user_8/data%' OR (Path = '/home/user_8' AND Filename = 'data' )  )  AND Missing = 0
                GROUP BY PK_File, Path, Filename, INode,  AttrDate, AttrCount, ModificationDate
        )
UNION
        (
                SELECT PK_File, Path, Filename, INode, Source, Missing,
                        AttrDate, AttrCount, ModificationDate,
                        MAX(IF(LongAttribute.psc_mod IS NULL,CAST('0000-00-00 00:00:00' AS DATE), LongAttribute.psc_mod)) AS PSC_MOD,
                        0 AS BOOKMARKS, 0 AS ATTRIBUTES,
                        COUNT(PK_LongAttribute) AS LONG_ATTRIBUTES,
                        0 AS PICTURES
                FROM File
                LEFT JOIN LongAttribute ON LongAttribute.FK_File = PK_File
                WHERE 1 = 1 AND (Path LIKE '/home/public/data%' OR (Path = '/home/public' AND Filename = 'data' )  OR Path LIKE '/home/user_1/data%' OR (Path = '/home/user_1' AND Filename = 'data' )  OR Path LIKE '/home/user_2/data%' OR (Path = '/home/user_2' AND Filename = 'data' )  OR Path LIKE '/home/user_3/data%' OR (Path = '/home/user_3' AND Filename = 'data' )  OR Path LIKE '/home/user_4/data%' OR (Path = '/home/user_4' AND Filename = 'data' )  OR Path LIKE '/home/user_5/data%' OR (Path = '/home/user_5' AND Filename = 'data' )  OR Path LIKE '/home/user_6/data%' OR (Path = '/home/user_6' AND Filename = 'data' )  OR Path LIKE '/home/user_7/data%' OR (Path = '/home/user_7' AND Filename = 'data' )  OR Path LIKE '/home/user_8/data%' OR (Path = '/home/user_8' AND Filename = 'data' )  )  AND Missing = 0
                GROUP BY PK_File, Path, Filename, INode,  AttrDate, AttrCount, ModificationDate
        )
UNION
        (
                SELECT PK_File, Path, Filename, INode, Source, Missing,
                        AttrDate, AttrCount, ModificationDate,
                        MAX(IF(Picture_File.psc_mod IS NULL,CAST('0000-00-00 00:00:00' AS DATE), Picture_File.psc_mod)) AS PSC_MOD,
                        0 AS BOOKMARKS, 0 AS ATTRIBUTES, 0 AS LONG_ATTRIBUTES,
                        COUNT(FK_Picture) AS PICTURES
                FROM File
                LEFT JOIN Picture_File ON Picture_File.FK_File = PK_File
                WHERE 1 = 1 AND (Path LIKE '/home/public/data%' OR (Path = '/home/public' AND Filename = 'data' )  OR Path LIKE '/home/user_1/data%' OR (Path = '/home/user_1' AND Filename = 'data' )  OR Path LIKE '/home/user_2/data%' OR (Path = '/home/user_2' AND Filename = 'data' )  OR Path LIKE '/home/user_3/data%' OR (Path = '/home/user_3' AND Filename = 'data' )  OR Path LIKE '/home/user_4/data%' OR (Path = '/home/user_4' AND Filename = 'data' )  OR Path LIKE '/home/user_5/data%' OR (Path = '/home/user_5' AND Filename = 'data' )  OR Path LIKE '/home/user_6/data%' OR (Path = '/home/user_6' AND Filename = 'data' )  OR Path LIKE '/home/user_7/data%' OR (Path = '/home/user_7' AND Filename = 'data' )  OR Path LIKE '/home/user_8/data%' OR (Path = '/home/user_8' AND Filename = 'data' )  )  AND Missing = 0
                GROUP BY PK_File, Path, Filename, INode, AttrDate, AttrCount, ModificationDate
        )
) AS FILE_UNION
WHERE 1 = 1 AND (Path LIKE '/home/public/data%' OR (Path = '/home/public' AND Filename = 'data' )  OR Path LIKE '/home/user_1/data%' OR (Path = '/home/user_1' AND Filename = 'data' )  OR Path LIKE '/home/user_2/data%' OR (Path = '/home/user_2' AND Filename = 'data' )  OR Path LIKE '/home/user_3/data%' OR (Path = '/home/user_3' AND Filename = 'data' )  OR Path LIKE '/home/user_4/data%' OR (Path = '/home/user_4' AND Filename = 'data' )  OR Path LIKE '/home/user_5/data%' OR (Path = '/home/user_5' AND Filename = 'data' )  OR Path LIKE '/home/user_6/data%' OR (Path = '/home/user_6' AND Filename = 'data' )  OR Path LIKE '/home/user_7/data%' OR (Path = '/home/user_7' AND Filename = 'data' )  OR Path LIKE '/home/user_8/data%' OR (Path = '/home/user_8' AND Filename = 'data' )  )  AND Missing = 0
GROUP BY PK_File, Path, Filename, INode, AttrDate, AttrCount, ModificationDate |

My first question (dillema) is whether I'm chasing a ghost here and this is pretty normal or is there something to be checked further...

I'm on Dianemo S, but I guess this part of the system is pretty similar to LMCE also...

Any advice would help me a lot. My system is useless when this happens and it happens quite often (or all the time)...

Thanks in advance,

regards,

Bulek.

Edit: I think that Radu found the origin of this query (or similar one when we talked about it) here :
http://svn.linuxmce.org/trac.cgi/browser/trunk/src/UpdateMedia/MediaState.cpp    line 59....



21
Users / Re: Dianemo S (maybe LMCE): problem with large video collection ?
« on: September 20, 2013, 09:38:14 am »
Hi,

I did some further research (with the help of Dianemo's Radu) and we found out that slow disk is causing this.

If after x secs video data is not retrieved, then DCERouter crashes thinking of deadlock...

I've written my finidings about slow disk in other thread...

Regards,

Bulek.

22
Marketplace / Re: Dianemo S10.10 license for sale
« on: May 13, 2013, 10:55:28 pm »
Wombiroller has asked me to state that the item is sold.

Bulek.

23
Users / Dianemo S (maybe LMCE): problem with large video collection ?
« on: April 30, 2013, 12:13:19 am »
Hi,

I'm spotting frequent crashes when I try to enter Video collection media browser. I always try this on main Screen Orbiter... I get either really slow response for first screen or even get DCERouter crash, cause obviously mysql query didn't finish in planned time and DCERouter restarts...

Anyone with similar size of collection? Any other advice ?

Regards,

Bulek.

24
Users / Re: Dianemo S: Logitech Media Server and tags problems
« on: April 23, 2013, 09:42:13 am »
Andrew,

is LMS taking care only of audio files? Somewhere between updates I got into empty Video file list if I set sort by filename... Also, I think that only a subset of files appear when I select by author... All views are empty...

Thanks in advance,

regards,

Bulek.

25
Users / Re: Dianemo S: Logitech Media Server and tags problems
« on: April 18, 2013, 09:18:07 pm »
Hi,

thanks for response. Will contact Radu and sort out the problem... I was just curious if anyone else spotted similar problem...

Regards,

Bulek.

26
Users / Re: Motion and masks
« on: April 16, 2013, 08:07:17 pm »
Hi,

under Dianemo we have KMotion now. But I still remember that motion did movies into /home/cameras tree. Somewhere deeper are jpegs, higher are avi's...

I still have this settins under Motion Wrapper device ("Extra Parameters") :

Quote
#extra parameters defined by user

#image settings
frequency 0
rotate 0
width 320
height 240
framerate 10
auto_brightness on
brightness 128
contrast 128
saturation 128
hue 128

#http control
control_localhost off
control_html_output on
control_port 8888

#filters
despeckle EedDl
lightswitch 50
minimum_motion_frames 5

#detection
noise_tune on
threshold_tune on
smart_mask_speed 5
gap 5
post_capture 5
pre_capture 3

#output
locate on
text_double on
webcam_quality 70
webcam_maxrate 5
text_changes on
text_right %d-%m-%Y\\\\n%T

#movies
ffmpeg_cap_new on
ffmpeg_timelapse 60
ffmpeg_timelapse_mode daily
#ffmpeg_video_codec msmpeg4

#snapshot config
snapshot_interval 60
snapshot_filename %Y/%m/%d/%H/%M_%S
jpeg_filename %Y/%m/%d/%H/%M_%S
movie_filename movies/%d_%m_%Y_%H_%M_%S
timelapse_filename %Y/%m/%d-timelapse

Maybe you can figure out what you need for your case...

HTH,

regards,

Bulek.


27
Users / Dianemo S: Logitech Media Server and tags problems
« on: April 16, 2013, 12:32:08 pm »
Hi,

I'm not sure to what extent this also applies for LMCE, but I'm having a lot of problems under Dianemo S that currently switched to Logitech Media Server as internal music system...

First of all, the main problem is that my collection is not properly tagged and I'm waiting for option to use it via Folder structure... But that's another story... I'm trying to tag my collection as much as possible correctly, but have problems...

I've tagged few folders with mp3, wav and flac files. Then I tried to use LMS to rescan library and encountered following problems :
1. LMS behaves strange when you do only "scan for new and changed" media files. It finds all files, but when it should end scan it waits there forever... I have to abort scan. What I've learned is that it's recomendable to do full rescan each time...

2. if I scan only specific folder then all tag data seem to appear correctly on LMS (I'm not doing anything on Dianemo yet)... But when I do rescan of whole library (all folders) then my data from specific folder don't appear anymore... There are few errors about incorrect tag values on some files, but I guess this shouldn't interfere with files that are correctly tagged... But obviously something is wrong...

Anyone with same or similar problems ? Any advice ?

Thanks in advance,

regards,

Bulek.

28
Bulek,

with an original LinuxMCE setup, you could add another genre to all these files, and they could be selected using this additional genre. No idea if that is supported under the Dianemo scheme of things.
Thanks for info... I guess that Dianemo depends on features that are offered by Logitech Media Server and for now, I couldn't find any way to do this... But who knows...

Regards,
Bulek.

29
We have released an update that further integrates Logitech Media Server into Dianemo. We now use LMS to scan your audio media library and we then read the LMS database for any mp3 tag metadata. UpdatedMedia then uses that meta data directly. This means that Dianemo's internal DB get's better meta data about the audio tracks in your library and remains in sync with LMS now.

Another advantage we get from this tight integration with LMS is the tighter coupling with your iTunes audio library if you are an iTunes user. If you have stored your iTunes library on a storage device that is managed by your Dianemo NC then you will see in your Orbiters exactly the same meta data about your music that iTunes see's as we leverage LMS's ability to read iTunes meta data. This symbiotic relationship with LMS is dynamic in that as LMS scans for new material in your media library Dianemo will see those changes too and your Orbiter's will display them - this applies to music track and also to iTunes Playlists.

I know lot's of you have been asking for better playlist integration and also for a way to get your iTunes playlists into Dianemo... if you're one of those people you will be very happy with this update! If you already have a large number of playlists created in iTunes this allows you to replicate those in your Dianemo Orbiters and use then directly in your Dianemo S system. As you edit playlists in iTunes (or on a iOS device thats sync'd with iTunes) your changes will be picked up by Dianemo (it may take about 10 mins for changes to be reflected in your Orbiters).

Expect further announcements about integration with LMS in the coming months. There will be a new Dianemo S wiki page entry covering LMS integration shortly.

Don't forget to run the updater script regularly to get this update and future ones too.

All the best


Andrew

**Note; Make sure you configure LMS to use your audio media directory otherwise you will not get any meta data.
Hi,

I'm a bit disappointed with this enhancement :-( .

We've lost possibility to sort/browse music collection by filename that we were using for at least few years now. WAF (Wife Acceptance Factor) for our system is now much lower.... Any chance that user can retain/select older Audio collection behaviour ?

Right now, beside collection being organized by genre (domestic, foreign, pop,rock, ...) we also have certain directories where kids have stored their own mp3s. They are from different genres - how can I integrate that into collection without using Directory structure ? Can I use any other attribute for that to denote those files for daughter's files that can be easily selected from new interface ?

Regards,

Bulek.

30
Hi,

I'm trying it on Dianemo and seems that something is missing in Dianemo... I've entered credentials and then did Validate Credentials...

What should happen next if it works ?
I have all choices empty in Orbiter Specific section....

Thanks,

regards,

Bulek.

Pages: 1 [2] 3 4 ... 60