SAP Knowledge Base Article - Preview

2173776 - SAP IQ Create/Alter for user to enable 'VERIFY_PASSWORD_FUNCTION' caused crash in 15.4

Symptom

Server crashes with CREATE USER and ALTER USER statements with password when VERIFY_PASSWORD_FUNCTION is enabled in 15.4.

stacktrace from .iqmsg file:

I. 05/25 15:40:34. 0000395545 **************************************************
I. 05/25 15:40:34. 0000395545 ***   Sybase IQ Abort:
I. 05/25 15:40:34. 0000395545 ***      From:  st_server.cxx:1430
I. 05/25 15:40:34. 0000395545 ***      PID: xxxxxx
I. 05/25 15:40:34. 0000395545 ***      Message: caught signal 11, program abort
I. 05/25 15:40:34. 0000395545 ***      Thread: xxxxxxxxx  (TID: 6)
I. 05/25 15:40:34. 0000395545 **************************************************
[...]
===== Thread Number  603080448  (IQ connID: 0000395545) =====
I. 05/25 15:40:34. 0000395545 pc: 0x7fd121b64b66 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x36
I. 05/25 15:40:34. 0000395545 pc: 0x7fd121b64da1 ucstkgentrace(int, int)+0x111
I. 05/25 15:40:34. 0000395545 pc: 0x7fd121b65e21 DumpAllThreads(char const*, unsigned int, int)+0x111
I. 05/25 15:40:34. 0000395545 pc: 0x7fd12192f4cf hos_ABORT(char const*, unsigned int, char const*, char*, char*)+0x18f
I. 05/25 15:40:34. 0000395545 pc: 0x7fd1223d4b0f SigHndlr+0x4f
I. 05/25 15:40:34. 0000395545 pc: 0x7fd2b96737c0 typeinfo+0x986627b1
I. 05/25 15:40:34. 0000395545 pc: 0x7fd121ca273b saint_iqthresholdddl::Complete(a_statement const*, IConnection*, void const*, unsigned long, char*, unsigned int)+0x14b
I. 05/25 15:40:34. 0000395545 pc: 0x7fd2b9cf9185 Worker::ProcessStatementToBeLogged(unsigned int, unsigned int, unsigned int)+0x235
I. 05/25 15:40:34. 0000395545 pc: 0x7fd2b9d8dec1 _ri_auto_commit()+0x41
I. 05/25 15:40:34. 0000395545 pc: 0x7fd2b9d86518 dbi_alter_user(Connection*, a_statement*)+0x308
I. 05/25 15:40:34. 0000395545 pc: 0x7fd2b9e4a10f DoExecuteStmt(Connection*, a_stmt*, a_statement*, a_stmt_identifier*, unsigned short, unsigned int)+0x176f
I. 05/25 15:40:34. 0000395545 pc: 0x7fd2b9e4d46a db__execute(Connection*, an_sqlpres_receive*)+0x22a
I. 05/25 15:40:34. 0000395545 pc: 0x7fd2b9e599cd RequestProcedure::call()+0x9ed
I. 05/25 15:40:34. 0000395545 pc: 0x7fd2b9cf931e Context::call(Procedure*, Context**)+0x4e
I. 05/25 15:40:34. 0000395545 pc: 0x7fd2b9cf9406 Worker::call_on_stack(Procedure*)+0x56
I. 05/25 15:40:34. 0000395545 pc: 0x7fd2b9e55a6d TopProcedure::call()+0x3d
I. 05/25 15:40:34. 0000395545 pc: 0x7fd2b9cfaf79 Worker::spawn(Procedure*)+0x49
I. 05/25 15:40:34. 0000395545 pc: 0x7fd2b9e55eae EngStream::handle_ind(unsigned char, unsigned int)+0x13e
I. 05/25 15:40:34. 0000395545 pc: 0x7fd2b9e58727 EngStream::execute()+0xcb7
I. 05/25 15:40:34. 0000395545 pc: 0x7fd2b9e54dca RQBaseItem::do_work(Worker*)+0xa
I. 05/25 15:40:34. 0000395545 pc: 0x7fd2b9e81e66 RequestQueue::worker_body()+0x66
I. 05/25 15:40:34. 0000395545 pc: 0x7fd2b9e55446 request_task(void*)+0x46
I. 05/25 15:40:34. 0000395545 pc: 0x7fd2ba28c81d run_task_body+0x2d
I. 05/25 15:40:34. 0000395545 pc: 0x7fd2b9e82a87 UnixTask::pre_body(void*)+0x77
I. 05/25 15:40:34. 0000395545 pc: 0x7fd2b966b7b6 typeinfo+0x9865a7a7
I. 05/25 15:40:34. 0000395545 pc: 0x7fd2b8c43d6d typeinfo+0x97c32d5e
I. 05/25 15:40:34. 0000000000

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

SAP IQ 15.4

Product

SAP Sybase IQ 15.4

Keywords

KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.