Hello all,

We are trialling running motor-admin for out RoR application and right off the bat it was amazing. We followed the installation guide exactly and it worked very well. We were getting full functionality, but found that once there was anything populated in my motor.yml file I received the following error:

ActiveRecord::StatementInvalid (PG::ReadOnlySqlTransaction: ERROR:  cannot execute setval() in a read-only transaction

We determined this was caused by Rails' auto-switching to read-only dbs on GET requests (we have a reader and a read-writer). And on GET /motor_admin it was trying to sync the motor.yml file with our local db. For anyone else who stumbles upon this, our solution was to create a custom database resolver which would point all motor-admin commands to the writer instance given we could specify which db to hit from the MotorUI afterwards. It could probably be a bit more restrictive, but overall it did successfully sync our YML outline with the db.

class MotorAdminDatabaseResolver < ActiveRecord::Middleware::DatabaseSelector::Resolver
  def reading_request?(request)
    return false if request.path.start_with?("/motor")

    super
  end
end

Rails.application.configure do
  config.active_record.database_selector = {delay: 2.seconds}
  config.active_record.database_resolver = MotorAdminDatabaseResolver
  config.active_record.database_resolver_context = ActiveRecord::Middleware::DatabaseSelector::Resolver::Session
end

Enter The Error In This Issue

While that fixed the read-only issue, we are now hitting the same issue here. We are also on Rails 8.1.

TypeError (no _dump_data is defined for class PG::Result):
  
config/initializers/selective_logger.rb:23:in 'SelectiveLogger#call'

Any direction would be very helpful here as we would love to work with motor admin in our application. Also, I've given the solution proposed in #203 a shot to no avail unfortunately.

TypeError (no _dump_data is defined for class PG::Result) #200

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions