Bug #4349 Error 1067
Submitted: 30 Jun 2004 18:58 Modified: 30 Jun 2004 19:12
Reporter: Renato Gontijo Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S1 (Critical)
Version:4.0.20d OS:Windows (windows xp)
Assigned to: CPU Architecture:Any

[30 Jun 2004 18:58] Renato Gontijo
Description:
When I start service on windows xp it generate the following error:
Error 1067 - Process finished of unexpected form.

I put the file my.ini on c:\windows\ folder

####################### my.ini ########################
# This will be passed to all mysql clients
[client]
#password=my_password
port=3306
#socket=MySQL

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# The MySQL server
[mysqld]
port=3306
#socket=MySQL
skip-locking
set-variable	= key_buffer=16K
set-variable    = lower_case_table_names=0
set-variable	= max_allowed_packet=16M
set-variable	= net_buffer_length=2K
set-variable	= sort_buffer=64K
set-variable	= table_cache=4
set-variable	= thread_stack=64K
server-id	= 1

# Uncomment the following if you want to log updates
#log-bin

# Uncomment the following rows if you move the MySQL distribution to another
# location
#basedir = e:\mysql\
datadir = e:\mysql\data\

# Uncomment the following if you are NOT using BDB tables
#skip-bdb

# Uncomment the following if you are using Innobase tables
innodb_data_home_dir = e:\mysql\ibdata\
innodb_data_file_path = ibdata1:256M:autoextend
innodb_flush_log_at_trx_commit = 1
innodb_log_group_home_dir = e:\mysql\iblogs\
innodb_log_arch_dir = e:\mysql\iblogs\
innodb_log_archive = 0
set-variable = innodb_additional_mem_pool_size=50M
set-variable = innodb_buffer_pool_size=16M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
set-variable = innodb_log_files_in_group=2
set-variable = innodb_log_file_size=16M
set-variable = innodb_log_buffer_size=8M
set-variable = innodb_mirrored_log_groups=1

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
set-variable	= key_buffer=8M
set-variable	= sort_buffer=8M

[myisamchk]
set-variable	= key_buffer=8M
set-variable	= sort_buffer=8M

[mysqlhotcopy]
interactive-timeout
#####################################################

To start mysql I write the command (at first time)
mysqld --console --standalone

I created the ibdata and iblogs folders. The files of innodb was generated successfully. When I restart the windows xp the service don't start and when I try to start it is generated the error 1067.

How to repeat:
1. write the my.ini like above and put on %windir% folder
2. create ibdata and iblogs folders
3. write command mysqld --console --standalone
4. restart computer

the service don't start.
[30 Jun 2004 19:12] MySQL Verification Team
That error means something wrong you have in your my.ini,
I guess you have commented the basedir key.
If the above no works, try to start the servers as standalone:

mysqld-nt --standalone --console

amd verify the error output.

thanks