Jump to content

albion01

Members
 View Profile  See their activity

  • Posts

    4

  • Joined

  • Last visited

 Content Type 

Posts posted by albion01

    Questions about a major motherboard upgrade.

    in General Support

    Posted

    Unraid has been the flagship of my Home Lab for many years. Worth every penny. Kudos to the developers. It's been running on a 4th gen Intel i7 with 32gig.  It has 3 4TB spinners, a 2TB spinner and 2 SSDs.  I've purchased a 9th gen Intel i7 mb with 32gig for the upgrade.

     

    I've read some of the forum/reddit posts about upgrades like this. It seems like a fairly simple process. My concern is the generation gap. I'm moving rom a 4th gen to a 9th gen. A lot can happen in 5 generations of a CPU and Chipsets. Is there anything I should be aware of or look out for?

     

    -Craig

    Cache drives in unassigned devices?

    in General Support

    Posted

    On 5/8/2020 at 2:03 AM, JorgeB said:

    You'll destroy the pool doing that, for the future the correct procedure would be:

     

    Stop the array, if Docker/VM services are using the cache pool disable them, unassign all cache devices, start array to make Unraid "forget" current cache config, stop array, reassign all cache devices, re-enable Docker/VMs if needed, start array.

     

    Alternatively you can also do a new config and reassign all devices, then check parity is already valid before starting the array.

     

    Lost a power supply, after replacing the unit my raid came up with one of the Cache Pool drives unassigned. This solution worked great to get my dockers and VMs back.

     

    Thanks!

    • Like 1

    [Support] uberchuckie - observium

    in Docker Containers

    Posted

    13 hours ago, uberchuckie said:

    Having the MariaDB log file is useful. I'm not sure if the problem is the same as the others are having but the symptoms are the same where MariaDB is not starting.

     

    The problem here is the redo log is preventing the MariaDB to upgrade from 10.4 to 10.5.

     

    You can try reverting to image tag 2.0.2, shutdown and see if the redo gets processed properly then move the latest again.

     

    The other thing you can try is to just delete the /config/databases/ib_logfile* before trying to start the container. You may potentially lose transactions that were not committed but that's probably fine.

    I've tried removing ib_logfile (renamed it to old_ib_logfile0).  No change, the web UI still gives me "DB Error 2002: No such file or directory".  I'm not sure I understand what you mean by "reverting to image tag 2.0.2." 

    [Support] uberchuckie - observium

    in Docker Containers

    Posted

    On 8/28/2020 at 9:40 AM, Fiala06 said:

    I can not get this to work. I've deleted it a dozen times, left it overnight before trying to login, and I get different error messages all the time even with new install dir's. 

     

    Most recent one: DB Error 2002: No such file or directory

    Or the "observium" username and password don't work. 

    Log keeps spamming 

      

    
Starting MariaDB...
200828 07:31:48 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:31:48 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:31:49 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:31:49 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:31:51 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:31:51 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:31:52 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:31:52 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.


    Here is a new install:

      

    
___ _ _
/ _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___
| | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \
| |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | |
\___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_|[0;36m
Observium Community Edition 19.8.10000
http://www.observium.org[0m
[0m

CMD[[0;33m/opt/observium/scripts/distro[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0153s[0m][0m
STDOUT[
Linux|4.19.107-Unraid|amd64|Ubuntu|18.04|vmware|docker
][0m

CMD[[0;33m/usr/bin/env python --version 2>&1[0m]

[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0016s[0m][0m
STDOUT[
Python 2.7.17
][0m

SQL[[0;33mSELECT version();[0m][0m

SQL RUNTIME[[0;32m0.00018501s[0m][0m

CMD[[0;33m/usr/bin/snmpget --version 2>&1[0m]

[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0018s[0m][0m
STDOUT[
NET-SNMP version: 5.7.3

][0m

CMD[[0;33m/usr/bin/rrdtool --version | head -n1[0m]

[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0068s[0m][0m
STDOUT[
RRDtool 1.7.0 Copyright by Tobias Oetiker <tobi@oetiker.ch>
][0m

CMD[[0;33m/usr/bin/fping -v 2>&1[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0015s[0m][0m
STDOUT[
/usr/bin/fping: Version 4.0

/usr/bin/fping: comments to [email protected]
][0m

CMD[[0;33m/usr/sbin/apache2 -v | awk '/Server version:/ {print $3}'[0m]

[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0414s[0m][0m
STDOUT[
Apache/2.4.29
][0m

CMD[[0;33mdate "+%:z"[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;32m0.0009s[0m][0m
CMD EXITDELAY[[0;31m10ms[0m][0m
STDOUT[
-07:00
][0m

SQL[[0;33mSELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);[0m][0m
SQL RUNTIME[[0;32m0.00020695s[0m][0m

SQL[[0;33mSELECT @@SESSION.sql_mode;[0m][0m
SQL RUNTIME[[0;32m0.00009990s[0m][0m

SQL[[0;33mSHOW VARIABLES LIKE 'character_set_connection'[0m][0m
SQL RUNTIME[[0;32m0.00091219s[0m][0m

[0;36m##### [1;37mSoftware versions[0;36m #####[0m
[0m
[0;36m o [1;37mOS [0m Linux 4.19.107-Unraid [amd64] (Ubuntu 18.04)
[0;36m o [1;37mApache [0m 2.4.29
[0;36m o [1;37mPHP [0m 7.2.24-0ubuntu0.18.04.6 (OPcache: DISABLED)
[0;36m o [1;37mPython [0m 2.7.17
[0;36m o [1;37mMySQL [0m 10.5.4-MariaDB-1:10.5.4+maria~bionic (extension: mysqli 5.0.12-dev)
[0;36m o [1;37mSNMP [0m NET-SNMP 5.7.3
[0;36m o [1;37mRRDtool [0m 1.7.0
[0;36m o [1;37mFping [0m 4.0 (IPv4 and IPv6)

[0;35m##### [1;37mMemory Limit[0;35m #####[0m
[0m
[0;35m o [1;37mPHP [0m Unlimited

[0;35m##### [1;37mMySQL mode[0;35m #####[0m
[0m
[0;35m o [1;37mMySQL [0m ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

[0;35m##### [1;37mCharset info[0;35m #####[0m
[0m
[0;35m o [1;37mPHP [0m UTF-8
[0;35m o [1;37mMySQL [0m utf8

[0;35m##### [1;37mTimezones info[0;35m #####[0m
[0m
[0;35m o [1;37mDate [0m Friday, 28-Aug-20 07:36:54 PDT
[0;35m o [1;37mPHP [0m -07:00
[0;35m o [1;37mMySQL [0m -07:00


SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';[0m][0m
SQL RUNTIME[[0;32m0.00015116s[0m][0m

SQL[[0;33mSELECT `version` FROM `dbSchema` ORDER BY `version` DESC LIMIT 1[0m][0m

SQL RUNTIME[[0;32m0.00010705s[0m][0m

SQL[[0;33mSELECT 1 FROM `devices` LIMIT 1;[0m][0m
SQL RUNTIME[[0;32m0.00011396s[0m]
SQL ERROR[[0;31mError in query: (Table 'observium.devices' doesn't exist) 1146[0m][0m

Install initial database schema ...
CMD[[0;33m/usr/bin/mysql -u'observium' -p'bjccHfoupBCWBTWPODmOFa16nN8DYF7X' -h'localhost' -D 'observium' < '/opt/observium/update/db_schema_mysql.sql'[0m]
[0m
CMD EXITCODE[[0;32m0[0m]
CMD RUNTIME[[0;31m115.721s[0m][0m
STDOUT[

][0m

SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema';[0m][0m
SQL RUNTIME[[0;32m0.00043917s[0m][0m
done.

SQL[[0;33mSELECT * FROM `observium_processes` WHERE `process_name` = 'discovery.php' AND `device_id` = '-1'[0m][0m
SQL RUNTIME[[0;32m0.00041986s[0m][0m

SQL[[0;33mINSERT INTO `observium_processes` (`process_pid`,`process_name`,`process_ppid`,`process_uid`,`process_command`,`process_start`,`device_id`) VALUES ('225','discovery.php','36','0','php ./discovery.php -d -u','1598625529','-1')[0m][0m
SQL RUNTIME[[0;32m0.02732396s[0m][0m
-- Database is up to date.

SQL[[0;33mDELETE FROM `observium_processes` WHERE `process_pid` = '225' AND `process_name` = 'discovery.php' AND `device_id` = '-1'[0m][0m
SQL RUNTIME[[0;32m0.02290606s[0m][0m

SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck';[0m][0m
SQL RUNTIME[[0;32m0.00021791s[0m][0m

REQUEST[[0;33mhttp://www.observium.org/versions.php[0m]
REQUEST STATUS[[0;32mTRUE[0m]
REQUEST RUNTIME[[0;32m1.3866s[0m]
RESPONSE CODE[200 OK][0m

SQL[[0;33mSELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'latest_ver')[0m][0m
SQL RUNTIME[[0;32m0.00026703s[0m][0m

SQL[[0;33mINSERT INTO `observium_attribs` (`attrib_type`,`attrib_value`) VALUES ('latest_ver','19.8')[0m][0m
SQL RUNTIME[[0;32m0.01941109s[0m][0m

SQL[[0;33mSELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev')[0m][0m
SQL RUNTIME[[0;32m0.00016999s[0m][0m

SQL[[0;33mINSERT INTO `observium_attribs` (`attrib_type`,`attrib_value`) VALUES ('latest_rev','10000')[0m][0m
SQL RUNTIME[[0;32m0.01637483s[0m][0m

SQL[[0;33mSELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev_date')[0m][0m
SQL RUNTIME[[0;32m0.00024509s[0m][0m

SQL[[0;33mINSERT INTO `observium_attribs` (`attrib_type`,`attrib_value`) VALUES ('latest_rev_date','2019-08-24')[0m][0m
SQL RUNTIME[[0;32m0.04439902s[0m][0m

SQL[[0;33mSELECT EXISTS (SELECT 1 FROM `observium_attribs` WHERE `attrib_type` = 'last_versioncheck')[0m][0m
SQL RUNTIME[[0;32m0.00021100s[0m][0m

SQL[[0;33mINSERT INTO `observium_attribs` (`attrib_type`,`attrib_value`) VALUES ('last_versioncheck','1598625531')[0m][0m
SQL RUNTIME[[0;32m0.04074883s[0m][0m

SQL[[0;33mSELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'latest_rev';[0m][0m
SQL RUNTIME[[0;32m0.00024605s[0m][0m
Adding the 'observium' user to the app.
[0;32mObservium CE 19.8.10000
[1;37mAdd User[0m
[0m
User observium added successfully.
Shutting down.
Aug 28 07:38:51 9ac22bf8d797 mysqld: 2020-08-28 7:38:51 0 [Note] /usr/sbin/mariadbd (initiated by: root[root] @ localhost []): Normal shutdown
Aug 28 07:38:51 9ac22bf8d797 mysqld: 2020-08-28 7:38:51 0 [Note] Event Scheduler: Purging the queue. 0 events
Aug 28 07:38:51 9ac22bf8d797 mysqld: 2020-08-28 7:38:51 0 [Note] InnoDB: FTS optimize thread exiting.
Aug 28 07:38:51 9ac22bf8d797 mysqld: 2020-08-28 7:38:51 0 [Note] InnoDB: Starting shutdown...
Aug 28 07:38:51 9ac22bf8d797 mysqld: 2020-08-28 7:38:51 0 [Note] InnoDB: Dumping buffer pool(s) to /config/databases/ib_buffer_pool
Aug 28 07:38:51 9ac22bf8d797 mysqld: 2020-08-28 7:38:51 0 [Note] InnoDB: Restricted to 2013 pages due to innodb_buf_pool_dump_pct=25
Aug 28 07:38:51 9ac22bf8d797 mysqld: 2020-08-28 7:38:51 0 [Note] InnoDB: Buffer pool(s) dump completed at 200828 7:38:51
Aug 28 07:38:53 9ac22bf8d797 mysqld: 2020-08-28 7:38:53 0 [Note] InnoDB: Shutdown completed; log sequence number 5767295; transaction id 5202
Aug 28 07:38:53 9ac22bf8d797 mysqld: 2020-08-28 7:38:53 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Aug 28 07:38:53 9ac22bf8d797 mysqld: 2020-08-28 7:38:53 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Aug 28 07:38:53 9ac22bf8d797 mysqld:
Aug 28 07:38:53 9ac22bf8d797 mysqld_safe: mysqld from pid file /run/mysqld/mysqld.pid ended
Aug 28 07:38:53 9ac22bf8d797 mysqld: 2020-08-28 7:38:53 0 [Note] InnoDB: Shutdown completed; log sequence number 5767295; transaction id 5202
Aug 28 07:38:53 9ac22bf8d797 mysqld: 2020-08-28 7:38:53 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
Aug 28 07:38:53 9ac22bf8d797 mysqld: 2020-08-28 7:38:53 0 [Note] /usr/sbin/mariadbd: Shutdown complete
Aug 28 07:38:53 9ac22bf8d797 mysqld:
Aug 28 07:38:53 9ac22bf8d797 mysqld_safe: mysqld from pid file /run/mysqld/mysqld.pid ended
chown time
Initialization complete.
Starting MariaDB...
200828 07:38:57 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:38:57 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:38:58 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:38:58 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:38:59 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:38:59 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:38:59 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:38:59 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:39:00 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:39:00 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:39:01 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:39:01 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Aug 28 07:39:02 9ac22bf8d797 CRON[906]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Aug 28 07:39:02 9ac22bf8d797 CRON[906]: (root) CMD ( [ -x /usr/lib/php/sessionclean ] && if [ ! -d /run/systemd/system ]; then /usr/lib/php/sessionclean; fi)
Database exists.
Starting MariaDB...
200828 07:39:03 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:39:03 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:39:04 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:39:04 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:39:04 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:39:04 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:39:05 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:39:05 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:39:06 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:39:06 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:39:06 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:39:06 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...
200828 07:39:08 mysqld_safe Logging to '/config/databases/9ac22bf8d797.err'.
200828 07:39:08 mysqld_safe Starting mariadbd daemon with databases from /config/databases
Database exists.
Starting MariaDB...


    Any ideas?

    I hate to be the one to say "me too", but...  Seems like a couple of people have received this error here in the support thread.  Not seeing a solution yet.  The above Quote is pretty much exactly what I am seeing. 

    I am also running unRaid 6.8.3.

    Errors from the logfile mentioned in the unRaid log.


    2020-09-20  8:28:02 0 [Note] InnoDB: Using Linux native AIO
    2020-09-20  8:28:02 0 [Note] InnoDB: Uses event mutexes
    2020-09-20  8:28:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2020-09-20  8:28:02 0 [Note] InnoDB: Number of pools: 1
    2020-09-20  8:28:02 0 [Note] InnoDB: Using SSE4.2 crc32 instructions
    2020-09-20  8:28:02 0 [Note] mariadbd: O_TMPFILE is not supported on /tmp (disabling future attempts)
    2020-09-20  8:28:02 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
    2020-09-20  8:28:02 0 [Note] InnoDB: Completed initialization of buffer pool
    2020-09-20  8:28:02 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. S
    ee the man page of setpriority().
    2020-09-20  8:28:02 0 [ERROR] InnoDB: Upgrade after a crash is not supported. The redo log was created with MariaDB 10.4.12.
    2020-09-20  8:28:02 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
    2020-09-20  8:28:02 0 [Note] InnoDB: Starting shutdown...
    2020-09-20  8:28:02 0 [ERROR] Plugin 'InnoDB' init function returned error.
    2020-09-20  8:28:02 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
    2020-09-20  8:28:02 0 [Note] Plugin 'FEEDBACK' is disabled.
    2020-09-20  8:28:02 0 [ERROR] Unknown/unsupported storage engine: InnoDB
    2020-09-20  8:28:02 0 [ERROR] Aborting

     

    -Craig 

×
×
  • Create New...