Heroku DB:push is not working

Question

I'm fairly new to Heroku and deploying Rails app. I have an app hosted in Heroku with a MySQL database, been working flawlessly for a month or so. Today, I did a db:pull and took longer than expected. When I did db:push, I'm getting an error:

Sending schema>
Schema:         17% |=======                                   | ETA:  00:00:22
Saving session to push_201107211055.dat..
!!! Caught Server Exception
HTTP CODE: 503
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org /TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
  <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
  <style type="text/css">
    html, body, iframe { margin: 0; padding: 0; height: 100%; }
    iframe { display: block; width: 100%; border: none; }
  </style>
<title>Application Error</title></head>
</head>
<body>
  <iframe src="https://s3.amazonaws.com/heroku_pages/error.html">
    <p>Application Error</p>
  </iframe>
</body>
</html>

What might be the issue?

Possibly related/duplicate: http://stackoverflow.com/questions/5357486/heroku-help-amazon-rds-rails-push-database-error — coreyward, Jul 21 '11 at 18:13
I went into that question, but the answer seems not to apply to my case. I don't have an Amazon AWS > Amazon RDS log in or account. — Luis D Urraca, Jul 21 '11 at 18:23
can you explicitly show which gems you are using to map databases on local and production environments. — thenengah, Jul 21 '11 at 19:10
Now it went back to working as expected. Thanks everyone for the support. — Luis D Urraca, Jul 21 '11 at 19:30
Can you please let us know the solution? I have a similar problem but with error code 503. — WowBow, May 06 '12 at 17:19

Brett C · Answer 1 · 2013-01-17T14:40:57.823

2

(while this may not "fix" anything, it did work for me twice, definitely worth a shot) try:

heroku restart
heroku db:push --confirm app-name-1234

edited Jan 17 '13 at 14:40

answered Jan 15 '13 at 17:13

Brett C

291
2
13

'heroku restart' fixed a problem I've been having with db:pull – KurtPreston Feb 01 '13 at 07:27

score 0 · Answer 2 · answered Jul 21 '11 at 18:14

0

do you have the taps gem?

gem install taps

Source

answered Jul 21 '11 at 18:14

Nicos Karalis

3,724
4
33
62

Yes, I do have the taps gem installed, this been working for the past month. – Luis D Urraca Jul 21 '11 at 18:19

Heroku DB:push is not working

2 Answers2