MYSQL cluster issue: shutdown data node correctly breaks replication

I faced issue on mysql cluster (5.7.28), i shuted down properly vm6 (data nodes) and the mysql replication was broken, i’m trying to make the link bettwen the datanode down and the replication broken but i still can’t find the reason (below the relevant), is there someone who can help me to find the link

Slave: Got error 4009 ‘Cluster Failure’ from NDB Error_code: 1296 [Warning] Slave: Can’t lock file (errno: 157 – Could not connect to storage engine) Error_code: 1015 Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START".

How to fix caching issue in PHP data from database

Im trying to use the code belong for my plugin development but there is a caching issue (I think). Please below for the details.

Problem

I created filter to accept the customized url, and I’m querying the database but it seams like the result value is not changing in the browser but changing in the database. So basically the data passed is not returning the updated value from the database.

Code

add_action( 'init',  function() {     add_rewrite_rule('coupon/([a-zA-Z0-9]+)[/]?$  ', 'index.php?coupon=$  matches[1]', 'top'); });  add_filter('query_vars', function( $  query_vars ) {     $  query_vars[] = 'coupon';     return $  query_vars; });  add_action( 'template_include', function( $  template ) {     if ( get_query_var( 'coupon' ) == false || get_query_var( 'coupon' ) == '' ) {         return $  template;     }      ob_clean();     ob_start();      // Check if coupon exists     global $  wpdb;     $  coupon = get_query_var('coupon');      $  coupon_query = $  wpdb->prepare('SELECT * FROM wp_urls WHERE coupon = %s AND claimed_at IS NULL', $  coupon);     $  coupon_available = $  wpdb->query($  coupon_query) ? true : false;      if(!$  coupon_available) {         header('Location: /'); // Redirect to landing page         exit();     }          return plugin_dir_path(__FILE__) . 'views/client/index.php';; } ); 

index.php (Update function with the form)

After clicking submit button, the code below will run.

$  update_query = "UPDATE wp_urls SET                          `email` = %s,                          `phone_number` = %s,                          `first_name` = %s,                          `last_name` = %s,                          `message` = %s,                          `claimed_at` = %s                          WHERE `coupon` = %s";  //  Execute query $  wpdb->query($  wpdb->prepare($  update_query, $  placeholder_values)); 

Expected Result

The expected result should redirect the user to the header('Location: /'); if the coupon is not available.

Any idea?

HTML Issue with Twitter Card – What We are Missing

Hi,

i added to our website code of open graph and twitter …… so if we share to social media then pictures, title, description etc are coming properly in Facebook, Linkedin but On twitter image is missing …. While image URL in code id perfect.

If i am using any tools like buffer then images are coming properly and sharing also to properly to twitter but when i am sharing from website then twitter is not showing image.

Code are as below

<meta name="twitter:card"...
Code (markup):

HTML Issue with Twitter Card – What We are Missing

Is this issue with my mobile or the mobile menu is not working

hello friends,

I have made a bootstrap template https://www.webdesigncut.com/bootstrap4/25spa/index.html
but for some reasons when i open the wbesite on mobile the mobile menu and the preloader animation doesn't seem to work..although it works on several online browser testing website

when i open the website in my mobile ..i see this
[​IMG]
golf tdi 0 60
and the a javascript doesn't work at all to close the menu

any help will…

Is this issue with my mobile or the mobile menu is not working

JSON Creation Issue

I’m new to PostgreSQL database. Although I’ve good experience on Oracle Database. I’m facing issue while generating JSON from Postgres. I’ve tried to generate the same output but not able to achieve is properly. Can someone please help or guide may be with examples on similar problem. I’ll be very much thankful to you.

"PostgreSQL 12.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.3 20140911 (Red Hat 4.8.3-9), 64-bit"

Tables and Sample Data.

CREATE TABLE PARKING_LOT (       PARKING_LOT_ID      NUMERIC(10)      ,PARKING_LOT_NAME    VARCHAR(100) ) ;  CREATE TABLE PARKING_LOT_VEHICLE_CLASS_MAP (       PARKING_LOT_ID       NUMERIC(10)      ,VEHICLE_CLASS_ID     NUMERIC(10)      ,AVAILABLE_SLOT_COUNT NUMERIC(10) ) ;   CREATE TABLE PARKING_SLOT (       PARKING_LOT_ID          NUMERIC(10)      ,VEHICLE_CLASS_ID        NUMERIC(10)      ,PARKING_SLOT_ID         NUMERIC(10)      ,SLOT_OCCUPANCY_STATUS   NUMERIC(10) ) ;   INSERT INTO PARKING_LOT VALUES( 1, 'PARKING 1' ) ; INSERT INTO PARKING_LOT VALUES( 2, 'PARKING 2' ) ;  INSERT INTO PARKING_LOT_VEHICLE_CLASS_MAP VALUES( 1, 1, 10 ) ; INSERT INTO PARKING_LOT_VEHICLE_CLASS_MAP VALUES( 1, 1, 11 ) ; INSERT INTO PARKING_LOT_VEHICLE_CLASS_MAP VALUES( 2, 2, 12 ) ; INSERT INTO PARKING_LOT_VEHICLE_CLASS_MAP VALUES( 2, 2, 13 ) ;  INSERT INTO PARKING_SLOT VALUES( 2, 1, 1, 1 ) ; INSERT INTO PARKING_SLOT VALUES( 2, 1, 2, 1 ) ; INSERT INTO PARKING_SLOT VALUES( 2, 2, 3, 0 ) ; 

Desired Output

{    "ResHeader":{       "ResDate":"09-01-2021 12:38:20",       "ResID":"12345",       "ResName":"Occupancy",       "ResDesc":"Parking Lot Availability and Occupancy Status"    },    "ResDetail":[       {          "ParkingLotID":"1",          "ParkingLotName":"PARKING 1",          "ParkingLotOccupancySummary":[             {                "VehicleClassID":"1",                "AvailableSlotCount":"10"             },             {                "VehicleClassID":"2",                "AvailableSlotCount":"12"             }          ]       },       {          "ParkingLotID":"2",          "ParkingLotName":"PARKING 2",          "ParkingLotOccupancySummary":[             {                "VehicleClassID":"1",                "AvailableSlotCount":"5",                "SlotOccupancyDetails":[                   {                      "SlotID":"1",                      "OccupancyStatus":"1"                   },                   {                      "SlotID":"2",                      "OccupancyStatus":"1"                   }                ]             },             {                "VehicleClassID":"2",                "AvailableSlotCount":"7",                "SlotOccupancyDetails":[                   {                      "SlotID":"3",                      "OccupancyStatus":"0"                   }                ]             }          ]       }    ] } 

What I’m able to achieve till now in bits and pieces

WITH     HEAD AS     (         SELECT json_build_object( 'ResHeader', H ) HeaderData         FROM         (             SELECT                  TO_CHAR(CURRENT_TIMESTAMP, 'YYYY-MM-DD HH24:MI:SS.MS') "ResDate"                 ,1  "ResID"         ) H     ) SELECT * FROM HEAD H  SELECT X.PARKING_LOT_ID, row_to_json(X) FROM (     SELECT VCM.PARKING_LOT_ID, VCM.VEHICLE_CLASS_ID  "VehicleClassID"     FROM PARKING_LOT_VEHICLE_CLASS_MAP2 VCM     LEFT OUTER JOIN PARKING_SLOT2 PS     ON VCM.PARKING_LOT_ID = PS.PARKING_LOT_ID ) X 

Regards Manoj

Automator issue

Hello Scrapebox team, I’m using Automator plugin and I have a problem.

I load some .txt file lists from gsa ser to Outbound link checker via Automator and sometimes if file does not saved on folder, then Automator doesn’t find it and it stops and gives this message:

https://ibb.co/ygLrmfY

Is it possible to pass the file and continue to others?

Is it possible to update it please?

Thank you
Chris

Why would “dice sharing” be an issue at a game? [closed]

Tasha’s Cauldron of Everything, page 141 says the following (emphasis mine):

Common in-game limits include – but are not limited to – […]
Common out-of-game limits include unwanted physical contact, dice-sharing, dice-throwing, shouting, vulgarity, […].

All of these make sense to me, except for dice sharing. Why would people find dice sharing offensive? What about it would be offensive? Would it be forcing a player to use your dice, or forcing a player to share their dice? Or would it just be someone would be offended by you sharing your dice with someone?

Unity – Root Motion Physic Material Issue

I have a slope with an "icy" physic material with 0 static and dynamic friction. I also have this same physic material set to my model’s capsule collider. The model’s rigid body has a mass of 10.

When the penguin preforms its root motion belly slide on the ice, I expect the physics engine to do its work and see the penguin slide down the slope. However, I instead see a slow, sort of inching down the slope as shown in linked video. When I turn root motion off, the sliding works as expected.

What is going on here? What about root motion would be causing this?

I have tried a slew of root transform position baking options (including y) and it seems none make any difference.

Any insight is much appreciated! Thanks.

possible corruption or other issue that doesnt show on basic scans?

I have a WP table with about 33000 records that suddenly is taking more than a minute to query. According to optimization tools, everything is good but given the sudden nature of the trouble, I doubt that. We went from those tables taking way less than second to query to between 48-93 seconds now each time. Have confirmed no other load on the server slowing it down so its all down to this. Looking for other places to look or check given the issues?