Maria DB keep dying issue

Maria DB keeps dying after restart every hour, shows following error:


Mar 06 09:03:15 freeubuntu systemd[1]: mariadb.service: Start operation timed out. Terminating.
Mar 06 09:03:17 freeubuntu systemd[1]: mariadb.service: Failed with result ‘timeout’.
Mar 06 09:03:17 freeubuntu systemd[1]: Failed to start MariaDB 10.3.28 database server.

The Maria db itself is working fine, but seems the start didn’t return to systemctl correctly, so systemctl kills it after some time – around 1 hour as I can see after system reboot

I installed and later un-installed a MySql before installing the MariaDB 10.3, not sure if this is related, but seems not.

Following 2 blog shows how to resolve the issue

https://askubuntu.com/questions/750604/why-does-mariadb-keep-dying-how-do-i-stop-it

https://askubuntu.com/questions/175820/mysql-doesnt-update-due-to-error-in-apparmor-profile

React-Native demo

Following is a simple sample on building an demo react-native app
With basic navigations

1, Create a sample app
npm expo-cli init MyApp --npm

2, Install React Navigation
npm install react-navigation

3, Install dependencies
expo install react-native-gesture-handler react-native-reanimated react-native-screens react-native-safe-area-context @react-native-community/masked-view
npm install react-navigation-stack @react-native-community/masked-view

4, Install React Navigation Stack
npm install react-navigation

5, Start the app and clear cache
expo r -c

How to use JS to parse a csv file

Following is an example on how can we use Regular Expression to parse a CSV file in Java script

function CSVToArray( strData, strDelimiter ){
	// Check to see if the delimiter is defined. If not,
	// then default to comma.
	strDelimiter = (strDelimiter || ",");

	// Create a regular expression to parse the CSV values.
	var objPattern = new RegExp(
		(
			// Delimiters.
			"(\\" + strDelimiter + "|\\r?\\n|\\r|^)" +

			// Quoted fields.
			"(?:\"([^\"]*(?:\"\"[^\"]*)*)\"|" +

			// Standard fields.
			"([^\"\\" + strDelimiter + "\\r\\n]*))"
		),
		"gi"
		);


	// Create an array to hold our data. Give the array
	// a default empty first row.
	var arrData = [[]];

	// Create an array to hold our individual pattern
	// matching groups.
	var arrMatches = null;


	// Keep looping over the regular expression matches
	// until we can no longer find a match.
	while (arrMatches = objPattern.exec( strData )){

		// Get the delimiter that was found.
		var strMatchedDelimiter = arrMatches[ 1 ];

		// Check to see if the given delimiter has a length
		// (is not the start of string) and if it matches
		// field delimiter. If id does not, then we know
		// that this delimiter is a row delimiter.
		if (
			strMatchedDelimiter.length &&
			strMatchedDelimiter !== strDelimiter
			){

			// Since we have reached a new row of data,
			// add an empty row to our data array.
			arrData.push( [] );

		}

		var strMatchedValue;

		// Now that we have our delimiter out of the way,
		// let's check to see which kind of value we
		// captured (quoted or unquoted).
		if (arrMatches[ 2 ]){

			// We found a quoted value. When we capture
			// this value, unescape any double quotes.
			strMatchedValue = arrMatches[ 2 ].replace(
				new RegExp( "\"\"", "g" ),
				"\""
				);

		} else {

			// We found a non-quoted value.
			strMatchedValue = arrMatches[ 3 ];

		}


		// Now that we have our value string, let's add
		// it to the data array.
		arrData[ arrData.length - 1 ].push( strMatchedValue );
	}

	// Return the parsed data.
	return( arrData );
}

The Journey Begins

Thanks for joining me!

Good company in a journey makes the way seem shorter. — Izaak Walton

post