· 6 years ago · Dec 08, 2019, 08:46 PM
1[[36m12-08 19:42:07.08[0m] [[36m MainThread[0m] [[36m logging:70 [0m] [[1m INFO[0m] [1mSetting log level to 20 (INFO).[0m
2[[36m12-08 19:42:07.33[0m] [[36m Thread-2[0m] [[36mPooledQueryExecutor:29 [0m] [[1m INFO[0m] [1mConnecting to DB[0m
3[[36m12-08 19:42:07.41[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_monivlist` (
4 `monlist_id` int UNSIGNED NOT NULL AUTO_INCREMENT,
5 `guid` varchar(32) NULL,
6 `instance_id` int UNSIGNED NOT NULL,
7 `name` varchar(128) NOT NULL,
8 PRIMARY KEY (`monlist_id`),
9 -- UNIQUE KEY (`name`, `instance_id`),
10 CONSTRAINT `fk_mil_instance`
11 FOREIGN KEY (`instance_id`)
12 REFERENCES `madmin_instance` (`instance_id`)
13 ON DELETE CASCADE
14 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'madmin_instance'[0m
15[[36m12-08 19:42:07.41[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_monivlist` (
16 `monlist_id` int UNSIGNED NOT NULL AUTO_INCREMENT,
17 `guid` varchar(32) NULL,
18 `instance_id` int UNSIGNED NOT NULL,
19 `name` varchar(128) NOT NULL,
20 PRIMARY KEY (`monlist_id`),
21 -- UNIQUE KEY (`name`, `instance_id`),
22 CONSTRAINT `fk_mil_instance`
23 FOREIGN KEY (`instance_id`)
24 REFERENCES `madmin_instance` (`instance_id`)
25 ON DELETE CASCADE
26 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'madmin_instance'[0m
27[[36m12-08 19:42:07.41[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_monivlist_to_mon` (
28 `monlist_id` int UNSIGNED NOT NULL,
29 `mon_id` int(11) NOT NULL,
30 `mon_order` int(11) NOT NULL,
31 PRIMARY KEY (`monlist_id`,`mon_id`),
32 INDEX (`monlist_id`),
33 INDEX (`mon_id`),
34 CONSTRAINT `settings_monivlist_to_mon_ibfk_1`
35 FOREIGN KEY (`monlist_id`)
36 REFERENCES `settings_monivlist` (`monlist_id`)
37 ON DELETE CASCADE
38 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'settings_monivlist'[0m
39[[36m12-08 19:42:07.41[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_monivlist_to_mon` (
40 `monlist_id` int UNSIGNED NOT NULL,
41 `mon_id` int(11) NOT NULL,
42 `mon_order` int(11) NOT NULL,
43 PRIMARY KEY (`monlist_id`,`mon_id`),
44 INDEX (`monlist_id`),
45 INDEX (`mon_id`),
46 CONSTRAINT `settings_monivlist_to_mon_ibfk_1`
47 FOREIGN KEY (`monlist_id`)
48 REFERENCES `settings_monivlist` (`monlist_id`)
49 ON DELETE CASCADE
50 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'settings_monivlist'[0m
51[[36m12-08 19:42:07.42[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_auth` (
52 `auth_id` int UNSIGNED NOT NULL AUTO_INCREMENT,
53 `guid` varchar(32) NULL,
54 `instance_id` int UNSIGNED NOT NULL,
55 `username` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
56 `password` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
57 PRIMARY KEY (`auth_id`),
58 -- UNIQUE (`instance_id`, `username`, `password`),
59 CONSTRAINT `fk_sauth_instance`
60 FOREIGN KEY (`instance_id`)
61 REFERENCES `madmin_instance` (`instance_id`)
62 ON DELETE CASCADE
63 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'madmin_instance'[0m
64[[36m12-08 19:42:07.42[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_auth` (
65 `auth_id` int UNSIGNED NOT NULL AUTO_INCREMENT,
66 `guid` varchar(32) NULL,
67 `instance_id` int UNSIGNED NOT NULL,
68 `username` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
69 `password` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
70 PRIMARY KEY (`auth_id`),
71 -- UNIQUE (`instance_id`, `username`, `password`),
72 CONSTRAINT `fk_sauth_instance`
73 FOREIGN KEY (`instance_id`)
74 REFERENCES `madmin_instance` (`instance_id`)
75 ON DELETE CASCADE
76 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'madmin_instance'[0m
77[[36m12-08 19:42:07.42[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_devicepool` (
78 `pool_id` int UNSIGNED NOT NULL AUTO_INCREMENT,
79 `guid` varchar(32) NULL,
80 `instance_id` int UNSIGNED NOT NULL,
81 `name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
82 `post_walk_delay` float DEFAULT NULL,
83 `post_teleport_delay` float DEFAULT NULL,
84 `walk_after_teleport_distance` float DEFAULT NULL,
85 `cool_down_sleep` tinyint(1) DEFAULT NULL,
86 `post_turn_screen_on_delay` float DEFAULT NULL,
87 `post_pogo_start_delay` float DEFAULT NULL,
88 `restart_pogo` int(11) DEFAULT NULL,
89 `delay_after_hatch` float DEFAULT NULL,
90 `inventory_clear_rounds` int(11) DEFAULT NULL,
91 `inventory_clear_item_amount_tap_duration` int(11) DEFAULT NULL,
92 `mitm_wait_timeout` float DEFAULT NULL,
93 `vps_delay` float DEFAULT NULL,
94 `reboot` tinyint(1) DEFAULT NULL,
95 `reboot_thresh` int(11) DEFAULT NULL,
96 `restart_thresh` int(11) DEFAULT NULL,
97 `post_screenshot_delay` float DEFAULT NULL,
98 `screenshot_x_offset` int(11) DEFAULT NULL,
99 `screenshot_y_offset` int(11) DEFAULT NULL,
100 `screenshot_type` enum('jpeg','png') COLLATE utf8mb4_unicode_ci NULL,
101 `screenshot_quality` int(11) DEFAULT NULL,
102 `startcoords_of_walker` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
103 `injection_thresh_reboot` int(11) DEFAULT NULL,
104 PRIMARY KEY (`pool_id`),
105 -- UNIQUE KEY (`instance_id`, `name`),
106 CONSTRAINT `fk_sds_instance`
107 FOREIGN KEY (`instance_id`)
108 REFERENCES `madmin_instance` (`instance_id`)
109 ON DELETE CASCADE
110 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'madmin_instance'[0m
111[[36m12-08 19:42:07.42[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_devicepool` (
112 `pool_id` int UNSIGNED NOT NULL AUTO_INCREMENT,
113 `guid` varchar(32) NULL,
114 `instance_id` int UNSIGNED NOT NULL,
115 `name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
116 `post_walk_delay` float DEFAULT NULL,
117 `post_teleport_delay` float DEFAULT NULL,
118 `walk_after_teleport_distance` float DEFAULT NULL,
119 `cool_down_sleep` tinyint(1) DEFAULT NULL,
120 `post_turn_screen_on_delay` float DEFAULT NULL,
121 `post_pogo_start_delay` float DEFAULT NULL,
122 `restart_pogo` int(11) DEFAULT NULL,
123 `delay_after_hatch` float DEFAULT NULL,
124 `inventory_clear_rounds` int(11) DEFAULT NULL,
125 `inventory_clear_item_amount_tap_duration` int(11) DEFAULT NULL,
126 `mitm_wait_timeout` float DEFAULT NULL,
127 `vps_delay` float DEFAULT NULL,
128 `reboot` tinyint(1) DEFAULT NULL,
129 `reboot_thresh` int(11) DEFAULT NULL,
130 `restart_thresh` int(11) DEFAULT NULL,
131 `post_screenshot_delay` float DEFAULT NULL,
132 `screenshot_x_offset` int(11) DEFAULT NULL,
133 `screenshot_y_offset` int(11) DEFAULT NULL,
134 `screenshot_type` enum('jpeg','png') COLLATE utf8mb4_unicode_ci NULL,
135 `screenshot_quality` int(11) DEFAULT NULL,
136 `startcoords_of_walker` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
137 `injection_thresh_reboot` int(11) DEFAULT NULL,
138 PRIMARY KEY (`pool_id`),
139 -- UNIQUE KEY (`instance_id`, `name`),
140 CONSTRAINT `fk_sds_instance`
141 FOREIGN KEY (`instance_id`)
142 REFERENCES `madmin_instance` (`instance_id`)
143 ON DELETE CASCADE
144 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'madmin_instance'[0m
145[[36m12-08 19:42:07.43[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_area` (
146 `area_id` int UNSIGNED NOT NULL AUTO_INCREMENT,
147 `guid` varchar(32) NULL,
148 `instance_id` int UNSIGNED NOT NULL,
149 `name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
150 `mode` enum('idle','iv_mitm','mon_mitm','pokestops','raids_mitm') COLLATE utf8mb4_unicode_ci NOT NULL,
151 PRIMARY KEY (`area_id`),
152 -- UNIQUE KEY (`instance_id`, `name`),
153 CONSTRAINT `fk_sa_instance`
154 FOREIGN KEY (`instance_id`)
155 REFERENCES `madmin_instance` (`instance_id`)
156 ON DELETE CASCADE
157 ) ENGINE=InnoDB;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'madmin_instance'[0m
158[[36m12-08 19:42:07.43[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_area` (
159 `area_id` int UNSIGNED NOT NULL AUTO_INCREMENT,
160 `guid` varchar(32) NULL,
161 `instance_id` int UNSIGNED NOT NULL,
162 `name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
163 `mode` enum('idle','iv_mitm','mon_mitm','pokestops','raids_mitm') COLLATE utf8mb4_unicode_ci NOT NULL,
164 PRIMARY KEY (`area_id`),
165 -- UNIQUE KEY (`instance_id`, `name`),
166 CONSTRAINT `fk_sa_instance`
167 FOREIGN KEY (`instance_id`)
168 REFERENCES `madmin_instance` (`instance_id`)
169 ON DELETE CASCADE
170 ) ENGINE=InnoDB;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'madmin_instance'[0m
171[[36m12-08 19:42:07.43[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_area_idle` (
172 `area_id` int UNSIGNED NOT NULL,
173 `geofence_included` int UNSIGNED NOT NULL,
174 `routecalc` int UNSIGNED NOT NULL,
175 PRIMARY KEY (`area_id`),
176 CONSTRAINT `fk_area_idle`
177 FOREIGN KEY (`area_id`)
178 REFERENCES `settings_area` (`area_id`)
179 ON DELETE CASCADE,
180 CONSTRAINT `fk_area_idle_geofence`
181 FOREIGN KEY (`geofence_included`)
182 REFERENCES `settings_geofence` (`geofence_id`),
183 CONSTRAINT `fk_area_idle_routecalc`
184 FOREIGN KEY (`routecalc`)
185 REFERENCES `settings_routecalc` (`routecalc_id`)
186 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'settings_area'[0m
187[[36m12-08 19:42:07.43[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_area_idle` (
188 `area_id` int UNSIGNED NOT NULL,
189 `geofence_included` int UNSIGNED NOT NULL,
190 `routecalc` int UNSIGNED NOT NULL,
191 PRIMARY KEY (`area_id`),
192 CONSTRAINT `fk_area_idle`
193 FOREIGN KEY (`area_id`)
194 REFERENCES `settings_area` (`area_id`)
195 ON DELETE CASCADE,
196 CONSTRAINT `fk_area_idle_geofence`
197 FOREIGN KEY (`geofence_included`)
198 REFERENCES `settings_geofence` (`geofence_id`),
199 CONSTRAINT `fk_area_idle_routecalc`
200 FOREIGN KEY (`routecalc`)
201 REFERENCES `settings_routecalc` (`routecalc_id`)
202 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'settings_area'[0m
203[[36m12-08 19:42:07.43[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_area_iv_mitm` (
204 `area_id` int UNSIGNED NOT NULL,
205 `geofence_included` int UNSIGNED NOT NULL,
206 `geofence_excluded` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
207 `routecalc` int UNSIGNED NOT NULL,
208 `speed` float DEFAULT NULL,
209 `max_distance` float DEFAULT NULL,
210 `delay_after_prio_event` int(11) DEFAULT NULL,
211 `priority_queue_clustering_timedelta` float DEFAULT NULL,
212 `remove_from_queue_backlog` boolean DEFAULT NULL,
213 `starve_route` boolean DEFAULT NULL,
214 `monlist_id` int UNSIGNED DEFAULT NULL,
215 `min_time_left_seconds` int(11) DEFAULT NULL,
216 PRIMARY KEY (`area_id`),
217 CONSTRAINT `fk_area_iv_mitm`
218 FOREIGN KEY (`area_id`)
219 REFERENCES `settings_area` (`area_id`)
220 ON DELETE CASCADE,
221 CONSTRAINT `fk_ai_monid`
222 FOREIGN KEY (`monlist_id`)
223 REFERENCES `settings_monivlist` (`monlist_id`),
224 CONSTRAINT `fk_area_iv_mitm_geofence`
225 FOREIGN KEY (`geofence_included`)
226 REFERENCES `settings_geofence` (`geofence_id`),
227 CONSTRAINT `fk_area_iv_mitm_routecalc`
228 FOREIGN KEY (`routecalc`)
229 REFERENCES `settings_routecalc` (`routecalc_id`)
230 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'settings_area'[0m
231[[36m12-08 19:42:07.43[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_area_iv_mitm` (
232 `area_id` int UNSIGNED NOT NULL,
233 `geofence_included` int UNSIGNED NOT NULL,
234 `geofence_excluded` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
235 `routecalc` int UNSIGNED NOT NULL,
236 `speed` float DEFAULT NULL,
237 `max_distance` float DEFAULT NULL,
238 `delay_after_prio_event` int(11) DEFAULT NULL,
239 `priority_queue_clustering_timedelta` float DEFAULT NULL,
240 `remove_from_queue_backlog` boolean DEFAULT NULL,
241 `starve_route` boolean DEFAULT NULL,
242 `monlist_id` int UNSIGNED DEFAULT NULL,
243 `min_time_left_seconds` int(11) DEFAULT NULL,
244 PRIMARY KEY (`area_id`),
245 CONSTRAINT `fk_area_iv_mitm`
246 FOREIGN KEY (`area_id`)
247 REFERENCES `settings_area` (`area_id`)
248 ON DELETE CASCADE,
249 CONSTRAINT `fk_ai_monid`
250 FOREIGN KEY (`monlist_id`)
251 REFERENCES `settings_monivlist` (`monlist_id`),
252 CONSTRAINT `fk_area_iv_mitm_geofence`
253 FOREIGN KEY (`geofence_included`)
254 REFERENCES `settings_geofence` (`geofence_id`),
255 CONSTRAINT `fk_area_iv_mitm_routecalc`
256 FOREIGN KEY (`routecalc`)
257 REFERENCES `settings_routecalc` (`routecalc_id`)
258 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'settings_area'[0m
259[[36m12-08 19:42:07.44[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_area_mon_mitm` (
260 `area_id` int UNSIGNED NOT NULL,
261 `init` boolean NOT NULL,
262 `geofence_included` int UNSIGNED NOT NULL,
263 `geofence_excluded` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
264 `routecalc` int UNSIGNED NOT NULL,
265 `coords_spawns_known` boolean NULL,
266 `speed` float DEFAULT NULL,
267 `max_distance` float DEFAULT NULL,
268 `delay_after_prio_event` int DEFAULT NULL,
269 `priority_queue_clustering_timedelta` float DEFAULT NULL,
270 `remove_from_queue_backlog` float DEFAULT NULL,
271 `starve_route` boolean DEFAULT NULL,
272 `init_mode_rounds` int DEFAULT NULL,
273 `monlist_id` int UNSIGNED DEFAULT NULL,
274 `min_time_left_seconds` int DEFAULT NULL,
275 PRIMARY KEY (`area_id`),
276 CONSTRAINT `fk_area_mon_mitm`
277 FOREIGN KEY (`area_id`)
278 REFERENCES `settings_area` (`area_id`)
279 ON DELETE CASCADE,
280 CONSTRAINT `fk_am_monid`
281 FOREIGN KEY (`monlist_id`)
282 REFERENCES `settings_monivlist` (`monlist_id`),
283 CONSTRAINT `fk_area_mon_mitm_geofence`
284 FOREIGN KEY (`geofence_included`)
285 REFERENCES `settings_geofence` (`geofence_id`),
286 CONSTRAINT `fk_area_mon_mitm_routecalc`
287 FOREIGN KEY (`routecalc`)
288 REFERENCES `settings_routecalc` (`routecalc_id`)
289 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'settings_area'[0m
290[[36m12-08 19:42:07.44[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_area_mon_mitm` (
291 `area_id` int UNSIGNED NOT NULL,
292 `init` boolean NOT NULL,
293 `geofence_included` int UNSIGNED NOT NULL,
294 `geofence_excluded` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
295 `routecalc` int UNSIGNED NOT NULL,
296 `coords_spawns_known` boolean NULL,
297 `speed` float DEFAULT NULL,
298 `max_distance` float DEFAULT NULL,
299 `delay_after_prio_event` int DEFAULT NULL,
300 `priority_queue_clustering_timedelta` float DEFAULT NULL,
301 `remove_from_queue_backlog` float DEFAULT NULL,
302 `starve_route` boolean DEFAULT NULL,
303 `init_mode_rounds` int DEFAULT NULL,
304 `monlist_id` int UNSIGNED DEFAULT NULL,
305 `min_time_left_seconds` int DEFAULT NULL,
306 PRIMARY KEY (`area_id`),
307 CONSTRAINT `fk_area_mon_mitm`
308 FOREIGN KEY (`area_id`)
309 REFERENCES `settings_area` (`area_id`)
310 ON DELETE CASCADE,
311 CONSTRAINT `fk_am_monid`
312 FOREIGN KEY (`monlist_id`)
313 REFERENCES `settings_monivlist` (`monlist_id`),
314 CONSTRAINT `fk_area_mon_mitm_geofence`
315 FOREIGN KEY (`geofence_included`)
316 REFERENCES `settings_geofence` (`geofence_id`),
317 CONSTRAINT `fk_area_mon_mitm_routecalc`
318 FOREIGN KEY (`routecalc`)
319 REFERENCES `settings_routecalc` (`routecalc_id`)
320 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'settings_area'[0m
321[[36m12-08 19:42:07.44[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_area_pokestops` (
322 `area_id` int UNSIGNED NOT NULL,
323 `geofence_included` int UNSIGNED NOT NULL,
324 `geofence_excluded` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
325 `routecalc` int UNSIGNED NOT NULL,
326 `init` boolean NOT NULL,
327 `level` boolean NULL,
328 `route_calc_algorithm` enum('optimized','quick') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
329 `speed` float DEFAULT NULL,
330 `max_distance` float DEFAULT NULL,
331 `ignore_spinned_stops` boolean DEFAULT NULL,
332 `cleanup_every_spin` boolean DEFAULT NULL,
333 PRIMARY KEY (`area_id`),
334 CONSTRAINT `fk_area_pokestops`
335 FOREIGN KEY (`area_id`)
336 REFERENCES `settings_area` (`area_id`)
337 ON DELETE CASCADE,
338 CONSTRAINT `fk_area_pokestops_geofence`
339 FOREIGN KEY (`geofence_included`)
340 REFERENCES `settings_geofence` (`geofence_id`),
341 CONSTRAINT `fk_area_pokestops_routecalc`
342 FOREIGN KEY (`routecalc`)
343 REFERENCES `settings_routecalc` (`routecalc_id`)
344 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'settings_area'[0m
345[[36m12-08 19:42:07.44[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_area_pokestops` (
346 `area_id` int UNSIGNED NOT NULL,
347 `geofence_included` int UNSIGNED NOT NULL,
348 `geofence_excluded` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
349 `routecalc` int UNSIGNED NOT NULL,
350 `init` boolean NOT NULL,
351 `level` boolean NULL,
352 `route_calc_algorithm` enum('optimized','quick') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
353 `speed` float DEFAULT NULL,
354 `max_distance` float DEFAULT NULL,
355 `ignore_spinned_stops` boolean DEFAULT NULL,
356 `cleanup_every_spin` boolean DEFAULT NULL,
357 PRIMARY KEY (`area_id`),
358 CONSTRAINT `fk_area_pokestops`
359 FOREIGN KEY (`area_id`)
360 REFERENCES `settings_area` (`area_id`)
361 ON DELETE CASCADE,
362 CONSTRAINT `fk_area_pokestops_geofence`
363 FOREIGN KEY (`geofence_included`)
364 REFERENCES `settings_geofence` (`geofence_id`),
365 CONSTRAINT `fk_area_pokestops_routecalc`
366 FOREIGN KEY (`routecalc`)
367 REFERENCES `settings_routecalc` (`routecalc_id`)
368 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'settings_area'[0m
369[[36m12-08 19:42:07.44[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_area_raids_mitm` (
370 `area_id` int UNSIGNED NOT NULL,
371 `init` boolean NOT NULL,
372 `geofence_included` int UNSIGNED NOT NULL,
373 `geofence_excluded` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
374 `routecalc` int UNSIGNED NOT NULL,
375 `including_stops` boolean NULL,
376 `speed` float DEFAULT NULL,
377 `max_distance` float DEFAULT NULL,
378 `delay_after_prio_event` int DEFAULT NULL,
379 `priority_queue_clustering_timedelta` float DEFAULT NULL,
380 `remove_from_queue_backlog` float DEFAULT NULL,
381 `starve_route` boolean DEFAULT NULL,
382 `init_mode_rounds` int DEFAULT NULL,
383 `monlist_id` int UNSIGNED DEFAULT NULL,
384 PRIMARY KEY (`area_id`),
385 CONSTRAINT `fk_area_raids_mitm`
386 FOREIGN KEY (`area_id`)
387 REFERENCES `settings_area` (`area_id`)
388 ON DELETE CASCADE,
389 CONSTRAINT `fk_ar_monid`
390 FOREIGN KEY (`monlist_id`)
391 REFERENCES `settings_monivlist` (`monlist_id`),
392 CONSTRAINT `fk_area_raids_mitm_geofence`
393 FOREIGN KEY (`geofence_included`)
394 REFERENCES `settings_geofence` (`geofence_id`),
395 CONSTRAINT `fk_area_raids_mitm_routecalc`
396 FOREIGN KEY (`routecalc`)
397 REFERENCES `settings_routecalc` (`routecalc_id`)
398 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'settings_area'[0m
399[[36m12-08 19:42:07.44[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_area_raids_mitm` (
400 `area_id` int UNSIGNED NOT NULL,
401 `init` boolean NOT NULL,
402 `geofence_included` int UNSIGNED NOT NULL,
403 `geofence_excluded` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
404 `routecalc` int UNSIGNED NOT NULL,
405 `including_stops` boolean NULL,
406 `speed` float DEFAULT NULL,
407 `max_distance` float DEFAULT NULL,
408 `delay_after_prio_event` int DEFAULT NULL,
409 `priority_queue_clustering_timedelta` float DEFAULT NULL,
410 `remove_from_queue_backlog` float DEFAULT NULL,
411 `starve_route` boolean DEFAULT NULL,
412 `init_mode_rounds` int DEFAULT NULL,
413 `monlist_id` int UNSIGNED DEFAULT NULL,
414 PRIMARY KEY (`area_id`),
415 CONSTRAINT `fk_area_raids_mitm`
416 FOREIGN KEY (`area_id`)
417 REFERENCES `settings_area` (`area_id`)
418 ON DELETE CASCADE,
419 CONSTRAINT `fk_ar_monid`
420 FOREIGN KEY (`monlist_id`)
421 REFERENCES `settings_monivlist` (`monlist_id`),
422 CONSTRAINT `fk_area_raids_mitm_geofence`
423 FOREIGN KEY (`geofence_included`)
424 REFERENCES `settings_geofence` (`geofence_id`),
425 CONSTRAINT `fk_area_raids_mitm_routecalc`
426 FOREIGN KEY (`routecalc`)
427 REFERENCES `settings_routecalc` (`routecalc_id`)
428 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'settings_area'[0m
429[[36m12-08 19:42:07.44[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_walker` (
430 `walker_id` int UNSIGNED NOT NULL AUTO_INCREMENT,
431 `guid` varchar(32) NULL,
432 `instance_id` int UNSIGNED NOT NULL,
433 `name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
434 PRIMARY KEY (`walker_id`),
435 -- UNIQUE KEY `origin` (`name`, `instance_id`),
436 CONSTRAINT `fk_w_instance`
437 FOREIGN KEY (`instance_id`)
438 REFERENCES `madmin_instance` (`instance_id`)
439 ON DELETE CASCADE
440 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'madmin_instance'[0m
441[[36m12-08 19:42:07.44[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_walker` (
442 `walker_id` int UNSIGNED NOT NULL AUTO_INCREMENT,
443 `guid` varchar(32) NULL,
444 `instance_id` int UNSIGNED NOT NULL,
445 `name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
446 PRIMARY KEY (`walker_id`),
447 -- UNIQUE KEY `origin` (`name`, `instance_id`),
448 CONSTRAINT `fk_w_instance`
449 FOREIGN KEY (`instance_id`)
450 REFERENCES `madmin_instance` (`instance_id`)
451 ON DELETE CASCADE
452 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'madmin_instance'[0m
453[[36m12-08 19:42:07.45[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_walkerarea` (
454 `walkerarea_id` int UNSIGNED NOT NULL AUTO_INCREMENT,
455 `guid` varchar(32) NULL,
456 `instance_id` int UNSIGNED NOT NULL,
457 `name` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
458 `area_id` int UNSIGNED NOT NULL,
459 `algo_type` enum('countdown','timer','round','period','coords', 'idle') COLLATE utf8mb4_unicode_ci NOT NULL,
460 `algo_value` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
461 `max_walkers` int DEFAULT NULL,
462 PRIMARY KEY (`walkerarea_id`),
463 CONSTRAINT `fk_wa_instance`
464 FOREIGN KEY (`instance_id`)
465 REFERENCES `madmin_instance` (`instance_id`)
466 ON DELETE CASCADE,
467 CONSTRAINT `settings_walkerarea_ibfk_1`
468 FOREIGN KEY (`area_id`)
469 REFERENCES `settings_area` (`area_id`)
470 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'madmin_instance'[0m
471[[36m12-08 19:42:07.45[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_walkerarea` (
472 `walkerarea_id` int UNSIGNED NOT NULL AUTO_INCREMENT,
473 `guid` varchar(32) NULL,
474 `instance_id` int UNSIGNED NOT NULL,
475 `name` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
476 `area_id` int UNSIGNED NOT NULL,
477 `algo_type` enum('countdown','timer','round','period','coords', 'idle') COLLATE utf8mb4_unicode_ci NOT NULL,
478 `algo_value` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
479 `max_walkers` int DEFAULT NULL,
480 PRIMARY KEY (`walkerarea_id`),
481 CONSTRAINT `fk_wa_instance`
482 FOREIGN KEY (`instance_id`)
483 REFERENCES `madmin_instance` (`instance_id`)
484 ON DELETE CASCADE,
485 CONSTRAINT `settings_walkerarea_ibfk_1`
486 FOREIGN KEY (`area_id`)
487 REFERENCES `settings_area` (`area_id`)
488 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'madmin_instance'[0m
489[[36m12-08 19:42:07.45[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_walker_to_walkerarea` (
490 `walker_id` int UNSIGNED NOT NULL,
491 `walkerarea_id` int UNSIGNED NOT NULL,
492 `area_order` int NOT NULL,
493 PRIMARY KEY (`walker_id`,`walkerarea_id`, `area_order`),
494 INDEX (`walker_id`),
495 INDEX (`walkerarea_id`),
496 CONSTRAINT `settings_walker_to_walkerarea_ibfk_1`
497 FOREIGN KEY (`walker_id`)
498 REFERENCES `settings_walker` (`walker_id`)
499 ON DELETE CASCADE,
500 CONSTRAINT `settings_walker_to_walkerarea_ibfk_2`
501 FOREIGN KEY (`walkerarea_id`)
502 REFERENCES `settings_walkerarea` (`walkerarea_id`)
503 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'settings_walker'[0m
504[[36m12-08 19:42:07.45[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_walker_to_walkerarea` (
505 `walker_id` int UNSIGNED NOT NULL,
506 `walkerarea_id` int UNSIGNED NOT NULL,
507 `area_order` int NOT NULL,
508 PRIMARY KEY (`walker_id`,`walkerarea_id`, `area_order`),
509 INDEX (`walker_id`),
510 INDEX (`walkerarea_id`),
511 CONSTRAINT `settings_walker_to_walkerarea_ibfk_1`
512 FOREIGN KEY (`walker_id`)
513 REFERENCES `settings_walker` (`walker_id`)
514 ON DELETE CASCADE,
515 CONSTRAINT `settings_walker_to_walkerarea_ibfk_2`
516 FOREIGN KEY (`walkerarea_id`)
517 REFERENCES `settings_walkerarea` (`walkerarea_id`)
518 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'settings_walker'[0m
519[[36m12-08 19:42:07.45[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_device` (
520 `device_id` int UNSIGNED NOT NULL AUTO_INCREMENT,
521 `guid` varchar(32) NULL,
522 `instance_id` int UNSIGNED NOT NULL,
523 `name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
524 `walker_id` int UNSIGNED NOT NULL,
525 `pool_id` int UNSIGNED DEFAULT NULL,
526 `adbname` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
527 `post_walk_delay` float DEFAULT NULL,
528 `post_teleport_delay` float DEFAULT NULL,
529 `walk_after_teleport_distance` float DEFAULT NULL,
530 `cool_down_sleep` tinyint(1) DEFAULT NULL,
531 `post_turn_screen_on_delay` float DEFAULT NULL,
532 `post_pogo_start_delay` float DEFAULT NULL,
533 `restart_pogo` int DEFAULT NULL,
534 `delay_after_hatch` float DEFAULT NULL,
535 `inventory_clear_rounds` int DEFAULT NULL,
536 `inventory_clear_item_amount_tap_duration` int DEFAULT NULL,
537 `mitm_wait_timeout` float DEFAULT NULL,
538 `vps_delay` float DEFAULT NULL,
539 `reboot` tinyint(1) DEFAULT NULL,
540 `reboot_thresh` int DEFAULT NULL,
541 `restart_thresh` int DEFAULT NULL,
542 `post_screenshot_delay` float DEFAULT NULL,
543 `screenshot_x_offset` int DEFAULT NULL,
544 `screenshot_y_offset` int DEFAULT NULL,
545 `screenshot_type` enum('jpeg','png') COLLATE utf8mb4_unicode_ci NULL,
546 `screenshot_quality` int DEFAULT NULL,
547 `startcoords_of_walker` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
548 `screendetection` tinyint(1) DEFAULT NULL,
549 `logintype` enum('google','ptc') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
550 `ggl_login_mail` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
551 `ptc_login` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
552 `clear_game_data` tinyint(1) DEFAULT NULL,
553 `account_rotation` tinyint(1) DEFAULT NULL,
554 `rotation_waittime` float DEFAULT NULL,
555 `rotate_on_lvl_30` tinyint(1) DEFAULT NULL,
556 `injection_thresh_reboot` int DEFAULT NULL,
557 PRIMARY KEY (`device_id`),
558 -- UNIQUE KEY (`name`, `instance_id`),
559 -- UNIQUE KEY (`adbname`, `instance_id`),
560 CONSTRAINT `settings_device_ibfk_1`
561 FOREIGN KEY (`walker_id`)
562 REFERENCES `settings_walker` (`walker_id`),
563 CONSTRAINT `settings_device_ibfk_2`
564 FOREIGN KEY (`pool_id`)
565 REFERENCES `settings_devicepool` (`pool_id`),
566 CONSTRAINT `fk_sd_instance`
567 FOREIGN KEY (`instance_id`)
568 REFERENCES `madmin_instance` (`instance_id`)
569 ON DELETE CASCADE
570 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'settings_walker'[0m
571[[36m12-08 19:42:07.45[0m] [[36m MainProcess[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: CREATE TABLE IF NOT EXISTS `settings_device` (
572 `device_id` int UNSIGNED NOT NULL AUTO_INCREMENT,
573 `guid` varchar(32) NULL,
574 `instance_id` int UNSIGNED NOT NULL,
575 `name` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
576 `walker_id` int UNSIGNED NOT NULL,
577 `pool_id` int UNSIGNED DEFAULT NULL,
578 `adbname` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
579 `post_walk_delay` float DEFAULT NULL,
580 `post_teleport_delay` float DEFAULT NULL,
581 `walk_after_teleport_distance` float DEFAULT NULL,
582 `cool_down_sleep` tinyint(1) DEFAULT NULL,
583 `post_turn_screen_on_delay` float DEFAULT NULL,
584 `post_pogo_start_delay` float DEFAULT NULL,
585 `restart_pogo` int DEFAULT NULL,
586 `delay_after_hatch` float DEFAULT NULL,
587 `inventory_clear_rounds` int DEFAULT NULL,
588 `inventory_clear_item_amount_tap_duration` int DEFAULT NULL,
589 `mitm_wait_timeout` float DEFAULT NULL,
590 `vps_delay` float DEFAULT NULL,
591 `reboot` tinyint(1) DEFAULT NULL,
592 `reboot_thresh` int DEFAULT NULL,
593 `restart_thresh` int DEFAULT NULL,
594 `post_screenshot_delay` float DEFAULT NULL,
595 `screenshot_x_offset` int DEFAULT NULL,
596 `screenshot_y_offset` int DEFAULT NULL,
597 `screenshot_type` enum('jpeg','png') COLLATE utf8mb4_unicode_ci NULL,
598 `screenshot_quality` int DEFAULT NULL,
599 `startcoords_of_walker` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
600 `screendetection` tinyint(1) DEFAULT NULL,
601 `logintype` enum('google','ptc') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
602 `ggl_login_mail` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
603 `ptc_login` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
604 `clear_game_data` tinyint(1) DEFAULT NULL,
605 `account_rotation` tinyint(1) DEFAULT NULL,
606 `rotation_waittime` float DEFAULT NULL,
607 `rotate_on_lvl_30` tinyint(1) DEFAULT NULL,
608 `injection_thresh_reboot` int DEFAULT NULL,
609 PRIMARY KEY (`device_id`),
610 -- UNIQUE KEY (`name`, `instance_id`),
611 -- UNIQUE KEY (`adbname`, `instance_id`),
612 CONSTRAINT `settings_device_ibfk_1`
613 FOREIGN KEY (`walker_id`)
614 REFERENCES `settings_walker` (`walker_id`),
615 CONSTRAINT `settings_device_ibfk_2`
616 FOREIGN KEY (`pool_id`)
617 REFERENCES `settings_devicepool` (`pool_id`),
618 CONSTRAINT `fk_sd_instance`
619 FOREIGN KEY (`instance_id`)
620 REFERENCES `madmin_instance` (`instance_id`)
621 ON DELETE CASCADE
622 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;, error: 1142 (42000): REFERENCES command denied to user 'MAD-WOB'@'localhost' for table 'settings_walker'[0m
623[[36m12-08 19:42:07.48[0m] [[36m route_joiner[0m] [[36m MappingManager:57 [0m] [[1m INFO[0m] [1mStarting Route join Thread - safemode[0m
624[[36m12-08 19:42:07.48[0m] [[36m Thread-2[0m] [[36m MappingManager:568 [0m] [[1m INFO[0m] [1mAcquiring lock to update mappings,full[0m
625[[36m12-08 19:42:07.49[0m] [[36mMappingManagerManager-2|Thread-2[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: SELECT `monlist_id` FROM `settings_monivlist` WHERE `instance_id` = %s ORDER BY `name`, error: 1146 (42S02): Table 'rocketmap.settings_monivlist' doesn't exist[0m
626[[36m12-08 19:42:07.49[0m] [[36mMappingManagerManager-2|Thread-2[0m] [[36mPooledQueryExecutor:101 [0m] [[31m[1m ERROR[0m] [31m[1mFailed executing query: SELECT `monlist_id` FROM `settings_monivlist` WHERE `instance_id` = %s ORDER BY `name`, error: 1146 (42S02): Table 'rocketmap.settings_monivlist' doesn't exist[0m
627Traceback (most recent call last):
628 File "start.py", line 194, in <module>
629 mapping_manager: MappingManager = mapping_manager_manager.MappingManager(db_wrapper, args, data_manager, False)
630 File "/usr/lib/python3.6/multiprocessing/managers.py", line 662, in temp
631 token, exp = self._create(typeid, *args, **kwds)
632 File "/usr/lib/python3.6/multiprocessing/managers.py", line 556, in _create
633 id, exposed = dispatch(conn, None, 'create', (typeid,)+args, kwds)
634 File "/usr/lib/python3.6/multiprocessing/managers.py", line 82, in dispatch
635 raise convert_to_error(kind, result)
636multiprocessing.managers.RemoteError:
637---------------------------------------------------------------------------
638Traceback (most recent call last):
639 File "/usr/lib/python3.6/multiprocessing/managers.py", line 195, in handle_request
640 result = func(c, *args, **kwds)
641 File "/usr/lib/python3.6/multiprocessing/managers.py", line 359, in create
642 obj = callable(*args, **kwds)
643 File "/home/MAD/utils/MappingManager.py", line 97, in __init__
644 self.update(full_lock=True)
645 File "/home/MAD/utils/MappingManager.py", line 570, in update
646 self._monlists = self.__get_latest_monlists()
647 File "/home/MAD/utils/MappingManager.py", line 519, in __get_latest_monlists
648 monivs = self.__data_manager.get_root_resource('monivlist')
649 File "/home/MAD/utils/data_manager/__init__.py", line 58, in get_root_resource
650 identifiers = self.dbc.autofetch_column(sql % tuple(args), args=(self.instance_id,))
651 File "/home/MAD/db/DbWrapper.py", line 64, in autofetch_column
652 return self._db_exec.autofetch_column(sql, args=args)
653 File "<string>", line 2, in autofetch_column
654 File "/usr/lib/python3.6/multiprocessing/managers.py", line 772, in _callmethod
655 raise convert_to_error(kind, result)
656TypeError: 'NoneType' object is not iterable
657---------------------------------------------------------------------------