Professional Web Applications Themes

Lost connection to MySQL server during query - MySQL

I have a script that is processing data from a single table and splitting it into smaller normalized tables. The script takes anywhere between 5-10 minutes to complete, and as it runs it constantly outputs a report on its progress. The script seems to run fine the first time I run it, but with subsequent runs (To see if it incorrectly creates duplicates of records etc), after a couple of minutes the script ends with an error message saying "Lost connection to MySQL server during query". During the first run, the script is mostly just chopping up the data and ...

  1. #1

    Default Lost Connection to MySQL server during query

    I have a script that is processing data from a single table and splitting it
    into smaller normalized tables.



    The script takes anywhere between 5-10 minutes to complete, and as it runs
    it constantly outputs a report on its progress.



    The script seems to run fine the first time I run it, but with subsequent
    runs (To see if it incorrectly creates duplicates of records etc), after a
    couple of minutes the script ends with an error message saying "Lost
    connection to MySQL server during query".



    During the first run, the script is mostly just chopping up the data and
    placing it in the new tables, and doing a little comparing. But during
    subsequent runs, all of the records in the new tables should already exist,
    so the script see's this, and instead of creating new records, it compares
    them to see if its correct.



    Does anyone have any idea why it would be losing connection all the time?



    This is just being run on a test server at the moment. Being used as the
    server and also the client, configured as follows:



    Windows XP Tablet Edition

    PHP 4.3.3

    PHP Extensions: XmlRPC

    MySQL 4.0.14

    Apache 2.0.47



    Please help, this has been making my life hell for a week now!



    Thanks





    Donald


    Donald Tyler Guest

  2. #2

    Default Lost connection to MySQL server during query



    RHEL3 (up2date) mysql 4.0


    DELETE FROM database.tablename;

    This runs for about 30 minutes(expected), and then results with "Lost connection to MySQL server during query".
    This has been working for a long time now until today. The only difference is that it it has a LOT more records to delete.

    the error log shows:
    060410 7:20:59 Aborted connection 285910 to db: 'database' user: 'import' host: `rhost' (Got timeout reading communication packets)
    (Actually all of our servers are causing this error to appear.


    anybody know what to change.
    Troubled User Guest

Similar Threads

  1. Replies: 5
    Last Post: September 12th, 10:46 PM
  2. Replies: 26
    Last Post: September 12th, 11:02 PM
  3. #26490 [Com]: Lost connection to MySQL server during query
    By claudelfino at hotmail dot com in forum PHP Bugs
    Replies: 1
    Last Post: December 15th, 03:46 PM
  4. Replies: 15
    Last Post: February 26th, 11:50 PM
  5. [PHP] Lost Connection to MySQL server during query
    By Marek Kilimajer in forum PHP Development
    Replies: 1
    Last Post: September 10th, 03:47 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139