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

Theo Schlossnagle jesus at omniti.com
Wed Nov 4 18:14:00 EST 2009


The stratcon.conf file needs to be updated too.

http://labs.omniti.com/trac/reconnoiter/wiki/UpgradeNotes

On Nov 4, 2009, at 6:11 PM, Julian Seidenberg wrote:

> 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:
> CREATE ROLE
> CREATE DATABASE
> CREATE ROLE
> NOTICE:  schema "noit" does not exist
> ALTER ROLE
> CREATE ROLE
> 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.
>
> Julian
>
> 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
> _______________________________________________
> 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







More information about the Reconnoiter-users mailing list