Database Locked Error

Hello-

Often, I minimize mAirList during playout and work on the database. While doing so, I notice that mAirList often shows a "Can’t write to database, database locked’ error (bottom, left of screen). Once, I believe it may have prevented a playlist from loading. Is there a way to work on the database and still allow mAirList to access the database?

Also, somewhat unrelated, while choosing soundcard options, I’ve noticed a variety of options. Am I correct that the choice should be ‘default?’

Thank you for any assistance.

Regards, Alec

I assume you’re talking about the local (non-networked) mAirListDB.

It seems that SQLite is pretty strict when it comes to more than one application accessing a single database file at the same time. An “real” SQL database, just like PostgreSQL which is used in the networked mAirListDB, would just delay the second application until the first application has finished its work, or even let them work at the same time using so-called transactions (and taking care of any conflicts between them).

I’m looking into a way to open the database administration from within the playout main window (for the Personal Edition) - that would solve the problem for good, because then it’s only one application instance accessing the database.

Regarding the second question, which configuration page are you referring to?

Thank you for the fast reply Torben. I appreciate your effort :slight_smile:

Yes, I was talking about local database.

I don’t have the configuration utility in front of me, but it’s the configuration page that assigns the various audio card outputs to the players, PFL. The choices include the the specific output, including additional choices of ‘Default’, ‘Front’. (ex: Delta 44 1/2 front, Delta 44 1/2 default). I believe the correct setting would be ‘default’, yes?

Thanks, Alec M.

Oh, I see what you mean. First of all, it’s important to understand that there’s two types of multichannel (more than one stereo pair) soundcards:

Some cards provide a separate virtual device for each stereo output. For example, imagine a four channel (two stereo output) card of that type. In the configuration, you will see entries like this:

My Soundcard (Output 1 and 2) - default My Soundcard (Output 1 and 2) - front (1/2) My Soundcard (Output 3 and 4) - default My Soundcard (Output 3 and 4) - front (1/2)

If I remember correctly, the M-Audio Delta cards work like this.

From the perspective of the software, it appears that there’s two separate stereo sound cards in your system “My Soundcard (Output 1 and 2)” and “My Soundcard (Output 3 and 4)”, but it’s actually only one, with two stereo outputs. The advantage is that even old applications that cannot handle multichannel sound cards can access the outputs separately.

For this type of sound card, it doesn’t really matter whether you choose “default” or “1/2”, because both refers to the first (and only) channel pair of the particular virtual device.

Other sound cards provide a single audio device, with multiple channel pairs. This approach is used by most onboard or cheap 5.1 PCI or USB cards designed for home theater DVD playback. For example, for a 5.1 card, you see something like this in the audio devices list:

My Soundcard - default My Soundcard - front (1/2) My Soundcard - rear (3/4) My Soundcard - center/sub (5/6)

So there’s only a single device here, but three stereo pairs. (For most cards, you need to set the type of speakers in the Windows Control Panel to “5.1” or similar to see all channel pairs. If it still doesn’t work, there’s an option named “force multichannel output” on the WDM Devices page in mAirListConfig.)

Technically, “default” means “use the first available channels” - for stereo files, that’s 1/2, so it doesn’t matter if you choose default or 1/2. (Mono files are mixed up to stereo, so they’re also being played on 1/2.) It’s even possible to play multichannel audio files (e.g. 5.1 Ogg Vorbis files) using the “default” setting on a 5.1 card.

With a card of the second type, you should always pick the particular channel pair entries (1/2, 3/4, etc.) to ensure correct routing. Don’t use the “default” entry unless you’re only going to use the first output anyway. Mixing the “default” entry with specific “3/4” etc. entries might screw up the audio output.

Torben-

Ah, very good. The ‘front’ ‘default’ options had me puzzled, but now I understand.

There are so many excellent options within mAirList that I sometimes get overwhelmed (in a good way) :slight_smile:

Best Regards, Alec

See here: http://forum.mairlist.com/index.php/topic,4738.msg33844.html#msg33844

Very Good… I’ll have a try once I get back in front of my machine, probably early next week.

Best Regards, Alec