OTRS entfernt Anhänge

[Rocky]

Guten Morgen,
wenn ich meine Support Postfächer abrufe, entfernt mir OTRS im Ticket die Anhänge. An was kann das liegen?

Viele Grüße
Matthias

[reneeb]

Das macht OTRS eigentlich nicht. Was sind das für Anhänge (haben die alle einen bestimmten Namen, sind die von einem bestimmten Typ)? Kannst Du ausschließen, dass der Mailserver das schon macht?

[Rocky]

Es handelt sich ganz normal um PDFs und so. Bis Freitag hat er es ohne Probleme gemacht.

[reneeb]

Hast Du den Mailserver mal geprüft? Hast Du Code-Änderungen vorgenommen oder Module installiert? Was hat sich seit Freitag geändert?

[Rocky]

Da einzigste, was wir geändert haben ist die VMware geclont auf eine größere Platte. Aber auch am Freitag ging es ohne Probleme.

[reneeb]

Taucht was in den Logs auf? Hast Du eine Testumgebung, in der Du das Verhalten nachstellen kannst? Hast Du eine Originalmail (inkl. Anhang) als Quelltext vorliegen? Dann könntest Du die zum Test mal eine Mail "per Hand" (cat <Mailbody> | perl bin/otrs.PostMaster.pl, wobei <Mailbody> der Pfad zur Datei mit dem Mailquelltext ist) reinschieben.

[Rocky]

Es fehlen mir alle Anlagen die im OTRS waren

[reneeb]

Ihr speichert die Anhänge auf Platte, richtig? Stimmt die Einstellung in der SysConfig noch? Habt ihr das <OTRS_HOME>/var/article/ Verzeichnis mit umgezogen? Passen die Berechtigungen? Was sagen die Logs?

[Rocky]

So der erste Auszug von Logs (kam beim Neustart der Services)

Message: NOTICE: otrs.Shceduler4win.pl is registered on the DB, but the registr
y has not been updated in 355974 seconds!. The register will be deleted so Sched
uler can start again without forcing

Traceback (6476):
Module: main::_AutoStop (v1.22) Line: 685
Module: C:/PROGRA~1/OTRS/OTRS/bin/otrs.Scheduler4win.pl (v1.22) Line: 213

Drücken Sie eine beliebige Taste . . .

LOG Auszug
[Tue Jan 7 11:35:02 2014][Error][main::_AutoStop][685] NOTICE: otrs.Shceduler4win.pl is registered on the DB, but the registry has not been updated in 355974 seconds!. The register will be deleted so Scheduler can start again without forcing
[Tue Jan 7 11:35:03 2014][Notice][main::_start] Scheduler Service is starting...!
[Tue Jan 7 11:35:04 2014][Notice][main::_start] Scheduler Service start! PID 6440
[Tue Jan 7 11:35:11 2014][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndexRaw][376] Table '.\otrs\article_attachment' is marked as crashed and should be repaired, SQL: 'SELECT filename, content_type, content_size, content_id, content_alternative FROM article_attachment WHERE article_id = ? ORDER BY filename, id'
[Tue Jan 7 11:35:11 2014][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndexRaw][376] Table '.\otrs\article_attachment' is marked as crashed and should be repaired, SQL: 'SELECT filename, content_type, content_size, content_id, content_alternative FROM article_attachment WHERE article_id = ? ORDER BY filename, id'
[Tue Jan 7 11:35:11 2014][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndexRaw][376] Table '.\otrs\article_attachment' is marked as crashed and should be repaired, SQL: 'SELECT filename, content_type, content_size, content_id, content_alternative FROM article_attachment WHERE article_id = ? ORDER BY filename, id'
[Tue Jan 7 11:35:11 2014][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndexRaw][376] Table '.\otrs\article_attachment' is marked as crashed and should be repaired, SQL: 'SELECT filename, content_type, content_size, content_id, content_alternative FROM article_attachment WHERE article_id = ? ORDER BY filename, id'
[Tue Jan 7 11:35:11 2014][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndexRaw][376] Table '.\otrs\article_attachment' is marked as crashed and should be repaired, SQL: 'SELECT filename, content_type, content_size, content_id, content_alternative FROM article_attachment WHERE article_id = ? ORDER BY filename, id'
[Tue Jan 7 11:35:11 2014][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndexRaw][376] Table '.\otrs\article_attachment' is marked as crashed and should be repaired, SQL: 'SELECT filename, content_type, content_size, content_id, content_alternative FROM article_attachment WHERE article_id = ? ORDER BY filename, id'
[Tue Jan 7 11:35:11 2014][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndexRaw][376] Table '.\otrs\article_attachment' is marked as crashed and should be repaired, SQL: 'SELECT filename, content_type, content_size, content_id, content_alternative FROM article_attachment WHERE article_id = ? ORDER BY filename, id'
[Tue Jan 7 11:35:11 2014][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndexRaw][376] Table '.\otrs\article_attachment' is marked as crashed and should be repaired, SQL: 'SELECT filename, content_type, content_size, content_id, content_alternative FROM article_attachment WHERE article_id = ? ORDER BY filename, id'
[Tue Jan 7 11:35:11 2014][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndexRaw][376] Table '.\otrs\article_attachment' is marked as crashed and should be repaired, SQL: 'SELECT filename, content_type, content_size, content_id, content_alternative FROM article_attachment WHERE article_id = ? ORDER BY filename, id'
[Tue Jan 7 11:35:11 2014][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndexRaw][376] Table '.\otrs\article_attachment' is marked as crashed and should be repaired, SQL: 'SELECT filename, content_type, content_size, content_id, content_alternative FROM article_attachment WHERE article_id = ? ORDER BY filename, id'
[Tue Jan 7 11:35:11 2014][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndexRaw][376] Table '.\otrs\article_attachment' is marked as crashed and should be repaired, SQL: 'SELECT filename, content_type, content_size, content_id, content_alternative FROM article_attachment WHERE article_id = ? ORDER BY filename, id'
[Tue Jan 7 11:35:11 2014][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndexRaw][376] Table '.\otrs\article_attachment' is marked as crashed and should be repaired, SQL: 'SELECT filename, content_type, content_size, content_id, content_alternative FROM article_attachment WHERE article_id = ? ORDER BY filename, id'
[Tue Jan 7 11:35:11 2014][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndexRaw][376] Table '.\otrs\article_attachment' is marked as crashed and should be repaired, SQL: 'SELECT filename, content_type, content_size, content_id, content_alternative FROM article_attachment WHERE article_id = ? ORDER BY filename, id'
[Tue Jan 7 11:35:11 2014][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndexRaw][376] Table '.\otrs\article_attachment' is marked as crashed and should be repaired, SQL: 'SELECT filename, content_type, content_size, content_id, content_alternative FROM article_attachment WHERE article_id = ? ORDER BY filename, id'
[Tue Jan 7 11:35:11 2014][Notice][Kernel::System::Web::InterfaceAgent::Run] Response::Agent: 1s taken (URL:Action=AgentTicketZoom;TicketID=4926:name)
[Tue Jan 7 11:35:15 2014][Notice][Kernel::System::Web::InterfaceAgent::Run] Response::Agent: 1s taken (URL:Action=AgentTicketZoom&Subaction=MarkAsSeen:name)
[Tue Jan 7 11:35:15 2014][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndexRaw][376] Table '.\otrs\article_attachment' is marked as crashed and should be repaired, SQL: 'SELECT filename, content_type, content_size, content_id, content_alternative FROM article_attachment WHERE article_id = ? ORDER BY filename, id'
[Tue Jan 7 11:35:15 2014][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndexRaw][376] Table '.\otrs\article_attachment' is marked as crashed and should be repaired, SQL: 'SELECT filename, content_type, content_size, content_id, content_alternative FROM article_attachment WHERE article_id = ? ORDER BY filename, id'
[Tue Jan 7 11:35:15 2014][Notice][Kernel::System::Web::InterfaceAgent::Run] Response::Agent: 0s taken (URL:Action=AgentTicketZoom&Subaction=ArticleUpdate:pfender)
[Tue Jan 7 11:35:19 2014][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndexRaw][376] Table '.\otrs\article_attachment' is marked as crashed and should be repaired, SQL: 'SELECT filename, content_type, content_size, content_id, content_alternative FROM article_attachment WHERE article_id = ? ORDER BY filename, id'
[Tue Jan 7 11:35:19 2014][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndexRaw][376] Table '.\otrs\article_attachment' is marked as crashed and should be repaired, SQL: 'SELECT filename, content_type, content_size, content_id, content_alternative FROM article_attachment WHERE article_id = ? ORDER BY filename, id'

[jojo]

steht doch alles in der Log Meldung....

[Rocky]

Kompletter LOG

[jojo]

Table '.\otrs\article_attachment' is marked as crashed and should be repaired, SQL: 'SELECT filename, content_type, content_size, content_id, content_alternative FROM article_attachment WHERE article_id = ? ORDER BY filename, id'

[KlausNehrer]

[Tue Jan 7 11:35:11 2014][Error][Kernel::System::Ticket::ArticleStorageDB::ArticleAttachmentIndexRaw][376] Table '.\otrs\article_attachment' is marked as crashed and should be repaired, SQL: 'SELECT filename, content_type, content_size, content_id, content_alternative FROM article_attachment WHERE article_id = ? ORDER BY filename, id'

http://blog.emeidi.com/2007/09/13/mysql ... -repaired/

[Rocky]

Perfekt danke. Mit repair table hat alles wieder funktioniert.