Why is telegram sqlite3 database locked?

Question

SQLite

After processing incoming messages, other people's comments appeared. in the telegram channel and immediately the database is locked

main.py

from pyrogram import Client

api_id =
api_hash = ""

@app.on_message()
async def my_handler(client, message):
await message.forward("me")

app.run()

Answer 1

because the database is open in another file or something like that. sqlite3 works on the principle that when someone reads, other files cannot. Simply put, try to open sqlite3 only at the right moments. That is, do not write

conn = sqlite.connect(*arg)
#some code here
conn.close()

a

with sqlite.connect(*arg) as conn: 
 #some code here

Also, you should not open the database in other files all the time. They must be closed at the same moment when you received or wrote down the necessary information.