Status: NEW → ASSIGNED
Status: ASSIGNED → RESOLVED
Last Resolved: 2 years ago
Resolution: --- → FIXED
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
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
I didn't do the grant, I only created the table. Fixing.
grants added for infernyx and read_only
You need to log in before you can comment on or make changes to this bug.