WARNING: Error while sending QUERY packet. PID=82827

I’m on SSL

@infolotnicze – great thanks. Let’s see what other people say before I post my logical theory.

@infolotnicze – Since you have BPS Pro installed then go to DB Monitor > DB Status & Info > click the Show Global Variables button > look for these 3 variables in the list of variables that is displayed after clicking the Show Global Variables button. Post your variable settings.

have_openssl: NO
have_ssl: NO
have_query_cache: YES

do not post your actual ssl info and just use an X if these settings are not blank.
ssl_ca: X
ssl_capath: X
ssl_cert: X
ssl_cipher: X
ssl_key: X

Also this info is about using SSL directly for your DB and there is another possible logical issue with using SSL at the HTTPS level.

have_openssl: NO
have_ssl: DISABLED
have_query_cache: YES

those belowe are blank:
ssl_ca: X
ssl_capath: X
ssl_cert: X
ssl_cipher: X
ssl_key: X

And some more about SS and other stuffL:

version: 10.1.12-MariaDB
version_comment: MariaDB Server
version_compile_machine: x86_64
version_compile_os: Linux
version_malloc_library: bundled jemalloc
version_ssl_library: YaSSL 2.3.9
wait_timeout: 360
wsrep_osu_method: TOI
wsrep_auto_increment_control: ON
wsrep_causal_reads: OFF

I had the same error and was not using an SSL site.

Sorry for the late response. I did not got an email that anyone had replied. Ok so the issue does not have anything to do with SSL at either the HTTP or DB level. Thanks.

So the most likely causes are:
Data Type or the Data itself in a particular DB Table.
max_allowed_packet and wait_timeout variable values/settings – either a timeout or error checking logic problem probably related specifically to using sql command line mysqldump.

Something must have been updated somewhere, because from August 23 I no longer get any warnings!

??

@alhbin – Most likely that would confirm that the issue is related to Table Data|Data Type specific. The big picture is that the error is “after the fact” – insignificant|just a nuisance error.

Please check you error log file. The issue with me was posite plugin, when i deactivated it, problem solved