Watch, Follow, &
Connect with Us

QualityCentral

Public Report
Report From: InterBase/Server    [ Add a report in this area ]  
Report #:  100015   Status: Closed
Interbase crashes on executing query
Project:  InterBase Build #:  10.0.3.566
Version:    10.0 Submitted By:   Juan Carlos Porras Boada
Report Type:  Crash / Data loss / Total failure Date Reported:  10/13/2011 10:15:47 AM
Severity:    Critical / Show Stopper Last Updated: 4/26/2013 9:03:56 PM
Platform:    Windows 95/98/NT 4.0 on Intel Internal Tracking #:   288612
Resolution: Fixed (Resolution Comments) Resolved in Build: : Update 4
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: 4
Description
Executing this query interbase crashes:

delete from NM_NVDADEMPLEADO NE where NE.FC_DMNIOGNRAL_ID in ( SELECT E.FC_DMNIOGNRAL_ID  FROM NM_EMPLEADO E  where E.GN_CMPNIA_CDGO = 3 and  E.NM_GRPONMNA_CDGO = 103 and E.FC_DMNIOGNRAL_ID >= 0)


   Access violation.


The code attempted to access a virtual


address without privilege to do so.

This exception will cause the InterBase server

to terminate abnormally.

WIN-OSR53PR5H9T (Client)
Thu Oct 13 12:01:59 2011

C:\Embarcadero\InterBase\bin\ibserver.exe: terminated abnormally (-1)


WIN-OSR53PR5H9T (Server)
Thu Oct 13 12:02:01 2011

SERVER/set_process_affinity: hyper-threading ProcessAffinityMask is f

WIN-OSR53PR5H9T (Server)
Thu Oct 13 12:02:01 2011

Server: setting SWEEP_QUANTUM to 250, USER_QUANTUM to 1000,
        SWEEP_YIELD_TIME to 1 ms, and MAX_THREADS to 1000000
        SQL_COMPILER_RECURSION to 2000


WIN-OSR53PR5H9T (Client)
Thu Oct 13 12:02:01 2011

Guardian starting: C:\Embarcadero\InterBase\bin\ibserver.exe
Steps to Reproduce:
How can attach a ibk compressed of my database?
Workarounds
None
Attachment
SIAGEMDB crash example Final 2.zip
Comments

Juan Carlos Porras Boada at 10/13/2011 10:29:42 AM -
How can attach a ibk compressed of my database?

Tomohiro Takahashi at 10/13/2011 5:52:49 PM -
Please use Windows native QC Client to attach a .zip file to your existing report.
The standalone client is available at this URL.
http://qc.codegear.com/qualitycentral.zip

Could you also provide more detailed [Steps] to reproduce your issue?
and, if you have any sample project(e.g., Delphi, C++Builder), please include sample project in the attachment.

Juan Carlos Porras Boada at 10/14/2011 9:32:01 AM -
Hello,

Zip is 21 MB. Atachment doesn't work.

Can i send you in another way?

Juan Carlos Porras Boada at 10/14/2011 9:36:00 AM -
it finish. Attachment works.

Please, Restore database User:SYSDBA, Password Masterkey, it uses FreeAdhocUDF. After restore it please execute query statement      delete from NM_NVDADEMPLEADO NE where NE.FC_DMNIOGNRAL_ID in ( SELECT E.FC_DMNIOGNRAL_ID  FROM NM_EMPLEADO E  where E.GN_CMPNIA_CDGO = 3 and  E.NM_GRPONMNA_CDGO = 103 and E.FC_DMNIOGNRAL_ID >= 0), it crashes ibserver.exe...

Tomohiro Takahashi at 10/16/2011 5:27:32 PM -
Since attached database file is too big, we can not open/promote this report into our internal tracking system.
Can you reduce the size and re-attached it?

Tomohiro Takahashi at 10/14/2011 11:44:06 PM -
> .. , it uses FreeAdhocUDF.  ...
Does your issue depends on the UDF?

Juan Carlos Porras Boada at 10/15/2011 5:29:26 AM -
This issue not depends on the UDF. As you see in this query doesn't exist any call to UDF function.

Tomohiro Takahashi at 10/14/2011 11:45:16 PM -
I strongly advise you to contact technical support service first if you need more intensive support and official reply from Embarcadero.
http://support.embarcadero.com/

Juan Carlos Porras Boada at 10/15/2011 6:33:03 AM -
https://forums.embarcadero.com/message.jspa?messageID=308120

Juan Carlos Porras Boada at 10/15/2011 5:49:57 AM -
Besides, this is a known problem of Interbase XE as you can see https://forums.embarcadero.com/message.jspa?messageID=298047, so please if you can reproduce it with information i give you, why don't use it to resolve this issue?

Juan Carlos Porras Boada at 10/15/2011 5:32:26 AM -
You want to say me that you can't help about this issue?

I used that UDF on INTERBASE SMP 2009 and never get this kind of error. This error happend when we upgrade to INTERBASE XE...

Tomohiro Takahashi at 10/15/2011 7:01:52 PM -
As you know, QualityCentral is NOT technical support service. So, if you need official reply(including hotfix, patches etc...) from Embarcadero, please contact technical support.
http://support.embarcadero.com/

Juan Carlos Porras Boada at 10/16/2011 1:44:05 PM -
Ok...

What is the way to contact technical support? I don't have user and password...

Tomohiro Takahashi at 10/16/2011 5:25:47 PM -
Please contact Sales rep of Embarcadero about technical support contract.

Juan Carlos Porras Boada at 10/17/2011 7:18:06 AM -
What kind of feedback do you need? Can you be more specific?

Tomohiro Takahashi at 10/18/2011 4:18:18 AM -
Have you already contacted technical support service?
http://support.embarcadero.com/


and, since attached database file is too big, we can not open/promote this report into our internal tracking system.
Can you reduce the size and re-attached it?

Juan Carlos Porras Boada at 11/3/2011 8:45:24 AM -
Hello..

This is database to reproduce that INTERBASE XE bug.

I downloaded it from qc 100015 report, unziped it and restored it on my nettop... it worked fine.

I hope you can do it too...

quinn wildman at 12/2/2011 3:35:13 PM -
I have reproduced your problem and submitted the issue to R&D for further investigation. Note that my observation is the first two clients to run the query appeared to hang. The third client running the query caused the crash.

quinn wildman at 12/2/2011 2:29:44 PM -
I have downloaded your attachment and I am investigating your report. Thanks for your report.

Server Response from: ETNACODE01

Copyright© 1994 - 2013 Embarcadero Technologies, Inc. All rights reserved.