The error below was fixed by a REPAIR TABLE bugs_fulltext; statement. Has been corrupted on last reboot perhaps.
Well reinstalling 3.6 and upgrading would fix those issues, you're right. But that is somehow just a workaround. I want to use 4 and I think the updated status_names are better than before. Are there plans to release an official scmbug RELEASE für bugzilla 4.0 support? Do you know when this will be? Mit freundlichen Grüßen / Kind regards Michel Pittelkow Via Outlook Webaccess ________________________________ Von: Yavor Nikolov [[email protected]] Gesendet: Dienstag, 8. März 2011 11:22 Bis: Michel Pittelkow - michael-wessel.de Cc: [email protected] Betreff: Re: Re: [scmbug-users] SCMBug Commit: Error 7 How does your daemon.conf look like? You should say you're using bugzilla version 4.0.0 there. BTW. I suppose relatively easy way to get a Bugzilla with old states workflow would be installing 3.6 and then upgrade it to 4.0. (I'm not sure what exactly would get broken in Scmbug if status names are different. Actually that's not so new issue since Bugzilla supported custom states with earlier versions). Yavor On Tue, Mar 8, 2011 at 12:21, Michel Pittelkow - michael-wessel.de<http://michael-wessel.de> <[email protected]<mailto:[email protected]>> wrote: Here are the log entries for the commit: 2011/03/08 11:09:22 Scmbug WARN> Bugzilla.pm:699:Scmbug::Daemon::Bugzilla::integration_add_comment - DBD::mysql::db do failed: Incorrect key file for table './bugs/bugs_fulltext.MYI'; try to repair it [for Statement "UPDATE bugs_fulltext SET comments = ?, comments_noprivate = ? WHERE bug_id = ?"] at /var/www/bugzilla/Bugzilla/Bug.pm line 1056 Bugzilla::Bug::_sync_fulltext('Bugzilla::Bug=HASH(0x1408a030)') called at /var/www/bugzilla/Bugzilla/Bug.pm line 1003 Bugzilla::Bug::update('Bugzilla::Bug=HASH(0x1408a030)') called at /usr/share/scmbug/lib/Scmbug/Daemon/Bugzilla.pm line 692 eval {...} called at /usr/share/scmbug/lib/Scmbug/Daemon/Bugzilla.pm line 686 Scmbug::Daemon::Bugzilla::integration_add_comment('Scmbug::Daemon::Bugzilla=HASH(0x11ca8d70)', 1, '[email protected]<mailto:[email protected]>', 'Test mit So und so\x{a}\x{a}\x{a}Branch: Cannot_be_determined\x{a}Affe...') called at /usr/share/scmbug/lib/Scmbug/Daemon/Integration.pm line 468 Scmbug::Daemon::Integration::add_comment_to_all('Scmbug::Daemon::Integration=HASH(0x13d182d0)', '[email protected]<mailto:[email protected]>', 'Test mit So und so\x{a}\x{a}\x{a}Branch: Cannot_be_determined\x{a}Affe...', 'ARRAY(0x13d181e0)') called at /usr/share/scmbug/lib/Scmbug/Daemon/Integration.pm line 89 Scmbug::Daemon::Integration::process_activity_commit('Scmbug::Daemon::Integration=HASH(0x13d182d0)') called at /usr/share/scmbug/lib/Scmbug/Daemon/Process.pm line 869 Scmbug::Daemon::Process::process_activity_commit('Scmbug::Daemon::Process=HASH(0x13d0f300)', 'Scmbug::Daemon::Request=HASH(0x13cc5870)') called at /usr/share/scmbug/lib/Scmbug/Daemon/Process.pm line 786 Scmbug::Daemon::Process::process_activity('Scmbug::Daemon::Process=HASH(0x13d0f300)', 'Scmbug::Daemon::Request=HASH(0x13cc5870)') called at /usr/share/scmbug/lib/Scmbug/Daemon/Process.pm line 152 Scmbug::Daemon::Process::process_connection('Scmbug::Daemon::Process=HASH(0x13d0f300)', '*main::STDIN', '*main::STDOUT', 'Scmbug::Daemon::Request=HASH(0x13cc5870)') called at /usr/share/scmbug/lib/Scmbug/Daemon/Daemon.pm line 579 Scmbug::Daemon::Daemon::spawn_child('Scmbug::Daemon::Daemon=HASH(0x111e23f0)', 'localhost.localdomain', 127.0.0.1, 47023) called at /usr/share/scmbug/lib/Scmbug/Daemon/Daemon.pm line 493 Scmbug::Daemon::Daemon::start_daemon_forked('Scmbug::Daemon::Daemon=HASH(0x111e23f0)') called at /usr/share/scmbug/lib/Scmbug/Daemon/Daemon.pm line 410 Scmbug::Daemon::Daemon::start_daemon('Scmbug::Daemon::Daemon=HASH(0x111e23f0)', '/etc/scmbug/daemon.conf') called at /usr/sbin/scmbug_daemon.pl<http://scmbug_daemon.pl> line 39 main::main('/etc/scmbug/daemon.conf') called at /usr/sbin/scmbug_daemon.pl<http://scmbug_daemon.pl> line 28 2011/03/08 11:09:22 Scmbug WARN> Process.pm:813:Scmbug::Daemon::Process::process_activity - 127.0.0.1:47023<http://127.0.0.1:47023> Error while adding bug comment: DBD::mysql::db do failed: Incorrect key file for table './bugs/bugs_fulltext.MYI'; try to repair it [for Statement "UPDATE bugs_fulltext SET comments = ?, comments_noprivate = ? WHERE bug_id = ?"] at /var/www/bugzilla/Bugzilla/Bug.pm line 1056 Bugzilla::Bug::_sync_fulltext('Bugzilla::Bug=HASH(0x1408a030)') called at /var/www/bugzilla/Bugzilla/Bug.pm line 1003 Bugzilla::Bug::update('Bugzilla::Bug=HASH(0x1408a030)') called at /usr/share/scmbug/lib/Scmbug/Daemon/Bugzilla.pm line 692 eval {...} called at /usr/share/scmbug/lib/Scmbug/Daemon/Bugzilla.pm line 686 Scmbug::Daemon::Bugzilla::integration_add_comment('Scmbug::Daemon::Bugzilla=HASH(0x11ca8d70)', 1, '[email protected]<mailto:[email protected]>', 'Test mit So und so\x{a}\x{a}\x{a}Branch: Cannot_be_determined\x{a}Affe...') called at /usr/share/scmbug/lib/Scmbug/Daemon/Integration.pm line 468 Scmbug::Daemon::Integration::add_comment_to_all('Scmbug::Daemon::Integration=HASH(0x13d182d0)', '[email protected]<mailto:[email protected]>', 'Test mit So und so\x{a}\x{a}\x{a}Branch: Cannot_be_determined\x{a}Affe...', 'ARRAY(0x13d181e0)') called at /usr/share/scmbug/lib/Scmbug/Daemon/Integration.pm line 89 Scmbug::Daemon::Integration::process_activity_commit('Scmbug::Daemon::Integration=HASH(0x13d182d0)') called at /usr/share/scmbug/lib/Scmbug/Daemon/Process.pm line 869 Scmbug::Daemon::Process::process_activity_commit('Scmbug::Daemon::Process=HASH(0x13d0f300)', 'Scmbug::Daemon::Request=HASH(0x13cc5870)') called at /usr/share/scmbug/lib/Scmbug/Daemon/Process.pm line 786 Scmbug::Daemon::Process::process_activity('Scmbug::Daemon::Process=HASH(0x13d0f300)', 'Scmbug::Daemon::Request=HASH(0x13cc5870)') called at /usr/share/scmbug/lib/Scmbug/Daemon/Process.pm line 152 Scmbug::Daemon::Process::process_connection('Scmbug::Daemon::Process=HASH(0x13d0f300)', '*main::STDIN', '*main::STDOUT', 'Scmbug::Daemon::Request=HASH(0x13cc5870)') called at /usr/share/scmbug/lib/Scmbug/Daemon/Daemon.pm line 579 Scmbug::Daemon::Daemon::spawn_child('Scmbug::Daemon::Daemon=HASH(0x111e23f0)', 'localhost.localdomain', 127.0.0.1, 47023) called at /usr/share/scmbug/lib/Scmbug/Daemon/Daemon.pm line 493 Scmbug::Daemon::Daemon::start_daemon_forked('Scmbug::Daemon::Daemon=HASH(0x111e23f0)') called at /usr/share/scmbug/lib/Scmbug/Daemon/Daemon.pm line 410 Scmbug::Daemon::Daemon::start_daemon('Scmbug::Daemon::Daemon=HASH(0x111e23f0)', '/etc/scmbug/daemon.conf') called at /usr/sbin/scmbug_daemon.pl<http://scmbug_daemon.pl> line 39 main::main('/etc/scmbug/daemon.conf') called at /usr/sbin/scmbug_daemon.pl<http://scmbug_daemon.pl> line 28 2011/03/08 11:09:22 Scmbug WARN> Daemon.pm:589:Scmbug::Daemon::Daemon::spawn_child - 127.0.0.1:47023<http://127.0.0.1:47023> Connection from localhost.localdomain processed Mit freundlichen Grüßen / Kind regards Michel Pittelkow Via Outlook Webaccess ________________________________________ Von: Michel Pittelkow - michael-wessel.de<http://michael-wessel.de> [[email protected]<mailto:[email protected]>] Gesendet: Dienstag, 8. März 2011 11:12 Bis: Yavor Nikolov Cc: [email protected]<mailto:[email protected]> Betreff: Re: [scmbug-users] SCMBug Commit: Error 7 Ok. For now i just disabled the check and it commits. But somehow i don't see anything in Bugzilla. Should'nt there be the commit message as comment? am I missing something? Mit freundlichen Grüßen / Kind regards Michel Pittelkow Via Outlook Webaccess ________________________________ Von: Yavor Nikolov [[email protected]<mailto:[email protected]>] Gesendet: Dienstag, 8. März 2011 09:29 Bis: Michel Pittelkow - michael-wessel.de<http://michael-wessel.de> Cc: [email protected]<mailto:[email protected]> Betreff: Re: Re: [scmbug-users] SCMBug Commit: Error 7 You can modify Bugzilla's status workflow to be as it used to be in previous Bugzilla versions. There are other places in scmbug relying on particular status names. http://bugzillaupdate.wordpress.com/2010/07/06/bugzilla-4-0-has-a-new-default-status-workflow/ Regards, Yavor On Tue, Mar 8, 2011 at 02:52, Michel Pittelkow - michael-wessel.de<http://michael-wessel.de><http://michael-wessel.de> <[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>> wrote: Hi, So there is actually nothing i can do but disable the is_open_state check, right? Thanks for your help. Mit freundlichen Grüßen / Kind regards Michel Pittelkow Mobil via BlackBerry Von: Yavor Nikolov [mailto:[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>] Gesendet: Monday, March 07, 2011 11:12 PM An: Michel Pittelkow - michael-wessel.de<http://michael-wessel.de><http://michael-wessel.de> Cc: [email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>> <[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>> Betreff: Re: [scmbug-users] SCMBug Commit: Error 7 Hi, Actually list of states is dynamically retrieved from Bugzilla but "active" flag is hardcoded: $status_map->{ $status }->{ active } = 0; #Bugzilla::Bug::is_open_state( $status ); ... $status_map->{ 'ASSIGNED' }->{ active } = 1; $status_map->{ 'REOPENED' }->{ active } = 1; * I don't know why that "Bugzilla::Bug::is_open_state( $status )" has been disabled (maybe to prevent updating bugs in initial unassigned state). * If it's not possible to dynamically populate everything from Bugzilla - maybe it would be better to have those state names moved to config files instead of being hard-coded. Regards, Yavor On Mon, Mar 7, 2011 at 23:44, Yavor Nikolov <[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>> wrote: Hi, I think problem is related to fact that Bugzilla 4 has introduced new default status workflow. (I haven't noticed that since I upgraded from earlier version - old default workflow is preserved in such cases). In particular - IN_PROGRESS seems to be a new state (didn't exist in earlier Bugzilla versions). To some extent Bugzilla::bug_status_map implementation is hard-coded and it doesn't take into account that IN_PROGRESS is an active state. Kind of workaround may be to try disabling open_bug_state in glue.conf which will skip this validation. Regards, Yavor On Mon, Mar 7, 2011 at 22:48, Michel Pittelkow - michael-wessel.de<http://michael-wessel.de><http://michael-wessel.de> <[email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>>> wrote: Hi there, got another Problem. Using Bugzilla 4. When I commit a test i get: ** Scmbug error 7: Bug '1' is in the 'IN_PROGRESS' state, instead of the '' or '' states. Perhaps there is a problem fetching the valud resolution states? Bugtracker.pm#392: sub valid_resolution_states_list { my $self = shift; my ( $bug_status, $bug_status_map ) = ( @_ ); my $list = ""; my $count = 0; foreach my $resolution_state ( @{ $bug_status_map->{ $bug_status }->{ possible_resolution_states } } ) { $count++; if ( $count > 1) { $list .= " or "; } $list .= "'" . $resolution_state . "'"; } if ( $count == 0 ) { $list .= ''; } elsif ( $count == 1 ) { $list .= " state"; } else { $list .= " states"; } return $list; } Mit freundlichen Grüßen / Kind regards Michel Pittelkow Via Outlook Webaccess _______________________________________________ scmbug-users mailing list [email protected]<mailto:[email protected]><mailto:[email protected]<mailto:[email protected]>> http://lists.mkgnu.net/cgi-bin/mailman/listinfo/scmbug-users +----------------------------------------------------------------------+ | - michael-wessel.de<http://michael-wessel.de><http://michael-wessel.de> Secure E-Mail Status - | +----------------------------------------------------------------------+ | - Die Nachricht war weder verschluesselt noch digital unterschrieben | +----------------------------------------------------------------------+ +----------------------------------------------------------------------+ | - michael-wessel.de<http://michael-wessel.de> Secure E-Mail Status - | +----------------------------------------------------------------------+ | - Die Nachricht war weder verschluesselt noch digital unterschrieben | +----------------------------------------------------------------------+ _______________________________________________ scmbug-users mailing list [email protected]<mailto:[email protected]> http://lists.mkgnu.net/cgi-bin/mailman/listinfo/scmbug-users +----------------------------------------------------------------------+ | - michael-wessel.de<http://michael-wessel.de> Secure E-Mail Status - | +----------------------------------------------------------------------+ | - Die Nachricht war weder verschluesselt noch digital unterschrieben | +----------------------------------------------------------------------+ +----------------------------------------------------------------------+ | - michael-wessel.de Secure E-Mail Status - | +----------------------------------------------------------------------+ | - Die Nachricht war weder verschluesselt noch digital unterschrieben | +----------------------------------------------------------------------+ _______________________________________________ scmbug-users mailing list [email protected] http://lists.mkgnu.net/cgi-bin/mailman/listinfo/scmbug-users
