[Bug 279418] databases/sqlite3 crashes with SIGSEGV in dspam

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=279418

            Bug ID: 279418
           Summary: databases/sqlite3 crashes with SIGSEGV in dspam
           Product: Ports & Packages
           Version: Latest
          Hardware: amd64
                OS: Any
            Status: New
          Severity: Affects Some People
          Priority: ---
         Component: Individual Port(s)
          Assignee: ports-bugs@FreeBSD.org
          Reporter: vova@fbsd.ru
                CC: pavelivolkov@gmail.com
             Flags: maintainer-feedback?(pavelivolkov@gmail.com)
                CC: pavelivolkov@gmail.com

sqlite3-3.45.1,1 badly break dspam - now it died with SIGSEGV:

exim -d -d -M 1sCqf4-00000000HJz-3K8x
...
LOG: MAIN
  ** <email> R=dspam_spamscan_router T=dspam_spamcheck_transport: Child process
of dspam_spamcheck_transport transport (running command "/usr/local/bin/dspam
--deliver=innocent --user "${lookup{$local_part} lsearch,ret=key
{/etc/passwd}}" -- %u") was terminated by signal 11 (segmentation fault)
...

if start debugger while it not yet crashed:

# lldb -n dspam
(lldb) c
Process 91463 resuming
Process 91463 stopped
* thread #1, name = 'dspam', stop reason = signal SIGSEGV: invalid address
(fault address: 0x121668)
    frame #0: 0x0000000824cbdfd4 libc.so.7`___lldb_unnamed_symbol5326 + 164
libc.so.7`___lldb_unnamed_symbol5326:
->  0x824cbdfd4 <+164>: movq   (%rax), %rax
    0x824cbdfd7 <+167>: movq   %rax, %r13
    0x824cbdfda <+170>: shrq   $0x30, %r13
    0x824cbdfde <+174>: leaq   0x28685b(%rip), %rcx
(lldb) bt
* thread #1, name = 'dspam', stop reason = signal SIGSEGV: invalid address
(fault address: 0x121668)
  * frame #0: 0x0000000824cbdfd4 libc.so.7`___lldb_unnamed_symbol5326 + 164
    frame #1: 0x00000008242d002e
libsqlite3_drv.so`_sqlite_drv_query_error(error="_ds_set_signature:
sqlite3_prepare() failed", query="INSERT INTO dspam_signature_data
(signature,created_on,data) VALUES
(\"6659280d914632013293170\",date('now'),?)") at sqlite3_drv.c:1339:3
    frame #2: 0x00000008242d284d
libsqlite3_drv.so`_ds_set_signature(CTX=0x000018d77d45a100,
SIG=0x000018d77d4ba280, signature="6659280d914632013293170") at
sqlite3_drv.c:974:5
    frame #3: 0x000000000020c51b dspam`process_message(ATX=0x000000082112e210,
message=0x000018d77d45c0e0, username="vova", result_string=0x000000082112d7a8)
at dspam.c:641:17
    frame #4: 0x000000000020a975 dspam`process_users(ATX=0x000000082112e210,
message=0x000018d77d45c0a0) at dspam.c:1892:16
    frame #5: 0x0000000000209484 dspam`main(argc=6, argv=0x000000082112f148) at
dspam.c:263:14
    frame #6: 0x0000000824bcbafa libc.so.7`__libc_start1 + 298
    frame #7: 0x0000000000208ea0 dspam`_start + 48
(lldb)


if rollback to previous sqlite3-3.45.0_1,1 - everything goes fine:
LOG: MAIN
  => vova <vova@domain...> R=dspam_spamscan_router T=dspam_spamcheck_transport


FreeBSD srv 14.0-RELEASE FreeBSD 14.0-RELEASE #16 f9716eee8ab4: Fri Apr  5
13:43:53 MSK 2024     root@srv:/usr/obj/usr/src/amd64.amd64/sys/SRV amd64

-- 
You are receiving this mail because:
You are the assignee for the bug.