# 'rake db:structure:load' is succeeding then timing out

**URL:** <https://discuss.circleci.com/t/rake-dbload-is-succeeding-then-timing-out/25944>\
**Category:** Build Environment\
**Created:** [October 23, 2018, 3:41am UTC](https://discuss.circleci.com/t/rake-dbload-is-succeeding-then-timing-out/25944 "2018-10-23T03:41:01Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![caseyli](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/caseyli/32/19511_2.png) [@caseyli](https://discuss.circleci.com/u/caseyli)\
**Post date:** [October 23, 2018, 3:41am UTC](https://discuss.circleci.com/t/rake-dbload-is-succeeding-then-timing-out/25944/1 "2018-10-23T03:41:01Z")

</div>

I’m relatively new to CircleCI. Just setup my Docker Hub image which includes PG client. I’m trying to do some testing on a Rails App, and it’s getting stuck at

`rake db:structure:load`

What’s interesting, is that it does seem to succeed, but then times out. I get the output

```auto
set_config 
------------
 
(1 row)

(END)

```

which usually indicates that the structure load succeeds. But then it just hangs, and eventually times out with:

```auto
(END)rails aborted! Interrupt: /root/repo/vendor/bundle/ruby/2.2.0/gems/activerecord-5.1.2/lib/active_record/tasks/postgresql_database_tasks.rb:108:in `system' 
/root/repo/vendor/bundle/ruby/2.2.0/gems/activerecord-5.1.2/lib/active_record/tasks/postgresql_database_tasks.rb:108:in `run_cmd' 
/root/repo/vendor/bundle/ruby/2.2.0/gems/activerecord-5.1.2/lib/active_record/tasks/postgresql_database_tasks.rb:80:in `structure_load' 
/root/repo/vendor/bundle/ruby/2.2.0/gems/activerecord-5.1.2/lib/active_record/tasks/database_tasks.rb:223:in `structure_load' /root/repo/vendor/bundle/ruby/2.2.0/gems/activerecord-5.1.2/lib/active_record/tasks/database_tasks.rb:236:in `load_schema' 
/root/repo/vendor/bundle/ruby/2.2.0/gems/activerecord-5.1.2/lib/active_record/tasks/database_tasks.rb:255:in `block in load_schema_current' 
/root/repo/vendor/bundle/ruby/2.2.0/gems/activerecord-5.1.2/lib/active_record/tasks/database_tasks.rb:304:in `block in each_current_configuration' /root/repo/vendor/bundle/ruby/2.2.0/gems/activerecord-5.1.2/lib/active_record/tasks/database_tasks.rb:303:in `each' 
/root/repo/vendor/bundle/ruby/2.2.0/gems/activerecord-5.1.2/lib/active_record/tasks/database_tasks.rb:303:in `each_current_configuration' 
/root/repo/vendor/bundle/ruby/2.2.0/gems/activerecord-5.1.2/lib/active_record/tasks/database_tasks.rb:254:in `load_schema_current' 
/root/repo/vendor/bundle/ruby/2.2.0/gems/activerecord-5.1.2/lib/active_record/railties/databases.rake:290:in `block (3 levels) in &lt;top (required)&gt;' /root/repo/vendor/bundle/ruby/2.2.0/gems/railties-5.1.2/lib/rails/commands/rake/rake_command.rb:21:in `block in perform' 
/root/repo/vendor/bundle/ruby/2.2.0/gems/railties-5.1.2/lib/rails/commands/rake/rake_command.rb:18:in `perform' 
/root/repo/vendor/bundle/ruby/2.2.0/gems/railties-5.1.2/lib/rails/command.rb:46:in `invoke' /root/repo/vendor/bundle/ruby/2.2.0/gems/railties-5.1.2/lib/rails/commands.rb:16:in `&lt;top (required)&gt;' bin/rails:4:in `require' bin/rails:4:in `&lt;main&gt;' Tasks: TOP =&gt; db:structure:load (See full trace by running task with --trace) Too long with no output (exceeded 10m0s)

```

So it seems like it’s succeeding, then just hanging.

The previous `rake db:create` succeeds without problem.

Any ideas?

---

<div class="post-metadata">

**Author:** ![Kache](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/kache/32/19572_2.png) [@Kache](https://discuss.circleci.com/u/Kache)\
**Post date:** [October 29, 2018, 11:02pm UTC](https://discuss.circleci.com/t/rake-dbload-is-succeeding-then-timing-out/25944/2 "2018-10-29T23:02:58Z")

</div>

I also ran into this issue, I made a [Stackoverflow post](https://stackoverflow.com/questions/53055044) about it.

In short: seems to involve `psql` using a terminal pager for output and waiting for user input, and my current improper workaround in `.circleci/config.yml` is:

```
environment:
  PAGER: cat # prevent psql commands triggering pager
```

---

<div class="post-metadata">

**Author:** ![caseyli](https://sea2.discourse-cdn.com/circleci/user_avatar/discuss.circleci.com/caseyli/32/19511_2.png) [@caseyli](https://discuss.circleci.com/u/caseyli)\
**Post date:** [October 29, 2018, 11:37pm UTC](https://discuss.circleci.com/t/rake-dbload-is-succeeding-then-timing-out/25944/3 "2018-10-29T23:37:56Z")

</div>

Awesome! Thanks for the workaround! Seems to be working now!

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/circleci/original/3X/5/1/511608acda8e85906e15909b57bd0a46c1dbe291.png) [@system](https://discuss.circleci.com/u/system)\
**Post date:** [January 27, 2019, 11:37pm UTC](https://discuss.circleci.com/t/rake-dbload-is-succeeding-then-timing-out/25944/4 "2019-01-27T23:37:56Z")

</div>

Closed on January 27, 2019, 11:37pm UTC

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.