Can the MySQL AB folks please tell me whether this bug really exists in
3.23.54a? And, if so, can we look forward to 3.23.54b soonish? I am not
ready yet for the 4.x series, as I generally frown upon running such a major
engine for my server in gamma/beta software. But a shiny new 3.23 version
would just do the trick. :)
- Mark
System Administrator Asarian-host.org
---
"If you were supposed to understand it,
we wouldn't call it code." - FedEx
----- Original Message -----
From: "Manuzhai" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, January 11, 2003 12:31 AM
Subject: Re: file permissions problem on ALTER TABLE
> Hmm, okay, but isn't the 3.23 supposed to be stable and thus more bugless
> than a gamma like 4.0.7?
>
> And also, I was wondering when 4 is going to be released as stable.
> Looking over the changelogs, it shouldn't be too long, right?
>
> Zak: thanks for the advice. I got real pissed off about it, since it seems
> like a real bug. :) But I guess it helps pretty good.
>
> Regards,
>
> Dirkjan
>
> ----- Original Message -----
> From: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]>
> To: "Dirkjan Ochtman" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Friday, January 10, 2003 11:45 PM
> Subject: Re: file permissions problem on ALTER TABLE
>
> > Dirkjan,
> >
> > > I am using MySQL 3.23.54 on Windows XP (with SP1). Today, I
> > > encountered a weird problem: when trying to ALTER a TABLE, MySQL said
> > > that it no permissions to rename the *.myi file for that table.
> >
> > Last 3.23 I used was 3.23.49, and I didn't have an ALTER TABLE problem,
> > neither on Win98, Win2K, nor Linux. I did have problems like the ones
> > you describe with 4.0.1, 4.0.3 and 4.0.4 under Win98 and Win2K. Using
> > 4.0.7 now und Win98 and Win2K, the ALTER TABLE problems have gone.
> >
> > Reporting this problem to the list, I heard strange advices like "switch
> > lower_case_table_names to 0". I believe it's a MySQL on Win bug with the
> > 4.0.x versions mentioned above, and it might also affect 3.23 version
> > after 3.23.49.
> >
> > My advice is: Update, MySQL 4.0.7 is real funky :)
> >
> > Regards,
> >
> > --
> >
> > Stefan Hinz <[EMAIL PROTECTED]>
> > Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
> > Heesestr. 6, 12169 Berlin (Germany)
> > Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
> >
> > ----- Original Message -----
> >
> > From: "Dirkjan Ochtman" <[EMAIL PROTECTED]>
> >
> > To: <[EMAIL PROTECTED]>
> >
> > Sent: Friday, January 10, 2003 7:40 PM
> >
> > Subject: Bug: file permissions problem on ALTER TABLE
> >
> > > > Hi there,
> > > >
> > > > I am using MySQL 3.23.54 on Windows XP (with SP1). Today, I
> > > > encountered a weird problem: when trying to ALTER a TABLE, MySQL
> > > > said that it no permissions to rename the *.myi file for that table.
> > > > I kept encountering this problem (trying to go from VARCHAR(6) to
> > > > CHAR(6) for an index field), but it would only work after I
> > > > restarted the mysqld-max-nt. Immediately after restarting the
> > > > server, it worked, but then after a few minutes I tried to ALTER
> > > > another field in the table, and it had the same problem. So I
> > > > restarted the server again, it went through, but the problem
> > > > persisted. I checked the file permissions, but everyone has full
> > > > control to the files.
> > > >
> > > > The table now looks like this:
> > > >
> > > > CREATE TABLE postcodes (
> > > > id mediumint(8) unsigned NOT NULL auto_increment,
> > > > postcode char(6) NOT NULL default '',
> > > > plaats smallint(5) unsigned NOT NULL default '0',
> > > > straat mediumint(8) unsigned NOT NULL default '0',
> > > > low mediumint(5) unsigned NOT NULL default '0',
> > > > high mediumint(5) unsigned NOT NULL default '0',
> > > > parity enum('0','1','2') NOT NULL default '2',
> > > > PRIMARY KEY (id),
> > > > KEY postcode (postcode)
> > > > ) TYPE=MyISAM;
> > > >
> > > > It has 570,441 rows.
> > > >
> > > > Is this a bug in MySQL, or am I doing something wrong? I was using
> > > > phpMyAdmin to do the changes, but I don't think that should make any
> > > > difference.
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
