| Rob Waywell 2005-12-14, 11:23 am |
| What we'd really like to see is the reproducible case showing the hang.
Since you now have a workaround you can submit that throught Submit a Bug
link shown below my signature block.
--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional
Sybase's iAnywhere Solutions
Please respond ONLY to newsgroup
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports:
http://case-express.sybase.com/cx/c...sc?CASETYPE=Bug
SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
"Jason Boardman" < nospam_jasonboardman
_@_gmail_._com> wrote in message
news:439f3c9f@forums
-2-dub...
> Just to throw this out there - here's how I fixed the previously stated
> problem (in my first post: "help: dbisqlc hangs when deleting large # of
> rows") for anyone who wants to file it away:
>
> The problem: (using v 9.0.2.3169 / linux) when trying to delete large
> numbers of rows in dbisqlc, it and the server would hang and i would have
> to kill the process on both and restart. i unloaded and rebuilt the
> database and still had the same problem.
>
> How I fixed it: i unloaded the db, and hand-edited the reload.sql command
> file and removed the entire "Reload Statistics" portion from it before
> reloading. The db rebuilt fine and subsequently performed perfectly when
> deleting any number of rows in any fashion i chose.
>
> I don't know why this worked or even what the "Reload Statistics" portion
> is for (it looks like maybe how to handle changes in page size from unload
> to rebuild? but i dunno) but it did work for me in this case. Perhaps a
> sybase-master can read this and post reasons why this might have worked or
> what it may mean?
>
> Jason Boardman
|