From: Reindl Harald
Date: September 9 2011 4:49pm
Subject: Re: MySQL daemons restarting every 7 minutes
List-Archive: http://lists.mysql.com/mysql/225695
Message-Id: <4E6A43A8.4020803@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enigE6019954378DEA9458EABBD2"

--------------enigE6019954378DEA9458EABBD2
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

jesus christ can you post a WHOLE log
this is only a normal start, there is no single line about stop

Am 09.09.2011 18:30, schrieb a.smith@stripped:
> Yep, but its basically identical to the info in the logs when its resta=
rting itself. I have upgraded to MySQL 5.5
> as of yesterday, so the error info differs due to the version now. Here=
 is the log output:
>=20
> 110909 17:27:35 mysqld_safe Starting mysqld daemon with databases from =
/var/db/mysql
> 110909 17:27:35 InnoDB: The InnoDB memory heap is disabled
> 110909 17:27:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins
> 110909 17:27:35 InnoDB: Compressed tables use zlib 1.2.3
> 110909 17:27:35 InnoDB: Initializing buffer pool, size =3D 2.0G
> 110909 17:27:36 InnoDB: Completed initialization of buffer pool
> 110909 17:27:36 InnoDB: highest supported file format is Barracuda.
> 110909 17:27:36  InnoDB: Waiting for the background threads to start
> 110909 17:27:37 InnoDB: 1.1.8 started; log sequence number 1589339
> 110909 17:27:37 [Note] Slave SQL thread initialized, starting replicati=
on in log 'mysql-bin.002830' at position
> 293541, relay log './tau-relay-bin.000920' position: 253
> 110909 17:27:37 [Note] Event Scheduler: Loaded 0 events
> 110909 17:27:37 [Note] /usr/local/libexec/mysqld: ready for connections=
=2E
> Version: '5.5.15'  socket: '/tmp/mysql.sock'  port: 3306  Source distri=
bution
> 110909 17:27:37 [Note] Slave I/O thread: connected to master 'slave@kap=
pa:3306',replication started in log
> 'mysql-bin.002830' at position 293541
>=20
> Just not giving any hit of a problem....
>=20
> thanks Andy.
>=20
> Quoting Suresh Kuna <sureshkumarilu@stripped>:
>=20
>> can you remove it from service and start it normally using mysqld_safe=
 with
>> log warnings enabled in the cnf file.
>>
>> On Fri, Sep 9, 2011 at 4:16 PM, <a.smith@stripped> wrote:
>>
>>> Hi,
>>>
>>>  that really is the complete error log, that exact same info gets rep=
eated
>>> over and over, there is zero in the syslog and I get this behaviour w=
hen
>>> running with no my.cnf (I do obviously have one but I tried without a=
nd it I
>>> still see the prob, so that probably makes things easier from a
>>> troubleshooting perspective)...
>>> The system has loads of free RAM (8GB total).
>>> Really the system isn't giving me much to go in in terms of clues....=

>>>
>>> Andy.
>=20
>=20
>=20
>=20
>=20

--=20

Mit besten Gr=FC=DFen, Reindl Harald
the lounge interactive design GmbH
A-1060 Vienna, Hofm=FChlgasse 17
CTO / software-development / cms-solutions
p: +43 (1) 595 3999 33, m: +43 (676) 40 221 40
icq: 154546673, http://www.thelounge.net/

http://www.thelounge.net/signature.asc.what.htm


--------------enigE6019954378DEA9458EABBD2
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk5qQ6gACgkQhmBjz394AnlObgCdG+JFzwwzKBKWQVN4uPTj+53D
4o8AoJUERFf1/3mHftWFaKOmS2EeBdyc
=4kp1
-----END PGP SIGNATURE-----

--------------enigE6019954378DEA9458EABBD2--