Daphne breaks the database connection when I use WebSocketConsumer

[LeandreLapidus]

Hello to you. I hope you are well. I would like to thank you for the work you are doing on this project.

If I come to you, it is to report a small problem.
Indeed, I try to set up a custom chat application. I am currently developing on a Windows 10 machine and for the chat I am using:
- channels==3.0.3
- channels_redis==3.2
- daphne~=3.0
- psycopg2~=2.8

The problem is that when I try to save information in my database, the connection is interrupted beyond my control.

1. Channel Layer

ASGI_APPLICATION = 'nrk.asgi.application'


CHANNEL_LAYERS = {
    'default': {
        'BACKEND': 'channels_redis.core.RedisChannelLayer',
        'CONFIG': {
            "hosts": [('localhost', 6379)],
        },
    },
}

2. Routing

#project/routing.py
from channels.auth import AuthMiddlewareStack
from channels.routing import ProtocolTypeRouter, URLRouter
import home.routing
from channels.http import AsgiHandler
import django
import os
os.environ.setdefault('DJANGO_SETTINGS_MODULE', '*****settings')
django.setup()

application = ProtocolTypeRouter({
    # (http->django views is added by default)
    "http": AsgiHandler(),
    'websocket': AuthMiddlewareStack(
        URLRouter(
            home.routing.websocket_urlpatterns
        )
    ),
})

3. Consumer

import json

from channels.generic.websocket import WebsocketConsumer, AsyncWebsocketConsumer # The class we're using
from asgiref.sync import async_to_sync
from django.shortcuts import get_object_or_404
from .models import DialogMessage
from users.models import User, Friendship
from channels.db import database_sync_to_async


class DialogConsumer(WebsocketConsumer):

        
    def save_message(self, fid, username, content):
        fs = get_object_or_404(Friendship, pk=friendship_id)
        sender = get_object_or_404(User, username=username)
        msg = DialogMessage(friendship = fs, content=content, sender=sender)
        msg.save()
        return msg
    
    
    def message_to_json(self, message):
        
        return {
            'username': message.sender.username,
            'name': message.sender.name,
            'content': message.content,
            'sent_on': message.sent_on.strftime('%d %b %Y %H:%M:%S')
        }
    
    def connect(self):
        print("Connecting to websocket...")
        self.friendship_id = self.scope['url_route']['kwargs']['friendship_id']
        self.user = self.scope["user"]
        self.room_group_name = 'chat_%s' % self.friendship_id

        # Join room group
        async_to_sync(self.channel_layer.group_add)(
            self.room_group_name,
            self.channel_name
        )

        self.accept()
        if self.user:
            # login(self.scope, self.user)
            print(self.user.name ," is connected.")
            

    def disconnect(self, close_code):
        # Leave room group
        async_to_sync(self.channel_layer.group_discard)(
            self.room_group_name,
            self.channel_name
        )
    # Receive message from room group
    def chat_message(self, data):
        content = data['content']
        sender = data['sender']
        fid = self.friendship_id
        print("message", self.friendship_id)
        
        fs = get_object_or_404(Friendship, pk=friendship_id)
        sender = get_object_or_404(User, username=sender)
        
        print(sender, fs)
        
        message = DialogMessage.objects.create(friendship = fs, content=content, sender=sender)
        result = {
            'command': data["command"],
            'username': message.sender.username,
            'name': message.sender.name,
            'content': message.content,
            'sent_on': message.sent_on.strftime('%d %b %Y %H:%M:%S')
        }
        
        async_to_sync(self.channel_layer.group_send)(
            self.room_group_name,
            {
                'type': 'dialog_message',
                'result': result,
            }
        )
        
    commands = {
        'chat_message': chat_message
    }

    # Receive message from WebSocket
    def receive(self, text_data):
        data = json.loads(text_data)
        content = data['content']
        sender = data['sender']

        # Send message to room group
        self.commands[data["command"]](self, data),
        
    
    # Receive message from room group
    def dialog_message(self, event):
        result = event["result"]
        self.send(text_data=json.dumps(result))

Edit: I tried to follow this tutorial : https://www.youtube.com/watch?v=9jqHWwubnoY&list=PLLRM7ROnmA9EnQmnfTgUzCfzbbnc-oEbZ&index=6

4. Browser

var cs = new WebSocket(
    "ws://" + window.location.host + "/ws" + window.location.pathname,
)

cs.onclose = function(){
    console.log('connection lost')
}

cs.onmessage = function(e){
    var data = JSON.parse(e.data);
    console.log("Message sent", data)
    if(data){
        $("#chat-log").append("<span><b>"+ data['name'] +"</b>@"+ data['username'] +"</span> : " + data['content'] + " (" + data['sent_on'] + ") <br>")
    }
} 

$("#send-to-other").click(function(e){
    const input = $("#id_content")
    const content = input.val()
    cs.send(JSON.stringify({
        'content': content,
        'sender': '{{request.user.username}}',
        'command': 'chat_message',
    }))

    input.val("")
})

I'm expecting this to save the message in the database before displaying it on the browser. But this is what is sent :

HTTP GET /medias/default/profile.png 200 [0.01, 127.0.0.1:6954]
HTTP GET /static/css/fonts/MaterialIcons-Regular.woff2 200 [0.01, 127.0.0.1:6954]
HTTP GET /static/css/styles.css.map 200 [0.01, 127.0.0.1:6954]
HTTP GET /static/css/materialize.css.map 200 [0.02, 127.0.0.1:4434]
HTTP GET /static/js/swiper.min.js.map 404 [0.01, 127.0.0.1:4434]
WebSocket HANDSHAKING /ws/dialog/1/ [127.0.0.1:4495]
Connecting to websocket...
WebSocket CONNECT /ws/dialog/1/ [127.0.0.1:4495]
Kingue Joel  is connected.
WebSocket DISCONNECT /ws/dialog/1/ [127.0.0.1:4495]

And when i retry the click event on the submit button, it sends back the daphne 500 internal error page. I hope i'm addressing to the good one. I search on the net to find a solution but didn't fix it.