MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Christopher M. DeBracy Date:July 26 2004 6:25pm
Subject:RE: run-all-test
View as plain text  
This is a follow-up to my original post from yesterday. I've narrowed down
the problem to the "test-connect" script.

C:\mysql\bench>perl test-connect --user=root --password=tops3cr3t
Testing server 'MySQL 4.0.20a nt' at 2004-07-26 13:01:26

Testing the speed of connecting to the server and sending of data
Connect tests are done 10000 times and other tests 100000 times

Testing connection/disconnect
DBI connect('database=test;host=localhost','root',...) failed: Can't connect
to MySQL server on 'localhost' (10048) at test-connect line 69
. 
. (repeats a number of times)
.
Got error 'Can't connect to MySQL server on 'localhost' (10048)' after 3908
connects at test-connect line 79.

It's always dying at about 3900 connections. If I re-run the test
immediately after it fails, it typically aborts.

Is there a parameter I'm missing somewhere?

Thanks,

Chris

> -----Original Message-----
> From: Christopher M. DeBracy [mailto:christopher@stripped] 
> Sent: Sunday, July 25, 2004 10:19 PM
> To: mysql@stripped
> Subject: run-all-test
> 
> 
> Have done a fresh install of 4.0.20 and am getting some odd 
> errors when running as root when I peform the tests:
> 
> ***************************************
> C:\mysql\bench>perl run-all-tests --user=root 
> --password=tops3cr3t Benchmark DBD suite: 2.15
> Date of test:        2004-07-25 22:11:28
> Running tests on:    Windows NT 5.1 x86
> Arguments:
> Comments:
> Limits from:
> Server version:      MySQL 4.0.20a nt
> Optimization:        None
> Hardware:
> 
> alter-table: Total time: 32 wallclock secs ( 0.06 usr  0.02 
> sys +  0.00 cusr 0. 00 csys =  0.08 CPU)
> ATIS: Total time: 35 wallclock secs (12.09 usr  5.26 sys +  
> 0.00 cusr  0.00 csys  = 17.36 CPU)
> big-tables: Total time: 29 wallclock secs (10.31 usr 10.36 
> sys +  0.00 cusr 0.0 0 csys = 20.67 CPU)
> connect: DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't co nnect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 DBI 
> connect('database=test;host=localhost','root',...) failed: 
> Can't connect to MySQL server on 'localhost' (10048) at 
> ./test-connect line 69 Got error 'Can't connect to MySQL 
> server on 'localhost' (10048)' after 3940 conn ects at 
> ./test-connect line 79.
> Warning: Can't execute connect.  Check the file 
> 'output/connect-mysql-NT_5.1' Failed (output/connect-mysql-NT_5.1)
> create: Got error: 'Can't connect to MySQL server on 
> 'localhost' (10048)' when c onnecting to 
> DBI:mysql:database=test;host=localhost with user: 'root'
> password:
> 'tops3cr3t'
> Compilation failed in require at ./test-create line 41.
> Warning: Can't execute create.  Check the file 
> 'output/create-mysql-NT_5.1' Failed (output/create-mysql-NT_5.1)
> insert: Got error: 'Can't connect to MySQL server on 
> 'localhost' (10048)' when c onnecting to 
> DBI:mysql:database=test;host=localhost with user: 'root'
> password:
> 'tops3cr3t'
> Compilation failed in require at ./test-insert line 43.
> Warning: Can't execute insert.  Check the file 
> 'output/insert-mysql-NT_5.1' Failed (output/insert-mysql-NT_5.1)
> select: Got error: 'Can't connect to MySQL server on 
> 'localhost' (10048)' when c onnecting to 
> DBI:mysql:database=test;host=localhost with user: 'root'
> password:
> 'tops3cr3t'
> Compilation failed in require at ./test-select line 35.
> Warning: Can't execute select.  Check the file 
> 'output/select-mysql-NT_5.1' Failed (output/select-mysql-NT_5.1)
> wisconsin: Got error: 'Can't connect to MySQL server on 
> 'localhost' (10048)' whe n connecting to 
> DBI:mysql:database=test;host=localhost with user: 'root' passwor
> d: 'tops3cr3t'
> Compilation failed in require at ./test-wisconsin line 27.
> Warning: Can't execute wisconsin.  Check the file 
> 'output/wisconsin-mysql-NT_5.1 ' Failed 
> (output/wisconsin-mysql-NT_5.1)
> 
> Of 8 tests, 5 tests didn't work
> 
> Totals per operation:
> Operation             seconds     usr     sys     cpu   tests
> alter_table_add                       14.00    0.03    0.00   
>  0.03     100
> alter_table_drop                      13.00    0.00    0.00   
>  0.00      91
> create_index                           3.00    0.00    0.00   
>  0.00       8
> create_table                           0.00    0.00    0.02   
>  0.02      28
> drop_index                             2.00    0.00    0.00   
>  0.00       8
> drop_table                             1.00    0.01    0.00   
>  0.01      28
> insert                                 5.00    0.89    0.56   
>  1.45    9768
> insert_many_fields                     4.00    0.31    0.18   
>  0.50    2000
> select_distinct                        7.00    2.25    1.02   
>  3.27     800
> select_group                           9.00    1.66    0.58   
>  2.23    2800
> select_join                            2.00    0.66    0.27   
>  0.92     100
> select_key_prefix_join                10.00    5.81    2.55   
>  8.36     100
> select_many_fields                    24.00   10.00   10.17   
> 20.17    2000
> select_simple_join                     1.00    0.81    0.28   
>  1.09     500
> TOTALS                                95.00   22.43   15.63   
> 38.05   18331
> 
> C:\mysql\bench>
> 
> **********************************************
> 
> The reports are 0 bytes so nothing in the error log beyond 
> what is printed on the screen.
> 
> What's so odd is that the tables can be modified, yet the 
> creates and inserts fail.
> 
> Any ideas?
> 
> Thanks.
> 
> 
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/mysql?unsub=1
> 
> 


Thread
run-all-testChristopher M. DeBracy26 Jul
  • RE: run-all-testChristopher M. DeBracy26 Jul