Monday, December 24, 2007

Dhanurmasam - Significance

Dhanurmasam is also known as margazhi masam. But the latter name is usually known to sreevaishnavaites and the people who follow Vaishnava Sampradaya. According to the common people terminology the month between Dec16 to Jan 15 is called Dhanurmasam as the Dhanursankramanam happens in this period, where the Sun rays changes its position there by increasing the agriculture oriented results. Coming to Vaishnava Sampradaya, to marry Lord Sreeranganatha Swami whose temple is Famous in Sreerangam, Godha Devi aslo called as Neela Devi also called as Andal took birth in Sree Velliputhooru (which is also a famous place in chennai). puttadamante actually thanu oka thulasi kota daggara Vishnu ChithamaCharylu ane ayinaki dorkindhi. He used to pray the god with that garlands daily. So ayina avidani thandrila penchi pedha chesthuaru. Alane Ranganatha Swami gurinchi, ayina goppathananni gurinchi cheppi mothaniki, nenu pelli cheuskunte eeyanane chesukovali anna stage ki theskeltharu. So once she comes to yuktha vayas, she in the month of margazhi which is athyantha preethi pathra of Sreerangantha, decides to do a vratham called THIRUPPAVAI. Vratha deeksha was the entire month from dec-16 to jan 15. She chants 30 sacred pasuramsone each day one, which narrates the gods unnatha lakshanas..and divinity and mixture of some of the qualities which should be possesd by the god devotees, and like that so on. The last day Ranganatha swami shows his Grace on her. He comes with his parivara to marry her. And by performing the marraige of andal - ranganath, the margazhi masam ends.

Source : One of the Interesting personalities, I have ever met, explained me in one of our discussions. I copied and pasted it Here.


@Koteswara sarma

Sunday, December 23, 2007

An article on Management

Here is one of the Best Articles which I read in recent past, Hope people love to read it. http://koumudi.net/General/Modern_management.html


@Koteswara sarma

Thursday, November 8, 2007

Happy Diwali

Happy Diwali to All

May this Diwali give you -


* Independence of Java

* Power of Unix

* Popularity of Windows

* Extensibility of J2EE

* Luxury of .Net

* Efficiency of C

* Ease of VB

* Robustness of Oracle

* Vision of UML

* Simplicity of HTML

* Style of Mac

* Dexterity of Photoshop

* Enormity of 3D Max

* Vastness of Internet

* Compactness of JPG

* Richness of BMP

* Coverage as Yahoo

* Reach of Google

* Prudence of Froogle

* Security of Norton & McAfee

* Intelligence of Unreal

* Realism of Max Payne

* Speed of NFS

* Fun of RoadRash

* Intelligence of Chessmaster

* Impression of Quake3


And the goodness of all software that comes for free...


source : One of forwarded mails.....

Saturday, October 20, 2007

Review - Happy Days

Movie Name - Happy Days

Story - Love Story in College Days.

Shekhar Kammula Did good job on well-known Commercial Element - Love. There are two things, which brings people to theaters, one - movie should be based on Students, another - Love.

In Simple terms, a Love Story started in College in First year itself. Introduction of characters is Good. Ragging scenes and Seniors - Juniors interaction is neat. Sometimes, I feel like Movie is too slow and boring sometimes. But, Overall it is Good. It was nice ending to story of Tyson and Sravs. Direct does not involve in giving any message for a Love story between a Senior and a Junior. Friendship plus Love is shown very well so that one of them does not dominate the other.



@Koteswara sarma

Saturday, September 29, 2007

Happy Moments

We(Team Vegayan) are having Good time now. Our work is getting some shape now. We had Movie + Dinner Event YesterDay. We watched "Chak De" in SunCity, Ville Parle and then we went to "GreenHouse" for Dinner. Three of our Team members got Promotions. Tushar Shiva is now Team Lead now and Prashant and myself stepped into Shoes of Senior Software Engineers. It was awesome feeling when My CEO Prof Girish P Saraph announced it.


@ Koteswara sarma
Senior Software Engineer

Monday, September 24, 2007

Week-end Shocking

I watched One of the Best Worst Movies - "VijayaDashami". Till then, My week-end was fantastic, executing almost all the plans. One of my friends came from Pune and we planned for a Telugu Movie. We found that movie. Editing was poor. Director V. Samudra clubbed two different stories into one and made Hell lot of Nonsense.


@ Koteswara sarma

Friday, September 21, 2007

SA - Chokers

SA lost to India and out of Tournament, but they Succeed in Keeping their name as Chokers. I thought India will buckle down in pressure and South Africa will Out play India because of the Kind of Form and Flow, it is in. But, SA once again proved that, it is not Good as it used to be in Crunch Matches.


@ Koteswara sarma

Tuesday, September 18, 2007

Alibag and Mumbai Darshan

3 Vs from Amdocs(Vamshi, Varma and Vikas(their colleague)) came to Mumbai, so that they can catch up some Good time.

They reached here by 12:00 AM(Sat Day) and we had little Dinner outside and we reached my Flat by 1:30 AM. We had small chat and made some plan to work out on Saturday and Sunday.

On Saturday Morning, we woke up at 4 AM(You read it right) and started our Journey to Alibag, a nearby Tourism place.Alibag is covered by water 3 sides. We can reach Alibag either on Boat or we can go by roadways. But we preferred Boat Journey. We went to Gateway of India, to go by Boat.

Boat Journey was Superb. It was not first time for me, still I enjoyed as if I am traveling for the first time on Sea. We enjoyed a lot on Boat. Few People are really scared.

We reached Alibag, there we went to Alibag Main beach, Birla temple and Kashid Beach. there are some 4 or 5 other beached and 2 Forts. Both the Forts are closed on that day, because of High Tide. Both the Forts are just inside Sea(some 100, 200m from sea shore). It was Sunny Day, so we were Very tired soon. We reached Mumbai by 7 PM. We spent some time at Gateway of India then returned to my Flat.

On Sunday, we had partly Mumbai Darshan... Girgaun Chowpatty, Marine Drive, ChurchGate and Nariman Point. I dropped them in Vashi on Sunday Evening, they left for Pune.

You can find some of our snaps at here.

I had really nice time with Vamshi and Varma........ ThanQ very much Guys.............


@ Koteswara sarma

Friday, September 14, 2007

Interactions with American clients - Useful tips

1. Do not write "the same" in an email - it makes little sense to them.

Example - I will try to organize the project artifacts and inform you of the same when it is done


This is somewhat an Indian construct. It is better written simply as:
I will try to organize the project artifacts and inform you when that is done



2. Do not write or say, "I have some doubts on this issue"

The term "Doubt" is used in the sense of doubting someone - we use this term because in Indian languages (such as Tamil), the word for a "doubt" and a "question" is the same.
The correct usage (for clients) is:
I have a few questions on this issue


3.The term "regard" is not used much in American English.
They usually do not say "regarding this issue" or "with regard to this".
Simply use, "about this issue".


4.Do not say "Pardon" when you want someone to repeat what they said
The word "Pardon" is unusual for them and is somewhat formal.


5. Americans do not understand most of the Indian accent immediately - They only understand 75% of what we speak and then interpret the rest. Therefore try not to use shortcut terms such as "Can't" or "Don't". Use the expanded "Cannot" or "Do not".


6. Do not use the term "screwed up" liberally. If a situation is not good, it is better to say, "The situation is messed up". Do not use words such as "shucks", or "pissed off".


7. As a general matter of form, Indians interrupt each other constantly in meetings - DO NOT interrupt a client when they are speaking. Over the phone, there could be delays - but wait for a short time before responding.


8. When explaining some complex issue, stop occasionally and ask "Does that make sense?". This is preferrable than "Do you understand me?"


9. In email communications, use proper punctuation. To explain something, without breaking your flow, use semicolons, hyphens or paranthesis.
As an example:
You have entered a new bug (the popup not showing up) in the defect tracking system; we could not reproduce it - although,
a screenshot would help.


Notice that a reference to the actual bug is added in paranthesis so that the sentence flow is not broken. Break a long sentence using such punctuation.


10. In American English, a mail is a posted letter. An email is electronic mail. When you say "I mailed the information to you", it means you sent an actual letter or package through the postal system.
The correct usage is:
"I emailed the information to you"


11. To "prepone" an appointment is an Indian usage. There is no actual word called prepone. You can "advance" an appointment.


12. In the term "N-tier Architecture" or "3-tier Architecture", the word "tier" is NOT pronounced as "Tire". I have seen many people pronounce it this way. The correct pronunciation is "tea-yar". The "ti" is pronounced as "tea".


13. The usages "September End", "Month End", "Day End" are not understood well by Americans. They use these as "End of September", "End of Month" or "End of Day".


14. Americans have weird conventions for time - when they say the time is "Quarter Of One", they mean the time is 1:15. Better to ask them the exact time.


15. Indians commonly use the terms "Today Evening", "Today Night". These are not correct; "Today" means "This Day" where the Day stands for Daytime. Therefore "Today Night" is confusing. The correct usages are: "This Evening", "Tonight". That applies for "Yesterday Night" and "Yesterday Evening". The correct usages are: "Last Night" and "Last Evening".


16. When Americans want to know the time, it is usual for them to say, "Do you have the time?". Which makes no sense to an indian.


17. There is no word called "Updation". You update somebody. You wait for updates to happen to the database. Avoid saying "Updation".


18. When you talk with someone for the first time, refer to them as they refer to you - in America, the first conversation usually starts by using the first name. Therefore you can use the first name of a client. Do not say "Sir". Do not call women "Madam".


19. It is usual convention in initial emails (particularly technical) to expand abbreviations, this way:
We are planning to use the Java API For Registry (JAXR).


After mentioning the expanded form once, subsequently you can use the abbreviation.


20. Make sure you always have a subject in your emails and that the subject is relevant. Do not use a subject line such as HI .


21.Avoid using "Back" instead of "Back" Use "ago".Back is the worst word for American. (for Days use "Ago",For hours use "before")


22.Avoid using "but" instead of "But" Use "However".


23.Avoid using "Yesterday", hereafter use "Last day".


24.Avoid using "Tomorrow", hereafter use "Next day".

Source : Suresh Veluru


@ Koteswara sarma

Thursday, September 13, 2007

Love .... Really cool

Premante paike GOLD

Premiste Clear BOWLED

LOVE ante paike SWARGAM

Lopalanta Bheekara NARAKAM



@ Koteswara sarma

Wednesday, September 12, 2007

One of Forwarded mails

PLEASE READ & THINK.......

To: Dear All,

It's half past 8 in the office but the lights are still on...

PCs still running, coffee machines still buzzing...

and who's at work? Most of them??? Take a closer look...

All or most specimens are ??-something male species of the human race...

Look closer... again all or most of them are bachelors...

and why are they sitting late? Working hard? No way!!!

Any guesses???

Let's ask one of them...

Here's what he says... "What's there 2 do after going home... here we get to surf, AC, phone, food, coffee.. that is why I am working late...

importantly no bossssssss!!!!!!!!!!!

This is the scene in most research centers and software companies, and other off-shore offices.

Bachelors "time-passing" during late hours in the office just bcoz they say they've nothing else to do...

Now what r the consequences... read on...

"Working"(for the record only) late hours soon becomes part of the institute or company culture. With bosses more than eager to provide support to those "working" late in the form of taxi vouchers, food vouchers and of course good feedback,(oh, he's a hard worker... goes home only to change..!!).They aren't helping things too... To hell with bosses who don't understand the difference between "sitting" late and "working" late!!! Very soon, the boss start expecting all employees to put in extra working hours.

So, My dear Bachelors let me tell you, life changes when u get married and start having a family... office is no longer a priority, family is...

and that's when the problem starts... becoz u start having commitments at home too.

For your boss, the earlier "hardworking" guy suddenly seems to become a "early leaver" even if u leave an hour after regulartime... after doing the same amount of work.

People leaving on time after doing their tasks for the day are labeled as work-shirkers...

Girls who thankfully always (its changing nowadays... though) leave on time are labeled as "not up to it". All the while, the bachelors pat their own backs and carry on "working" not realizing that they r spoiling
the work culture at their own place and never realize that they wuld have to regret at one point of time.

* So what's the moral of the story?? *

* Very clear, LEAVE ON TIME!!!

* Never put in extra time " *unless really needed *"

* Don't stay back unnecessarily and spoil your company work culture

which will in turn cause inconvenience to you and your colleagues.

There are hundred other things to do in the evening..

Learn music...

Learn a foreign language...

try a sport... TT, cricket.........

importantly Get a girl friend or gal friend, take him/her around town...

* And for heaven's sake net cafe rates have dropped to an all-time low (plus, no fire-walls) and try cooking for a change.

Take a tip from the Smirnoff ad: *"Life's calling, where are you??"*

Please pass on this message to all those colleagues And please do it

before leaving time, don't stay back till midnight to forward this!!!

ITS A TYPICAL INDIAN MENTALITY THAT WORKING FOR LONG HOURS MEANS VERY
HARD WORKING & 100% CO
MMITMENT ETC.

PEOPLE WHO REGULARLY SIT LATE IN THE OFFICE DON'T KNOW TO MANAGE THEIR TIME.

SIMPLE !!!



@ Koteswara sarma

Saturday, September 8, 2007

Sarcasm at its Best

One of the Best Articles I have ever read can be found here. This is an article in Telugu Newspaper, Eenadu in Opinions Section.


@Koteswara sarma

Friday, September 7, 2007

MySQL Installation - Issues

Finally, I came up with some fix for MySQL installation problem of "mysql.host" does not exist.

Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist(we can find this info in /var/log/mysqld.log)

Follow the following steps, MySQL will be installed(all wrt Linux)

1. shell > rm -rf /var/lib/mysql

2. Install mysql rpms.

3. Go to directory where mysql binaries are installed(mysqld_safe, mysql etc)

4. ./mysql_install_db --user=mysql --ldata=/mysqldata (where mysqldata is my data directory for MySQL database. datadir can be specified in /etc/my.cnf file, then we can ignore here)

If it gives a message that hostname is not set or conflict in hostname, then use
./mysql_install_db --user=mysql --ldata=/mysqldata --force

5. MySQL is installed, start MySQL server now,
./mysqld_safe --user=mysql &

Congrats, MySQL is up and running....

When MySQL is Installed, MySQL client does not have any password. It will contain four users, root@localhost, root@localhost.localdomain, ''@localhost, ''@localhost.localdomain('' - anonymous user).
Delete all users at localhost.localdomain and all anonymous users. Set password for root@localhost using

shell > mysql

mysql > drop user root@localhost.localdomain;

mysql > drop user ''@localhost;

mysql > drop user ''@localhost.localdomain;

mysql > set password for root@localhost = password('mysqlroot');

mysql > flush privileges;

mysql > \q

shell >

Flush Privileges will tell server that password is set for root.

MySQL is installed and password is set for mysql client.


@ Koteswara sarma

TableSpace - Useful Info

Here is mail on TableSpace in Oracle from one of my Friends who is working for one of the Successful MNCs(Originated in India) as a DBA.


Hello Sharma,

Hope that I am not late to reply.

Database is logically divided into a number of tablespaces.

Physically at O/s Level , you can see datafiles, where every datafile belong to a uniue tablespace.
When u create a database, a couple of tablespaces are created for system internal purpose. Apart from these, u can create new tablespaces. Generally different tablespaces are created to store tables/indexes of different database users or different types of tables ( if single Database user Application)

Example: Create tablespace TS_U1 datafile c:\oracle\ts_u1_01.dbf size 100M. --- u can see this datafile in c:\oracle of size 100MB.

Now create a user U1 and define his default tablespace as TS-U1. This means that All the tables created by User U1, will get stored in tablespace TS_U1, ie, c:\oracle\ts_u1_01.dbf in O/s level.

Tables and indexes are the only objects which consume space and are called segments. Tablespaces are to provide storage space for these segments. So, Ur database size is size of all tables & indexes, views & procedures dont occupy any space.

Now , if 100M is full, you can either add anothere datafile to the existing tablespace or extend the existing datafile to 200M...etc.

Single user can have quota on more than one tablespace. Also, generally a different tablespace is created for indexes to avoid contention , because when a query is fired it may like to use both table and index to read from datafile.

If both tables and indexes are in different tablespaces , then they will be in different datafiles ( datafile can only belong to a single tablespace), so it avoids contention while Oracle tries to read both table & index at a time.

Tablespace is some thing which physically hosts the table, not just info.

Also, there are storage features like RAID1,0,5,1+0 etc., ( Mirroring & Striping )etc., To distribute database properly different tablespaces are used with diff datafiles, accross different disks.

I hope I answered ur question. Reply me if U did not understand anything . I can suggest U some documentation if u like.

:-)

Regards,
Chaitanya Gouru

Hi Chinnu,

Tablespace stores information about table, index and so on. Whether Tablespace is restricted to single table or all the tables existing in a database or set of tables in database. Can you gimme some thought on this?

Thanx in advance
sarma
09324 444 164


@Koteswara sarma

Thursday, September 6, 2007

India Vs England VI LOI @ Oval

India registered win in one of the most dramatic matches of One Day Internationals. Everybody Contributed to Victory. Seven Batsmen Formula once again proved that any target could be chased.

Sachin played the best innings so far in this Series and I wish, he will do it once more at Lords. Sourav continued his form. He is in awesome form right from his comeback to international cricket. He is playing cover drive, as if nobody can play better than that. It is a treat to Eyes. The most Successful Opening Pair in One day Cricket once again proved, why they are successful and dangerous.

I guess, Dravid took right decision by having Utappa in the team. I like Dinesh Karthick's attitude. But he does not suit for One Day Cricket. He more suits for Test Cricket where player gets more amount of time to settle and score runs. This team combination looks fine, 4 front line bowlers and 3 part time bowlers.

India is on Top by winning back to back matches and I wish, it will continue its winning streak at Lords and Sourav(Prince of Kolkatha for Geoffrey Boycott) is looking for his shirt to unbutton it.

All the Best Dravid and co.


@Koteswara sarma

Monday, August 20, 2007

Progress @ Feed the Hungry Project, Charni Road

Yuva Unstoppable is Running a Project called "Feed the Hungry Children" at Charni Road, Mumbai. We(around 15 Volunteers) are part of that Project. We go there and teach Children for some time, then we play with Kids and we feed them.

This Project is started in May 2007. Its been more than three months now. We have done significant work in building relationship with Kids and their Parents. Next step is to provide Right Education for them. We meet them on Sundays only, so I guess, we have to follow some unconventional Methods so that the work done by us will have some Value Addition.

All the Volunteers are Young in this Field, so it will take time to shape up the things, But nevertheless, we are working for something Good to make it Better. I wish, I see a change in a year time, and We also better equipped in this Field.


@Koteswara sarma

Saturday, August 18, 2007

Saturday @ Office

I am in the Office on Saturday also, as there are many things, I have to Finish.

Nothing to update on my blog except this as I am doing Nothing.


@Koteswara sarma

Friday, August 17, 2007

Happy Independence Day

August 15 - Independence Day.

I met few people on this Day, who are into Social Service and running NGOs. We had a meeting at Charni Road, Chowpatti. Few people were present from Yuva Unstoppable, Ahmedabad. Group of around 15 people divided into groups and took part in Random Acts of Kindness. Our Group of people helped an old woman in Selling Flags. Other Group helped in peeling Butta's. Group 3 thanked local cops and other Navy Staff. Group 4 cleaned the place, gathered people and sang National Anthem with them.

Monday, August 6, 2007

Frenship Day Celebrated @ Matheran





My week-end was awesome and it was a much needed break for me from my routine work. I went to Pune to meet my friends and beloved Juniors.

Saturday I was all the time meeting friends, roaming here and there.

We(Aaditya, Vikas, Varma, Ramesh, Anjan, Vamsi and me) started to Matheran, a near by Hill Station. It is a Hill Station, in Express way connecting Mumbai and Pune, around 100 kms from Mumbai and 120 kms from Pune. Base of Hill Station is NERAL.

We Hired a Tavera and Started from Pune at around 6 am and we reached gateway of Matheran at 9:00 pm. Then we started walking towards Matheran Market. Thanks to Govt for not allowing any vehicles inside Matheran, so you feel completely different as there will be no BUZZ from any motor vehicles. We have options to roam around, either on Foot or Horse or Rickshaw's pulled by people. We opted to roam around on Foot as we can go wherever we wish and we can spend any amount of Time.

I guess, everybody follows one of Mahatma's sayings in Matheran... KEEP WALKING (Mahatma used this when he lead DANDI MOVEMENT). We were roaming and shouting like anything all the time. I was very happy as I had very good relationship with everybody in Team and all the guys are equally responding in either cracking Jokes, or pulling other's legs. Every scene was so beautiful that, we used to forget ourselves and we used to struck there. One of us used to Ping... chalo chalte hai karke.

We were roaming there till 5 pm, by that time, we were completely done, so started our journey back to our places.

My Juniors(MTech, IIITM) gave me a memorable Treat on Friendship Day, Thank you very much guys.

Thanks to Vikas(Colleague of my friends), who was lone North Indian, but cooperated us with ever smiling Face and attitude.

More pics of Matheran are found here.


@Koteswara sarma

Thursday, August 2, 2007

Pathetic Management @ PVR Mulund, Mumbai

Yesterday I had very bitter experience at PVR Mulund, Mumbai. But what made me to write a blog on it, I am not the only one to suffer from Mismanagement of PVR Mulund, I have so many friends(at least 30 people were there at around 11:40 PM).

I went to watch a movie with my friend, by that time we were only two people to watch that movie. The person in Ticket Counter said that we need at least 5, 6 people to run a show. Then we waited for some time, then 3 people came to watch the same movie. I thought they will run a show as we were 5 in number. Then so called Manager(Mr Datta) came and said that they do not run a show if occupancy is less than 10% of theater capacity. He was so arrogant that he said whatever he wanted to say and left the place.

About other 30 or so people - They came to watch movie - Partner. It was given in Bombay Times, that there is a show at 11:40 PM. Many people came to watch movie as yesterday was some special day. But Management had given following reasons
1. Its Distributor's Fault, so we are not responsible
2. You should have called us before coming to theater, its your fault.

The staff(Mr ChhatraRaj, Mr Vijay, Mr Ramesh, Mr Kuldeep, Mr Vrijesh) was just watching and there is no concern that these many people turned out because of their fault.

The reasons gave by Management were ridiculous. In any organization, Management cares about Customers, but I don't know the priority criteria of PVR.


@Koteswara sarma

Wednesday, August 1, 2007

Pros and Cons of Working in a Start-up

Its been more than one year now working for Vegayan Systems, a start-up in IIT B, Mumbai.

Some times, One Year seems to be very big, but some times, I feel, its OK.Here, I came up with few points about working in start up companies. I am both In(70%) and Out(30%) for working for a start up.

The Advantages, I find are

1. Scope to learn Work(as much as you can - there is no point that, you are not given any work, especially in product development companies)

2. Chance to learn about Resource Management. Team will be small, so you see how they are handled.

3. Growth factor - Here also, willing to learn plays major role.

4. Ownership of module - You are given a module, You are sole proprietor of module. You are free to design in whichever way you like, as long as you are good enough to make people to buy your design.

5. You develop more than one skill in a start up and you become master in your specialization.

6. Better rapport with team members as team is small.

The cons are

1. Getting a Leave every now and then is Tough.

2. Have to Google for many things.

3. Some times, get bugged with work.


Note: The Opinions I mentioned here are of mine, no way relevant to my employer's.



@Koteswara sarma

Tuesday, July 31, 2007

Need a Freshener

I am in really bad mood. My MySQL nahi chal raha hai. I am not able to find any fix for that. I need something really very interesting and refreshing thing from which I can draw some motivation. Now I am moving out to meet friends, hoping that they will fix me, if not MySQL.


@Koteswara sarma

MySQL - Few Observations

I have observed few things about MySQL, what it supports and how it supports.

MySQL supports different storage engines. Storage Engines not only describe how Indexing is done but also features supported. Primary Key is supported by MyISAM and InnoDB(These are widely used Stored Engines). But Foriegn Key Constraints are supported by InnoDB only.

MySQL works in different sql modes namely, STRICT_ALL_TABLES, ANSI, STRICT_TRANS_TABLES, TRADITIONAL, ALLOW_INVALID_DATES etc. SQL Mode tells, what kind of MySQL Syntax it supports and level of data validation checks it puts on Input Data. By Default, sql_mode is empty. sql_mode can be seen by
mysql > select @@session.sql_mode;

Importance of sql_mode:
My table definition is person(id int unsigned, name char(10), primary key(id));

Behaviour of this table under default sql_mode(which is empty).
mysql > Insert into person values(-1,'sarma');
Query OK, 1 row affected, 1 warning (0.07 sec)

Warning (Code 1264): Out of range value adjusted for column 'id' at row 1
Value is adjusted so that it will fit into id, if you see value of id, u find it to be Zero.

So, for first time, MySQL does not issue Error, but when you attempt to do it second time, inserting another -Ve value, it also adjusted to Zero again, causing Primary Key violation, so issues Error 1062(Duplicate Entry).

changing sql_mode to STRICT_ALL_TABLES will solve this problem.

mysql > SET SESSION sql_mode='STRICT_ALL_TABLES';
will change for this Session for this client.
If you want to change for all clients and for all sessions(globally), then better to change in /etc/my.cnf file.

It solves many problems, as MySQL issues warning when there is a mismatch between expected and actual values for a column. For Example, column Dt expects value to be in 'yyyy-mm-dd' and actual value is 'dd-mm-yyyy', it simply rejects rather than making it '0000-00-00'.


@Koteswara sarma

MySQL Error 2013

Of all MySQL errors I got, Error Number 2013 is most frustrating and annoying. MySQL Errors like 1062(Duplicate Entry), 2002(Server is not started), 2006(Server has gone away) are easy to identify and solve. 2013 says that you lost connection to server in the middle of query execution.

2013 is frustrating because, you can't produce it again for same sequence of actions. So you never know when it will come or when it won't.

Finally, I have come up with few points to look for when MySQL Error 2013 occurs.

1. check for MySQL Status
shell> mysql -u root -p -e "\s" | grep Uptime

It will give uptime of MySQL Server. If it is less than 1 min, then server must have gone down and started again. So, you have look for Status Variable wait_timeout. By default, wait-timeout will be 28800 sec (8 Hours). Developer can change it while starting a server(change has to be done in my.cnf file) or by setting parameter "CLIENT_INTERACTIVE" in "mysql_real_connect()". If Uptime is not less than a min, then there is a problem with Query.

Query can be too long or it is syntactically correct but not semantically.

Example: I am running a stored procedure spLogin(uname, pword, status). Here uname and pword are input parameters and status output parameter. To supply input to this stored procedure, I use user defined variables.

So, order of queries will be
mysql > SET @user = 'sarma', @passwd = 'sarma';
mysql > call spLogin(@username, @password, @status);
There is a chance that it will give an error 2013, as query is syntactically correct, but values passed to query are garbage.

Remedy will be
mysql> call spLogin(@user, @passwd, @status);
query Success(if stored procedure is correct).

But as I said earlier, it is tough to reproduce Error 2013. Care should be taken in passing inputs to either Queries or Stored Procedures and wait_timeout should be atleast 4 Hrs.


@Koteswara sarma


Monday, July 30, 2007

Week-end 27.07.2007

Week-end(Friday, 27.07.2007) started with Heavy rain. So I was in IIT with my friends. I was awake all the night either chatting with my frens on "Operation ThotaRamudu" or working for it or watching movie or listening Songs.

I slept on Satday Morning from 6 am to 11 pm, then had some work in Bank, did that, then I came to Office. (2 nd and 4 th sat days are working days for me). My Project Manager was so angry on me.. not for coming late to Office, but for not sleeping in the nite. She told me that it was not good for health and all.

I was in the office till 7 pm, then I went to meet one of my friends, Anil to get some info on "Operation ThotaRamudu". He said few things. It was all OK chatting with him and his roommates. Then I called up Mahesh(Saketa), he was in PVR, Mulund, to watch "Shankar Dada Zindabad". Then He took ticket for me also, I went there and watched "Shankar Dada Zindabad". It was super, awesome. Megastar's performance was too gud.

Sunday Morning, I had hair-cut. It has little significance, because I had it first time in last 10 months.

Then I went to Charni Road, to work for a program called "Feed the Hungry Children", run by Yuva Unstoppable, Ahmedabad. We(Team of about 15 people) spend some good two hours with Children, teaching them, explaining on good habits and Behaviour, and finally providing Food.

I reached my Flat by 4:30 PM. I worked for "Operation ThotaRamudu" for some time, then I went to sleep. I woke up at 12:00 PM and again spent some time on "Operation ThotaRamudu".

Monday, Morning 8:30 AM, I was in the office... started working on User Management.


@Koteswara sarma

Review - Shankar Dada Zindabad

This review is from one of the fellows who says MegaStar Zindabad and whistles whenever Megastart appears on scene, claps for every dialog. I usually admire people who sell themselves for Best Price. Megastar is just one of them.

I watched Lageraho Munnabhai and this movie is remake of "Lageraho...". The only difference is Lageraho is class classic and Shankar Dada is Mass masala.

Movie was Super, especially Megastar's Performance. He did his best. His mass appeal, Dialog Delivery and Style was too gud to watch. Srikanth has done very well to that role. I guess, Prabhudeva or whoever concerned did not work much for Heroin's role. May be they thought, its Megastar's movie, so why to waste money on a Heroin who performs well. Karisha kotak... no facials, no body language, no dance performance, just a doll beside Megastar. Sada is also Good. Shiyaji Shinde impressed me alot, i did not expect that he would suit into that role so well.

Coming to Story, Shankar dada is a Social worker(goon), who helps Raj Lingam to acquire lands and buildings illegally. ATM is right hand to Shankar Dada. Shankar Dada falls in love with voice of Jahnavi, a Radio Jockey. Shankar Dada gets a chance to meet Jahnavi, and he falls in love with her beauty also. He himself introduces a History Professor to Jahnavi, which creates all problems. How he handles all them and why follows Gandhigiri to Dadagiri is you should watch in Movie.

Dialogs were not that Good, but the way, Megastar delivers them was awesome.

Few dialogs which i remember are "nenu ippudu peace follow avutunna, ledante ninnu eppudo piece piece chese vanni", "For Dog's Bite, Slipper's Slap", "Open Banana, give for eating", "No emitting, No vomiting".

Songs were good because of Music, not because of Lyrics. "Bhoogolamanta..." song which is sung by Adnan sami was best of all.

Gandhigiri Zindabad


@Koteswara sarma

Saturday, July 28, 2007

Indian Cricket League

Indian Cricket League is a cool idea to make our first class cricket format strong. When there is a competition we get better results, because we compare the Both. If there is only entity BCCI, which is not accountable to any one, and whoever is in its President's seat will be owner of BCCI, then there is not much to talk about.

Kapil Dev said that we were managed to produce great players but not great teams. I wish ICL works towards making Great Teams. ICL initially have 6 teams - players from India and a few Foreign players also. It will be a good chance for Bright Youngsters in India also, they learn a lot while playing with Greats like Lara, Warne etc.

This will help Indian Cricket in Long run, may be after Dravid, Sachin - we look for alternatives from ICL.

It would be nice if ICL shapes up soon and starts functioning.


@Koteswara sarma

Friday, July 27, 2007

Missing Home...

Its been long time that I left for home. I feel very sad but I am not in a position to leave for home now. There are hell lot of constraints... one I can publish is MONEY. I usually have many works at hand, so that I do not get time to think about anything but work. But still, I miss my parents.

I feel - I am tired, I am upset, I am sad and I am bad.

Last but not least, thanks to all my friends, who help me always to keep focussed on work and at least for some time, I feel Happy.

Thursday, July 26, 2007

My Theory

One:

The more BUSY You are, The more FREE time you will have.

The more FREE time you have, The more work you can Do, and in a way you become more BUSY.

Moral of the Story : Have more FREE time to become more BUSY, so you will have more FREE time.

Two:

To forget the things, we have to Remember them.

So Remember things, to Forget them.


@Koteswara sarma

Why to choose a start-up

Many of my friends ask me why Did you choose a start-up when you have offers from some other MNCs.
I question them what is the advantage of working in a MNC which is not in a start-up. They told me that when you are swicthing from one job to other job, there will be less risk and you need not to advertize about your company, you carry a brand name, if you work in a MNC. My reasoning to them is, Why should I think of swicthing my job before joining in that? If I am not satisfied with the work I am doing or If I am not fit into the team , then only I think of swicthing job. So doing work is my priority, which I certainly get in a start-up. I am not sure whether I'll be assigned work from Day 1, if I join in a MNC. I am not against working in MNCs, they have their own headaches. Its true that Resource Management is the toughest thing. The reason, I opted for start-up is if I work for some time, then I can get job in MNC at any time. But if I join in a MNC and happened to be on bench (or member of Freepool), then it would be tough. Working in a start-up gives you the next best chance to see how a company shapes up.(Best chance to see is to start a company). Working in a start-up has other advantage, you can watch the building process of a company very closely,you know ups and downs in making it Big. More importantly, every one's voice is heard in a start-up, so u can raise your voice, you can take part in design discussions, brain storming sessions. This is all happens in MNCs also, but you need to gain some experience, before raising your voice.

This is all experiences I heard from my friends, I never worked in a MNC.

Note : The views expressed here are mine and not my employer's.


@koteswara sarma

Wednesday, July 25, 2007

Filing IT Returns

Today, I filed IT Returns through e-filing. It is simple and Happy Hassle-free process. Thanx to IT Dept of India for providing such a facility and Prashant(my colleague) for letting me know this opportunity. I have a good impression on IT Dept of India, from long time (may be from the time, I applied my PAN Card), now I have very good impression.

To file e-returns, download form from http://incometaxindiaefiling.gov.in/portal/html/individual_huf.jsp fill it properly, check it out. Then Generate Bar code, take print out and export it to XML Format. Create an account in http://www.incometaxindiaefiling.gov.in and uplaod XML File by loggin with your username. You get ITR-V (Income Tax Returns Verification) form as acknowledgment. Take print out(2 copies) and submit in your nearest Aayakar Bhavan.

Submitting ITR-V form in Mumbai is done in seconds. and many people know about this fecility in IT Office here.

Humor

A TWO-LINE RHYME WITH THE MOST ROMANTIC FIRST LINE, BUT THE LEAST ROMANTIC SECOND LINE:

My darling, my lover, my beautiful wife:
Marrying you screwed up my life.

I see your face when I am dreaming.
That's why I always wake up screaming.

Kind, intelligent, loving and hot;
This describes everything you are not.

Love may be beautiful, love may be bliss,
But I only slept with you 'cause I was pissed.

I thought that I could love no other --
that is until I met your brother.

Roses are red, violets are blue, sugar is sweet, and so are you.
But the roses are wilting, the violets are dead, the sugar bowl's empty
and so is your head.

I want to feel your sweet embrace;
But don't take that paper bag off your face.

I love your smile, your face, and your eyes --
Damn, I'm good at telling lies!

My love, you take my breath away.
What have you stepped in to smell this way?

My feelings for you no words can tell,
Except for maybe "Go to hell."

What inspired this amorous rhyme?
Two parts vodka, one part lime


Source : From one of Forwarded emails....

Trivikram's Style

Chelli : Akka, nuvvu Bread Jam tho tintava? Butter tho tintava???

Akka : nenu Aakali tho tintanu.



Source : Amar Sujit, one of the beloved juniors in IIITM, Gwalior

Typical Libran's blog

Here are some of my(Libran's) traits...

Nice to everyone they meet. Their Love is one of a kind. Silly, fun and sweet. Have own unique appeal. Most caring person you will ever meet! However, not the kind of person you want to mess with... you might end up crying...

Above all, libran's are the most romantic persons on Earth...