mysql startup debugging tip

If you are not able to start the mysql daemon repeatedly using your linux distribution init scripts and you are ready to pull out your hair in frustration, here is a tip that might help you in finding the problem.

Try running the mysqld_safe from the command line (without using the init scripts). Try running /usr/bin/mysqld_safe -v, which should spit out some debugging information.

If that fails, try calling the mysqld daemon directly from the command line, with the "-v" option . mysqld is usually present under /usr/sbin/mysqld. mysqld can be called with --print-defaults to get the command line options it would be run with.

/usr/sbin/mysqld would have been started with the following arguments: --user=mysql --pid-file=/var/run/mysqld/mysqld.pid ..... --max_binlog_size=100M

Try adding the -v option to these options to get more verbose details. When run from command line, mysqld will not detach from console and will print debugging info that might be useful in finding the cause of the error.

I suggest using 3 terminals to figure out what is going on

• one terminal with tail -f /var/log/mysql/mysqld.err
• one terminal with tail -f /var/log/messages
• one terminal where I ran the mysqld_safe / mysqld command

The init scripts are usually good for day to day work. However, sometimes the init scripts can impede a innodb crash recovery process on a large database. Some init scripts have timeout built into them and they can kill mysql while the innodb is still trying to recover its tables.

Release of PythonOnPlanes-1.3.07 aka. SuperSunday release

What is PythonOnPlanes ?

PythonOnPlanes is a rapid development framework for Python which uses commonly known design patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC. Our primary goal is to provide a structured framework that enables Python users at all levels to rapidly develop robust web applications, without any loss to flexibility.

See the Features list below to learn more about the framework.

Release Announcement

The Release Engineering Team is happy to announce the availability of PythonOnPlanes-1.3.07 , the latest release of the PythonOnPlanes Stable development branch. Since PythonOnPlanes-1.3.06 release we have made many improvements in functionality, stability, performance, and mod_snake_oil support for Apache web servers, as well as dealt with known security issues and made many bugfixes.

Major highlights in the release include Active Scrum Manager 1, Sanity Preserver 3.13 and Lart 22.21. This is also the first release with the PythonOnPlanes Live CD Installer officially debuting on the x86 platform.

Features

The software development world is moving towards AGILE DEVELOPMENT, WEB-2.OH, GURU PRESENCE and LEAN SOFTWARE. Our Framework is geared to support all these features.

"Out of the box" features available

Out of the box PythonOnPlanes supports

• Sprint Management
• Pair programming using an editor that can be shared by 2 developers. We have named it ALN (Analog Large Notebook)
• LoC2LoC to generate a report on each developer's productivity.
• Active Suggest DESIGN PATTERN (ASDP). This feature will make your refactoring efforts a snap

Beta Experimental Features

These features are not enabled by default and you have to enable them by editing the configuration file.

• Developers' Blog . Each developer in the team is given a blog which he can update. If enabled, PythonOnPlanes will generate a daily report of the developer activity log and post it on the blog too
• CutesyErrorMessages-0.0.1-BETA. This replaces stern error messages with very user friendly messages

GET PythonOnPlanes-1.3.07 IN NO TIME

Download PythonOnPlanes-1.3.07 from <http://pythononplanes.com/>