[SVN-4911] SQLite error on HTTP to HTTPS redirect with file externals

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.14.2
• Fix Version/s: 1.15, 1.14.3
• Assignee: Daniel Sahlberg
• Reporter: Nathan Hartman
• Created: 12/Mar/23 21:41
• Updated: 02/Apr/23 20:31
• Resolved: 02/Apr/23 20:31

Description

Users who previously served repositories via HTTP, wish to migrate to HTTPS, configured redirection, and whose repositories use file-externals, are encountering a failure during "svn checkout" or "svn upgrade" when the file-external is encountered.

The command line client prints text similar to:

Redirecting to URL 'https://repo/.../test.txt':
Fetching external item into 'wc\test.txt':
svn: warning: W200035: sqlite[S19]: NOT NULL constraint failed: EXTERNALS.def_repos_relpath

.

.

.
Checked out revision N.
svn: E205011: Failure occurred processing one or more externals definitions

References:

1. Mail by Pál Kovács (with reproduction steps) to users@s.a.o with title "redirection error with file externals - possible bug" dated Saturday, March 11, 2023, archived:
https://lists.apache.org/thread/go4r3lflzy7yvq7bt4rnofyc46n59whh

2. Mail by Baldauf Christoph to users@s.a.o with title "Checkout problem via http with file external pointing at redirected URL" dated Tuesday, February 7, 2023, archived: https://lists.apache.org/thread/x0v1tj68d2mz4vdoxj0bts8h5x892q9n