Bug 955973

Summary:	net-dns/avahi-0.9_rc2 db usage broken with python3.13
Product:	Gentoo Linux	Reporter:	Nick Owens <mischief>
Component:	Current packages	Assignee:	No maintainer - Look at https://wiki.gentoo.org/wiki/Project:Proxy_Maintainers if you want to take care of it <maintainer-needed>
Status:	UNCONFIRMED ---
Severity:	normal
Priority:	Normal
Version:	unspecified
Hardware:	All
OS:	Linux
See Also:	https://github.com/avahi/avahi/pull/698 https://github.com/avahi/avahi/issues/670 https://github.com/avahi/avahi/issues/260
Whiteboard:
Package list:		Runtime testing required:	---

Description Nick Owens 2025-05-15 05:24:02 UTC

some python programs in avahi now break with sqlite3 backend in python due to attempts to write to read-only locations. avahi-discover is functionally broken now.

i believe upstream is trying to address it in https://github.com/avahi/avahi/pull/698 but it's not in yet.

mischief@beast:~ $ avahi-discover

(avahi-discover:1600533): GVFS-WARNING **: 22:20:51.707: Error creating proxy: Error calling StartServiceByName for org.gtk.vfs.Daemon: Unit gvfs-daemon.service is masked. (g-io-error-quark, 36)


(avahi-discover:1600533): dbind-WARNING **: 22:20:51.718: AT-SPI: Error retrieving accessibility bus address: org.freedesktop.systemd1.UnitMasked: Unit at-spi-dbus-bus.service is masked.
Browsing domain 'local' on -1.-1 ...
Browsing domain '.' on -1.-1 ...
Browsing for services of type '_matter._tcp' in domain 'local' on 3.1 ...
Browsing for services of type '_workstation._tcp' in domain 'local' on 3.1 ...
Browsing for services of type '_googlezone._tcp' in domain 'local' on 3.1 ...
Browsing for services of type '_googcrossdevice._tcp' in domain 'local' on 3.1 ...
Browsing for services of type '_googlecast._tcp' in domain 'local' on 3.1 ...
Browsing for services of type '_meshcop._udp' in domain 'local' on 3.1 ...
Browsing for services of type '_trel._udp' in domain 'local' on 3.1 ...
Browsing for services of type '_apt_proxy._tcp' in domain 'local' on 3.1 ...
Browsing for services of type '_home-assistant._tcp' in domain 'local' on 3.1 ...
Browsing for services of type '_eero._tcp' in domain 'local' on 3.1 ...
Browsing for services of type '_ssh._tcp' in domain 'local' on 3.1 ...
Browsing for services of type '_sftp-ssh._tcp' in domain 'local' on 3.1 ...
Browsing for services of type '_printer._tcp' in domain 'local' on 3.1 ...
Browsing for services of type '_ipps._tcp' in domain 'local' on 3.1 ...
Browsing for services of type '_ipp._tcp' in domain 'local' on 3.1 ...
Browsing for services of type '_p2p._udp' in domain 'local' on 3.1 ...
Browsing for services of type '_workstation._tcp' in domain 'local' on 3.0 ...
Browsing for services of type '_matter._tcp' in domain 'local' on 3.0 ...
Browsing for services of type '_googlezone._tcp' in domain 'local' on 3.0 ...
Browsing for services of type '_googcrossdevice._tcp' in domain 'local' on 3.0 ...
Browsing for services of type '_googlecast._tcp' in domain 'local' on 3.0 ...
Browsing for services of type '_meshcop._udp' in domain 'local' on 3.0 ...
Browsing for services of type '_trel._udp' in domain 'local' on 3.0 ...
...
Browsing for services of type '_ssh._tcp' in domain 'local' on 1.0 ...
Browsing for services of type '_sftp-ssh._tcp' in domain 'local' on 1.0 ...
Browsing for services of type '_printer._tcp' in domain 'local' on 1.0 ...
Browsing for services of type '_ipps._tcp' in domain 'local' on 1.0 ...
Browsing for services of type '_ipp._tcp' in domain 'local' on 1.0 ...
Browsing for services of type '_workstation._tcp' in domain 'local' on 1.0 ...
Found service '53B88AE6E8649D50-0115C889FA0C5C51' of type '_matter._tcp' in domain 'local' on 3.1.
ERROR:dbus.connection:Exception in handler for D-Bus signal:
Traceback (most recent call last):
  File "/usr/lib/python3.13/dbm/sqlite3.py", line 79, in _execute
    return closing(self._cx.execute(*args, **kwargs))
                   ~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^
sqlite3.OperationalError: attempt to write a readonly database

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/lib/python3.13/site-packages/dbus/connection.py", line 263, in maybe_handle_message
    self._handler(*args, **kwargs)
    ~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^
  File "/usr/bin/avahi-discover", line 143, in new_service
    self.zc_types[(interface,protocol,stype,domain)] = self.insert_row(self.treemodel, thisDomain, self.lookup_type(stype), name, interface,None,None,None)
                                                                                                   ~~~~~~~~~~~~~~~~^^^^^^^
  File "/usr/bin/avahi-discover", line 126, in lookup_type
    return service_type_db[stype].decode('utf-8', 'replace')
           ~~~~~~~~~~~~~~~^^^^^^^
  File "/usr/lib/python3.13/site-packages/avahi/ServiceTypeDatabase.py", line 66, in __getitem__
    return self.db[key + suffix]
           ~~~~~~~^^^^^^^^^^^^^^
  File "/usr/lib/python3.13/dbm/sqlite3.py", line 89, in __getitem__
    with self._execute(LOOKUP_KEY, (key,)) as cu:
         ~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^
  File "/usr/lib/python3.13/dbm/sqlite3.py", line 81, in _execute
    raise error(str(exc))
dbm.sqlite3.error: attempt to write a readonly database
...
many more of the same
...



Reproducible: Always

Steps to Reproduce:
1. avahi-discover

Actual Results:  
read-only exceptions

Expected Results:  
ui shows discovered services