MySQL InnoDB Cluster can’t be created. Why?

I am trying to setup a MySQL InnoDB Cluster. I configured each node involved using dba.configureInstance(...). Everything was nominal until I ran var cluster = dba.createCluster('clusterNmae'). When I run this command I get this error:

ERROR: Unable to start Group Replication for instance 'my-mysql-cluster-1:3306'. 
Please check the MySQL server error log for more information.
Dba.createCluster: Group Replication failed to start: MySQL Error 2013 (HY000): my-mysql-cluster-1:3306: Lost connection to MySQL server during query (RuntimeError)

So I modified the max_allowed_packet to max_allowed_packet = 512M but I still get the same error.

Here is the complete error log for mysql:

2021-03-02T21:12:52.161487Z 0 (System) (MY-010116) (Server) /usr/sbin/mysqld (mysqld 8.0.23-0ubuntu0.20.04.1) starting as process 1410
2021-03-02T21:12:52.173719Z 1 (System) (MY-013576) (InnoDB) InnoDB initialization has started.
2021-03-02T21:12:52.542976Z 1 (System) (MY-013577) (InnoDB) InnoDB initialization has ended.
2021-03-02T21:12:52.686661Z 0 (System) (MY-011323) (Server) X Plugin ready for connections. Bind-address: '127.0.0.1' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2021-03-02T21:12:52.688284Z 0 (System) (MY-013587) (Repl) Plugin group_replication reported: 'Plugin 'group_replication' is starting.'
2021-03-02T21:12:52.707092Z 0 (System) (MY-010229) (Server) Starting XA crash recovery...
2021-03-02T21:12:52.722770Z 0 (System) (MY-010232) (Server) XA crash recovery finished.
2021-03-02T21:12:52.778384Z 0 (Warning) (MY-010068) (Server) CA certificate ca.pem is self signed.
2021-03-02T21:12:52.778578Z 0 (System) (MY-013602) (Server) Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2021-03-02T21:12:52.802880Z 0 (Warning) (MY-010604) (Repl) Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!!>
2021-03-02T21:12:52.808702Z 0 (System) (MY-010931) (Server) /usr/sbin/mysqld: ready for connections. Version: '8.0.23-0ubuntu0.20.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu).
2021-03-02T21:12:52.815373Z 10 (System) (MY-010597) (Repl) 'CHANGE MASTER TO FOR CHANNEL 'group_replication_applier' executed'. Previous state master_host='<NULL>', master_port= 0, master_log_file='', maste>
2021-03-02T21:12:52.820635Z 2 (ERROR) (MY-011735) (Repl) Plugin group_replication reported: '(GCS) Unable to join the group: peers not configured. '
2021-03-02T21:12:52.820668Z 2 (ERROR) (MY-011639) (Repl) Plugin group_replication reported: 'Error on group communication engine start'
2021-03-02T21:12:52.820682Z 2 (ERROR) (MY-011735) (Repl) Plugin group_replication reported: '(GCS) The member is leaving a group without being on one.'

I’m running ubuntu 20.04 on all instances.

Why do I get this error(s) and what can I do to get over it? Thank you!

I created a fun way to interact with website visitors!

Hi, fellow business owners!

I used to run an e-commerce store in sunglasses a while back and had mixed feelings about it. I had decent amounts of traffic but literally almost 0% conversion rate compared to the average ~1-2%.
SEMrush

I knew something was off but couldn’t really validate what it was because there was no way for me to ask the website visitors or at least engage them long enough to increase their likelihood of converting to a customer. I eventually shut down the store a while ago but didn’t forget about my experience running it.

A couple of years later now, I built the tool that I was thinking of but didn’t fully realize at that time. I created a live shopping widget that I put on my website to engage with website visitors.

It helps me get a human presence on my website, just like you would have in a real store.

To finish the story, a friend (who comically is also running an e-commerce store in sunglasses but way more successful than me…) is using this to increase his conversions. We are going live later today on our website https://www.tryemcee.com/ to showcase the widget.

Let me know if you have any feedback!

 

created sql query to REBUILD/REORGANIZE indexes

I’ve created sql query to REBUILD/REORGANIZE indexes, but some of the avg_fragmentation_in_percent remains at 50% even after rebuilding them.

really appreciate any suggestions.

create table #tempQueries
(
    Query nvarchar(max),
)

CREATE TABLE #TempTable
(
    ROWID int identity(1,1) primary key,
    Name nvarchar(max),
)

insert into #TempTable
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'

--select * from #TempTable
DECLARE @MAXID INT, @Counter INT

SET @COUNTER = 1
SELECT @MAXID = COUNT(*) FROM #TempTable

WHILE (@COUNTER <= @MAXID)
BEGIN
    --DO THE PROCESSING HERE  
    insert into #tempQueries
    SELECT 
    'ALTER INDEX ' + QUOTENAME(ind.name)  + ' ON ' +QUOTENAME(object_name(ind.object_id)) + 
        CASE    WHEN indexstats.avg_fragmentation_in_percent>30 THEN ' REBUILD ' 
            WHEN indexstats.avg_fragmentation_in_percent>=5 THEN ' REORGANIZE'
            ELSE NULL END as (SQLQuery)  -- if <5 not required, so no query needed
    FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, NULL) indexstats 
    INNER JOIN sys.indexes ind ON ind.object_id = indexstats.object_id 
        AND ind.index_id = indexstats.index_id 
    WHERE 
    --indexstats.avg_fragmentation_in_percent , e.g. >10, you can specify any number in percent 
    ind.Name is not null 
    and OBJECT_NAME(ind.OBJECT_ID) = (SELECT Name FROM #TempTable where ROWID = @Counter)
    ORDER BY indexstats.avg_fragmentation_in_percent DESC

    SET @COUNTER = @COUNTER + 1
END

delete from #tempQueries where Query is null
select * from #tempQueries

While (Select Count(*) From #tempQueries) > 0
Begin

    DECLARE @sql NVARCHAR(MAX);
    
    SET @sql = (select top 1 Query from #tempQueries)

    print @sql
    exec (@sql)

    Delete top (1) from #tempQueries

End

drop table #tempQueries
drop table #TempTable

sorting – Sort items so that parents are created before their children

I’ve been asked to create some code to help automate the loading of data into a system based on employee data in a spreadsheet. However, the data isn’t clean, so some people may have no manager, some may be their own manager, some have managers who already exist in the system, so aren’t included in the export, and others managers are somewhere in the export.

The below sort algorithm is to allow a sort of such dirty data, to ensure that where a dependency chain can be resolved it is and the items are returned in the appropriate order; but if the data’s bad, we’ll still be able to do as much good as possible.

Sharing it here as there may be a more efficient solution. I’ve seem similar solutions which build a tree then traverse it; but all those I’ve seen require clean data to function correct, and I can’t think of a way to amend them whilst keeping their efficiency.

Function Sort-ParentChild {
    (CmdletBinding())
    Param (
        (Parameter(Mandatory, ValueFromPipeline))
        (PSCustomObject())$ListItems
        ,
        (Parameter(Mandatory))
        (string)$ParentPropertyName
        ,
        (Parameter(Mandatory))
        (string)$CurrentPropertyName
    )
    Begin {
        (System.Collections.Generic.List(PSCustomObject))$Pending = (System.Collections.Generic.List(PSCustomObject))::new()
    }
    Process {
        foreach ($item in $ListItems) {
            # first return items which have no parent, or which are their own parent (since circular dependencies would otherwise never be resolved
            if (($null -eq $item."$ParentPropertyName") -or (($item."$CurrentPropertyName" -eq $item."$ParentPropertyName"))) {
                $item
            } else {
                $Pending.Add($item)
            }
        }
    }
    End {
        while ($Pending.Count) {
            $circularLoop = $true
            # return any items whose parents are not in the pending list (i.e. they already existed so weren't in the todo list, or we've returned them earlier in the process)
            for ($i = ($Pending.Count-1); $i -ge 0; $i--) { # work down, so that removing an item won't have any odd impacts
                if ($Pending($i)."$ParentPropertyName" -notin @($Pending | Select-Object -ExpandProperty $CurrentPropertyName)) {
                    $Pending($i)
                    $Pending.RemoveAt($i)
                    $circularLoop = $false # if we've found something to return, we're not in a loop yet
                }
            }
            if ($circularLoop) {
                # in case there are any circular dependencies, to avoid getting stuck, return a single item, then try to unravel in dependency order from there
                Write-Warning "Circular dependency found; breaking loop by returning $($Pending(0)."$CurrentPropertyName")"
                $Pending(0)
                $Pending.RemoveAt(0)
            }
        }
    }
}

Example Usage

$users = @(
    @{Id = 'Subordinate17';   ManagerId = 'MiddleManager1'}      
    @{Id = 'Subordinate15';   ManagerId = 'MiddleManager1'}   
    @{Id = 'Subordinate14';   ManagerId = 'MiddleManager3'}   
    @{Id = 'Subordinate13';   ManagerId = 'MiddleManager1'}   
    @{Id = 'TopDog';          ManagerId = $null}      # this person's the top dog; they don't have a manager
    @{Id = 'MiddleManager1';  ManagerId = 'BigBoss1'}
    @{Id = 'BigBoss1';        ManagerId = 'BigBoss1'} # Big Boss is their own boss
    @{Id = 'AmbassadorX';     ManagerId = 'PilotX'}        
    @{Id = 'MiddleManager2';  ManagerId = 'BigBoss1'}
    @{Id = 'PilotX';          ManagerId = 'InstructorX'}   
    @{Id = 'Subordinate17';   ManagerId = 'MiddleManager1'}      
    @{Id = 'MiddleManager3';  ManagerId = 'TopDog'}
    @{Id = 'Subordinate16';   ManagerId = 'MiddleManager3'}      
    @{Id = 'Mya';             ManagerId = 'PilotX'}         
    @{Id = 'Subordinate12';   ManagerId = 'MiddleManager2'}      
    @{Id = 'Subordinate11';   ManagerId = 'MiddleManager1'}      
    @{Id = 'InstructorX';     ManagerId = 'AmbassadorX'}
    @{Id = 'Subordinate10';   ManagerId = 'MiddleManager2'}   
    @{Id = 'Subordinate09';   ManagerId = 'MiddleManager2'}   
    @{Id = 'Subordinate08';   ManagerId = 'MiddleManager2'}   
    @{Id = 'Subordinate07';   ManagerId = 'MiddleManager2'}   
    @{Id = 'Subordinate06';   ManagerId = 'MiddleManager2'}   
    @{Id = 'Subordinate05';   ManagerId = 'TopDog'}   
    @{Id = 'Subordinate04';   ManagerId = 'BigBoss1'}   
    @{Id = 'Subordinate03';   ManagerId = 'MiddleManager3'}   
    @{Id = 'Shark';           ManagerId = $null}           # alone shark :S
    @{Id = 'Subordinate02';   ManagerId = 'MiddleManager3'}   
    @{Id = 'Subordinate01';   ManagerId = 'MiddleManager3'}
) | %{(pscustomobject)$_} #| Sort -Property @{E={(Guid)::NewGuid()}} # optional chaos sort, to avoid any chance of my data being in some helpful order before testing

$users | Sort-ParentChild -ParentPropertyName 'ManagerId' -CurrentPropertyName 'Id'
WARNING: Circular dependency found; breaking loop by returning AmbassadorX
Id             ManagerId     
--             ---------     
TopDog                       
BigBoss1       BigBoss1      
Shark                        
Subordinate04  BigBoss1      
Subordinate05  TopDog        
MiddleManager3 TopDog        
MiddleManager2 BigBoss1      
MiddleManager1 BigBoss1      
Subordinate13  MiddleManager1
Subordinate14  MiddleManager3
Subordinate15  MiddleManager1
Subordinate17  MiddleManager1
Subordinate01  MiddleManager3
Subordinate02  MiddleManager3
Subordinate03  MiddleManager3
Subordinate06  MiddleManager2
Subordinate07  MiddleManager2
Subordinate08  MiddleManager2
Subordinate09  MiddleManager2
Subordinate10  MiddleManager2
Subordinate11  MiddleManager1
Subordinate12  MiddleManager2
Subordinate16  MiddleManager3
Subordinate17  MiddleManager1
AmbassadorX    PilotX        
InstructorX    AmbassadorX   
PilotX         InstructorX   
Mya            PilotX  

sharepoint online – Column default value settings on folders created when creating Ms Teams channel

I am migrating sites from SharePoint On Premise to SharePoint Online/Ms Teams. We have not been using folders in our document libraries, instead we have relied on managed metadata. For one of the new sites, I created the site as an Ms Teams, and then I set up a number of channels, one for each sub-process (that we have metadata for). So I got the corresponding folders in my SharePoint library, one for each channel.

I would now like to have the files added to the folders tagged with the sub-process metadata for that folder automatically. But when I go to “Column default value setting” I can see none of the folders that exist in the library. I can just set default values for the document library.

How can I get the folders created by Ms Teams to display in “Column default value settings”?

I created a PowerApps form, then placed it in a Page Viewer Web Part. I need to remove “New Item”, “Save”, and “Cancel”

So I customized a modern form in SharePoint with PowerApps. My client then wanted my to have this form display on a separate page. So I placed the form in a Page Viewer Web Part. It looks good except I need to remove “New Item”, which appears to just be static text. I also need to remove/hide “Save” and “Cancel” at the top, as I created custom buttons at the bottom of the form to perform that function. Here’s what I’m talking about:

enter image description here

I just want to know if it’s possible to hide/remove these parts. Or if I can even lower the top of the web part enough to cover them.

Thank you for your help!!

Chris

multisite – I’m unable to access a newly created website on Bitnami Local WordPress

I have followed this tutorial: How to setup wordpress multisites I have made the changes in the files as they have mentioned and was able to create a new site and enable the Network Admin dashboard but when I open the site’s dashboard (http://localhost/wordpress/staudt/wp-admin/) or even the site itself I get a message saying: “This page isn’t working right now”.

I don’t know what’s the issue and can’t figure it out. I have tried to use another browser and create another site but no success. I’m using WordPress Bitnami which is locally installed on my machine.

Any help will be appreciated. Thank you.

Unlimited New Gmail And 2008-2020 Created Verified Old Gmail Sell — 👉 GSA SEO and Marketing Forum 👈

Unlimited New Gmail And 2008-2020 Created Verified Old Gmail Sell

new gmails with 7days replacement guarranty

 Price:-               20 Gmail 8$

                       50 gmail 15$

                       100 Gmail 25$

Old
Gmail Price Depend How Old gmail You need.I have Multiple Years Old
gmail Like 2008/2011/2012/2014/2016/2018/2019/2020 and new

                         I have Unlimited Old and New gmail in Stock

Contact Me:-   

       

                Skype :-  saikat-nakib

            Whatsapp  :-  +8801995177888

        Mail/hangouts :-  saikatnakib@gmail.com