500 Oops errors after upgrading

Support
1

After upgrading earlier this evening, I was getting 500 “Oops” error pages and in /logs I was seeing errors like this:

PG::InvalidTextRepresentation (ERROR:  invalid input syntax for type inet: "unix:"
LINE 7:     client_ip = 'unix:',
                        ^
)

I have Discourse reverse proxied behind Caddy, and it turns out that the solution was to add

header_up X-Real-IP {remote_host}

to the reverse_proxy section in my Caddyfile, which I hadn’t needed before.

I figured out that X-Real-IP was needed due to the similar error message in this post.

I hope this helps someone having a similar problem.