When we first received our 3466 the system crashed on a SQL error that was
a syntax misstake.  I can't remember the exact thing but it was an
incorrect NodeName or a weird node name that know one every QUERY'd until
a few months .

This could at least answer your "Why now when nothing has
changed" question.

........... joe.f.

Joseph A Faracchio,  Systems Programmer, UC Berkeley


On Wed, 9 Aug 2000, Roger C Cook wrote:

> This thread reminds me of a question I've been meaning to ask. I have
> several SQL queries that run as cron jobs to keep me current on system
> status. About two months ago the server started crashing every Sunday at the
> same exact time. The problem was traced to an automated query that runs
> every day, which has been running for almost two years. Once I modified the
> statement, the crashes stopped. Support said that it was because of the
> "group by" portion of the query, and that this is a know issue. My questions
> are:
>
> 1. Why would this start happening when I have been using this script every
> day for over a year? (There have been no upgrades or changes - still using
> 3.1.2.20 and same hardware.)
>
> 2. Since running the scripts manually has never caused a crash, could it
> have something to do with running as a cron job?
>
> 3. Has anyone else seen or heard of this type of behavior?
>
> 4. Would upgrading help? (We have already purchased and received 3.7, but
> were waiting till we get 4.1 to actually upgrade)
>
> Any feedback would be appreciated.
>
> Roger C Cook
> RCG Information Services
>