{"action":"created","issue":{"url":"https://api.github.com/repos/metabase/metabase/issues/3560","repository_url":"https://api.github.com/repos/metabase/metabase","labels_url":"https://api.github.com/repos/metabase/metabase/issues/3560/labels{/name}","comments_url":"https://api.github.com/repos/metabase/metabase/issues/3560/comments","events_url":"https://api.github.com/repos/metabase/metabase/issues/3560/events","html_url":"https://github.com/metabase/metabase/issues/3560","id":182836872,"number":3560,"title":"Corrupt H2 database file","user":{"login":"pratapsingh","id":484164,"avatar_url":"https://avatars.githubusercontent.com/u/484164?v=3","gravatar_id":"","url":"https://api.github.com/users/pratapsingh","html_url":"https://github.com/pratapsingh","followers_url":"https://api.github.com/users/pratapsingh/followers","following_url":"https://api.github.com/users/pratapsingh/following{/other_user}","gists_url":"https://api.github.com/users/pratapsingh/gists{/gist_id}","starred_url":"https://api.github.com/users/pratapsingh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pratapsingh/subscriptions","organizations_url":"https://api.github.com/users/pratapsingh/orgs","repos_url":"https://api.github.com/users/pratapsingh/repos","events_url":"https://api.github.com/users/pratapsingh/events{/privacy}","received_events_url":"https://api.github.com/users/pratapsingh/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/metabase/metabase/labels/Bug","name":"Bug","color":"CC333F"},{"url":"https://api.github.com/repos/metabase/metabase/labels/Database/H2","name":"Database/H2","color":"782E2E"},{"url":"https://api.github.com/repos/metabase/metabase/labels/Unable%20to%20Reproduce","name":"Unable to Reproduce","color":"CC7C83"}],"state":"open","locked":false,"assignee":{"login":"camsaul","id":1455846,"avatar_url":"https://avatars.githubusercontent.com/u/1455846?v=3","gravatar_id":"","url":"https://api.github.com/users/camsaul","html_url":"https://github.com/camsaul","followers_url":"https://api.github.com/users/camsaul/followers","following_url":"https://api.github.com/users/camsaul/following{/other_user}","gists_url":"https://api.github.com/users/camsaul/gists{/gist_id}","starred_url":"https://api.github.com/users/camsaul/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/camsaul/subscriptions","organizations_url":"https://api.github.com/users/camsaul/orgs","repos_url":"https://api.github.com/users/camsaul/repos","events_url":"https://api.github.com/users/camsaul/events{/privacy}","received_events_url":"https://api.github.com/users/camsaul/received_events","type":"User","site_admin":false},"assignees":[{"login":"camsaul","id":1455846,"avatar_url":"https://avatars.githubusercontent.com/u/1455846?v=3","gravatar_id":"","url":"https://api.github.com/users/camsaul","html_url":"https://github.com/camsaul","followers_url":"https://api.github.com/users/camsaul/followers","following_url":"https://api.github.com/users/camsaul/following{/other_user}","gists_url":"https://api.github.com/users/camsaul/gists{/gist_id}","starred_url":"https://api.github.com/users/camsaul/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/camsaul/subscriptions","organizations_url":"https://api.github.com/users/camsaul/orgs","repos_url":"https://api.github.com/users/camsaul/repos","events_url":"https://api.github.com/users/camsaul/events{/privacy}","received_events_url":"https://api.github.com/users/camsaul/received_events","type":"User","site_admin":false}],"milestone":null,"comments":53,"created_at":"2016-10-13T16:24:54Z","updated_at":"2016-10-13T21:40:13Z","closed_at":null,"body":"Hi,\r\n\r\nMetabase is not starting and I am getting below error on the startup log:\r\n\r\n> ERROR sync-database.sync :: Error in _metabase_metadata: Column \"FIELD_TYPE\" not found; SQL statement:\r\n> UPDATE \"METABASE_FIELD\" SET \"FIELD_TYPE\" = ? WHERE (\"NAME\" = ? AND \"TABLE_ID\" = 2) [42122-192]\r\n> ..\r\n> ..\r\n> ..\r\n> 10-13 15:38:21 ERROR metabase.core :: Metabase Initialization FAILED:  General error: \"java.lang.NullPointerException\"; SQL statement:\r\n> SELECT MAX(LOB) FROM INFORMATION_SCHEMA.LOB_MAP [50000-192]\r\n> 10-13 15:38:21 INFO metabase.core :: Metabase Shutting Down ...\r\n> 10-13 15:38:22 INFO metabase.core :: Metabase Shutdown COMPLETE\r\n\r\nI am not sure what caused this but now we are unable to get our metabase up and running. \r\n\r\nThanks,\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/metabase/metabase/issues/comments/253646885","html_url":"https://github.com/metabase/metabase/issues/3560#issuecomment-253646885","issue_url":"https://api.github.com/repos/metabase/metabase/issues/3560","id":253646885,"user":{"login":"pratapsingh","id":484164,"avatar_url":"https://avatars.githubusercontent.com/u/484164?v=3","gravatar_id":"","url":"https://api.github.com/users/pratapsingh","html_url":"https://github.com/pratapsingh","followers_url":"https://api.github.com/users/pratapsingh/followers","following_url":"https://api.github.com/users/pratapsingh/following{/other_user}","gists_url":"https://api.github.com/users/pratapsingh/gists{/gist_id}","starred_url":"https://api.github.com/users/pratapsingh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pratapsingh/subscriptions","organizations_url":"https://api.github.com/users/pratapsingh/orgs","repos_url":"https://api.github.com/users/pratapsingh/repos","events_url":"https://api.github.com/users/pratapsingh/events{/privacy}","received_events_url":"https://api.github.com/users/pratapsingh/received_events","type":"User","site_admin":false},"created_at":"2016-10-13T21:40:13Z","updated_at":"2016-10-13T21:40:13Z","body":"cat metabase.db.h2.sql | grep 'CREATE FORCE ALIAS'\r\nINSERT INTO O_0 VALUES(41, 0, 9, 'CREATE FORCE ALIAS PUBLIC.READ_BLOB FOR \"org.h2.tools.Recover.readBlob\"');\r\nINSERT INTO O_0 VALUES(72, 0, 9, 'CREATE FORCE ALIAS PUBLIC.READ_CLOB FOR \"org.h2.tools.Recover.readClob\"');\r\nINSERT INTO O_0 VALUES(73, 0, 9, 'CREATE FORCE ALIAS PUBLIC.READ_BLOB_DB FOR \"org.h2.tools.Recover.readBlobDb\"');\r\nINSERT INTO O_0 VALUES(74, 0, 9, 'CREATE FORCE ALIAS PUBLIC.READ_CLOB_DB FOR \"org.h2.tools.Recover.readClobDb\"');\r\nCREATE FORCE ALIAS PUBLIC.READ_BLOB FOR \"org.h2.tools.Recover.readBlob\";\r\nCREATE FORCE ALIAS PUBLIC.READ_CLOB FOR \"org.h2.tools.Recover.readClob\";\r\nCREATE FORCE ALIAS PUBLIC.READ_BLOB_DB FOR \"org.h2.tools.Recover.readBlobDb\";\r\nCREATE FORCE ALIAS PUBLIC.READ_CLOB_DB FOR \"org.h2.tools.Recover.readClobDb\";\r\n"}}
{"actor":{"display_login":"pratapsingh"}}