[Bug 227131] New: Akonadi Crashes. Unable to create entire table

[Javier Olaechea]

https://bugs.kde.org/show_bug.cgi?id=227131

           Summary: Akonadi Crashes. Unable to create entire table
           Product: Akonadi
           Version: 4.4
          Platform: Archlinux Packages
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: crash
          Priority: NOR
         Component: general
        AssignedTo: vkrause at kde.org
        ReportedBy: pirata at gmail.com
                CC: kdepim-bugs at kde.org


Version:            (using KDE 4.4.0)
OS:                Linux
Installed from:    Archlinux Packages

[pirata at myhost ~]$ akonadictl start
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
Starting Akonadi Server...                                                      
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
   done.                                                                       
                       [akonadiserver] search paths:  ("/opt/opencascade/bin",
"/bin", "/usr/bin", "/sbin", "/usr/sbin", "/opt/kde/bin",
"/usr/bin/perlbin/site", "/usr/bin/perlbin/vendor", "/usr/bin/perlbin/core",
"/opt/qt/bin", "/usr/sbin", "/usr/local/sbin", "/usr/local/libexec",
"/usr/libexec", "/opt/mysql/libexec", "/opt/local/lib/mysql5/bin")              
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"                 
[akonadiserver] DbInitializer::run()                                            
[akonadiserver] checking table  "SchemaVersionTable"                            
[akonadiserver] checking table  "ResourceTable"                                 
[akonadiserver] checking table  "CollectionTable"                               
[akonadiserver] checking table  "MimeTypeTable"                                 
[akonadiserver] checking table  "PimItemTable"                                  
[akonadiserver] "CREATE TABLE PimItemTable (id BIGINT NOT NULL PRIMARY KEY
AUTO_INCREMENT, rev INTEGER NOT NULL DEFAULT 0, remoteId TEXT , collectionId
BIGINT  REFERENCES CollectionTable(id) ON DELETE CASCADE ON UPDATE CASCADE,
mimeTypeId BIGINT  REFERENCES MimeTypeTable(id) ON DELETE CASCADE ON UPDATE
CASCADE, datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, atime TIMESTAMP , dirty
BOOL , size BIGINT NOT NULL DEFAULT 0);"                                        
[akonadiserver] "Unable to create entire table.                                 
[akonadiserver] Query error: 'Invalid default value for 'atime' QMYSQL: Unable
to execute query'"                              
[akonadiserver] Unable to initialize database.                                  
[akonadiserver] "[                                                              
[akonadiserver] 0: akonadiserver(_Z11akBacktracev+0x39) [0x40b1c9]              
[akonadiserver] 1: akonadiserver() [0x40b712]                                   
[akonadiserver] 2: /lib/libc.so.6(+0x320b0) [0x7f89ed99a0b0]                    
[akonadiserver] 3: /lib/libc.so.6(gsignal+0x35) [0x7f89ed99a035]                
[akonadiserver] 4: /lib/libc.so.6(abort+0x180) [0x7f89ed99b460]                 
[akonadiserver] 5:
/usr/lib/libQtCore.so.4(_Z17qt_message_output9QtMsgTypePKc+0x6f)
[0x7f89eeb4631f]                           
[akonadiserver] 6: akonadiserver(_ZN15FileDebugStream9writeDataEPKcx+0xa8)
[0x40c758]                                          
[akonadiserver] 7: /usr/lib/libQtCore.so.4(_ZN9QIODevice5writeEPKcx+0x78)
[0x7f89eebd5e38]                                     
[akonadiserver] 8: /usr/lib/libQtCore.so.4(+0x10b5d9) [0x7f89eebe65d9]          
[akonadiserver] 9: /usr/lib/libQtCore.so.4(_ZN11QTextStreamD1Ev+0x39)
[0x7f89eebe77d9]                                         
[akonadiserver] 10: akonadiserver(_ZN6QDebugD1Ev+0x4e) [0x4067ce]               
[akonadiserver] 11:
/usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServerC1EP7QObject+0x5f7)
[0x7f89eefb4347]             
[akonadiserver] 12:
/usr/lib/libakonadiprivate.so.1(_ZN7Akonadi13AkonadiServer8instanceEv+0x4a)
[0x7f89eefb50ba]               
[akonadiserver] 13: akonadiserver(main+0x3ac) [0x405dec]                        
[akonadiserver] 14: /lib/libc.so.6(__libc_start_main+0xfd) [0x7f89ed986b6d]     
[akonadiserver] 15: akonadiserver() [0x405949]                                  
[akonadiserver] ]                                                               
[akonadiserver] "                                                               
ProcessControl: Application 'akonadiserver' returned with exit code 255
(Unknown error)  


I think The critical Part is
"
[akonadiserver] "CREATE TABLE PimItemTable (id BIGINT NOT NULL PRIMARY KEY
AUTO_INCREMENT, rev INTEGER NOT NULL DEFAULT 0, remoteId TEXT , collectionId
BIGINT  REFERENCES CollectionTable(id) ON DELETE CASCADE ON UPDATE CASCADE,
mimeTypeId BIGINT  REFERENCES MimeTypeTable(id) ON DELETE CASCADE ON UPDATE
CASCADE, datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP, atime TIMESTAMP , dirty
BOOL , size BIGINT NOT NULL DEFAULT 0);"                                        
[akonadiserver] "Unable to create entire table.                                 
[akonadiserver] Query error: 'Invalid default value for 'atime' QMYSQL: Unable
to execute query'"
"

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.