[CASSANDRA-18088] cqlsh - module 're' has no attribute 'sre_parse' - with Python 3.11

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 4.0.8, 4.1.1, 5.0-alpha1, 5.0
• Component/s: CQL/Interpreter
• Bug Category: Code
• Severity: Normal
• Complexity: Normal
• Discovered By: User Report
• Platform: All
• Since Version: NA

Source Control Link

https://github.com/apache/cassandra/commit/0b5248d8c3ef743a8dda42f7be5dadb70e373b51

Test and Documentation Plan

run CI

• Assignee: Brandon Williams
• Reporter: Aaron Ploetz

Authors

Brandon Williams

Reviewers

Berenguer Blasi

• Created: 04/Dec/22 17:43
• Updated: 12/Sep/23 13:02
• Resolved: 20/Jan/23 21:31

Description

User reported an error with cqlsh (Cassandra 4.0.7) on Stack Overflow: https://stackoverflow.com/questions/74673247/cannot-able-to-run-cqlsh-due-to-python-attribute-error

 

Found out that the user was using Python 3.11, and I was able to reproduce it with that.

% python3.11 bin/cqlsh.py
Traceback (most recent call last):
  File "/Users/aaronploetz/local/apache-cassandra-4.0.7/bin/cqlsh.py", line 159, in <module>
    from cqlshlib import cql3handling, cqlhandling, pylexotron, sslhandling, cqlshhandling
  File "/Users/aaronploetz/local/apache-cassandra-4.0.7/bin/../pylib/cqlshlib/cql3handling.py", line 19, in <module>
    from cqlshlib.cqlhandling import CqlParsingRuleSet, Hint
  File "/Users/aaronploetz/local/apache-cassandra-4.0.7/bin/../pylib/cqlshlib/cqlhandling.py", line 23, in <module>
    from cqlshlib import pylexotron, util
  File "/Users/aaronploetz/local/apache-cassandra-4.0.7/bin/../pylib/cqlshlib/pylexotron.py", line 342, in <module>
    class ParsingRuleSet:
  File "/Users/aaronploetz/local/apache-cassandra-4.0.7/bin/../pylib/cqlshlib/pylexotron.py", line 343, in ParsingRuleSet
    RuleSpecScanner = SaferScanner([
                      ^^^^^^^^^^^^^^
  File "/Users/aaronploetz/local/apache-cassandra-4.0.7/bin/../pylib/cqlshlib/saferscanner.py", line 91, in {}init{}
    s = re.sre_parse.State()
        ^^^^^^^^^^^^

AttributeError: module 're' has no attribute 'sre_parse'

Appears to be something specific (again) with Python's synchronizing regex engine (SRE).  Works fine with Python 3.10, so there may have been a(nother) breaking change in that the re module with 3.11.

Issue Links

• requires: CASSANDRA-18121 Dtests need python 3.11 support
• requires: CASSANDRA-18094 Add python 3.11 to CI