New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
0.9.8 hangs periodically #677
Comments
Author:rowanb@gmail.com Date:2010-05-07 15:38:42 Is there anything in Console.app, if you fire that up and filter by "Sequel Pro"? Hangs are tricky because we can't capture it very easily. Next time it happens, could you open up Activity That'll hopefully give us a clue as to what's breaking... |
Author:inspir...@gmail.com Date:2010-05-07 15:43:17 Yup! May 7 15:38:23 everybean Sequel Pro[10753]: kCGErrorIllegalArgument: _CGSFindSharedWindow: WID 2002 some older ones too: May 4 09:49:32 everybean Sequel Pro[585]: An uncaught exception was raised
hope it helps! |
Author:jerome.f...@free.fr Date:2010-05-10 09:50:14 I too have the same problem. FYI, I only use mysql connections over ssh. There's nothing in the console that looks suspicious. For me it looks like it happens when the app is let idle in the background with a ssh connection active. |
Author:rowanb@gmail.com Date:2010-05-10 09:54:39 Very mysterious. The console log isn't very informative - anyone running into this, please do open up Activity Then save and post the sample, which will hopefully help track this down. |
Author:jerome.f...@free.fr Date:2010-05-12 05:18:31 Here you go: Total number in stack (recursive counted multiple, when >=5): Sort by top of stack, same collapsed (when >= 5): |
Author:rowanb@gmail.com Date:2010-05-12 06:35:11 Hi Jerome, That's very helpful actually - did that then freeze completely? This looks like it might be something that was addressed in r2216. Is there any chance you could the latest |
Author:jerome.f...@free.fr Date:2010-05-17 01:21:22 Installed r2224, and got the same issue. I fetched a sample from Activity Monitor : Sampling process 2960 for 3 seconds with 1 millisecond of run time between samples Total number in stack (recursive counted multiple, when >=5): Sort by top of stack, same collapsed (when >= 5): |
Author:rowanb@gmail.com Date:2010-05-17 02:26:11 Jerome, Thanks for the update. Looks like it's hanging at the end of a Core Animation (eg fading the progress view in, I |
Author:rowanb@gmail.com Date:2010-05-17 02:28:18 By the way - earlier you said it was when the application had been in the background for a while, eg the Do you have multiple windows open when this happens? Is the progress actually displaying? And is this in the |
Author:inspir...@gmail.com Date:2010-05-17 10:45:29 In my case there was no transaction processing. It was likely that the connection had timed out, however no I usually cmd+h to hide sequel pro while I'm working in other windows, so perhaps its related to attempting to Sounds like my report may be different from the others after all |
Author:jerome.f...@free.fr Date:2010-05-18 00:38:17 OK. New hang. I had only one window opened. It's a connection to mySQL via a SSH tunnel. Note that the sampling below show that a NSTask was running. I don't know if there's a request sent when one dismisses the edition of a cell, but If you want me to test a debug version of Sequel Pro with tons of logs, feel free to send me one. Sampling process 463 for 3 seconds with 1 millisecond of run time between samples Total number in stack (recursive counted multiple, when >=5): Sort by top of stack, same collapsed (when >= 5): |
Author:rowanb@gmail.com Date:2010-05-18 02:58:58 It's definitely a problem somewhere in drawing code - in this case, it's trying to hide the window, going through The NSTask you mention is just used for the SSH tunnel - similarly the NSConnection thread is associated with I'm afraid we probably will have to send you a debug build - I'm afraid I'm out tonight though - tomorrow. |
Author:rowanb@gmail.com Date:2010-05-27 03:06:10 Hi guys, Thanks for your patience. I'd appreciate it if anyone running into this problem try the attached build of Sequel Pro; it's 0.9.8 with an Thanks! |
Author:jerome.f...@free.fr Date:2010-06-03 23:55:48 I'm afradi the test build of 0.9.8 does not fix the issue. I'm still experiencing hangs |
Author:sgrosm...@gmail.com Date:2010-06-11 10:34:28 Here's a dump from the test build: Sampling process 26320 for 3 seconds with 1 millisecond of run time between samples Total number in stack (recursive counted multiple, when >=5): Sort by top of stack, same collapsed (when >= 5): |
Author:justin.m...@gmail.com Date:2010-06-11 11:59:25 i believe i'm getting the exact same issue, i tunnel mysql over SSH and it randomly gets the spin wheel usually when i come back to it. |
Author:justin.m...@gmail.com Date:2010-06-11 12:01:48 i'd be willing to provide an ssh and mysql account on my server for testing if it helps. |
Author:rowanb@gmail.com Date:2010-06-14 09:23:51 Hi to anybody running into this issue, and a little update: This appears to be a problem deep within the window drawing code in the system frameworks. This doesn't necessarily mean it's Apple's fault - we may be setting something up incorrectly. The issues all relate to internal drawing code locking on some condition we can't see; it appears one or two other projects (eg the Google QuickSearch box) are running into the same problem, and it's very hard to pin down. I don't believe it's related to any connection settings, although if it is (eg only occurs for SSH?) that'd be enormously helpful. Anyone who is running into this: please do continue to post your traces, and also a comment indicating roughly how often you run into the problem (vs how often you use Sequel Pro), together with any steps that you've found to trigger this problem. If we find a way to reproduce this code, that'd be 90% of the way to fixing it! For example, I use Sequel Pro for bursts of five minutes throughout the day, and for longer periods in the evening when testing. I've run into this issue approximately once a week, usually when switching windows or applications, but not doing anything particular within those windows. |
Author:justin.m...@gmail.com Date:2010-06-15 20:36:09 just wanted to comment that my previous comment about the nightly not fixing it might not be true, it turns out I was still running the release version. I haven't experience the lockup issue with the nightly so far on two different machines and this was for about 4 hours of total use which some application switching/hiding. i'll report back if i run into it or by next week, i usually end up working in MySQL DB's for 20 hours/week. |
Author:jerome.f...@free.fr Date:2010-06-18 09:15:45 I've been running v0.9.8 build 2210 for a couple of weeks now (this is the test build that's been sent by rowanb on May 27th). I've experienced the same hangs as before with this test build. But I continued to use it on a daily basis. I've now upgraded my system to 10.6.4. Just a coincidence ? |
Author:rowanb@gmail.com Date:2010-06-18 09:18:25 Very interesting, Jerome! I had been starting to suspect a CoreVideo/CoreAnimation issue for child windows - I hadn't pinned it down yet. It would well be something they've fixed in 10.6.4; but let's wait a little longer before we assume that! Do report back next week :) |
Author:justin.m...@gmail.com Date:2010-06-20 15:33:20 I hadn't noticed happening with 10.6.4 and the latest nightly and was hoping it was fixed, however it just did it after I switched back to Sequel Pro after working with Textmate and leaving it alone for 5-10 minutes. I'm attaching a process sample and a crash report. my offer to provide an ssh account and mysql account to my offer still stands for anyone that wants to debug this. |
Author:justin.m...@gmail.com Date:2010-06-20 19:42:12 Just had another lockup, however this one happened the moment I switched back into Sequel Pro from Textmate, however the lockup didn't happen instantly. When I switched back to Sequel Pro, i was able to create a new table and save and then the lockup happened. I've attached a process sample. |
Author:jerome.f...@free.fr Date:2010-07-02 05:42:51 I just installed the latest build 2389 today, in hope.... He's the process sample. Good luck ! |
Author:jerome.f...@free.fr Date:2010-07-02 05:43:18 I just installed the latest build 2389 today, in hope.... He's the process sample. Good luck ! |
Author:rowanb@gmail.com Date:2010-07-05 16:40:45 OK all - apologies that this is taking so long to track down; I haven't been able to trigger this for a couple of weeks. Something that may help - I've put together two builds which remove two things:
This will hopefully prove to be more stable, and if it is we can slowly restore appearance tweaks to pin down the issues. There are two builds available - one tweaked version of 0.9.8, and one tweaked version of a recent nightly build (r2421). Let me know how it goes... |
Author:justin.m...@gmail.com Date:2010-07-08 05:35:36 so far the nightly-noCA build hasn't crashed at all, it's been running for almost 24 hours without quitting. |
Author:rowanb@gmail.com Date:2010-07-08 05:38:56 Thanks for the update! I assume you normally run into it much more often than that? Let's give it a couple of days longer to make sure, and then I'll add another build which re-enables one piece of functionality I'm starting to suspect. |
Author:justin.m...@gmail.com Date:2010-07-08 05:55:30 It usually doesn't last more than an hour, I'll keep it going and report back in a few days. |
Author:rowanb@gmail.com Date:2010-07-08 06:00:47 An hour!! Apologies, I didn't realise it was affecting anyone quite so often. The upside is that that'll make it much easier to isolate a fix/workaround - though I'm sure that's no real consolation ;) |
Author:jerome.f...@free.fr Date:2010-07-25 02:19:30 Ouch. Just got a hang with CAalpha3 Here's exactly what I did before it hung:
Hope this helps |
Author:jerome.f...@free.fr Date:2010-07-25 02:19:58 Better if I actually attach the file. Ain't it ? |
Author:rowanb@gmail.com Date:2010-07-25 04:55:14 Aargh :) Thanks both for the continued testing. These later stacktraces are subtly different - they're crashes when drawing a layer, not when committing a core animation transaction. It's increasingly looking like Core Animation in any form in child windows is causing this hang; now that the fade is rewritten, it's the layer-backed view (for shadows) that is still at fault. The combination of both seems to be much worse than either individually. So the next logical step is to remove the layer backing from the views, and do that drawing ourselves as well. Watch this space... |
Author:rowanb@gmail.com Date:2010-07-25 06:46:49 This version - again, a tweaked nightly - replaces all the layer-backed views with manual drawing. This has the rather pleasant side effect that this build no longer triggers discrete graphics chips in latest-gen laptops. http://dev.sequelpro.com/uploads/sequel-pro-nightly-CAalpha4.dmg Once again, fingers crossed. (Also: those of you running into crashes, had you used tabs? If yes, writing up this bug for Apple may be a little more complex: please let me know!) |
Author:jerome.f...@free.fr Date:2010-07-25 07:41:31 Tabs ? no I wasn't even aware that Sequel Pro had tabs. Damned pretty nice ! |
Author:rowanb@gmail.com Date:2010-07-25 07:55:22 Good, that simplifies things! (0.9.8 doesn't have tabs anyway - added to the nightlies not so long ago - but various code paths that you're testing have all changed as a result) |
Author:fla...@gmail.com Date:2010-07-25 08:33:15 Haven't been using tabs (since the goal is usually to have two windows side-by-side for comparison.) |
Author:rdsh...@gmail.com Date:2010-07-27 06:59:38 I just had it hang using CAbuild4. The sample process result is attached. |
Author:rowanb@gmail.com Date:2010-07-27 07:12:21 Robert - thanks for the report. This sample is completely different to the others (which is a good thing!), but curiously I can't see anything in here that looks like a hang cause. In fact, the sample looks perfectly normal, as if it's drawing only part of the time. Was this a beachballing hang, or was it a different type of hang - where the task window stayed up, but the task never completed but the window controls stayed disabled? |
Author:rdsh...@gmail.com Date:2010-07-27 07:28:01 Interesting. This wasn't a beachballing hang - SequelPro was trying to load a table (not that large in terms of rows / columns) and the loading task window came up and didn't go away, nor did the table actually load. |
Author:rowanb@gmail.com Date:2010-07-27 07:31:11 Oh phew! That is a slightly different problem - I think I've fixed that problem for imports, but not for table loading yet. Basically, some problem - usually connection related - causes the load to abort, but does so in a messy way so that the task doesn't complete. This is definitely on our radar, but is thankfully separate from this issue :) |
Author:rdsh...@gmail.com Date:2010-07-28 01:35:27 Great - glad to hear that this is a clear improvement. I'll let you know if I run into any other issues with CAbuild4. Please let me know if there's a new build around this issue that I should be testing for you. Thanks! |
Author:rowanb@gmail.com Date:2010-07-28 18:04:49 Has anyone else been using CAbuild4, and if so have you run into the hang? I'm hoping that no news is good news :) |
Author:justin.m...@gmail.com Date:2010-07-28 19:10:45 sadly I haven't had the chance since I've been doing a ton of non-database related work. tomorrow i'll be back in the database world and i'll report back. |
Author:sgrosm...@gmail.com Date:2010-07-29 06:04:01 I'm in Flash mode for the next couple of days, but I'll run it in the background and move though the UI when I can remember to. |
Author:justin.m...@gmail.com Date:2010-07-29 09:43:22 I installed CAalpha4 build 4 hours ago and have been using it casually and it hasn't crashed yet. Crashes tend to happen in the first hour so I would say this one is good. |
Author:rowanb@gmail.com Date:2010-07-30 14:12:43 Any further feedback? Based on the positive responses so far, I think it's looking good (fingers crossed), so will commit to trunk soon - and that means we can probably go 0.9.8.1 this weekend :) |
Author:justin.m...@gmail.com Date:2010-07-30 19:04:27 still good so far, no crashes, haven't quit CAalpha4 build for over 48 hours. |
Author:rdsh...@gmail.com Date:2010-07-31 13:06:27 After that first (apparently unrelated) hang, CAbuild4 has been running smoothly. |
Author:rowanb@gmail.com Date:2010-07-31 15:37:15 I've committed the fix for this to trunk in r2482. You have no idea how incredibly glad I am that this bug is fixed - it's been incredibly frustrating :) Jerome, Justin, inspire22, sgrosmark, Ted, Robert, Adam: many, many thanks for all your testing and feedback on this. Without you guys, this would never have been fixed as I simply wasn't able to reproduce it. We'll get working on a 0.9.8.1 so everyone can benefit from this. Thanks again all :D |
Author:jerome.f...@free.fr Date:2010-08-18 03:29:10 Back from holidays.... |
Author:justin.m...@gmail.com Date:2010-08-18 13:27:17 So i'm using 0.9.8.1 Build 2492 and I had a lockup that seemed to be the same thing, happened after I quickly switched back in, I've uploaded a process sample. |
Author:rowanb@gmail.com Date:2010-08-18 13:54:01 Justin, You almost gave me a heart attack there :) While the symptoms were very similar, the cause appears to be quite different - I've logged this as Issue #792 . As always, thanks :) |
Author:sergiopi...@gmail.com Date:2010-08-31 07:07:55 OSX 10.5.8 - Mysql 5.0 and/or 5.1 - Sequel Pro 0.9.8.1 - Often freeze (with kill process needed) running query for this reason: 8/31/10 3:57:16 PM Sequel Pro[61535] *** -[NSLock lock]: deadlock (<NSLock: 0x1613b6b0> '(null)') It happens frequently. |
Author:rowanb@gmail.com Date:2010-08-31 07:11:56 sergiopiero, That looks to be a separate issue, and is quite possibly 10.5.8-only. Is there any chance you could sample Sequel Pro next time it happens, and post as a new issue? Thanks :) |
@sequelpro Oh, the link is dead now. What was the fix? |
@barracuda156 use https://github.com/Sequel-Ace/Sequel-Ace as Sequel Pro is no longer updated. |
Issue imported from Google Code: https://code.google.com/p/sequel-pro/issues/detail?id=677
Reporter:inspir...@gmail.com Date:2010-05-07 14:44:24 Status:Fixed Closed:2010-07-01
Sorry, I haven't noticed a pattern.
Idling. Long running queries sometimes. I've had to force-kill it 3 times today.
mysql version 5.1.37
thanks for a great product!
The text was updated successfully, but these errors were encountered: