ActiveRecord::StatementInvalid: PG::UntranslatableCharacter: ERROR: unsupported Unicode escape sequence
https://sentry.gitlab.net/gitlab/gitlabcom/issues/2949775/?referrer=gitlab_plugin
PG::UntranslatableCharacter: ERROR: unsupported Unicode escape sequence
LINE 1: ...in.', 'production', '2021-11-08 17:30:48.489413', '{"event_i...
^
DETAIL: \u0000 cannot be converted to text.
CONTEXT: JSON data, line 1: ...commandName":"App\\Jobs\\GoGetSslSync","command":...
lib/gitlab/database/load_balancing/connection_proxy.rb:119:in `block in write_using_load_balancer'
connection.send(...)
lib/gitlab/database/load_balancing/load_balancer.rb:112:in `block in read_write'
yield connection
lib/gitlab/database/load_balancing/load_balancer.rb:179:in `retry_with_backoff'
return yield
lib/gitlab/database/load_balancing/load_balancer.rb:110:in `read_write'
retry_with_backoff do
lib/gitlab/database/load_balancing/connection_proxy.rb:118:in `write_using_load_balancer'
@load_balancer.read_write do |connection|
...
(239 additional frame(s) were not displayed)
ActiveRecord::StatementInvalid: PG::UntranslatableCharacter: ERROR: unsupported Unicode escape sequence
LINE 1: ...in.', 'production', '2021-11-08 17:30:48.489413', '{"event_i...
^
DETAIL: \u0000 cannot be converted to text.
CONTEXT: JSON data, line 1: ...commandName":"App\\Jobs\\GoGetSslSync","command":...
Proposed solution
Scrub nulbytes from JSON payload before saving.
API exception details
Edited by Peter Leitzen