Lost connection to MySQL server

Discussion in 'MySQL' started by mlao, Oct 12, 2008.

0
  1. #1
    Hi I get this Errors on my Check Error Logs. :confused:

    DBD::mysql::st fetchrow_array failed: fetch() without execute() at (eval 13) line 1.
    DBD::mysql::st execute failed: Table 'travelersmeeting.photos' doesn't exist at (eval 12) line 1.
    DBD::mysql::st fetchrow_array failed: fetch() without execute() at (eval 13) line 1.
    DBD::mysql::st execute failed: Table 'travelersmeeting.photos' doesn't exist at (eval 12) line 1.
    DBD::mysql::st fetchrow_array failed: fetch() without execute() at (eval 13) line 1.
    DBD::mysql::st execute failed: Table 'travelersmeeting.photos' doesn't exist at (eval 12) line 1.
    DBD::mysql::st fetchrow_array failed: fetch() without execute() at (eval 13) line 1.
    DBD::mysql::st execute failed: Table 'travelersmeeting.photos' doesn't exist at (eval 12) line 1.
    DBD::mysql::st fetchrow_array failed: fetch() without execute() at (eval 13) line 1.
    DBD::mysql::st execute failed: Duplicate entry '108385181224' for key 1 at lib/mysql.lib line 309.
    DBD::mysql::st execute failed: Duplicate entry '108385185152' for key 1 at lib/mysql.lib line 309.
    DBD::mysql::st execute failed: Duplicate entry '108385186466' for key 1 at lib/mysql.lib line 309.
    DBD::mysql::st execute failed: Lost connection to MySQL server during query at lib/pm.lib line 2438.
    DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at lib/pm.lib line 2439.
    DBD::mysql::st execute failed: Lost connection to MySQL server during query at lib/pm.lib line 2465.
    DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at lib/pm.lib line 2466.
    DBD::mysql::st execute failed: Lost connection to MySQL server during query at lib/pm.lib line 2465.
    DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at lib/pm.lib line 2466.

    Is there a way to be fix ? :rolleyes:
    Thank you.
     
    mlao, Oct 12, 2008 IP
  2. bluetrendz

    bluetrendz Peon

    Messages:
    23
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Are the relevant tables created ??? in ur DB
     
    bluetrendz, Oct 12, 2008 IP
  3. Bohra

    Bohra Prominent Member

    Messages:
    12,573
    Likes Received:
    537
    Best Answers:
    0
    Trophy Points:
    310
    #3
    First of all check the status and repair ur databese
     
    Bohra, Oct 13, 2008 IP
  4. Freewebspace

    Freewebspace Notable Member

    Messages:
    6,213
    Likes Received:
    370
    Best Answers:
    0
    Trophy Points:
    275
    #4
    I think it's more to do with the Server status

    Check your SQL server status and restart it..

    and sometimes this may be due to your query which might be taking a long time to execute..
     
    Freewebspace, Oct 13, 2008 IP
  5. mlao

    mlao Active Member

    Messages:
    321
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #5
    Hi
    Thanks for help...
    But how do I restart SQL server status..:rolleyes:
     
    mlao, Oct 14, 2008 IP
  6. Estevan

    Estevan Peon

    Messages:
    120
    Likes Received:
    8
    Best Answers:
    1
    Trophy Points:
    0
    #6
    lost connections is due timeout in mysql look in your my.cnf ( nano /etc/my.cnf )
    connect_timeout = 30

    add more value if need if no have this line add the line and restart mysqld
    service mysqld restart


    Best
     
    Estevan, Oct 14, 2008 IP
  7. captaincore

    captaincore Peon

    Messages:
    98
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    more likely server is down or network issues.
     
    captaincore, Oct 14, 2008 IP
  8. mlao

    mlao Active Member

    Messages:
    321
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #8
    Sorry but Im slow on database thing. :eek:
    Im in hosting server!
    can please someone tell me the steps to do that ?
    I have this links when Im inside MySQL :
    Show MySQL runtime information
    Show MySQL system variables
    Show processes
    Character Sets and Collations
    Storage Engines
    Databases
    Export
    Import
     
    mlao, Oct 14, 2008 IP
  9. mlao

    mlao Active Member

    Messages:
    321
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #9
    Any of you guys ?:rolleyes:
     
    mlao, Oct 17, 2008 IP