Re: INDIGOPlotD error creating gnu plots
Posted: Fri Mar 30, 2018 4:31 am
Here is the contents (middle part skipped):
cd '/Library/Application Support/Perceptive Automation/Indigo 7/Logs'
date +"%H:%M:%S TED 5000-PowerNow_MTU1" >>/Users/grwilde/indigo/INDIGOplotD/sql/sqlcmd.log
/Applications/Postgres.app/Contents/Versions/10/bin/psql indigo_history -U postgres -t -A -F ';' -c " SELECT id, to_char(ts,'YYYYmmddHH24MIss'), PowerNow_MTU1 from device_history_826269353 WHERE PowerNow_MTU1 IS NOT NULL AND ID > 659591 order by id LIMIT 10000000;" 2>/Users/grwilde/indigo/INDIGOplotD/sql/826269353-PowerNow_MTU1.error | awk -F';' 'NF>2 && !/data unavailable/ {print}' > /Users/grwilde/indigo/INDIGOplotD/sql/826269353-PowerNow_MTU1.sqlOut
/usr/bin/python2.7 '/Library/Application Support/Perceptive Automation/Indigo 7/Plugins/INDIGOplotD.indigoPlugin/Contents/Server Plugin/fixSQLoutput.py' '{"fileDir": "/Users/grwilde/indigo/INDIGOplotD/sql/", "startID": "659591", "outputFile": "826269353-PowerNow_MTU1", "logFile": "sqlFix", "inputFile": "826269353-PowerNow_MTU1.sqlout"}'
ls -l -T /Users/grwilde/indigo/INDIGOplotD/sql/826269353-PowerNow_MTU1 | awk '{print $8 " " $5 " " $10}' >>/Users/grwilde/indigo/INDIGOplotD/sql/sqlcmd.log
echo finished > /Users/grwilde/indigo/INDIGOplotD/sql/826269353-PowerNow_MTU1.done
date +"%H:%M:%S TED 5000-VoltageNow_MTU1" >>/Users/grwilde/indigo/INDIGOplotD/sql/sqlcmd.log
/Applications/Postgres.app/Contents/Versions/10/bin/psql indigo_history -U postgres -t -A -F ';' -c " SELECT id, to_char(ts,'YYYYmmddHH24MIss'), VoltageNow_MTU1 from device_history_826269353 WHERE VoltageNow_MTU1 IS NOT NULL AND ID > 659591 order by id LIMIT 10000000;" 2>/Users/grwilde/indigo/INDIGOplotD/sql/826269353-VoltageNow_MTU1.error | awk -F';' 'NF>2 && !/data unavailable/ {print}' > /Users/grwilde/indigo/INDIGOplotD/sql/826269353-VoltageNow_MTU1.sqlOut
/usr/bin/python2.7 '/Library/Application Support/Perceptive Automation/Indigo 7/Plugins/INDIGOplotD.indigoPlugin/Contents/Server Plugin/fixSQLoutput.py' '{"fileDir": "/Users/grwilde/indigo/INDIGOplotD/sql/", "startID": "659591", "outputFile": "826269353-VoltageNow_MTU1", "logFile": "sqlFix", "inputFile": "826269353-VoltageNow_MTU1.sqlout"}'
ls -l -T /Users/grwilde/indigo/INDIGOplotD/sql/826269353-VoltageNow_MTU1 | awk '{print $8 " " $5 " " $10}' >>/Users/grwilde/indigo/INDIGOplotD/sql/sqlcmd.log
echo finished > /Users/grwilde/indigo/INDIGOplotD/sql/826269353-VoltageNow_MTU1.done
date +"%H:%M:%S 004 - Entry Hall Temperature-sensorValue" >>/Users/grwilde/indigo/INDIGOplotD/sql/sqlcmd.log
/Applications/Postgres.app/Contents/Versions/10/bin/psql indigo_history -U postgres -t -A -F ';' -c " SELECT id, to_char(ts,'YYYYmmddHH24MIss'), sensorValue from device_history_635276168 WHERE sensorValue IS NOT NULL AND ID > 1746 order by id LIMIT 10000000;" 2>/Users/grwilde/indigo/INDIGOplotD/sql/635276168-sensorValue.error | awk -F';' 'NF>2 && !/data unavailable/ {print}' > /Users/grwilde/indigo/INDIGOplotD/sql/635276168-sensorValue.sqlOut
/usr/bin/python2.7 '/Library/Application Support/Perceptive Automation/Indigo 7/Plugins/INDIGOplotD.indigoPlugin/Contents/Server Plugin/fixSQLoutput.py' '{"fileDir": "/Users/grwilde/indigo/INDIGOplotD/sql/", "startID": "1746", "outputFile": "635276168-sensorValue", "logFile": "sqlFix", "inputFile": "635276168-sensorValue.sqlout"}'
ls -l -T /Users/grwilde/indigo/INDIGOplotD/sql/635276168-sensorValue | awk '{print $8 " " $5 " " $10}' >>/Users/grwilde/indigo/INDIGOplotD/sql/sqlcmd.log
echo finished > /Users/grwilde/indigo/INDIGOplotD/sql/635276168-sensorValue.done
date +"%H:%M:%S 006 - Inside Garage Temperature-sensorValue" >>/Users/grwilde/indigo/INDIGOplotD/sql/sqlcmd.log
*
*Skipped Lines
*
/Applications/Postgres.app/Contents/Versions/10/bin/psql indigo_history -U postgres -t -A -F ';' -c " SELECT id, to_char(ts,'YYYYmmddHH24MIss'), value from variable_history_508483491 WHERE value IS NOT NULL AND ID > 22 order by id LIMIT 10000000;" 2>/Users/grwilde/indigo/INDIGOplotD/sql/508483491-value.error | awk -F';' 'NF>2 && !/data unavailable/ {print}' > /Users/grwilde/indigo/INDIGOplotD/sql/508483491-value.sqlOut
/usr/bin/python2.7 '/Library/Application Support/Perceptive Automation/Indigo 7/Plugins/INDIGOplotD.indigoPlugin/Contents/Server Plugin/fixSQLoutput.py' '{"fileDir": "/Users/grwilde/indigo/INDIGOplotD/sql/", "startID": "22", "outputFile": "508483491-value", "logFile": "sqlFix", "inputFile": "508483491-value.sqlout"}'
ls -l -T /Users/grwilde/indigo/INDIGOplotD/sql/508483491-value | awk '{print $8 " " $5 " " $10}' >>/Users/grwilde/indigo/INDIGOplotD/sql/sqlcmd.log
echo finished > /Users/grwilde/indigo/INDIGOplotD/sql/508483491-value.done
echo finished > /Users/grwilde/indigo/INDIGOplotD/sql/sqlcmd.done
cd '/Library/Application Support/Perceptive Automation/Indigo 7/Logs'
date +"%H:%M:%S TED 5000-PowerNow_MTU1" >>/Users/grwilde/indigo/INDIGOplotD/sql/sqlcmd.log
/Applications/Postgres.app/Contents/Versions/10/bin/psql indigo_history -U postgres -t -A -F ';' -c " SELECT id, to_char(ts,'YYYYmmddHH24MIss'), PowerNow_MTU1 from device_history_826269353 WHERE PowerNow_MTU1 IS NOT NULL AND ID > 659591 order by id LIMIT 10000000;" 2>/Users/grwilde/indigo/INDIGOplotD/sql/826269353-PowerNow_MTU1.error | awk -F';' 'NF>2 && !/data unavailable/ {print}' > /Users/grwilde/indigo/INDIGOplotD/sql/826269353-PowerNow_MTU1.sqlOut
/usr/bin/python2.7 '/Library/Application Support/Perceptive Automation/Indigo 7/Plugins/INDIGOplotD.indigoPlugin/Contents/Server Plugin/fixSQLoutput.py' '{"fileDir": "/Users/grwilde/indigo/INDIGOplotD/sql/", "startID": "659591", "outputFile": "826269353-PowerNow_MTU1", "logFile": "sqlFix", "inputFile": "826269353-PowerNow_MTU1.sqlout"}'
ls -l -T /Users/grwilde/indigo/INDIGOplotD/sql/826269353-PowerNow_MTU1 | awk '{print $8 " " $5 " " $10}' >>/Users/grwilde/indigo/INDIGOplotD/sql/sqlcmd.log
echo finished > /Users/grwilde/indigo/INDIGOplotD/sql/826269353-PowerNow_MTU1.done
date +"%H:%M:%S TED 5000-VoltageNow_MTU1" >>/Users/grwilde/indigo/INDIGOplotD/sql/sqlcmd.log
/Applications/Postgres.app/Contents/Versions/10/bin/psql indigo_history -U postgres -t -A -F ';' -c " SELECT id, to_char(ts,'YYYYmmddHH24MIss'), VoltageNow_MTU1 from device_history_826269353 WHERE VoltageNow_MTU1 IS NOT NULL AND ID > 659591 order by id LIMIT 10000000;" 2>/Users/grwilde/indigo/INDIGOplotD/sql/826269353-VoltageNow_MTU1.error | awk -F';' 'NF>2 && !/data unavailable/ {print}' > /Users/grwilde/indigo/INDIGOplotD/sql/826269353-VoltageNow_MTU1.sqlOut
/usr/bin/python2.7 '/Library/Application Support/Perceptive Automation/Indigo 7/Plugins/INDIGOplotD.indigoPlugin/Contents/Server Plugin/fixSQLoutput.py' '{"fileDir": "/Users/grwilde/indigo/INDIGOplotD/sql/", "startID": "659591", "outputFile": "826269353-VoltageNow_MTU1", "logFile": "sqlFix", "inputFile": "826269353-VoltageNow_MTU1.sqlout"}'
ls -l -T /Users/grwilde/indigo/INDIGOplotD/sql/826269353-VoltageNow_MTU1 | awk '{print $8 " " $5 " " $10}' >>/Users/grwilde/indigo/INDIGOplotD/sql/sqlcmd.log
echo finished > /Users/grwilde/indigo/INDIGOplotD/sql/826269353-VoltageNow_MTU1.done
date +"%H:%M:%S 004 - Entry Hall Temperature-sensorValue" >>/Users/grwilde/indigo/INDIGOplotD/sql/sqlcmd.log
/Applications/Postgres.app/Contents/Versions/10/bin/psql indigo_history -U postgres -t -A -F ';' -c " SELECT id, to_char(ts,'YYYYmmddHH24MIss'), sensorValue from device_history_635276168 WHERE sensorValue IS NOT NULL AND ID > 1746 order by id LIMIT 10000000;" 2>/Users/grwilde/indigo/INDIGOplotD/sql/635276168-sensorValue.error | awk -F';' 'NF>2 && !/data unavailable/ {print}' > /Users/grwilde/indigo/INDIGOplotD/sql/635276168-sensorValue.sqlOut
/usr/bin/python2.7 '/Library/Application Support/Perceptive Automation/Indigo 7/Plugins/INDIGOplotD.indigoPlugin/Contents/Server Plugin/fixSQLoutput.py' '{"fileDir": "/Users/grwilde/indigo/INDIGOplotD/sql/", "startID": "1746", "outputFile": "635276168-sensorValue", "logFile": "sqlFix", "inputFile": "635276168-sensorValue.sqlout"}'
ls -l -T /Users/grwilde/indigo/INDIGOplotD/sql/635276168-sensorValue | awk '{print $8 " " $5 " " $10}' >>/Users/grwilde/indigo/INDIGOplotD/sql/sqlcmd.log
echo finished > /Users/grwilde/indigo/INDIGOplotD/sql/635276168-sensorValue.done
date +"%H:%M:%S 006 - Inside Garage Temperature-sensorValue" >>/Users/grwilde/indigo/INDIGOplotD/sql/sqlcmd.log
*
*Skipped Lines
*
/Applications/Postgres.app/Contents/Versions/10/bin/psql indigo_history -U postgres -t -A -F ';' -c " SELECT id, to_char(ts,'YYYYmmddHH24MIss'), value from variable_history_508483491 WHERE value IS NOT NULL AND ID > 22 order by id LIMIT 10000000;" 2>/Users/grwilde/indigo/INDIGOplotD/sql/508483491-value.error | awk -F';' 'NF>2 && !/data unavailable/ {print}' > /Users/grwilde/indigo/INDIGOplotD/sql/508483491-value.sqlOut
/usr/bin/python2.7 '/Library/Application Support/Perceptive Automation/Indigo 7/Plugins/INDIGOplotD.indigoPlugin/Contents/Server Plugin/fixSQLoutput.py' '{"fileDir": "/Users/grwilde/indigo/INDIGOplotD/sql/", "startID": "22", "outputFile": "508483491-value", "logFile": "sqlFix", "inputFile": "508483491-value.sqlout"}'
ls -l -T /Users/grwilde/indigo/INDIGOplotD/sql/508483491-value | awk '{print $8 " " $5 " " $10}' >>/Users/grwilde/indigo/INDIGOplotD/sql/sqlcmd.log
echo finished > /Users/grwilde/indigo/INDIGOplotD/sql/508483491-value.done
echo finished > /Users/grwilde/indigo/INDIGOplotD/sql/sqlcmd.done