How to Solve the Problem of Github Actions Django Test Failing to Destroy PostgreSQL Database?

-


TL;DR

Description

I had a Github action that runs my Django test without problem for ages and suddenly I have the problem of it not being able to destroy the test database because there are "There are 6 other sessions using the database."

My Solution

1. I removed the conn_max_age=600 from my dj_database_url.config. 

Possible Variations

1. Find your PostgreSQL connection configuration. If there is a configuration similar to the maximum time the system will keep the connection alive, set it to 0 or remove it so that the default 0 will be used. This essentially means it will close the connection once it is done. 

The Full Story

Introduction

I have one repository where I am doing my final project for CS50 Web. I changed my project from a task manager to a 90-day notification tracker because it is something that I see myself using. After I've changed the model and committed my code, I started to see the following error in my Github Actions test. 

Thinking Process

First thought

My first suspicion is the version of the program so I tried to specify the version of Django and psycopg2. I changed it to an older version to no avail. 

Stackoverflow

Most of the posts suggested either we restart the database or revoke some connection rights which doesn't help in this case. 

Django Test -- Unable to drop and recreate test database

Postgresql - unable to drop database because of some auto connections to DB

The Breakthrough

The breakthrough came when I read that Django's CONN_MAX_AGE's default value is 0 and it means that the database connection is closed at the end of the request. Upon closer inspection, I found that my dj_database_url's configuration is the same as the sample in its PyPI listing which is dj_database_url.config(conn_max_age=600, ssl_require=True)

The Solution

Removing the conn_max_age=600 from dj_database_url solves the problem because the default value of this is 0 which also means that the database connection is closed at the end of the request. 

Comments

Post a Comment

Popular posts from this blog

How to Auto Convert Malaysian IC Number to Birthdays Using Excel (Updated to Support Millennials)

-
Image
Photo by Annie Spratt on Unsplash I wrote this an article about how to automatically convert Malaysian IC Number to Birthdays five years ago. I was surprised that people recently commented that it didn't support those born after the year 2000. I'm responsible of putting the original information online so I'm obliged to update it if it didn't work. So here I am giving you the updated version. You can play with the excel sheet here to see how it works. The excel formulas that I used above are as below. YYYY-MM-DD Format =CONCATENATE(IF(LEFT(A1,2)<RIGHT(YEAR(TODAY()),2),"20","19"),LEFT(A1,2),"-",MID(A1,3,2),"-",MID(A1,5,2)) DD-MM-YYYY Format =CONCATENATE(MID(A1,5,2),"-",MID(A1,3,2),"-",IF(LEFT(A1,2)<RIGHT(YEAR(TODAY()),2),"20","19"),LEFT(A1,2)) There are two parts to the formula. Depending on the format, the sequence will be different. Generally, I extract the month,
Read more

How to Prepare for a Table Topics Compeition?

-
Image
Original photo by  Kane Reinholdtsen  on  Unsplash "How do I prepare for the upcoming Table Topics competition?" was the question that popped up in my head before my first competition. After winning my second consecutive district level table topic contest , I believe I have something to share. We are going to cover the possible topics in the competition, how to practice and what to read. If you have one or two weeks before your competition, I recommend you to read  5 Tips For Your Next Table Topic Contest . If you have more time than that, please read on! If you prefer videos, please follow this link to the video version of this article.  Table of Contents Possible Topics in The Competition How to Practice Practice Understanding the Topic Practice Sharpening Your Points Practice Breaking Your Usual Patterns Practice Handling Hard Topics What to Read Possible Topics in The Competition You might ask, "How do you prepare for something unknown?". Well, a Table Topics c
Read more

How to Solve ModuleNotFoundError: No module named 'tencentcloud' on Tencent Serverless Cloud Function?

-
Image
Introduction You are excited to use Tencent Serverless Cloud Function to do your automation. You are following the Tencent API Explorer  and you are ready to rock yet when you test your Python code; you encountered  ModuleNotFoundError: No module named 'tencentcloud' . This is a guide on how to solve this error and explanations of why you need to do those steps.  How to solve this error According to Tencent Cloud's Serverless Cloud Function's  Dependency Installation guide , there are two ways to solve this problem.  Package the dependency libraries and code together for upload - I haven't tried this so if you did and it works, please feel free to write a post and comment here. Use dependency management tools. Use dependency management tools to solve this error I'm going to use the same steps as shown in the guide. I will add pictures and edit the steps so that it will be easier for you.  Log in to the SCF console and select Function Service on the left sideba
Read more