Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 11 Mar 2020 02:34:04 +0000
From:      bugzilla-noreply@freebsd.org
To:        apache@FreeBSD.org
Subject:   [Bug 243793] [PATCH] www/mod_log_sql2: fix for FreeBSD's PID > 65535 when 'LogSQLCreateTables On'
Message-ID:  <bug-243793-16115-AC5VTf25r5@https.bugs.freebsd.org/bugzilla/>
In-Reply-To: <bug-243793-16115@https.bugs.freebsd.org/bugzilla/>
References:  <bug-243793-16115@https.bugs.freebsd.org/bugzilla/>

next in thread | previous in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D243793

--- Comment #7 from Tommy P <tommyhp2@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 g=
oes
up to 99922 as of this writing.

Regards,
Tommy

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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-243793-16115-AC5VTf25r5>