Databases
StackOverflow2013
Postsdbo
POError when using XHProf and XHGui
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POError when using XHProf and XHGui
    text
    copied!<p>I have installed and configured XHGui as per the instructions here:</p> <p><a href="http://www.sitepoint.com/the-need-for-speed-profiling-with-xhprof-and-xhgui/" rel="nofollow">http://www.sitepoint.com/the-need-for-speed-profiling-with-xhprof-and-xhgui/</a></p> <p>However, when I try to profile a page I see an error inserting into the details table (have truncated this as there is a large string of binary/compressed data):</p> <pre><code>Failed to insert: INSERT INTO `details` (`id`, `url`, `c_url`, `timestamp`, `server name`, `perfdata`, `type`, `cookie`, `post`, `get`, `pmu`, `wt`, `cpu`, `server_id`, `aggregateCalls_include`) VALUES('5278f06a19b9d', '/whats-on/?', '/whats-on/?', FROM_UNIXTIME('1383657576'), 'local.site2', 'x^���r$Iv%\n�K?����v����/?���������-��-�����~��j�\\/�g��&gt;��X����O���~���o��mv���������������r9�p~�=��_��&gt;�N_���jI�/�Wt�bqX�������Sy��S��K�u��:?g��K�6��p�����ӇOw�_&gt;ষ�˄;.|�%��X���;n�&gt;�����������-A\0ܞ/��\n\Z����������;C��om?\r;|a %5\0^�p��+z��A���rk��×�a��L\'OFю@X8�\"��7�\r��ah=���J�\'\n��Q���?�0�?��b\ZN�����rzz�����ߝ�O�Al=7� </code></pre> <p>I believe zlib compression is being used and that my PHP install was compiled with zlib support:</p> <pre><code>'./configure' '--prefix=/usr/local/php5' '--with-apxs2=/usr/sbin/apxs' '--with-config-file-scan-dir=/usr/local/php5/php.d' '--with-openssl=/usr' '--with-zlib=/usr' '--with-zlib-dir=/usr' '--with-gd' '--with-ldap' '--with-xmlrpc' '--enable-exif' '--enable-soap' '--enable-sqlite-utf8' '--enable-wddx' '--enable-ftp' '--enable-sockets' '--with-bz2=/usr' '--enable-zip' '--enable-shmop' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg' '--enable-mbstring' '--enable-bcmath' '--enable-calendar' '--with-iodbc' '--with-mhash' '--enable-fpm' '--with-mysql=mysqlnd' '--with-mysqli=mysqlnd' '--with-pdo-mysql=mysqlnd' '--enable-pcntl' '--enable-dtrace' '--with-icu-dir=/usr/local/php5' '--with-mssql=shared,/usr/local/php5' '--with-pdo-dblib=shared,/usr/local/php5' '--with-libxml-dir=shared,/usr/local/php5' '--with-xsl=shared,/usr/local/php5' '--with-imap=../imap-2007f' '--with-kerberos=/usr' '--with-imap-ssl=/usr' '--with-gettext=/usr/local/php5' '--with-curl=shared,/usr/local/php5' '--with-png-dir=/usr/local/php5' '--with-jpeg-dir=/usr/local/php5' '--enable-gd-native-ttf' '--with-freetype-dir=/usr/local/php5' '--with-pgsql=shared,/usr/local/php5' '--with-pdo-pgsql=shared,/usr/local/php5' '--with-mcrypt=shared,/usr/local/php5' '--with-tidy=/usr/local/php5' '--with-gmp=shared,/usr/local/php5' '--with-readline=shared,/usr/local/php5' </code></pre> <p>Anyone seen this before or know what is going on? Its running on localhost (Mountain Lion with <a href="http://php-osx.liip.ch/" rel="nofollow">Liip OSX PHP</a> - PHP 5.4</p> <p><strong>UPDATE</strong></p> <p>I increased the server_id field length and ran the profile again. Now getting:</p> <p>Incorrect integer value: '' for column 'pmu' at row 1 as a result of this query:</p> <pre><code>INSERT INTO `details` (`id`, `url`, `c_url`, `timestamp`, `server name`, `perfdata`, `type`, `cookie`, `post`, `get`, `pmu`, `wt`, `cpu`, `server_id`, `aggregateCalls_include`) VALUES('5279085839571', '/whats-on/?', '/whats-on/?', FROM_UNIXTIME('1383663629'), 'local.mysitename', 'x^��\0\0�\0�', '1', 'a:1:{s:8:\"_profile\";s:1:\"1\";}', 'a:0:{}', 'a:0:{}', '', '', '', 'localhost', '') </code></pre> <p>SHOW CREATE TABLE:</p> <pre><code>CREATE TABLE `details` ( `id` char(17) NOT NULL, `url` varchar(255) DEFAULT NULL, `c_url` varchar(255) DEFAULT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `server name` varchar(64) DEFAULT NULL, `perfdata` mediumblob, `type` tinyint(4) DEFAULT NULL, `cookie` blob, `post` blob, `get` blob, `pmu` int(11) unsigned DEFAULT NULL, `wt` int(11) unsigned DEFAULT NULL, `cpu` int(11) unsigned DEFAULT NULL, `server_id` char(3) NOT NULL DEFAULT 't11', `aggregateCalls_include` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `url` (`url`), KEY `c_url` (`c_url`), KEY `cpu` (`cpu`), KEY `wt` (`wt`), KEY `pmu` (`pmu`), KEY `timestamp` (`timestamp`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload