PHP Decode

--TEST--
trx_stickiness=master, failover, roundrobin
--SKIPIF--
<?php
if (version_compare(PHP_VERSION, '5.3.99-dev', '<'))
	die(sprintf("SKIP Requires PHP 5.3.99 or newer, using " . PHP_VERSION));

require_once('skipif.inc');
require_once("connect.inc");

_skipif_check_extensions(array("mysqli"));
_skipif_connect($master_host_only, $user, $passwd, $db, $master_port, $master_socket);
_skipif_connect($slave_host_only, $user, $passwd, $db, $slave_port, $slave_socket);

$settings = array(
	"myapp" => array(
		'master' => array($master_host, "realyunknownrealy:6033"),
		'slave' => array($slave_host),
		'trx_stickiness' => 'master',
		'pick' => array("roundrobin"),
		'lazy_connections' => 1,
		'failover' => array('strategy' => 'loop_before_master', 'remember_failed' => 1),
	),
);
if ($error = mst_create_config("test_mysqlnd_ms_trx_stickiness_master_failover_rr.ini", $settings))
	die(sprintf("SKIP %s\n", $error));

?>
--INI--
mysqlnd_ms.enable=1
mysqlnd_ms.multi_master=1
mysqlnd_ms.config_file=test_mysqlnd_ms_trx_stickiness_master_failover_rr.ini
--FILE--
<?php
	require_once("connect.inc");
	require_once("util.inc");

	if (!($link = mst_mysqli_connect("myapp", $user, $passwd, $db, $port, $socket)))
		printf("[001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());

	mst_mysqli_query(2, $link, "SET @myrole='slave'", MYSQLND_MS_SLAVE_SWITCH);

	/* trying to hit the unavailable master */
	$i = 0;

	do {
		$last = NULL;
		$link->autocommit(FALSE);
		/*
         This is the first query in the transaction,
         failover may be done to find an initial connection.
		 Once we have a connection, it must not change, ever!
		*/
		$res = $link->query("SELECT CONNECTION_ID() AS _master_role");
		if (0 != $link->errno) {
			printf("[003] [%d] '%s'\n", $link->errno, $link->error);
			break;
		}
		$row = $res->fetch_assoc();
		$last = $row['_master_role'];

		$res = $link->query("SELECT CONNECTION_ID() AS _master_role");
		if (0 != $link->errno) {
			printf("[004] [%d] '%s'\n", $link->errno, $link->error);
			break;
		}
		$row = $res->fetch_assoc();
		if ($last != $row['_master_role']) {
			printf("[005] Server switched in the middle of a transaction!\n");
			break;
		}
		$link->autocommit(TRUE);

	} while ((++$i < 50) && ($res) &&  (0 == $link->errno));
	printf("[006] %d - [%d] '%s'\n", $i, $link->errno, $link->error);

	/* this is a MUST to break out of "in_trx = 1 => use last_used" */
	$link->autocommit(TRUE);
	$link->autocommit(FALSE);

	/* in_trx = 1, remember_failed skips failed master */
	for ($i = 0; $i < 10; $i++) {
		$res = $link->query("SELECT CONCAT(@myrole, ' ', CONNECTION_ID()) AS _role");
		if (!$res) {
			printf("[075] [%d] '%s'\n", $link->errno, $link->error);
			break;
		}
	}
	print "done!";
?>
--CLEAN--
<?php
	if (!unlink("test_mysqlnd_ms_trx_stickiness_master_failover_rr.ini"))
	  printf("[clean] Cannot unlink ini file 'test_mysqlnd_ms_trx_stickiness_master_failover_rr.ini'.\n");
?>
--EXPECTF--

Warning: mysqli::query(): php_network_getaddresses: getaddrinfo %s
[006] 50 - [0] ''
done!