Issue 32120: python 3.6.0 is not importing sqlite3 (original) (raw)

Issue32120

Created on 2017-11-23 11:14 by abinaya, last changed 2022-04-11 14:58 by admin. This issue is now closed.

Messages (10)
msg306803 - (view)	Author: Abinaya (abinaya)	Date: 2017-11-23 11:14
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
msg306809 - (view)	Author: Berker Peksag (berker.peksag) *	Date: 2017-11-23 11:55
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.
msg306811 - (view)	Author: Abinaya (abinaya)	Date: 2017-11-23 12:00
Thanks for the update. Could you please let me know if we build latest python_v363 then sqlite will be work right.
msg306813 - (view)	Author: Berker Peksag (berker.peksag) *	Date: 2017-11-23 12:44
> 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.
msg306819 - (view)	Author: Abinaya (abinaya)	Date: 2017-11-23 13:40
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.
msg306820 - (view)	Author: Berker Peksag (berker.peksag) *	Date: 2017-11-23 14:00
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.
msg306881 - (view)	Author: Abinaya (abinaya)	Date: 2017-11-24 09:55
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.
msg307108 - (view)	Author: Abinaya (abinaya)	Date: 2017-11-28 07:14
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.
msg307111 - (view)	Author: Abinaya (abinaya)	Date: 2017-11-28 08:48
*** 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.
msg307113 - (view)	Author: Serhiy Storchaka (serhiy.storchaka) *	Date: 2017-11-28 08:57
This issue already has been fixed. Try Python 3.6.3.