function.gzuncompress error in modules/Archive/Single.php

[anonymous-matomo-user]

I’m testing piwik, (piwik 0.1.5, mysql 4.1.21, php 5.2.5, PDO Driver for MySQL 5.0.41),
and after a week running ok, it has showed this error in two plugins (“Pages” and “List of Keywords”), in the summary for a specific day, in just one site:
for example in plugin “Pages” (the other error is very similar):

+++++++++++++++++++++++++++++++++++++++++

Warning: gzuncompress() [function.gzuncompress]: data error in /piwik/modules/Archive/Single.php on line 246
Backtrace —>

1. Piwik_ErrorHandler(2, gzuncompress() [data error, /piwik/modules/Archive/Single.php, 246, Array ([name](function.gzuncompress]:) => Actions_actions,[=> blob,[table](typeValue]) => piwik_archive_blob_2008_04,[=> Zend_Db_Adapter_Pdo_Mysql Object ([](db]) => mysql,[=> Array ([host](]) => localhost,[=> ****_,[password](username]) => ***_*,[=> *,[tables_prefix](dbname]) => piwik_,[=> PDO_MYSQL,[options](adapter]) => Array ([=> 0,[autoQuoteIdentifiers](caseFolding]) => 1),[=> Array ()),[](driver_options]) => 2,[=> Zend_Db_Profiler Object ([](]) => Array (),[=> ,[](]) => ,[=> ),[](]) => PDO Object (),[=> 0,[](]) => 1),[value] => xo$I?$?mn?�??{

+++++++++++++++++++++++++++++++++++++++++

And it continues on with a very very long binary chunk.

It occurs only in the site that has >5,000 visits per day, and just in one day.
I have other sites with less visits, and they run ok.

mysqlcheck says that there’s no corrupted table.

Both plugins contains thousands of entries… couldn’t be a way to limit their size? May be the size is not related, but it’s enormous anyway.

thanx
Keywords: gzuncompress Single.php

[mattab]

Did it happen only once?

For your query of ‘limit the size of the data’ this is indeed a very important feature we are planning to implement: see #5456

[anonymous-matomo-user]

No, it seems to happen every time the size of the data is too big (thousands of entries) in those two plugins (“Pages” and “List of Keywords”). (Though I haven’t tried every plugin). As I said, the site with the problem has >5,000 visits/day…
If some day visits are lower, the plugins run ok, but if visits are big, the error appears.

I thought it could be related to the php gzuncompress function itself, but I used it with big data, and it compress and uncompress perfectly. May be something related to mysql, or the way the field is stored? If I could know the exact field from the DB in which data resides, I’d try to check it, but the table has thousands of entries, and I wasn’t able to find which registry the php tries to read…

thanx

[mattab]

rsg, finally could reproduce the bug and it comes from the BLOB field limit to 2^16 characters, ie. 65535 bytes.
I changed the types to MEDIUMBLOB which will allow 16MB fields.

The new tables will be available for new users. For existing users, please use this query on your piwik_archive_blob\* tables:

```
ALTER TABLE `piwik`.`piwik_archive_blob_XXXX_XX` MODIFY COLUMN `value` MEDIUMBLOB DEFAULT NULL;
```

[mattab]

(In ⁴⁷⁰) – refs #5623, fixing tables field types, limit is now MEDIUMBLOB to allow up to 16M values. Previous BLOB limit of 64K was not enough.