Not sure if this is an error due to sql limitations, or if it is an error with my source.
As always, your help is appreciated.
dave
- Code: Select all
Nov 12, 2019 at 7:22:49 AM
SQL Logger adding column "forecastgroup_forecast_1_snowlevel_textsummary_ui" to table device_history_974671683 ("dd.weather.gc.ca")
SQL Logger Error exception trying to update table device_history_974671683 ("dd.weather.gc.ca") -- unable to modify table
SQL Logger Error ERROR: tables can have at most 1600 columns
SQL Logger Error exception trying to insert row into table device_history_974671683 ("dd.weather.gc.ca") -- unable to modify table
SQL Logger Error ERROR: column "hourlyforecastgroup_hourlyforecast_7_datetimeutc_ui" of relation "device_history_974671683" does not exist at character 321
SQL Logger Error INSERT INTO device_history_974671683 ("hourlyforecastgroup_hourlyforecast_17_datetimeutc", "hourlyforecastgroup_hourlyforecast_10_datetimeutc", "hourlyforecastgroup_hourlyforecast_22_datetimeutc", "hourlyforecastgroup_hourlyforecast_11_lop_ui", "hourlyforecastgroup_hourlyforecast_20_datetimeutc", "datetime_2_hour_ui", "hourlyforecastgroup_hourlyforecast_7_datetimeutc_ui", "currentconditions_iconcode", "hourlyforecastgroup_hourlyforecast_1_datetimeutc", "datetime_1_hour", "currentconditions_datetime_2_textsummary_ui", "hourlyforecastgroup_hourlyforecast_7_wind_speed", "hourlyforecastgroup_hourlyforecast_5_iconcode_ui", "currentconditions_dewpoint", "currentconditions_wind_bearing_ui", "datetime_1_minute", "hourlyforecastgroup_hourlyforecast_21_datetimeutc_ui", "datetime_2_hour", "hourlyforecastgroup_hourlyforecast_14_datetimeutc", "datetime_2_timestamp_ui", "hourlyforecastgroup_hourlyforecast_23_datetimeutc", "datetime_2_textsummary_ui", "hourlyforecastgroup_hourlyforecast_15_datetimeutc_ui", "hourlyforecastgroup_hourlyforecast_18_datetimeutc", "currentconditions_dewpoint_ui", "datetime_2_minute_ui", "hourlyforecastgroup_hourlyforecast_21_wind_direction", "hourlyforecastgroup_hourlyforecast_24_datetimeutc", "hourlyforecastgroup_hourlyforecast_13_datetimeutc_ui", "currentconditions_wind_bearing", "hourlyforecastgroup_hourlyforecast_21_wind_speed_ui", "hourlyforecastgroup_hourlyforecast_4_datetimeutc_ui", "hourlyforecastgroup_hourlyforecast_6_datetimeutc_ui", "hourlyforecastgroup_hourlyforecast_24_wind_speed", "hourlyforecastgroup_hourlyforecast_13_datetimeutc", "hourlyforecastgroup_hourlyforecast_9_temperature_ui", "currentconditions_datetime_1_textsummary_ui", "hourlyforecastgroup_hourlyforecast_8_datetimeutc_ui", "hourlyforecastgroup_hourlyforecast_5_datetimeutc", "hourlyforecastgroup_hourlyforecast_16_datetimeutc", "hourlyforecastgroup_hourlyforecast_20_lop_ui", "hourlyforecastgroup_hourlyforecast_10_datetimeutc_ui", "currentconditions_wind_direction_ui", "datetime_1_timestamp", "hourlyforecastgroup_hourlyforecast_9_temperature", "hourlyforecastgroup_hourlyforecast_20_condition_ui", "hourlyforecastgroup_hourlyforecast_11_datetimeutc_ui", "currentconditions_datetime_1_minute", "hourlyforecastgroup_hourlyforecast_5_iconcode", "hourlyforecastgroup_hourlyforecast_7_datetimeutc", "hourlyforecastgroup_hourlyforecast_11_lop", "hourlyforecastgroup_hourlyforecast_24_wind_speed_ui", "hourlyforecastgroup_hourlyforecast_15_datetimeutc", "hourlyforecastgroup_hourlyforecast_20_iconcode_ui", "hourlyforecastgroup_hourlyforecast_9_datetimeutc", "hourlyforecastgroup_hourlyforecast_13_temperature", "hourlyforecastgroup_hourlyforecast_11_lop_category", "hourlyforecastgroup_hourlyforecast_7_temperature_ui", "currentconditions_datetime_2_hour_ui", "hourlyforecastgroup_hourlyforecast_24_wind_direction", "hourlyforecastgroup_hourlyforecast_18_datetimeutc_ui", "currentconditions_datetime_1_hour_ui", "hourlyforecastgroup_hourlyforecast_6_datetimeutc", "hourlyforecastgroup_hourlyforecast_13_wind_speed_ui", "hourlyforecastgroup_hourlyforecast_23_datetimeutc_ui", "hourlyforecastgroup_hourlyforecast_13_wind_speed", "hourlyforecastgroup_hourlyforecast_11_lop_category_ui", "currentconditions_condition", "hourlyforecastgroup_hourlyforecast_13_wind_direction_ui", "hourlyforecastgroup_hourlyforecast_22_datetimeutc_ui", "hourlyforecastgroup_hourlyforecast_16_datetimeutc_ui", "hourlyforecastgroup_hourlyforecast_8_temperature_ui", "hourlyforecastgroup_hourlyforecast_2_datetimeutc_ui", "currentconditions_visibility", "hourlyforecastgroup_hourlyforecast_12_datetimeutc", "hourlyforecastgroup_hourlyforecast_2_temperature_ui", "currentconditions_datetime_2_timestamp", "hourlyforecastgroup_hourlyforecast_1_datetimeutc_ui", "hourlyforecastgroup_hourlyforecast_2_datetimeutc", "datetime_1_textsummary_ui", "hourlyforecastgroup_hourlyforecast_7_wind_speed_ui", "hourlyforecastgroup_hourlyforecast_17_datetimeutc_ui", "currentconditions_datetime_1_textsummary", "hourlyforecastgroup_hourlyforecast_19_datetimeutc", "currentconditions_datetime_2_minute_ui", "hourlyforecastgroup_hourlyforecast_3_datetimeutc", "hourlyforecastgroup_hourlyforecast_20_lop", "hourlyforecastgroup_hourlyforecast_5_datetimeutc_ui", "hourlyforecastgroup_hourlyforecast_12_datetimeutc_ui", "hourlyforecastgroup_hourlyforecast_7_temperature", "hourlyforecastgroup_hourlyforecast_21_wind_speed", "currentconditions_temperature", "datetime_2_textsummary", "currentconditions_wind_speed_ui", "currentconditions_datetime_2_minute", "hourlyforecastgroup_hourlyforecast_5_condition", "currentconditions_iconcode_ui", "hourlyforecastgroup_hourlyforecast_11_condition_ui", "hourlyforecastgroup_hourlyforecast_23_temperature", "currentconditions_temperature_ui", "hourlyforecastgroup_hourlyforecast_2_temperature", "currentconditions_condition_ui", "datetime_1_timestamp_ui", "hourlyforecastgroup_hourlyforecast_21_datetimeutc", "currentconditions_datetime_1_timestamp", "hourlyforecastgroup_hourlyforecast_9_datetimeutc_ui", "currentconditions_datetime_1_timestamp_ui", "currentconditions_datetime_2_timestamp_ui", "currentconditions_wind_direction", "hourlyforecastgroup_hourlyforecast_24_wind_direction_ui", "hourlyforecastgroup_hourlyforecast_8_temperature", "hourlyforecastgroup_hourlyforecast_5_condition_ui", "datetime_1_textsummary", "hourlyforecastgroup_hourlyforecast_20_lop_category_ui", "hourlyforecastgroup_hourlyforecast_12_temperature_ui", "datetime_2_timestamp", "hourlyforecastgroup_hourlyforecast_20_iconcode", "hourlyforecastgroup_hourlyforecast_8_datetimeutc", "hourlyforecastgroup_hourlyforecast_14_datetimeutc_ui", "datetime_1_hour_ui", "hourlyforecastgroup_hourlyforecast_23_temperature_ui", "currentconditions_datetime_2_textsummary", "hourlyforecastgroup_hourlyforecast_13_temperature_ui", "currentconditions_datetime_1_hour", "hourlyforecastgroup_hourlyforecast_24_datetimeutc_ui", "hourlyforecastgroup_hourlyforecast_11_condition", "hourlyforecastgroup_hourlyforecast_20_datetimeutc_ui", "datetime_1_minute_ui", "currentconditions_datetime_2_hour", "hourlyforecastgroup_hourlyforecast_7_wind_direction_ui", "hourlyforecastgroup_hourlyforecast_4_datetimeutc", "hourlyforecastgroup_hourlyforecast_19_datetimeutc_ui", "currentconditions_wind_speed", "currentconditions_datetime_1_minute_ui", "hourlyforecastgroup_hourlyforecast_12_temperature", "datetime_2_minute", "hourlyforecastgroup_hourlyforecast_20_condition", "hourlyforecastgroup_hourlyforecast_21_wind_direction_ui", "currentconditions_visibility_ui", "hourlyforecastgroup_hourlyforecast_20_lop_category", "hourlyforecastgroup_hourlyforecast_7_wind_direction", "hourlyforecastgroup_hourlyforecast_3_datetimeutc_ui", "hourlyforecastgroup_hourlyforecast_11_datetimeutc", "hourlyforecastgroup_hourlyforecast_13_wind_direction") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);