Final Cut Server

Vacuum the database:

/Library/Application\ Support/Final\ Cut\ Server/Final\ Cut\ Server.bundle/Contents/Resources/sbin/fcsvr_run psql px pxdb -c “vacuum analyze verbose;”

May want to add the vacuum FULL

/Library/Application\ Support/Final\ Cut\ Server/Final\ Cut\ Server.bundle/Contents/Resources/sbin/fcsvr_run psql px pxdb -c “vacuum FULL analyze verbose;”

Flush the responses queue:

sudo /Library/Application\ Support/Final\ Cut\ Server/Final\ Cut\ Server.bundle/Contents/MacOS/fcsvr_client flush_response_queue

Check for stuck responses:

/Library/Application\ Support/Final\ Cut\ Server/Final\ Cut\ Server.bundle/Contents/Resources/sbin/fcsvr_run psql px pxdb -c “select * from pxeventresponse;” | grep row

Command line to hard delete assets:

fcsvr_client setmd /asset/383324 LOCK_VEC=

 

1.5 connection to postgres

bin/psql -p 8820 -d px -U postgres

pgadmin settings

Name: FCS
Port: 8820
Maintenance DB: postgres
Username: postgres
Store password: checked
Restore env?: checked

“With nothing to lose, since my DB is backed up, I ran through every command. I should mention that I was logged in as root, as sudo just made it more difficult. Here is my summary:

1. Delete and recreate symlinks:
cd "/Library/Application Support/Final Cut Server/Final Cut Server.bundle/Contents/PostgreSQL/lib" [this is all one line] for x in `ls`; do rm /usr/lib/$x; done for x in `ls`; do ln -s "$PWD/$x" /usr/lib; done

2. Connect to the database, set jobs as complete and delete them:
cd .. bin/psql -p 8820 -d px -U postgres update pxeventresponse set eventstatusid=3; delete from pxeventresponse; \q

3. Restart final cut server

I probably didn’t need to set the jobs to complete just to delete them, but I’m posting it because it worked.”

“Just a thought – in your case the queue could be filling up because nothing deletes the XML file so when the file is read, it’s invalid, nothing is done so it reads again and again until the queue fills up.

Do you have a ‘Delete Always’ response after the ‘Read XML’? That might stop things overflowing.”

Helpful Links:

http://forums.creativecow.net/thread/249/881

https://discussions.apple.com/thread/2524907?start=0&tstart=0

Final Cut Server Scripts & Apps

These are a few misc scripts and automater apps I’ve made for people to make things a bit easier on them. This is an automater app that will stop the Final Cut Server, and restart it via command line through a double clickable app. Restart Final Cut Server App This is an automater app that …

View page »

Leave a Reply