
my greyhole won't update any longer and is stuck with this message:
Code: Select all
frank@frank-X7SPA-H:~$ greyhole --view-queue
PHP Fatal error: Uncaught exception 'Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'Daten_Doris-D/Daten/Musi/S/Stansfield, Lisa' for key 'uniqness'' in /usr/bin/greyhole:491
Stack trace:
#0 /usr/bin/greyhole(669): DB::execute('ALTER TABLE `du...')
#1 /usr/bin/greyhole(472): DB::migrate()
#2 /usr/bin/greyhole(3159): DB::connect()
#3 /usr/bin/greyhole(3123): CommandLineHelper->getRunner()
#4 /usr/bin/greyhole(3498): CommandLineHelper->processCommandLine()
#5 {main}
thrown in /usr/bin/greyhole on line 491
so H E L P !!!

1. my config:
Code: Select all
3.2.0-64-generic
Package: samba
Status: install ok installed
Priority: optional
Section: net
Installed-Size: 22863
Maintainer: Ubuntu Developers <ubuntu-devel-discuss@lists.ubuntu.com>
Architecture: amd64
Version: 2:3.6.3-2ubuntu2.10
Replaces: samba-common (<= 2.0.5a-2)
Depends: samba-common (= 2:3.6.3-2ubuntu2.10), libwbclient0 (= 2:3.6.3-2ubuntu2.10), libacl1 (>= 2.2.51-5), libattr1 (>= 1:2.4.46-5), libc6 (>= 2.15), libcap2 (>= 2.10), libcomerr2 (>= 1.01), libcups2 (>= 1.4.0), libgssapi-krb5-2 (>= 1.10+dfsg~), libk5crypto3 (>= 1.6.dfsg.2), libkrb5-3 (>= 1.10+dfsg~), libldap-2.4-2 (>= 2.4.7), libpam0g (>= 0.99.7.1), libpopt0 (>= 1.14), libtalloc2 (>= 2.0.4~git20101213), libtdb1 (>= 1.2.7+git20101214), zlib1g (>= 1:1.1.4), debconf (>= 0.5) | debconf-2.0, upstart-job, libpam-runtime (>= 1.0.1-11), libpam-modules, lsb-base (>= 3.2-13), procps, update-inetd, adduser, samba-common-bin
Recommends: logrotate, tdb-tools
Suggests: openbsd-inetd | inet-superserver, smbldap-tools, ldb-tools, ctdb, ufw
Conflicts: samba4 (<< 4.0.0~alpha6-2)
Conffiles:
/etc/init/nmbd.conf 737e820c320801a2a0fc9e9c84d43fc0
/etc/init/smbd.conf ef97a6e85e7f13aba5e63321990a31a4
/etc/cron.daily/samba f6519535df7964f95cdd7db501bf3ad2
/etc/ufw/applications.d/samba 9d474788f9a1955e16134f2794be473d
/etc/logrotate.d/samba 9a7687a2498ae9bfbe6c1cc252818113
/etc/network/if-up.d/samba 2c617f0d1baebc4ba4177087a7eefc57
Description: SMB/CIFS file, print, and login server for Unix
Samba is an implementation of the SMB/CIFS protocol for Unix systems,
providing support for cross-platform file and printer sharing with
Microsoft Windows, OS X, and other Unix systems. Samba can also function
as an NT4-style domain controller, and can integrate with both NT4 domains
and Active Directory realms as a member server.
.
This package provides the components necessary to use Samba as a
stand-alone file and print server. For use in an NT4 domain or Active
Directory realm, you will also need the winbind package.
.
This package is not required for connecting to existing SMB/CIFS servers
(see smbclient) or for mounting remote filesystems (see cifs-utils).
Homepage: http://www.samba.org
Original-Maintainer: Debian Samba Maintainers <pkg-samba-maint@lists.alioth.debian.org>
Package: greyhole
Status: install ok installed
Priority: extra
Section: net
Maintainer: Guillaume Boudreau <guillaume@greyhole.net>
Architecture: amd64
Version: 0.9.53-1
Depends: libc6 (>= 2.4), samba (>= 3.4.3), samba-common, samba-common-bin, lsof, rsync, sysstat, mysql-server, php5-cli (>= 5), php-pear, php5-intl, php5-mysql | php5-mysqlnd
Conffiles:
/etc/init.d/greyhole ad4a20cbe73594daea8fbe8429d694cf
/etc/init/greyhole.conf 980ae3ac61009bb174d89d7f429dd5e5
/etc/greyhole.conf 54d48065ab0a1a2cce134523112b75eb
/etc/logrotate.d/greyhole f6b8cabcd4a0a7f6c8599668ec0a8a21
/etc/cron.weekly/greyhole 7397a9117e6eeebc05b18028709000f7
/etc/cron.d/greyhole 16e8b8a248b1eb8410160cf983a10a7f
/etc/cron.daily/greyhole d8914c41957535d54232c5ac71ad1009
Description: Drive pooling technology for Samba
Allows you to create a storage pool, accessible from
Samba shares, that offers data redundancy and JBOD concatenation.
Homepage: http://www.greyhole.net
Code: Select all
http://paste.ubuntu.com/7606998/
Code: Select all
http://paste.ubuntu.com/7606999/
Code: Select all
mount
/dev/sda1 on / type ext4 (rw,errors=remount-ro)
proc on /proc type proc (rw,noexec,nosuid,nodev)
sysfs on /sys type sysfs (rw,noexec,nosuid,nodev)
none on /sys/fs/fuse/connections type fusectl (rw)
none on /sys/kernel/debug type debugfs (rw)
none on /sys/kernel/security type securityfs (rw)
udev on /dev type devtmpfs (rw,mode=0755)
devpts on /dev/pts type devpts (rw,noexec,nosuid,gid=5,mode=0620)
tmpfs on /run type tmpfs (rw,noexec,nosuid,size=10%,mode=0755)
none on /run/lock type tmpfs (rw,noexec,nosuid,nodev,size=5242880)
none on /run/shm type tmpfs (rw,nosuid,nodev)
/dev/sdi1 on /var/hda/files/drives/drive14 type ext4 (rw,_netdev)
/dev/sdf1 on /var/hda/files/drives/drive8 type ext4 (rw,_netdev)
/dev/sdh1 on /var/hda/files/drives/drive2 type ext4 (rw,_netdev)
/dev/sdd1 on /var/hda/files/drives/drive10 type ext4 (rw,_netdev)
/dev/sde1 on /var/hda/files/drives/drive12 type ext4 (rw,_netdev)
/dev/sdb1 on /var/hda/files/drives/drive9 type ext4 (rw,_netdev)
/dev/sdm1 on /var/hda/files/drives/drive4 type ext4 (rw,_netdev)
/dev/sdj1 on /var/hda/files/drives/drive3 type ext4 (rw,_netdev)
/dev/sdc1 on /var/hda/files/drives/drive1 type ext4 (rw,_netdev)
/dev/sdl1 on /var/hda/files/drives/drive13 type ext4 (rw,_netdev)
/dev/sdk1 on /var/hda/files/drives/drive7 type ext4 (rw,_netdev)
/dev/sdg1 on /var/hda/files/drives/drive6 type ext4 (rw,_netdev)
none on /var/spool/greyhole/mem type tmpfs (rw,size=4M)
/home/frank/.Private on /home/frank type ecryptfs (ecryptfs_check_dev_ruid,ecryptfs_cipher=aes,ecryptfs_key_bytes=16,ecryptfs_unlink_sigs,ecryptfs_sig=843440543c8de7f5,ecryptfs_fnek_sig=949b88064fe9a8b2)
gvfs-fuse-daemon on /home/frank/.gvfs type fuse.gvfs-fuse-daemon (rw,nosuid,nodev,user=frank)
frank@frank-X7SPA-H:~$ fdisk -l
frank@frank-X7SPA-H:~$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 227G 27G 189G 13% /
udev 1,5G 12K 1,5G 1% /dev
tmpfs 301M 1,5M 299M 1% /run
none 5,0M 0 5,0M 0% /run/lock
none 1,5G 13M 1,5G 1% /run/shm
/dev/sdi1 2,8T 2,3T 301G 89% /var/hda/files/drives/drive14
/dev/sdf1 1,8T 1,5T 299G 83% /var/hda/files/drives/drive8
/dev/sdh1 2,8T 2,3T 300G 89% /var/hda/files/drives/drive2
/dev/sdd1 1,8T 1,5T 301G 83% /var/hda/files/drives/drive10
/dev/sde1 2,8T 2,3T 300G 89% /var/hda/files/drives/drive12
/dev/sdb1 1,8T 1,5T 301G 83% /var/hda/files/drives/drive9
/dev/sdm1 2,8T 2,3T 300G 89% /var/hda/files/drives/drive4
/dev/sdj1 2,8T 2,3T 302G 89% /var/hda/files/drives/drive3
/dev/sdc1 1,8T 1,5T 279G 85% /var/hda/files/drives/drive1
/dev/sdl1 930G 584G 300G 67% /var/hda/files/drives/drive13
/dev/sdk1 2,8T 2,3T 299G 89% /var/hda/files/drives/drive7
/dev/sdg1 1,8T 1,5T 300G 83% /var/hda/files/drives/drive6
none 4,0M 0 4,0M 0% /var/spool/greyhole/mem
/home/frank/.Private 227G 27G 189G 13% /home/frank
frank@frank-X7SPA-H:~$ greyhole --stats
PHP Fatal error: Uncaught exception 'Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'Daten_Doris-D/Daten/Musi/S/Stansfield, Lisa' for key 'uniqness'' in /usr/bin/greyhole:491
Stack trace:
#0 /usr/bin/greyhole(669): DB::execute('ALTER TABLE `du...')
#1 /usr/bin/greyhole(472): DB::migrate()
#2 /usr/bin/greyhole(3159): DB::connect()
#3 /usr/bin/greyhole(3123): CommandLineHelper->getRunner()
#4 /usr/bin/greyhole(3498): CommandLineHelper->processCommandLine()
#5 {main}
thrown in /usr/bin/greyhole on line 491
frank@frank-X7SPA-H:~$
4. list drives
Code: Select all
mysql -u root -phda -e "select * from disk_pool_partitions" hda_production
+----+-------------------------------+--------------+---------------------+---------------------+
| id | path | minimum_free | created_at | updated_at |
+----+-------------------------------+--------------+---------------------+---------------------+
| 1 | /var/hda/files/drives/drive8 | 10 | 2013-01-24 22:42:46 | 2013-01-24 22:42:46 |
| 2 | /var/hda/files/drives/drive6 | 10 | 2013-01-24 22:42:47 | 2013-01-24 22:42:47 |
| 3 | /var/hda/files/drives/drive7 | 10 | 2013-01-24 22:42:47 | 2013-01-24 22:42:47 |
| 4 | /var/hda/files/drives/drive9 | 10 | 2013-01-24 22:42:48 | 2013-01-24 22:42:48 |
| 5 | /var/hda/files/drives/drive1 | 10 | 2013-01-24 22:42:48 | 2013-01-24 22:42:48 |
| 6 | /var/hda/files/drives/drive4 | 10 | 2013-01-24 22:42:49 | 2013-01-24 22:42:49 |
| 7 | /var/hda/files/drives/drive10 | 10 | 2013-01-24 22:42:50 | 2013-01-24 22:42:50 |
| 8 | /var/hda/files/drives/drive12 | 10 | 2013-01-24 22:42:50 | 2013-01-24 22:42:50 |
| 9 | /var/hda/files/drives/drive13 | 10 | 2013-01-24 22:42:51 | 2013-01-24 22:42:51 |
| 10 | /var/hda/files/drives/drive2 | 10 | 2013-04-10 05:15:30 | 2013-04-10 05:15:30 |
| 11 | /var/hda/files/drives/drive3 | 10 | 2013-07-04 01:51:00 | 2013-07-04 01:51:00 |
+----+-------------------------------+--------------+---------------------+---------------------+
5. directory list:
Code: Select all
http://paste.ubuntu.com/7607007/

Code: Select all
frank@frank-X7SPA-H:~$ greyhole --view-queue
PHP Fatal error: Uncaught exception 'Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'Daten_Doris-D/Daten/Musi/S/Stansfield, Lisa' for key 'uniqness'' in /usr/bin/greyhole:491
Stack trace:
#0 /usr/bin/greyhole(669): DB::execute('ALTER TABLE `du...')
#1 /usr/bin/greyhole(472): DB::migrate()
#2 /usr/bin/greyhole(3159): DB::connect()
#3 /usr/bin/greyhole(3123): CommandLineHelper->getRunner()
#4 /usr/bin/greyhole(3498): CommandLineHelper->processCommandLine()
#5 {main}
thrown in /usr/bin/greyhole on line 491
so, i hope you can find the error. everything worked fine (apart from some webif-troubles) until an update this week.
maybe you can find some other things to pimp on my system.
THX !!!!