ecpg: unstable INSERT operation

Edward Pilipczuk (edx(at)astercity(dot)net) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
ecpg: unstable INSERT operation

Long Description
Frequently INSERT operation causes backend crash (with SIGSEGV) or the parser reports: error [-400] 'ERROR: parser: parse error at or near "^Y"' in line xxx.

Sample Code
Table definition:
Table "rdr_meas"
Attribute | Type | Modifier
-----------+--------------------------+------------------------------------------
seq | integer | not null default nextval('rdr_meas_serial_seq'::text)
name | character(8) | not null
loc | character(8) | not null
ts | timestamp with time zone | not null
devstat | integer | not null
meastat | integer | not null
relative | real |
level | real |
ullage | real |
levelrate | real |
volume | real |
Index: rdr_meas_pkey

Embedded code:
...............
long sql_checkresult()
{

if ( sqlca.sqlcode ) {
sprintf( buf, "%s [%d] %s", sqlca.sqlcode<0?"error":"warning",
sqlca.sqlcode, sqlca.sqlerrm.sqlerrmc );
error_hndlr( WARN_SQL, MSG_SQL, buf );
};
return( sqlca.sqlcode );
}
...............
int db_savemeas( rdr, ms )
{
...............
sprintf(buf,"INSERT: '%.8s'%.8s'%.32s' %08x/%08x %f %f %f %f %f",
name, loc, ts, devstat, meastat, relative, level, ullage, rate, volume );
dbg_message( __FILE__, __LINE__, DBG_DBI, MSG_SQL, buf );
exec sql INSERT INTO rdr_meas ( name, loc, ts, devstat, meastat, relative, level, ullage, levelrate, volume )
VALUES ( :name, :loc, :ts, :devstat, :meastat, :relative, :level, :ullage, :rate, :volume ) ;
dbg_message( __FILE__, __LINE__, DBG_DBI, MSG_SQL, "Inserted!" );
if( sql_checkresult() == 0 ) {
exec sql COMMIT;
exec sql SELECT seq INTO :seq FROM rdr_meas ORDER BY seq DESC LIMIT 1;
if( sql_checkresult() == 0 ) {
sprintf(buf,"Data record #%d stored and committed.", seq );
dbg_message( __FILE__, __LINE__, DBG_DBI, MSG_SQL, buf );
return( seq );
};
};

..............
error_handler and dbg_mesage produces the following types of entries in syslog:

...: DEBUG(dbi.pgc/760) SQL: INSERT: 'NR3 'Swedwood'2001-08-06 23:22:08' 00000000/00001000 35.978611 0.841900 1.498100 -0.000002 4.132665
...: DEBUG(dbi.pgc/767) SQL: Inserted!
...: Error condition occured: WARNING: Data base SQL exec error.
...: -- SQL: error [-400] 'ERROR: parser: parse error at or near "^Y"' in line xxx.

Some times appears that the ecpg program abnormally terminates with the following trace logged by the parent process: signal #17=SGCHLD, existstatus of the child process (SIGSEGV in HEX) is presented here as a value returned by waitpid:

...: DEBUG(radnew.c/129) TASK: SIGNAL #17 catched.
...: DEBUG(radnew.c/203) TASK: Child process abnormally terminated, exitstatus=0000000b

No file was uploaded with this report