It's strange that the whole "wipe everything from the database and
restart from scratch" seems to be solution that works for everything.
I think this was a lot of the original motivation for the need of a
"clean db" button.
We really need to start tracking exactly what happens that causes the
system to degrade from a clean working copy to numerous connection
errors, execution errors, zombie threads, etc.
Right now, from the user's perspective, our solution is the same as
that given for most Microsoft software: "Restart your computer, call
us back if you're still having problems."
Exactly how to track down these problems, I'm not sure. Maybe if we
start collecting logs and database snapshots, and then start searching
for trends and patterns that cause the degradation. Once we have
that, determine the actions taken that lead down these execution
paths, and troubleshoot from there. It's a somewhat sophisticated
means for troubleshooting, but it also probably wouldn't hurt to have
the tools to do it.
Jonathan
On 2/14/06, Tibor Biro <[EMAIL PROTECTED]> wrote:
> Hi Metasharp,
>
> It appears that we are unable to read an executor ID from the database, the
> simplest way to fix it would be to wipe out the database.
>
> I would like to see what data causes the issue so if you can give me the
> data from the executor table before you wipe it I could put in a fix for
> this issue.
>
> Thanks,
> Tibor
>
>
> >
> > 2006-02-14 14:10:54,875 [1300] ERROR [(null)]
> > [{log4net:HostName=x157972}] - Executor : invalid id?
> >
> > System.Data.SqlClient.SqlException: Erreur de syntaxe lors de la
> > conversion d'une chaîne de caractères en uniqueidentifier.
> > at System.Data.SqlClient.SqlDataReader.Read()
> > at
> > Alchemi.Manager.Storage.GenericManagerDatabaseStorage.DecodeExecutorFromDa
> > taReader(IDataReader
> > dataReader)
> > at
> > Alchemi.Manager.Storage.GenericManagerDatabaseStorage.GetExecutor(String
> > executorId)
> > at Alchemi.Manager.MExecutor.VerifyExists(RemoteEndPoint ep)
> > 2006-02-14 14:11:18,156 [1592] DEBUG [(null)]
> > [{log4net:HostName=x157972}] - GManager:PingManager():0 - Manager
> > pinged successfully.
> >
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
> for problems? Stop! Download the new AJAX search engine that makes
> searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
> http://sel.as-us.falkag.net/sel?cmdlnk&kid3432&bid#0486&dat1642
> _______________________________________________
> Alchemi-developers mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/alchemi-developers
>
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid3432&bid#0486&dat1642
_______________________________________________
Alchemi-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/alchemi-developers
