| View previous topic :: View next topic |
| Author |
Message |
madchaz
l33t
Joined: 01 Jul 2003
Posts: 995
Location: Quebec, Canada
|
 Posted: Thu Mar 02, 2006 7:07 pm Post subject: mysql_install_db script frezes |
 |
|
This tread is a continuity of this tread
https://forums.gentoo.org/viewtopic-t-439282.html
I am making a new tread as the issue I am facing now is different then the one in the original tread.
The issue I am facing now is creating the original database. When I run mysql_install_db, it appears to go into an infinite loop. I get the following, then nothing.
| Code: | [mydev@cnedbsrv01 bin]$ ./mysql_install_db
Installing all prepared tables
060302 14:56:52 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
060302 14:56:52 [Note] /u02/mysql/dev/libexec/mysqld: ready for connections.
Version: '5.0.18' socket: '--bootstrap' port: 3306 Source distribution
|
It'll hang there untill I kill it. I've been looking over the mysql doc, but the only issues remotely similar are for version 4, not 5. The only thing I found that "might" have relevence was net_buffer_length being set at 8K that would need to be switched to 16K, but that changed nothing.
When I look in the data folder, there is no file being created, but the folders to hold the files do get created.
_________________
Someone asked me once if I suffered from mental illness. I told him I enjoyed every second of it. |
|
| Back to top |
|
 |
madchaz
l33t
Joined: 01 Jul 2003
Posts: 995
Location: Quebec, Canada
|
| Posted: Fri Mar 03, 2006 2:14 pm Post subject: |
|
|
I left the script to run overnight, just it case it was busy doing something. When I came in this morning, it was still stuck in the same place. No files got created in the data folder.
I was able to trace the issue to this line in the code.
| Code: | /u02/mysql/dev/libexec/mysqld --bootstrap --skip-grant-tables --basedir=/u02/mysql/dev --datadir=/u03/mysql/dev --skip-innodb --skip-bdb --skip-ndbcluster --max_allowed_packet=8M --net_buffer_length=16K
|
So the issue appears to be with starting the mysql deamon. It never returns.
_________________
Someone asked me once if I suffered from mental illness. I told him I enjoyed every second of it. |
|
| Back to top |
|
|
madchaz
l33t
Joined: 01 Jul 2003
Posts: 995
Location: Quebec, Canada
|
| Posted: Fri Mar 03, 2006 2:26 pm Post subject: |
|
|
I left the script to run overnight, just it case it was busy doing something. When I came in this morning, it was still stuck in the same place. No files got created in the data folder.
I was able to trace the issue to this line in the code.
| Code: | /u02/mysql/dev/libexec/mysqld --bootstrap --skip-grant-tables --basedir=/u02/mysql/dev --datadir=/u03/mysql/dev --skip-innodb --skip-bdb --skip-ndbcluster --max_allowed_packet=8M --net_buffer_length=16K
|
So the issue appears to be with starting the mysql deamon. It never returns. It looks like mysqld does not deamonise (detatch) at all. If I run the command at the comand line, I get the exact same error as when trying to run the script.
_________________
Someone asked me once if I suffered from mental illness. I told him I enjoyed every second of it. |
|
| Back to top |
|
|
madchaz
l33t
Joined: 01 Jul 2003
Posts: 995
Location: Quebec, Canada
|
| Posted: Fri Mar 03, 2006 6:14 pm Post subject: |
|
|
Got a litle bit further by adding a & at the end of the command line that launches mysqld in the innitialisation script, but it looks like it's not doing its job properly.
mysqld fails to start and the .err file contains the following errors.
| Code: | 060303 14:24:56 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
060303 14:24:56 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
060303 14:24:57 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
060303 14:24:57 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
060303 14:24:57 InnoDB: Started; log sequence number 0 0
060303 14:24:57 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
060303 14:24:57 mysqld ended
|
_________________
Someone asked me once if I suffered from mental illness. I told him I enjoyed every second of it. |
|
| Back to top |
|
|
madchaz
l33t
Joined: 01 Jul 2003
Posts: 995
Location: Quebec, Canada
|
| Posted: Fri Mar 03, 2006 8:26 pm Post subject: |
|
|
It looks like the .sql script is empty. It says it's there as a place holder and that the bootstrap script will replace it. This obviously isn't appening.
Anyone as an idea why?
_________________
Someone asked me once if I suffered from mental illness. I told him I enjoyed every second of it. |
|
| Back to top |
|
|
|
Networking & Security
