1254661 - Deploy Infernyx 0.1.45 to Stage

Status: VERIFIED FIXED

(Content Services Graveyard :: Tiles: Ops, defect)

Comment 1

[Daniel Thorn [:relud]]

in progress

Comment 2

[Nan Jiang [:nanj]]

Thanks Daniel!

Have one more question here, is it possible to do an end-to-end test in stage? The plan is to test the new infernyx rule processes the logs properly, and saves the processed data to the new table in Redshift.

Specifically, my script sends dozens of pings(application logs) to Onyx, which in turn logs the pings and pushes them to ddfs. Then I can manually execute the infernyx rule on the stage server.

I've managed to ping the Onyx in stage, but couldn't see any new logs in ddfs, thought we might need to trigger something on your side. Can you help me out here?


Thanks,
Nan

Comment 3

[Nan Jiang [:nanj]]

Hi Daniel,

Infernyx raised a "Permission denied" error while attempting to insert data into the "activity_stream_stats_daily" table on the stage server. The full error message as attached below,

Did you grant write permission to the Infernyx user for the new table? Or because I was executing it under my account rather than infernyx?


2016-03-09 20:28:35,785 ERROR 4917 [root] application_stats@5b1:87916:1d674: Error persisting results. Rolling back: permission denied for relation activity_stream_stats_daily

2016-03-09 20:28:35,785 ERROR 4917 [root] application_stats@5b1:87916:1d674: Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/infernyx/database.py", line 115, in _insert_datafiles
    cursor.execute(command)
  File "/usr/lib64/python2.7/site-packages/psycopg2/extras.py", line 120, in execute
    return super(DictCursor, self).execute(query, vars)
ProgrammingError: permission denied for relation activity_stream_stats_daily


Thanks,
Nan

Comment 4

[Daniel Thorn [:relud]]

I didn't do the grant, I only created the table. Fixing.

Comment 5

[Daniel Thorn [:relud]]

grants added for infernyx and read_only