Migrate H2 to MySQL
90 views
Skip to first unread message
Tien-Chi Lee
Jul 8, 2015, 12:13:26 AM7/8/15
to repo-d...@googlegroups.com
Recently, I need to migrate H2 to MySQL for Master/Slave
But i have one problem
when i migrate H2 to mysql, gerrrit is ok to start, but log in with AD account is fail.
[2015-07-08 10:27:23,315] INFO com.google.gerrit.pgm.Daemon : Gerrit Code Review 2.10 ready
[2015-07-08 10:27:40,238] INFO com.google.gerrit.httpd.auth.ldap.LdapLoginServlet : 'xxx' failed to sign in: Authentication error
[2015-07-08 10:27:47,587] INFO com.google.gerrit.httpd.auth.ldap.LdapLoginServlet : 'xxx' failed to sign in: Authentication error
[2015-07-08 10:28:13,804] WARN com.google.gerrit.server.account.AccountCacheImpl : Cannot load AccountState for 1000000
java.util.concurrent.ExecutionException: com.google.gwtorm.server.OrmException: fetch failure on accounts
at com.google.common.util.concurrent.AbstractFuture$Sync.getValue(AbstractFuture.java:299)
at com.google.common.util.concurrent.AbstractFuture$Sync.get(AbstractFuture.java:286)
at com.google.common.util.concurrent.AbstractFuture.get(AbstractFuture.java:116)
at com.google.common.util.concurrent.Uninterruptibles.getUninterruptibly(Uninterruptibles.java:135)
at com.google.common.cache.LocalCache$Segment.getAndRecordStats(LocalCache.java:2346)
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2318)
at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2280)
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2195)
at com.google.common.cache.LocalCache.get(LocalCache.java:3934)
at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3938)
at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4821)
at com.google.gerrit.server.account.AccountCacheImpl.get(AccountCacheImpl.java:84)
at com.google.gerrit.server.IdentifiedUser.state(IdentifiedUser.java:228)
at com.google.gerrit.server.IdentifiedUser.getAccount(IdentifiedUser.java:245)
at com.google.gerrit.sshd.DatabasePubKeyAuth.authenticate(DatabasePubKeyAuth.java:144)
at org.apache.sshd.server.auth.UserAuthPublicKey.doAuth(UserAuthPublicKey.java:78)
at org.apache.sshd.server.auth.AbstractUserAuth.auth(AbstractUserAuth.java:49)
at org.apache.sshd.server.session.ServerSession.userAuth(ServerSession.java:443)
at org.apache.sshd.server.session.ServerSession.handleMessage(ServerSession.java:212)
at org.apache.sshd.common.session.AbstractSession.decode(AbstractSession.java:587)
at org.apache.sshd.common.session.AbstractSession.messageReceived(AbstractSession.java:253)
at org.apache.sshd.common.AbstractSessionIoHandler.messageReceived(AbstractSessionIoHandler.java:54)
at org.apache.sshd.common.io.mina.MinaService.messageReceived(MinaService.java:94)
at org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:690)
at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:417)
at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:47)
at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:765)
at org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:109)
at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:417)
at org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:410)
at org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:710)
at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:664)
at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:653)
at org.apache.mina.core.polling.AbstractPollingIoProcessor.access$600(AbstractPollingIoProcessor.java:67)
at org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:1124)
at org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.google.gwtorm.server.OrmException: fetch failure on accounts
at com.google.gwtorm.schema.sql.SqlDialect.convertError(SqlDialect.java:153)
at com.google.gwtorm.schema.sql.DialectMySQL.convertError(DialectMySQL.java:227)
at com.google.gwtorm.jdbc.JdbcAccess.convertError(JdbcAccess.java:457)
at com.google.gwtorm.jdbc.JdbcAccess.queryOne(JdbcAccess.java:135)
at com.google.gerrit.reviewdb.client.Account_Access_accounts_GwtOrm$$11.get(Unknown Source)
at com.google.gerrit.server.account.AccountCacheImpl$ByIdLoader.load(AccountCacheImpl.java:155)
at com.google.gerrit.server.account.AccountCacheImpl$ByIdLoader.load(AccountCacheImpl.java:142)
at com.google.gerrit.server.account.AccountCacheImpl$ByIdLoader.load(AccountCacheImpl.java:125)
at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3524)
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2317)
... 33 more
Caused by: java.sql.SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1061)
at com.mysql.jdbc.ByteArrayRow.getTimestampFast(ByteArrayRow.java:127)
at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6591)
at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6191)
at com.google.gerrit.reviewdb.client.Account_Access_accounts_GwtOrm$$11.bindOneFetch(Unknown Source)
at com.google.gwtorm.jdbc.JdbcAccess.queryOne(JdbcAccess.java:122)
... 39 more
But i have one problem
when i migrate H2 to mysql, gerrrit is ok to start, but log in with AD account is fail.
[2015-07-08 10:27:23,315] INFO com.google.gerrit.pgm.Daemon : Gerrit Code Review 2.10 ready
[2015-07-08 10:27:40,238] INFO com.google.gerrit.httpd.auth.ldap.LdapLoginServlet : 'xxx' failed to sign in: Authentication error
[2015-07-08 10:27:47,587] INFO com.google.gerrit.httpd.auth.ldap.LdapLoginServlet : 'xxx' failed to sign in: Authentication error
[2015-07-08 10:28:13,804] WARN com.google.gerrit.server.account.AccountCacheImpl : Cannot load AccountState for 1000000
java.util.concurrent.ExecutionException: com.google.gwtorm.server.OrmException: fetch failure on accounts
at com.google.common.util.concurrent.AbstractFuture$Sync.getValue(AbstractFuture.java:299)
at com.google.common.util.concurrent.AbstractFuture$Sync.get(AbstractFuture.java:286)
at com.google.common.util.concurrent.AbstractFuture.get(AbstractFuture.java:116)
at com.google.common.util.concurrent.Uninterruptibles.getUninterruptibly(Uninterruptibles.java:135)
at com.google.common.cache.LocalCache$Segment.getAndRecordStats(LocalCache.java:2346)
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2318)
at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2280)
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2195)
at com.google.common.cache.LocalCache.get(LocalCache.java:3934)
at com.google.common.cache.LocalCache.getOrLoad(LocalCache.java:3938)
at com.google.common.cache.LocalCache$LocalLoadingCache.get(LocalCache.java:4821)
at com.google.gerrit.server.account.AccountCacheImpl.get(AccountCacheImpl.java:84)
at com.google.gerrit.server.IdentifiedUser.state(IdentifiedUser.java:228)
at com.google.gerrit.server.IdentifiedUser.getAccount(IdentifiedUser.java:245)
at com.google.gerrit.sshd.DatabasePubKeyAuth.authenticate(DatabasePubKeyAuth.java:144)
at org.apache.sshd.server.auth.UserAuthPublicKey.doAuth(UserAuthPublicKey.java:78)
at org.apache.sshd.server.auth.AbstractUserAuth.auth(AbstractUserAuth.java:49)
at org.apache.sshd.server.session.ServerSession.userAuth(ServerSession.java:443)
at org.apache.sshd.server.session.ServerSession.handleMessage(ServerSession.java:212)
at org.apache.sshd.common.session.AbstractSession.decode(AbstractSession.java:587)
at org.apache.sshd.common.session.AbstractSession.messageReceived(AbstractSession.java:253)
at org.apache.sshd.common.AbstractSessionIoHandler.messageReceived(AbstractSessionIoHandler.java:54)
at org.apache.sshd.common.io.mina.MinaService.messageReceived(MinaService.java:94)
at org.apache.mina.core.filterchain.DefaultIoFilterChain$TailFilter.messageReceived(DefaultIoFilterChain.java:690)
at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:417)
at org.apache.mina.core.filterchain.DefaultIoFilterChain.access$1200(DefaultIoFilterChain.java:47)
at org.apache.mina.core.filterchain.DefaultIoFilterChain$EntryImpl$1.messageReceived(DefaultIoFilterChain.java:765)
at org.apache.mina.core.filterchain.IoFilterAdapter.messageReceived(IoFilterAdapter.java:109)
at org.apache.mina.core.filterchain.DefaultIoFilterChain.callNextMessageReceived(DefaultIoFilterChain.java:417)
at org.apache.mina.core.filterchain.DefaultIoFilterChain.fireMessageReceived(DefaultIoFilterChain.java:410)
at org.apache.mina.core.polling.AbstractPollingIoProcessor.read(AbstractPollingIoProcessor.java:710)
at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:664)
at org.apache.mina.core.polling.AbstractPollingIoProcessor.process(AbstractPollingIoProcessor.java:653)
at org.apache.mina.core.polling.AbstractPollingIoProcessor.access$600(AbstractPollingIoProcessor.java:67)
at org.apache.mina.core.polling.AbstractPollingIoProcessor$Processor.run(AbstractPollingIoProcessor.java:1124)
at org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:64)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.google.gwtorm.server.OrmException: fetch failure on accounts
at com.google.gwtorm.schema.sql.SqlDialect.convertError(SqlDialect.java:153)
at com.google.gwtorm.schema.sql.DialectMySQL.convertError(DialectMySQL.java:227)
at com.google.gwtorm.jdbc.JdbcAccess.convertError(JdbcAccess.java:457)
at com.google.gwtorm.jdbc.JdbcAccess.queryOne(JdbcAccess.java:135)
at com.google.gerrit.reviewdb.client.Account_Access_accounts_GwtOrm$$11.get(Unknown Source)
at com.google.gerrit.server.account.AccountCacheImpl$ByIdLoader.load(AccountCacheImpl.java:155)
at com.google.gerrit.server.account.AccountCacheImpl$ByIdLoader.load(AccountCacheImpl.java:142)
at com.google.gerrit.server.account.AccountCacheImpl$ByIdLoader.load(AccountCacheImpl.java:125)
at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3524)
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2317)
... 33 more
Caused by: java.sql.SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1061)
at com.mysql.jdbc.ByteArrayRow.getTimestampFast(ByteArrayRow.java:127)
at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6591)
at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6191)
at com.google.gerrit.reviewdb.client.Account_Access_accounts_GwtOrm$$11.bindOneFetch(Unknown Source)
at com.google.gwtorm.jdbc.JdbcAccess.queryOne(JdbcAccess.java:122)
... 39 more
Tien-Chi Lee
Jul 8, 2015, 3:02:29 AM7/8/15
to repo-d...@googlegroups.com
Fixed. at db.accounts, "contact_filed_on" is not set to NULL
Another problem. Server is ruuning, when i log in , stop at "Loading Gerrit Code Review ..."
ssh is ok. web is fail.....
Tien-Chi Lee於 2015年7月8日星期三 UTC+8下午12時13分26秒寫道：
Another problem. Server is ruuning, when i log in , stop at "Loading Gerrit Code Review ..."
ssh is ok. web is fail.....
Tien-Chi Lee於 2015年7月8日星期三 UTC+8下午12時13分26秒寫道：
Marcin Cieslak
Jul 8, 2015, 3:07:06 AM7/8/15
to Tien-Chi Lee, repo-d...@googlegroups.com
On Wed, 8 Jul 2015, Tien-Chi Lee wrote:
> Fixed. at db.accounts, "contact_filed_on" is not set to NULL
>
>
> Another problem. Server is ruuning, when i log in , stop at "Loading Gerrit
> Code Review <http://code.google.com/p/gerrit/> ..."
> Fixed. at db.accounts, "contact_filed_on" is not set to NULL
>
>
> Another problem. Server is ruuning, when i log in , stop at "Loading Gerrit
>
> ssh is ok. web is fail.....
You have to check whether various types from H2 got imported correctly.
> ssh is ok. web is fail.....
Obviously timestamps didn't. Maybe some other fields?
Marcin
Zohaib ahmed hassan
Jul 14, 2015, 5:23:20 AM7/14/15
to repo-d...@googlegroups.com
hey is your gerrit and mysql are in diffrent vms or server ?
Reply all
Reply to author
Forward
0 new messages