mysql warning "Truncated incorrect DOUBLE value"

[lxyu]

I keep getting this warning with sentry server. Any idea how to solve it?

/srv/virtualenvs/sentryenv/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py:114: Warning: Truncated incorrect DOUBLE value: '2012-11-02T08:44:47.000000Z'
  return self.cursor.execute(query, args)

[dcramer]

I'm not sure what column it'd be failing on off hand. What version of MySQL?

You could try this to get a full error:

http://stackoverflow.com/questions/2102251/trapping-a-mysql-warning

David Cramer

twitter.com/zeeg
disqus.com/zeeg

On Friday, November 2, 2012 at 1:55 AM, Lx Yu wrote:

I keep getting this warning with sentry server. Any idea how to solve it?
/srv/virtualenvs/sentryenv/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py:114: Warning: Truncated incorrect DOUBLE value: '2012-11-02T08:44:47.000000Z' return self.cursor.execute(query, args)

—
Reply to this email directly or view it on GitHub (#643).

[lxyu]

$ mysql -v
Server version: 5.5.28-0ubuntu0.12.04.2-log (Ubuntu)

And

$ pip freeze
MySQL-python==1.2.4b5

FYI, I start an UDP server to receive log and a http server for web view. The warning pop up in the http server part. So it may be somewhere in the frontend.

Hmm, warnings are just warnings, may be I shall just ignore them.

[dcramer]

Well a warning is definitely suggesting we're inserting something incorrectly, I just need to know what that something is

David Cramer

twitter.com/zeeg
disqus.com/zeeg

On Friday, November 2, 2012 at 2:12 AM, Lx Yu wrote:

$ mysql -v Server version: 5.5.28-0ubuntu0.12.04.2-log (Ubuntu)

And
$ pip freeze MySQL-python==1.2.4b5

FYI, I start an UDP server to receive log and a http server for web view. The warning pop up in the http server part. So it may be somewhere in the frontend.
Hmm, warnings are just warnings, may be I shall just ignore them.

—
Reply to this email directly or view it on GitHub (#643 (comment)).

[lxyu]

Yeah, I'm glad to help. So what shall I do to get more information? I get no idea where the error from and how to locate it.

[lxyu]

Here's a more complete log, hope it helps.

$ sentry --config=sentry.conf.py start
Performing upgrade before service startup...
Syncing...
Creating tables ...
Installing custom SQL ...
Installing indexes ...
Installed 0 object(s) from 0 fixture(s)
Migrating...
Running migrations for djcelery:
- Nothing to migrate.
 - Loading initial data for djcelery.
Installed 0 object(s) from 0 fixture(s)
Running migrations for django:
- Nothing to migrate.
 - Loading initial data for django.
Installed 0 object(s) from 0 fixture(s)
Running migrations for django:
- Nothing to migrate.
 - Loading initial data for django.
Installed 0 object(s) from 0 fixture(s)
Running migrations for sentry:
- Nothing to migrate.
 - Loading initial data for sentry.
Installed 0 object(s) from 0 fixture(s)

Synced:
 > django.contrib.auth
 > django.contrib.admin
 > django.contrib.contenttypes
 > django.contrib.sessions
 > django.contrib.sites
 > django.contrib.messages
 > crispy_forms
 > sentry.plugins.sentry_mail
 > sentry.plugins.sentry_servers
 > sentry.plugins.sentry_urls
 > sentry.plugins.sentry_user_emails
 > sentry.plugins.sentry_useragents
 > social_auth
 > south

Migrated:
 - djcelery
 - kombu.transport.django
 - raven.contrib.django
 - sentry
Running service: 'http'
2012-11-02 13:23:07 [29988] [INFO] Starting gunicorn 0.15.0
Starting gunicorn 0.15.0
2012-11-02 13:23:07 [29988] [INFO] Listening at: http://0.0.0.0:8000 (29988)
Listening at: http://0.0.0.0:8000 (29988)
2012-11-02 13:23:07 [29988] [INFO] Using worker: sync
Using worker: sync
2012-11-02 13:23:07 [29998] [INFO] Booting worker with pid: 29998
Booting worker with pid: 29998
2012-11-02 13:23:07 [29999] [INFO] Booting worker with pid: 29999
Booting worker with pid: 29999
/srv/virtualenvs/sentryenv/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py:114: Warning: Truncated incorrect DOUBLE value: '2012-11-02T09:29:23.000000Z'
  return self.cursor.execute(query, args)
/srv/virtualenvs/sentryenv/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py:114: Warning: Truncated incorrect DOUBLE value: '2012-11-02T09:29:23.000000Z'
  return self.cursor.execute(query, args)

[mwaterfall]

I'm experiencing this too. I tracked the SQL statement that causes the warning but it doesn't seem to be consistent. The same query only seems to trigger the warning a few times when browsing the stream view of the server.

Query:

SELECT (sentry_groupedmessage.last_seen) AS `sort_value`, `sentry_groupedmessage`.`id`, `sentry_groupedmessage`.`project_id`, `sentry_groupedmessage`.`logger`, `sentry_groupedmessage`.`level`, `sentry_groupedmessage`.`message`, `sentry_groupedmessage`.`view`, `sentry_groupedmessage`.`checksum`, `sentry_groupedmessage`.`data`, `sentry_groupedmessage`.`status`, `sentry_groupedmessage`.`times_seen`, `sentry_groupedmessage`.`last_seen`, `sentry_groupedmessage`.`first_seen`, `sentry_groupedmessage`.`resolved_at`, `sentry_groupedmessage`.`active_at`, `sentry_groupedmessage`.`time_spent_total`, `sentry_groupedmessage`.`time_spent_count`, `sentry_groupedmessage`.`score`, `sentry_groupedmessage`.`is_public` 
FROM `sentry_groupedmessage` 
WHERE (`sentry_groupedmessage`.`project_id` = %s  AND `sentry_groupedmessage`.`status` = %s  AND `sentry_groupedmessage`.`last_seen` >= %s  AND UNIX_TIMESTAMP(sentry_groupedmessage.last_seen) > %s) 
ORDER BY `sort_value` DESC, `sentry_groupedmessage`.`last_seen` DESC 
LIMIT 15

Args:

(2, 0, u'2012-11-30 17:26:58', u'2012-12-03T17:03:27.000000Z')

Warning:

/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/django/db/backends/mysql/base.py:116: Warning: Truncated incorrect DOUBLE value: '2012-12-03T17:03:27.000000Z'
  return self.cursor.execute(query, args)

Traceback:

  File "/Users/mwaterfall/.virtualenvs/myapp/bin/sentry", line 9, in <module>
    load_entry_point('sentry==5.0.21', 'console_scripts', 'sentry')()
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/sentry/utils/runner.py", line 150, in main
    initializer=initialize_app,
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/logan/runner.py", line 136, in run_app
    management.execute_from_command_line([runner_name, command] + command_args)
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/django/core/management/__init__.py", line 443, in execute_from_command_line
    utility.execute()
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/django/core/management/__init__.py", line 382, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/django/core/management/base.py", line 196, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/django/core/management/base.py", line 232, in execute
    output = self.handle(*args, **options)
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/sentry/management/commands/start.py", line 78, in handle
    service.run()
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/sentry/services/http.py", line 46, in run
    call_command('run_gunicorn', **self.options)
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/django/core/management/__init__.py", line 150, in call_command
    return klass.execute(*args, **defaults)
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/django/core/management/base.py", line 232, in execute
    output = self.handle(*args, **options)
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/gunicorn/management/commands/run_gunicorn.py", line 100, in handle
    DjangoApplicationCommand(options, admin_media_path).run()
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/gunicorn/app/base.py", line 127, in run
    Arbiter(self).run()
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/gunicorn/arbiter.py", line 165, in run
    self.manage_workers()
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/gunicorn/arbiter.py", line 444, in manage_workers
    self.spawn_workers()
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/gunicorn/arbiter.py", line 496, in spawn_workers
    self.spawn_worker()
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/gunicorn/arbiter.py", line 469, in spawn_worker
    worker.init_process()
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/gunicorn/workers/base.py", line 104, in init_process
    self.run()
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/gunicorn/workers/sync.py", line 37, in run
    self.handle(client, addr)
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/gunicorn/workers/sync.py", line 73, in handle
    self.handle_request(req, client, addr)
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/gunicorn/workers/sync.py", line 103, in handle_request
    respiter = self.wsgi(environ, resp.start_response)
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/django/contrib/staticfiles/handlers.py", line 67, in __call__
    return self.application(environ, start_response)
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/django/core/handlers/wsgi.py", line 241, in __call__
    response = self.get_response(request)
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/django/core/handlers/base.py", line 111, in get_response
    response = callback(request, *callback_args, **callback_kwargs)
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/django/views/decorators/csrf.py", line 77, in wrapped_view
    return view_func(*args, **kwargs)
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/sentry/web/decorators.py", line 65, in _wrapped
    return func(request, project, *args, **kwargs)
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/django/views/decorators/cache.py", line 89, in _wrapped_view_func
    response = view_func(request, *args, **kwargs)
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/sentry/web/api.py", line 222, in poll
    event_list = list(event_list[offset:limit])
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/django/db/models/query.py", line 87, in __len__
    self._result_cache.extend(self._iter)
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/django/db/models/query.py", line 291, in iterator
    for row in compiler.results_iter():
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 763, in results_iter
    for rows in self.execute_sql(MULTI):
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/django/db/models/sql/compiler.py", line 818, in execute_sql
    cursor.execute(sql, params)
  File "/Users/mwaterfall/.virtualenvs/myapp/lib/python2.7/site-packages/django/db/backends/mysql/base.py", line 118, in execute
    print traceback.print_stack()
None

[bmaynard]

I am also experiencing this issue that is exactly the same as the comment above.

After some debugging I believe its because the last parameter field gets converted to UNIX_TIMESTAMP.

WHERE (`sentry_groupedmessage`.`project_id` = %s  AND `sentry_groupedmessage`.`status` = %s  AND `sentry_groupedmessage`.`last_seen` >= %s  AND UNIX_TIMESTAMP(sentry_groupedmessage.last_seen) > %s) 

[dcramer]

This should be a pretty quick fix. Will get this corrected for the upcoming 5.1 release

[hslewis]

Is this fixed now? I'm still seeing this (Sentry version 5.1.2)

[pr4th4m]

Even I am getting this error, is this fixed ? Or is there any work around for this ?

[dim0]

Same issue here:
/opt/sentry/lib/python2.6/site-packages/Django-1.4.3-py2.6.egg/django/db/backends/mysql/base.py:114: Warning: Truncated incorrect DOUBLE value: '2013-02-28T10:27:36.000000Z'
return self.cursor.execute(query, args)

[davecoutts]

Same issue here:

For each event I get:

/home/dave/.virtualenvs/sentry/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py:114: Warning: Truncated incorrect DOUBLE value: '2013-03-08T20:29:40.000000Z'
  return self.cursor.execute(query, args)

Supporting info:

'ENGINE': 'django.db.backends.mysql',

mkvirtualenv sentry -i MySQL-python -i sentry

BeautifulSoup==3.2.1
Django==1.4.5
MySQL-python==1.2.4
Pygments==1.6
South==0.7.6
amqp==1.0.9
anyjson==0.3.3
argparse==1.2.1
billiard==2.7.3.22
celery==3.0.16
cssutils==0.9.10b1
django-celery==3.0.11
django-crispy-forms==1.2.3
django-indexer==0.3.0
django-paging==0.2.4
django-picklefield==0.3.0
django-social-auth==0.7.22
django-social-auth-trello==1.0.3
django-static-compiler==0.3.1
django-templatetag-sugar==0.1
gunicorn==0.17.2
httpagentparser==1.2.2
httplib2==0.8
kombu==2.5.7
logan==0.5.4
oauth2==1.5.211
pynliner==0.4.0
python-dateutil==1.5
python-openid==2.2.5
pytz==2012j
raven==3.1.17
requests==1.1.0
sentry==5.4.4
sentry-pushover==1.0.2
setproctitle==1.1.7
simplejson==3.1.0
six==1.2.0
wsgiref==0.1.2
yolk==0.4.3

Python 2.7.3
Ubuntu 12.04.2 LTS
mysql Ver 14.14 Distrib 5.5.29, for debian-linux-gnu (x86_64) using readline 6.2

[olevinsky]

The same warning, sentry==5.4.4

[mwaterfall]

Still getting this issue in 5.4.5!

[dcramer]

Please reopen if this is still a problem