commit 753f04a0e9fc9da857623dc14d5f8f5bce3eb0bc
author Marco Nelissen <marcone@google.com> Mon Jul 23 13:59:53 2012 -0700
committer Marco Nelissen <marcone@google.com> Mon Jul 23 14:02:14 2012 -0700
tree fb2041146a699f26584bf877c35b4e7fe880e6cc
parent d7ae855c99e8ee7a46d84d33117f7abe95fa20f4

Use fractional seconds for timestamp

This should prevent key uniqueness issues like in b/6700936

Change-Id: Ie0416024f39b2e2c4a84512adede55b4a49755d4

src/com/android/providers/media/MediaProvider.java

diff --git a/src/com/android/providers/media/MediaProvider.java b/src/com/android/providers/media/MediaProvider.java
index c5d15b1..3434089 100644
--- a/src/com/android/providers/media/MediaProvider.java
+++ b/src/com/android/providers/media/MediaProvider.java
@@ -1733,7 +1733,7 @@
      * Write a persistent diagnostic message to the log table.
      */
     static void logToDb(SQLiteDatabase db, String message) {
-        db.execSQL("INSERT INTO log (time, message) VALUES (datetime('now'),?);",
+        db.execSQL("INSERT INTO log (time,message) VALUES (strftime('%Y-%m-%d %H:%M:%f','now'),?);",
                 new String[] { message });
         // delete all but the last 500 rows
         db.execSQL("DELETE FROM log WHERE rowid IN" +