Uncaught Exception: Unable to execute statement: column name is not unique

  • Resolved Aharon

    (@spaceling)


    1 year, 7 months ago

    Thank you for this software — it seems to be working from what I can tell from the cache statistics. But perhaps you might have some insight into the following error being reported in our error_log:

    #7 /home/.../.../.../wp-content/object-cache.php on line 1296
#6 /home/.../.../.../wp-includes/post.php(7438): update_post_cache(Array)
#5 /home/.../.../.../wp-includes/post.php(7358): wp_cache_add_multiple(Array, 'posts')
#4 /home/.../.../.../wp-content/object-cache.php(1902): WP_Object_Cache->add_multiple(Array, 'posts', 0)
#3 /home/.../.../.../wp-content/object-cache.php(1047): WP_Object_Cache->add(24151, Object(stdClass), 'posts', 0)
#2 /home/.../.../.../wp-content/object-cache.php(1092): WP_Object_Cache->set(24151, Object(stdClass), 'posts', 0)
#1 /home/.../.../.../wp-content/object-cache.php(1239): WP_Object_Cache->handle_put(24151, Object(stdClass), 'posts', 0)
#0 /home/.../.../.../wp-content/object-cache.php(1296): SQLite3Stmt->execute()
Stack trace:
[18-Jan-2023 21:36:20 UTC] PHP Fatal error: Uncaught Exception: Unable to execute statement: column name is not unique in /home/.../.../.../wp-content/object-cache.php:1296

    In case it is relevant:
    WP Version: 6.1.1; PHP Version: 7.4.33; SQLite: 3.7.17; Database Version: 5.7.41.
    Jetpack 11.7.1 with Jetpack Boost 1.7.0. WP Supercache 1.9.2
    Performance Lab (disabled).

    • This topic was modified 1 year, 7 months ago by Aharon. Reason: adding the SQLite version if pertinent

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author OllieJones

    (@olliejones)

    1 year, 7 months ago

    You found a bug. Thanks! And thanks for adding the SQLite version. It is indeed relevant.

    Darn it! — I thought I defeated that particular one. It’s something to do with SQLite 3.7, and how it handles unique keys in tables.

    I’m near to releasing a new version, so your report is timely.

    (Squeeeeeee …. the sound of the bug-zapper charging up … )

    Thread Starter Aharon

    (@spaceling)

    1 year, 7 months ago

    Thank you Ollie. It’s good to know I’m helping. I’m looking now through the other error logs and I’m finding similar “unable to execute” errors (either ‘column is not unique‘ or ‘database is locked‘). Copying these below just in case they offer any additional clues.

    This one is from the root error log:

    #0 /home/.../.../.../wp-content/object-cache.php(1296): SQLite3Stmt->execute()
#1 /home/.../.../.../wp-content/object-cache.php(1239): WP_Object_Cache->handle_put('get_page_by_pat...', 0, 'posts', 0)
#2 /home/.../.../.../wp-content/object-cache.php(1950): WP_Object_Cache->set('get_page_by_pat...', 0, 'posts', 0)
#3 /home/.../.../.../wp-includes/post.php(5747): wp_cache_set('get_page_by_pat...', 0, 'posts')
#4 /home/.../.../.../wp-includes/class-wp.php(239): get_page_by_path('compilations/li...')
#5 /home/.../.../.../wp-includes/class-wp.php(780): WP->parse_request('')
#6 /home/.../.../.../wp-includes/functions.php(1332): WP->main('')
#7 /home/.../.../.../wp-blog-header.php(16): wp()
#8 /home/. in /home/.../.../.../wp-content/object-cache.php on line 1296
[19-Jan-2023 03:29:43 UTC] PHP Fatal error: Uncaught Exception: Unable to execute statement: database is locked in /home/.../.../.../wp-content/object-cache.php:1178
Stack trace:
#0 /home/.../.../.../wp-content/object-cache.php(1178): SQLite3Stmt->execute()
#1 /home/.../.../.../wp-content/object-cache.php(1142): WP_Object_Cache->getone('get_page_by_pat...', 'posts')
#2 /home/.../.../.../wp-content/object-cache.php(1428): WP_Object_Cache->cache_item_exists('get_page_by_pat...', 'posts')
#3 /home/.../.../.../wp-content/object-cache.php(1994): WP_Object_Cache->get('get_page_by_pat...', 'posts', false, NULL)
#4 /home/.../.../.../wp-includes/post.php(5680): wp_cache_get('get_page_by_pat...', 'posts')
#5 /home/.../.../.../wp-includes/class-wp.php(239): get_page_by_path('prayers/lunisol...')
#6 /home/.../.../.../wp-includes/class-wp.php(780): WP->parse_request('')
#7 /home/.../.../... in /home/.../.../.../wp-content/object-cache.php on line 1178

    This one is from the error log in wp_admin:

    [19-Jan-2023 04:51:52 UTC] PHP Fatal error: Uncaught Exception: Unable to execute statement: column name is not unique in /home/.../.../.../wp-content/object-cache.php:1296
Stack trace:
#0 /home/.../.../.../wp-content/object-cache.php(1296): SQLite3Stmt->execute()
#1 /home/.../.../.../wp-content/object-cache.php(1239): WP_Object_Cache->handle_put('wp_query:8d3851...', Array, 'posts', 0)
#2 /home/.../.../.../wp-content/object-cache.php(1950): WP_Object_Cache->set('wp_query:8d3851...', Array, 'posts', 0)
#3 /home/.../.../.../wp-includes/class-wp-query.php(3292): wp_cache_set('wp_query:8d3851...', Array, 'posts')
#4 /home/.../.../.../wp-includes/class-wp-query.php(3749): WP_Query->get_posts()
#5 /home/.../.../.../wp-content/plugins/contact-form-7/includes/contact-form.php(89): WP_Query->query(Array)
#6 /home/.../.../.../wp-content/plugins/contact-form-7/includes/block-editor/block-editor.php(58): W in /home/.../.../.../wp-content/object-cache.php on line 1296
    Plugin Author OllieJones

    (@olliejones)

    1 year, 7 months ago

    Thanks again for the report!

    Tracked here. https://github.com/OllieJones/sqlite-object-cache/issues/9

    Plugin Author OllieJones

    (@olliejones)

    1 year, 7 months ago

    Fixed in v1.1.0

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Uncaught Exception: Unable to execute statement: column name is not unique’ is closed to new replies.