Website Dropdown not working any more


#1

Hi,

I just upgraded to 1.6 and the website dropdown does not work any more, every time I try to select a website from the dropdown it asks me to download index.php, when doing so I get an empty file.

I see no messages in error logs or anything, please advice…

Thanks
Bastian


(Matthieu Aubry) #2

Can you right click on the link in the dropdown and copy it here? it sounds like maybe the link is not constructed correctly?


#3

Not working here either. If I drop down and click on any website other than the default option (one that loads when you first log in) it gives us an error. There error says “Proxy Received an invalid response.” If I bring it back to 1.5.1 works fine.


#4

Upgraded off the RC and it still claims I am running 1.5.1? However the drop downs work now…So am I running 1.5.1 or 1.6 hmmm


(Matthieu Aubry) #5

JMETERX, what is the URL that it is trying to load that returns an error message ? can you copy here the URL without the domain as to see if the URL is the problem, or something else.

Regarding the update, make sure all files are overwritten correctly. Then, delete browser cache and refresh and you should see “About Piwik 1.6” in the box.


#6

Matt-

Deleted browser cache still did not do the job. We are running multiple frontend servers here so I deleted all the files and ensured they were overwritten correctly. We now get this error:


Zend_Session::start() - /opt/piwik/libs/Zend/Session.php(Line:480): Error #2 session_start() [function.session-start]: open(/opt/piwik/tmp/sessions/sess_0v6cqgbq580f379o9hnvbdio52, O_RDWR) failed: No such file or directory (2) Array /opt/piwik/libs/Zend/Session.php(Line:490): Error #2 session_write_close() [function.session-write-close]: open(/opt/piwik/tmp/sessions/sess_0v6cqgbq580f379o9hnvbdio52, O_RDWR) failed: No such file or directory (2) Array /opt/piwik/libs/Zend/Session.php(Line:490): Error #2 session_write_close() [function.session-write-close]: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/opt/piwik/tmp/sessions) Array

After receiving this I pushed the files to the server again and are now back up but still receiving the version number of 1.5.1. I also checked the sessions and it IS set to save it in the correct place (opt/piwik/tmp/sessions) and the folder does exist. The config file is also set up to save the session data to the DB so maybe that is the issue that is coming into play? Either way we aren’t receiving that error anymore but I have no clue what version I am really running here…PLEASE HELP!! :S


#7

I also have my config.ini.php file syncing across all systems. Basically set up the exact way the instructions read for multiple servers


(Matthieu Aubry) #8

To know for sure which version you are running, you should look at the file core/Version.php

Also, please try to delete the directories inside tmp/* in your webservers, and they should be created again (maybe you will have to setup the right permissions).

After this, you should definitely see in the “About box” the same version number as your core/Version.php file.

Error #2 session_start() [function.session-start]: open(/opt/piwik/tmp/sessions/sess_0v6cqgbq580f379o9hnvbdio52, O_RDWR) failed: No such file or directory

Regarding this error I am not sure what the problem could be - does /opt/piwik/tmp/sessions/ and all files inside have RW for the webserver user to overwrite these files?

But, if you have several servers behind load balancer, you should be using DB based sessions as explained in: Installation - Analytics Platform - Matomo

Then no such message should be displayed?


#9

[quote=matt]
Can you right click on the link in the dropdown and copy it here? it sounds like maybe the link is not constructed correctly?[/quote]

Hi Matt,

Here comes a sample url:

index.php?module=CoreHome&action=index&date=yesterday&period=day&updated=1&idSite=17#module=Dashboard&action=embeddedIndex&date=yesterday&period=day&idSite=17

I guess the # might be the issue, curiously it does not allways happen, sometimes the dropdown works…

Thanks
Bastian


#10

Matt -

Checked out the core/Version.php — still says 1.5.1. I have no clue as to why this might be. I even tried deleting all the piwik files and just doing a “fresh” install on one of the servers. That is when we received the “Zend Session” error that is located earlier in this thread. I did download the correct file. Also performed all the needed steps of deleting everything inside tmp folder.

[quote=“Regarding this error I am not sure what the problem could be - does /opt/piwik/tmp/sessions/ and all files inside have RW for the webserver user to overwrite these files? But, if you have several servers behind load balancer, you should be using DB based sessions as explained in: [piwik.org] Then no such message should be displayed?”]

[/quote]

I agree this message should not even be displayed at this point.

RW are set correctly, and yes we ARE using the DB sessions though I am not 100% convinced they are properly going to the DB…

We have this set in the config.ini.php file here is the code:
Is this all you ahve to do to make it set or do we need to edit the php.ini file as well?


session_save_handler = dbtable


#11

Matt -

Just tried to install everything again. Here is what my Version.php reads (Remember, I DID and CONFIRMED the version I installed is 1.6)


<?php
/**
 * Piwik - Open source web analytics
 *
 * @link http://piwik.org
 * @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
 * @version $Id: Version.php 5014 2011-07-09 10:28:13Z matt $
 *
 * @category Piwik
 * @package Piwik
 */

/**
 * Piwik version information.
 *
 * @package Piwik
 */
final class Piwik_Version
{
        const VERSION = '1.5.1';
}

UPDATE:This is pretty strange but I was using a wget command to download from http://piwik.org/latest.zip and it would download and I would check the version and everytime it was reading as 1.5.1. So I downloaded the files to my desktop and transferred them to one of our other servers and wouldn’t you know it, it now says 1.6!

On that note, the issue still remains with the drop down not working…Here is the code for one of mine


index.php?module=MultiSites&action=index&period=day&date=today&idSite=12

NOTE: Just like the other user having the same issue mine does not happen all the time. Also, is there another way we can get in contact with you a little faster?


(Matthieu Aubry) #12

JMETERX, the problem is probably that some proxy server cached piwik.org/latest.zip. Instead, try to download from : http://builds.piwik.org/piwik-1.6.zip

Regarding the website dropdown problem, I suspect that the problem is not so much the dropdown but the fact that the request for another website either times out, or fails to process. Can you check your webserver error logs? Is there any information there?


#13

Here is my log for a period of about 10 seconds that I was receiving the error:
Basically when it happens we get the short links like the three in bold below. The large links are when the back button is clicked.

The error we receive is [quote=“The Proxy received an invalid response. URL: ********/index.php?module=CoreHome&action=index&period=day&date=2011-10-14&idSite=11”]

[/quote]

[b]XXX.XXX.XXX - - [19/Oct/2011:12:46:12 -0500] “GET /piwik.php” 200 121

XXX.XXX.XXX - - [19/Oct/2011:12:46:16 -0500] “GET /piwik.php” 200 121

XXX.XXX.XXX - - [19/Oct/2011:12:46:17 -0500] “GET /piwik.php” 200 121[/b]

XXX.XXX.XXX - - [19/Oct/2011:12:46:18 -0500] “GET /index.php?module=CoreHome&action=index&idSite=1&period=day&date=2011-10-14 HTTP/1.1” 200 22718

XXX.XXX.XXX - - [19/Oct/2011:12:46:18 -0500] “GET /index.php?module=Dashboard&action=embeddedIndex&idSite=1&period=day&date=2011-10-14 HTTP/1.1” 200 10956

XXX.XXX.XXX - - [19/Oct/2011:12:46:19 -0500] “GET /index.php?module=VisitsSummary&action=getSparklines&widget=1&idSite=1&period=day&date=2011-10-14 HTTP/1.1” 200 2208

XXX.XXX.XXX - - [19/Oct/2011:12:46:19 -0500] “GET /index.php?module=UserCountryMap&action=worldMap&widget=1&idSite=1&period=day&date=2011-10-14 HTTP/1.1” 200 2798

XXX.XXX.XXX - - [19/Oct/2011:12:46:19 -0500] “GET /index.php?module=VisitorInterest&action=getNumberOfVisitsPerVisitDuration&viewDataTable=table&widget=1&idSite=1&period=day&date=2011-10-14 HTTP/1.1” 200 3681

XXX.XXX.XXX- - [19/Oct/2011:12:46:19 -0500] “GET /index.php?module=VisitTime&action=getVisitInformationPerServerTime&viewDataTable=graphPie&widget=1&idSite=1&period=day&date=2011-10-14 HTTP/1.1” 200 4031

XXX.XXX.XXX - - [19/Oct/2011:12:46:19 -0500] “GET /index.php?module=VisitorInterest&action=getNumberOfVisitsPerPage&widget=1&idSite=1&period=day&date=2011-10-14 HTTP/1.1” 200 3572

XXX.XXX.XXX - - [19/Oct/2011:12:46:19 -0500] “GET /index.php?module=UserSettings&action=getBrowser&viewDataTable=graphVerticalBar&widget=1&idSite=1&period=day&date=2011-10-14 HTTP/1.1” 200 3647

XXX.XXX.XXX - - [19/Oct/2011:12:46:19 -0500] “GET /index.php?module=Referers&action=getWebsites&viewDataTable=table&widget=1&idSite=1&period=day&date=2011-10-14 HTTP/1.1” 200 3834

XXX.XXX.XXX - - [19/Oct/2011:12:46:19 -0500] “GET /index.php?module=VisitsSummary&action=getEvolutionGraph&columns[]=nb_visits&viewDataTable=graphEvolution&widget=1&idSite=1&period=day&date=2011-10-14 HTTP/1.1” 200 7404

XXX.XXX.XXX- - [19/Oct/2011:12:46:21 -0500] “GET /piwik.php” 200 121

XXX.XXX.XXX - - [19/Oct/2011:12:46:22 -0500] “GET /piwik.php” 200 121

XXX.XXX.XXX- - [19/Oct/2011:12:46:22 -0500] “GET /index.php?module=CoreHome&action=index&idSite=1&period=day&date=2011-10-14 HTTP/1.1” 200 22718

XXX.XXX.XXX - - [19/Oct/2011:12:46:23 -0500] “GET /index.php?module=Dashboard&action=embeddedIndex&idSite=1&period=day&date=2011-10-14 HTTP/1.1” 200 10956

XXX.XXX.XXX - - [19/Oct/2011:12:46:23 -0500] “GET /index.php?module=UserCountryMap&action=worldMap&widget=1&idSite=1&period=day&date=2011-10-14 HTTP/1.1” 200 2798

XXX.XXX.XXX - - [19/Oct/2011:12:46:23 -0500] “GET /index.php?module=VisitsSummary&action=getSparklines&widget=1&idSite=1&period=day&date=2011-10-14 HTTP/1.1” 200 2208

XXX.XXX.XXX - - [19/Oct/2011:12:46:23 -0500] “GET /index.php?module=VisitorInterest&action=getNumberOfVisitsPerPage&widget=1&idSite=1&period=day&date=2011-10-14 HTTP/1.1” 200 3572

XXX.XXX.XXX - - [19/Oct/2011:12:46:23 -0500] “GET /index.php?module=VisitorInterest&action=getNumberOfVisitsPerVisitDuration&viewDataTable=table&widget=1&idSite=1&period=day&date=2011-10-14 HTTP/1.1” 200 3681

XXX.XXX.XXX - - [19/Oct/2011:12:46:23 -0500] “GET /index.php?module=UserSettings&action=getBrowser&viewDataTable=graphVerticalBar&widget=1&idSite=1&period=day&date=2011-10-14 HTTP/1.1” 200 3647

XXX.XXX.XXX - - [19/Oct/2011:12:46:24 -0500] “GET /plugins/UserCountryMap/PiwikMap.swf?cb=49bc5a9ff7c262fe72fef0d1512b0044 HTTP/1.1” 304 -

XXX.XXX.XXX - - [19/Oct/2011:12:46:23 -0500] “GET /index.php?module=Referers&action=getWebsites&viewDataTable=table&widget=1&idSite=1&period=day&date=2011-10-14 HTTP/1.1” 200 3834


(Matthieu Aubry) #14

Could you just put the request that is the one matching your click in the website selector?


#15

Sorry about that

Doing a tail -f to the access_log file gives us nothing but normal generated requests from the load balancer. So we have nothing there. However,

In the error_log we are receiving this each time there is a click


[Wed Oct 19 13:30:01 2011] [notice] child pid 558 exit signal Segmentation fault (11)
[Wed Oct 19 13:30:01 2011] [notice] child pid 796 exit signal Segmentation fault (11)
[Wed Oct 19 13:30:01 2011] [notice] child pid 811 exit signal Segmentation fault (11)
[Wed Oct 19 13:30:01 2011] [notice] child pid 826 exit signal Segmentation fault (11)
[Wed Oct 19 13:30:01 2011] [notice] child pid 827 exit signal Segmentation fault (11)
[Wed Oct 19 13:30:02 2011] [notice] child pid 813 exit signal Segmentation fault (11)

Short of a core dump (beyond my expertise) in Apache not sure what else to do here


(Matthieu Aubry) #16

OK so the problem is really that the some websites trigger a segmentation fault. This is unfortunate :frowning:
I suppose you already looked at: Troubleshooting - Analytics Platform - Matomo ?


#17

I did some more digging and was able to get the trace:


#0  0x01526d9c in zend_do_delayed_early_binding () from /opt/lampp/modules/libphp5.so
(gdb) bt full
#0  0x01526d9c in zend_do_delayed_early_binding () from /opt/lampp/modules/libphp5.so
No symbol table info available.
#1  0x0079e32b in eaccelerator_compile_file () from /opt/lampp/lib/php/extensions/no-debug-non-zts-20090626/eaccelerator.so
No symbol table info available.
#2  0x0150caa2 in compile_filename () from /opt/lampp/modules/libphp5.so
No symbol table info available.
#3  0x01561f7f in zend_get_zval_ptr_ptr () from /opt/lampp/modules/libphp5.so
No symbol table info available.
#4  0x01558847 in execute () from /opt/lampp/modules/libphp5.so
No symbol table info available.
#5  0x0152ce27 in zend_call_function () from /opt/lampp/modules/libphp5.so
No symbol table info available.
#6  0x014589d9 in zif_call_user_func_array () from /opt/lampp/modules/libphp5.so
No symbol table info available.
#7  0x0155936d in zend_get_zval_ptr_ptr () from /opt/lampp/modules/libphp5.so
No symbol table info available.
#8  0x01558847 in execute () from /opt/lampp/modules/libphp5.so
No symbol table info available.
#9  0x0152ce27 in zend_call_function () from /opt/lampp/modules/libphp5.so
No symbol table info available.
#10 0x014589d9 in zif_call_user_func_array () from /opt/lampp/modules/libphp5.so
No symbol table info available.
#11 0x0155936d in zend_get_zval_ptr_ptr () from /opt/lampp/modules/libphp5.so
No symbol table info available.
#12 0x01558847 in execute () from /opt/lampp/modules/libphp5.so
No symbol table info available.
#13 0x01537792 in zend_execute_scripts () from /opt/lampp/modules/libphp5.so
No symbol table info available.
#14 0x014e59fc in php_execute_script () from /opt/lampp/modules/libphp5.so
No symbol table info available.
#15 0x015aa49b in php_ap2_register_hook () from /opt/lampp/modules/libphp5.so
No symbol table info available.
#16 0x080783b8 in ap_invoke_handler ()
No symbol table info available.
#17 0x080870ef in ap_process_request ()
No symbol table info available.
#18 0x080841a8 in ap_filter_protocol ()
No symbol table info available.
#19 0x08080705 in ap_process_connection ()
No symbol table info available.
#20 0x0808dbdc in ap_graceful_stop_signalled ()
No symbol table info available.
#21 0x0808ced7 in ap_graceful_stop_signalled ()
No symbol table info available.
#22 0x0808d0bb in ap_graceful_stop_signalled ()
No symbol table info available.
#23 0x0808c8ce in ap_mpm_run ()
No symbol table info available.
#24 0x080649ca in main ()
No symbol table info available.


In an extremely unfortunate twist of fate upgrading to 1.6 kills eaccelerator. I know you guys had said a few times before that it doesn’t work anyway however, we were able to get it to work and if you have seen my posts in 301 Moved Permanently Eaccelerator along with a few other tweaks increased the load capabilities by almost 150%. Very familiar with your guys segmentation help page, none of it has every worked for me :slight_smile: .

Anything you can think of that has changed between 1.5.1 and 1.6 that would cause this to stop working? Eaccelerator is still working on the other frontend nodes running 1.5.1 and everything works just fine…

By the way thanks for all your help on this…handling as many hits as we do per month its extremely important to keep everything up and running smooth


(Matthieu Aubry) #18

Clearly here this is a bug in Eaccelerator which we can’t do much about, probably triggered by some random dataset (because “only some websites fail”).

Try APC or another one instead? List of PHP accelerators - Wikipedia


#19

Thanks. I will have to try one of those out…we were just talking about Zend may give that a try.

As you can see…no eaccelerator, the other tweaks just are not enough.

[attachment 375 test1.png]


#20

Just an update, APC is up and running works great about 12% more efficient overall than eaccelerator