Maria DB Fatal Error Can't create/write to file '/var/tmp/#sql-temptable-227-8f9d-13e.MAI Errcode: 2 No such file or directory

[joejac]

SYSTEM INFORMATION
OS type and version	AlmaLinux 9.4
Webmin version	2.202
Virtualmin version	7.20.2
Webserver version	Apache 2.4.57
Related packages	MariaDB 10.5.22

Hello to all.

1. I get this error after 1 hour of generating a new virtual server:

Importing MariaDB database newdomain …
… MariaDB database failed! : mysql::table_structure failed : SQL desc db failed : Can’t create/write to file ‘/var/tmp/#sql-temptable-227-8f21-33.MAI’ (Errcode: 2 “No such file or directory”)
mysql/mysql-lib.pl/(line 359)
…/web-lib-funcs.pl (line 4264)

There was no database to import because it was a new virtual server.

Unlike other accounts, the Edit Databases option is not in the menu, and I need to create and populate a database for this new virtual server.

2. In Webmin > Servers > MariaDB Database Server, there is no list although I have another virtual server with a database and only appears a pink error, please see the screen capture ant the end:

Fatal Error!
SQL select table_schema,table_name from information_schema.views where table_schema = ? failed : Can’t create/write to file ‘/var/tmp/#sql-temptable-227-8f9d-13e.MAI’ (Errcode: 2 “No such file or directory”)

2.1 In the button Create a new database, an option to assign a virtual server to the new database does not appear.

Compared to Centos 7 + Virtualmin 7.1 something is not working fine in Alma Linux 9 + Virtualmin version 7.20.2 at least in my new installation.

What can I do?
I deleted the virtual server and created it again with the same error, and another hour was lost in the virtual server creation process.
Thank you and regards.
joejac