Re: [rt-users] DBD::mysql::st execute failed: MySQL server has goneaway at
Ok here is some more diags
I have deleted the database and recreated the database from the
installation instructions. I am still getting the same error.
In a browser it says DBD::mysql::st execute failed: MySQL server has
gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm line 71.
This is the last few lines of the log says this:
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x2af2d455f180)',
'TimeEstimated', '', 'Status', 'new', 'new-DependsOn', '', 'Queue',
'General', ...) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1284
eval {...} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp('undef', 'undef', 'undef',
'TimeEstimated', '', 'Status', 'new', 'new-DependsOn', '', ...) called
at /opt/rt3/share/html/autohandler line 308
HTML::Mason::Commands::__ANON__('TimeEstimated', '', 'Status',
'new', 'new-DependsOn', '', 'Queue', 'General', 'AdminCc', ...) called
at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x2af2d4188ed0)',
'TimeEstimated', '', 'Status', 'new', 'new-DependsOn', '', 'Queue',
'General', ...) called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1279
eval {...} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1274
HTML::Mason::Request::comp('undef', 'undef', 'undef',
'TimeEstimated', '', 'Status', 'new', 'new-DependsOn', '', ...) called
at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 473
eval {...} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 473
eval {...} called at
/usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 425
HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x2af2d44ad6d0)')
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 168
HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0x2af2d44ad6d0)')
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x2af2d10de3f0)',
'Apache2::RequestRec=SCALAR(0x2af2d430fa50)') called at
/opt/rt3/bin/webmux.pl line 148
eval {...} called at /opt/rt3/bin/webmux.pl line 148
RT::Mason::handler('Apache2::RequestRec=SCALAR(0x2af2d430fa50)')
called at -e line 0
eval {...} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272)
[Sun Oct 26 11:21:28 2008] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm line 67.
(/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm:67)
[Sun Oct 26 11:21:28 2008] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm line 71.
(/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm:71)
Please can someone help with this.
Thank you
Kobus
Ruslan Zakirov wrote:
Have you done steps from UPGRADING.mysql?
On Sat, Oct 25, 2008 at 12:08 AM, Kobus Bensch [EMAIL PROTECTED] wrote:
No nothing in the mysql log.
I juast had to restart the server and i sent one ticket via email and it
generated a 122mb log file.
There is something really wrong here and I dont know what and why.
I had RT running on a server with i386 acrch and version 3.6.5.
I then moved it all to a new server and x64 arch and 3.8.1 and now I get all
of these errors.
[EMAIL PROTECTED] wrote:
Anything in the mysql logs ?
Sent via BlackBerry from T-Mobile
-Original Message-
From: Kobus Bensch - No Sig [EMAIL PROTECTED]
Date: Fri, 24 Oct 2008 21:01:27
To: Curtis Bruneau[EMAIL PROTECTED]
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] DBD::mysql::st execute failed: MySQL server has gone
away at
Hi
2GB on rt/db server.
I will have to look at the innodb settings, not changed these before so
will have to dig around.
Ticket volume is very low. Around 20 max a day.
I checked httpd and mysql logs and when this occur there is nothing much
going on in the logs.
Thanks for the help.
kobus
Curtis Bruneau wrote:
Sounds like the oom-killer is getting mysql. How much memory is on
your db server? Is it configured in such a way that when the innodb
pool is full it's not running out of memory? You shouldn't really have
an issue with this unless you have a large amount of tickets. Might
want to check some of your other logs and see what's occurring.
Apache/mod_perl can be quite memory intensive at times depending how
many children are setup, it will slowly grow.
Kobus Bensch - No Sig wrote:
Hi
I am able to access the server, I am able to login, and in some cases
even able to brwose normally.
The problem I then get is that when I try to create a ticket it thinks a
bit and then gives me this error.
Re: [rt-users] DBD::mysql::st execute failed: MySQL server has goneaway at
Anything in the mysql logs ?
Sent via BlackBerry from T-Mobile
-Original Message-
From: Kobus Bensch - No Sig [EMAIL PROTECTED]
Date: Fri, 24 Oct 2008 21:01:27
To: Curtis Bruneau[EMAIL PROTECTED]
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] DBD::mysql::st execute failed: MySQL server has gone
away at
Hi
2GB on rt/db server.
I will have to look at the innodb settings, not changed these before so
will have to dig around.
Ticket volume is very low. Around 20 max a day.
I checked httpd and mysql logs and when this occur there is nothing much
going on in the logs.
Thanks for the help.
kobus
Curtis Bruneau wrote:
Sounds like the oom-killer is getting mysql. How much memory is on
your db server? Is it configured in such a way that when the innodb
pool is full it's not running out of memory? You shouldn't really have
an issue with this unless you have a large amount of tickets. Might
want to check some of your other logs and see what's occurring.
Apache/mod_perl can be quite memory intensive at times depending how
many children are setup, it will slowly grow.
Kobus Bensch - No Sig wrote:
Hi
I am able to access the server, I am able to login, and in some cases
even able to brwose normally.
The problem I then get is that when I try to create a ticket it thinks a
bit and then gives me this error.
Due to this error the server creates massive logs, so much so that I
have to reboot the server and delete it as soon as it comes back. I
deleted a 81GB rt.log file.
Further problems, but after tghis issue has been solved is after each
page i try to click on i have to login.
Last error I sometimes just get blank pages.
Thanks for the help
Kobus
Eli Altman wrote:
Please explain in detail what problem you are experiencing. Are you
having problems installing RT and running it for the first time?
Can you not access RT at all through a browser?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kobus
Bensch
Sent: Friday, October 24, 2008 12:38 PM
To: RT Users
Subject: [rt-users] DBD::mysql::st execute failed: MySQL server has
gone away at
Hi
Please can someone help.
Fresh install of os and rt and i get this error which ends of with
the ticket email sent but no ticket created and my RT is currently
not working. I have downloaded all the email archives and found
other people with the same error but no real solution.
Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45.
Thanks for any help
Kobus
There is a lot more to this log entry, I just could not include it
all here.
HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)')
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 168
HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)')
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x2b994c2469a0)',
'Apache2::RequestRec=SCALAR(0x2b995437e480)') called at
/opt/rt3/bin/webmux.pl line 148
eval {...} called at /opt/rt3/bin/webmux.pl line 148
RT::Mason::handler('Apache2::RequestRec=SCALAR(0x2b995437e480)')
called at -e line 0
eval {...} called at -e line 0
(/usr/lib/perl5/5.8.8/Carp.pm:272)
[Thu Oct 23 22:30:23 2008] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm line 67.
(/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm:67)
[Thu Oct 23 22:30:23 2008] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm line 71.
(/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm:71)
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] DBD::mysql::st execute failed: MySQL server has goneaway at
Title: Fullnet Solutions Limited
No nothing in the mysql log.
I juast had to restart the server and i sent one ticket via email and
it generated a 122mb log file.
There is something really wrong here and I dont know what and why.
I had RT running on a server with i386 acrch and version 3.6.5.
I then moved it all to a new server and x64 arch and 3.8.1 and now I
get all of these errors.
[EMAIL PROTECTED] wrote:
Anything in the mysql logs ?
Sent via BlackBerry from T-Mobile
-Original Message-
From: Kobus Bensch - No Sig [EMAIL PROTECTED]
Date: Fri, 24 Oct 2008 21:01:27
To: Curtis Bruneau[EMAIL PROTECTED]
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] DBD::mysql::st execute failed: MySQL server has gone
away at
Hi
2GB on rt/db server.
I will have to look at the innodb settings, not changed these before so
will have to dig around.
Ticket volume is very low. Around 20 max a day.
I checked httpd and mysql logs and when this occur there is nothing much
going on in the logs.
Thanks for the help.
kobus
Curtis Bruneau wrote:
Sounds like the oom-killer is getting mysql. How much memory is on
your db server? Is it configured in such a way that when the innodb
pool is full it's not running out of memory? You shouldn't really have
an issue with this unless you have a large amount of tickets. Might
want to check some of your other logs and see what's occurring.
Apache/mod_perl can be quite memory intensive at times depending how
many children are setup, it will slowly grow.
Kobus Bensch - No Sig wrote:
Hi
I am able to access the server, I am able to login, and in some cases
even able to brwose normally.
The problem I then get is that when I try to create a ticket it thinks a
bit and then gives me this error.
Due to this error the server creates massive logs, so much so that I
have to reboot the server and delete it as soon as it comes back. I
deleted a 81GB rt.log file.
Further problems, but after tghis issue has been solved is after each
page i try to click on i have to login.
Last error I sometimes just get blank pages.
Thanks for the help
Kobus
Eli Altman wrote:
Please explain in detail what problem you are experiencing. Are you
having problems installing RT and running it for the first time?
Can you not access RT at all through a browser?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Kobus
Bensch
Sent: Friday, October 24, 2008 12:38 PM
To: RT Users
Subject: [rt-users] DBD::mysql::st execute failed: MySQL server has
gone away at
Hi
Please can someone help.
Fresh install of os and rt and i get this error which ends of with
the ticket email sent but no ticket created and my RT is currently
not working. I have downloaded all the email archives and found
other people with the same error but no real solution.
Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45.
Thanks for any help
Kobus
There is a lot more to this log entry, I just could not include it
all here.
HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)')
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 168
HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)')
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x2b994c2469a0)',
'Apache2::RequestRec=SCALAR(0x2b995437e480)') called at
/opt/rt3/bin/webmux.pl line 148
eval {...} called at /opt/rt3/bin/webmux.pl line 148
RT::Mason::handler('Apache2::RequestRec=SCALAR(0x2b995437e480)')
called at -e line 0
eval {...} called at -e line 0
(/usr/lib/perl5/5.8.8/Carp.pm:272)
[Thu Oct 23 22:30:23 2008] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm line 67.
(/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm:67)
[Thu Oct 23 22:30:23 2008] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm line 71.
(/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm:71)
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
--
Re: [rt-users] DBD::mysql::st execute failed: MySQL server has goneaway at
Have you done steps from UPGRADING.mysql?
On Sat, Oct 25, 2008 at 12:08 AM, Kobus Bensch [EMAIL PROTECTED] wrote:
No nothing in the mysql log.
I juast had to restart the server and i sent one ticket via email and it
generated a 122mb log file.
There is something really wrong here and I dont know what and why.
I had RT running on a server with i386 acrch and version 3.6.5.
I then moved it all to a new server and x64 arch and 3.8.1 and now I get all
of these errors.
[EMAIL PROTECTED] wrote:
Anything in the mysql logs ?
Sent via BlackBerry from T-Mobile
-Original Message-
From: Kobus Bensch - No Sig [EMAIL PROTECTED]
Date: Fri, 24 Oct 2008 21:01:27
To: Curtis Bruneau[EMAIL PROTECTED]
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] DBD::mysql::st execute failed: MySQL server has gone
away at
Hi
2GB on rt/db server.
I will have to look at the innodb settings, not changed these before so
will have to dig around.
Ticket volume is very low. Around 20 max a day.
I checked httpd and mysql logs and when this occur there is nothing much
going on in the logs.
Thanks for the help.
kobus
Curtis Bruneau wrote:
Sounds like the oom-killer is getting mysql. How much memory is on
your db server? Is it configured in such a way that when the innodb
pool is full it's not running out of memory? You shouldn't really have
an issue with this unless you have a large amount of tickets. Might
want to check some of your other logs and see what's occurring.
Apache/mod_perl can be quite memory intensive at times depending how
many children are setup, it will slowly grow.
Kobus Bensch - No Sig wrote:
Hi
I am able to access the server, I am able to login, and in some cases
even able to brwose normally.
The problem I then get is that when I try to create a ticket it thinks a
bit and then gives me this error.
Due to this error the server creates massive logs, so much so that I
have to reboot the server and delete it as soon as it comes back. I
deleted a 81GB rt.log file.
Further problems, but after tghis issue has been solved is after each
page i try to click on i have to login.
Last error I sometimes just get blank pages.
Thanks for the help
Kobus
Eli Altman wrote:
Please explain in detail what problem you are experiencing. Are you
having problems installing RT and running it for the first time?
Can you not access RT at all through a browser?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kobus
Bensch
Sent: Friday, October 24, 2008 12:38 PM
To: RT Users
Subject: [rt-users] DBD::mysql::st execute failed: MySQL server has
gone away at
Hi
Please can someone help.
Fresh install of os and rt and i get this error which ends of with
the ticket email sent but no ticket created and my RT is currently
not working. I have downloaded all the email archives and found
other people with the same error but no real solution.
Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45.
Thanks for any help
Kobus
There is a lot more to this log entry, I just could not include it
all here.
HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)')
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 168
HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)')
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x2b994c2469a0)',
'Apache2::RequestRec=SCALAR(0x2b995437e480)') called at
/opt/rt3/bin/webmux.pl line 148
eval {...} called at /opt/rt3/bin/webmux.pl line 148
RT::Mason::handler('Apache2::RequestRec=SCALAR(0x2b995437e480)')
called at -e line 0
eval {...} called at -e line 0
(/usr/lib/perl5/5.8.8/Carp.pm:272)
[Thu Oct 23 22:30:23 2008] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm line 67.
(/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm:67)
[Thu Oct 23 22:30:23 2008] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm line 71.
(/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm:71)
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from
Re: [rt-users] DBD::mysql::st execute failed: MySQL server has goneaway at
Title: Fullnet Solutions Limited
No, because the previous server had the same version of MySQL as the
new one.
Ruslan Zakirov wrote:
Have you done steps from UPGRADING.mysql?
On Sat, Oct 25, 2008 at 12:08 AM, Kobus Bensch [EMAIL PROTECTED] wrote:
No nothing in the mysql log.
I juast had to restart the server and i sent one ticket via email and it
generated a 122mb log file.
There is something really wrong here and I dont know what and why.
I had RT running on a server with i386 acrch and version 3.6.5.
I then moved it all to a new server and x64 arch and 3.8.1 and now I get all
of these errors.
[EMAIL PROTECTED] wrote:
Anything in the mysql logs ?
Sent via BlackBerry from T-Mobile
-Original Message-
From: Kobus Bensch - No Sig [EMAIL PROTECTED]
Date: Fri, 24 Oct 2008 21:01:27
To: Curtis Bruneau[EMAIL PROTECTED]
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] DBD::mysql::st execute failed: MySQL server has gone
away at
Hi
2GB on rt/db server.
I will have to look at the innodb settings, not changed these before so
will have to dig around.
Ticket volume is very low. Around 20 max a day.
I checked httpd and mysql logs and when this occur there is nothing much
going on in the logs.
Thanks for the help.
kobus
Curtis Bruneau wrote:
Sounds like the oom-killer is getting mysql. How much memory is on
your db server? Is it configured in such a way that when the innodb
pool is full it's not running out of memory? You shouldn't really have
an issue with this unless you have a large amount of tickets. Might
want to check some of your other logs and see what's occurring.
Apache/mod_perl can be quite memory intensive at times depending how
many children are setup, it will slowly grow.
Kobus Bensch - No Sig wrote:
Hi
I am able to access the server, I am able to login, and in some cases
even able to brwose normally.
The problem I then get is that when I try to create a ticket it thinks a
bit and then gives me this error.
Due to this error the server creates massive logs, so much so that I
have to reboot the server and delete it as soon as it comes back. I
deleted a 81GB rt.log file.
Further problems, but after tghis issue has been solved is after each
page i try to click on i have to login.
Last error I sometimes just get blank pages.
Thanks for the help
Kobus
Eli Altman wrote:
Please explain in detail what problem you are experiencing. Are you
having problems installing RT and running it for the first time?
Can you not access RT at all through a browser?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Kobus
Bensch
Sent: Friday, October 24, 2008 12:38 PM
To: RT Users
Subject: [rt-users] DBD::mysql::st execute failed: MySQL server has
gone away at
Hi
Please can someone help.
Fresh install of os and rt and i get this error which ends of with
the ticket email sent but no ticket created and my RT is currently
not working. I have downloaded all the email archives and found
other people with the same error but no real solution.
Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45.
Thanks for any help
Kobus
There is a lot more to this log entry, I just could not include it
all here.
HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)')
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 168
HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)')
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x2b994c2469a0)',
'Apache2::RequestRec=SCALAR(0x2b995437e480)') called at
/opt/rt3/bin/webmux.pl line 148
eval {...} called at /opt/rt3/bin/webmux.pl line 148
RT::Mason::handler('Apache2::RequestRec=SCALAR(0x2b995437e480)')
called at -e line 0
eval {...} called at -e line 0
(/usr/lib/perl5/5.8.8/Carp.pm:272)
[Thu Oct 23 22:30:23 2008] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm line 67.
(/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm:67)
[Thu Oct 23 22:30:23 2008] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm line 71.
(/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm:71)
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover
Re: [rt-users] DBD::mysql::st execute failed: MySQL server has goneaway at
You still must do that.
On Sat, Oct 25, 2008 at 12:43 AM, Kobus Bensch [EMAIL PROTECTED] wrote:
No, because the previous server had the same version of MySQL as the new
one.
Ruslan Zakirov wrote:
Have you done steps from UPGRADING.mysql?
On Sat, Oct 25, 2008 at 12:08 AM, Kobus Bensch [EMAIL PROTECTED]
wrote:
No nothing in the mysql log.
I juast had to restart the server and i sent one ticket via email and it
generated a 122mb log file.
There is something really wrong here and I dont know what and why.
I had RT running on a server with i386 acrch and version 3.6.5.
I then moved it all to a new server and x64 arch and 3.8.1 and now I get all
of these errors.
[EMAIL PROTECTED] wrote:
Anything in the mysql logs ?
Sent via BlackBerry from T-Mobile
-Original Message-
From: Kobus Bensch - No Sig [EMAIL PROTECTED]
Date: Fri, 24 Oct 2008 21:01:27
To: Curtis Bruneau[EMAIL PROTECTED]
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] DBD::mysql::st execute failed: MySQL server has gone
away at
Hi
2GB on rt/db server.
I will have to look at the innodb settings, not changed these before so
will have to dig around.
Ticket volume is very low. Around 20 max a day.
I checked httpd and mysql logs and when this occur there is nothing much
going on in the logs.
Thanks for the help.
kobus
Curtis Bruneau wrote:
Sounds like the oom-killer is getting mysql. How much memory is on
your db server? Is it configured in such a way that when the innodb
pool is full it's not running out of memory? You shouldn't really have
an issue with this unless you have a large amount of tickets. Might
want to check some of your other logs and see what's occurring.
Apache/mod_perl can be quite memory intensive at times depending how
many children are setup, it will slowly grow.
Kobus Bensch - No Sig wrote:
Hi
I am able to access the server, I am able to login, and in some cases
even able to brwose normally.
The problem I then get is that when I try to create a ticket it thinks a
bit and then gives me this error.
Due to this error the server creates massive logs, so much so that I
have to reboot the server and delete it as soon as it comes back. I
deleted a 81GB rt.log file.
Further problems, but after tghis issue has been solved is after each
page i try to click on i have to login.
Last error I sometimes just get blank pages.
Thanks for the help
Kobus
Eli Altman wrote:
Please explain in detail what problem you are experiencing. Are you
having problems installing RT and running it for the first time?
Can you not access RT at all through a browser?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kobus
Bensch
Sent: Friday, October 24, 2008 12:38 PM
To: RT Users
Subject: [rt-users] DBD::mysql::st execute failed: MySQL server has
gone away at
Hi
Please can someone help.
Fresh install of os and rt and i get this error which ends of with
the ticket email sent but no ticket created and my RT is currently
not working. I have downloaded all the email archives and found
other people with the same error but no real solution.
Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45.
Thanks for any help
Kobus
There is a lot more to this log entry, I just could not include it
all here.
HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)')
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 168
HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)')
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x2b994c2469a0)',
'Apache2::RequestRec=SCALAR(0x2b995437e480)') called at
/opt/rt3/bin/webmux.pl line 148
eval {...} called at /opt/rt3/bin/webmux.pl line 148
RT::Mason::handler('Apache2::RequestRec=SCALAR(0x2b995437e480)')
called at -e line 0
eval {...} called at -e line 0
(/usr/lib/perl5/5.8.8/Carp.pm:272)
[Thu Oct 23 22:30:23 2008] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm line 67.
(/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm:67)
[Thu Oct 23 22:30:23 2008] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm line 71.
(/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm:71)
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
___
Re: [rt-users] DBD::mysql::st execute failed: MySQL server has goneaway at
Kobus Bensch wrote: No, because the previous server had the same version of MySQL as the new one. you need to upgrade the mysql schema when upgrading rt from 3.6 to 3.8 -- -- Chaim Rieger ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] DBD::mysql::st execute failed: MySQL server has goneaway at
Yeah that's strange, I had a similar issue where my fastcgi segfaulted
causing a permanent error state, which causes the process to keep
cycling filling up the log/hard drive. This would only happen in low
memory situations, yours seems to be somewhat driver/software related
where it keeps trying and just fills up the log.
Kobus Bensch wrote:
No nothing in the mysql log.
I juast had to restart the server and i sent one ticket via email and
it generated a 122mb log file.
There is something really wrong here and I dont know what and why.
I had RT running on a server with i386 acrch and version 3.6.5.
I then moved it all to a new server and x64 arch and 3.8.1 and now I
get all of these errors.
[EMAIL PROTECTED] wrote:
Anything in the mysql logs ?
Sent via BlackBerry from T-Mobile
-Original Message-
From: Kobus Bensch - No Sig [EMAIL PROTECTED]
Date: Fri, 24 Oct 2008 21:01:27
To: Curtis Bruneau[EMAIL PROTECTED]
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] DBD::mysql::st execute failed: MySQL server has gone
away at
Hi
2GB on rt/db server.
I will have to look at the innodb settings, not changed these before so
will have to dig around.
Ticket volume is very low. Around 20 max a day.
I checked httpd and mysql logs and when this occur there is nothing much
going on in the logs.
Thanks for the help.
kobus
Curtis Bruneau wrote:
Sounds like the oom-killer is getting mysql. How much memory is on
your db server? Is it configured in such a way that when the innodb
pool is full it's not running out of memory? You shouldn't really have
an issue with this unless you have a large amount of tickets. Might
want to check some of your other logs and see what's occurring.
Apache/mod_perl can be quite memory intensive at times depending how
many children are setup, it will slowly grow.
Kobus Bensch - No Sig wrote:
Hi
I am able to access the server, I am able to login, and in some cases
even able to brwose normally.
The problem I then get is that when I try to create a ticket it thinks a
bit and then gives me this error.
Due to this error the server creates massive logs, so much so that I
have to reboot the server and delete it as soon as it comes back. I
deleted a 81GB rt.log file.
Further problems, but after tghis issue has been solved is after each
page i try to click on i have to login.
Last error I sometimes just get blank pages.
Thanks for the help
Kobus
Eli Altman wrote:
Please explain in detail what problem you are experiencing. Are you
having problems installing RT and running it for the first time?
Can you not access RT at all through a browser?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kobus
Bensch
Sent: Friday, October 24, 2008 12:38 PM
To: RT Users
Subject: [rt-users] DBD::mysql::st execute failed: MySQL server has
gone away at
Hi
Please can someone help.
Fresh install of os and rt and i get this error which ends of with
the ticket email sent but no ticket created and my RT is currently
not working. I have downloaded all the email archives and found
other people with the same error but no real solution.
Rt 3.8.1 on Centos 5.2 with php 5 perl 5.8.8 and mysql 5.0.45.
Thanks for any help
Kobus
There is a lot more to this log entry, I just could not include it
all here.
HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)')
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 168
HTML::Mason::Request::ApacheHandler::exec('RT::Interface::Web::Request=HASH(0x2b99543613e0)')
called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
line 825
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x2b994c2469a0)',
'Apache2::RequestRec=SCALAR(0x2b995437e480)') called at
/opt/rt3/bin/webmux.pl line 148
eval {...} called at /opt/rt3/bin/webmux.pl line 148
RT::Mason::handler('Apache2::RequestRec=SCALAR(0x2b995437e480)')
called at -e line 0
eval {...} called at -e line 0
(/usr/lib/perl5/5.8.8/Carp.pm:272)
[Thu Oct 23 22:30:23 2008] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm line 67.
(/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm:67)
[Thu Oct 23 22:30:23 2008] [warning]: DBD::mysql::st execute failed:
MySQL server has gone away at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm line 71.
(/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Lock/MySQL.pm:71)
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at
Re: [rt-users] DBD::mysql::st execute failed: MySQL server has goneaway at
Hi I have now run the actions for the upgrading rt and it still give me the same error. Kobus Chaim Rieger wrote: Kobus Bensch wrote: No, because the previous server had the same version of MySQL as the new one. you need to upgrade the mysql schema when upgrading rt from 3.6 to 3.8 signature.asc Description: OpenPGP digital signature ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] DBD::mysql::st execute failed: MySQL server has goneaway at
Kobus Bensch - No Sig wrote: Hi I have now run the actions for the upgrading rt and it still give me the same error. Kobus stop and restart your web server clear the mason cache -- -- Chaim Rieger ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
