Slow Controls Time History - Revision history

129.57.167.4 at 22:07, 19 March 2010

2010-03-19T22:07:23Z

← Older revision		Revision as of 18:07, 19 March 2010
Line 71:		Line 71:

	</font>		</font>

			'''NOTE''': password to slow control timeline to add or delete: ''arne''.

Boiarino at 14:20, 6 April 2009

2009-04-06T14:20:36Z

← Older revision		Revision as of 10:20, 6 April 2009
Line 1:		Line 1:
			Produces Web-based timeline plots, can be viewed on http://clasweb.jlab.org/cgi-bin/epics_history/epics.pl.

	Resides in CVSROOT=/home/epics/cvs, normally checked out to /home/epics/history and running on clon01 as user ''epics''.		Resides in CVSROOT=/home/epics/cvs, normally checked out to /home/epics/history and running on clon01 as user ''epics''.

Boiarino at 19:16, 16 January 2007

2007-01-16T19:16:17Z

← Older revision		Revision as of 15:16, 16 January 2007
Line 34:		Line 34:
	mysqldump -uroot -pe1tocome epics \| gzip > /home/epics.sql.gz		mysqldump -uroot -pe1tocome epics \| gzip > /home/epics.sql.gz
	mysqldump: Can't get CREATE TABLE for table `hallb_sf_xy560_0_12_1min` (Can't open file: 'hallb_sf_xy560_0_12_1min.MYI'. (errno: 145))		mysqldump: Can't get CREATE TABLE for table `hallb_sf_xy560_0_12_1min` (Can't open file: 'hallb_sf_xy560_0_12_1min.MYI'. (errno: 145))
			one table:
			mysqldump -uroot -pe1tocome epics hallb_sf_xy560_0_12_1hr > 1hr.sql
			(works)
			mysqldump -uroot -pe1tocome epics hallb_sf_xy560_0_12_1min > 1min.sql
			mysqldump: Can't get CREATE TABLE for table `hallb_sf_xy560_0_12_1min` (Can't open file: 'hallb_sf_xy560_0_12_1min.MYI'. (errno: 145))


	Following command produce error message but runs (took about 33 minutes):		Following command produce error message but runs (took about 33 minutes):

Boiarino at 19:59, 11 January 2007

2007-01-11T19:59:02Z

← Older revision		Revision as of 15:59, 11 January 2007
Line 9:		Line 9:
	Cron job is checking if main script is running (if not it will try to restart it):		Cron job is checking if main script is running (if not it will try to restart it):

	0,15,30,45 * * * * /home/epics/history/www/check_get.pl		0,15,30,45 * * * * (/bin/tcsh -c /home/epics/history/www/check_get.pl >> /dev/null)

	If started by cron job, log file ''/home/epics/history/log/get_latest_cont.log'' will be produced		If started by cron job, log file ''/home/epics/history/log/get_latest_cont.log'' will be produced

Boiarino at 19:57, 11 January 2007

2007-01-11T19:57:30Z

← Older revision		Revision as of 15:57, 11 January 2007
Line 32:		Line 32:

	cd /home		cd /home
	mysqldump -uroot -pe1tocome epics \| gzip > /~~misc/mysql/clasweb-bck~~/epics.sql.gz		mysqldump -uroot -pe1tocome epics \| gzip > /home/epics.sql.gz
	mysqldump: Can't get CREATE TABLE for table `hallb_sf_xy560_0_12_1min` (Can't open file: 'hallb_sf_xy560_0_12_1min.MYI'. (errno: 145))		mysqldump: Can't get CREATE TABLE for table `hallb_sf_xy560_0_12_1min` (Can't open file: 'hallb_sf_xy560_0_12_1min.MYI'. (errno: 145))

Boiarino at 17:52, 11 January 2007

2007-01-11T17:52:51Z

← Older revision		Revision as of 13:52, 11 January 2007
Line 11:		Line 11:
	0,15,30,45 * * * * /home/epics/history/www/check_get.pl		0,15,30,45 * * * * /home/epics/history/www/check_get.pl

	~~CURRENTLY GOES TO /dev/null !!!~~ If started by cron job, log file ''/home/epics/history/log/get_latest_cont.log'' will be produced.		If started by cron job, log file ''/home/epics/history/log/get_latest_cont.log'' will be produced
			<font color=red>
			(CURRENTLY GOES TO /dev/null !!!)
			</font>

	Database ''epics'' on ''clondb1'' was creates as follwoing:		Database ''epics'' on ''clondb1'' was creates as follwoing:

Boiarino at 17:12, 11 January 2007

2007-01-11T17:12:41Z

← Older revision		Revision as of 13:12, 11 January 2007
Line 48:		Line 48:

	(last command took about 19 minutes).		(last command took about 19 minutes).

			<font color=red>

	TODO:		TODO:
Line 56:		Line 58:
	'/home/epics/history/log/get_latest_cont.log1'; currently script is writing to /dev/null		'/home/epics/history/log/get_latest_cont.log1'; currently script is writing to /dev/null
	so log file can be used to see what was wrong		so log file can be used to see what was wrong

			</font>

Boiarino at 17:10, 11 January 2007

2007-01-11T17:10:12Z

← Older revision		Revision as of 13:10, 11 January 2007
Line 54:		Line 54:

	when script 'get_latest_cont.pl' was started it produced the number of errors into log file		when script 'get_latest_cont.pl' was started it produced the number of errors into log file
	'/home/epics/history/log/get_latest_cont.~~log~~'; currently script is writing to /dev/null		'/home/epics/history/log/get_latest_cont.log1'; currently script is writing to /dev/null
	so log file can be used to see what was wrong		so log file can be used to see what was wrong

Boiarino at 17:05, 11 January 2007

2007-01-11T17:05:42Z

← Older revision		Revision as of 13:05, 11 January 2007
Line 51:		Line 51:
	TODO:		TODO:

	understand ~~previous~~ errors		understand errors reported by 'mysqldump'; fix database if necessary

	when script 'get_latest_cont.pl' was started it produced the number of errors into log file		when script 'get_latest_cont.pl' was started it produced the number of errors into log file
	'/home/epics/history/log/get_latest_cont.log'; currently script is writing to /dev/null		'/home/epics/history/log/get_latest_cont.log'; currently script is writing to /dev/null
	so log file can be used to see what was wrong		so log file can be used to see what was wrong

Boiarino at 17:04, 11 January 2007

2007-01-11T17:04:17Z

← Older revision		Revision as of 13:04, 11 January 2007
Line 11:		Line 11:
	0,15,30,45 * * * * /home/epics/history/www/check_get.pl		0,15,30,45 * * * * /home/epics/history/www/check_get.pl

	If started by cron job, log file ''/home/epics/history/log/get_latest_cont.log'' will be produced.		CURRENTLY GOES TO /dev/null !!! If started by cron job, log file ''/home/epics/history/log/get_latest_cont.log'' will be produced.

	Database ''epics'' on ''clondb1'' was creates as follwoing:		Database ''epics'' on ''clondb1'' was creates as follwoing:
Line 26:		Line 26:


	DUMPING FROM clasweb-bck:		IMPORTANT: DUMPING FROM clasweb-bck:

	cd /home		cd /home
Line 32:		Line 32:
	mysqldump: Can't get CREATE TABLE for table `hallb_sf_xy560_0_12_1min` (Can't open file: 'hallb_sf_xy560_0_12_1min.MYI'. (errno: 145))		mysqldump: Can't get CREATE TABLE for table `hallb_sf_xy560_0_12_1min` (Can't open file: 'hallb_sf_xy560_0_12_1min.MYI'. (errno: 145))

	Following command produce error message but runs:		Following command produce error message but runs (took about 33 minutes):

	mysqldump -f -l --opt -uroot -pe1tocome epics \| gzip > /home/epics.sql.gz		mysqldump -f -l --opt -uroot -pe1tocome epics \| gzip > /home/epics.sql.gz
Line 46:		Line 46:
	gunzip epics.sql.gz		gunzip epics.sql.gz
	mysql -u root -p epics < epics.sql		mysql -u root -p epics < epics.sql

			(last command took about 19 minutes).

			TODO:

			understand previous errors

			when script 'get_latest_cont.pl' was started it produced the number of errors into log file
			'/home/epics/history/log/get_latest_cont.log'; currently script is writing to /dev/null
			so log file can be used to see what was wrong