Sounds like whatever you fed it from (not knowing what you are using to jam stuff in there) had some sort of issues. File's corrupt, you can dump it out textually with spamdb and re-create it, or blow it away and start over.
On Mon, Jun 9, 2014 at 7:17 AM, Kamil Andrusz <[email protected]> wrote: > Hi list! > > I’ve done an upgrade to a more recent snapshot (Jun 6), it did not fix the > issue. I’ve also noticed that adding IP addresses manually (via "spamdb -a”) > does not work. I’ve installed the same snapshot in a virtual machine, > replicated the spamd config and it works just fine, so I’m assuming there > must be something broken on the server itself. If I copy /var/db/spamd from > the server to the VM, I cannot add any entries as well. > > I’d really appreciate any hints on how to debug this issue. > > Regards, > Kamil Andrusz > -- > It's just a matter of opinion. > > On 5 cze 2014, at 15:36, [email protected] wrote: > >>> Synopsis: Issues with spamd (/var/db/spamd corruption) >>> Category: spamd >>> Environment: >> System : OpenBSD 5.5 >> Details : OpenBSD 5.5-current (GENERIC.MP) #165: Mon Jun 2 >> 20:31:13 MDT 2014 >> >> [email protected]:/usr/src/sys/arch/amd64/compile/GENERIC.MP >> >> Architecture: OpenBSD.amd64 >> Machine : amd64 >>> Description: >> Fresh install machine running an amd64 snapshot from June 2nd. >> Has a standard spamd setup running but includes additional entries for >> bgp-spamd (as described on bgp-spamd.net) + one black and one white list. >> After some time there appears to be a corruption in the /var/db/spamd >> file, following entries appear in the logs, first time usually right after >> "queueing deletion of ..." message >> Jun 5 02:46:07 shwurzbung spamd[22638]: bogus entry in spamd database >> Jun 5 02:46:07 shwurzbung spamd[22638]: scan of /var/db/spamd failed >> >> I can provide the corrupt /var/db/spamd file on request along with the >> full logs (I don't want to sanitize the email addresses, as it may impact >> the debugging process) and other files that might be relevant. >> >> Contents of the /etc/mail/spamd.conf file: >> all:\ >> :uatraps:nixspam:spammers:spf: >> >> uatraps:\ >> :black:\ >> :msg="Your address %A has sent mail to a ualberta.ca spamtrap\n\ >> within the last 24 hours":\ >> :method=http:\ >> :file=www.openbsd.org/spamd/traplist.gz >> >> nixspam:\ >> :black:\ >> :msg="Your address %A is in the nixspam list\n\ >> See http://www.heise.de/ix/nixspam/dnsbl_en/ for details":\ >> :method=http:\ >> :file=www.openbsd.org/spamd/nixspam.gz >> >> bgp-spamd:\ >> :black:\ >> :msg="Your address %A has sent mail to a spamtrap\n\ >> within the last 24 hours":\ >> :method=file:\ >> :file=/var/db/spamd.black: >> >> spammers:\ >> :black:\ >> :msg="Lot's of crap received from your host":\ >> :method=file:\ >> :file=/var/db/spammers.txt: >> >> spf:\ >> :white:\ >> :method=file:\ >> :file=/var/db/spamd-spf.txt: >> >>> How-To-Repeat: >> Remove /var/db/spamd, restart spamd, wait. >>> Fix: >> No clue yet. >> >> >> dmesg: >> OpenBSD 5.5-current (GENERIC.MP) #165: Mon Jun 2 20:31:13 MDT 2014 >> [email protected]:/usr/src/sys/arch/amd64/compile/GENERIC.MP >> real mem = 17070387200 (16279MB) >> avail mem = 16607203328 (15837MB) >> mpath0 at root >> scsibus0 at mpath0: 256 targets >> mainbus0 at root >> bios0 at mainbus0: SMBIOS rev. 2.6 @ 0xeb170 (107 entries) >> bios0: vendor American Megatrends Inc. version "1006" date 08/11/2011 >> bios0: ASUSTeK Computer INC. P8H67-M PRO >> acpi0 at bios0: rev 2 >> acpi0: sleep states S0 S1 S3 S4 S5 >> acpi0: tables DSDT FACP APIC SSDT MCFG HPET >> acpi0: wakeup devices UAR1(S4) PS2K(S4) PS2M(S4) BR20(S3) EUSB(S4) USBE(S4) >> P0P3(S4) P0P4(S4) P0P1(S4) P0P2(S4) PEX0(S4) PEX1(S4) PEX2(S4) PEX3(S4) >> PEX4(S4) PEX5(S4) [...] >> acpitimer0 at acpi0: 3579545 Hz, 24 bits >> acpimadt0 at acpi0 addr 0xfee00000: PC-AT compat >> cpu0 at mainbus0: apid 0 (boot processor) >> cpu0: Intel(R) Core(TM) i7-2600 CPU @ 3.40GHz, 3411.90 MHz >> cpu0: >> FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CFLUSH,DS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE,SSE3,PCLMUL,DTES64,MWAIT,DS-CPL,VMX,SMX,EST,TM2,SSSE3,CX16,xTPR,PDCM,PCID,SSE4.1,SSE4.2,x2APIC,POPCNT,DEADLINE,AES,XSAVE,AVX,NXE,LONG,LAHF,PERF,ITSC >> cpu0: 256KB 64b/line 8-way L2 cache >> cpu0: smt 0, core 0, package 0 >> mtrr: Pentium Pro MTRR support, 10 var ranges, 88 fixed ranges >> cpu0: apic clock running at 100MHz >> cpu0: mwait min=64, max=64, C-substates=0.2.1.1.0, IBE >> cpu1 at mainbus0: apid 2 (application processor) >> cpu1: Intel(R) Core(TM) i7-2600 CPU @ 3.40GHz, 3411.49 MHz >> cpu1: >> FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CFLUSH,DS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE,SSE3,PCLMUL,DTES64,MWAIT,DS-CPL,VMX,SMX,EST,TM2,SSSE3,CX16,xTPR,PDCM,PCID,SSE4.1,SSE4.2,x2APIC,POPCNT,DEADLINE,AES,XSAVE,AVX,NXE,LONG,LAHF,PERF,ITSC >> cpu1: 256KB 64b/line 8-way L2 cache >> cpu1: smt 0, core 1, package 0 >> cpu2 at mainbus0: apid 4 (application processor) >> cpu2: Intel(R) Core(TM) i7-2600 CPU @ 3.40GHz, 3411.49 MHz >> cpu2: >> FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CFLUSH,DS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE,SSE3,PCLMUL,DTES64,MWAIT,DS-CPL,VMX,SMX,EST,TM2,SSSE3,CX16,xTPR,PDCM,PCID,SSE4.1,SSE4.2,x2APIC,POPCNT,DEADLINE,AES,XSAVE,AVX,NXE,LONG,LAHF,PERF,ITSC >> cpu2: 256KB 64b/line 8-way L2 cache >> cpu2: smt 0, core 2, package 0 >> cpu3 at mainbus0: apid 6 (application processor) >> cpu3: Intel(R) Core(TM) i7-2600 CPU @ 3.40GHz, 3411.49 MHz >> cpu3: >> FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CFLUSH,DS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE,SSE3,PCLMUL,DTES64,MWAIT,DS-CPL,VMX,SMX,EST,TM2,SSSE3,CX16,xTPR,PDCM,PCID,SSE4.1,SSE4.2,x2APIC,POPCNT,DEADLINE,AES,XSAVE,AVX,NXE,LONG,LAHF,PERF,ITSC >> cpu3: 256KB 64b/line 8-way L2 cache >> cpu3: smt 0, core 3, package 0 >> cpu4 at mainbus0: apid 1 (application processor) >> cpu4: Intel(R) Core(TM) i7-2600 CPU @ 3.40GHz, 3411.49 MHz >> cpu4: >> FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CFLUSH,DS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE,SSE3,PCLMUL,DTES64,MWAIT,DS-CPL,VMX,SMX,EST,TM2,SSSE3,CX16,xTPR,PDCM,PCID,SSE4.1,SSE4.2,x2APIC,POPCNT,DEADLINE,AES,XSAVE,AVX,NXE,LONG,LAHF,PERF,ITSC >> cpu4: 256KB 64b/line 8-way L2 cache >> cpu4: smt 1, core 0, package 0 >> cpu5 at mainbus0: apid 3 (application processor) >> cpu5: Intel(R) Core(TM) i7-2600 CPU @ 3.40GHz, 3411.49 MHz >> cpu5: >> FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CFLUSH,DS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE,SSE3,PCLMUL,DTES64,MWAIT,DS-CPL,VMX,SMX,EST,TM2,SSSE3,CX16,xTPR,PDCM,PCID,SSE4.1,SSE4.2,x2APIC,POPCNT,DEADLINE,AES,XSAVE,AVX,NXE,LONG,LAHF,PERF,ITSC >> cpu5: 256KB 64b/line 8-way L2 cache >> cpu5: smt 1, core 1, package 0 >> cpu6 at mainbus0: apid 5 (application processor) >> cpu6: Intel(R) Core(TM) i7-2600 CPU @ 3.40GHz, 3411.49 MHz >> cpu6: >> FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CFLUSH,DS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE,SSE3,PCLMUL,DTES64,MWAIT,DS-CPL,VMX,SMX,EST,TM2,SSSE3,CX16,xTPR,PDCM,PCID,SSE4.1,SSE4.2,x2APIC,POPCNT,DEADLINE,AES,XSAVE,AVX,NXE,LONG,LAHF,PERF,ITSC >> cpu6: 256KB 64b/line 8-way L2 cache >> cpu6: smt 1, core 2, package 0 >> cpu7 at mainbus0: apid 7 (application processor) >> cpu7: Intel(R) Core(TM) i7-2600 CPU @ 3.40GHz, 3411.49 MHz >> cpu7: >> FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,PSE36,CFLUSH,DS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE,SSE3,PCLMUL,DTES64,MWAIT,DS-CPL,VMX,SMX,EST,TM2,SSSE3,CX16,xTPR,PDCM,PCID,SSE4.1,SSE4.2,x2APIC,POPCNT,DEADLINE,AES,XSAVE,AVX,NXE,LONG,LAHF,PERF,ITSC >> cpu7: 256KB 64b/line 8-way L2 cache >> cpu7: smt 1, core 3, package 0 >> ioapic0 at mainbus0: apid 0 pa 0xfec00000, version 20, 24 pins >> acpimcfg0 at acpi0 addr 0xe0000000, bus 0-63 >> acpihpet0 at acpi0: 14318179 Hz >> acpiprt0 at acpi0: bus 0 (PCI0) >> acpiprt1 at acpi0: bus -1 (P0P3) >> acpiprt2 at acpi0: bus -1 (P0P4) >> acpiprt3 at acpi0: bus 1 (P0P1) >> acpiprt4 at acpi0: bus -1 (P0P2) >> acpiprt5 at acpi0: bus 2 (PEX0) >> acpiprt6 at acpi0: bus -1 (PEX1) >> acpiprt7 at acpi0: bus -1 (PEX2) >> acpiprt8 at acpi0: bus -1 (PEX3) >> acpiprt9 at acpi0: bus -1 (PEX4) >> acpiprt10 at acpi0: bus 3 (PEX5) >> acpiprt11 at acpi0: bus 4 (PEX6) >> acpiprt12 at acpi0: bus 6 (BR19) >> acpicpu0 at acpi0: C3, C2, C1, PSS >> acpicpu1 at acpi0: C3, C2, C1, PSS >> acpicpu2 at acpi0: C3, C2, C1, PSS >> acpicpu3 at acpi0: C3, C2, C1, PSS >> acpicpu4 at acpi0: C3, C2, C1, PSS >> acpicpu5 at acpi0: C3, C2, C1, PSS >> acpicpu6 at acpi0: C3, C2, C1, PSS >> acpicpu7 at acpi0: C3, C2, C1, PSS >> acpibtn0 at acpi0: PWRB >> acpivideo0 at acpi0: GFX0 >> acpivout0 at acpivideo0: DD02 >> cpu0: Enhanced SpeedStep 3411 MHz: speeds: 3401, 3400, 3300, 3200, 3100, >> 3000, 2900, 2800, 2700, 2600, 2500, 2400, 2300, 2200, 2100, 1600 MHz >> pci0 at mainbus0 bus 0 >> pchb0 at pci0 dev 0 function 0 "Intel Core 2G Host" rev 0x09 >> ppb0 at pci0 dev 1 function 0 "Intel Core 2G PCIE" rev 0x09: msi >> pci1 at ppb0 bus 1 >> vga1 at pci0 dev 2 function 0 "Intel HD Graphics 2000" rev 0x09 >> intagp at vga1 not configured >> inteldrm0 at vga1 >> drm0 at inteldrm0 >> drm: Memory usable by graphics device = 2048M >> No connectors reported connected with modes >> Cannot find any crtc or sizes - going 1024x768 >> inteldrm0: 1024x768 >> wsdisplay0 at vga1 mux 1: console (std, vt100 emulation) >> wsdisplay0: screen 1-5 added (std, vt100 emulation) >> "Intel 6 Series MEI" rev 0x04 at pci0 dev 22 function 0 not configured >> ehci0 at pci0 dev 26 function 0 "Intel 6 Series USB" rev 0x05: apic 0 int 23 >> usb0 at ehci0: USB revision 2.0 >> uhub0 at usb0 "Intel EHCI root hub" rev 2.00/1.00 addr 1 >> ppb1 at pci0 dev 28 function 0 "Intel 6 Series PCIE" rev 0xb5: msi >> pci2 at ppb1 bus 2 >> ppb2 at pci0 dev 28 function 5 "Intel 6 Series PCIE" rev 0xb5: msi >> pci3 at ppb2 bus 3 >> "ASMedia ASM1042 xHCI" rev 0x00 at pci3 dev 0 function 0 not configured >> ppb3 at pci0 dev 28 function 6 "Intel 6 Series PCIE" rev 0xb5: msi >> pci4 at ppb3 bus 4 >> re0 at pci4 dev 0 function 0 "Realtek 8168" rev 0x06: RTL8168E/8111E >> (0x2c00), msi, address 54:04:a6:7e:e5:98 >> rgephy0 at re0 phy 7: RTL8169S/8110S PHY, rev. 4 >> ppb4 at pci0 dev 28 function 7 "Intel 82801BA Hub-to-PCI" rev 0xb5: msi >> pci5 at ppb4 bus 5 >> ppb5 at pci5 dev 0 function 0 "ASMedia ASM1083/1085 PCIE-PCI" rev 0x01 >> pci6 at ppb5 bus 6 >> ehci1 at pci0 dev 29 function 0 "Intel 6 Series USB" rev 0x05: apic 0 int 23 >> usb1 at ehci1: USB revision 2.0 >> uhub1 at usb1 "Intel EHCI root hub" rev 2.00/1.00 addr 1 >> pcib0 at pci0 dev 31 function 0 "Intel H67 LPC" rev 0x05 >> ahci0 at pci0 dev 31 function 2 "Intel 6 Series AHCI" rev 0x05: msi, AHCI 1.3 >> scsibus1 at ahci0: 32 targets >> sd0 at scsibus1 targ 0 lun 0: <ATA, ST33000651AS, CC45> SCSI3 0/direct fixed >> naa.5000c5003534516c >> sd0: 2861588MB, 512 bytes/sector, 5860533168 sectors >> sd1 at scsibus1 targ 1 lun 0: <ATA, ST33000651AS, CC45> SCSI3 0/direct fixed >> naa.5000c5003ec82147 >> sd1: 2861588MB, 512 bytes/sector, 5860533168 sectors >> ichiic0 at pci0 dev 31 function 3 "Intel 6 Series SMBus" rev 0x05: apic 0 >> int 18 >> iic0 at ichiic0 >> spdmem0 at iic0 addr 0x50: 4GB DDR3 SDRAM PC3-10600 >> spdmem1 at iic0 addr 0x51: 4GB DDR3 SDRAM PC3-10600 >> spdmem2 at iic0 addr 0x52: 4GB DDR3 SDRAM PC3-10600 >> spdmem3 at iic0 addr 0x53: 4GB DDR3 SDRAM PC3-10600 >> isa0 at pcib0 >> isadma0 at isa0 >> pckbc0 at isa0 port 0x60/5 >> pckbd0 at pckbc0 (kbd slot) >> pckbc0: using irq 1 for kbd slot >> wskbd0 at pckbd0: console keyboard, using wsdisplay0 >> pcppi0 at isa0 port 0x61 >> spkr0 at pcppi0 >> wbsio0 at isa0 port 0x2e/2: NCT6776F rev 0x33 >> lm1 at wbsio0 port 0x290/8: NCT6776F >> uhub2 at uhub0 port 1 "Intel Rate Matching Hub" rev 2.00/0.00 addr 2 >> uhub3 at uhub1 port 1 "Intel Rate Matching Hub" rev 2.00/0.00 addr 2 >> vscsi0 at root >> scsibus2 at vscsi0: 256 targets >> softraid0 at root >> scsibus3 at softraid0: 256 targets >> sd2 at scsibus3 targ 1 lun 0: <OPENBSD, SR RAID 1, 005> SCSI2 0/direct fixed >> sd2: 2097148MB, 512 bytes/sector, 4294961093 sectors >> root on sd2a (198369b15ed32efc.a) swap on sd2b dump on sd2b
