Segmentation fault with cronjob under Debian Squeeze

Support & Bugs
1

Hello dear Piwik users.

When executing the archive.sh script via cronjob every hour sometimes the script chrashes with a segmentation fault:

Sep 23 13:05:03 machine_xy kernel: [3986278.598839] php5[25030]: segfault at ffffffff ip 00000000006a311f sp 00007fff0280a040 error 4 in php5[400000+6f9000]
Sep 23 13:05:03 machine_xy /USR/SBIN/CRON[25009]: (CRON) error (grandchild #25011 failed with exit status 139)

I have been looking into the Segmentation Fault FAQs but nothing has worked so far. Changed PDO_MYSQL to MYSQLI. Did nothing. I cannot disable suhosin because I need it for other stuff

I am using Debian Squeeze (2.6.32-5), PHP5 version is 5.3.3-7. MYSQL version is 5.1.49-3.

Any other suggestions? Do I have to use a older version of Piwik??

2

I have had the same problem as this today on a Debian 6 server.

My solution was to install php5-cgi and modify the archive.sh script to use that and not cli.

edit line 33 on the file /misc/cron/archive.sh
changing
"for TEST_PHP_BIN in php5 php php-cli php-cgi; do"
to
"for TEST_PHP_BIN in php5 php php-cgi; do"

It should now work on Debian 6 and Ubuntu 11

Please let us know if this fixed your problem.

3

Please try to use SVN trunk and use the new archive.php cron script in the same directory, it behaves a lot better and will become the new script in the next release. Does it work fine for you?

4

SVN is something new to me so how do I get access to it ? Do I use just that file or should I update the entire installation ?

5

You can now try 1.7-b1: http://builds.piwik.org/piwik-1.7-b1.zip