DBD::mysql::db do failes when too many concurrenct connections [rt.cpan.org #83520]

[mbeijen]

trafficstars

Migrated from rt.cpan.org#83520 (status was 'new')

Requestors:

• [email protected]

From [email protected] on 2013-02-21 22:02:16:

Originally reported by Oli Sennhauser at
http://bugs.mysql.com/bug.php?id=20629

Description:
When we run a benchmark script which need for the PT Workshop. It gives
an error with too many concurrent connections.

How to repeat:
# perl benchmark-sql.pl --flush=0 -c 1 -n 10000 --schema=world -e "select 1"
Total Time is: 1.0333
Number of Iterations: 10000
Number of Clients: 1

  #   Time/Query  Total Time  Query
 ---  ----------  ----------  -----
  1.     0.00010     1.03315  select 1

  1. select 1

# perl benchmark-sql.pl --flush=0 -c 5 -n 2000 --schema=world -e "select 1"
ERROR processing SQL statement #1:

select 1

DBD::mysql::db do failed: Lost connection to MySQL server during query
at benchmark-sql.pl line 132.
 at benchmark-sql.pl line 132
        eval {...} called at benchmark-sql.pl line 132

# perl benchmark-sql.pl --flush=0 -c 25 -n 400 --schema=world -e "select 1"
DBD::mysql::db do failed: Lost connection to MySQL server during query
at benchmark-sql.pl line 112.
 at benchmark-sql.pl line 112

Original file to repeat the issue is hidden, but I was not able to find
a way to put hidden file into this user interface. So, please, if you
need test case, let me, or some other Oracle employee who has developer
access to bugs.mysql.com, know how to send it privately.

[dveeden]

@CaptTofu do you have access to the file mentioned here?

[dveeden]

Closing this as there isn't enough information to reproduce this and this has been reported a long time ago with much older DBD::mysql and MySQL versions.

cc @svetasmirnova @shinguz