Crontab job bombs
Posted in 1995
Topics: Installation, Setup & Upgrades, Connectivity: ESQL/C, 4GL & Embedded SQL, Internationalization & Character Sets
Crontab job bombs (sounds like some terrorist ploy, eh?)
Simply stated, I run an informix job to generate our Class Schedule
listings for our Gopher server.
It runs fine from a terminal.
It bombs when run from a cron entry.
The shell script looks like:
#! /usr/bin/ksh
DBPATH=/u/informix:/u/gopher/schedmast
INFORMIXDIR=/usr/informix
PATH=$PATH:$INFORMIXDIR/bin
export DBPATH INFORMIXDIR PATHcd /u/gopher/schedmast
/usr/bin/env <-- stuck in for debugging
echo ----- Loading schedule into database
/u/gopher/schedmast/schedload.4ge
echo ----- Generating class schedule listings
/u/gopher/schedmast/schedrp2.4ge
echo ----- Done!
The cron output I get looks like:
From daemon Wed Mar 29 11:16:18 1995
Received: by rs6000.adm.fau.edu (AIX 3.2/UCB 5.64/4.03)
id AA08376; Wed, 29 Mar 1995 11:16:17 -0500
_=/usr/bin/env
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/prime/%N
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/informix/bin
DBPATH=/u/informix:/u/gopher/schedmastUSER=gopher
SHELL=/bin/ksh
HOME=/u/gopher
INFORMIXDIR=/usr/informixTERM=dumb
PWD=/u/gopher/schedmast
----- FTPing latest schedmast from AS/400
----- Using SED to change / to -
----- Loading schedule into database
Program stopped at "schedload.4gl", line number 4.
SQL statement error number -408.
Invalid message type received from the sqlexec process.
----- Generating class schedule listings
Program stopped at "schedrp2.4gl", line number 30.
SQL statement error number -408.
Invalid message type received from the sqlexec process.
----- Done!
The statement bombing in both instances is a plain isql statement;
DELETE in the first case, SELECT in the second.
I had this bug a year ago and thought I'd fixed it with the proper environment
variables, and by making sure my compilations were up to the latest versions
(a system upgrade produced this same bug once.) No such circumstances this
time.
stumped!
----\\____/----\\____/----\\____/----\\____/----\\____/----\\____/----\\____/
"Basically, I believe in peace and bashing two bricks together."
- Archbishop Gumby, Monty Pythons Flying Circus
barton@rs6000.adm.fau.edu -- Florida Atlantic University, Boca Raton, FL
http://www.fau.edu/barton/home.html