Issue #2809 has been updated by Brice Figureau.
Brice Figureau wrote: > I think the correct fix would be to use a BINARY VARCHAR in the schema. And I also think a severe error in storeconfigs (ie a catalog caching operation) should not abort the whole compilation. And more generally a fatal error in a cache operation should not halt the backing find operation. But still the error should be transmitted to the client (people tend to look more at the client side of the thing than at the master). ---------------------------------------- Bug #2809: storeconfigs: with mysql impossible to have resource title differing in case http://projects.reductivelabs.com/issues/2809 Author: Brice Figureau Status: Unreviewed Priority: Low Assigned to: Category: Rails Target version: 0.25.2 Affected version: 0.25.1 Keywords: Branch: With the following resource: <pre> file { "/etc/sv/m44-test/env/MEMOIR44_HOME": content => "content"; "/etc/sv/m44-test/env/memoir44_HOME": ensure => absent; } </pre> I get: <pre> Mysql::Error: Duplicate entry '/etc/sv/m44-test/env/MEMOIR44_HOME-File-116' for key 2: INSERT INTO `resources` (`exported`, `title`, `line`, `updated_at`, `restype`, `source_file_id`, `host_id`) VALUES(0, '/etc/sv/m44-test/env/MEMOIR44_HOME', 103, '2009-11-12 17:00:08', 'File', 85, 116) </pre> The problem is that a VARCHAR field in MySQL does a lookup in a case-insensitive way, so both titles are the same for the MySQL server. I think the correct fix would be to use a BINARY VARCHAR in the schema. -- You have received this notification because you have either subscribed to it, or are involved in it. To change your notification preferences, please click here: http://reductivelabs.com/redmine/my/account --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/puppet-bugs?hl=en -~----------~----~----~----~------~----~------~--~---
