Saludos amigos, mi MySQL dejo de trabajar por arte de magia, opte por desinstalarlo completamente y volver a montarlo, luego de lo cual al tratar de iniciarlo me pone lo sgte en los logs:
101216 14:59:28 mysqld started 101216 14:59:28 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 InnoDB: Log scan progressed past the checkpoint lsn 0 36808 101216 14:59:28 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... InnoDB: Doing recovery: scanned up to log sequence number 0 43655 101216 14:59:28 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 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 InnoDB: Apply batch completed 101216 14:59:29 InnoDB: Started; log sequence number 0 43655 101216 14:59:29 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 101216 14:59:29 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 101216 14:59:29 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 101216 14:59:29 mysqld ended
Hola Orlando,
tiene pinta de que se haya quedado basura durante el proceso de desistalación que no permite arrancar bien el servicio.
Cómo desistalastes MySql ¿? y como lo has vuelto a instalar ¿?
saludos!
On Thu, Dec 16, 2010 at 9:11 PM, Orlando Pantoja Jr orlanjr@mumella.uo.edu.cu wrote:
Saludos amigos, mi MySQL dejo de trabajar por arte de magia, opte por desinstalarlo completamente y volver a montarlo, luego de lo cual al tratar de iniciarlo me pone lo sgte en los logs:
101216 14:59:28 mysqld started 101216 14:59:28 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 InnoDB: Log scan progressed past the checkpoint lsn 0 36808 101216 14:59:28 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... InnoDB: Doing recovery: scanned up to log sequence number 0 43655 101216 14:59:28 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 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 InnoDB: Apply batch completed 101216 14:59:29 InnoDB: Started; log sequence number 0 43655 101216 14:59:29 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 101216 14:59:29 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 101216 14:59:29 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 101216 14:59:29 mysqld ended _______________________________________________ CentOS-es mailing list CentOS-es@centos.org http://lists.centos.org/mailman/listinfo/centos-es
Al final del log, te habla de que falta el archivo /var/lib/mysql/mysql/host.frm; asegúrate de que está, que su propietario y grupo sea mysql.mysql y sus permisos sean 660.
2010/12/16 Orlando Pantoja Jr orlanjr@mumella.uo.edu.cu
Saludos amigos, mi MySQL dejo de trabajar por arte de magia, opte por desinstalarlo completamente y volver a montarlo, luego de lo cual al tratar de iniciarlo me pone lo sgte en los logs:
101216 14:59:28 mysqld started 101216 14:59:28 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295 InnoDB: Log scan progressed past the checkpoint lsn 0 36808 101216 14:59:28 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... InnoDB: Doing recovery: scanned up to log sequence number 0 43655 101216 14:59:28 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 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 InnoDB: Apply batch completed 101216 14:59:29 InnoDB: Started; log sequence number 0 43655 101216 14:59:29 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 101216 14:59:29 [ERROR] /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 101216 14:59:29 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 101216 14:59:29 mysqld ended _______________________________________________ CentOS-es mailing list CentOS-es@centos.org http://lists.centos.org/mailman/listinfo/centos-es
-
Orlando Pantoja Jr -
Ricardo Martinez -
victor santana