TarantoolException: request sync is not equal response sync #104

baltazorbest · 2016-09-07T19:30:04Z

When I try execute upsert method with big array, I have error:

PHP Fatal error:  Uncaught TarantoolException: request sync is not equal response sync. closing connection in /home/username/test.php:28`
Stack trace:
#0 /home/username/test.php(28): Tarantool->upsert('testing', Array, Array)
#1 {main}
  thrown in /home/username/test.php on line 28"

OS: centos 6.8 x86_64
PHP: 7.0.8
Tarantool: 1.7.1.123-1.el6.x86_64

PHP script:

$tnt = new Tarantool('127.0.0.1:3302');
$tnt->connect();
$space = "testing";
$key = "key_1";
$data = array(
    "id"=> 10224539,
    "category_id" => 176,
    "ccategory_id" => 176,
    "testmode" => 2,
    "fulldays" => 30,
    "lifetime" => 12324,
    "uid" => 2397,
    "userid" => 21176,
    "tags_cl_id" => 3499,
    "pricecost" => "10",
);
$tnt->upsert($space, array($key, $data), array(array("field" => 1,"op" => "=","arg" => $data)));

testing.lua box:

box.cfg {
    wal_dir="/home/username/testing/wal";
    snap_dir="/home/username/testing/snap";
    vinyl_dir="/home/username/testing/vinyl";
    listen = 3302;
    custom_proc_title = 'testing';
    slab_alloc_arena = 1.5;
    slab_alloc_minimal = 16;
    slab_alloc_maximal = 10485760;
    slab_alloc_factor = 1.06;
    snapshot_period = 300;
    snapshot_count = 10;
    panic_on_snap_error = true;
    panic_on_wal_error = true;
    rows_per_wal = 5000000;
    snap_io_rate_limit = nil;
    wal_mode = "write";
    wal_dir_rescan_delay = 2.0;
    io_collect_interval = nil;
    readahead = 16320;
    log_level = 5;
    logger_nonblock = true;
    too_long_threshold = 0.5;
}

local function bootstrap()
    local space = box.schema.create_space('testing', {id=1024})
    space:create_index('primary', {type = 'hash', parts = {1, 'STR'}})
    box.schema.user.grant('guest', 'read,write,execute', 'universe')
end

box.once('testing-1.0', bootstrap)

The text was updated successfully, but these errors were encountered:

bigbes · 2016-09-12T13:23:16Z

Are you sure, that this bug is still in php7-v2? I can't reproduce it.

bigbes · 2016-09-22T16:20:04Z

Any update on this?

cebeh · 2016-11-23T12:06:56Z

PHP 7.0.8-0ubuntu0.16.04.3
tarantool: 1.7.2-263-g1f3f7ac
tarantool-php: 0.2.0

still reproduce

tt.php code

<?php
$tnt = new Tarantool('127.0.0.1:3302');
$tnt->connect();
$space = "attr";
$rows = [
    1   => [
        'traffic' =>
            [
                581 => 1,
                633 => 1,
                820 => 1,
            ],
    ],
    666 => [
        'traffic' => [
            405 => 36,
            563 => 34,
            565 => 28,
            581 => 23,
            631 => 25,
            633 => 35,
            669 => 19,
            671 => 18,
            674 => 26,
            676 => 28,
            718 => 14,
            752 => 1,
            754 => 1,
            756 => 1,
            796 => 22,
            800 => 22,
            808 => 19,
            810 => 17,
            814 => 14,
            820 => 7,
            830 => 13,
            838 => 15,
            842 => 15,
            846 => 9,
            848 => 9,
            850 => 7,
            858 => 11,
            876 => 1,
            878 => 2,
            880 => 1,
        ],
    ],

];
foreach ($rows as $key => $data) {
    echo 'upsert key: ' . $key . PHP_EOL;
    $tnt->upsert($space, [$key, $data], [["field" => 1, "op" => "=", "arg" => $data]]);
}

seven@shelby:~$ php tt.php 
upsert key: 1
upsert key: 666
PHP Fatal error:  Uncaught TarantoolException: request sync is not equal response sync. closing connection in /home/seven/tt.php:52
Stack trace:
#0 /home/seven/tt.php(52): Tarantool->upsert('attr', Array, Array)
#1 {main}
  thrown in /home/seven/tt.php on line 52

box.space.attr

---
- index:
    0: &0
      unique: true
      parts:
      - type: unsigned
        fieldno: 1
      id: 0
      space_id: 520
      name: primary
      type: TREE
    primary: *0
  on_replace: 'function: 0x41466680'
  temporary: false
  id: 520
  engine: vinyl
  enabled: true
  name: attr
  field_count: 0
...

bigbes · 2016-11-23T12:39:34Z

Hello, Dmitriy.

Well, that (usually) means that previous request has been timedout. You
haven't observed anything? Are you using Vinyl?

With best regards, Eugene.

2016-11-23 15:06 GMT+03:00 Dmitriy Protasov [email protected]:

PHP 7.0.8-0ubuntu0.16.04.3
tarantool: 1.7.2-263-g1f3f7ac
tarantool-php: 0.2.0

still reproduce

tt.php code
connect();$space = "attr";$rows = [ 1 => [ 'traffic' => [ 581 => 1, 633 => 1, 820 => 1, ], ], 666 => [ 'traffic' => [ 405 => 36, 563 => 34, 565 => 28, 581 => 23, 631 => 25, 633 => 35, 669 => 19, 671 => 18, 674 => 26, 676 => 28, 718 => 14, 752 => 1, 754 => 1, 756 => 1, 796 => 22, 800 => 22, 808 => 19, 810 => 17, 814 => 14, 820 => 7, 830 => 13, 838 => 15, 842 => 15, 846 => 9, 848 => 9, 850 => 7, 858 => 11, 876 => 1, 878 => 2, 880 => 1, ], ],];foreach ($rows as $key => $data) { echo 'upsert key: ' . $key . PHP_EOL; $tnt->upsert($space, [$key, $data], [["field" => 1, "op" => "=", "arg" => $data]]);} seven@shelby:~$ php tt.php upsert key: 1 upsert key: 666 PHP Fatal error: Uncaught TarantoolException: request sync is not equal response sync. closing connection in /home/seven/tt.php:52 Stack trace:#0 /home/seven/tt.php(52): Tarantool->upsert('attr', Array, Array)#1 {main} thrown in /home/seven/tt.php on line 52 — You are receiving this because you were assigned. Reply to this email directly, view it on GitHub https://github.com//issues/104#issuecomment-262496798, or mute the thread https://github.com/notifications/unsubscribe-auth/AAeQFLxz8Qmfnv7wOqjRykm52aTcImCVks5rBCxggaJpZM4J3RR5 .

bigbes · 2016-11-23T12:40:39Z

I need full test-case, if you can provide it (with Tarantool configuration
file).

With best regards, Eugene.

2016-11-23 15:39 GMT+03:00 Eugine Blikh [email protected]:

Hello, Dmitriy.

Well, that (usually) means that previous request has been timedout. You
haven't observed anything? Are you using Vinyl?

With best regards, Eugene.

2016-11-23 15:06 GMT+03:00 Dmitriy Protasov [email protected]:

PHP 7.0.8-0ubuntu0.16.04.3
tarantool: 1.7.2-263-g1f3f7ac
tarantool-php: 0.2.0

still reproduce

tt.php code
connect();$space = "attr";$rows = [ 1 => [ 'traffic' => [ 581 => 1, 633 => 1, 820 => 1, ], ], 666 => [ 'traffic' => [ 405 => 36, 563 => 34, 565 => 28, 581 => 23, 631 => 25, 633 => 35, 669 => 19, 671 => 18, 674 => 26, 676 => 28, 718 => 14, 752 => 1, 754 => 1, 756 => 1, 796 => 22, 800 => 22, 808 => 19, 810 => 17, 814 => 14, 820 => 7, 830 => 13, 838 => 15, 842 => 15, 846 => 9, 848 => 9, 850 => 7, 858 => 11, 876 => 1, 878 => 2, 880 => 1, ], ],];foreach ($rows as $key => $data) { echo 'upsert key: ' . $key . PHP_EOL; $tnt->upsert($space, [$key, $data], [["field" => 1, "op" => "=", "arg" => $data]]);} seven@shelby:~$ php tt.php upsert key: 1 upsert key: 666 PHP Fatal error: Uncaught TarantoolException: request sync is not equal response sync. closing connection in /home/seven/tt.php:52 Stack trace:#0 /home/seven/tt.php(52): Tarantool->upsert('attr', Array, Array)#1 {main} thrown in /home/seven/tt.php on line 52 — You are receiving this because you were assigned. Reply to this email directly, view it on GitHub https://github.com//issues/104#issuecomment-262496798, or mute the thread https://github.com/notifications/unsubscribe-auth/AAeQFLxz8Qmfnv7wOqjRykm52aTcImCVks5rBCxggaJpZM4J3RR5 .

cebeh · 2016-11-23T14:27:54Z

Found case how to reproduce exception:

create guest user without password
connect without authentication
execute upsert with big array

When using authentication there is no exception

test/shared/box.lua

@@ -18,6 +18,7 @@ box.cfg{
 }
 
 box.once('initialization', function()
+    box.schema.user.grant('guest', 'read,write,execute', 'universe')
     box.schema.user.create('test', { password = 'test' })
     box.schema.user.create('test_empty', { password = '' })
     box.schema.user.create('test_big', {

test/AuthMsgPackTest.php

<?php

class AuthMsgPackTest extends PHPUnit_Framework_TestCase
{
    protected static $tarantool;

    protected static $data = [
        'small'   => [
            1 => 2,
            2 => 3,
        ],
        'big' => [
            405 => 36,
            563 => 34,
            565 => 28,
            581 => 23,
            631 => 25,
            633 => 35,
            669 => 19,
            671 => 18,
            674 => 26,
            676 => 28,
            718 => 14,
            752 => 1,
            754 => 1,
            756 => 1,
            796 => 22,
            800 => 22,
            808 => 19,
            810 => 17,
            814 => 14,
            820 => 7,
            830 => 13,
            838 => 15,
            842 => 15,
            846 => 9,
            848 => 9,
            850 => 7,
            858 => 11,
            876 => 1,
            878 => 2,
            880 => 1,
        ],
    ];

    public function test_01_guest_user_msgpack()
    {
        self::$tarantool = new Tarantool('localhost', getenv('PRIMARY_PORT'));
        self::$tarantool->ping();

        self::$tarantool->upsert("msgpack", [7, "insert big array with sub arrays", self::$data], [[
            'field' => 2,
            'op'    => '=',
            'arg'   => self::$data,
        ]]);
        $resp = self::$tarantool->select("msgpack", [7]);
        $this->assertEquals(count($resp[0][2]['big']), 30);
        $this->assertTrue(True);
    }

    public function test_02_authorized_user_msgpack()
    {
        self::$tarantool = new Tarantool('localhost', getenv('PRIMARY_PORT'));
        self::$tarantool->authenticate('test', 'test');

        self::$tarantool->upsert("msgpack", [7, "insert big array with sub arrays", self::$data], [[
            'field' => 2,
            'op'    => '=',
            'arg'   => self::$data,
        ]]);
        $resp = self::$tarantool->select("msgpack", [7]);
        $this->assertEquals(count($resp[0][2]['big']), 30);
        $this->assertTrue(True);
    }
}

bigbes · 2016-11-23T15:25:37Z

Thank you, Dmitry! I'll try it tomorrow.

With best regards, Eugene.

2016-11-23 17:27 GMT+03:00 Dmitriy Protasov [email protected]:

Found case how to reproduce exception:

create guest user without password

connect without authentication

execute upsert with big array

When using authentication there is no exception

test/shared/box.lua
https://github.com/tarantool/tarantool-php/edit/php7-v2/test/shared/box.lua

@@ -18,6 +18,7 @@ box.cfg{
}

box.once('initialization', function()+ box.schema.user.grant('guest', 'read,write,execute', 'universe')
box.schema.user.create('test', { password = 'test' })
box.schema.user.create('test_empty', { password = '' })
box.schema.user.create('test_big', {

test/AuthMsgPackTest.php
[ 1 => 2, 2 => 3, ], 'big' => [ 405 => 36, 563 => 34, 565 => 28, 581 => 23, 631 => 25, 633 => 35, 669 => 19, 671 => 18, 674 => 26, 676 => 28, 718 => 14, 752 => 1, 754 => 1, 756 => 1, 796 => 22, 800 => 22, 808 => 19, 810 => 17, 814 => 14, 820 => 7, 830 => 13, 838 => 15, 842 => 15, 846 => 9, 848 => 9, 850 => 7, 858 => 11, 876 => 1, 878 => 2, 880 => 1, ], ]; public function test_01_guest_user_msgpack() { self::$tarantool = new Tarantool('localhost', getenv('PRIMARY_PORT')); self::$tarantool->ping(); self::$tarantool->upsert("msgpack", [7, "insert big array with sub arrays", self::$data], [[ 'field' => 2, 'op' => '=', 'arg' => self::$data, ]]); $resp = self::$tarantool->select("msgpack", [7]); $this->assertEquals(count($resp[0][2]['big']), 30); $this->assertTrue(True); } public function test_02_authorized_user_msgpack() { self::$tarantool = new Tarantool('localhost', getenv('PRIMARY_PORT')); self::$tarantool->authenticate('test', 'test'); self::$tarantool->upsert("msgpack", [7, "insert big array with sub arrays", self::$data], [[ 'field' => 2, 'op' => '=', 'arg' => self::$data, ]]); $resp = self::$tarantool->select("msgpack", [7]); $this->assertEquals(count($resp[0][2]['big']), 30); $this->assertTrue(True); }} — You are receiving this because you were assigned. Reply to this email directly, view it on GitHub https://github.com//issues/104#issuecomment-262526412, or mute the thread https://github.com/notifications/unsubscribe-auth/AAeQFHJHHwTfNJd1vsf6IaZzfvGkHc6Xks5rBE1rgaJpZM4J3RR5 .

kvspb · 2017-09-03T18:51:04Z

up

AKEB · 2018-02-21T11:51:43Z

2018-02-20 18:34:24.456 [36943] iproto xrow.c:59 E> ER_INVALID_MSGPACK: Invalid MsgPack - packet header
2018-02-20 18:34:24.462 [36943] iproto iproto.cc:744 E> ER_INVALID_MSGPACK: Invalid MsgPack - packet length

bigbes added bug Something isn't working in progress php7 labels Sep 8, 2016

bigbes self-assigned this Sep 8, 2016

bigbes added this to the 0.2.0 milestone Sep 8, 2016

bigbes added need feedback and removed in progress labels Sep 22, 2016

alg1973 self-assigned this Apr 18, 2018

alg1973 closed this as completed Apr 18, 2018

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

TarantoolException: request sync is not equal response sync #104

TarantoolException: request sync is not equal response sync #104

baltazorbest commented Sep 7, 2016 •

edited

Loading

bigbes commented Sep 12, 2016 •

edited

Loading

bigbes commented Sep 22, 2016

cebeh commented Nov 23, 2016 •

edited

Loading

bigbes commented Nov 23, 2016

bigbes commented Nov 23, 2016

cebeh commented Nov 23, 2016

bigbes commented Nov 23, 2016

kvspb commented Sep 3, 2017

AKEB commented Feb 21, 2018

TarantoolException: request sync is not equal response sync #104

TarantoolException: request sync is not equal response sync #104

Comments

baltazorbest commented Sep 7, 2016 • edited Loading

bigbes commented Sep 12, 2016 • edited Loading

bigbes commented Sep 22, 2016

cebeh commented Nov 23, 2016 • edited Loading

bigbes commented Nov 23, 2016

bigbes commented Nov 23, 2016

cebeh commented Nov 23, 2016

bigbes commented Nov 23, 2016

kvspb commented Sep 3, 2017

AKEB commented Feb 21, 2018

baltazorbest commented Sep 7, 2016 •

edited

Loading

bigbes commented Sep 12, 2016 •

edited

Loading

cebeh commented Nov 23, 2016 •

edited

Loading