[rt-users] DBD::mysql::st execute failed: MySQL server has goneaway at

Fri Oct 24 16:45:43 EDT 2008

You still must do that.

On Sat, Oct 25, 2008 at 12:43 AM, Kobus Bensch <kbensch at fullnet.co.uk> 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 <kbensch at fullnet.co.uk>
> 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.
>
>
>
> chaim.rieger at gmail.com wrote:
>
> Anything in the mysql logs ?
> Sent via BlackBerry from T-Mobile
>
> -----Original Message-----
> From: Kobus Bensch - No Sig <kbensch at fullnet.co.uk>
>
> Date: Fri, 24 Oct 2008 21:01:27
> To: Curtis Bruneau<curtisb at vianet.ca>
> Cc: <rt-users at 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: rt-users-bounces at lists.bestpractical.com
> [mailto:rt-users-bounces at lists.bestpractical.com] 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: sales at bestpractical.com
>
>
> 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: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
>
> --
>
>
>
>
>
> 7 Marlborough Close
> Maidenhead
> Berkshire
> SL6 4LP
> United Kingdom
>
> Telephone: +44 (01628) 675 978
> Facsimile: +44 (07092) 289 990
> Mobile Phone: +44 (07703) 503 733
> Skype ID: fullnetsolutionsltd Kobus Bensch: kbensch at fullnet.co.uk
>
> Information: info at fullnet.co.uk>
>
> Sales Team: fslsales at fullnet.co.uk
>
> WWW: http://www.fullnet.co.uk
>
> Registered in England & Wales, Company Number 3568937
>
> VAT registration number: UK 714 7309 42
>
> E & O.E. All prices exclude VAT & Carriage unless otherwise specified.
>
> This email and any files transmitted with it are confidential and intended
> solely for the use of the individual or entity to whom they are addressed.
> If you have received this email in error please notify the system
> administrator by emailing admin at fullnet.co.uk with the subject "eMail
> Confidentiality Query!".
>
> The content of this email does not necessarily reflect the views or opinions
> of Fullnet Solutions Limited. If you have any queries or complaints please
> email info at fullnet.co.uk with the subject "eMail Comment/Complaint Query!".
>
> This footnote also confirms that this email message has been scanned for the
> presence of computer viruses. Fullnet Solutions Limited can however not be
> held responsible for any virus infections on the recipients or any other
> systems. For more information regarding the solutions Fullnet has to offer
> please email sales at fullnet.co.uk with the subject "Sales Query!".
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>
>
>
>
>
> --
>
>
>
>
>
> 7 Marlborough Close
> Maidenhead
> Berkshire
> SL6 4LP
> United Kingdom
>
> Telephone: +44 (01628) 675 978
> Facsimile: +44 (07092) 289 990
> Mobile Phone: +44 (07703) 503 733
> Skype ID: fullnetsolutionsltd Kobus Bensch: kbensch at fullnet.co.uk
>
> Information: info at fullnet.co.uk>
>
> Sales Team: fslsales at fullnet.co.uk
>
> WWW: http://www.fullnet.co.uk
>
> Registered in England & Wales, Company Number 3568937
>
> VAT registration number: UK 714 7309 42
>
> E & O.E. All prices exclude VAT & Carriage unless otherwise specified.
>
> This email and any files transmitted with it are confidential and intended
> solely for the use of the individual or entity to whom they are addressed.
> If you have received this email in error please notify the system
> administrator by emailing admin at fullnet.co.uk with the subject "eMail
> Confidentiality Query!".
>
> The content of this email does not necessarily reflect the views or opinions
> of Fullnet Solutions Limited. If you have any queries or complaints please
> email info at fullnet.co.uk with the subject "eMail Comment/Complaint Query!".
>
> This footnote also confirms that this email message has been scanned for the
> presence of computer viruses. Fullnet Solutions Limited can however not be
> held responsible for any virus infections on the recipients or any other
> systems. For more information regarding the solutions Fullnet has to offer
> please email sales at fullnet.co.uk with the subject "Sales Query!".
>
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
>

-- 
Best regards, Ruslan.