Database conversion: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: ""

[nblock]

Steps to reproduce

1. Create an empty PostgreSQL database
2. Perform a database conversion: ./occ db:convert-type --password <password> --all-apps --clear-schema pgsql <username> <hostname> <database>

Expected behaviour

A working database conversion.

Actual behaviour

oc_filecache
  215/6634 [>---------------------------]   3%
[Doctrine\DBAL\Exception\DriverException]                                                                                                                                                                                                                                            
  An exception occurred while executing 'INSERT INTO oc_filecache ("fileid", "storage", "parent", "name", "mimetype", "mimepart", "mtime", "encrypted", "etag", "path_hash", "storage_mtime", "path", "permissions", "size", "unencrypted_size", "checksum") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["2925", "10", "-1", "", "7", "4", "", "0", "54bf5558e262c", "d41d8cd98f00b204e9800998ecf8427e", "", "", "27", "", "0", null]:  
  SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for integer: ""                                                                                                                                                            
  [Doctrine\DBAL\Driver\PDOException]                                                           
  SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for integer: ""  

  [PDOException]                                                                                
  SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for integer: "" 

Server configuration

Operating system: Arch Linux

Web server: Nginx

Database: SQLite

PHP version: 7.0.7

Nextcloud version: 9.0.50

Updated from an older Nextcloud/ownCloud or fresh install: Updated, starting from ownCloud 3.0

Where did you install Nextcloud from: archive

Signing status (Nextcloud 9.0 and above):

No errors have been found.

List of activated apps:

Enabled:
  - activity: 2.2.1
  - admin_audit: 1.0.0
  - calendar: 1.2.2
  - comments: 0.2
  - contacts: 1.3.1.0
  - dav: 0.1.6
  - federatedfilesharing: 0.1.0
  - federation: 0.0.4
  - files: 1.4.4
  - files_pdfviewer: 0.8.1
  - files_sharing: 0.9.1
  - files_trashbin: 0.8.0
  - files_versions: 1.2.0
  - files_videoplayer: 0.9.8
  - firstrunwizard: 1.1
  - gallery: 14.5.0
  - notes: true
  - notifications: 0.2.3
  - provisioning_api: 0.4.1
  - systemtags: 0.2
  - tasks: true
  - templateeditor: 0.1
  - updatenotification: 0.1.0
Disabled:
  - encryption
  - external
  - files_external
  - files_texteditor
  - user_external
  - user_ldap

Are you using encryption: no

[nblock]

A workaround is to truncate oc_filecache.

Is it actually safe to delete all entries from oc_filecache and rescan all files using ./occ files:scan --all?

[MorrisJobke]

Is it actually safe to delete all entries from oc_filecache and rescan all files using ./occ files:scan --all?

Then you loose all share information as they point to an old fileid, that is not existent anymore.

[nblock]

I deleted the culprit from oc_filecache and all the remaining entries in this table get converted without any issues.