Can’t remove “synchronizing/suspect” database after removed from availability group Sql Server 2019 Enterprise

I’ve removed a db from a synchronous availability group.The db shows "synchronizing/suspect" as it should. I’m trying to remove this database cannot. I have tried:

DROP DATABASE [db1]; 

but get "Cannot drop database "db1" because it is currently in use.". even though their are no sessions using this database.

ALTER DATABASE [db1] SET OFFLINE; 

but get "ALTER DATABASE failed because a lock could not be placed on database ‘db1’. Try again later."

ALTER DATABASE [db1] SET SINGLE_USER WITH ROLLBACK IMMEDIATE 

but get "ALTER DATABASE failed because a lock could not be placed on database ‘db1’. Try again later."

ALTER DATABASE [db1] SET EMERGENCY; 

ALTER DATABASE failed because a lock could not be placed on database ‘db1’. Try again later.

This is a 24/7 production db and restarting is not a good option.

Any advice?

How to insert ads after an “h2, p, h3, etc…” tag

This code below is well known on the internet, I tried several times to change it and make it not only count the

tag as a paragraph, but the , , etc. tags. Does anyone have an idea how to do this?

Insert ad after second paragraph of single post content.

function prefix_insert_after_paragraph2( $ ads, $ content ) { if ( ! is_array( $ ads ) ) { return $ content; } $ closing_p = ‘

‘; $ paragraphs = explode( $ closing_p, $ content );

foreach ($  paragraphs as $  index => $  paragraph) {     if ( trim( $  paragraph ) ) {         $  paragraphs[$  index] .= $  closing_p;     }      $  n = $  index + 1;      if ( isset( $  ads[ $  n ] ) ) {         $  paragraphs[$  index] .= $  ads[ $  n ];     } }  return implode( '', $  paragraphs ); 

}

add_filter( ‘the_content’, ‘prefix_insert_post_ads’ );

function prefix_insert_post_ads( $ content ) { if ( is_single() && ! is_admin() ) { $ content = prefix_insert_after_paragraph2( array( // The format is: ‘{PARAGRAPH_NUMBER}’ => ‘AD_CODE’, ‘1’ => ‘ ad code 1 goes here ‘, ‘6’ => ‘ ad code 2 goes here’, ), $ content ); }

return $  content; 

}

the_content() printing site title after page/post title and before its content

My pages are all showing the Site Title (from the Customizer) after the page or post title and before the "body" of the post. Troubleshooting by injecting lines of text to print before and after WordPress code narrows the source down to the the_content() call within the page template.

Here’s how the_content is called:

        ...         </header><!-- .entry-header -->          <div class="content entry-content">             <?php the_content(                 // Translators: %s: Name of current post. Only visible to screen readers.                 sprintf( esc_html__( 'Continue reading %s', 'bulmapress' ), '<span class="screen-reader-text">' . the_title( '', '', false ) . '</span>' )             );              wp_link_pages( array(                 'before' => '<div class="page-links">' . esc_html__( 'Pages:', 'bulmapress' ),                 'after'  => '</div>',                 ) );                 ?>         </div><!-- .entry-content -->          <footer class="content entry-footer">         ... 

I’m a bit baffled because post_template.php where the_content() and get_the_content() are defined is a WordPress /includes file, not a parent theme file.

Should I be looking for some filter that’s been defined in the theme? TIA

AAD users lose access to database after import

I googled for the last few days but I got a bit confused and I do not know how to proceed further. Also, I’m not a DBA and I was just faced with this situation for the first time. Using sqlpackage.exe I’m exporting a bacpac from a PRD DB and import it on another server to refresh the lower environments. The original database is contained. After I’m importing the new database, the contained database users and the AAD external ones lose access to the new database. I’m fixing the contained database user by updating its password with

ALTER USER [RandomUser] WITH PASSWORD='randomPassword' 

but I am not sure what to do with the AAD users. They have an external user created for them (the aad users are placed inside a group). So far my option is to drop the said user and recreate it

CREATE USER [sthRandom] FROM EXTERNAL PROVIDER 

but in order to do this, you have to be connected with an AAD user

Principal 'sthRandom' could not be created. Only connections established with Active Directory accounts can create other Active Directory users. 

I have to automate this whole process so I could use a service principal like this. I’m creating the service principal inside all the databases, but after refresh the user won’t exist anymore, or I create it in the PRD database too, but I can not use it to login anymore.

What other options do I have? Thanks

Unity DontDestroyOnLoad not always working after Android build

I’ve been using this small script as a component to any object I want to not be destroyed at scene loading.

public class DontDestroy : MonoBehaviour {     void Start()     {         DontDestroyOnLoad(gameObject);     } } 

It has been working fine. It works for my GameOver canvas which I’ve been using for a long time whilst making the game.

Today I added the same script to a new AndroidControls Canvas I made. In the Editor it worked fine. Then I built it for Android to run on my physical phone (Galaxy S10). It gave me a Null exception.

It turned out to be caused by the AndroidControls Canvas being destroyed between scene loading (even though as I say, I tested in Editor for a few runs and it didnt get destroyed). And it gets a little weirder because after the attempted build to APK, and fail on physical device, it then failed to work in the editor. It continues to not work in each test after this in Editor, however if I remove the component and add it again, the entire process then repeats.

Please help as I don’t have a clue how to start fixing this. The only thing I can imagine it being wrong is it started as soon as I used this script on two canvas’s simultaneously. (I highly doubt I am correct but it’s the only thing I could notice at all that might be causing this).

This picture actually shows my DontDestroy component is attached to Canvas_AndroidControls, but in the Hierarchy you can already see that it is not in the DontDestroyOnLoad section (excuse the pink overlay for play-mode):

enter image description here

Maybe relevant, here are some of my specs:

Win 10 Unity 2020.3.5f1 (Just downloaded NDK/SDK for Android today via Unity Modules) Android 11 (Samsung Galaxy S10) 

After mysql 8.0.24 does master-slave replication, if the master database hangs, how does the slave database switch to the master database?

After mysql 8.0.24 does master-slave replication, if the master database hangs, how does the slave database switch to the master database? If it can switch, what are the exact steps?

If switching is not possible, what mode can be used so that if a primary database hangs, another database, which is synchronised with the primary database in real time, can operate normally and can be read and written to?

After new user logs in or signs up, make a POST call in WordPress

What I am trying to achieve is this: after a user either signs in or signs up on my e-commerce site, I want to trigger a POST call to an endpoint on POSTMAN that will show the data like username, email, password, etc.

I am new to WordPress development so can someone help guide me to where to access the code on WordPress and furthermore make this POST call? Any help is much appreciated!

Also, I am using Woo Commerce if that factors in at all

Problem with the Rank of a matrix after a FindRoot

I am solving a boundary problem defined by a set of four-component vectorial functions. Without going into many details, I have two functions on the left and two on the right of an interface. The boundary problem is defined by requiring that the sum of the two functions on the left is equal to the sum of the two on the right when the functions are evaluated at the position of the interface. The various components of the functions are given by confluent hypergeometric functions of the first and second kind. A similar problem is studied in this work but with two-components functions "L. Cohnitz, A. De Martino, W. Häusler, and R. Egger, Phys. Rev. B 94, 165443 (2016) [https://arxiv.org/pdf/1608.03469.pdf]".

The problem admits a unique solution when the determinant of the matrix associated with the 4 functions is zero. There is a free parameter $ j$ and for a given value of it, I can determine with FindRoot the associated value of the energy $ \mathcal{E}$ . For this pair of number, the determinant is smaller than $ 10^{-10}$ , however, the rank of the associated matrix is not reduced to 3 but is still 4. To reduce the Rank of the matrix, I need to work around the solution $ \mathcal{E}$ , until the determinant is not smaller than $ 10^{-16}$ !

Is there any solution around this problem. I am happy to give additional details if necessary, I am not posting the code because is pretty long at the moment.

ODBC Calling Fill – Unexpected closed connection after 2 hours

Using PostgreSQL 12.3 (Ubuntu 12.3-1.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit I use driver PostgresSQL Unicode(x64) version 13.00.00.00

I have a query that is executed through an ODBC connection in a Powershell 5.1 script. I use the Fill() method to retreive about 3500 records daily. When the script works, it takes 2-5 minutes to execute and retrieve data when it works. Problem is that the script "fails" half of the time approx. When this occurs, the Powershell script does stop only after 2h and 30 seconds.

We double checked the postgres logs and when this occurs, we see that the query successfully completed within 6 minutes always. I don’t know what to look for. any Idea?

Below is the error got:

Executed as user: NT Service\SQLSERVERAGENT. A job step received an error at line 94 in a PowerShell script. The corresponding line is ‘(New-Object system.Data.odbc.odbcDataAdapter($ cmd)).fill($ ds) | out-null ‘. Correct the script and reschedule the job. The error information returned by PowerShell is: ‘Exception calling "Fill" with "1" argument(s): "The connection has been disabled." ‘. Process Exit Code -1.

Not too familiar with postgreSQL.

Thanks!

SSRS reports resets the parameters to default after I click on “View Report”

We are using SSRS version 16(build 13.0.x) in Native mode.

I built a report using Report Builder with 2 parameters(independent). Everything works as it should when I run the report in Report Builder.

When I publish it to WebPortal – some random set of users have the following issue:

  1. Through WebPortal URL, they click on the report to open in browser, we have always used chrome.
  2. They populate the parameters and click on "View Report".
  3. The report starts "Loading" and immediately the parameters are reset to default(or blank) and the report area goes blank. They couldn’t even see the column header or the menu bar in the report area.

Apart from a handful of seemingly random users, everyone else have no issues.

We use SQL accounts for authentication and all users have permissions to fetch data from tables. I checked if this issue is only with certain kind of parameters, but there seems to no common denominator.

I’ve come up dry on PowerBI, Technet forums. I appreciate any help/troubleshooting steps. Thanks 🙂