Skip to content

sqlite3 OperationalError on changing into WAL transaction mode #73414

Closed
Closed
sqlite3 OperationalError on changing into WAL transaction mode#73414
Labels
stdlibStandard Library Python modules in the Lib/ directorytype-bugAn unexpected behavior, bug, or error

Description

@yadayada
yadayada
mannequin
opened on Jan 10, 2017
BPO 29228
Nosy @berkerpeksag, @palaviv, @yadayada
Superseder
  • bpo-28518: execute("begin immediate") throwing OperationalError
    		•

    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-01-10.18:33:37.730>
created_at = <Date 2017-01-10.18:19:26.362>
labels = ['type-bug', 'library']
title = 'sqlite3 OperationalError on changing into WAL transaction mode'
updated_at = <Date 2017-01-23.22:31:00.701>
user = 'https://github.com/yadayada'

    bugs.python.org fields:

    activity = <Date 2017-01-23.22:31:00.701>
actor = 'palaviv'
assignee = 'none'
closed = True
closed_date = <Date 2017-01-10.18:33:37.730>
closer = 'berker.peksag'
components = ['Library (Lib)']
creation = <Date 2017-01-10.18:19:26.362>
creator = 'yadayada'
dependencies = []
files = []
hgrepos = []
issue_num = 29228
keywords = []
message_count = 3.0
messages = ['285141', '285142', '286123']
nosy_count = 3.0
nosy_names = ['berker.peksag', 'palaviv', 'yadayada']
pr_nums = []
priority = 'normal'
resolution = 'duplicate'
stage = 'resolved'
status = 'closed'
superseder = '28518'
type = 'behavior'
url = 'https://bugs.python.org/issue29228'
versions = ['Python 3.6']

    Activity

    1. yadayada commented on Jan 10, 2017

      @yadayada
      yadayadamannequin
      on Jan 10, 2017
      MannequinAuthor

      Running

      sqlite3.connect('foo.db').execute("PRAGMA journal_mode = WAL")

      will throw

      sqlite3.OperationalError: cannot change into wal mode from within a transaction

      on Python 3.6.0, but not with older versions.

    2. berkerpeksag commented on Jan 10, 2017

      @berkerpeksag
      berkerpeksag
      on Jan 10, 2017
      Member

      Thanks for the report. This is a duplicate of bpo-28518.

    3. berkerpeksag
      added
      stdlibStandard Library Python modules in the Lib/ directory
      on Jan 10, 2017
    4. berkerpeksag
      closed this as completedon Jan 10, 2017
    5. berkerpeksag
      added
      type-bugAn unexpected behavior, bug, or error
      on Jan 10, 2017

    6. palaviv commented on Jan 23, 2017

      @palaviv
      palavivmannequin
      on Jan 23, 2017
      Mannequin

      There is also a issue with the docs here. Look at bpo-29121.

    7. ezio-melotti
      transferred this issue fromon Apr 10, 2022
    Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

    Metadata

    Metadata

    Assignees

    No one assigned

      Labels

      stdlibStandard Library Python modules in the Lib/ directorytype-bugAn unexpected behavior, bug, or error

      Projects

      No projects

        Milestone

        No milestone

        Relationships

        None yet

        Development

        No branches or pull requests

        Issue actions