Author Topic: Orbiter crash when retrieving video list  (Read 5148 times)

mhorst

  • Veteran
  • ***
  • Posts: 72
    • View Profile
Orbiter crash when retrieving video list
« on: November 23, 2009, 08:08:59 pm »
Hello,

For some reason my Orbiter crashes when I select Media - Video.
The problem already occurred intermittently in the past, but recently I haven't been able to open the list of videos at all.

My experience was that this crash only occurs after my media director has rebooted. If I select Media - Video and it works, then it will stay working, otherwise it will crash immediately. Unfortunately, the last few days it always crashed :(

I suspect it may have to do with the number of video files that I have, since that is the only thing that (I think) has changed.
Because I have not yet tagged all my videos I always switched to the Filename sort order. That may explain why subsequent openings of the video list always succeeded; because of the directory structure there wouldn't be too many files in it at once.

Anyway, I don't have any problems with Media - Audio, that one always works.

I checked the logging files, but I'm not experienced enough in LinuxMCE yet to make much of them. I included the sections I think are relevant below.

The LaunchOrbiter.sh.log on the media director:
Code: [Select]
========== NEW LOG SECTION ==========
1 11/23/09 19:56:54 51 (spawning-device) Starting... 1
1 11/23/09 19:56:55 51 (spawning-device) Found /usr/pluto/bin/LaunchOrbiter.sh
05 11/23/09 19:57:00.128 will overwrite wm window id // void X11wrapper::Assign_WmWindow(Window) <0xb56ffb90>
05 11/23/09 19:57:00.153 Using masked UI? YES <0xb56ffb90>
01 11/23/09 19:57:01.896 qqq Pixmap_Create 0,0,1280,720 transparent (reset), wmwindow 0xa0000e <0xb6052b90>
05 11/23/09 19:57:01.927 Creating child 52 <0xb60936e0>
05 11/23/09 19:57:02.087 Creating child 54 <0xb60936e0>
05 11/23/09 19:57:02.152 Creating child 55 <0xb60936e0>
05 11/23/09 19:57:02.225 Creating child 56 <0xb60936e0>
05 11/23/09 19:57:02.289 Creating child 57 <0xb60936e0>
05 11/23/09 19:57:04.652 FocusOut! <0xb60936e0>
05 11/23/09 19:57:05.063 FocusIn! <0xb60936e0>
05 11/23/09 19:57:05.292 FocusOut! <0xb60936e0>
01 11/23/09 19:57:40.563 Socket::ReceiveData-a 0xb570b938 failed ret 0 <0xb424bb90>
05 11/23/09 19:57:40.563 Socket::ReceiveString2 ReceiveData failed m_Socket: -1 Event Dev #51 <0xb424bb90>
05 11/23/09 19:57:40.563 Socket::SendReceiveMessage didn't get valid response ReceiveData failed <0xb424bb90>
05 11/23/09 19:57:40.563 InternalSendCommand cannot send with return message.  type 1 id 35 to 6 Going to quit <0xb424bb90>
05 11/23/09 19:57:40.563 Orbiter reloading... <0xb424bb90>
05 11/23/09 19:57:40.563 Orbiter quiting... <0xb424bb90>
05 11/23/09 19:57:40.563 Socket::SendData socket is invalid <0xb424bb90>
05 11/23/09 19:57:40.563 Socket::SendMessage *failed to send* type 7 id 0 from 51 to 52 <0xb424bb90>
05 11/23/09 19:57:40.564 Socket::SendData socket is invalid <0xb424bb90>
05 11/23/09 19:57:40.564 Socket::SendMessage *failed to send* type 7 id 0 from 51 to 54 <0xb424bb90>
05 11/23/09 19:57:40.564 Socket::SendData socket is invalid <0xb424bb90>
05 11/23/09 19:57:40.564 Socket::SendMessage *failed to send* type 7 id 0 from 51 to 55 <0xb424bb90>
05 11/23/09 19:57:40.564 Socket::SendData socket is invalid <0xb424bb90>
05 11/23/09 19:57:40.564 Socket::SendMessage *failed to send* type 7 id 0 from 51 to 56 <0xb424bb90>
05 11/23/09 19:57:40.564 Socket::SendData socket is invalid <0xb424bb90>
05 11/23/09 19:57:40.564 Socket::SendMessage *failed to send* type 7 id 0 from 51 to 57 <0xb424bb90>
05 11/23/09 19:57:40.564 Got an on quit.  Pushing an event into SDL <0xb424bb90>
05 11/23/09 19:57:40.564 Got an on quit.  Pushing an event into SDL <0xb424bb90>
05 11/23/09 19:57:40.564 Populate datagrid: 63 failed <0xb424bb90>
05 11/23/09 19:57:40.791 XRecordExtensionHandler::recordingThreadMainFunction(): pDisplay_ControlConnection=159222696, pDisplay_DataConnection=159235296 ->Closing <0xb09fdb90>
05 11/23/09 19:57:40.792 XRecordExtensionHandler::recordingThreadMainFunction(): pDisplay_ControlConnection=159222696, pDisplay_DataConnection=159235296 ->Closed <0xb09fdb90>
05 11/23/09 19:57:45.345 Socket::SendData socket is invalid <0xb60936e0>
05 11/23/09 19:57:45.345 Socket::SendMessage *failed to send* type 1 id 255 from 51 to 9 <0xb60936e0>
05 11/23/09 19:57:45.345 InternalSendCommand cannot send with return message.  type 1 id 255 to 9 Going to quit <0xb60936e0>
05 11/23/09 19:57:45.345 Orbiter reloading... <0xb60936e0>
05 11/23/09 19:57:45.345 Orbiter quiting... <0xb60936e0>
05 11/23/09 19:57:45.345 Socket::SendData socket is invalid <0xb60936e0>
05 11/23/09 19:57:45.345 Socket::SendMessage *failed to send* type 7 id 0 from 51 to 52 <0xb60936e0>
05 11/23/09 19:57:45.345 Socket::SendData socket is invalid <0xb60936e0>
05 11/23/09 19:57:45.345 Socket::SendMessage *failed to send* type 7 id 0 from 51 to 54 <0xb60936e0>
05 11/23/09 19:57:45.345 Socket::SendData socket is invalid <0xb60936e0>
05 11/23/09 19:57:45.345 Socket::SendMessage *failed to send* type 7 id 0 from 51 to 55 <0xb60936e0>
05 11/23/09 19:57:45.345 Socket::SendData socket is invalid <0xb60936e0>
05 11/23/09 19:57:45.346 Socket::SendMessage *failed to send* type 7 id 0 from 51 to 56 <0xb60936e0>
05 11/23/09 19:57:45.346 Socket::SendData socket is invalid <0xb60936e0>
05 11/23/09 19:57:45.346 Socket::SendMessage *failed to send* type 7 id 0 from 51 to 57 <0xb60936e0>
05 11/23/09 19:57:45.346 Got an on quit.  Pushing an event into SDL <0xb60936e0>
05 11/23/09 19:57:45.346 Got an on quit.  Pushing an event into SDL <0xb60936e0>
05 11/23/09 19:57:45.830 void ClientSocket::Disconnect() on this socket: 0x972b450 (m_Socket: 16) <0xb60936e0>
Return code: 2
2 11/23/09 19:57:45 51 (spawning-device) Device requests restart... count=1/50 dev=51
Mon Nov 23 19:57:46 CET 2009 Restart

The DCERouter.log:
Code: [Select]
08      11/23/09 19:57:20.531           Received Message from 118 (ESC[36;1mmce_usb2 / Living RoomESC[0m) to 51 (ESC[36;1mOnScreen
 Orbiter / Living RoomESC[0m), type 1 id 190 Command:ESC[35;1mEnter/GoESC[0m, retry none, parameters: <0x84240b90>
08      11/23/09 19:57:20.550           Received Message from 51 (ESC[36;1mOnScreen Orbiter / Living RoomESC[0m) to 118 (ESC[36;1m
mce_usb2 / Living RoomESC[0m), type 1 id 687 Command:ESC[35;1mSet Screen TypeESC[0m, retry none, parameters: <0x7fa37b90>
08      11/23/09 19:57:20.550             Parameter 48(Value): 66 <0x7fa37b90>
08      11/23/09 19:57:20.562           Received Message from 51 (ESC[36;1mOnScreen Orbiter / Living RoomESC[0m) to 6 (ESC[36;1mDa
tagrid Plug-in / Living RoomESC[0m), type 1 id 35 Command:ESC[35;1mPopulate DatagridESC[0m, retry none, parameters: <0x779d9b90>
08      11/23/09 19:57:20.562             Parameter 4(PK_Variable): 0 <0x779d9b90>
08      11/23/09 19:57:20.562             Parameter 5(Value To Assign):  <0x779d9b90>
08      11/23/09 19:57:20.562             Parameter 10(ID): 2 <0x779d9b90>
08      11/23/09 19:57:20.562             Parameter 15(DataGrid ID): MediaFile_51 <0x779d9b90>
08      11/23/09 19:57:20.563             Parameter 38(PK_DataGrid): 63 <0x779d9b90>
08      11/23/09 19:57:20.563             Parameter 39(Options): 5||||1,2|0|13|0 | 2 | <0x779d9b90>
08      11/23/09 19:57:20.563             Parameter 40(IsSuccessful): 1 <0x779d9b90>
08      11/23/09 19:57:20.563             Parameter 44(PK_DeviceTemplate): 0 <0x779d9b90>
08      11/23/09 19:57:20.563             Parameter 60(Width): 1 <0x779d9b90>
08      11/23/09 19:57:20.563             Parameter 61(Height): 20 <0x779d9b90>
05      11/23/09 19:57:20.563           ESC[33;1mMediaBrowser parms: mediatype 5, submediatype , fileformat , attribute_genres , sources 1,2, users_private 0, attributetype_sort 13, users 0, last_viewed 2, pk_attribute ESC[0m <0x95a63b90>
05      11/23/09 19:57:20.590           ESC[33;1mPopulateFileBrowserInfoForFile : attrtype_sort 13,  subdir 0ESC[0m <0x95a63b90>
08      11/23/09 19:57:35.692           Received Message from 15 (ESC[36;1mApp Server / Closet/Storage SpaceESC[0m) to 15 (ESC[36;1mApp Server / Closet/Storage SpaceESC[0m), type 1 id 812 Command:ESC[35;1mApplication ExitedESC[0m, retry none, parameters: <0xa6a85b90>
08      11/23/09 19:57:35.692             Parameter 227(PID): 23331 <0xa6a85b90>
08      11/23/09 19:57:35.692             Parameter 228(Exit Code): 0 <0xa6a85b90>
05      11/23/09 19:57:45.824           ESC[33;1mSocket::ReceiveData 0xa75af00 failed, bytes left 0 start: 1450000 1: 0 1b: 0 2: 0 2b: 0 m_Socket: 130 Incoming_Conn Socket 130 192.168.80.2EVENT 51 T=8 Event #51ESC[0m <0x7fa37b90>
05      11/23/09 19:57:45.824           ESC[33;1mSocket::ReceiveString2 ReceiveData failed m_Socket: -1 Incoming_Conn Socket 130 192.168.80.2EVENT 51 T=8 Event #51ESC[0m <0x7fa37b90>
05      11/23/09 19:57:45.824           ESC[33;1mTCPIP: Closing connection to 51 (Router Dev #0) 0xa75af00 m_Socket: -1ESC[0m <0x7fa37b90>
05      11/23/09 19:57:45.824           ESC[33;1mRouter::RemoveAndDeleteSocket 0xa75af00 51ESC[0m <0x7fa37b90>
08      11/23/09 19:57:45.947           Received Message from 15 (ESC[36;1mApp Server / Closet/Storage SpaceESC[0m) to 15 (ESC[36;1mApp Server / Closet/Storage SpaceESC[0m), type 1 id 812 Command:ESC[35;1mApplication ExitedESC[0m, retry none, parameters: <0xa6a85b90>
08      11/23/09 19:57:45.947             Parameter 227(PID): 23316 <0xa6a85b90>
08      11/23/09 19:57:45.947             Parameter 228(Exit Code): 0 <0xa6a85b90>
08      11/23/09 19:57:50.001           Received Message from 9 (ESC[36;1mOrbiter Plug-in / Living RoomESC[0m) to 15 (ESC[36;1mApp Server / Closet/Storage SpaceESC[0m), type 1 id 67 Command:ESC[35;1mSpawn ApplicationESC[0m, retry retry, parameters: <0xac290b90>
08      11/23/09 19:57:50.001             Parameter 13(Filename): /usr/pluto/bin/flickr.pl <0xac290b90>
08      11/23/09 19:57:50.001             Parameter 50(Name): screen_saver_flickr.pl <0xac290b90>
08      11/23/09 19:57:50.001             Parameter 51(Arguments): 100  1000    700      <0xac290b90>
08      11/23/09 19:57:50.001             Parameter 94(SendOnFailure):  <0xac290b90>
08      11/23/09 19:57:50.001             Parameter 95(SendOnSuccess):  <0xac290b90>
08      11/23/09 19:57:50.001             Parameter 115(Show logo): 0 <0xac290b90>
08      11/23/09 19:57:50.001             Parameter 120(Retransmit): 0 <0xac290b90>
08      11/23/09 19:57:50.001             Parameter 126(Exclusive): 0 <0xac290b90>
08      11/23/09 19:57:50.001             Parameter 241(Detach): 0 <0xac290b90>
08      11/23/09 19:57:50.004           Received Message from 9 (ESC[36;1mOrbiter Plug-in / Living RoomESC[0m) to 15 (ESC[36;1mApp Server / Closet/Storage SpaceESC[0m), type 1 id 67 Command:ESC[35;1mSpawn ApplicationESC[0m, retry retry, parameters: <0xac290b90>
08      11/23/09 19:57:50.004             Parameter 13(Filename): /usr/pluto/bin/getxmls <0xac290b90>
08      11/23/09 19:57:50.004             Parameter 50(Name): getxmls <0xac290b90>
08      11/23/09 19:57:50.004             Parameter 51(Arguments):  <0xac290b90>
08      11/23/09 19:57:50.004             Parameter 94(SendOnFailure):  <0xac290b90>
08      11/23/09 19:57:50.004             Parameter 95(SendOnSuccess):  <0xac290b90>
08      11/23/09 19:57:50.004             Parameter 115(Show logo): 0 <0xac290b90>
08      11/23/09 19:57:50.004             Parameter 120(Retransmit): 0 <0xac290b90>
08      11/23/09 19:57:50.004             Parameter 126(Exclusive): 0 <0xac290b90>
08      11/23/09 19:57:50.004             Parameter 241(Detach): 0 <0xac290b90>
08      11/23/09 19:57:50.242           Received Message from 15 (ESC[36;1mApp Server / Closet/Storage SpaceESC[0m) to 15 (ESC[36;1mApp Server / Closet/Storage SpaceESC[0m), type 1 id 812 Command:ESC[35;1mApplication ExitedESC[0m, retry none, parameters: <0xa6a85b90>
08      11/23/09 19:57:50.242             Parameter 227(PID): 23713 <0xa6a85b90>
08      11/23/09 19:57:50.242             Parameter 228(Exit Code): 0 <0xa6a85b90>
01      11/23/09 19:57:50.586           ESC[31;1mSocket::ReceiveData-a 0xa715438 failed ret 0ESC[0m <0x779d9b90>
05      11/23/09 19:57:50.597           ESC[33;1mSocket::ReceiveString2 ReceiveData failed m_Socket: -1 Incoming_Conn Socket 97 127.0.0.1 dev 6ESC[0m <0x779d9b90>
01      11/23/09 19:57:50.597           ESC[31;1mSocket 0xa715438 failure waiting for response to message from device 6 type 1 id 35ESC[0m <0x779d9b90>
01      11/23/09 19:57:50.597           ESC[31;1mPlugin 6 stopped respondingESC[0m <0x779d9b90>
05      11/23/09 19:57:50.597           ESC[33;1mSender: 51 sent message type: 1 ID: 35 and expected a message reply from 6ESC[0m <0x779d9b90>
05      11/23/09 19:57:50.597           ESC[33;1mSocket::ReceiveData 0xa788508 failed, bytes left 0 start: 1490000 1: 0 1b: 0 2: 0 2b: 0 m_Socket: 146 Incoming_Conn Socket 146 192.168.80.2EVENT 51 T=8 Event #51ESC[0m <0x779d9b90>
05      11/23/09 19:57:50.597           ESC[33;1mSocket::ReceiveString2 ReceiveData failed m_Socket: -1 Incoming_Conn Socket 146 192.168.80.2EVENT 51 T=8 Event #51ESC[0m <0x779d9b90>
05      11/23/09 19:57:50.597           ESC[33;1mTCPIP: Closing connection to 51 (Router Dev #0) 0xa788508 m_Socket: -1ESC[0m <0x779d9b90>
05      11/23/09 19:57:50.597           ESC[33;1mRouter::RemoveAndDeleteSocket 0xa788508 51ESC[0m <0x779d9b90>

<snip (a list of all my media)>

05      11/23/09 19:57:51.339           ESC[33;1mGot a reload command from 0 ESC[0m <0x9a26cb90>
05      11/23/09 19:57:51.339           ESC[33;1mGot a reload command from 0 ESC[0m <0x98a69b90>
05      11/23/09 19:57:51.339           ESC[33;1mGot a reload command from 0 ESC[0m <0x97266b90>
05      11/23/09 19:57:51.340           ESC[33;1mSocket::SendData socket is invalidESC[0m <0xb6def6c0>
05      11/23/09 19:57:51.340           ESC[33;1mSocket::SendMessage *failed to send* type 7 id 1 from 0 to 6ESC[0m <0xb6def6c0>
05      11/23/09 19:57:51.340           ESC[33;1mGot a reload command from 0 ESC[0m <0x94260b90>
05      11/23/09 19:57:51.340           ESC[33;1mGot a reload command from 0 ESC[0m <0x92a5db90>
05      11/23/09 19:57:51.341           ESC[33;1mGot a reload command from 0 ESC[0m <0x8d252b90>
05      11/23/09 19:57:51.341           ESC[33;1mGot a reload command from 0 ESC[0m <0x8ba4fb90>
05      11/23/09 19:57:51.342           ESC[33;1mGot a reload command from 0 ESC[0m <0x8a24cb90>
05      11/23/09 19:57:51.342           ESC[33;1mGot a reload command from 0 ESC[0m <0x88248b90>
05      11/23/09 19:57:51.346           ESC[33;1mGot a reload command from 0 ESC[0m <0x86a45b90>
05      11/23/09 19:57:51.348           ESC[33;1mGot a reload command from 0 ESC[0m <0x7e21ab90>
05      11/23/09 19:57:51.350           ESC[33;1mGot a reload command from 0 ESC[0m <0x9125ab90>
05      11/23/09 19:57:51.436           ESC[33;1mSocket::ReceiveData 0xa462370 failed, bytes left 0 start: 1600000 1: 0 1b: 0 2: 0 2b: 0 m_Socket: 96 Command_Impl1 Dev #6ESC[0m <0x95a63b90>
05      11/23/09 19:57:51.436           ESC[33;1mSocket::ReceiveString2 ReceiveData failed m_Socket: -1 Command_Impl1 Dev #6ESC[0m <0x95a63b90>
01      11/23/09 19:57:51.436           ESC[31;1mReceive string failed in HandleRequestSocket 18:ReceiveData failed Command_Impl1 Dev #6ESC[0m <0x95a63b90>
05      11/23/09 19:57:51.450           ESC[33;1mDumping 104 locksESC[0m <0x95a63b90>
05      11/23/09 19:57:51.450           ESC[33;1mfinished check for exceptionsESC[0m <0x95a63b90>
05      11/23/09 19:57:51.450           ESC[33;1mOL: (0x9febf14) (>2) messagequeue DCERouter.cpp l:1862 time: 1:00:00a (1259002671 s) thread: 3068062608 Rel: Y Got: YESC[0m <0x95a63b90>

Any insights would be appreciated :)

mhorst

  • Veteran
  • ***
  • Posts: 72
    • View Profile
Re: Orbiter crash when retrieving video list
« Reply #1 on: December 15, 2009, 10:40:58 pm »
Still the same problem.

I think it might have to do with the access time for the video files. Maybe there is some kind of time-out being reached.
The video files are on the server on a software raid (5) array, and there are over 4,000 of them.
If I log into the orbiter and access the files from the command line (using a command like "du"), then afterwards I can retrieve the video list successfully.

Anyway, I have a work around now. I'll see if I can get any further with this.

mhorst

  • Veteran
  • ***
  • Posts: 72
    • View Profile
Re: Orbiter crash when retrieving video list
« Reply #2 on: December 27, 2009, 04:52:38 pm »
The workaround does not seem to work :(
I think it was a fluke that it happened to work twice in a row.

Any advice on how I can go on debugging this?

I can get tons of logging from the /var/log directory, from the screen session of the orbiter, and from wireshark. But that doesn't help if I don't know what I'm looking for. There are plenty of warnings/errors in the logging but most of them seem to be OK, or not very informative.

Anyway, as it is now the system's pretty unusable.

mhorst

  • Veteran
  • ***
  • Posts: 72
    • View Profile
Re: Orbiter crash when retrieving video list
« Reply #3 on: December 27, 2009, 05:40:27 pm »
Hmmm,

A bit of digging revealed that the DCErouter actually segfaults. Not sure why that happens, but when I look into the screen I see the following:

Code: [Select]
ready to dump locks using logger: 0x94c8f60
/usr/pluto/bin/Spawn_DCERouter.sh: line 74: 20460 Segmentation fault      (core dumped) /usr/pluto/bin/Spawn_Wrapper.sh /usr/pluto/bin/DCE
Router $PLUTO_DB_CRED -D "$MySqlDBName" -l "$LogFile"
LOG: Return code: 139
3       12/27/09 17:35:21       DCERouter (server)      ESC[1;31mDevice died... count=35/200 dev=DCERouterESC[1;00m
3       12/27/09 17:35:21       DCERouter (server)      ESC[1;31mDevice died... count=35/200 dev=DCERouterESC[1;00m
LOG: Sun Dec 27 17:35:21 CET 2009 died
out
LOG: ========== NEW LOG SECTION ==========
1       12/27/09 17:35:27       DCERouter (server)      ESC[1;00mStarting... 36ESC[1;00m
1       12/27/09 17:35:27       DCERouter (server)      ESC[1;00mStarting... 36ESC[1;00m
LOG: Sun Dec 27 17:35:27 CET 2009 Starting
Cannot perform query: [update CommandGroup set `PK_CommandGroup`=80, `FK_Array`=5, `FK_Installation`=1001371, `Description`="TV", `Hint`="
Living Room", `CanTurnOff`=0, `AlwaysShow`=0, `CanBeHidden`=0, `FK_Criteria_Orbiter`=NULL, `FK_DesignObj`=NULL, `FK_Template`=33, `AltID`=
NULL, `FK_Icon`=11, `AutoGeneratedDate`="2009-09-02 21:02:55", `Disabled`=0, `TemplateParm1`=57, `TemplateParm2`=1, `FK_Text`=NULL, `psc_i
d`=NULL, `psc_batch`=NULL, `psc_user`=0, `psc_frozen`=0, `psc_restrict`=0 where `PK_CommandGroup`=80] Unknown column 'FK_Text' in 'field l
ist'

<snip a whole lot of "Cannot perform query because of Unknown column FK_Text">

Copyright (C) 2004 Pluto, Inc., a Florida Corporation
www.plutohome.com
Phone: +1 (877) 758-8648
This program is distributed according to the terms of the GNU Public License, available at:
http://www.fsf.org/licensing/licenses/gpl.html
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
See the GNU Public License for more details.
---------------

Checking MythTV storage group Default for host localhost...Ok
Checking MythTV storage group LiveTV for host localhost...Ok
Checking MythTV storage group public for host localhost...Ok
Checking MythTV storage group Martijn for host localhost...Ok
Checking MythTV storage group Default for host localhost...Ok
Checking MythTV storage group LiveTV for host localhost...Ok
Checking MythTV storage group public: Media [43] for host localhost...Ok
Checking MythTV storage group Martijn: Media [43] for host localhost...Ok
Checking MythTV storage group Default for host dcerouter...Ok
Checking MythTV storage group LiveTV for host dcerouter...Ok
Checking MythTV storage group public for host dcerouter...Ok
Checking MythTV storage group Martijn for host dcerouter...Ok
Checking MythTV storage group Default for host dcerouter...Ok
Checking MythTV storage group LiveTV for host dcerouter...Ok
Checking MythTV storage group public: Media [43] for host dcerouter...Ok
Checking MythTV storage group Martijn: Media [43] for host dcerouter...Ok
Checking MythTV storage group Default for host moon49...Ok
Checking MythTV storage group LiveTV for host moon49...Ok
Checking MythTV storage group public for host moon49...Ok

So what's with the FK_Text field, and why does my database not have it?

Andanotherusername

  • Regular Poster
  • **
  • Posts: 26
    • View Profile
Re: Orbiter crash when retrieving video list
« Reply #4 on: March 29, 2010, 08:04:20 am »
Did you find a solution to the problem? I have/had the same problem.
You can also find the same problem reported here (http://forum.linuxmce.org/index.php?topic=9581.0).
A reinstall with deleting all the id3 & key files solved the problem for now. It seems that the cover-art is the problem. I just wanted to check if you found a solution to the problem before I start adding cover-arts back in the database. Thanks.

mhorst

  • Veteran
  • ***
  • Posts: 72
    • View Profile
Re: Orbiter crash when retrieving video list
« Reply #5 on: March 29, 2010, 10:49:38 am »
I didn't really find a solution, a re-install seemed to help. Most of the meta-data and cover art was automatically re-entered into the data base, but some of it disappeared after the re-install.
I have my media in a directory structure (for historical reasons, I know it's not the LinuxMCE way, but until I have entered all the meta-data it is the easiest way for me to find my media), and to ease navigation I gave the directories containing a movie the same meta-data (and cover art) as the movie inside it. This meta-data of the directories (or at least the cover art) seems to have disappeared for some directories, I still have to look into that.

I also have to say that originally my media was on an ext3 file system on an LVM volume on top of a Raid 5 array. During the install I took the opportunity to reorganize that to ReiserFS directly on the Raid 5 array, without LVM in-between.
That might have speed things up enough to solve the problem for now, but I am afraid it might return as soon as I start adding more cover art again.

Thingie

  • Veteran
  • ***
  • Posts: 114
    • View Profile
Re: Orbiter crash when retrieving video list
« Reply #6 on: March 29, 2010, 06:55:56 pm »
http://forum.linuxmce.org/index.php?topic=9581.msg67579#msg67579

same problem here. A ticket has been made. Pls enter your experience to the ticket.

Thx

Thingie

Andanotherusername

  • Regular Poster
  • **
  • Posts: 26
    • View Profile
Re: Orbiter crash when retrieving video list
« Reply #7 on: May 14, 2010, 09:55:11 pm »
I just devoted a little time towards finding the exact issue, and I believe that I might have found part or the exact issue. I believe that the id3 Tags are the Issue. A copy of the picture is stored in each Id3 Tag file. This is additionally to the Thumbnails and "real" picture that is stored under mediapics. This increases the id3 file size & this should be the problem for the orbiter crash due to the increased reading time (According to WIKI, LMCE shows the pictures from mediapics, so the actual picture is not the problem).

Unfortunately, I do not have the time (getting back into programming plus understanding LMCE structure) to resolve this issue. I do not know the whole structure under LMCE, and it is very hard to understand all the connections if you start late in the game to understand the complex structure of this fantastic product. This is why I do not know if this is an easy fix (as I believe that it would be for the original programmer of a feature) or a complex task. One way would be to allow users to upload files through the Cover Art feature. The other way would be to allow the user (through a checkbox or something similar) to decide whether or not to save the picture in the id3 Tag (This seems to be a simple fix if-else statement, but this might be contrary to the LMCE concept or it might cause problems with other features). I might try to do it myself depending on my understanding of the LMCE structure & me getting back into programming.

I hope that this is the actual culprit. I will add this finding to the ticket.

sambuca

  • Guru
  • ****
  • Posts: 462
    • View Profile
Re: Orbiter crash when retrieving video list
« Reply #8 on: May 14, 2010, 10:24:12 pm »
As far as I know (and I'm no expert, even though I've been contributing for a year or so now ;) ), the files themselves is not accessed when displaying the file list. If you have any indication that this is the problem, please elaborate.

I know the database queries haven been discussed a bit, as they weren't optimized in any way. I don't know whats come of that, but that may also be part of the problem.

I don't think there is any particular reason or guideline as to why the cover art is stored in the file. But LMCE syncs every other attribute, so why not the picture as well. (bytes these days are cheap anyway, and whats another 100k to a 3-4MB file, or 30-40 in the case of flac, my favourite ;) ).
On the other hand, options is always good to have, so feel free to dive in  :)

best regards,
sambuca

tschak909

  • LinuxMCE God
  • ****
  • Posts: 5549
  • DOES work for LinuxMCE.
    • View Profile
Re: Orbiter crash when retrieving video list
« Reply #9 on: May 15, 2010, 08:42:40 am »
The database queries filling the datagrids in media plugin are NOT optimized at all. Please can somebody look into them?

-Thom