502 Error when get models data (ubuntu 14.04,nginx,php-fpm)

Question

502 Error when get models data (ubuntu 14.04,nginx,php-fpm)

Vladislav Turchinskiy Apr '15

Created Apr '15	Last Reply May '15	Replies 7	Views 1288	Votes 2

Vladislav Turchinskiy 3.0k

Apr '15

2015/04/24 20:06:24 [error] 12488#0: *6 recv() failed (104: Connection reset by peer) while reading response header from upstream, client: 127.0.0.1, server: namivam, request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/var/run/php5-fpm.sock:", host: "namivam"

This error throw when i trying execute any model "find" or "findFirst" method. And it is not permanent behavior, 2 times is ok, 2 times is 502 error. How improve it? I tried reinstall php5-fpm, phalcon (from repository and directly,by making of source),disable opcache,xdebug, but it has no effect. On 1.3.4 version i hadn't such problem.

I am using mariaDb instead mysql, maybe it cause problem?

If I can provide any info - let me know. Thanks.

2

tmihalik · Answer 1 · 2015-04-24T04:20:14-07:00

I have exactly the same problem with phalcon2 and postgresql. When pressing F5, 2 requests ok, 2 requests 502. I spent lot of time on this bug and found out that it's somehow related to Dialect (maybe in \Phalcon\Db\Dialect method select or getSqlTable). Whenever I try to extend the built-in dialect class the bug shows up.

$di->setShared('db', function () use ($config) {

    $conn = new Phalcon\Db\Adapter\Pdo\Postgresql([
        'host'     => $config->database->host,
        'username' => $config->database->username,
        'password' => $config->database->password,
        'dbname'   => $config->database->dbname,
    ]);

    $conn->setDialect(new CustomDialect()); // without this line, no error!!

    return $conn;
});

<?php

class CustomDialect extends \Phalcon\Db\Dialect\Postgresql
{
    // no code needed here to demonstrate the bug
}

My config is:

Ubuntu 14.04.2 LTS
Nginx 1.4.7
PHP 5.5.9
Postgresql 9.3.6

Vladislav Turchinskiy · Answer 2 · 2015-04-24T04:34:03-07:00

I dont use any custom dialect

$di -> set('db', function () use ($config) {
    return new DbAdapter(array (
        'host'     => $config -> database -> host,
        'username' => $config -> database -> username,
        'password' => $config -> database -> password,
        'dbname'   => $config -> database -> dbname,
        "charset"  => $config -> database -> charset
    ));
}, true);

tmihalik · Answer 3 · 2015-04-24T05:10:27-07:00

Hmmm, then it's more interesting... I'm trying to trace this bug since weeks with no luck.

One important note:

When I compile Phalcon with cphalcon/ext/install-test this bug disappears.

Vladislav Turchinskiy · Answer 4 · 2015-04-24T05:25:12-07:00

Hmmm, then it's more interesting... I'm trying to trace this bug since weeks with no luck.

One important note:

When I compile Phalcon with cphalcon/ext/install-test this bug disappears.

How can i try it? It is command-line flag?