SOLVED: greyhole php error

frankhaas
Posts: 18
Joined: Fri Dec 10, 2010 6:31 am

SOLVED: greyhole php error

Postby frankhaas » Sat Jun 07, 2014 3:24 am

hi, anyone who can help me please? ;-)

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
2. my smb.conf:

Code: Select all

http://paste.ubuntu.com/7606998/
2. my greyhole.conf:

Code: Select all

http://paste.ubuntu.com/7606999/
3.

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/
6. greyhole working queue: (won't work, greyhole is stuck :(

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
7. no result



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 !!!!

frankhaas
Posts: 18
Joined: Fri Dec 10, 2010 6:31 am

Re: greyhole php error

Postby frankhaas » Sun Jun 08, 2014 12:30 am


Who is online

Users browsing this forum: No registered users and 22 guests