Pieceinfo: unexpected schema does not match actual

Ive gotten an error:
Error: Error during preflight check for storagenode databases: preflight: database "pieceinfo": expected schema does not match actual: &dbschema.Schema{
Ive looked this up in the forums but cannot find anything that will work on my case. The full error output is below. I was running this node on a drive that I had forgotten was formated with largefile4, so I ran out of inodes and i think that corrupted something. I copied everything over to a new drive, but the data bases are corrupt. I can remove them and it all works fine, but would like to keep the data. I would greatly appreciate any help anyone can give me.

today at 7:08:07 PM2022-03-21T19:08:07.875-0400	INFO	Configuration loaded	{"Location": "/app/config/config.yaml"}
today at 7:08:07 PM2022-03-21T19:08:07.875-0400	INFO	Operator email	{"Address": "lrrrac@gmail.com"}
today at 7:08:07 PM2022-03-21T19:08:07.875-0400	INFO	Operator wallet	{"Address": "0xEb664374382AeB53750Ae74eaB553EFbdC34db36"}
today at 7:08:08 PM2022-03-21T19:08:08.389-0400	INFO	Telemetry enabled	{"instance ID": "1DoWkNcTci1sZATKhuYTDM5Bf8rJTCnBmAn3xppdAYLpj7iav5"}
today at 7:08:08 PM2022-03-21T19:08:08.895-0400	INFO	db.migration	Database Version	{"version": 53}
today at 7:08:10 PM2022-03-21T19:08:10.380-0400	WARN	db	database "pieceinfo": schema contains unexpected indices [Index<Table: piece_space_used, Name: idx_piece_space_used_satellite_id, Columns: satellite_id, Unique: true, Partial: "">]
today at 7:08:10 PMError: Error during preflight check for storagenode databases: preflight: database "pieceinfo": expected schema does not match actual:   &dbschema.Schema{
today at 7:08:10 PM  	Tables: []*dbschema.Table{
today at 7:08:10 PM- 		(
today at 7:08:10 PM- 			s"""
today at 7:08:10 PM- 			Name: pieceinfo_
today at 7:08:10 PM- 			Columns:
today at 7:08:10 PM- 				Name: deletion_failed_at
today at 7:08:10 PM- 				Type: TIMESTAMP
today at 7:08:10 PM- 				Nullable: true
today at 7:08:10 PM- 				Default: ""
today at 7:08:10 PM- 				Reference: nil
today at 7:08:10 PM- 				Name: order_limit
today at 7:08:10 PM- 				Type: BLOB
today at 7:08:10 PM- 				Nullable: false
today at 7:08:10 PM- 				Default: ""
today at 7:08:10 PM- 				Reference: nil
today at 7:08:10 PM- 				Name: piece_creation
today at 7:08:10 PM- 				Type: TIMESTAMP
today at 7:08:10 PM- 				Nullable: false
today at 7:08:10 PM- 				Default: ""
today at 7:08:10 PM- 				Reference: nil
today at 7:08:10 PM- 				Name: piece_expiration
today at 7:08:10 PM- 				Type: TIMESTAMP
today at 7:08:10 PM- 				Nullable: true
today at 7:08:10 PM- 				Default: ""
today at 7:08:10 PM- 				Reference: nil
today at 7:08:10 PM- 				Name: piece_id
today at 7:08:10 PM- 				Type: BLOB
today at 7:08:10 PM- 				Nullable: false
today at 7:08:10 PM- 				Default: ""
today at 7:08:10 PM- 				Reference: nil
today at 7:08:10 PM- 				Name: piece_size
today at 7:08:10 PM- 				Type: BIGINT
today at 7:08:10 PM- 				Nullable: false
today at 7:08:10 PM- 				Default: ""
today at 7:08:10 PM- 			... // 19 elided lines
today at 7:08:10 PM- 			s"""
today at 7:08:10 PM- 		),
today at 7:08:10 PM+ 		(
today at 7:08:10 PM+ 			s"""
today at 7:08:10 PM+ 			Name: piece_space_used
today at 7:08:10 PM+ 			Columns:
today at 7:08:10 PM+ 				Name: content_size
today at 7:08:10 PM+ 				Type: INTEGER
today at 7:08:10 PM+ 				Nullable: false
today at 7:08:10 PM+ 				Default: ""
today at 7:08:10 PM+ 				Reference: nil
today at 7:08:10 PM+ 				Name: satellite_id
today at 7:08:10 PM+ 				Type: BLOB
today at 7:08:10 PM+ 				Nullable: true
today at 7:08:10 PM+ 				Default: ""
today at 7:08:10 PM+ 				Reference: nil
today at 7:08:10 PM+ 				Name: total
today at 7:08:10 PM+ 				Type: INTEGER
today at 7:08:10 PM+ 				Nullable: false
today at 7:08:10 PM+ 				Default: ""
today at 7:08:10 PM+ 				Reference: nil
today at 7:08:10 PM+ 			PrimaryKey: 
today at 7:08:10 PM+ 			Uniques:
today at 7:08:10 PM+ 				
today at 7:08:10 PM+ 			s"""
today at 7:08:10 PM+ 		),
today at 7:08:10 PM  	},
today at 7:08:10 PM  	Indexes: []*dbschema.Index{
today at 7:08:10 PM- 		s`Index<Table: pieceinfo_, Name: idx_pieceinfo__expiration, Columns: piece_expiration, Unique: false, Partial: "piece_expiration IS NOT NULL">`,
today at 7:08:10 PM  		&{
today at 7:08:10 PM- 			Name:  "pk_pieceinfo_",
today at 7:08:10 PM+ 			Name:  "idx_piece_space_used_satellite_id",
today at 7:08:10 PM- 			Table: "pieceinfo_",
today at 7:08:10 PM+ 			Table: "piece_space_used",
today at 7:08:10 PM  			Columns: []string{
today at 7:08:10 PM  				"satellite_id",
today at 7:08:10 PM- 				"piece_id",
today at 7:08:10 PM  			},
today at 7:08:10 PM  			Unique:  true,
today at 7:08:10 PM  			Partial: "",
today at 7:08:10 PM  		},
today at 7:08:10 PM  	},
today at 7:08:10 PM  }
today at 7:08:10 PM
today at 7:08:10 PM	storj.io/storj/storagenode/storagenodedb.(*DB).preflight:406
today at 7:08:10 PM	storj.io/storj/storagenode/storagenodedb.(*DB).Preflight:353
today at 7:08:10 PM	main.cmdRun:241
today at 7:08:10 PM	storj.io/private/process.cleanup.func1.4:363
today at 7:08:10 PM	storj.io/private/process.cleanup.func1:381
today at 7:08:10 PM	github.com/spf13/cobra.(*Command).execute:852
today at 7:08:10 PM	github.com/spf13/cobra.(*Command).ExecuteC:960
today at 7:08:10 PM	github.com/spf13/cobra.(*Command).Execute:897
today at 7:08:10 PM	storj.io/private/process.ExecWithCustomConfig:88
today at 7:08:10 PM	storj.io/private/process.ExecCustomDebug:70
today at 7:08:10 PM	main.main:474
today at 7:08:10 PM	runtime.main:255
today at 7:08:10 PMContainer stopped

You can use this guide to re-create pieceinfo.db database file: https://support.storj.io/hc/en-us/articles/4403032417044-How-to-fix-database-file-is-not-a-database-error

Wow that was easy. THANK YOU!!!

1 Like