Bug 53468 – netlogon listener: sqlite3.OperationalError: cannot VACUUM from within a transaction

Bug 53468 - netlogon listener: sqlite3.OperationalError: cannot VACUUM from within a transaction


Summary:	netlogon listener: sqlite3.OperationalError: cannot VACUUM from within a tran...

Status:	CLOSED DUPLICATE of bug 52618

Product:	UCS@school
Classification:	Unclassified
Component:	Netlogon scripts
Version:	UCS@school 5.0
Hardware:	Other Linux

Importance:	P5 normal (vote)
Target Milestone:	UCS@school 5.0 v1
Assigned To:	Florian Best
QA Contact:	Felix Botner

URL:
Keywords:	interim-4

Depends on:
Blocks:
	Show dependency tree / graph

Reported:	2021-06-21 09:43 CEST by Florian Best
Modified:	2022-03-23 09:58 CET (History)
CC List:	1 user (show)

See Also:	52618 52619
What kind of report is it?:	Development Internal
What type of bug is this?:	---
Who will be affected by this bug?:	---
How will those affected feel about the bug?:	---
User Pain:
Enterprise Customer affected?:
School Customer affected?:
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:
Bug group (optional):
Max CVSS v3 score:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

Description Florian Best

2021-06-21 09:43:15 CEST

We see the following traceback in the listener module ucs-school-user-logonscript.py:

https://jenkins.knut.univention.de:8181/job/UCSschool-5.0/job/Install%20Singleserver/Config=s4,TestGroup=import3,UCSRelease=testing/ws/test/listener.log

Traceback (most recent call last):
  File "/usr/lib/univention-directory-listener/system/ucs-school-user-logonscript.py", line 310, in clean
    SqliteQueue(logger=Log).truncate_database()
  File "/usr/lib/python3/dist-packages/ucsschool/netlogon/__init__.py", line 145, in truncate_database
    cursor.execute(u"VACUUM")
  File "/usr/lib/python3/dist-packages/ucsschool/netlogon/__init__.py", line 96, in execute
    return self._cursor.execute(query)
sqlite3.OperationalError: cannot VACUUM from within a transaction

Comment 1 Florian Best

2021-07-05 16:56:05 CEST


*** This bug has been marked as a duplicate of bug 52618 ***

Comment 3 Felix Botner

2021-08-05 11:56:01 CEST

ok

Comment 4 Felix Botner

2021-08-05 15:14:06 CEST

ok