Installation 4.1.1

------=_NextPart_000_0204_01C3BB37.7C413730
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Hello,

I have a problem in the installation of mysql 4.1.1.
When i try to install the server rpm, i get the following error message =
:=20

/usr/bin/mysql_install_db: line 202: =
/usr/bin/mysql_create_system_tables: No such file or directory
ERROR: 1046 No Database Selected
(...)

This file (mysql_create_system_tables) doesn't seem to be in the rpm.
Is it a bug in the rpm or does i do something wrong ?
I have no problem with the installation of mysql 4.1.0.

Thank you for your help.

Bertrand Lanneau.

------=_NextPart_000_0204_01C3BB37.7C413730--

Re: Installation 4.1.1

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

On Fri, 5 Dec 2003, Bertrand Lanneau wrote:

> I have a problem in the installation of mysql 4.1.1. When i try to
> install the server rpm, i get the following error message :
>
> /usr/bin/mysql_install_db: line 202: /usr/bin/mysql_create_system_tables: No such file or directory
> ERROR: 1046 No Database Selected
> (...)
>
> This file (mysql_create_system_tables) doesn't seem to be in the rpm.

Yes, you are right - thanks for spotting this one!

> Is it a bug in the rpm or does i do something wrong ?

No, it's a packaging bug on our side - it will be fixed soon.

As a workaround, you can "steal" that file from a binary distribution
(tarball) and place it into /usr/bin.

I will prepare an updated MySQL-server RPM ASAP.

Bye,
LenZ
- --
Lenz Grimmer
Senior Production Engineer
MySQL GmbH, http://www.mysql.de/
Hamburg, Germany

For technical support contracts, visit https://order.mysql.com/?ref=mlgr
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)
Comment: For info see http://quantumlab.net/pine_privacy_guard/

iD8DBQE/0OuASVDhKrJykfIRAmhoAJ4gEAXgCI/WBQcAXULgTU41hoUw5gCf fg7H
ZyUxTtgMJlZYQRwDXWcqsco=
=tSGS
-----END PGP SIGNATURE-----

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Installation 4.1.1

------=_NextPart_000_00B0_01C3BE4E.20FB1C00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Hi,

Ok, I stole the file in the tar distribution and succeeded in the=20
installation of mysql 4.1.1 .

I then checked some new features i was interested in:=20
- you wrote in the changelog that mysql 4.1.1 count now characters and=20
no more bytes.
I checked the length of "ab=E9" and got 4 ... it doesn't work.
- I had mentionned a bug two months ago : crash of mysql with the =
execution of
create table t1 (col1 varchar(20) PRIMARY KEY, col2 varchar(30) not =
null, unique index(col2));
insert into t1 set col1=3D"abc", col2=3D"Ik=E9a";
update t1 set col2=3D"Ikea" where col2=3D"Ik=E9a";
This still crashes mysql... :-(

I then supposed that i could use mysql 4.1.1 and have to wait some more =
time for the=20
fixes of the bugs mentionned above but :
- I'm now unable to connect from Java. I got exactly the same error =
messages as if
mysql was down :=20
Caused by: java.sql.SQLException: Server connection failure during =
transaction.
Attempted reconnect 3 times. Giving up.
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1704)
Does i have to change something in my code to upgrade from 4.10 to 4.1.1 =
?
- I'm also unable to type characters with accents(=E9,=E8, ...) in the =
client . My console
is unusable...

I reinstalled mysql 4.1.0 and everything works fine again (java, =
console).=20
I have no doubt mysql 4.1.1 will bring a lot of ameliorations/bug fixes, =
but i suppose
i have to wait some more time before it will be usable.

I hope the mention of these bugs can help fixing it.

Bertrand Lanneau.





----- Original Message -----=20
From: "Lenz Grimmer"
To: "Bertrand Lanneau"
Cc:
Sent: Friday, December 05, 2003 9:33 PM
Subject: Re: Installation 4.1.1=20


> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>=20
> Hi,
>=20
> On Fri, 5 Dec 2003, Bertrand Lanneau wrote:
>=20
> > I have a problem in the installation of mysql 4.1.1. When i try to
> > install the server rpm, i get the following error message :
> >=20
> > /usr/bin/mysql_install_db: line 202: =
/usr/bin/mysql_create_system_tables: No such file or directory
> > ERROR: 1046 No Database Selected
> > (...)
> >=20
> > This file (mysql_create_system_tables) doesn't seem to be in the =
rpm.
>=20
> Yes, you are right - thanks for spotting this one!
>=20
> > Is it a bug in the rpm or does i do something wrong ?
>=20
> No, it's a packaging bug on our side - it will be fixed soon.
>=20
> As a workaround, you can "steal" that file from a binary distribution=20
> (tarball) and place it into /usr/bin.
>=20
> I will prepare an updated MySQL-server RPM ASAP.
>=20
> Bye,
> LenZ
> - --=20
> Lenz Grimmer
> Senior Production Engineer
> MySQL GmbH, http://www.mysql.de/
> Hamburg, Germany
>=20
> For technical support contracts, visit =
https://order.mysql.com/?ref=3Dmlgr
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.2 (GNU/Linux)
> Comment: For info see http://quantumlab.net/pine_privacy_guard/
>=20
> iD8DBQE/0OuASVDhKrJykfIRAmhoAJ4gEAXgCI/WBQcAXULgTU41hoUw5gCf fg7H
> ZyUxTtgMJlZYQRwDXWcqsco=3D
> =3DtSGS
> -----END PGP SIGNATURE-----
>=20
> --=20
> MySQL Bugs Mailing List
> For list archives: http://lists.mysql.com/bugs
> To unsubscribe: =
http://lists.mysql.com/bugs?unsub=3Dbertrand.lanneau@citobi. be
>=20
>
------=_NextPart_000_00B0_01C3BE4E.20FB1C00--

Re: Installation 4.1.1

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello,

Bertrand Lanneau wrote:
> Hi,
>
> Ok, I stole the file in the tar distribution and succeeded in the
> installation of mysql 4.1.1 .
>
> I then checked some new features i was interested in:
> - you wrote in the changelog that mysql 4.1.1 count now characters and
> no more bytes.
> I checked the length of "abé" and got 4 ... it doesn't work.
> - I had mentionned a bug two months ago : crash of mysql with the execution of
> create table t1 (col1 varchar(20) PRIMARY KEY, col2 varchar(30) not null,
unique index(col2));
> insert into t1 set col1="abc", col2="Ikéa";
> update t1 set col2="Ikea" where col2="Ikéa";
> This still crashes mysql... :-(


How does this crashes MySQL? Please fill in repeatable test case and include
your server and client character set settings. If you already did that tell us
what Bug number in http://bugs.mysql.com is.



mysql> create table t1 (col1 varchar(20) PRIMARY KEY, col2 varchar(30) not null,
unique index(col2));
Query OK, 0 rows affected (0.00 sec)

mysql> insert into t1 set col1="abc", col2="Ikéa";
Query OK, 1 row affected (0.00 sec)

mysql> select * from t1;
+------+-------+
| col1 | col2 |
+------+-------+
| abc | Ikéa |
+------+-------+
1 row in set (0.00 sec)


mysql> select * from t1 where col2="Ikéa";
+------+-------+
| col1 | col2 |
+------+-------+
| abc | Ikéa |
+------+-------+
1 row in set (0.00 sec)


mysql> update t1 set col2="Ikea" where col2="Ikéa";
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select * from t1;
+------+------+
| col1 | col2 |
+------+------+
| abc | Ikea |
+------+------+
1 row in set (0.00 sec)


Nothing wrong here.

For LENGHT() function I agree it is broken:


update t1 set col1="abé" where col2="Ikea";
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select col1, length(col1) from t1;
+------+--------------+
| col1 | length(col1) |
+------+--------------+
| abé | 4 |
+------+--------------+
1 row in set (0.00 sec)


However CHAR_LENGTH() works well.

mysql> select col1, length(col1), char_length(col1) from t1;
+------+--------------+-------------------+
| col1 | length(col1) | char_length(col1) |
+------+--------------+-------------------+
| abé | 4 | 3 |
+------+--------------+-------------------+



> Bertrand Lanneau.

Best regards

- --
Are you MySQL certified? -> http://www.mysql.com/certification
For technical support contracts, visit https://order.mysql.com/?ref=msal
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
<___/ www.mysql.com


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

iD8DBQE/1blMeehWBZ4HcYkRAvd1AKCu6VpoalO1dCqs7OUXRvViePR1IQCg u2AN
teRunhRjg1CP1TITXdoqdiQ=
=x7hQ
-----END PGP SIGNATURE-----


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Installation 4.1.1

Hi!

On Dec 09, Alexander Keremidarski wrote:
>
> For LENGHT() function I agree it is broken.
> However CHAR_LENGTH() works well.

The manual specifies that:

`LENGTH(str)'
Returns the length of the string `str', measured in bytes. A
multi-byte character counts as multiple bytes. This means that
for a string containing five two-byte characters, `LENGTH()'
returns `10', whereas `CHAR_LENGTH()' returns `5'.

Regards,
Sergei

--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org

Re: Installation 4.1.1

Bertrand Lanneau writes:
>=20
> Hi,
>=20
> Ok, I stole the file in the tar distribution and succeeded in the=20
> installation of mysql 4.1.1 .
>=20
> I then checked some new features i was interested in:=20
> - you wrote in the changelog that mysql 4.1.1 count now characters an=
d=20
> no more bytes.
> I checked the length of "ab=E9" and got 4 ... it doesn't work.
> - I had mentionned a bug two months ago : crash of mysql with the exe=
cution of
> create table t1 (col1 varchar(20) PRIMARY KEY, col2 varchar(30) not n=
ull, unique index(col2));
> insert into t1 set col1=3D"abc", col2=3D"Ik=E9a";
> update t1 set col2=3D"Ikea" where col2=3D"Ik=E9a";
> This still crashes mysql... :-(
>=20
> I then supposed that i could use mysql 4.1.1 and have to wait some mo=
re time for the=20
> fixes of the bugs mentionned above but :
> - I'm now unable to connect from Java. I got exactly the same error m=
essages as if
> mysql was down :=20
> Caused by: java.sql.SQLException: Server connection failure during tr=
ansaction.
> Attempted reconnect 3 times. Giving up.
> at com.mysql.jdbc.Connection.createNewIO(Connection.java:1704=
)
> Does i have to change something in my code to upgrade from 4.10 to 4.=
1.1 =3F
> - I'm also unable to type characters with accents(=E9,=E8, ...) in th=
e client . My console
> is unusable...
>=20
> I reinstalled mysql 4.1.0 and everything works fine again (java, cons=
ole).=20
> I have no doubt mysql 4.1.1 will bring a lot of ameliorations/bug fix=
es, but i suppose
> i have to wait some more time before it will be usable.
>=20
> I hope the mention of these bugs can help fixing it.
>=20
> Bertrand Lanneau.

Hi!

The above small test case should not crash 4.1.1.

Regarding connecting our JDBC to 4.1.1, there were changes in the
protocol and I guess it depends on the version of our JDBC that you
are using.

--=20

Sincerely,

--=20
For technical support contracts, go to https://order.mysql.com/=3Fref=3D=
msmi
__ __=5F __=5F ____ __
/ |/ /=5F __/ __/ __ \/ / Mr. Sinisa Milivojevic nisa@mysql.com>
/ /|=5F/ / // /\ \/ /=5F/ / /__ MySQL AB
/=5F/ /=5F/\=5F, /__=5F/\__=5F\=5F\__=5F/ Fulltime Devel=
oper and Support Coordinator
<__=5F/ www.mysql.com Larnaca, Cyprus


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org

Re: Installation 4.1.1

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Sinisa Milivojevic wrote:

> Bertrand Lanneau writes:
[snip]
>>I hope the mention of these bugs can help fixing it.
>>
>>Bertrand Lanneau.
>
>
> Hi!
>
> The above small test case should not crash 4.1.1.
>
> Regarding connecting our JDBC to 4.1.1, there were changes in the
> protocol and I guess it depends on the version of our JDBC that you
> are using.
>

You need to use a nightly snapshot build of Connector/J 3.0.x or 3.1.x
from http://downloads.mysql.com/snapshots.php to connect to MySQL-4.1.1,
to support the new protocol that 4.1.1 uses.

Connector/J 3.1.1 is going through a final phase of regression and
compliance testing this week, before release, which should occur around
the end of this week.

Regards,

-Mark

- --
Mr. Mark Matthews
MySQL AB, Software Development Manager, J2EE and Windows Platforms
Office: +1 708 557 2388
www.mysql.com

Are you MySQL Certified?
http://www.mysql.com/certification/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQE/1dfytvXNTca6JD8RAt7gAKCopDz6oFBTgoX4BX6Ug6bwZJtyxwCe JopO
9F/eejR44JWneHX7LceHLfo=
=r8GA
-----END PGP SIGNATURE-----

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org