search

Shooter7119 / sequel-pro

Automatically exported from code.google.com/p/sequel-pro
Other
0 stars 0 forks source link

Crashes on connect to Sphinx server #1596

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?

1. Start up the Sphinx searchd daemon, with a `listen = localhost:9306:mysql41 
to development.sphinx.conf`in the searchd block.
2. Connect via sequel pro to the port 9306 on localhost

What is the expected output?

Sphinx supports the MySQL 4.1 protocol for searching their full text indexes; 
you can use the `mysql` command line client to connect to it and issue queries 
and see results. I was hoping to see the list of indexes as tables, and then be 
able to issue custom queries and see the results in the GUI.

What do you see instead?

It crashes on startup. I send the bug report with the stacktrace.

What version of Sequel Pro are you using?

1.0.1 build 4004

What version of OS X are you using?

10.8.2

What version of MySQL are you connecting to on the server?

I'm using Sphinx 2.0.3 (r3043)

Please provide any additional information below.

More details about Sphinx support for the MySQL protocol can be found here

http://sphinxsearch.com/docs/1.10/sphinxql.html

Original issue reported on code.google.com by andrew.m...@gmail.com on 6 Feb 2013 at 3:11

GoogleCodeExporter commented 9 years ago 
The exception I'm getting is

NSInvalidArgumentException

*** -[NSPlaceholderString initWithString:]: nil argument

(
    0   CoreFoundation                      0x00007fff846c00a6 __exceptionPreprocess + 198
    1   libobjc.A.dylib                     0x00007fff85fe03f0 objc_exception_throw + 43
    2   CoreFoundation                      0x00007fff846bfe7c +[NSException raise:format:] + 204
    3   Foundation                          0x00007fff8eba8e5c -[NSPlaceholderString initWithString:] + 93
    4   Sequel Pro                          0x00000001000340f5 -[SPDatabaseDocument setConnection:] + 472
    5   Sequel Pro                          0x000000010015917b -[SPConnectionController(SPConnectionHandler) addConnectionToDocument] + 356
    6   Sequel Pro                          0x0000000100158d64 -[SPConnectionController(SPConnectionHandler) mySQLConnectionEstablished] + 965
    7   Foundation                          0x00007fff8ebce677 __NSThreadPerformPerform + 225
    8   CoreFoundation                      0x00007fff8463f101 __CFRUNLOOP_IS_CALLING_OUT_TO_A_SOURCE0_PERFORM_FUNCTION__ + 17
    9   CoreFoundation                      0x00007fff8463ea25 __CFRunLoopDoSources0 + 245
    10  CoreFoundation                      0x00007fff84661dc5 __CFRunLoopRun + 789
    11  CoreFoundation                      0x00007fff846616b2 CFRunLoopRunSpecific + 290
    12  HIToolbox                           0x00007fff856930a4 RunCurrentEventLoopInMode + 209
    13  HIToolbox                           0x00007fff85692e42 ReceiveNextEventCommon + 356
    14  HIToolbox                           0x00007fff85692cd3 BlockUntilNextEventMatchingListInMode + 62
    15  AppKit                              0x00007fff88696613 _DPSNextEvent + 685
    16  AppKit                              0x00007fff88695ed2 -[NSApplication nextEventMatchingMask:untilDate:inMode:dequeue:] + 128
    17  AppKit                              0x00007fff8868d283 -[NSApplication run] + 517
    18  AppKit                              0x00007fff88631cb6 NSApplicationMain + 869
    19  Sequel Pro                          0x0000000100001664 start + 52
    20  ???                                 0x0000000000000002 0x0 + 2
)

Original comment by andrew.m...@gmail.com on 6 Feb 2013 at 4:37

GoogleCodeExporter commented 9 years ago 
The issue here is that Sphinx does not return a version during SHOW VARIABLES;

While we should handle that more gracefully, I'm not really sure if we want to 
support Sphinx.
Technically that would mean when we detect a Sphinx server we would have to 
disable basically every feature except the custom query editor.

Original comment by schlabbe...@gmail.com on 8 Feb 2013 at 12:56

GoogleCodeExporter commented 9 years ago 
Yeah, I love Sequel Pro, but wasn't sure this would be welcome. Sphinx supports 
a SHOW TABLES (which lists the indexes) and a DESC TABLE (which describes what 
attributes are in the table); in an ideal world these would be supported as 
well, so you coud navigate around and look at your indexes, as well as query 
and fetch the results.

http://sphinxsearch.com/docs/2.0.6/sphinxql-reference.html

This functionality would be even more interesting with SphinxSE, which compiles 
Sphinx into MySQL as a storage engine, allowing joins across the data stores 
and more seamless index population.

http://sphinxsearch.com/docs/2.0.6/sphinxse-overview.html

Original comment by andrew.m...@gmail.com on 9 Feb 2013 at 6:21

GoogleCodeExporter commented 9 years ago 
I am experiencing a similar error when using mariadb

Jul 23, 2013 10:32:33 AM: CoreAnimation: warning, deleted thread with 
uncommitted CATransaction; set CA_DEBUG_TRANSACTIONS=1 in environment to log 
backtraces.
Jul 23, 2013 10:32:33 AM: *** -[NSPlaceholderString initWithString:]: nil 
argument
Jul 23, 2013 10:32:33 AM: (
  0   CoreFoundation                      0x00007fff8fd97b06 __exceptionPreprocess + 198
  1   libobjc.A.dylib                     0x00007fff8cdf83f0 objc_exception_throw + 43
  2   CoreFoundation                      0x00007fff8fd978dc +[NSException raise:format:] + 204
  3   Foundation                          0x00007fff8d2fadac -[NSPlaceholderString initWithString:] + 93
  4   Sequel Pro                          0x0000000100034e99 -[SPDatabaseDocument setConnection:] + 472
  5   Sequel Pro                          0x000000010015b6b5 -[SPConnectionController(SPConnectionHandler) addConnectionToDocument] + 356
  6   Sequel Pro                          0x000000010015b2f5 -[SPConnectionController(SPConnectionHandler) mySQLConnectionEstablished] + 965
  7   Foundation                          0x00007fff8d3205ca __NSThreadPerformPerform + 225
  8   CoreFoundation                      0x00007fff8fd16b31 __CFRUNLOOP_IS_CALLING_OUT_TO_A_SOURCE0_PERFORM_FUNCTION__ + 17
  9   CoreFoundation                      0x00007fff8fd16455 __CFRunLoopDoSources0 + 245
  10  CoreFoundation                      0x00007fff8fd397f5 __CFRunLoopRun + 789
  11  CoreFoundation                      0x00007fff8fd390e2 CFRunLoopRunSpecific + 290
  12  HIToolbox                           0x00007fff8f311eb4 RunCurrentEventLoopInMode + 209
  13  HIToolbox                           0x00007fff8f311c52 ReceiveNextEventCommon + 356
  14  HIToolbox                           0x00007fff8f311ae3 BlockUntilNextEventMatchingListInMode + 62
  15  AppKit                              0x00007fff87258533 _DPSNextEvent + 685
  16  AppKit                              0x00007fff87257df2 -[NSApplication nextEventMatchingMask:untilDate:inMode:dequeue:] + 128
  17  AppKit                              0x00007fff8724f1a3 -[NSApplication run] + 517
  18  AppKit                              0x00007fff871f3bd6 NSApplicationMain + 869
  19  Sequel Pro                          0x0000000100002084 start + 52
  20  ???                                 0x0000000000000002 0x0 + 2
)
Jul 23, 2013 10:32:34 AM: Found 0 crash files earlier than latest submission on 
2013-07-19 20:51:14 +0000
Jul 23, 2013 10:32:35 AM: Sending feedback to http://log.sequelpro.com/submit
Jul 23, 2013 10:32:35 AM: Posting 10784 bytes to http://log.sequelpro.com/submit
Jul 23, 2013 10:32:36 AM: Connection received data
Jul 23, 2013 10:32:47 AM: CoreAnimation: warning, deleted thread with 
uncommitted CATransaction; set CA_DEBUG_TRANSACTIONS=1 in environment to log 
backtraces.
Jul 23, 2013 10:32:47 AM: *** -[NSPlaceholderString initWithString:]: nil 
argument
Jul 23, 2013 10:32:47 AM: (
  0   CoreFoundation                      0x00007fff8fd97b06 __exceptionPreprocess + 198
  1   libobjc.A.dylib                     0x00007fff8cdf83f0 objc_exception_throw + 43
  2   CoreFoundation                      0x00007fff8fd978dc +[NSException raise:format:] + 204
  3   Foundation                          0x00007fff8d2fadac -[NSPlaceholderString initWithString:] + 93
  4   Sequel Pro                          0x0000000100034e99 -[SPDatabaseDocument setConnection:] + 472
  5   Sequel Pro                          0x000000010015b6b5 -[SPConnectionController(SPConnectionHandler) addConnectionToDocument] + 356
  6   Sequel Pro                          0x000000010015b2f5 -[SPConnectionController(SPConnectionHandler) mySQLConnectionEstablished] + 965
  7   Foundation                          0x00007fff8d3205ca __NSThreadPerformPerform + 225
  8   CoreFoundation                      0x00007fff8fd16b31 __CFRUNLOOP_IS_CALLING_OUT_TO_A_SOURCE0_PERFORM_FUNCTION__ + 17
  9   CoreFoundation                      0x00007fff8fd16455 __CFRunLoopDoSources0 + 245
  10  CoreFoundation                      0x00007fff8fd397f5 __CFRunLoopRun + 789
  11  CoreFoundation                      0x00007fff8fd390e2 CFRunLoopRunSpecific + 290
  12  HIToolbox                           0x00007fff8f311eb4 RunCurrentEventLoopInMode + 209
  13  HIToolbox                           0x00007fff8f311c52 ReceiveNextEventCommon + 356
  14  HIToolbox                           0x00007fff8f311ae3 BlockUntilNextEventMatchingListInMode + 62
  15  AppKit                              0x00007fff87258533 _DPSNextEvent + 685
  16  AppKit                              0x00007fff87257df2 -[NSApplication nextEventMatchingMask:untilDate:inMode:dequeue:] + 128
  17  AppKit                              0x00007fff8724f1a3 -[NSApplication run] + 517
  18  AppKit                              0x00007fff871f3bd6 NSApplicationMain + 869
  19  Sequel Pro                          0x0000000100002084 start + 52
  20  ???                                 0x0000000000000002 0x0 + 2
)
Jul 23, 2013 10:32:48 AM: Found 0 crash files earlier than latest submission on 
2013-07-23 17:32:36 +0000
Jul 23, 2013 10:35:50 AM: CoreAnimation: warning, deleted thread with 
uncommitted CATransaction; set CA_DEBUG_TRANSACTIONS=1 in environment to log 
backtraces.
Jul 23, 2013 10:35:50 AM: *** -[NSPlaceholderString initWithString:]: nil 
argument
Jul 23, 2013 10:35:50 AM: (
  0   CoreFoundation                      0x00007fff8fd97b06 __exceptionPreprocess + 198
  1   libobjc.A.dylib                     0x00007fff8cdf83f0 objc_exception_throw + 43
  2   CoreFoundation                      0x00007fff8fd978dc +[NSException raise:format:] + 204
  3   Foundation                          0x00007fff8d2fadac -[NSPlaceholderString initWithString:] + 93
  4   Sequel Pro                          0x0000000100034e99 -[SPDatabaseDocument setConnection:] + 472
  5   Sequel Pro                          0x000000010015b6b5 -[SPConnectionController(SPConnectionHandler) addConnectionToDocument] + 356
  6   Sequel Pro                          0x000000010015b2f5 -[SPConnectionController(SPConnectionHandler) mySQLConnectionEstablished] + 965
  7   Foundation                          0x00007fff8d3205ca __NSThreadPerformPerform + 225
  8   CoreFoundation                      0x00007fff8fd16b31 __CFRUNLOOP_IS_CALLING_OUT_TO_A_SOURCE0_PERFORM_FUNCTION__ + 17
  9   CoreFoundation                      0x00007fff8fd16455 __CFRunLoopDoSources0 + 245
  10  CoreFoundation                      0x00007fff8fd397f5 __CFRunLoopRun + 789
  11  CoreFoundation                      0x00007fff8fd390e2 CFRunLoopRunSpecific + 290
  12  HIToolbox                           0x00007fff8f311eb4 RunCurrentEventLoopInMode + 209
  13  HIToolbox                           0x00007fff8f311c52 ReceiveNextEventCommon + 356
  14  HIToolbox                           0x00007fff8f311ae3 BlockUntilNextEventMatchingListInMode + 62
  15  AppKit                              0x00007fff87258533 _DPSNextEvent + 685
  16  AppKit                              0x00007fff87257df2 -[NSApplication nextEventMatchingMask:untilDate:inMode:dequeue:] + 128
  17  AppKit                              0x00007fff8724f1a3 -[NSApplication run] + 517
  18  AppKit                              0x00007fff871f3bd6 NSApplicationMain + 869
  19  Sequel Pro                          0x0000000100002084 start + 52
  20  ???                                 0x0000000000000002 0x0 + 2
)
Jul 23, 2013 10:35:51 AM: Found 0 crash files earlier than latest submission on 
2013-07-23 17:32:36 +0000
Jul 23, 2013 10:38:59 AM: CoreAnimation: warning, deleted thread with 
uncommitted CATransaction; set CA_DEBUG_TRANSACTIONS=1 in environment to log 
backtraces.
Jul 23, 2013 10:38:59 AM: *** -[NSPlaceholderString initWithString:]: nil 
argument
Jul 23, 2013 10:38:59 AM: (
  0   CoreFoundation                      0x00007fff8fd97b06 __exceptionPreprocess + 198
  1   libobjc.A.dylib                     0x00007fff8cdf83f0 objc_exception_throw + 43
  2   CoreFoundation                      0x00007fff8fd978dc +[NSException raise:format:] + 204
  3   Foundation                          0x00007fff8d2fadac -[NSPlaceholderString initWithString:] + 93
  4   Sequel Pro                          0x0000000100034e99 -[SPDatabaseDocument setConnection:] + 472
  5   Sequel Pro                          0x000000010015b6b5 -[SPConnectionController(SPConnectionHandler) addConnectionToDocument] + 356
  6   Sequel Pro                          0x000000010015b2f5 -[SPConnectionController(SPConnectionHandler) mySQLConnectionEstablished] + 965
  7   Foundation                          0x00007fff8d3205ca __NSThreadPerformPerform + 225
  8   CoreFoundation                      0x00007fff8fd16b31 __CFRUNLOOP_IS_CALLING_OUT_TO_A_SOURCE0_PERFORM_FUNCTION__ + 17
  9   CoreFoundation                      0x00007fff8fd16455 __CFRunLoopDoSources0 + 245
  10  CoreFoundation                      0x00007fff8fd397f5 __CFRunLoopRun + 789
  11  CoreFoundation                      0x00007fff8fd390e2 CFRunLoopRunSpecific + 290
  12  HIToolbox                           0x00007fff8f311eb4 RunCurrentEventLoopInMode + 209
  13  HIToolbox                           0x00007fff8f311c52 ReceiveNextEventCommon + 356
  14  HIToolbox                           0x00007fff8f311ae3 BlockUntilNextEventMatchingListInMode + 62
  15  AppKit                              0x00007fff87258533 _DPSNextEvent + 685
  16  AppKit                              0x00007fff87257df2 -[NSApplication nextEventMatchingMask:untilDate:inMode:dequeue:] + 128
  17  AppKit                              0x00007fff8724f1a3 -[NSApplication run] + 517
  18  AppKit                              0x00007fff871f3bd6 NSApplicationMain + 869
  19  Sequel Pro                          0x0000000100002084 start + 52
  20  ???                                 0x0000000000000002 0x0 + 2
)

Original comment by EarlKra...@gmail.com on 23 Jul 2013 at 5:43

GoogleCodeExporter commented 9 years ago 
oh saw on another post that mysql_update followed by restart mariadb fixes 
this. Worked for me.

Original comment by EarlKra...@gmail.com on 23 Jul 2013 at 5:47