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

Fri Oct 24 16:49:42 EDT 2008

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.
>
>
>
> 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 <skype:fullnetsolutionsltd?call> 	Kobus 
> Bensch: kbensch at fullnet.co.uk <mailto:kbensch at fullnet.co.uk>
>
> Information: info at fullnet.co.uk> <mailto:info at fullnet.co.uk>
>
> Sales Team: fslsales at fullnet.co.uk <mailto: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!" 
> <mailto:admin at fullnet.co.uk?subject=eMail%20Confidentiality%20Query%21>.
>
> 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!" 
> <mailto:info at fullnet.co.uk?subject=eMail%20Comment/Complaint%20Query%21>.
>
> 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!" 
> <mailto:fslsales at fullnet.co.uk?subject=Sales%20Query%21>.
>