App crashes when connect to sphinx server ver > 2.2.10 #2653

Open
coolswitcher opened this Issue Jan 10, 2017 · 8 comments

Projects

None yet

2 participants

@coolswitcher
coolswitcher commented Jan 10, 2017 edited

I'm can't connect to sphinx server version greater than 2.2.10 - app crashes.
Versions 2.2.10 or 2.2.8 works fine.
Try last nightly build and 1.1.2, no success.

Process:               Sequel Pro [31101]
Path:                  /Applications/Sequel Pro.app/Contents/MacOS/Sequel Pro
Identifier:            com.sequelpro.SequelPro
Version:               Snapshot r50a0f18540 (4749)
Code Type:             X86-64 (Native)
Parent Process:        ??? [1]
Responsible:           Sequel Pro [31101]
User ID:               501

Date/Time:             2017-01-10 11:41:48.657 +0300
OS Version:            Mac OS X 10.12.2 (16C68)
Report Version:        12
Anonymous UUID:        DF1BC431-205B-A7E1-DAC7-245F5A4FFA1F


Time Awake Since Boot: 6400 seconds

System Integrity Protection: enabled

Crashed Thread:        0  Dispatch queue: com.apple.main-thread

Exception Type:        EXC_BAD_ACCESS (SIGSEGV)
Exception Codes:       KERN_PROTECTION_FAILURE at 0x00007fff5f3fffc8
Exception Note:        EXC_CORPSE_NOTIFY

Termination Signal:    Segmentation fault: 11
Termination Reason:    Namespace SIGNAL, Code 0xb
Terminating Process:   exc handler [0]
@dmoagx
Collaborator
dmoagx commented Jan 10, 2017

Please post the full crash report.

@dmoagx
Collaborator
dmoagx commented Jan 10, 2017

Oh, nice, a stack overflow.

Since I don't have a sphinx server at hand, can you try connecting with the mysql cli client to both versions and post what this query returns on each?

SET GLOBAL max_allowed_packet = @@global.max_allowed_packet
@dmoagx
Collaborator
dmoagx commented Jan 10, 2017

Please also check this queries:

SHOW VARIABLES LIKE 'max_allowed_packet';
SELECT @@global.max_allowed_packet;
@coolswitcher

All versions returns: ERROR 1064 (42000): sphinxql: syntax error, unexpected SYSVAR near '@@global.max_allowed_packet'

@coolswitcher
coolswitcher commented Jan 10, 2017 edited

2.2.10

SET GLOBAL max_allowed_packet = @@global.max_allowed_packet;

ERROR 1064 (42000): sphinxql: syntax error, unexpected SYSVAR, expecting IDENT (or 95 other tokens) near '@@global.max_allowed_packet'

SHOW VARIABLES LIKE 'max_allowed_packet';

+--------------------+---------+
| Variable_name      | Value   |
+--------------------+---------+
| max_allowed_packet | 8388608 |
+--------------------+---------+
1 row in set (0.00 sec)

SELECT @@global.max_allowed_packet;

Query OK, 0 rows affected (0.00 sec)

2.2.11

SET GLOBAL max_allowed_packet = @@global.max_allowed_packet;

ERROR 1064 (42000): sphinxql: syntax error, unexpected SYSVAR, expecting IDENT (or 95 other tokens) near '@@global.max_allowed_packet'

SHOW VARIABLES LIKE 'max_allowed_packet';

+--------------------+---------+
| Variable_name      | Value   |
+--------------------+---------+
| max_allowed_packet | 8388608 |
+--------------------+---------+
1 row in set (0.00 sec)

SELECT @@global.max_allowed_packet;

+-----------------------------+
| @@global.max_allowed_packet |
+-----------------------------+
|                             |
+-----------------------------+
1 row in set (0.00 sec)
@dmoagx
Collaborator
dmoagx commented Jan 10, 2017

OK, thanks.
So the reason it crashes is that 2.2.11 returns an empty string instead of nothing for SELECT @@global.max_allowed_packet;

@dmoagx dmoagx removed the WaitingOnUser label Jan 10, 2017
@coolswitcher

thx dmoagx

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment