Results 1 to 12 of 12
  1. #1

    MySQL server crashes when queried

    Hello Guys,

    MYSQL has worked for months fine and then suddenly just crashes upon query. Ive reinstalled, tried upgrading, downgrading etc and they all do the same. I have recreated configs many a time but this problem wont go away. Running most up-to-date Windows server 2003 with service pack 1.

    If i do MYSQL-nt --console i get:

    C:\Documents and Settings\Administrator>mysqld-nt --console
    050613 16:51:22 InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    050613 16:51:22 InnoDB: Starting log scan based on checkpoint at
    InnoDB: log sequence number 0 1015146.
    InnoDB: Doing recovery: scanned up to log sequence number 0 1015146
    050613 16:51:22 InnoDB: Flushing modified pages from the buffer pool...
    050613 16:51:22 InnoDB: Started; log sequence number 0 1015146
    mysqld-nt: ready for connections.
    Version: '4.1.12a-nt' socket: '' port: 3306 Official MySQL binary

    I then query the mysql server and it just closes down. This is quering via scripts , programs and even just quering using MySQL Control Centre. Im getting no errors in mysql logs as well.. I have tried running MYSQL with and without innodb enabled.. Help please
    Clanplanet: Serving the gaming industry since 2004.
    > Game/Clan Servers, Teamspeak and Ventrilo
    > Dedicated Servers
    Want a new gaming POP in the UK? Low ping and Lag Free? Contact us.

  2. #2
    Join Date
    Feb 2005
    Location
    India
    Posts
    911

  3. #3
    Server Specs: P3 650MHZ
    512 ecc memory
    120GB Hard drive.

    It is used to host our teamspeak and controlpanel for our gaming servers. So the low spec does the job very very easily Memory Check? Take its software then.. is that whats it called?
    Clanplanet: Serving the gaming industry since 2004.
    > Game/Clan Servers, Teamspeak and Ventrilo
    > Dedicated Servers
    Want a new gaming POP in the UK? Low ping and Lag Free? Contact us.

  4. #4
    Join Date
    Sep 2002
    Location
    Nashville, TN
    Posts
    237
    Do you use InnoDB? If not, turn it off and see if it still crashes. How long has it been running with Win2k3SP1? I have a feeling that may have something to do with it. Also, how much free disk space do you have? Finally, turn on verbose/debug logging and see what that says...

    -Chris

  5. #5
    Ive tried it with InnoDB on and Off Its been running with it for around 3 months and its been fine until now Disk space wise I have 80GB on the files drive (used for copies of our games servers) and on our Windows only hard drive 2.9GB
    Clanplanet: Serving the gaming industry since 2004.
    > Game/Clan Servers, Teamspeak and Ventrilo
    > Dedicated Servers
    Want a new gaming POP in the UK? Low ping and Lag Free? Contact us.

  6. #6
    Originally posted by ThinkSupport
    Can you let us know your server specs.

    Try running memory check on the server as you said it was running fine earlier.

    I second the memory check.

  7. #7
    Join Date
    Sep 2002
    Location
    Nashville, TN
    Posts
    237
    How much free space, though, do you have?

  8. #8
    on the MySQL hard drive 2.5GB space and 98gb on the other hard drive. is it possible to do it via Windows instead of at boot up as im doing this via terminal services.. server is at data centre
    Clanplanet: Serving the gaming industry since 2004.
    > Game/Clan Servers, Teamspeak and Ventrilo
    > Dedicated Servers
    Want a new gaming POP in the UK? Low ping and Lag Free? Contact us.

  9. #9
    Join Date
    Sep 2002
    Location
    Nashville, TN
    Posts
    237
    So let me get this right... you have 98GB free on an 80GB drive? and 2.5GB free on a 2.9GB drive with Windows installed? I don't think I can recall a Windows Server installation taking ~300MB... are you sure about this?

    -Chris

  10. #10
    c: (NTFS on drive 1) 9.16 GB 2.90 GB free
    e: (NTFS on drive 0) 119.34 GB 98.57 GB free
    Clanplanet: Serving the gaming industry since 2004.
    > Game/Clan Servers, Teamspeak and Ventrilo
    > Dedicated Servers
    Want a new gaming POP in the UK? Low ping and Lag Free? Contact us.

  11. #11
    Join Date
    Sep 2002
    Location
    Nashville, TN
    Posts
    237
    What about SP1? Did you recently install it? Was it working afterwards?

    -Chris

  12. #12
    Was installed with Windows
    Clanplanet: Serving the gaming industry since 2004.
    > Game/Clan Servers, Teamspeak and Ventrilo
    > Dedicated Servers
    Want a new gaming POP in the UK? Low ping and Lag Free? Contact us.

Posting Permissions

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