Hello, I have been using Membase (a nosql database), which uses sqlite3 to persist data to disk and have run into some problems when attempting to backup the database files. Membase uses 4 different database files to store the data on each Node and in my particular case, each file is around 800 Mb. When I issue the backup statement:
/opt/membase/bin/sqlite3 /mnt/data-store/default-data/default-1.mb '.backup /mnt/data-backup/mbfiles/default-1-backup.mb' The command executes and almost immediately copies 180Mb and then comes to a near standstill. It continues in tiny spurts until it reaches 260915200 bytes, and then the file stops growing but the process continues to consume CPU resources. I've been trying to get a successful backup for weeks now with no avail. If it matters, this system is set up on the Amazon Cloud via EC2 and is using EBS drives. Additionally, this is a production environment so the db is being accessed and restarts cannot be performed. Also here is a list of the files (I have set them and the destination directory to 777 permissions to fix some access issues) drwxrwxrwx 2 membase membase 4096 Sep 13 18:19 . drwxrwxrwx 4 membase root 4096 Aug 5 01:10 .. -rwxrwxrwx 1 membase membase 53248 Sep 13 18:19 default -rwxrwxrwx 1 membase membase 892068864 Sep 13 18:19 default-0.mb -rwxrwxrwx 1 membase membase 32768 Sep 13 18:19 default-0.mb-shm -rwxrwxrwx 1 membase membase 1858136 Sep 13 18:19 default-0.mb-wal -rwxrwxrwx 1 membase membase 892246016 Sep 13 18:19 default-1.mb -rwxrwxrwx 1 membase membase 32768 Sep 13 18:19 default-1.mb-shm -rwxrwxrwx 1 membase membase 1422168 Sep 13 18:19 default-1.mb-wal -rwxrwxrwx 1 membase membase 891885568 Sep 13 18:19 default-2.mb -rwxrwxrwx 1 membase membase 32768 Sep 13 18:19 default-2.mb-shm -rwxrwxrwx 1 membase membase 1322608 Sep 13 18:19 default-2.mb-wal -rwxrwxrwx 1 membase membase 892113920 Sep 13 18:18 default-3.mb -rwxrwxrwx 1 membase membase 32768 Sep 13 18:19 default-3.mb-shm -rwxrwxrwx 1 membase membase 1359288 Sep 13 18:19 default-3.mb-wal -rwxrwxrwx 1 ec2-user ec2-user 0 Sep 12 17:12 default-4.mb -rwxrwxrwx 1 ec2-user ec2-user 0 Sep 12 16:27 default.mb -rwxrwxrwx 1 membase membase 32768 Sep 13 18:19 default-shm -rwxrwxrwx 1 membase membase 1083664 Sep 13 18:19 default-wal Any help would be greatly appropriated. Thanks! David _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
