How should celery handle database links (psycopg2) in prefork mode?

problem description

celery uses prefork mode (4 processes) and is used in conjunction with psycopg2. Each startup can successfully complete a celery task. InterfaceError: cursor already closed appears when the second task is carried out. What should be done?

what methods have you tried

as you can see in the psycopg2 document , this library should not be used in forked process. So I"m a little confused, is it because of celery"s prefork mode that caused the problem? So how should I handle it? Do you need to create a new database link in each celery task and turn it off after you finish it?

Postgresql celery
Mar.28,2021

Previous: Mobile Wechat browser ios cannot get focus by using the div contenteditable attribute input box and using the focus () method.

Next: Angular client interacts with web server Websocket, error converting data using JSON

css mysql arrays josn react html typescript webpack npm sass R objective-c .net sql-server jquery python-3.x angularjs django angular excel regex iphone ajax linux xml pandas vba spring database wordpress string wpf xcode windows bash postgresql oracle multithreading eclipse list firebase algorithm macos forms image scala visual-studio azure bootstrap spring-boot react-native python-2.7 docker performance function winforms matlab powershell apache dataframe api sqlite numpy rest shell selenium flutter dart maven loops qt swing android-studio csv express file class tensorflow sorting codeigniter perl
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e48903-66664.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e48903-66664.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?