Kbase P142063: Progress SQL92 server process crashes when running a multi-database Cyberquery query.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/07/2010 |
|
Status: Verified
SYMPTOM(s):
Progress SQL92 server process crashes when running a multi-database Cyberquery query.
Cyberquery report only displays 20 records but should display more.
SYSTEM ERROR: Memory violation. (49)
SYSTEM ERROR: Bus error. (48)
Stacktrace from _sqlsrv2 reads:
__1cNquery_reply_tPprocess_request6M_i_()
__1cOserver_reply_tNexecute_reply6MppCpi_i_()
__1cNquery_reply_tHexecute6MpCp1pi3nLsqlm_type_t__i_()
__1cMsrv_nw_hdl_tNdsn_listen_106MipvpnKsvr_args_t__i_()
Stacktrace from _sqlsrv2 reads:
__1cQmarshal_server_tQumsh_query_sqlda6MppnFsqlda_pnMsrv_nw_hdl_t_pC_i_()
__1cQmarshal_server_tSumsh_query_request6MpnNquery_reply_t__i_()
__1cOserver_reply_tNexecute_reply6MppCpi_i_()
__1cNquery_reply_tHexecute6MpCp1pi3nLsqlm_type_t__i_()
FACT(s) (Environment):
Cyberquery report uses prepared statements to select records from db1.table1 which feeds the results into a select on db2.table2 which then feeds the results into a select on db1.table3.
Cyberquery report works fine if the tables contain minimal records.
OpenEdge 10.0B
Solaris
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
Upgrade to 10.1C03 or later.