Create an account

Very important

  • To access the important data of the forums, you must be active in each forum and especially in the leaks and database leaks section, send data and after sending the data and activity, data and important content will be opened and visible for you.
  • You will only see chat messages from people who are at or below your level.
  • More than 500,000 database leaks and millions of account leaks are waiting for you, so access and view with more activity.
  • Many important data are inactive and inaccessible for you, so open them with activity. (This will be done automatically)


Thread Rating:
  • 328 Vote(s) - 3.5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How To Troubleshoot "FastCGI: incomplete headers (0 bytes) received from server" error

#1
I keep receiving the following error:

Wed Mar 30 01:22:43.780576 2016] [fastcgi:error] [pid 12345:tid 1234567890] [client 123.459.78.123:12345] FastCGI: incomplete headers (0 bytes) received from server "/path/to/php5-fcgi", referer:

[To see links please register here]


Which only occurs when i visit a specific page (controllers). What confuses me even more, this error appears to be in random. Meaning that sometime i can access the page just fine, other times i keep getting that error.

The page i am talking about is the backoffice of Prestashop 1.5.4, specifically the order page (Backoffice > Orders > Order).

That page does send a query to MySQL (how ever it took less than a sec). Here's the full query (debugged):

SELECT SQL_CALC_FOUND_ROWS
a.`id_order`,`reference`,`total_paid_tax_incl`,`payment`,a.date_add as date_add,
a.id_currency,
a.id_order AS id_pdf,
CONCAT(LEFT(c.`firstname`, 1), '. ', c.`lastname`) AS `customer`,
osl.`name` AS `osname`,
os.`color`,
IF((SELECT COUNT(so.id_order) FROM `ps_orders` so WHERE so.id_customer = a.id_customer) > 1, 0, 1) as new
FROM `ps_orders` a
LEFT JOIN `ps_customer` c ON (c.`id_customer` = a.`id_customer`)
LEFT JOIN `ps_order_state` os ON (os.`id_order_state` = a.`current_state`)
LEFT JOIN `ps_order_state_lang` osl ON (os.`id_order_state` = osl.`id_order_state` AND osl.`id_lang` = 1)
WHERE 1
ORDER BY a.id_order DESC LIMIT 0,50;

My biggest suspicious is that there is something wrong with the query, because when i ran that query using MySQL Workbench, the initial run took about 2 secs. When i ran the query again (immediately after the first one) it took ~0.059 (could be cache).

Can anyone help me with this?

I am using Ubuntu 14.04
PHP 5.5.9
Apache 2.4.7 (with PHP5-FPM)

** EDIT **

When i ran:

sudo tail -f /var/log/upstart/php5-fpm.log

This is what i get:

[04-Apr-2016 10:55:54] WARNING: [pool www] child 37686 exited on signal 11 (SIGSEGV - core dumped) after 111.726966 seconds from start
[04-Apr-2016 10:55:54] NOTICE: [pool www] child 38128 started
[04-Apr-2016 10:55:54] WARNING: [pool www] child 37774 exited on signal 11 (SIGSEGV - core dumped) after 81.831809 seconds from start
[04-Apr-2016 10:55:54] NOTICE: [pool www] child 38129 started
[04-Apr-2016 10:55:54] WARNING: [pool www] child 37798 exited on signal 11 (SIGSEGV - core dumped) after 76.299913 seconds from start
[04-Apr-2016 10:55:54] NOTICE: [pool www] child 38130 started
[04-Apr-2016 10:55:54] WARNING: [pool www] child 37768 exited on signal 11 (SIGSEGV - core dumped) after 83.162501 seconds from start
[04-Apr-2016 10:55:54] NOTICE: [pool www] child 38131 started
[04-Apr-2016 10:55:57] WARNING: [pool www] child 37859 exited on signal 11 (SIGSEGV - core dumped) after 65.427848 seconds from start
[04-Apr-2016 10:55:57] NOTICE: [pool www] child 38133 started

There is now new warning/notice/error that show up when i execute the problematic page.


** EDIT 2 **
I think i narrow down the problem after turning on slow_log on my fpm config. This is what i get:

script_filename = /path/to/some/script.php
[0x00007f55bb18afd8] query() /path/to/some/script/DbPDO.php:80
[0x00007f55bb18aef8] _query() /path/to/some/script/Db.php:305
[0x00007f55bb18ad88] query() /path/to/some/script/Db.php:482
[0x00007f55bb18ab68] executeS() /path/to/some/script/AdminController.php:2198
[0x00007f55bb18a9e8] getList() /path/to/some/script/AdminController.php:1531
[0x00007f55bb18a8d0] renderList() /path/to/some/script/AdminController.php:1440
[0x00007f55bb18a788] initContent() /path/to/some/script/Controller.php:167
[0x00007f55bb18a5d0] run() /path/to/some/script/Dispatcher.php:349
[0x00007f55bb18a480] dispatch() /path/to/some/script/index.php:50


More best guess would be because of this function :

[0x00007f55bb18ab68] executeS() /path/to/some/script/AdminController.php:2198

Where it basically send a query i mentioned earlier. Changing this would mean i have to change the core engine of Prestashop. I do not wish to do that, since it may have some dependencies to other functions/modules.

I wonder if there is a way where i can slightly increase the timeout on my php-fpm or Apache. I know such solution exist, i just don't know where to look/begin.
Reply



Forum Jump:


Users browsing this thread:
1 Guest(s)

©0Day  2016 - 2023 | All Rights Reserved.  Made with    for the community. Connected through