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@kde.org
Reporter: i...@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.
_______________________________________________
Kdepim-bugs mailing list
Kdepim-bugs@kde.org
https://mail.kde.org/mailman/listinfo/kdepim-bugs
