search

wa0x6e / php-resque-ex

PHP port of resque (Workers and Queueing), with phpredis support, and more logging options
MIT License
137 stars 92 forks source link

Error while sending QUERY packet #48

Open Muffinman opened 7 years ago

Muffinman commented 7 years ago

Hi, we're seeing the following MySQL error when running a job through the queue worker. When running the same class outside the queue environment the error doesn't appear.

PHP Warning: Error while sending QUERY packet. PID=7741 in private/lib/core/db.class.php on line 134

We've checked the query and the max packet size / timeouts in MariaDB and everything is within tolerances. The query is a simple update which updates a single row in the DB. We're using the MySQLi extension and php5-mysqlnd.

Any idea why this would only happen in php-resque-ex ?

PHP version: 5.5.9 php-resque-ex version: 1.3.0 MariaDB version: 10.0.30

jision commented 7 years ago

Its just a warning I suppose check in php.ini and check what is increasing the query size.Its not on mysql end its more on the php code side

Muffinman commented 7 years ago

Unfortunately although it's not just a PHP warning, the query has actually failed.

Like I said, this is not related to query size (although the error would seem to indicate that), the query was only about 100 bytes.

UPDATE: After some further testing this only seems to happen when sending an UPDATE query as the first query to the SQL server. If I send a dummy SELECT first then we don't get the error!?