Deploy Infernyx 0.1.45 to Stage

VERIFIED FIXED

Status

Content Services Graveyard
Tiles: Ops
VERIFIED FIXED
2 years ago
2 years ago

People

(Reporter: nanj, Assigned: relud)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

Comment hidden (empty)
(Reporter)

Updated

2 years ago
Assignee: nobody → dthorn
(Assignee)

Comment 1

2 years ago
in progress
Status: NEW → ASSIGNED
(Assignee)

Updated

2 years ago
Status: ASSIGNED → RESOLVED
Last Resolved: 2 years ago
Resolution: --- → FIXED
(Reporter)

Comment 2

2 years ago
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
(Reporter)

Comment 3

2 years ago
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
Flags: needinfo?(dthorn)
(Assignee)

Comment 4

2 years ago
I didn't do the grant, I only created the table. Fixing.
Flags: needinfo?(dthorn)
(Assignee)

Comment 5

2 years ago
grants added for infernyx and read_only
(Reporter)

Updated

2 years ago
Status: RESOLVED → VERIFIED
(Reporter)

Updated

2 years ago
Blocks: 1255432
You need to log in before you can comment on or make changes to this bug.