7.1 Beautifier dies on reformatting a PL/SQL package

[Stew Stryker]

I accidentally told it to Beautify a package and finally killed the process after 5 minutes. It was taking 98% of my CPU. The package is 1400 lines, what I'd call medium-sized.

I believe this was reported in the Beta forum, but I never tested whether it was resolved or not.

My machine has 2 Gb of memory and a fairly fast processor, plenty of disk space, running XP SP2. It was NOT running a virus scan in the background, nothing remarkable going on at the same time.

I can email you the package source, but given that it's not that big, I should think you'd be able to recreate this with local code samples?

Good luck!

Stew

 

[Marco Kalter]

Can you send me the package source? Maybe there is something specific that causes this problem.

 

[Stew Stryker]

That's odd!!! I tried again with the same package (I think) and it worked nicely!

I'm sorry to have raised this and been wrong.

My apologies,

 

[Stew Stryker]

This is still locking up on me, but of course it's intermittent. I kept hoping someone else would have it happen to them and have a small set of code that consistently generates the crash.

These days I make sure I save before I run Beautifier, but it's still happening a few times each day, which gets annoying. The package is about 1000 lines. I suspect it happens more when Beautifying the body than the spec, but obviously the body is bigger, so more likely to croak?

Can anyone confirm this is happening too?

 

[Dave Sharpe]

Re "Can anyone confirm this is happening too?"

Yes, a coworker of mine (actually our departmental SQL guru) has also been experiencing this problem.

 

[Stew Stryker]

Dave,

Thanks for showing that I wasn't crazy!

At least about this...

 

[andyh]

I'm also getting intermittent hangs during the recompilation of large packages - I have Beautifier set to perform prior to compile.

Task Manager shows *two* PL/SQL Developer applications as not responding, whilst processes shows just the one plsqldev.exe process.

CPU usage goes to 50%, memory usage to 50Mb.

 

[Stew Stryker]

Andy,

Thanks for bringing this up. What happens if you turn off the "Beautify before compile" option?

My task manager saying plsqldev.exe getting about 97% of my processor. Any chance you're running on a dual-processor machine, so the overall usage would only be 50%?

 

[Dezsoe Kados]

I have sometimes similar problems with the beautifier which is only started manually (and not e.g. by compilation). The beautifier 'eats' the whole cpu and only restarting PLSD helps.
Unfortunately the problem is not well reproducible, but it happens from time to time. I most cases the same(!) source is beautified without problems after PLSD restart. For the few cases, where PLSD restart was not enough "select all" before beautify seemed to solve the problem (but I'm not really sure about this).
I'm using PLSD 7.1.1.1339 on XP SP2, the Oracle Database version 10.2.0.2.0 on a Linux platform.

 

[andyh]

Originally posted by Stew Stryker:
Andy,

Thanks for bringing this up. What happens if you turn off the "Beautify before compile" option?

My task manager saying plsqldev.exe getting about 97% of my processor. Any chance you're running on a dual-processor machine, so the overall usage would only be 50%?

Yes, I have a dual-core machine so I guess that PLD took all of one.

I'll try using PLD without Beautifier automatically running prior to the compile.

 

[fantom_v]

Originally posted by Marco Kalter:
Can you send me the package source? Maybe there is something specific that causes this problem.

Hello, all. I think I have the same problem.I have found how to avoid it. The beautifier hangs when there are bookmarks or breakpoints in package and no matter how big is it. When i choose "remove all breakpoints" or/and "remove all bookmarks" - it work correctly. So before beautifying i remove all bookmarks and breackpoints. And after - i push them back if needed .

 

[Sebastien]

I have the same issue with the beautifier.

Sebastien

 

[Stew Stryker]

fantom_v,

Excellent job determining that the Bookmarks are the key to this failure!

I just confirmed it on a package of mine. I was editing it, saved it, said Beautify, IT LOCKED UP. Then I opened the recovery file, said Beautify, BEAUTIFY WORKED, I added 3 bookmarks, said Beautify, IT LOCKED UP.

Exactly as you said.

Great, now the developers have something to work with and can fix it!

Thanks!!!

 

[Marco Kalter]

Thanks, we'll fix it.

 

[jschmied]

Hi!

Is there any relese date planed?

I've to kill the plsqldev about 10 times a day.

It's quite anoying. I'd take any prerelease

Thanks!

Juergen

 

[Stew Stryker]

Juergen,

Did you not like using fantom_v's workaround?

I agree that it needs to be fixed soon, but dropping the bookmarks or just Beautifying a small block of code seems a lot simpler than crashing PSD that often.

Good luck,

Stew

 

[jschmied]

Hi!

I've used to type some lines in without caring about formatting and then hit a hotkey to format these lines....