Hmm, not sure if that is correctly !? Did you install from the DVD ?

I was upgrading from alpha 2.37 to beta2.  I also did a fresh net install on a virtual machine, I'll be testing a fresh DVD install in a virtual machine this evening when I get home from work.

The current installer is adding the avenard 'release' repo during a net or dvd installation.

From pre-install-from-repo.sh and pre-install-from-dvd.sh

Code:

AddRepoToSources "http://www.avenard.org/files/ubuntu-repos intrepid release"

J.

lmce and avenard are seperate repositories but lmce is using the avenard repositories for nvidia drivers, libvdpau & mythtv.  You should have the avenard 'release' repo in your sources.list.  The lmce repository has also been updated and should automatically be changed during the upgrade to beta2.

J.

When I was testing my wiimote with lmce there was no 'pairing' of the remote to lmce.  I could use the wiimote with lmce by pressing the 1&2 buttons to activate it (as long as my wii was not on) and then I could still use it with the wii by pressing the power button on the wiimote.  So as long as your wii is off and you don't press the power button you should be able to use it with LMCE or the wii.  YMMV.

J.

Orbitergen ran for 1 hour on my p4 2.8 (make sure you wait for it) through all of that time I had a black screen with a white mouse cursor.  After orbitergen finished the media director services did not start up.

I rebooted after orbitergen finished (I watched it running in 'top' from an ssh session) and my system started up perfectly.

http://forum.linuxmce.org/index.php?topic=9232.0

J.

After an hour Orbitergen finished and I am left with a black screen with white mouse cursor.  (My heart sank.)  Both my diskless MDs (not yet updated)  were woken with WOL and seem to function properly.

After I was certain all upgrade activity had ceased I rebooted one more time and orbiter came up just fine.  At first glance everything seems okay and I'm going to update my MDs next.  I think I may do a rebuild on them.

Anyways, still up and running...

J.

Alright, I was upgrading from Alpha 2.37 and had a minor hiccup during the upgrade.

A mythtv related script has moved from one package to another which has caused an upgrade hiccup.  Here's my experience:

Code:

# apt-get update
# apt-get dist-upgrade

After downloading for about 45 minutes apt began updating packages but failed, a window opened telling me that "lmce-mythtv-scripts 2.0.0.44.09112922522 had failed to install or upgrade."

So I performed another dist-upgrade and watched the screen as it failed again (and left other packages not upgraded):

Code:

Unpacking lmce-mythtv-scripts (from .../lmce-mythtv-scripts_2.0.0.44.09112922522_i386.deb) ...
dpkg: error processing /var/cache/apt/archives/lmce-mythtv-scripts_2.0.0.44.09112922522_i386.deb (--unpack):
 trying to overwrite `/usr/pluto/bin/SaveMythRecording.sh', which is also in package pluto-mythtv-player

Now almost all of the packages have been updated but... I performed another dist-upgrade and watched the screen:

Code:

You might want to run `apt-get -f install' to correct these.
The following packages have unmet dependencies:         
  pluto-mythtv-player: Depends: lmce-mythtv-scripts (>= 2.0.0.44) but it is not installed 
                       Depends: lmce-mythtv-scripts (< 2.0.0.45) but it is not installed           
  pluto-mythtv-plugin: Depends: lmce-mythtv-scripts (>= 2.0.0.44) but it is not installed
                       Depends: lmce-mythtv-scripts (< 2.0.0.45) but it is not installed   
E: Unmet dependencies. Try using -f.             

All other packages have been updated at this point, so then I did an "apt-get -f install" and it installed the lmce-mythtv-scripts package successfully.

I used apt-get, "aptitude dist-upgrade" may have been able to deal with the removal/install ordering better, I'm not sure.

I rebooted and am currently waiting for orbiter to regenerate.

J.

Just did an 'apt-get update' on my core only to find a whole bunch of lmce updates.  

I checked the webpage and it shows LinuxMCE Beta 2.  Congrats on Beta 2 guys!

I'm going to update my core momentarily and report my progress.

J.

LMCE has a script which automaticlly restarts mythbackend when it dies, except when mythtv-setup is running.  The script is:

/usr/pluto/bin/Restart_MythBackend.sh

You will have to kill this script before you stop mythbackend and do your scan or mythbackend will automatically restart and lock your dvb adaptors again.

J.

Sounds like a udev rules issue.  Unfortunately that's all the insight I can offer because I've never had the need to investigate udev rules myself.

My understanding is that udev populates the links automatically based on detected hardware and may simply not be aware of what to do with your card.  I believe you may simply have to tell udev what to do with your card...  But again I've never investigated this further.  Something to investigate.

J.

How are you determining the amount of cache space consumed by the query?

You can monitor the status of the query cache like this:

Code:

mysql> SHOW STATUS LIKE 'Qcache%';
+-------------------------+----------+
| Variable_name           | Value    |
+-------------------------+----------+
| Qcache_free_blocks      | 16       |
| Qcache_free_memory      | 13297728 |
| Qcache_hits             | 57112    |
| Qcache_inserts          | 5118     |
| Qcache_lowmem_prunes    | 0        |
| Qcache_not_cached       | 31260    |
| Qcache_queries_in_cache | 1951     |
| Qcache_total_blocks     | 3978     |
+-------------------------+----------+
8 rows in set (0.00 sec)

And with out the filter you can see more mysql information.

Code:

SHOW STATUS;

I would have assumed that the query to create the collection of files would not have also retrieved the artwork. Only once Orbiter determines how many and which files are needed for the onscreen grid would it then query and return the artwork for those files only. In which case the artwork assigned shouldn't matter.....

Yes, you are correct as far as I can tell.  I don't see this being artwork related with the behaviour I'm observing.

J.

Okay, the two queries are large but I see what they're doing, they're too large to post here so I've put them on pastebin.

The audio query results from mysql-slow.log show each query took 6 seconds to execute:
# Time: 091117 19:44:46
# User@Host: root[root] @ localhost []
# Query_time: 6  Lock_time: 0  Rows_sent: 627  Rows_examined: 117280

The video query from mysql-slow.log:
# Time: 091117 19:44:56
# User@Host: root[root] @ localhost []
# Query_time: 6  Lock_time: 0  Rows_sent: 8594  Rows_examined: 954413

The audio query results of the EXPLAIN EXTENDED & SHOW WARNINGS> http://pastebin.com/f5efcf4a7
The video query results of the EXPLAIN EXTENDED & SHOW WARNINGS> http://pastebin.com/f711a0612

The audio and video query results clearly show temporary tables being used rather than indexes.

J

Predominantly my Windows Orbiter.

The behaviour:
device, time uncached, time cached
WinOrbiter, ~7s, <1s (UI1)
Nokia N800, ~10s, ~3s (UI1)
WebDT 366, ~7s, ~2s (UI1)
p42.8 Core, ~7s, <1s (UI2 mask)
Zotac ION MD, ~7, <1s (UI2 mask)

When the query is executed and not present in the cache, top shows mysql using 90-100% of the processor for nearly the entire 7s time period, and it doesn't even show up as a blip in top when the query is in the cache.  I'm about to investigate some of the slow query logging options Viking pointed out and see what I can find out.

J.

Artwork may be a contributing factor then, almost all of my media has artwork.  I can see the memory being allocated for the query in mysql when I select Audio or Video button in orbiter (takes ~7s).  The Audio query occupies a about 570Kb in the cache on my system.  I return to the home menu and select audio, the artists now display in about 0.5s.  As I monitor the cache in mysql after a couple minutes a 570kb chunk is freed from the cache memory.  Selecting audio again takes ~7s and about 570kb is added to the query_cache.  Mysql is abosolutely removing the query from the cache every few minutes on my system.  I'm not home from work yet but I'm going to dig around a bit more when I get home.

J.

Thanks Viking, I'll do some more investigating when I get home from work.

J.

Without actually looking, I think I have about 600 videos and around 800 or 900 artists in my audio folders.

The response time is the same regardless of the orbiter I use (n800,webdt,onscreen), UI1 or 2, core or MD.  It takes about 7 seconds from click/touch to display of the datagrid.  When I do this the query is cached by query_cache in mysql and choosing audio/video again immediately is very responsive from click/touch to display of the datagrid, 0.5 seconds on my windows orbiter to about 3 seconds on my WebDT.  Response is the same now as it was under 0710, I'm currently running 0810 Alpha 2.37.

The responsiveness lasts for a couple minutes, until the query is removed from the cache, and then it takes about 7 seconds to re-rerun the query and re-store the results in mysql query_cache for another couple of minutes.  I can only assume that UpdateMedia is writing to the table but I'm speculating.

J.