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
