ArchiveSW - Display & Data Archive Storage

Developers Third-Party Integrations
, , ,
1542

downloaded the new altertables and ran. Here’s what I have.
image

Serverlog shows: “2019-12-03 19:14:27 Error running AlterTables”

1 Like
1543

I think it might be because of a typo. Look at the extra D in the word “HubSDtatus”

hubstatus
hubstatus1276×474 28.6 KB

1 Like
1544

I already checked that out No Change when corrected.
image

1 Like
1545

Geez… I fixed it. Please download again.

Sorry, Gary

1 Like
1546

I think it’s still missing the weird, slanted, single quote looking thing in front of HubStatus. The line above has it on both ends of the word DailySky.
I can’t get my nano to copy/paste so I can’t fix it easily.

1 Like
1547

Sorry, Still not fixed :slight_smile:

1 Like
1548

They say, ‘Third time is the charm.’ But even I know that’s not true.

Please try, “One more time, give me just one more time.”

1 Like
1549

do you want to update the server?
I have the same file. LOL

1 Like
1550

It is the same file number just edits to fix my goofs.

1551

Ok, that one seemed to work. Looked at the archive.log file and it got rid of the mqtt error but now there’s a new one:

2019-12-03 17:21:03 Error in insertHubStatus (4): ER_DATA_TOO_LONG: Data too long for column 'fs' at row 1

and it seems to be complaining about some new stuff in the altertables.log as well:

2019-12-03 17:19:47 Starting AlterTables v1.8.16.032
2019-12-03 17:19:48 Dropping table index: DailySky
2019-12-03 17:19:48 Dropping table index: PrecipEvent
2019-12-03 17:19:48 Dropping table index: SkyObservation
2019-12-03 17:19:48 Dropping table index: StrikeEvent
2019-12-03 17:19:48 Checking table index: AirBackfill
2019-12-03 17:19:48 Checking table index: AirObservation
2019-12-03 17:19:48 Checking table index: DailyAir
2019-12-03 17:19:48 Checking table index: DailySensor
2019-12-03 17:19:48 Checking table index: DailySky
2019-12-03 17:19:48 Checking table index: DeviceEvents
2019-12-03 17:19:48 Checking table index: DeviceStatus
2019-12-03 17:19:48 Checking table index: FWUpdate
2019-12-03 17:19:48 Checking table index: HubEvents
2019-12-03 17:19:48 Checking table index: HubStatus
2019-12-03 17:19:48 Checking table index: PrecipEvent
2019-12-03 17:19:48 Checking table index: RapidWind
2019-12-03 17:19:48 Checking table index: SkyBackfill
2019-12-03 17:19:49 Checking table index: SkyObservation
2019-12-03 17:19:49 Checking table index: StrikeEvent
2019-12-03 17:19:49 Checking table index: Xrain
2019-12-03 17:19:49 Checking table index: Yds18b20
2019-12-03 17:19:49 Error alterTableIndex (create index): Yds18b20 serial_number_timestamp
  ER_NO_SUCH_TABLE
2019-12-03 17:19:49 Error alterTableIndex (create index): Yds18b20 timestamp
  ER_NO_SUCH_TABLE
2019-12-03 17:19:49 Checking table index: Yuthing
2019-12-03 17:19:49 Error alterTableIndex (create index): Yuthing serial_number_timestamp
  ER_NO_SUCH_TABLE
2019-12-03 17:19:49 Error alterTableIndex (create index): Yuthing timestamp
  ER_NO_SUCH_TABLE
2019-12-03 17:19:49 Checking table index: Z_version
2019-12-03 17:19:49 Creating table: Yds18b20
2019-12-03 17:19:49 Creating table: Yuthing
2019-12-03 17:19:49 Table: HubEvents changed: fs to: varchar(10)
2019-12-03 17:19:49 Process changes complete
2019-12-03 17:19:49 Update Version complete
1 Like
1552

Ignore those errors for now. I will find why that is wrong.

1553

Run it again and I bet you get no errors.

1 Like
1554

Right you are! The altertables errors went away. Just left with the
2019-12-03 17:28:43 Error in insertHubStatus (4): ER_DATA_TOO_LONG: Data too long for column 'fs' at row 1

And the Devices tab still doesn’t look quite right:

devices
devices1538×887 53.5 KB

1 Like
1555

Weird, Still getting the old file. Rebooting…
Deleted old altertables and got a fresh one.

image
image698×592 12.6 KB

Going out for the night. I’ll check in tomorrow. Thanks for the great support @GaryFunk !!!

1 Like
1556

Like Gary said, try running altertables again and those errors seem to go away.
I’m heading out for dinner soon too!
Edit: here’s the results from the second running of altertables:
2019-12-03 20:51:37 Starting AlterTables v1.8.16.032
2019-12-03 20:51:38 Dropping table index: DailySky
2019-12-03 20:51:38 Dropping table index: PrecipEvent
2019-12-03 20:51:38 Dropping table index: SkyObservation
2019-12-03 20:51:38 Dropping table index: StrikeEvent
2019-12-03 20:51:38 Checking table index: AirBackfill
2019-12-03 20:51:38 Checking table index: AirObservation
2019-12-03 20:51:38 Checking table index: DailyAir
2019-12-03 20:51:38 Checking table index: DailySensor
2019-12-03 20:51:38 Checking table index: DailySky
2019-12-03 20:51:38 Checking table index: DeviceEvents
2019-12-03 20:51:38 Checking table index: DeviceStatus
2019-12-03 20:51:38 Checking table index: FWUpdate
2019-12-03 20:51:38 Checking table index: HubEvents
2019-12-03 20:51:38 Checking table index: HubStatus
2019-12-03 20:51:38 Checking table index: PrecipEvent
2019-12-03 20:51:38 Checking table index: RapidWind
2019-12-03 20:51:38 Checking table index: SkyBackfill
2019-12-03 20:51:39 Checking table index: SkyObservation
2019-12-03 20:51:39 Checking table index: StrikeEvent
2019-12-03 20:51:39 Checking table index: Xrain
2019-12-03 20:51:39 Checking table index: Yds18b20
2019-12-03 20:51:39 Checking table index: Yuthing
2019-12-03 20:51:39 Checking table index: Z_version
2019-12-03 20:51:39 Process changes complete
2019-12-03 20:51:39 Update Version complete

1 Like
1557

Getting the same error as @todd.lorey now.

image
image772×158 3.47 KB

No errors on updatefiles or altertables.

1 Like
1558

Make sure altertables is 1.8.16.032

1559

image

1560

Ahh, that’s a different error.

wget https://fsoft.com/archivesw/altertables.js

Here is a new file that should correct that.

1561

I assume you meant this for me. Yes, I’m still getting the following error every 10 seconds:

2019-12-04 16:18:31 Error in insertHubStatus (4): ER_DATA_TOO_LONG: Data too long for column 'fs' at row 1
2019-12-04 16:18:41 Error in insertHubStatus (4): ER_DATA_TOO_LONG: Data too long for column 'fs' at row 1
2019-12-04 16:18:51 Error in insertHubStatus (4): ER_DATA_TOO_LONG: Data too long for column 'fs' at row 1
1 Like