Call to a member function succeed() on null

[NicklasWallgren]

This error happens fairly often.

$pool = new Pool();

$promises[] = $pool->query('<query>');
$promises[] = $pool->query('<query>');
$promises[] = $pool->query('<query>'));
$promises[] = $pool->query('<query>'));
$promises[] = $pool->query('<query>'));
$promises[] = $pool->query'<query>'));

foreach ($promises as $promise) {
    // Retrieve the result set
    \Amp\wait($promise);
}

#21 {main}  
[2017-05-31 14:00:38] lumen.ERROR: Symfony\Component\Debug\Exception\FatalThrowableError: Call to a member function succeed() on null in /home/vagrant/fras/source/lumen/vendor/amphp/mysql/lib/Processor.php:458
Stack trace:
#0 /home/vagrant/fras/source/lumen/vendor/amphp/mysql/lib/Processor.php(1086): Amp\Mysql\Processor->handleOk('\x00\x00\x00\n\x00\x00\x00')
#1 /home/vagrant/fras/source/lumen/vendor/amphp/mysql/lib/Processor.php(926): Amp\Mysql\Processor->parsePayload('\x00\x00\x00\n\x00\x00\x00')
#2 /home/vagrant/fras/source/lumen/vendor/amphp/amp/lib/NativeReactor.php(265): Amp\Mysql\Processor->onRead('000000003d7266f...', Resource id #511, NULL)
#3 /home/vagrant/fras/source/lumen/vendor/amphp/amp/lib/NativeReactor.php(249): Amp\NativeReactor->doIoCallback('000000003d7266f...', Object(stdClass), Resource id #511)
#4 /home/vagrant/fras/source/lumen/vendor/amphp/amp/lib/NativeReactor.php(214): Amp\NativeReactor->selectActionableStreams(0.5947)
#5 /home/vagrant/fras/source/lumen/vendor/amphp/amp/lib/NativeReactor.php(156): Amp\NativeReactor->doTick(false)

[bwoebi]

Could you please give me the full data transferred?

I.e.: set define("MYSQL_DEBUG", true); so that this will be dumped. The backtrace alone doesn't help me too much here.

[NicklasWallgren]

Sure, I'll post it here tomorrow.

The queries looks something like this;

SET FOREIGN_KEY_CHECKS=0;

INSERT SELECT ...;
``

[NicklasWallgren]

Payload

in: 59 0 0 0 a 35 2e 35 2e 35 2d 31 30 2e 31 2e 31 39 2d 4d 61 72 69 61 44 42 0 dc 22 29 0 52 4a 5a 68 7c 58 21 39 0 ff f7 8 2 0 3f a0 15 0 0 0 0 0 0 0 0 0 0 3a 57 29 65 41 55 66 23 75 4b 52 3b 0 6d 79 73 71 6c 5f 6e 61 74 69 76 65 5f 70 61 73 73 77 6f 72 64 0 len: 89 string(89) "
5.5.5-10.1.19-MariaDB.?").RJZh|X!9.??...??...........:W)eAUf#uKR;.mysql_native_password."
in: 59 0 0 0 a 35 2e 35 2e 35 2d 31 30 2e 31 2e 31 39 2d 4d 61 72 69 61 44 42 0 dd 22 29 0 6e 32 4e 70 69 41 45 75 0 ff f7 8 2 0 3f a0 15 0 0 0 0 0 0 0 0 0 0 42 28 40 48 2a 36 6f 52 2a 77 3d 67 0 6d 79 73 71 6c 5f 6e 61 74 69 76 65 5f 70 61 73 73 77 6f 72 64 0 len: 89 string(89) "
5.5.5-10.1.19-MariaDB.?").n2NpiAEu.??...??...........B(@H*6oR*w=g.mysql_native_password."
in: 59 0 0 0 a 35 2e 35 2e 35 2d 31 30 2e 31 2e 31 39 2d 4d 61 72 69 61 44 42 0 de 22 29 0 6e 36 5f 5b 2c 65 3b 38 0 ff f7 8 2 0 3f a0 15 0 0 0 0 0 0 0 0 0 0 44 2f 5e 69 76 38 50 6c 4d 7d 4e 4d 0 6d 79 73 71 6c 5f 6e 61 74 69 76 65 5f 70 61 73 73 77 6f 72 64 0 len: 89 string(89) "
5.5.5-10.1.19-MariaDB.?").n6_[,e;8.??...??...........D/^iv8PlM}NM.mysql_native_password."
in: 59 0 0 0 a 35 2e 35 2e 35 2d 31 30 2e 31 2e 31 39 2d 4d 61 72 69 61 44 42 0 df 22 29 0 2b 61 27 3f 45 7e 69 75 0 ff f7 8 2 0 3f a0 15 0 0 0 0 0 0 0 0 0 0 2f 2a 23 71 31 3f 29 4c 24 6f 23 5f 0 6d 79 73 71 6c 5f 6e 61 74 69 76 65 5f 70 61 73 73 77 6f 72 64 0 len: 89 string(89) "
5.5.5-10.1.19-MariaDB.?").+a'?E~iu.??...??.........../*#q1?)L$o#_.mysql_native_password."
out: 46 0 0 1 28 a2 27 0 0 0 80 0 2d 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 66 72 61 73 5f 64 65 76 0 14 14 8e d8 f5 9 20 98 ce e4 65 72 59 cc 62 db d8 d4 f7 58 35 46 52 41 44 54 41 44 0 len: 74 string(74) "F...(?'...?.-.......................fras_dev...???	 ???erY?b????X5FRADTAD."
out: 46 0 0 1 28 a2 27 0 0 0 80 0 2d 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 66 72 61 73 5f 64 65 76 0 14 ce 37 12 16 11 87 40 45 fe ca 51 26 c3 19 a1 9c d7 d d2 2a 46 52 41 44 54 41 44 0 len: 74 string(74) "F...(?'...?.-.......................fras_dev..?7...?@E??Q&?.???.?*FRADTAD."
in: 59 0 0 0 a 35 2e 35 2e 35 2d 31 30 2e 31 2e 31 39 2d 4d 61 72 69 61 44 42 0 e0 22 29 0 46 46 6a 63 33 71 61 71 0 ff f7 8 2 0 3f a0 15 0 0 0 0 0 0 0 0 0 0 36 56 2e 23 62 45 72 32 3f 28 46 69 0 6d 79 73 71 6c 5f 6e 61 74 69 76 65 5f 70 61 73 73 77 6f 72 64 0 len: 89 string(89) "
5.5.5-10.1.19-MariaDB.?").FFjc3qaq.??...??...........6V.#bEr2?(Fi.mysql_native_password."
in: 59 0 0 0 a 35 2e 35 2e 35 2d 31 30 2e 31 2e 31 39 2d 4d 61 72 69 61 44 42 0 e1 22 29 0 27 22 6f 2f 38 69 2d 40 0 ff f7 8 2 0 3f a0 15 0 0 0 0 0 0 0 0 0 0 3c 4a 3e 3b 4a 44 55 5e 5a 2a 61 2a 0 6d 79 73 71 6c 5f 6e 61 74 69 76 65 5f 70 61 73 73 77 6f 72 64 0 len: 89 string(89) "
5.5.5-10.1.19-MariaDB.?").'"o/8i-@.??...??...........<J>;JDU^Z*a*.mysql_native_password."
out: 46 0 0 1 28 a2 27 0 0 0 80 0 2d 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 66 72 61 73 5f 64 65 76 0 14 1e c7 4d 33 b8 74 80 e1 47 48 70 9a 49 a1 e7 8 51 b2 c3 2a 46 52 41 44 54 41 44 0 len: 74 string(74) "F...(?'...?.-.......................fras_dev...?M3?t??GHp?I??.Q??*FRADTAD."
out: 46 0 0 1 28 a2 27 0 0 0 80 0 2d 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 66 72 61 73 5f 64 65 76 0 14 fd 25 b0 82 6 ab 5c 40 e9 bf 95 27 42 c5 44 77 85 70 52 a7 46 52 41 44 54 41 44 0 len: 74 string(74) "F...(?'...?.-.......................fras_dev..?%??.?\@鿕'B?Dw?pR?FRADTAD."
in: 7 0 0 2 0 0 0 2 0 0 0 len: 7 string(7) "......."
in: 7 0 0 2 0 0 0 2 0 0 0 len: 7 string(7) "......."
out: 46 0 0 1 28 a2 27 0 0 0 80 0 2d 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 66 72 61 73 5f 64 65 76 0 14 ea 33 d2 ee ca 9 7c f5 3e fc 45 71 7a e6 7e 28 bf 8e f7 a 46 52 41 44 54 41 44 0 len: 74 string(74) "F...(?'...?.-.......................fras_dev..?3???	|?>?Eqz?~(???
FRADTAD."
out: 46 0 0 1 28 a2 27 0 0 0 80 0 2d 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 66 72 61 73 5f 64 65 76 0 14 f7 2e 71 aa 5e e2 13 56 fb 0 c5 8f cf a0 f1 45 6a 25 48 a5 46 52 41 44 54 41 44 0 len: 74 string(74) "F...(?'...?.-.......................fras_dev..?.q?^?.V?.ŏϠ?Ej%H?FRADTAD."
in: 7 0 0 2 0 0 0 2 0 0 0 len: 7 string(7) "......."
in: 7 0 0 2 0 0 0 2 0 0 0 len: 7 string(7) "......."
in: 59 0 0 0 a 35 2e 35 2e 35 2d 31 30 2e 31 2e 31 39 2d 4d 61 72 69 61 44 42 0 e2 22 29 0 4f 55 3c 6a 26 78 4d 56 0 ff f7 8 2 0 3f a0 15 0 0 0 0 0 0 0 0 0 0 4a 4f 2d 34 5d 57 7a 25 42 5d 30 73 0 6d 79 73 71 6c 5f 6e 61 74 69 76 65 5f 70 61 73 73 77 6f 72 64 0 len: 89 string(89) "
5.5.5-10.1.19-MariaDB.?").OU<j&xMV.??...??...........JO-4]Wz%B]0s.mysql_native_password."
out: 8d 4 0 0 3 49 4e 53 45 52 54 20 49 4e 54 4f 20 46 52 43 41 54 45 47 4f 52 59 41 4d 4f 55 4e 54 43 41 43 48 45 28 53 45 4e 44 45 52 49 44 2c 20 44 49 53 54 52 49 44 2c 20 46 49 4c 45 49 44 2c 20 52 45 50 4f 52 54 4b 45 59 2c 20 54 59 50 45 2c 20 52 45 50 4f 52 54 53 54 41 54 55 53 2c 20 41 4d 4f 55 4e 54 29 a 53 45 4c 45 43 54 20 53 45 4e 44 45 52 49 44 2c 20 44 49 53 54 52 49 44 2c 20 46 49 4c 45 49 44 2c 20 52 45 50 4f 52 54 4b 45 59 2c 20 27 31 27 2c 20 52 45 50 53 54 41 54 55 53 2c 20 41 4d 4f 55 4e 54 20 46 52 4f 4d a 28 a 9 53 45 4c 45 43 54 a 9 46 52 44 49 53 2e 53 45 4e 44 45 len: 1169 string(200) "?....INSERT INTO FRCATEGORYAMOUNTCACHE(SENDERID, DISTRID, FILEID, REPORTKEY, TYPE, REPORTSTATUS, AMOUNT)
SELECT SENDERID, DISTRID, FILEID, REPORTKEY, '1', REPSTATUS, AMOUNT FROM
(
	SELECT
	FRDIS.SENDE"
out: c8 3 0 0 3 53 45 54 20 66 6f 72 65 69 67 6e 5f 6b 65 79 5f 63 68 65 63 6b 73 20 3d 20 30 3b a a 49 4e 53 45 52 54 20 49 4e 54 4f 20 46 52 43 41 54 45 47 4f 52 59 41 4d 4f 55 4e 54 43 41 43 48 45 28 53 45 4e 44 45 52 49 44 2c 20 44 49 53 54 52 49 44 2c 20 46 49 4c 45 49 44 2c 20 52 45 50 4f 52 54 4b 45 59 2c 20 54 59 50 45 2c 20 52 45 50 4f 52 54 53 54 41 54 55 53 2c 20 41 4d 4f 55 4e 54 29 a 53 45 4c 45 43 54 20 53 45 4e 44 45 52 49 44 2c 20 44 49 53 54 52 49 44 2c 20 46 49 4c 45 49 44 2c 20 30 2c 20 27 30 31 27 2c 20 27 30 27 2c 20 41 4d 4f 55 4e 54 20 46 52 4f 4d a 28 a 9 53 45 4c len: 972 string(200) "?....SET foreign_key_checks = 0;

INSERT INTO FRCATEGORYAMOUNTCACHE(SENDERID, DISTRID, FILEID, REPORTKEY, TYPE, REPORTSTATUS, AMOUNT)
SELECT SENDERID, DISTRID, FILEID, 0, '01', '0', AMOUNT FROM
(
	SEL"
in: 7 0 0 2 0 0 0 2 0 0 0 len: 7 string(7) "......."
in: 7 0 0 2 0 0 0 2 0 0 0 len: 7 string(7) "......."
out: f6 6 0 0 3 53 45 54 20 66 6f 72 65 69 67 6e 5f 6b 65 79 5f 63 68 65 63 6b 73 20 3d 20 30 3b a a 49 4e 53 45 52 54 20 49 4e 54 4f 20 46 52 43 41 54 45 47 4f 52 59 41 4d 4f 55 4e 54 43 41 43 48 45 28 53 45 4e 44 45 52 49 44 2c 20 44 49 53 54 52 49 44 2c 20 46 49 4c 45 49 44 2c 20 52 45 50 4f 52 54 4b 45 59 2c 20 54 59 50 45 2c 20 52 45 50 4f 52 54 53 54 41 54 55 53 2c 20 41 4d 4f 55 4e 54 29 a 53 45 4c 45 43 54 20 53 45 4e 44 45 52 49 44 2c 20 44 49 53 54 52 49 44 2c 20 46 49 4c 45 49 44 2c 20 52 45 50 4f 52 54 4b 45 59 2c 52 45 50 53 54 41 54 55 53 2c 20 52 45 50 4f 52 54 54 59 50 45 2c len: 1786 string(200) "?....SET foreign_key_checks = 0;

INSERT INTO FRCATEGORYAMOUNTCACHE(SENDERID, DISTRID, FILEID, REPORTKEY, TYPE, REPORTSTATUS, AMOUNT)
SELECT SENDERID, DISTRID, FILEID, REPORTKEY,REPSTATUS, REPORTTYPE,"
out: 46 0 0 1 28 a2 27 0 0 0 80 0 2d 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 66 72 61 73 5f 64 65 76 0 14 3d fe 35 6a 6e 81 db b3 4d cd 9c 73 82 43 54 a6 52 98 b7 a8 46 52 41 44 54 41 44 0 len: 74 string(74) "F...(?'...?.-.......................fras_dev..=?5jn?۳M͜s?CT?R???FRADTAD."
in: 7 0 0 1 0 0 0 a 0 0 0 len: 7 string(7) "...
..."
in: 7 0 0 1 0 0 0 a 0 0 0 len: 7 string(7) "...
..."
in: 7 0 0 2 0 0 0 2 0 0 0 len: 7 string(7) "......."
in: 2f 0 0 2 0 0 0 22 8 0 0 27 52 65 63 6f 72 64 73 3a 20 32 34 20 20 44 75 70 6c 69 63 61 74 65 73 3a 20 30 20 20 57 61 72 6e 69 6e 67 73 3a 20 30 len: 47 string(47) "..."...'Records: 24  Duplicates: 0  Warnings: 0"

                                                           
  [Symfony\Component\Debug\Exception\FatalThrowableError]  
  Call to a member function succeed() on null              

[NicklasWallgren]

Do you need any additional information?

[bwoebi]

Ah, seems like we're not handling multiple results if one subquery has been replied without resultset, but only with an OK-packet.

Will fix that, thanks a lot for reporting :-)

[NicklasWallgren]

Perfect, thanks.

[bwoebi]

Uh … the patch was nearly ready, but I just had forgotten about this :-( Fixed now.

[marcioAlmada]

Great work! I've been testing with mysql 8.0 and 5.7 and the annoying warning is gone. @bwoebi could we have a tag release?

[bwoebi]

@marcioAlmada tagged :-)