[arch-general] [arch-dev-public] MySQL 5.5

[Marek Otahal]

On Wednesday 22 of December 2010 10:29:43 Andrea Scarpino wrote:
> > [root at beruska ~]# mysql_upgrade
> > Looking for 'mysql' as: mysql
> > Looking for 'mysqlcheck' as: mysqlcheck
> > Running 'mysqlcheck' with connection arguments: '--port=3306' '--
> > socket=/var/run/mysqld/mysqld.sock' '--port=3306' '--
> > socket=/var/run/mysqld/mysqld.sock'
> > mysqlcheck: Got error: 2002: Can't connect to local MySQL server through
> > socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect
> > FATAL ERROR: Upgrade failed
> > 
> > Any ideas?
> 
> Is mysql running?
It is not, mysqld doesn't know some option '--skip-locking' . Here's my 
debugging :

[root at beruska ~]# ps aux | grep mysql
marek    27468  1.1  1.2 235992 24788 ?        Sl   11:19   0:03 
/usr/bin/mysqld --defaults-file=/home/marek/.local/share/akonadi//mysql.conf 
--datadir /home/marek/.local/share/akonadi/db_data/ --
socket=/home/marek/.local/share/akonadi/db_misc/mysql.socket
root     27829  0.0  0.0   4284   828 pts/2    S+   11:23   0:00 grep mysql

[root at beruska ~]# /etc/rc.d/mysqld restart
:: Stopping MySQL Server                                                                                
[FAIL] 
:: Starting MySQL Server                                                                                
[FAIL] 

[root at beruska ~]# vim /etc/rc.d/mysqld 
I tried the commands manually to see output

[root at beruska ~]# pgrep -u mysql mysqld
[root at beruska ~]# /usr/bin/mysqld_safe --user=mysql
101222 11:26:35 mysqld_safe Logging to '/var/lib/mysql/beruska.err'.
101222 11:26:35 mysqld_safe Starting mysqld daemon with databases from 
/var/lib/mysql
101222 11:26:37 mysqld_safe mysqld from pid file /var/lib/mysql/beruska.pid 
ended
[root at beruska ~]# /usr/bin/mysqladmin -uUNKNOWN_USER ping 
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket 
'/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: 
'/var/run/mysqld/mysqld.sock' exists!
[root at beruska ~]# ls -l /var/run/mysqld/mysqld.sock
ls: cannot access /var/run/mysqld/mysqld.sock: No such file or directory
[root at beruska ~]# tail -10 /var/lib/mysql/beruska.err 
101222 11:26:36  InnoDB: highest supported file format is Barracuda.
101222 11:26:36  InnoDB: 1.1.4 started; log sequence number 1591525
101222 11:26:36 [ERROR] /usr/bin/mysqld: unknown option '--skip-locking'
101222 11:26:36 [ERROR] Aborting

101222 11:26:36  InnoDB: Starting shutdown...
101222 11:26:37  InnoDB: Shutdown completed; log sequence number 1591525
101222 11:26:37 [Note] /usr/bin/mysqld: Shutdown complete

101222 11:26:37 mysqld_safe mysqld from pid file /var/lib/mysql/beruska.pid 
ended

Thanks, Marek
-- 

Marek Otahal :o)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 836 bytes
Desc: This is a digitally signed message part.
URL: <http://mailman.archlinux.org/pipermail/arch-general/attachments/20101222/c2d18de8/attachment-0001.asc>