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/[EMAIL PROTECTED]
