Got It; Thank You; Re: Mysql Bug 04/01/11
Got It; Thank You, Thank You, Thank You On 4/1/2011 11:28 PM, Claudio Nanni wrote: Hi Thomas, Did you run the post install script? http://kae.li/iiikj Claudio On Apr 2, 2011 2:20 AM, Thomas Dineen tdin...@ix.netcom.com mailto:tdin...@ix.netcom.com wrote:
Mysql Bug 04/01/11
Gentlemen: - Keep in mind that I have approximately 50 hours into this Mysql server install and still no results! - Regarding the Sun Freeware package mysql-5.0.67-sol10-x86-local.gz - When installed and started with the following command: /usr/local/mysql/bin/mysqld_safe --user=mysql The following error occurs: 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 1) Please identify where the missing file can be found, keeping in mind that I just installed and have no backup (of the current rev.). 2) If we are installing in /usr/local/mysql where exactly dose this file belong, (exact path please). 3) What exactly do the file ownersiip and permissions have to be? Keep in mind that I have tried several dozen experiments over many late hours with a version host.frm from a older version of mysql with NO success! I have tried putting it in every possible location. Using 777 file permissions. A snapshot of my system: root@Sun# pwd /usr/local/mysql root@Sun# ls bin infoman mysql-test var host.frmlib my.cnf share include libexec mysql sql-bench root@Sun# ls -la host.frm -rwxrwxrwx 1 root root9064 Apr 1 16:39 host.frm root@Sun# ls -la mysql total 22 drwxrwxrwx 2 root root 512 Apr 1 16:34 . drwxr-xr-x 13 bin bin 512 Apr 1 16:39 .. -rwxrwxrwx 1 root root9064 Apr 1 16:34 host.frm - The entire transcript is shown below: 10401 16:39:27 mysqld started 110401 16:39:27 [Warning] option 'max_join_size': unsigned value 18446744073709 551615 adjusted to 4294967295 110401 16:39:27 [Warning] option 'max_join_size': unsigned value 18446744073709 551615 adjusted to 4294967295 110401 16:39:27 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 110401 16:39:27 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 InnoDB: Log scan progressed past the checkpoint lsn 0 36808 110401 16:39:27 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... InnoDB: Doing recovery: scanned up to log sequence number 0 43655 110401 16:39:27 InnoDB: Starting an apply batch of log records to the database ... InnoDB: Progress in percents: 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 5 1 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 110401 16:39:27 InnoDB: Started; log sequence number 0 43655 110401 16:39:27 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './my sql/host.frm' (errno: 13) 110401 16:39:27 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './my sql/host.frm' (errno: 13) 110401 16:39:27 [ERROR] Fatal error: Can't open and lock privilege tables: Can' t find file: './mysql/host.frm' (errno: 13) 110401 16:39:27 mysqld ended 110401 16:42:30 mysqld started 110401 16:42:30 [Warning] option 'max_join_size': unsigned value 18446744073709 551615 adjusted to 4294967295 110401 16:42:30 [Warning] option 'max_join_size': unsigned value 18446744073709 551615 adjusted to 4294967295 110401 16:42:30 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 110401 16:42:30 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 InnoDB: Log scan progressed past the checkpoint lsn 0 36808 110401 16:42:30 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... InnoDB: Doing recovery: scanned up to log sequence number 0 43655 110401 16:42:30 InnoDB: Starting an apply batch of log records to the database ... InnoDB: Progress in percents: 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 5 1 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 110401 16:42:30 InnoDB: Started; log sequence number 0 43655 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './my sql/host.frm' (errno: 13) 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './my sql/host.frm' (errno: 13) 110401 16:42:30 [ERROR] Fatal error: Can't open and lock privilege tables: Can' t find file: './mysql/host.frm' (errno: 13) 110401 16:42:30 mysqld ended root@Sun# -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mysql-5.0.67-sol10-x86-local Bug
Gentle People: Using the following startup command: /etc/init.d/mysql.server start I get the following error: 110331 18:49:41 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 1) Where do I find or how do I create the file host.frm 2) What is the proper location (Full path please) for host.frm 3) It would be easier to debug this if your error messages included the full path! not something like ./ which provides no help in identifing where a file is required. Thomas Dineen 110331 18:40:10 mysqld started 110331 18:40:10 [Warning] option 'max_join_size': unsigned value 184467440737095 51615 adjusted to 4294967295 110331 18:40:10 [Warning] option 'max_join_size': unsigned value 184467440737095 51615 adjusted to 4294967295 InnoDB: Log scan progressed past the checkpoint lsn 0 36808 110331 18:40:10 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... InnoDB: Doing recovery: scanned up to log sequence number 0 43655 110331 18:40:10 InnoDB: Starting an apply batch of log records to the database. .. InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 7 5 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 110331 18:40:11 InnoDB: Started; log sequence number 0 43655 110331 18:40:11 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist 110331 18:40:11 mysqld ended 110331 18:49:41 mysqld started 110331 18:49:41 [Warning] option 'max_join_size': unsigned value 184467440737095 51615 adjusted to 4294967295 110331 18:49:41 [Warning] option 'max_join_size': unsigned value 184467440737095 51615 adjusted to 4294967295 InnoDB: Log scan progressed past the checkpoint lsn 0 36808 110331 18:49:41 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... InnoDB: Doing recovery: scanned up to log sequence number 0 43655 110331 18:49:41 InnoDB: Starting an apply batch of log records to the database. .. InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 7 5 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 110331 18:49:41 InnoDB: Started; log sequence number 0 43655 110331 18:49:41 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mys ql/host.frm' (errno: 13) 110331 18:49:41 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mys ql/host.frm' (errno: 13) 110331 18:49:41 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 110331 18:49:41 mysqld ended 110331 19:06:48 mysqld started 110331 19:06:48 [Warning] option 'max_join_size': unsigned value 184467440737095 51615 adjusted to 4294967295 110331 19:06:48 [Warning] option 'max_join_size': unsigned value 184467440737095 51615 adjusted to 4294967295 InnoDB: Log scan progressed past the checkpoint lsn 0 36808 110331 19:06:48 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... InnoDB: Doing recovery: scanned up to log sequence number 0 43655 110331 19:06:48 InnoDB: Starting an apply batch of log records to the database. .. InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 7 5 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 110331 19:06:48 InnoDB: Started; log sequence number 0 43655 110331 19:06:48 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mys ql/host.frm' (errno: 13) 110331 19:06:48 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: './mys ql/host.frm' (errno: 13) 110331 19:06:48 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 110331 19:06:48 mysqld ended 110331 19:19:10 mysqld started 110331 19:19:10 [Warning] option 'max_join_size': unsigned value 184467440737095 51615 adjusted to 4294967295 110331 19:19:10 [Warning] option 'max_join_size