[Antelope] schema compilation(?) problem on 4.9/PowerPC

[Dr. Kent Lindquist]

Hello Phil,

One thing that might cause this is indeed corruption in the schema  
definition files, and that is the first thing to check. However, you  
have to check more than just the definition file for the table in  
which the error crops up (e.g. "dlsite" in your case below). You have  
to check all schema and schema extension files that might use this  
particular attribute. For example, on my copy of Antelope (admittedly  
4.10 on Intel Mac), the "model" attribute is used in all of the  
dlsite, digitizer, dlcalwf, and seismometer tables:

	% pwd
	/opt/antelope/4.10/data/schemas/css3.0.ext
	
	% grep "Attribute model" *
	digitizer:Attribute model
	dlcalwf:Attribute model
	dlsite:Attribute model
	seismometer:Attribute model
	%

The corruption could be in any one of these (in principle it could  
also be in the base schema $ANTELOPE/data/schemas/css3.0, but that one  
doesn't define the "model" attribute).

Antelope allows an attribute that is used in multiple tables to be  
defined in any one of the supporting definition files, and in fact the  
"Attribute" definition block can appear multiple times, once in each  
of the files in which it is used, as long as the repetitious  
definitions are completely consistent with one another. Generally this  
repetition is done, which makes the tables less sensitive to load  
order etc. The first time (during schema parsing) that Antelope  
encounters one of these Attribute blocks, it merely loads in the newly  
defined Attribute. When Antelope sees subsequent definition blocks for  
the same attribute, it double-checks that they are consistent with the  
original. Thus, the comparison you're seeing below is presumably of  
two separate definitions of the "model" attribute in two separate  
extension tables.

For the fields in question that are causing you problems, you should  
hunt down all the extension tables in which they are used, looking for  
errors. Most if not all of the extension tables you list are in  
various places in the Antelope contributed-code repository. The rest  
should be available on the Antelope CD.

Best regards,
Kent


On Apr 18, 2009, at 7:39 PM, Phil Cummins wrote:

> Hi,
>
> I am using Antelope 4.9 on a PowerPC Macintosh Powerbook.  
> Antelope_update says that all patches are up-to-date (granted, this  
> isn't saying much).
>
> I am developing a script and running it on a test database I created  
> some time ago from an IRIS volume using seed2db. I have used this  
> database many times with no problem. I have also tried recreating  
> the database, again using seed2db. Now I find that, whenever I  
> access the wfdisc table, even using dbe, I get the following error:
>
> % dbe smtra_2007
> /opt/antelope/4.9/bin/dbe: formats differ: '%-15s' != '%-15'
> /opt/antelope/4.9/bin/dbe: conflicting Attribute model in schema  
> css3.0
> /opt/antelope/4.9/bin/dbe: db : bad attribute at ';' while compiling  
> attribute 'model' near line #60 of /opt/antelope/4.9/data/schemas/ 
> css3.0.ext/dlsite
> /opt/antelope/4.9/bin/dbe: formats differ: '%-15s' != '%-15'
> /opt/antelope/4.9/bin/dbe: conflicting Attribute manu in schema css3.0
> /opt/antelope/4.9/bin/dbe: db : bad attribute at ';' while compiling  
> attribute 'manu' near line #68 of /opt/antelope/4.9/data/schemas/ 
> css3.0.ext/dlsite
> /opt/antelope/4.9/bin/dbe: Parsing error in input schema
> /opt/antelope/4.9/bin/dbe: failed to compile database extension /opt/ 
> antelope/4.9/data/schemas/css3.0.ext/dlsite
> /opt/antelope/4.9/bin/dbe: Bad table id -102 in db pointer
>     ** repeated 3 times
> /opt/antelope/4.9/bin/dbe: formats differ: '%-25s' != '%-25'
> /opt/antelope/4.9/bin/dbe: conflicting Attribute hostname in schema  
> css3.0
> /opt/antelope/4.9/bin/dbe: db : bad attribute at ';' while compiling  
> attribute 'hostname' near line #72 of /opt/antelope/4.9/data/schemas/ 
> css3.0.ext/qctests
> /opt/antelope/4.9/bin/dbe: Parsing error in input schema
> /opt/antelope/4.9/bin/dbe: failed to compile database extension /opt/ 
> antelope/4.9/data/schemas/css3.0.ext/qctests
>
> This is baffling to me. The files in $ANTELOPE/data/schemas/ 
> css3.0ext seem to say, e.g., '%-15s', as i think they should. What  
> is antelope comparing to that thinks the format should be '%-15'?  
> Although dbe seems to actually work OK, my script seems to end up  
> with a bad dbpointer when I look up the wfdisc table. And, this is  
> happening with at least one other database that I used to access  
> with no problem. Could one of Antelope's data files been corrupted,  
> and if so, is there any way for me to tell which one?
>
> Any help you can give me would be much appreciated.
>
> Thanks,
>
> - Phil
> _______________________________________________
> Antelope mailing list
> Antelope at brtt.net
> http://brtt.net/mailman/listinfo/antelope_brtt.net

--
Dr. Kent Lindquist                     kent at lindquistconsulting.com
Lindquist Consulting, Inc.
59 College Rd. Suite #7
Fairbanks, AK 99701              Phone/FAX 907-457-2374

http://www.lindquistconsulting.com