rubyrep is syncing fine, but replication is failing with below errors.

27 views
Skip to first unread message

sko...@etouch.net

unread,
Dec 5, 2018, 3:45:21 PM12/5/18
to rubyrep
Starting replication
2018-12-05T19:24:35Z Exception caught: replication run timed out
                     /home/skotla/rubyrep-2.0.1/lib/rubyrep/replication_runner.rb:125:in `execute_once'
                     /home/skotla/rubyrep-2.0.1/lib/rubyrep/replication_runner.rb:147:in `execute'
                     /home/skotla/rubyrep-2.0.1/lib/rubyrep/replication_runner.rb:168:in `run'
                     /home/skotla/rubyrep-2.0.1/lib/rubyrep/command_runner.rb:102:in `run'
                     /home/skotla/rubyrep-2.0.1/bin/rubyrep:7:in `<main>'
Exception caught: ActiveRecord::ConnectionNotEstablished: no connection available:           SELECT tablename
            FROM pg_tables
           WHERE schemaname IN ('zorro_runner')
arjdbc/jdbc/RubyJdbcConnection.java:888:in `execute_query'
/home/skotla/rubyrep-2.0.1/jruby/lib/ruby/gems/shared/gems/activerecord-jdbc-adapter-1.3.23/lib/arjdbc/jdbc/adapter.rb:455:in `block in exec_query'
/home/skotla/rubyrep-2.0.1/jruby/lib/ruby/gems/shared/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:484:in `block in log'
/home/skotla/rubyrep-2.0.1/jruby/lib/ruby/gems/shared/gems/activesupport-4.2.8/lib/active_support/notifications/instrumenter.rb:20:in `instrument'
/home/skotla/rubyrep-2.0.1/jruby/lib/ruby/gems/shared/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract_adapter.rb:482:in `log'
/home/skotla/rubyrep-2.0.1/jruby/lib/ruby/gems/shared/gems/activerecord-jdbc-adapter-1.3.23/lib/arjdbc/jdbc/adapter.rb:455:in `exec_query'
/home/skotla/rubyrep-2.0.1/jruby/lib/ruby/gems/shared/gems/activerecord-jdbc-adapter-1.3.23/lib/arjdbc/jdbc/adapter.rb:542:in `select'
/home/skotla/rubyrep-2.0.1/jruby/lib/ruby/gems/shared/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/database_statements.rb:32:in `select_all'
/home/skotla/rubyrep-2.0.1/jruby/lib/ruby/gems/shared/gems/activerecord-4.2.8/lib/active_record/connection_adapters/abstract/query_cache.rb:70:in `select_all'
/home/skotla/rubyrep-2.0.1/lib/rubyrep/connection_extenders/postgresql_extender.rb:28:in `tables'
/home/skotla/rubyrep-2.0.1/lib/rubyrep/table_spec_resolver.rb:14:in `tables'
/home/skotla/rubyrep-2.0.1/lib/rubyrep/table_spec_resolver.rb:91:in `block in expand_table_specs'
org/jruby/RubyArray.java:1734:in `each'
/home/skotla/rubyrep-2.0.1/lib/rubyrep/table_spec_resolver.rb:83:in `expand_table_specs'
/home/skotla/rubyrep-2.0.1/lib/rubyrep/table_spec_resolver.rb:58:in `resolve'
/home/skotla/rubyrep-2.0.1/lib/rubyrep/session.rb:45:in `manual_primary_keys'
/home/skotla/rubyrep-2.0.1/lib/rubyrep/session.rb:215:in `connect_database'
/home/skotla/rubyrep-2.0.1/lib/rubyrep/session.rb:179:in `block in refresh_database_connection'

Shajimon Abraham

unread,
Dec 6, 2018, 11:34:33 PM12/6/18
to rub...@googlegroups.com
I do not know the exact cause of this error. If you have not found the reason so far kindly see if the name,structure etc in both left and right are same. One or more table missing in one of the replica may create problem while replicating

--
You received this message because you are subscribed to the Google Groups "rubyrep" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyrep+u...@googlegroups.com.
To post to this group, send email to rub...@googlegroups.com.
Visit this group at https://groups.google.com/group/rubyrep.
For more options, visit https://groups.google.com/d/optout.


--
Shajimon

Reply all
Reply to author
Forward
0 new messages