What flavor of Linux? Version?
-- Jeremy McSpadden On Feb 28, 2012, at 4:14 PM, "Kleber Rocha" <[email protected]<mailto:[email protected]>> wrote: Yes, already added, the error happens anyway. 2012/2/28 Jeremy McSpadden <[email protected]<mailto:[email protected]>> Add -U to your mailscanner # line. -- Jeremy McSpadden On Feb 28, 2012, at 4:11 PM, "Kleber Rocha" <[email protected]<mailto:[email protected]>> wrote: Only these erros of perl. In Debugging mode, not forking... Trying to setlogsock(unix) Building a message batch to scan... Have a batch of 1 message. Insecure dependency in open while running with -T switch at /usr/lib64/perl5/IO/File.pm line 185. Insecure dependency in open while running with -T switch at /usr/lib64/perl5/IO/File.pm line 185. Insecure dependency in open while running with -T switch at /usr/lib64/perl5/IO/File.pm line 188. Insecure dependency in open while running with -T switch at /usr/lib64/perl5/IO/File.pm line 185. Insecure dependency in open while running with -T switch at /usr/lib64/perl5/IO/File.pm line 185. Stopping now as you are debugging me. 2012/2/28 Jeremy McSpadden <[email protected]<mailto:[email protected]>> Looks ok. Now check logs as to why. What does debug output? -- Jeremy McSpadden On Feb 28, 2012, at 4:05 PM, "Kleber Rocha" <[email protected]<mailto:[email protected]>> wrote: [root@napmail01 tmp]# mysqlcheck -u root baruwa baruwa.archive OK baruwa.auth_group OK baruwa.auth_group_permissions OK baruwa.auth_hosts OK baruwa.auth_message OK baruwa.auth_permission OK baruwa.auth_user OK baruwa.auth_user_groups OK baruwa.auth_user_user_permissions OK baruwa.celery_taskmeta OK baruwa.celery_tasksetmeta OK baruwa.deliveryinfo OK baruwa.django_content_type OK baruwa.django_session OK baruwa.djcelery_crontabschedule OK baruwa.djcelery_intervalschedule OK baruwa.djcelery_periodictask OK baruwa.djcelery_periodictasks OK baruwa.djcelery_taskstate OK baruwa.djcelery_workerstate OK baruwa.domain_signatures OK baruwa.lists OK baruwa.mail_hosts OK baruwa.mailq OK baruwa.message_recipients OK baruwa.messages OK baruwa.profiles OK baruwa.quarantine_releases OK baruwa.report_filters OK baruwa.sa_rules OK baruwa.scanner_config OK baruwa.scanner_config_sections OK baruwa.scanners OK baruwa.signature_imgs OK baruwa.south_migrationhistory OK baruwa.user_addresses OK baruwa.user_signatures OK 2012/2/28 Jeremy McSpadden <[email protected]<mailto:[email protected]>> Looks like its not ok. Have you checked the db? to server failed, using backup -- Jeremy McSpadden On Feb 28, 2012, at 4:01 PM, "Kleber Rocha" <[email protected]<mailto:[email protected]>> wrote: Why this happens? Feb 28 07:14:17 napmail01 MailScanner[30376]: Baruwa: Sending message 102DEAC33CA.A8F82 to server failed, using backup Feb 28 07:14:17 napmail01 MailScanner[30376]: Baruwa: 102DEAC33CA.A8F82: Logged using backup DB The MySQL server is ok and running. Thanks 2012/2/28 Mikael Syska <[email protected]<mailto:[email protected]>> http://baruwa.org/docs/batteries_included.html#database-maintenance mvh Mikael Syska On Tue, Feb 28, 2012 at 9:47 PM, Kleber Rocha <[email protected]<mailto:[email protected]>> wrote: > I understanding the export, but how can I archive messages tables, to avoid > that table growing? > Rename table and create new table with the properties of old table? > > > Thanks > > 2012/2/28 Jeremy McSpadden <[email protected]<mailto:[email protected]>> >> >> mysqldump –uUSER –pPASSWORD DBNAME > /tmp/backup.sql >> >> Login to mysql >> drop database DBNAME; >> create database DBNAME; >> Logout >> >> mysql –uUSER-pPASSWORD DBNAME < /tmp/backup.sql >> >> >> Problem you'll run out of memory real quick doing this import. 24gb db >> file .. good luck with that >> >> -- >> Jeremy McSpadden >> Flux Labs, Inc >> http://www.fluxlabs.net >> Endless Solutions >> Office : 850-588-4626<tel:850-588-4626> >> Cell : 850-890-2543<tel:850-890-2543> >> Fax : 850-254-2955<tel:850-254-2955> >> >> From: Kleber Rocha <[email protected]<mailto:[email protected]>> >> Reply-To: Baruwa list >> <[email protected]<mailto:[email protected]>> >> Date: Tue, 28 Feb 2012 17:37:44 -0300 >> To: Baruwa list <[email protected]<mailto:[email protected]>> >> Subject: Re: [Baruwa] Duplicate Entry >> >> I don't understanding, I have to create dump? how can I export this table? >> >> Thanks >> >> 2012/2/28 Jeremy McSpadden <[email protected]<mailto:[email protected]>> >>> >>> Export and start over :) >>> >>> >>> -- >>> Jeremy McSpadden >>> >>> On Feb 28, 2012, at 2:34 PM, "Kleber Rocha" >>> <[email protected]<mailto:[email protected]>> wrote: >>> >>> How can I archive this? >>> >>> Thanks >>> >>> 2012/2/28 Jeremy McSpadden <[email protected]<mailto:[email protected]>> >>>> >>>> You can't. Unless you want to go ID by ID .. And manually delete them. >>>> I'm pretty sure you'll have more than a few. >>>> >>>> Why is your DB 24gb? Why don't you archive the database >>>> >>>> >>>> -- >>>> Jeremy McSpadden >>>> >>>> On Feb 28, 2012, at 2:25 PM, "Kleber Rocha" >>>> <[email protected]<mailto:[email protected]>> wrote: >>>> >>>> Jeremy, >>>> >>>> Thanks for the reply. >>>> >>>> But this table has 24GB, how can I avoid this issue? >>>> >>>> Thanks. >>>> >>>> >>>> 2012/2/28 Jeremy McSpadden >>>> <[email protected]<mailto:[email protected]>> >>>>> >>>>> Export the table, then reimport. Will re-index on import. >>>>> >>>>> >>>>> -- >>>>> Jeremy McSpadden >>>>> >>>>> On Feb 28, 2012, at 2:02 PM, "Kleber Rocha" >>>>> <[email protected]<mailto:[email protected]>> wrote: >>>>> >>>>> > Hi, >>>>> > >>>>> > I have many errors like: >>>>> > >>>>> > Duplicate entry '7AF82AC3AF1.A5D3F' for key 'PRIMARY' error 1062 >>>>> > recorded: Duplicate entry '7AF82AC3AF1.A5D3F' for key 'PRIMARY' >>>>> > >>>>> > >>>>> > How can I fix this? >>>>> > >>>>> > Thanks >>>>> > _______________________________________________ >>>>> > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>>>> >>>>> _______________________________________________ >>>>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>>> >>>> >>>> _______________________________________________ >>>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>>> >>>> >>>> _______________________________________________ >>>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>>> >>> >>> _______________________________________________ >>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>> >>> >>> _______________________________________________ >>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>> >> >> _______________________________________________ Keep Baruwa FREE - >> http://pledgie.com/campaigns/12056 >> >> _______________________________________________ >> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >> > > > _______________________________________________ > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
_______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
