Hi Everyone,
I have a strange database error. Last night I filled my partition with the Database on it and started getting an error from the Cron job. So I cleaned up my partition a bit, checked a manual insert on the table, and everything worked great, however I still get the error:
DBD::mysql::db do failed: The table 'article_plain' is full at /home/otrs/Kernel/System/DB.pm line 380.
ERROR: OTRS-PM3-10 Perl: 5.8.4 OS: linux Time: Tue Jan 22 16:50:02 2008
Message: The table 'article_plain' is full, SQL: 'INSERT INTO article_plain (article_id, body, create_time, create_by, change_time, change_by) VALUES (31041, ?, current_timestamp, 1, current_timestamp, 1)'
Traceback (11718):
Module: Kernel::System::Ticket::ArticleStorageDB::ArticleWritePlain (v1.36) Line: 208
Module: Kernel::System::PostMaster::NewTicket::Run (v1.57) Line: 268
Module: Kernel::System::PostMaster::Run (v1.60) Line: 246
Module: main::FetchMail (v1.23) Line: 207
Module: /home/otrs//bin/PostMasterPOP3.pl (v1.23) Line: 126
Or if I try and send a message:
ERROR: OTRS-CGI-10 Perl: 5.8.4 OS: linux Time: Wed Jan 23 10:07:30 2008
Message: The table 'article_plain' is full, SQL: 'INSERT INTO article_plain (article_id, body, create_time, create_by, change_time, change_by) VALUES (31125, ?, current_timestamp, 2, current_timestamp, 2)'
Traceback (24485):
Module: Kernel::System::Ticket::ArticleStorageDB::ArticleWritePlain (v1.36) Line: 208
Module: Kernel::System::Ticket::Article::ArticleSend (v1.128) Line: 1564
Module: Kernel::Modules::AgentTicketCompose::Run (v1.21) Line: 353
Module: Kernel::System::Web::InterfaceAgent::Run (v1.17) Line: 671
Module: /home/otrs/bin/cgi-bin/index.pl (v1.81) Line: 47
However, the message does go to the recipient AND it gets logged into the ticket and I can follow the history.
Anyone got any ideas?
Graham Strang
d 403-450-3629 c 403-978-6706
--------------------------------------------------
Ice Edge Business Solutions
7303 - 30th Street SE, Calgary, AB T2C 1N6
t 800.605.6707 f 403.723.6644 www.ice-edge.com