[Bug 243793] [PATCH] www/mod_log_sql2: fix for FreeBSD's PID > 65535 when 'LogSQLCreateTables On'

[bugzilla-noreply at freebsd.org]

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

--- Comment #7 from Tommy P <tommyhp2 at gmail.com> ---
(In reply to Jochen Neumeister from comment #5)
Hi Jochen,

There aren't any errors in the logs that I could see.  I did noticed the SQL
file, from the setting LogSQLPreserveFile, got bigger when the DB and web
servers have been running for a long time.  When I tried to enter the data
manually by running that SQL file, all of the rows failed because the data is
larger (> 65535) than column (child_pid) allowed (unsigned smallint).  The
patches allow the setting LogSQLCreateTables to work as intended.  I don't
recall the max limit of PID on FreeBSD 11.x but on 12.1-RELEASE, I see it goes
up to 99922 as of this writing.

Regards,
Tommy

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