Jira import error with no connection available

hello,

Today, we had an error during the import, here is the log, could you please help? Thanks.

2020-03-24 10:00:01 +0800 ERROR: [application_import 3] [Dwh.use_database] ActiveRecord::ConnectionNotEstablished: no connection available
2020-03-24 10:00:01 +0800 ERROR: [application_import 3] [Dwh.use_database] trying to re-create database eazybi_jira_dwh_3
2020-03-24 10:00:01 +0800 ERROR: [application_import 3] Dwh.execute failed: CREATE DATABASE IF NOT EXISTS eazybi_jira_dwh_3 DEFAULT CHARACTER SET utf8
2020-03-24 10:00:01 +0800 ERROR: [application_import 3] ActiveRecord::ConnectionNotEstablished: no connection available
2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from arjdbc/jdbc/RubyJdbcConnection.java:587:in execute' 2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/gem.home/gems/activerecord-jdbc-adapter-1.3.25/lib/arjdbc/jdbc/adapter.rb:598:in _execute’
2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/gem.home/gems/activerecord-jdbc-adapter-1.3.25/lib/arjdbc/jdbc/adapter.rb:572:in execute' 2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/rails.root/vendor/gems/eazybi/app/models/dwh.class:1150:in execute’
2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/rails.root/vendor/gems/eazybi/app/models/dwh.class:188:in create_database' 2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/rails.root/vendor/gems/eazybi/app/models/dwh.class:155:in use_database’
2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/rails.root/vendor/gems/eazybi/app/models/account.class:107:in block in use_dwh' 2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/rails.root/vendor/gems/eazybi/app/models/dwh.class:113:in with_connection’
2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/rails.root/vendor/gems/eazybi/app/models/account.class:106:in use_dwh' 2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/rails.root/vendor/gems/eazybi/app/models/source_application.class:976:in perform_import’
2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/rails.root/vendor/gems/eazybi/lib/private_async_queue_processor.class:34:in block in on_message' 2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/rails.root/vendor/gems/eazybi/lib/account_lock.class:5:in block in async_around_filter’
2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/rails.root/vendor/gems/eazybi/lib/private_async_queue_helpers.class:59:in async_around_filter' 2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/rails.root/vendor/gems/eazybi/lib/account_lock.class:5:in async_around_filter’
2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/rails.root/vendor/gems/eazybi/lib/private_async_queue_processor.class:33:in block in on_message' 2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/gem.home/gems/activerecord-4.2.10/lib/active_record/connection_adapters/abstract/connection_pool.rb:292:in with_connection’
2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/rails.root/vendor/gems/eazybi/lib/private_async_queue_processor.class:26:in block in on_message' 2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/gem.home/gems/activesupport-4.2.10/lib/active_support/tagged_logging.rb:68:in block in tagged’
2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/gem.home/gems/activesupport-4.2.10/lib/active_support/tagged_logging.rb:26:in tagged' 2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/gem.home/gems/activesupport-4.2.10/lib/active_support/tagged_logging.rb:68:in tagged’
2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/rails.root/vendor/gems/eazybi/lib/private_async_queue_processor.class:22:in on_message' 2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/rails.root/vendor/gems/eazybi_p2/config/initializers/work_queues.class:10:in block in ’
2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/gem.home/gems/girl_friday-0.11.2/lib/girl_friday/work_queue.rb:147:in block in start' 2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/gem.home/gems/rubinius-actor-0.0.2/lib/rubinius/actor.rb:88:in block in spawn_link’
2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/gem.home/gems/rubinius-actor-0.0.2/lib/rubinius/actor.rb:71:in block in spawn' 2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/gem.home/gems/rubinius-actor-0.0.2/lib/rubinius/actor.rb:214:in block in initialize’
2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/gem.home/gems/rubinius-actor-0.0.2/lib/rubinius/actor.rb:373:in watchdog' 2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/gem.home/gems/rubinius-actor-0.0.2/lib/rubinius/actor.rb:214:in initialize’
2020-03-24 10:00:01 +0800 ERROR: [application_import 3] from /var/atlassian/application-data/jira/plugins/.osgi-plugins/felix/felix-cache/bundle178/version0.0/plugin.9042082128878936394.eazybi-jira-5.0.3_1563347979000.jar-lib/0/META-INF/gem.home/gems/rubinius-actor-0.0.2/lib/rubinius/actor.rb:68:in `block in spawn’

BR
Xavi

There is some connection pool problem. First thing to try would be to upgrade to newest version, there were improvements to DB connection handling after 5.0.3 that you are using. If the problem persists, check database to see if there actually are available connections, perhaps the database connection pool is maxed out. If that still does not help, please send full log files (https://docs.eazybi.com/eazybijira/set-up-and-administer/set-up-and-administer-for-jira-server/troubleshooting#Troubleshooting-eazyBIlogfiles) to support@eazybi.com