Unknown table 'CLNodeInfos' in information_schema

[Former Member]

Hello, after successfully initializing on Hybris v6.7, subsequent ant updatesystems fail with the following error:

  [java]  org.apache.ddlutils.DatabaseOperationException: java.sql.SQLSyntaxErrorException: Unknown table 'CLNodeInfos' in information_schema

We use MySQL 5.6.40

Any ideas?

[Former Member · Accepted solution]

We rolled back from mysql Connector 8.x to 5.1.46 and everything is working smoothly now.

[kneuhaus · Accepted solution]

confirmed...

[Former Member · Accepted solution]

Confirmed. I had it quit on me on another table though. Mine threw this exception when calling ant updatesystem from the command line, when it tried to update the database schema. The table it threw the exception for was called systeminit. Downgrading the MySQL connector to the 5.1.46 version did the trick.

[Former Member · Accepted solution]

Confirmed. Broke on first table (which in my case was 'abstractcontact26sn'). Solution to downgrade the MySQL connector to 5.1.47 solved the problem! Problem occured on Hybris v1808.

[Former Member]

Currently it does NOT work with connector 8.x. There were some known mysql problems regarding this failure ("...unknown table..."), which should be fixed in one of the latest driver versions (maybe 8.0.14 or 15). But our tests have shown - it still doesn't work. So currently we know that 5.x databases work fine with 5.x driver. Here another suggestion - use 5.1.46, not 5.1.47 - there is another known mysql bug which pop ups in hybris platform.