[Reconnoiter-users] Undefined table: 7 ERROR: relation "metric_name_summary" does not exist

Julian Seidenberg julian at silverstripe.com
Wed Nov 4 18:11:59 EST 2009

Yes, an SVN update was probably the cause. I have recreated the  
database with:

cat /usr/local/share/reconnoiter/schema.sql | psql

I get these errors, but the rest of the script appears to run correctly:
NOTICE:  schema "noit" does not exist
NOTICE:  schema "noit" does not exist

Although the noit schema is actually being created with 20 tables in it.

However, now the problem I'm having is that none of the noit data is  
being written to the database tables. The uuid of the checks in the  
noit are being added to the "map_uuid_to_sid" table, but no actual  
data appears in the "noit" tables.

Do you know what could be causing this? Do I have to do anything more  
to setup the database?

should <iep disabled="false"> be "false" or "true"? The sample file  
has it set to "true", but the comment says the default it "false".

Thanks for all your help.


On 5/11/2009, at 7:45 AM, Theo Schlossnagle wrote:

> did you svn update? There have been some substantive changes that  
> would cause that issue.
> On Nov 3, 2009, at 8:03 PM, Julian Seidenberg wrote:
>> Hi,
>> I'm having some more trouble. I was using Reconnoiter without any
>> problems for a while, then did added some http checks and found that
>> the Reconnoiter web-ui now gives me the following error (as a  
>> response
>> to the ajax call to /reconnoiter/json/worksheet/search?q=&o=O&l=25):
>> Error: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation
>> "metric_name_summary" does not exist
>> The "metric_name_summary" table does exist. I have tried rebuilding
>> the database and the same error still occurs. Could you point me in
>> the right direction to fixing this issue?
>> Best regards,
>> Julian
>> -------
>> Julian Seidenberg
>> _______________________________________________
>> Reconnoiter-users mailing list
>> Reconnoiter-users at lists.omniti.com
>> http://lists.omniti.com/mailman/listinfo/reconnoiter-users
> --
> Theo Schlossnagle
> http://omniti.com/is/theo-schlossnagle
> p: +1.443.325.1357 x201   f: +1.410.872.4911

Julian Seidenberg

More information about the Reconnoiter-users mailing list