It is currently Thu Apr 24, 2014 2:27 pm


Post new topic Reply to topic  [ 12 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: Greyhole service stopped
PostPosted: Sun Feb 27, 2011 1:36 pm 
Offline
User avatar

Joined: Thu Dec 02, 2010 12:55 am
Posts: 223
Hello,

just noticed by coincidence that Greyhole on my hda has stopped working. I cannot start it via HDA dashboard or via the console.

Here's the debug information according to the "Greyhole troubleshooting" wiki: http://pastebin.com/3gYZvC22

However I think the log is more interesting. Here's the relevant part: http://pastebin.com/m2G969mn

Have a look at these two lines:

Code:
Feb 25 20:57:13 2 read_smb_spool: Can't get tasks count: Table 'greyhole.tasks' doesn't exist
Feb 25 20:58:15 4 daemon: Found a share (jayrockDoc) defined in /etc/greyhole.conf with no path in /etc/samba/smb.conf. Either add this share in /etc/samba/smb.conf, or remove it from /etc/greyhole.conf, then restart Greyhole.


Any clue what's going on?

Cheers

jayrock


Top
 Profile  
 
 Post subject: Re: Greyhole service stopped
PostPosted: Sun Feb 27, 2011 5:53 pm 
Offline
User avatar

Joined: Sat Jan 23, 2010 1:15 pm
Posts: 606
Location: Montréal, Canada
You seem to be missing the MySQL tables that Greyhole uses.
Did you somehow upgraded Greyhole or Amahi recently ?
Maybe from Amahi 5 to Amahi 6 (F12 to F14) ?

_________________
- Guillaume Boudreau


Top
 Profile  
 
 Post subject: Re: Greyhole service stopped
PostPosted: Sun Feb 27, 2011 11:13 pm 
Offline
User avatar

Joined: Thu Dec 02, 2010 12:55 am
Posts: 223
Yes, as you can see in the logs I'm on Fedora 14. I did a clean install from scratch like two weeks ago. First it worked fine, the problem only occurred recently. Don't think I changed anything in the setup then, have no clue what triggered this misbehaviour.

/jayrock


Top
 Profile  
 
 Post subject: Re: Greyhole service stopped
PostPosted: Mon Feb 28, 2011 5:17 am 
Offline
User avatar

Joined: Sat Jan 23, 2010 1:15 pm
Posts: 606
Location: Montréal, Canada
You should file a bug on the Amahi bug tracker.
Maybe check in past greyhole.log files (found in /var/log) to see when the error started.
The easy solution is to re-create the tables, but that wouldn't help finding what made that table disappear in the first place.

_________________
- Guillaume Boudreau


Top
 Profile  
 
 Post subject: Re: Greyhole service stopped
PostPosted: Mon Feb 28, 2011 5:26 am 
Offline
User avatar

Joined: Thu Dec 02, 2010 12:55 am
Posts: 223
Thanks Guillaume,

how do I recreate the tables? I'm in #amahi irc now trying to fix it with the guys.

/jayrock


Top
 Profile  
 
 Post subject: Re: Greyhole service stopped
PostPosted: Mon Feb 28, 2011 5:31 am 
Offline
Administrator
User avatar

Joined: Wed Dec 03, 2008 7:40 am
Posts: 2442
Greyhole tables need to be created and initialized, in the update path to Amahi 6. We are creating a script to do all this.

This is not going to be longer an issue.

_________________
My HDA: Intel(R) Core(TM) i5-3570K CPU @ 3.40GHz on MSI board, 8GB RAM, 1TBx2+3TBx1


Top
 Profile  
 
 Post subject: Re: Greyhole service stopped
PostPosted: Mon Feb 28, 2011 6:10 am 
Offline
User avatar

Joined: Sat Jan 23, 2010 1:15 pm
Posts: 606
Location: Montréal, Canada
Execute everything found in /usr/share/greyhole/schema-mysql.sql into the MySQL console:
Code:
mysql -ugreyhole -pgreyhole greyhole

You might get errors for already existing tables; that's fine.

_________________
- Guillaume Boudreau


Top
 Profile  
 
 Post subject: Re: Greyhole service stopped
PostPosted: Mon Feb 28, 2011 6:43 am 
Offline
Administrator
User avatar

Joined: Wed Dec 03, 2008 7:40 am
Posts: 2442
he already ran the new update script, which drops the db if it exists and loads that sql file you mention to initialize it.

incidentally, 0.9.1 is live in the beta, hoping to get some mileage on it.

note: his issue is that service greyhole status indicates stopped.
restarting it seems to show all [ OK ] ... (except the php datetime warning issue that i am fixing as we discuss this thread)

nothing in the gh log, and i could not get him to investigate deeper at the time and had no chance to investigate myself.

_________________
My HDA: Intel(R) Core(TM) i5-3570K CPU @ 3.40GHz on MSI board, 8GB RAM, 1TBx2+3TBx1


Top
 Profile  
 
 Post subject: Re: Greyhole service stopped
PostPosted: Mon Feb 28, 2011 7:01 am 
Offline
User avatar

Joined: Thu Dec 02, 2010 12:55 am
Posts: 223
Hi cpg and gboudreau,

I guess I got the issue mitigated. gboudreau suggested to run

Code:
mysql -u greyhole -pgreyhole greyhole < /usr/share/greyhole/schema-mysql.sql


After that the service immediately started and everything looks ok so far. Log is ok, files are in place.

I looked at the migration script and though I'm no expert in SQL I cannot spot the difference compared to what the terminal command does.

For completeness, here's my /var/log/monit: http://pastebin.com/6vzW11sx
Doesn't show much. There is one older copy but that looks the same (same messages, just different time stamps).

So the best conclusion that I can draw is that (i) most probably I experienced the issue that cpg suspected from the beginning and (ii) most probably something's not correct with the ruby script. Maybe you can draw more/other conclusions?

Could it be related to the fact that I installed the beta some 14 days ago, presumably I started with an earlier version then? Might explain why others do not experience this. Just speculating.

/jayrock


Top
 Profile  
 
 Post subject: Re: Greyhole service stopped
PostPosted: Sat Mar 05, 2011 3:56 pm 
Offline

Joined: Mon Jan 03, 2011 5:36 pm
Posts: 5
Thanks for this. Same thing happened to myself. Running

Code:
mysql -u greyhole -pgreyhole greyhole < /usr/share/greyhole/schema-mysql.sql


Did fix the issue immediately and now Greyhole is once again running and commands are working via the terminal.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 12 posts ]  Go to page 1, 2  Next

All times are UTC - 8 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: