Bug#599384: akonadi-server: Query error: 'ERROR: column "version" of relation "schemaversiontable" already exists
Package: akonadi-server
Version: 1.3.1-3+b1
Severity: important
Hi,
akonadiserver never starts due to it trying to create a column in schemaversiontable
when it starts, 'version' column, and just exits instead of continuing on once it sees
it's there already. IME/IMO, it should just continue once it's sees this is the case,
and the schema is up to date. it should be noted i'm trying to use the postgresql driver.
partial conf:
=====
[%General]
Driver=QPSQL
SizeThreshold=4096
ExternalPayload=false
=====
error log:
=====
"Unable to add column 'version' to table 'SchemaVersionTable'.
Query error: 'ERROR: column "version" of relation "schemaversiontable" already exists
QPSQL: Unable to create query'"
Unable to initialize database.
"[
0: akonadiserver(_Z11akBacktracev+0x35) [0x8052255]
1: akonadiserver() [0x8052706]
2: [0xb78b6400]
3: [0xb78b6424]
4: /lib/i686/cmov/libc.so.6(gsignal+0x51) [0xb7150751]
5: /lib/i686/cmov/libc.so.6(abort+0x182) [0xb7153b82]
6: /usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x84) [0xb74e6264]
7: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xc4) [0x8053784]
8: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x8e) [0xb75802ae]
9: /usr/lib/libQtCore.so.4(+0x111fd5) [0xb758ffd5]
10: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x3d) [0xb75914fd]
11: akonadiserver(_ZN6QDebugD1Ev+0x43) [0x804dd93]
12: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x67a) [0xb77757da]
13: /usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x58) [0xb7776698]
14: akonadiserver(main+0x37c) [0x804d1dc]
15: /lib/i686/cmov/libc.so.6(__libc_start_main+0xe6) [0xb713cc76]
16: akonadiserver() [0x804cd91]
]
"
=====
(BTW, I was also getting this with the qt4 libs in sid, so that doesn't apply).
thanks
simon
-- System Information:
Debian Release: squeeze/sid
APT prefers unstable
APT policy: (995, 'unstable'), (990, 'experimental')
Architecture: i386 (i686)
Kernel: Linux 2.6.35.4-acahkos
Locale: LANG=en_CA.UTF-8, LC_CTYPE=en_CA.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages akonadi-server depends on:
ii libakonadiprivate1 1.3.1-3+b1 libraries for the Akonadi PIM stor
ii libboost-program-options1. 1.42.0-4 program options library for C++
ii libc6 2.11.2-6 Embedded GNU C Library: Shared lib
ii libgcc1 1:4.4.5-2 GCC support library
ii libqt4-dbus 4:4.7.0~rc1-1 Qt 4 D-Bus module
ii libqt4-sql-mysql 4:4.7.0~rc1-1 Qt 4 MySQL database driver
ii libqtcore4 4:4.7.0~rc1-1 Qt 4 core module
ii libstdc++6 4.4.5-2 The GNU Standard C++ Library v3
ii mysql-server-core-5.1 [mys 5.1.49-1 MySQL database server binaries
akonadi-server recommends no packages.
akonadi-server suggests no packages.
-- no debconf information
Reply to: