Nextcloud does not sync files from external storage - with postgresql

ℹ️ Support
1

[/details]

Nextcloud version : 15.0.2
Operating system and version : docker version of nextcloud.

The issue you are facing:
Hello, i’m using nextcloud 15.0.2.0 with docker. I migrated my database from sqlite to postgresql and since i’m facing a synchronization problem with external storages.
In fact, the new files inserted directly in S3 are not shown on nextcloud.
This problem exist only when i use postgres. With Sqlite it works perfectly.

I tried to run : “php occ files:scan --all” to synchronization my files but this command take a lot of time (more than 2 hours).

Steps to replicate it:

  1. insall docker
  2. pull nextcloud image
  3. start container
    4- connect to external storage : S3 in my case.
    5- migrate to postgresql : php occ db:convert-type --all-apps pgsql…etc
    6- insert files into the S3 bucket.
    7- look for files in nextcloud.

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

<?php
$CONFIG = array (
  'htaccess.RewriteBase' => '/',
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'apps_paths' =>
  array (
    0 =>
    array (
      'path' => '/var/www/html/apps',
      'url' => '/apps',
      'writable' => false,
    ),
    1 =>
    array (
      'path' => '/var/www/html/custom_apps',
      'url' => '/custom_apps',
      'writable' => true,
    ),
  ),
  'instanceid' => 'ocllz3edvu8k',
  'passwordsalt' => 'TTUNy8GbZbICko4qgpzY9rdirFZOmf',
  'secret' => 'gNmrBY9/kQVfffLow13TE3WZNajUvEVEBrZFFSWeR3Jkm6hj',
  'trusted_domains' =>
  array (
    0 => 'hostmachine:8080',
  ),
  'datadirectory' => '/var/www/html/data',
  'dbtype' => 'pgsql',
  'version' => '15.0.2.0',
  'overwrite.cli.url' => 'http://hostmachine:8080',
  'installed' => true,
  'maintenance' => false,
  'dbname' => 'nextcloud',
  'dbhost' => 'myhost',
  'dbuser' => 'myuser',
  'dbpassword' => 'mypassword',
);