Hello, No, your database has not been properly updated.
We do not test Bacula with MariaDB, so all bets are off, but clearly
something went wrong with the database upgrade.
Best regards,
Kern
On 11/23/2015 03:32 AM, bdam wrote:
> Sorry for the verbosity this time, you'll see it is necessary though. I am
> wondering why the code looks for a column which doesn't exist, even though
> the db upgrade script says it has been updated. See this - does it look like
> a v15 table structure?
>
> [root@tiger ~]# mysql
> Welcome to the MariaDB monitor. Commands end with ; or \g.
> Your MariaDB connection id is 498
> Server version: 10.0.21-MariaDB-log MariaDB Server
>
> Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
>
> MariaDB [(none)]> use bacula;
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Database changed
> MariaDB [bacula]> describe Media;
> +------------------+------------------------------------------------------------------------------------------------------------+------+-----+---------------------+----------------+
> | Field | Type
> | Null | Key | Default
> | Extra |
> +------------------+------------------------------------------------------------------------------------------------------------+------+-----+---------------------+----------------+
> | MediaId | int(10) unsigned
> | NO | PRI | NULL
> | auto_increment |
> | VolumeName | tinyblob
> | NO | UNI | NULL
> | |
> | Slot | int(11)
> | YES | | 0
> | |
> | PoolId | int(10) unsigned
> | YES | MUL | 0
> | |
> | MediaType | tinyblob
> | NO | | NULL
> | |
> | MediaTypeId | int(10) unsigned
> | YES | | 0
> | |
> | LabelType | tinyint(4)
> | YES | | 0
> | |
> | FirstWritten | datetime
> | YES | | 0000-00-00
> 00:00:00 | |
> | LastWritten | datetime
> | YES | | 0000-00-00
> 00:00:00 | |
> | LabelDate | datetime
> | YES | | 0000-00-00
> 00:00:00 | |
> | VolJobs | int(10) unsigned
> | YES | | 0
> | |
> | VolFiles | int(10) unsigned
> | YES | | 0
> | |
> | VolBlocks | int(10) unsigned
> | YES | | 0
> | |
> | VolMounts | int(10) unsigned
> | YES | | 0
> | |
> | VolBytes | bigint(20) unsigned
> | YES | | 0
> | |
> | VolParts | int(10) unsigned
> | YES | | 0
> | |
> | VolErrors | int(10) unsigned
> | YES | | 0
> | |
> | VolWrites | int(10) unsigned
> | YES | | 0
> | |
> | VolCapacityBytes | bigint(20) unsigned
> | YES | | 0
> | |
> | VolStatus |
> enum('Full','Archive','Append','Recycle','Purged','Read-Only','Disabled','Error','Busy','Used','Cleaning')
> | NO | | NULL | |
> | Enabled | tinyint(4)
> | YES | | 1
> | |
> | Recycle | tinyint(4)
> | YES | | 0
> | |
> | ActionOnPurge | tinyint(4)
> | YES | | 0
> | |
> | VolRetention | bigint(20) unsigned
> | YES | | 0
> | |
> | VolUseDuration | bigint(20) unsigned
> | YES | | 0
> | |
> | MaxVolJobs | int(10) unsigned
> | YES | | 0
> | |
> | MaxVolFiles | int(10) unsigned
> | YES | | 0
> | |
> | MaxVolBytes | bigint(20) unsigned
> | YES | | 0
> | |
> | InChanger | tinyint(4)
> | YES | | 0
> | |
> | StorageId | int(10) unsigned
> | YES | | 0
> | |
> | DeviceId | int(10) unsigned
> | YES | | 0
> | |
> | MediaAddressing | tinyint(4)
> | YES | | 0
> | |
> | VolReadTime | bigint(20) unsigned
> | YES | | 0
> | |
> | VolWriteTime | bigint(20) unsigned
> | YES | | 0
> | |
> | EndFile | int(10) unsigned
> | YES | | 0
> | |
> | EndBlock | int(10) unsigned
> | YES | | 0
> | |
> | LocationId | int(10) unsigned
> | YES | | 0
> | |
> | RecycleCount | int(10) unsigned
> | YES | | 0
> | |
> | InitialWrite | datetime
> | YES | | 0000-00-00
> 00:00:00 | |
> | ScratchPoolId | int(10) unsigned
> | YES | | 0
> | |
> | RecyclePoolId | int(10) unsigned
> | YES | | 0
> | |
> | Comment | blob
> | YES | | NULL
> | |
> +------------------+------------------------------------------------------------------------------------------------------------+------+-----+---------------------+----------------+
> 42 rows in set (0.00 sec)
>
> MariaDB [bacula]>
>
> +----------------------------------------------------------------------
> |This was sent by bill.dam...@yahoo.com via Backup Central.
> |Forward SPAM to ab...@backupcentral.com.
> +----------------------------------------------------------------------
>
>
>
> ------------------------------------------------------------------------------
> Go from Idea to Many App Stores Faster with Intel(R) XDK
> Give your users amazing mobile app experiences with Intel(R) XDK.
> Use one codebase in this all-in-one HTML5 development environment.
> Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
> http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
