· 6 years ago · Jan 08, 2020, 09:26 AM
1[MR2Tachiyomi] [2020-01-08 01:41:55] [Exposed] WARN - Transaction attempt #0 failed: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id). Statement(s): CREATE TABLE IF NOT EXISTS MangaChapter (_id INTEGER PRIMARY KEY, manga_id INT NOT NULL, num_pages INT NOT NULL, oid VARCHAR(1024) NOT NULL, chapter_order INT NOT NULL, title VARCHAR(1024) NOT NULL, _id INT NULL, CONSTRAINT fk_MangaChapter__id__id FOREIGN KEY (_id) REFERENCES MangaChapterLocal(_id) ON DELETE RESTRICT ON UPDATE RESTRICT)
2org.jetbrains.exposed.exceptions.ExposedSQLException: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
3 at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:48)
4 at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:131)
5 at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:125)
6 at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:101)
7 at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:92)
8 at org.jetbrains.exposed.sql.SchemaUtils.create(SchemaUtils.kt:157)
9 at com.waicool20.mr2tachiyomi.converters.JsonConverter$convert$1.invoke(JsonConverter.kt:40)
10 at com.waicool20.mr2tachiyomi.converters.JsonConverter$convert$1.invoke(JsonConverter.kt:34)
11 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$1.invoke(ThreadLocalTransactionManager.kt:156)
12 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$2.invoke(ThreadLocalTransactionManager.kt:197)
13 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
14 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction(ThreadLocalTransactionManager.kt:196)
15 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$transaction$1.invoke(ThreadLocalTransactionManager.kt:134)
16 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
17 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:106)
18 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:104)
19 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction$default(ThreadLocalTransactionManager.kt:103)
20 at com.waicool20.mr2tachiyomi.converters.JsonConverter.convert(JsonConverter.kt:39)
21 at com.waicool20.mr2tachiyomi.MR2Tachiyomi.convert(MR2Tachiyomi.kt:92)
22 at com.waicool20.mr2tachiyomi.MR2TachiyomiKt.main(MR2Tachiyomi.kt:72)
23Caused by: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
24 at org.sqlite.core.DB.newSQLException(DB.java:941)
25 at org.sqlite.core.DB.newSQLException(DB.java:953)
26 at org.sqlite.core.DB.throwex(DB.java:918)
27 at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
28 at org.sqlite.core.NativeDB.prepare(NativeDB.java:134)
29 at org.sqlite.core.DB.prepare(DB.java:257)
30 at org.sqlite.core.CorePreparedStatement.<init>(CorePreparedStatement.java:47)
31 at org.sqlite.jdbc3.JDBC3PreparedStatement.<init>(JDBC3PreparedStatement.java:30)
32 at org.sqlite.jdbc4.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:19)
33 at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:35)
34 at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:241)
35 at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:205)
36 at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:214)
37 at org.jetbrains.exposed.sql.statements.Statement.prepared(Statement.kt:25)
38 at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:46)
39 ... 19 common frames omitted
40[MR2Tachiyomi] [2020-01-08 01:41:55] [Exposed] WARN - Transaction attempt #1 failed: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id). Statement(s): CREATE TABLE IF NOT EXISTS MangaChapter (_id INTEGER PRIMARY KEY, manga_id INT NOT NULL, num_pages INT NOT NULL, oid VARCHAR(1024) NOT NULL, chapter_order INT NOT NULL, title VARCHAR(1024) NOT NULL, _id INT NULL, CONSTRAINT fk_MangaChapter__id__id FOREIGN KEY (_id) REFERENCES MangaChapterLocal(_id) ON DELETE RESTRICT ON UPDATE RESTRICT)
41org.jetbrains.exposed.exceptions.ExposedSQLException: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
42 at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:48)
43 at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:131)
44 at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:125)
45 at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:101)
46 at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:92)
47 at org.jetbrains.exposed.sql.SchemaUtils.create(SchemaUtils.kt:157)
48 at com.waicool20.mr2tachiyomi.converters.JsonConverter$convert$1.invoke(JsonConverter.kt:40)
49 at com.waicool20.mr2tachiyomi.converters.JsonConverter$convert$1.invoke(JsonConverter.kt:34)
50 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$1.invoke(ThreadLocalTransactionManager.kt:156)
51 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$2.invoke(ThreadLocalTransactionManager.kt:197)
52 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
53 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction(ThreadLocalTransactionManager.kt:196)
54 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$transaction$1.invoke(ThreadLocalTransactionManager.kt:134)
55 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
56 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:106)
57 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:104)
58 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction$default(ThreadLocalTransactionManager.kt:103)
59 at com.waicool20.mr2tachiyomi.converters.JsonConverter.convert(JsonConverter.kt:39)
60 at com.waicool20.mr2tachiyomi.MR2Tachiyomi.convert(MR2Tachiyomi.kt:92)
61 at com.waicool20.mr2tachiyomi.MR2TachiyomiKt.main(MR2Tachiyomi.kt:72)
62Caused by: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
63 at org.sqlite.core.DB.newSQLException(DB.java:941)
64 at org.sqlite.core.DB.newSQLException(DB.java:953)
65 at org.sqlite.core.DB.throwex(DB.java:918)
66 at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
67 at org.sqlite.core.NativeDB.prepare(NativeDB.java:134)
68 at org.sqlite.core.DB.prepare(DB.java:257)
69 at org.sqlite.core.CorePreparedStatement.<init>(CorePreparedStatement.java:47)
70 at org.sqlite.jdbc3.JDBC3PreparedStatement.<init>(JDBC3PreparedStatement.java:30)
71 at org.sqlite.jdbc4.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:19)
72 at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:35)
73 at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:241)
74 at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:205)
75 at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:214)
76 at org.jetbrains.exposed.sql.statements.Statement.prepared(Statement.kt:25)
77 at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:46)
78 ... 19 common frames omitted
79[MR2Tachiyomi] [2020-01-08 01:41:55] [Exposed] WARN - Transaction attempt #2 failed: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id). Statement(s): CREATE TABLE IF NOT EXISTS MangaChapter (_id INTEGER PRIMARY KEY, manga_id INT NOT NULL, num_pages INT NOT NULL, oid VARCHAR(1024) NOT NULL, chapter_order INT NOT NULL, title VARCHAR(1024) NOT NULL, _id INT NULL, CONSTRAINT fk_MangaChapter__id__id FOREIGN KEY (_id) REFERENCES MangaChapterLocal(_id) ON DELETE RESTRICT ON UPDATE RESTRICT)
80org.jetbrains.exposed.exceptions.ExposedSQLException: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
81 at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:48)
82 at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:131)
83 at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:125)
84 at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:101)
85 at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:92)
86 at org.jetbrains.exposed.sql.SchemaUtils.create(SchemaUtils.kt:157)
87 at com.waicool20.mr2tachiyomi.converters.JsonConverter$convert$1.invoke(JsonConverter.kt:40)
88 at com.waicool20.mr2tachiyomi.converters.JsonConverter$convert$1.invoke(JsonConverter.kt:34)
89 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$1.invoke(ThreadLocalTransactionManager.kt:156)
90 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$2.invoke(ThreadLocalTransactionManager.kt:197)
91 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
92 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction(ThreadLocalTransactionManager.kt:196)
93 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$transaction$1.invoke(ThreadLocalTransactionManager.kt:134)
94 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
95 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:106)
96 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:104)
97 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction$default(ThreadLocalTransactionManager.kt:103)
98 at com.waicool20.mr2tachiyomi.converters.JsonConverter.convert(JsonConverter.kt:39)
99 at com.waicool20.mr2tachiyomi.MR2Tachiyomi.convert(MR2Tachiyomi.kt:92)
100 at com.waicool20.mr2tachiyomi.MR2TachiyomiKt.main(MR2Tachiyomi.kt:72)
101Caused by: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
102 at org.sqlite.core.DB.newSQLException(DB.java:941)
103 at org.sqlite.core.DB.newSQLException(DB.java:953)
104 at org.sqlite.core.DB.throwex(DB.java:918)
105 at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
106 at org.sqlite.core.NativeDB.prepare(NativeDB.java:134)
107 at org.sqlite.core.DB.prepare(DB.java:257)
108 at org.sqlite.core.CorePreparedStatement.<init>(CorePreparedStatement.java:47)
109 at org.sqlite.jdbc3.JDBC3PreparedStatement.<init>(JDBC3PreparedStatement.java:30)
110 at org.sqlite.jdbc4.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:19)
111 at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:35)
112 at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:241)
113 at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:205)
114 at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:214)
115 at org.jetbrains.exposed.sql.statements.Statement.prepared(Statement.kt:25)
116 at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:46)
117 ... 19 common frames omitted
118[MR2Tachiyomi] [2020-01-08 01:41:55] [c.w.m.MR2Tachiyomi] ERROR - Could not convert database file to json due to unknown exception
119org.jetbrains.exposed.exceptions.ExposedSQLException: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
120 at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:48)
121 at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:131)
122 at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:125)
123 at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:101)
124 at org.jetbrains.exposed.sql.Transaction.exec(Transaction.kt:92)
125 at org.jetbrains.exposed.sql.SchemaUtils.create(SchemaUtils.kt:157)
126 at com.waicool20.mr2tachiyomi.converters.JsonConverter$convert$1.invoke(JsonConverter.kt:40)
127 at com.waicool20.mr2tachiyomi.converters.JsonConverter$convert$1.invoke(JsonConverter.kt:34)
128 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$1.invoke(ThreadLocalTransactionManager.kt:156)
129 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$inTopLevelTransaction$2.invoke(ThreadLocalTransactionManager.kt:197)
130 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
131 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.inTopLevelTransaction(ThreadLocalTransactionManager.kt:196)
132 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt$transaction$1.invoke(ThreadLocalTransactionManager.kt:134)
133 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.keepAndRestoreTransactionRefAfterRun(ThreadLocalTransactionManager.kt:204)
134 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:106)
135 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction(ThreadLocalTransactionManager.kt:104)
136 at org.jetbrains.exposed.sql.transactions.ThreadLocalTransactionManagerKt.transaction$default(ThreadLocalTransactionManager.kt:103)
137 at com.waicool20.mr2tachiyomi.converters.JsonConverter.convert(JsonConverter.kt:39)
138 at com.waicool20.mr2tachiyomi.MR2Tachiyomi.convert(MR2Tachiyomi.kt:92)
139 at com.waicool20.mr2tachiyomi.MR2TachiyomiKt.main(MR2Tachiyomi.kt:72)
140Caused by: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (duplicate column name: _id)
141 at org.sqlite.core.DB.newSQLException(DB.java:941)
142 at org.sqlite.core.DB.newSQLException(DB.java:953)
143 at org.sqlite.core.DB.throwex(DB.java:918)
144 at org.sqlite.core.NativeDB.prepare_utf8(Native Method)
145 at org.sqlite.core.NativeDB.prepare(NativeDB.java:134)
146 at org.sqlite.core.DB.prepare(DB.java:257)
147 at org.sqlite.core.CorePreparedStatement.<init>(CorePreparedStatement.java:47)
148 at org.sqlite.jdbc3.JDBC3PreparedStatement.<init>(JDBC3PreparedStatement.java:30)
149 at org.sqlite.jdbc4.JDBC4PreparedStatement.<init>(JDBC4PreparedStatement.java:19)
150 at org.sqlite.jdbc4.JDBC4Connection.prepareStatement(JDBC4Connection.java:35)
151 at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:241)
152 at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:205)
153 at org.sqlite.jdbc3.JDBC3Connection.prepareStatement(JDBC3Connection.java:214)
154 at org.jetbrains.exposed.sql.statements.Statement.prepared(Statement.kt:25)
155 at org.jetbrains.exposed.sql.statements.Statement.executeIn$exposed(Statement.kt:46)
156 ... 19 common frames omitted