Problem with synchronizing svn commits to MySQL database

[trac@…]

We've faced the following problem: when there's a simultanious addition of the file and replacement of the same file in one ticket, trac is unable to synchronize such a commit and the whole process stops. The cause of the error lies here: the 'Replacing' type of change is put to database as adding a new file and as a result we get the duplicate of the database. Here's the dump of sql quieries trac has sent to database:

58 Query INSERT INTO node_change
               (repos,rev,path,node_type,change_type,base_path,
                base_rev)
           VALUES (1,'0000011999','branch/debug_GC/tools/src/gameserver/MyTools/DropListGenerator.java','F','A',NULL,-1)
58 Query INSERT INTO node_change
               (repos,rev,path,node_type,change_type,base_path,
                base_rev)
           VALUES (1,'0000011999','branch/debug_GC/tools/src/gameserver/MyTools/DroplistGenerator.java','F','A',NULL,-1)

Synchronization of the data stops after that and all the changes following this problem revision are not seen by trac

[Jun Omae]

The two file paths are not same.

branch/debug_GC/tools/src/gameserver/MyTools/DropListGenerator.java
                                                 |
branch/debug_GC/tools/src/gameserver/MyTools/DroplistGenerator.java

Seems that charset and collation in your MySQL database lead the issue. MySQL database for Trac must be configured with utf8 charset and utf8_bin collation. See also, MySqlDb.

[Jun Omae]

An InstallationIssue of mysql.