Database - Unable to delete song

[manichardtiger]

Hi

Lately I've noticed that the database cannot handle deleted items in the Music root directory

I'm aware of #291 & #127 but this is on a new installation:

Sonerezh v1.2.6, Sqlite
PHP 7.4.5
10.3.22-MariaDB-0+deb10u1
Raspbian 10
Nginx

After running the update attempt, checked log files but with no interesting results:

/var/log/nginx/error/log empty

tail -n 100 /var/www/sonerezh/app/tmp/logs/error.log

ImageComponent::resize() - APP/Controller/Component/ImageComponent.php, line 15
ImgController::index() - APP/Controller/ImgController.php, line 42
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 109

2020-05-11 10:42:26 Warning: Warning (2): exif_read_data(40b43eddbf440e17b6f677ff6f853823.png): File not supported in [/var/www/sonerezh/app/Controller/Component/ImageComponent.php, line 15]
Trace:
ErrorHandler::handleError() - APP/Vendor/cakephp/cakephp/lib/Cake/Error/ErrorHandler.php, line 230
exif_read_data - [internal], line ??
ImageComponent::resize() - APP/Controller/Component/ImageComponent.php, line 15
ImgController::index() - APP/Controller/ImgController.php, line 42
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 109

2020-05-11 11:24:34 Error: [NotFoundException] The requested file was not found
Request URL: /songs/download/14007
Stack Trace:
#0 /var/www/sonerezh/app/Controller/SongsController.php(681): CakeResponse->file()
#1 [internal function]: SongsController->download()
#2 /var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php(499): ReflectionMethod->invokeArgs()
#3 /var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php(193): Controller->invokeAction()
#4 /var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php(167): Dispatcher->_invoke()
#5 /var/www/sonerezh/app/webroot/index.php(109): Dispatcher->dispatch()
#6 {main}
2020-05-11 11:25:45 Error: [NotFoundException] The requested file was not found
Request URL: /songs/download/14007
Stack Trace:
#0 /var/www/sonerezh/app/Controller/SongsController.php(681): CakeResponse->file()
#1 [internal function]: SongsController->download()
#2 /var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php(499): ReflectionMethod->invokeArgs()
#3 /var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php(193): Controller->invokeAction()
#4 /var/www/sonerezh/app/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php(167): Dispatcher->_invoke()
#5 /var/www/sonerezh/app/webroot/index.php(109): Dispatcher->dispatch()
#6 {main}
2020-05-11 11:35:41 Warning: Warning (2): exif_read_data(no-cover.png): File not supported in [/var/www/sonerezh/app/Controller/Component/ImageComponent.php, line 15]
Trace:
ErrorHandler::handleError() - APP/Vendor/cakephp/cakephp/lib/Cake/Error/ErrorHandler.php, line 230
exif_read_data - [internal], line ??
ImageComponent::resize() - APP/Controller/Component/ImageComponent.php, line 15
ImgController::index() - APP/Controller/ImgController.php, line 42
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 109

2020-05-11 12:20:31 Warning: Warning (2): exif_read_data(40b43eddbf440e17b6f677ff6f853823.png): File not supported in [/var/www/sonerezh/app/Controller/Component/ImageComponent.php, line 15]
Trace:
ErrorHandler::handleError() - APP/Vendor/cakephp/cakephp/lib/Cake/Error/ErrorHandler.php, line 230
exif_read_data - [internal], line ??
ImageComponent::resize() - APP/Controller/Component/ImageComponent.php, line 15
ImgController::index() - APP/Controller/ImgController.php, line 42
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 109

2020-05-14 18:24:58 Warning: Warning (2): exif_read_data(no-cover.png): File not supported in [/var/www/sonerezh/app/Controller/Component/ImageComponent.php, line 15]
Trace:
ErrorHandler::handleError() - APP/Vendor/cakephp/cakephp/lib/Cake/Error/ErrorHandler.php, line 230
exif_read_data - [internal], line ??
ImageComponent::resize() - APP/Controller/Component/ImageComponent.php, line 15
ImgController::index() - APP/Controller/ImgController.php, line 42
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 109

2020-05-14 18:25:00 Warning: Warning (2): exif_read_data(40b43eddbf440e17b6f677ff6f853823.png): File not supported in [/var/www/sonerezh/app/Controller/Component/ImageComponent.php, line 15]
Trace:
ErrorHandler::handleError() - APP/Vendor/cakephp/cakephp/lib/Cake/Error/ErrorHandler.php, line 230
exif_read_data - [internal], line ??
ImageComponent::resize() - APP/Controller/Component/ImageComponent.php, line 15
ImgController::index() - APP/Controller/ImgController.php, line 42
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 109

2020-05-15 10:47:57 Warning: Warning (2): exif_read_data(40b43eddbf440e17b6f677ff6f853823.png): File not supported in [/var/www/sonerezh/app/Controller/Component/ImageComponent.php, line 15]
Trace:
ErrorHandler::handleError() - APP/Vendor/cakephp/cakephp/lib/Cake/Error/ErrorHandler.php, line 230
exif_read_data - [internal], line ??
ImageComponent::resize() - APP/Controller/Component/ImageComponent.php, line 15
ImgController::index() - APP/Controller/ImgController.php, line 42
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 109

But I pretty much have the above all the time

tail -n 100 /var/www/sonerezh/app/tmp/logs/debug.log

2020-05-18 17:21:21 Notice: Notice (8): Undefined offset: 0 in [/var/www/sonerezh/app/Controller/SongsController.php, line 198]
Trace:
ErrorHandler::handleError() - APP/Vendor/cakephp/cakephp/lib/Cake/Error/ErrorHandler.php, line 230
SongsController::import() - APP/Controller/SongsController.php, line 198
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 109

2020-05-18 17:21:21 Notice: Notice (8): Trying to access array offset on value of type null in [/var/www/sonerezh/app/Controller/SongsController.php, line 198]
Trace:
ErrorHandler::handleError() - APP/Vendor/cakephp/cakephp/lib/Cake/Error/ErrorHandler.php, line 230
SongsController::import() - APP/Controller/SongsController.php, line 198
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 109

2020-05-18 17:21:21 Notice: Notice (8): Undefined offset: 0 in [/var/www/sonerezh/app/Controller/SongsController.php, line 207]
Trace:
ErrorHandler::handleError() - APP/Vendor/cakephp/cakephp/lib/Cake/Error/ErrorHandler.php, line 230
SongsController::import() - APP/Controller/SongsController.php, line 207
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 109

2020-05-18 17:21:21 Notice: Notice (8): Trying to access array offset on value of type null in [/var/www/sonerezh/app/Controller/SongsController.php, line 207]
Trace:
ErrorHandler::handleError() - APP/Vendor/cakephp/cakephp/lib/Cake/Error/ErrorHandler.php, line 230
SongsController::import() - APP/Controller/SongsController.php, line 207
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 109

2020-05-18 17:21:21 Notice: Notice (8): Undefined offset: 0 in [/var/www/sonerezh/app/Controller/SongsController.php, line 195]
Trace:
ErrorHandler::handleError() - APP/Vendor/cakephp/cakephp/lib/Cake/Error/ErrorHandler.php, line 230
SongsController::import() - APP/Controller/SongsController.php, line 195
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 109

2020-05-18 17:21:21 Notice: Notice (8): Trying to access array offset on value of type null in [/var/www/sonerezh/app/Controller/SongsController.php, line 195]
Trace:
ErrorHandler::handleError() - APP/Vendor/cakephp/cakephp/lib/Cake/Error/ErrorHandler.php, line 230
SongsController::import() - APP/Controller/SongsController.php, line 195
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 109

2020-05-18 17:21:21 Notice: Notice (8): Undefined offset: 0 in [/var/www/sonerezh/app/Controller/SongsController.php, line 198]
Trace:
ErrorHandler::handleError() - APP/Vendor/cakephp/cakephp/lib/Cake/Error/ErrorHandler.php, line 230
SongsController::import() - APP/Controller/SongsController.php, line 198
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 109

2020-05-18 17:21:21 Notice: Notice (8): Trying to access array offset on value of type null in [/var/www/sonerezh/app/Controller/SongsController.php, line 198]
Trace:
ErrorHandler::handleError() - APP/Vendor/cakephp/cakephp/lib/Cake/Error/ErrorHandler.php, line 230
SongsController::import() - APP/Controller/SongsController.php, line 198
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 109

2020-05-18 17:21:21 Notice: Notice (8): Undefined offset: 0 in [/var/www/sonerezh/app/Controller/SongsController.php, line 207]
Trace:
ErrorHandler::handleError() - APP/Vendor/cakephp/cakephp/lib/Cake/Error/ErrorHandler.php, line 230
SongsController::import() - APP/Controller/SongsController.php, line 207
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 109

2020-05-18 17:21:21 Notice: Notice (8): Trying to access array offset on value of type null in [/var/www/sonerezh/app/Controller/SongsController.php, line 207]
Trace:
ErrorHandler::handleError() - APP/Vendor/cakephp/cakephp/lib/Cake/Error/ErrorHandler.php, line 230
SongsController::import() - APP/Controller/SongsController.php, line 207
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php, line 499
Dispatcher::_invoke() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - APP/Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 109

Again nothing interesting

Please note that I can successfully reset the database and re-create it

Any help appreciated!