SQL Anywhere ultralite - strange crashes of application on zire72

Author

strange crashes of application on zire72

Michal Seliga

2005-07-29, 11:24 am

sybase asa 7.0.4.3536
c++ api
palmos
metrowerks codewarrior 9.3 with latest palmos sdk

i know that asa7 isn't supported, but i need to solve this somehow. any hint
will be useful

my problem is that after writing to some tables application crashes or behaves
incorrectly. possibilities are

1) in palmexit it crashes (debugger will show the problem function is
UlDynMemFree).simulator show message about not word aligned handle

2) it crashes while making insert or update to table. on device it freezes. in
emulator i was able to identify problem like one here
http://www.risingroad.com/symptoms/symptom0118.html. i removed all long varchars
from database and maybe it helped, i can't be sure at the moment

both these things happens sometimes on all devices, but it is quite rare. it
seems that on zire 72 it happens very often. and maybe as side-effect after
several crashes the database ultralite_db_HmLt.pdb will grow in size that it
will fill all available storage (and it seems to be damaged because ULPalmLaunch
will crash when it tries to open it)

did anyone ever heard about similar problem? does anyone know what could cause
it and how to fix it?

i am stuck, because application seems to behave completely unpredictable. all
our customers use it without problems - except 2 of them and for one of them
(which uses zire72) it is absolutely unusable... when i test in emulator then
the same pdb and prc files on freshly started emulator behave differently. if i
do exactly the same steps then from 10 tries it crashes once or twice.

btw. version built on ebf 3526 worked for them without any problem. crashing
started to happen just after we sent them version built on ebf 3536. but i don't
like idea of returning to older ebf (and downgrade all instalations...). do you
think there was some change which could cause this?

thanks in advance
Michal Seliga / Visicom

Tim McClements

2005-09-08, 11:23 am

Like you said, 7.x isn't supported on NVFS devices... we have not tested it.

Are there important fixes which affect your application in ebf 3536? (I
don't see any UL changes in that build number range.) If not, there's no
reason to use it over the older one and I'd suggested trying the older one
with your new version, at least to see how it affects this problem
specifically.

- Tim

"Michal Seliga" <michal.seliga@visicom.sk> wrote in message
news:42ea5050$1@foru
ms-2-dub...
> sybase asa 7.0.4.3536
> c++ api
> palmos
> metrowerks codewarrior 9.3 with latest palmos sdk
>
> i know that asa7 isn't supported, but i need to solve this somehow. any
> hint will be useful
>
> my problem is that after writing to some tables application crashes or
> behaves incorrectly. possibilities are
>
> 1) in palmexit it crashes (debugger will show the problem function is
> UlDynMemFree).simulator show message about not word aligned handle
>
> 2) it crashes while making insert or update to table. on device it
> freezes. in emulator i was able to identify problem like one here
> http://www.risingroad.com/symptoms/symptom0118.html. i removed all long
> varchars from database and maybe it helped, i can't be sure at the moment
>
> both these things happens sometimes on all devices, but it is quite rare.
> it seems that on zire 72 it happens very often. and maybe as side-effect
> after several crashes the database ultralite_db_HmLt.pdb will grow in size
> that it will fill all available storage (and it seems to be damaged
> because ULPalmLaunch will crash when it tries to open it)
>
> did anyone ever heard about similar problem? does anyone know what could
> cause it and how to fix it?
>
> i am stuck, because application seems to behave completely unpredictable.
> all our customers use it without problems - except 2 of them and for one
> of them (which uses zire72) it is absolutely unusable... when i test in
> emulator then the same pdb and prc files on freshly started emulator
> behave differently. if i do exactly the same steps then from 10 tries it
> crashes once or twice.
>
> btw. version built on ebf 3526 worked for them without any problem.
> crashing started to happen just after we sent them version built on ebf
> 3536. but i don't like idea of returning to older ebf (and downgrade all
> instalations...). do you think there was some change which could cause
> this?
>
> thanks in advance
> Michal Seliga / Visicom

Michal Seliga

2005-09-09, 7:23 am

i already found a problem.
there was one strange select i used, when i got rid of it crashes ended. i added
this select almost exactly in time we upgraded to this ebf so thats why i didn't
thought about it. i call it strange select because it used sql features i never
used in ultralite before

so thank you for answer but problem dissapeared (for now)

btw zire72 isn't nvfs device. and later we realized that these problems appeared
on every device we have tried. our customerws who used zire72 were just lucky
and used part of palication with this select i mentioned much more often then others

Tim McClements wrote:
> Like you said, 7.x isn't supported on NVFS devices... we have not tested it.
>
> Are there important fixes which affect your application in ebf 3536? (I
> don't see any UL changes in that build number range.) If not, there's no
> reason to use it over the older one and I'd suggested trying the older one
> with your new version, at least to see how it affects this problem
> specifically.
>
> - Tim
>
>
> "Michal Seliga" <michal.seliga@visicom.sk> wrote in message
> news:42ea5050$1@foru
ms-2-dub...
>
>
>
>

Tim McClements

2005-09-14, 8:24 pm

I see. Would you like to post the troublesome query?

I agree, the Zire 72 is not NVFS... oops.

- Tim

"Michal Seliga" <michal.seliga@visicom.sk> wrote in message
news:43215099$1@foru
ms-2-dub...[color=darkred]
>i already found a problem.
> there was one strange select i used, when i got rid of it crashes ended. i
> added
> this select almost exactly in time we upgraded to this ebf so thats why i
> didn't
> thought about it. i call it strange select because it used sql features i
> never
> used in ultralite before
>
> so thank you for answer but problem dissapeared (for now)
>
> btw zire72 isn't nvfs device. and later we realized that these problems
> appeared
> on every device we have tried. our customerws who used zire72 were just
> lucky
> and used part of palication with this select i mentioned much more often
> then others
>
>
>
> Tim McClements wrote:

Michal Seliga

2005-09-15, 7:23 am

query:

select midpricelistrow.prl_price, minpricelistrow.prl_price as minprice,
maxpricelistrow.prl_price as maxprice, product.prd_price,
product.prc_id,prodcat.prc_idpath
from customer,product,pro
dcat,
(select geninfo.gi_ref,pricelistrow.prl_price
from geninfo,geninfot,pri
celistrow
where geninfo.git_id=geninfot.git_id
and geninfot.git_typ='@MINP'
and geninfot.git_reftab=1
and pricelistrow.prd_id=?
and cast(geninfo.gi_info as smallint)=pricelistr
ow.pl_id
) as minpricelistrow,
(select geninfo.gi_ref,pricelistrow.prl_price
from geninfo,geninfot,pri
celistrow
where geninfo.git_id=geninfot.git_id
and geninfot.git_typ='@MAXP'
and geninfot.git_reftab=1
and pricelistrow.prd_id=?
and cast(geninfo.gi_info as smallint)=pricelistr
ow.pl_id
) as maxpricelistrow,
(select pl_id,prl_price
from pricelistrow
where pricelistrow.prd_id=?
) as midpricelistrow
where customer. pl_id*=midpricelistr
ow.pl_id
and cast(customer.cus_id as char(10))*=minpricel
istrow.gi_ref
and cast(customer.cus_id as char(10))*=maxpricel
istrow.gi_ref
and product.prc_id=prodcat.prc_id
and customer.cus_id=?
and product.prd_id=?

i am afraid it won't help without tables...so script is in attachment

the part i believe can be a problem is cast() - because i never used it before
in any other query and never before i had such problems

i also tried to replace cast with convert but result was the same

Tim McClements wrote:
> I see. Would you like to post the troublesome query?
>
> I agree, the Zire 72 is not NVFS... oops.
>
> - Tim
>
> "Michal Seliga" <michal.seliga@visicom.sk> wrote in message
> news:43215099$1@foru
ms-2-dub...
>
>
>

Sponsored Links