Database is incomplete, how to debug?
#4
I've done some more troubleshooting, but unfortunately still haven't found a solution.

The first thing I did was double check the tags on some of the files I noticed aren't showing up in my database. They look fine to me. They also show up on my phone just fine, so I don't think it's a tagging issue.

Then I ran the database update with the serial console open like you suggested. I only saw 2 things:

1. A bunch of warnings trying to parse cover.jpg in every folder -- which I guess is to be expected since those aren't music tracks.
2. Some warnings of a hash collision. This is also not unexpected, since I have 3 albums in different folders that are, to MusicBrainz, the "same album."

I removed the offending hash collision files and re-scanned but no new logs appeared beyond the cover.jpg ones, and the tracks are still missing.

I tried running the following in the serial Lua repl, to get a dump of all album titles in the database. I'd like to at least narrow down how many / which albums are missing other than the ones I happened to manually check:

Code:
do
    local albums = database.indexes()[4]

    for album in albums:iter() do
        print(album)
    end
end

But it crashed Tangara (out of memory?)

Code:
Guru Meditation Error: Core  1 panic'ed (Unhandled debug exception).
Debug exception reason: Stack canary watchpoint triggered (console_repl)
Core  1 register dump:
PC      : 0x40230762  PS      : 0x00060136  A0      : 0x80231139  A1      : 0x3ffe0510
A2      : 0x00000002  A3      : 0x3ffe0634  A4      : 0x00000000  A5      : 0x00000000
A6      : 0x00000010  A7      : 0x00000001  A8      : 0xc8e9260b  A9      : 0x3ffc3ca4
A10     : 0x3f4419a8  A11     : 0xffffffff  A12     : 0x00000001  A13     : 0x00000000
A14     : 0x00001034  A15     : 0x3ffb1b40  SAR     : 0x00000008  EXCCAUSE: 0x00000001
EXCVADDR: 0x00000000  LBEG    : 0x4000c28c  LEND    : 0x4000c296  LCOUNT  : 0x00000000


Backtrace: 0x4023075f:0x3ffe0510 0x40231136:0x3ffe0630 0x4022eb6d:0x3ffe0670 0x401ccf71:0x3ffe06d0 0x401c66c9:0x3ffe06f0 0x401c9c79:0x3ffe0710 0x401ca5bd:0x3ffe0770 0x400e9bda:0x3ffe0830 0x40224500:0x3ffe18d0 0x4021f868:0x3ffe1930




ELF file SHA256: 8a2a205cf

Rebooting...
ets Jul 29 2019 12:21:46

rst:0xc (SW_CPU_RESET),boot:0x1f (SPI_FAST_FLASH_BOOT)
configsip: 0, SPIWP:0xee
clk_drv:0x00,q_drv:0x00,d_drv:0x00,cs0_drv:0x00,hd_drv:0x00,wp_drv:0x00
mode:DIO, clock div:1
load:0x3fff0030,len:5128
load:0x40078000,len:15780
load:0x40080400,len:4
load:0x40080404,len:3700
entry 0x400805c4
W (39) esp_psram: Virtual address not enough for PSRAM, map as much as we can. 4MB is mapped
W (51) i2c: This driver is an old driver, please migrate your application code to adapt `driver/i2c_master.h`
W (1062) i2s_common: dma frame num is out of dma buffer size, limited to 1023
W (1062) i2s_common: dma frame num is out of dma buffer size, limited to 1023

Then I decided to try to take a look at the .tangara-db directory contents. Mine looks like this:

Code:
.rwxr-xr-x  153 js 31 Dec  1979 000005.ldb
.rwxr-xr-x 2.1M js 31 Dec  1979 000595.ldb
.rwxr-xr-x 2.1M js 31 Dec  1979 000596.ldb
.rwxr-xr-x 1.3M js 31 Dec  1979 000597.ldb
.rwxr-xr-x  130 js  1 Jan  1980 000617.ldb
.rwxr-xr-x  124 js 31 Dec  1979 000620.ldb
.rwxr-xr-x    0 js 31 Dec  1979 000631.log
.rwxr-xr-x   16 js 31 Dec  1979 CURRENT
.rwxr-xr-x    0 js 31 Dec  1979 LOG
.rwxr-xr-x    0 js 29 Nov  1979 LOG.old
.rwxr-xr-x  606 js 31 Dec  1979 MANIFEST-000630

I ran cat *.ldb | strings and searched for the missing track/album data, and they're in there! It has the full file paths of the tracks, the album titles, and the song titles.

So, I'm still not sure why they're not appearing in the All Albums, All Tracks, or Albums by Artist lists.

I'm open to other suggestions about what to try next. Later tonight, I am planning to wipe my SD card and start fresh, with a smaller subset of my library including these albums to see if they show up then. If that still fails, I'll try converting all the file formats to mp3 or ogg and see if that changes anything.
  Reply


Messages In This Thread
Database is incomplete, how to debug? - by js - 2024-12-19, 04:35 PM
RE: Database is incomplete, how to debug? - by js - 2024-12-20, 02:12 AM
RE: Database is incomplete, how to debug? - by js - 2024-12-20, 01:45 PM
RE: Database is incomplete, how to debug? - by js - 2024-12-20, 11:24 PM
RE: Database is incomplete, how to debug? - by js - 2024-12-21, 01:36 PM
RE: Database is incomplete, how to debug? - by js - 2024-12-21, 08:59 PM
RE: Database is incomplete, how to debug? - by js - 2024-12-21, 10:08 PM

Forum Jump: