[rt-users] DBD::mysql::st execute failed: MySQL server has goneaway at
Kobus Bensch
kbensch at fullnet.co.uk
Sun Oct 26 07:25:07 EDT 2008
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 <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
>>
>>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20081026/6ea42c59/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: kbensch.vcf
Type: text/x-vcard
Size: 179 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20081026/6ea42c59/attachment.vcf>
More information about the rt-users
mailing list