[Shake-dev] Re: Error message I can't figure out

[mwithers at memphis.edu]

Hi Steve,

We've messed up our database a couple times in the process of learning
how to do things properly (I'll let you know when we learn how to do things
properly).  So I wrote these notes.  Not sure if they'll help your situation
or not.

Notes from withers, 20060330, on removing bad entries from mysql.
genex doesn't like null origin times.

Connect to the database
mysql -h localhost -u shake -p
(see config for password)

show databases;

use shakemap

show tables;

select * from earthquake;

select * from earthquake where tabsol IS NULL;

Unfortunately, you can't delete rows based on the value of tabsol.
You have to delete based on a key.  So, note the evid's returned
from the select query and do this.

delete from earthquake where evid = 'KKQ50_se';

You can run the select query on NULL again to verify that you got them all.

A better way to do this that I haven't tried yet is by using the shakemap
module, cancel.  (tried this "cancel -event <evid>" and didn't remove it
from the db or the web page.)


Mitch

Center for Earthquake Research and Information (CERI)
University of Memphis                Ph: 901-678-4940
Memphis, TN 38152                   Fax: 901-678-4734


On Mon, 5 Nov 2007, Vince Quitoriano wrote:

>
> It sounds like one of the events in the MySQL event database has a missing
> or corrupted event date. Try going through the database with:
>
> select name,tabsol from earthquake;
>
> You may find one that has a null or bogus date.
> Let me know if that doesn't help.
>
> - Vince
>
>
> Steve Malone wrote:
>> Help,
>> I am at wits end with an error message that I have no idea how to go
>> about finding the problem.
>> This is for a special high res version of shakemap running on a linux
>> (RedHat) box that was working before but I am trying some new scenarios
>> and they all seem to fail in the same way.  In fact, now reruns of
>> previous events fail in the same way.  We have the same thing running
>> successfully on a Solaris-10 box and I think I have configs and such
>> pretty much the same on the two, but....
>> I always get a failure in genex with the following messages at the end:
>>
>> .....
>> genex: Running: PATH=$PATH:/usr/bin/; export PATH; /usr/bin/convert
>> -colorspace
>> RGB -quality 90 -crop 882x1065+0+-273 tvmap_bare.ps tvmap_bare.jpg
>>
>> genex: Running: PATH=$PATH:/usr/bin/; export PATH; /usr/bin/convert
>> -colorspace
>> RGB -quality 90 -crop +0+107 psa03.ps psa03.jpg
>>
>> Preparing info for clickmaps
>> Collecting files for the web site
>> mp 2.9.3 - Peter N. Schweitzer (U.S. Geological Survey)
>> No errors
>> Cooking web pages
>> Build homepage
>> Build 'Most Recent Earthquake' table
>> Build 'Other Recent Earthquakes' list
>>   events [] in list
>> Month '-1' out of range 0..11 at
>> /earthworm/SHAKE/bin/../perl/lib/Genex/Html.pm
>> line 701
>> shake: Error in genex: 65280
>> 137.227u 11.020s 2:34.98 95.6%  0+0k 0+0io 134pf+0w
>>
>>
>> As I say, the exact same event.xml runns fine on a Solaris-10 box.  Any
>> ideas?
>> Steve
>>
>>   Steve Malone                        steve at ess.washington.edu
>> <mailto:steve at ess.washington.edu>
>>
>>   Department of Earth & Space Sciences
>>
>>   Box 351310     (for shipping: 70 Johnson Hall)
>>
>>   University of Washington
>>
>>   Seattle, WA 98195                www.ess.washington.edu/malone
>>
>> office: 206-685-3811   (ATG-226)
>>
>>
>>
> _______________________________________________
> Shake-dev mailing list
> Shake-dev at scsnmail.gps.caltech.edu
> http://unix1.gps.caltech.edu/mailman/listinfo/shake-dev
>