Hi,

We have installed python-3.6.0 on our RedHat 6 machine.
when we are trying to import sqlite module in python_v36 we could see below issue,

[root@euca-10-254-72-197 rpmbuild]$ python
Python 3.6.0 (default, Nov 23 2017, 12:46:54)
[GCC 4.4.7 20120313 (Red Hat 4.4.7-18)] on linux
Type "help", "copyright", "credits" or "license" for more information.

            import sqlite3
            Traceback (most recent call last):
            File "", line 1, in
            File "/opt/python/x86_64/3.6.0-1/lib/python3.6/sqlite3/init.py", line 23, in
            from sqlite3.dbapi2 import *
            File "/opt/python/x86_64/3.6.0-1/lib/python3.6/sqlite3/dbapi2.py", line 27, in
            from _sqlite3 import *
            ModuleNotFoundError: No module named '_sqlite3'

While installing the python manually we could see below line on installation log
****************************************
Failed to build these modules:
_hashlib _ssl

Following modules built successfully but were removed because they could not be imported:
_sqlite3
****************************************
It seems to be sqlite is getting broken.

Below sqlite versions are already installed on my machine:
********************************************
[root@euca-10-254-72-197 rpmbuild]$ rpm -qa | grep sqlite
qt-sqlite-4.6.2-28.el6_5.x86_64
sqlite-devel-3.6.20-1.el6_7.2.x86_64
sqlite-3.6.20-1.el6_7.2.x86_64
libdbi-dbd-sqlite-0.8.3-5.1.el6.x86_64
**********************************************

Also sqlite3 seems to be working fine without any issue on python2.
Can anyone please help me on this.

Regards,
Abinaya

3.6.0 was required sqlite 3.7.4 but the requirement was lifted in Python 3.6.1. 3.6.3 is the latest release of Python 3.6. Please try Python 3.6.3.

Also, this is a duplicate of issue 29098.

Thanks for the update.

Could you please let me know if we build latest python_v363 then sqlite will be work right.

> Could you please let me know if we build latest python_v363 then sqlite
> will be work right.

It should build fine with Python 3.6.3. Let us know if you can't get it working.

Thanks for the help.

If we import pysqlite2 I could see the error that pysqlite2 module not found.
Please let us know is there anyway to get pysqlite2 in python_v363.

pysqlite2 only works in Python 2: https://github.com/ghaering/pysqlite/blob/e728ffbcaeb7bfae1d6b7165369bd0ae16cabf95/setup.py#L25-L28

You don't need to install pysqlite2 in Python 3. The latest release of Python 3.6 (which is 3.6.3, not 3.6.0) should work fine with sqlite3 3.6.20.

Is there any bug in python_v360.
Please let me know why its not supporting sqlite3.

Python-3.6.3 seems to working but It would be better if you give some clarification about python3.6.0.

Sorry to re-open.

Please anyone let me know why python 3.6.0 not supporting sqlite3.
our customers request to give the clarification.
i have tried a lot and spend more time on this but i couldn't get the exact reason.

*** WARNING: renaming "_sqlite3" since importing it failed: build/lib.linux-x86_64-3.6/_sqlite3.cpython-36m-x86_64-linux-gnu.so: undefined symbol: sqlite3_stmt_readonly

Python build finished successfully!
The necessary bits to build these optional modules were not found:
_lzma
To find the necessary bits, look in setup.py in detect_modules() for the module's name.

The following modules found by detect_modules() in setup.py, have been
built by the Makefile instead, as configured by the Setup files:
atexit                pwd                   time

Failed to build these modules:
_hashlib              _ssl


Following modules built successfully but were removed because they could not be imported:
_sqlite3


>> Above issue is the one which we could see while building the python 3.6.0.

This issue already has been fixed. Try Python 3.6.3.