Please Help: API exit signal Segmentation fault


#1

Dell All , Please help me, My question is very strange.

Please reference the below feature1. I can get the Visitor Log normally. It’s no problem.
[attachment 245 visitors_log.png]

Please reference the below feature2. Its use the Official’ API [module=API&method=Actions.getPageTitles] to get data. This image is right, because the Site ID1 is no data. So each date showed Empty table. It’s ok.
[attachment 246 API_getPageTitles.png]

My problem is below feature 3. In the image I got nothing, This time I trace the Appache Error log, found string about these:
[Sat Jun 25 20:05:27 2011] [notice] child pid 7342 exit signal Segmentation fault (11)
[Sat Jun 25 20:33:08 2011] [notice] child pid 7338 exit signal Segmentation fault (11)

I don’t know what’s happening, I haven’t modified the piwik/index.php, It’s Official Piwik API. I just use it.
My question is why Feature2 with site:1 no data can present normally,
Why Site:2 have data can’t present to normally just show white page empty.

Other, Above two img use URL is: (only different idSite=1 & idSite=2)
http://10.201.175.xx/piwik/index.php?module=API&method=Actions.getPageTitles&idSite=2&period=day&date=last10&format=rss&token_auth=ec0e6bcc3218acf4616abd7c2c2ab360
I don’t know why ‘isSite=2’ can’t show data. Please Help. thks
[attachment 247 API_getPageTitlesSite2.png]

Please help me. thank you very much.


(vipsoft) #2

The Visitor log is a plain SELECT over the raw tables. In contrast, for Page Titles, Piwik gets the data from the archive. To generate the archives, Piwik has to SELECT from raw tables, INSERT/LOAD DATA into archive tables, and the SELECT from the archive tables.

Please update to Piwik 1.5 if you haven’t already done so, and refer to Troubleshooting - Analytics Platform - Matomo


#3

Hi Anthon,
Thanks for your response, Yes I am upgrade to Piwik 1.5 & PHP is 5.3.0. My adapter use the “PDO_MYSQL” , So far , I still can’t resolve it.

But I have try open the Debug log from global.ini.php. I Found something May be have somebody can help me. Wen I Run the API again I will get the below error message in …/tmp/logs.

[2011-06-26 23:21:01] [9caab5b8] [10.79 Mb] * PROCESSING Preparing archive: day(2011-06-24), plugin Actions , not archived yet…

[2011-06-26 23:21:01] [9caab5b8] [10.81 Mb] ‘day’, idSite = 2 (definitive archive), segment = ‘’, report = ‘Actions_actions’, UTC datetime [2011-06-24 00:00:00 -> 2011-06-24 23:59:59 ]…

[2011-06-26 23:21:01] [9caab5b8] [11.58 Mb] LOAD DATA INFILE failed… Error was:SQLSTATE[HY000]: General error: 13 Can’t get stat of ‘/var/piwik/tmp/assets/piwik_archive_blob_2011_06-8da10daa4e8b4d7faed083fa25b8cecc.csv’ (Errcode: 2)

Have anyone can help me again, thank you much, Thanks.

Potato


(vipsoft) #4

Change the permissions on the tmp/assets folder so it’s writeable by the web user, i.e., 0600 may be too restrictive. Try chmod 0660 tmp/assets. If that still fails, try chmod 0666 tmp/assets.


#5

Hi Anthon,
Yes , Thanks you, My problem is fixed. Thank you very much.
My Approach is your support method “chmod 0660 tmp/assets”.

Thanks again , thank you very much.
Potato


#6

Other, If your Dashbord doesn’t working after upgrade to 1.5 or 1.6.
You also can try reference below url change setting for the fix.

; file location: …/config/global.ini.php
; if set to 1, javascript and css files will be included individually
; this option must be set to 1 when adding, removing or modifying javascript and css files
disable_merged_assets = 1

http://forum.piwik.org/read.php?2,78043,78043