Edgewall Software
Modify

Opened 10 years ago

Closed 10 years ago

#11727 closed defect (worksforme)

Problem with synchronizing svn commits to MySQL database

Reported by: trac@… Owned by:
Priority: normal Milestone:
Component: version control Version: 1.0.1
Severity: normal Keywords: svn cache mysql
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description (last modified by Jun Omae)

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

Attachments (1)

svn.PNG (10.9 KB ) - added by trac@… 10 years ago.

Download all attachments as: .zip

Change History (4)

by trac@…, 10 years ago

Attachment: svn.PNG added

comment:1 by Jun Omae, 10 years ago

Component: database backendversion control
Description: modified (diff)
Keywords: svn cache added; mysql resync removed
Milestone: 1.0.2next-stable-1.0.x

comment:2 by Jun Omae, 10 years ago

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.

Last edited 10 years ago by Jun Omae (previous) (diff)

comment:3 by Jun Omae, 10 years ago

Keywords: mysql added
Milestone: next-stable-1.0.x
Resolution: worksforme
Status: newclosed

An InstallationIssue of mysql.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.