Soy nuevo en el foro y antes que nada pido disculpas si mi problema es recurrente.
**************************************
Base de datos: MySql 5.0
Servidor: Windows server 2003 (
**************************************
Tenemos como 100 usuarios(dispositivos moviles) que actualizan la base de datos minuto a minuto la mayor parte del dia (insertan registros y hacen correr procedimientos almacenados y trigers).
El problema es que en cualquier momento se rompe(crash) Mysql. Reviso el log y me da esta informacion que No entiendo.
:::::::::::::::::::::::::::::::::::::::::::::::::: :::
InnoDB: Rolling back of trx id 0 9669611 completed
101125 22:42:05 InnoDB: Rollback of non-prepared transactions completed
101126 5:34:04 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...
101126 5:34:04 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 3 2353795669.
InnoDB: Doing recovery: scanned up to log sequence number 3 2353795669
101126 5:34:05 InnoDB: Started; log sequence number 3 2353795669
101126 5:34:05 [Note] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.20-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
101126 8:43:55 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...
101126 8:43:56 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 3 2384284453.
InnoDB: Doing recovery: scanned up to log sequence number 3 2384290216
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 3 row operations to undo
InnoDB: Trx id counter is 0 9765888
101126 8:43:56 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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: Starting in background the rollback of uncommitted transactions
101126 8:43:57 InnoDB: Rolling back trx with id 0 9765486, 3 rows to undo
101126 8:43:57 InnoDB: Started; log sequence number 3 2384290216
101126 8:43:57 [Note] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.20-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
InnoDB: Rolling back of trx id 0 9765486 completed
101126 8:43:57 InnoDB: Rollback of non-prepared transactions completed
101126 8:53:59 [ERROR] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted
101126 8:54:00 [ERROR] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted
101126 8:55:39 [ERROR] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: Sort aborted
101126 9:31:36 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...
101126 9:31:36 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 3 2405314578.
InnoDB: Doing recovery: scanned up to log sequence number 3 2405314578
InnoDB: 1 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 3 row operations to undo
InnoDB: Trx id counter is 0 9772800
InnoDB: Starting in background the rollback of uncommitted transactions
101126 9:31:36 InnoDB: Rolling back trx with id 0 9772341, 3 rows to undo
101126 9:31:36 InnoDB: Started; log sequence number 3 2405314578
101126 9:31:36 [Note] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.20-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
InnoDB: Rolling back of trx id 0 9772341 completed
101126 9:31:36 InnoDB: Rollback of non-prepared transactions completed
101126 9:31:52 [Note] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown
101126 9:31:54 [Warning] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 1 user: 'APM'
101126 9:31:54 InnoDB: Starting shutdown...
101126 9:31:56 InnoDB: Shutdown completed; log sequence number 3 2405316509
101126 9:31:56 [Note] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
101126 9:31:57 InnoDB: Started; log sequence number 3 2405316509
101126 9:31:57 [Note] C:\Archivos de programa\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.20-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
:::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: :::::::::::::::::::::::::::::::::::::::::::::::::: ::
Tengo este problema desde hace 3 meses, intente reinstalando de nuevo Mysql pero NO tuve exito.
Pueden ayudarme?
Saludos
Domingo
