Bug #1211 replication commands in embedded mysql
Submitted: 6 Sep 2003 1:52 Modified: 8 Sep 2003 2:30
Reporter: Georg Richter Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Embedded Library ( libmysqld ) Severity:S1 (Critical)
Version:4.0.15 OS:Linux (Linux)
Assigned to: Alexey Botchkov CPU Architecture:Any

[6 Sep 2003 1:52] Georg Richter
Description:
Replication commands should not be supported in embedded mysql

SHOW SLAVE STATUS
segfault

SHOW MASTER STATUS
 ok, but all queries behind will fail with Commands out of sync;  You can't run this command now

LOAD DATA FROM MASTER
segfault
 

How to repeat:
commands.sql
SHOW SLAVE STATUS
SHOW MASTER STATUS
LOAD DATA FROM MASTER

/* {{{ test_commands ()
   reads and executes various commands from commands.sql */
int test_commands()  {
	FILE	*fp;
	char	query[1000];
	int		rc;

	if (!(fp = fopen("commands.sql", "r"))) {
		printf ("can't open commands.sql");
		return 1;
	}

	while (!feof(fp)) {
		if (fgets((char *)&query, 1000, fp)) {
			printf ("\t%s", query);
			if ((rc = mysql_query(mysql, query))) { 
				printf ("\tfailed (%s)\n", mysql_error(mysql));
			}
			else
				printf ("\tpassed\n");
		}
	}
	fclose(fp);
}
/* }}} */
[6 Sep 2003 1:55] Georg Richter
only affects 4.0.15, not 4.1
[8 Sep 2003 2:30] Alexey Botchkov
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

changeset 1.1559