Bug #107425 Application Crash
Submitted: 30 May 2022 7:39 Modified: 2 Jun 2022 5:11
Reporter: micha weiss Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S1 (Critical)
Version:8.0.29.0 OS:Windows (2019)
Assigned to: CPU Architecture:Any
Tags: ODBC, windows 2019

[30 May 2022 7:39] micha weiss 
Description:
Faulting application name: MgxpaRuntime.exe, version: 4.7.2.354, time stamp: 0x60b1bf64
Faulting module name: myodbc8w.dll, version: 8.0.29.0, time stamp: 0x623c3e76
Exception code: 0xc0000005
Fault offset: 0x000379c1
Faulting process id: 0x27b0
Faulting application start time: 0x01d873f722817d41
Faulting application path: \\132.64.7.150\magic\prog\magic\MagicXpA472\MgxpaRuntime.exe
Faulting module path: C:\Program Files (x86)\MySQL\Connector ODBC 8.0\myodbc8w.dll
Report Id: a7f624e8-5813-46bf-829e-449dfb6fe1a9
Faulting package full name: 
Faulting package-relative application ID: 

How to repeat:
View Table
[30 May 2022 7:47] micha weiss 
We'm stuck in the middle of upgrading from version 5 to version 8
[30 May 2022 12:11] MySQL Verification Team 
Hello,

Thank you for the bug report.
Could you please let us know the exact steps to reproduce this issue at our end?

Regards,
Ashwini Patil
[30 May 2022 12:39] micha weiss 
Hello
We are using an application that is call MagicXpa
This application perform a simple select then crash as you see.
This is the log from the server side:
# Time: 2022-05-30T12:21:36.132328Z
# User@Host: XXXXXX[XXXXXX] @ magic-sync.cc.huji.ac.il [132.64.AAA.BBB]  Id:  9798
# Query_time: 0.000419  Lock_time: 0.000005 Rows_sent: 1  Rows_examined: 2
SET timestamp=1653913296;
SELECT `id`,`htoar`,`etoar`,`emeritus`,`hname`,`hfamily`,`ename`,`efamily`,`zehut`,`oldzehut`,`uniqid`,`list`,`workstatus`,`workflag`,`contract`,`contractdate`,`pensiontype`,`darga`,`edepartment`,`hdepartment`,`taarich_idkun_mamka`,`lastaccess`,`maamad`,`hr`,`student`,`pre_student`,`student_nofac`,`curr_year_student`,`prev_year_student`,`pre_post_student`,`post_student`,`doctoral_student`,`postdoctoral_student`,`teacher`,`pensioner`,`email1`,`email2`,`tele1`,`tele2`,`cell`,`campus`,`student_faculties`,`student_faculties_old`,`zehut9`,`peopleng_id` FROM `peopleng` WHERE  `zehut9` = '12345678'   ORDER BY `zehut9` ASC ,`peopleng_id` ASC;
[2 Jun 2022 5:03] micha weiss 
We were able to resolve the issue by reinstalling the windows server after trying to figure out the problem with the existing server
[2 Jun 2022 5:11] MySQL Verification Team 
Hello,

Thank you for confirming that issue is no longer seen after reinstalling.
Closing the report for now.

Regards,
Ashwini Patil