Skip to main content
Participant
March 15, 2014
Question

Coldfusion 10 iis process restart every 900 seconds

  • March 15, 2014
  • 1 reply
  • 459 views

Dear All CF GURU,

There have been a bug that troubling me.

I have a mysql dump process as code below and it will keep restart the process around every 900 seconds.

<cfsetting requesttimeout="72000">
<cfquery name="backupdb" datasource="main">
SELECT schema_name FROm information_schema.SCHEMATA where schema_name <> "information_schema" and schema_name <> "mysql"
</cfquery>
<cfloop query="backupdb" >
<cfset dts = backupdb.schema_name>
<cfset currentDirectory = "C:\DAILYBACKUP\"& dts>
<cfif DirectoryExists(currentDirectory) eq false>
<cfdirectory action = "create" directory = "#currentDirectory#" >
</cfif>
<cfset filename=dts&"_"&dateformat(now(),'YYYYMMDD')&"_"&timeformat(now(),'HHMMSS')&"_"&GetAuthUser()&"_DAILY.sql">
<cfset currentdirfile=currentDirectory&"\"&filename>
<cfexecute name = "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump"
    arguments = "--user=root --password=xxxxxx #dts#" outputfile="#currentdirfile#" timeout="3600">
</cfexecute>
</cfloop>

<cfzip source="C:\DAILYBACKUP" action="zip" file="C:\DAILY_BACKUP_#dateformat(now(),'YYYYMMDD')#_#timeformat(now(),'HHMMSS')#.zip" overwrite="yes">

<cfdirectory action="delete" directory="C:\DAILYBACKUP\" recurse="yes">

As picture below, it has run the cfexecure for 4 times before the whole process end.

The process wil ltake around 1 to 2 hours and as in server monitor, it will start a new same process every 900 seconds.

The process is run through schedule task but i try with IE still facing the same issue.

This topic has been closed for replies.

1 reply

BKBK
Community Expert
Community Expert
March 15, 2014

Lancelotling wrote:

The process wil ltake around 1 to 2 hours and as in server monitor, it will start a new same process every 900 seconds.

The process is run through schedule task....

Then the relevant code to examine is that of the scheduled task!

Participant
March 18, 2014

The code is run through coldfusion schedule task.

BKBK
Community Expert
Community Expert
March 18, 2014

Please give us as many details of the scheduled task as possible, preferably all.