{"issue":{"milestone":{"title":"0.9.2","created_at":"2011-12-30T02:11:02Z","open_issues":0,"creator":{"login":"dynamobi-build","id":1123017,"url":"https://api.github.com/users/dynamobi-build","avatar_url":"https://secure.gravatar.com/avatar/cb215b3d786be20761071a562a56af64?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"cb215b3d786be20761071a562a56af64"},"state":"closed","due_on":null,"closed_issues":1,"number":6,"description":null,"url":"https://api.github.com/repos/dynamobi/dynamobi/milestones/6"},"title":"[LDB-198] Assertion failure isSingleton(inputTuple) in LbmEntry when creating IDX","created_at":"2011-12-30T02:14:56Z","user":{"login":"dynamobi-build","id":1123017,"url":"https://api.github.com/users/dynamobi-build","avatar_url":"https://secure.gravatar.com/avatar/cb215b3d786be20761071a562a56af64?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"cb215b3d786be20761071a562a56af64"},"labels":[{"name":"LBM","url":"https://api.github.com/repos/dynamobi/dynamobi/labels/LBM","color":"3de99d"},{"name":"LDB","url":"https://api.github.com/repos/dynamobi/dynamobi/labels/LDB","color":"e2b9bd"}],"updated_at":"2011-12-30T02:15:01Z","state":"closed","id":2685279,"closed_at":"2011-12-30T02:14:57Z","html_url":"https://github.com/dynamobi/dynamobi/issues/124","pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"body":"<b><i>[reporter=\"ngoodman\", created=\"Thu, 10 Sep 2009 15:20:28 -0500 (GMT-05:00)\"]</i></b>\nOriginally reported here:\n<br/>\n<a href=\"http://n2.nabble.com/Re-Lucid-Indexes-tc3578725.html#none\">http://n2.nabble.com/Re-Lucid-Indexes-tc3578725.html#none</a>\n<br/>\n\n<br/>\nSep 7, 2009 9:35:56 AM net.sf.farrago.db.FarragoDbSession prepare\n<br/>\nINFO: create index f_salesledger_stat_idx on OPEN_ACCOUNTS.F_SALESLEDGER(STAT)\n<br/>\nSep 7, 2009 9:35:56 AM net.sf.farrago.db.FarragoDbSession commitImpl\n<br/>\nINFO: commit\n<br/>\nSep 7, 2009 9:35:57 AM net.sf.farrago.db.FarragoDbStmtContext cancel\n<br/>\nINFO: cancel\n<br/>\nSep 7, 2009 9:35:58 AM org.eigenbase.util.EigenbaseException <init>\n<br/>\nSEVERE: org.eigenbase.util.EigenbaseException: Internal error:  Assertion `isSingleton(inputTuple)' failed at line 944 in file /root/open/dev/fennel/lucidera/bitmap/LbmEntry.cpp\n<br/>\nSep 7, 2009 9:35:58 AM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException\n<br/>\nSEVERE: error while fetching from cursor\n<br/>\nSep 7, 2009 9:35:58 AM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException\n<br/>\nSEVERE: Internal error:  Assertion `isSingleton(inputTuple)' failed at line 944 in file /root/open/dev/fennel/lucidera/bitmap/LbmEntry.cpp\n<br/>\nSep 7, 2009 9:35:58 AM org.eigenbase.util.EigenbaseException <init>\n<br/>\nSEVERE: org.eigenbase.util.EigenbaseException: DML statement execution failed.\n<br/>\nSep 7, 2009 9:35:58 AM org.eigenbase.util.EigenbaseException <init>\n<br/>\nSEVERE: org.eigenbase.util.EigenbaseException: Failed while executing internal statement\n<br/>\nSep 7, 2009 9:35:58 AM net.sf.farrago.db.FarragoDbStmtContext cancel\n<br/>\nINFO: cancel\n<br/>\nSep 7, 2009 9:35:58 AM net.sf.farrago.db.FarragoDbSession rollbackImpl\n<br/>\nINFO: rollback\n<br/>\nSep 7, 2009 9:35:58 AM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException\n<br/>\nSEVERE: Failed while executing internal statement\n<br/>\nSep 7, 2009 9:35:58 AM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException\n<br/>\nSEVERE: DML statement execution failed.\n<br/>\nSep 7, 2009 9:35:58 AM net.sf.farrago.jdbc.FarragoJdbcUtil newSqlException\n<br/>\nSEVERE: Internal error:  Assertion `isSingleton(inputTuple)' failed at line 944 in file /root/open/dev/fennel/lucidera/bitmap/LbmEntry.cpp\n<br/>\nSep 7, 2009 9:35:58 AM net.sf.farrago.db.FarragoDbStmtContext cancel\n<br/>\nINFO: cancel\n<br/>\nSep 7, 2009 9:35:58 AM net.sf.farrago.db.FarragoDbStmtContext cancel\n<br/>\nINFO: cancel\n<br/>\n\n<br/>\nNot resolved in 0.9.2 (unreleased).\n<br/>\n\n<br/>\nEmailed with Tom Barber.  Data isn't public so we'll try and reproduce in the lab and resolve.","number":124,"url":"https://api.github.com/repos/dynamobi/dynamobi/issues/124","comments":3,"assignee":null},"comment":{"created_at":"2011-12-30T02:15:01Z","user":{"login":"dynamobi-build","id":1123017,"url":"https://api.github.com/users/dynamobi-build","avatar_url":"https://secure.gravatar.com/avatar/cb215b3d786be20761071a562a56af64?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"cb215b3d786be20761071a562a56af64"},"updated_at":"2011-12-30T02:15:01Z","id":3308751,"body":"<b><i>[author=\"jvs\", created=\"Mon, 14 Sep 2009 21:48:02 -0500 (GMT-05:00)\"]</i></b>\nWorkaround is to trim trailing spaces from data being indexed,\n<br/>\n\n<br/>\ne.g.\n<br/>\n\n<br/>\nUPDATE OPEN_ACCOUNTS.F_SALESLEDGER SET STAT=trim(STAT);\n<br/>\nALTER TABLE OPEN_ACCOUNTS.F_SALESLEDGER REBUILD;\n<br/>\n\n<br/>\n(The rebuild is necessary to purge the rows deleted by the UPDATE, since believe it or not, CREATE INDEX has to index deleted rows as well.)\n<br/>\n","url":"https://api.github.com/repos/dynamobi/dynamobi/issues/comments/3308751"},"action":"created"}