[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Actualicé el sistema y el servidor mysql no funciona



Pues esto es lo que dice:

Jul 13 09:51:23 debariel mysqld_safe[27993]: Please report any problems with the /usr/scripts/mysqlbug script!
Jul 13 09:51:23 debariel mysqld_safe[27993]: 
Jul 13 09:51:23 debariel mysqld_safe[28038]: 110713  9:51:23 [Note] Plugin 'FEDERATED' is disabled.
Jul 13 09:51:23 debariel mysqld_safe[28038]: 110713  9:51:23  InnoDB: Initializing buffer pool, size = 8.0M
Jul 13 09:51:23 debariel mysqld_safe[28038]: 110713  9:51:23  InnoDB: Completed initialization of buffer pool
Jul 13 09:51:23 debariel mysqld_safe[28038]: 110713  9:51:23  InnoDB: Started; log sequence number 0 44233
Jul 13 09:51:23 debariel mysqld_safe[28038]: 110713  9:51:23  InnoDB: Starting shutdown...
Jul 13 09:51:28 debariel mysqld_safe[28038]: 110713  9:51:28  InnoDB: Shutdown completed; log sequence number 0 44233
Jul 13 09:51:28 debariel mysqld_safe[28087]: 110713  9:51:28 [Note] Plugin 'FEDERATED' is disabled.
Jul 13 09:51:28 debariel mysqld_safe[28087]: 110713  9:51:28  InnoDB: Initializing buffer pool, size = 8.0M
Jul 13 09:51:28 debariel mysqld_safe[28087]: 110713  9:51:28  InnoDB: Completed initialization of buffer pool
Jul 13 09:51:28 debariel mysqld_safe[28087]: 110713  9:51:28  InnoDB: Started; log sequence number 0 44233
Jul 13 09:51:28 debariel mysqld_safe[28087]: ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
Jul 13 09:51:28 debariel mysqld_safe[28087]: 110713  9:51:28 [ERROR] Aborting
Jul 13 09:51:28 debariel mysqld_safe[28087]: 
Jul 13 09:51:28 debariel mysqld_safe[28087]: 110713  9:51:28  InnoDB: Starting shutdown...
Jul 13 09:51:33 debariel mysqld_safe[28087]: 110713  9:51:33  InnoDB: Shutdown completed; log sequence number 0 44233
Jul 13 09:51:33 debariel mysqld_safe[28087]: 110713  9:51:33 [Note] /usr/sbin/mysqld: Shutdown complete
Jul 13 09:51:33 debariel mysqld_safe[28087]: 
Jul 13 09:51:33 debariel mysqld_safe[28132]: 110713  9:51:33 [Note] Plugin 'FEDERATED' is disabled.
Jul 13 09:51:33 debariel mysqld_safe[28132]: 110713  9:51:33  InnoDB: Initializing buffer pool, size = 8.0M
Jul 13 09:51:33 debariel mysqld_safe[28132]: 110713  9:51:33  InnoDB: Completed initialization of buffer pool
Jul 13 09:51:33 debariel mysqld_safe[28132]: 110713  9:51:33  InnoDB: Started; log sequence number 0 44233
Jul 13 09:51:33 debariel mysqld_safe[28132]: 110713  9:51:33  InnoDB: Starting shutdown...
Jul 13 09:51:38 debariel mysqld_safe[28132]: 110713  9:51:38  InnoDB: Shutdown completed; log sequence number 0 44233
Jul 13 09:51:38 debariel mysqld_safe[28180]: 110713  9:51:38 [Note] Plugin 'FEDERATED' is disabled.
Jul 13 09:51:38 debariel mysqld_safe[28180]: 110713  9:51:38  InnoDB: Initializing buffer pool, size = 8.0M
Jul 13 09:51:39 debariel mysqld_safe[28180]: 110713  9:51:39  InnoDB: Completed initialization of buffer pool
Jul 13 09:51:39 debariel mysqld_safe[28180]: 110713  9:51:39  InnoDB: Started; log sequence number 0 44233
Jul 13 09:51:39 debariel mysqld_safe[28180]: ERROR: 1050  Table 'plugin' already exists
Jul 13 09:51:39 debariel mysqld_safe[28180]: 110713  9:51:39 [ERROR] Aborting
Jul 13 09:51:39 debariel mysqld_safe[28180]: 
Jul 13 09:51:39 debariel mysqld_safe[28180]: 110713  9:51:39  InnoDB: Starting shutdown...
Jul 13 09:51:44 debariel mysqld_safe[28180]: 110713  9:51:44  InnoDB: Shutdown completed; log sequence number 0 44233
Jul 13 09:51:44 debariel mysqld_safe[28180]: 110713  9:51:44 [Note] /usr/sbin/mysqld: Shutdown complete
Jul 13 09:51:44 debariel mysqld_safe[28180]: 
Jul 13 09:51:44 debariel mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Jul 13 09:51:44 debariel mysqld: 110713  9:51:44 [Note] Plugin 'FEDERATED' is disabled.
Jul 13 09:51:44 debariel mysqld: 110713  9:51:44  InnoDB: Initializing buffer pool, size = 8.0M
Jul 13 09:51:44 debariel mysqld: 110713  9:51:44  InnoDB: Completed initialization of buffer pool
Jul 13 09:51:44 debariel mysqld: 110713  9:51:44  InnoDB: Started; log sequence number 0 44233
Jul 13 09:51:44 debariel mysqld: 110713  9:51:44 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Jul 13 09:51:44 debariel mysqld: 110713  9:51:44 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Jul 13 09:51:44 debariel mysqld: 110713  9:51:44 [ERROR] Aborting
Jul 13 09:51:44 debariel mysqld: 
Jul 13 09:51:44 debariel mysqld: 110713  9:51:44  InnoDB: Starting shutdown...
Jul 13 09:51:49 debariel mysqld: 110713  9:51:49  InnoDB: Shutdown completed; log sequence number 0 44233
Jul 13 09:51:49 debariel mysqld: 110713  9:51:49 [Note] /usr/sbin/mysqld: Shutdown complete
Jul 13 09:51:49 debariel mysqld: 
Jul 13 09:51:49 debariel mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Jul 13 09:51:58 debariel /etc/init.d/mysql[28642]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jul 13 09:51:58 debariel /etc/init.d/mysql[28642]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jul 13 09:51:58 debariel /etc/init.d/mysql[28642]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jul 13 09:51:58 debariel /etc/init.d/mysql[28642]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jul 13 09:51:58 debariel /etc/init.d/mysql[28642]: 
Jul 13 10:58:05 debariel named[1698]: built with '--prefix=/usr' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--sysconfdir=/etc/bind' '--localstatedir=/var' '--enable-threads' '--enable-largefile' '--with-libtool' '--enable-shared' '--enable-static' '--with-openssl=/usr' '--with-gssapi=/usr' '--with-gnu-ld' '--with-dlz-postgres=no' '--with-dlz-mysql=no' '--with-dlz-bdb=yes' '--with-dlz-filesystem=yes' '--with-dlz-ldap=yes' '--with-dlz-stub=yes' '--with-geoip=/usr' '--enable-ipv6' 'CFLAGS=-fno-strict-aliasing -DDIG_SIGCHASE -O2' 'LDFLAGS=' 'CPPFLAGS='
Jul 13 10:58:11 debariel mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Jul 13 10:58:11 debariel mysqld: 110713 10:58:11 [Note] Plugin 'FEDERATED' is disabled.
Jul 13 10:58:12 debariel mysqld: 110713 10:58:12  InnoDB: Initializing buffer pool, size = 8.0M
Jul 13 10:58:12 debariel mysqld: 110713 10:58:12  InnoDB: Completed initialization of buffer pool
Jul 13 10:58:12 debariel mysqld: 110713 10:58:12  InnoDB: Started; log sequence number 0 44233
Jul 13 10:58:12 debariel mysqld: 110713 10:58:12 [ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
Jul 13 10:58:12 debariel mysqld: 110713 10:58:12 [ERROR] Do you already have another mysqld server running on port: 3306 ?
Jul 13 10:58:12 debariel mysqld: 110713 10:58:12 [ERROR] Aborting
Jul 13 10:58:12 debariel mysqld: 
Jul 13 10:58:12 debariel mysqld: 110713 10:58:12  InnoDB: Starting shutdown...
Jul 13 10:58:19 debariel mysqld: 110713 10:58:19  InnoDB: Shutdown completed; log sequence number 0 44233
Jul 13 10:58:19 debariel mysqld: 110713 10:58:19 [Note] /usr/sbin/mysqld: Shutdown complete
Jul 13 10:58:19 debariel mysqld: 
Jul 13 10:58:20 debariel mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Jul 13 10:58:25 debariel /etc/init.d/mysql[2746]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jul 13 10:58:25 debariel /etc/init.d/mysql[2746]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jul 13 10:58:25 debariel /etc/init.d/mysql[2746]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jul 13 10:58:25 debariel /etc/init.d/mysql[2746]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jul 13 10:58:25 debariel /etc/init.d/mysql[2746]: 


Saludos

2011/7/13 Manolo Díaz <dusml@pleione.es>
El miércoles, 13 de julio de 2011 a las 09:49:02 -0400 horas,
Ariel escribió:

> Los logs de mysql que están en /var/log no dicen nada.

Mira a ver si hay algo en los logs de sistema.

grep mysql /var/log/syslog

Saludos.
--
Manolo Díaz


--
To UNSUBSCRIBE, email to debian-user-spanish-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
Archive: 20110713161127.093b08d4@85.48.198.176" target="_blank">http://lists.debian.org/20110713161127.093b08d4@85.48.198.176



Reply to: