Informix - Problem description
Problem IT27550 | Status: Closed |
CREATE DATABASE MAY REPORT ERROR -673 WHEN CREATING INTERNAL UDRS LIKE LOCOPY OR SYNC_MONGO_USERS | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
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 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS 12.10.xC11 and older versions. * **************************************************************** * PROBLEM DESCRIPTION: * * Create database may report error -673 when creating internal * * UDRs like locopy or sync_mongo_users. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 26.12.2018 07.10.2019 07.10.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC12 | |
Problem solved according to the fixlist(s) of the following version(s) |