When running concurrent create database statements, they may
occasionally fail with error -673.
Trapping the error may show the following picture:
09:21:44 Assert Failed: found errno 673 in session 32
09:21:44 Who: Session(32, informix@, 20401, 0x4841ca18)
Thread(50, sqlexec, 483df5c8, 8)
File: rsdebug.c Line: 3552
09:21:44 Action: Use onmode -I to stop verbose error trapping.
sqscb info
scb sqscb optofc pdqpriority
optcompind directives
48d451c0 4acb1028 0 0 0
1
Sess SQL Current Iso Lock SQL
ISAM F.E.
Id Stmt type Database Lvl Mode ERR
ERR Vers Explain
32 CREATE PROCEDU sysuser CR Not Wait -673
0 9.24 Off
Current SQL statement (909) :
create dba function informix.locopy(informix.blob, char(128),
char(128))
returns informix.blob with (handlesnulls) external
name
'(blob_copy_colspec)' language c variant;
Last parsed SQL statement :
create dba function informix.locopy(informix.blob, char(128),
char(128))
returns informix.blob with (handlesnulls) external
name
'(blob_copy_colspec)' language c variant;
Or
14:36:17 Assert Failed: found errno 673 in session 993
14:36:17 Who: Session(993, informix@, 0, 0x496bf478)
Thread(1003, dbWorker4, 49fadcb8, 1)
File: rsdebug.c Line: 3398
14:36:17 Action: Use onmode -I to stop verbose error trapping.
14:36:17 SHM Globals and Master Pool/Master Block Adresses:
Sess SQL Current Iso Lock SQL
ISAM F.E.
Id Stmt type Database Lvl Mode ERR
ERR Vers Explain
993 CREATE PROCEDU sysuser DR Wait 5 -673
0 - Off
Current SQL statement (114) :
CREATE FUNCTION IF NOT EXISTS
informix.sync_mongo_users(task_id INT
DEFAULT -1, task_seq INT DEFAULT -1)
RETURNING INTEGER DEFINE ifxdir VARCHAR(130); DEFINE cmd
VARCHAR(255);
CREATE TABLE IF NOT EXISTS sysmongousers ( username
nchar(32), hashed_password varchar(128) ) lock mode row;
CREATE
UNIQUE INDEX IF NOT EXISTS sysmongousers_idx_username ON
sysmongousers(username) IN TABLE; SELECT |
