4.0 "production release" corrupts files on install

I have a test machine and a live machine. Fortunately I installed mySQL
4.0.13 on the test machine, because it is corrupting tables on the most
basic operations. I start with a blank table, do an insert, and boom I
receive "Got error 22 from table handler" then "error: 145" file corrupted.

This is a WinXP machine, was working fine on mySQL 3.
I've managed to create a very simple repro. Is this a known issue?

Also, when importing it seems that maybe v3 dumps aren't compatible with
v4?? This is not good. I import a whole table without errors, but then its
empty.




--
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: 4.0 "production release" corrupts files on install

Hi,

When You upgrade from 3.xx to 4.xx there are some changes to tabelstructure,
and by that some procedures to work thrue - please see the details in the
manual.

This might Your case.

Unfortunately, the automatic scripts are only for Linux-versions - but, if
You study the Linux-scripts You find the relevant SQL sentences and these
can be run manually following the manual.

Best regards
Peter







----- Original Message -----
From: "Adam Pedersen"
To:
Sent: Monday, June 23, 2003 8:04 PM
Subject: 4.0 "production release" corrupts files on install


> I have a test machine and a live machine. Fortunately I installed mySQL
> 4.0.13 on the test machine, because it is corrupting tables on the most
> basic operations. I start with a blank table, do an insert, and boom I
> receive "Got error 22 from table handler" then "error: 145" file
corrupted.
>
> This is a WinXP machine, was working fine on mySQL 3.
> I've managed to create a very simple repro. Is this a known issue?
>
> Also, when importing it seems that maybe v3 dumps aren't compatible with
> v4?? This is not good. I import a whole table without errors, but then
its
> empty.
>
>
>
>
> --
> MySQL Bugs Mailing List
> For list archives: http://lists.mysql.com/bugs
> To unsubscribe: http://lists.mysql.com/bugs?unsub=pwr@post4.tele.dk
>
>


--
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: 4.0 "production release" corrupts files on install

Adam,

Adam Pedersen wrote:
> I have a test machine and a live machine. Fortunately I installed mySQL
> 4.0.13 on the test machine, because it is corrupting tables on the most
> basic operations. I start with a blank table, do an insert, and boom I
> receive "Got error 22 from table handler" then "error: 145" file corrupted.
> This is a WinXP machine, was working fine on mySQL 3.
> I've managed to create a very simple repro. Is this a known issue?

We are highly interested in repeating this corruption (as well as any other problem).

If you have repeatable test case please upload it to
ftp://support.mysql.com/pub/secret

Best place to report bugs is http://bugs.mysql.com


> Also, when importing it seems that maybe v3 dumps aren't compatible with
> v4?? This is not good. I import a whole table without errors, but then its
> empty.

This is odd. 3.23 dumps should be 100% compatible with 4.0

Can send us separate repeatable test case for it?

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




--
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: 4.0 "production release" corrupts files on install

That ftp path doesn't seem to exist. But the repro for both problems is
small enough to put here:

--
-- Table structure for table 'whosonline'
--

DROP TABLE IF EXISTS whosonline;
CREATE TABLE whosonline (
MemberID mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (MemberID)
) TYPE=MyISAM;

/*!40000 ALTER TABLE whosonline DISABLE KEYS */;

--
-- Dumping data for table 'whosonline'
--


LOCK TABLES whosonline WRITE;
INSERT INTO whosonline VALUES (22588);

/*!40000 ALTER TABLE whosonline ENABLE KEYS */;
UNLOCK TABLES;

INSERT INTO whosonline SET MemberID="218";

--
-- end
--

This fails right out of the box, with a clean database. And if you comment
out the last insert, it doesn't get the error 22, but it also doesn't insert
anything into the table. The top is from a dump from mysql 3.
I haven't looked into the code changes in 4 yet, because I thought dumps
would be compatible.. either way I think I'll hold off on going to 4 since
this seems like a pretty major issue for a production release. Unless I'm
missing something..

Thanks,
Adam

----- Original Message -----
From: "Alexander Keremidarski"
To: "Adam Pedersen"
Cc:
Sent: Monday, June 23, 2003 1:44 PM
Subject: Re: 4.0 "production release" corrupts files on install


> Adam,
>
> Adam Pedersen wrote:
> > I have a test machine and a live machine. Fortunately I installed mySQL
> > 4.0.13 on the test machine, because it is corrupting tables on the most
> > basic operations. I start with a blank table, do an insert, and boom I
> > receive "Got error 22 from table handler" then "error: 145" file
corrupted.
> > This is a WinXP machine, was working fine on mySQL 3.
> > I've managed to create a very simple repro. Is this a known issue?
>
> We are highly interested in repeating this corruption (as well as any
other problem).
>
> If you have repeatable test case please upload it to
> ftp://support.mysql.com/pub/secret
>
> Best place to report bugs is http://bugs.mysql.com
>
>
> > Also, when importing it seems that maybe v3 dumps aren't compatible with
> > v4?? This is not good. I import a whole table without errors, but then
its
> > empty.
>
> This is odd. 3.23 dumps should be 100% compatible with 4.0
>
> Can send us separate repeatable test case for it?
>
> 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
>
>


--
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: 4.0 "production release" corrupts files on install

Hi,

Adam Pedersen wrote:
> That ftp path doesn't seem to exist. >

Sorry. My fault. It is ftp://support.mysql.com/pub/mysql/secret


> But the repro for both problems is small enough to put here:


Thanks.

> --
> -- Table structure for table 'whosonline'
> --
>
> DROP TABLE IF EXISTS whosonline;
> CREATE TABLE whosonline (
> MemberID mediumint(8) unsigned NOT NULL default '0',
> PRIMARY KEY (MemberID)
> ) TYPE=MyISAM;
>
> /*!40000 ALTER TABLE whosonline DISABLE KEYS */;
> --
> -- Dumping data for table 'whosonline'
> --
>
>
> LOCK TABLES whosonline WRITE;
> INSERT INTO whosonline VALUES (22588);
>
> /*!40000 ALTER TABLE whosonline ENABLE KEYS */;
> UNLOCK TABLES;
>
> INSERT INTO whosonline SET MemberID="218";

I just tried it and result is:

mysql> select * from whosonline;
+----------+
| MemberID |
+----------+
| 218 |
| 22588 |
+----------+
2 rows in set (0.09 sec)


which is expected result.

> --
> -- end
> --
>
> This fails right out of the box, with a clean database. And if you comment
> out the last insert, it doesn't get the error 22, but it also doesn't insert
> anything into the table. The top is from a dump from mysql 3.

I tested it under Linux. We will test it under WinXP too, but I doubt such kind of
bug can be OS related.

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




--
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: 4.0 "production release" corrupts files on install

Very interesting.. if it doesn't repro under windows for you, I'm at a total
loss to what it could be..

Just in case, let me add that I'm using 4.0.13 with mysqld-nt and
my-small.cnf (also tried my-large.cnf)


----- Original Message -----
From: "Alexander Keremidarski"
To: "Adam Pedersen"
Cc:
Sent: Monday, June 23, 2003 2:49 PM
Subject: Re: 4.0 "production release" corrupts files on install


> Hi,
>
> Adam Pedersen wrote:
> > That ftp path doesn't seem to exist. >
>
> Sorry. My fault. It is ftp://support.mysql.com/pub/mysql/secret
>
>
> > But the repro for both problems is small enough to put here:
>
>
> Thanks.
>
> > --
> > -- Table structure for table 'whosonline'
> > --
> >
> > DROP TABLE IF EXISTS whosonline;
> > CREATE TABLE whosonline (
> > MemberID mediumint(8) unsigned NOT NULL default '0',
> > PRIMARY KEY (MemberID)
> > ) TYPE=MyISAM;
> >
> > /*!40000 ALTER TABLE whosonline DISABLE KEYS */;
> > --
> > -- Dumping data for table 'whosonline'
> > --
> >
> >
> > LOCK TABLES whosonline WRITE;
> > INSERT INTO whosonline VALUES (22588);
> >
> > /*!40000 ALTER TABLE whosonline ENABLE KEYS */;
> > UNLOCK TABLES;
> >
> > INSERT INTO whosonline SET MemberID="218";
>
> I just tried it and result is:
>
> mysql> select * from whosonline;
> +----------+
> | MemberID |
> +----------+
> | 218 |
> | 22588 |
> +----------+
> 2 rows in set (0.09 sec)
>
>
> which is expected result.
>
> > --
> > -- end
> > --
> >
> > This fails right out of the box, with a clean database. And if you
comment
> > out the last insert, it doesn't get the error 22, but it also doesn't
insert
> > anything into the table. The top is from a dump from mysql 3.
>
> I tested it under Linux. We will test it under WinXP too, but I doubt such
kind of
> bug can be OS related.
>
> 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
>
>


--
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: 4.0 "production release" corrupts files on install

At 03:07 PM 6/23/2003 -0500, Adam Pedersen wrote:
Hi Adam,

Thank you for the bug report I was able to repeat on Win2k server:

c:\mysql\bin>mysql -uroot test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.0.13-max-debug-log

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

mysql> DROP TABLE IF EXISTS whosonline;
Query OK, 0 rows affected (0.02 sec)

mysql> CREATE TABLE whosonline (
-> MemberID mediumint(8) unsigned NOT NULL default '0',
-> PRIMARY KEY (MemberID)
-> ) TYPE=3DMyISAM;
Query OK, 0 rows affected (0.05 sec)

mysql> /*!40000 ALTER TABLE whosonline DISABLE KEYS */;
Query OK, 0 rows affected (0.01 sec)

mysql> LOCK TABLES whosonline WRITE;
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO whosonline VALUES (22588);
Query OK, 1 row affected (0.02 sec)

mysql> /*!40000 ALTER TABLE whosonline ENABLE KEYS */;
Query OK, 0 rows affected (0.00 sec)

mysql> UNLOCK TABLES;
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO whosonline SET MemberID=3D"218";
ERROR 1030: Got error 22 from table handler
mysql> check table whosonline;
+-----------------+-------+----------+---------------------- ----------------=
-----------+
| Table | Op | Msg_type |=20
Msg_text |
+-----------------+-------+----------+---------------------- ----------------=
-----------+
| test.whosonline | check | warning | Table is marked as=20
crashed |
| test.whosonline | check | warning | Size of indexfile is:=20
2048 Should be: 1024 |
| test.whosonline | check | warning | Size of datafile is: 5 Should=
=20
be: 0 |
| test.whosonline | check | error | Found 1 keys of=20
0 |
| test.whosonline | check | error |=20
Corrupt |
+-----------------+-------+----------+---------------------- ----------------=
-----------+
5 rows in set (0.03 sec)




--=20
Regards,

For technical support contracts, visit https://order.mysql.com/
Are you MySQL certified?, http://www.mysql.com/certification/

Miguel Angel Sol=F3rzano
S=E3o Paulo - Brazil


--
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: 4.0 "production release" corrupts files on install

OK, is this being looked at, or do I need to use the bug form?

I wonder which particular command is screwing it up. If you do things in a
slightly different way, the problem disappears. This must be windows only,
to go this long without being found. I noticed a few discussions searching
the web for "error 22", it sounds like others have had this unresolved
issue.

Adam

----- Original Message -----
From: "miguel solorzano"
To: "Adam Pedersen" ; "Alexander Keremidarski"

Cc:
Sent: Monday, June 23, 2003 5:29 PM
Subject: Re: 4.0 "production release" corrupts files on install


> At 03:07 PM 6/23/2003 -0500, Adam Pedersen wrote:
> Hi Adam,
>
> Thank you for the bug report I was able to repeat on Win2k server:
>
> c:\mysql\bin>mysql -uroot test
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 3 to server version: 4.0.13-max-debug-log
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> DROP TABLE IF EXISTS whosonline;
> Query OK, 0 rows affected (0.02 sec)
>
> mysql> CREATE TABLE whosonline (
> -> MemberID mediumint(8) unsigned NOT NULL default '0',
> -> PRIMARY KEY (MemberID)
> -> ) TYPE=MyISAM;
> Query OK, 0 rows affected (0.05 sec)
>
> mysql> /*!40000 ALTER TABLE whosonline DISABLE KEYS */;
> Query OK, 0 rows affected (0.01 sec)
>
> mysql> LOCK TABLES whosonline WRITE;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> INSERT INTO whosonline VALUES (22588);
> Query OK, 1 row affected (0.02 sec)
>
> mysql> /*!40000 ALTER TABLE whosonline ENABLE KEYS */;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> UNLOCK TABLES;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> INSERT INTO whosonline SET MemberID="218";
> ERROR 1030: Got error 22 from table handler
> mysql> check table whosonline;
>
+-----------------+-------+----------+---------------------- ----------------
-----------+
> | Table | Op | Msg_type |
> Msg_text |
>
+-----------------+-------+----------+---------------------- ----------------
-----------+
> | test.whosonline | check | warning | Table is marked as
> crashed |
> | test.whosonline | check | warning | Size of indexfile is:
> 2048 Should be: 1024 |
> | test.whosonline | check | warning | Size of datafile is: 5 Should
> be: 0 |
> | test.whosonline | check | error | Found 1 keys of
> 0 |
> | test.whosonline | check | error |
> Corrupt |
>
+-----------------+-------+----------+---------------------- ----------------
-----------+
> 5 rows in set (0.03 sec)
>
>
>
>
> --
> Regards,
>
> For technical support contracts, visit https://order.mysql.com/
> Are you MySQL certified?, http://www.mysql.com/certification/
>
> Miguel Angel Solórzano
> São Paulo - Brazil
>
>
> --
> MySQL Bugs Mailing List
> For list archives: http://lists.mysql.com/bugs
> To unsubscribe:
http://lists.mysql.com/bugs?unsub=adamp@adeptsoftware.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: 4.0 "production release" corrupts files on install

At 02:45 PM 6/24/2003 -0500, Adam Pedersen wrote:
Hi,

>OK, is this being looked at, or do I need to use the bug form?

Yes please open a new bug report and I will mark as verified.


>I wonder which particular command is screwing it up. If you do things in a
>slightly different way, the problem disappears. This must be windows only,

Yes with your test case only Windows showed this behavior.

>to go this long without being found. I noticed a few discussions searching
>the web for "error 22", it sounds like others have had this unresolved
>issue.
>
>Adam

--=20
Regards,

For technical support contracts, visit https://order.mysql.com/
Are you MySQL certified?, http://www.mysql.com/certification/

Miguel Angel Sol=F3rzano
S=E3o Paulo - Brazil


--
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: 4.0 "production release" corrupts files on install

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

Adam Pedersen wrote:

> OK, is this being looked at, or do I need to use the bug form?
>
> I wonder which particular command is screwing it up. If you do things
in a
> slightly different way, the problem disappears. This must be windows
only,
> to go this long without being found. I noticed a few discussions
searching
> the web for "error 22", it sounds like others have had this unresolved
> issue.

Adam, I've filed this bug for you, it's #713


You can follow the progress at:

http://bugs.mysql.com/bug.php?id=713

Thanks for the bug report!

-Mark



- --
For technical support contracts, visit https://order.mysql.com/?ref=mmma

__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. Manager - J2EE/Windows
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE++LBstvXNTca6JD8RArtHAJ4wbgnwNoG+qT/I78ai9ZVJYiECHQCd EBL+
nLg/Q8tvYUz8fcjUWtWvisU=
=Abvp
-----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: 4.0 "production release" corrupts files on install

Wow, this is certainly a different response than filing a PHP bug. Thanks!!


----- Original Message -----
From: "Mark Matthews"
To: "Adam Pedersen"
Cc: "Alexander Keremidarski" ; "miguel solorzano"
;
Sent: Tuesday, June 24, 2003 3:11 PM
Subject: Re: 4.0 "production release" corrupts files on install


> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Adam Pedersen wrote:
>
> > OK, is this being looked at, or do I need to use the bug form?
> >
> > I wonder which particular command is screwing it up. If you do things
> in a
> > slightly different way, the problem disappears. This must be windows
> only,
> > to go this long without being found. I noticed a few discussions
> searching
> > the web for "error 22", it sounds like others have had this unresolved
> > issue.
>
> Adam, I've filed this bug for you, it's #713
>
>
> You can follow the progress at:
>
> http://bugs.mysql.com/bug.php?id=713
>
> Thanks for the bug report!
>
> -Mark
>
>
>
> - --
> For technical support contracts, visit https://order.mysql.com/?ref=mmma
>
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mark Matthews
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. Manager - J2EE/Windows
> /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
> <___/ www.mysql.com
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.1 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQE++LBstvXNTca6JD8RArtHAJ4wbgnwNoG+qT/I78ai9ZVJYiECHQCd EBL+
> nLg/Q8tvYUz8fcjUWtWvisU=
> =Abvp
> -----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: 4.0 "production release" corrupts files on install

This critical bug has yet to be looked at, how long does it usually take?
I'm waiting for the diagnosis before I switch to 4...
Thanks,
Adam

----- Original Message -----
From: "miguel solorzano"
To: "Adam Pedersen" ; "Alexander Keremidarski"

Cc:
Sent: Tuesday, June 24, 2003 3:02 PM
Subject: Re: 4.0 "production release" corrupts files on install


> At 02:45 PM 6/24/2003 -0500, Adam Pedersen wrote:
> Hi,
>
> >OK, is this being looked at, or do I need to use the bug form?
>
> Yes please open a new bug report and I will mark as verified.
>
>
> >I wonder which particular command is screwing it up. If you do things in
a
> >slightly different way, the problem disappears. This must be windows
only,
>
> Yes with your test case only Windows showed this behavior.
>
> >to go this long without being found. I noticed a few discussions
searching
> >the web for "error 22", it sounds like others have had this unresolved
> >issue.
> >
> >Adam
>
> --
> Regards,
>
> For technical support contracts, visit https://order.mysql.com/
> Are you MySQL certified?, http://www.mysql.com/certification/
>
> Miguel Angel Solórzano
> São Paulo - Brazil


--
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: 4.0 "production release" corrupts files on install

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

Adam Pedersen wrote:

> This critical bug has yet to be looked at, how long does it usually take?
> I'm waiting for the diagnosis before I switch to 4...
> Thanks,
> Adam

I just got through speaking with Monty about it, he's going to look at
it later today. We're in the process of working out all known bugs for
4.0.14 before we release it (with this being one of the 'known' bugs).

-Mark
- --
For technical support contracts, visit https://order.mysql.com/?ref=mmma

__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. Manager - J2EE/Windows
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/BEn6tvXNTca6JD8RAsZBAJ97wlcIe98sDbaKVWi7ZE4TJL6/rACf XX5y
PbdHkLwn5dte4wvnLLEa9Gc=
=mq9O
-----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: 4.0 "production release" corrupts files on install

At 20:37 +0200 6/23/03, PeterWR wrote:
>Hi,
>
>When You upgrade from 3.xx to 4.xx there are some changes to tabelstructure,
>and by that some procedures to work thrue - please see the details in the
>manual.

What? That might be true when upgrading to 4.1.x, but the manual states
that when upgrading from 3.23 to 4.0.x you can continue to use your
data with no changes:

http://www.mysql.com/doc/en/Upgrading-from-3.23.html

It's recommended that you convert ISAM tables to MyISAM tables, but
even in this case you can continue to use them without conversion.

>
>This might Your case.
>
>Unfortunately, the automatic scripts are only for Linux-versions - but, if
>You study the Linux-scripts You find the relevant SQL sentences and these
>can be run manually following the manual.
>
>Best regards
>Peter
>
>
>
>
>
>
>
>----- Original Message -----
>From: "Adam Pedersen"
>To:
>Sent: Monday, June 23, 2003 8:04 PM
>Subject: 4.0 "production release" corrupts files on install
>
>
>> I have a test machine and a live machine. Fortunately I installed mySQL
>> 4.0.13 on the test machine, because it is corrupting tables on the most
>> basic operations. I start with a blank table, do an insert, and boom I
>> receive "Got error 22 from table handler" then "error: 145" file
>corrupted.
>>
>> This is a WinXP machine, was working fine on mySQL 3.
>> I've managed to create a very simple repro. Is this a known issue?
>>
>> Also, when importing it seems that maybe v3 dumps aren't compatible with
>> v4?? This is not good. I import a whole table without errors, but then
>its
>> empty.
>>
>>
>>
>>
>> --
>> MySQL Bugs Mailing List
>> For list archives: http://lists.mysql.com/bugs
>> To unsubscribe: http://lists.mysql.com/bugs?unsub=pwr@post4.tele.dk
>>
>>
>
>
>--
>MySQL Bugs Mailing List
>For list archives: http://lists.mysql.com/bugs
>To unsubscribe: http://lists.mysql.com/bugs?unsub=paul@mysql.com


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

Are you MySQL certified? http://www.mysql.com/certification/


--
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: 4.0 "production release" corrupts files on install

Adam Pedersen writes:
> That ftp path doesn't seem to exist. But the repro for both problems is
> small enough to put here:
>

[skip]

>
> This fails right out of the box, with a clean database. And if you comment
> out the last insert, it doesn't get the error 22, but it also doesn't insert
> anything into the table. The top is from a dump from mysql 3.
> I haven't looked into the code changes in 4 yet, because I thought dumps
> would be compatible.. either way I think I'll hold off on going to 4 since
> this seems like a pretty major issue for a production release. Unless I'm
> missing something..
>
>
> Just in case, let me add that I'm using 4.0.13 with mysqld-nt and
> my-small.cnf (also tried my-large.cnf)
>
>
>
> Thanks,
> Adam
>

Hi!

I have ran your dump on Linux with 4.0.14 and got the following
results, which are quite OK:


mysql> show tables;
+---------------+
| Tables_in_bug |
+---------------+
| whosonline |
+---------------+
1 row in set (0.00 sec)

mysql> select * from whosonline;
+----------+
| MemberID |
+----------+
| 218 |
| 22588 |
+----------+
2 rows in set (0.00 sec)

I will ask our Windows team to try that on Windows XP.

--

Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinator
<___/ 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=gcdmb-bugs@m.gmane.org