Sehr geehrte Damen und Herren,
in der Zeit vom 02.11.2018 bis einschließlich 18.11.2018 befinde ich mich nicht
im Büro.
Beachten Sie bitte, dass Ihre E-Mail nicht automatisch weitergeleitet wird.
In dringenden Fällen wenden Sie sich bitte an unsere Hotline, 0203-378530, oder
an Herrn Hesselmann (hesselm...@opm-computer.de).
Mit freundlichen Grüßen
Ronny Bär
OPM IT Service GmbH
Send otrs mailing list submissions to
otrs@lists.otrs.org
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.otrs.org/mailman/listinfo/otrs
or, via email, send a message with subject or body 'help' to
otrs-requ...@lists.otrs.org
You can reach the person managing the list at
otrs-ow...@lists.otrs.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of otrs digest..."
Today's Topics:
1. Re: Mysql Timeouts? (=?UTF-8?B?TFEgTWFyc2hhbGw=?=)
2. Fail to update DB to 6 (Alvaro Cordero)
3. Can I use upgraded DB on new code install? (Mike Morris)
4. Re: Can I use upgraded DB on new code install? (Gerald Young)
----------------------------------------------------------------------
Message: 1
Date: Mon, 29 Oct 2018 12:10:31 -0700
From: "=?UTF-8?B?TFEgTWFyc2hhbGw=?=" <qmarsh...@inetspace.net>
To: "User questions and discussions about OTRS." <otrs@lists.otrs.org>
Subject: Re: [otrs] Mysql Timeouts?
Message-ID: <mailman.1009.1541737606.22665.o...@lists.otrs.org>
Content-Type: text/plain; charset="utf-8"
MartinExamine Mysql for connectivity/performance issues - Check mysql logs.L.Q.
MarshallOne's strength is only determined when the challenge seems
overwhelming.<div>
</div><div>
</div><!-- originalMessage --><div>-------- Original message
--------</div><div>From: Hochreiter Martin <martin.hochrei...@fhstp.ac.at>
</div><div>Date: 10/29/18 07:46 (GMT-07:00) </div><div>To:
otrs@lists.otrs.org </div><div>Subject: [otrs] Mysql Timeouts? </div><div>
</div>
Dear members,
I have a strange syslog on Ubuntu 18.04:
otrs Aborted connection XXX to db: Got timeout reading communication
OTRS seems to be working - how can I solve that?
Kind regards
_____________________
DI (FH) Martin Hochreiter
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.otrs.org/pipermail/otrs/attachments/20181029/4908b057/attachment.html>
------------------------------
Message: 2
Date: Fri, 2 Nov 2018 15:15:04 -0600
From: Alvaro Cordero <alv...@gridshield.net>
To: "User questions and discussions about OTRS." <otrs@lists.otrs.org>
Subject: [otrs] Fail to update DB to 6
Message-ID:
<CAKzf-ZPHrKXhTK-UD5EuADm58-Dyrk0vS=imu3dbv3uthc1...@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
Hello,
I am running a migration process of an OTRS 5.0.30 to OTRS 6.0.12 on CentOS
7 with MariaDB and during DB-Migrate-to-6 execution I get the following
error. The first time I ran, it told me there were some orphaned articles
and some orphaned tags and asked to delete them.
I tried reloading the original Database and those orphaned messages
disappeared but It keeps giving the error.
Step 29 of 42: Post changes on article related tables ...
[Fri Nov 2 21:07:29 2018] DBUpdate-to-6.pl: DBD::mysql::db do failed:
Cannot add or update a child row: a foreign key constraint fails
(`otrs`.`#sql-955_4c109`, CONSTRAINT `FK_article_data_mime_create_by_id`
FOREIGN KEY (`create_by`) REFERENCES `users` (`id`)) at
/opt/otrs/Kernel/System/DB.pm line 470.
ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-1 Perl: 5.16.3 OS: linux
Time: Fri Nov 2 21:07:29 2018
Message: Cannot add or update a child row: a foreign key constraint fails
(`otrs`.`#sql-955_4c109`, CONSTRAINT `FK_article_data_mime_create_by_id`
FOREIGN KEY (`create_by`) REFERENCES `users` (`id`)), SQL: 'EXECUTE
FKStatement'
Traceback (123074):
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 394
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 342
Module:
scripts::DBUpdateTo6::PostArticleTableStructureChanges::_UpdateArticleDataMimeTable
Line: 286
Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::Run
Line: 52
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
Module: scripts::DBUpdateTo6::Run Line: 69
Module: scripts/DBUpdate-to-6.pl Line: 87
ERROR: OTRS-otrs.Console.pl-Maint::Database::Check-1 Perl: 5.16.3 OS: linux
Time: Fri Nov 2 21:07:29 2018
Message: Error during execution of 'EXECUTE FKStatement'!
Traceback (123074):
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBString Line: 397
Module: scripts::DBUpdateTo6::Base::ExecuteXMLDBArray Line: 342
Module:
scripts::DBUpdateTo6::PostArticleTableStructureChanges::_UpdateArticleDataMimeTable
Line: 286
Module: scripts::DBUpdateTo6::PostArticleTableStructureChanges::Run
Line: 52
Module: scripts::DBUpdateTo6::_ExecuteComponent Line: 157
Module: scripts::DBUpdateTo6::Run Line: 69
Module: scripts/DBUpdate-to-6.pl Line: 87
Not possible to complete migration, check previous messages for more
information.
--
*Alvaro Cordero RetanaConsultor de Tecnologias*
*Tel: 22585757 ext 123*
*Email:* alv...@gridshield.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.otrs.org/pipermail/otrs/attachments/20181102/c00c72cd/attachment-0001.html>
------------------------------
Message: 3
Date: Thu, 8 Nov 2018 17:35:30 -0800
From: Mike Morris <m...@musicplace.com>
To: otrs@lists.otrs.org
Subject: [otrs] Can I use upgraded DB on new code install?
Message-ID: <a17a6d17-db40-1ca7-2f94-7a6871470...@musicplace.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Hi,
I have an old (3.x) installation that I want to migrate to current 6.x.
Can I run the DB upgrade scripts from all intermediate versions against
my database, and then expect that upgraded database to work on a brand
new installation? (Assuming I handle migration of the config files to
the new install, of course.)
I don't see why this wouldn't work, but thought I should at least ask
the experts...
Thanks in advance,
Mike Morris
------------------------------
Message: 4
Date: Thu, 8 Nov 2018 23:26:31 -0500
From: Gerald Young <cryth...@gmail.com>
To: "User questions and discussions about OTRS." <otrs@lists.otrs.org>
Subject: Re: [otrs] Can I use upgraded DB on new code install?
Message-ID:
<cakk-oulpv+n4_-e9w_ymm6vmlcuqdld1_su4ogc9xwq10ex...@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
In theory, yes, for vanilla code. but it's a bit more complicated than
simply run the database scripts.
http://doc.otrs.com/doc/manual/admin/4.0/en/html/upgrading.html
http://doc.otrs.com/doc/manual/admin/5.0/en/html/upgrading.html
http://doc.otrs.com/doc/manual/admin/stable/en/html/updating.html
Note that any customizations in code and plugins will very likely not work
if they're referenced, and not upgraded as well or available. For instance
in Kernel/Config.pm or Kernel/Config/Files/.
And always use the latest patch level for each revision to upgrade
(3.1.latest -> 3.3.latest)
Make sure you have SQL backups for each step, and it'd be preferred to do a
dry run against another install out of production. Yes, then you can
restore that backup to new production version.
Also, what I've found in mysql backup is that I've had better luck with
backups when using mysqldump --hex-blob. This makes a larger dump file, but
it also made my restore less likely to fail.
https://stackoverflow.com/questions/16559086/does-mysqldump-handle-binary-data-reliably
Also, make sure your max_allowed_packet is fairly large in [mysqld] so your
import won't die.
On Thu, Nov 8, 2018 at 8:36 PM Mike Morris <m...@musicplace.com> wrote:
> Hi,
>
> I have an old (3.x) installation that I want to migrate to current 6.x.
>
> Can I run the DB upgrade scripts from all intermediate versions against
> my database, and then expect that upgraded database to work on a brand
> new installation? (Assuming I handle migration of the config files to
> the new install, of course.)
>
> I don't see why this wouldn't work, but thought I should at least ask
> the experts...
>
> Thanks in advance,
>
> Mike Morris
>
> ---------------------------------------------------------------------
> OTRS mailing list: otrs - Webpage: http://otrs.org/
> Archive: http://lists.otrs.org/pipermail/otrs
> To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.otrs.org/pipermail/otrs/attachments/20181108/d86c1f05/attachment.html>
------------------------------
Subject: Digest Footer
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
------------------------------
End of otrs Digest, Vol 122, Issue 1
************************************
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs
