Loading of schema fails for DerbyDB (#806)

Activities

Andrzej Wójcik (Tigase) opened 8 years ago

Due Date
2017-04-24

As I was testing schema loading for DerbyDB (during fixing reported issues) I found that it is not possible to properly load schema, unless I will comment out

-- QUERY START:
ALTER TABLE tig_pairs ADD COLUMN PID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1) NOT NULL PRIMARY KEY;
-- QUERY END:

from @derby-schema-7.1-schema.sql@.

Error reported by DerbyDB:

2017-04-20 13:00:42.758 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: ALTER TABLE tig_pairs ADD COLUMN PID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1) NOT NULL PRIMARY KEY
2017-04-20 13:00:42.760 [main]             DBSchemaLoader.validateDBSchema()       WARNING:  Can't load schema: ALTER TABLE statement cannot add an IDENTITY column to a table.
2017-04-20 13:00:42.760 [main]             DBSchemaLoader.addXmppAdminAccount()    WARNING:  Database schema is invalid
2017-04-20 13:00:42.760 [main]             DBSchemaLoader.postInstallation()       WARNING:  Database schema is invalid

wojciech.kapcia@tigase.net commented 8 years ago

Works for me:

wojtek@atlantiscity.local ~/dev/tmps/tigase-server-dists/tigase-issue #7.2.0-SNAPSHOT-b4787 $ java -cp "jars/*" tigase.db.util.DBSchemaLoader -T derby -U tigase72tts -P tigase72tts -D tigase72tts -L ALL
Picked up JAVA_TOOL_OPTIONS: -Djava.awt.headless=true
properties: {dbHostname=localhost, logLevel=ALL, dbType=derby, rootUser=root, useSSL=false, dbPass=tigase72tts, dbName=tigase72tts, schemaVersion=7-2, rootPass=root, dbUser=tigase72tts, ignoreMissingFiles=false}
LogLevel: ALL
2017-04-24 18:16:18.464 [main]             DBSchemaLoader.<init>()                 CONFIG:   Properties: {dbHostname=localhost, logLevel=ALL, dbType=derby, rootUser=root, useSSL=false, dbPass=tigase72tts, dbName=tigase72tts, schemaVersion=7-2, rootPass=root, dbUser=tigase72tts, ignoreMissingFiles=false}
2017-04-24 18:16:18.482 [main]             DBSchemaLoader.validateDBConnection()   INFO:     Validating DBConnection, URI: jdbc:derby:tigase72tts;create=true
2017-04-24 18:16:18.885 [main]             DBSchemaLoader.validateDBConnection()   CONFIG:   DriverManager (available drivers): [org.apache.derby.jdbc.AutoloadedDriver@18769467, jTDS 1.3.1, com.mysql.jdbc.Driver@694f9431, com.mysql.fabric.jdbc.FabricMySQLDriver@20fa23c1, org.postgresql.Driver@ba8a1dc]
2017-04-24 18:16:18.886 [main]             DBSchemaLoader.validateDBConnection()   INFO:     Connection OK
2017-04-24 18:16:18.886 [main]             DBSchemaLoader.validateDBExists()       INFO:     Validating whether DB Exists, URI: jdbc:derby:tigase72tts;create=true
2017-04-24 18:16:18.888 [main]             DBSchemaLoader.validateDBExists()       INFO:     Exists OK
2017-04-24 18:16:18.888 [main]             DBSchemaLoader.validateDBSchema()       INFO:     Validating DBSchema, URI: jdbc:derby:tigase72tts;create=true
2017-04-24 18:16:18.996 [main]             DBSchemaLoader.validateDBSchema()       WARNING:  Exception, possibly schema hasn't been loaded yet.
2017-04-24 18:16:18.997 [main]             DBSchemaLoader.validateDBSchema()       INFO:     DB schema doesn't exists, creating one..., URI: jdbc:derby:tigase72tts;create=true
2017-04-24 18:16:18.999 [main]             DBSchemaLoader.loadSQLQueries()         FINER:    Loading queries, resource: derby-schema-7-2-schema, res_prefix: derby
2017-04-24 18:16:19.011 [main]             DBSchemaLoader.loadSQLQueries()         FINER:    Loading queries, resource: database/derby-schema-7-1-schema.sql, res_prefix: null
2017-04-24 18:16:19.011 [main]             DBSchemaLoader.loadSQLQueries()         FINER:    Loading queries, resource: database/derby-schema-5-1-schema.sql, res_prefix: null
2017-04-24 18:16:19.012 [main]             DBSchemaLoader.loadSQLQueries()         FINER:    Loading queries, resource: database/derby-schema-4-schema.sql, res_prefix: null
2017-04-24 18:16:19.017 [main]             DBSchemaLoader.loadSQLQueries()         FINER:    Loading queries, resource: derby-schema-7-2-sp, res_prefix: derby
2017-04-24 18:16:19.019 [main]             DBSchemaLoader.loadSQLQueries()         FINER:    Loading queries, resource: database/derby-schema-7-1-sp.sql, res_prefix: null
2017-04-24 18:16:19.019 [main]             DBSchemaLoader.loadSQLQueries()         FINER:    Loading queries, resource: database/derby-schema-5-1-sp.sql, res_prefix: null
2017-04-24 18:16:19.020 [main]             DBSchemaLoader.loadSQLQueries()         FINER:    Loading queries, resource: database/derby-schema-4-sp.sql, res_prefix: null
2017-04-24 18:16:19.024 [main]             DBSchemaLoader.loadSQLQueries()         FINER:    Loading queries, resource: derby-schema-7-2-props, res_prefix: derby
2017-04-24 18:16:19.026 [main]             DBSchemaLoader.loadSchemaQueries()      FINE:     Loading schema queries: [create table tig_users ( uid BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY, user_id varchar(2049) NOT NULL, user_pw varchar(255) default NULL, acc_create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP, last_login timestamp, last_logout timestamp, online_status int default 0, failed_logins int default 0, account_status int default 1 ), create unique index user_id on tig_users ( user_id ), create index user_pw on tig_users (user_pw), create index last_login on tig_users (last_login), create index last_logout on tig_users (last_logout), create index account_status on tig_users (account_status), create index online_status on tig_users (online_status), create table tig_nodes ( nid BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY, parent_nid bigint, uid bigint NOT NULL references tig_users(uid), node varchar(255) NOT NULL ), create unique index tnode on tig_nodes ( parent_nid, uid, node ), create index node on tig_nodes ( node ), create index nuid on tig_nodes (uid), create index parent_nid on tig_nodes (parent_nid), create table tig_pairs ( nid bigint references tig_nodes(nid), uid bigint NOT NULL references tig_users(uid), pkey varchar(255) NOT NULL, pval long varchar ), create index pkey on tig_pairs ( pkey ), create index puid on tig_pairs (uid), create index pnid on tig_pairs (nid), alter table tig_pairs ADD column pval2 CLOB, update tig_pairs set pval2=pval, alter table tig_pairs drop column pval, RENAME COLUMN tig_pairs.pval2 to pval, ALTER TABLE tig_pairs ADD COLUMN PID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1) NOT NULL PRIMARY KEY, create table tig_offline_messages ( msg_id BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY, ts timestamp DEFAULT CURRENT_TIMESTAMP, expired timestamp, sender varchar(2049), sender_sha1 char(128), receiver varchar(2049) not null, receiver_sha1 char(128) not null, msg_type int not null default 0, message varchar(32672) not null ), create index tig_offline_messages_expired on tig_offline_messages (expired), create index tig_offline_messages_receiver on tig_offline_messages (receiver_sha1), create index tig_offline_messages_receiver_sender on tig_offline_messages (receiver_sha1, sender_sha1), create table tig_broadcast_messages ( id varchar(128) not null, expired timestamp not null, msg varchar(32672) not null, primary key (id) ), create table tig_broadcast_jids ( jid_id BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY, jid varchar(2049) not null, jid_sha1 char(128) not null ), create table tig_broadcast_recipients ( msg_id varchar(128) not null references tig_broadcast_messages(id), jid_id bigint not null references tig_broadcast_jids(jid_id), primary key (msg_id, jid_id) ), CREATE procedure Tig_OfflineMessages_Migrate() PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.MsgRepositoryStoredProcedures.migrateFromOldSchema', call Tig_OfflineMessages_Migrate(), drop procedure Tig_OfflineMessages_Migrate, create table tig_cluster_nodes ( hostname varchar(512) not null, secondary varchar(512), password varchar(255) not null, last_update timestamp default current_timestamp, port int, cpu_usage double precision not null, mem_usage double precision not null, primary key (hostname) ), CREATE function TigGetDBProperty(tkey varchar(255)) returns long varchar PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigGetDBProperty', CREATE procedure TigPutDBProperty(tkey varchar(255), tval varchar(32672)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigPutDBProperty', CREATE procedure TigInitdb() PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigInitdb', CREATE procedure TigAddUser(userId varchar(2049), userPw varchar(255)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigAddUser', CREATE procedure TigAddUserPlainPw(userId varchar(2049), userPw varchar(255)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigAddUserPlainPw', CREATE procedure TigGetUserDBUid(userId varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigGetUserDBUid', CREATE procedure TigRemoveUser(userId varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigRemoveUser', CREATE procedure TigGetPassword(userId varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigGetPassword', CREATE procedure TigUpdatePasswordPlainPwRev(userId varchar(2049), userPw varchar(255)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigUpdatePasswordPlainPwRev', CREATE procedure TigUpdatePasswordPlainPw(userId varchar(2049), userPw varchar(255)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigUpdatePasswordPlainPw', CREATE procedure TigUpdatePassword(userId varchar(2049), userPw varchar(255)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigUpdatePassword', CREATE procedure TigOnlineUsers() PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigOnlineUsers', CREATE procedure TigOfflineUsers() PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigOfflineUsers', CREATE procedure TigAllUsers() PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigAllUsers', CREATE procedure TigAllUsersCount() PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigAllUsersCount', CREATE procedure TigUserLoginPlainPw(userId varchar(2049), userPw varchar(255)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigUserLoginPlainPw', CREATE procedure TigUserLogin(userId varchar(2049), userPw varchar(255)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigUserLogin', CREATE procedure TigUserLogout(userId varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigUserLogout', CREATE procedure TigDisableAccount(userId varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigDisableAccount', CREATE procedure TigEnableAccount(userId varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigEnableAccount', CREATE procedure TigActiveAccounts() PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigActiveAccounts', CREATE procedure TigDisabledAccounts() PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigDisabledAccounts', CREATE procedure TigAddNode(parentNid bigint, uid bigint, node varchar(255)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigAddNode', CREATE procedure TigUpdatePairs(nid bigint, uid bigint, tkey varchar(255), tval varchar(32672)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigUpdatePairs', drop procedure TigUpdatePairs, CREATE procedure TigUpdatePairs(nid bigint, uid bigint, tkey varchar(255), tval clob) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigUpdatePairs', drop procedure TigPutDBProperty, CREATE procedure TigPutDBProperty(tkey varchar(255), tval varchar(32672)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigPutDBProperty', CREATE procedure TigUpdateLoginTime(userId varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigUpdateLoginTime', CREATE procedure Tig_OfflineMessages_AddMessage("to" varchar(2049), "from" varchar(2049), "type" int, "ts" timestamp, "message" varchar(32672), "expired" timestamp, "limit" bigint) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgRepositoryStoredProcedures.addMessage', CREATE procedure Tig_OfflineMessages_GetMessages("to" varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgRepositoryStoredProcedures.getMessages', CREATE procedure Tig_OfflineMessages_GetMessagesByIds("to" varchar(2049), "msg_id1" varchar(50), "_msg_id2" varchar(50), "_msg_id3" varchar(50), "_msg_id4" varchar(50)) PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgRepositoryStoredProcedures.getMessagesByIds', CREATE procedure Tig_OfflineMessages_GetMessagesCount("to" varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgRepositoryStoredProcedures.getMessagesCount', CREATE procedure Tig_OfflineMessages_ListMessages("to" varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgRepositoryStoredProcedures.listMessages', CREATE procedure Tig_OfflineMessages_DeleteMessages("to" varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgRepositoryStoredProcedures.deleteMessages', CREATE procedure Tig_OfflineMessages_DeleteMessagesByIds("to" varchar(2049), "msg_id1" varchar(50), "_msg_id2" varchar(50), "_msg_id3" varchar(50), "_msg_id4" varchar(50)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgRepositoryStoredProcedures.deleteMessagesByIds', CREATE procedure Tig_OfflineMessages_DeleteMessage(msg_id bigint) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgRepositoryStoredProcedures.deleteMessage', CREATE procedure Tig_OfflineMessages_GetExpiredMessages("limit" int) PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgRepositoryStoredProcedures.getExpiredMessages', CREATE procedure Tig_OfflineMessages_GetExpiredMessagesBefore("before" timestamp) PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgRepositoryStoredProcedures.getExpiredMessagesBefore', CREATE procedure Tig_BroadcastMessages_AddMessage("msg_id" varchar(128), "expired" timestamp, "msg" varchar(32672)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.MsgBroadcastRepositoryStoredProcedures.addMessage', CREATE procedure Tig_BroadcastMessages_AddMessageRecipient("msg_id" varchar(128), "jid" varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.MsgBroadcastRepositoryStoredProcedures.addMessageRecipient', CREATE procedure Tig_BroadcastMessages_GetMessages("expired" timestamp) PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgBroadcastRepositoryStoredProcedures.getMessages', CREATE procedure Tig_BroadcastMessages_GetMessageRecipients("msg_id" varchar(128)) PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgBroadcastRepositoryStoredProcedures.getMessageRecipients', CREATE PROCEDURE TigUpdateAccountStatus("userId" VARCHAR(2049), "status" INT) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigUpdateAccountStatus', call TigAddUserPlainPw('db-properties', NULL), call TigPutDBProperty('schema-version', '7.2')] // [Ljava.lang.Object;@5e0826e7
2017-04-24 18:16:19.034 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create table tig_users ( uid BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY, user_id varchar(2049) NOT NULL, user_pw varchar(255) default NULL, acc_create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP, last_login timestamp, last_logout timestamp, online_status int default 0, failed_logins int default 0, account_status int default 1 )
2017-04-24 18:16:19.121 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create unique index user_id on tig_users ( user_id )
2017-04-24 18:16:19.142 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create index user_pw on tig_users (user_pw)
2017-04-24 18:16:19.158 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create index last_login on tig_users (last_login)
2017-04-24 18:16:19.166 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create index last_logout on tig_users (last_logout)
2017-04-24 18:16:19.175 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create index account_status on tig_users (account_status)
2017-04-24 18:16:19.191 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create index online_status on tig_users (online_status)
2017-04-24 18:16:19.201 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create table tig_nodes ( nid BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY, parent_nid bigint, uid bigint NOT NULL references tig_users(uid), node varchar(255) NOT NULL )
2017-04-24 18:16:19.245 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create unique index tnode on tig_nodes ( parent_nid, uid, node )
2017-04-24 18:16:19.255 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create index node on tig_nodes ( node )
2017-04-24 18:16:19.264 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create index nuid on tig_nodes (uid)
2017-04-24 18:16:19.270 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create index parent_nid on tig_nodes (parent_nid)
2017-04-24 18:16:19.282 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create table tig_pairs ( nid bigint references tig_nodes(nid), uid bigint NOT NULL references tig_users(uid), pkey varchar(255) NOT NULL, pval long varchar )
2017-04-24 18:16:19.316 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create index pkey on tig_pairs ( pkey )
2017-04-24 18:16:19.323 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create index puid on tig_pairs (uid)
2017-04-24 18:16:19.328 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create index pnid on tig_pairs (nid)
2017-04-24 18:16:19.337 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: alter table tig_pairs ADD column pval2 CLOB
2017-04-24 18:16:19.351 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: update tig_pairs set pval2=pval
2017-04-24 18:16:19.418 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: alter table tig_pairs drop column pval
2017-04-24 18:16:19.461 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: RENAME COLUMN tig_pairs.pval2 to pval
2017-04-24 18:16:19.469 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: ALTER TABLE tig_pairs ADD COLUMN PID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1) NOT NULL PRIMARY KEY
2017-04-24 18:16:19.508 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create table tig_offline_messages ( msg_id BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY, ts timestamp DEFAULT CURRENT_TIMESTAMP, expired timestamp, sender varchar(2049), sender_sha1 char(128), receiver varchar(2049) not null, receiver_sha1 char(128) not null, msg_type int not null default 0, message varchar(32672) not null )
2017-04-24 18:16:19.524 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create index tig_offline_messages_expired on tig_offline_messages (expired)
2017-04-24 18:16:19.531 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create index tig_offline_messages_receiver on tig_offline_messages (receiver_sha1)
2017-04-24 18:16:19.550 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create index tig_offline_messages_receiver_sender on tig_offline_messages (receiver_sha1, sender_sha1)
2017-04-24 18:16:19.560 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create table tig_broadcast_messages ( id varchar(128) not null, expired timestamp not null, msg varchar(32672) not null, primary key (id) )
2017-04-24 18:16:19.573 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create table tig_broadcast_jids ( jid_id BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL PRIMARY KEY, jid varchar(2049) not null, jid_sha1 char(128) not null )
2017-04-24 18:16:19.582 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create table tig_broadcast_recipients ( msg_id varchar(128) not null references tig_broadcast_messages(id), jid_id bigint not null references tig_broadcast_jids(jid_id), primary key (msg_id, jid_id) )
2017-04-24 18:16:19.622 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure Tig_OfflineMessages_Migrate() PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.MsgRepositoryStoredProcedures.migrateFromOldSchema'
2017-04-24 18:16:19.628 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: call Tig_OfflineMessages_Migrate()
2017-04-24 18:16:19.667 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: drop procedure Tig_OfflineMessages_Migrate
2017-04-24 18:16:19.672 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: create table tig_cluster_nodes ( hostname varchar(512) not null, secondary varchar(512), password varchar(255) not null, last_update timestamp default current_timestamp, port int, cpu_usage double precision not null, mem_usage double precision not null, primary key (hostname) )
2017-04-24 18:16:19.692 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE function TigGetDBProperty(tkey varchar(255)) returns long varchar PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigGetDBProperty'
2017-04-24 18:16:19.694 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigPutDBProperty(tkey varchar(255), tval varchar(32672)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigPutDBProperty'
2017-04-24 18:16:19.696 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigInitdb() PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigInitdb'
2017-04-24 18:16:19.698 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigAddUser(userId varchar(2049), userPw varchar(255)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigAddUser'
2017-04-24 18:16:19.699 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigAddUserPlainPw(userId varchar(2049), userPw varchar(255)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigAddUserPlainPw'
2017-04-24 18:16:19.701 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigGetUserDBUid(userId varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigGetUserDBUid'
2017-04-24 18:16:19.705 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigRemoveUser(userId varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigRemoveUser'
2017-04-24 18:16:19.707 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigGetPassword(userId varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigGetPassword'
2017-04-24 18:16:19.708 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigUpdatePasswordPlainPwRev(userId varchar(2049), userPw varchar(255)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigUpdatePasswordPlainPwRev'
2017-04-24 18:16:19.710 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigUpdatePasswordPlainPw(userId varchar(2049), userPw varchar(255)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigUpdatePasswordPlainPw'
2017-04-24 18:16:19.715 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigUpdatePassword(userId varchar(2049), userPw varchar(255)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigUpdatePassword'
2017-04-24 18:16:19.717 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigOnlineUsers() PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigOnlineUsers'
2017-04-24 18:16:19.718 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigOfflineUsers() PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigOfflineUsers'
2017-04-24 18:16:19.723 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigAllUsers() PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigAllUsers'
2017-04-24 18:16:19.726 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigAllUsersCount() PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigAllUsersCount'
2017-04-24 18:16:19.734 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigUserLoginPlainPw(userId varchar(2049), userPw varchar(255)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigUserLoginPlainPw'
2017-04-24 18:16:19.738 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigUserLogin(userId varchar(2049), userPw varchar(255)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigUserLogin'
2017-04-24 18:16:19.741 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigUserLogout(userId varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigUserLogout'
2017-04-24 18:16:19.743 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigDisableAccount(userId varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigDisableAccount'
2017-04-24 18:16:19.745 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigEnableAccount(userId varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigEnableAccount'
2017-04-24 18:16:19.747 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigActiveAccounts() PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigActiveAccounts'
2017-04-24 18:16:19.749 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigDisabledAccounts() PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigDisabledAccounts'
2017-04-24 18:16:19.759 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigAddNode(parentNid bigint, uid bigint, node varchar(255)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigAddNode'
2017-04-24 18:16:19.761 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigUpdatePairs(nid bigint, uid bigint, tkey varchar(255), tval varchar(32672)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigUpdatePairs'
2017-04-24 18:16:19.763 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: drop procedure TigUpdatePairs
2017-04-24 18:16:19.765 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigUpdatePairs(nid bigint, uid bigint, tkey varchar(255), tval clob) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigUpdatePairs'
2017-04-24 18:16:19.767 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: drop procedure TigPutDBProperty
2017-04-24 18:16:19.770 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigPutDBProperty(tkey varchar(255), tval varchar(32672)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigPutDBProperty'
2017-04-24 18:16:19.772 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure TigUpdateLoginTime(userId varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigUpdateLoginTime'
2017-04-24 18:16:19.776 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure Tig_OfflineMessages_AddMessage("to" varchar(2049), "from" varchar(2049), "type" int, "ts" timestamp, "message" varchar(32672), "expired" timestamp, "limit" bigint) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgRepositoryStoredProcedures.addMessage'
2017-04-24 18:16:19.784 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure Tig_OfflineMessages_GetMessages("to" varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgRepositoryStoredProcedures.getMessages'
2017-04-24 18:16:19.789 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure Tig_OfflineMessages_GetMessagesByIds("to" varchar(2049), "msg_id1" varchar(50), "_msg_id2" varchar(50), "_msg_id3" varchar(50), "_msg_id4" varchar(50)) PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgRepositoryStoredProcedures.getMessagesByIds'
2017-04-24 18:16:19.792 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure Tig_OfflineMessages_GetMessagesCount("to" varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgRepositoryStoredProcedures.getMessagesCount'
2017-04-24 18:16:19.793 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure Tig_OfflineMessages_ListMessages("to" varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgRepositoryStoredProcedures.listMessages'
2017-04-24 18:16:19.795 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure Tig_OfflineMessages_DeleteMessages("to" varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgRepositoryStoredProcedures.deleteMessages'
2017-04-24 18:16:19.797 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure Tig_OfflineMessages_DeleteMessagesByIds("to" varchar(2049), "msg_id1" varchar(50), "_msg_id2" varchar(50), "_msg_id3" varchar(50), "_msg_id4" varchar(50)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgRepositoryStoredProcedures.deleteMessagesByIds'
2017-04-24 18:16:19.808 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure Tig_OfflineMessages_DeleteMessage(msg_id bigint) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgRepositoryStoredProcedures.deleteMessage'
2017-04-24 18:16:19.811 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure Tig_OfflineMessages_GetExpiredMessages("limit" int) PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgRepositoryStoredProcedures.getExpiredMessages'
2017-04-24 18:16:19.813 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure Tig_OfflineMessages_GetExpiredMessagesBefore("before" timestamp) PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgRepositoryStoredProcedures.getExpiredMessagesBefore'
2017-04-24 18:16:19.815 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure Tig_BroadcastMessages_AddMessage("msg_id" varchar(128), "expired" timestamp, "msg" varchar(32672)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.MsgBroadcastRepositoryStoredProcedures.addMessage'
2017-04-24 18:16:19.816 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure Tig_BroadcastMessages_AddMessageRecipient("msg_id" varchar(128), "jid" varchar(2049)) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.MsgBroadcastRepositoryStoredProcedures.addMessageRecipient'
2017-04-24 18:16:19.819 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure Tig_BroadcastMessages_GetMessages("expired" timestamp) PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgBroadcastRepositoryStoredProcedures.getMessages'
2017-04-24 18:16:19.821 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE procedure Tig_BroadcastMessages_GetMessageRecipients("msg_id" varchar(128)) PARAMETER STYLE JAVA LANGUAGE JAVA READS SQL DATA DYNAMIC RESULT SETS 1 EXTERNAL NAME 'tigase.db.derby.MsgBroadcastRepositoryStoredProcedures.getMessageRecipients'
2017-04-24 18:16:19.825 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: CREATE PROCEDURE TigUpdateAccountStatus("userId" VARCHAR(2049), "status" INT) PARAMETER STYLE JAVA LANGUAGE JAVA MODIFIES SQL DATA EXTERNAL NAME 'tigase.db.derby.StoredProcedures.tigUpdateAccountStatus'
2017-04-24 18:16:19.832 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: call TigAddUserPlainPw('db-properties', NULL)
2017-04-24 18:16:19.941 [main]             DBSchemaLoader.validateDBSchema()       FINEST:   Executing query: call TigPutDBProperty('schema-version', '7.2')
2017-04-24 18:16:19.970 [main]             DBSchemaLoader.validateDBSchema()       INFO:     New schema loaded OK
2017-04-24 18:16:19.970 [main]             DBSchemaLoader.addXmppAdminAccount()    WARNING:  Error: No admin users entered
2017-04-24 18:16:19.970 [main]             DBSchemaLoader.postInstallation()       INFO:     Post Installation, URI: jdbc:derby:tigase72tts;create=true
2017-04-24 18:16:19.970 [main]             DBSchemaLoader.postInstallation()       INFO:     Finalizing...
2017-04-24 18:16:19.971 [main]             DBSchemaLoader.loadSQLQueries()         FINER:    Loading queries, resource: derby-installer-post, res_prefix: derby
2017-04-24 18:16:19.972 [main]             DBSchemaLoader.postInstallation()       INFO:      completed OK
2017-04-24 18:16:19.973 [main]             DBSchemaLoader.shutdownDerby()          INFO:     Validating DBConnection, URI: jdbc:derby:tigase72tts;create=true
2017-04-24 18:16:20.014 [main]             DBSchemaLoader.shutdownDerby()          WARNING:  Database 'tigase72tts' shutdown.
2017-04-24 18:16:20.015 [main]             DBSchemaLoader.printInfo()              INFO:

Database init.properties configuration:
dataSource {
    default {
        uri = 'jdbc:derby:tigase72tts;create=true'
    }
}

wojtek@atlantiscity.local ~/dev/tmps/tigase-server-dists/tigase-issue #7.2.0-SNAPSHOT-b4787 $

Andrzej Wójcik (Tigase) commented 8 years ago

Now it also works for me.

Type	Bug
Priority	Normal
Assignee	wojciech.kapcia@tigase.net
RedmineID	5402
Version	tigase-server-8.0.0

Issue Votes (0)

Watchers (0)

Reference

tigase/_server/server-core#806