MySQL server in broken state will crash Sequel Pro

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Connect to MariaDB 10.0.3 (possibly other versions)
2. Crash
3.

What version of Sequel Pro are you using?

Tried with 1.0.2 and nightly build on Jul 14, 2013.

What version of OS X are you using?

10.8.4

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

MariaDB 10.0.3

Please provide any additional information below.

Tried with and without SSH, same result. This used to work, then suddenly 
stopped working. I have no idea why. I did not change anything client-side, but 
it's possible that MariaDB was updated one revision.

Exception dump:

NSInvalidArgumentException

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

(
    0   CoreFoundation                      0x00007fff81702b06 __exceptionPreprocess + 198
    1   libobjc.A.dylib                     0x00007fff81a8a3f0 objc_exception_throw + 43
    2   CoreFoundation                      0x00007fff817028dc +[NSException raise:format:] + 204
    3   Foundation                          0x00007fff8bc22dac -[NSPlaceholderString initWithString:] + 93
    4   Sequel Pro                          0x0000000100032c46 -[SPDatabaseDocument setConnection:] + 450
    5   Foundation                          0x00007fff8bc485ca __NSThreadPerformPerform + 225
    6   CoreFoundation                      0x00007fff81681b31 __CFRUNLOOP_IS_CALLING_OUT_TO_A_SOURCE0_PERFORM_FUNCTION__ + 17
    7   CoreFoundation                      0x00007fff81681455 __CFRunLoopDoSources0 + 245
    8   CoreFoundation                      0x00007fff816a47f5 __CFRunLoopRun + 789
    9   CoreFoundation                      0x00007fff816a40e2 CFRunLoopRunSpecific + 290
    10  HIToolbox                           0x00007fff848c0eb4 RunCurrentEventLoopInMode + 209
    11  HIToolbox                           0x00007fff848c0c52 ReceiveNextEventCommon + 356
    12  HIToolbox                           0x00007fff848c0ae3 BlockUntilNextEventMatchingListInMode + 62
    13  AppKit                              0x00007fff81d6c533 _DPSNextEvent + 685
    14  AppKit                              0x00007fff81d6bdf2 -[NSApplication nextEventMatchingMask:untilDate:inMode:dequeue:] + 128
    15  AppKit                              0x00007fff81d631a3 -[NSApplication run] + 517
    16  AppKit                              0x00007fff81d07bd6 NSApplicationMain + 869
    17  Sequel Pro                          0x00000001000022b4 start + 52
)

Original issue reported on code.google.com by adam.ier...@gmail.com on 14 Jul 2013 at 6:24

[GoogleCodeExporter]

Going by the stack trace the cause is probably similar to issue #1596.

Can you post the output of SHOW VARIABLES; of that server?

Original comment by schlabbe...@gmail.com on 14 Jul 2013 at 9:06

• Changed state: WaitingOnUser

[GoogleCodeExporter]

MariaDB [(none)]> show variables;
ERROR 1946 (HY000): Failed to load replication slave GTID position from table 
mysql.gtid_slave_pos

Ahh... I'm gonna see if I can fix that and see if the problem goes away. If it 
does I'll come back and close this. But still: Sequel Pro should pop up an 
informative dialog here, not crash. :)

Original comment by adam.ier...@gmail.com on 15 Jul 2013 at 12:32

[GoogleCodeExporter]

Yes, running mysql_upgrade fixed it.

Original comment by adam.ier...@gmail.com on 15 Jul 2013 at 12:36

[GoogleCodeExporter]

Original comment by schlabbe...@gmail.com on 16 Jul 2013 at 5:59

• Changed title: MySQL server in broken state will crash Sequel Pro
• Changed state: Accepted

[GoogleCodeExporter]

I recently upgraded to 10.0.3 as well, and mysql_upgrade +restart of mysql 
service fixed it.

Original comment by bcorco...@gmail.com on 22 Jul 2013 at 8:36

[GoogleCodeExporter]

yay this worked for me too!

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

[GoogleCodeExporter]

Original comment by stuart02 on 25 Oct 2013 at 9:38

• Added labels: Component-Logic, Priority-Low, Type-Defect