retug December 23, 2022

Website Database Scare

On Decemeber 10th, I logged into my website to be greeted by a scary error message

I had not done anything to the site, so I figured something bad more than likely happened.

The work week was busy, so I was not able to start troubleshooting until December 17th. Running the command heroku logs --tail  led to message that stated:

File "/app/my_website/settings.py", line 108, in <module> raise Exception("DATABASE_URL environment variable not defined") Exception: DATABASE_URL environment variable not defined

Reading this, I knew the database had somehow gotten disconnected. Logging into heroku where I host the website and database, I was greeted with a scary red warning label:

At this point, real panic sets in, what happened to my database? I knew that I was paying heroku to host my website, so I thought was just a warning they were putting on all dashboards. At this point, I open up the 10 emails I received from heroku stating that they are removing free hosting and database services. After some research, I realized that I was paying for the server, but not for the database; I was still using the free tier postgres database. 

Tail tucked between my legs, I follow heroku's "hey you dummy, you ignored all of our emails and you want to get your website back" tutorial and within 4 hours of opening a ticket and 9 bucks later, my database was restored.

The take away

DONT IGNORE IMPORTANT EMAILS!

Web Dev

Our Sidebar

You can put any information here you'd like.

  • Latest Comments
  • retug on ETABs Parametric Building -

    Toni,

    Please take the new concrete design tool for a spin.

    There is a nice new export to excel button for your use, MM diagrams, and additional parameters for the concrete section in question.

    Thanks,

    Retug

  • Toni on ETABs Parametric Building -

    Retug,

    I have a request for the site. For the P&M output into excel, could you add a header with the basic parameters? Width, height, reinforcement provided so the pasting has context as to which output it is for? 

     

    Thanks,

    Toni

  • retug on ETABs Parametric Building -

    @Toni, this post does not discuss the level of mesh refinement required. The focus is on building an ETABS model efficiently. Mesh refinement is typically evaluated within ETABS by studying the parameter of interest and refining the mesh until the results converge to an acceptable tolerance.

    @fpsstructures, I edited your …