Hello Jess,
I have tried everything whatever you have mentioned above
But i am still facing issue with
select * from kalturadw.dwh_fact_events where event_date_id >=%Y%m%d ;
query not showing any data in dwh_fact_events…
Can you tell me how to come up with this error ?
and I am getting this output in
tail -f /opt/kaltura/log/kaltura_apache_access.log
127.0.0.1 - - [23/Oct/2015:20:45:35 +0530] “POST /api_v3/index.php?service=contentdistribution_contentdistributionbatch&action=createRequiredJobs HTTP/1.1” 200 416 5/5050139 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31222 2142830984 - 625 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:20:45:42 +0530] “POST /api_v3/index.php?service=livestream&action=list HTTP/1.1” 200 486 1/1213335 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31346 531585370 - 779 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:20:45:38 +0530] “POST /api_v3/index.php?service=batchcontrol&action=reportStatus HTTP/1.1” 200 4213 5/5876144 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31221 231891248 - 9455 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:20:45:54 +0530] “POST /api_v3/index.php?service=system&action=ping HTTP/1.1” 200 477 0/1322 “-” “-” “-” 127.0.0.1 “cached-dispatcher,cache_v3-4573cb1b41aa602d154d9108d17cdd50,0.00014519691467285” “abc.wddemo.com” 31224 - - 558 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:20:45:54 +0530] “POST /api_v3/index.php?service=batch&action=updatePartnerLoadTable HTTP/1.1” 200 415 0/894804 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31340 725979446 - 584 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:20:45:55 +0530] “POST /api_v3/index.php?service=batch&action=suspendJobs HTTP/1.1” 200 416 0/702079 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31217 1978743820 - 568 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:20:45:54 +0530] “POST /api_v3/index.php?service=batch&action=cleanExclusiveJobs HTTP/1.1” 200 413 2/2652912 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31218 1265582244 - 572 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:20:45:54 +0530] “POST /api_v3/index.php?service=batchcontrol&action=reportStatus HTTP/1.1” 200 4213 19/19063564 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31223 162208650 - 9571 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:20:46:13 +0530] “POST /api_v3/index.php?service=livestream&action=list HTTP/1.1” 200 487 0/754958 “-” “-” “-” 127.0.0.1 “-” “abc.wddemo.com” 31219 1378412699 - 778 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
127.0.0.1 - - [23/Oct/2015:20:46:15 +0530] “POST /api_v3/index.php?service=system&action=ping HTTP/1.1” 200 477 0/1588 “-” “-” “-” 127.0.0.1 “cached-dispatcher,cache_v3-4573cb1b41aa602d154d9108d17cdd50,0.00017309188842773” “abc.wddemo.com” 31220 - - 557 “-” “-” “-” “-” “no-store, no-cache, must-revalidate, post-check=0, pre-check=0” -1
And out put for :- logrotate -vvv -f /etc/logrotate.d/kaltura_apache
reading config file /etc/logrotate.d/kaltura_apache
reading config info for /opt/kaltura/log/kaltura_apache_errors.log
error: /etc/logrotate.d/kaltura_apache:12 unknown option ‘root’ – ignoring line
error: /etc/logrotate.d/kaltura_apache:12 unexpected text
reading config info for /opt/kaltura/log/kaltura_apache_access.log
error: /etc/logrotate.d/kaltura_apache:26 unknown option ‘root’ – ignoring line
error: /etc/logrotate.d/kaltura_apache:26 unexpected text
reading config info for /opt/kaltura/log/kaltura_apache_errors_ssl.log
error: /etc/logrotate.d/kaltura_apache:40 unknown option ‘root’ – ignoring line
error: /etc/logrotate.d/kaltura_apache:40 unexpected text
reading config info for /opt/kaltura/log/kaltura_apache_access_ssl.log
error: /etc/logrotate.d/kaltura_apache:54 unknown option ‘root’ – ignoring line
error: /etc/logrotate.d/kaltura_apache:54 unexpected text
Handling 4 logs
rotating pattern: /opt/kaltura/log/kaltura_apache_errors.log forced from command line (5 rotations)
empty log files are not rotated, old logs are removed
considering log /opt/kaltura/log/kaltura_apache_errors.log
log needs rotating
rotating log /opt/kaltura/log/kaltura_apache_errors.log, log->rotateCount is 5
dateext suffix '-20151023’
glob pattern '-[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
destination /opt/kaltura/log/kaltura_apache_errors.log-20151023.gz already exists, skipping rotation
rotating pattern: /opt/kaltura/log/kaltura_apache_access.log forced from command line (5 rotations)
empty log files are not rotated, old logs are removed
considering log /opt/kaltura/log/kaltura_apache_access.log
log needs rotating
rotating log /opt/kaltura/log/kaltura_apache_access.log, log->rotateCount is 5
dateext suffix '-20151023’
glob pattern '-[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
glob finding old rotated logs failed
renaming /opt/kaltura/log/kaltura_apache_access.log to /opt/kaltura/log/kaltura_apache_access.log-20151023
compressing log with: /bin/gzip
running last action script
Reloading httpd:
rotating pattern: /opt/kaltura/log/kaltura_apache_errors_ssl.log forced from command line (5 rotations)
empty log files are not rotated, old logs are removed
considering log /opt/kaltura/log/kaltura_apache_errors_ssl.log
log /opt/kaltura/log/kaltura_apache_errors_ssl.log does not exist – skipping
not running postrotate script, since no logs were rotated
rotating pattern: /opt/kaltura/log/kaltura_apache_access_ssl.log forced from command line (5 rotations)
empty log files are not rotated, old logs are removed
considering log /opt/kaltura/log/kaltura_apache_access_ssl.log
log /opt/kaltura/log/kaltura_apache_access_ssl.log does not exist – skipping
not running last action script, since no logs will be rotated