Application: akonadi_kcal_resource (0.1)
KDE Platform Version: 4.5.60 (KDE 4.5.60 (KDE 4.6 >= 20100627)) (Compiled from sources)
Qt Version: 4.7.0
Operating System: Linux 2.6.34-toi i686
Distribution: Debian GNU/Linux 5.0.5 (lenny)

-- Information about the crash:
I just updated to the last trunk version of kdesupport, kdelibs, kdebase and kdepimlibs. While using kdepim 4.4. After a system restart akonadi didn't start properly anymore without any changes on the configuration.

It complained about not possible to alter table:
DBUpdater: query error: "ERROR:  syntax error at or near "CONVERT"
LINE 1: ALTER TABLE CollectionAttributeTable CONVERT TO CHARACTER SE...
                                             ^
QPSQL: Unable to create query" " " 
Query was:  "ALTER TABLE CollectionAttributeTable CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE CollectionMimeTypeRelation CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE CollectionPimItemRelation CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE CollectionTable CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE FlagTable CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE MimeTypeTable CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE PartTable CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE PimItemFlagRelation CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE PimitemTable CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE ResourceTable CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
    ALTER TABLE SchemaVersionTable CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;" 
Target version was:  16 
Mandatory:  false 
Failed to commit transaction for database update 

I'm using posgresql backend.

- What I was doing when the application crashed:
Akonadi seems to work, but my calendar entries are all gone, hence I tried to reconfigure the calendar source by removing my previous calendar. When inserting the "new" one akonadi resource crashes all the time.

The crash can be reproduced every time.

-- Backtrace:
Application: Akonadi Resource (akonadi_kcal_resource), signal: Segmentation fault
[KCrash Handler]
#7  0xb7535794 in QBasicAtomicInt::ref (this=0xb0a48000) at /usr/include/qt4/QtCore/qatomic_i386.h:120
#8  0xb7535934 in QString (this=0xbfc34614, other=...) at /usr/include/qt4/QtCore/qstring.h:727
#9  0xb7534f6f in Akonadi::Entity::remoteId (this=0x8fb9654) at /media/kdesvn/kde4svn/src/kdepimlibs/akonadi/entity.cpp:85
#10 0xb75894c4 in Akonadi::CollectionSync::Private::createRemoteNode (this=0x91c4908, col=...) at /media/kdesvn/kde4svn/src/kdepimlibs/akonadi/collectionsync.cpp:148
#11 0xb75883da in Akonadi::CollectionSync::setRemoteCollections (this=0x8bb6c50, remoteCollections=...) at /media/kdesvn/kde4svn/src/kdepimlibs/akonadi/collectionsync.cpp:551
#12 0xb75fafbe in Akonadi::ResourceBase::collectionsRetrieved (this=0x8b98248, collections=...) at /media/kdesvn/kde4svn/src/kdepimlibs/akonadi/resourcebase.cpp:385
#13 0x080517f1 in KCalResource::retrieveCollections (this=0x8b98248) at /media/kdesvn/kde4svn/src/kdepim/runtime/resources/kcal/kcalresource.cpp:223
#14 0xb75fd242 in Akonadi::ResourceBase::qt_metacall (this=0x8b98248, _c=QMetaObject::InvokeMetaMethod, _id=2, _a=0xbfc3498c)
    at /media/kdesvn/kde4svn/build/kdepimlibs/akonadi/moc_resourcebase.cpp:111
#15 0x08055252 in KCalResource::qt_metacall (this=0x8b98248, _c=QMetaObject::InvokeMetaMethod, _id=23, _a=0xbfc3498c) at /media/kdesvn/kde4svn/build/kdepim/runtime/resources/kcal/kcalresource.moc:91
#16 0xb73742da in QMetaObject::metacall(QObject*, QMetaObject::Call, int, void**) () from /usr/lib/libQtCore.so.4
#17 0xb738384b in QMetaObject::activate(QObject*, QMetaObject const*, int, void**) () from /usr/lib/libQtCore.so.4
#18 0xb760135f in Akonadi::ResourceScheduler::executeFullSync (this=0x8ba6440) at /media/kdesvn/kde4svn/build/kdepimlibs/akonadi/resourcescheduler_p.moc:124
#19 0xb75ff4b7 in Akonadi::ResourceScheduler::executeNext (this=0x8ba6440) at /media/kdesvn/kde4svn/src/kdepimlibs/akonadi/resourcescheduler.cpp:241
#20 0xb7601319 in Akonadi::ResourceScheduler::qt_metacall (this=0x8ba6440, _c=QMetaObject::InvokeMetaMethod, _id=14, _a=0x92b19a8)
    at /media/kdesvn/kde4svn/build/kdepimlibs/akonadi/resourcescheduler_p.moc:113
#21 0xb73742da in QMetaObject::metacall(QObject*, QMetaObject::Call, int, void**) () from /usr/lib/libQtCore.so.4
#22 0xb737f6a6 in QMetaCallEvent::placeMetaCall(QObject*) () from /usr/lib/libQtCore.so.4
#23 0xb738088e in QObject::event(QEvent*) () from /usr/lib/libQtCore.so.4
#24 0xb5b44b6c in QApplicationPrivate::notify_helper(QObject*, QEvent*) () from /usr/lib/libQtGui.so.4
#25 0xb5b4c19e in QApplication::notify(QObject*, QEvent*) () from /usr/lib/libQtGui.so.4
#26 0xb68a31a6 in KApplication::notify (this=0xbfc35428, receiver=0x8ba6440, event=0x92b1978) at /media/kdesvn/kde4svn/src/kdelibs/kdeui/kernel/kapplication.cpp:309
#27 0xb736e55b in QCoreApplication::notifyInternal(QObject*, QEvent*) () from /usr/lib/libQtCore.so.4
#28 0xb73727e4 in QCoreApplicationPrivate::sendPostedEvents(QObject*, int, QThreadData*) () from /usr/lib/libQtCore.so.4
#29 0xb737295d in QCoreApplication::sendPostedEvents(QObject*, int) () from /usr/lib/libQtCore.so.4
#30 0xb739c69f in ?? () from /usr/lib/libQtCore.so.4
#31 0xb55c62f5 in g_main_context_dispatch () from /lib/libglib-2.0.so.0
#32 0xb55c9fd8 in ?? () from /lib/libglib-2.0.so.0
#33 0xb55ca1b8 in g_main_context_iteration () from /lib/libglib-2.0.so.0
#34 0xb739c195 in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib/libQtCore.so.4
#35 0xb5c04ee5 in ?? () from /usr/lib/libQtGui.so.4
#36 0xb736d039 in QEventLoop::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib/libQtCore.so.4
#37 0xb736d48a in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib/libQtCore.so.4
#38 0xb7372a1f in QCoreApplication::exec() () from /usr/lib/libQtCore.so.4
#39 0xb5b43c37 in QApplication::exec() () from /usr/lib/libQtGui.so.4
#40 0xb75f9d88 in Akonadi::ResourceBase::init (r=0x8b98248) at /media/kdesvn/kde4svn/src/kdepimlibs/akonadi/resourcebase.cpp:245
#41 0x080576ad in Akonadi::ResourceBase::init<KCalResource> (argc=3, argv=0xbfc35524) at /home/kde4/kde4.5/include/akonadi/resourcebase.h:186
#42 0x08055191 in main (argc=3, argv=0xbfc35524) at /media/kdesvn/kde4svn/src/kdepim/runtime/resources/kcal/kcalresource.cpp:690

Reported using DrKonqi