Article_attachment error

[sometin]

hi,

otrs was working fine when out of the blue all new attachments stopped comming... some emails cant be opened either... the logs show an error with the id here is an abstract of the log starting with where i believe the problem is:

MSWin32 Time: Thu Mar 22 12:34:58 2012

Message: Duplicate entry '148017' for key 'PRIMARY', SQL: 'INSERT INTO article_attachment (article_id, filename, content_type, content_size, content, content_id, content_alternative, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)'

Traceback (2480):
Module: Kernel::System::Ticket::ArticleStorageDB::ArticleWriteAttachment (v1.78.2.1) Line: 252
Module: Kernel::System::Ticket::Article::ArticleCreate (v1.274.2.3) Line: 265
Module: Kernel::Modules::AgentTicketActionCommon::Run (unknown version) Line: 660
Module: Kernel::System::Web::InterfaceAgent::Run (v1.58.2.1) Line: 853
Module: ModPerl::ROOT::ModPerl::Registry::T_3a_OTRS_OTRS_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 46
Module: (eval) (v1.89.2.1) Line: 204
Module: ModPerl::RegistryCooker::run (v1.89.2.1) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.89.2.1) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31

Scalars leaked: 1
Scalars leaked: 1
Scalars leaked: 1
Scalars leaked: 1
Scalars leaked: 1
Scalars leaked: 1
Scalars leaked: 1
Scalars leaked: 1
Scalars leaked: 1
Scalars leaked: 1
Scalars leaked: 1
Scalars leaked: 1

No idea what caused it, there was no power outage or restart... it was working fine yesterday... For now i am using MySQL query browser to change the table's auto increment figure to 148018 and its been doing that for the last 10 minutes... does anyone have any idea if the issue will be fixed once i skip the affected line?
And why did the auto increment not even work in the first place...?
Could it be even if i make it to 148018 the first attachment will get through and all others will get stuck at 148018 too...?

[sometin]

strange... it never completed it or maybe i was too impatient... so anyway i deleted the row which was causing the conflict but i still got the message
[Thu Mar 22 14:06:30 2012] -e: DBD::mysql::db do failed: Duplicate entry '148017' for key 'PRIMARY' at T:/OTRS/OTRS//Kernel/System/DB.pm line 422.
[Thu Mar 22 14:06:30 2012] -e: Use of uninitialized value in concatenation (.) or string at T:/OTRS/OTRS//Kernel/System/Log.pm line 161.
ERROR: OTRS-CGI-61 Perl: 5.12.3 OS: MSWin32 Time: Thu Mar 22 14:06:30 2012

Message: Duplicate entry '148017' for key 'PRIMARY', SQL: 'INSERT INTO article_attachment (article_id, filename, content_type, content_size, content, content_id, content_alternative, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)'

Traceback (2112):
Module: Kernel::System::Ticket::ArticleStorageDB::ArticleWriteAttachment (v1.78.2.1) Line: 252
Module: Kernel::System::PostMaster::FollowUp::Run (v1.67.2.1) Line: 316
Module: Kernel::System::PostMaster::Run (v1.85) Line: 318
Module: Kernel::System::MailAccount::POP3::Fetch (v1. Line: 201
Module: Kernel::System::MailAccount::MailAccountFetch (v1.16) Line: 386
Module: Kernel::Modules::AdminMailAccount::Run (v1.23) Line: 63
Module: Kernel::System::Web::InterfaceAgent::Run (v1.58.2.1) Line: 853
Module: ModPerl::ROOT::ModPerl::Registry::T_3a_OTRS_OTRS_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 46
Module: (eval) (v1.89.2.1) Line: 204
Module: ModPerl::RegistryCooker::run (v1.89.2.1) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.89.2.1) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31

[Thu Mar 22 14:06:47 2012] -e: Use of uninitialized value in lc at T:/OTRS/OTRS//Kernel/System/PostMaster/Filter/FollowUpArticleTypeCheck.pm line 55.

Back to changing auto increment figure...

[sometin]

well that fixed the issue!