MySQL Bugs: #83979: mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'

Bug #83979	mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
Submitted:	28 Nov 2016 2:13	Modified:	28 Dec 2016 19:20
Reporter:	David van Laatum	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S3 (Non-critical)
Version:	5.6.16	OS:	CentOS (6)
Assigned to:		CPU Architecture:	Any

Description:
I am guessing this is a concurrency thing. But when running mysqlslap against mysql running on a Gemalto encrypted filesystem with concurrency of 100 it complains
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
yet the schema is there. Turning up logging level shows that some connections connect but others fail. It worked prior to the encryption. We are unsure if this affects the results or how much.

time mysqlslap --host=bdvlin01-valex-ro-sql --user=mysqlslap --password=mysqlslap --auto-generate-sql --verbose --concurrency=100 -vv
Warning: Using a password on the command line interface can be insecure.
Building Create Statements for Auto
Building Query Statements for Auto
Parsing engines to use.
Starting Concurrency Test
DROP SCHEMA IF EXISTS `mysqlslap`;
Loading Pre-data
CREATE SCHEMA `mysqlslap`;
CREATE SCHEMA `mysqlslap`;
CREATE TABLE `t1` (intcol1 INT(32) ,charcol1 VARCHAR(128));
...
Generating primary key list
connected!
...
connected!
...
SELECT intcol1,charcol1 FROM t1;
INSERT INTO t1 VALUES (73673339,'BN3152Gza4GW7atxJKACYwJqDbFynLxqc0kh30YTwgz3FktQ43XTrqJ4PQ25frn7kXhfXD8RuzN1j8Rf3y8ugKy6es3IbqPJM6ylCyD6xS7YcQCfHKZxYNvB7yTahm');
INSERT INTO t1 VALUES (1759592334,'3lkoxjtvgLu5xKHSTTtJuGE5F5QqmCcppCTmvFZScRZQgim93gSxwb24gKmIPEzEQStMjQiCu7WapGbkw4ilXch3xRLMhKSzgLDOovSi2qGj6rKvnuYAWDDJgaZDu2');
INSERT INTO t1 VALUES (95275444,'bNIrBDBl81tjzdvuOpQRCXgX37xGtzLKEXBIcE3k7xK7aFtqxC99jqYnpTviK83bf6lGDgsKd4R3KLmHPnI8TqnIKj1gjw7N2sXFZNS2Svyg8cpZN7atxL39w4igsp');
INSERT INTO t1 VALUES (364531492,'qMa5SuKo4M5OM7ldvisSc6WK9rsG9E8sSixocHdgfa5uiiNTGFxkDJ4EAwWC2e4NL1BpAgWiFRcp1zIH6F1BayPdmwphatwnmzdwgzWnQ6SRxmcvtd6JRYwEKdvuWr');
SELECT intcol1,charcol1 FROM t1;
INSERT INTO t1 VALUES (1759592334,'3lkoxjtvgLu5xKHSTTtJuGE5F5QqmCcppCTmvFZScRZQgim93gSxwb24gKmIPEzEQStMjQiCu7WapGbkw4ilXch3xRLMhKSzgLDOovSi2qGj6rKvnuYAWDDJgaZDu2');
INSERT INTO t1 VALUES (73673339,'BN3152Gza4GW7atxJKACYwJqDbFynLxqc0kh30YTwgz3FktQ43XTrqJ4PQ25frn7kXhfXD8RuzN1j8Rf3y8ugKy6es3IbqPJM6ylCyD6xS7YcQCfHKZxYNvB7yTahm');
INSERT INTO t1 VALUES (95275444,'bNIrBDBl81tjzdvuOpQRCXgX37xGtzLKEXBIcE3k7xK7aFtqxC99jqYnpTviK83bf6lGDgsKd4R3KLmHPnI8TqnIKj1gjw7N2sXFZNS2Svyg8cpZN7atxL39w4igsp');
INSERT INTO t1 VALUES (73673339,'BN3152Gza4GW7atxJKACYwJqDbFynLxqc0kh30YTwgz3FktQ43XTrqJ4PQ25frn7kXhfXD8RuzN1j8Rf3y8ugKy6es3IbqPJM6ylCyD6xS7YcQCfHKZxYNvB7yTahm');
INSERT INTO t1 VALUES (1759592334,'3lkoxjtvgLu5xKHSTTtJuGE5F5QqmCcppCTmvFZScRZQgim93gSxwb24gKmIPEzEQStMjQiCu7WapGbkw4ilXch3xRLMhKSzgLDOovSi2qGj6rKvnuYAWDDJgaZDu2');
INSERT INTO t1 VALUES (73673339,'BN3152Gza4GW7atxJKACYwJqDbFynLxqc0kh30YTwgz3FktQ43XTrqJ4PQ25frn7kXhfXD8RuzN1j8Rf3y8ugKy6es3IbqPJM6ylCyD6xS7YcQCfHKZxYNvB7yTahm');
INSERT INTO t1 VALUES (1759592334,'3lkoxjtvgLu5xKHSTTtJuGE5F5QqmCcppCTmvFZScRZQgim93gSxwb24gKmIPEzEQStMjQiCu7WapGbkw4ilXch3xRLMhKSzgLDOovSi2qGj6rKvnuYAWDDJgaZDu2');
INSERT INTO t1 VALUES (1759592334,'3lkoxjtvgLu5xKHSTTtJuGE5F5QqmCcppCTmvFZScRZQgim93gSxwb24gKmIPEzEQStMjQiCu7WapGbkw4ilXch3xRLMhKSzgLDOovSi2qGj6rKvnuYAWDDJgaZDu2');
SELECT intcol1,charcol1 FROM t1;
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
SELECT intcol1,charcol1 FROM t1;
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
INSERT INTO t1 VALUES (1759592334,'3lkoxjtvgLu5xKHSTTtJuGE5F5QqmCcppCTmvFZScRZQgim93gSxwb24gKmIPEzEQStMjQiCu7WapGbkw4ilXch3xRLMhKSzgLDOovSi2qGj6rKvnuYAWDDJgaZDu2');
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
mysqlslap: Error when connecting to server: 1049 Unknown database 'mysqlslap'
SELECT intcol1,charcol1 FROM t1;
INSERT INTO t1 VALUES (73673339,'BN3152Gza4GW7atxJKACYwJqDbFynLxqc0kh30YTwgz3FktQ43XTrqJ4PQ25frn7kXhfXD8RuzN1j8Rf3y8ugKy6es3IbqPJM6ylCyD6xS7YcQCfHKZxYNvB7yTahm');
SELECT intcol1,charcol1 FROM t1;
SELECT intcol1,charcol1 FROM t1;
SELECT intcol1,charcol1 FROM t1;
SELECT intcol1,charcol1 FROM t1;

How to repeat:
Setup mysql using Gemalto encrypted fs.

Full output

Attachment: nohup.txt (text/plain), 94.74 KiB.

MySQL Config

Attachment: my.cnf (application/octet-stream, text), 1.51 KiB.

Please check duplicate with https://bugs.mysql.com/bug.php?id=21358. Thanks.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".