{"id":69,"date":"2008-10-01T11:37:27","date_gmt":"2008-10-01T17:37:27","guid":{"rendered":"http:\/\/thenoyes.com\/littlenoise\/?p=69"},"modified":"2008-10-01T11:38:00","modified_gmt":"2008-10-01T17:38:00","slug":"a-parting-shot","status":"publish","type":"post","link":"https:\/\/thenoyes.com\/littlenoise\/?p=69","title":{"rendered":"A Parting Shot"},"content":{"rendered":"
mysql> INSERT IGNORE INTO trickyTable (id) VALUES (1);\r\nQuery OK, 0 rows affected (0.00 sec)\r\n\r\nmysql> SELECT * FROM trickyTable;\r\nEmpty set (0.00 sec)<\/pre>\n
That’s odd – what happened to the row?<\/p>\n
I have the necessary privileges:<\/p>\n
mysql> SHOW GRANTS;\r\n+---------------------------------------------------+\r\n| Grants for root@localhost                         |\r\n+---------------------------------------------------+\r\n| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' |\r\n+---------------------------------------------------+\r\n1 row in set (0.00 sec)<\/pre>\n
The table exists:<\/p>\n
mysql> SHOW TABLES;\r\n+------------------------+\r\n| Tables_in_example      |\r\n+------------------------+\r\n| trickytable            |\r\n+------------------------+\r\n1 row in set (0.00 sec)<\/pre>\n
The field is there and adequately typed for the value:<\/p>\n
mysql> DESCRIBE trickyTable;\r\n+-------+---------+------+-----+---------+-------+\r\n| Field | Type    | Null | Key | Default | Extra |\r\n+-------+---------+------+-----+---------+-------+\r\n| id    | int(11) | YES  |     | NULL    |       |\r\n+-------+---------+------+-----+---------+-------+\r\n1 row in set (0.02 sec)<\/pre>\n
Not using BLACKHOLE, and no transaction tricks:<\/p>\n
mysql> SELECT engine FROM information_schema.tables WHERE table_name = 'trickyTable';\r\n+--------+\r\n| engine |\r\n+--------+\r\n| MyISAM |\r\n+--------+\r\n1 row in set (0.00 sec)<\/pre>\n
No triggers to make things tricky:<\/p>\n
mysql> SELECT * FROM information_schema.triggers WHERE event_object_table = 'trickyTable';\r\nEmpty set (0.00 sec)<\/pre>\n
Just take my word for it that I’m not using Proxy, and this has nothing to do with replication.<\/p>\n","protected":false},"excerpt":{"rendered":"
mysql> INSERT IGNORE INTO trickyTable (id) VALUES (1); Query OK, 0 rows affected (0.00 sec) mysql> SELECT * FROM trickyTable; Empty set (0.00 sec) That’s odd – what happened to the row? I have the necessary privileges: mysql> SHOW GRANTS; +—————————————————+ | Grants for root@localhost | +—————————————————+ | GRANT ALL PRIVILEGES ON *.* TO ‘root’@’localhost’ […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[6],"tags":[],"class_list":["post-69","post","type-post","status-publish","format-standard","hentry","category-gotchas"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p2IBF1-17","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/posts\/69","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=69"}],"version-history":[{"count":0,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/posts\/69\/revisions"}],"wp:attachment":[{"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=69"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=69"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=69"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}