Beiträge von jjanarnava

/home/<user>/.local/share/akonadi/db_data/mysql.err


2015-01-12 10:48:38 7f3992d82740 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
150112 10:48:38 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150112 10:48:38 [Note] InnoDB: The InnoDB memory heap is disabled
150112 10:48:38 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150112 10:48:38 [Note] InnoDB: Compressed tables use zlib 1.2.8
150112 10:48:38 [Note] InnoDB: Using Linux native AIO
150112 10:48:38 [Note] InnoDB: Using CPU crc32 instructions
150112 10:48:38 [Note] InnoDB: Initializing buffer pool, size = 80.0M
150112 10:48:38 [Note] InnoDB: Completed initialization of buffer pool
150112 10:48:38 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
150112 10:48:38 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
150112 10:48:38 [Note] InnoDB: Retrying to lock the first data file
150112 10:48:39 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11
...

akonadictl start
Starting Akonadi Server... 
   done. 
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
psh@isis:~> search paths:  ("/home/psh/bin", "/usr/local/bin", "/usr/bin", "/bin", "/usr/bin/X11", "/usr/games", "/opt/kde3/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec", "/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin", "/opt/mysql/sbin") 
Found mysql_install_db:  "/usr/bin/mysql_install_db" 
Found mysqlcheck:  "/usr/bin/mysqlcheck" 
akonadi.collectionattributetable               	OK
akonadi.collectionmimetyperelation             	OK
akonadi.collectionpimitemrelation              	OK
akonadi.collectiontable                        	OK
akonadi.flagtable                              	OK
akonadi.mimetypetable                          	OK
akonadi.parttable                              	OK
akonadi.parttypetable                          	OK
akonadi.pimitemflagrelation                    	OK
akonadi.pimitemtable                           	OK
akonadi.pimitemtagrelation                     	OK
akonadi.resourcetable                          	OK
akonadi.schemaversiontable                     	OK
akonadi.tagattributetable                      	OK
akonadi.tagremoteidresourcerelationtable       	OK
akonadi.tagtable                               	OK
akonadi.tagtypetable                           	OK
mysql.columns_priv                             	OK
mysql.db                                       	OK
mysql.event                                    	OK
mysql.func                                     	OK
mysql.help_category                            	OK
mysql.help_keyword                             	OK
mysql.help_relation                            	OK
mysql.help_topic                               	OK
mysql.host                                     	OK
mysql.ndb_binlog_index                         	OK
mysql.plugin                                   	OK
mysql.proc                                     	OK
mysql.procs_priv                               	OK
mysql.proxies_priv                             	OK
mysql.servers                                  	OK
mysql.tables_priv                              	OK
mysql.time_zone                                	OK
mysql.time_zone_leap_second                    	OK
mysql.time_zone_name                           	OK
mysql.time_zone_transition                     	OK
mysql.time_zone_transition_type                	OK
mysql.user                                     	OK
MySQL version OK (required "5.1" , available "10.0" ) 
Database "akonadi" opened using driver "QMYSQL" 
DbInitializer::run() 
checking table  "SchemaVersionTable" 
checking table  "ResourceTable" 
checking table  "CollectionTable" 
checking table  "MimeTypeTable" 
checking table  "PimItemTable" 
checking table  "FlagTable" 
checking table  "PartTypeTable" 
checking table  "PartTable" 
checking table  "CollectionAttributeTable" 
checking table  "TagTypeTable" 
checking table  "TagTable" 
checking table  "TagAttributeTable" 
checking table  "TagRemoteIdResourceRelationTable" 
checking table  "PimItemFlagRelation" 
checking table  "PimItemTagRelation" 
checking table  "CollectionMimeTypeRelation" 
checking table  "CollectionPimItemRelation" 
DbInitializer::run() done 
skipping update 2 
skipping update 3 
skipping update 4 
skipping update 8 
skipping update 10 
skipping update 12 
skipping update 13 
skipping update 14 
skipping update 15 
skipping update 16 
skipping update 17 
skipping update 18 
skipping update 19 
skipping update 20 
skipping update 21 
skipping update 22 
skipping update 23 
skipping update 24 
skipping update 25 
skipping update 26 
skipping update 28 
Adding new foreign key constraints 
"ALTER TABLE PartTable ADD FOREIGN KEY (pimItemId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE" 
Updating index failed:  
Sql error: Cannot add or update a child row: a foreign key constraint fails (`akonadi`.`#sql-1797_4`, CONSTRAINT `#sql-1797_4_ibfk_1` FOREIGN KEY (`pimItemId`) REFERENCES `pimitemtable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) QMYSQL: Unable to execute query
Query: ALTER TABLE PartTable ADD FOREIGN KEY (pimItemId) REFERENCES PimItemTable(id) ON UPDATE CASCADE ON DELETE CASCADE 
""
Unable to initialize database.
"[
0: akonadiserver(_Z11akBacktracev+0x37) [0x46d747]
1: akonadiserver() [0x46d9a2]
2: /lib64/libc.so.6(+0x35200) [0x7fb102fce200]
3: /lib64/libc.so.6(gsignal+0x37) [0x7fb102fce187]
4: /lib64/libc.so.6(abort+0x118) [0x7fb102fcf538]
5: /usr/lib64/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x64) [0x7fb1047ce2b4]
6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0x9d) [0x46fb5d]
7: /usr/lib64/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0xb0) [0x7fb1048685b0]
8: /usr/lib64/libQtCore.so.4(+0x120bdd) [0x7fb104877bdd]
9: /usr/lib64/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x31) [0x7fb1048807c1]
10: akonadiserver(_ZN7Akonadi6Server13AkonadiServer4initEv+0x5fc) [0x47344c]
11: akonadiserver() [0x549836]
12: /usr/lib64/libQtCore.so.4(_ZN7QObject5eventEP6QEvent+0x24e) [0x7fb1048f259e]
13: /usr/lib64/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x6d) [0x7fb1048da2ad]
14: /usr/lib64/libQtCore.so.4(_ZN23QCoreApplicationPrivate16sendPostedEventsEP7QObjectiP11QThreadData+0x1ed) [0x7fb1048dd57d]
15: /usr/lib64/libQtCore.so.4(+0x1b08fe) [0x7fb1049078fe]
16: /usr/lib64/libglib-2.0.so.0(g_main_context_dispatch+0x254) [0x7fb10269fa04]
17: /usr/lib64/libglib-2.0.so.0(+0x4bc48) [0x7fb10269fc48]
18: /usr/lib64/libglib-2.0.so.0(g_main_context_iteration+0x2c) [0x7fb10269fcec]
19: /usr/lib64/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x7e) [0x7fb1049070be]
20: /usr/lib64/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x2f) [0x7fb1048d8e6f]
21: /usr/lib64/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x175) [0x7fb1048d9165]
22: /usr/lib64/libQtCore.so.4(_ZN16QCoreApplication4execEv+0x89) [0x7fb1048de5b9]
23: akonadiserver(main+0x1ce) [0x4670ae]
24: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7fb102fbab05]
25: akonadiserver() [0x46789e]
]
"
...