Problem creating database with rt3rc4

RT Developers
1

Hi Folks!

Just to let you know, I’m encountering an error trying to create the db
using mysql:innodb tables. I get the following error:

Creating database schema.
DBD::mysql::st execute failed: Can’t create table
’./rt3/#sql-6dc2_84.frm’ (errn
o: 135) at //opt/rt3/sbin/rt-setup-database line 139, line 416.
Problem with statement:

CREATE INDEX ACL1 on ACL(RightName, ObjectType,
ObjectId,PrincipalType,Principa
lId)
Can’t create table ‘./rt3/#sql-6dc2_84.frm’ (errno: 135) at
//opt/rt3/sbin/rt-se
tup-database line 140, line 416.
make: *** [initialize-database] Error 255

If I turn off InnoDB support in my.cnf using skip-innodb, and make
initialize-database again, it successfully creates the tables using
MyISAM. I can then turn on InnoDB support again, and convert the
tables.

OS: Debian 3.0 on Sparc64
Mysql 3.23.49 Debian package
Perl 5.6.1 Debian Package.
Rt-test-deps shows everything there.

Hope this helps!

/Mike

2

Sounds like you have innodb configured improperly.

pallas:% /usr/local/mysql/bin/perror 135 ~ 10:19AM:ttypts/10
Error code 135: Unknown error 135
135 = No more room in record fileOn Fri, Mar 21, 2003 at 09:48:04AM -0500, Michael K. Brown wrote:

Hi Folks!

Just to let you know, I’m encountering an error trying to create the db
using mysql:innodb tables. I get the following error:

Creating database schema.
DBD::mysql::st execute failed: Can’t create table
‘./rt3/#sql-6dc2_84.frm’ (errn
o: 135) at //opt/rt3/sbin/rt-setup-database line 139, line 416.
Problem with statement:

CREATE INDEX ACL1 on ACL(RightName, ObjectType,
ObjectId,PrincipalType,Principa
lId)
Can’t create table ‘./rt3/#sql-6dc2_84.frm’ (errno: 135) at
//opt/rt3/sbin/rt-se
tup-database line 140, line 416.
make: *** [initialize-database] Error 255

If I turn off InnoDB support in my.cnf using skip-innodb, and make
initialize-database again, it successfully creates the tables using
MyISAM. I can then turn on InnoDB support again, and convert the
tables.

OS: Debian 3.0 on Sparc64
Mysql 3.23.49 Debian package
Perl 5.6.1 Debian Package.
Rt-test-deps shows everything there.

Hope this helps!

/Mike

rt-devel mailing list
rt-devel@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

3

Hi Jesse!

Here’s the Innodb config in my.cnf. Could you point out any problems,
and maybe suggest a “typical” config for the list, since many folks may
be running MyISAM tables on RT2, and this may come up in the upgrade
process for others.

MySQL 3.23.49 - doesn’t support :autoextend in innodb_data_file_path.
That starts in 3.23.50

Uncomment the following if you are using Innobase tables

innodb_data_file_path = ibdata1:10M
innodb_data_home_dir = /var/lib/mysql
innodb_log_group_home_dir = /var/lib/mysql
innodb_log_arch_dir = /var/lib/mysql
set-variable = innodb_mirrored_log_groups=1
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=64M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=80M
set-variable = innodb_additional_mem_pool_size=20M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50

Thanks for your time!
/Mike-----Original Message-----
From: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Friday, March 21, 2003 10:20 AM
To: Michael K. Brown
Cc: ‘Rt-Devel’
Subject: Re: [rt-devel] Problem creating database with rt3rc4

Sounds like you have innodb configured improperly.

pallas:% /usr/local/mysql/bin/perror 135 ~
10:19AM:ttypts/10
Error code 135: Unknown error 135
135 = No more room in record file

4

Hi Jesse!

Here’s the Innodb config in my.cnf. Could you point out any problems,
and maybe suggest a “typical” config for the list, since many folks may
be running MyISAM tables on RT2, and this may come up in the upgrade
process for others.

No, but I can recommend the documentation at www.mysql.com

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

5

For the benefit of the archives:

innodb_data_file_path needs to be fairly large in order to create the
rt3 database. I set mine up to 500M, and it was able to create the db.
It wasn’t really a discovered thing… I jumped it up from 10M to 100M
to 500M, so I won’t be troubled by it in the future. Your results may
vary…

Hope that helps somebody…

/Mike-----Original Message-----
From: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: Friday, March 21, 2003 11:21 AM
To: Michael K. Brown
Cc: ‘Rt-Devel’
Subject: Re: [rt-devel] Problem creating database with rt3rc4

On Fri, Mar 21, 2003 at 11:14:08AM -0500, Michael K. Brown wrote:

Hi Jesse!

Here’s the Innodb config in my.cnf. Could you point out any problems,

and maybe suggest a “typical” config for the list, since many folks
may be running MyISAM tables on RT2, and this may come up in the
upgrade process for others.

No, but I can recommend the documentation at www.mysql.com

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.