[kdepim-users] akonadi error - fails to start

[dirk]

Am 18.11.2014 14:06, schrieb René J.V. Bertin:
> On Tuesday November 18 2014 11:47:03 dirk wrote:
>
>
>> InnoDB: Unable to lock ./ibdata1, error: 11
>> InnoDB: Check that you do not already have another mysqld process
>> InnoDB: using the same InnoDB data or log files.
> what does `ps -axlww | fgrep -i mysql` tell you?
>
> And
>
>> od -x ~/.local/share/akonadi/db_data/ibdata1
> doesn't show you a file with all zeroes I hope?
>
> Heh, looking at this on my end showed me I have 2 log files, ib_logfile0 and ib_logfile1 of equal size, more than 3x that of ibdata1 itself.
> Talk about redundancy!!
>
> R.
> _______________________________________________
> KDE PIM users mailing list
> Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users
>

dirk at azid:~> ps axlww | fgrep -i mysql
0  1000  5173     1  20   0 338732 31676 -      Sl   ?          1:10 
/usr/sbin/mysqld 
--defaults-file=/home/dirk/.local/share/akonadi/mysql.conf 
--datadir=/home/dirk/.local/share/akonadi/db_data/ 
--socket=/home/dirk/.local/share/akonadi/socket-azid/mysql.socket
0  1004 20637 20635  20   0 1514684 33888 ?     Sl   ?          0:56 
/usr/sbin/mysqld 
--defaults-file=/home/test/.local/share/akonadi/mysql.conf 
--datadir=/home/test/.local/share/akonadi/db_data/ 
--socket=/home/test/.local/share/akonadi/socket-azid/mysql.socket
0  1000 31853 16679  20   0   7880   864 pipe_w S+   pts/1      0:00 
fgrep --color=auto -i mysql


dirk at azid:~> od -x ~/.local/share/akonadi/db_data/ibdata1
shows a file looks like something like this:

snip

22440120 ffff ffff ffff ffff ffff ffff ffff ffff
*
22450100 ffff ffff ffff ffff 0000 0000 0000 0000
22450120 0000 0000 0000 0000 0000 0000 0000 0000
*
22477760 0000 0000 0000 0000 d98a f6a7 1700 caab
22500000 cb4f 9ae7 0000 2a01 0000 0000 0000 0000
22500020 0000 0000 1700 d3db 0600 0000 0000 0000
22500040 0000 0000 0000 ffff feff 0000 0000 0000
22500060 0000 ffff ffff 0000 ffff ffff 0000 0000
22500100 0000 0000 f300 b228 ffff ffff ffff ffff
22500120 ffff ffff ffff ffff ffff ffff ffff ffff
*
22510100 ffff ffff ffff ffff 0000 0000 0000 0000
22510120 0000 0000 0000 0000 0000 0000 0000 0000
*
22537760 0000 0000 0000 0000 6ebc 8d9e 1700 d3db
22540000 857e 9413 0000 2b01 0000 0000 0000 0000
22540020 0000 0000 1800 dc0b 0600 0000 0000 0000
22540040 0000 0000 0000 ffff feff 0000 0000 0000
22540060 0000 ffff ffff 0000 ffff ffff 0000 0000
22540100 0000 0000 f300 7229 ffff ffff ffff ffff
22540120 ffff ffff ffff ffff ffff ffff ffff ffff
*

snip

Does it help?

--
Dirk

_______________________________________________
KDE PIM users mailing list
Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users