update fedora live table to set collection id to "rucore00000002073"

Project:RUcore Jobs & Reports
Component:Job - production server
Category:task
Priority:normal
Assigned:jgeng
Status:closed
Description

After Jeffery moved 1404 objects form collection njedl to collection "rucore00000002073" , fedoralive table need to be updated as well. Scripts will be provided on the release date.

Comments

#1

Status:active» test

A script is ready for production only

#2

Assigned to:jgeng» rjantz

Ron, please test this on production server. If it is fixed, please close this issue.

Thanks

#3

Assigned to:rjantz» dhoover

Hi Dave,

I have the script ready to run on production stats database to test if this bug is fixed.

the script is on test server under my home directory

/home/jgeng/script_for_dave/check objects collection in fedoralive table for 7.4.txt

Please run it and report with the results.

Thanks,
Jie

#4

Project:RUcore Statistics» RUcore Jobs & Reports
Version:7.4» <none>
Component:Miscellaneous» Job - production server

#5

Assigned to:dhoover» jgeng
Status:test» active

Sorry, I should of responded sooner.

What I say about all reports holds true to this one.

Please package this as a script that will run and capture any necessary
output into a file. It should not rely on me redirecting to a file.

Please place it in /mellon/cvsroot the delivery point for all scripts.

Please do not use blank spaces in files names.

#6

Assigned to:jgeng» dhoover

Please find script job2551.sql in /mellon/cvsroot/. The result should be all with collection id rucore00000002073.

Thanks,

#7

Assigned to:dhoover» jgeng

While not a script that captures its own output as requested, at
least it was in /mellon/cvsroot and the filename had no spaces.

I ran the following to capture the output.

/usr/bin/mysql -u root -p stats_prod < job2551.sql > job2551.txt

Attached is the output.

#8

Dave,

We hear you. We'll work on that for the next time. Because there is always a next time....

Chad

#9

Status:active» closed

Dave,

Thanks!!

Back to top