• State Not Answered
  • Replies 6 replies
  • Subscribers 93 subscribers
  • Views 2407 views
  • Users 0 members are here
Options
Related

Job servers keep in "Update Running" state, and software version keep in "-1"

tac.su
over 3 years ago

Hi experts,

I'm evaluating the approach of upgrading server from 7.1.6 to v8.

I deployed new servers with newer OS and SQL version, and restore the original DB to the new server, updated job server list and sync server reference in sync editor, reinstalled application server, checked data consistency, all seems fine.

However, in Job Queue, the jobs are not processing, and the job servers keep in "Update running" state with software version "-1". I browsed the job server in browsers, there is no error in the log, but just keep repeating info "Requesting process steps for queue \XXXX (job server name) / Last process step request succeeded."

Where can I know what was wrong, so that I may fix it? Please kindly advise.

Many thanks!

Tac

Parents Reply Children
  • 0 over 3 years ago in reply to Markus Weiss-Ehlers

    Hi Marcus, 

    Database journal showed some warning that the database "STOP because too many Slots are dead." and "Dead slot resetted".

    I ran the queries following the steps in the provided url to create new service broker ID and initializing DBQueue Processor, and restarted services, there are some tasks appears in the DBQueue and gone from time to time, so I think the DB Queue processor is running. But still the Job queue is not processed and the job server state is still "Update running".

    Anymore things I can do?

  • 0 over 3 years ago in reply to tac.su

    If the DB Queue is now running and no new errors are showing in the Database Journal, then please check the Job Queue if there are update processes for the Job Servers. If not then try to set the flag IsInSoftwareUpdate in table QBMServer to 0 for the job servers.

  • 0 over 3 years ago in reply to Markus Weiss-Ehlers

    There are some processes of "fire event Checkversion for object type QBMServer", "fire event DeployTargetChanged for object type QBMServer" " fire event GetConfig for object type QBMServer", are any of them related to update processes? 

    I tried to set the flag IsInSoftwareUpdate in table QBMServer to 0, but it automatically changed back to 1.

    If the job queue processes are triggered for orphaned job servers before migration, can they be forcibly terminated?

  • 0 over 3 years ago in reply to tac.su

    Yes, these are related to the update process.

    You can remove the processes for the orphaned job servers by selecting them in Job Queue Info and pressing CTRL+D

    And, is one (and only one) of your new job servers marked as "Update Server" in the list fo server functions?

  • 0 over 3 years ago in reply to tac.su

    I found an old post about how to kill running job queues, it can be done by pressing Ctrl-D, so I did it to the orphaned processes, and then the job server update process can be initialized, and the job servers are updated now.