Sep 24 15:17:03 ip-172-20-9-222 systemd[1]: Started Nebraska.
Sep 24 15:17:04 ip-172-20-9-222 docker[2669]: {"_t":"2019-09-24T15:17:04+0000", "_p":"1", "_l":"INF", "_n":"dat:sqlx", "_m":"Query time", "elapsed":"1.91489ms", "sql":"select setting from pg_settings where name='standard_conforming_strings'"}
Sep 24 15:17:04 ip-172-20-9-222 docker[2669]: {"_t":"2019-09-24T15:17:04+0000", "_p":"1", "_l":"INF", "_n":"dat:sqlx", "_m":"Query time", "elapsed":"1.36534ms", "sql":"SHOW server_version_num"}
Sep 24 15:17:04 ip-172-20-9-222 docker[2669]: {"_t":"2019-09-24T15:17:04+0000", "_p":"1", "_l":"INF", "_n":"dat:sqlx", "_m":"Query time", "elapsed":"6.594847ms", "sql":"SELECT row_to_json(dat__item.*) FROM ( SELECT id, name, description, created_ts, (SELECT array_agg(dat__groups.*) FROM (SELECT *, (SELECT array_agg(dat__version_breakdown.*) FROM (\n\tSELECT version, count(*) as instances, (count(*) * 100.0 / total) as percentage\n\tFROM instance_application, (\n\t\tSELECT count(*) as total \n\t\tFROM instance_application \n\t\tWHERE group_id=groups.id AND last_check_for_updates \u003e now() at time zone 'utc' - interval '1 days'\n\t\t) totals\n\tWHERE group_id=groups.id AND last_check_for_updates \u003e now() at time zone 'utc' - interval '1 days'\n\tGROUP BY version, total\n\tORDER BY regexp_matches(version, '(\\d+)\\.(\\d+)\\.(\\d+)')::int[] DESC\n\t) AS dat__version_breakdown) AS \"version_breakdown\", (SELECT row_to_json(dat__instances_stats.*) FROM (\n\tSELECT\n\t\tcount(*) total,\n\t\tsum(case when status IS NULL then 1 else 0 end) undefined,\n\t\tsum(case when status = 3 then 1 else 0 end) error,\n\t\tsum(case when status = 2 then 1 else 0 end) update_granted,\n\t\tsum(case when status = 4 then 1 else 0 end) complete,\n\t\tsum(case when status = 5 then 1 else 0 end) installed,\n\t\tsum(case when status = 6 then 1 else 0 end) downloaded,\n\t\tsum(case when status = 7 then 1 else 0 end) downloading,\n\t\tsum(case when status = 8 then 1 else 0 end) onhold\n\tFROM instance_application\n\tWHERE group_id=groups.id AND last_check_for_updates \u003e now() at time zone 'utc' - interval '1 days') AS dat__instances_stats) AS \"instances_stats\", (SELECT row_to_json(dat__channel.*) FROM (SELECT *, (SELECT row_to_json(dat__package.*) FROM (SELECT \n\t\t\tpackage.*, \n\t\t\tarray_agg(pcb.channel_id) FILTER (WHERE pcb.channel_id IS NOT NULL) as channels_blacklist\n\t\t, (SELECT row_to_json(dat__coreos_action.*) FROM (SELECT * FROM coreos_action WHERE package_id = package.id) AS dat__coreos_action) AS \"coreos_action\" FROM package LEFT JOIN package_channel_blacklist pcb ON package.id = pcb.package_id WHERE (package.id = channel.package_id) GROUP BY package.id ORDER BY regexp_matches(version, '(\\d+)\\.(\\d+)\\.(\\d+)')::int[] DESC) AS dat__package) AS \"package\" FROM channel WHERE (id = groups.channel_id) ORDER BY name ASC) AS dat__channel) AS \"channel\" FROM groups WHERE (application_id = application.id) ORDER BY created_ts DESC) AS dat__groups) AS \"groups\", (SELECT array_agg(dat__channels.*) FROM (SELECT *, (SELECT row_to_json(dat__package.*) FROM (SELECT \n\t\t\tpackage.*, \n\t\t\tarray_agg(pcb.channel_id) FILTER (WHERE pcb.channel_id IS NOT NULL) as channels_blacklist\n\t\t, (SELECT row_to_json(dat__coreos_action.*) FROM (SELECT * FROM coreos_action WHERE package_id = package.id) AS dat__coreos_action) AS \"coreos_action\" FROM package LEFT JOIN package_channel_blacklist pcb ON package.id = pcb.package_id WHERE (package.id = channel.package_id) GROUP BY package.id ORDER BY regexp_matches(version, '(\\d+)\\.(\\d+)\\.(\\d+)')::int[] DESC) AS dat__package) AS \"package\" FROM channel WHERE (application_id = application.id) ORDER BY name ASC) AS dat__channels) AS \"channels\", (SELECT array_agg(dat__packages.*) FROM (SELECT \n\t\t\tpackage.*, \n\t\t\tarray_agg(pcb.channel_id) FILTER (WHERE pcb.channel_id IS NOT NULL) as channels_blacklist\n\t\t, (SELECT row_to_json(dat__coreos_action.*) FROM (SELECT * FROM coreos_action WHERE package_id = package.id) AS dat__coreos_action) AS \"coreos_action\" FROM package LEFT JOIN package_channel_blacklist pcb ON package.id = pcb.package_id WHERE (application_id = application.id) GROUP BY package.id ORDER BY regexp_matches(version, '(\\d+)\\.(\\d+)\\.(\\d+)')::int[] DESC) AS dat__packages) AS \"packages\", (SELECT row_to_json(dat__instances.*) FROM (\n\tSELECT count(*)\n\tFROM instance_application \n\tWHERE application_id = application.id AND \n\t last_check_for_updates \u003e now() at time zone 'utc' - interval '1 days'\n\t) AS dat__instances) AS \"instances\" FROM application WHERE (id = '{e96281a6-d1af-4bde-9a0a-97b76e56dc57}') ORDER BY created_ts DESC) as dat__item"}
Sep 24 15:17:04 ip-172-20-9-222 docker[2669]: {"_t":"2019-09-24T15:17:04+0000", "_p":"1", "_l":"ERR", "_n":"rollerd", "_m":"sql: no rows in result set"}
Sep 24 15:17:04 ip-172-20-9-222 systemd[1]: nebraska.service: Main process exited, code=exited, status=1/FAILURE
Sep 24 15:17:04 ip-172-20-9-222 systemd[1]: nebraska.service: Failed with result 'exit-code'.
Nebraska should work w/o any "sample data" in the database. Required data should be applied through a migration. A freshly installed instance should work with -enable-syncer
and be usable out of the box.