Bus Error (core dumped)

haamid.gazi · Post by **haamid.gazi** » Thu Sep 18, 2008 1:59 pm

Hi Jon,

I am trying to run this query and I am getting this error when I run the query from command window:

select ticket from ticket where ((title\tick_txt\tic_text\attch_text likep 'banana') or (tic_comm likep 'banana' and Prod in ('21983','21984','23492','23622','23624','25511','25512','25516','35028'))) and (Prod in ('21983','21984','23492','23622','23624','25511','25512','25516','35028','25517','35029'))

I get some results but after that I get this error:

Bus Error (core dumped) can you please help me in resolvin gthe issue.
Regards
Haamid

Post by **mark** » Thu Sep 18, 2008 2:09 pm

Are there any other messages before the Bus Error?
Are you running this in tsql, vortex, or your own C program? Sounds like maybe your own C program since tsql and vortex will trap the Bus Error and say ABEND. What if you do the same query in tsql?

haamid.gazi · Post by **haamid.gazi** » Thu Sep 18, 2008 2:10 pm

Hey Mark,

I am running the above query in tsql prompt itself.

Regards
Haamid

haamid.gazi · Post by **haamid.gazi** » Thu Sep 18, 2008 2:12 pm

This is the full result set:

Texis Version 05.01.1171516286(20070214) Copyright (c) 1988-2007 Thunderstone EPI

ticket
------------+
4383201
6987501
6958922
6958922
Bus Error (core dumped)

Post by **mark** » Thu Sep 18, 2008 3:12 pm

What is your full tsql command line?
Did you perform any SQL "set" statements before running the select?
Does it work if you remove the redundant
and Prod in ('21983','21984','23492','23622','23624','25511','25512','25516','35028')
part of the where clause?
Does the newer version you were sent in December behave the same way?

haamid.gazi · Post by **haamid.gazi** » Thu Sep 18, 2008 6:14 pm

Hey mark those are not redundant actually lets break the full query into parts:
((title\tick_txt\tic_text\attch_text likep 'banana') or (tic_comm likep 'banana' and Prod in ('21983','21984','23492','23622','23624','25511','25512','25516','35028'))) and (Prod in ('21983','21984','23492','23622','23624','25511','25512','25516','35028','25517','35029'))

part1

((title\tick_txt\tic_text\attch_text likep 'banana') or (tic_comm likep 'banana' and Prod in ('21983','21984','23492','23622','23624','25511','25512','25516','35028')))

This part gives the result which match in the index mentioned. (tic_comm likep 'banana' and Prod in ('21983','21984','23492','23622','23624','25511','25512','25516','35028'))).
thispart I am trying to get all the results which match tic_comm but are in the prods mentioned so this restirction applies only for tic_comm and not the whole result set.

Part2: and (Prod in ('21983','21984','23492','23622','23624','25511','25512','25516','35028','25517','35029'))

This is a restriction on all results that all the results should be within this group only.

Regards
Haamid

Post by **mark** » Fri Sep 19, 2008 10:26 am

What about the other 3 questions?

What is your full tsql command line?
Did you perform any SQL "set" statements before running the select?
Does the newer version you were sent in December behave the same way?

haamid.gazi · Post by **haamid.gazi** » Fri Sep 19, 2008 3:36 pm

tsql "select ticket from ticket where ((title\tick_txt\tic_text\attch_text likep 'banana') or (tic_comm likep 'banana' and Prod in ('21983','21984','23492','23622','23624','25511','25512','25516','35028'))) and (Prod in ('21983','21984','23492','23622','23624','25511','25512','25516','35028','25517','35029')) ;"

2. I didnt use any sql set statement
3. we dont have the dember version so cant tell wether it would help or not

Post by **mark** » Fri Sep 19, 2008 3:49 pm

Open a ticket to get it again, or an update if you have maintenance.

haamid.gazi · Post by **haamid.gazi** » Fri Sep 19, 2008 4:52 pm

Hi Mark,

Are you sure changing the version would resolve the issue or do we have to make change in the query or index to make it running. because making a change for version would involve effort just wanted to confirm if that could resolve the issue.