Re: [PHPLIB] MySQL goes away From: Brian S. Craigie (Brian.Craigie <email protected>)
Date: 01/06/00

If it's any help to you, printing the error corresponding to error number 9
(Errcode: 9) reveals the error to be "Bad file number"

Use the following command to check what the error is:-

perror <error_number>

for example:

perror 9

I think you should (or the sysadmin) run isamchk. See the mysql docs for how to
run it. Looks like your db is somehow corrupt. It does not necessarily follow
that phplib caused the problem. It could be that it is just highlighting a
pre-existant problem.

Hope that helps.

Brian

garyb <email protected> wrote:

> Folks,
> On a new phplib install, I have two problems, on an OpenBSD 2.6 machine.
> PHP (modphp) 3.0.7, mysql 3.22.27, apache 1.2.5/Stronghold 2.2.
>
> I didn't look in the archives - sorry if this is repetitive. I'm just
> searching for a clue...
>
> 1. one of the tables in the Create_database_mysql isn't created as it
> should be.
> #
> # Table structure for table 'db_sequence'
> #
> CREATE TABLE db_sequence (
> seq_name varchar(127) DEFAULT '' NOT NULL,
> nextid int(10) unsigned DEFAULT '0' NOT NULL,
> PRIMARY KEY (seq_name)
> );
>
> The table is created but the .ISD file isn't. No fields exist according to
> mysqlshow (warnings appear). I've tried the above from mysql shell and the
> same thing happened.
>
> 2. MySQL periodically goes away - the daemon seems to be running but I
> can't connect to it from the web. From the shell I can use 'mysql -w ...'
> but not without the -w. It happens regularly running phplib, but the
> sysadmin says it was happening before I installed phplib - he warned me in
> advance that it wasn't ready for production use. It appears that the
> "logout" option is very good at this - 100% loss of connection.
>
> I don't have access to the mysql log files (OS security is tight) so I can't
> tell what might be in them. I didn't have any problem running the
> phpMyAdmin system before I installed phplib, but I only had it running an
> hour or two so that's not necessarily significant.
>
> I also get stuff like this:
> %:stuff {189} mysqlshow -p mydb
> Enter password:
> mysqlshow: Cannot list tables in mydb: Can't read dir of './mydb' (Errcode: 9)
> %:stuff {190} mysqlshow -p
> Enter password:
> mysqlshow: Cannot list databases: Can't read dir of '.' (Errcode: 9)
>
> And yet using mysql -w -p mydb, I can work fine with at least one of the
> tables, updating and selecting.
> -
> PHP3 Base Library Mailing List. Send messages to <phplib <email protected>>.
> To unsubscribe, send "unsubscribe" to <phplib-request <email protected>> in
> the body, not the subject, of your message.

-
PHP3 Base Library Mailing List. Send messages to <phplib <email protected>>.
To unsubscribe, send "unsubscribe" to <phplib-request <email protected>> in
the body, not the subject, of your message.