# Container specific

### <span class="mw-headline" id="bkmrk-mysql-1">MySQL</span>

##### <span class="mw-headline" id="bkmrk-error-migrating-from-1">Error migrating from 5.x to 8.x</span>

Error messages

- ORDER BY clause is not in SELECT list, references column ... (\[[more](https://stackoverflow.com/questions/36829911/how-to-resolve-order-by-clause-is-not-in-select-list-caused-mysql-5-7-with-sel%7Clearn)\])
- Invalid default value for 'CreatedAt' (\[[more](https://stackoverflow.com/questions/36374335/error-in-mysql-when-setting-default-value-for-date-or-datetime%7Clearn)\])

The default SQL mode is causing trouble:

- ONLY\_FULL\_GROUP\_BY (prevent order on fields not selected)
- STRICT\_TRANS\_TABLES (prevent default date values)
- NO\_AUTO\_VALUE\_ON\_ZERO (allow default date values)

Temporary fix

```mysql
SET GLOBAL sql_mode='NO_AUTO_VALUE_ON_ZERO';
```

Permanent fix Set it in the configuration file

1. Open my.ini
2. Replace sql\_mode definition with

```ini
sql_mode="NO_AUTO_VALUE_ON_ZERO"
```

##### <span id="bkmrk-"></span><span class="mw-headline" id="bkmrk-driver-for-%2B8.4-not--1">Driver for +8.4 not being used</span>

Make sure that the 8.4 driver is present in

- TOMCAT\\lib
- TOMCAT\\webapps\\XXX\\WEB-INF\\lib

In the application context file: TOMCAT\\conf\\Catalina\\localhost\\XXX.xml

```
driverClassName=com.mysql.jdbc.Driver
```

Should be changed to (simply add '.cj')

```
driverClassName=com.mysql.cj.jdbc.Driver
```

#### <span class="mw-headline" id="bkmrk-import-timeouts-1">Import timeouts</span>

Sometimes large blobs will cause timeouts when running the mysql tool

- Create a config file with (example import.cnf)

```ini
[mysqld]
max_allowed_packet=1024M
innodb_lock_wait_timeout=3600
net_read_timeout=3600
net_write_timeout=3600
wait_timeout=3600
innodb_log_file_size=2048M
innodb_log_buffer_size=2048M
bulk_insert_buffer_size=1024M
```

- Then a parameter in the import --

```powershell
mysql.exe --defaults-file=import.cnf ... 
```

##### <span class="mw-headline" id="bkmrk-unable-to-restart-se-1">Unable to restart services</span>

Kill the underlying processes for both webserver and database

```bash
sudo killall -KILL mysqld_safe mysqld
```

If you cannot start MySQL again try removing the logfiles

```bash
sudo mv /mnt/sda/mysql/ib_logfile0 /mnt/sda/backup/
sudo mv /mnt/sda/mysql/ib_logfile1 /mnt/sda/backup/
sudo mv /mnt/sda/mysql/ibdata1 /mnt/sda/backup/
```

In some cases DB table repairs are needed

```bash
sudo nano /etc/my.cnf
```

Add the line

```ini
innodb_force_recovery = 1
```

#### <span class="mw-headline" id="bkmrk-recover-data-from-ba-1">Recover data from backup</span>

Create a restore script

```bash
 sudo nano ./restoreall.sh
 chmod 777 ./restoreall.sh
```

Add the following

```bash
APP="ts"

for sql_file in `ls /mnt/sda/backup/rsync/${APP}base_*.sql`;
do mysql -uroot -pPASSWORD ${APP}base < $sql_file ;
done

for sql_file in `ls /mnt/sda/backup/rsync/${APP}live_*.sql`;
do mysql -uroot -pPASSWORD ${APP}live < $sql_file ;
done

for sql_file in `ls /mnt/sda/backup/rsync/${APP}test_*.sql`;
do mysql -uroot -pPASSWORD ${APP}test < $sql_file ;
done
```

#### <span class="mw-headline" id="bkmrk-encoding-problems-wi-1">Encoding problems with SQL dumps</span>

If it is caused by special characters (æøå) in the sql files

1. Open the .sql file in Notepad++
2. Set encoding to ANSI
3. Save

### <span class="mw-headline" id="bkmrk-tomcat-1">Tomcat</span>

##### <span class="mw-headline" id="bkmrk-warning-during-serve-1">Warning during server stop</span>

Example

> *SEVERE: The web application \[/sandbox\] registered the JDBC driver \[com.mysql.jdbc.Driver\] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.*

The warning is of no importance because the shutdown automatically kills all objects in memory, and no memory leaks are there possible.

### <span class="mw-headline" id="bkmrk-jboss-1">JBoss</span>

##### <span class="mw-headline" id="bkmrk-warn-errors-during-b-1">WARN errors during boot</span>

Example

> *17:56:40,337 WARN \[org.jboss.as.server.deployment\] (MSC service thread 1-12) Class Path entry* ...

The warnings are due to jar taht have their version number appended to their name. Possible fixes include stripping the names of all jar files in the /WEB-INF/lib/, but recommended solution is ignoring the warnings.