[Solved] The Directory ‘/APP_GlobalResources/’ is not allowed because the application is precomplied

Dear All,

While working on website shifting task , I came through intresting error inspite our applications are not precomplied .

The error was

The Directory ‘/APP_GlobalResources/’ is not allowed because the application is precomplied

error

Solution :- Delete the “PrecompiledApp.config” file from web application folder and re-start your application.

 

Thanks

Prashant Deshpande

Leave a comment

Filed under Uncategorized

There was an error while performing this operation IIS 7.5

Dear All,

Faced one new issue while shifting websites from one IDC to AMAZON cloud, I have configured websites as generally we configure and set the application pool also

When I was trying to open any feature from feature panel of that website it was giving error

There was an error while performing this operation in IIS 7.5

err1

The error message was blank so it was very difficult task to identify the error as nothing was getting on net also.

Checked permissions and found permissions were as required so tried to browse the website  but here also it was showing below error from which we couldn’t get the exact cause of error

500.19

There was no option for getting the exact error code / message which will help to troubleshoot , followed below steps to identify the cause

  • Opened Web.config and started removing tags one by one like removed <httphandlers >, <httpmoudles>
  • Still same error
  • Removed custom error tag
  • Still same error
  • Removed <applicationInitialization doAppInitAfterRestart=”true” />
  • Error gone away and website started browsing

After checking for the tag details came to know it is for Optimizing Application Initialization Module for IIS and for make website running along with the tag inside web.config we need to install

Application Initialization Module for IIS 7.5 extension on Server

Downloaded and installed it from http://www.iis.net/downloads/microsoft/application-initialization , then added the above tag and website started running.

Thanks

Prashant Deshpande

Leave a comment

Filed under Uncategorized

How to handle transaction rollback in progress. Estimated rollback completion

Dear All,

On one fine morning when I saw on one of our database server , SQL full weekly backup job was running since 8 hours , which was a very higher side as the database size was small so checked for SPID and given kill command for that SPID .

The message came was “command executed successfully” in background the killed SPID went in transaction roll back state.

Message shown once I tried to kill again the same SPID was

“SPID 87: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds “

The same message was coming even after 15 mins , now the question appearing in my mind was how to forcefully stop this SPID.

I know all things works in MSSQL is with threads, each thread has different work so if I could get the thread I can kill the thread to stop the rollback process.

Thread id can be seen in SQL by using

“select spid, kpid, status, hostname, dbid, cmd from sys.sysprocesses”

Here in the query KPID is the thread id which is getting controlled by Operating System

Now the part of Operating system begins from where we can kill the thread from its ID , in OS to get the read id we will have to make use of sysinternals tool PROCESS EXPLORER .

In process explorer right click on SQL server Process, in Properties tab we can see the threads running we can sort by thread is and kill any specific thread which si KPID in background for SQL server .

Please take proper precautionary measures before doing this activity on production server.

Thanks,

Prashant Deshpande

2 Comments

Filed under Uncategorized

Reducing IO waits on Ubuntu for MYSQL 5.6

Dear All,

I was continuously receiving IO waits high usage alerts for our MYSQL 5.6 DB servers running on Ubuntu servers and so checked lots of things to reduce IOs like optimizing queries and shifting database on SAS disks.

But not got any success so tried to split table data (partitioning) but the business logic was not supporting it so started doing RND to reduce IO waits on Ubuntu servers.

And finally got solution and all were happy J

Added below line in MY.CNF

innodb_flush_method =  O_DSYNC

Benefits got after adding the line

  • Reduced IO waits
  • Reduce memory usage of database server

Thanks

Prashant Deshpande

Leave a comment

Filed under Uncategorized

[SOLVED ] : A process serving application pool suffered a fatal communication error with the Windows Process Activation Service

Dear All,

I have configured UNC based web farm for IIS 7.5 sites on multiple server for one of major project and cross checked by browsing on each server. As the first page of site is .html file website god browsed and when tried to browse .aspx page got below error

 

 

500.19

Tried below option to resolve the issue

Dropped and re-created App Pool   ( as in some cases it works ) but in this scenario it didn’t worked so checked app pool running in which identity and authentication for website it was running under NETWORK SERVICE

So tried by giving permissions to NETWORK SERVICE to Shared folder permissions and the website started working and problem gor resolved.

Thanks

Prashant Deshpande

Leave a comment

Filed under Uncategorized

[SOLVED]: RENAME Database in MYSQL 5.6

Dear All,

Today morning I have been called by one of SDP team manager and told to rename one of MYSQL database of development server.

As per my knowledge MYSQL 5.6 does not support Database rename facility and the datebase size was 90 GB so to accomplish the task I was having option to get increase partition size by another 90 GB and create a blank database with the required name and by right click on database and selecting option “COPY Database on different Host “ in SQLYOG

I was aware this option will take minimum 8 hours so started thinking and I was aware that in MYSQL there is a facility to rename table which I use to execute for several times.

I thought for COPY Database on different Host I need to create new database and select the table names which I need to make duplicate so why shouldn’t I try same option by using rename table.

So my new command was

RENAME olddb.oldtablename TO <newdbname>.<tablename>

e.g.

RENAME xyz.abcdef TO abc.abcdef

And this resulted to accomplish the task in max 15 mins with the desired result J

Thanks

Prashant Deshpande

Leave a comment

Filed under Uncategorized

[Solved]: SQL mirroring error 1488, 1499

Dear All,

While configuring Mirroring on SQL server I was getting a message “Alter Database failed ….” Error no 1488

As below

SQLerror1488

So searched a lot on internet, but didn’t got success as all blogs were point that the database is in single user mode in reality it was wrong as my database was in multi_user mode

So I dug and got the solution, it  is very simple.

On Mirrored (secondary) server the database files were not having permissions for the user from which the SQL service was running and the same user I was using to configure mirroring too.

Steps followed

  • Stopped SQL service on Mirrored (secondary) server
  • Given full control to the user from which the SQL service is running
  • Started SQL service

On principal server now clicked on start mirroring and the mirroring is configured successfully

Thanks

Prashant Deshpande

Leave a comment

Filed under Uncategorized