Since quite some time, months, when booting my Tumbleweed system, always
up-to-date, I see a red message shown, telling "Failed to start Load Kernel
Modules", coming from the systemd unit systemd-modules-load.service.
However "systemctl status systemd-modules-load.service" later does not show any
error message. Further inspection shows that the module inspects a number of
files with names of modules, among others /etc/modules-load.d/* which contain
module names: sg and snd-hda-intel.
I don't know anymore how I did see a hint on what went wrong, but what I recall
is that it could not find a file or directory.
My suggestion is therefor that at the moment this unit is executed the
filesystem with one of these modules is not yet available. Apparently another
attempt to run the unit succeeds, which explains why such an error message does
not show in the journal.
Maybe the unit should depend on finishing of mounting the root filesystem or
maybe /usr