[Bug 9995] New: Rsync 3.1 dev :

[samba-bugs at samba.org]

https://bugzilla.samba.org/show_bug.cgi?id=9995

           Summary: Rsync 3.1 dev :
           Product: rsync
           Version: 3.1.0
          Platform: x64
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: P5
         Component: core
        AssignedTo: wayned at samba.org
        ReportedBy: dochitoai.vu at ladhyx.polytechnique.fr
         QAContact: rsync-qa at samba.org


Hi,

Sorry, I am french ,  my english is not very fluent.
Just a word, i wish to thank Wayne Davison for his work.
I 'm testing Rsync 3.1, with the db.diff Patch, especially the checksum
feature.
The build has no troubles. 
But, to initialize the tables in the Mysql Database, i have found an error :

dvu at alix:~/LADHYX/Dev/Rsync/Git/rsync> /opt/Rsync/bin/rsyncdb
--db=/opt/Rsync/dbconfig --init --mounts
Creating DB rsync (if it does not exist)
Dropping old tables (if they exist))
Creating empty tables ...
[rsyncdb] Prepare failed: Table 'rsync.disk' doesn't exist
INSERT INTO disk SET host = ?, last_seen = ?, mount_uniq = ?, devno = ? ON
DUPLICATE KEY UPDATE last_seen = VALUES(last_seen), devno = VALUES(devno)
Marking mount "Mount of /dev/sda4" (2052) as recently seen
Erreur de segmentation

The Mysql query in db.c file do not work.

CREATE TABLE disk (
                    disk_id integer unsigned NOT NULL PRIMARY KEY
AUTO_INCREMENT,
                    host varchar(256) NOT NULL default 'localhost',
                    mount_uniq varchar(256) default NULL,
                    devno bigint unsigned NOT NULL,
                    last_seen bigint NOT NULL,
                    UNIQUE KEY mount_lookup (host, mount_uniq),
                    KEY dev_lookup (devno, host)
                )

I have tested it inside Mysql :

MariaDB [rsync]> CREATE TABLE disk (disk_id integer unsigned NOT NULL PRIMARY
KEY AUTO_INCREMENT,
    -> host varchar(256) NOT NULL default 'localhost',
    -> mount_uniq varchar(256) default NULL,
    -> devno bigint unsigned NOT NULL,
    -> last_seen bigint NOT NULL,
    -> UNIQUE KEY mount_lookup (host, mount_uniq),
    -> KEY dev_lookup (devno, host)
    -> );
ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes

I dont know if it's a Mysql's bug.

-- 
Configure bugmail: https://bugzilla.samba.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.