Re: [Tracker] New CVS version

[Jamie McCracken <jamiemcc blueyonder co uk>]

Gergan Penkov wrote:
> >
> Hi
> it seems much faster and better with every new release.

Yes the GCond thread synchronisation is much faster than the previous 
sleep/awake poll. Threads are now immediately awoken when necessary.

> Some small issues I have observed:
> head -n 25 tracker.log 
> 22 Aug 2006, 04:57:49:758 - setting no watch directory /home/gero/workspace
> 22 Aug 2006, 04:57:49:759 - setting no watch directory /home/gero/jython
> 22 Aug 2006, 04:57:49:759 - setting no watch directory /home/gero/Projects
> 22 Aug 2006, 04:57:49:759 - setting no watch directory /home/gero/Borland
> 22 Aug 2006, 04:57:49:759 - setting no watch directory /home/gero/netbeans-5.5beta
> 22 Aug 2006, 04:57:49:759 - setting no watch directory /home/gero/SUNWappserver
> 22 Aug 2006, 04:57:49:760 - setting no watch directory /home/gero/jboss-4.0.4.GA-src
> 22 Aug 2006, 04:57:49:760 - setting no watch directory /home/gero/jboss-4.0.4.GA
> 22 Aug 2006, 04:57:49:795 - DB initialised - embedded mysql version is 50024
> 22 Aug 2006, 04:57:49:795 - Creating system database...
> 22 Aug 2006, 04:57:49:907 - Creating tracker database...
> 22 Aug 2006, 04:57:49:908 - Creating tables...
> 22 Aug 2006, 04:57:50:79 - Checking for Options table...
> 22 Aug 2006, 04:57:50:79 - Options table is present
> 22 Aug 2006, 04:57:50:80 - Checking tracker DB version...Current version is 3 and needed version is 3
> 22 Aug 2006, 04:57:50:80 - Creating stored procedures...
> 22 Aug 2006, 04:57:50:85 - tracker_exec_sql failed: You have an error in your SQL syntax; check the manual 
> that corresponds to your MySQL server version for the right syntax to use near 'select 1 where exists (select 
> IndexID from ServiceMetaData where IndexID = ID);
> ' at line 3 [
>
> CREATE PROCEDURE IndexIDExists (ID int unsigned)
> BEGIN
>         select 1 where exists (select IndexID from ServiceMetaData where IndexID = ID);
> END]


Thanks have now fixed in CVS

> So I don't know why but it helps :)
> There is a second thing, but I have tested it only three times and it happened 2 of them, essentially there 
> is still some deadlock in the file thread, after hitting ctrl-c:
> Extracting Metadata for file /home/gero/Mail/inbox/whois3/5 with mime text/plain
> Received termination signal Interrupt so now exiting
> total allocations = 42955 , total deallocations = 42606
> starting shutdown...
> shutting down threads
> poll thread awoken
> poll thread has exited successfully
> request thread has exited successfully
> metadata thread going to deep sleep...
> metadata thread has exited successfully
>
> and trackerd does not exit, I haven't waited more than 5-10 minutes though.

Rats - I thought I sussed this one!

if it takes more then a few seconds to exit then its a deadlock on a 
mutex. I guess I should unlock them all as a precaution when exiting. 
Please try latest cvs again (I cannot replicate your problem mind you)


--
Mr Jamie McCracken
http://jamiemcc.livejournal.com/