problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9
Hey folks, My mysql-fu is minimal to the point of nonexistent, so please forgive any vagaries that come across: I've recently compiled 4.1.3 to replace 4.1.0 on a machine here where I work. The compile and install went fine (as far as I can tell, anyway), but when I try to start mysqld via the init script it dies almost immediately and I get the following lines in my .err file: 040709 13:41:04 mysqld started 040709 13:41:04 InnoDB: Started; log sequence number 0 43912 040709 13:41:04 Fatal error: Can't open privilege tables: Can't find file: 'host.MYI' (errno: 2) 040709 13:41:04 mysqld ended Indeed, I have no host.MYI -- I thought perhaps it might be a directory permissions error or something, but it's not. 4.1.0 trundled happily along without a host.MYI file in my db's mysql directory. Furthermore, none of our other machines with MySQL (running various 3.23 and 4.0) have them either. Thanks for any help you can provide, jf. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9
What is the location of your data/mysql directory? -Original Message- From: John Fink To: [EMAIL PROTECTED] Sent: 7/9/04 3:49 PM Subject: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9 Hey folks, My mysql-fu is minimal to the point of nonexistent, so please forgive any vagaries that come across: I've recently compiled 4.1.3 to replace 4.1.0 on a machine here where I work. The compile and install went fine (as far as I can tell, anyway), but when I try to start mysqld via the init script it dies almost immediately and I get the following lines in my .err file: 040709 13:41:04 mysqld started 040709 13:41:04 InnoDB: Started; log sequence number 0 43912 040709 13:41:04 Fatal error: Can't open privilege tables: Can't find file: 'host.MYI' (errno: 2) 040709 13:41:04 mysqld ended Indeed, I have no host.MYI -- I thought perhaps it might be a directory permissions error or something, but it's not. 4.1.0 trundled happily along without a host.MYI file in my db's mysql directory. Furthermore, none of our other machines with MySQL (running various 3.23 and 4.0) have them either. Thanks for any help you can provide, jf. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9
On Fri, 9 Jul 2004, Victor Pendleton wrote: What is the location of your data/mysql directory? It's actually in /database/var. There's a symlink in /opt/mysql that points it over. Could a symlink be the problem? jf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9
Is the symlink still valid? Can you point the data directory variable to this location and see if the MySQL server starts up? -Original Message- From: [EMAIL PROTECTED] To: Victor Pendleton Cc: 'John Fink '; '[EMAIL PROTECTED] ' Sent: 7/9/04 4:08 PM Subject: RE: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9 On Fri, 9 Jul 2004, Victor Pendleton wrote: What is the location of your data/mysql directory? It's actually in /database/var. There's a symlink in /opt/mysql that points it over. Could a symlink be the problem? jf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9
Okay, I changed the datadir to /database/var, same error. The symlink is definitely valid: when doing cd and ls and such I always use the symlink. jf On Fri, 9 Jul 2004, Victor Pendleton wrote: Is the symlink still valid? Can you point the data directory variable to this location and see if the MySQL server starts up? -Original Message- From: [EMAIL PROTECTED] To: Victor Pendleton Cc: 'John Fink '; '[EMAIL PROTECTED] ' Sent: 7/9/04 4:08 PM Subject: RE: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9 On Fri, 9 Jul 2004, Victor Pendleton wrote: What is the location of your data/mysql directory? It's actually in /database/var. There's a symlink in /opt/mysql that points it over. Could a symlink be the problem? jf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9
When you ls to /database/var do you see the mysql/ directory? -Original Message- From: [EMAIL PROTECTED] To: Victor Pendleton Cc: '[EMAIL PROTECTED] '; ''[EMAIL PROTECTED] ' ' Sent: 7/9/04 4:15 PM Subject: RE: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9 Okay, I changed the datadir to /database/var, same error. The symlink is definitely valid: when doing cd and ls and such I always use the symlink. jf On Fri, 9 Jul 2004, Victor Pendleton wrote: Is the symlink still valid? Can you point the data directory variable to this location and see if the MySQL server starts up? -Original Message- From: [EMAIL PROTECTED] To: Victor Pendleton Cc: 'John Fink '; '[EMAIL PROTECTED] ' Sent: 7/9/04 4:08 PM Subject: RE: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9 On Fri, 9 Jul 2004, Victor Pendleton wrote: What is the location of your data/mysql directory? It's actually in /database/var. There's a symlink in /opt/mysql that points it over. Could a symlink be the problem? jf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9
Yup. It's definitely there and definitely being accessed when I start up mysql -- for fun, I tried removing it (temporarily, natch) and starting mysql and got different errors. jf On Fri, 9 Jul 2004, Victor Pendleton wrote: When you ls to /database/var do you see the mysql/ directory? -Original Message- From: [EMAIL PROTECTED] To: Victor Pendleton Cc: '[EMAIL PROTECTED] '; ''[EMAIL PROTECTED] ' ' Sent: 7/9/04 4:15 PM Subject: RE: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9 Okay, I changed the datadir to /database/var, same error. The symlink is definitely valid: when doing cd and ls and such I always use the symlink. jf On Fri, 9 Jul 2004, Victor Pendleton wrote: Is the symlink still valid? Can you point the data directory variable to this location and see if the MySQL server starts up? -Original Message- From: [EMAIL PROTECTED] To: Victor Pendleton Cc: 'John Fink '; '[EMAIL PROTECTED] ' Sent: 7/9/04 4:08 PM Subject: RE: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9 On Fri, 9 Jul 2004, Victor Pendleton wrote: What is the location of your data/mysql directory? It's actually in /database/var. There's a symlink in /opt/mysql that points it over. Could a symlink be the problem? jf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9
Yup. It's all there, everything's fine on directory structure. I can start 4.1.0 back up without changing anything else and it starts up okay. Very perplexing. jf On Fri, 9 Jul 2004, Victor Pendleton wrote: When you ls to /database/var do you see the mysql/ directory? -Original Message- From: [EMAIL PROTECTED] To: Victor Pendleton Cc: '[EMAIL PROTECTED] '; ''[EMAIL PROTECTED] ' ' Sent: 7/9/04 4:15 PM Subject: RE: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9 Okay, I changed the datadir to /database/var, same error. The symlink is definitely valid: when doing cd and ls and such I always use the symlink. jf On Fri, 9 Jul 2004, Victor Pendleton wrote: Is the symlink still valid? Can you point the data directory variable to this location and see if the MySQL server starts up? -Original Message- From: [EMAIL PROTECTED] To: Victor Pendleton Cc: 'John Fink '; '[EMAIL PROTECTED] ' Sent: 7/9/04 4:08 PM Subject: RE: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9 On Fri, 9 Jul 2004, Victor Pendleton wrote: What is the location of your data/mysql directory? It's actually in /database/var. There's a symlink in /opt/mysql that points it over. Could a symlink be the problem? jf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9
Do you have a hosts.MYD, or a hosts.frm file? If you do, and there is no .MYI file, perhaps the older version is just ignoring the table and not making it available while the newer version errors out. If those files exist, try removing them from the data directory (move them somewhere else) then starting the new version. Hope that helps, swany --- John Fink [EMAIL PROTECTED] wrote: Hey folks, My mysql-fu is minimal to the point of nonexistent, so please forgive any vagaries that come across: I've recently compiled 4.1.3 to replace 4.1.0 on a machine here where I work. The compile and install went fine (as far as I can tell, anyway), but when I try to start mysqld via the init script it dies almost immediately and I get the following lines in my .err file: 040709 13:41:04 mysqld started 040709 13:41:04 InnoDB: Started; log sequence number 0 43912 040709 13:41:04 Fatal error: Can't open privilege tables: Can't find file: 'host.MYI' (errno: 2) 040709 13:41:04 mysqld ended Indeed, I have no host.MYI -- I thought perhaps it might be a directory permissions error or something, but it's not. 4.1.0 trundled happily along without a host.MYI file in my db's mysql directory. Furthermore, none of our other machines with MySQL (running various 3.23 and 4.0) have them either. Thanks for any help you can provide, jf. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9
Swany, I do indeed have a host.frm file, and the timestamp is from 2000. Unfortunately, I've had to start up 4.1.0 again and leave it up as folks here have to work on the db. Since they won't be working tomorrow, I'll try to remove the host.frm (also perhaps the host.ISD and host.ISM?) file tomorrow and let you know if it works out. Somehow I think it will; your suggestion feels correct to me. Thanks much. jf On Fri, 9 Jul 2004, Justin Swanhart wrote: Do you have a hosts.MYD, or a hosts.frm file? If you do, and there is no .MYI file, perhaps the older version is just ignoring the table and not making it available while the newer version errors out. If those files exist, try removing them from the data directory (move them somewhere else) then starting the new version. Hope that helps, swany --- John Fink [EMAIL PROTECTED] wrote: Hey folks, My mysql-fu is minimal to the point of nonexistent, so please forgive any vagaries that come across: I've recently compiled 4.1.3 to replace 4.1.0 on a machine here where I work. The compile and install went fine (as far as I can tell, anyway), but when I try to start mysqld via the init script it dies almost immediately and I get the following lines in my .err file: 040709 13:41:04 mysqld started 040709 13:41:04 InnoDB: Started; log sequence number 0 43912 040709 13:41:04 Fatal error: Can't open privilege tables: Can't find file: 'host.MYI' (errno: 2) 040709 13:41:04 mysqld ended Indeed, I have no host.MYI -- I thought perhaps it might be a directory permissions error or something, but it's not. 4.1.0 trundled happily along without a host.MYI file in my db's mysql directory. Furthermore, none of our other machines with MySQL (running various 3.23 and 4.0) have them either. Thanks for any help you can provide, jf. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]