I recently installed ubuntu focal on my laptop and running ipython based on the python3 (3.8.5) provided by the system produces the following warning:
UserWarning: IPython History requires SQLite, your history will not be saved
Digging further I found that the problem came from the import of sqlite3 in python which produces the following error:
ImportError: /usr/lib/python3.8/lib-dynload/_sqlite3.cpython-38-x86_64-linux-gnu.so: undefined symbol: sqlite3_errstr
I read some posts related to this kind of error but all were about python that the user installed on their own. Here I am dealing with a python provided by the system and I do not want to install a python from scratch. Would you know what is wrong ?
My experience maybe helpful:

check the dynamic library linked by sqlite3
ldd /usr/lib/python3.8/lib-dynload/_sqlite3.cpython-38-x86_64-linux-gnu.so
I found that it linked wrong .so library.

reset LD_LIBRARY_PATH and reinstall sqlite3
native python3 fails to import sqlite3 on ubuntu focal