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

Kotlin
IOS
VB.Net
SQL
Node.js
Swift
Ruby
Go
Oracle
Git
Laravel
Mongodb
Asp.Net
More...

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

False
Django, Why does the system automatically generate an empty session? every time the request is made?
Use python to convert dict1 to dict2, in the example. I tried for a long time but couldn't find a solution.
How to self-start the php-fpm service when building a LNMP environment with docker?
Can an array in react state be bound to a dom state using an element in the array?
Wechat browser version 6.6.5 cannot prevent the springback of pull-up and drop-down to the top under ios system.
In express+hbs, how do you define the routed data as a variable on the page?
How to use symbol reference of Iconfont in dva
How to elegantly add data to JSON objects?
Using node to build video streaming server
The proportional width of the echarts graph is inconsistent.
React uses axios to call the background data. After success, how to jump to the page based on the returned value?
I don't understand what a linux command means. Please explain it.
Vue introduces multiple components in vue-router by nesting named views, and does not refresh the same reference in other pages.
Running nodejs reports fewer errors ")"

React uses children to nest components, how to get the parent component props
Why php socket programming should be divided into server-side php socket and client-side php socket?
Problems with thinkphp5.17 federated query
There is a problem with the value of hashset set method. In the running result, there is only one element in the result set, and the value obtained by, size () is > 1.
About node generating Taobao password (that is, the thing that can open the baby in Taobao)