service terminating

I'm having a problem where every day or so, the mysql service is restarting. This is MySql 5 running on a win2003 server.
The error in the event log says:

Faulting application mysqld-nt.exe, version 0.0.0.0, faulting module mysqld-nt.exe, version 0.0.0.0, fault address 0x001fa173.

In MySql's error file, it only shows that the service stopped unexpectedly and it's trying to recover:

Version: '5.0.18-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
090519 8:04:31 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...
090519 8:04:32 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 7 3461755255.
InnoDB: Doing recovery: scanned up to log sequence number 7 3461778224
090519 8:04:32 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name
090519 8:04:32 InnoDB: Started; log sequence number 7 3461778224
090519 8:04:32 [Note] D:\Mysql\bin\mysqld-nt: ready for connections.


I have excluded the mysql data directory from the virus scan (Trend Micro) and this seems to have reduced the frequency
but it still happens every day or two.




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: service terminating

--000e0cd247e46dd1fa046a5a4af5
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hi,
aren't there any other clues before restarting?

2009/5/20 Duane Hebert

> I'm having a problem where every day or so, the mysql service is
> restarting. This is MySql 5 running on a win2003 server.
> The error in the event log says:
>
> Faulting application mysqld-nt.exe, version 0.0.0.0, faulting module
> mysqld-nt.exe, version 0.0.0.0, fault address 0x001fa173.
>
> In MySql's error file, it only shows that the service stopped unexpectedly
> and it's trying to recover:
>
> Version: '5.0.18-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
> 090519 8:04:31 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...
> 090519 8:04:32 InnoDB: Starting log scan based on checkpoint at
> InnoDB: log sequence number 7 3461755255.
> InnoDB: Doing recovery: scanned up to log sequence number 7 3461778224
> 090519 8:04:32 InnoDB: Starting an apply batch of log records to the
> database...
> InnoDB: Progress in percents: 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
> InnoDB: Apply batch completed
> InnoDB: Last MySQL binlog file position 0 0, file name
> 090519 8:04:32 InnoDB: Started; log sequence number 7 3461778224
> 090519 8:04:32 [Note] D:\Mysql\bin\mysqld-nt: ready for connections.
>
>
> I have excluded the mysql data directory from the virus scan (Trend Micro)
> and this seems to have reduced the frequency
> but it still happens every day or two.
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=claudio.nanni@gmail.com
>
>

--000e0cd247e46dd1fa046a5a4af5--