Rt2 to rt3

RT Developers
1

I am curretnlt import data into rt 3 (3.0.6) and have the follwing
message is the logs:
RT: Use of uninitialized value in numeric ne (!=) at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 669.
(/opt/rt3/lib/RT.pm:247)

This seems to be repeated on every entry made into the database.
Is it safe to procceed with the import?

My setup:
Redhat 9
mysql 3.23.58-1.9
Apache2 (2.0.40-21.5)
mod_perl2 (1.99_07-5)
DBIx::SearchBuilder 0.92
HTML::Mason m1.23

2

I have a newbie question. Can I run the rt-2.0-to-dumpfile while rt2 is
running on my production machine ?

Thanks

Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There’s no place like 127.0.0.1

3

At Sat, 28 Jun 2003 00:40:56 -0400 (EDT),
Asif Iqbal wrote:

I have a newbie question. Can I run the rt-2.0-to-dumpfile while rt2 is
running on my production machine ?

Have you tried it before asking the question?

Yes, but I wouldn’t use that dumpfile except to test, because it can
potentially be inconsistent if something in the database changes while
you’re running it.

Also, please learn how to properly use your email client and do not
“just reply” to any post on a mailing list to post. Please start a
new email with the “new message” or “compose” button and type in the
email address. If you don’t, it screws up threading, and will make
many of us just ignore all of your emails.

-R

4

At Sat, 28 Jun 2003 00:40:56 -0400 (EDT),
Asif Iqbal wrote:

I have a newbie question. Can I run the rt-2.0-to-dumpfile while rt2 is
running on my production machine ?

Have you tried it before asking the question?

Yes

Yes, but I wouldn’t use that dumpfile except to test, because it can
potentially be inconsistent if something in the database changes while
you’re running it.

I am planning to stop sendmail and web gui and then rerun the
“rt-2.0-to-dumpfile since date” after the priliminary dump process
finishes. This should cover any changes, made during the priliminary dump,
in the database. In that a correct assumption ?

Thanks

Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There’s no place like 127.0.0.1

5

Yes, but I wouldn’t use that dumpfile except to test, because it can
potentially be inconsistent if something in the database changes while
you’re running it.

I am planning to stop sendmail and web gui and then rerun the
“rt-2.0-to-dumpfile since date” after the priliminary dump process
finishes. This should cover any changes, made during the priliminary dump,
in the database. In that a correct assumption ?

What happens if a record is deleted? I would use my first dump as a test,
then when I knew it all worked ok, zero the database, take a final full dump
are repeat my known and tested procedure.

6

Yes, but I wouldn’t use that dumpfile except to test, because it can
potentially be inconsistent if something in the database changes while
you’re running it.

I am planning to stop sendmail and web gui and then rerun the
“rt-2.0-to-dumpfile since date” after the priliminary dump process
finishes. This should cover any changes, made during the priliminary dump,
in the database. In that a correct assumption ?

What happens if a record is deleted? I would use my first dump as a test,
then when I knew it all worked ok, zero the database, take a final full dump
are repeat my known and tested procedure.

The Tickets status will be changed only to dead. But the record won’t get
removed since I am the only one who has root access to the database to
delete an entry. So I guess in my case it should be ok

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

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There’s no place like 127.0.0.1

7

I am currenty importinf data into rt 3 (3.0.6) and have the following
message in the logs:
RT: Use of uninitialized value in numeric ne (!=) at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 669.
(/opt/rt3/lib/RT.pm:247)

This seems to be repeated on every entry made into the database.
Is it safe to procceed with the import?

My setup:
Redhat 9
mysql 3.23.58-1.9
Apache2 (2.0.40-21.5)
mod_perl2 (1.99_09-10custom)
DBIx::SearchBuilder 0.92
HTML::Mason 1.23

8

mixo wrote:

I am currenty importinf data into rt 3 (3.0.6) and have the following
message in the logs:
+++++++++++++++++
RT: Use of uninitialized value in numeric ne (!=) at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 669.
(/opt/rt3/lib/RT.pm:247)
+++++++++++++++++
search in srchive there is something about this.

This seems to be repeated on every entry made into the database.
Is it safe to procceed with the import?

My setup:
Redhat 9
mysql 3.23.58-1.9
You have to upgrade mysql to 4.0.x
In other case you’ll come soon with perfomance problems