Integer size error (out of range) while migrating MySQL to PostgreSQL

ℹ️ Support
1

I’m running NC15 with MariaDB on Debian. I wanted to migrate to PostgreSQL (11). During the convert I got this error:

root@server:/var/www/nextcloud# sudo -u www-data php occ db:convert-type --all-apps --password "__password__" pgsql __user__ localhost __dbname__
Creating schema in new database
oc_migrations
Skipping migrations table because it was already filled by running the migrations
oc_calendar_resources
    0 [>---------------------------]oc_appconfig
 163/163 [============================] 100%oc_storages
 4/4 [============================] 100%oc_calendar_rooms
    0 [>---------------------------]oc_mimetypes
 61/61 [============================] 100%oc_filecache
chunked query, 39 chunks
   100/38989 [>---------------------------]   0%
In AbstractPostgreSQLDriver.php line 92:

  An exception occurred while executing 'INSERT INTO "oc_filecache" ("fileid", "storage", "path", "path_hash", "parent", "name", "mimetype", "mime
  part", "size", "mtime", "storage_mtime", "encrypted", "unencrypted_size", "etag", "permissions", "checksum") VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  , ?, ?, ?, ?, ?, ?)' with params ["340", "3", "", "d41d8cd98f00b204e9800998ecf8427e", "-1", "", "2", "1", "96646122159", "4035913200", "15449476
  86", "0", "0", "5c2d331b57050", "23", ""]:

  SQLSTATE[22003]: Numeric value out of range: 7 ERROR:  value "4035913200" is out of range for type integer

anyone got an idea why?

2

for the record:

$ sudo -u www-data php occ db:convert-filecache-bigint
All tables already up to date!
3

So I logged in my MariaDB server, removed 3 entries with an mtime > 4000000000 and ran the convert command again. Now it works. But something’s not right here!