Loosing connection with "show open tables"

Hi,
this is something weird. We have mysql-4.0.2 on linux i386, official
binaries. We have a user which has:

How-To-Repeat:

mysql> select * from user where user="wwwpedant";
+---------------+-----------+----------+-------------+------ -------+-------------+-------------+-------------+---------- -+-------------+---------------+--------------+-----------+- -----------+-----------------+------------+------------+---- ----------+------------+-----------------------+------------ ------+--------------+-----------------+------------------+- ---------+------------+-------------+--------------+-------- -------+-------------+-----------------+
| Host | User | password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections |
+---------------+-----------+----------+-------------+------ -------+-------------+-------------+-------------+---------- -+-------------+---------------+--------------+-----------+- -----------+-----------------+------------+------------+---- ----------+------------+-----------------------+------------ ------+--------------+-----------------+------------------+- ---------+------------+-------------+--------------+-------- -------+-------------+-----------------+
| 127.0.0.1 | wwwpedant | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | Y | Y | N | N | N | | | | | 892350001 | 1950445148 | 875652916 |
| 146.107.217.% | wwwpedant | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | Y | Y | N | N | N | | | | | 726412075 | 1279991881 | 0 |



The user accesses test_* database. He can get a list of tables,
but is loosing connection on SHOW OPEN TABLES. It seems permissions
do not allow him to lock a table in a write.
He is not listed in mysql.db table as a user having write
permissions and I thought anyone can access fully those test_* databases.
Is it possible this worked under 4.0.2?

Anyway, he looses connection on SHOW OPEN TABLES.

No errors in the logfile. Any ideas?
--
Martin Mokrejs ,
PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
tel.: +49-89-3187 3683 , fax: +49-89-3187 3585


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12423@lists.mysql.com
To unsubscribe, e-mail

Re: Loosing connection with "show open tables"

On Wednesday 28 August 2002 19:16, Martin MOKREJ=A9 wrote:
> Hi,
> this is something weird. We have mysql-4.0.2 on linux i386, official
> binaries. We have a user which has:
>

MySQL 4.0.3 was released now with large bunch of changes. Could you
please try if it still have the problem.

Also in case the problem is still on the place, please use mysqlbug scrip=
t for
error reporting, so we will have all information required to debug the bu=
g.

Moreover you should post only repeatable bug reports to bugs@lists.mysql.=
com
So if the big is repeatable, please provide all SQL statements required t=
o repeat it,
if it is not repeatable it should be posted to mysql@lists.mysql.com inst=
ead.=20

--=20
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Peter Zaitsev
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
<___/ www.mysql.com M: +7 095 725 4955


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12424@lists.mysql.com
To unsubscribe, e-mail

Re: Loosing connection with "show open tables"

On Wed, 28 Aug 2002, Peter Zaitsev wrote:

> On Wednesday 28 August 2002 19:16, Martin MOKREJ© wrote:
> > Hi,
> > this is something weird. We have mysql-4.0.2 on linux i386, official
> > binaries. We have a user which has:
> >
>
> MySQL 4.0.3 was released now with large bunch of changes. Could you
> please try if it still have the problem.

Hi,
it is repeatable:

$mysql -uwwwpedant -hkulan -p test_japonica
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 25 to server version: 4.0.3-beta

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show tables;
+-------------------------+
| Tables_in_test_japonica |
+-------------------------+
| Upd |
| blast |
| blast_data |
| blimps |
| blimps_data |
| cogs |
| cogs_data |
| coils |
| coils_data |
| contig |
| contig_data |
| exon |
| exon_data |
| funcat |
| funcat_data |
| known3d |
| known3d_data |
| mem |
| mem_data |
| nonglob |
| nonglob_data |
| orf |
| orf_data |
| pfam_data |
| prd |
| prd_data |
| pros |
| pros_data |
| prot_data |
| psort_data |
| pstat_data_backup |
| rep |
| scop1 |
| scop1_data |
| scop2_data |
| seg |
| seg_data |
| struc |
| tmhmm |
| tmhmm_data |
+-------------------------+
40 rows in set (0.03 sec)

mysql> show open tables;
ERROR 2013: Lost connection to MySQL server during query
mysql> show tables;
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 26
Current database: test_japonica

+-------------------------+
| Tables_in_test_japonica |
+-------------------------+
| Upd |
| blast |
| blast_data |
| blimps |
| blimps_data |
| cogs |
| cogs_data |
| coils |
| coils_data |
| contig |
[...]


Please let me know what kind of information do you need. We have

I tried with some other databases, and still have same problem.
Maybe this gives you a hint:

mysql> explain show open tables;
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 40
Current database: Agrobacterium_tumefaciens_C58

ERROR 1064: You have an error in your SQL syntax near 'show open tables' at line 1
mysql>


--
Martin Mokrejs ,
PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
tel.: +49-89-3187 3683 , fax: +49-89-3187 3585


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12425@lists.mysql.com
To unsubscribe, e-mail

Re: Loosing connection with "show open tables"

On Thursday 29 August 2002 13:20, Martin MOKREJ=A9 wrote:

> >
> > MySQL 4.0.3 was released now with large bunch of changes. Could you
> > please try if it still have the problem.
>
> Hi,
> it is repeatable:

Dear Martin.

Unfortunately the information provided is not enough. I've just tested th=
e same command
sequence on my 4.0.3 and it works, thus the problem seems to be related t=
o your configuration.
Number of your tables, number of open tables, MySQL configuration etc.

We generally need repeatable test case for MySQL in default configuration=
and empty=20
database, as it comes recently installed as this is only configuration we=
can use as a base.

Also I would note you once again forgot to use mysqlbug script for writin=
g bug report, which=20
makes us even harder to understand the problem.

If your test case would be really large (ie you will have to create 10.00=
0 tables for bug to appear)

please do not send it to the list but upload to ftp://support.mysql.com/p=
ub/mysql/secret=20
and inform us about file name

Thank you.


--=20
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Peter Zaitsev
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
<___/ www.mysql.com M: +7 095 725 4955


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12427@lists.mysql.com
To unsubscribe, e-mail

Re: Loosing connection with "show open tables"

Hi,
my report is longer then the listserver allows, so please have a look at
http://www.natur.cuni.cz/~mmokrejs/mysql-403.txt . My problem with loosing
connection with 'show open tables' I had on linux-2.4.18-pre1,
linux-2.4.18-pre2, and have debugged that on linux-2.4.20-pre5.
We are running Debian Linux on SMP boxes, one with HIGMEM second box
without HIGHMEM. Both show the problem after running for a while. Both
boxes where upgraded to contain same version of all packages.


How-To-Repeat:

The problem is I thing

do_command: info: vio_read returned -1, errno: 11

and once I've seen complaint from mysql like:

020829 19:28:18 Aborted connection 9 to db: 'nsb9' user: 'frishman' host: `146.107.217.46' (Got an error writing communication packets)

I do not see any networking problems. After uptime 19hours I see:

eth0 Link encap:Ethernet HWaddr 00:50:04:51:81:DC
inet addr:146.107.217.84 Bcast:146.107.217.255 Mask:255.255.255.0
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:10771275 errors:0 dropped:0 overruns:0 frame:0
TX packets:16175522 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:100
RX bytes:2316035607 (2.1 GiB) TX bytes:3645607832 (3.3 GiB)
Interrupt:17 Base address:0xb400


You will see also netstat output at the end of the report on web.

And finally, I crashed mysqld so new problem is resolved stacktrace for
you. If you'd know about better debugging options for this problem, please
let me know.

TIA
--
Martin Mokrejs ,
PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
tel.: +49-89-3187 3683 , fax: +49-89-3187 3585





------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12435@lists.mysql.com
To unsubscribe, e-mail

Re: Loosing connection with "show open tables"

=3D?iso-8859-2?Q?Martin_MOKREJ=3DA9?=3D writes:
> Hi,
> this is something weird. We have mysql-4.0.2 on linux i386, officia=
l
> binaries. We have a user which has:
>=20
> How-To-Repeat:
>=20
> | 146.107.217.% | wwwpedant | | N | N | =
N | N | N | N | N | N =
| N | N | N | N | =
N | N | N | N | Y =
| Y | N | N | N =
| | | | | 7264120=
75 | 1279991881 | 0 |
>=20
>=20
>=20
> The user accesses test_* database. He can get a list of tables,
> but is loosing connection on SHOW OPEN TABLES. It seems permissions
> do not allow him to lock a table in a write.
> He is not listed in mysql.db table as a user having write
> permissions and I thought anyone can access fully those test_* databa=
ses.
> Is it possible this worked under 4.0.2?
>=20
> Anyway, he looses connection on SHOW OPEN TABLES.
>=20
> No errors in the logfile. Any ideas?
> --=20
> Martin Mokrejs ,
> PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
> MIPS / Institute for Bioinformatics
> GSF - National Research Center for Environment and Health
> Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
> tel.: +49-89-3187 3683 , fax:=A0+49-89-3187 3585
>=20

Hi!

I hereby confirm what Peter has said.

I have fixed this problem in 4.0.3 before anyone has reported it.

You will have to fix the above numbers manually, I am afraid ...


--=20
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic >
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12440@lists.mysql.com
To unsubscribe, e-mail

Re: Loosing connection with "show open tables"

=3D?iso-8859-2?Q?Martin_MOKREJ=3DA9?=3D writes:
> Hi,
> this is something weird. We have mysql-4.0.2 on linux i386, officia=
l
> binaries. We have a user which has:
>=20
> How-To-Repeat:
>=20
> Martin Mokrejs ,
> PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
> MIPS / Institute for Bioinformatics
> GSF - National Research Center for Environment and Health
> Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
> tel.: +49-89-3187 3683 , fax:=A0+49-89-3187 3585
>=20

Just to correct myself.

When I said that I have fixed a problem in 4.0.3, I was referring to
those random integer values.

--=20
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic >
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12441@lists.mysql.com
To unsubscribe, e-mail

Re: Loosing connection with "show open tables"

=3D?iso-8859-2?Q?Martin_MOKREJ=3DA9?=3D writes:
> Hi,
> my report is longer then the listserver allows, so please have a lo=
ok at
> http://www.natur.cuni.cz/~mmokrejs/mysql-403.txt . My problem with lo=
osing
> connection with 'show open tables' I had on linux-2.4.18-pre1,
> linux-2.4.18-pre2, and have debugged that on linux-2.4.20-pre5.
> We are running Debian Linux on SMP boxes, one with HIGMEM second box
> without HIGHMEM. Both show the problem after running for a while. Bot=
h
> boxes where upgraded to contain same version of all packages.
>=20

[skip]

>=20
> You will see also netstat output at the end of the report on web.
>=20
> And finally, I crashed mysqld so new problem is resolved stacktrace=
for
> you. If you'd know about better debugging options for this problem, p=
lease
> let me know.
>=20
> TIA
> --=20
> Martin Mokrejs ,
> PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
> MIPS / Institute for Bioinformatics
> GSF - National Research Center for Environment and Health
> Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
> tel.: +49-89-3187 3683 , fax:=A0+49-89-3187 3585
>=20

The above is completely different problem and it is caused by mysqld
running out of file descriptors. Check both your global and ulimit
values.=20

--=20
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic >
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12442@lists.mysql.com
To unsubscribe, e-mail

Re: Loosing connection with "show open tables"

On Fri, 30 Aug 2002, Sinisa Milivojevic wrote:

> > And finally, I crashed mysqld so new problem is resolved stacktrace for
> > you. If you'd know about better debugging options for this problem, please
> > let me know.
>
> The above is completely different problem and it is caused by mysqld
> running out of file descriptors. Check both your global and ulimit
> values.

$ cat /etc/security/limits.conf
* hard nofile 32768
* hard nproc 32768

$ cat /etc/rc3.d/S21network.local
#! /bin/sh
echo "65535" > /proc/sys/fs/file-max
ulimit -n 65535

/etc/my.cnf has:
set-variable = open_files_limit=30000

OK, I'll increase the values in /etc/security/limits.conf , if you think
so. ;) I do not see any errors in hostn.err.

--
Martin Mokrejs ,
PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
tel.: +49-89-3187 3683 , fax: +49-89-3187 3585


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12443@lists.mysql.com
To unsubscribe, e-mail

Re: Loosing connection with "show open tables"

On Fri, 30 Aug 2002, Sinisa Milivojevic wrote:

Hi,

> =?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
> > Hi,
> > this is something weird. We have mysql-4.0.2 on linux i386, official
> > binaries. We have a user which has:
> >
> > How-To-Repeat:
> >
> > | 146.107.217.% | wwwpedant | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | Y | Y | N | N | N | | | | | 726412075 | 1279991881 | 0 |
> >
> >
> >
> > The user accesses test_* database. He can get a list of tables,
> > but is loosing connection on SHOW OPEN TABLES. It seems permissions
> > do not allow him to lock a table in a write.
> > He is not listed in mysql.db table as a user having write
> > permissions and I thought anyone can access fully those test_* databases.
> > Is it possible this worked under 4.0.2?
> >
> > Anyway, he looses connection on SHOW OPEN TABLES.
> >
> > No errors in the logfile. Any ideas?

Actually I have to say that at least now, I'm getting into host.err file:

020830 14:44:06 Aborted connection 822 to db: 'unconnected' user: 'wwwpedant' host: `146.107.217.64' (Got an error writing communica
tion packets)
020830 14:46:14 Aborted connection 824 to db: 'unconnected' user: 'wwwpedant' host: `146.107.217.64' (Got an error writing communica
tion packets)
020830 14:46:20 Aborted connection 825 to db: 'unconnected' user: 'wwwpedant' host: `146.107.217.64' (Got an error writing communica
tion packets)

Maybe this is just because of current situation, as I've done even these test yesterday
using same 4.0.3 with debug enabled and received this errorlog line only once.

>
> Hi!
>
> I hereby confirm what Peter has said.

Unfortunately I don't know what he said and where. :(

>
> I have fixed this problem in 4.0.3 before anyone has reported it.
>
> You will have to fix the above numbers manually, I am afraid ...

Hmm, I set them to 0. Would empty value be better?

--
Martin Mokrejs ,
PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
tel.: +49-89-3187 3683 , fax: +49-89-3187 3585


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12446@lists.mysql.com
To unsubscribe, e-mail

Re: Loosing connection with "show open tables"

=3D?iso-8859-2?Q?Martin_MOKREJ=3DA9?=3D writes:
> On Fri, 30 Aug 2002, Sinisa Milivojevic wrote:
>=20
>=20
> $ cat /etc/security/limits.conf
> * hard nofile 32768
> * hard nproc 32768
>=20
> $ cat /etc/rc3.d/S21network.local
> #! /bin/sh
> echo "65535" > /proc/sys/fs/file-max
> ulimit -n 65535
>=20
> /etc/my.cnf has:
> set-variable =3D open_files_limit=3D30000
>=20
> OK, I'll increase the values in /etc/security/limits.conf , if you th=
ink
> so. ;) I do not see any errors in hostn.err.
>=20
> --=20
> Martin Mokrejs ,
> PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
> MIPS / Institute for Bioinformatics
> GSF - National Research Center for Environment and Health
> Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
> tel.: +49-89-3187 3683 , fax:=A0+49-89-3187 3585
>=20

Hmm, the above looks fine, even better would be to have this in
my.cnf:

[safe_mysqld] or [mysqld_safe}
open-files-limit=3D.,...
=20
You have nothing in .err as you have not started mysqld with
--warnings.

If it is not a limit reached in fd's, then it could be some TCP/IP
problem.=20

--=20
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic >
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12447@lists.mysql.com
To unsubscribe, e-mail

Re: Loosing connection with "show open tables"

=3D?iso-8859-2?Q?Martin_MOKREJ=3DA9?=3D writes:
> On Fri, 30 Aug 2002, Sinisa Milivojevic wrote:
>=20
> Hi,
>=20
> Actually I have to say that at least now, I'm getting into host.err f=
ile:
>=20
> 020830 14:44:06 Aborted connection 822 to db: 'unconnected' user: 'w=
wwpedant' host: `146.107.217.64' (Got an error writing communica
> tion packets)
> 020830 14:46:14 Aborted connection 824 to db: 'unconnected' user: 'w=
wwpedant' host: `146.107.217.64' (Got an error writing communica
> tion packets)
> 020830 14:46:20 Aborted connection 825 to db: 'unconnected' user: 'w=
wwpedant' host: `146.107.217.64' (Got an error writing communica
> tion packets)
>=20
> Maybe this is just because of current situation, as I've done even th=
ese test yesterday
> using same 4.0.3 with debug enabled and received this errorlog line o=
nly once.
>=20
> Hmm, I set them to 0. Would empty value be better?
>=20
> --=20
> Martin Mokrejs ,
> PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
> MIPS / Institute for Bioinformatics
> GSF - National Research Center for Environment and Health
> Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
> tel.: +49-89-3187 3683 , fax:=A0+49-89-3187 3585
>=20


The above errors (not a crash with SHOW OPEN TABLES) are most likely
caused by LAN problems.=20

Are you using LAN ??

If yes, please read about duplexing problems in our (fine) manual.

--=20
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic >
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12448@lists.mysql.com
To unsubscribe, e-mail

Re: Loosing connection with "show open tables"

On Fri, 30 Aug 2002, Sinisa Milivojevic wrote:

> =?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
> > On Fri, 30 Aug 2002, Sinisa Milivojevic wrote:
> >
> >
> > $ cat /etc/security/limits.conf
> > * hard nofile 32768
> > * hard nproc 32768
> >
> > $ cat /etc/rc3.d/S21network.local
> > #! /bin/sh
> > echo "65535" > /proc/sys/fs/file-max
> > ulimit -n 65535
> >
> > /etc/my.cnf has:
> > set-variable = open_files_limit=30000
>
> Hmm, the above looks fine, even better would be to have this in
> my.cnf:
>
> [safe_mysqld] or [mysqld_safe}
> open-files-limit=.,...

I have this already in [mysqld] section. Is it not the right place?

>
> You have nothing in .err as you have not started mysqld with
> --warnings.

No, I have:

[mysqld]
warnings


On this box I have really no warnings logged (maybe there're none), but on
another I have (which sometimes also has show "Lost connection ... "
problem:

020829 13:28:56 mysqld started
/usr/local/mysql/bin/mysqld: ready for connections

Status information:

Current dir: /data/mysql/
Current locks:
key_cache status:
blocks used: 2615
not flushed: 0
w_requests: 0
writes: 0
r_requests: 0
reads: 0

handler status:
read_key: 0
read_next: 0
read_rnd 0
read_first: 0
write: 0
delete 0
update: 0

Table status:
Opened tables: 0
Open tables: 0
Open files: 0
Open streams: 0

Alarm status:
Active alarms: 2
Max used alarms: 4
Next alarm time: 53913

Status information:

Current dir: /data/mysql/
Current locks:
key_cache status:
blocks used: 2618
not flushed: 0
w_requests: 0
writes: 0
r_requests: 0
reads: 0

handler status:
read_key: 0
read_next: 0
read_rnd 0
read_first: 0
write: 0
delete 0
update: 0

Table status:
Opened tables: 0
Open tables: 0
Open files: 0
Open streams: 0

Alarm status:
Active alarms: 2
Max used alarms: 4
Next alarm time: 53903

Status information:

Current dir: /data/mysql/
Current locks:
key_cache status:
blocks used: 3872
not flushed: 0
w_requests: 0
writes: 0
r_requests: 0
reads: 0

handler status:
read_key: 0
read_next: 0
read_rnd 0
read_first: 0
write: 0
delete 0
update: 0

Table status:
Opened tables: 0
Open tables: 0
Open files: 0
Open streams: 0

Alarm status:
Active alarms: 0
Max used alarms: 6
Next alarm time: 0

Status information:

Current dir: /data/mysql/
Current locks:
key_cache status:
blocks used: 3899
not flushed: 0
w_requests: 0
writes: 0
r_requests: 0
reads: 0

handler status:
read_key: 0
read_next: 0
read_rnd 0
read_first: 0
write: 0
delete 0
update: 0

Table status:
Opened tables: 0
Open tables: 0
Open files: 0
Open streams: 0

Alarm status:
Active alarms: 0
Max used alarms: 6
Next alarm time: 0

Status information:

Current dir: /data/mysql/
Current locks:
lock: 844431c: read
read : 87d2bd4 (3952643:1);

key_cache status:
blocks used: 3903
not flushed: 0
w_requests: 0
writes: 0
r_requests: 0
reads: 0

handler status:
read_key: 0
read_next: 0
read_rnd 0
read_first: 0
write: 0
delete 0
update: 0

Table status:
Opened tables: 0
Open tables: 1
Open files: 2
Open streams: 0

Alarm status:
Active alarms: 0
Max used alarms: 6
Next alarm time: 0

Status information:

Current dir: /data/mysql/
Current locks:
key_cache status:
blocks used: 3915
not flushed: 0
w_requests: 0
writes: 0
r_requests: 0
reads: 0

handler status:
read_key: 0
read_next: 0
read_rnd 0
read_first: 0
write: 0
delete 0
update: 0

Table status:
Opened tables: 0
Open tables: 0
Open files: 0
Open streams: 0

Alarm status:
Active alarms: 0
Max used alarms: 6
Next alarm time: 0

Status information:

Current dir: /data/mysql/
Current locks:
key_cache status:
blocks used: 3927
not flushed: 0
w_requests: 0
writes: 0
r_requests: 0
reads: 0

handler status:
read_key: 0
read_next: 0
read_rnd 0
read_first: 0
write: 0
delete 0
update: 0

Table status:
Opened tables: 0
Open tables: 0
Open files: 0
Open streams: 0

Alarm status:
Active alarms: 0
Max used alarms: 6
Next alarm time: 0

Status information:

Current dir: /data/mysql/
Current locks:
key_cache status:
blocks used: 3930
not flushed: 0
w_requests: 0
writes: 0
r_requests: 0
reads: 0

handler status:
read_key: 0
read_next: 0
read_rnd 0
read_first: 0
write: 0
delete 0
update: 0

Table status:
Opened tables: 0
Open tables: 0
Open files: 0
Open streams: 0

Alarm status:
Active alarms: 0
Max used alarms: 6
Next alarm time: 0


Unfortunately, I haven't found yet explanation how to read them.


>
> If it is not a limit reached in fd's, then it could be some TCP/IP
> problem.

That's what I'd think, I thing there were such post in past months, and
always said to be networking problem. Hmm, but what should I do.
Seems a bug in kernel or networking part in mysql.

--
Martin Mokrejs ,
PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
tel.: +49-89-3187 3683 , fax: +49-89-3187 3585



------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12449@lists.mysql.com
To unsubscribe, e-mail

Re: Loosing connection with "show open tables"

=3D?iso-8859-2?Q?Martin_MOKREJ=3DA9?=3D writes:
> On Fri, 30 Aug 2002, Sinisa Milivojevic wrote:
>=20
>=20
> I have this already in [mysqld] section. Is it not the right place?
>=20

As safe_mysqld is run by root and mysqld by e.g. user mysql, guess
which one has more chances. But if you do not get any messages in the
..err file related to setrlimit(), then either one is ok.

In that case, you do not have problem with fd's, but problems with LAN.=


>=20
> No, I have:
>=20
> [mysqld]
> warnings
>=20

Yes, this is it.

>=20
> On this box I have really no warnings logged (maybe there're none), b=
ut on
> another I have (which sometimes also has show "Lost connection ... "
> problem:
>=20
> 020829 13:28:56 mysqld started
> /usr/local/mysql/bin/mysqld: ready for connections
>=20
> Status information:
>=20
>=20
> Unfortunately, I haven't found yet explanation how to read them.
>=20

This is just statistics.

>=20
> >
> > If it is not a limit reached in fd's, then it could be some TCP/IP
> > problem.
>=20
> That's what I'd think, I thing there were such post in past months, a=
nd
> always said to be networking problem. Hmm, but what should I do.
> Seems a bug in kernel or networking part in mysql.
>=20
> --=20
> Martin Mokrejs ,
> PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
> MIPS / Institute for Bioinformatics
> GSF - National Research Center for Environment and Health
> Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
> tel.: +49-89-3187 3683 , fax:=A0+49-89-3187 3585
>=20
>=20
>=20

--=20
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic >
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12450@lists.mysql.com
To unsubscribe, e-mail

Re: Loosing connection with "show open tables"

=3D?iso-8859-2?Q?Martin_MOKREJ=3DA9?=3D writes:
> On Wed, 28 Aug 2002, Peter Zaitsev wrote:
>=20
>=20
> Hi,
> it is repeatable:
>=20
> $mysql -uwwwpedant -hkulan -p test_japonica
> Enter password:
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 25 to server version: 4.0.3-beta
>=20
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>=20
>=20
> --=20
> Martin Mokrejs ,
> PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
> MIPS / Institute for Bioinformatics
> GSF - National Research Center for Environment and Health
> Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
> tel.: +49-89-3187 3683 , fax:=A0+49-89-3187 3585
>=20

Hi!

I tried to repeat it with 4.0.3 and no success !!

I ran few cartesian products with 5 tables, then show table, then show
optn tables and no success at all !!!

Please check exactly what I should do to get connection lost error
with show open tables.


--=20
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic >
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12455@lists.mysql.com
To unsubscribe, e-mail