<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
No, because the previous server had the same version of MySQL as the
new one.<br>
<br>
Ruslan Zakirov wrote:
<blockquote
cite="mid:589c94400810241341r80963b6ua4a115467e4a6841@mail.gmail.com"
type="cite">
<pre wrap="">Have you done steps from UPGRADING.mysql?
On Sat, Oct 25, 2008 at 12:08 AM, Kobus Bensch <a class="moz-txt-link-rfc2396E" href="mailto:kbensch@fullnet.co.uk"><kbensch@fullnet.co.uk></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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.
<a class="moz-txt-link-abbreviated" href="mailto:chaim.rieger@gmail.com">chaim.rieger@gmail.com</a> wrote:
Anything in the mysql logs ?
Sent via BlackBerry from T-Mobile
-----Original Message-----
From: Kobus Bensch - No Sig <a class="moz-txt-link-rfc2396E" href="mailto:kbensch@fullnet.co.uk"><kbensch@fullnet.co.uk></a>
Date: Fri, 24 Oct 2008 21:01:27
To: Curtis Bruneau<a class="moz-txt-link-rfc2396E" href="mailto:curtisb@vianet.ca"><curtisb@vianet.ca></a>
Cc: <a class="moz-txt-link-rfc2396E" href="mailto:rt-users@lists.bestpractical.com"><rt-users@lists.bestpractical.com></a>
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: <a class="moz-txt-link-abbreviated" href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com</a>
[<a class="moz-txt-link-freetext" href="mailto:rt-users-bounces@lists.bestpractical.com">mailto:rt-users-bounces@lists.bestpractical.com</a>] 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)
_______________________________________________
<a class="moz-txt-link-freetext" href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a>
Community help: <a class="moz-txt-link-freetext" href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a>
Commercial support: <a class="moz-txt-link-abbreviated" href="mailto:sales@bestpractical.com">sales@bestpractical.com</a>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at <a class="moz-txt-link-freetext" href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a>
_______________________________________________
<a class="moz-txt-link-freetext" href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a>
Community help: <a class="moz-txt-link-freetext" href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a>
Commercial support: <a class="moz-txt-link-abbreviated" href="mailto:sales@bestpractical.com">sales@bestpractical.com</a>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at <a class="moz-txt-link-freetext" href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a>
--
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: <a class="moz-txt-link-abbreviated" href="mailto:kbensch@fullnet.co.uk">kbensch@fullnet.co.uk</a>
Information: <a class="moz-txt-link-abbreviated" href="mailto:info@fullnet.co.uk">info@fullnet.co.uk</a>>
Sales Team: <a class="moz-txt-link-abbreviated" href="mailto:fslsales@fullnet.co.uk">fslsales@fullnet.co.uk</a>
WWW: <a class="moz-txt-link-freetext" href="http://www.fullnet.co.uk">http://www.fullnet.co.uk</a>
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 <a class="moz-txt-link-abbreviated" href="mailto:admin@fullnet.co.uk">admin@fullnet.co.uk</a> 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 <a class="moz-txt-link-abbreviated" href="mailto:info@fullnet.co.uk">info@fullnet.co.uk</a> 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 <a class="moz-txt-link-abbreviated" href="mailto:sales@fullnet.co.uk">sales@fullnet.co.uk</a> with the subject "Sales Query!".
_______________________________________________
<a class="moz-txt-link-freetext" href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a>
Community help: <a class="moz-txt-link-freetext" href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a>
Commercial support: <a class="moz-txt-link-abbreviated" href="mailto:sales@bestpractical.com">sales@bestpractical.com</a>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at <a class="moz-txt-link-freetext" href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a>
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<title>Fullnet Solutions Limited</title>
<meta http-equiv="Content-Type" content="text/html; ">
<br>
<table align="center" border="0" width="99%">
<tbody>
<tr>
<td align="center" width="33%">
<p> </p>
<p><img src="cid:part1.00000806.02060507@fullnet.co.uk"></p>
<p> </p>
</td>
<td width="33%">7 Marlborough Close<br>
Maidenhead<br>
Berkshire<br>
SL6 4LP<br>
United Kingdom<br>
<br>
Telephone: +44 (01628) 675 978<br>
Facsimile: +44 (07092) 289 990<br>
Mobile Phone: +44 (07703) 503 733<br>
Skype ID: <a href="skype:fullnetsolutionsltd?call">fullnetsolutionsltd</a></td>
<td width="33%">Kobus Bensch: <a
href="mailto:kbensch@fullnet.co.uk">kbensch@fullnet.co.uk</a><br>
<br>
Information: <a href="mailto:info@fullnet.co.uk">info@fullnet.co.uk></a><br>
<br>
Sales Team: <a href="mailto:fslsales@fullnet.co.uk">fslsales@fullnet.co.uk</a><br>
<br>
WWW: <a href="http://www.fullnet.co.uk">http://www.fullnet.co.uk</a><br>
<br>
Registered in England & Wales, Company Number 3568937<br>
<br>
VAT registration number: UK 714 7309 42</td>
</tr>
<tr>
<td colspan="3" align="center" width="33%">
<p>E & O.E. All prices exclude VAT & Carriage unless
otherwise specified.</p>
</td>
</tr>
<tr>
<td colspan="3" align="center" width="33%">
<p>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 <a
href="mailto:admin@fullnet.co.uk?subject=eMail%20Confidentiality%20Query%21">
admin@fullnet.co.uk with the subject "eMail Confidentiality Query!"</a>.</p>
<p>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 <a
href="mailto:info@fullnet.co.uk?subject=eMail%20Comment/Complaint%20Query%21">
info@fullnet.co.uk with the subject "eMail Comment/Complaint Query!"</a>.</p>
<p>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 <a
href="mailto:fslsales@fullnet.co.uk?subject=Sales%20Query%21">
sales@fullnet.co.uk with the subject "Sales Query!"</a>.</p>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>