Bug #32355 loadxml.test fails in embedded server
Submitted: 14 Nov 2007 9:08 Modified: 30 Nov 2007 1:26
Reporter: Ingo Strüwing Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Server Severity:S7 (Test Cases)
Version:6.0.4 OS:Any
Assigned to: Ingo Strüwing CPU Architecture:Any
Tags: pbfail

[14 Nov 2007 9:08] Ingo Strüwing 
Description:
This is critical as it breaks the test suite.

main.loadxml                   [ fail ]

mysqltest: At line 26: command "$MYSQL_DUMP --xml test t1 > "$MYSQLTEST_VARDIR/loadxml-dump.xml" 2>&1" failed

The result from queries just before the failure was:
< snip >
select * from t1 order by a;
a	b
1	b1
2	b2
3	b3
11	b11
111	b111
112	b112 & < > " ' &unknown; -- check entities
212	b212
delete from t1;
-- Load a static XML file with 'IGNORE num ROWS'
load xml infile '../std_data_ln/loadxml.dat' into table t1
rows identified by '<row>' ignore 4 rows;
select * from t1 order by a;
a	b
111	b111
112	b112 & < > " ' &unknown; -- check entities
212	b212
-- Check 'mysqldump --xml' + 'LOAD XML' round trip
exec of '/data0/pushbuild/pb1/pb/mysql-6.0/29/mysql-6.0.4-alpha-pb29/client/mysqldump --no-defaults -uroot --debug-check --port=11020 --socket=/dev/shm/pbtmp-embedded-102/master.sock --password= --xml test t1 > "/dev/shm/var-embedded-102/loadxml-dump.xml" 2>&1' failed, error: 512, status: 2, errno: 22

More results from queries before failure can be found in /dev/shm/var-embedded-102/log/loadxml.log

How to repeat:
See https://intranet.mysql.com/secure/pushbuild/showdir.pl?dir=mysql-6.0
'debx86-b' tests with embedded server.
[14 Nov 2007 20:12] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/37779

ChangeSet@1.2665, 2007-11-14 21:11:50+01:00, istruewing@stella.local +1 -0
  Bug#32355 - loadxml.test fails in embedded server
  
  Test case failed because the mysql dump tool tried to connect
  to the server. But an embedded server does not provide a
  connect port.
  
  Disabled test case for embedded server.
[15 Nov 2007 13:55] Mattias Jonsson 
OK to push. mysqldump is not a part of embedded, ok to disable the test for embedded.
[15 Nov 2007 14:01] Sergey Vojtovich 
Ok to push.
[15 Nov 2007 15:03] Ingo Strüwing 
Queued to 6.0-engines.
[28 Nov 2007 10:24] Bugs System 
Pushed into 6.0.4-alpha
[30 Nov 2007 1:26] Paul DuBois 
Test case change. No changelog entry needed.