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:


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


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


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


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?

Failover an Availability Group during a backup

This is a scenario I hope won’t happen, but if I was to perform a manual failover on an availability group halfway through a database backup will this cause the backup to fail or would it continue? I’ve been looking through MS documentation but can’t find this specific case.

I’m running SQL 2017 in an active – active environment with the listener in a third location. (synchronous commit)

(Backups are utilizing the Ola Hallengren scripts)

Availability Group- Redo Rate displayed on AG Dashboard vs Perfmon counter

I am bit confused on checking the metrics for REDO Rate KB/Sec from Always on AG dashboard which for some scenarios matches with perfmon counter Database replica : Redone Bytes/Sec ( hopefully its correct counter for redo rate via perfmon) and sometimes not at all.

Most of the times when there is lot of activity ongoing, my belief is that AG dashboard and DMV shows REDO rate for e.g. 40 MB/Secs at given time which matches with perfmon counter.

However during less activity time or nothing much to send over to sec, REDO Rate on Dashboard and dmv seems to be showing incorrect values compared to perfmon counter.

Not able to understand which value is correct and how to analyze. Any idea why or is it bug in dashboard?

Can a group be cleaned?

Hi Sven, simple query:
I have a group that contains 9 projects, I want to do a weekly cache clean to each project.
Can I do the cache clearing directly to the group? to remove all caches from each project or do I have to manually do each project?

PostgreSQL COPY TO doesn’t honor Linux group privileges

I have issues executing COPY to command, receiving below error msg:

ERROR: could not open file "/home/pgsql/TMP/out.txt" for writing: Permission denied

  • Postgres engine is being run as postgres user
  • Postgres user belongs to app group
  • TMP folder has below priviledges set:

drwxrws— 2 pgsql app 23 Mar 28 19:47 TMP

I don’t understand why it doesn’t work…

I did quick check login as postgres user and creating file and this worked:

sudo -i -u postgres

If I change priviledges to 777 all works as expected (I can do copy to command with no issues) So as to me it looks postgres doesn’t somehow honor Linux groups rights

Can someone guide me how to resolve that (777 is not an option to me…)

How do I find a friendly, inclusive roleplay group online?

One of my queer friends is interested in joining a campaign online, and is looking for an inclusive, friendly group of players. She asked me how she’d find such a group. I’d love to answer her, but after years of roleplaying irl and online, I still have no idea how I’d accomplish such a feat.

Most of the time in online games, the issue of gender and sexual diversity isn’t addressed, so I tend to end up with groups where at least one person isn’t comfortable with a non gender binary character, or expresses ideas about gender that make me uncomfortable. It tends to eventually come up and ruin an otherwise fun game night.

I don’t want to play in a don’t ask, don’t tell roleplaying campaign. How do I find a group of friendly, inclusive players who can roll with lgbt characters?

Ways to numerically find the monodromy group of an ODE

I’m interested in finding the monodromy group of some solutions of an ODE that I know only either approximately or numerically. For example, I might have a 3rd order ODE of which I cannot find exact solutions, but I can find them to very high accuracy as a series expansion. For the sake of the example, however, let me take an ODE of which I know the solutions, so I can compare whatever numerical method I have to the analytic solution.

Let me take the ODE $ $ f”(z)+\frac{(2-5 z) f'(z)}{4 z (1-z)}-\frac{3 f(z)}{64 (z-1)^2}=0$ $ that has the two linear independent solutions $ $ f_1=\frac{\sqrt{1-z}+\sqrt{z}+1}{2 \sqrt{\sqrt{z}+1} (1-z)^{1/8}}$ $ $ $ f_2=\frac{-\sqrt{1-z}+\sqrt{z}+1}{\sqrt{\sqrt{z}+1} (1-z)^{1/8}}$ $

Say that I start with $ 0<z<1$ , I analytically continue $ z$ to the complex plane, go around $ z=1$ , which is a branch point, and I come back to $ 0<z<1$ . From the explicit solutions, we can see that they change to $ $ \left( {\begin{array}{c} f_1 \ f_2 \ \end{array} } \right)\to \left( {\begin{array}{cc} 0 & \frac{1}{2} e^{-\frac{1}{4} i \pi }\ 2 e^{-\frac{1}{4} i \pi } & 4 \ \end{array} } \right) \left( {\begin{array}{c} f_1 \ f_2 \ \end{array} } \right) $ $

Now, let’s assume I don’t know exactly the form of $ f_1$ and $ f_2$ . Maybe I know them for example as a series expansions around z=0 with as many orders as I want. I wanna find out how the monodromy group acts on these solutions.

One way to do this would be as explained here. The idea is to discretize the path around z=1, solve the ODE as a series expansion in all of these points, and match these approximate solutions to the ones closeby. In this way we go around z=1 approximately. I’ve tried this and, assuming I’ve done this correctly, I get a sensible result, but even with 16 points and keeping 200ish orders of the series expansion, I get an error which is roughly 1-2%.

I would like to get these numbers with a higher precision. Is there any way that I could do this, without using the explicit form of $ f_1$ and $ f_2$ ? Maybe there’s a smart way of using NDSolve?

mySQL Group Replication Error “ERROR 3092 (HY000)”

The full error (on 2nd node) is:

mysql> START GROUP_REPLICATION;  ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more details on error log. 

This is after starting the 1st server without error. The log shows:

2021-02-27T19:05:45.079426Z 16 [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_recovery' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. 2021-02-27T19:06:10.874606Z 16 [System] [MY-013587] [Repl] Plugin group_replication reported: 'Plugin 'group_replication' is starting.' 2021-02-27T19:06:10.875454Z 17 [System] [MY-011565] [Repl] Plugin group_replication reported: 'Setting super_read_only=ON.' 2021-02-27T19:06:10.878134Z 16 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Automatically adding IPv4 localhost address to the allowlist. It is mandatory that it is added.' 2021-02-27T19:06:10.878182Z 16 [Warning] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Automatically adding IPv6 localhost address to the allowlist. It is mandatory that it is added.' 2021-02-27T19:06:10.881114Z 18 [System] [MY-010597] [Repl] 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='<NULL>', master_port= 0, master_log_file='', master_log_pos= 4, master_bind=''. 2021-02-27T19:06:13.300659Z 0 [ERROR] [MY-011516] [Repl] Plugin group_replication reported: 'There is already a member with server_uuid 6227f63c-dd97-11ea-8989-86fbcb300464. The member will now exit the group.' 

I am following the instructions here:

The instructions say that the UUID should be the same for all servers.

My droplet is a LAMP Ubuntu 20.04 droplet. mySQL 8.0.23

Anyone run into this? Any thoughts on what’s going wrong? I’ve checked and double-checked the procedure and made sure I followed it as best I could.

Was I right to leave my rp group after feeling like my player agency was violated?

Everyone. I was apart of a discord RP group but I recently left after this incident. To give some background. I was being repeatedly belittled OOC by other members and was being made to walk on egg shells around everyone. I was already Abit on edge the whole time I had been apart of this group which was for around six months. So this event starts and we find this group of nineteen children who had survived a horrific attack. They end up being affected by some unknown disease so we are all in quarantine with them.

This whole time my Character gravitates to this one little girl and makes sure to dote on her. Several of the children including her are confirmed to be orphans. My character is in her 30’s and I thought I would be given the chance to adopt her. Well the GM barely rped as her because they could not handle dealing with multiple players and scenes very well. They give us permission to just npc the children to an extent because they can’t keep up. So I am just writting scene after scene the whole time of cuteness. I am ignored by most the players and the GM even when I try to interact with others but I just play it off and try not to let it bother me.

So after the event ends the GM announces that the particular little girl I was taking care of was adopted by another player who hadn’t even met her. Needless to say I was very livid. I ended up leaving because I felt like no one was taking me into consideration or even allowing me to really interact with the events. Two players reached out to me to try and get me to come back even though in there own words the mods were "Cold hearted." I didn’t talk to the GMs about it because I was so mad and hurt to be stepped on like that, nor did they ever try to reach out to me. Am I just being childish here or am I in the right?

Character issues with my group

I am fairly newish to d and d. Our group plays every week and I have been a GM before. My character is fairly chill, chaotic neutral and will often get distracted for a few moments looking at something or talking to someone, as it fits into her character. She will often be the one to push the button in the middle of the room, or lick the wall etc. A real yes character trying not to block anyone else’s ideas. The other players however, one in particular shut her down at every turn, undermining her to NPCs making out like she is annoying and pathetic and often at times it can get hurtful as it seems to be aimed at me personally. We get along great in real life but anything my character says Is shut down, even when my ideas are good, they will chat about it and then either do what I had said or ignore me completely. When everything is getting a but too serious during times that are not serious, my character may do something to bring the story back to life. The GM loves it and will always let me go for it, as the story is richer and more enjoyable and I will feed more into some of the story elements he has done. The group however want to follow everything to the book. The campaign we are playing, I have been tasked with looking after the money etc from our group business, and even though it is my role ,(we all have our own) I get no say in anything ever. I don’t even see the point having the role. As it is always 2 against me. I roll a lot of natural 20s and the dm will allow certain things and the group will straight up say no.

For example tonight we were having a long rest, and my character was having a bit of fun and while they slept, put mud on their hands and woke them with a feather…when they woke they got a muddy face. Nothing major, just a little prank. It’s not real. And one of them set their familiar onto me to attack, which I of course batted it away… I am a tabaxi, I have claws… the gm made me roll to hit it and with my roll it died (can be brought back with a spell). This is a great twist to the story! An ogre then attacked us due to all the noise they were making about it and the ogre ruined their tents, Instead of the characters continuing on, etc, instead they both start getting actual mad at me, blamed me for everything. Started using spells to grovel to them and trying to hurt me on purpose and leave me in the forest and go off and continue the adventure. Their words and behaviors actually made me the person feel so shit. It was not intentional and it was not permanent. I mean, is this not the point of the game, to have moments that you can not control, or you might fuck up etc. The person who had the bird has actually nearly killed my character by accident during the campaign and I didn’t freak out and go on some kind or attack mode. The last few sessions I am not having a lot of fun, as one of the characters in particular takes over the entire story, tells you no if it’s not what they want to do and the character is really not nice to play with. So serious and straight. I try to talk about it but often get shut down. Do you think j need to find a new group. I was actually nearly in tears tonight, it was embarrassing and it’s a game. Yes a game I take seriously but fun is supposed to be the main component. I love my gm and would be gutted but our characters do not seem t mesh well.