Rescuing ActiveRecord errors without logging

rubyonrails-talk
1

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.

2

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

3

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.