RE: issue wtih foreign keys

[mathieu ferlay]

Hi Dave,

I’m using the version of the docker image trafodion\incubator and I believe
it’s the 2.0.0 .

 

Regards,

Mathieu

 

De : Dave Birdsall [mailto:dave.birds...@esgyn.com] 
Envoyé : jeudi 16 mars 2017 16:26
À : user@trafodion.incubator.apache.org
Objet : RE: issue wtih foreign keys

 

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
<mailto: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