“SQLSTATE[HY000]: General error“ on high traffic site


#1

Hi,

firts of all: thanks for this usefull tool!

We’re currently using PIWIK on several domains from 1000 to 450.000 PI’s a day.

Since 2 or 3 month it is not possible to view the reports of the higher traffic sites any more. PIWIK waits about 1 minute and then always shows up an error message like


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

The complete database is about 1,5GB for three sites and contains about 27.000.000 entries.

Auto archiving is activated but fails every time with the same error message.


Archiving period = week for idsite = 2...
<?xml version="1.0" encoding="utf-8" ?>
<result>
	<error message="SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/MYnqFsfh' (Errcode: 28)" />
</result>

Any idea how to tweak the speed or what this error message could mean?

Using PIWIK 1.1.1, PHP Version 5.2.17,

Thanks.


(Thomas Seifert) #2

OS error code  28:  No space left on device

MySQL is running out of space on the /tmp partition. I guess its creating some large temporary tables here.
Either point mysqls tmp dir to some larger partition or increase the size of the tmp partition.


(Matthieu Aubry) #3

First of all, please upgrade to 1.2-rc3 - there are SQL queries memory improvements in there, which might fix your issue. (check out the top forum topic)

Otherwise, increase size of your partitions, maybe also enable slow query log and send us the log (if after update it still fails).

Thanks!