This discussion is locked
V.J.

Q: unexpected eof on client connection

Our FCS froze. Rebooting does not fix the problem. I can see tons of 'unexpected eof on client connection' lines in system log.
Is our database corrupted? What do you suggest first thing to troubleshot this?

Thanks

VJ

Mac OS X (10.6.3)

Posted on Aug 3, 2010 8:27 PM

Close

Q: unexpected eof on client connection

  • All replies
  • Helpful answers

  • by Minas Morgul,

    Minas Morgul Minas Morgul Aug 4, 2010 9:11 AM in response to V.J.
    Level 1 (0 points)
    Aug 4, 2010 9:11 AM in response to V.J.
    Final Cut Server runs on top of a PostgreSQL database, and it usually freezes when something gets jammed into an event table. Rebooting the system will not fix this, you have to go into the database and clear the tables manually. Having the SQL skills and the know how to do this is the first mountain to climb. The second is that fact that Apple has hidden away the PostgreSQL backend utility, so you'll have to first figure out how to get that running.

    Do you have the chops to push an SQL database around?
  • by V.J.,

    V.J. V.J. Oct 31, 2010 8:04 PM in response to Minas Morgul
    Level 1 (0 points)
    Oct 31, 2010 8:04 PM in response to Minas Morgul
    Thanks Minas
    Yes I did a little research and found command lines to tackle database.
    I am not afraid to go backdoor into the database just not sure how would I find corrupted record(s). It looks like it is time consuming troubleshoot process so
    we polled the last known good image (couple of months old) and rebuild it to the latest.
    VJ
  • by John F. Whitehead,

    John F. Whitehead John F. Whitehead Nov 3, 2010 8:11 PM in response to V.J.
    Level 2 (380 points)
    Nov 3, 2010 8:11 PM in response to V.J.
    It's not that hard to clear out the queue.

    Apple has now documented it in the Apple Pro Training Series book Final Cut Server 1.5 by Drew Tucker, published by Peachpit (<http://peachpit.com>) and available at fine booksellers everywhere.
  • by Minas Morgul,

    Minas Morgul Minas Morgul Nov 4, 2010 8:27 PM in response to John F. Whitehead
    Level 1 (0 points)
    Nov 4, 2010 8:27 PM in response to John F. Whitehead
    Can you tell me on what page I will find the complete breakdown of the syntax and usage of the 'fcsvr_client' utility?
  • by John F. Whitehead,

    John F. Whitehead John F. Whitehead Nov 5, 2010 7:51 AM in response to Minas Morgul
    Level 2 (380 points)
    Nov 5, 2010 7:51 AM in response to Minas Morgul
    (Your question sounds like a troll, but I'll answer for the benefit for anyone that does not know.)

    The book doesn't provide complete documentation on the command, just how it can be used in a couple of situations.

    You can get fairly complete, albeit basic, syntax/usage info by running the command with no arguments.

    You can also learn a lot by doing the FinalCutServerIntegrationSample.
  • by Minas Morgul,

    Minas Morgul Minas Morgul Nov 5, 2010 8:23 AM in response to John F. Whitehead
    Level 1 (0 points)
    Nov 5, 2010 8:23 AM in response to John F. Whitehead
    I took the time to write out a detailed and informative paragraph in response to the original poster's issue. You copied and pasted a link for people to go out and buy some book. So who's acting more like a troll?

    There is no API for Final Cut Server. The only thing you can do is to use XML and the 'fcsvr_client' utilities in order to communicate with another application. Is it asking too much for Apple to provide us all (not just a few 'chosen insiders') with complete documentation for the 'fcsvr_client' utility?
  • by John F. Whitehead,

    John F. Whitehead John F. Whitehead Nov 5, 2010 9:04 AM in response to Minas Morgul
    Level 2 (380 points)
    Nov 5, 2010 9:04 AM in response to Minas Morgul
    You said the answer was "hidden away" and "you'll have to first figure out how" and "Do you have the chops," implying you knew but wouldn't tell. That wasn't an informative answer at all.

    I provided a link to the book where the answer is documented by Apple.

    Then you asked me "on what page I will find the complete breakdown," though you apparently knew the answer already, just to set up your complaint.
  • by Minas Morgul,

    Minas Morgul Minas Morgul Nov 5, 2010 10:53 AM in response to John F. Whitehead
    Level 1 (0 points)
    Nov 5, 2010 10:53 AM in response to John F. Whitehead
    I don't believe in 'spoon feeding' people the answers to complex issues, like clearing things out of a live PostgreSQL database. I expect people to have a grasp of the basics before I plunge in and help them. If he went out and bought a PostgreSQL book, or even a copy of 'SQL for Dummies', and started learning the basics, then he will acquire skills that will help him way beyond Final Cut Server.

    I wasn't really 100% certain of the answer to the '..what page?' question, since I have not obtained or looked through the new book.