# Error pydio.grpc.data.index.thumbnails **URL:** \ **Category:** Pydio Cells\ **Created:** [November 10, 2021, 11:18pm UTC](https://forum.pydio.com/t/error-pydio-grpc-data-index-thumbnails/4146 "2021-11-10T23:18:52Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![jasonmccullar](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@jasonmccullar](https://forum.pydio.com/u/jasonmccullar)\ **Post date:** [November 10, 2021, 11:18pm UTC](https://forum.pydio.com/t/error-pydio-grpc-data-index-thumbnails/4146/1 "2021-11-10T23:18:52Z")
Ts : 1636585950 Level : error Logger : pydio.grpc.data.index.thumbnails Msg : Could not run - Error 1091: Can’t DROP ‘data\_index\_thumbnails\_idx\_tree\_u1’; check that column/key exists handling data\_index\_thumbnails\_idx\_0.4.sql SpanUuid : span-13 thumbnail indexing is not occuring…? Any thoughts on clearing this up? Thanks JasonMcCullar ---
**Author:** ![jasonmccullar](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@jasonmccullar](https://forum.pydio.com/u/jasonmccullar)\ **Post date:** [November 10, 2021, 11:19pm UTC](https://forum.pydio.com/t/error-pydio-grpc-data-index-thumbnails/4146/2 "2021-11-10T23:19:49Z")
Maybe direct me to a folder to delete or a script to run, or a terminal line to run…? appreciated ---
**Author:** ![bsinou](https://yyz2.discourse-cdn.com/flex032/user_avatar/forum.pydio.com/bsinou/32/476_2.png) [@bsinou](https://forum.pydio.com/u/bsinou)\ **Post date:** [November 11, 2021, 8:02am UTC](https://forum.pydio.com/t/error-pydio-grpc-data-index-thumbnails/4146/3 "2021-11-11T08:02:29Z")
Hi, it would help if you could tell: - OS / deployment type, version of your DB, version of cells - When did the error happen ? ---
**Author:** ![jasonmccullar](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@jasonmccullar](https://forum.pydio.com/u/jasonmccullar)\ **Post date:** [November 11, 2021, 2:16pm UTC](https://forum.pydio.com/t/error-pydio-grpc-data-index-thumbnails/4146/4 "2021-11-11T14:16:45Z")
OK here you go Hardware: dedicated I-5 16GB ram 500GB SSD box for Pydio only Software: pydio v.3.01 OS: Linux ubuntu/debian flavor Database: default Pydio installation system is for personal use storage and indexing of all files/folders Community version Havent used it much in last 12 months… been watching progress of cells and allowing time to mature more before use… then v.3.01 came I decided to start using this week. Started adding content ( heavy uploads last 36 hours ) to the system after update to 3.01 noticed error yesterday afternoon. Was not sure how to correct it. ---
**Author:** ![jasonmccullar](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@jasonmccullar](https://forum.pydio.com/u/jasonmccullar)\ **Post date:** [November 11, 2021, 2:18pm UTC](https://forum.pydio.com/t/error-pydio-grpc-data-index-thumbnails/4146/5 "2021-11-11T14:18:34Z")
![thumbnails disabled](https://canada1.discourse-cdn.com/flex032/uploads/pydio/original/2X/0/026f79eefdd9985097414cd56a2a79d5a79a3ce9.png) ---
**Author:** ![jasonmccullar](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@jasonmccullar](https://forum.pydio.com/u/jasonmccullar)\ **Post date:** [November 11, 2021, 2:18pm UTC](https://forum.pydio.com/t/error-pydio-grpc-data-index-thumbnails/4146/6 "2021-11-11T14:18:47Z")
![thumbs with error noted](https://canada1.discourse-cdn.com/flex032/uploads/pydio/original/2X/9/952a6afd6bd716175c15cac0a86c36f6145bf7ca.png) ---
**Author:** ![jasonmccullar](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@jasonmccullar](https://forum.pydio.com/u/jasonmccullar)\ **Post date:** [November 11, 2021, 2:19pm UTC](https://forum.pydio.com/t/error-pydio-grpc-data-index-thumbnails/4146/7 "2021-11-11T14:19:35Z")
was simply looking for a process to clear the error and …maybe…let the process rebuild the thumbnails??? dunno ---
**Author:** ![jasonmccullar](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@jasonmccullar](https://forum.pydio.com/u/jasonmccullar)\ **Post date:** [November 11, 2021, 2:22pm UTC](https://forum.pydio.com/t/error-pydio-grpc-data-index-thumbnails/4146/8 "2021-11-11T14:22:00Z")
![log file screenshot](https://canada1.discourse-cdn.com/flex032/uploads/pydio/original/2X/6/607ed455506bb7c235210fd9ba461172d4c5c671.png) ---
**Author:** ![bsinou](https://yyz2.discourse-cdn.com/flex032/user_avatar/forum.pydio.com/bsinou/32/476_2.png) [@bsinou](https://forum.pydio.com/u/bsinou)\ **Post date:** [November 11, 2021, 3:52pm UTC](https://forum.pydio.com/t/error-pydio-grpc-data-index-thumbnails/4146/9 "2021-11-11T15:52:27Z")
In fact it seems like you have a real issue there: it looks like at some point, the migration of the thumbnail datasource failed. Now the index of the thumbnail DS cannot start so you won’t have any thumb and you have to solve this before trying to re-generate the thumbnails. Yet, from what I see, I suppose you have been migrated from a very _“old”_ version of Cells, so a few more questions to be able to help: - from which version have you upgraded? - was the process directly OK, or did you have to make it more than once? - do you still have the log of the migration process (it is the log of the first restart after you perform the upgrade via the admin console)? ---
**Author:** ![jasonmccullar](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@jasonmccullar](https://forum.pydio.com/u/jasonmccullar)\ **Post date:** [November 12, 2021, 2:36pm UTC](https://forum.pydio.com/t/error-pydio-grpc-data-index-thumbnails/4146/10 "2021-11-12T14:36:44Z")
good morning. This is a fresh installation on a fresh box. The old data ( files only) was copied over and I have started the manual creation of fresh data. IE… no upgrade from old version of Pydio. Now this system did start on cells v.2.0. Test data was introduced, and then 12 months+ went by as I watched cells update its product. I recently upgraded to 3.01 earlier this week. The thumbnail indexing service looks to have last run in June 2021. I deleted the thumbnails from the folder and made sure it was writeable. ---
**Author:** ![jasonmccullar](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@jasonmccullar](https://forum.pydio.com/u/jasonmccullar)\ **Post date:** [November 12, 2021, 2:40pm UTC](https://forum.pydio.com/t/error-pydio-grpc-data-index-thumbnails/4146/11 "2021-11-12T14:40:08Z")
I also rebooted the server and attached a pic of the log file upon startup… indeed looks like the service is not starting ![thumbnail_indexing not running](https://canada1.discourse-cdn.com/flex032/uploads/pydio/original/2X/d/d1c06ce9f533c32c509d378cbb70f140aa88274e.png) ---
**Author:** ![bsinou](https://yyz2.discourse-cdn.com/flex032/user_avatar/forum.pydio.com/bsinou/32/476_2.png) [@bsinou](https://forum.pydio.com/u/bsinou)\ **Post date:** [November 12, 2021, 4:28pm UTC](https://forum.pydio.com/t/error-pydio-grpc-data-index-thumbnails/4146/12 "2021-11-12T16:28:37Z")
> [@jasonmccullar](#): > > no upgrade from old version of Pydio. Now this system did start on cells v.2.0. Not sure to understand this… Does it means that at some point, you have been running a version of the app that you built locally and then had v0.2.0 ? ---
**Author:** ![jasonmccullar](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@jasonmccullar](https://forum.pydio.com/u/jasonmccullar)\ **Post date:** [November 12, 2021, 4:55pm UTC](https://forum.pydio.com/t/error-pydio-grpc-data-index-thumbnails/4146/13 "2021-11-12T16:55:24Z")
this system started as pydio cells v2.0 yes ---
**Author:** ![jasonmccullar](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@jasonmccullar](https://forum.pydio.com/u/jasonmccullar)\ **Post date:** [November 13, 2021, 2:39pm UTC](https://forum.pydio.com/t/error-pydio-grpc-data-index-thumbnails/4146/14 "2021-11-13T14:39:48Z")
Final thoughts here as I believe I have found the problem… Looks like a .sql table issue. I will correct/clean and restart… that should resolve the issue. Thanks for the replies. it is appreciated. ---
**Author:** ![jasonmccullar](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@jasonmccullar](https://forum.pydio.com/u/jasonmccullar)\ **Post date:** [November 15, 2021, 3:07pm UTC](https://forum.pydio.com/t/error-pydio-grpc-data-index-thumbnails/4146/15 "2021-11-15T15:07:57Z")
this is the error that I am trying to solve: |2021-11-15T08:20:13.986-0600|ERROR|pydio.grpc.data.index.thumbnails|Failed to init DB provider|{error: Error 1091: Can’t DROP ‘data\_index\_thumbnails\_idx\_tree\_u1’; check that column/key exists handling data\_index\_thumbnails\_idx\_0.4.sql}| I wanted to solicit advice on a proper fix. The indexer isnt running and I dont want to just drop the table without talking with someone about it first. thoughts on a .sql script that would remedy the issue? Thanks Jason ---
**Author:** ![jasonmccullar](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@jasonmccullar](https://forum.pydio.com/u/jasonmccullar)\ **Post date:** [November 15, 2021, 3:09pm UTC](https://forum.pydio.com/t/error-pydio-grpc-data-index-thumbnails/4146/16 "2021-11-15T15:09:00Z")
FULL ERROR here: |2021-11-15T08:20:13.986-0600|ERROR|pydio.grpc.data.index.thumbnails|Failed to init DB provider|{error: Error 1091: Can’t DROP ‘data\_index\_thumbnails\_idx\_tree\_u1’; check that column/key exists handling data\_index\_thumbnails\_idx\_0.4.sql}| |2021-11-15T08:20:13.986-0600|ERROR|pydio.grpc.data.index.thumbnails|Could not run |{error: Error 1091: Can’t DROP ‘data\_index\_thumbnails\_idx\_tree\_u1’; check that column/key exists handling data\_index\_thumbnails\_idx\_0.4.sql}| ---
**Author:** ![jasonmccullar](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@jasonmccullar](https://forum.pydio.com/u/jasonmccullar)\ **Post date:** [November 16, 2021, 7:49pm UTC](https://forum.pydio.com/t/error-pydio-grpc-data-index-thumbnails/4146/17 "2021-11-16T19:49:13Z")
after playing around with the database, etc… I decided to just NUKE the installation and start from scratch. You can close this thread as desired. Thanks, Jason ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex032/uploads/pydio/original/2X/6/61f19fa52ec15fd4250db51aea351adba0e831fd.png) [@system](https://forum.pydio.com/u/system)\ **Post date:** [January 15, 2022, 7:50pm UTC](https://forum.pydio.com/t/error-pydio-grpc-data-index-thumbnails/4146/18 "2022-01-15T19:50:05Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.