{"action":"created","issue":{"url":"https://api.github.com/repos/getredash/redash/issues/1238","repository_url":"https://api.github.com/repos/getredash/redash","labels_url":"https://api.github.com/repos/getredash/redash/issues/1238/labels{/name}","comments_url":"https://api.github.com/repos/getredash/redash/issues/1238/comments","events_url":"https://api.github.com/repos/getredash/redash/issues/1238/events","html_url":"https://github.com/getredash/redash/issues/1238","id":171537903,"number":1238,"title":"Dashboards public links not working","user":{"login":"WesleyBatista","id":755254,"avatar_url":"https://avatars.githubusercontent.com/u/755254?v=3","gravatar_id":"","url":"https://api.github.com/users/WesleyBatista","html_url":"https://github.com/WesleyBatista","followers_url":"https://api.github.com/users/WesleyBatista/followers","following_url":"https://api.github.com/users/WesleyBatista/following{/other_user}","gists_url":"https://api.github.com/users/WesleyBatista/gists{/gist_id}","starred_url":"https://api.github.com/users/WesleyBatista/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/WesleyBatista/subscriptions","organizations_url":"https://api.github.com/users/WesleyBatista/orgs","repos_url":"https://api.github.com/users/WesleyBatista/repos","events_url":"https://api.github.com/users/WesleyBatista/events{/privacy}","received_events_url":"https://api.github.com/users/WesleyBatista/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":13,"created_at":"2016-08-16T23:00:51Z","updated_at":"2016-08-19T15:54:46Z","closed_at":null,"body":"### Issue Summary\r\n\r\nHello guys,\r\n\r\nTrying to share a dashboard I am getting this:\r\n![scheenshot](https://cloud.githubusercontent.com/assets/755254/17718639/495b1096-63eb-11e6-8034-adac36a9dd37.png)\r\n\r\nThe log starting from the call:\r\n```\r\n[2016-08-16 22:21:55,103][PID:15393][INFO][metrics] method=GET path=/public/dashboards/4y6fsdfymPRy7hCOHe5OsD2RdmfqXEim3QOMN53QJRuPL1 endpoint=redash.public_dashboard status=500 content_type=? content_length=-1 duration=53.16 query_count=17 query_duration=13.12\r\n[2016-08-16 22:21:55,751][PID:15393][INFO][metrics] method=GET path=/styles/main.515f0263.css endpoint=redash.send_static status=200 content_type=text/css; charset=utf-8 content_length=258555 duration=2.88 query_count=0 query_duration=0.00\r\n[2016-08-16 22:21:55,751][PID:15393][INFO][metrics] method=GET path=/styles/main.515f0263.css endpoint=redash.send_static status=500 content_type=? content_length=-1 duration=3.26 query_count=0 query_duration=0.00\r\n[2016-08-16 22:21:56,017][PID:15393][INFO][metrics] method=GET path=/scripts/plugins.3e90b1ef.js endpoint=redash.send_static status=200 content_type=application/javascript content_length=2517605 duration=2.84 query_count=0 query_duration=0.00\r\n[2016-08-16 22:21:56,018][PID:15393][INFO][metrics] method=GET path=/scripts/plugins.3e90b1ef.js endpoint=redash.send_static status=500 content_type=? content_length=-1 duration=3.22 query_count=0 query_duration=0.00\r\n[2016-08-16 22:21:56,285][PID:15393][INFO][metrics] method=GET path=/scripts/scripts.f59202ee.js endpoint=redash.send_static status=200 content_type=application/javascript content_length=100183 duration=2.85 query_count=0 query_duration=0.00\r\n[2016-08-16 22:21:56,285][PID:15393][INFO][metrics] method=GET path=/scripts/scripts.f59202ee.js endpoint=redash.send_static status=500 content_type=? content_length=-1 duration=3.24 query_count=0 query_duration=0.00\r\n[2016-08-16 22:21:56,407][PID:14741][INFO][metrics] method=GET path=/fonts/roboto/Roboto-Regular-webfont.woff endpoint=redash.send_static status=200 content_type=application/x-font-woff content_length=25020 duration=2.87 query_count=0 query_duration=0.00\r\n[2016-08-16 22:21:56,408][PID:14741][INFO][metrics] method=GET path=/fonts/roboto/Roboto-Regular-webfont.woff endpoint=redash.send_static status=500 content_type=? content_length=-1 duration=3.25 query_count=0 query_duration=0.00\r\n[2016-08-16 22:21:56,695][PID:15881][INFO][metrics] method=GET path=/images/redash_icon_small.png endpoint=redash.send_static status=200 content_type=image/png content_length=3123 duration=2.85 query_count=0 query_duration=0.00\r\n[2016-08-16 22:21:56,696][PID:15881][INFO][metrics] method=GET path=/images/redash_icon_small.png endpoint=redash.send_static status=500 content_type=? content_length=-1 duration=3.23 query_count=0 query_duration=0.00\r\n[2016-08-16 22:21:58,824][PID:15881][INFO][metrics] method=GET path=/views/dashboard.html endpoint=redash.send_static status=200 content_type=text/html; charset=utf-8 content_length=6620 duration=3.16 query_count=0 query_duration=0.00\r\n[2016-08-16 22:21:58,825][PID:15881][INFO][metrics] method=GET path=/views/dashboard.html endpoint=redash.send_static status=500 content_type=? content_length=-1 duration=4.61 query_count=0 query_duration=0.00\r\n[2016-08-16 22:21:59,199][PID:15881][INFO][metrics] method=GET path=/fonts/roboto/Roboto-Medium-webfont.woff endpoint=redash.send_static status=200 content_type=application/x-font-woff content_length=25048 duration=2.98 query_count=0 query_duration=0.00\r\n[2016-08-16 22:21:59,200][PID:15881][INFO][metrics] method=GET path=/fonts/roboto/Roboto-Medium-webfont.woff endpoint=redash.send_static status=500 content_type=? content_length=-1 duration=4.16 query_count=0 query_duration=0.00\r\n[2016-08-16 22:22:00,270][PID:15393][INFO][metrics] method=POST path=/api/events endpoint=events status=200 content_type=application/json content_length=4 duration=57.31 query_count=20 query_duration=14.60\r\n[2016-08-16 22:22:00,270][PID:15393][INFO][metrics] method=POST path=/api/events endpoint=events status=500 content_type=? content_length=-1 duration=57.82 query_count=20 query_duration=14.60\r\n[2016-08-16 22:22:21,759][PID:15393][INFO][metrics] method=GET path=/views/dashboard_share.html endpoint=redash.send_static status=200 content_type=text/html; charset=utf-8 content_length=637 duration=2.82 query_count=0 query_duration=0.00\r\n[2016-08-16 22:22:21,760][PID:15393][INFO][metrics] method=GET path=/views/dashboard_share.html endpoint=redash.send_static status=500 content_type=? content_length=-1 duration=3.62 query_count=0 query_duration=0.00\r\n[2016-08-16 22:22:26,373][PID:15881][INFO][metrics] method=DELETE path=/api/dashboards/369/share endpoint=dashboard_share status=200 content_type=application/json content_length=4 duration=12.85 query_count=7 query_duration=6.76\r\n[2016-08-16 22:22:26,374][PID:15881][INFO][metrics] method=DELETE path=/api/dashboards/369/share endpoint=dashboard_share status=500 content_type=? content_length=-1 duration=13.67 query_count=7 query_duration=6.76\r\n[2016-08-16 22:22:27,631][PID:15393][INFO][metrics] method=POST path=/api/dashboards/369/share endpoint=dashboard_share status=200 content_type=application/json content_length=179 duration=14.60 query_count=8 query_duration=8.08\r\n[2016-08-16 22:22:27,632][PID:15393][INFO][metrics] method=POST path=/api/dashboards/369/share endpoint=dashboard_share status=500 content_type=? content_length=-1 duration=15.80 query_count=8 query_duration=8.08\r\n[2016-08-16 22:22:36,241: ERROR/MainProcess] Task redash.tasks.record_event[e51bc501-4600-4174-960d-10783b7d13ae] raised unexpected: ValueError(\"invalid literal for int() with base 10: 'N3xLsL8kCGyBk7y5yXHzH5oMo1wvf5xrhJDakIHf'\",)\r\nTraceback (most recent call last):\r\n  File \"/usr/local/lib/python2.7/dist-packages/celery/app/trace.py\", line 240, in trace_task\r\n    R = retval = fun(*args, **kwargs)\r\n  File \"/opt/redash/current/redash/tasks/base.py\", line 13, in __call__\r\n    return super(BaseTask, self).__call__(*args, **kwargs)\r\n  File \"/usr/local/lib/python2.7/dist-packages/celery/app/trace.py\", line 437, in __protected_call__\r\n    return self.run(*args, **kwargs)\r\n  File \"/opt/redash/current/redash/tasks/general.py\", line 15, in record_event\r\n    models.Event.record(event)\r\n  File \"/opt/redash/current/redash/models.py\", line 1073, in record\r\n    additional_properties=additional_properties, created_at=created_at)\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 4001, in create\r\n    inst.save(force_insert=True)\r\n  File \"/opt/redash/current/redash/models.py\", line 99, in save\r\n    super(BaseModel, self).save(*args, **kwargs)\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 4148, in save\r\n    pk_from_cursor = self.insert(**field_dict).execute()\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 2858, in execute\r\n    cursor = self._execute()\r\n  File \"/opt/redash/current/redash/metrics/database.py\", line 50, in metered_execute\r\n    result = real_execute(self, *args, **kwargs)\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 2370, in _execute\r\n    sql, params = self.sql()\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 2832, in sql\r\n    return self.compiler().generate_insert(self)\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 1733, in generate_insert\r\n    return self.build_query(clauses, alias_map)\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 1542, in build_query\r\n    return self.parse_node(Clause(*clauses), alias_map)\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 1503, in parse_node\r\n    sql, params, unknown = self._parse(node, alias_map, conv)\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 1478, in _parse\r\n    sql, params = self._parse_map[node_type](node, alias_map, conv)\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 1406, in _parse_clause\r\n    node.nodes, alias_map, conv, node.glue)\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 1520, in parse_node_list\r\n    node_sql, node_params = self.parse_node(node, alias_map, conv)\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 1503, in parse_node\r\n    sql, params, unknown = self._parse(node, alias_map, conv)\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 1478, in _parse\r\n    sql, params = self._parse_map[node_type](node, alias_map, conv)\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 1406, in _parse_clause\r\n    node.nodes, alias_map, conv, node.glue)\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 1520, in parse_node_list\r\n    node_sql, node_params = self.parse_node(node, alias_map, conv)\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 1503, in parse_node\r\n    sql, params, unknown = self._parse(node, alias_map, conv)\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 1478, in _parse\r\n    sql, params = self._parse_map[node_type](node, alias_map, conv)\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 1406, in _parse_clause\r\n    node.nodes, alias_map, conv, node.glue)\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 1520, in parse_node_list\r\n    node_sql, node_params = self.parse_node(node, alias_map, conv)\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 1503, in parse_node\r\n    sql, params, unknown = self._parse(node, alias_map, conv)\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 1478, in _parse\r\n    sql, params = self._parse_map[node_type](node, alias_map, conv)\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 1394, in _parse_param\r\n    params = [node.conv(node.value)]\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 1187, in db_value\r\n    return self.to_field.db_value(value)\r\n  File \"/usr/local/lib/python2.7/dist-packages/peewee.py\", line 787, in db_value\r\n    return value if value is None else self.coerce(value)\r\nValueError: invalid literal for int() with base 10: 'N3xLsL8kCGyBk7y5yXHdzH5oMo1wvf5xrhJDakIHf'\r\n```\r\n\r\nI think that it is something related to events recording:\r\n```\r\nTask redash.tasks.record_event[e51bc501-4600-4174-960d-10783b7d13ae] raised unexpected: ValueError(\"invalid literal for int() with base 10: 'N3xLsL8kCGyBk7y5yXHzH5oMo1wvf5xrhJDakIHf'\",)\r\n```\r\n\r\nI also think that it is strange to get so much `status=500` on the calls reported in the log.\r\n\r\nI have tried to reproduced the steps on the demo instance and it works just fine.\r\n\r\n### Steps to Reproduce\r\n\r\n1. Create a dashboard\r\n2. Create the public link by clicking on 'enable/disable share' and checking the 'allow public access' checkbox\r\n\r\n### Technical details:\r\n\r\n* Redash Version: 0.11.0\r\n* Browser/OS: Chrome\r\n* How did you install Redash: docker-compose\r\n"},"comment":{"url":"https://api.github.com/repos/getredash/redash/issues/comments/241057333","html_url":"https://github.com/getredash/redash/issues/1238#issuecomment-241057333","issue_url":"https://api.github.com/repos/getredash/redash/issues/1238","id":241057333,"user":{"login":"WesleyBatista","id":755254,"avatar_url":"https://avatars.githubusercontent.com/u/755254?v=3","gravatar_id":"","url":"https://api.github.com/users/WesleyBatista","html_url":"https://github.com/WesleyBatista","followers_url":"https://api.github.com/users/WesleyBatista/followers","following_url":"https://api.github.com/users/WesleyBatista/following{/other_user}","gists_url":"https://api.github.com/users/WesleyBatista/gists{/gist_id}","starred_url":"https://api.github.com/users/WesleyBatista/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/WesleyBatista/subscriptions","organizations_url":"https://api.github.com/users/WesleyBatista/orgs","repos_url":"https://api.github.com/users/WesleyBatista/repos","events_url":"https://api.github.com/users/WesleyBatista/events{/privacy}","received_events_url":"https://api.github.com/users/WesleyBatista/received_events","type":"User","site_admin":false},"created_at":"2016-08-19T15:54:46Z","updated_at":"2016-08-19T15:54:46Z","body":"I use docker. to see the logs I run `docker logs --since '2016-08-19' --tail=all -f redash`.\r\nWhere is located the **api_error.log**? Before using the docker the logs were located at `/opt/redash/logs`. \r\nThere are no files there anymore."}}
{"actor":{"display_login":"WesleyBatista"}}