By using AWS re:Post, you agree to the Terms of Use

Questions tagged with Database

Sort by most recent

Browse through the questions and answers listed below or filter and sort to narrow down your results.

ERROR 2002 (HY000): Can't connect to local server through socket '/opt/bitnami/mariadb/tmp/mysql.sock' (111)

My website has a problem, Error establishing a database connection I fail to access to > /wp-admin/maint/repair.php So tried to Recover A MariaDB Database. But there are Error message like this. > ERROR 2002 (HY000): Can't connect to local server through socket '/opt/bitnami/mariadb/tmp/mysql.sock' (111) I appreciat you guyts if give some advice to solve the database problems [sql log] ``` 2022-09-15 11:51:53 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-09-15 11:51:53 0 [Note] InnoDB: Number of pools: 1 2022-09-15 11:51:53 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-09-15 11:51:53 0 [Note] InnoDB: Using Linux native AIO 2022-09-15 11:51:53 0 [Note] InnoDB: Initializing buffer pool, total size = 2147483648, ch unk size = 134217728 2022-09-15 11:51:53 0 [Note] InnoDB: Completed initialization of buffer pool 2022-09-15 11:51:53 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=374566523 4,3747530277 2022-09-15 11:51:53 0 [ERROR] InnoDB: Missing FILE_CREATE, FILE_DELETE or FILE_MODIFY befo re FILE_CHECKPOINT for tablespace 541 2022-09-15 11:51:53 0 [ERROR] InnoDB: Plugin initialization aborted with error Data struct ure corruption 2022-09-15 11:51:53 0 [Note] InnoDB: Starting shutdown... 2022-09-15 11:51:53 0 [ERROR] Plugin 'InnoDB' init function returned error. 2022-09-15 11:51:53 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2022-09-15 11:51:53 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-09-15 11:51:53 0 [ERROR] Unknown/unsupported storage engine: InnoDB 2022-09-15 11:51:53 0 [ERROR] Aborting ```
1
answers
0
votes
39
views
profile picture
asked 19 days ago

Errors Launching MariaDB on Lightsale

Hello, I recently launched a new Lightsale instance and the first thing I wanted to do is launch MariaDB. I ran the below command, which I found in AWS help docs: sudo /opt/bitnami/mariadb/bin/mysqld_safe --defaults-file=/opt/bitnami/mariadb/conf/my.cnf --init-file=/tmp/mysql-init 2> /dev/null & But the process dies almost immediately. Here is the associated errors from mysqld.log: 220914 16:02:15 mysqld_safe Starting mariadbd daemon with databases from /opt/bitnami/mariadb/data 2022-09-14 16:02:15 0 [Note] /opt/bitnami/mariadb/sbin/mariadbd (server 10.6.7-MariaDB) starting as process 17091 ... 2022-09-14 16:02:15 0 [ERROR] mariadbd: Can't lock aria control file '/opt/bitna mi/mariadb/data/aria_log_control' for exclusive use, error: 11. Will retry for 30 seconds 2022-09-14 16:02:45 0 [ERROR] mariadbd: Got error 'Could not get an exclusive lock; file is probably in use by another process' when trying to use aria control file '/opt/bitnami/mariadb/data/aria_log_control' 2022-09-14 16:02:45 0 [ERROR] Plugin 'Aria' init function returned error. 2022-09-14 16:02:45 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed. 2022-09-14 16:02:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2022-09-14 16:02:45 0 [Note] InnoDB: Number of pools: 1 2022-09-14 16:02:45 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-09-14 16:02:45 0 [Note] InnoDB: Using Linux native AIO 2022-09-14 16:02:45 0 [Note] InnoDB: Initializing buffer pool, total size = 16777216, chunk size = 16777216 2022-09-14 16:02:45 0 [Note] InnoDB: Completed initialization of buffer pool 2022-09-14 16:02:45 0 [Note] InnoDB: 128 rollback segments are active. 2022-09-14 16:02:45 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-09-14 16:02:45 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2022-09-14 16:02:45 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2022-09-14 16:02:45 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2022-09-14 16:02:45 0 [Note] InnoDB: 10.6.7 started; log sequence number 42437; transaction id 14 2022-09-14 16:02:45 0 [Note] Plugin 'FEEDBACK' is disabled. 2022-09-14 16:02:45 0 [ERROR] Could not open mysql.plugin table: "Unknown storage engine 'Aria'". Some plugins may be not loaded 2022-09-14 16:02:45 0 [ERROR] Failed to initialize plugins. 2022-09-14 16:02:45 0 [ERROR] Aborting 220914 16:02:45 mysqld_safe mysqld from pid file /opt/bitnami/mariadb/tmp/mysqld.pid ended The my.cnf is pretty basic: [mysqladmin] user= [mysqld] skip_name_resolve explicit_defaults_for_timestamp basedir=/opt/bitnami/mariadb port=3306 tmpdir=/opt/bitnami/mariadb/tmp socket=/opt/bitnami/mariadb/tmp/mysql.sock pid_file=/opt/bitnami/mariadb/tmp/mysqld.pid max_allowed_packet=16M bind_address=127.0.0.1 log_error=/opt/bitnami/mariadb/logs/mysqld.log slow_query_log=0 slow_query_log_file=/opt/bitnami/mariadb/logs/mysqld.log long_query_time=10.0 character_set_server=utf8 collation_server=utf8_general_ci plugin_dir=/opt/bitnami/mariadb/lib/plugin [client] port=3306 socket=/opt/bitnami/mariadb/tmp/mysql.sock pid_file=/opt/bitnami/mariadb/tmp/mysqld.pid !include /opt/bitnami/mariadb/conf/bitnami/my_custom.cnf !include /opt/bitnami/mariadb/conf/bitnami/memory.conf I have made no changes to anything, other than creating /tmp/mysql.init as described on another AWS kb article, but all that does is change the root password for MariaDB. Can anyone help me figure this out?
1
answers
0
votes
23
views
asked 19 days ago

Limitations of dynamoDB & GraphQL

**1.** Paginating a query: When I'm using ```ModelQuery.list(Todo.class,Todo.DESCRIPTION.contains("hi"), ModelPagination.limit(10)``` it is returning less than 10 items. It seems like it is returning ```Todo``` those ```DESCRIPTION``` contains ```hi``` from first 10 itmes in DynamoDB Todo table(It is filtering the itmes form the 10 itmes). If there is no items with ```DESCRIPTION``` contains ```hi``` in first 10 items of table it will return null. **My table have 25 items with description=hi** **My expectation:** It should return exactly 10 items which should have ```description=hi``` whether it is in the first 10 items of table or not. **2.** Getting the highest like comments & total comment count: For example we can take a YouTube video. When we open YouTube video comment section it will show us the comments with highest likes. We can't do that with graphQL and DynamoDB with **an easy way**. We have to do lot more to get highest liked comments. **There is no way to count the comments:** Look at the schema below: ``` type Post @model { id: ID! title: String! comments: [Comment] @hasMany } type Comment @model { id: ID! content: String! post: Post @belongsTo } ``` We can't count the total number of comments on the post. **Lets say we have to make a query for get post : we can directly retrieve the comments with post as we have created a relationship. Look at my YouTube video example like that how can we retrieve the comments with highest likes. **DynamoDB query max size is 1mb lets say a post has 1 million comments if we will query get post with 1 million comments, the response data may reach 1mb and the latency of response also become very high. For that pagination is provided I know, then after getting the nextToken we have to make a separate comment query for that post. **3.** NextToken issue: If I'm querying items with pagination( limit=10) it is returning a next token. For the next query we can use next token to get next 10 items. If I I'm creating a new items in the table . It is creating in between the items that are present before next Token. I have descrribed it here in a better way: https://stackoverflow.com/questions/73669620/how-to-code-a-simple-algorithm-to-fetch-list-of-data-through-pagination-in-a-fre
0
answers
0
votes
27
views
asked 21 days ago