Jump to content

[BETA] Ear Wax - NOW AVAILABLE - Testers Wanted

MarvinB

By MarvinB
in Amazon Alexa

 Share

Recommended Posts

ginjaninja

ginjaninja 609

Posted
Posted (edited)

Artist matching helpers and gremlins

Command - "play artist acdc"

Response - There was a problem with the requested skills response 

2026-06-08 18:46:22.389 Debug ItemsService-0HNM57JC6DN9D:00000001: http/1.1 GET https://‌‍‍xxx.xxx.xxx‌/emby/Users/ba605147d56742b1b91f1e90f91db45c/Items?Recursive=true&IncludeItemTypes=MusicArtist&SearchTerm=acdc&UserId=‌ba605147d56742b1b91f1e90f91db45c‌&api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌. Source Ip: ‌‍‍34.243.23.0‌, UserAgent: 
2026-06-08 18:46:22.392 Debug ItemsService-0HNM57JC6DN9D:00000001: http/1.1 Response 200 to ‌‍‍34.243.23.0‌. Time: 3ms. GET https://‌‍‍xxx.xxx.xxx‌/emby/Users/ba605147d56742b1b91f1e90f91db45c/Items?Recursive=true&IncludeItemTypes=MusicArtist&SearchTerm=acdc&UserId=‌ba605147d56742b1b91f1e90f91db45c‌&api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌. 
2026-06-08 18:46:22.438 Debug ItemsService-0HNM57JC6DN9E:00000001: http/1.1 GET https://‌‍‍xxx.xxx.xxx‌/emby/Users/ba605147d56742b1b91f1e90f91db45c/Items?Recursive=true&IncludeItemTypes=MusicArtist&UserId=‌ba605147d56742b1b91f1e90f91db45c‌&api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌. Source Ip: ‌‍‍34.243.23.0‌, UserAgent: 
2026-06-08 18:46:24.937 Debug ItemsService-0HNM57JC6DN9E:00000001: http/1.1 Response 200 to ‌‍‍34.243.23.0‌. Time: 2499ms. GET https://‌‍‍xxx.xxx.xxx‌/emby/Users/ba605147d56742b1b91f1e90f91db45c/Items?Recursive=true&IncludeItemTypes=MusicArtist&UserId=‌ba605147d56742b1b91f1e90f91db45c‌&api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌.

maybe the skill needs a dynamic entity for ac/dc.

It great that the skill consumes all artists for another bite at the cherry.

are you building a database of synonyms if so i will list mine here as i go.

Real name / Synonyms (what skill searched for)

AC/DC / ACDC

Anything with & or and or +/ & or and (eg requested - Angus & Julia Stone, searched Angus and Julia Stone, Tracey + Plastics searched tracey and the plastics).

Grover Washington, Jr / Grover Washington Junior (Probably JR should always be tried for Junior?)

plain white t's / plain white t.'s

t.A.T.u. / tattoo

 

is it realistic to build an architecture that consumes eg Artist and Album names metadata from users servers to crowdsource collection of this data for better matching?

 

its very clever the skill starts looking for matches and sometimes it works 

00001: http/1.1 Response 200 to ‌‍‍34.244.24.84‌. Time: 4519ms. GET https://‌‍‍xxx.xxx.xxx‌/emby/Users/ba605147d56742b1b91f1e90f91db45c/Items?Recursive=true&IncludeItemTypes=MusicArtist&SearchTerm=grover washington junior&UserId=‌ba605147d56742b1b91f1e90f91db45c‌&api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌. 
2026-06-08 19:09:43.613 Debug ItemsService-0HNM57JC6DNBO:00000001: http/1.1 GET https://‌‍‍xxx.xxx.xxx‌/emby/Users/ba605147d56742b1b91f1e90f91db45c/Items?Recursive=true&IncludeItemTypes=MusicArtist&SearchTerm=groverwashingtonjunior&UserId=‌ba605147d56742b1b91f1e90f91db45c‌&api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌. Source Ip: ‌‍‍34.244.24.84‌, UserAgent: 
2026-06-08 19:09:43.614 Debug ItemsService-0HNM57JC6DNBO:00000001: http/1.1 Response 200 to ‌‍‍34.244.24.84‌. Time: 1ms. GET https://‌‍‍xxx.xxx.xxx‌/emby/Users/ba605147d56742b1b91f1e90f91db45c/Items?Recursive=true&IncludeItemTypes=MusicArtist&SearchTerm=groverwashingtonjunior&UserId=‌ba605147d56742b1b91f1e90f91db45c‌&api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌. 
2026-06-08 19:09:43.661 Debug ItemsService-0HNM57JC6DNBP:00000001: http/1.1 GET https://‌‍‍xxx.xxx.xxx‌/emby/Users/ba605147d56742b1b91f1e90f91db45c/Items?Recursive=true&IncludeItemTypes=MusicArtist&SearchTerm=washington&UserId=‌ba605147d56742b1b91f1e90f91db45c‌&api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌. Source Ip: ‌‍‍34.244.24.84‌, UserAgent: 
2026-06-08 19:09:43.674 Debug ItemsService-0HNM57JC6DNBP:00000001: http/1.1 Response 200 to ‌‍‍34.244.24.84‌. Time: 13ms. GET https://‌‍‍xxx.xxx.xxx‌/emby/Users/ba605147d56742b1b91f1e90f91db45c/Items?Recursive=true&IncludeItemTypes=MusicArtist&SearchTerm=washington&UserId=‌ba605147d56742b1b91f1e90f91db45c‌&api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌. 
2026-06-08 19:09:43.723 Debug ItemsService-0HNM57JC6DNBQ:00000001: http/1.1 GET https://‌‍‍xxx.xxx.xxx‌/emby/Users/ba605147d56742b1b91f1e90f91db45c/Items?Recursive=true&IncludeItemTypes=MusicArtist&SearchTerm=grover&UserId=‌ba605147d56742b1b91f1e90f91db45c‌&api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌. Source Ip: ‌‍‍34.244.24.84‌, UserAgent: 
2026-06-08 19:09:43.727 Debug ItemsService-0HNM57JC6DNBQ:00000001: http/1.1 Response 200 to ‌‍‍34.244.24.84‌. Time: 4ms. GET https://‌‍‍xxx.xxx.xxx‌/emby/Users/ba605147d56742b1b91f1e90f91db45c/Items?Recursive=true&IncludeItemTypes=MusicArtist&SearchTerm=grover&UserId=‌ba605147d56742b1b91f1e90f91db45c‌&api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌. 
2026-06-08 19:09:43.771 Debug ItemsService-0HNM57JC6DNBR:00000001: http/1.1 GET https://‌‍‍xxx.xxx.xxx‌/emby/Users/ba605147d56742b1b91f1e90f91db45c/Items?Recursive=true&IncludeItemTypes=Audio&ArtistIds=261680&SortBy=Album,SortName&UserId=‌ba605147d56742b1b91f1e90f91db45c‌&Fields=Album,AlbumId,Artists,ArtistItems,BitRate,Container&api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌&Limit=2. Source Ip: ‌‍‍34.244.24.84‌, UserAgent: 
2026-06-08 19:09:43.841 Debug SqliteItemRepository: GetitemById Folder 213363 \\x99\x99a\Music\Compilations\The Best\[2000] The Best Jazz Album in the World... Ever!

 

Command - "play artist Jay-Z"

Response artist not found...odd because the correct artist is searched for, does your skill not like minus signs? 

2026-06-08 19:13:44.335 Debug ItemsService-0HNM57JC6DNC0:00000001: http/1.1 GET https://‌‍‍xxx.xxx.xxx‌/emby/Users/ba605147d56742b1b91f1e90f91db45c/Items?Recursive=true&IncludeItemTypes=MusicArtist&SearchTerm=jay-z&UserId=‌ba605147d56742b1b91f1e90f91db45c‌&api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌. Source Ip: ‌‍‍34.244.24.84‌, UserAgent: 
2026-06-08 19:13:44.342 Debug ItemsService-0HNM57JC6DNC0:00000001: http/1.1 Response 200 to ‌‍‍34.244.24.84‌. Time: 7ms. GET https://‌‍‍xxx.xxx.xxx‌/emby/Users/ba605147d56742b1b91f1e90f91db45c/Items?Recursive=true&IncludeItemTypes=MusicArtist&SearchTerm=jay-z&UserId=‌ba605147d56742b1b91f1e90f91db45c‌&api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌.

Command "play artist Richard o'brien"

Response - there was a problem with the requested skills response..

Correct search term 'Richard o'brien' but ecosystem shat the bed 

2026-06-08 19:29:24.907 Debug ItemsService-0HNM57JC6DNCS:00000001: http/1.1 GET https://‌‍‍xxx.xxx.xxx‌/emby/Users/ba605147d56742b1b91f1e90f91db45c/Items?Recursive=true&IncludeItemTypes=MusicArtist&SearchTerm=richard o'brien&UserId=‌ba605147d56742b1b91f1e90f91db45c‌&api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌. Source Ip: ‌‍‍108.131.82.95‌, UserAgent: 
2026-06-08 19:29:30.330 Info SqliteItemRepository: Interrupt query due to cancellation.
2026-06-08 19:29:30.330 Debug App: Sqlite: 9 - statement aborts at 0: interrupted; [SELECT pgno FROM 'main'.'fts_search9_idx' WHERE segid=? AND term<=? ORDER BY term DESC LIMIT 1]
2026-06-08 19:29:30.330 Debug App: Sqlite: 9 - statement aborts at 5: interrupted; [SELECT rowid, rank FROM 'main'.'fts_search9' ORDER BY bm25("fts_search9") ASC]
2026-06-08 19:29:30.330 Debug App: Sqlite: 9 - statement aborts at 54: interrupted; [with WithAncestors AS (SELECT itemid FROM AncestorIds2 WHERE AncestorId=57475 ),WithItemLinkItemIds AS (select ItemLinks2.LinkedId From ItemLinks2 join withancestors on withancestors.itemid=itemlinks2.itemid  where ItemLinks2.Type in (0,1,5))select A.Id,A.Name,A.RunTimeTicks,A.Images,UserDatas.IsFavorite from mediaitems A join fts_search9 on A.Id=fts_search9.RowId and fts_search9 match @SearchTerm left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And UserDatas.UserId=17 where A.Type=13 AND A.Id in WithItemLinkItemIds ORDER BY Rank ASC]
2026-06-08 19:29:30.330 Info ItemsService-0HNM57JC6DNCS:00000001: http/1.1 Response completed after client disconnected to ‌‍‍108.131.82.95‌. Time: 5423ms. GET https://‌‍‍xxx.xxx.xxx‌/emby/Users/ba605147d56742b1b91f1e90f91db45c/Items?Recursive=true&IncludeItemTypes=MusicArtist&SearchTerm=richard o'brien&UserId=‌ba605147d56742b1b91f1e90f91db45c‌&api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌. 
2026-06-08 19:29:30.362 Debug ItemsService-0HNM57JC6DNCT:00000001: http/1.1 GET https://‌‍‍xxx.xxx.xxx‌/emby/Users/ba605147d56742b1b91f1e90f91db45c/Items?Recursive=true&IncludeItemTypes=MusicArtist&SearchTerm=richard obrien&UserId=‌ba605147d56742b1b91f1e90f91db45c‌&api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌. Source Ip: ‌‍‍108.131.82.95‌, UserAgent: 
2026-06-08 19:29:32.823 Info SqliteItemRepository: Interrupt query due to cancellation.
2026-06-08 19:29:32.823 Debug App: Sqlite: 9 - statement aborts at 0: interrupted; []
2026-06-08 19:29:32.823 Debug App: Sqlite: 9 - statement aborts at 5: interrupted; [SELECT rowid, rank FROM 'main'.'fts_search9' ORDER BY bm25("fts_search9") ASC]
2026-06-08 19:29:32.823 Debug App: Sqlite: 9 - statement aborts at 54: interrupted; [with WithAncestors AS (SELECT itemid FROM AncestorIds2 WHERE AncestorId=57475 ),WithItemLinkItemIds AS (select ItemLinks2.LinkedId From ItemLinks2 join withancestors on withancestors.itemid=itemlinks2.itemid  where ItemLinks2.Type in (0,1,5))select A.Id,A.Name,A.RunTimeTicks,A.Images,UserDatas.IsFavorite from mediaitems A join fts_search9 on A.Id=fts_search9.RowId and fts_search9 match @SearchTerm left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And UserDatas.UserId=17 where A.Type=13 AND A.Id in WithItemLinkItemIds ORDER BY Rank ASC]
2026-06-08 19:29:32.824 Info ItemsService-0HNM57JC6DNCT:00000001: http/1.1 Response completed after client disconnected to ‌‍‍108.131.82.95‌. Time: 2461ms. GET https://‌‍‍xxx.xxx.xxx‌/emby/Users/ba605147d56742b1b91f1e90f91db45c/Items?Recursive=true&IncludeItemTypes=MusicArtist&SearchTerm=richard obrien&UserId=‌ba605147d56742b1b91f1e90f91db45c‌&api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌. 
2026-06-08 19:29:33.579 Info AudioService-0HNM57JC6DNCP:00000001: http/1.1 Response completed after client disconnected to ‌‍‍192.168.4.2‌. Time: 70077ms. GET https://‌‍‍xxx.xxx.xxx‌/emby/Audio/197295/stream?api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌&static=true. Headers: Content-Type=audio/mpeg, Date=Mon, 08 Jun 2026 18:28:23 GMT, Server=UPnP/1.0 DLNADOC/1.50, Accept-Ranges=bytes, Cache-Control=private, no-transform, ETag="0953994a044ffb961652348010d25a9d", Content-Length=7715725, Cross-Origin-Resource-Policy=cross-origin, Private-Network-Access-Name=X99, Private-Network-Access-Id=fccaa6f897f140dbb689938224ae1938

Command "play artist Róisín Murphy"

Response - the requested media the artist  Róisín Murphy can not be found in your library

correct search term did the skill not like the response? too long? special characters? fwiw no problem with t'pau

Spoiler

  

{
  "Items": [
    {
      "Name": "Róisín Murphy",
      "ServerId": "fccaa6f897f140dbb689938224ae1938",
      "Id": "260670",
      "RunTimeTicks": 347692648640,
      "IsFolder": true,
      "Type": "MusicArtist",
      "ImageTags": {
        "Primary": "b4ab4c9b6760750260b27d2f1c169cbf_635154830085694209",
        "Logo": "e1c1a9c2b3642f28b687e5f9068ecb91_635886314514860668",
        "Banner": "314e28a596ab89580dbae64868e3efef_635288514462966077"
      },
      "BackdropImageTags": [
        "70ecb9aec647c85b86f93072168711eb_639165404296506876",
        "70ecb9aec647c85b86f93072168711eb_637460877067777744",
        "166d65fb88c3ca87b128e023e14fe12c_638305774766801971",
        "9aca6678951940ba07300c2240dd23bc_638305774791182134"
      ]
    },
    {
      "Name": "Matthew Murphy",
      "ServerId": "fccaa6f897f140dbb689938224ae1938",
      "Id": "257488",
      "RunTimeTicks": 13154220340,
      "IsFolder": true,
      "Type": "MusicArtist",
      "ImageTags": {
        "Primary": "98349f2cc734fc91151bee9b3e587201_638096569221599364"
      },
      "BackdropImageTags": []
    },
    {
      "Name": "Eddie Murphy",
      "ServerId": "fccaa6f897f140dbb689938224ae1938",
      "Id": "259575",
      "RunTimeTicks": 6296509330,
      "IsFolder": true,
      "Type": "MusicArtist",
      "ImageTags": {
        "Primary": "acfddf8de53830429ff438e6c71ddffb_637627594200189013",
        "Logo": "de87b81d54eb70844c9bb3b256d9219a_638097135267099294"
      },
      "BackdropImageTags": [
        "53b1afbc322f9edc74ce5c71163285de_638097135267208941"
      ]
    },
    {
      "Name": "Peter Murphy",
      "ServerId": "fccaa6f897f140dbb689938224ae1938",
      "Id": "259907",
      "RunTimeTicks": 14586513980,
      "IsFolder": true,
      "Type": "MusicArtist",
      "ImageTags": {
        "Logo": "421ebd496e62c29fd2bdf7baeef23bc4_638096953589942446",
        "Primary": "c08ad561ba6b70cc03fc7702025cfdec_638096953590522202"
      },
      "BackdropImageTags": [
        "da9cb5714f51d60a4cd8bed80e4d1065_638444267698190468",
        "07ac4d040fed3e68b4d56e41c3bea7cc_638096953590241764"
      ]
    },
    {
      "Name": "Dropkick Murphys",
      "ServerId": "fccaa6f897f140dbb689938224ae1938",
      "Id": "259976",
      "RunTimeTicks": 5233437000,
      "IsFolder": true,
      "Type": "MusicArtist",
      "ImageTags": {
        "Primary": "db159b0dd1888a0d3a487e547db82551_638096611117371360",
        "Logo": "6416b43ba67d95d3499a4e59c2d72dae_638096611117620760"
      },
      "BackdropImageTags": [
        "c638f39c7a9966ba57184237da6fa17a_638444268202766491",
        "2df61cbbe97fd6e62e337eb66bfe98f8_638096611118249277"
      ]
    },
    {
      "Name": "Nick Murphy",
      "ServerId": "fccaa6f897f140dbb689938224ae1938",
      "Id": "260378",
      "RunTimeTicks": 9286394550,
      "IsFolder": true,
      "Type": "MusicArtist",
      "ImageTags": {
        "Primary": "777008f2c32574a996b907cb46713f35_638096955857403084"
      },
      "BackdropImageTags": []
    },
    {
      "Name": "James Murphy",
      "ServerId": "fccaa6f897f140dbb689938224ae1938",
      "Id": "260439",
      "RunTimeTicks": 171371218630,
      "IsFolder": true,
      "Type": "MusicArtist",
      "ImageTags": {
        "Primary": "58061c52b6121dd12307656a9515f684_638096955096537866"
      },
      "BackdropImageTags": []
    },
    {
      "Name": "Hope Murphy",
      "ServerId": "fccaa6f897f140dbb689938224ae1938",
      "Id": "262754",
      "RunTimeTicks": 1678628570,
      "IsFolder": true,
      "Type": "MusicArtist",
      "ImageTags": {},
      "BackdropImageTags": []
    },
    {
      "Name": "Walter Murphy",
      "ServerId": "fccaa6f897f140dbb689938224ae1938",
      "Id": "266000",
      "RunTimeTicks": 7087319870,
      "IsFolder": true,
      "Type": "MusicArtist",
      "ImageTags": {
        "Primary": "baa214126bff16f143ff8519566bcfba_637651508957612244",
        "Logo": "a1530672f49326085e24d3e2c86db16b_638097144909232780"
      },
      "BackdropImageTags": [
        "a70d2d9c961707a3887ce32e99bdb91b_638097144909522058"
      ]
    },
    {
      "Name": "Sharon Murphy",
      "ServerId": "fccaa6f897f140dbb689938224ae1938",
      "Id": "266703",
      "RunTimeTicks": 2249142860,
      "IsFolder": true,
      "Type": "MusicArtist",
      "ImageTags": {},
      "BackdropImageTags": []
    },
    {
      "Name": "Brittany Murphy",
      "ServerId": "fccaa6f897f140dbb689938224ae1938",
      "Id": "267048",
      "RunTimeTicks": 1941942860,
      "IsFolder": true,
      "Type": "MusicArtist",
      "ImageTags": {
        "Primary": "e323ee24df09e6fd3a2f396a6469413e_637603700974825620",
        "Logo": "492808ea342948f7170c44afc2f208c9_637699844056854985"
      },
      "BackdropImageTags": [
        "2d7d72a9e612f5e4919daea1d6754aa6_637699844056380997"
      ]
    },
    {
      "Name": "Mark Murphy",
      "ServerId": "fccaa6f897f140dbb689938224ae1938",
      "Id": "272872",
      "RunTimeTicks": 3413942860,
      "IsFolder": true,
      "Type": "MusicArtist",
      "ImageTags": {
        "Primary": "d00d2047b6021d81b3eb962ff3786a7f_638033529889049769"
      },
      "BackdropImageTags": [
        "1bd38b328ef8435137654d67fcc0734c_638097120721072565"
      ]
    },
    {
      "Name": "Shaun Murphy",
      "ServerId": "fccaa6f897f140dbb689938224ae1938",
      "Id": "273530",
      "RunTimeTicks": 3397224640,
      "IsFolder": true,
      "Type": "MusicArtist",
      "ImageTags": {
        "Primary": "4637ba37f95f3940d88e003bc35b2ec8_638097065787485384"
      },
      "BackdropImageTags": []
    },
    {
      "Name": "Mic Murphy",
      "ServerId": "fccaa6f897f140dbb689938224ae1938",
      "Id": "274923",
      "RunTimeTicks": 2981403000,
      "IsFolder": true,
      "Type": "MusicArtist",
      "ImageTags": {
        "Primary": "57f04604a6194ac8e2946dc0bc45e6ed_638507489222057389"
      },
      "BackdropImageTags": []
    },
    {
      "Name": "Dan Murphy",
      "ServerId": "fccaa6f897f140dbb689938224ae1938",
      "Id": "275244",
      "RunTimeTicks": 6100114280,
      "IsFolder": true,
      "Type": "MusicArtist",
      "ImageTags": {
        "Primary": "022ce5cd558c6404ad48c0bf6981281c_638507495219171926"
      },
      "BackdropImageTags": []
    },
    {
      "Name": "John Murphy",
      "ServerId": "fccaa6f897f140dbb689938224ae1938",
      "Id": "275862",
      "RunTimeTicks": 4369502170,
      "IsFolder": true,
      "Type": "MusicArtist",
      "ImageTags": {
        "Primary": "657ccbccac3d27866a0e695a55f63098_638097083903475827",
        "Logo": "90fb9b4098cfd3395a86bad89cf94435_638097083903616233"
      },
      "BackdropImageTags": [
        "43482f8e60bc678294a8c03c926a43e2_638444387965774389",
        "1d0e3ffe4a11395dad7d702df968c386_638097083903855994"
      ]
    },
    {
      "Name": "Spider Murphy Gang",
      "ServerId": "fccaa6f897f140dbb689938224ae1938",
      "Id": "269331",
      "RunTimeTicks": 2159542500,
      "IsFolder": true,
      "Type": "MusicArtist",
      "ImageTags": {
        "Primary": "ed3af710b0390a74a3aa2791578ae969_638097016309373078"
      },
      "BackdropImageTags": [
        "5986ed5bfb1eb8916461fc0040a12640_638444338553862967",
        "b54023dfbc5a3bdd12871c9b8f713c95_638097016309742251"
      ]
    }
  ],
  "TotalRecordCount": 17
}

"Play x-ray spex"

"there was a problem with the skills response"......again right search term selected by skill... 

2026-06-08 19:47:30.327 Debug ItemsService-0HNM57JC6DNEH:00000001: http/1.1 GET https://‌‍‍xxx.xxx.xxx‌/emby/Users/ba605147d56742b1b91f1e90f91db45c/Items?Recursive=true&IncludeItemTypes=MusicArtist&SearchTerm=x-ray spex&UserId=‌ba605147d56742b1b91f1e90f91db45c‌&api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌. Source Ip: ‌‍‍3.254.84.43‌, UserAgent: 
2026-06-08 19:47:35.689 Info SqliteItemRepository: Interrupt query due to cancellation.
2026-06-08 19:47:35.689 Debug App: Sqlite: 9 - statement aborts at 0: interrupted; [SELECT pgno FROM 'main'.'fts_search9_idx' WHERE segid=? AND term<=? ORDER BY term DESC LIMIT 1]
2026-06-08 19:47:35.689 Debug App: Sqlite: 9 - statement aborts at 5: interrupted; [SELECT rowid, rank FROM 'main'.'fts_search9' ORDER BY bm25("fts_search9") ASC]
2026-06-08 19:47:35.689 Debug App: Sqlite: 9 - statement aborts at 54: interrupted; [with WithAncestors AS (SELECT itemid FROM AncestorIds2 WHERE AncestorId=57475 ),WithItemLinkItemIds AS (select ItemLinks2.LinkedId From ItemLinks2 join withancestors on withancestors.itemid=itemlinks2.itemid  where ItemLinks2.Type in (0,1,5))select A.Id,A.Name,A.RunTimeTicks,A.Images,UserDatas.IsFavorite from mediaitems A join fts_search9 on A.Id=fts_search9.RowId and fts_search9 match @SearchTerm left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And UserDatas.UserId=17 where A.Type=13 AND A.Id in WithItemLinkItemIds ORDER BY Rank ASC]
2026-06-08 19:47:35.690 Info ItemsService-0HNM57JC6DNEH:00000001: http/1.1 Response completed after client disconnected to ‌‍‍3.254.84.43‌. Time: 5362ms. GET https://‌‍‍xxx.xxx.xxx‌/emby/Users/ba605147d56742b1b91f1e90f91db45c/Items?Recursive=true&IncludeItemTypes=MusicArtist&SearchTerm=x-ray spex&UserId=‌ba605147d56742b1b91f1e90f91db45c‌&api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌. 
2026-06-08 19:47:35.720 Debug ItemsService-0HNM57JC6DNEI:00000001: http/1.1 GET https://‌‍‍xxx.xxx.xxx‌/emby/Users/ba605147d56742b1b91f1e90f91db45c/Items?Recursive=true&IncludeItemTypes=MusicArtist&SearchTerm=x ray spex&UserId=‌ba605147d56742b1b91f1e90f91db45c‌&api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌. Source Ip: ‌‍‍3.254.84.43‌, UserAgent: 
2026-06-08 19:47:38.181 Info SqliteItemRepository: Interrupt query due to cancellation.
2026-06-08 19:47:38.181 Debug App: Sqlite: 9 - statement aborts at 0: interrupted; [SELECT pgno FROM 'main'.'fts_search9_idx' WHERE segid=? AND term<=? ORDER BY term DESC LIMIT 1]
2026-06-08 19:47:38.181 Debug App: Sqlite: 9 - statement aborts at 5: interrupted; [SELECT rowid, rank FROM 'main'.'fts_search9' ORDER BY bm25("fts_search9") ASC]
2026-06-08 19:47:38.181 Debug App: Sqlite: 9 - statement aborts at 54: interrupted; [with WithAncestors AS (SELECT itemid FROM AncestorIds2 WHERE AncestorId=57475 ),WithItemLinkItemIds AS (select ItemLinks2.LinkedId From ItemLinks2 join withancestors on withancestors.itemid=itemlinks2.itemid  where ItemLinks2.Type in (0,1,5))select A.Id,A.Name,A.RunTimeTicks,A.Images,UserDatas.IsFavorite from mediaitems A join fts_search9 on A.Id=fts_search9.RowId and fts_search9 match @SearchTerm left join UserDatas on A.UserDataKeyId=UserDatas.UserDataKeyId And UserDatas.UserId=17 where A.Type=13 AND A.Id in WithItemLinkItemIds ORDER BY Rank ASC]
2026-06-08 19:47:38.182 Info ItemsService-0HNM57JC6DNEI:00000001: http/1.1 Response completed after client disconnected to ‌‍‍3.254.84.43‌. Time: 2461ms. GET https://‌‍‍xxx.xxx.xxx‌/emby/Users/ba605147d56742b1b91f1e90f91db45c/Items?Recursive=true&IncludeItemTypes=MusicArtist&SearchTerm=x ray spex&UserId=‌ba605147d56742b1b91f1e90f91db45c‌&api_key=‌c8c89131fa594134b37205e7dcd8c7e0‌.

about 20 issues over 898 album artists...i will move on to test 9941 artists (not really).

I wonder if the Albumartist type is your friend in some circumstances to search the smaller subset of Album Artists quickly. No doubt i sometimes want content from an Artist but Albumartist is much more likely.

note there is an issue it seems with having to use a userid but you you are

 

Edited by ginjaninja

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...