Rescuing ActiveRecord errors without logging

Hi,

I have the following piece of code:

begin

DummyModel.create(record)

rescue

if $!.class == ActiveRecord::StatementInvalid and $!.to_s[‘PG::CharacterNotInRepertoire’]

Logger.info(“Issues with encoding for #{record[:email_domain]}. Attempting encoding”)

DummyModel.create(Utils.encode_record_as_utf8(record))

end



Since ActiveRecord always sends errors to logger I always see the error in my log files, even tough I rescue it and handle it.

I see this error in the log files:

Apr 19 10:43:16 E, [2015-04-19T07:43:16.217488 #1] ERROR – : PG::CharacterNotInRepertoire: ERROR: invalid byte sequence for encoding “UTF8”: 0xf1 0x6f 0x0a 0x52

I’m running rails 4.0.1, but upgrade to rails 4.2 didn’t help.

This is very problematic, as I cannot monitor my log for errors - the monitor always sends me this error, even though it is already taken care of.

I found out the piece of rails code responsible for this behavior inside AbstractAdapter.log method

def log(sql, name = “SQL”, binds = [])

@instrumenter.instrument(

“sql.active_record”,
:sql => sql,
:name => name,
:connection_id => object_id,
:binds => binds) { yield }
rescue => e
message = “#{e.class.name}: #{e.message}: #{sql}”
@logger.error message if @logger
exception = translate_exception(e, message)
exception.set_backtrace e.backtrace
raise exception
end

As you can see, error logging cannot be avoided (unless logger is disabled)

Can anyone think of a way around this?

Any advice would be highly appreciated.

Hi there , i don't know if that will help you , but i did have this kind
of encoding problem with my database few weeks ago.

I solved it by running this query on my DB:

update database set encoding = char_to_encoding('UTF8') where datname =
'thedb'

Any advice would be highly appreciated.

This is one , maybe not your problem's solution :confused:

see you

Tanguy
ps:English is not my mother tongue

I’m not speaking about the encoding issue but about the exception rescue issue.
Imagine I would like to handle unique key exceptions for instance.