[Bug]: One tag-album for different folder-albums

[zc-devs]

What happened?

Consider the following structure: /<music_folder>/<artist>/<type>/<album>/<song>.
For example:

$ ls /var/music/Nightwish/
Album  Compilation  EP  Live

$ ls /var/music/Nightwish/Album/
'Angels Fall First'  'Dark Passion Play'             'Human. _ll_ Nature'  'Imaginaerum (Orchestral)'   Once                 Wishmaster
'Century Child'      'Endless Forms Most Beautiful'   Imaginaerum           Oceanborn                  'Once (Remastered)'

$ ls /var/music/Nightwish/Live/
'Decades (Live in Buenos Aires)'  'Showtime, Storytime'  'Vehicle of Spirit (Wembley Arena)'

1. For Nightwish Once there are

# media_file
id  |path                                                                          |type |format|title                                    |album|artist   |album_artist|disc_number|track_number|year|genre          |bit_rate|variable_bit_rate|file_size|width|height|parent_path                      |play_count|last_played            |comment|created                |changed                |last_scanned           |children_last_updated  |present|version|mb_release_id                       |mb_recording_id                     |duration          |folder_id|start_position|index_path|
----+------------------------------------------------------------------------------+-----+------+-----------------------------------------+-----+---------+------------+-----------+------------+----+---------------+--------+-----------------+---------+-----+------+---------------------------------+----------+-----------------------+-------+-----------------------+-----------------------+-----------------------+-----------------------+-------+-------+------------------------------------+------------------------------------+------------------+---------+--------------+----------+
2103|Nightwish/Album/Once                                                          |ALBUM|      |                                         |Once |Nightwish|            |           |            |2004|Symphonic metal|        |false            |         |     |      |Nightwish/Album                  |        21|2024-07-29 21:51:50.205|       |2023-08-03 17:37:06.610|2023-08-03 17:37:06.610|2024-11-09 03:00:00.504|2023-08-03 17:37:06.610|true   |      4|                                    |                                    |                  |        1|          -1.0|          |
2150|Nightwish/Album/Once/01 Dark Chest of Wonders.m4a                             |MUSIC|m4a   |Dark Chest of Wonders                    |Once |Nightwish|Nightwish   |          1|           1|2004|Symphonic metal|     256|true             |  9291254|     |      |Nightwish/Album/Once             |         0|                       |       |2020-05-18 18:49:25.000|2020-05-18 18:49:25.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|                                    |                                    | 268.7013151927438|        1|          -1.0|          |
2142|Nightwish/Album/Once/02 Wish I Had an Angel.m4a                               |MUSIC|m4a   |Wish I Had an Angel                      |Once |Nightwish|Nightwish   |          1|           2|2004|Symphonic metal|     256|true             |  8503479|     |      |Nightwish/Album/Once             |         0|                       |       |2020-05-18 18:49:25.000|2020-05-18 18:49:25.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|                                    |                                    |246.06185941043083|        1|          -1.0|          |
2146|Nightwish/Album/Once/03 Nemo.m4a                                              |MUSIC|m4a   |Nemo                                     |Once |Nightwish|Nightwish   |          1|           3|2004|Symphonic metal|     256|true             |  9458447|     |      |Nightwish/Album/Once             |         0|                       |       |2020-05-18 18:49:25.000|2020-05-18 18:49:25.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|                                    |                                    |276.15492063492064|        1|          -1.0|          |
2139|Nightwish/Album/Once/04 Planet Hell.m4a                                       |MUSIC|m4a   |Planet Hell                              |Once |Nightwish|Nightwish   |          1|           4|2004|Symphonic metal|     256|true             |  9703067|     |      |Nightwish/Album/Once             |         0|                       |       |2020-05-18 18:49:26.000|2020-05-18 18:49:26.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|                                    |                                    | 278.8948752834467|        1|          -1.0|          |
2143|Nightwish/Album/Once/05 Creek Mary's Blood.m4a                                |MUSIC|m4a   |Creek Mary's Blood                       |Once |Nightwish|Nightwish   |          1|           5|2004|Symphonic metal|     256|true             | 17056891|     |      |Nightwish/Album/Once             |         0|                       |       |2020-05-18 18:49:26.000|2020-05-18 18:49:26.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|                                    |                                    | 509.4922448979592|        1|          -1.0|          |
2148|Nightwish/Album/Once/06 The Siren.m4a                                         |MUSIC|m4a   |The Siren                                |Once |Nightwish|Nightwish   |          1|           6|2004|Symphonic metal|     256|true             |  9804054|     |      |Nightwish/Album/Once             |         0|                       |       |2020-05-18 18:49:26.000|2020-05-18 18:49:26.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|                                    |                                    | 285.2107029478458|        1|          -1.0|          |
2144|Nightwish/Album/Once/07 Dead Gardens.m4a                                      |MUSIC|m4a   |Dead Gardens                             |Once |Nightwish|Nightwish   |          1|           7|2004|Symphonic metal|     256|true             |  9246142|     |      |Nightwish/Album/Once             |         7|2024-07-29 21:42:51.194|       |2020-05-18 18:49:27.000|2020-05-18 18:49:27.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|                                    |                                    | 268.1440362811791|        1|          -1.0|          |
2141|Nightwish/Album/Once/08 Romanticide.m4a                                       |MUSIC|m4a   |Romanticide                              |Once |Nightwish|Nightwish   |          1|           8|2004|Symphonic metal|     256|true             | 10259455|     |      |Nightwish/Album/Once             |         1|2024-07-29 21:43:42.796|       |2020-05-18 18:49:27.000|2020-05-18 18:49:27.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|                                    |                                    | 298.2138775510204|        1|          -1.0|          |
2145|Nightwish/Album/Once/09 Ghost Love Score.m4a                                  |MUSIC|m4a   |Ghost Love Score                         |Once |Nightwish|Nightwish   |          1|           9|2004|Symphonic metal|     256|true             | 20087873|     |      |Nightwish/Album/Once             |         0|                       |       |2020-05-18 18:49:28.000|2020-05-18 18:49:28.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|                                    |                                    | 602.1166439909297|        1|          -1.0|          |
2138|Nightwish/Album/Once/10 Kuolema Tekee Taiteilijan.m4a                         |MUSIC|m4a   |Kuolema Tekee Taiteilijan                |Once |Nightwish|Nightwish   |          1|          10|2004|Symphonic metal|     256|true             |  8314474|     |      |Nightwish/Album/Once             |         0|                       |       |2020-05-18 18:49:28.000|2020-05-18 18:49:28.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|                                    |                                    |238.60825396825396|        1|          -1.0|          |
2147|Nightwish/Album/Once/11 Higher Than Hope (With Wind Sound Effect).m4a         |MUSIC|m4a   |Higher Than Hope (With Wind Sound Effect)|Once |Nightwish|Nightwish   |          1|          11|2004|Symphonic metal|     256|true             | 11343611|     |      |Nightwish/Album/Once             |         5|2024-07-29 21:45:05.948|       |2020-05-18 18:49:28.000|2020-05-18 18:49:28.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|                                    |                                    |338.03609977324265|        1|          -1.0|          |
2149|Nightwish/Album/Once/12 White Night Fantasy.m4a                               |MUSIC|m4a   |White Night Fantasy                      |Once |Nightwish|Nightwish   |          1|          12|2004|Symphonic metal|     256|true             |  8443879|     |      |Nightwish/Album/Once             |         3|2024-07-29 21:46:58.417|       |2020-05-18 18:49:29.000|2020-05-18 18:49:29.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|                                    |                                    |244.13460317460317|        1|          -1.0|          |
2140|Nightwish/Album/Once/13 Live to Tell the Tale.m4a                             |MUSIC|m4a   |Live to Tell the Tale                    |Once |Nightwish|Nightwish   |          1|          13|2004|Symphonic metal|     256|true             | 10319000|     |      |Nightwish/Album/Once             |         4|2024-07-29 21:51:50.205|       |2020-05-18 18:49:29.000|2020-05-18 18:49:29.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|                                    |                                    | 298.8408163265306|        1|          -1.0|          |
3741|Nightwish/Album/Once (Remastered)                                             |ALBUM|      |                                         |Once |Nightwish|            |           |            |2021|Symphonic Metal|        |false            |         |     |      |Nightwish/Album                  |        11|2024-07-29 21:45:33.944|       |2024-07-28 21:36:10.538|2024-07-28 21:36:10.538|2024-11-09 03:00:00.504|2024-07-28 21:36:10.538|true   |      4|                                    |                                    |                  |        1|          -1.0|          |
3749|Nightwish/Album/Once (Remastered)/01 Nightwish - Dark Chest Of Wonders.m4a    |MUSIC|m4a   |Dark Chest of Wonders                    |Once |Nightwish|Nightwish   |          1|           1|2021|Symphonic Metal|     278|true             |  9422104|     |      |Nightwish/Album/Once (Remastered)|         0|                       |       |2024-07-28 21:30:06.000|2024-07-28 21:30:06.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|be3acbf3-f2ff-45a3-b2d5-9c6e2781707b|24da9484-f122-4d76-9db8-0daed341cd9e|268.77097505668934|        1|          -1.0|          |
3743|Nightwish/Album/Once (Remastered)/02 Nightwish - Wish I Had An Angel.m4a      |MUSIC|m4a   |Wish I Had An Angel                      |Once |Nightwish|Nightwish   |          1|           2|2021|Symphonic Metal|     278|true             |  8637490|     |      |Nightwish/Album/Once (Remastered)|         0|                       |       |2024-07-28 21:30:06.000|2024-07-28 21:30:06.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|be3acbf3-f2ff-45a3-b2d5-9c6e2781707b|ed1393b7-93c4-4a88-9866-2de181338d33|246.01541950113378|        1|          -1.0|          |
3747|Nightwish/Album/Once (Remastered)/03 Nightwish - Nemo.m4a                     |MUSIC|m4a   |Nemo                                     |Once |Nightwish|Nightwish   |          1|           3|2021|Symphonic Metal|     273|true             |  9510843|     |      |Nightwish/Album/Once (Remastered)|         0|                       |       |2024-07-28 21:30:06.000|2024-07-28 21:30:06.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|be3acbf3-f2ff-45a3-b2d5-9c6e2781707b|4246bace-0765-4715-84cb-fbb1e4247f2a| 276.2710204081633|        1|          -1.0|          |
3751|Nightwish/Album/Once (Remastered)/04 Nightwish - Planet Hell.m4a              |MUSIC|m4a   |Planet Hell                              |Once |Nightwish|Nightwish   |          1|           4|2021|Symphonic Metal|     278|true             |  9762038|     |      |Nightwish/Album/Once (Remastered)|         0|                       |       |2024-07-28 21:30:06.000|2024-07-28 21:30:06.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|be3acbf3-f2ff-45a3-b2d5-9c6e2781707b|49219164-87bc-4152-a78f-1265dfb45ba6| 278.0821768707483|        1|          -1.0|          |
3745|Nightwish/Album/Once (Remastered)/05 Nightwish - Creek Mary's Blood.m4a       |MUSIC|m4a   |Creek Mary's Blood                       |Once |Nightwish|Nightwish   |          1|           5|2021|Symphonic Metal|     273|true             | 17546847|     |      |Nightwish/Album/Once (Remastered)|         0|                       |       |2024-07-28 21:30:06.000|2024-07-28 21:30:06.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|be3acbf3-f2ff-45a3-b2d5-9c6e2781707b|7af75d8c-e9c5-445a-94b7-f8f065367132| 510.2817233560091|        1|          -1.0|          |
3750|Nightwish/Album/Once (Remastered)/06 Nightwish - The Siren.m4a                |MUSIC|m4a   |The Siren                                |Once |Nightwish|Nightwish   |          1|           6|2021|Symphonic Metal|     284|true             | 10210040|     |      |Nightwish/Album/Once (Remastered)|         0|                       |       |2024-07-28 21:30:06.000|2024-07-28 21:30:06.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|be3acbf3-f2ff-45a3-b2d5-9c6e2781707b|2ba4907b-1578-466c-bb59-19f970815c5c| 285.3035827664399|        1|          -1.0|          |
3748|Nightwish/Album/Once (Remastered)/07 Nightwish - Dead Gardens.m4a             |MUSIC|m4a   |Dead Gardens                             |Once |Nightwish|Nightwish   |          1|           7|2021|Symphonic Metal|     279|true             |  9448011|     |      |Nightwish/Album/Once (Remastered)|         6|2024-07-29 21:43:41.124|       |2024-07-28 21:30:06.000|2024-07-28 21:30:06.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|be3acbf3-f2ff-45a3-b2d5-9c6e2781707b|e3ac0f9b-cd25-413f-b3bb-2c3e86542834|268.16725623582767|        1|          -1.0|          |
3744|Nightwish/Album/Once (Remastered)/08 Nightwish - Romanticide.m4a              |MUSIC|m4a   |Romanticide                              |Once |Nightwish|Nightwish   |          1|           8|2021|Symphonic Metal|     280|true             | 10539994|     |      |Nightwish/Album/Once (Remastered)|         1|2024-07-29 21:43:12.645|       |2024-07-28 21:30:06.000|2024-07-28 21:30:06.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|be3acbf3-f2ff-45a3-b2d5-9c6e2781707b|7c9bdf2b-1307-4b3e-af5c-cf08bf3e616a| 298.2138775510204|        1|          -1.0|          |
3746|Nightwish/Album/Once (Remastered)/09 Nightwish - Ghost Love Score.m4a         |MUSIC|m4a   |Ghost Love Score                         |Once |Nightwish|Nightwish   |          1|           9|2021|Symphonic Metal|     278|true             | 21082433|     |      |Nightwish/Album/Once (Remastered)|         0|                       |       |2024-07-28 21:30:06.000|2024-07-28 21:30:06.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|be3acbf3-f2ff-45a3-b2d5-9c6e2781707b|fea7ce79-a488-4fde-9f5a-ae9bdf7027b5| 602.1166439909297|        1|          -1.0|          |
3752|Nightwish/Album/Once (Remastered)/10 Nightwish - Kuolema Tekee Taiteilijan.m4a|MUSIC|m4a   |Kuolema Tekee Taiteilijan                |Once |Nightwish|Nightwish   |          1|          10|2021|Symphonic Metal|     265|true             |  7981120|     |      |Nightwish/Album/Once (Remastered)|         0|                       |       |2024-07-28 21:30:06.000|2024-07-28 21:30:06.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|be3acbf3-f2ff-45a3-b2d5-9c6e2781707b|9fcf99c7-e664-4649-a2bf-d4ba1a66e713| 238.5618140589569|        1|          -1.0|          |
3742|Nightwish/Album/Once (Remastered)/11 Nightwish - Higher Than Hope.m4a         |MUSIC|m4a   |Higher Than Hope                         |Once |Nightwish|Nightwish   |          1|          11|2021|Symphonic Metal|     272|true             | 11639703|     |      |Nightwish/Album/Once (Remastered)|         4|2024-07-29 21:45:33.944|       |2024-07-28 21:30:06.000|2024-07-28 21:30:06.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|be3acbf3-f2ff-45a3-b2d5-9c6e2781707b|36093376-9f30-4a07-829e-b7378df29ec3|339.35963718820864|        1|          -1.0|          |

# album

id  |path                |name|artist   |song_count|play_count|last_played            |comment|created                |last_scanned           |present|year|genre          |folder_id|mb_release_id                       |duration         |
----+--------------------+----+---------+----------+----------+-----------------------+-------+-----------------------+-----------------------+-------+----+---------------+---------+------------------------------------+-----------------+
1971|Nightwish/Album/Once|Once|Nightwish|        24|        32|2024-07-29 21:51:50.205|       |2024-07-28 21:30:06.000|2024-11-09 03:00:00.504|true   |2021|Symphonic Metal|        1|be3acbf3-f2ff-45a3-b2d5-9c6e2781707b|7763.754376417232|

As we can see there is one tag-based album with 13+11=24 songs. And there is year 2021 - I think airsonic get first by ID of album from media_file and fill album from it.
In Substreamer it looks like:

I suppose, as both music_folder.path=[Nightwish/Album/Once;Nightwish/Album/Once (Remastered)] album paths start with album.path=Nightwish/Album/Once, songs from both albums show in Substreamer.

2. For Limp Bizkit Significant Other there are

# music_file


id  |path                                                                                                                                                               |type |format|title                                |album            |artist                                                          |album_artist|disc_number|track_number|year|genre      |bit_rate|variable_bit_rate|file_size|width|height|parent_path                                              |play_count|last_played|comment|created                |changed                |last_scanned           |children_last_updated  |present|version|mb_release_id                       |mb_recording_id                     |duration          |folder_id|start_position|index_path|
----+-------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----+------+-------------------------------------+-----------------+----------------------------------------------------------------+------------+-----------+------------+----+-----------+--------+-----------------+---------+-----+------+---------------------------------------------------------+----------+-----------+-------+-----------------------+-----------------------+-----------------------+-----------------------+-------+-------+------------------------------------+------------------------------------+------------------+---------+--------------+----------+
1358|Limp Bizkit/Album/Significant Other (Special edition CD2)                                                                                                          |ALBUM|      |                                     |Significant Other|Limp Bizkit                                                     |            |           |            |2000|Alternative|        |false            |         |     |      |Limp Bizkit/Album                                        |         0|           |       |2023-08-03 17:35:01.485|2023-08-03 17:35:01.485|2024-11-09 03:00:00.504|2023-08-03 17:35:01.485|true   |      4|                                    |                                    |                  |        1|          -1.0|          |
1369|Limp Bizkit/Album/Significant Other (Special edition CD2)/2-01 Limp Bizkit - Break Stuff (live).m4a                                                                |MUSIC|m4a   |Break Stuff (live)                   |Significant Other|Limp Bizkit                                                     |Limp Bizkit |          2|           1|2000|Alternative|     278|true             |  8926403|     |      |Limp Bizkit/Album/Significant Other (Special edition CD2)|         0|           |       |2023-08-01 20:28:20.000|2023-08-01 20:28:20.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|ac422f92-d6c8-4a2b-8d47-72cc7227cc04|0e5e1d4f-8957-44e0-8bdb-b781f04e9b9a| 242.7181859410431|        1|          -1.0|          |
1367|Limp Bizkit/Album/Significant Other (Special edition CD2)/2-02 Limp Bizkit - Re‐Arranged (live).m4a                                                                |MUSIC|m4a   |Re‐Arranged (live)                   |Significant Other|Limp Bizkit                                                     |Limp Bizkit |          2|           2|2000|Alternative|     266|true             | 10345587|     |      |Limp Bizkit/Album/Significant Other (Special edition CD2)|         0|           |       |2023-08-01 20:28:20.000|2023-08-01 20:28:20.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|ac422f92-d6c8-4a2b-8d47-72cc7227cc04|5729a146-980f-4634-b7a6-3ca0659f5c4c|  295.590022675737|        1|          -1.0|          |
1368|Limp Bizkit/Album/Significant Other (Special edition CD2)/2-03 Limp Bizkit - Nookie (live).m4a                                                                     |MUSIC|m4a   |Nookie (live)                        |Significant Other|Limp Bizkit                                                     |Limp Bizkit |          2|           3|2000|Alternative|     266|true             | 13939869|     |      |Limp Bizkit/Album/Significant Other (Special edition CD2)|         0|           |       |2023-08-01 20:28:20.000|2023-08-01 20:28:20.000|2024-11-09 03:00:00.504|1970-01-01 00:00:00.001|true   |      4|ac422f92-d6c8-4a2b-8d47-72cc7227cc04|7d24c926-c8a6-432d-8251-cbd8b30c9225|402.35537414965984|        1|          -1.0|          |
1359|Limp Bizkit/Album/Significant Other (Japan version)                                                                                                                |ALBUM|      |                                     |Significant Other|Limp Bizkit                                                     |            |           |            |1999|Alternative|        |false            |         |     |      |Limp Bizkit/Album                                        |         0|           |       |2023-08-03 17:35:00.509|2023-08-03 17:35:00.509|2024-11-09 03:00:00.504|2023-08-03 17:35:00.509|true   |      4|                                    |                                    |                  |        1|          -1.0|          |
2883|Limp Bizkit/Album/Significant Other (Japan version)/01 Limp Bizkit - Intro.m4a                                                                                     |MUSIC|m4a   |Intro                                |Significant Other|Limp Bizkit                                                     |Limp Bizkit |          1|           1|1999|Alternative|     266|true             |  1400714|     |      |Limp Bizkit/Album/Significant Other (Japan version)      |         0|           |       |2023-08-01 20:23:19.000|2023-08-01 20:23:19.000|2024-09-25 03:00:00.291|1970-01-01 00:00:00.001|false  |      4|83da8985-5ae3-4527-943c-978d20b66eee|d5e488d5-8c10-4634-aefb-9d6c8bc6fb17|  37.8485260770975|        1|          -1.0|          |
2876|Limp Bizkit/Album/Significant Other (Japan version)/02 Limp Bizkit - Just Like This.m4a                                                                            |MUSIC|m4a   |Just Like This                       |Significant Other|Limp Bizkit                                                     |Limp Bizkit |          1|           2|1999|Alternative|     287|true             |  7915400|     |      |Limp Bizkit/Album/Significant Other (Japan version)      |         0|           |       |2023-08-01 20:23:19.000|2023-08-01 20:23:19.000|2024-09-25 03:00:00.291|1970-01-01 00:00:00.001|false  |      4|83da8985-5ae3-4527-943c-978d20b66eee|64766d96-6e5b-42d1-9fd9-21894ed34557|215.08643990929704|        1|          -1.0|          |
2880|Limp Bizkit/Album/Significant Other (Japan version)/03 Limp Bizkit - Nookie.m4a                                                                                    |MUSIC|m4a   |Nookie                               |Significant Other|Limp Bizkit                                                     |Limp Bizkit |          1|           3|1999|Alternative|     268|true             |  9910199|     |      |Limp Bizkit/Album/Significant Other (Japan version)      |         0|           |       |2023-08-01 20:23:19.000|2023-08-01 20:23:19.000|2024-09-25 03:00:00.291|1970-01-01 00:00:00.001|false  |      4|83da8985-5ae3-4527-943c-978d20b66eee|d026e0a0-cd5d-41ed-b894-f4f421391160|289.66893424036283|        1|          -1.0|          |
2881|Limp Bizkit/Album/Significant Other (Japan version)/04 Limp Bizkit - Break Stuff.m4a                                                                               |MUSIC|m4a   |Break Stuff                          |Significant Other|Limp Bizkit                                                     |Limp Bizkit |          1|           4|1999|Alternative|     275|true             |  5904121|     |      |Limp Bizkit/Album/Significant Other (Japan version)      |         0|           |       |2023-08-01 20:23:19.000|2023-08-01 20:23:19.000|2024-09-25 03:00:00.291|1970-01-01 00:00:00.001|false  |      4|83da8985-5ae3-4527-943c-978d20b66eee|c8e00a85-9f7e-4779-a451-7b6890c5f0b9|166.71927437641725|        1|          -1.0|          |
2884|Limp Bizkit/Album/Significant Other (Japan version)/05 Limp Bizkit - Re-Arranged.m4a                                                                               |MUSIC|m4a   |Re-Arranged                          |Significant Other|Limp Bizkit                                                     |Limp Bizkit |          1|           5|1999|Alternative|     287|true             | 12950176|     |      |Limp Bizkit/Album/Significant Other (Japan version)      |         0|           |       |2023-08-01 20:23:19.000|2023-08-01 20:23:19.000|2024-09-25 03:00:00.291|1970-01-01 00:00:00.001|false  |      4|83da8985-5ae3-4527-943c-978d20b66eee|c55f55cc-71fb-45ea-aadf-847cfd8a9017|354.82412698412696|        1|          -1.0|          |
2877|Limp Bizkit/Album/Significant Other (Japan version)/06 Limp Bizkit - I’m Broke.m4a                                                                                 |MUSIC|m4a   |I’m Broke                            |Significant Other|Limp Bizkit                                                     |Limp Bizkit |          1|           6|1999|Alternative|     286|true             |  8742874|     |      |Limp Bizkit/Album/Significant Other (Japan version)      |         0|           |       |2023-08-01 20:23:19.000|2023-08-01 20:23:19.000|2024-09-25 03:00:00.291|1970-01-01 00:00:00.001|false  |      4|83da8985-5ae3-4527-943c-978d20b66eee|0e39f9c5-f04e-4b53-919e-60cdf07f40e3|239.18875283446712|        1|          -1.0|          |
2874|Limp Bizkit/Album/Significant Other (Japan version)/07 Limp Bizkit - Nobody Like You.m4a                                                                           |MUSIC|m4a   |Nobody Like You                      |Significant Other|Limp Bizkit                                                     |Limp Bizkit |          1|           7|1999|Alternative|     294|true             |  9774194|     |      |Limp Bizkit/Album/Significant Other (Japan version)      |         0|           |       |2023-08-01 20:23:19.000|2023-08-01 20:23:19.000|2024-09-25 03:00:00.291|1970-01-01 00:00:00.001|false  |      4|83da8985-5ae3-4527-943c-978d20b66eee|bf014f07-e8db-48e6-9d15-0fb82c2ad3b1|260.06349206349205|        1|          -1.0|          |
2871|Limp Bizkit/Album/Significant Other (Japan version)/08 Limp Bizkit - Don’t Go Off Wandering.m4a                                                                    |MUSIC|m4a   |Don’t Go Off Wandering               |Significant Other|Limp Bizkit                                                     |Limp Bizkit |          1|           8|1999|Alternative|     282|true             |  8662896|     |      |Limp Bizkit/Album/Significant Other (Japan version)      |         0|           |       |2023-08-01 20:23:19.000|2023-08-01 20:23:19.000|2024-09-25 03:00:00.291|1970-01-01 00:00:00.001|false  |      4|83da8985-5ae3-4527-943c-978d20b66eee|308ab935-5a18-4cc7-8d42-d5f9c9016ad7|240.11755102040817|        1|          -1.0|          |
2885|Limp Bizkit/Album/Significant Other (Japan version)/09 Limp Bizkit - 9 Teen 90 Nine.m4a                                                                            |MUSIC|m4a   |9 Teen 90 Nine                       |Significant Other|Limp Bizkit                                                     |Limp Bizkit |          1|           9|1999|Alternative|     279|true             |  9818651|     |      |Limp Bizkit/Album/Significant Other (Japan version)      |         0|           |       |2023-08-01 20:23:19.000|2023-08-01 20:23:19.000|2024-09-25 03:00:00.291|1970-01-01 00:00:00.001|false  |      4|83da8985-5ae3-4527-943c-978d20b66eee|b8a364e0-d794-4da1-b094-2c675187b3b6| 276.0852607709751|        1|          -1.0|          |
2882|Limp Bizkit/Album/Significant Other (Japan version)/10 Limp Bizkit feat. Method Man - N 2 Gether Now.m4a                                                           |MUSIC|m4a   |N 2 Gether Now                       |Significant Other|Limp Bizkit feat. Method Man                                    |Limp Bizkit |          1|          10|1999|Alternative|     209|true             |  7782662|     |      |Limp Bizkit/Album/Significant Other (Japan version)      |         0|           |       |2023-08-01 20:23:19.000|2023-08-01 20:23:19.000|2024-09-25 03:00:00.291|1970-01-01 00:00:00.001|false  |      4|83da8985-5ae3-4527-943c-978d20b66eee|023aa8f9-325c-42df-b88b-89e720cdae27|289.99401360544215|        1|          -1.0|          |
2879|Limp Bizkit/Album/Significant Other (Japan version)/11 Limp Bizkit - Trust_.m4a                                                                                    |MUSIC|m4a   |Trust?                               |Significant Other|Limp Bizkit                                                     |Limp Bizkit |          1|          11|1999|Alternative|     282|true             | 10754171|     |      |Limp Bizkit/Album/Significant Other (Japan version)      |         0|           |       |2023-08-01 20:23:19.000|2023-08-01 20:23:19.000|2024-09-25 03:00:00.291|1970-01-01 00:00:00.001|false  |      4|83da8985-5ae3-4527-943c-978d20b66eee|349322ed-db46-4926-9a1b-db89f287bb82|299.42131519274375|        1|          -1.0|          |
2872|Limp Bizkit/Album/Significant Other (Japan version)/12 Limp Bizkit - No Sex.m4a                                                                                    |MUSIC|m4a   |No Sex                               |Significant Other|Limp Bizkit                                                     |Limp Bizkit |          1|          12|1999|Alternative|     278|true             |  8350677|     |      |Limp Bizkit/Album/Significant Other (Japan version)      |         0|           |       |2023-08-01 20:23:19.000|2023-08-01 20:23:19.000|2024-09-25 03:00:00.291|1970-01-01 00:00:00.001|false  |      4|83da8985-5ae3-4527-943c-978d20b66eee|72711020-d77f-42ec-a675-3fd4f96ae624|234.61442176870747|        1|          -1.0|          |
2878|Limp Bizkit/Album/Significant Other (Japan version)/13 Limp Bizkit - Show Me What You Got.m4a                                                                      |MUSIC|m4a   |Show Me What You Got                 |Significant Other|Limp Bizkit                                                     |Limp Bizkit |          1|          13|1999|Alternative|     287|true             |  9784687|     |      |Limp Bizkit/Album/Significant Other (Japan version)      |         0|           |       |2023-08-01 20:23:19.000|2023-08-01 20:23:19.000|2024-09-25 03:00:00.291|1970-01-01 00:00:00.001|false  |      4|83da8985-5ae3-4527-943c-978d20b66eee|e2d4645b-c2c0-4c51-9287-fae0da8bc12d| 266.9598185941043|        1|          -1.0|          |
2873|Limp Bizkit/Album/Significant Other (Japan version)/14 Limp Bizkit - A Lesson Learned.m4a                                                                          |MUSIC|m4a   |A Lesson Learned                     |Significant Other|Limp Bizkit                                                     |Limp Bizkit |          1|          14|1999|Alternative|     270|true             |  5582281|     |      |Limp Bizkit/Album/Significant Other (Japan version)      |         0|           |       |2023-08-01 20:23:19.000|2023-08-01 20:23:19.000|2024-09-25 03:00:00.291|1970-01-01 00:00:00.001|false  |      4|83da8985-5ae3-4527-943c-978d20b66eee|5458eaf8-0745-406a-b8f0-b06bf174e85c|160.07836734693876|        1|          -1.0|          |
2875|Limp Bizkit/Album/Significant Other (Japan version)/15 Limp Bizkit feat. Matt Pinfield _ Limp Bizkit feat. Les Claypool - Outro _ Radio Sucks _ The Mind of Les.m4a|MUSIC|m4a   |Outro / Radio Sucks / The Mind of Les|Significant Other|Limp Bizkit feat. Matt Pinfield / Limp Bizkit feat. Les Claypool|Limp Bizkit |          1|          15|1999|Alternative|     173|true             |  9738969|     |      |Limp Bizkit/Album/Significant Other (Japan version)      |         0|           |       |2023-08-01 20:23:19.000|2023-08-01 20:23:19.000|2024-09-25 03:00:00.291|1970-01-01 00:00:00.001|false  |      4|83da8985-5ae3-4527-943c-978d20b66eee|ab274405-ecaa-488e-9863-b3d72e1b2707| 438.0908843537415|        1|          -1.0|          |

# album

id |path                                                     |name             |artist     |song_count|play_count|last_played|comment|created                |last_scanned           |present|year|genre      |folder_id|mb_release_id                       |duration         |
---+---------------------------------------------------------+-----------------+-----------+----------+----------+-----------+-------+-----------------------+-----------------------+-------+----+-----------+---------+------------------------------------+-----------------+
150|Limp Bizkit/Album/Significant Other (Special edition CD2)|Significant Other|Limp Bizkit|        18|         0|           |       |2023-08-01 20:28:20.000|2024-11-09 03:00:00.504|true   |1999|Alternative|        1|83da8985-5ae3-4527-943c-978d20b66eee|4709.424761904761|

We can see, that path got from media_file album with lower ID, but songs count is a sum: 3+15=18. Also year got from another media_file album.
In Substreamer it looks like:

I suppose, as only one of music_folder.path=[Limp Bizkit/Album/Significant Other (Special edition CD2);Limp Bizkit/Album/Significant Other (Japan version)] album paths start with album.path=Limp Bizkit/Album/Significant Other (Special edition CD2), songs from only one album show in Substreamer and there is no way to access to another via Albums tab.

Steps to reproduce

^

Version

11.1.4 (Stable)

Version Detail

No response

Operating System

Linux, Docker

Java Version

17

Database

Other

DB Detail

Postgres 16

Configuration paramter

SPRING_DATASOURCE_DRIVER_CLASS_NAME: org.postgresql.Driver
SPRING_DATASOURCE_URL: jdbc:postgresql://postgres:5432/airsonic?stringtype=unspecified
SPRING_SERVLET_MULTIPART_MAX_FILE_SIZE: 1GB
SPRING_SERVLET_MULTIPART_MAX_REQUEST_SIZE: 1GB

Proxy Server

No response

client detail

Substreamer on Android

language

None

Relevant log output

No response