[Akonadi] [Bug 323977] New: information_schema.REFERENTIAL_CONSTRAINTS errors in akonadi server log

Geert Janssens info at kobaltwit.be
Sat Aug 24 18:09:32 BST 2013 

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

            Bug ID: 323977
           Summary: information_schema.REFERENTIAL_CONSTRAINTS errors in
                    akonadi server log
    Classification: Unclassified
           Product: Akonadi
           Version: 1.10.2
          Platform: Fedora RPMs
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: server
          Assignee: kdepim-bugs at kde.org
          Reporter: info at kobaltwit.be

Whenever akonadi starts, it generates a series of errors in the server log:
Error during executing query "SELECT
information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME,
information_schema.KEY_COLUMN_USAGE.COLUMN_NAME,
information_schema.KEY_COLUMN_USAGE.REFERENCED_TABLE_NAME,
information_schema.KEY_COLUMN_USAGE.REFERENCED_COLUMN_NAME,
information_schema.REFERENTIAL_CONSTRAINTS.UPDATE_RULE,
information_schema.REFERENTIAL_CONSTRAINTS.DELETE_RULE FROM
information_schema.REFERENTIAL_CONSTRAINTS INNER JOIN
information_schema.KEY_COLUMN_USAGE ON (
information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME =
information_schema.KEY_COLUMN_USAGE.CONSTRAINT_NAME ) WHERE (
information_schema.KEY_COLUMN_USAGE.TABLE_SCHEMA = ( :0 ) AND
information_schema.KEY_COLUMN_USAGE.TABLE_NAME = ( :1 ) )" :  "Unknown table
'REFERENTIAL_CONSTRAINTS' in information_schema QMYSQL: Unable to execute
query" 
Error during executing query "SELECT
information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME,
information_schema.KEY_COLUMN_USAGE.COLUMN_NAME,
information_schema.KEY_COLUMN_USAGE.REFERENCED_TABLE_NAME,
information_schema.KEY_COLUMN_USAGE.REFERENCED_COLUMN_NAME,
information_schema.REFERENTIAL_CONSTRAINTS.UPDATE_RULE,
information_schema.REFERENTIAL_CONSTRAINTS.DELETE_RULE FROM
information_schema.REFERENTIAL_CONSTRAINTS INNER JOIN
information_schema.KEY_COLUMN_USAGE ON (
information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME =
information_schema.KEY_COLUMN_USAGE.CONSTRAINT_NAME ) WHERE (
information_schema.KEY_COLUMN_USAGE.TABLE_SCHEMA = ( :0 ) AND
information_schema.KEY_COLUMN_USAGE.TABLE_NAME = ( :1 ) )" :  "Unknown table
'REFERENTIAL_CONSTRAINTS' in information_schema QMYSQL: Unable to execute
query" 
Error during executing query "SELECT
information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME,
information_schema.KEY_COLUMN_USAGE.COLUMN_NAME,
information_schema.KEY_COLUMN_USAGE.REFERENCED_TABLE_NAME,
information_schema.KEY_COLUMN_USAGE.REFERENCED_COLUMN_NAME,
information_schema.REFERENTIAL_CONSTRAINTS.UPDATE_RULE,
information_schema.REFERENTIAL_CONSTRAINTS.DELETE_RULE FROM
information_schema.REFERENTIAL_CONSTRAINTS INNER JOIN
information_schema.KEY_COLUMN_USAGE ON (
information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME =
information_schema.KEY_COLUMN_USAGE.CONSTRAINT_NAME ) WHERE (
information_schema.KEY_COLUMN_USAGE.TABLE_SCHEMA = ( :0 ) AND
information_schema.KEY_COLUMN_USAGE.TABLE_NAME = ( :1 ) )" :  "Unknown table
'REFERENTIAL_CONSTRAINTS' in information_schema QMYSQL: Unable to execute
query" 
Error during executing query "SELECT
information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME,
information_schema.KEY_COLUMN_USAGE.COLUMN_NAME,
information_schema.KEY_COLUMN_USAGE.REFERENCED_TABLE_NAME,
information_schema.KEY_COLUMN_USAGE.REFERENCED_COLUMN_NAME,
information_schema.REFERENTIAL_CONSTRAINTS.UPDATE_RULE,
information_schema.REFERENTIAL_CONSTRAINTS.DELETE_RULE FROM
information_schema.REFERENTIAL_CONSTRAINTS INNER JOIN
information_schema.KEY_COLUMN_USAGE ON (
information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME =
information_schema.KEY_COLUMN_USAGE.CONSTRAINT_NAME ) WHERE (
information_schema.KEY_COLUMN_USAGE.TABLE_SCHEMA = ( :0 ) AND
information_schema.KEY_COLUMN_USAGE.TABLE_NAME = ( :1 ) )" :  "Unknown table
'REFERENTIAL_CONSTRAINTS' in information_schema QMYSQL: Unable to execute
query" 
Error during executing query "SELECT
information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME,
information_schema.KEY_COLUMN_USAGE.COLUMN_NAME,
information_schema.KEY_COLUMN_USAGE.REFERENCED_TABLE_NAME,
information_schema.KEY_COLUMN_USAGE.REFERENCED_COLUMN_NAME,
information_schema.REFERENTIAL_CONSTRAINTS.UPDATE_RULE,
information_schema.REFERENTIAL_CONSTRAINTS.DELETE_RULE FROM
information_schema.REFERENTIAL_CONSTRAINTS INNER JOIN
information_schema.KEY_COLUMN_USAGE ON (
information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME =
information_schema.KEY_COLUMN_USAGE.CONSTRAINT_NAME ) WHERE (
information_schema.KEY_COLUMN_USAGE.TABLE_SCHEMA = ( :0 ) AND
information_schema.KEY_COLUMN_USAGE.TABLE_NAME = ( :1 ) )" :  "Unknown table
'REFERENTIAL_CONSTRAINTS' in information_schema QMYSQL: Unable to execute
query" 
Error during executing query "SELECT
information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME,
information_schema.KEY_COLUMN_USAGE.COLUMN_NAME,
information_schema.KEY_COLUMN_USAGE.REFERENCED_TABLE_NAME,
information_schema.KEY_COLUMN_USAGE.REFERENCED_COLUMN_NAME,
information_schema.REFERENTIAL_CONSTRAINTS.UPDATE_RULE,
information_schema.REFERENTIAL_CONSTRAINTS.DELETE_RULE FROM
information_schema.REFERENTIAL_CONSTRAINTS INNER JOIN
information_schema.KEY_COLUMN_USAGE ON (
information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME =
information_schema.KEY_COLUMN_USAGE.CONSTRAINT_NAME ) WHERE (
information_schema.KEY_COLUMN_USAGE.TABLE_SCHEMA = ( :0 ) AND
information_schema.KEY_COLUMN_USAGE.TABLE_NAME = ( :1 ) )" :  "Unknown table
'REFERENTIAL_CONSTRAINTS' in information_schema QMYSQL: Unable to execute
query" 
Error during executing query "SELECT
information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME,
information_schema.KEY_COLUMN_USAGE.COLUMN_NAME,
information_schema.KEY_COLUMN_USAGE.REFERENCED_TABLE_NAME,
information_schema.KEY_COLUMN_USAGE.REFERENCED_COLUMN_NAME,
information_schema.REFERENTIAL_CONSTRAINTS.UPDATE_RULE,
information_schema.REFERENTIAL_CONSTRAINTS.DELETE_RULE FROM
information_schema.REFERENTIAL_CONSTRAINTS INNER JOIN
information_schema.KEY_COLUMN_USAGE ON (
information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME =
information_schema.KEY_COLUMN_USAGE.CONSTRAINT_NAME ) WHERE (
information_schema.KEY_COLUMN_USAGE.TABLE_SCHEMA = ( :0 ) AND
information_schema.KEY_COLUMN_USAGE.TABLE_NAME = ( :1 ) )" :  "Unknown table
'REFERENTIAL_CONSTRAINTS' in information_schema QMYSQL: Unable to execute
query" 
Error during executing query "SELECT
information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME,
information_schema.KEY_COLUMN_USAGE.COLUMN_NAME,
information_schema.KEY_COLUMN_USAGE.REFERENCED_TABLE_NAME,
information_schema.KEY_COLUMN_USAGE.REFERENCED_COLUMN_NAME,
information_schema.REFERENTIAL_CONSTRAINTS.UPDATE_RULE,
information_schema.REFERENTIAL_CONSTRAINTS.DELETE_RULE FROM
information_schema.REFERENTIAL_CONSTRAINTS INNER JOIN
information_schema.KEY_COLUMN_USAGE ON (
information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME =
information_schema.KEY_COLUMN_USAGE.CONSTRAINT_NAME ) WHERE (
information_schema.KEY_COLUMN_USAGE.TABLE_SCHEMA = ( :0 ) AND
information_schema.KEY_COLUMN_USAGE.TABLE_NAME = ( :1 ) )" :  "Unknown table
'REFERENTIAL_CONSTRAINTS' in information_schema QMYSQL: Unable to execute
query" 
Error during executing query "SELECT
information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME,
information_schema.KEY_COLUMN_USAGE.COLUMN_NAME,
information_schema.KEY_COLUMN_USAGE.REFERENCED_TABLE_NAME,
information_schema.KEY_COLUMN_USAGE.REFERENCED_COLUMN_NAME,
information_schema.REFERENTIAL_CONSTRAINTS.UPDATE_RULE,
information_schema.REFERENTIAL_CONSTRAINTS.DELETE_RULE FROM
information_schema.REFERENTIAL_CONSTRAINTS INNER JOIN
information_schema.KEY_COLUMN_USAGE ON (
information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME =
information_schema.KEY_COLUMN_USAGE.CONSTRAINT_NAME ) WHERE (
information_schema.KEY_COLUMN_USAGE.TABLE_SCHEMA = ( :0 ) AND
information_schema.KEY_COLUMN_USAGE.TABLE_NAME = ( :1 ) )" :  "Unknown table
'REFERENTIAL_CONSTRAINTS' in information_schema QMYSQL: Unable to execute
query" 
Error during executing query "SELECT
information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME,
information_schema.KEY_COLUMN_USAGE.COLUMN_NAME,
information_schema.KEY_COLUMN_USAGE.REFERENCED_TABLE_NAME,
information_schema.KEY_COLUMN_USAGE.REFERENCED_COLUMN_NAME,
information_schema.REFERENTIAL_CONSTRAINTS.UPDATE_RULE,
information_schema.REFERENTIAL_CONSTRAINTS.DELETE_RULE FROM
information_schema.REFERENTIAL_CONSTRAINTS INNER JOIN
information_schema.KEY_COLUMN_USAGE ON (
information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME =
information_schema.KEY_COLUMN_USAGE.CONSTRAINT_NAME ) WHERE (
information_schema.KEY_COLUMN_USAGE.TABLE_SCHEMA = ( :0 ) AND
information_schema.KEY_COLUMN_USAGE.TABLE_NAME = ( :1 ) )" :  "Unknown table
'REFERENTIAL_CONSTRAINTS' in information_schema QMYSQL: Unable to execute
query" 
Error during executing query "SELECT
information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME,
information_schema.KEY_COLUMN_USAGE.COLUMN_NAME,
information_schema.KEY_COLUMN_USAGE.REFERENCED_TABLE_NAME,
information_schema.KEY_COLUMN_USAGE.REFERENCED_COLUMN_NAME,
information_schema.REFERENTIAL_CONSTRAINTS.UPDATE_RULE,
information_schema.REFERENTIAL_CONSTRAINTS.DELETE_RULE FROM
information_schema.REFERENTIAL_CONSTRAINTS INNER JOIN
information_schema.KEY_COLUMN_USAGE ON (
information_schema.REFERENTIAL_CONSTRAINTS.CONSTRAINT_NAME =
information_schema.KEY_COLUMN_USAGE.CONSTRAINT_NAME ) WHERE (
information_schema.KEY_COLUMN_USAGE.TABLE_SCHEMA = ( :0 ) AND
information_schema.KEY_COLUMN_USAGE.TABLE_NAME = ( :1 ) )" :  "Unknown table
'REFERENTIAL_CONSTRAINTS' in information_schema QMYSQL: Unable to execute
query" 

Apart from this, akonadi seems to work ok.

It may be relevant that I am using a real database server as backend:
Centos 5 with mysql-server-5.0.95-5.el5_9

Reproducible: Always

Steps to Reproduce:
1. Set up a Centos 5 server with mysql version 5.0.95
2. Configure akonadi to use that server as backend
3. Start akonadi
Actual Results:  
The errors presented above.

Expected Results:  
No errors

-- 
You are receiving this mail because:
You are the assignee for the bug.

More information about the Kdepim-bugs mailing list