Skip to content

Python 3.13: test_sqlite3 fails. TESTFN_UNDECODABLE in test/support/os_helper.py is broken on zfs. #125117

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
satmandu opened this issue Oct 8, 2024 · 6 comments
Closed

Python 3.13: test_sqlite3 fails. TESTFN_UNDECODABLE in test/support/os_helper.py is broken on zfs. #125117

satmandu opened this issue Oct 8, 2024 · 6 comments
Labels
topic-sqlite3 type-bug An unexpected behavior, bug, or error

Comments

@satmandu
Copy link

satmandu commented Oct 8, 2024 •
edited
Loading

Bug report

Bug description:

Fails in both i686 and x86_64 containers on an Ubuntu 24.04 host with a zfs filesystem with utf8only = on and normalization = formD, succeeds in armv7l container on a debian host with an ext4 filesystem on ChromeOS/Chromebrew.

0:03:42 load avg: 1.48 [37/44] test_sqlite3                                                                                                   
test test_sqlite3 failed                                                                                                                      
0:03:44 load avg: 1.44 [38/44] test_statistics -- test_sqlite3 failed (4 errors)                                                              
0:04:13 load avg: 1.29 [39/44] test_str                                                                                                       
0:04:21 load avg: 1.24 [40/44] test_struct                                                                                                    
0:04:24 load avg: 1.22 [41/44] test_tabnanny                                                                                                  
0:04:25 load avg: 1.22 [42/44] test_time                                                                                                      
0:04:28 load avg: 1.22 [43/44] test_xml_etree                                                                                                 
0:04:31 load avg: 1.21 [44/44] test_xml_etree_c  

LD_LIBRARY_PATH=/usr/local/tmp/crew/py
thon3.20241008135741.dir/Python-3.13.0/builddir:/usr/local/lib64:/lib64 ./python ../Lib/test/test_sqlite3/                                    
test_sqlite3: testing with SQLite version 3.46.1                                                                                              
..............................................................................................................................................
..........................................................EE....EE............................................................................
.........................................................................................................................s.s..................
.....................................s.s.................                                                                                     
======================================================================                                                                        
ERROR: test_open_undecodable_uri (test.test_sqlite3.test_dbapi.OpenTests.test_open_undecodable_uri)                                           
----------------------------------------------------------------------                                                                        
Traceback (most recent call last):                                                                                                            
  File "/usr/local/tmp/crew/python3.20241008135741.dir/Python-3.13.0/Lib/test/test_sqlite3/test_dbapi.py", line 729, in test_open_undecodable_
uri                                                                                                                                           
    with contextlib.closing(sqlite.connect(uri, uri=True)) as cx:                                                                             
                            ~~~~~~~~~~~~~~^^^^^^^^^^^^^^^                                                                                     
sqlite3.OperationalError: unable to open database file                                                                                        
                                                                                                                                              
======================================================================                                                                        
ERROR: test_open_undecodable_uri (test.test_sqlite3.test_dbapi.OpenTests.test_open_undecodable_uri)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/local/tmp/crew/python3.20241008135741.dir/Python-3.13.0/Lib/test/support/os_helper.py", line 345, in unlink
    _unlink(filename)
    ~~~~~~~^^^^^^^^^^
OSError: [Errno 84] Invalid or incomplete multibyte or wide character: b'@test_10783_tmp\xe7w\xf0'

======================================================================
ERROR: test_open_with_undecodable_path (test.test_sqlite3.test_dbapi.OpenTests.test_open_with_undecodable_path)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/local/tmp/crew/python3.20241008135741.dir/Python-3.13.0/Lib/test/test_sqlite3/test_dbapi.py", line 682, in test_open_with_undecod
able_path
    with contextlib.closing(sqlite.connect(path)) as cx:
                            ~~~~~~~~~~~~~~^^^^^^
sqlite3.OperationalError: unable to open database file

======================================================================
ERROR: test_open_with_undecodable_path (test.test_sqlite3.test_dbapi.OpenTests.test_open_with_undecodable_path)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/local/tmp/crew/python3.20241008135741.dir/Python-3.13.0/Lib/test/support/os_helper.py", line 345, in unlink
    _unlink(filename)
    ~~~~~~~^^^^^^^^^^
OSError: [Errno 84] Invalid or incomplete multibyte or wide character: b'@test_10783_tmp\xe7w\xf0'

----------------------------------------------------------------------
Ran 481 tests in 1.226s

FAILED (errors=4, skipped=4)

CPython versions tested on:

3.13

Operating systems tested on:

Linux
@satmandu satmandu added the type-bug An unexpected behavior, bug, or error label Oct 8, 2024
@satmandu
Copy link
Author

satmandu commented Oct 8, 2024

This might be related to #81765 as this is on an OpenZFS filesystem...

@satmandu satmandu changed the title Python 3.13 build test_sqlite3 fails Python 3.13: test_sqlite3 fails with builds on zfs filesystem Oct 8, 2024
@satmandu satmandu changed the title Python 3.13: test_sqlite3 fails with builds on zfs filesystem Python 3.13: test_sqlite3 fails. TESTFN in test/support/os_helper.py is broken on zfs? Oct 8, 2024
@satmandu satmandu changed the title Python 3.13: test_sqlite3 fails. TESTFN in test/support/os_helper.py is broken on zfs? Python 3.13: test_sqlite3 fails. TESTFN_UNDECODABLE in test/support/os_helper.py is broken on zfs. Oct 8, 2024
@erlend-aasland
Copy link
Contributor

This might be related to #81765 as this is on an OpenZFS filesystem...

Yes, it does look suspiciously similar. Consider closing this as a duplicate.

@satmandu
Copy link
Author

satmandu commented Oct 8, 2024

This might be related to #81765 as this is on an OpenZFS filesystem...

Yes, it does look suspiciously similar. Consider closing this as a duplicate.

As per #81765 (comment) is there a good way to tag this (or that 5 year old issue with a confirmation 3 years ago) as a bug for the test suite?

@erlend-aasland
Copy link
Contributor

Suspecting #120191 is related (or a duplicate).

@satmandu
Copy link
Author

satmandu commented Oct 9, 2024

Suspecting #120191 is related (or a duplicate).

That would now be confirmed.

@erlend-aasland erlend-aasland mentioned this issue Oct 10, 2024
Open
@erlend-aasland
Copy link
Contributor

Thanks, @satmandu! Marking this as a duplicate of #81765.

@erlend-aasland erlend-aasland closed this as not planned Won't fix, can't repro, duplicate, stale Oct 10, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
topic-sqlite3 type-bug An unexpected behavior, bug, or error
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@satmandu @skirpichev @erlend-aasland