RE: issue wtih foreign keys

[Dave Birdsall]

Hi Mathieu,

Error 8838 usually indicates a core in the tdm_arkcmp process. So you're likely 
running into a bug. What version of Trafodion are you using? (What banner comes 
up when you enter, sqlci?)

I tried your CREATE statements in the latest version of Trafodion and they 
worked for me.

Dave

From: mathieu ferlay [mailto:mfer...@gnubila.fr]
Sent: Thursday, March 16, 2017 7:46 AM
To: user@trafodion.incubator.apache.org
Subject: RE: issue wtih foreign keys

Hi again,
I don't know if explain my process will help but maybe:
    try (Connection connection = DriverManager.getConnection(dbUrl, dbUser, 
dbPwd);
        BufferedReader reader = new BufferedReader(
            new FileReader("create-tables.sql"));) {
     ScriptRunner runner = new ScriptRunner(connection, false, true);
      runner.runScript(reader);
      connection.close();
    } catch (Exception e) {
      e.printStackTrace();
      throw e;
    }

In the sql file, I have all my requests to create all my tables and the script 
runner execute one statement by request.
I  start to think that's due to the autocommit and so by consequence the 
"database" access.

Regards,
Mathieu

De : mathieu ferlay [mailto:mfer...@gnubila.fr]
Envoyé : jeudi 16 mars 2017 15:02
À : 
user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org>
Objet : RE: issue wtih foreign keys

Hi,
I have change my request by using alter table do it but I still have some 
"lost" of process. It's look like an infinite loop inside the execute statement.
I don't know what it could causes that.

Regards,
Mathieu

De : mathieu ferlay [mailto:mfer...@gnubila.fr]
Envoyé : jeudi 16 mars 2017 10:05
À : 
user@trafodion.incubator.apache.org<mailto:user@trafodion.incubator.apache.org>
Objet : issue wtih foreign keys

Hi, i'll try to create the following table C. I assume that tables A & B are 
executed before C.  But when I try to execute the statement for the table C, 
the process nerver back from the statement.execute(request). Furthermore, I 
obtain also the following trace when I force the commit with 
connection.commit();
' (line 120): *** ERROR[8838] Unable to receive reply from Compiler, possibly 
caused by internal errors when compiling SQL statements, processing DDL 
statements, or executing the builtin stored procedures. [2017-03-16 09:02:56]
Could you tell me which kind of reasons could provoked it.



CREATE TABLE IF NOT EXISTS A (
  AID VARCHAR(255) CHARACTER SET utf8 COLLATE DEFAULT  NOT NULL,
  Description  VARCHAR(255) CHARACTER SET utf8 COLLATE DEFAULT  NULL,
  PRIMARY KEY(AID)
)

CREATE TABLE IF NOT EXISTS B (
  Name VARCHAR(255) CHARACTER SET utf8 COLLATE DEFAULT NOT NULL,
  FirstName VARCHAR(255) CHARACTER SET utf8 COLLATE DEFAULT NOT NULL,
  BID VARCHAR(255) CHARACTER SET utf8 COLLATE DEFAULT NOT NULL,
  PRIMARY KEY(BID)
)



CREATE TABLE IF NOT EXISTS C (
  BID VARCHAR(255) CHARACTER SET utf8 COLLATE DEFAULT NOT NULL,
  AID VARCHAR(255) CHARACTER SET utf8 COLLATE DEFAULT NOT NULL,
  PRIMARY KEY(AID,BID),
  FOREIGN KEY(AID)
    REFERENCES A(AID),
  FOREIGN KEY(BID)
    REFERENCES B(BID)
)


Regards
Mathieu FERLAY