USB Flash drive intermittently recognized

[dconrow premium]

dconrow premium

10. Oktober 2019 at 0:14 #47259

Hello,

I have a Raspberry Pi 3b+ that’s running the latest Max2Play version. I’ve got a 250GB USB 3.0 flash drive with approximately 40,000 music files attached to one of the USB inputs on the pi. On the Max2Play filesystem page, when I first plug in the USB drive, it shows up, and I’m able to complete a scan through Squeezebox Server. But after a short time (an hour or so), Max2Play tells me that there are no external drives recognized. The Squeezebox server triggers a scan and then deletes all the library information it had previously scanned. I’ve got my Pi set up in a media closet, and don’t touch it typically, so it’s not that the USB drive got moved or something. I’m not sure if this is a fault with the RPi hardware, the USB drive, Max2Play, or Squeezebox server. Any ideas of what is going on? I’ve set Max USB power on the Raspberry settings in Max2Play in the hopes that would solve the problem, but no. For what it’s worth, I’m running the Pi as a server feeding two Squeezebox classics, no audio output on the pi.

Here’s the DEBUG info:

#### FILESYSTEM ####
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/root 30419692 2683476 26471720 10% /
devtmpfs 495416 0 495416 0% /dev
tmpfs 500024 0 500024 0% /dev/shm
tmpfs 500024 52528 447496 11% /run
tmpfs 5120 0 5120 0% /run/lock
tmpfs 500024 0 500024 0% /sys/fs/cgroup
/dev/mmcblk0p1 42136 22498 19638 54% /boot
tmpfs 100004 8 99996 1% /run/user/1000

#### LOAD AVERAGE ####
0.18 0.11 0.07 1/223 8687

#### KERNEL ####
Linux max2play 4.19.30-v7+ #1209 SMP Tue Mar 26 13:14:20 GMT 2019 armv7l GNU/Linux

#### LINUX-VERSION ####
Distributor ID: Raspbian
Description: Raspbian GNU/Linux 9.8 (stretch)
Release: 9.8
Codename: stretch

Here’s the Squeezebox DEBUG:
#### SQUEEZESERVER LOG ####
[19-10-09 14:13:38.7268] Slim::Plugin::FullTextSearch::Plugin::_initPopularTerms (525) Fulltext index missing or outdated – re-building
[19-10-09 14:13:38.7363] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::db selectcol_arrayref failed: no such table: fulltext_terms [for Statement “
SELECT term, d FROM (
SELECT term, SUM(documents) d
FROM fulltext_terms
WHERE NOT col IN (‚*‘, 1, 0) AND LENGTH(term) > 1
GROUP BY term
ORDER BY d DESC
)
WHERE d > 500
„]
[19-10-09 14:13:38.7370] Slim::Schema::Storage::throw_exception (122) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 122)
frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1007)
frame 2: DBIx::Class::Storage::DBI::__ANON__ (/usr/share/perl5/Slim/Plugin/FullTextSearch/Plugin.pm line 532)
frame 3: Slim::Plugin::FullTextSearch::Plugin::_initPopularTerms (/usr/share/perl5/Slim/Plugin/FullTextSearch/Plugin.pm line 118)
frame 4: Slim::Plugin::FullTextSearch::Plugin::__ANON__ (/usr/share/perl5/Slim/Control/Request.pm line 2058)
frame 5: (eval) (/usr/share/perl5/Slim/Control/Request.pm line 2058)
frame 6: Slim::Control::Request::notify (/usr/share/perl5/Slim/Control/Request.pm line 859)
frame 7: Slim::Control::Request::checkNotifications (/usr/sbin/squeezeboxserver line 708)
frame 8: main::idle (/usr/sbin/squeezeboxserver line 677)
frame 9: main::main (/usr/sbin/squeezeboxserver line 1210)

[19-10-09 14:13:38.7377] Slim::Control::Request::notify (2060) Error: Failed notify: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db selectcol_arrayref failed: no such table: fulltext_terms [for Statement “
SELECT term, d FROM (
SELECT term, SUM(documents) d
FROM fulltext_terms
WHERE NOT col IN (‚*‘, 1, 0) AND LENGTH(term) > 1
GROUP BY term
ORDER BY d DESC
)
WHERE d > 500
„] at /usr/share/perl5/Slim/Schema/Storage.pm line 126
[19-10-09 14:13:51.5277] Slim::Plugin::FullTextSearch::Plugin::_initPopularTerms (525) Fulltext index missing or outdated – re-building
[19-10-09 14:13:51.5287] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::db selectcol_arrayref failed: no such table: fulltext_terms [for Statement “
SELECT term, d FROM (
SELECT term, SUM(documents) d
FROM fulltext_terms
WHERE NOT col IN (‚*‘, 1, 0) AND LENGTH(term) > 1
GROUP BY term
ORDER BY d DESC
)
WHERE d > 500
„]
[19-10-09 14:13:51.5294] Slim::Schema::Storage::throw_exception (122) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 122)
frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1007)
frame 2: DBIx::Class::Storage::DBI::__ANON__ (/usr/share/perl5/Slim/Plugin/FullTextSearch/Plugin.pm line 532)
frame 3: Slim::Plugin::FullTextSearch::Plugin::_initPopularTerms (/usr/share/perl5/Slim/Plugin/FullTextSearch/Plugin.pm line 118)
frame 4: Slim::Plugin::FullTextSearch::Plugin::__ANON__ (/usr/share/perl5/Slim/Control/Request.pm line 2058)
frame 5: (eval) (/usr/share/perl5/Slim/Control/Request.pm line 2058)
frame 6: Slim::Control::Request::notify (/usr/share/perl5/Slim/Control/Request.pm line 859)
frame 7: Slim::Control::Request::checkNotifications (/usr/sbin/squeezeboxserver line 708)
frame 8: main::idle (/usr/sbin/squeezeboxserver line 677)
frame 9: main::main (/usr/sbin/squeezeboxserver line 1210)

[19-10-09 14:13:51.5300] Slim::Control::Request::notify (2060) Error: Failed notify: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db selectcol_arrayref failed: no such table: fulltext_terms [for Statement “
SELECT term, d FROM (
SELECT term, SUM(documents) d
FROM fulltext_terms
WHERE NOT col IN (‚*‘, 1, 0) AND LENGTH(term) > 1
GROUP BY term
ORDER BY d DESC
)
WHERE d > 500
„] at /usr/share/perl5/Slim/Schema/Storage.pm line 126
[19-10-09 14:15:53.1837] Slim::Plugin::FullTextSearch::Plugin::_initPopularTerms (525) Fulltext index missing or outdated – re-building
[19-10-09 14:15:53.1850] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::db selectcol_arrayref failed: no such table: fulltext_terms [for Statement “
SELECT term, d FROM (
SELECT term, SUM(documents) d
FROM fulltext_terms
WHERE NOT col IN (‚*‘, 1, 0) AND LENGTH(term) > 1
GROUP BY term
ORDER BY d DESC
)
WHERE d > 500
„]
[19-10-09 14:15:53.1858] Slim::Schema::Storage::throw_exception (122) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 122)
frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1007)
frame 2: DBIx::Class::Storage::DBI::__ANON__ (/usr/share/perl5/Slim/Plugin/FullTextSearch/Plugin.pm line 532)
frame 3: Slim::Plugin::FullTextSearch::Plugin::_initPopularTerms (/usr/share/perl5/Slim/Plugin/FullTextSearch/Plugin.pm line 118)
frame 4: Slim::Plugin::FullTextSearch::Plugin::__ANON__ (/usr/share/perl5/Slim/Control/Request.pm line 2058)
frame 5: (eval) (/usr/share/perl5/Slim/Control/Request.pm line 2058)
frame 6: Slim::Control::Request::notify (/usr/share/perl5/Slim/Control/Request.pm line 859)
frame 7: Slim::Control::Request::checkNotifications (/usr/sbin/squeezeboxserver line 708)
frame 8: main::idle (/usr/sbin/squeezeboxserver line 677)
frame 9: main::main (/usr/sbin/squeezeboxserver line 1210)

[19-10-09 14:15:53.1865] Slim::Control::Request::notify (2060) Error: Failed notify: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db selectcol_arrayref failed: no such table: fulltext_terms [for Statement “
SELECT term, d FROM (
SELECT term, SUM(documents) d
FROM fulltext_terms
WHERE NOT col IN (‚*‘, 1, 0) AND LENGTH(term) > 1
GROUP BY term
ORDER BY d DESC
)
WHERE d > 500
„] at /usr/share/perl5/Slim/Schema/Storage.pm line 126
[19-10-09 14:16:52.3145] Slim::Plugin::FullTextSearch::Plugin::_initPopularTerms (525) Fulltext index missing or outdated – re-building
[19-10-09 14:16:52.3156] Slim::Schema::Storage::throw_exception (122) Error: DBI Exception: DBD::SQLite::db selectcol_arrayref failed: no such table: fulltext_terms [for Statement “
SELECT term, d FROM (
SELECT term, SUM(documents) d
FROM fulltext_terms
WHERE NOT col IN (‚*‘, 1, 0) AND LENGTH(term) > 1
GROUP BY term
ORDER BY d DESC
)
WHERE d > 500
„]
[19-10-09 14:16:52.3163] Slim::Schema::Storage::throw_exception (122) Backtrace:

frame 0: Slim::Utils::Log::logBacktrace (/usr/share/perl5/Slim/Schema/Storage.pm line 122)
frame 1: Slim::Schema::Storage::throw_exception (/usr/share/squeezeboxserver/CPAN/DBIx/Class/Storage/DBI.pm line 1007)
frame 2: DBIx::Class::Storage::DBI::__ANON__ (/usr/share/perl5/Slim/Plugin/FullTextSearch/Plugin.pm line 532)
frame 3: Slim::Plugin::FullTextSearch::Plugin::_initPopularTerms (/usr/share/perl5/Slim/Plugin/FullTextSearch/Plugin.pm line 118)
frame 4: Slim::Plugin::FullTextSearch::Plugin::__ANON__ (/usr/share/perl5/Slim/Control/Request.pm line 2058)
frame 5: (eval) (/usr/share/perl5/Slim/Control/Request.pm line 2058)
frame 6: Slim::Control::Request::notify (/usr/share/perl5/Slim/Control/Request.pm line 859)
frame 7: Slim::Control::Request::checkNotifications (/usr/sbin/squeezeboxserver line 708)
frame 8: main::idle (/usr/sbin/squeezeboxserver line 677)
frame 9: main::main (/usr/sbin/squeezeboxserver line 1210)

[19-10-09 14:16:52.3168] Slim::Control::Request::notify (2060) Error: Failed notify: Carp::Clan::__ANON__(): DBI Exception: DBD::SQLite::db selectcol_arrayref failed: no such table: fulltext_terms [for Statement “
SELECT term, d FROM (
SELECT term, SUM(documents) d
FROM fulltext_terms
WHERE NOT col IN (‚*‘, 1, 0) AND LENGTH(term) > 1
GROUP BY term
ORDER BY d DESC
)
WHERE d > 500
„] at /usr/share/perl5/Slim/Schema/Storage.pm line 126
[19-10-09 16:46:17.1778] Plugins::Spotty::API::__ANON__ (1345) Invalid data

#### PERL VERSION ####
v5.24.1

#### SQUEEZEBOXSERVER PERL VERSION FOUND ####
5.24

• This topic was modified 5 years, 2 months ago by dconrow.

[Heiner premium]

Heiner premium

11. Oktober 2019 at 15:08 #47271

Hi dconrow,

It is very likely that is an issue with insufficient power via USB. With bigger usb drives, especially HDD that don’t have their own power, we recommend using a powered USB hub to make sure the drive receives enough power.