List:General Discussion« Previous MessageNext Message »
From:zxcv Date:September 27 2002 4:33am
Subject:Known Database "Unknown"...
View as plain text  
Hello all,

MySQL 3.23.51 
Apache 1.3.26

In my php connection to MySQL I send a message if there is a problem.
Today for the first time in 3 years of MySQL/Apache use I received the
following error message:

[26-Sep-2002 15:49:14] ERROR: Couldn't connect to the DB while drawing the
main page quicklinks. 
Unknown database 'ADMIN' 

[26-Sep-2002 18:41:41] ERROR: Couldn't connect to the DB while drawing the
main page quicklinks. 
Unknown database 'ADMIN'

Yet any other time or when I connect manually to the database, it's there:

mysql> use ADMIN;
Database changed
mysql> show tables;
+-----------------+
| Tables_in_ADMIN |
+-----------------+
| QUICKLINKS      |
+-----------------+
1 row in set (0.00 sec)

The only thing I could see off the top is the duplicate times of
connection (My Apache Logs in both cases showed duplicate timestamps), but
this can't be? It connected, just couldn't talk to the Database... 

I/O issue?

The database server is on a PII 450 with 384MB's of ram. 100Mb/s
Full-Duplex running SCSI-3... FreeBSD 4.6.2-RELEASE. Data is the only
thing using that drive. My Cron job showing uptime shows 0.00 0.00 0.00
across the board with little spiking, and then only to 0.02 - 0.04.

MySQL status:

Threads: 1  Questions: 1860358  Slow queries: 5  Opens: 2004  Flush
tables: 1  Open tables: 256 Queries per second avg: 0.524

MySQL show status:

| Table_locks_immediate    | 3052077    |
| Table_locks_waited       | 0          |
| Open_tables              | 256        | <-- This???
| Open_files               | 479        |
| Opened_tables            | 2004       |

Any suggestions? Did I run out of file descriptors? Currently some
sysctl's are:

kern.maxfiles: 13542 (Max can be: 65536)
kern.maxfilesperproc: 12187 (Max can be: 32768)

Thank you in advance...

Rob B.


Thread
Known Database "Unknown"...zxcv27 Sep
  • Re: Known Database "Unknown"...Dan Nelson27 Sep