mclarenlife
Level 1 (0 points)

Q: Mavericks update messed up my server :( - VPN down, CPU util high. Postgres seems to be the problem

Hey Guys,

 

I just upgraded my server to Mavericks and my server log is filling up with errors. My VPN isnt working anymore and on idle I have 20-30% CPU utilization.

 

Here's a snippet of some errors:

 

Oct 30 23:22:02 dauph.no-ip.biz servermgrd[118]: servermgr_postgres_server: missing postgres config file: /Library/Server/PostgreSQL For Server Services/Config/com.apple.postgres.plist

Oct 30 23:22:02 dauph.no-ip.biz servermgrd[118]: --Module servermgr_swupdate's response has retain count of 3.

Oct 30 23:22:03 dauph kernel[0]: **** [IOBluetoothHostControllerUSBTransport][SuspendDevice] -- Resume -- suspendDeviceCallResult = 0x0000 (kIOReturnSuccess) -- 0x4c00 ****

Oct 30 23:22:12 --- last message repeated 3 times ---

Oct 30 23:22:12 dauph.no-ip.biz mds_stores[103]: (/private/var/folders/zz/zyxvpxvq6csfxvn_n0000000000000/T)(Error) IndexGeneral in void setAttributes(si_set_attr_ctx *, Boolean):Couldn't update index oid:68964342 options:4 updateErr:-1 resolveErr:2

Oct 30 23:22:12 --- last message repeated 1 time ---

Oct 30 23:22:12 dauph.no-ip.biz mds_stores[103]: (/private/var/folders/zz/zyxvpxvq6csfxvn_n0000000000000/T)(Error) IndexStore in int computePath(SIRef, db_obj *, oid_t *, ssize_t *):SIPersistentIDStoreGetParentForOid error:2 at:740 oid:68964303 parent:0

Oct 30 23:22:12 dauph.no-ip.biz mds_stores[103]: (/private/var/folders/zz/zyxvpxvq6csfxvn_n0000000000000/T)(Error) IndexGeneral in void setAttributes(si_set_attr_ctx *, Boolean):Couldn't update index oid:68964303 options:4 updateErr:-1 resolveErr:2

Oct 30 23:22:12 dauph.no-ip.biz mds_stores[103]: (/private/var/folders/zz/zyxvpxvq6csfxvn_n0000000000000/T)(Error) IndexStore in int computePath(SIRef, db_obj *, oid_t *, ssize_t *):SIPersistentIDStoreGetParentForOid error:2 at:740 oid:68964303 parent:0

Oct 30 23:22:12 dauph.no-ip.biz mds_stores[103]: (/private/var/folders/zz/zyxvpxvq6csfxvn_n0000000000000/T)(Error) IndexGeneral in void setAttributes(si_set_attr_ctx *, Boolean):Couldn't update index oid:68964303 options:4 updateErr:-1 resolveErr:2

Oct 30 23:22:41 dauph kernel[0]: **** [IOBluetoothHostControllerUSBTransport][SuspendDevice] -- Suspend -- suspendDeviceCallResult = 0x0000 (kIOReturnSuccess) -- 0x4c00 ****

Oct 30 23:23:05 dauph.no-ip.biz mds[47]: (Normal) Volume: volume:0x7f974c00ce00 ********** Bootstrapped Creating a default store:0 SpotLoc:(null) SpotVerLoc:(null) occlude:0 /Volumes/firmwaresyncd.JuubDp

 

I have a few more errors. though my guess is that they might be linked to this.

 

Can anyone please suggest some fixes; anyidea how I can reset my com.apple.postgres.plist file?

Mac mini (Late 2012), OS X Mavericks (10.9)

Posted on Oct 30, 2013 8:29 PM

Close
mclarenlife

Q: Mavericks update messed up my server :( - VPN down, CPU util high. Postgres seems to be the problem

  • All replies
  • Helpful answers

  • by Linc Davis,

    Linc Davis Linc Davis Oct 30, 2013 11:40 PM in response to mclarenlife
    Level 10 (208,027 points)
    Applications
    Oct 30, 2013 11:40 PM in response to mclarenlife

    Have you installed Server 3?

  • by mclarenlife,

    mclarenlife mclarenlife Oct 31, 2013 2:29 PM in response to Linc Davis
    Level 1 (0 points)
    Oct 31, 2013 2:29 PM in response to Linc Davis

    Yes, im on Server 3.

     

    Kinda feel like Apple should return the money I paid for Server 3. Its crap!

  • by Linc Davis,

    Linc Davis Linc Davis Oct 31, 2013 5:10 PM in response to mclarenlife
    Level 10 (208,027 points)
    Applications
    Oct 31, 2013 5:10 PM in response to mclarenlife

    The VPN service is known to be non-functional in this release. I don't know of a way around that.

     

    What process is using the most CPU cycles?

  • by bfdulock,

    bfdulock bfdulock Oct 31, 2013 5:42 PM in response to Linc Davis
    Level 2 (214 points)
    Oct 31, 2013 5:42 PM in response to Linc Davis

    VPN (L2TP over IPSec) works correctly for me using Mavericks on both server and client.

     

     

    Bryan Dulock

    Apple Consultants Network

    Houston, Texas

  • by Changren Yong,

    Changren Yong Changren Yong Oct 31, 2013 11:27 PM in response to Linc Davis
    Level 1 (108 points)
    Mac OS X
    Oct 31, 2013 11:27 PM in response to Linc Davis

    If you still have a copy of /usr/sbin/racoon from Mountain Lion, you can copy over the one in Mavericks. After a reboot, VPN (L2TP) should work again.

  • by mclarenlife,

    mclarenlife mclarenlife Nov 1, 2013 7:01 AM in response to Linc Davis
    Level 1 (0 points)
    Nov 1, 2013 7:01 AM in response to Linc Davis

    @Linc - kernel_task is usually the one process eating up the cpu.

     

    I google around a bit but dont know if kernel_task process is particular to anything!

     

    @bfdulock - your really lucky! i gave up on trying to get vpn to work with server 3 and mavericks.

     

    @changren - darn, i really dont have a copy of mountain lion around.

     

    the worst part is that, i did a clean install of mavericks and the logs are full of crap errors. postgres sql server files missing, user errors. its bad - i have no idea how Apple could let server 3 past QA!

  • by Changren Yong,

    Changren Yong Changren Yong Nov 1, 2013 8:20 AM in response to mclarenlife
    Level 1 (108 points)
    Mac OS X
    Nov 1, 2013 8:20 AM in response to mclarenlife

    If you have VMWare Fusion or another Mac, just download Mountain Lion from the Mac App Store again and install it on the VM/Mac. You can get the racoon file that way. Or, if you have backed up your Mac before installing Mavericks, just restore that one file.

  • by Linc Davis,Helpful

    Linc Davis Linc Davis Nov 1, 2013 9:12 AM in response to mclarenlife
    Level 10 (208,027 points)
    Applications
    Nov 1, 2013 9:12 AM in response to mclarenlife

    The kernel is using excessive processor cycles. Below are some possible causes for the condition.

    Throttling

    When it gets high temperature readings from the hardware, or a low-voltage reading from the battery, the kernel may try to compensate by interrupting the processor(s) to slow them down and reduce power consumption. This condition can be due to

     

    • a buildup of dust on the logic board
    • high ambient temperature
    • a worn-out or faulty battery in a portable
    • the malfunction of a cooling fan or sensor

     

    Note that if the problem is caused by a sensor, there may be no actual overheating or undervoltage.

    If the computer is portable, test with and without the AC adapter connected. If kernel_task hogs the processor only on battery power, the fault is in the battery or the logic board. If it happens only on AC power, charging is causing the machine to heat up. That may be normal on some models. CPU usage should drop when charging is complete.

    The Apple Hardware Test or Apple Diagnostics, though not very reliable, is sometimes able to detect a bad fan or sensor.

    If nothing is wrong with the hardware, then whatever you can do to improve cooling may help.

    Installed software

    User-installed software that includes a device driver or other kernel code may thrash the kernel. That category includes virtualization software, such as Parallels and VMware, as well as most commercial "anti-virus" products. Some system-monitoring applications, such as "iStat," can also contribute to the problem. You can test for this possibility by completely disabling or removing the software according to the developer's instructions, or booting in safe mode. Note, however, that disabling a system modification without removing it or booting in safe mode may not be as easy as you think it is.

    Corrupt NVRAM or SMC data

    Sometimes the problem is cleared up by resetting the NVRAM or the SMC.

    External display

    Connecting an external LCD display to some MacBook Pro models may cause this issue. If applicable, test by disconnecting the display. You might get better results with a newer LED display.

  • by mclarenlife,

    mclarenlife mclarenlife Nov 1, 2013 9:58 PM in response to Linc Davis
    Level 1 (0 points)
    Nov 1, 2013 9:58 PM in response to Linc Davis

    @Linc Resetting my SMC made the kernel task run away. Atleast CPU is normal now. Tnx!

     

    @Changren - what does the racoon file contain? i just went through a mess with my server backup. To get the dir, I would have to go the VM route. Would take me sometime - so just wanted to make sure thats its a good bet in terms of resolving the Postgres problem?

     

    btw. In the middle of all this I was on the recieving end of a brute force attack on ftp from an ip out of beijing. Go figure

  • by Changren Yong,

    Changren Yong Changren Yong Nov 1, 2013 10:00 PM in response to mclarenlife
    Level 1 (108 points)
    Mac OS X
    Nov 1, 2013 10:00 PM in response to mclarenlife

    Replacing /usr/sbin/racoon fixes the VPN (L2TP) connectivity issue introduced by Mavericks Server.

  • by laundry bleach,

    laundry bleach laundry bleach Dec 19, 2013 2:41 PM in response to Changren Yong
    Level 5 (6,982 points)
    Safari
    Dec 19, 2013 2:41 PM in response to Changren Yong

    Looks like there is a VPN Update for OS X Server that just came out. It requires OS X 10.9.1. Installing it myself now.

     

    Good luck to everyone.

  • by konarzed,

    konarzed konarzed Jan 3, 2014 12:54 PM in response to laundry bleach
    Level 1 (5 points)
    Jan 3, 2014 12:54 PM in response to laundry bleach

    @laundry bleach: Did you get the VPN to work by installing OS X 10.9.1 on OS X Server 3.0.1?

     

    I am considering upgrading to Mavericks, but I am affraid to lose my VPN connection. Besides, I don't know how to find the file /usr/sbin/racoon mentioned above. Can you help?

     

    Thanks!

  • by Robb Allan,

    Robb Allan Robb Allan Mar 25, 2014 4:06 PM in response to mclarenlife
    Level 2 (354 points)
    Servers Enterprise
    Mar 25, 2014 4:06 PM in response to mclarenlife

    sudo -s

    ln -s /Library/Server/Postgres/Config /Library/Server/Postgres\ For\ Server\ Services/Config

    ln -s /Library/Server/Postgres/Data /Library/Server/Postgres\ For\ Server\ Services/Data

    serveradmin start postgres

  • by Robb Allan,

    Robb Allan Robb Allan Mar 25, 2014 7:59 PM in response to Robb Allan
    Level 2 (354 points)
    Servers Enterprise
    Mar 25, 2014 7:59 PM in response to Robb Allan

    Modify that:

     

    1. sudo -s
    2. serveradmin stop postgres
    3. cp -R /Library/Server/Postgres/Config /Library/Server/Postgres\ For\ Server\ Services/
    4. cp -R /Library/Server/Postgres/Data /Library/Server/Postgres\ For\ Server\ Services/
    5. cd /Library/Server/Postgres\ For\ Server\ Services/Config/
    6. mv org.postgresql.postgres.plist com.apple.postgres.plist
    7. edit com.apple.postgres.plist: change "/Library/Server/PostgreSQL/Data" to "/Library/Server/PostgreSQL For Server Services/Data"
    8. serveradmin start postgres