Ticket #33998: akonadi-selftest-report-20121017.txt

File akonadi-selftest-report-20121017.txt, 17.0 KB (added by mparchet@…, 12 years ago)
Line 
1Akonadi Server Self-Test Report
2===============================
3
4Test 1:  ERROR
5--------
6
7Database driver not found.
8Details: The QtSQL driver 'QMYSQL' is required by your current Akonadi server configuration.
9The following drivers are installed: QSQLITE.
10Make sure the required driver is installed.
11
12File content of '/Users/rparchet/.config/akonadi/akonadiserverrc':
13[%General]
14Driver=QMYSQL
15
16[QMYSQL]
17Name=akonadi
18Host=
19Options="UNIX_SOCKET=/Users/rparchet/.local/share/akonadi/socket-MacBook-Pro-de-Michael.local/mysql.socket"
20ServerPath=/opt/local/libexec/mysqld
21StartServer=true
22
23
24Test 2:  SUCCESS
25--------
26
27Akonadi is not running as root
28Details: Akonadi is not running as a root/administrator user, which is the recommended setup for a secure system.
29
30Test 3:  SUCCESS
31--------
32
33MySQL server found.
34Details: You have currently configured Akonadi to use the MySQL server '/opt/local/libexec/mysqld'.
35Make sure you have the MySQL server installed, set the correct path and ensure you have the necessary read and execution rights on the server executable. The server executable is typically called 'mysqld'; its location varies depending on the distribution.
36
37Test 4:  SUCCESS
38--------
39
40MySQL server is executable.
41Details: MySQL server found: /opt/local/libexec/mysqld  Ver 5.1.66 for apple-darwin12.2.0 on i386 (Source distribution)
42
43
44Test 5:  ERROR
45--------
46
47MySQL server log contains errors.
48Details: The MySQL server error log file &apos;<a href='/Users/rparchet/.local/share/akonadi/db_data/mysql.err'>/Users/rparchet/.local/share/akonadi/db_data/mysql.err</a>&apos; contains errors.
49
50File content of '/Users/rparchet/.local/share/akonadi/db_data/mysql.err':
51120713 18:56:48 [ERROR] mysqld: Can't lock aria control file '/Users/rparchet/.local/share/akonadi/db_data/aria_log_control' for exclusive use, error: 35. Will retry for 30 seconds
52120713 18:56:49 [Note] PrimeBase XT (PBXT) Engine 1.0.11-7 Pre-GA loaded...
53120713 18:56:49 [Note] Paul McCullagh, PrimeBase Technologies GmbH, http://www.primebase.org
54InnoDB: The InnoDB memory heap is disabled
55InnoDB: Mutexes and rw_locks use GCC atomic builtins
56InnoDB: Compressed tables use zlib 1.2.3
57120713 18:56:49  InnoDB: Initializing buffer pool, size = 80.0M
58120713 18:56:49  InnoDB: Completed initialization of buffer pool
59120713 18:56:49  InnoDB: highest supported file format is Barracuda.
60InnoDB: No valid checkpoint found.
61InnoDB: If this error appears when you are creating an InnoDB database,
62InnoDB: the problem may be that during an earlier attempt you managed
63InnoDB: to create the InnoDB data files, but log file creation failed.
64InnoDB: If that is the case, please refer to
65InnoDB: http://dev.mysql.com/doc/refman/5.1/en/error-creating-innodb.html
66120713 18:56:49 [ERROR] Plugin 'InnoDB' init function returned error.
67120713 18:56:49 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
68120713 18:56:49 [ERROR] Failed to initialize plugins.
69120713 18:56:49 [ERROR] Aborting
70
71120713 18:56:49 [Note] PrimeBase XT Engine shutdown...
72120713 18:56:49 [Note] /opt/local/libexec/mysqld: Shutdown complete
73
74
75
76Test 6:  SUCCESS
77--------
78
79MySQL server default configuration found.
80Details: The default configuration for the MySQL server was found and is readable at <a href='/opt/local/share/config/akonadi/mysql-global.conf'>/opt/local/share/config/akonadi/mysql-global.conf</a>.
81
82File content of '/opt/local/share/config/akonadi/mysql-global.conf':
83#
84# Global Akonadi MySQL server settings,
85# These settings can be adjusted using $HOME/.config/akonadi/mysql-local.conf
86#
87# Based on advice by Kris Köhntopp <kris@mysql.com>
88#
89[mysqld]
90
91# strict query parsing/interpretation
92# TODO: make Akonadi work with those settings enabled
93# sql_mode=strict_trans_tables,strict_all_tables,strict_error_for_division_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zero_date,no_zero_in_date,only_full_group_by,pipes_as_concat
94# sql_mode=strict_trans_tables
95
96# DEBUGGING:
97# log all queries, useful for debugging but generates an enormous amount of data
98# log=mysql.full
99# log queries slower than n seconds, log file name relative to datadir (for debugging only)
100# log_slow_queries=mysql.slow
101# long_query_time=1
102# log queries not using indices, debug only, disable for production use
103# log_queries_not_using_indexes=1
104#
105# mesure database size and adjust innodb_buffer_pool_size
106# SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");
107
108# NOTES:
109# Keep Innob_log_waits and keep Innodb_buffer_pool_wait_free small (see show global status like "inno%", show global variables)
110
111#expire_logs_days=3
112
113#sync_bin_log=0
114
115# Use UTF-8 encoding for tables
116character_set_server=utf8
117collation_server=utf8_general_ci
118
119# use InnoDB for transactions and better crash recovery
120default_storage_engine=innodb
121
122# memory pool InnoDB uses to store data dictionary information and other internal data structures (default:1M)
123innodb_additional_mem_pool_size=1M
124
125# memory buffer InnoDB uses to cache data and indexes of its tables (default:128M)
126# Larger values means less I/O
127innodb_buffer_pool_size=80M
128
129# Create a .ibd file for each table (default:0)
130innodb_file_per_table=1
131
132# Write out the log buffer to the log file at each commit (default:1)
133innodb_flush_log_at_trx_commit=2
134
135# Buffer size used to write to the log files on disk (default:1M for builtin, 8M for plugin)
136# larger values means less I/O
137innodb_log_buffer_size=1M
138
139# Size of each log file in a log group (default:5M) larger means less I/O but more time for recovery.
140innodb_log_file_size=64M
141
142# # error log file name, relative to datadir (default:hostname.err)
143log_error=mysql.err
144
145# print warnings and connection errors (default:1)
146log_warnings=2
147
148# Convert table named to lowercase
149lower_case_table_names=1
150
151# Maximum size of one packet or any generated/intermediate string. (default:1M)
152max_allowed_packet=32M
153
154# Maximum simultaneous connections allowed (default:100)
155max_connections=256
156
157# The two options below make no sense with prepared statements and/or transactions
158# (make sense when having the same query multiple times)
159
160# Memory allocated for caching query results (default:0 (disabled))
161query_cache_size=0
162
163# Do not cache results (default:1)
164query_cache_type=0
165
166# Do not use the privileges mechanisms
167skip_grant_tables
168
169# Do not listen for TCP/IP connections at all
170skip_networking
171
172# The number of open tables for all threads. (default:64)
173table_cache=200
174
175# How many threads the server should cache for reuse (default:0)
176thread_cache_size=3
177
178# wait 365d before dropping the DB connection (default:8h)
179wait_timeout=31536000
180
181[client]
182default-character-set=utf8
183
184
185Test 7:  SKIP
186--------
187
188MySQL server custom configuration not available.
189Details: The custom configuration for the MySQL server was not found but is optional.
190
191Test 8:  SUCCESS
192--------
193
194MySQL server configuration is usable.
195Details: The MySQL server configuration was found at <a href='/Users/rparchet/.local/share/akonadi/mysql.conf'>/Users/rparchet/.local/share/akonadi/mysql.conf</a> and is readable.
196
197File content of '/Users/rparchet/.local/share/akonadi/mysql.conf':
198#
199# Global Akonadi MySQL server settings,
200# These settings can be adjusted using $HOME/.config/akonadi/mysql-local.conf
201#
202# Based on advice by Kris Köhntopp <kris@mysql.com>
203#
204[mysqld]
205
206# strict query parsing/interpretation
207# TODO: make Akonadi work with those settings enabled
208# sql_mode=strict_trans_tables,strict_all_tables,strict_error_for_division_by_zero,no_auto_create_user,no_auto_value_on_zero,no_engine_substitution,no_zero_date,no_zero_in_date,only_full_group_by,pipes_as_concat
209# sql_mode=strict_trans_tables
210
211# DEBUGGING:
212# log all queries, useful for debugging but generates an enormous amount of data
213# log=mysql.full
214# log queries slower than n seconds, log file name relative to datadir (for debugging only)
215# log_slow_queries=mysql.slow
216# long_query_time=1
217# log queries not using indices, debug only, disable for production use
218# log_queries_not_using_indexes=1
219#
220# mesure database size and adjust innodb_buffer_pool_size
221# SELECT sum(data_length) as bla, sum(index_length) as blub FROM information_schema.tables WHERE table_schema not in ("mysql", "information_schema");
222
223# NOTES:
224# Keep Innob_log_waits and keep Innodb_buffer_pool_wait_free small (see show global status like "inno%", show global variables)
225
226#expire_logs_days=3
227
228#sync_bin_log=0
229
230# Use UTF-8 encoding for tables
231character_set_server=utf8
232collation_server=utf8_general_ci
233
234# use InnoDB for transactions and better crash recovery
235default_storage_engine=innodb
236
237# memory pool InnoDB uses to store data dictionary information and other internal data structures (default:1M)
238innodb_additional_mem_pool_size=1M
239
240# memory buffer InnoDB uses to cache data and indexes of its tables (default:128M)
241# Larger values means less I/O
242innodb_buffer_pool_size=80M
243
244# Create a .ibd file for each table (default:0)
245innodb_file_per_table=1
246
247# Write out the log buffer to the log file at each commit (default:1)
248innodb_flush_log_at_trx_commit=2
249
250# Buffer size used to write to the log files on disk (default:1M for builtin, 8M for plugin)
251# larger values means less I/O
252innodb_log_buffer_size=1M
253
254# Size of each log file in a log group (default:5M) larger means less I/O but more time for recovery.
255innodb_log_file_size=64M
256
257# # error log file name, relative to datadir (default:hostname.err)
258log_error=mysql.err
259
260# print warnings and connection errors (default:1)
261log_warnings=2
262
263# Convert table named to lowercase
264lower_case_table_names=1
265
266# Maximum size of one packet or any generated/intermediate string. (default:1M)
267max_allowed_packet=32M
268
269# Maximum simultaneous connections allowed (default:100)
270max_connections=256
271
272# The two options below make no sense with prepared statements and/or transactions
273# (make sense when having the same query multiple times)
274
275# Memory allocated for caching query results (default:0 (disabled))
276query_cache_size=0
277
278# Do not cache results (default:1)
279query_cache_type=0
280
281# Do not use the privileges mechanisms
282skip_grant_tables
283
284# Do not listen for TCP/IP connections at all
285skip_networking
286
287# The number of open tables for all threads. (default:64)
288table_cache=200
289
290# How many threads the server should cache for reuse (default:0)
291thread_cache_size=3
292
293# wait 365d before dropping the DB connection (default:8h)
294wait_timeout=31536000
295
296[client]
297default-character-set=utf8
298
299
300Test 9:  SUCCESS
301--------
302
303akonadictl found and usable
304Details: The program '/opt/local/bin/akonadictl' to control the Akonadi server was found and could be executed successfully.
305Result:
306Akonadi 1.7.2
307
308
309Test 10:  ERROR
310--------
311
312Akonadi control process not registered at D-Bus.
313Details: The Akonadi control process is not registered at D-Bus which typically means it was not started or encountered a fatal error during startup.
314
315Test 11:  ERROR
316--------
317
318Akonadi server process not registered at D-Bus.
319Details: The Akonadi server process is not registered at D-Bus which typically means it was not started or encountered a fatal error during startup.
320
321Test 12:  ERROR
322--------
323
324Nepomuk search service not registered at D-Bus.
325Details: The Nepomuk search service is not registered at D-Bus which typically means it was not started or encountered a fatal error during startup.
326
327Test 13:  SKIP
328--------
329
330Protocol version check not possible.
331Details: Without a connection to the server it is not possible to check if the protocol version meets the requirements.
332
333Test 14:  ERROR
334--------
335
336No resource agents found.
337Details: No resource agents have been found, Akonadi is not usable without at least one. This usually means that no resource agents are installed or that there is a setup problem. The following paths have been searched: '/opt/local/share/akonadi/agents'. The XDG_DATA_DIRS environment variable is set to ''; make sure this includes all paths where Akonadi agents are installed.
338
339Directory listing of '/opt/local/share/akonadi/agents':
340akonadinepomukfeederagent.desktop
341akonotesresource.desktop
342birthdaysresource.desktop
343calendarsearchagent.desktop
344contactsresource.desktop
345davgroupwareresource.desktop
346icalresource.desktop
347imapresource.desktop
348invitationsagent.desktop
349kabcresource.desktop
350kalarmdirresource.desktop
351kalarmresource.desktop
352kcalresource.desktop
353kdeaccountsresource.desktop
354knutresource.desktop
355kolabproxyresource.desktop
356localbookmarksresource.desktop
357maildirresource.desktop
358maildispatcheragent.desktop
359mailfilteragent.desktop
360mboxresource.desktop
361microblog.desktop
362mixedmaildirresource.desktop
363mtdummyresource.desktop
364nepomuktagresource.desktop
365nntpresource.desktop
366notesresource.desktop
367openxchangeresource.desktop
368pop3resource.desktop
369vcarddirresource.desktop
370vcardresource.desktop
371
372Environment variable XDG_DATA_DIRS is set to ''
373
374Test 15:  ERROR
375--------
376
377Current Akonadi server error log found.
378Details: The Akonadi server reported errors during its current startup. The log can be found in <a href='/Users/rparchet/.local/share/akonadi/akonadiserver.error'>/Users/rparchet/.local/share/akonadi/akonadiserver.error</a>.
379
380File content of '/Users/rparchet/.local/share/akonadi/akonadiserver.error':
381Invalid database object during database server startup
382"[
3830: 0   akonadiserver                       0x00000001097dc07b _Z11akBacktracev + 75
3841: 1   akonadiserver                       0x00000001097dc3c6 _ZL19defaultCrashHandleri + 86
3852: 2   libsystem_c.dylib                   0x00007fff948dfcfa _sigtramp + 26
3863: 3   ???                                 0x00007fff693d1908 0x0 + 140734958999816
3874: 4   libsystem_c.dylib                   0x00007fff9487ea7a abort + 143
3885: 5   libQtCore.4.dylib                   0x00000001099a6e25 _Z17qt_message_output9QtMsgTypePKc + 149
3896: 6   akonadiserver                       0x00000001097ddd8f _ZN15FileDebugStream9writeDataEPKcx + 159
3907: 7   libQtCore.4.dylib                   0x0000000109a3ad85 _ZN9QIODevice5writeEPKcx + 207
3918: 8   libQtCore.4.dylib                   0x0000000109a43e3f _ZN18QTextStreamPrivate16flushWriteBufferEv + 201
3929: 9   libQtCore.4.dylib                   0x0000000109a44cef _ZN11QTextStreamD2Ev + 51
39310: 10  akonadiserver                       0x00000001097d7b47 _ZN6QDebugD2Ev + 247
39411: 11  akonadiserver                       0x0000000109852625 _ZN13DbConfigMysql19startInternalServerEv + 6357
39512: 12  akonadiserver                       0x00000001097e0084 _ZN7Akonadi13AkonadiServer20startDatabaseProcessEv + 228
39613: 13  akonadiserver                       0x00000001097df055 _ZN7Akonadi13AkonadiServerC2EP7QObject + 181
39714: 14  akonadiserver                       0x00000001097e138a _ZN7Akonadi13AkonadiServer8instanceEv + 42
39815: 15  akonadiserver                       0x00000001097d6e26 main + 614
39916: 16  akonadiserver                       0x00000001097d6b84 start + 52
40017: 17  ???                                 0x0000000000000001 0x0 + 1
401]
402"
403
404
405Test 16:  ERROR
406--------
407
408Previous Akonadi server error log found.
409Details: The Akonadi server reported errors during its previous startup. The log can be found in <a href='/Users/rparchet/.local/share/akonadi/akonadiserver.error.old'>/Users/rparchet/.local/share/akonadi/akonadiserver.error.old</a>.
410
411File content of '/Users/rparchet/.local/share/akonadi/akonadiserver.error.old':
412Invalid database object during database server startup
413"[
4140: 0   akonadiserver                       0x000000010d9a507b _Z11akBacktracev + 75
4151: 1   akonadiserver                       0x000000010d9a53c6 _ZL19defaultCrashHandleri + 86
4162: 2   libsystem_c.dylib                   0x00007fff948dfcfa _sigtramp + 26
4173: 3   ???                                 0x00007fff6d59a908 0x0 + 140735027980552
4184: 4   libsystem_c.dylib                   0x00007fff9487ea7a abort + 143
4195: 5   libQtCore.4.dylib                   0x000000010db70e25 _Z17qt_message_output9QtMsgTypePKc + 149
4206: 6   akonadiserver                       0x000000010d9a6d8f _ZN15FileDebugStream9writeDataEPKcx + 159
4217: 7   libQtCore.4.dylib                   0x000000010dc04d85 _ZN9QIODevice5writeEPKcx + 207
4228: 8   libQtCore.4.dylib                   0x000000010dc0de3f _ZN18QTextStreamPrivate16flushWriteBufferEv + 201
4239: 9   libQtCore.4.dylib                   0x000000010dc0ecef _ZN11QTextStreamD2Ev + 51
42410: 10  akonadiserver                       0x000000010d9a0b47 _ZN6QDebugD2Ev + 247
42511: 11  akonadiserver                       0x000000010da1b625 _ZN13DbConfigMysql19startInternalServerEv + 6357
42612: 12  akonadiserver                       0x000000010d9a9084 _ZN7Akonadi13AkonadiServer20startDatabaseProcessEv + 228
42713: 13  akonadiserver                       0x000000010d9a8055 _ZN7Akonadi13AkonadiServerC2EP7QObject + 181
42814: 14  akonadiserver                       0x000000010d9aa38a _ZN7Akonadi13AkonadiServer8instanceEv + 42
42915: 15  akonadiserver                       0x000000010d99fe26 main + 614
43016: 16  akonadiserver                       0x000000010d99fb84 start + 52
43117: 17  ???                                 0x0000000000000001 0x0 + 1
432]
433"
434
435
436Test 17:  SUCCESS
437--------
438
439No current Akonadi control error log found.
440Details: The Akonadi control process did not report any errors during its current startup.
441
442Test 18:  SUCCESS
443--------
444
445No previous Akonadi control error log found.
446Details: The Akonadi control process did not report any errors during its previous startup.
447