Not able to push data into bitbucket repository

[Harshil Narielwala]

Bitbucket:6.3.0

git:2.21.0

mysql : Ver 14.14 Distrib 5.7.26

2019-05-28 22:55:53,007 DEBUG [http-nio-7990-exec-9] @1LRNBGx1375x1275x0 115.96.65.131 "GET /scm/ws/webservices0.1.git/info/refs HTTP/1.1" c.a.b.i.c.s.CrowdSsoAuthenticationHandler Skipping Crowd SSO as it is not enabled
2019-05-28 22:55:53,007 DEBUG [http-nio-7990-exec-9] @1LRNBGx1375x1275x0 115.96.65.131 "GET /scm/ws/webservices0.1.git/info/refs HTTP/1.1" c.a.s.i.i18n.PluginI18nService No values found in any valid locale for key ProviderManager.providerNotFound and locales [en_US, en]
2019-05-28 22:55:53,793 DEBUG [http-nio-7990-exec-5] @1LRNBGx1375x1276x0 115.96.65.131 "GET /scm/ws/webservices0.1.git/info/refs HTTP/1.1" c.a.b.i.c.s.CrowdSsoAuthenticationHandler Skipping Crowd SSO as it is not enabled
2019-05-28 22:55:53,837 DEBUG [http-nio-7990-exec-5] harshil@appexinnovation.com @1LRNBGx1375x1276x0 115.96.65.131 "GET /scm/ws/webservices0.1.git/info/refs HTTP/1.1" c.a.bitbucket.scm.BaseCommand Executed /usr/local/git/bin/git http-backend
2019-05-28 22:55:54,997 DEBUG [http-nio-7990-exec-4] @1LRNBGx1375x1277x0 115.96.65.131 "GET /scm/ws/webservices0.1.git/info/refs HTTP/1.1" c.a.b.i.c.s.CrowdSsoAuthenticationHandler Skipping Crowd SSO as it is not enabled
2019-05-28 22:55:54,998 DEBUG [http-nio-7990-exec-4] @1LRNBGx1375x1277x0 115.96.65.131 "GET /scm/ws/webservices0.1.git/info/refs HTTP/1.1" c.a.s.i.i18n.PluginI18nService No values found in any valid locale for key ProviderManager.providerNotFound and locales [en_US, en]
2019-05-28 22:55:55,725 DEBUG [http-nio-7990-exec-1] @1LRNBGx1375x1278x0 115.96.65.131 "GET /scm/ws/webservices0.1.git/info/refs HTTP/1.1" c.a.b.i.c.s.CrowdSsoAuthenticationHandler Skipping Crowd SSO as it is not enabled
2019-05-28 22:55:55,742 DEBUG [http-nio-7990-exec-1] harshil@appexinnovation.com @1LRNBGx1375x1278x0 115.96.65.131 "GET /scm/ws/webservices0.1.git/info/refs HTTP/1.1" c.a.bitbucket.scm.BaseCommand Executed /usr/local/git/bin/git http-backend
2019-05-28 22:56:01,014 DEBUG [http-nio-7990-exec-10] @1LRNBGx1376x1279x0 115.96.65.131 "GET /scm/ws/webservices0.1.git/info/refs HTTP/1.1" c.a.b.i.c.s.CrowdSsoAuthenticationHandler Skipping Crowd SSO as it is not enabled
2019-05-28 22:56:01,015 DEBUG [http-nio-7990-exec-10] @1LRNBGx1376x1279x0 115.96.65.131 "GET /scm/ws/webservices0.1.git/info/refs HTTP/1.1" c.a.s.i.i18n.PluginI18nService No values found in any valid locale for key ProviderManager.providerNotFound and locales [en_US, en]
2019-05-28 22:56:01,826 DEBUG [http-nio-7990-exec-3] @1LRNBGx1376x1280x0 115.96.65.131 "GET /scm/ws/webservices0.1.git/info/refs HTTP/1.1" c.a.b.i.c.s.CrowdSsoAuthenticationHandler Skipping Crowd SSO as it is not enabled
2019-05-28 22:56:01,861 DEBUG [http-nio-7990-exec-3] harshil@appexinnovation.com @1LRNBGx1376x1280x0 115.96.65.131 "GET /scm/ws/webservices0.1.git/info/refs HTTP/1.1" c.a.bitbucket.scm.BaseCommand Executed /usr/local/git/bin/git http-backend
2019-05-28 22:56:10,572 DEBUG [http-nio-7990-exec-2] @1LRNBGx1376x1281x0 115.96.65.131 "GET /scm/ws/webservices0.1.git/info/refs HTTP/1.1" c.a.b.i.c.s.CrowdSsoAuthenticationHandler Skipping Crowd SSO as it is not enabled
2019-05-28 22:56:10,573 DEBUG [http-nio-7990-exec-2] @1LRNBGx1376x1281x0 115.96.65.131 "GET /scm/ws/webservices0.1.git/info/refs HTTP/1.1" c.a.s.i.i18n.PluginI18nService No values found in any valid locale for key ProviderManager.providerNotFound and locales [en_US, en]
2019-05-28 22:56:11,366 DEBUG [http-nio-7990-exec-9] @1LRNBGx1376x1282x0 115.96.65.131 "GET /scm/ws/webservices0.1.git/info/refs HTTP/1.1" c.a.b.i.c.s.CrowdSsoAuthenticationHandler Skipping Crowd SSO as it is not enabled
2019-05-28 22:56:11,399 DEBUG [http-nio-7990-exec-9] harshil@appexinnovation.com @1LRNBGx1376x1282x0 115.96.65.131 "GET /scm/ws/webservices0.1.git/info/refs HTTP/1.1" c.a.bitbucket.scm.BaseCommand Executed /usr/local/git/bin/git http-backend
2019-05-28 22:56:13,042 DEBUG [http-nio-7990-exec-5] @1LRNBGx1376x1283x0 115.96.65.131 "GET /scm/ws/webservices0.1.git/info/refs HTTP/1.1" c.a.b.i.c.s.CrowdSsoAuthenticationHandler Skipping Crowd SSO as it is not enabled
2019-05-28 22:56:13,042 DEBUG [http-nio-7990-exec-5] @1LRNBGx1376x1283x0 115.96.65.131 "GET /scm/ws/webservices0.1.git/info/refs HTTP/1.1" c.a.s.i.i18n.PluginI18nService No values found in any valid locale for key ProviderManager.providerNotFound and locales [en_US, en]
2019-05-28 22:56:13,768 DEBUG [http-nio-7990-exec-7] @1LRNBGx1376x1284x0 115.96.65.131 "GET /scm/ws/webservices0.1.git/info/refs HTTP/1.1" c.a.b.i.c.s.CrowdSsoAuthenticationHandler Skipping Crowd SSO as it is not enabled
2019-05-28 22:56:13,782 DEBUG [http-nio-7990-exec-7] harshil@appexinnovation.com @1LRNBGx1376x1284x0 115.96.65.131 "GET /scm/ws/webservices0.1.git/info/refs HTTP/1.1" c.a.bitbucket.scm.BaseCommand Executed /usr/local/git/bin/git http-backend
2019-05-28 22:56:15,166 DEBUG [http-nio-7990-exec-1] @1LRNBGx1376x1285x0 115.96.65.131 "POST /scm/ws/webservices0.1.git/info/lfs/locks/verify HTTP/1.1" c.a.b.i.c.s.CrowdSsoAuthenticationHandler Skipping Crowd SSO as it is not enabled
2019-05-28 22:56:15,173 ERROR [http-nio-7990-exec-1] harshil@appexinnovation.com @1LRNBGx1376x1285x0 115.96.65.131 "POST /scm/ws/webservices0.1.git/info/lfs/locks/verify HTTP/1.1" c.a.b.i.s.g.lfs.http.LfsHttpScmUtils Un-mapped exception
com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.atlassian.bitbucket.server.bitbucket-git-lfs]
at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:106)
at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:97)
at com.atlassian.sal.core.executor.ThreadLocalDelegateCallable.call(ThreadLocalDelegateCallable.java:38)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.lang.Thread.run(Thread.java:748)
... 1 frame trimmed
Caused by: java.lang.RuntimeException: Could not read fields for table AO_811463_GIT_LFS_LOCK
at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getFields(DatabaseMetaDataReaderImpl.java:141)
at net.java.ao.schema.ddl.SchemaReader.readFields(SchemaReader.java:126)
at net.java.ao.schema.ddl.SchemaReader.readTable(SchemaReader.java:110)
at net.java.ao.schema.ddl.SchemaReader.access$000(SchemaReader.java:62)
at net.java.ao.schema.ddl.SchemaReader$1.apply(SchemaReader.java:99)
at net.java.ao.schema.ddl.SchemaReader$1.apply(SchemaReader.java:97)
at com.google.common.collect.Iterators$6.transform(Iterators.java:785)
at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:47)
at com.google.common.collect.Iterators.addAll(Iterators.java:358)
at com.google.common.collect.Lists.newArrayList(Lists.java:147)
at com.google.common.collect.Lists.newArrayList(Lists.java:133)
at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:97)
at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:88)
at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:81)
at net.java.ao.schema.SchemaGenerator.generateImpl(SchemaGenerator.java:107)
at net.java.ao.schema.SchemaGenerator.migrate(SchemaGenerator.java:84)
at net.java.ao.EntityManager.migrate(EntityManager.java:128)
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:51)
at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory$1.doInTransaction(AbstractActiveObjectsFactory.java:77)
at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory$1.doInTransaction(AbstractActiveObjectsFactory.java:72)
at com.atlassian.sal.core.transaction.HostContextTransactionTemplate$1.doInTransaction(HostContextTransactionTemplate.java:21)
at com.atlassian.stash.internal.sal.spi.HostContextAccessorImpl.doInTransaction(HostContextAccessorImpl.java:54)
at com.atlassian.sal.core.transaction.HostContextTransactionTemplate.execute(HostContextTransactionTemplate.java:18)
at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)
at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)
at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60)
at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70)
at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53)
at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)
at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.create(AbstractActiveObjectsFactory.java:72)
at com.atlassian.activeobjects.internal.DelegatingActiveObjectsFactory.create(DelegatingActiveObjectsFactory.java:32)
at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:102)
... 6 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: Unknown table 'AO_811463_GIT_LFS_LOCK' in information_schema
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1218)
at com.mysql.cj.jdbc.DatabaseMetaData$7.forEach(DatabaseMetaData.java:2980)
at com.mysql.cj.jdbc.DatabaseMetaData$7.forEach(DatabaseMetaData.java:2968)
at com.mysql.cj.jdbc.IterateBlock.doForAll(IterateBlock.java:56)
at com.mysql.cj.jdbc.DatabaseMetaData.getPrimaryKeys(DatabaseMetaData.java:3021)
at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getFields(DatabaseMetaDataReaderImpl.java:129)
... 37 common frames omitted
2019-05-28 22:56:15,829 DEBUG [http-nio-7990-exec-8] @1LRNBGx1376x1286x0 115.96.65.131 "POST /scm/ws/webservices0.1.git/git-receive-pack HTTP/1.1" c.a.b.i.c.s.CrowdSsoAuthenticationHandler Skipping Crowd SSO as it is not enabled
2019-05-28 22:56:15,844 DEBUG [http-nio-7990-exec-8] harshil@appexinnovation.com @1LRNBGx1376x1286x0 115.96.65.131 "POST /scm/ws/webservices0.1.git/git-receive-pack HTTP/1.1" c.a.bitbucket.scm.BaseCommand Executed /usr/local/git/bin/git http-backend
2019-05-28 22:56:16,052 DEBUG [http-nio-7990-exec-10] @1LRNBGx1376x1287x0 115.96.65.131 "POST /scm/ws/webservices0.1.git/git-receive-pack HTTP/1.1" c.a.b.i.c.s.CrowdSsoAuthenticationHandler Skipping Crowd SSO as it is not enabled
2019-05-28 22:56:18,243 WARN [hook-callback:thread-2] harshil@appexinnovation.com @1LRNBGx1376x1287x0 115.96.65.131 "POST /scm/ws/webservices0.1.git/git-receive-pack HTTP/1.1" c.a.s.i.h.r.DefaultRepositoryHookService [WS/webservices0.1[1]] Error calling com.atlassian.bitbucket.internal.scm.git.lfs.hook.VerifyLfsLocksHook.preUpdate (com.atlassian.bitbucket.server.bitbucket-git-lfs:verify-lfs-locks-hook)
com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.atlassian.bitbucket.server.bitbucket-git-lfs]
at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:106)
at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:97)
at com.atlassian.sal.core.executor.ThreadLocalDelegateCallable.call(ThreadLocalDelegateCallable.java:38)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.lang.Thread.run(Thread.java:748)
... 1 frame trimmed
Caused by: java.lang.RuntimeException: Could not read fields for table AO_811463_GIT_LFS_LOCK
at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getFields(DatabaseMetaDataReaderImpl.java:141)
at net.java.ao.schema.ddl.SchemaReader.readFields(SchemaReader.java:126)
at net.java.ao.schema.ddl.SchemaReader.readTable(SchemaReader.java:110)
at net.java.ao.schema.ddl.SchemaReader.access$000(SchemaReader.java:62)
at net.java.ao.schema.ddl.SchemaReader$1.apply(SchemaReader.java:99)
at net.java.ao.schema.ddl.SchemaReader$1.apply(SchemaReader.java:97)
at com.google.common.collect.Iterators$6.transform(Iterators.java:785)
at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:47)
at com.google.common.collect.Iterators.addAll(Iterators.java:358)
at com.google.common.collect.Lists.newArrayList(Lists.java:147)
at com.google.common.collect.Lists.newArrayList(Lists.java:133)
at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:97)
at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:88)
at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:81)
at net.java.ao.schema.SchemaGenerator.generateImpl(SchemaGenerator.java:107)
at net.java.ao.schema.SchemaGenerator.migrate(SchemaGenerator.java:84)
at net.java.ao.EntityManager.migrate(EntityManager.java:128)
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:51)
at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory$1.doInTransaction(AbstractActiveObjectsFactory.java:77)
at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory$1.doInTransaction(AbstractActiveObjectsFactory.java:72)
at com.atlassian.sal.core.transaction.HostContextTransactionTemplate$1.doInTransaction(HostContextTransactionTemplate.java:21)
at com.atlassian.stash.internal.sal.spi.HostContextAccessorImpl.doInTransaction(HostContextAccessorImpl.java:54)
at com.atlassian.sal.core.transaction.HostContextTransactionTemplate.execute(HostContextTransactionTemplate.java:18)
at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)
at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)
at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60)
at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70)
at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53)
at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)
at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.create(AbstractActiveObjectsFactory.java:72)
at com.atlassian.activeobjects.internal.DelegatingActiveObjectsFactory.create(DelegatingActiveObjectsFactory.java:32)
at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:102)
... 6 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: Unknown table 'AO_811463_GIT_LFS_LOCK' in information_schema
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1218)
at com.mysql.cj.jdbc.DatabaseMetaData$7.forEach(DatabaseMetaData.java:2980)
at com.mysql.cj.jdbc.DatabaseMetaData$7.forEach(DatabaseMetaData.java:2968)
at com.mysql.cj.jdbc.IterateBlock.doForAll(IterateBlock.java:56)
at com.mysql.cj.jdbc.DatabaseMetaData.getPrimaryKeys(DatabaseMetaData.java:3021)
at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getFields(DatabaseMetaDataReaderImpl.java:129)
... 37 common frames omitted

[Stephen Sifers · Accepted solution]

Hello Harshil and welcome to the community!

Thank you for providing your log output when you’re unable to push data into Bitbucket. From the logs, I was able to find the 4 following faulting issues which all point to a database problem. The errors are as follows:

Caused by: java.lang.RuntimeException: Could not read fields for table AO_811463_GIT_LFS_LOCK at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getFields(DatabaseMetaDataReaderImpl.java:141)

Caused by: java.sql.SQLSyntaxErrorException: Unknown table 'AO_811463_GIT_LFS_LOCK' in information_schema

Caused by: java.lang.RuntimeException: Could not read fields for table AO_811463_GIT_LFS_LOCKat net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getFields(DatabaseMetaDataReaderImpl.java:141)

Caused by: java.sql.SQLSyntaxErrorException: Unknown table 'AO_811463_GIT_LFS_LOCK' in information_schema

A few items to attempt would be as follows:

• Restart your database instance or server in an attempt to unlock the table
• Ensure permissions are correctly configured for Bitbucket and your Database.
• Ensure your MySQL driver is configured correctly and at the right version
• Connecting Bitbucket Server to MySQL
• Restore your database to an earlier working state (You may test this within a staging instance)

If you’re still unable to push data to Bitbucket after attempting to above please let us know.

Regards,
Stephen Sifers