SharePoint Publishing Site Slow to Load Pages: An unexpected error occured while manipulating the navigational structure of this Web

One of our SharePoint Web Application is running extremely slow. It often takes about 2 to 3 minutes to load one single page. All other web applications are running as fast as they should be.

Called DBA and DBA reported there are blockings in the content database. It comes and goes.

Looked into SharePoint Logs and here is what we found:
System.Data.SqlClient.SqlException: Transaction (Process ID 212) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction
PortalSiteMapProvider was unable to fetch children for node at URL: /subsite, message: An unexpected error occured while manipulating the navigational structure of this Web.

It looks like something wrong with this subsite’s navigations.

Went to navigation settings on the root level of the site: http://sharepoint_site/_layouts/AreaNavigationSettings.aspx and removed /subsite from the global navigation. Click OK button and the site is as fast as before.

Except the /subsite. Tried to open http://sharepoint_site/subsite/_layouts/AreaNavigationSettings.aspx but it is almost impossible to get the page load.

Opened the subsite using SharePoint designer, navigate into Pages library. Removed all recently modified publishing pages. Went back to the browser to test the site, and it was gooooooooooooood.

Restore the page one by one, surprisely the issue didn’t occur.

I believe somehow there is a stalled update in the navigations. It never finished and always tried to update the database. By resetting the navigation, it cleared the issue out.

 

 

Read More

Yahoo SMTP Server: Delivery Temporarily Suspended

Recently the outgoing messages to Yahoo from my Linux boxes are all deferred. The linux box hosts a website which contains a webform, which sends about 200 mails to 100 subscribed accounts, which is about 20K messages per day. About 13 accounts are Yahoo addresses. I use Postfix and below is the results from “mailq”.
7AE4531F83EE 1895 Fri Apr 5 22:08:17 apache@myhostname
(delivery temporarily suspended: lost connection with mta7.am0.yahoodns.net[66.196.118.35] while performing the HELO handshake)
xxxx@yahoo.com

 

Tried to telnet to port 25 of Yahoo’s SMTP server, and this is the message:
421 4.7.0 [TS02] Messages from xx.xx.xx.xxx temporarily deferred – 4.16.56.1; see http://postmaster.yahoo.com/errors/421-ts02.html
Connection closed by foreign host.
Contacted Yahoo using two online forms:

1. Yahoo! Mail Delivery Issues Form

2. Yahoo! Mail Bulk Sender Form

I submitted the form On Sunday, got reply from Yahoo for the second form on following Tuesday. Here is the response:

Thank you for contacting Yahoo! Mail.

The information you have sent us has been updated in our system. Feel free to test things out and let us know if you experience any problems, so we may assist you further to resolve your issue.

Your patience during this process is greatly appreciated.

Thank you again for contacting Yahoo! Mail.

Regards,

Yahoo! Customer Care

Checked the server, the mails are still deferred and total number of mails in the mailq is still rising.

So I followed up with Yahoo using the first form again, with the incident ID I got earlier. Got response within 3 hours:

Thank you for contacting Yahoo! Mail.

We have reviewed the IP information you have provided and made the appropriate changes in our database. As a result, the recent deferrals you have referenced in your report should now be resolved.

If you need further assistance or to see the latest information with regard to delivery to Yahoo! Mail, please visit:
Your patience during this process is greatly appreciated.

Thank you again for contacting Yahoo! Mail.

Regards,
Yahoo! Customer Care

After getting this mail, I checked the server and half of the queue has been cleared (about 3500 messages were sent).

 

Read More