[digikam] [Bug 364762] New: Invalid mysql configuration option table_cache

[bugzilla_noreply]

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

            Bug ID: 364762
           Summary: Invalid mysql configuration option table_cache
           Product: digikam
           Version: 5.0.0
          Platform: Compiled Sources
               URL: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=8087
                    29
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: Database-Mysql
          Assignee: [hidden email]
          Reporter: [hidden email]

As reported by a Debian user: mysql-global.conf uses an unsupported option that
causes the db server to not start at all.  

In MySQL 5.1.3, the variable table_cache was renamed to table_open_cache.  For
several releases, both names worked, but starting in 5.6, it seems the older
name is completely removed.  Quoting https://bugs.mysql.com/bug.php?id=68315 :


This change was documneted in 5.1.3 change log -
http://dev.mysql.com/doc/relnotes/mysql/5.1/en/news-5-1-3.html
and http://dev.mysql.com/doc/refman/5.1/en/upgrading-from-previous-series.html

See, Incompatible Change: Renamed the table_cache system variable to
table_open_cache. Any scripts that refer to table_cache should be updated to
use the new name.

Also, table_cache is the old name of table_open_cache before MySQL 5.1.3. From
5.1.3 on, use table_open_cache instead.

http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_table_cache



Reproducible: Always

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[bugzilla_noreply]

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

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[hidden email],
                   |                            |[hidden email],
                   |                            |[hidden email]

--- Comment #1 from [hidden email] ---
Swati,

This option must be fixed in configurations files before 5.0.0 release.

Also, there is an important question : It's the same changes in config option
name for Oracle Mysql and MariaDb ?

Gilles Caulier

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[bugzilla_noreply]

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

--- Comment #2 from [hidden email] ---
Configuration file changed.

And yes, table_open_cache is valid for both Oracle MySQL and Maria DB.

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel

[bugzilla_noreply]

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

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |FIXED
   Version Fixed In|                            |5.0.0
             Status|UNCONFIRMED                 |RESOLVED
      Latest Commit|                            |http://commits.kde.org/digi
                   |                            |kam/ceea763c6dd60cd151ee9e8
                   |                            |55a7dc14b41befecc

--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Digikam-devel mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-devel