{"action":"created","issue":{"url":"https://api.github.com/repos/naver/yobi/issues/923","labels_url":"https://api.github.com/repos/naver/yobi/issues/923/labels{/name}","comments_url":"https://api.github.com/repos/naver/yobi/issues/923/comments","events_url":"https://api.github.com/repos/naver/yobi/issues/923/events","html_url":"https://github.com/naver/yobi/issues/923","id":85480072,"number":923,"title":"0.8 업그레이드시 DB관련 오류 발생","user":{"login":"namineya","id":8434627,"avatar_url":"https://avatars.githubusercontent.com/u/8434627?v=3","gravatar_id":"","url":"https://api.github.com/users/namineya","html_url":"https://github.com/namineya","followers_url":"https://api.github.com/users/namineya/followers","following_url":"https://api.github.com/users/namineya/following{/other_user}","gists_url":"https://api.github.com/users/namineya/gists{/gist_id}","starred_url":"https://api.github.com/users/namineya/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/namineya/subscriptions","organizations_url":"https://api.github.com/users/namineya/orgs","repos_url":"https://api.github.com/users/namineya/repos","events_url":"https://api.github.com/users/namineya/events{/privacy}","received_events_url":"https://api.github.com/users/namineya/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-06-05T09:14:19Z","updated_at":"2015-06-08T01:03:08Z","closed_at":null,"body":"오류 내용은 아래와 같습니다.\r\n기존에 사용중인 yobi.h2.db 를 덮어쓰기 한 후 실행을 하니 발생한 오류입니다.\r\n이 오류 관련하여 참고할만한 이슈가 있다면 피드백 부탁 드립니다.\r\n\r\n\r\nPicked up _JAVA_OPTIONS: -Xmx2048m -Xms1024m\r\nPlay server process ID is 3575\r\n[error] c.j.b.h.AbstractConnectionHook - Failed to obtain initial connection Sleeping for 0ms and trying again. Attempts left: 0. Exception: null.Message:Unique index or primary key violation: \"PRIMARY KEY ON \"\"\"\".PAGE_INDEX\"; SQL statement:\r\nALTER TABLE PUBLIC.NOTIFICATION_EVENT_N4USER ADD CONSTRAINT PUBLIC.FK_NOTIFICATION_EVENT_N4USER__01 FOREIGN KEY(NOTIFICATION_EVENT_ID) REFERENCES PUBLIC.NOTIFICATION_EVENT(ID) NOCHECK [23505-176]\r\nOops, cannot start the server.\r\nConfiguration error: Configuration error[Cannot connect to database [default]]\r\n        at play.api.Configuration$.play$api$Configuration$$configError(Configuration.scala:94)\r\n        at play.api.Configuration.reportError(Configuration.scala:743)\r\n        at play.api.db.BoneCPPlugin$$anonfun$onStart$1.apply(DB.scala:247)\r\n        at play.api.db.BoneCPPlugin$$anonfun$onStart$1.apply(DB.scala:238)\r\n        at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:244)\r\n        at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:244)\r\n        at scala.collection.immutable.List.foreach(List.scala:318)\r\n        at scala.collection.TraversableLike$class.map(TraversableLike.scala:244)\r\n        at scala.collection.AbstractTraversable.map(Traversable.scala:105)\r\n        at play.api.db.BoneCPPlugin.onStart(DB.scala:238)\r\n        at play.api.Play$$anonfun$start$1$$anonfun$apply$mcV$sp$1.apply(Play.scala:91)\r\n        at play.api.Play$$anonfun$start$1$$anonfun$apply$mcV$sp$1.apply(Play.scala:91)\r\n        at scala.collection.immutable.List.foreach(List.scala:318)\r\n        at play.api.Play$$anonfun$start$1.apply$mcV$sp(Play.scala:91)\r\n        at play.api.Play$$anonfun$start$1.apply(Play.scala:91)\r\n        at play.api.Play$$anonfun$start$1.apply(Play.scala:91)\r\n        at play.utils.Threads$.withContextClassLoader(Threads.scala:21)\r\n        at play.api.Play$.start(Play.scala:90)\r\n        at play.core.StaticApplication.<init>(ApplicationProvider.scala:55)\r\n        at play.core.server.NettyServer$.createServer(NettyServer.scala:244)\r\n        at play.core.server.NettyServer$$anonfun$main$3.apply(NettyServer.scala:280)\r\n        at play.core.server.NettyServer$$anonfun$main$3.apply(NettyServer.scala:275)\r\n        at scala.Option.map(Option.scala:145)\r\n        at play.core.server.NettyServer$.main(NettyServer.scala:275)\r\n        at play.core.server.NettyServer.main(NettyServer.scala)\r\nCaused by: org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: \"PRIMARY KEY ON \"\"\"\".PAGE_INDEX\"; SQL statement:\r\nALTER TABLE PUBLIC.NOTIFICATION_EVENT_N4USER ADD CONSTRAINT PUBLIC.FK_NOTIFICATION_EVENT_N4USER__01 FOREIGN KEY(NOTIFICATION_EVENT_ID) REFERENCES PUBLIC.NOTIFICATION_EVENT(ID) NOCHECK [23505-176]\r\n        at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)\r\n        at org.h2.message.DbException.get(DbException.java:178)\r\n        at org.h2.message.DbException.get(DbException.java:154)\r\n        at org.h2.index.PageDataIndex.getNewDuplicateKeyException(PageDataIndex.java:166)\r\n        at org.h2.index.PageDataIndex.add(PageDataIndex.java:144)\r\n        at org.h2.store.PageStore.addMeta(PageStore.java:1808)\r\n        at org.h2.index.PageBtreeIndex.<init>(PageBtreeIndex.java:64)\r\n        at org.h2.table.RegularTable.addIndex(RegularTable.java:235)\r\n        at org.h2.command.ddl.AlterTableAddConstraint.createIndex(AlterTableAddConstraint.java:280)\r\n        at org.h2.command.ddl.AlterTableAddConstraint.tryUpdate(AlterTableAddConstraint.java:205)\r\n        at org.h2.command.ddl.AlterTableAddConstraint.update(AlterTableAddConstraint.java:73)\r\n        at org.h2.engine.MetaRecord.execute(MetaRecord.java:59)\r\n        at org.h2.engine.Database.open(Database.java:719)\r\n        at org.h2.engine.Database.openDatabase(Database.java:260)\r\n        at org.h2.engine.Database.<init>(Database.java:254)\r\n        at org.h2.engine.Engine.openSession(Engine.java:57)\r\n        at org.h2.engine.Engine.openSession(Engine.java:164)\r\n        at org.h2.engine.Engine.createSessionAndValidate(Engine.java:142)\r\n        at org.h2.engine.Engine.createSession(Engine.java:125)\r\n        at org.h2.engine.Engine.createSession(Engine.java:27)\r\n        at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:331)\r\n        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:107)\r\n        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:91)\r\n        at org.h2.Driver.connect(Driver.java:74)\r\n        at java.sql.DriverManager.getConnection(DriverManager.java:571)\r\n        at java.sql.DriverManager.getConnection(DriverManager.java:215)\r\n        at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:363)\r\n        at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:416)\r\n        at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:120)\r\n        at play.api.db.BoneCPPlugin$$anonfun$onStart$1.apply(DB.scala:240)\r\n        ... 22 move\r\n"},"comment":{"url":"https://api.github.com/repos/naver/yobi/issues/comments/109819619","html_url":"https://github.com/naver/yobi/issues/923#issuecomment-109819619","issue_url":"https://api.github.com/repos/naver/yobi/issues/923","id":109819619,"user":{"login":"namineya","id":8434627,"avatar_url":"https://avatars.githubusercontent.com/u/8434627?v=3","gravatar_id":"","url":"https://api.github.com/users/namineya","html_url":"https://github.com/namineya","followers_url":"https://api.github.com/users/namineya/followers","following_url":"https://api.github.com/users/namineya/following{/other_user}","gists_url":"https://api.github.com/users/namineya/gists{/gist_id}","starred_url":"https://api.github.com/users/namineya/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/namineya/subscriptions","organizations_url":"https://api.github.com/users/namineya/orgs","repos_url":"https://api.github.com/users/namineya/repos","events_url":"https://api.github.com/users/namineya/events{/privacy}","received_events_url":"https://api.github.com/users/namineya/received_events","type":"User","site_admin":false},"created_at":"2015-06-08T01:03:08Z","updated_at":"2015-06-08T01:03:08Z","body":"#924 를 참고하여 정상 페이지까지 확인 하였습니다. 그런데 로그인 시 암호가 맞지 않다고 나오는데 혹시 어떤 문제일런지요? 복원은 zip파일로 백업을 한 후 진행하였습니다. "}}