How to fix Table doesn't exist in engine error for MariaDB Error 1932

Question: When attempting a mysqldump on one of the databases on a MariaDB server with this command I received the error message mysqldump: Got error: 1932: "Table 'schema1.myTable' doesn't exist in engine" when using LOCK TABLES mysqldump -u myun -p database_name > /mariadb/backups/mydb1171117.sql Description: Backup of [~myDB1~] MySQL database failed. The error message [~mysqldump: Couldn't execute 'show create table `my_code`': Table 'mydb1.my_code' doesn't exist in engine (1932) ~] is received during backup. Source: myserver1, Process: MySqlBackupChil How can I fix? In summary - some files were moved around and this has caused the issue Answer:I've found this error message appears... Read more →

How to use auto-increment with PostgreSQL sequence

A developer contacted me to to tell me they were experiencing problems with enabling an auto-increment on a PostgreSQL table.He wanted to know if the privileges assigned to his user credentials had the right level of permission to create a sequence. I reviewed the privileges and identified some missing details: GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA myschema1 TO user1; As a test I logged on as the user's credentials and completed some simple validation tasks to confirm they could complete a CREATE SEQUENCE and add to a table. Step 1 : Create a simple SEQUENCE CREATE SEQUENCE myschema1.jvtest_seq;... Read more →

Announcing Powerful Rules for Disruptors with MongoDB

An interesting presentation highlighting the power of keeping the pressure on but making as many friends as possible - to create change . Modernizing and rethinking legacy platforms can be a daunting task. This presentation describes cultural buttons to push - and how to start small , but keep growing. Starting small - allows developing expertise at a granular level which is the foundation of hyperscale These are some highlights from the presentation- with a link to the presentation Rules for Disruptors - Making, Managing and Scaling the Case for Change with MongoDB by Jeff Needham - Architect The most... Read more →

How to fix - Cannot connect to the Docker daemon

Question: I'm getting this error message when attempting to connect to the Docker daemon ? Can you supply a method to fix this issue docker info Cannot connect to the Docker daemon at tcp://localhost:2375/usr/lib/systemd/system/docker.socket. Is the docker daemon running? Answer: I've experienced this problem previously - and this is the way I worked around the problem.Let me know if this doesn't fix the issue Add your self to the docker group usermod -aG docker $USER Fix permissions on docker socker and command. sudo chgrp docker /usr/bin/docker sudo chgrp docker /var/run/docker.sock $ ll $(which docker) -rwxr-xr-x 1 root docker 18991768 08.07.2017... Read more →

How to master KSQL with cheat-sheet

KSQL is the the streaming SQL Engine for the real time data processing of Kafka. These are some of the commands --check KSQL is running ps aux | grep ksql --check KSQL error logs (if using Confluent) confluent log ksql-server --list created streams LIST STREAMS --View the structure of STREAM DESCRIBE mySTREAM_NAME --display all topics SHOW TOPICS --display values in topic PRINT 'topic_name' Read more on Apache Kafka How to Rock Apache Kafka with a cheat-sheet Read more →