topic ERROR [HY000] [Qlik][MySQL] Error writing file in App Development

ERROR [HY000] [Qlik][MySQL] Error writing file

nigam_bhavya1410 — Tue, 24 Jan 2023 02:13:04 GMT

Hello All,

I am trying to load data to my Qliksense dashboard through the data load editor. I have been loading the data for two years. While loading the data, I am getting the below error, but it works fine when I load data for one year. Can anyone please help me resolve this issue?

The following error occurred:

ERROR [HY000] [Qlik][MySQL] Error writing file 'C:\Windows\TEMP\MY4ACB.tmp' (Errcode: 28).

Re: ERROR [HY000] [Qlik][MySQL] Error writing file

Benoit_C — Tue, 24 Jan 2023 15:16:46 GMT

Hello @nigam_bhavya1410,

Error you have provided is very generic and does not seem Qlik related.

(Errcode: 28 - No space left on device) The error means that you don't have enough space to create temp files needed by MySQL.
You can use df -h to check whether \tmp is in its own partition, and how much space is allocated to it.

If it is in its own partition and short of space, you can either: modify /tmp so that its partition has more space (either by reallocating or moving it to the main partition - e.g. see here) changing MySql config so that it uses a different temp folder on a different partition, e.g. /var/tmp

You can refer this similar issue:

https://stackoverflow.com/questions/7415710/mysql-writing-file-error-errcode-28
https://support.cpanel.net/hc/en-us/articles/4402486828567-MySQL-won-t-start-Errcode-28-No-space-left-on-device-

Regards,

Benoit

Re: ERROR [HY000] [Qlik][MySQL] Error writing file

ShubhamD_QS — Tue, 13 Jun 2023 06:41:47 GMT

Hi @Benoit_C ,

We are also getting the same error,

ERROR [HY000] [Qlik][Support] (50070) Cannot open file 'C:\Users\AUQLIK~1\AppData\Local\Temp\XYZ.tmp' - Error: Access is denied.

What could be the reason ??

Is it from QlikSense or DB ?

Shubham