We have a Docker Cassandra container running 6.8.21. At times when the container is restarted the the Logs show the usual startup activities and all just works well post that. But on a few occasions we observed that an output similar to that of nodetool tpstats keeps getting printed over and over again. Posting a sample of the output below. Need help: 1. Why is Cassandra Printing this? Is there some bottleneck that it has hit? 2. What does this log trying to tell? 3. What should be the next steps in our investigation? Appreciate any help here. Log:

INFO  [OptionalTasks:1] 2022-08-11 01:33:55,678  StatusLogger.java:174 - 
Pool Name                                       Active        Pending   Backpressure   Delayed      Shared      Stolen      Completed   Blocked  All Time Blocked
AuthzStage                                           0              0            N/A       N/A         N/A         N/A              0         0                 0
LwtStage                                             0              0            N/A       N/A         N/A         N/A              0         0                 0
RequestResponseStage                                 0              0            N/A       N/A         N/A         N/A              0         0                 0
AntiCompactionExecutor                               0              0            N/A       N/A         N/A         N/A              0         0                 0
AntiEntropyStage                                     0              0            N/A       N/A         N/A         N/A              0         0                 0
BackgroundIoStage                                    0              0            N/A       N/A         N/A         N/A              0         0                 0
CacheCleanupExecutor                                 0              0            N/A       N/A         N/A         N/A              0         0                 0
CompactionExecutor                                   0              0            N/A       N/A         N/A         N/A             77         0                 0
GossipStage                                          0              0            N/A       N/A         N/A         N/A              0         0                 0
HintsDispatcher                                      0              0            N/A       N/A         N/A         N/A              0         0                 0
InternalResponseStage                                0              0            N/A       N/A         N/A         N/A              0         0                 0
MemtableFlushWriter                                  0              0            N/A       N/A         N/A         N/A             78         0                 0
MemtablePostFlush                                    0              0            N/A       N/A         N/A         N/A            203         0                 0
MemtableReclaimMemory                                0              0            N/A       N/A         N/A         N/A             78         0                 0
MigrationStage                                       0              0            N/A       N/A         N/A         N/A              0         0                 0
MiscStage                                            0              0            N/A       N/A         N/A         N/A              0         0                 0
PendingRangeCalculator                               0              0            N/A       N/A         N/A         N/A              1         0                 0
PerDiskMemtableFlushWriter_0                         0              0            N/A       N/A         N/A         N/A             39         0                 0
Repair-Task                                          0              0            N/A       N/A         N/A         N/A              0         0                 0
Sampler                                              0              0            N/A       N/A         N/A         N/A              0         0                 0
SecondaryIndexManagement                             0              0            N/A       N/A         N/A         N/A              0         0                 0
TPC/all                                            N/A            N/A            N/A       N/A         N/A         N/A            N/A       N/A               N/A
TPC/all/AUTHENTICATION                               0            N/A            N/A       N/A           0           0              8       N/A               N/A
TPC/all/AUTHORIZATION                                0            N/A            N/A       N/A           0           0              9       N/A               N/A
TPC/all/BACKPRESSURED_MESSAGE_DECODE                 0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/BACKPRESSURE_RESCHEDULE                      0              0            N/A       N/A           0           0              0       N/A                 0
TPC/all/BACKUP_OPERATION                             0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/BATCH_REMOVE                                 0              0            N/A       N/A           0           0              0       N/A                 0
TPC/all/BATCH_REPLAY                                 0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/BATCH_STORE                                  0              0            N/A       N/A           0           0              0       N/A                 0
TPC/all/BATCH_STORE_RESPONSE                         0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/BLOCKING_OPERATION_RESTART                   0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/BUFFER_POOL_CLEANUP                          0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/CLEAN_BACKUPS_OPERATION                      0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/CONTINUOUS_PAGING                            0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/COUNTER_ACQUIRE_LOCK                         0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/EXECUTE_STATEMENT                            0            N/A            N/A       N/A           0           0             38       N/A               N/A
TPC/all/FRAME_DECODE                                 0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/HINT_DISPATCH                                0              0            N/A       N/A           0           0              0       N/A                 0
TPC/all/HINT_RESPONSE                                0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/INCREMENTAL_NODESYNC_MAINTENANCE             0            N/A            N/A       N/A           0           0           1271       N/A               N/A
TPC/all/LWT_COMMIT                                   0              0            N/A       N/A           0           0              0       N/A                 0
TPC/all/LWT_PREPARE                                  0              0            N/A       N/A           0           0              0       N/A                 0
TPC/all/LWT_PREPARE_AWAIT_LOCK                       0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/LWT_PROPOSE                                  0              0            N/A       N/A           0           0              0       N/A                 0
TPC/all/LWT_PROPOSE_AWAIT_LOCK                       0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/NETWORK_BACKPRESSURE                         0              0            N/A       N/A           0           0              0       N/A                 0
TPC/all/NODESYNC_VALIDATION                          0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/OUTBOUND_FLUSH                               0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/OUTBOUND_SCHEDULED_FLUSH                     0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/PARALLEL_MESSAGE_DECODE                      0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/POPULATE_VIRTUAL_TABLE                       0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/READ_DISK_ASYNC                              0            N/A            N/A       N/A           0           0             36       N/A               N/A
TPC/all/READ_DISK_RETRY                              0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/READ_DISK_WOULD_BLOCK                        0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/READ_INTERNAL                                0            N/A            N/A       N/A           0           0             13       N/A               N/A
TPC/all/READ_LOCAL                                   0              0            N/A       N/A           0           0              0       N/A                 0
TPC/all/READ_RANGE_INTERNAL                          0            N/A            N/A       N/A           0           0             22       N/A               N/A
TPC/all/READ_RANGE_LOCAL                             0              0            N/A       N/A           0           0              0       N/A                 0
TPC/all/READ_RANGE_NODESYNC                          0              0            N/A       N/A           0           0              0       N/A                 0
TPC/all/READ_RANGE_REMOTE                            0              0            N/A       N/A           0           0              0       N/A                 0
TPC/all/READ_RANGE_RESPONSE                          0            N/A            N/A       N/A           0           0             22       N/A               N/A
TPC/all/READ_REMOTE                                  0              0            N/A       N/A           0           0              0       N/A                 0
TPC/all/READ_RESPONSE                                0            N/A            N/A       N/A           0           0             13       N/A               N/A
TPC/all/READ_SECONDARY_INDEX                         0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/READ_SPECULATE                               0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/READ_SWITCH_FOR_ITERATOR                     0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/READ_TIMEOUT                                 0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/RESTORE_OPERATION                            0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/SAVE_LOCAL_NODE                              0            N/A            N/A       N/A           0           0              7       N/A               N/A
TPC/all/SAVE_PEER_NODES                              0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/SOLR_ACQUIRE_LOCK                            0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/SOLR_INDEXING                                0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/SYSTEM_KEYSPACE_ACQUIRE_LOCK                 0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/TIMED_TIMEOUT                                0            N/A            N/A       N/A           0           0           2331       N/A               N/A
TPC/all/TIMED_UNKNOWN                                0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/TRUNCATE                                     0              0            N/A       N/A           0           0              0       N/A                 0
TPC/all/UNKNOWN                                      0            N/A            N/A       N/A           0           0             49       N/A               N/A
TPC/all/UPDATE_NOTIFICATION                          0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/VIEW_ACQUIRE_LOCK                            0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/WRITE_AWAIT_COMMITLOG_SEGMENT                0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/WRITE_AWAIT_COMMITLOG_SYNC                   0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/WRITE_DEFRAGMENT                             0              0            N/A       N/A           0           0              0       N/A                 0
TPC/all/WRITE_INTERNAL                               0            N/A            N/A       N/A           0           0              3       N/A               N/A
TPC/all/WRITE_LOCAL                                  0              0            N/A       N/A           0           0              0       N/A                 0
TPC/all/WRITE_MEMTABLE_FULL                          0            N/A            N/A       N/A           0           0              0       N/A               N/A
TPC/all/WRITE_REMOTE                                 0              0            N/A       N/A           0           0              0       N/A                 0
TPC/all/WRITE_RESPONSE                               0            N/A            N/A       N/A           0           0              3       N/A               N/A
TPC/all/WRITE_SWITCH_FOR_MEMTABLE                    0            N/A            N/A       N/A           0           0            372       N/A               N/A
ValidationExecutor                                   0              0            N/A       N/A         N/A         N/A              0         0                 0
ViewBuildExecutor                                    0              0            N/A       N/A         N/A         N/A              0         0                 0
CompactionManager                 0         0
MessagingService                n/a       0/0
Buffer pool size for cached reads: 4.000MiB, for direct reads: 4.000MiB
Cached reads buffer pool BufferPool for long lived buffers: Size-tiered from 4.000KiB to 4.000KiB buffers, using 1024 buffers per slab.
Sub pools:
Buffer size 4.000KiB: 584.000KiB used, 4.000MiB allocated, 1 slabs.
Overflow: 0.000KiB
Direct reads buffer pool BufferPool for temporary buffers: allocated 4.000MiB, used 0.000KiB, overflow 0.000KiB, overflow allocations mean rate 0.000000
Global memtable buffer pool size: onHeap = 3.402KiB, offHeap = 2.029KiB
Cache Type                     Size                 Capacity               KeysToSave
KeyCache                          0                104857600                      all
RowCache                          0                        0                      all
Table                       Memtable ops,data
system_schema.keyspaces                   0,0
system_schema.hidden_columns                 0,0
system_schema.edges                       0,0
system_schema.views                       0,0
system_schema.columns                     0,0
system_schema.types                       0,0
system_schema.indexes                     0,0
system_schema.vertices                    0,0
system_schema.dropped_columns                 0,0
system_schema.aggregates                  0,0
system_schema.triggers                    0,0
system_schema.tables                      0,0
system_schema.functions                   0,0
system_auth.roles                       2,262
system_auth.role_members                  0,0
system_auth.role_permissions               1,199
dse_system_local.solr_resources                 0,0
dse_system.encrypted_keys                 0,0
dse_leases.logs                           0,0
dse_leases.leases                         0,0
solr_admin.solr_resources                 0,0
dse_insights.insights_config                 0,0
dse_insights.tokens                       0,0
dse_insights_local.insights_config                 0,0
system_distributed.nodesync_status                 0,0
system_distributed.nodesync_user_validations                 0,0
system_distributed.parent_repair_history                 0,0
system_distributed.repair_history                 0,0
system_distributed.restore_task_state                 0,0
system_distributed.backups                 0,0
system_distributed.backup_task_state                 0,0
system_distributed.view_build_status                 0,0
system_backups.backup_stores                 0,0
system_backups.backup_configurations                 0,0
dse_perf.node_slow_log                    0,0
system_traces.sessions                    0,0
system_traces.events                      0,0
dse_security.digest_tokens                 0,0
dse_security.role_options                 0,0
dse_security.spark_security                 0,0
axone.config_context                      0,0
axone.test_hc                             0,0
axone.config                              0,0
axone.valid_context                       0,0
system.compaction_history               1,254
system.IndexInfo                          0,0
system.repairs                            0,0
system.size_estimates                     0,0
system.paxos                              0,0
system.built_views                        0,0
system.peer_events                        0,0
system.range_xfers                        0,0
system.peers                              0,0
system.batches                            0,0
system.transferred_ranges                 0,0
system.view_builds_in_progress                 0,0
system.local                              0,0
system.sstable_activity                   4,0
system.nodesync_checkpoints                 0,0
system.available_ranges                   0,0
system.prepared_statements               5,655

I have a second MySQL 8 instance running on Ubunut 20.04, started by this command: mysqld_safe --defaults-file=/home/user/mysqld_replica.cnf & The config file contains all needed settings like port, socket and data dir. That works well but I can not figure out how to start the second instance on boot. What would be the recommended way to start both instances at boot time?

I am using oracle 10g with 4 instance with same server but one of them has failed to start Oracle Enterprise Manager and rest of three are working fine. Starting Oracle Enterprise Manager 10g Database Control .................................................................... failed. Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/vvs/sysman/log Here I posted error log file -> **emagent.log** 2018-07-31 11:10:55 Thread-4124031232 Starting Agent 10.1.0.6.0 from /u01/app/oracle/product/10.2.0/db_1 (00701) 2018-07-31 11:10:55 Thread-4124031232 Starting Agent 10.1.0.6.0 from /u01/app/oracle/product/10.2.0/db_1 (00701) 2018-07-31 11:18:41 Thread-4124375296 Starting Agent 10.1.0.6.0 from /u01/app/oracle/product/10.2.0/db_1 (00701) 2018-07-31 11:35:28 Thread-4124748032 Starting Agent 10.1.0.6.0 from /u01/app/oracle/product/10.2.0/db_1 (00701) 2018-07-31 12:03:41 Thread-4124952832 Starting Agent 10.1.0.6.0 from /u01/app/oracle/product/10.2.0/db_1 (00701) 2018-07-31 14:36:27 Thread-4125055232 Starting Agent 10.1.0.6.0 from /u01/app/oracle/product/10.2.0/db_1 (00701) 2018-07-31 15:23:13 Thread-4124195072 Starting Agent 10.1.0.6.0 from /u01/app/oracle/product/10.2.0/db_1 (00701) 2018-07-31 18:19:37 Thread-4124940544 Starting Agent 10.1.0.6.0 from /u01/app/oracle/product/10.2.0/db_1 (00701) and when i am going to start agent is says agent is already running but while checking status it shows the agent is not running [oracle@vvs ~]$ emctl start agent TZ set to Asia/Calcutta Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0 Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved. Agent is already running [oracle@vvs ~]$ emctl status agent TZ set to Asia/Calcutta Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0 Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved. --------------------------------------------------------------- Agent is Not Running And when I'm going to start OEM of this instance it failed but the rest of OEM instance stops working So please let me know how to solve this Problem edited data 2018-08-16 16:47:50 Thread-4090489664 ERROR http: 9: Unable to initialize ssl connection with server, aborting connection attempt 2018-08-16 16:47:50 Thread-4090489664 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://vvs:5502/em/upload/ : retStatus=-1 2018-08-16 16:47:50 Thread-4090489664 ERROR pingManager: Error in updating the agent time stamp file 2018-08-16 16:47:53 Thread-4087339840 ERROR command: nmejcn: error receiving response headers from http://vvs:5502/em/upload/

I need to create a script to start and shut down a 12c database in rhel7 automatically when the operating system starts and shuts down, it turns out that I have tried the common options with dbstart and dbshut, but it only works for the listener, it does nothing with the database instance ... recently I did an migration of asm to the operating system's filesystem for that reason I disabled the start of asm since I didn't need it, I don't know if this would be influencing the dbstart and dbshut scripts Don't start, I have the oratab file like this: myoradb:/u01/app/oracle/db/12.1:Y The truth is that the content of these dbstart and dbshut seems a bit dense and I do not see where the problem could be so that they do not run correctly with the database instance. Is there an example of how to create these scripts manually without using dbstart and dbshut ??? Thanks

I've got a file /etc/mysql/mysqld_multi_cls.cnf with everyting mariadb needs for multiple database instances. I can start these instances with the following command: sudo mariadbd-multi --defaults-file=/etc/mysql/mysqld_multi_cls.cnf start But I can't find a (neat) way to start these instances at boot. Adding the .cnf file in the /conf.d/ folder doesn't start the instance, unless I'm messing up unknowingly. The db is running on a Raspberry pi5, Raspberry Pi OS, which is Debian based. And I am quite unfamiliar/noob with Linux. After request, here is the .cnf file: # Configuration Settings for mysqld_multi , as well as separate instances. # [mysqld_multi] mysqld = /usr/bin/mariadbd-safe mysqladmin = /usr/bin/mariadb-admin [mysqld2] socket = /tmp/mysql.sock2 port = 3307 pid-file = /usr/local/mysql/mdb2/ansible-host1.pid2 datadir = /var/lib/mysql2 log-error = /var/log/mysql2/error.log log-bin = /var/log/mysql2/mdb2-mysql-bin.log server-id = 2 expire-logs-days = 72 sync_binlog = 1 innodb_flush_log_at_trx_commit = 1 innodb_flush_method = O_DIRECT binlog_format = mixed gtid_strict_mode = 1 [mysqld3] socket = /tmp/mysql.sock3 port = 3308 pid-file = /usr/local/mysql/mdb3/ansible-host1.pid3 datadir = /var/lib/mysql3 log-error = /var/log/mysql3/error.log log-bin = /var/log/mysql3/mdb3-mysql-bin.log server-id = 3 expire-logs-days = 64 sync_binlog = 1 innodb_flush_log_at_trx_commit = 1 innodb_flush_method = O_DIRECT binlog_format = mixed gtid_strict_mode = 1 [mysqld4] socket = /tmp/mysql.sock4 port = 3309 pid-file = /usr/local/mysql/mdb4/ansible-host1.pid4 datadir = /var/lib/mysql4 log-error = /var/log/mysql4/error.log log-bin = /var/log/mysql4/mdb4-mysql-bin.log server-id = 4 expire-logs-days = 64 sync_binlog = 1 innodb_flush_log_at_trx_commit = 1 innodb_flush_method = O_DIRECT binlog_format = mixed gtid_strict_mode = 1

I'm on Windows. I installed MySQL 8.4, stopped all services and copied the Data folder and my.ini files into the 8.4 folder but now the 8.4 services does not start and does not produce any logs. I can't find an answer that doesn't involved either replacing the data (ie what I did) or replacing the binaries (which is what I did just the other way around). What is the correct way to do this?

I have installed MariaDB via brew and each time I restart my computer I need to start it manually by brew services start mariadb@10.5 Also I cannot find mariadb listed in the "Login Items" in Settings > General How do I make mariadb appear in the "Login Items"? Thank you in advance.

I have configured SCCM with a remote SQL server in the same domain, and it is working fine. When I stop the SMS_EXECUTIVE service fo SCCM and SQL server in the remote machine, SQL server gets started automatically in a few minutes. I want to know who is responsible for automatically starting the SQL Server after manually stopping it. Before configuring SCCM server with that SQL instance, it never happened. I have disabled the SQL Server Agent automatic restart of SQL server, so it can't be responsible. Also I have not setup any recovery actions in services too I also tried to check in taskschd.msc, don't have a clue on how to check this, attaching a screenshot for reference. I want to know if SCCM is responsible for this behaviour(if so, how can I confirm that), or any scheduler or something is configured(automatically in the backend like a scheduler) in SQL server machine itself during the configuration of SCCM server.

I was following along a course and entered a command that was given

mongod --dbpath=data --bind_ip 127.0.0.1

In the past, I had used mongo and it had worked, but I'm sure I had never entered this command. Now when I try to launch mongo via terminal I get this error:

MongoDB shell version v4.4.0
connecting to: mongodb://127.0.0.1:27017/?compressors=disabled&gssapiServiceName=mongodb
Error: couldn't connect to server 127.0.0.1:27017, connection attempt failed: SocketException: Error connecting to 127.0.0.1:27017 :: caused by :: Connection refused :
connect@src/mongo/shell/mongo.js:362:17
@(connect):2:6
exception: connect failed
exiting with code 1

Whenever I try to start up mongod I get this error:

{"t":{"$date":"2020-08-24T10:50:51.683+02:00"},"s":"I",  "c":"CONTROL",  "id":23285,   "ctx":"main","msg":"Automatically disabling TLS 1.0, to force-enable TLS 1.0 specify --sslDisabledProtocols 'none'"}
{"t":{"$date":"2020-08-24T10:50:51.715+02:00"},"s":"W",  "c":"ASIO",     "id":22601,   "ctx":"main","msg":"No TransportLayer configured during NetworkInterface startup"}
{"t":{"$date":"2020-08-24T10:50:51.716+02:00"},"s":"I",  "c":"NETWORK",  "id":4648602, "ctx":"main","msg":"Implicit TCP FastOpen in use."}
{"t":{"$date":"2020-08-24T10:50:51.721+02:00"},"s":"I",  "c":"STORAGE",  "id":4615611, "ctx":"initandlisten","msg":"MongoDB starting","attr":{"pid":51965,"port":27017,"dbPath":"/data/db","architecture":"64-bit","host":"22biedermann-p"}}
{"t":{"$date":"2020-08-24T10:50:51.721+02:00"},"s":"I",  "c":"CONTROL",  "id":23403,   "ctx":"initandlisten","msg":"Build Info","attr":{"buildInfo":{"version":"4.4.0","gitVersion":"563487e100c4215e2dce98d0af2a6a5a2d67c5cf","modules":[],"allocator":"system","environment":{"distarch":"x86_64","target_arch":"x86_64"}}}}
{"t":{"$date":"2020-08-24T10:50:51.722+02:00"},"s":"I",  "c":"CONTROL",  "id":51765,   "ctx":"initandlisten","msg":"Operating System","attr":{"os":{"name":"Mac OS X","version":"18.7.0"}}}
{"t":{"$date":"2020-08-24T10:50:51.722+02:00"},"s":"I",  "c":"CONTROL",  "id":21951,   "ctx":"initandlisten","msg":"Options set by command line","attr":{"options":{}}}
{"t":{"$date":"2020-08-24T10:50:51.731+02:00"},"s":"E",  "c":"STORAGE",  "id":20557,   "ctx":"initandlisten","msg":"DBException in initAndListen, terminating","attr":{"error":"NonExistentPath: Data directory /data/db not found. Create the missing directory or specify another path using (1) the --dbpath command line option, or (2) by adding the 'storage.dbPath' option in the configuration file."}}
{"t":{"$date":"2020-08-24T10:50:51.732+02:00"},"s":"I",  "c":"NETWORK",  "id":20562,   "ctx":"initandlisten","msg":"Shutdown: going to close listening sockets"}
{"t":{"$date":"2020-08-24T10:50:51.732+02:00"},"s":"I",  "c":"-",        "id":20520,   "ctx":"initandlisten","msg":"Stopping further Flow Control ticket acquisitions."}
{"t":{"$date":"2020-08-24T10:50:51.733+02:00"},"s":"I",  "c":"CONTROL",  "id":20565,   "ctx":"initandlisten","msg":"Now exiting"}
{"t":{"$date":"2020-08-24T10:50:51.733+02:00"},"s":"I",  "c":"CONTROL",  "id":23138,   "ctx":"initandlisten","msg":"Shutting down","attr":{"exitCode":100}}

I have been googling and trying to find different solutions but I have no clue how to proceed. I am using Mac OS.

I installed the Oracle 11g server on Ubuntu 12.10. But I can't start the server. When I start up the server, the following error occurs: SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/xe/dbs/initXE.ora' How can I solve this issue? I think the connect failed because target host or object does not exist. How can a target host be specified? Running: $ ls -latr /u01/app/oracle/product/11.2.0/xe/dbs/initXE.ora returns: -rw-r--r-- 1 oracle dba 2637 Mar 13 17:07 /u01/app/oracle/product/11.2.0/xe/dbs/initxe.ora Running echo $ORACLE_SID displays nothing - an empty line.

Running a Mac. I installed Postgresql 9 many years ago and configured it to auto-start. Now I have upgraded to version 12 using brew, but on system restart version 9 server is still starting automatically. I don't know how to determine what is starting it, I don't see anything in my bash_profile and I don't see a feature in brew or pg_ctl that allows me to disable an auto-start configuration. I have no postgres files in /Library/LaunchAgents either. Thanks

I have installed an Oracle 12c database on my development environment, which I start only once a while for integration testing. But today, it does not seem to start, or did it start but does not allow connections? Here are some clues: - OS is Debian 8 - I use a shell script to start and stop the database - **$ORACLE_SID** contains > INFO - The **hosts** file contains > 127.0.0.1 localhost and 127.0.1.1 Strada.nohoo.biz Strada - The **/u01/app/oracle/diag/rdbms/info/INFO/alert_INFO.log** file ends with > Completed: ALTER DATABASE OPEN Sun Mar 11 20:27:57 2018 Shared IO Pool > defaulting to 112MB. Trying to get it from Buffer Cache for process > 4294. > =========================================================== Dumping current patch information > =========================================================== No patches have been applied > =========================================================== Sun Mar 11 20:27:57 2018 db_recovery_file_dest_size of 4560 MB is 0.00% used. > This is a user-specified limit on the amount of space that will be > used by this database for recovery-related files, and does not reflect > the amount of space available in the underlying filesystem or ASM > diskgroup. - **tnsping** INFO returns > TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on > 11-MAR-2018 21:42:22 > > Copyright (c) 1997, 2014, Oracle. All rights reserved. > > Used parameter files: > /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora > > > Used TNSNAMES adapter to resolve the alias Attempting to contact > (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = > 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = > INFO.nohoo.biz))) > > OK (0 msec) - **tnsnames.ora** contains > INFO = > (DESCRIPTION = > (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) > (CONNECT_DATA = > (SERVER = DEDICATED) > (SERVICE_NAME = INFO.nohoo.biz) > ) > ) - **listner.ora** contains > LISTENER = > (DESCRIPTION_LIST = > (DESCRIPTION = > (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) > ) > ) - **lsnrctl services** returns > LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 11-MAR-2018 > 21:54:24 > > Copyright (c) 1991, 2014, Oracle. All rights reserved. > > Connecting to > (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))) > > The listener supports no services > > > The command completed successfully - The **ps -A | grep ora** command in a shell returns a list of > 6003 ? 00:00:00 ora_pmon_info > 6005 ? 00:00:00 ora_psp0_info > 6007 ? 00:00:00 ora_vktm_info > 6011 ? 00:00:00 ora_gen0_info > 6013 ? 00:00:00 ora_mman_info > 6017 ? 00:00:00 ora_diag_info > 6019 ? 00:00:00 ora_dbrm_info > 6021 ? 00:00:00 ora_vkrm_info > 6023 ? 00:00:00 ora_dia0_info > 6025 ? 00:00:00 ora_dbw0_info > 6027 ? 00:00:00 ora_lgwr_info > 6029 ? 00:00:00 ora_ckpt_info But all this does not look like a successful situation! And finally, trying to connect with SQLplus ends up with > ORA-12547: TNS:lost contact Thanks for you help!

I'm trying to answer the following question (asked in a previous exam and supposedly having one correct answer): > To create a DATAFILE and Assign it to a DATABASE, the instance can't be > > 1. started in NOMOUNT mode > 2. started in MOUNT mode > 3. started in OPEN mode > 4. not started To this end, I started reading the relevant Oracle documentation in the article Database and Instance Startup and Shutdown . In the section *How a Database is Mounted*, the following was stated (emphasis mine):
> How a Database is Mounted > = > The instance mounts a database to associate the database with that > instance. To mount the database, the instance finds the database > control files and opens them. Control files are specified in the > CONTROL_FILES initialization parameter in the parameter file used to > start the instance. Oracle then reads the control files to get the > names of the database's datafiles and redo log files. > > At this point, ***the database is still closed and is accessible only to > the database administrator***. The database administrator can keep the > database closed while completing specific maintenance operations. > However, the database is not yet available for normal operations. According to this passage, when the database is mounted it can be accessed by the database administrator. Does *access* here mean that the administrator can only perform read operations, or can also modify the database (e.g. by creating a datafile)?

I did an in place upgrade for host OS from Windows server 2012 R2 to windows server 2022. After this move, I noticed the SQL server 2017 enterprise edition instance therein does not start automatically across reboots; but picks up when manually started from services. Any possible cause for this? This is a box purely dedicated to the SQL server.

The OS is Ubuntu 20.04. I moved the data directory to a secondary disk. In the "Disks" utility, I clicked "Edit Mount Options", turned off "User Session Defaults", and specified a hard-coded Mount Point like /mnt/database, because by default it was mounted at something like /media/[user name]/disk label. "Mount at system startup" had been checked (unchanged from default). Now, postgresql's automatic start at the system startup fails with a message like: "[data directory] is not accessible or does not exist". If I manually start it, by executing sudo systemctl start postgresql it starts fine. I suspect that the system tried to start postgresql before the secondary disk was automatically mounted. Is that so? If that is the case, how can I make it start after the secondary disk has been mounted?

I have been running Postgres on a Linode with the data directory mapped to an external volume. Yesterday Linode prompted me to upgrade my storage to NVMe so I did. Unfortunately, following that, Postgres is unable to start. When I attempt to start the process it just hangs with no output. It is also impossible to stop at that point, implying that it is in an "uninterruptable sleep" state. I've started Postgres with debug enabled and it doesn't output anything useful (as best I can tell):

2022-03-11 01:39:36 EST [1752-1] DEBUG:  postgres: PostmasterMain: initial environment dump:
2022-03-11 01:39:36 EST [1752-2] DEBUG:  -----------------------------------------
2022-03-11 01:39:36 EST [1752-3] DEBUG:  	TERM=xterm-256color
2022-03-11 01:39:36 EST [1752-4] DEBUG:  	LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=00:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arc=01;31:*.arj=01;31:*.taz=01;31:*.lha=01;31:*.lz4=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.tzo=01;31:*.t7z=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lrz=01;31:*.lz=01;31:*.lzo=01;31:*.xz=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.war=01;31:*.ear=01;31:*.sar=01;31:*.rar=01;31:*.alz=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.cab=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.webm=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=00;36:*.au=00;36:*.flac=00;36:*.m4a=00;36:*.mid=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mpc=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36:*.oga=00;36:*.opus=00;36:*.spx=00;36:*.xspf=00;36:
2022-03-11 01:39:36 EST [1752-5] DEBUG:  	PATH=/home/user/bin:/home/user/.nvm/versions/node/v14.17.0/bin:/home/user/.cargo/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games
2022-03-11 01:39:36 EST [1752-6] DEBUG:  	LANG=en_ZA.UTF-8
2022-03-11 01:39:36 EST [1752-7] DEBUG:  	HOME=/home/user
2022-03-11 01:39:36 EST [1752-8] DEBUG:  	MAIL=/var/mail/postgres
2022-03-11 01:39:36 EST [1752-9] DEBUG:  	LOGNAME=postgres
2022-03-11 01:39:36 EST [1752-10] DEBUG:  	USER=postgres
2022-03-11 01:39:36 EST [1752-11] DEBUG:  	USERNAME=postgres
2022-03-11 01:39:36 EST [1752-12] DEBUG:  	SHELL=/bin/bash
2022-03-11 01:39:36 EST [1752-13] DEBUG:  	SUDO_COMMAND=/usr/lib/postgresql/9.6/bin/postgres -d 3 -D /mnt/project-backup/postgres/project/data -c config_file=/etc/postgresql/9.6/project_db/postgresql.conf
2022-03-11 01:39:36 EST [1752-14] DEBUG:  	SUDO_USER=user
2022-03-11 01:39:36 EST [1752-15] DEBUG:  	SUDO_UID=1000
2022-03-11 01:39:36 EST [1752-16] DEBUG:  	SUDO_GID=1000
2022-03-11 01:39:36 EST [1752-17] DEBUG:  	PGLOCALEDIR=/usr/share/locale
2022-03-11 01:39:36 EST [1752-18] DEBUG:  	PGSYSCONFDIR=/etc/postgresql-common
2022-03-11 01:39:36 EST [1752-19] DEBUG:  	LC_COLLATE=en_ZA.UTF-8
2022-03-11 01:39:36 EST [1752-20] DEBUG:  	LC_CTYPE=en_ZA.UTF-8
2022-03-11 01:39:36 EST [1752-21] DEBUG:  	LC_MESSAGES=en_ZA.UTF-8
2022-03-11 01:39:36 EST [1752-22] DEBUG:  	LC_MONETARY=C
2022-03-11 01:39:36 EST [1752-23] DEBUG:  	LC_NUMERIC=C
2022-03-11 01:39:36 EST [1752-24] DEBUG:  	LC_TIME=C
2022-03-11 01:39:36 EST [1752-25] DEBUG:  -----------------------------------------

When I look in the process's file descriptor folder I also don't see anything obviously weird:

lrwx------ 1 postgres postgres 64 Mar 11 01:39 0 -> /dev/pts/0
lrwx------ 1 postgres postgres 64 Mar 11 01:39 1 -> /dev/pts/0
lrwx------ 1 postgres postgres 64 Mar 11 01:39 2 -> /dev/pts/0
lr-x------ 1 postgres postgres 64 Mar 11 01:39 3 -> /dev/urandom
lrwx------ 1 postgres postgres 64 Mar 11 01:39 4 -> /mnt/project-backup/postgres/project/data/postmaster.pid

The postmaster.pid file looks like this:

1752
/mnt/project-backup/postgres/project/data
1646980776
5437

Any idea what could be happening here and how I can fix it? If I can't recover the current situation is there at least any way to recover the data through some other means?

I need to execute a request (Stored Procedure) to MS SQL Server after Windows restart, i.e. as soon as the database is accessible. How can I do that? Is there a possibility to register a database event that fires after startup or a system event after a service started (here: SQL Server Service)?

I am planning a move of Postgres' data directory from one disk to another on a CentOS 7 server. All of the data and configuration files reside in /var/lib/pgsql/12/data/. I have previously migrated data directories before, but this time I am going to migrate the configuration files (postgresql.conf, pg_hba.conf, etc.) from the existing data directory to a new one in /etc. I see that the postgresql.conf file has the following file location configurations, with the caveat that they are driven from the -D option on startup, however startup is managed through systemctl:

#data_directory = 'ConfigDir'
#hba_file = 'ConfigDir/pg_hba.conf'
#ident_file = 'ConfigDir/pg_ident.conf'

So my question is: Will the changes in postgresql.conf be all that needs to occur so the database starts up after migration -OR- is there something within systemctl that needs to change in tandem with the configuration so it starts up as expected?

On Windows Server 2008 R2, when I am trying to startup Oracle 11g database it shows an error: SQL> startup ORACLE instance started. Total System Global Area 3206836224 bytes Fixed Size 2180024 bytes Variable Size 1996491848 bytes Database Buffers 1191182336 bytes Redo Buffers 16982016 bytes ORA-00204: error in reading (block 3, # blocks 8) of control file ORA-00202: control file: 'D:\APP\FROZEN\ORADATA\ORCL\CONTROL01.CTL' ORA-27070: async read/write failed OSD-04006: ReadFile() failure, unable to read from file O/S-Error: (OS 1117) The request could not be performed because of an I/O device error. The disk is online. Can any one help me how to resolve this issue?

I've installed MongoDB 3.0 in RHEL 6. From root user, I'm trying to start the mongo service but it is getting failed and the log file is not getting updated as well.

2015-10-13T09:53:26.133+0530 E NETWORK  [initandlisten] Failed to unlink socket file /tmp/mongodb-27017.sock errno:1 Operation not permitted
2015-10-13T09:53:26.133+0530 I -        [initandlisten] Fatal Assertion 28578
2015-10-13T09:53:26.133+0530 I -        [initandlisten]
    
***aborting after fassert() failure

The above is the last updated log. I have another user 'oracle' from which also it is not starting. I also tried running mongod --repair It gives:

2015-10-13T11:02:59.473+0530 I CONTROL  [initandlisten] MongoDB starting : pid=11033 port=27017 dbpath=/data/db 64-bit host=vmrac2 
2015-10-13T11:02:59.473+0530 I CONTROL  [initandlisten] ** WARNING: You are running this process as the root user, which is not recommended. 
2015-10-13T11:02:59.473+0530 I CONTROL  [initandlisten] 2015-10-13T11:02:59.474+0530 I CONTROL  [initandlisten] 
2015-10-13T11:02:59.474+0530 I CONTROL  [initandlisten] ** WARNING: You are running on a NUMA machine. 
2015-10-13T11:02:59.474+0530 I CONTROL  [initandlisten] **          We suggest launching mongod like this to avoid performance problems: 
2015-10-13T11:02:59.474+0530 I CONTROL  [initandlisten] **              numactl --interleave=all mongod [other options] 
2015-10-13T11:02:59.474+0530 I CONTROL  [initandlisten] 
2015-10-13T11:02:59.474+0530 I CONTROL  [initandlisten] ** WARNING: /sys/kernel/mm/transparent_hugepage/enabled is 'always'. 
2015-10-13T11:02:59.474+0530 I CONTROL  [initandlisten] **        We suggest setting it to 'never' 
2015-10-13T11:02:59.474+0530 I CONTROL  [initandlisten] 
2015-10-13T11:02:59.474+0530 I CONTROL  [initandlisten] ** WARNING: /sys/kernel/mm/transparent_hugepage/defrag is 'always'. 
2015-10-13T11:02:59.474+0530 I CONTROL  [initandlisten] **        We suggest setting it to 'never' 
2015-10-13T11:02:59.474+0530 I CONTROL  [initandlisten] 
2015-10-13T11:02:59.474+0530 I CONTROL  [initandlisten] ** WARNING: soft rlimits too low. rlimits set to 16384 processes, 65536 files. Number of processes should be at least 32768 : 0.5 times number of files. 
2015-10-13T11:02:59.474+0530 I CONTROL  [initandlisten] 
2015-10-13T11:02:59.474+0530 I CONTROL  [initandlisten] db version v3.0.6 
2015-10-13T11:02:59.474+0530 I CONTROL  [initandlisten] git version: 1ef45a23a4c5e3480ac919b28afcba3c615488f2 
2015-10-13T11:02:59.474+0530 I CONTROL  [initandlisten] build info: Linux ip-10-67-194-123 2.6.32-220.el6.x86_64 #1 SMP Wed Nov 9 08:03:13 EST 2011 x86_64 BOOST_LIB_VERSION=1_49 
2015-10-13T11:02:59.474+0530 I CONTROL  [initandlisten] allocator: tcmalloc 
2015-10-13T11:02:59.474+0530 I CONTROL  [initandlisten] options: { repair: true } 
2015-10-13T11:02:59.474+0530 I STORAGE  [initandlisten] finished checking dbs 
2015-10-13T11:02:59.474+0530 I CONTROL  [initandlisten] now exiting 
2015-10-13T11:02:59.474+0530 I NETWORK  [initandlisten] shutdown: going to close listening sockets... 
2015-10-13T11:02:59.474+0530 I NETWORK  [initandlisten] removing socket file: /tmp/mongodb-27017.sock 
2015-10-13T11:02:59.474+0530 I NETWORK  [initandlisten] shutdown: going to flush diaglog... 
2015-10-13T11:02:59.474+0530 I NETWORK  [initandlisten] shutdown: going to close sockets... 
2015-10-13T11:02:59.474+0530 I STORAGE  [initandlisten] shutdown: waiting for fs preallocator... 
2015-10-13T11:02:59.474+0530 I STORAGE  [initandlisten] shutdown: closing all files... 
2015-10-13T11:02:59.474+0530 I STORAGE  [initandlisten] closeAllFiles() finished 
2015-10-13T11:02:59.474+0530 I STORAGE  [initandlisten] shutdown: removing fs lock... 
2015-10-13T11:02:59.475+0530 I CONTROL  [initandlisten] dbexit:  rc: 0

Things I have tried: * Deleting /tmp/mongodb-27017.sock but it says no file found with that name. * Changing the net.port in the config file to change the .sock file. * Setting unixDomainSocket : enabled: false