in reply to DBD::MySQL timeout during query

How about turning on tracing and posting the output?

Replies are listed 'Best First'.
Re^2: DBD::MySQL timeout during query
by rcraig (Initiate) on Sep 09, 2004 at 15:27 UTC
    OK - here it is:
        DBI::db=HASH(0x198c768) trace level set to 0x2/0 (DBI @ Ox0/0) in 
+DBI 1.42-ithread (pid 2800)
    Note: perl is running without the recommended perl -w option
    -> prepare for DBD::mysql::db (DBI::db=HASH(0x1960e34)~0x198c768 '
+select count(*) FROM Result;') thr#15d404c
Setting mysql_use_result to 0
    <- prepare= DBI::st=HASH(0x198c8dc) at stat_test.pl line 21
    -> execute for DBD::mysql::st (DBI::st=HASH(0x198c8dc)~0x188a14c) 
+thr#15d404c
    -> dbd_st_execute for 0198cfa8
    <- dbd_st_execute 1 rows
    <- execute= 1 at stat_test.pl line 22
    -> fetchrow_array for DBD::mysql::st (DBI::st=HASH(0x198c8dc)~0x18
+8a14c) thr#15d404c
    -> dbd_st_fetch for 0198cfa8, chopblanks 0
    <- dbd_st_fetch, 1 cols
    <- fetchrow_array= ( '8227' ) [1 items] row1 at stat_test.pl line 
+23
    -> prepare for DBD::mysql::db (DBI::db=HASH(0x1960e34)~0x198c768 '
+select count(*) FROM Protein;') thr#15d404c
Setting mysql_use_result to 0
    <- prepare= DBI::st=HASH(0x198d014) at stat_test.pl line 28
    -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x188a14c)~INNER) thr#
+15d404c
    <- DESTROY= undef at stat_test.pl line 29
    -> execute for DBD::mysql::st (DBI::st=HASH(0x198d014)~0x198d044) 
+thr#15d404c
    -> dbd_st_execute for 018da194
    <- dbd_st_execute 1 rows
    <- execute= 1 at stat_test.pl line 29
    -> fetchrow_array for DBD::mysql::st (DBI::st=HASH(0x198d014)~0x19
+8d044) thr#15d404c
    -> dbd_st_fetch for 018da194, chopblanks 0
    <- dbd_st_fetch, 1 cols
    <- fetchrow_array= ( '369276' ) [1 items] row1 at stat_test.pl lin
+e 30
    -> prepare for DBD::mysql::db (DBI::db=HASH(0x1960e34)~0x198c768 '
+select count(DISTINCT label) FROM ProSeq;') thr#15d404c
Setting mysql_use_result to 0
    <- prepare= DBI::st=HASH(0x198d0ec) at stat_test.pl line 36
    -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x198d044)~INNER) thr#
+15d404c
    <- DESTROY= undef at stat_test.pl line 37
    -> execute for DBD::mysql::st (DBI::st=HASH(0x198d0ec)~0x198d11c) 
+thr#15d404c
    -> dbd_st_execute for 0198d038
    <- dbd_st_execute 1 rows
    <- execute= 1 at stat_test.pl line 37
    -> fetchrow_array for DBD::mysql::st (DBI::st=HASH(0x198d0ec)~0x19
+8d11c) thr#15d404c
    -> dbd_st_fetch for 0198d038, chopblanks 0
    <- dbd_st_fetch, 1 cols
    <- fetchrow_array= ( '51909' ) [1 items] row1 at stat_test.pl line
+ 38
    -> prepare for DBD::mysql::db (DBI::db=HASH(0x1960e34)~0x198c768 '
+select count(*) FROM Peptide;') thr#15d404c
Setting mysql_use_result to 0
    <- prepare= DBI::st=HASH(0x198cff0) at stat_test.pl line 46
    -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x198d11c)~INNER) thr#
+15d404c
    <- DESTROY= undef at stat_test.pl line 47
    -> execute for DBD::mysql::st (DBI::st=HASH(0x198cff0)~0x198c8e8) 
+thr#15d404c
    -> dbd_st_execute for 0198d110
    <- dbd_st_execute 1 rows
    <- execute= 1 at stat_test.pl line 47
    -> fetchrow_array for DBD::mysql::st (DBI::st=HASH(0x198cff0)~0x19
+8c8e8) thr#15d404c
    -> dbd_st_fetch for 0198d110, chopblanks 0
    <- dbd_st_fetch, 1 cols
    <- fetchrow_array= ( '1860342' ) [1 items] row1 at stat_test.pl li
+ne 48
    -> execute for DBD::mysql::st (DBI::st=HASH(0x198cff0)~0x198c8e8) 
+thr#15d404c
    -> dbd_st_execute for 0198d110
    <- dbd_st_execute 1 rows
    <- execute= 1 at stat_test.pl line 54
    -> fetchrow_array for DBD::mysql::st (DBI::st=HASH(0x198cff0)~0x19
+8c8e8) thr#15d404c
    -> dbd_st_fetch for 0198d110, chopblanks 0
    <- dbd_st_fetch, 1 cols
    <- fetchrow_array= ( '1860342' ) [1 items] row1 at stat_test.pl li
+ne 55
    -> finish for DBD::mysql::st (DBI::st=HASH(0x198cff0)~0x198c8e8) t
+hr#15d404c
    <- finish= 1 at stat_test.pl line 57
    -> disconnect for DBD::mysql::db (DBI::db=HASH(0x1960e34)~0x198c76
+8) thr#15d404c
&imp_dbh->mysql: 198cc94
    <- disconnect= 1 at stat_test.pl line 76
!   -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x198c8e8)~INNER) thr#
+15d404c
!   <- DESTROY= undef during global destruction
!   -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x198c768)~INNER) thr#
+15d404c
!   <- DESTROY= undef during global destruction
    DBI::db=HASH(0x198c1a0) trace level set to 0x2/0 (DBI @ Ox0/0) in 
+DBI 1.42-ithread (pid 1840)
    Note: perl is running without the recommended perl -w option
    -> prepare for DBD::mysql::db (DBI::db=HASH(0x1961304)~0x198c1a0 '
+select count(*) FROM Result;') thr#15d404c
Setting mysql_use_result to 0
    <- prepare= DBI::st=HASH(0x198ce90) at stat_test.pl line 21
    -> execute for DBD::mysql::st (DBI::st=HASH(0x198ce90)~0x188a37c) 
+thr#15d404c
    -> dbd_st_execute for 0198cf38
    <- dbd_st_execute 1 rows
    <- execute= 1 at stat_test.pl line 22
    -> fetchrow_array for DBD::mysql::st (DBI::st=HASH(0x198ce90)~0x18
+8a37c) thr#15d404c
    -> dbd_st_fetch for 0198cf38, chopblanks 0
    <- dbd_st_fetch, 1 cols
    <- fetchrow_array= ( '8227' ) [1 items] row1 at stat_test.pl line 
+23
    -> prepare for DBD::mysql::db (DBI::db=HASH(0x1961304)~0x198c1a0 '
+select count(*) FROM Protein;') thr#15d404c
Setting mysql_use_result to 0
    <- prepare= DBI::st=HASH(0x198cfa4) at stat_test.pl line 28
    -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x188a37c)~INNER) thr#
+15d404c
    <- DESTROY= undef at stat_test.pl line 29
    -> execute for DBD::mysql::st (DBI::st=HASH(0x198cfa4)~0x198cfd4) 
+thr#15d404c
    -> dbd_st_execute for 018da15c
    <- dbd_st_execute 1 rows
    <- execute= 1 at stat_test.pl line 29
    -> fetchrow_array for DBD::mysql::st (DBI::st=HASH(0x198cfa4)~0x19
+8cfd4) thr#15d404c
    -> dbd_st_fetch for 018da15c, chopblanks 0
    <- dbd_st_fetch, 1 cols
    <- fetchrow_array= ( '369276' ) [1 items] row1 at stat_test.pl lin
+e 30
    -> prepare for DBD::mysql::db (DBI::db=HASH(0x1961304)~0x198c1a0 '
+select count(DISTINCT label) FROM ProSeq;') thr#15d404c
Setting mysql_use_result to 0
    <- prepare= DBI::st=HASH(0x198d07c) at stat_test.pl line 36
    -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x198cfd4)~INNER) thr#
+15d404c
    <- DESTROY= undef at stat_test.pl line 37
    -> execute for DBD::mysql::st (DBI::st=HASH(0x198d07c)~0x198d0ac) 
+thr#15d404c
    -> dbd_st_execute for 0198cfc8
    <- dbd_st_execute 1 rows
    <- execute= 1 at stat_test.pl line 37
    -> fetchrow_array for DBD::mysql::st (DBI::st=HASH(0x198d07c)~0x19
+8d0ac) thr#15d404c
    -> dbd_st_fetch for 0198cfc8, chopblanks 0
    <- dbd_st_fetch, 1 cols
    <- fetchrow_array= ( '51909' ) [1 items] row1 at stat_test.pl line
+ 38
    -> prepare for DBD::mysql::db (DBI::db=HASH(0x1961304)~0x198c1a0 '
+select count(*) FROM Peptide;') thr#15d404c
Setting mysql_use_result to 0
    <- prepare= DBI::st=HASH(0x198cf80) at stat_test.pl line 46
    -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x198d0ac)~INNER) thr#
+15d404c
    <- DESTROY= undef at stat_test.pl line 47
    -> execute for DBD::mysql::st (DBI::st=HASH(0x198cf80)~0x198ce9c) 
+thr#15d404c
    -> dbd_st_execute for 0198d0a0
    <- dbd_st_execute 1 rows
    <- execute= 1 at stat_test.pl line 47
    -> fetchrow_array for DBD::mysql::st (DBI::st=HASH(0x198cf80)~0x19
+8ce9c) thr#15d404c
    -> dbd_st_fetch for 0198d0a0, chopblanks 0
    <- dbd_st_fetch, 1 cols
    <- fetchrow_array= ( '1860342' ) [1 items] row1 at stat_test.pl li
+ne 48
    -> prepare for DBD::mysql::db (DBI::db=HASH(0x1961304)~0x198c1a0 '
+select count(DISTINCT seq) FROM Peptide;') thr#15d404c
Setting mysql_use_result to 0
    <- prepare= DBI::st=HASH(0x198d058) at stat_test.pl line 54
    -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x198ce9c)~INNER) thr#
+15d404c
    <- DESTROY= undef at stat_test.pl line 55
    -> execute for DBD::mysql::st (DBI::st=HASH(0x198d058)~0x198cfb0) 
+thr#15d404c
    -> dbd_st_execute for 0198d10c
Lost connection to MySQL server during query error 2013 recorded: Lost
+ connection to MySQL server during query
    <- dbd_st_execute -2 rows
    !! ERROR: 2013 'Lost connection to MySQL server during query' (err
+#0)
    <- execute= undef at stat_test.pl line 55
!   -> DESTROY for DBD::mysql::st (DBI::st=HASH(0x198cfb0)~INNER) thr#
+15d404c
       ERROR: 2013 'Lost connection to MySQL server during query' (err
+#0)
!   <- DESTROY= undef during global destruction
!   -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x198c1a0)~INNER) thr#
+15d404c
&imp_dbh->mysql: 198cc04
       ERROR: 2013 'Lost connection to MySQL server during query' (err
+#0)
!   <- DESTROY= undef during global destruction

    [download]

    Hmmmmm. Does this help? I guess I need to eat more sushi.
    Thanks.
[reply]
[d/l]
      A quick search through the DBI lists ... Try here or here. One of these posts may help - the first one may be a likely candidate
[reply]

In Section Seekers of Perl Wisdom