./showdb my-db 5 Pagesize: 4096
Available pages: 1..745888 Page 5: (offsets 0x4000..0x4fff) 0000: 0d 00 00 00 01 0e 0d 00 0e 0d 00 00 00 00 00 00 ................ 0010: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0020: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0030: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0040: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0050: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0060: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0070: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ ............ all zeros...... 0cd0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0ce0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0cf0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0d00: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0d10: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0d20: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0d30: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0d40: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0d50: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0d60: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0d70: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0d80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0d90: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0da0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0db0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0dc0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0dd0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0de0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0df0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0e00: 00 00 00 00 00 00 00 00 00 00 00 00 00 85 d6 dd ................ 0e10: 8b 28 01 03 13 02 6c 6f 67 0b 74 00 00 00 00 00 .(....log.t..... 0e20: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0e30: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0e40: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0e50: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0e60: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0e70: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0e80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0e90: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0ea0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0eb0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0ec0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0ed0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0ee0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0ef0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0f00: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ ................. all zeros.......... 0f80: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0f90: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0fa0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0fb0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0fc0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0fd0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0fe0: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ 0ff0: 00 00 00 00 00 00 00 00 00 00 00 00 00 05 b0 fa ................ ./showdb my-db 5bc Pagesize: 4096 Available pages: 1..745888 Header on btree page 5: 000: 0d 13 table leaf 001: 00 00 0 Offset to first freeblock 003: 00 01 1 Number of cells on this page 005: 0e 0d 3597 Offset to cell content area 007: 00 0 Fragmented byte count key: lx=left-child n=payload-size r=rowid e0d: cell[0] n: 1524057512 r: 1 ov: 372986 txt(3),2932 Thanks. 2016. 7. 29. 오전 10:54에 "Richard Hipp" <[email protected]>님이 작성: > On 7/28/16, 이영준 <[hidden email] > <http:///user/SendEmail.jtp?type=node&node=90638&i=0>> wrote: > > > > For sqlite_sequence table, the hex dump of the problematic entry is like > > below. > > The rootpage of sqlite_sequence resides in page 5. > > Please get the original SQLite source tree and run "make showdb" . > Then run the commands: > > ./showdb your-database 5 > ./showdb your-database 5bc > > And send me the output. Thanks. > > > -- > D. Richard Hipp > [hidden email] <http:///user/SendEmail.jtp?type=node&node=90638&i=1> > _______________________________________________ > sqlite-users mailing list > [hidden email] <http:///user/SendEmail.jtp?type=node&node=90638&i=2> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > > http://sqlite.1065341.n5.nabble.com/string-or-blob-too-big-issue-on-a-corrupted-db-tp90633p90638.html > To unsubscribe from "string or blob too big" issue on a corrupted db, click > here > <http://sqlite.1065341.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=90633&code=dGhlc29vbXl1bmdAZ21haWwuY29tfDkwNjMzfC0xNjU5MTA3OTg5> > . > NAML > <http://sqlite.1065341.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
