Playback of mp4 Video (record from Pixel phone) fails with
Fehler beim Laden von PXL_ffffff.mp4 in Firefox and Chrome,
in Edge I can hear the sound during playback
I can generate this output in Terminal:
ffmpeg -hide_banner -i PXL_ffff.mp4
Input #0, mov,mp4,m4a,3gp,3g2,mj2, from 'PXL_ffff.mp4':
Metadata:
major_brand : isom
minor_version : 131072
compatible_brands: isomiso2mp41
creation_time : 2024-09-07T22:25:01.000000Z
location ffff
location-eng ffff
com.android.manufacturer: Google
com.android.model: Pixel 8
SpecialTypeID : com.google.android.apps.camera.gallery.specialtype.SpecialType-AMETHYST
com.android.capture.fps: 30.000000
Duration: 00:00:16.42, start: 0.000000, bitrate: 42687 kb/s
Stream #0:0(eng): Data: none (mett / 0x7474656D), 39 kb/s (default)
Metadata:
rotate : 180
creation_time : ffff
handler_name : MetaHandle
Stream #0:1(eng): Audio: aac (mp4a / 0x6134706D), 48000 Hz, stereo, fltp, 192 kb/s (default)
Metadata:
rotate : 180
creation_time : 2024-09-07T22:25:01.000000Z
handler_name : SoundHandle
vendor_id : [0][0][0][0]
Stream #0:2(eng): Video: hevc (Main 10) (hvc1 / 0x31637668), yuv420p10le(tv, bt2020nc/bt2020/arib-std-b67), 3840x2160, 42448 kb/s, SAR 1:1 DAR 16:9, 23.93 fps, 23.92 tbr, 90k tbn, 90k tbc (default)
Metadata:
rotate : 180
creation_time : ffff
handler_name : VideoHandle
vendor_id : [0][0][0][0]
Side data:
displaymatrix: rotation of -180.00 degrees[/details]
Nextcloud version (eg, 29.0.5): Nextcloud Hub 8
Operating system and version (eg, Ubuntu 24.04): Ubuntu 24.04
Apache or nginx version (eg, Apache 2.4.25): Apache2.4
PHP version (eg, 8.3): 8.2
The issue you are facing:
Is this the first time you’ve seen this error? Y
Steps to replicate it:
- playback a uploaded video in Browser on windows 11
The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):
<?php
$CONFIG = array (
),
'datadirectory' => '/mnt/nc',
'overwritewebroot' => '/',
'overwrite.cli.url' => itsthere,
'htaccess.RewriteBase' => '/',
'trusted_proxies' =>
array (
0 => 'yeah',
),
'dbtype' => 'mysql',
'version' => '29.0.6.1',
'dbname' => 'ffff',
'dbhost' => 'localhost', 'dbport' => '',
'dbtableprefix' => 'oc_',
'dbuser' => 'ffff',
'dbpassword' => 'ffff',
'installed' => true,
'maintenance' => false,
'maintenance_window_start' => 5,
'default_phone_region' => 'DE',
'theme' => '',
'log_type' => 'file',
'logfile' => '/var/www/html/nextcloud/data/nextcloud.log',
'logtimezone' => 'Europe/Berlin',
'loglevel' => 3,
'filelocking.enabled' => true,
'memcache.local' => '\\OC\\Memcache\\APCu',
'memcache.locking' => '\\OC\\Memcache\\Redis',
'redis' =>
array (
'host' => 'localhost',
'port' => 6379,
'timeout' => 0.0,
),
'updater.release.channel' => 'stable',
'mysql.utf8mb4' => true,
'mail_smtpmode' => 'smtp',
'mail_sendmailmode' => 'smtp',
'app_install_overwrite' =>
array (
0 => 'sharerenamer',
1 => 'documentserver_community',
),
fffff
'memories.exiftool' => '/var/www/html/nextcloud/apps/memories/bin-ext/exiftool-amd64-glibc',
'memories.vod.path' => '/var/www/html/nextcloud/apps/memories/bin-ext/go-vod-amd64',
'enabledPreviewProviders' =>
array (
0 => 'OC\\Preview\\Image',
1 => 'OC\\Preview\\TIFF',
2 => 'OC\\Preview\\Movie',
3 => 'OC\\Preview\\MP4',
),
'memories.db.triggers.fcu' => true,
'ffmpeg' => '/usr/bin/ffmpeg',
'memories.vod.ffmpeg' => '/usr/bin/ffmpeg',
'memories.vod.ffprobe' => '/usr/bin/ffprobe',
);
The output of your Apache/nginx/system log in /var/log/____:
cat /var/log/apache2/error.log
[Sun Sep 08 00:00:01.018729 2024] [mpm_prefork:notice] [pid 132381] AH00163: Apache/2.4.52 (Ubuntu) configured -- resuming normal operations
[Sun Sep 08 00:00:01.018781 2024] [core:notice] [pid 132381] AH00094: Command line: '/usr/sbin/apache2'
[Sun Sep 08 02:00:02.303973 2024] [mpm_prefork:notice] [pid 132381] AH00170: caught SIGWINCH, shutting down gracefully
[Sun Sep 08 02:26:07.432727 2024] [mpm_prefork:notice] [pid 141878] AH00163: Apache/2.4.52 (Ubuntu) configured -- resuming normal operations
[Sun Sep 08 02:26:07.433089 2024] [core:notice] [pid 141878] AH00094: Command line: '/usr/sbin/apache2'
[Sun Sep 08 12:26:30.477721 2024] [mpm_prefork:notice] [pid 141878] AH00170: caught SIGWINCH, shutting down gracefully
[Sun Sep 08 12:26:30.634790 2024] [mpm_prefork:notice] [pid 146095] AH00163: Apache/2.4.52 (Ubuntu) configured -- resuming normal operations
[Sun Sep 08 12:26:30.634825 2024] [core:notice] [pid 146095] AH00094: Command line: '/usr/sbin/apache2'
[Sun Sep 08 12:31:06.259378 2024] [mpm_prefork:notice] [pid 146095] AH00170: caught SIGWINCH, shutting down gracefully
[Sun Sep 08 12:31:06.392668 2024] [mpm_prefork:notice] [pid 146139] AH00163: Apache/2.4.52 (Ubuntu) configured -- resuming normal operations
[Sun Sep 08 12:31:06.392705 2024] [core:notice] [pid 146139] AH00094: Command line: '/usr/sbin/apache2'
[Sun Sep 08 12:34:15.102451 2024] [mpm_prefork:notice] [pid 146139] AH00170: caught SIGWINCH, shutting down gracefully
[Sun Sep 08 12:34:23.723436 2024] [mpm_prefork:notice] [pid 214] AH00163: Apache/2.4.52 (Ubuntu) configured -- resuming normal operations
[Sun Sep 08 12:34:23.723592 2024] [core:notice] [pid 214] AH00094: Command line: '/usr/sbin/apache2'
Output errors in nextcloud.log in /var/www/ or as admin user in top right menu, filtering for errors. Use a pastebin service if necessary.
{"reqId":"YvroGo00pVGj5B3XBVjC","level":0,"time":"2024-09-08T12:26:34+02:00","remoteAddr":"87.166.90.216","user":"me","app":"no app in context","method":"GET","url":"/remote.php/dav/files/me/SofortUpload/Camera/PXL_20240907_222440560.mp4","message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`storage` = :dcValue1) AND (`path_hash` = :dcValue2)","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:131.0) Gecko/20100101 Firefox/131.0","version":"29.0.6.1","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`storage` = :dcValue1) AND (`path_hash` = :dcValue2)","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":344,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php","line":384,"function":"executeQuery","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":280,"function":"execute","class":"Doctrine\\DBAL\\Query\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/Cache.php","line":164,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Cache/HomeCache.php","line":57,"function":"get","class":"OC\\Files\\Cache\\Cache","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":1336,"function":"get","class":"OC\\Files\\Cache\\HomeCache","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":1383,"function":"getCacheEntry","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Node/HookConnector.php","line":226,"function":"getFileInfo","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/Node/HookConnector.php","line":217,"function":"getNodeForPath","class":"OC\\Files\\Node\\HookConnector","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/legacy/OC_Hook.php","line":105,"function":"read","class":"OC\\Files\\Node\\HookConnector","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":1291,"function":"emit","class":"OC_Hook","type":"::"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":1154,"function":"runHooks","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Files/View.php","line":997,"function":"basicOperation","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Connector/Sabre/File.php","line":499,"function":"fopen","class":"OC\\Files\\View","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":85,"function":"get","class":"OCA\\DAV\\Connector\\Sabre\\File","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpGet","class":"Sabre\\DAV\\CorePlugin","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":253,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php","line":321,"function":"start","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/lib/Server.php","line":385,"function":"exec","class":"Sabre\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php","line":35,"function":"exec","class":"OCA\\DAV\\Server","type":"->"},{"file":"/var/www/html/nextcloud/remote.php","line":172,"args":["/var/www/html/nextcloud/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/html/nextcloud/lib/private/DB/Connection.php","Line":320,"message":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`storage` = :dcValue1) AND (`path_hash` = :dcValue2)","tables":["oc_filecache"],"reads":["oc_filecache","oc_filecache_extended","oc_files_metadata"],"exception":{},"CustomMessage":"dirty table reads: SELECT `filecache`.`fileid`, `storage`, `path`, `path_hash`, `filecache`.`parent`, `filecache`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `filecache`.`permissions`, `checksum`, `unencrypted_size`, `metadata_etag`, `creation_time`, `upload_time`, `meta`.`json` AS `meta_json`, `meta`.`sync_token` AS `meta_sync_token` FROM `*PREFIX*filecache` `filecache` LEFT JOIN `*PREFIX*filecache_extended` `fe` ON `filecache`.`fileid` = `fe`.`fileid` LEFT JOIN `*PREFIX*files_metadata` `meta` ON `filecache`.`fileid` = `meta`.`file_id` WHERE (`storage` = :dcValue1) AND (`path_hash` = :dcValue2)"}}