Developer

« Return to index ‹ #85 #87 › ⊕ View reports

#86: More MySQL client library vio_delete crashes

Type: Crash First reported: 26 Mar 2010
Status: New Last modified: 3 Sep 2011
Occurrences: 313 Fixed: In revision r3347
Thread 9 Crashed:
0 libSystem.B.dylib 0x00007fff8368484d usleep$NOCANCEL + 0
1 libSystem.B.dylib 0x00007fff836a3e3c abort + 93
2 libSystem.B.dylib 0x00007fff835bb155 free + 128
3 ...ogle.code.sequel-pro.mcpkit 0x0000000100366b51 vio_delete + 33
4 ...ogle.code.sequel-pro.mcpkit 0x0000000100361701 end_server + 65
5 ...ogle.code.sequel-pro.mcpkit 0x00000001003623db cli_safe_read + 107
6 ...ogle.code.sequel-pro.mcpkit 0x0000000100364c00 cli_advanced_command + 608
7 ...ogle.code.sequel-pro.mcpkit 0x0000000100343f41 mysql_ping + 49
8 ...ogle.code.sequel-pro.mcpkit 0x000000010033a279 pingConnectionTask + 9
9 libSystem.B.dylib 0x00007fff835edf8e _pthread_start + 331
10 libSystem.B.dylib 0x00007fff835ede41 thread_start + 13

Comments

Comment with feedback submission on 26 Mar 2010
click Retry to re-connect to server SSH after sleep and change of client network
( I meant to click "Reconnect" - previous attempts would result in hang )

Non-SSH work perfectly on click "reconnect"
Comment by rowan on 31 Mar 2010
I'll ask for confirmation, but believe this is fixed now.

Status changed to "Fixed". Marked as fixed in r2050.
Issue system message on 5 Apr 2010
Automatically reopened: new report received from a revision after this problem was believed to be fixed.
Comment with feedback submission on 5 Apr 2010
Switched databases. Modest number of tables in each database (<20)
Comment with feedback submission on 6 Apr 2010
initiated query after brief network interruption.
There was no-reconnect dialogue just simple clicking on new table to get contents.
I already sent Rowan the crash log
Comment by rowan on 6 Apr 2010
Status changed to "Fixed". Marked as fixed in r2066.
Issue system message on 5 May 2010
Automatically reopened: new report received from a revision after this problem was believed to be fixed.
Comment with feedback submission on 5 May 2010
Trying to switch tables
Comment with feedback submission on 6 May 2010
choose a different database
Comment with feedback submission on 6 May 2010
Attempted a "reconnect" after waking up the Laptop. Connection was an SSH tunnel starting a local connect.
Comment with feedback submission on 7 May 2010
select a db from menu
Comment with feedback submission on 7 May 2010
Export. SQL Dump and Cancel it
Comment with feedback submission on 10 May 2010
quitting app
Comment with feedback submission on 14 May 2010
I submitted a row.
Comment with feedback submission on 15 May 2010
trying to wake up a "dead" ssh connection
Comment with feedback submission on 17 May 2010
tried to reconnect the next morning after computer was sleeping
Comment with feedback submission on 18 May 2010
reloading tables
Comment with feedback submission on 27 May 2010
I went from the contents to the structure view - local dbase & very small in size so the app wasn't under any load? Sorry was just a random close & I have no more info to give - love your app but! Best kyle@voomstudio.com
Comment with feedback submission on 2 Jun 2010
wasn't even in focus! wtf?! love the program tho
Comment with feedback submission on 7 Jun 2010
Changed to a new table while in the 'Relationships' view.
Comment with feedback submission on 8 Jun 2010
Changing selected database
Comment with feedback submission on 10 Jun 2010
The application had two open connections, including one to a remote host to which it was attempting to reconnect after I put the computer to sleep.
Comment with feedback submission on 15 Jun 2010
just create view
Comment with feedback submission on 16 Jun 2010
Loading table view
Comment with feedback submission on 17 Jun 2010
Tried to switch to a new different table on a remote server after the computer having been asleep all night.
Comment with feedback submission on 17 Jun 2010
Clicked on another table after the app had been idle for a few hours.
Comment with feedback submission on 18 Jun 2010
Tried to rename one line
Comment with feedback submission on 19 Jun 2010
it quit during upload of csv import on a remote connection in a tab
Comment with feedback submission on 25 Jun 2010
While connected, suspend the Macbook. After reopening the Macbook, refresh the current table data. Sequel asks for 'Reconnect' or 'Retry'. Click 'Reconnect'. Crash.
Comment with feedback submission on 30 Jun 2010
Export a database of about 250MB with a search_index table (Drupal)
Comment with feedback submission on 1 Jul 2010
I was connected to one server and switched from one DB on that server to another. It crashed immediately.
Comment with feedback submission on 2 Jul 2010
suddently
Comment with feedback submission on 5 Jul 2010
clicked on a table which contains a lot of data
Comment with feedback submission on 5 Jul 2010
Changed database
Comment with feedback submission on 7 Jul 2010
I just change the database on select field.
Comment with feedback submission on 9 Jul 2010
Lost VPN connection
Comment with feedback submission on 10 Jul 2010
truncated a 11k records table
Comment with feedback submission on 10 Jul 2010
was connecting to a database
Comment with feedback submission on 13 Jul 2010
two sessions open one of them ssh

Sequel Pro idling as non-front App
crashed without warning
Comment with feedback submission on 17 Jul 2010
Tried to import a sql dump.
Comment with feedback submission on 20 Jul 2010
Launched a Java application
Comment with feedback submission on 30 Jul 2010
wanted to update a field in my database but the software crashed
Comment with feedback submission on 3 Aug 2010
I tried to edit an id column and set an auto_increment
Comment with feedback submission on 6 Aug 2010
Was switching to a different table in the same DB to try to view it's structure. Database was locally hosted on my machine.
Comment with feedback submission on 11 Aug 2010
internet connection got reset, sequel pro can't handle a reset it seems
Comment with feedback submission on 11 Aug 2010
Sequel pro is connected to a remote server when I put it to sleep. When my Mac woke up from Sleep, SequelPro Crashed. This never happened with the previous version of SequelPro.
Comment with feedback submission on 12 Aug 2010
try to image a csv, with linebreak - classic mac (cr) and encoding UTF8
Comment with feedback submission on 19 Aug 2010
i tried doing a mysql dump of my entire database and it sat and wouldnt continue
Comment with feedback submission on 19 Aug 2010
changed network connection while ssh was connected, disconnected from vpn, changed from airport to ethernet, connected to vpn -- I expected Sequel Pro to balk at that, would've closed it first if I'd noticed it was open
Comment with feedback submission on 23 Aug 2010
Updated a table.
Comment with feedback submission on 25 Aug 2010
accessing db over vpn
Comment with feedback submission on 25 Aug 2010
Restarted MySQL
Comment with feedback submission on 27 Aug 2010
waiting for a reconnect
Comment by rowan on 31 Aug 2010
Title changed to "More MySQL client library vio_delete crashes".
Comment with feedback submission on 1 Sep 2010
Ran processlist on my managed server
Try re-run query it bombed :(
Comment with feedback submission on 4 Sep 2010
I had two instances of Sequel Pro open.
The first one was connected to my localsystem

The second was connected to a remote server (Ubuntu 9.10)
I rebooted the server without closing the connection.
I was prompted to 'reconnect' to the remote server a couple of times and clicked 'reconnect' but it wasn't successful either time.
Went back to edit something locally and that's when the crash happened.
Comment with feedback submission on 5 Sep 2010
Reconnect
Comment by rowan on 5 Sep 2010
Status changed to "Fixed". Marked as fixed in r2602.
Comment with feedback submission on 5 Sep 2010
crashed on focus after 2min of idle
Comment with feedback submission on 7 Sep 2010
Choosing (matching) a field in the import CSV dialog box
Issue system message on 13 Sep 2010
Automatically reopened: new report received from a revision after this problem was believed to be fixed.
Comment with feedback submission on 13 Sep 2010
was running a query (through an ssh tunnel) and had to go in powersave. When I plugged the laptop, the thing was still spinning but crashed a few seconds later.
Comment with feedback submission on 14 Sep 2010
Comment with feedback submission on 17 Sep 2010
Crashed while re-connect to our mysql db.
Comment with feedback submission on 21 Sep 2010
Accidentally pressed CMD Q in the middle of Running a query
Comment with feedback submission on 22 Sep 2010
woke the computer from sleep -> seems to crash the app quite easily
Comment with feedback submission on 22 Sep 2010
ran a query that was taking a long time
Comment with feedback submission on 22 Sep 2010
changing of database on the same server
Comment with feedback submission on 23 Sep 2010
loading a table
Comment with feedback submission on 27 Sep 2010
import db
Comment with feedback submission on 30 Sep 2010
Changing databases
Comment with feedback submission on 2 Oct 2010
lost connection during table import
Comment with feedback submission on 3 Oct 2010
spontaneous crash
Comment with feedback submission on 14 Oct 2010
AAAAAARRRRRRRRGGGGGGG!!!!!!!!!!!!!
Comment with feedback submission on 15 Oct 2010
Suspended my laptop and reconnected at a different wifi-location (new IP-address). I then tried to look at a database table. I didn't expect it to work, but I hoped for a dialog about connection close with option to reconnect instead of a crash.
Comment with feedback submission on 18 Oct 2010
importing database to remote mysql server connected via ssh
Comment with feedback submission on 18 Oct 2010
Started to import a previous SQL export (export a SQL dump from Sequel Pro) over an SSH tunnel connection.
Comment with feedback submission on 25 Oct 2010
Sequel pro had just started, i had connected to a bookmarked database then clicked on a table name to view it.
Comment with feedback submission on 25 Oct 2010
Had four windows open, and two them had the "connection lost" sheet open. I went to each window and hit "Reconnect".
Comment with feedback submission on 30 Oct 2010
trying to "reconnect" - this hasn't worked for many months
Comment with feedback submission on 3 Nov 2010
unknown ca
Comment with feedback submission on 15 Nov 2010
I was running a query that did not complete, so I quit. It was unable to quit nicely so it quit "unexpectedly"...
Comment with feedback submission on 16 Nov 2010
reconnected
Comment with feedback submission on 16 Nov 2010
started the application
Comment with feedback submission on 17 Nov 2010
I've changed collation, from within a phpMyAdmin session, for the database currently selected in Sequel Pro. Then I've chosen a different database from Sequel Pro's "Choose Database..." popup menu
Comment with feedback submission on 18 Nov 2010
stopped a query b/c I hadn't VPN in yet
Comment with feedback submission on 23 Nov 2010
switched db
Comment with feedback submission on 28 Nov 2010
mysql dump
Comment with feedback submission on 16 Dec 2010
I was sorting a medium size table (2 million rows) with a binary column for a primary key.
Comment with feedback submission on 17 Dec 2010
changed databases
Comment with feedback submission on 21 Dec 2010
your mom
Comment with feedback submission on 21 Dec 2010
was exporting db when my connection to internet died. When connection re-gained I clicked on close connection & it crashed.
Comment with feedback submission on 2 Jan 2010
Refresh in content after a long idle period

And BTW, kudos for your good work
Comment with feedback submission on 4 Jan 2011
Tried to reconnect. I'm blaming it on Comcast.
Comment with feedback submission on 7 Jan 2011
Comment with feedback submission on 10 Jan 2011
Table update
Comment with feedback submission on 12 Jan 2011
trying to delete a bunch of rows (~30,000 real estate listings)
Comment with feedback submission on 14 Jan 2011
Retrieving rows from a large table was taking too much time, so I decided to stop it.
Comment with feedback submission on 16 Jan 2011
Open a database table.
Comment with feedback submission on 17 Jan 2011
Selected a table in a remote database, connected via SSH
Comment with feedback submission on 19 Jan 2011
internet connection lost while trying to connect to sql via ssh
Comment with feedback submission on 21 Jan 2011
was doing a search for a unique id
Comment with feedback submission on 22 Jan 2011
cancel reconnection
Comment with feedback submission on 25 Jan 2011
I was logged in to the MySQL server using an SSH connection. We have possibly 150 databases running on this server. I opened a database for one particular client, examined several of the tables, and then wanted to switch to another database in the same client account. As soon as I switched to the second DB, the application crashed.
Comment with feedback submission on 31 Jan 2011
I was exporting a big set of data (using export menu function, then mysqlDump and I selected only one big log table) on a remote server (ssh connection).
In the middle of the export, I hit the cancel button : spinning wheel then crashed.
Comment with feedback submission on 1 Feb 2011
external hard drive had to startup before I could switch tables. Sequel must have thought it was crashing and so it crashed?
Comment with feedback submission on 2 Feb 2011
Tried to open a Table in Content View
Comment with feedback submission on 7 Feb 2011
Right clicked a table
Comment with feedback submission on 9 Feb 2011
no idea, just crashed
Comment with feedback submission on 10 Feb 2011
Switched from one database to another using the "Choose Database..." dropdown
Comment with feedback submission on 14 Feb 2011
Comment with feedback submission on 15 Feb 2011
tried to export an sql table sans delete and create
Comment with feedback submission on 17 Feb 2011
your software died on me
Comment with feedback submission on 21 Feb 2011
Switched from query to table
Comment with feedback submission on 24 Feb 2011
nothing i can think of, but it was hanging around for a long time waiting for a response from a DB whose vpn had closed so something to do with that maybe
Comment with feedback submission on 1 Mar 2011
Quit during a running query
Comment with feedback submission on 4 Mar 2011
importing 1400000 rows
Comment with feedback submission on 9 Mar 2011
I opened the app and connected to a MySQL 5.1 server on my MacBook Pro (connected via WiFi though an Airport Extreme). I then left the window alone for a few hours during a meeting. Came back, chose the database I wanted, and boom.
Comment with feedback submission on 10 Mar 2011
ran query
Comment with feedback submission on 11 Mar 2011
Sitting here watching some ssh sessions. Previously ran 2 very simple queries.
Comment with feedback submission on 14 Mar 2011
remove table column in strcuture
Comment with feedback submission on 17 Mar 2011
just switched back and forth between windows a couple times, wasn't doing anything but looking at data
Comment with feedback submission on 21 Mar 2011
Ordinary queries
Comment with feedback submission on 23 Mar 2011
The machine had slept with a connection up - I hit refresh on a table to see some changes and it crashed
Comment with feedback submission on 24 Mar 2011
exporting from a remote database to my local filesystem -- logged in through ssh to that server -- love your product though, really, its awesome
Comment with feedback submission on 25 Mar 2011
I tried to switch off filter in the content table to see all records and then the app crushed
Comment with feedback submission on 27 Mar 2011
Couldn't connect, pressed "Retry" on the no-connection-popup, waited, opened a new window and connected there, closed the bad window
Comment with feedback submission on 28 Mar 2011
nothing, just crashed suddenly
Comment with feedback submission on 29 Mar 2011
open database
Comment with feedback submission on 30 Mar 2011
Clicked on a table
Comment with feedback submission on 30 Mar 2011
switched databases
Comment with feedback submission on 4 Apr 2011
Load table structure
Comment with feedback submission on 4 Apr 2011
System lost connection, sequel pro dialog displayed to 'reconnect' which I did, then it crashed.
Comment with feedback submission on 5 Apr 2011
Filtered a table on a foreign key
Comment with feedback submission on 5 Apr 2011
Connection difficulties when SSH tunneling.
Comment with feedback submission on 8 Apr 2011
tried to load a new table on a remote SSH connection
Comment with feedback submission on 10 Apr 2011
Switching to Content view from Structure view, thats all!
Comment with feedback submission on 12 Apr 2011
I opened two windows at same time and connected to same database
Comment with feedback submission on 13 Apr 2011
I just changed database and CMD+Tabbed into another window
Comment with feedback submission on 17 Apr 2011
signed on VPN
Comment with feedback submission on 17 Apr 2011
Killed mysql and started it again while sequel pro was connected
Comment with feedback submission on 27 Apr 2011
Nothing, just bombed
Comment with feedback submission on 27 Apr 2011
dont really remeber sorry!
Comment with feedback submission on 7 May 2011
Tried loading a large-ish table.
Comment with feedback submission on 11 May 2011
running a simple query
Comment with feedback submission on 15 May 2011
alt-click to a table name
Comment with feedback submission on 19 May 2011
Exporting a table from a remote schema
Comment with feedback submission on 26 May 2011
Reconnecting failed. I had it connected from work, then tried to reconnect from home. That's when the crashed happened. After the crash, I simply relaunched the app, and connected without problem. This reconnection problem has happened a number of times in the past - though sometimes the cursor/timer just spins forever. By the way, this app is AMAZING! Thank you, thank you, thank you!
Comment with feedback submission on 26 May 2011
ran query
Comment with feedback submission on 1 Jun 2011
Ran the following on a lark as a test:

SELECT MD5('THINGS AND MORE THINGS')
Comment with feedback submission on 1 Jun 2011
CMD+TAB between Google Chrome and Sequel Pro.
Comment with feedback submission on 5 Jun 2011
Cancelled a dump from a very large table.
Comment with feedback submission on 7 Jun 2011
Tried to export a report to CSV
Comment with feedback submission on 12 Jun 2011
While looking at a table record
I tried to double click on a column to edit
Sequel Pro said it lost connection to server, do I want to reconnect? Yes
It tried reconnecting to mysql db over ssh. Then crashed
Comment with feedback submission on 19 Jun 2011
running Query after computer with Sequel Pro running had slept over night
Comment with feedback submission on 21 Jun 2011
Nothing... it was sitting in the background :-/
I had run an update statement about 5 mins earlier.
Comment with feedback submission on 21 Jun 2011
adding a table
Comment with feedback submission on 21 Jun 2011
switched to a different applicatioin using cmd + tab
Comment with feedback submission on 21 Jun 2011
Attempted to sort results in a table of about ~500
Comment with feedback submission on 22 Jun 2011
Changed databases
Comment with feedback submission on 22 Jun 2011
No idea. I wasn't interacting with the program at all. It was just on and connected to my database.
Comment with feedback submission on 27 Jun 2011
run insert statement
Comment with feedback submission on 29 Jun 2011
tried to load db table
Comment with feedback submission on 1 Jul 2011
I just changed database from the "Choose Database..." list button.
Issue system message on 3 Sep 2011
Automatically reopened: new report received from a revision after this problem was believed to be fixed.
Comment with feedback submission on 1 Dec 2011
export a large db