Loading GPX files fails on most GPX files

I copied some saved tracks from a Garmin Oregon 550 device to my nextcloud 17 instance with maps plugin 0.1.6. Some of those .gpx can be shown on the map, but most don't. The error message in German reads „Laden des Streckeninhalts fehlgeschlagen.“

From the error log I get this for example:

{"reqId":"Vyh3box1MFbiP2ZqnlNA","level":3,"time":"2020-05-12T17:46:24+00:00","remoteAddr":"fd5b:86e0:557e:0:a06b:e017:9f43:5e07","user":"alex","app":"index","method":"GET","url":"/index.php/apps/maps/tracks/182","message":{"Exception":"Doctrine\\DBAL\\Exception\\DriverException","Message":"An exception occurred while executing 'UPDATE `oc_maps_tracks` SET `metadata` = ?, `etag` = ? WHERE `id` = ?' with params [\"{\\\"lat\\\":52.1261667553, \\\"lng\\\":11.6107696854, \\\"name\\\": \\\"Track_12-MAY-20 191632.gpx\\\", \\\"distance\\\": 7582.014, \\\"duration\\\": 1799, \\\"begin\\\": 1589284763, \\\"end\\\": 1589286562, \\\"posel\\\": 19.71, \\\"negel\\\": 92.79, \\\"minel\\\": 104.44, \\\"maxel\\\": 173.66, \\\"maxspd\\\": 29.09, \\\"avgspd\\\": 15.17, \\\"movtime\\\": 1533, \\\"stptime\\\": 280, \\\"movavgspd\\\": 17.81, \\\"n\\\": 52.14810630, \\\"s\\\": 52.12613432, \\\"e\\\": 11.65935874, \\\"w\\\": 11.60873624, \\\"trnl\\\": [\\\"12-MAY-20 19:16:32\\\"], \\\"lnkurl\\\": \\\"http:\\/\\/www.garmin.com\\\", \\\"lnktxt\\\": \\\"Garmin International\\\", \\\"movpace\\\": 3.37}\", \"349866873230bfb6664fe0077873880c\", 182]:\n\nSQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'metadata' at row 1","Code":0,"Trace":[{"file":"/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":169,"function":"convertException","class":"Doctrine\\DBAL\\Driver\\AbstractMySQLDriver","type":"->","args":["An exception occurred while executing 'UPDATE `oc_maps_tracks` SET `metadata` = ?, `etag` = ? WHERE `id` = ?' with params [\"{\\\"lat\\\":52.1261667553, \\\"lng\\\":11.6107696854, \\\"name\\\": \\\"Track_12-MAY-20 191632.gpx\\\", \\\"distance\\\": 7582.014, \\\"duration\\\": 1799, \\\"begin\\\": 1589284763, \\\"end\\\": 1589286562, \\\"posel\\\": 19.71, \\\"negel\\\": 92.79, \\\"minel\\\": 104.44, \\\"maxel\\\": 173.66, \\\"maxspd\\\": 29.09, \\\"avgspd\\\": 15.17, \\\"movtime\\\": 1533, \\\"stptime\\\": 280, \\\"movavgspd\\\": 17.81, \\\"n\\\": 52.14810630, \\\"s\\\": 52.12613432, \\\"e\\\": 11.65935874, \\\"w\\\": 11.60873624, \\\"trnl\\\": [\\\"12-MAY-20 19:16:32\\\"], \\\"lnkurl\\\": \\\"http:\\/\\/www.garmin.com\\\", \\\"lnktxt\\\": \\\"Garmin International\\\", \\\"movpace\\\": 3.37}\", \"349866873230bfb6664fe0077873880c\", 182]:\n\nSQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'metadata' at row 1",{"errorInfo":["22001",1406,"Data too long for column 'metadata' at row 1"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"}]},{"file":"/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php","line":145,"function":"wrapException","class":"Doctrine\\DBAL\\DBALException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOMySql\\Driver"},{"errorInfo":["22001",1406,"Data too long for column 'metadata' at row 1"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"An exception occurred while executing 'UPDATE `oc_maps_tracks` SET `metadata` = ?, `etag` = ? WHERE `id` = ?' with params [\"{\\\"lat\\\":52.1261667553, \\\"lng\\\":11.6107696854, \\\"name\\\": \\\"Track_12-MAY-20 191632.gpx\\\", \\\"distance\\\": 7582.014, \\\"duration\\\": 1799, \\\"begin\\\": 1589284763, \\\"end\\\": 1589286562, \\\"posel\\\": 19.71, \\\"negel\\\": 92.79, \\\"minel\\\": 104.44, \\\"maxel\\\": 173.66, \\\"maxspd\\\": 29.09, \\\"avgspd\\\": 15.17, \\\"movtime\\\": 1533, \\\"stptime\\\": 280, \\\"movavgspd\\\": 17.81, \\\"n\\\": 52.14810630, \\\"s\\\": 52.12613432, \\\"e\\\": 11.65935874, \\\"w\\\": 11.60873624, \\\"trnl\\\": [\\\"12-MAY-20 19:16:32\\\"], \\\"lnkurl\\\": \\\"http:\\/\\/www.garmin.com\\\", \\\"lnktxt\\\": \\\"Garmin International\\\", \\\"movpace\\\": 3.37}\", \"349866873230bfb6664fe0077873880c\", 182]:\n\nSQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'metadata' at row 1"]},{"file":"/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1063,"function":"driverExceptionDuringQuery","class":"Doctrine\\DBAL\\DBALException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOMySql\\Driver"},{"errorInfo":["22001",1406,"Data too long for column 'metadata' at row 1"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"UPDATE `oc_maps_tracks` SET `metadata` = ?, `etag` = ? WHERE `id` = ?",{"1":"{\"lat\":52.1261667553, \"lng\":11.6107696854, \"name\": \"Track_12-MAY-20 191632.gpx\", \"distance\": 7582.014, \"duration\": 1799, \"begin\": 1589284763, \"end\": 1589286562, \"posel\": 19.71, \"negel\": 92.79, \"minel\": 104.44, \"maxel\": 173.66, \"maxspd\": 29.09, \"avgspd\": 15.17, \"movtime\": 1533, \"stptime\": 280, \"movavgspd\": 17.81, \"n\": 52.14810630, \"s\": 52.12613432, \"e\": 11.65935874, \"w\": 11.60873624, \"trnl\": [\"12-MAY-20 19:16:32\"], \"lnkurl\": \"http://www.garmin.com\", \"lnktxt\": \"Garmin International\", \"movpace\": 3.37}","2":"349866873230bfb6664fe0077873880c","3":182}]},{"file":"/srv/nextcloud/lib/private/DB/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `oc_maps_tracks` SET `metadata` = ?, `etag` = ? WHERE `id` = ?",["{\"lat\":52.1261667553, \"lng\":11.6107696854, \"name\": \"Track_12-MAY-20 191632.gpx\", \"distance\": 7582.014, \"duration\": 1799, \"begin\": 1589284763, \"end\": 1589286562, \"posel\": 19.71, \"negel\": 92.79, \"minel\": 104.44, \"maxel\": 173.66, \"maxspd\": 29.09, \"avgspd\": 15.17, \"movtime\": 1533, \"stptime\": 280, \"movavgspd\": 17.81, \"n\": 52.14810630, \"s\": 52.12613432, \"e\": 11.65935874, \"w\": 11.60873624, \"trnl\": [\"12-MAY-20 19:16:32\"], \"lnkurl\": \"http://www.garmin.com\", \"lnktxt\": \"Garmin International\", \"movpace\": 3.37}","349866873230bfb6664fe0077873880c",182],[2,2,1]]},{"file":"/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":203,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["UPDATE `oc_maps_tracks` SET `metadata` = :dcValue2, `etag` = :dcValue3 WHERE `id` = :dcValue4",{"dcValue1":"182","dcValue2":"{\"lat\":52.1261667553, \"lng\":11.6107696854, \"name\": \"Track_12-MAY-20 191632.gpx\", \"distance\": 7582.014, \"duration\": 1799, \"begin\": 1589284763, \"end\": 1589286562, \"posel\": 19.71, \"negel\": 92.79, \"minel\": 104.44, \"maxel\": 173.66, \"maxspd\": 29.09, \"avgspd\": 15.17, \"movtime\": 1533, \"stptime\": 280, \"movavgspd\": 17.81, \"n\": 52.14810630, \"s\": 52.12613432, \"e\": 11.65935874, \"w\": 11.60873624, \"trnl\": [\"12-MAY-20 19:16:32\"], \"lnkurl\": \"http://www.garmin.com\", \"lnktxt\": \"Garmin International\", \"movpace\": 3.37}","dcValue3":"349866873230bfb6664fe0077873880c","dcValue4":182},{"dcValue1":1,"dcValue2":2,"dcValue3":2,"dcValue4":1}]},{"file":"/srv/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":214,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/srv/nextcloud/apps/maps/lib/Service/TracksService.php","line":307,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/srv/nextcloud/apps/maps/lib/Controller/TracksController.php","line":121,"function":"editTrackInDB","class":"OCA\\Maps\\Service\\TracksService","type":"->","args":[182,null,"{\"lat\":52.1261667553, \"lng\":11.6107696854, \"name\": \"Track_12-MAY-20 191632.gpx\", \"distance\": 7582.014, \"duration\": 1799, \"begin\": 1589284763, \"end\": 1589286562, \"posel\": 19.71, \"negel\": 92.79, \"minel\": 104.44, \"maxel\": 173.66, \"maxspd\": 29.09, \"avgspd\": 15.17, \"movtime\": 1533, \"stptime\": 280, \"movavgspd\": 17.81, \"n\": 52.14810630, \"s\": 52.12613432, \"e\": 11.65935874, \"w\": 11.60873624, \"trnl\": [\"12-MAY-20 19:16:32\"], \"lnkurl\": \"http://www.garmin.com\", \"lnktxt\": \"Garmin International\", \"movpace\": 3.37}","349866873230bfb6664fe0077873880c"]},{"file":"/srv/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":170,"function":"getTrackFileContent","class":"OCA\\Maps\\Controller\\TracksController","type":"->","args":["182"]},{"file":"/srv/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":99,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Maps\\Controller\\TracksController"},"getTrackFileContent"]},{"file":"/srv/nextcloud/lib/private/AppFramework/App.php","line":126,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Maps\\Controller\\TracksController"},"getTrackFileContent"]},{"file":"/srv/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php","line":47,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["TracksController","getTrackFileContent",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"id":"182","_route":"maps.tracks.getTrackFileContent"}]},{"function":"__invoke","class":"OC\\AppFramework\\Routing\\RouteActionHandler","type":"->","args":[{"id":"182","_route":"maps.tracks.getTrackFileContent"}]},{"file":"/srv/nextcloud/lib/private/Route/Router.php","line":297,"function":"call_user_func","args":[{"__class__":"OC\\AppFramework\\Routing\\RouteActionHandler"},{"id":"182","_route":"maps.tracks.getTrackFileContent"}]},{"file":"/srv/nextcloud/lib/base.php","line":997,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/maps/tracks/182"]},{"file":"/srv/nextcloud/index.php","line":42,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php","Line":106,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDOException","Message":"SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'metadata' at row 1","Code":"22001","Trace":[{"file":"/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1054,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"/srv/nextcloud/lib/private/DB/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `oc_maps_tracks` SET `metadata` = ?, `etag` = ? WHERE `id` = ?",["{\"lat\":52.1261667553, \"lng\":11.6107696854, \"name\": \"Track_12-MAY-20 191632.gpx\", \"distance\": 7582.014, \"duration\": 1799, \"begin\": 1589284763, \"end\": 1589286562, \"posel\": 19.71, \"negel\": 92.79, \"minel\": 104.44, \"maxel\": 173.66, \"maxspd\": 29.09, \"avgspd\": 15.17, \"movtime\": 1533, \"stptime\": 280, \"movavgspd\": 17.81, \"n\": 52.14810630, \"s\": 52.12613432, \"e\": 11.65935874, \"w\": 11.60873624, \"trnl\": [\"12-MAY-20 19:16:32\"], \"lnkurl\": \"http://www.garmin.com\", \"lnktxt\": \"Garmin International\", \"movpace\": 3.37}","349866873230bfb6664fe0077873880c",182],[2,2,1]]},{"file":"/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":203,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["UPDATE `oc_maps_tracks` SET `metadata` = :dcValue2, `etag` = :dcValue3 WHERE `id` = :dcValue4",{"dcValue1":"182","dcValue2":"{\"lat\":52.1261667553, \"lng\":11.6107696854, \"name\": \"Track_12-MAY-20 191632.gpx\", \"distance\": 7582.014, \"duration\": 1799, \"begin\": 1589284763, \"end\": 1589286562, \"posel\": 19.71, \"negel\": 92.79, \"minel\": 104.44, \"maxel\": 173.66, \"maxspd\": 29.09, \"avgspd\": 15.17, \"movtime\": 1533, \"stptime\": 280, \"movavgspd\": 17.81, \"n\": 52.14810630, \"s\": 52.12613432, \"e\": 11.65935874, \"w\": 11.60873624, \"trnl\": [\"12-MAY-20 19:16:32\"], \"lnkurl\": \"http://www.garmin.com\", \"lnktxt\": \"Garmin International\", \"movpace\": 3.37}","dcValue3":"349866873230bfb6664fe0077873880c","dcValue4":182},{"dcValue1":1,"dcValue2":2,"dcValue3":2,"dcValue4":1}]},{"file":"/srv/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":214,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/srv/nextcloud/apps/maps/lib/Service/TracksService.php","line":307,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/srv/nextcloud/apps/maps/lib/Controller/TracksController.php","line":121,"function":"editTrackInDB","class":"OCA\\Maps\\Service\\TracksService","type":"->","args":[182,null,"{\"lat\":52.1261667553, \"lng\":11.6107696854, \"name\": \"Track_12-MAY-20 191632.gpx\", \"distance\": 7582.014, \"duration\": 1799, \"begin\": 1589284763, \"end\": 1589286562, \"posel\": 19.71, \"negel\": 92.79, \"minel\": 104.44, \"maxel\": 173.66, \"maxspd\": 29.09, \"avgspd\": 15.17, \"movtime\": 1533, \"stptime\": 280, \"movavgspd\": 17.81, \"n\": 52.14810630, \"s\": 52.12613432, \"e\": 11.65935874, \"w\": 11.60873624, \"trnl\": [\"12-MAY-20 19:16:32\"], \"lnkurl\": \"http://www.garmin.com\", \"lnktxt\": \"Garmin International\", \"movpace\": 3.37}","349866873230bfb6664fe0077873880c"]},{"file":"/srv/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":170,"function":"getTrackFileContent","class":"OCA\\Maps\\Controller\\TracksController","type":"->","args":["182"]},{"file":"/srv/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":99,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Maps\\Controller\\TracksController"},"getTrackFileContent"]},{"file":"/srv/nextcloud/lib/private/AppFramework/App.php","line":126,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Maps\\Controller\\TracksController"},"getTrackFileContent"]},{"file":"/srv/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php","line":47,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["TracksController","getTrackFileContent",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"id":"182","_route":"maps.tracks.getTrackFileContent"}]},{"function":"__invoke","class":"OC\\AppFramework\\Routing\\RouteActionHandler","type":"->","args":[{"id":"182","_route":"maps.tracks.getTrackFileContent"}]},{"file":"/srv/nextcloud/lib/private/Route/Router.php","line":297,"function":"call_user_func","args":[{"__class__":"OC\\AppFramework\\Routing\\RouteActionHandler"},{"id":"182","_route":"maps.tracks.getTrackFileContent"}]},{"file":"/srv/nextcloud/lib/base.php","line":997,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/maps/tracks/182"]},{"file":"/srv/nextcloud/index.php","line":42,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":119,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'metadata' at row 1","Code":"22001","Trace":[{"file":"/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","line":117,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php","line":1054,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"/srv/nextcloud/lib/private/DB/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE `oc_maps_tracks` SET `metadata` = ?, `etag` = ? WHERE `id` = ?",["{\"lat\":52.1261667553, \"lng\":11.6107696854, \"name\": \"Track_12-MAY-20 191632.gpx\", \"distance\": 7582.014, \"duration\": 1799, \"begin\": 1589284763, \"end\": 1589286562, \"posel\": 19.71, \"negel\": 92.79, \"minel\": 104.44, \"maxel\": 173.66, \"maxspd\": 29.09, \"avgspd\": 15.17, \"movtime\": 1533, \"stptime\": 280, \"movavgspd\": 17.81, \"n\": 52.14810630, \"s\": 52.12613432, \"e\": 11.65935874, \"w\": 11.60873624, \"trnl\": [\"12-MAY-20 19:16:32\"], \"lnkurl\": \"http://www.garmin.com\", \"lnktxt\": \"Garmin International\", \"movpace\": 3.37}","349866873230bfb6664fe0077873880c",182],[2,2,1]]},{"file":"/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php","line":203,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["UPDATE `oc_maps_tracks` SET `metadata` = :dcValue2, `etag` = :dcValue3 WHERE `id` = :dcValue4",{"dcValue1":"182","dcValue2":"{\"lat\":52.1261667553, \"lng\":11.6107696854, \"name\": \"Track_12-MAY-20 191632.gpx\", \"distance\": 7582.014, \"duration\": 1799, \"begin\": 1589284763, \"end\": 1589286562, \"posel\": 19.71, \"negel\": 92.79, \"minel\": 104.44, \"maxel\": 173.66, \"maxspd\": 29.09, \"avgspd\": 15.17, \"movtime\": 1533, \"stptime\": 280, \"movavgspd\": 17.81, \"n\": 52.14810630, \"s\": 52.12613432, \"e\": 11.65935874, \"w\": 11.60873624, \"trnl\": [\"12-MAY-20 19:16:32\"], \"lnkurl\": \"http://www.garmin.com\", \"lnktxt\": \"Garmin International\", \"movpace\": 3.37}","dcValue3":"349866873230bfb6664fe0077873880c","dcValue4":182},{"dcValue1":1,"dcValue2":2,"dcValue3":2,"dcValue4":1}]},{"file":"/srv/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":214,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->","args":[]},{"file":"/srv/nextcloud/apps/maps/lib/Service/TracksService.php","line":307,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/srv/nextcloud/apps/maps/lib/Controller/TracksController.php","line":121,"function":"editTrackInDB","class":"OCA\\Maps\\Service\\TracksService","type":"->","args":[182,null,"{\"lat\":52.1261667553, \"lng\":11.6107696854, \"name\": \"Track_12-MAY-20 191632.gpx\", \"distance\": 7582.014, \"duration\": 1799, \"begin\": 1589284763, \"end\": 1589286562, \"posel\": 19.71, \"negel\": 92.79, \"minel\": 104.44, \"maxel\": 173.66, \"maxspd\": 29.09, \"avgspd\": 15.17, \"movtime\": 1533, \"stptime\": 280, \"movavgspd\": 17.81, \"n\": 52.14810630, \"s\": 52.12613432, \"e\": 11.65935874, \"w\": 11.60873624, \"trnl\": [\"12-MAY-20 19:16:32\"], \"lnkurl\": \"http://www.garmin.com\", \"lnktxt\": \"Garmin International\", \"movpace\": 3.37}","349866873230bfb6664fe0077873880c"]},{"file":"/srv/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":170,"function":"getTrackFileContent","class":"OCA\\Maps\\Controller\\TracksController","type":"->","args":["182"]},{"file":"/srv/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":99,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Maps\\Controller\\TracksController"},"getTrackFileContent"]},{"file":"/srv/nextcloud/lib/private/AppFramework/App.php","line":126,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Maps\\Controller\\TracksController"},"getTrackFileContent"]},{"file":"/srv/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php","line":47,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["TracksController","getTrackFileContent",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"id":"182","_route":"maps.tracks.getTrackFileContent"}]},{"function":"__invoke","class":"OC\\AppFramework\\Routing\\RouteActionHandler","type":"->","args":[{"id":"182","_route":"maps.tracks.getTrackFileContent"}]},{"file":"/srv/nextcloud/lib/private/Route/Router.php","line":297,"function":"call_user_func","args":[{"__class__":"OC\\AppFramework\\Routing\\RouteActionHandler"},{"id":"182","_route":"maps.tracks.getTrackFileContent"}]},{"file":"/srv/nextcloud/lib/base.php","line":997,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/maps/tracks/182"]},{"file":"/srv/nextcloud/index.php","line":42,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php","Line":117}},"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Firefox/68.0","version":"17.0.6.2","id":"5ebae0f0030ca"}

[index] Error: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'UPDATE `oc_maps_tracks` SET `metadata` = ?, `etag` = ? WHERE `id` = ?' with params ["{\"lat\":52.1261667553, \"lng\":11.6107696854, \"name\": \"Track_12-MAY-20 191632.gpx\", \"distance\": 7582.014, \"duration\": 1799, \"begin\": 1589284763, \"end\": 1589286562, \"posel\": 19.71, \"negel\": 92.79, \"minel\": 104.44, \"maxel\": 173.66, \"maxspd\": 29.09, \"avgspd\": 15.17, \"movtime\": 1533, \"stptime\": 280, \"movavgspd\": 17.81, \"n\": 52.14810630, \"s\": 52.12613432, \"e\": 11.65935874, \"w\": 11.60873624, \"trnl\": [\"12-MAY-20 19:16:32\"], \"lnkurl\": \"http:\/\/www.garmin.com\", \"lnktxt\": \"Garmin International\", \"movpace\": 3.37}", "349866873230bfb6664fe0077873880c", 182]:

SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'metadata' at row 1 at <<closure>>

 0. /srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 169
    Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException("An exception oc ... 1", Doctrine\DBAL\Dr ... ]})
 1. /srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 145
    Doctrine\DBAL\DBALException::wrapException(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "An exception oc ... 1")
 2. /srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php line 1063
    Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBAL\Driver\PDOMySql\Driver {}, Doctrine\DBAL\Dr ... ]}, "UPDATE `oc_maps ... ?", {1: "{\"lat\":52 ... 2})
 3. /srv/nextcloud/lib/private/DB/Connection.php line 216
    Doctrine\DBAL\Connection->executeUpdate("UPDATE `oc_maps ... ?", ["{\"lat\":52.12 ... 2], [2,2,1])
 4. /srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php line 203
    OC\DB\Connection->executeUpdate("UPDATE `oc_maps ... 4", {dcValue1: "182" ... 2}, {dcValue1: 1,dcV ... 1})
 5. /srv/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php line 214
    Doctrine\DBAL\Query\QueryBuilder->execute()
 6. /srv/nextcloud/apps/maps/lib/Service/TracksService.php line 307
    OC\DB\QueryBuilder\QueryBuilder->execute()
 7. /srv/nextcloud/apps/maps/lib/Controller/TracksController.php line 121
    OCA\Maps\Service\TracksService->editTrackInDB(182, null, "{\"lat\":52.126 ... }", "349866873230bfb6664fe0077873880c")
 8. /srv/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 170
    OCA\Maps\Controller\TracksController->getTrackFileContent("182")
 9. /srv/nextcloud/lib/private/AppFramework/Http/Dispatcher.php line 99
    OC\AppFramework\Http\Dispatcher->executeController(OCA\Maps\Controller\TracksController {}, "getTrackFileContent")
10. /srv/nextcloud/lib/private/AppFramework/App.php line 126
    OC\AppFramework\Http\Dispatcher->dispatch(OCA\Maps\Controller\TracksController {}, "getTrackFileContent")
11. /srv/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php line 47
    OC\AppFramework\App::main("TracksController", "getTrackFileContent", OC\AppFramework\ ... {}, {id: "182",_rout ... "})
12. <<closure>>
    OC\AppFramework\Routing\RouteActionHandler->__invoke({id: "182",_rout ... "})
13. /srv/nextcloud/lib/private/Route/Router.php line 297
    undefinedundefinedcall_user_func(OC\AppFramework\ ... {}, {id: "182",_rout ... "})
14. /srv/nextcloud/lib/base.php line 997
    OC\Route\Router->match("/apps/maps/tracks/182")
15. /srv/nextcloud/index.php line 42
    OC::handleRequest()

GET /index.php/apps/maps/tracks/182
from fd5b:86e0:557e:0:a06b:e017:9f43:5e07 by alex at 2020-05-12T17:46:24+00:00

Host is x86 32 bit virtual machine with Debian 10 GNU/Linux, webserver is lighttpd, database is MariaDB, native install, no containers. I can share more information, but I'd like to keep the actual .gpx files private. Contact me via E-Mail, if you need those for debugging.

Start in apps/maps/lib/Service/TracksService.php around line 307 and follow the getTrackFileContent entry point in TracksController.php. Reproduce the failure with an affected GPX file and inspect the metadata update shown in the error log; done means affected GPX files load without the metadata column truncation error.