Hello,
can someone point me, where is the problem with the command alter schema
... rename to ...? Each schema contains views, tables, identity columns and
much data. Simple test case does not produce such error.
Debug level 3 produces following error:
2017-11-27 16:59:59 jdbc[3]:
/**/conn0.getWarnings();
2017-11-27 16:59:59 jdbc[3]:
/**/conn0.clearWarnings();
2017-11-27 16:59:59 jdbc[3]:
/**/stat0.getWarnings();
2017-11-27 16:59:59 jdbc[3]:
/**/stat0.clearWarnings();
2017-11-27 16:59:59 jdbc[3]:
/**/DatabaseMetaData dbMeta35 = conn0.getMetaData();
2017-11-27 16:59:59 jdbc[3]:
/**/dbMeta35.supportsMultipleResultSets();
2017-11-27 16:59:59 jdbc[3]:
/**/stat0.getUpdateCount();
2017-11-27 16:59:59 jdbc[3]:
/**/stat0.close();
2017-11-27 17:00:26 jdbc[3]:
/**/Statement stat1 = conn0.createStatement();
2017-11-27 17:00:26 jdbc[3]:
/**/stat1.setMaxRows(100);
2017-11-27 17:00:26 jdbc[3]:
/**/stat1.getMaxRows();
2017-11-27 17:00:26 jdbc[3]:
/**/stat1.execute("set EXCLUSIVE 2");
2017-11-27 17:00:26 jdbc[3]:
/*SQL */set EXCLUSIVE 2;
2017-11-27 17:00:26 jdbc[3]:
/**/conn0.getWarnings();
2017-11-27 17:00:26 jdbc[3]:
/**/conn0.clearWarnings();
2017-11-27 17:00:26 jdbc[3]:
/**/stat1.getWarnings();
2017-11-27 17:00:26 jdbc[3]:
/**/stat1.clearWarnings();
2017-11-27 17:00:26 jdbc[3]:
/**/stat1.getUpdateCount();
2017-11-27 17:00:26 jdbc[3]:
/**/stat1.getMaxRows();
2017-11-27 17:00:26 jdbc[3]:
/**/stat1.execute("set LOG 0");
2017-11-27 17:00:26 jdbc[3]:
/*SQL */set LOG 0;
2017-11-27 17:00:26 jdbc[3]:
/**/conn0.getWarnings();
2017-11-27 17:00:26 jdbc[3]:
/**/conn0.clearWarnings();
2017-11-27 17:00:26 jdbc[3]:
/**/stat1.getWarnings();
2017-11-27 17:00:26 jdbc[3]:
/**/stat1.clearWarnings();
2017-11-27 17:00:26 jdbc[3]:
/**/stat1.getUpdateCount();
2017-11-27 17:00:26 jdbc[3]:
/**/stat1.getMaxRows();
2017-11-27 17:00:26 jdbc[3]:
/**/stat1.execute("set UNDO_LOG 0");
2017-11-27 17:00:26 jdbc[3]:
/*SQL */set UNDO_LOG 0;
2017-11-27 17:00:26 jdbc[3]:
/**/conn0.getWarnings();
2017-11-27 17:00:26 jdbc[3]:
/**/conn0.clearWarnings();
2017-11-27 17:00:26 jdbc[3]:
/**/stat1.getWarnings();
2017-11-27 17:00:26 jdbc[3]:
/**/stat1.clearWarnings();
2017-11-27 17:00:26 jdbc[3]:
/**/stat1.getUpdateCount();
2017-11-27 17:00:26 jdbc[3]:
/**/stat1.getMaxRows();
2017-11-27 17:00:26 jdbc[3]:
/**/stat1.execute("set schema \"PUBLIC\"");
2017-11-27 17:00:26 jdbc[3]:
/*SQL */set schema \"PUBLIC\";
2017-11-27 17:00:26 jdbc[3]:
/**/conn0.getWarnings();
2017-11-27 17:00:26 jdbc[3]:
/**/conn0.clearWarnings();
2017-11-27 17:00:26 jdbc[3]:
/**/stat1.getWarnings();
2017-11-27 17:00:26 jdbc[3]:
/**/stat1.clearWarnings();
2017-11-27 17:00:26 jdbc[3]:
/**/stat1.getUpdateCount();
2017-11-27 17:00:26 jdbc[3]:
/**/stat1.close();
2017-11-27 17:01:03 jdbc[3]:
/**/Statement stat2 = conn0.createStatement();
2017-11-27 17:01:03 jdbc[3]:
/**/stat2.getMaxRows();
2017-11-27 17:01:03 jdbc[3]:
/**/stat2.execute("alter schema \"DATA_D06\" rename to \"DATA_DXX\"");
2017-11-27 17:01:03 lock: 3 shared read lock unlock SYS
2017-11-27 17:01:03 jdbc[3]:
/*SQL t:119*/alter schema \"DATA_D06\" rename to \"DATA_DXX\";
2017-11-27 17:01:03 command: slow query: 134 ms
2017-11-27 17:01:03 jdbc[3]:
/**/conn0.getWarnings();
2017-11-27 17:01:03 jdbc[3]:
/**/conn0.clearWarnings();
2017-11-27 17:01:03 jdbc[3]:
/**/stat2.getWarnings();
2017-11-27 17:01:03 jdbc[3]:
/**/stat2.clearWarnings();
2017-11-27 17:01:03 jdbc[3]:
/**/stat2.getUpdateCount();
2017-11-27 17:01:03 jdbc[3]:
/**/stat2.close();
2017-11-27 17:01:06 jdbc[3]:
/**/Statement stat3 = conn0.createStatement();
2017-11-27 17:01:06 jdbc[3]:
/**/stat3.getMaxRows();
2017-11-27 17:01:06 jdbc[3]:
/**/stat3.execute("alter schema \"DATA_D05\" rename to \"DATA_D06\"");
2017-11-27 17:01:08 command: slow query: 1,885 ms
2017-11-27 17:01:08 jdbc[3]: exception
org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException:
SCHEMA DATA_D06:830:org.h2.engine.Comment@269a724e"; SQL statement:
alter schema "DATA_D05" rename to "DATA_D06" [50000-196]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.message.DbException.convert(DbException.java:295)
at org.h2.command.Command.executeUpdate(Command.java:268)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:192)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:164)
at
net.sourceforge.squirrel_sql.client.session.StatementWrapper.execute(StatementWrapper.java:165)
at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery(SQLExecuterTask.java:369)
at
net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:212)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.RuntimeException: SCHEMA
DATA_D06:830:org.h2.engine.Comment@269a724e
at org.h2.message.DbException.throwInternalError(DbException.java:242)
at
org.h2.engine.Database.updateMetaAndFirstLevelChildren(Database.java:1672)
at org.h2.engine.Database.renameDatabaseObject(Database.java:1712)
at
org.h2.command.ddl.AlterSchemaRename.update(AlterSchemaRename.java:53)
at org.h2.command.CommandContainer.update(CommandContainer.java:101)
at org.h2.command.Command.executeUpdate(Command.java:260)
... 7 more
2017-11-27 17:01:08 jdbc[3]:
/**/stat3.close();
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
