String being passed as int in postgres

[admorgan]

Steps to reproduce

1. Review Nextcloud Log
   Expected behaviour
2. No logs for music

Actual behaviour

1. Log has SQL errors logged between 10:30pm and 6:30 am. Despite these errors everything appears to work correctly.

Server configuration
Operating system:
Gentoo Linux
Web server:
Nginx
Database:
Postgres
PHP version:
8.1.20
Nextcloud version:
28.0.2

Are you using external storage: No

Are you using encryption: no

Are you using an external user-backend: no

Insert your Nextcloud log here

{"reqId":"ospRiMDvvbjdYaIAJPWy","level":3,"time":"2024-02-22T11:29:59+00:00","remoteAddr":"192.168.1.1","user":"--","app":"index","method":"GET","url":"/apps/music/subsonic/rest/getPlaylist.view?u=admorgan&p=enc:XXXXXXXXXXXXXXXX&v=1.2.0&c=DSub&id=1","message":"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: ""","userAgent":"DSub","version":"28.0.2.5","exception":{"Exception":"Doctrine\DBAL\Exception\DriverException","Message":"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: ""","Code":7,"Trace":[{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1938,"function":"convert","class":"Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1880,"function":"handleDriverException","class":"Doctrine\DBAL\Connection","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/3rdparty/doctrine/dbal/src/Statement.php","line":194,"function":"convertExceptionDuringQuery","class":"Doctrine\DBAL\Connection","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/DB/PreparedStatement.php","line":86,"function":"execute","class":"Doctrine\DBAL\Statement","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/AppFramework/Db/OldNextcloudMapper.php","line":246,"function":"execute","class":"OC\DB\PreparedStatement","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/AppFramework/Db/OldNextcloudMapper.php","line":330,"function":"execute","class":"OCA\Music\AppFramework\Db\OldNextcloudMapper","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Db/BaseMapper.php","line":88,"function":"findEntities","class":"OCA\Music\AppFramework\Db\OldNextcloudMapper","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/AppFramework/BusinessLayer/BusinessLayer.php","line":131,"function":"findById","class":"OCA\Music\Db\BaseMapper","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/BusinessLayer/AlbumBusinessLayer.php","line":60,"function":"findById","class":"OCA\Music\AppFramework\BusinessLayer\BusinessLayer","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/BusinessLayer/AlbumBusinessLayer.php","line":420,"function":"findById","class":"OCA\Music\BusinessLayer\AlbumBusinessLayer","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Controller/SubsonicController.php","line":1374,"function":"injectAlbumsToTracks","class":"OCA\Music\BusinessLayer\AlbumBusinessLayer","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Controller/SubsonicController.php","line":591,"function":"tracksToApi","class":"OCA\Music\Controller\SubsonicController","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Controller/SubsonicController.php","line":181,"function":"getPlaylist","class":"OCA\Music\Controller\SubsonicController","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":230,"function":"handleRequest","class":"OCA\Music\Controller\SubsonicController","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":137,"function":"executeController","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\AppFramework\App","type":"::"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/base.php","line":1069,"function":"match","class":"OC\Route\Router","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/index.php","line":39,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php","Line":87,"Previous":{"Exception":"Doctrine\DBAL\Driver\PDO\Exception","Message":"SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: ""","Code":7,"Trace":[{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":132,"function":"new","class":"Doctrine\DBAL\Driver\PDO\Exception","type":"::"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/3rdparty/doctrine/dbal/src/Statement.php","line":190,"function":"execute","class":"Doctrine\DBAL\Driver\PDO\Statement","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/DB/PreparedStatement.php","line":86,"function":"execute","class":"Doctrine\DBAL\Statement","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/AppFramework/Db/OldNextcloudMapper.php","line":246,"function":"execute","class":"OC\DB\PreparedStatement","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/AppFramework/Db/OldNextcloudMapper.php","line":330,"function":"execute","class":"OCA\Music\AppFramework\Db\OldNextcloudMapper","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Db/BaseMapper.php","line":88,"function":"findEntities","class":"OCA\Music\AppFramework\Db\OldNextcloudMapper","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/AppFramework/BusinessLayer/BusinessLayer.php","line":131,"function":"findById","class":"OCA\Music\Db\BaseMapper","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/BusinessLayer/AlbumBusinessLayer.php","line":60,"function":"findById","class":"OCA\Music\AppFramework\BusinessLayer\BusinessLayer","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/BusinessLayer/AlbumBusinessLayer.php","line":420,"function":"findById","class":"OCA\Music\BusinessLayer\AlbumBusinessLayer","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Controller/SubsonicController.php","line":1374,"function":"injectAlbumsToTracks","class":"OCA\Music\BusinessLayer\AlbumBusinessLayer","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Controller/SubsonicController.php","line":591,"function":"tracksToApi","class":"OCA\Music\Controller\SubsonicController","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Controller/SubsonicController.php","line":181,"function":"getPlaylist","class":"OCA\Music\Controller\SubsonicController","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":230,"function":"handleRequest","class":"OCA\Music\Controller\SubsonicController","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":137,"function":"executeController","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\AppFramework\App","type":"::"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/base.php","line":1069,"function":"match","class":"OC\Route\Router","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/index.php","line":39,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":28,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: ""","Code":"22P02","Trace":[{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/3rdparty/doctrine/dbal/src/Statement.php","line":190,"function":"execute","class":"Doctrine\DBAL\Driver\PDO\Statement","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/DB/PreparedStatement.php","line":86,"function":"execute","class":"Doctrine\DBAL\Statement","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/AppFramework/Db/OldNextcloudMapper.php","line":246,"function":"execute","class":"OC\DB\PreparedStatement","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/AppFramework/Db/OldNextcloudMapper.php","line":330,"function":"execute","class":"OCA\Music\AppFramework\Db\OldNextcloudMapper","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Db/BaseMapper.php","line":88,"function":"findEntities","class":"OCA\Music\AppFramework\Db\OldNextcloudMapper","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/AppFramework/BusinessLayer/BusinessLayer.php","line":131,"function":"findById","class":"OCA\Music\Db\BaseMapper","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/BusinessLayer/AlbumBusinessLayer.php","line":60,"function":"findById","class":"OCA\Music\AppFramework\BusinessLayer\BusinessLayer","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/BusinessLayer/AlbumBusinessLayer.php","line":420,"function":"findById","class":"OCA\Music\BusinessLayer\AlbumBusinessLayer","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Controller/SubsonicController.php","line":1374,"function":"injectAlbumsToTracks","class":"OCA\Music\BusinessLayer\AlbumBusinessLayer","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Controller/SubsonicController.php","line":591,"function":"tracksToApi","class":"OCA\Music\Controller\SubsonicController","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/apps/music/lib/Controller/SubsonicController.php","line":181,"function":"getPlaylist","class":"OCA\Music\Controller\SubsonicController","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":230,"function":"handleRequest","class":"OCA\Music\Controller\SubsonicController","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":137,"function":"executeController","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\AppFramework\App","type":"::"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/lib/base.php","line":1069,"function":"match","class":"OC\Route\Router","type":"->"},{"file":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/index.php","line":39,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud.morgancomputers.net/htdocs/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}},"message":"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: ""","exception":[],"CustomMessage":"An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: """},"id":"65d75eea7a910"}

[paulijar]

Thanks for the report. I'll look into this closer once I have time.

[paulijar]

The problem seems to happen when DSub tries to fetch the playlist with ID 1 (i.e. the first playlist you have created). If this was night time, then DSub has probably been doing some background syncing. Then, something unexpected happens when the back-end tries to attach the album information to one of the tracks on the playlist.

Can you see anything special on any of the tracks on that playlist?