every time I do a search in my movies it restart dcerouter. in router logs I see this
01 09/08/16 22:59:25.592 [31;1mQuery failed (Column 'FK_AttributeType' in field list is ambiguous): select DISTINCT PK_Attribute, IF(FK_AttributeType IN (2,3,13,57), IF(Name LIKE 'the %', CONCAT(SUBSTR(Name, 5), ', The'), Name), Name ) AS Name, Description, FK_Picture FROM Attribute JOIN AttributeType ON Attribute.FK_AttributeType=PK_AttributeType JOIN MediaType_AttributeType ON MediaType_AttributeType.FK_AttributeType=PK_AttributeType LEFT JOIN Picture_Attribute ON FK_Attribute=PK_Attribute WHERE Name Like 'w%' AND Identifier>0 AND MediaType_AttributeType.EK_MediaType=5 ORDER BY Name limit 30 (1)[0m <0x9122bb40>
05 09/08/16 22:59:25.592 [33;1mResetting db_wrapper connection[0m <0x9122bb40>
01 09/08/16 22:59:25.593 [31;1mQuery failed (Column 'FK_AttributeType' in field list is ambiguous): select DISTINCT PK_Attribute, IF(FK_AttributeType IN (2,3,13,57), IF(Name LIKE 'the %', CONCAT(SUBSTR(Name, 5), ', The'), Name), Name ) AS Name, Description, FK_Picture FROM Attribute JOIN AttributeType ON Attribute.FK_AttributeType=PK_AttributeType JOIN MediaType_AttributeType ON MediaType_AttributeType.FK_AttributeType=PK_AttributeType LEFT JOIN Picture_Attribute ON FK_Attribute=PK_Attribute WHERE Name Like 'w%' AND Identifier>0 AND MediaType_AttributeType.EK_MediaType=5 ORDER BY Name limit 30 (1)[0m <0x9122bb40>
05 09/08/16 22:59:25.593 [33;1mResetting db_wrapper connection[0m <0x9122bb40>
01 09/08/16 22:59:25.593 [31;1mQuery failed (): select DISTINCT PK_Attribute, IF(FK_AttributeType IN (2,3,13,57), IF(Name LIKE 'the %', CONCAT(SUBSTR(Name, 5), ', The'), Name), Name ) AS Name, Description, FK_Picture FROM Attribute JOIN AttributeType ON Attribute.FK_AttributeType=PK_AttributeType JOIN MediaType_AttributeType ON MediaType_AttributeType.FK_AttributeType=PK_AttributeType LEFT JOIN Picture_Attribute ON FK_Attribute=PK_Attribute WHERE Name Like 'w%' AND Identifier>0 AND MediaType_AttributeType.EK_MediaType=5 ORDER BY Name limit 30 retry: (nil)[0m <0x9122bb40>
Return code: 139
3 09/08/16 22:59:26 DCERouter (server) [1;31mDevice died... count=8/200 dev=DCERouter[1;00m
Thu Sep 8 22:59:26 EDT 2016 died
does this mean my database is wacked?
If DCERouter restarts during a media query most of the time it has to do with speed of the HDD. Post the log starting a minute before the failing.
posde I would agree with you. but it a ssd and never had a problem before until all updates to updatemedia...
I am not really seeing stuff in the log file. Couple of notes:
* Does it matter what type of Orbiter you use, ie. Onscreen Orbiter, Weborbiter, Windows Orbiter?
* Do you mean going into Option / Search when you say you search for movies?
* What happens after the crash if you go into the same list again. Does the crash happen again?
* How do you have your movies sorted by, and how many movies do you have. There is a limit of 16384 entries for a datagrid.
* Does it matter what type of Orbiter you use, ie. Onscreen Orbiter, Weborbiter, Windows Orbiter? all them
* Do you mean going into Option / Search when you say you search for movies? Option / Search
* What happens after the crash if you go into the same list again. Does the crash happen again? it crashes in option search type any key.
* How do you have your movies sorted by, and how many movies do you have. There is a limit of 16384 entries for a datagrid.. sort type title
when I do option / search and sort type is by title I have 8290 movies.
See if changing the sort by to something like genre will help.
Just a heads up: I am experiencing the same issue, and have way less media. Seems a recent update broke stuff.
Fixed. Should be in the next update, watch http://wiki.linuxmce.org/index.php/LinuxMCE-1204/1404_Updates#Upcoming_fixes...
1404 update available - 1204 in the making
and 1204 is done as well.