Expanding Further:

Before running ./nph-verify --check_all from command line.

Repaired Database == Everything reported OK (All Tables OK)

This MySQL server has been running for 0 days, 2 hours, 23 minutes and 7 seconds. It started up on Oct 13, 2004 at 07:52 AM.

Turned debugging on

executed the command from commandline

This is what log shows (few examples):

GT::SQL::Driver::MYSQL::sth (8416): Executing query: SELECT COUNT(*) FROM lsql_Links from main::check_links at ./nph-verify.cgi line 165

GT::SQL::Driver::MYSQL::sth (8416): Executing query: SELECT ID FROM lsql_Links from main::check_links at ./nph-verify.cgi line 192

GT::SQL::Driver::MYSQL::sth (8418): Executing query: SELECT * FROM lsql_Links WHERE (ID = 1) from Links::Tools::check_links at /admin/Links/Tools.pm line 298

GT::SQL::Driver::MYSQL::sth (8419): Executing query: SELECT * FROM lsql_Links WHERE (ID = 11) from Links::Tools::check_links at /admin/Links/Tools.pm line 298

GT::SQL::Driver::MYSQL::sth (8420): Executing query: SELECT * FROM lsql_Links WHERE (ID = 21) from Links::Tools::check_links at /admin/Links/Tools.pm line 298

GT::SQL::Driver::MYSQL::sth (8421): Executing query: SELECT * FROM lsql_Links WHERE (ID = 31) from Links::Tools::check_links at /admin/Links/Tools.pm line 298

GT::SQL::Driver::MYSQL::sth (8422): Executing query: SELECT * FROM lsql_Links WHERE (ID = 43) from Links::Tools::check_links at /admin/Links/Tools.pm line 298

GT::SQL::Driver::MYSQL::sth (8423): Executing query: SELECT * FROM lsql_Links WHERE (ID = 53) from Links::Tools::check_links at /admin/Links/Tools.pm line 298

GT::SQL::Table (8423): Status cannot contain the value '[undefined]' at ./nph-verify.cgi line 440.

GT::SQL::Driver::MYSQL::sth (8419): Executing query: SELECT * FROM lsql_Links WHERE (ID = 12) from Links::Tools::check_links at /admin/Links/Tools.pm line 298

GT::SQL::Table (8419): Failed to execute query: 'SELECT * FROM lsql_Links WHERE (ID = ?)' Reason: MySQL server has gone away at /admin/GT/SQL/Driver/MYSQL.pm line 121.

GT::SQL::Driver::MYSQL::sth (8419): Executing query: SELECT * FROM lsql_Links WHERE (ID = 13) from Links::Tools::check_links at /admin/Links/Tools.pm line 298

GT::SQL::Table (8419): Failed to execute query: 'SELECT * FROM lsql_Links WHERE (ID = ?)' Reason: MySQL server has gone away at /admin/GT/SQL/Driver/MYSQL.pm line 121.

GT::SQL::Driver::MYSQL::sth (8419): Executing query: SELECT * FROM lsql_Links WHERE (ID = 14) from Links::Tools::check_links at /admin/Links/Tools.pm line 298

GT::SQL::Table (8419): Failed to execute query: 'SELECT * FROM lsql_Links WHERE (ID = ?)' Reason: MySQL server has gone away at /admin/GT/SQL/Driver/MYSQL.pm line 121.

GT::SQL::Driver::MYSQL::sth (8419): Executing query: SELECT * FROM lsql_Links WHERE (ID = 15) from Links::Tools::check_links at /admin/Links/Tools.pm line 298

GT::SQL::Table (8419): Failed to execute query: 'SELECT * FROM lsql_Links WHERE (ID = ?)' Reason: MySQL server has gone away at /admin/GT/SQL/Driver/MYSQL.pm line 121.

and so on.

There is nothing logged in mysql log file. No CR_SERVER_GONE_ERROR or CR_SERVER_LOST

mysql log file just has this:

041013 07:52:26 mysqld started
041013 7:52:26 InnoDB: Started
/usr/sbin/mysqld-max: ready for connections.
Version: '4.0.20-Max' socket: '/var/lib/mysql/mysql.sock' port: 3306

The Runtime information of Mysql after the run also does not show any abnormality and is as follows:

This MySQL server has been running for 0 days, 2 hours, 34 minutes and 30 seconds. It started up on Oct 13, 2004 at 07:52 AM.

There is no column storing that >1MB stuff which can give this error. No images stored in database.

There are no server timed out and closed the connection related errors.

So what exactly is happening is not clear to me

The only other possibility of this type of error (Server Gone Away) within an application program is that you tried to run a query after closing the connection to the server. This indicates a logic error in the application that should be corrected.

The Admin interface show all links ok but if a try to reverify all links then again 13 links are marked 403 on first run from Admin interface.

Any thoughts on this?

HyTC

Thanks
HyTC
==================================
Mail Me If Contacting Privately Is That Necessary.
==================================