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 > > > > > > _______________________________________________ > 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 > > > -- > > > > > > 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: [EMAIL PROTECTED] > > Information: [EMAIL PROTECTED]> > > Sales Team: [EMAIL PROTECTED] > > 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] with the subject "Sales Query!". > > _______________________________________________ > 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 > > > > > > -- > > > > > > 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: [EMAIL PROTECTED] > > Information: [EMAIL PROTECTED]> > > Sales Team: [EMAIL PROTECTED] > > 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] with the subject "Sales Query!". > > _______________________________________________ > 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 >
-- Best regards, Ruslan. _______________________________________________ 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