nextcloud / talk-android

📱😀 Video & audio calls through Nextcloud on Android
Other
565 stars 249 forks source link

Cannot login from the app #3039

Closed Dremor closed 9 months ago

Dremor commented 1 year ago

Steps to reproduce

  1. Open the app
  2. Enter server address
  3. Enter credentials
  4. tap on the connexion button

Expected behaviour

Android app log in

Actual behaviour

The app hang with the loader on the connexion button constantly turning. Waiting don't resolve the problem (waited for half an hour)

Device brand and model

Samsung S21 ultra

Android version

12

Nextcloud Talk app version

16.0.3

Nextcloud server version

26.0.1

Talk version

16.0.1

Custom Signaling server configured

None

Custom TURN server configured

None

Custom STUN server configured

None

Android logs

No response

Server log

{"reqId":"LC9XtHZncWNL1OBHXbS3","level":3,"time":"2023-05-19T15:51:04+00:00","remoteAddr":"192.168.0.104","user":"--","app":"index","method":"GET","url":"/apps/theming/icon?v=b6589fc6","message":"Could not get appdata folder for theming","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/114.0","version":"26.0.1.1","exception":{"Exception":"RuntimeException","Message":"Could not get appdata folder for theming","Code":0,"Trace":[{"file":"/var/www/html/lib/private/Files/AppData/AppData.php","line":147,"function":"getAppDataFolder","class":"OC\\Files\\AppData\\AppData","type":"->","args":[]},{"file":"/var/www/html/apps/theming/lib/ImageManager.php","line":383,"function":"newFolder","class":"OC\\Files\\AppData\\AppData","type":"->","args":["global"]},{"file":"/var/www/html/apps/theming/lib/ImageManager.php","line":118,"function":"getRootFolder","class":"OCA\\Theming\\ImageManager","type":"->","args":[]},{"file":"/var/www/html/apps/theming/lib/Controller/IconController.php","line":155,"function":"getImage","class":"OCA\\Theming\\ImageManager","type":"->","args":["favicon"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":230,"function":"getTouchIcon","class":"OCA\\Theming\\Controller\\IconController","type":"->","args":["core"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":137,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Theming\\Controller\\IconController"],"getTouchIcon"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":183,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\Theming\\Controller\\IconController"],"getTouchIcon"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Theming\\Controller\\IconController","getTouchIcon",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["core","theming.Icon.getTouchIcon"]]},{"file":"/var/www/html/lib/base.php","line":1056,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/theming/icon"]},{"file":"/var/www/html/index.php","line":36,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/lib/private/Files/AppData/AppData.php","Line":108,"CustomMessage":"--"}}
{"reqId":"wIr3kyOlzOWVIE3ZeNAt","level":3,"time":"2023-05-19T15:51:22+00:00","remoteAddr":"192.168.0.104","user":"egeorget","app":"no app in context","method":"PUT","url":"/ocs/v2.php/apps/user_status/api/v1/heartbeat?format=json","message":"An exception occurred while executing a query: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint \"user_status_uid_ix\"\nDETAIL:  Key (user_id)=(egeorget) already exists.","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/114.0","version":"26.0.1.1","exception":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":"An exception occurred while executing a query: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint \"user_status_uid_ix\"\nDETAIL:  Key (user_id)=(egeorget) already exists.","Code":7,"Trace":[{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":328,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::","args":[["Doctrine\\DBAL\\Exception\\UniqueConstraintViolationException"]]},{"file":"/var/www/html/lib/public/AppFramework/Db/QBMapper.php","line":138,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/apps/user_status/lib/Listener/UserLiveStatusListener.php","line":104,"function":"insert","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[["OCA\\UserStatus\\Db\\UserStatus",null,"egeorget","online",1684511481,false,null,null,null,null,null]]},{"file":"/var/www/html/lib/private/EventDispatcher/ServiceEventListener.php","line":86,"function":"handle","class":"OCA\\UserStatus\\Listener\\UserLiveStatusListener","type":"->","args":[["OCP\\User\\Events\\UserLiveStatusEvent"]]},{"file":"/var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":251,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->","args":[["OCP\\User\\Events\\UserLiveStatusEvent"],"OCP\\User\\Events\\UserLiveStatusEvent",["Symfony\\Component\\EventDispatcher\\EventDispatcher"]]},{"file":"/var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":73,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->","args":[[["Closure"]],"OCP\\User\\Events\\UserLiveStatusEvent",["OCP\\User\\Events\\UserLiveStatusEvent"]]},{"file":"/var/www/html/lib/private/EventDispatcher/EventDispatcher.php","line":87,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->","args":[["OCP\\User\\Events\\UserLiveStatusEvent"],"OCP\\User\\Events\\UserLiveStatusEvent"]},{"file":"/var/www/html/lib/private/EventDispatcher/EventDispatcher.php","line":99,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->","args":["OCP\\User\\Events\\UserLiveStatusEvent",["OCP\\User\\Events\\UserLiveStatusEvent"]]},{"file":"/var/www/html/apps/user_status/lib/Controller/HeartbeatController.php","line":91,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->","args":[["OCP\\User\\Events\\UserLiveStatusEvent"]]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":230,"function":"heartbeat","class":"OCA\\UserStatus\\Controller\\HeartbeatController","type":"->","args":["online"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":137,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\UserStatus\\Controller\\HeartbeatController"],"heartbeat"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":183,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\UserStatus\\Controller\\HeartbeatController"],"heartbeat"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\UserStatus\\Controller\\HeartbeatController","heartbeat",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["ocs.user_status.Heartbeat.heartbeat"]]},{"file":"/var/www/html/ocs/v1.php","line":64,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/ocsapp/apps/user_status/api/v1/heartbeat"]},{"file":"/var/www/html/ocs/v2.php","line":23,"args":["/var/www/html/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/html/lib/private/DB/Exceptions/DbalException.php","Line":70,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\UniqueConstraintViolationException","Message":"An exception occurred while executing a query: SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint \"user_status_uid_ix\"\nDETAIL:  Key (user_id)=(egeorget) already exists.","Code":7,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1814,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],["Doctrine\\DBAL\\Query"]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1749,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],["Doctrine\\DBAL\\Query"]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1163,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":[["Doctrine\\DBAL\\Driver\\PDO\\Exception"],"INSERT INTO \"oc_user_status\" (\"user_id\", \"status\", \"status_timestamp\", \"is_user_defined\") VALUES(?, ?, ?, ?)",["egeorget","online",1684511481,false],[2,2,1,5]]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":297,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO \"oc_user_status\" (\"user_id\", \"status\", \"status_timestamp\", \"is_user_defined\") VALUES(?, ?, ?, ?)",["egeorget","online",1684511481,false],[2,2,1,5]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":354,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO \"oc_user_status\" (\"user_id\", \"status\", \"status_timestamp\", \"is_user_defined\") VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4)",["egeorget","online",1684511481,false],[2,2,1,5]]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":326,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/public/AppFramework/Db/QBMapper.php","line":138,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/apps/user_status/lib/Listener/UserLiveStatusListener.php","line":104,"function":"insert","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[["OCA\\UserStatus\\Db\\UserStatus",null,"egeorget","online",1684511481,false,null,null,null,null,null]]},{"file":"/var/www/html/lib/private/EventDispatcher/ServiceEventListener.php","line":86,"function":"handle","class":"OCA\\UserStatus\\Listener\\UserLiveStatusListener","type":"->","args":[["OCP\\User\\Events\\UserLiveStatusEvent"]]},{"file":"/var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":251,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->","args":[["OCP\\User\\Events\\UserLiveStatusEvent"],"OCP\\User\\Events\\UserLiveStatusEvent",["Symfony\\Component\\EventDispatcher\\EventDispatcher"]]},{"file":"/var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":73,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->","args":[[["Closure"]],"OCP\\User\\Events\\UserLiveStatusEvent",["OCP\\User\\Events\\UserLiveStatusEvent"]]},{"file":"/var/www/html/lib/private/EventDispatcher/EventDispatcher.php","line":87,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->","args":[["OCP\\User\\Events\\UserLiveStatusEvent"],"OCP\\User\\Events\\UserLiveStatusEvent"]},{"file":"/var/www/html/lib/private/EventDispatcher/EventDispatcher.php","line":99,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->","args":["OCP\\User\\Events\\UserLiveStatusEvent",["OCP\\User\\Events\\UserLiveStatusEvent"]]},{"file":"/var/www/html/apps/user_status/lib/Controller/HeartbeatController.php","line":91,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->","args":[["OCP\\User\\Events\\UserLiveStatusEvent"]]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":230,"function":"heartbeat","class":"OCA\\UserStatus\\Controller\\HeartbeatController","type":"->","args":["online"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":137,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\UserStatus\\Controller\\HeartbeatController"],"heartbeat"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":183,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\UserStatus\\Controller\\HeartbeatController"],"heartbeat"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\UserStatus\\Controller\\HeartbeatController","heartbeat",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["ocs.user_status.Heartbeat.heartbeat"]]},{"file":"/var/www/html/ocs/v1.php","line":64,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/ocsapp/apps/user_status/api/v1/heartbeat"]},{"file":"/var/www/html/ocs/v2.php","line":23,"args":["/var/www/html/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php","Line":57,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint \"user_status_uid_ix\"\nDETAIL:  Key (user_id)=(egeorget) already exists.","Code":7,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":103,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::","args":[["PDOException",["23505",7,"ERROR:  duplicate key value violates unique constraint \"user_status_uid_ix\"\nDETAIL:  Key (user_id)=(egeorget) already exists."]]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1153,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":297,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO \"oc_user_status\" (\"user_id\", \"status\", \"status_timestamp\", \"is_user_defined\") VALUES(?, ?, ?, ?)",["egeorget","online",1684511481,false],[2,2,1,5]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":354,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO \"oc_user_status\" (\"user_id\", \"status\", \"status_timestamp\", \"is_user_defined\") VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4)",["egeorget","online",1684511481,false],[2,2,1,5]]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":326,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/public/AppFramework/Db/QBMapper.php","line":138,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/apps/user_status/lib/Listener/UserLiveStatusListener.php","line":104,"function":"insert","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[["OCA\\UserStatus\\Db\\UserStatus",null,"egeorget","online",1684511481,false,null,null,null,null,null]]},{"file":"/var/www/html/lib/private/EventDispatcher/ServiceEventListener.php","line":86,"function":"handle","class":"OCA\\UserStatus\\Listener\\UserLiveStatusListener","type":"->","args":[["OCP\\User\\Events\\UserLiveStatusEvent"]]},{"file":"/var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":251,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->","args":[["OCP\\User\\Events\\UserLiveStatusEvent"],"OCP\\User\\Events\\UserLiveStatusEvent",["Symfony\\Component\\EventDispatcher\\EventDispatcher"]]},{"file":"/var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":73,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->","args":[[["Closure"]],"OCP\\User\\Events\\UserLiveStatusEvent",["OCP\\User\\Events\\UserLiveStatusEvent"]]},{"file":"/var/www/html/lib/private/EventDispatcher/EventDispatcher.php","line":87,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->","args":[["OCP\\User\\Events\\UserLiveStatusEvent"],"OCP\\User\\Events\\UserLiveStatusEvent"]},{"file":"/var/www/html/lib/private/EventDispatcher/EventDispatcher.php","line":99,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->","args":["OCP\\User\\Events\\UserLiveStatusEvent",["OCP\\User\\Events\\UserLiveStatusEvent"]]},{"file":"/var/www/html/apps/user_status/lib/Controller/HeartbeatController.php","line":91,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->","args":[["OCP\\User\\Events\\UserLiveStatusEvent"]]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":230,"function":"heartbeat","class":"OCA\\UserStatus\\Controller\\HeartbeatController","type":"->","args":["online"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":137,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\UserStatus\\Controller\\HeartbeatController"],"heartbeat"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":183,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\UserStatus\\Controller\\HeartbeatController"],"heartbeat"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\UserStatus\\Controller\\HeartbeatController","heartbeat",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["ocs.user_status.Heartbeat.heartbeat"]]},{"file":"/var/www/html/ocs/v1.php","line":64,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/ocsapp/apps/user_status/api/v1/heartbeat"]},{"file":"/var/www/html/ocs/v2.php","line":23,"args":["/var/www/html/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":30,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[23505]: Unique violation: 7 ERROR:  duplicate key value violates unique constraint \"user_status_uid_ix\"\nDETAIL:  Key (user_id)=(egeorget) already exists.","Code":"23505","Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":101,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1153,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":297,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO \"oc_user_status\" (\"user_id\", \"status\", \"status_timestamp\", \"is_user_defined\") VALUES(?, ?, ?, ?)",["egeorget","online",1684511481,false],[2,2,1,5]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":354,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO \"oc_user_status\" (\"user_id\", \"status\", \"status_timestamp\", \"is_user_defined\") VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4)",["egeorget","online",1684511481,false],[2,2,1,5]]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","line":326,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/lib/public/AppFramework/Db/QBMapper.php","line":138,"function":"executeStatement","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/apps/user_status/lib/Listener/UserLiveStatusListener.php","line":104,"function":"insert","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[["OCA\\UserStatus\\Db\\UserStatus",null,"egeorget","online",1684511481,false,null,null,null,null,null]]},{"file":"/var/www/html/lib/private/EventDispatcher/ServiceEventListener.php","line":86,"function":"handle","class":"OCA\\UserStatus\\Listener\\UserLiveStatusListener","type":"->","args":[["OCP\\User\\Events\\UserLiveStatusEvent"]]},{"file":"/var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":251,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->","args":[["OCP\\User\\Events\\UserLiveStatusEvent"],"OCP\\User\\Events\\UserLiveStatusEvent",["Symfony\\Component\\EventDispatcher\\EventDispatcher"]]},{"file":"/var/www/html/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":73,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->","args":[[["Closure"]],"OCP\\User\\Events\\UserLiveStatusEvent",["OCP\\User\\Events\\UserLiveStatusEvent"]]},{"file":"/var/www/html/lib/private/EventDispatcher/EventDispatcher.php","line":87,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->","args":[["OCP\\User\\Events\\UserLiveStatusEvent"],"OCP\\User\\Events\\UserLiveStatusEvent"]},{"file":"/var/www/html/lib/private/EventDispatcher/EventDispatcher.php","line":99,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->","args":["OCP\\User\\Events\\UserLiveStatusEvent",["OCP\\User\\Events\\UserLiveStatusEvent"]]},{"file":"/var/www/html/apps/user_status/lib/Controller/HeartbeatController.php","line":91,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->","args":[["OCP\\User\\Events\\UserLiveStatusEvent"]]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":230,"function":"heartbeat","class":"OCA\\UserStatus\\Controller\\HeartbeatController","type":"->","args":["online"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":137,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\UserStatus\\Controller\\HeartbeatController"],"heartbeat"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":183,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OCA\\UserStatus\\Controller\\HeartbeatController"],"heartbeat"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\UserStatus\\Controller\\HeartbeatController","heartbeat",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["ocs.user_status.Heartbeat.heartbeat"]]},{"file":"/var/www/html/ocs/v1.php","line":64,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/ocsapp/apps/user_status/api/v1/heartbeat"]},{"file":"/var/www/html/ocs/v2.php","line":23,"args":["/var/www/html/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":101}}},"CustomMessage":"--"}}
{"reqId":"tkfOwRfPEkWKg8wgyoyn","level":3,"time":"2023-05-19T15:51:22+00:00","remoteAddr":"192.168.0.104","user":"egeorget","app":"index","method":"GET","url":"/core/preview?fileId=42&x=250&y=250","message":"Could not get appdata folder for preview","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/114.0","version":"26.0.1.1","exception":{"Exception":"RuntimeException","Message":"Could not get appdata folder for preview","Code":0,"Trace":[{"file":"/var/www/html/lib/private/Files/AppData/AppData.php","line":147,"function":"getAppDataFolder","class":"OC\\Files\\AppData\\AppData","type":"->","args":[]},{"file":"/var/www/html/lib/private/Preview/Storage/Root.php","line":74,"function":"newFolder","class":"OC\\Files\\AppData\\AppData","type":"->","args":["a/1/d/0/c/6/e/42"]},{"file":"/var/www/html/lib/private/Preview/Generator.php","line":685,"function":"newFolder","class":"OC\\Preview\\Storage\\Root","type":"->","args":["42"]},{"file":"/var/www/html/lib/private/Preview/Generator.php","line":139,"function":"getPreviewFolder","class":"OC\\Preview\\Generator","type":"->","args":[["OC\\Files\\Node\\File"]]},{"file":"/var/www/html/lib/private/Preview/Generator.php","line":116,"function":"generatePreviews","class":"OC\\Preview\\Generator","type":"->","args":[["OC\\Files\\Node\\File"],[[250,250,true,"fill"]],"image/jpeg"]},{"file":"/var/www/html/lib/private/PreviewManager.php","line":192,"function":"getPreview","class":"OC\\Preview\\Generator","type":"->","args":[["OC\\Files\\Node\\File"],250,250,true,"fill",null]},{"file":"/var/www/html/core/Controller/PreviewController.php","line":144,"function":"getPreview","class":"OC\\PreviewManager","type":"->","args":[["OC\\Files\\Node\\File"],250,250,true,"fill"]},{"file":"/var/www/html/core/Controller/PreviewController.php","line":113,"function":"fetchPreview","class":"OC\\Core\\Controller\\PreviewController","type":"->","args":[["OC\\Files\\Node\\File"],250,250,false,true,"fill"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":230,"function":"getPreviewByFileId","class":"OC\\Core\\Controller\\PreviewController","type":"->","args":[42,250,250,false,true,"fill"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":137,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OC\\Core\\Controller\\PreviewController"],"getPreviewByFileId"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":183,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[["OC\\Core\\Controller\\PreviewController"],"getPreviewByFileId"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OC\\Core\\Controller\\PreviewController","getPreviewByFileId",["OC\\AppFramework\\DependencyInjection\\DIContainer"],["core.Preview.getPreviewByFileId"]]},{"file":"/var/www/html/lib/base.php","line":1056,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/core/preview"]},{"file":"/var/www/html/index.php","line":36,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/lib/private/Files/AppData/AppData.php","Line":108,"CustomMessage":"--"}}
{"reqId":"Ohy5VBprYjgIJQs0zb2T","level":2,"time":"2023-05-21T11:06:59+00:00","remoteAddr":"172.71.122.216","user":"--","app":"core","method":"GET","url":"/ocs/v2.php/cloud/user","message":"Login failed: 'egeorget' (Remote IP: '172.71.122.216')","userAgent":"Mozilla/5.0 (Android) Nextcloud-Talk v17.0.0 RC3","version":"26.0.1.1","data":{"app":"core"}}
{"reqId":"ZkaouXriBboZSfVCUQxe","level":2,"time":"2023-05-21T11:06:59+00:00","remoteAddr":"172.71.122.216","user":"--","app":"core","method":"GET","url":"/index.php/avatar/egeorget/512","message":"Login failed: 'egeorget' (Remote IP: '172.71.122.216')","userAgent":"Mozilla/5.0 (Android) Nextcloud-Talk v17.0.0 RC3","version":"26.0.1.1","data":{"app":"core"}}
{"reqId":"RHhipwKOuW0RxlERVjpG","level":2,"time":"2023-05-21T11:07:54+00:00","remoteAddr":"172.71.122.216","user":"--","app":"core","method":"GET","url":"/ocs/v2.php/cloud/user","message":"Login failed: 'egeorget' (Remote IP: '172.71.122.216')","userAgent":"Mozilla/5.0 (Android) Nextcloud-Talk v17.0.0 RC3","version":"26.0.1.1","data":{"app":"core"}}
{"reqId":"5AwOMSacjXQIsNx59yqv","level":2,"time":"2023-05-21T11:07:54+00:00","remoteAddr":"172.71.122.216","user":"--","app":"core","method":"GET","url":"/index.php/avatar/egeorget/512","message":"Login failed: 'egeorget' (Remote IP: '172.71.122.216')","userAgent":"Mozilla/5.0 (Android) Nextcloud-Talk v17.0.0 RC3","version":"26.0.1.1","data":{"app":"core"}}
{"reqId":"2vQpKVVvePrmb45c7oSs","level":2,"time":"2023-05-21T11:07:56+00:00","remoteAddr":"172.71.122.217","user":"--","app":"core","method":"POST","url":"/ocs/v2.php/apps/notifications/api/v2/push?devicePublicKey=-----BEGIN%20PUBLIC%20KEY-----%0AMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA5Yyf5kIdPVWpfJWQjdjH%0AEjP%2BZtsO%2B%2BQJjCBscPu25RFMKnHvx0YmcRPSlrSK%2BHnNhrLuGa4mKzQOf4dAzARF%0AmE%2BNNvroc9N4BQfd9HKwXCb6XFLf7ZbEb8cMa2A92R2ctJNygpb1e0eB0CERSvq9%0AsyJKBxgoVLinhdqgGNSBtDLbypwNKp9fBhJEwNgYJF1XdQOqGWGl%2BPQW%2BV%2FB99l8%0AU8IilT6JewJmNcF1pjqQGj6m8D2MLL63bWSexHTHpz9DnBs2zk85qQvXPJjZZwjf%0AB0%2B9iI0A7hHqc65sMJH9WnVm%2FQp5dmonGoRkZHxLK%2FRx18P70uizoMGAB6irMc64%0AGQIDAQAB%0A-----END%20PUBLIC%20KEY-----%0A&proxyServer=https%3A%2F%2Fpush-notifications.nextcloud.com&format=json&pushTokenHash=9fd44a21427e5c3e8bd96442ce391cad5f56e897e3f4668d96c471f7acec160957e6173371039e6c3ae895c9302d7f5248b2fa018e2a2ae92d47ccfecf2c5c51","message":"Login failed: 'egeorget' (Remote IP: '172.71.122.217')","userAgent":"Mozilla/5.0 (Android) Nextcloud-Talk v17.0.0 RC3","version":"26.0.1.1","data":{"app":"core"}}
{"reqId":"vr8bja1kOarx6Vcf4sfr","level":2,"time":"2023-05-21T11:07:58+00:00","remoteAddr":"172.71.122.216","user":"--","app":"core","method":"GET","url":"/index.php/avatar/egeorget/512","message":"Login failed: 'egeorget' (Remote IP: '172.71.122.216')","userAgent":"Mozilla/5.0 (Android) Nextcloud-Talk v17.0.0 RC3","version":"26.0.1.1","data":{"app":"core"}}
{"reqId":"MCrv2CWPILeeVE4zlrcJ","level":2,"time":"2023-05-21T11:07:58+00:00","remoteAddr":"172.71.122.216","user":"--","app":"core","method":"GET","url":"/ocs/v2.php/apps/spreed/api/v4/room?includeStatus=true","message":"Login failed: 'egeorget' (Remote IP: '172.71.122.216')","userAgent":"Mozilla/5.0 (Android) Nextcloud-Talk v17.0.0 RC3","version":"26.0.1.1","data":{"app":"core"}}
{"reqId":"44bzt7WfBFsPnCeZUWAw","level":2,"time":"2023-05-21T11:08:02+00:00","remoteAddr":"172.71.122.217","user":"--","app":"core","method":"DELETE","url":"/ocs/v2.php/apps/notifications/api/v2/push","message":"Login failed: 'egeorget' (Remote IP: '172.71.122.217')","userAgent":"Mozilla/5.0 (Android) Nextcloud-Talk v17.0.0 RC3","version":"26.0.1.1","data":{"app":"core"}}
{"reqId":"bi6fowodKt2E7If6Vety","level":2,"time":"2023-05-21T11:08:08+00:00","remoteAddr":"172.71.134.128","user":"--","app":"core","method":"DELETE","url":"/ocs/v2.php/apps/notifications/api/v2/push","message":"Login failed: 'egeorget' (Remote IP: '172.71.134.128')","userAgent":"Mozilla/5.0 (Android) Nextcloud-Talk v17.0.0 RC3","version":"26.0.1.1","data":{"app":"core"}}

Additional information

This is on a Truenas Scale 22.12.2 server, with the official Nextcloud image. Accessing from the WebUI works fine, only login through the Android app is affected.

The Nextcloud instance is behind a Traefik reverse proxy which handle HTTPS.

Note the multiple login attempt from the 17.0.0 RC3, I don't remember those failed attempts, but I did roll back to 16.0.1 client app, with the same result (and no failed login log since).

mahibi commented 1 year ago

sorry, this issue slipped through. is it still happening (with the newest version)?

lukaszzyla commented 10 months ago

hi! I am still seeing this error sometimes (5-10 times a day for same user) on nextcloud-aio 7.10 with nextcloud 28.0.1 (docker). I can login into web and android app and also nextcloud talk android app. DbalException An exception occurred while executing a query: SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique constraint "user_status_uid_ix" DETAIL: Key (user_id)=(XXXXXXXXX-XXXX-XXXX-XXXXXXXX) already exists. Exception thrown: OC\DB\Exceptions\DbalException

Dremor commented 9 months ago

In my case I resolved it by deploying another Talk instance from scratch. Not an ideal solution, but I needed it back running asap, sorry.

@lukaszzyla it would probably be better to create a new issue