ActiveRecord PostgreSQL adapter extension to deal with the Aurora Serverless hanging issue.

README.md

There's an issue reported in ruby-pg (ged/ruby-pg#325) where a query hangs and never return results to the application.

This adapter extension controls it with a ruby timeout set to 5 seconds. If the query doesn't return results in 5 seconds it aborts the async_exec method and tries the exec one.

We're not proud of this vut it saved a lot of erratic errors.

postgresql_adapter_extension.rb

ActiveRecord::ConnectionAdapters::PostgreSQLAdapter.class_eval do
    def exec_no_cache(sql, name, binds)
        begin
            Timeout::timeout(5) {
                log(sql, name, binds) { @connection.async_exec(sql, []) }
            }
        rescue
            Rails.logger.error("[SLOW QUERY] #{sql}")
            log(sql, name, binds) { @connection.exec(sql, []) }
        end
    end
end