Rt-3.6.1 glitch

I have rt-3.6.1 installed on a host different than the DB server. Today
I moved my database from one server to the other (dump then import).
MySQL-4.0.26 was in the old box, while the new box is MySQL-4.0.27.
Both support InnoDB.

Now when I try to “Take” a ticket, the following error pops up:

error: Transactions not supported by database at /usr/local/lib/perl5/site_perl/5.8.8/mach/DBI.pm line 1657.
context:

1653: sub begin_work {
1654: my $dbh = shift;
1655: return $dbh->set_err(1, “Already in a transaction”)
1656: unless $dbh->FETCH(‘AutoCommit’);
1657: $dbh->STORE(‘AutoCommit’, 0); # will croak if driver doesn’t support it
1658: $dbh->STORE(‘BegunWork’, 1); # trigger post commit/rollback action
1659: return 1;
1660: }
1661:

code stack: /usr/local/lib/perl5/site_perl/5.8.8/mach/DBI.pm:1657
/usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:682
/opt/rt3/lib/RT/Ticket_Overlay.pm:3044
/opt/rt3/lib/RT/Ticket_Overlay.pm:3111
/opt/rt3/share/html/Ticket/Display.html:128
/opt/rt3/share/html/autohandler:279

Not sure what changed, really, and neither can I figure out the fix…

    cheers
   - wash 

Odhiambo Washington . WANANCHI ONLINE LTD (Nairobi, KE) |
wash () WANANCHI ! com . 1ere Etage, Loita Hse, Loita St., |
GSM: (+254) 722 743 223 . # 10286, 00100 NAIROBI |
GSM: (+254) 733 744 121 . (+254) 020 313 985 - 9 |
“Oh My God! They killed init! You Bastards!”
–from a /. post

Hello!2006/8/19, Odhiambo Washington wash@wananchi.com:

I have rt-3.6.1 installed on a host different than the DB server. Today
I moved my database from one server to the other (dump then import).
MySQL-4.0.26 was in the old box, while the new box is MySQL-4.0.27.
Both support InnoDB.

error: Transactions not supported by database at

Did you check that new DB is using InnoDB engine?
Maybe that information was not stored in the dump, and it was
recreated as MyISAM.

Alexandr Ciornii, http://chorny.net

  • On 19/08/06 21:32 +0300, Alexandr Ciornii wrote:
    | Hello!
    || 2006/8/19, Odhiambo Washington wash@wananchi.com:
    | >I have rt-3.6.1 installed on a host different than the DB server. Today
    | >I moved my database from one server to the other (dump then import).
    | >MySQL-4.0.26 was in the old box, while the new box is MySQL-4.0.27.
    | >Both support InnoDB.
    | >
    | >error: Transactions not supported by database at
    |
    | Did you check that new DB is using InnoDB engine?
    | Maybe that information was not stored in the dump, and it was
    | recreated as MyISAM.

Yes, I did. I used 'show create table" and it tells me the tables are
InnoDB. The new db server supports InnoDB by default.

BTW, I left out an important detail. With native rt-3.4.5, this error
is not there at all. It’s only when I use rt-3.6.1 web UI to access the
same DB.

I just realized that the change of the DB server does not really count.
I pointed back to old DB server and same error pops up. So it’s
something I need to fix with rt-3.6.1, perhaps one of the deps is broken
on my test box.

    cheers
   - wash 

Odhiambo Washington . WANANCHI ONLINE LTD (Nairobi, KE) |
wash () WANANCHI ! com . 1ere Etage, Loita Hse, Loita St., |
GSM: (+254) 722 743 223 . # 10286, 00100 NAIROBI |
GSM: (+254) 733 744 121 . (+254) 020 313 985 - 9 |
“Oh My God! They killed init! You Bastards!”
–from a /. post

You ran the schema updates?

Odhiambo Washington wrote:

  • On 19/08/06 21:32 +0300, Alexandr Ciornii wrote:
    | Hello!
    |

| >I have rt-3.6.1 installed on a host different than the DB server. Today
| >I moved my database from one server to the other (dump then import).
| >MySQL-4.0.26 was in the old box, while the new box is MySQL-4.0.27.
| >Both support InnoDB.
| >
| >error: Transactions not supported by database at
|
| Did you check that new DB is using InnoDB engine?
| Maybe that information was not stored in the dump, and it was
| recreated as MyISAM.

Yes, I did. I used 'show create table" and it tells me the tables are
InnoDB. The new db server supports InnoDB by default.

BTW, I left out an important detail. With native rt-3.4.5, this error
is not there at all. It’s only when I use rt-3.6.1 web UI to access the
same DB.

I just realized that the change of the DB server does not really count.
I pointed back to old DB server and same error pops up. So it’s
something I need to fix with rt-3.6.1, perhaps one of the deps is broken
on my test box.

    cheers
   - wash 

±---------------------------------±----------------------------------------+
Odhiambo Washington . WANANCHI ONLINE LTD (Nairobi, KE) |
wash () WANANCHI ! com . 1ere Etage, Loita Hse, Loita St., |
GSM: (+254) 722 743 223 . # 10286, 00100 NAIROBI |
GSM: (+254) 733 744 121 . (+254) 020 313 985 - 9 |
±--------------------------------±-----------------------------------------+
“Oh My God! They killed init! You Bastards!”
–from a /. post


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati

Why would that be necessary? I dumped the working database are restored
on a different server (configured same way as the one I dumped from).

  • On 21/08/06 08:48 -0400, Drew Barnes wrote:
    | You ran the schema updates?
    |
    |
    | Odhiambo Washington wrote:
    | >* On 19/08/06 21:32 +0300, Alexandr Ciornii wrote:
    | >| Hello!
    | >|| >| 2006/8/19, Odhiambo Washington wash@wananchi.com:
    | >| >I have rt-3.6.1 installed on a host different than the DB server. Today
    | >| >I moved my database from one server to the other (dump then import).
    | >| >MySQL-4.0.26 was in the old box, while the new box is MySQL-4.0.27.
    | >| >Both support InnoDB.
    | >| >
    | >| >error: Transactions not supported by database at
    | >|
    | >| Did you check that new DB is using InnoDB engine?
    | >| Maybe that information was not stored in the dump, and it was
    | >| recreated as MyISAM.
    | >
    | >Yes, I did. I used 'show create table" and it tells me the tables are
    | >InnoDB. The new db server supports InnoDB by default.
    | >
    | >BTW, I left out an important detail. With native rt-3.4.5, this error
    | >is not there at all. It’s only when I use rt-3.6.1 web UI to access the
    | >same DB.
    | >
    | >I just realized that the change of the DB server does not really count.
    | >I pointed back to old DB server and same error pops up. So it’s
    | >something I need to fix with rt-3.6.1, perhaps one of the deps is broken
    | >on my test box.
    | >
    | >
    | > cheers
    | > - wash
    | >±---------------------------------±----------------------------------------+
    | >Odhiambo Washington . WANANCHI ONLINE LTD
    | >(Nairobi, KE) |
    | >wash () WANANCHI ! com . 1ere Etage, Loita Hse,
    | >Loita St., |
    | >GSM: (+254) 722 743 223 . # 10286, 00100 NAIROBI
    | >|
    | >GSM: (+254) 733 744 121 . (+254) 020 313 985 - 9
    | >|
    | >±--------------------------------±-----------------------------------------+
    | >“Oh My God! They killed init! You Bastards!”
    | > --from a /. post
    | >_______________________________________________
    | >http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
    | >
    | >Community help: http://wiki.bestpractical.com
    | >Commercial support: sales@bestpractical.com
    | >
    | >
    | >Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
    | >Buy a copy at http://rtbook.bestpractical.com
    | >
    |
    | –
    | Drew Barnes
    | Applications Analyst
    | Raymond Walters College
    | University of Cincinnati

      cheers
     - wash 
    

Odhiambo Washington . WANANCHI ONLINE LTD (Nairobi, KE) |
wash () WANANCHI ! com . 1ere Etage, Loita Hse, Loita St., |
GSM: (+254) 722 743 223 . # 10286, 00100 NAIROBI |
GSM: (+254) 733 744 121 . (+254) 020 313 985 - 9 |
“Oh My God! They killed init! You Bastards!”
–from a /. post

“| >BTW, I left out an important detail. With native rt-3.4.5, this error
| >is not there at all. It’s only when I use rt-3.6.1 web UI to access the
| >same DB.”

There are DB schema changes between 3.4.x and 3.6.x If you don’t
update, it likely won’t work properly.

There is also one perl module that needed to be installed for 3.6.x but
I can’t recall what it was at this time. UNIVERSAL::require I think?

Odhiambo Washington wrote:

Why would that be necessary? I dumped the working database are restored
on a different server (configured same way as the one I dumped from).

  • On 21/08/06 08:48 -0400, Drew Barnes wrote:
    | You ran the schema updates?
    |
    |
    | Odhiambo Washington wrote:
    | >* On 19/08/06 21:32 +0300, Alexandr Ciornii wrote:
    | >| Hello!
    | >|

| >| >I have rt-3.6.1 installed on a host different than the DB server. Today
| >| >I moved my database from one server to the other (dump then import).
| >| >MySQL-4.0.26 was in the old box, while the new box is MySQL-4.0.27.
| >| >Both support InnoDB.
| >| >
| >| >error: Transactions not supported by database at
| >|
| >| Did you check that new DB is using InnoDB engine?
| >| Maybe that information was not stored in the dump, and it was
| >| recreated as MyISAM.
| >
| >Yes, I did. I used 'show create table" and it tells me the tables are
| >InnoDB. The new db server supports InnoDB by default.
| >
| >BTW, I left out an important detail. With native rt-3.4.5, this error
| >is not there at all. It’s only when I use rt-3.6.1 web UI to access the
| >same DB.
| >
| >I just realized that the change of the DB server does not really count.
| >I pointed back to old DB server and same error pops up. So it’s
| >something I need to fix with rt-3.6.1, perhaps one of the deps is broken
| >on my test box.
| >
| >
| > cheers
| > - wash
| >±---------------------------------±----------------------------------------+
| >Odhiambo Washington . WANANCHI ONLINE LTD
| >(Nairobi, KE) |
| >wash () WANANCHI ! com . 1ere Etage, Loita Hse,
| >Loita St., |
| >GSM: (+254) 722 743 223 . # 10286, 00100 NAIROBI
| >|
| >GSM: (+254) 733 744 121 . (+254) 020 313 985 - 9
| >|
| >±--------------------------------±-----------------------------------------+
| >“Oh My God! They killed init! You Bastards!”
| > --from a /. post
| >_______________________________________________
| >http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
| >
| >Community help: http://wiki.bestpractical.com
| >Commercial support: sales@bestpractical.com
| >
| >
| >Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
| >Buy a copy at http://rtbook.bestpractical.com
| >

Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati
    cheers
   - wash 

±---------------------------------±----------------------------------------+
Odhiambo Washington . WANANCHI ONLINE LTD (Nairobi, KE) |
wash () WANANCHI ! com . 1ere Etage, Loita Hse, Loita St., |
GSM: (+254) 722 743 223 . # 10286, 00100 NAIROBI |
GSM: (+254) 733 744 121 . (+254) 020 313 985 - 9 |
±--------------------------------±-----------------------------------------+
“Oh My God! They killed init! You Bastards!”
–from a /. post


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati

The MySQL client library has changed.

Recompiling DBD::mysql solved the same problem for me.

David

Odhiambo Washington wrote:

Point of clarification: Recompiling DBD::mysql
must be against the updated MySQL client library.
One approach may be to update the MySQL install on
the RT box prior to recompiling DBD::mysql.

David Oberlitner wrote:

  • On 23/08/06 11:55 -0600, David Oberlitner wrote:
    | Point of clarification: Recompiling DBD::mysql
    | must be against the updated MySQL client library.
    | One approach may be to update the MySQL install on
    | the RT box prior to recompiling DBD::mysql.

Hi David,

You win!

I had upgraded from mysql 4.1.19 to 4.1.21 on the RT host box. I did not
think this would change much, but I recompiled DBD::mysql and now it
works again.

Thank you.

    cheers
   - wash 

Odhiambo Washington . WANANCHI ONLINE LTD (Nairobi, KE) |
wash () WANANCHI ! com . 1ere Etage, Loita Hse, Loita St., |
GSM: (+254) 722 743 223 . # 10286, 00100 NAIROBI |
GSM: (+254) 733 744 121 . (+254) 020 313 985 - 9 |
“Oh My God! They killed init! You Bastards!”
–from a /. post