Repository navigation
python 3.6.0 is not importing sqlite3 #76301
Description
| BPO | 32120 |
|---|---|
| Nosy | @berkerpeksag, @serhiy-storchaka, @python_sqlite issue |
| Superseder |
Note: these values reflect the state of the issue at the time it was migrated and might not reflect the current state.
Show more details
GitHub fields:
assignee = None
closed_at = <Date 2017-11-28.08:57:22.730>
created_at = <Date 2017-11-23.11:14:18.989>
labels = ['extension-modules', 'type-bug']
title = 'python 3.6.0 is not importing sqlite3'
updated_at = <Date 2017-11-28.08:57:22.727>
user = 'https://github.com/pythonsqliteissue'bugs.python.org fields:
activity = <Date 2017-11-28.08:57:22.727>
actor = 'serhiy.storchaka'
assignee = 'none'
closed = True
closed_date = <Date 2017-11-28.08:57:22.730>
closer = 'serhiy.storchaka'
components = ['Extension Modules']
creation = <Date 2017-11-23.11:14:18.989>
creator = 'abinaya'
dependencies = []
files = []
hgrepos = []
issue_num = 32120
keywords = []
message_count = 10.0
messages = ['306803', '306809', '306811', '306813', '306819', '306820', '306881', '307108', '307111', '307113']
nosy_count = 3.0
nosy_names = ['berker.peksag', 'serhiy.storchaka', 'abinaya']
pr_nums = []
priority = 'normal'
resolution = 'duplicate'
stage = 'resolved'
status = 'closed'
superseder = '29098'
type = 'behavior'
url = 'https://bugs.python.org/issue32120'
versions = ['Python 3.6']
Activity
pythonsqliteissue commentedon Nov 23, 2017
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.
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
berkerpeksag commentedon Nov 23, 2017
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 bpo-29098.
pythonsqliteissue commentedon Nov 23, 2017
Thanks for the update.
Could you please let me know if we build latest python_v363 then sqlite will be work right.
berkerpeksag commentedon Nov 23, 2017
It should build fine with Python 3.6.3. Let us know if you can't get it working.
pythonsqliteissue commentedon Nov 23, 2017
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.
berkerpeksag commentedon Nov 23, 2017
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.
pythonsqliteissue commentedon Nov 24, 2017
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.
pythonsqliteissue commentedon Nov 28, 2017
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.
pythonsqliteissue commentedon Nov 28, 2017
*** 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
serhiy-storchaka commentedon Nov 28, 2017
This issue already has been fixed. Try Python 3.6.3.