ads' corner

Ansible, "copy" module and "become"

For testing I did spin up a couple of new virtual (Ubuntu 20.04 LTS) instances, installed PostgreSQL, and wanted to copy over a '.sql' file to install in the database. And ran into a meaningless error message.

openHAB: Configuration model '....rules' has errors, therefore ignoring it: no viable alternative at input '...'

The openHAB rule system is not very helpful by pointing out when it’s missing something, or when there is an error to actually point to the problem.

Apache Karaf client in openHAB, and the "Session has been closed" error

Don’t you love it when things suddenly stop working?

In my openHAB installation I have a check which verifies that the weather data is up to date. Otherwise it restarts the openhab2 service. And this check stopped working … Leaving the kitchen display not updated for a longer time. The same display where I expect the entire installation to “just work”, and don’t create so many different problems. Seems to be a hard problem to have an openHAB installation without any trouble …

MySQL: what shall be repaired?

A website shows the following error message:

SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/tmp/#sql_1898_0.MYI'; try to repair it

So, MySQL: which table is to repair? The error message is not a table, it’s just the temp file.

Stupid and useless error message …

MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28)

If you run MySQL and this error occurs:

 SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/MYh0VgDS' (Errcode: 28)

then check if your server isn’t using the famous “overflow” filesystem for /tmp, limited to 1 MB space.

The MySQL error message is - as usual - misleading and non-descriptive.

There are many other possible causes for this error code, so this one here might just be a hint.