SOLVED: greyhole php error
Posted: 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:
so H E L P !!!
1. my config:
2. my smb.conf:
2. my greyhole.conf:
3.
4. list drives
5. directory list:
6. greyhole working queue: (won't work, greyhole is stuck
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 !!!!
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 !!!!
