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-test | Christopher M. DeBracy | 26 Jul |
| • RE: run-all-test | Christopher M. DeBracy | 26 Jul |
