Error pydio.grpc.data.index.thumbnails

Pydio Cells
1

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

2

Maybe direct me to a folder to delete or a script to run, or a terminal line to run…?
appreciated

3

Hi,

it would help if you could tell:

  • OS / deployment type, version of your DB, version of cells
  • When did the error happen ?
4

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.

5

thumbnails disabled
thumbnails disabled2560×1440 195 KB

6

thumbs with error noted
thumbs with error noted2560×1440 197 KB

7

was simply looking for a process to clear the error and …maybe…let the process rebuild the thumbnails??? dunno

8

log file screenshot
log file screenshot2560×1440 224 KB

9

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)?
10

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.

11

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
thumbnail_indexing not running2560×1440 315 KB

12

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 ?

13

this system started as pydio cells v2.0 yes

14

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.

15

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

16

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}|

17

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

18

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.