Upgrade - 5.0.3 to latest

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Upgrade - 5.0.3 to latest

Munish Joshi
Hello,

I am trying to upgrade my bugzilla version from 5.0.3 to latest but while
running checksetup.pl, i am getting following error -

"Removing existing compiled templates...
Precompiling templates...done.
Fixing file permissions...
Not a reference at Bugzilla/DB/Schema.pm line 2916."

Please advise.

-thanks
_______________________________________________
support-bugzilla mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [hidden email] in the To: field when you reply.
Reply | Threaded
Open this post in threaded view
|

Re: Upgrade - 5.0.3 to latest

Munish Joshi
Error - Fixing file permissions...
Not a reference at Bugzilla/DB/Schema.pm line 2916.

and below is my Schema.pm snippet for lines 2916 - and i am running 5.0.3 version.


   2902 =item C<columns_equal($col_one, $col_two)>
   2903
   2904  Description: Tells you if two columns have entirely identical definitions.
   2905               The TYPE field's value will be compared case-insensitive.
   2906               However, all other fields will be case-sensitive.
   2907  Params:      $col_one, $col_two - The columns to compare. Hash
   2908                   references, in C<ABSTRACT_SCHEMA> format.
   2909  Returns:     C<1> if the columns are identical, C<0> if they are not.
   2910
   2911 =back
   2912
   2913 =cut
   2914
   2915     my $self = shift;
   2916     my $col_one = dclone(shift);
   2917     my $col_two = dclone(shift);
   2918
   2919     $col_one->{TYPE} = uc($col_one->{TYPE});
   2920     $col_two->{TYPE} = uc($col_two->{TYPE});
   2921
   2922     # We don't care about foreign keys when comparing column definitions.
   2923     delete $col_one->{REFERENCES};
   2924     delete $col_two->{REFERENCES};
   2925
   2926     my @col_one_array = %$col_one;
   2927     my @col_two_array = %$col_two;
   2928
   2929     my ($removed, $added) = diff_arrays(\@col_one_array, \@col_two_array);
   2930
   2931     # If there are no differences between the arrays, then they are equal.
   2932     return !scalar(@$removed) && !scalar(@$added) ? 1 : 0;
   2933 }
   2934
   2935
   2936 =head1 SERIALIZATION/DESERIALIZATION
   2937
   2938 =over 4
_______________________________________________
support-bugzilla mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [hidden email] in the To: field when you reply.
Reply | Threaded
Open this post in threaded view
|

Re: Upgrade - 5.0.3 to latest

Munish Joshi
Thanks - I followed the upgrade guide and uses Git to pull new stable version 5.0.6.

After executing # git pull  on correct directory.

Checksetup script showing this version
#./checksetup.pl --version
* This is Bugzilla 5.0.6 on perl 5.10.1
* Running on Linux 2.6.32-696.3.1.el6.x86_64 #1 SMP Tue May 30 19:52:55 UTC 2017

But if i tried to run #checksetup.pl now -

Following error is coming -

Bugzilla now uses the InnoDB storage engine in MySQL for most tables.
Converting tables to InnoDB:
Converting table bugs_fulltext... DBD::mysql::db do failed: The used table type doesn't support FULLTEXT indexes [for Statement "ALTER TABLE bugs_fulltext ENGINE = InnoDB"] at Bugzilla/DB/Mysql.pm line 391
        Bugzilla::DB::Mysql::bz_setup_database('Bugzilla::DB::Mysql=HASH(0x56df8e8)') called at ./checksetup.pl line 123

I'm using MySql version - Server version: 5.1.73.

-Thanks.
 
_______________________________________________
support-bugzilla mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [hidden email] in the To: field when you reply.
Reply | Threaded
Open this post in threaded view
|

Re: Upgrade - 5.0.3 to latest

Munish Joshi
I think this may be due to - Table -  bugs_fulltext       using -  MyISAM Engine where as other all tables are using InnoDB.

If this is correct, than do you have any way to change the table type ?

If i tried to change using "Alter table"

it given me error =  mysql> alter table bugs.bugs_fulltext engine=innodb;
ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes
mysql>

Is this related to MySQL version 5.1.73 not supported ?
_______________________________________________
support-bugzilla mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [hidden email] in the To: field when you reply.
Reply | Threaded
Open this post in threaded view
|

Re: Upgrade - 5.0.3 to latest

Munish Joshi
Upgrade MySQL to 5.6.16 and re-run

# .\checksetup.pl

Script automatically converted MyISAM table into InnoDB.

But now, following error showing when i am running .\Checksetup.pl

Removing existing compiled templates...
Precompiling templates...done.
Fixing file permissions...
Not a reference at Bugzilla/DB/Schema.pm line 2889.


Below is the snippet of 2889 code lines -

 2877  Description: Tells you if two columns have entirely identical definitions.
   2878               The TYPE field's value will be compared case-insensitive.
   2879               However, all other fields will be case-sensitive.
   2880  Params:      $col_one, $col_two - The columns to compare. Hash
   2881                   references, in C<ABSTRACT_SCHEMA> format.
   2882  Returns:     C<1> if the columns are identical, C<0> if they are not.
   2883
   2884 =back
   2885
   2886 =cut
   2887
   2888   my $self    = shift;
   2889   my $col_one = dclone(shift);
   2890   my $col_two = dclone(shift);
   2891
   2892   $col_one->{TYPE} = uc($col_one->{TYPE});
   2893   $col_two->{TYPE} = uc($col_two->{TYPE});


Let me know if this is OK - Or need further troubleshooting.

-Thanks
_______________________________________________
support-bugzilla mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [hidden email] in the To: field when you reply.
Reply | Threaded
Open this post in threaded view
|

Re: Upgrade - 5.0.3 to latest

Munish Joshi
Is there way to force Bz_schema to recreate with new database/tables information ?

Seems like going over each tables, their field values and types and compare with BZ_schema is almost impossible.

Please suggest some alternative.
_______________________________________________
support-bugzilla mailing list
[hidden email]
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put [hidden email] in the To: field when you reply.