OPNsense Forum

Archive => 22.7 Legacy Series => Topic started by: crissi on January 19, 2023, 01:55:25 pm

Title: configd.py Error sqlite error while executing DROP TABLE
Post by: crissi on January 19, 2023, 01:55:25 pm

Hello,

upgraded today to V22-7-11 and recognized the following Syslog errors in backend:

Code: [Select]

2023-01-19T12:30:30 Error configd.py [dc4fc17f-1320-4ae5-86d3-969fb0e120ec] Script action stderr returned "b'pkg: sqlite error while executing DROP TABLE repo_update; in file pkgdb.c:2320: attempt to write a readonly database'"


Code: [Select]

2023-01-19T12:30:29 Error configd.py [82367a10-f22f-47e9-97b3-b8bf83c2579f] Script action stderr returned "b'pkg: sqlite error while executing CREATE TABLE packages (id INTEGER PRIMARY KEY,origin TEXT,name TEXT NOT NULL,version TEXT NOT NULL,comment TEXT NOT NULL,desc TEXT NOT NULL,osversion TEXT,arch TEXT NOT NULL,maintainer TEXT NOT NULL,www TEXT,prefix TEXT N'"


Code: [Select]

2023-01-19T12:29:43 Error configd.py Timeout (120) executing : interface newip 'lagg0'


Code: [Select]

2023-01-19T12:23:49 Error configd.py Timeout (120) executing : interface newip 'lagg0_vlan

How to solve them?

thx

Title: Re: configd.py Error sqlite error while executing DROP TABLE
Post by: crissi on February 01, 2023, 10:48:08 am

Have still the following error after Update to 23.1_6

Code: [Select]

2023-01-30T14:57:15 Error configd.py [f9bee656-6298-4dcf-b44f-d104d2aa3af0] Script action stderr returned "b"pkg: sqlite error while executing SELECT count(name) FROM sqlite_master WHERE type='table' AND name='repodata'; in file pkgdb.c:2345: database is locked\npkg: Repository OPNsense contains no repodata table, need to re-create database\npkg: sqlite error whil""


Code: [Select]

2023-01-30T14:57:15 Error configd.py [ce08aa03-0906-4025-8b4b-7bc62dac74b5] Script action stderr returned "b'pkg: sqlite error while executing CREATE TABLE packages (id INTEGER PRIMARY KEY,origin TEXT,name TEXT NOT NULL,version TEXT NOT NULL,comment TEXT NOT NULL,desc TEXT NOT NULL,osversion TEXT,arch TEXT NOT NULL,maintainer TEXT NOT NULL,www TEXT,prefix TEXT N'"

Do someone know, how to fix them?

Thx