Mysql down after restarting server

I have an Ubuntu 16.04 server with ISPConfig 3.1.

For some reason, the server was working too much on a process with high load, so I restarted the PC. After that, Mysql stopped working and couldn’t be restarted anymore.

I got these messages after trying to restart the service:

Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details. 

systemctl status mysql.service:

● mysql.service - LSB: Start and stop the mysql database server daemon Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled) Active: failed (Result: exit-code) since jue 2019-08-22 18:58:05 -04; 41s ago Docs: man:systemd-sysv-generator(8) Process: 12020 ExecStop=/etc/init.d/mysql stop (code=exited, status=0/SUCCESS) Process: 12056 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE) 

journalctl -xe:

ago 22 18:58:32 servidor1 mysqld[12230]: /usr/sbin/mysqld[0x955d0c] ago 22 18:58:32 servidor1 mysqld[12230]: /usr/sbin/mysqld[0x93b08e] ago 22 18:58:32 servidor1 mysqld[12230]: /usr/sbin/mysqld[0x93cd7f] ago 22 18:58:32 servidor1 mysqld[12230]: /usr/sbin/mysqld[0xa1dd9d] ago 22 18:58:32 servidor1 mysqld[12230]: /usr/sbin/mysqld[0xa670b6] ago 22 18:58:32 servidor1 mysqld[12230]: /usr/sbin/mysqld[0x9ba375] ago 22 18:58:32 servidor1 mysqld[12230]: /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f8ba90256ba] ago 22 18:58:32 servidor1 mysqld[12230]: x86_64/clone.S:111(clone)[0x7f8ba84cc41d] ago 22 18:58:32 servidor1 mysqld[12230]: The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains ago 22 18:58:32 servidor1 mysqld[12230]: information that should help you find out what is causing the crash.   ago 22 18:58:52 servidor1 dovecot[904]: auth-worker(12400): Error: sql(dmiranda@comercialkod.cl,152.172.252.195): Password query failed: Not connected to database ago 22 18:58:52 servidor1 dovecot[904]: auth: Error: auth worker: Aborted PASSV request for dmiranda@comercialkod.cl: Lookup timed out ago 22 18:58:52 servidor1 dovecot[904]: auth-worker(12673): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server throug ago 22 18:58:53 servidor1 dovecot[904]: auth-worker(12673): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server throug ago 22 18:58:54 servidor1 dovecot[904]: imap-login: Aborted login (auth failed, 1 attempts in 62 secs): user=<dmiranda@comercialkod.cl>, method=PLAIN, rip=152.172.252.19 ago 22 18:58:58 servidor1 dovecot[904]: auth-worker(12673): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server throug ago 22 18:59:01 servidor1 CRON[12687]: pam_unix(cron:session): session opened for user root by (uid=0) ago 22 18:59:01 servidor1 CRON[12686]: pam_unix(cron:session): session opened for user root by (uid=0) ago 22 18:59:01 servidor1 CRON[12688]: (root) CMD (/usr/local/ispconfig/server/cron.sh 2>&1 | while read line; do echo `/bin/date` "$  line" >> /var/log/ispconfig/cron.log ago 22 18:59:01 servidor1 CRON[12689]: (root) CMD (/usr/local/ispconfig/server/server.sh 2>&1 | while read line; do echo `/bin/date` "$  line" >> /var/log/ispconfig/cron.l ago 22 18:59:01 servidor1 CRON[12686]: pam_unix(cron:session): session closed for user root ago 22 18:59:23 servidor1 dovecot[904]: auth-worker(12673): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server throug ago 22 18:59:25 servidor1 su[12004]: pam_unix(su:session): session closed for user root ago 22 18:59:25 servidor1 sudo[12003]: pam_unix(sudo:session): session closed for user root ago 22 18:59:27 servidor1 dovecot[904]: auth-worker(12673): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server throug ago 22 18:59:28 servidor1 dovecot[904]: auth-worker(12673): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server throug ago 22 18:59:33 servidor1 dovecot[904]: auth-worker(12673): Error: mysql(localhost): Connect failed to database (dbispconfig): Can't connect to local MySQL server throug ago 22 18:59:34 servidor1 sudo[12790]: surempresa : TTY=pts/20 ; PWD=/home/surempresa ; USER=root ; COMMAND=/bin/su ago 22 18:59:34 servidor1 sudo[12790]: pam_unix(sudo:session): session opened for user root by (uid=0) ago 22 18:59:34 servidor1 su[12809]: Successful su for root by root ago 22 18:59:34 servidor1 su[12809]: + /dev/pts/20 root:root ago 22 18:59:34 servidor1 su[12809]: pam_unix(su:session): session opened for user root by (uid=0) ago 22 18:59:34 servidor1 su[12809]: pam_systemd(su:session): Cannot create session: Already running in a session 

However, I managed to restart the service after I tried the solution from this post:

Can't start MySQL server (database corruption)

So I set:

[mysqld] innodb_force_recovery = 1 

But, it doesn’t work well since some database tables are now read only.

What should I do instead? Thank you.

AppFabricCachingService status’ Down’

I’m running SP2013 Enterprise and this is in my QA environment, not production. Recently my WFE became unresponsive. I removed it from the farm, ran get-SPproducts -local on the other servers (2 APP Servers, one of which is dedicated to SSRS) and then readded the WFE to the farm. This fixed the issue with the WFE not responding.

However the Health Analyzer started displaying “This Distributed Cache host may cause cache reliability problems.” on the WFE. The AppFabric Caching Service is showing disabled in the services. When I run Get-CacheHost is shows as DOWN. The other 2 hosts are UP.

When I looked at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\AppFabric\V1.0\Configuration the ConnectionString and Provider values were empty so I looked at a healthy host and added those values in. I left the AdminConfigured and ServiceConfigured values set to 0, even though these were set to 1 on the healthy host, thinking this was set once the host was started up.

When I run 'Start-CacheHost –ComputerName WFE –CachePort 22233' it returns:

Start-CacheHost : Cannot start service AppFabricCachingService on computer’WFE.Company.Local’. At line:1 char:1 + Start-CacheHost -ComputerName WFE -CachePort 22233 + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [Start-AFCacheHost], InvalidOperationException + FullyQualifiedErrorId : System.InvalidOperationException,Microsoft.ApplicationServer.Caching.Commands.StartAFCacheHostCommand

Add-SPDistributedCacheServiceInstance did not return an error howver the AppFabric Caching Service did not start up.

There is quite a bit of guidance out there on troubleshooting and getting a host set up, or restarted. Before I try anything else I thought I’d get some feedback and suggestions from folks here.

Why don’t some websites get shut down for illegal content? [on hold]

There is a cracking-related clearnet forums out there (.com domain) with thousands of active users, many of who are permitted to sell verified bank accounts (that come with information such as SSNs), verified PayPals, fake IDs and passports, cracking tools, stolen accounts, and so on.

Even though the admin claims to ‘ban’ discussion of such content, most of the forum staff lets users get away with it anyway for the sake of more forum activity.

Are they bound to get shut down and in legal trouble eventually (particularly since the admin’s identity is not fully private), or can they go on for many years without issues? The website has already been breached this year and its database and source code leaked.

Displaying multiple column data in a drop down menu

I’m using SP2010 unfortunately without SP Designer and only used InfoPath once.

I have 2 lists:

  • List A – Is a list of ‘Event Codes’ with a ‘status’ column displaying Active, Used or Reserved status for each Event Code.

  • List B – Has a look up column displaying an Event Code from List A.

When adding a new item to List B and selecting an event code from the drop down box, I want to view all event codes and their allocated status next to each event code.

In effect having data from two columns displaying in the drop down menu.

https://drive.google.com/open?id=0B2-gTzHQ8fwVWlJ2dTItTzUxWmQxWjM2MjNITURtdDVNcEtn

how to get cascading drop down values from two child columns

I have a cascading drop down where if I select a value from the parent column, I want the child column to be populate it with values from two potential matching columns in the relationship list (i.e two relation ship list child columns)

$  ().SPServices.SPCascadeDropdowns(       {           relationshipList: "AGSL HCP DB",          relationshipListParentColumn: "Doctor_x003a__speciality",           relationshipListChildColumn: "Clinic_x0020_1_x003A_Town" "Clinic_x0020_2_x003A_Town",   **<<<<---- these are the two columns I want to check results from when speciality is selected**         parentColumn: "Specialties",           childColumn: "ClinicLocality",           debug: true       });  

is there a way to achieve this maybe with CAML Query?

How to change volume by just pressing down instead of clicking multiple times?

I’ve recently installed Linux (currently Mint 19.2, Cinnamon)…

I have a keyboard shortcut for volume increase/decrease, but I want to just hold them down to increase them to max. However, that doesn’t work and I have to resort to clicking the volume key multiple times…

Googled, searched through this forum but seems like there aren’t a lot of answers to the questions…

How do you lock down a users access to ODBC settings in Windows 10?

I was working with a users computer yesterday because they complained that an MS-Access Database they were using said that an ODBC datasource was not accessible.

I went to change the settings on the ODBC data source (which was under the systems tab) and no matter which account I logged in with I could not click the data source in question or the ‘Configuration’ button in ‘%windir%\System32\odbcad32.exe’

Is there a group policy or Windows permission that controls access to this?

If so, it seems really good for information security.

Display image on drop down selection change newitem form

I’m building a list where I want to show an image of the selected item as it’s selected in the drop down in the new item form, I have very little javascript knowledge. I’m using the following script

<img id="my_image" src="/mysites/site/AL-03T.PNG" alt="" style="width: 48px;  height: 48px;"/><script src="https://code.jquery.com/jquery-1.7.2.min.js"  type="text/javascript"></script><script type="text/javascript"> $  (document).ready(function(){ $  ("select[title='Product']").change(function() {   document.getElementById("my_image").attr('src',"/mysites/site/" + (select[title='Product']).val() + '.PNG'"); }); }); </script>  <img id="my_image" alt=""/> 

based on this answer

Load image depending of selected value of dropdown list – SharePoint Online

can someone help?