Greetings, We had an old 2.0.x otrs setup running relatively smoothly (if slow since the DB was huge) with PostgreSQL for many years.
The decision was made to switch to MySQL and start afresh with the latest otrs - the idea being to be as standard as possible to avoid problems, etc. Anywho, most things seem fine and dandy, except random SQL problems when replying/adding notes/etc. The error will typically be something like: ------------------------------------ Error: MySQL server has gone away, SQL: 'INSERT INTO article_plain (article_[..] Traceback: ERROR: OTRS-CGI-22 Perl: 5.8.8 OS: linux Time: Fri Apr 23 10:32:32 2010 Message: MySQL server has gone away, SQL: 'INSERT INTO article_plain (article_id, body, create_time, create_by, change_time, change_by) VALUES (?, ?, current_timestamp, ?, current_timestamp, ?)' Traceback (18328): Module: Kernel::System::Ticket::ArticleStorageDB::ArticleWritePlain (v1.68) Line: 213 Module: Kernel::System::Ticket::Article::ArticleSend (v1.232.2.1) Line: 2040 Module: Kernel::Modules::AgentTicketForward::SendEmail (v1.54.2.2) Line: 624 Module: Kernel::Modules::AgentTicketForward::Run (v1.54.2.2) Line: 88 Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line: 819 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 48 Module: (eval) (v1.88) Line: 204 Module: ModPerl::RegistryCooker::run (v1.88) Line: 204 Module: ModPerl::RegistryCooker::default_handler (v1.88) Line: 170 Module: ModPerl::Registry::handler (v1.99) Line: 31 ------------------------------------ The email (eg) to a customer will be sent, the note/article will be added to the database, but these irritating error messages will pop up randomly. Does anyone know what the hell this is all about? Alternatively, please direct me to the relevant log files which might help me figure out what I've done wrong. Thanks Henry --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
